Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationFri, 23 Dec 2011 10:54:41 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2011/Dec/23/t13246556987kvhi4q7nw6zgh3.htm/, Retrieved Mon, 29 Apr 2024 17:59:38 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=160527, Retrieved Mon, 29 Apr 2024 17:59:38 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact93
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [] [2010-12-05 18:59:57] [b98453cac15ba1066b407e146608df68]
- R PD  [Recursive Partitioning (Regression Trees)] [WS 10 Recursive p...] [2011-12-09 12:55:25] [60c0c94f647e2c90e494ab0f2a2f1926]
-   PD    [Recursive Partitioning (Regression Trees)] [WS 10 Recursive p...] [2011-12-09 13:55:20] [60c0c94f647e2c90e494ab0f2a2f1926]
-   PD        [Recursive Partitioning (Regression Trees)] [] [2011-12-23 15:54:41] [c80accbb627afb8a1e74b91ef6a0d2c4] [Current]
Feedback Forum

Post a new message
Dataseries X:
1818	279055	73
1433	212408	75
2059	233939	83
2733	222117	106
1399	189911	56
631	70849	28
5460	605767	135
381	33186	19
2150	227332	62
2042	267925	49
2536	371987	122
2429	276291	132
2100	212638	87
3020	368577	85
2265	269455	88
5139	398124	191
2363	335567	77
3564	432711	173
1516	185822	59
2398	267365	89
2546	279428	73
3253	527853	112
1705	220142	49
1787	200004	58
3792	257139	133
3108	270941	138
3230	324969	134
2348	329962	92
1780	190867	60
3218	393860	79
2692	327660	89
2187	269239	83
2577	396136	106
1293	130446	49
3567	430118	104
2764	273950	56
3755	428077	128
2075	254312	93
995	120351	35
3750	395658	212
3413	345875	86
2053	216827	82
1984	224524	83
1825	182485	69
2783	168492	86
5572	459455	157
918	78800	42
2685	255072	85
4145	368086	123
2841	230299	70
2175	244782	81
496	24188	24
2699	400109	334
744	65029	17
1161	101097	64
3333	309810	67
2970	375638	91
3969	367127	205
2919	387748	156
2399	280106	90
4121	400971	153
3323	322755	123
3132	291391	124
2868	295075	93
1778	280018	81
2109	267432	71
2148	217181	141
3009	258166	159
2562	264771	88
1737	182961	73
2680	256967	74
893	73566	32
2389	272362	93
2197	229056	62
2227	229851	70
2370	371391	91
3226	398210	104
1978	220419	111
2516	231884	72
2147	219381	73
2150	206169	54
4229	483074	132
1380	146100	72
2449	295224	109
870	80953	25
2700	217384	63
1574	179344	62
4046	415550	222
3259	389059	129
3098	180679	106
2615	299505	104
2404	292260	84
1932	199481	68
3147	282361	78
2598	329281	89
2108	234577	48
2193	297995	67
2478	342490	90
4198	416463	163
4165	429565	120
2842	297080	142
2562	331792	71
2449	229772	202
602	43287	14
2579	238089	87
2591	263322	160
2957	302082	61
2786	321797	95
1477	193926	96
3350	175138	105
2107	354041	78
2332	303273	91
400	23668	13
2233	196743	79
530	61857	25
2033	217543	54
3246	440711	128
387	21054	16
2137	252805	52
492	31961	22
3838	360436	125
2193	251948	77
1796	187320	97
1907	180842	58
568	38214	34
2602	280392	56
2819	358276	84
1464	211775	67
3946	447335	90
2554	348017	99
3506	441946	133
1552	215177	43
1389	130177	47
3101	318037	365
4541	466139	198
1872	162279	62
4403	416643	140
2113	178322	86
2046	292443	54
2564	283913	100
2145	251070	128
4112	387072	125
2340	246963	93
2035	173260	63
3241	346748	108
1991	178402	60
2864	277892	97
2748	314070	112
2	1	0
207	14688	10
5	98	1
8	455	2
0	0	0
0	0	0
2449	291847	95
3490	415421	168
0	0	0
4	203	4
151	7199	5
475	46660	21
141	17547	5
1145	121550	46
29	969	2
2080	242774	75




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'AstonUniversity' @ aston.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 3 seconds \tabularnewline
R Server & 'AstonUniversity' @ aston.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160527&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]3 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'AstonUniversity' @ aston.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160527&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160527&T=0

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'AstonUniversity' @ aston.wessa.net







Goodness of Fit
Correlation0.9324
R-squared0.8694
RMSE414.1052

\begin{tabular}{lllllllll}
\hline
Goodness of Fit \tabularnewline
Correlation & 0.9324 \tabularnewline
R-squared & 0.8694 \tabularnewline
RMSE & 414.1052 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160527&T=1

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.9324[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8694[/C][/ROW]
[ROW][C]RMSE[/C][C]414.1052[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160527&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160527&T=1

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Goodness of Fit
Correlation0.9324
R-squared0.8694
RMSE414.1052







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
118182518.84210526316-700.842105263158
214331838.90909090909-405.909090909091
320592214.95-155.95
427332557.28571428571175.714285714286
513991838.90909090909-439.909090909091
66311038.09090909091-407.090909090909
754604006.31453.7
8381481.222222222222-100.222222222222
921502214.95-64.9499999999998
1020422518.84210526316-476.842105263158
1125363283.30769230769-747.307692307692
1224292999.61538461538-570.615384615385
1321001838.90909090909261.090909090909
1430203283.30769230769-263.307692307692
1522652518.84210526316-253.842105263158
1651394006.31132.7
1723632518.84210526316-155.842105263158
1835644006.3-442.3
1915161838.90909090909-322.909090909091
2023982518.84210526316-120.842105263158
2125462518.8421052631627.1578947368421
2232534006.3-753.3
2317052214.95-509.95
2417871838.90909090909-51.909090909091
2537922999.61538461538792.384615384615
2631082999.61538461538108.384615384615
2732302999.61538461538230.384615384615
2823482518.84210526316-170.842105263158
2917801838.90909090909-58.909090909091
3032183283.30769230769-65.3076923076924
3126922518.84210526316173.157894736842
3221872518.84210526316-331.842105263158
3325773283.30769230769-706.307692307692
3412931038.09090909091254.909090909091
3535674006.3-439.3
3627642518.84210526316245.157894736842
3737554006.3-251.3
3820752214.95-139.95
399951038.09090909091-43.090909090909
4037503283.30769230769466.692307692308
4134132518.84210526316894.157894736842
4220532214.95-161.95
4319842214.95-230.95
4418251838.90909090909-13.909090909091
4527831838.90909090909944.090909090909
4655724006.31565.7
479181038.09090909091-120.090909090909
4826852518.84210526316166.157894736842
4941453283.30769230769861.692307692308
5028412214.95626.05
5121752214.95-39.9499999999998
52496481.22222222222214.7777777777778
5326994006.3-1307.3
547441038.09090909091-294.090909090909
5511611038.09090909091122.909090909091
5633332518.84210526316814.157894736842
5729703283.30769230769-313.307692307692
5839693283.30769230769685.692307692308
5929193283.30769230769-364.307692307692
6023992518.84210526316-119.842105263158
6141214006.3114.7
6233232999.61538461538323.384615384615
6331322999.61538461538132.384615384615
6428682518.84210526316349.157894736842
6517782518.84210526316-740.842105263158
6621092518.84210526316-409.842105263158
6721482557.28571428571-409.285714285714
6830092999.615384615389.38461538461524
6925622518.8421052631643.1578947368421
7017371838.90909090909-101.909090909091
7126802518.84210526316161.157894736842
728931038.09090909091-145.090909090909
7323892518.84210526316-129.842105263158
7421972214.95-17.9499999999998
7522272214.9512.0500000000002
7623703283.30769230769-913.307692307692
7732264006.3-780.3
7819782557.28571428571-579.285714285714
7925162214.95301.05
8021472214.95-67.9499999999998
8121501838.90909090909311.090909090909
8242294006.3222.7
8313801038.09090909091341.909090909091
8424492999.61538461538-550.615384615385
858701038.09090909091-168.090909090909
8627002214.95485.05
8715741838.90909090909-264.909090909091
8840464006.339.6999999999998
8932593283.30769230769-24.3076923076924
9030982557.28571428571540.714285714286
9126152518.8421052631696.157894736842
9224042518.84210526316-114.842105263158
9319321838.9090909090993.090909090909
9431472518.84210526316628.157894736842
9525982518.8421052631679.157894736842
9621082214.95-106.95
9721932518.84210526316-325.842105263158
9824782518.84210526316-40.8421052631579
9941984006.3191.7
10041654006.3158.7
10128422999.61538461538-157.615384615385
10225622518.8421052631643.1578947368421
10324492557.28571428571-108.285714285714
104602481.222222222222120.777777777778
10525792214.95364.05
10625912999.61538461538-408.615384615385
10729572518.84210526316438.157894736842
10827862518.84210526316267.157894736842
10914771838.90909090909-361.909090909091
11033502557.28571428571792.714285714286
11121072518.84210526316-411.842105263158
11223322518.84210526316-186.842105263158
113400481.222222222222-81.2222222222222
11422331838.90909090909394.090909090909
115530481.22222222222248.7777777777778
11620332214.95-181.95
11732464006.3-760.3
118387481.222222222222-94.2222222222222
11921372214.95-77.9499999999998
120492481.22222222222210.7777777777778
12138383283.30769230769554.692307692308
12221932214.95-21.9499999999998
12317961838.90909090909-42.909090909091
12419071838.9090909090968.090909090909
125568481.22222222222286.7777777777778
12626022518.8421052631683.157894736842
12728192518.84210526316300.157894736842
12814641838.90909090909-374.909090909091
12939464006.3-60.3000000000002
13025542518.8421052631635.1578947368421
13135064006.3-500.3
13215521838.90909090909-286.909090909091
13313891038.09090909091350.909090909091
13431012999.61538461538101.384615384615
13545414006.3534.7
13618721838.9090909090933.090909090909
13744034006.3396.7
13821131838.90909090909274.090909090909
13920462518.84210526316-472.842105263158
14025642518.8421052631645.1578947368421
14121452557.28571428571-412.285714285714
14241123283.30769230769828.692307692308
14323402214.95125.05
14420351838.90909090909196.090909090909
14532412999.61538461538241.384615384615
14619911838.90909090909152.090909090909
14728642518.84210526316345.157894736842
14827482999.61538461538-251.615384615385
149249.7272727272727-47.7272727272727
15020749.7272727272727157.272727272727
151549.7272727272727-44.7272727272727
152849.7272727272727-41.7272727272727
153049.7272727272727-49.7272727272727
154049.7272727272727-49.7272727272727
15524492518.84210526316-69.8421052631579
15634904006.3-516.3
157049.7272727272727-49.7272727272727
158449.7272727272727-45.7272727272727
15915149.7272727272727101.272727272727
160475481.222222222222-6.22222222222223
16114149.727272727272791.2727272727273
16211451038.09090909091106.909090909091
1632949.7272727272727-20.7272727272727
16420802214.95-134.95

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 1818 & 2518.84210526316 & -700.842105263158 \tabularnewline
2 & 1433 & 1838.90909090909 & -405.909090909091 \tabularnewline
3 & 2059 & 2214.95 & -155.95 \tabularnewline
4 & 2733 & 2557.28571428571 & 175.714285714286 \tabularnewline
5 & 1399 & 1838.90909090909 & -439.909090909091 \tabularnewline
6 & 631 & 1038.09090909091 & -407.090909090909 \tabularnewline
7 & 5460 & 4006.3 & 1453.7 \tabularnewline
8 & 381 & 481.222222222222 & -100.222222222222 \tabularnewline
9 & 2150 & 2214.95 & -64.9499999999998 \tabularnewline
10 & 2042 & 2518.84210526316 & -476.842105263158 \tabularnewline
11 & 2536 & 3283.30769230769 & -747.307692307692 \tabularnewline
12 & 2429 & 2999.61538461538 & -570.615384615385 \tabularnewline
13 & 2100 & 1838.90909090909 & 261.090909090909 \tabularnewline
14 & 3020 & 3283.30769230769 & -263.307692307692 \tabularnewline
15 & 2265 & 2518.84210526316 & -253.842105263158 \tabularnewline
16 & 5139 & 4006.3 & 1132.7 \tabularnewline
17 & 2363 & 2518.84210526316 & -155.842105263158 \tabularnewline
18 & 3564 & 4006.3 & -442.3 \tabularnewline
19 & 1516 & 1838.90909090909 & -322.909090909091 \tabularnewline
20 & 2398 & 2518.84210526316 & -120.842105263158 \tabularnewline
21 & 2546 & 2518.84210526316 & 27.1578947368421 \tabularnewline
22 & 3253 & 4006.3 & -753.3 \tabularnewline
23 & 1705 & 2214.95 & -509.95 \tabularnewline
24 & 1787 & 1838.90909090909 & -51.909090909091 \tabularnewline
25 & 3792 & 2999.61538461538 & 792.384615384615 \tabularnewline
26 & 3108 & 2999.61538461538 & 108.384615384615 \tabularnewline
27 & 3230 & 2999.61538461538 & 230.384615384615 \tabularnewline
28 & 2348 & 2518.84210526316 & -170.842105263158 \tabularnewline
29 & 1780 & 1838.90909090909 & -58.909090909091 \tabularnewline
30 & 3218 & 3283.30769230769 & -65.3076923076924 \tabularnewline
31 & 2692 & 2518.84210526316 & 173.157894736842 \tabularnewline
32 & 2187 & 2518.84210526316 & -331.842105263158 \tabularnewline
33 & 2577 & 3283.30769230769 & -706.307692307692 \tabularnewline
34 & 1293 & 1038.09090909091 & 254.909090909091 \tabularnewline
35 & 3567 & 4006.3 & -439.3 \tabularnewline
36 & 2764 & 2518.84210526316 & 245.157894736842 \tabularnewline
37 & 3755 & 4006.3 & -251.3 \tabularnewline
38 & 2075 & 2214.95 & -139.95 \tabularnewline
39 & 995 & 1038.09090909091 & -43.090909090909 \tabularnewline
40 & 3750 & 3283.30769230769 & 466.692307692308 \tabularnewline
41 & 3413 & 2518.84210526316 & 894.157894736842 \tabularnewline
42 & 2053 & 2214.95 & -161.95 \tabularnewline
43 & 1984 & 2214.95 & -230.95 \tabularnewline
44 & 1825 & 1838.90909090909 & -13.909090909091 \tabularnewline
45 & 2783 & 1838.90909090909 & 944.090909090909 \tabularnewline
46 & 5572 & 4006.3 & 1565.7 \tabularnewline
47 & 918 & 1038.09090909091 & -120.090909090909 \tabularnewline
48 & 2685 & 2518.84210526316 & 166.157894736842 \tabularnewline
49 & 4145 & 3283.30769230769 & 861.692307692308 \tabularnewline
50 & 2841 & 2214.95 & 626.05 \tabularnewline
51 & 2175 & 2214.95 & -39.9499999999998 \tabularnewline
52 & 496 & 481.222222222222 & 14.7777777777778 \tabularnewline
53 & 2699 & 4006.3 & -1307.3 \tabularnewline
54 & 744 & 1038.09090909091 & -294.090909090909 \tabularnewline
55 & 1161 & 1038.09090909091 & 122.909090909091 \tabularnewline
56 & 3333 & 2518.84210526316 & 814.157894736842 \tabularnewline
57 & 2970 & 3283.30769230769 & -313.307692307692 \tabularnewline
58 & 3969 & 3283.30769230769 & 685.692307692308 \tabularnewline
59 & 2919 & 3283.30769230769 & -364.307692307692 \tabularnewline
60 & 2399 & 2518.84210526316 & -119.842105263158 \tabularnewline
61 & 4121 & 4006.3 & 114.7 \tabularnewline
62 & 3323 & 2999.61538461538 & 323.384615384615 \tabularnewline
63 & 3132 & 2999.61538461538 & 132.384615384615 \tabularnewline
64 & 2868 & 2518.84210526316 & 349.157894736842 \tabularnewline
65 & 1778 & 2518.84210526316 & -740.842105263158 \tabularnewline
66 & 2109 & 2518.84210526316 & -409.842105263158 \tabularnewline
67 & 2148 & 2557.28571428571 & -409.285714285714 \tabularnewline
68 & 3009 & 2999.61538461538 & 9.38461538461524 \tabularnewline
69 & 2562 & 2518.84210526316 & 43.1578947368421 \tabularnewline
70 & 1737 & 1838.90909090909 & -101.909090909091 \tabularnewline
71 & 2680 & 2518.84210526316 & 161.157894736842 \tabularnewline
72 & 893 & 1038.09090909091 & -145.090909090909 \tabularnewline
73 & 2389 & 2518.84210526316 & -129.842105263158 \tabularnewline
74 & 2197 & 2214.95 & -17.9499999999998 \tabularnewline
75 & 2227 & 2214.95 & 12.0500000000002 \tabularnewline
76 & 2370 & 3283.30769230769 & -913.307692307692 \tabularnewline
77 & 3226 & 4006.3 & -780.3 \tabularnewline
78 & 1978 & 2557.28571428571 & -579.285714285714 \tabularnewline
79 & 2516 & 2214.95 & 301.05 \tabularnewline
80 & 2147 & 2214.95 & -67.9499999999998 \tabularnewline
81 & 2150 & 1838.90909090909 & 311.090909090909 \tabularnewline
82 & 4229 & 4006.3 & 222.7 \tabularnewline
83 & 1380 & 1038.09090909091 & 341.909090909091 \tabularnewline
84 & 2449 & 2999.61538461538 & -550.615384615385 \tabularnewline
85 & 870 & 1038.09090909091 & -168.090909090909 \tabularnewline
86 & 2700 & 2214.95 & 485.05 \tabularnewline
87 & 1574 & 1838.90909090909 & -264.909090909091 \tabularnewline
88 & 4046 & 4006.3 & 39.6999999999998 \tabularnewline
89 & 3259 & 3283.30769230769 & -24.3076923076924 \tabularnewline
90 & 3098 & 2557.28571428571 & 540.714285714286 \tabularnewline
91 & 2615 & 2518.84210526316 & 96.157894736842 \tabularnewline
92 & 2404 & 2518.84210526316 & -114.842105263158 \tabularnewline
93 & 1932 & 1838.90909090909 & 93.090909090909 \tabularnewline
94 & 3147 & 2518.84210526316 & 628.157894736842 \tabularnewline
95 & 2598 & 2518.84210526316 & 79.157894736842 \tabularnewline
96 & 2108 & 2214.95 & -106.95 \tabularnewline
97 & 2193 & 2518.84210526316 & -325.842105263158 \tabularnewline
98 & 2478 & 2518.84210526316 & -40.8421052631579 \tabularnewline
99 & 4198 & 4006.3 & 191.7 \tabularnewline
100 & 4165 & 4006.3 & 158.7 \tabularnewline
101 & 2842 & 2999.61538461538 & -157.615384615385 \tabularnewline
102 & 2562 & 2518.84210526316 & 43.1578947368421 \tabularnewline
103 & 2449 & 2557.28571428571 & -108.285714285714 \tabularnewline
104 & 602 & 481.222222222222 & 120.777777777778 \tabularnewline
105 & 2579 & 2214.95 & 364.05 \tabularnewline
106 & 2591 & 2999.61538461538 & -408.615384615385 \tabularnewline
107 & 2957 & 2518.84210526316 & 438.157894736842 \tabularnewline
108 & 2786 & 2518.84210526316 & 267.157894736842 \tabularnewline
109 & 1477 & 1838.90909090909 & -361.909090909091 \tabularnewline
110 & 3350 & 2557.28571428571 & 792.714285714286 \tabularnewline
111 & 2107 & 2518.84210526316 & -411.842105263158 \tabularnewline
112 & 2332 & 2518.84210526316 & -186.842105263158 \tabularnewline
113 & 400 & 481.222222222222 & -81.2222222222222 \tabularnewline
114 & 2233 & 1838.90909090909 & 394.090909090909 \tabularnewline
115 & 530 & 481.222222222222 & 48.7777777777778 \tabularnewline
116 & 2033 & 2214.95 & -181.95 \tabularnewline
117 & 3246 & 4006.3 & -760.3 \tabularnewline
118 & 387 & 481.222222222222 & -94.2222222222222 \tabularnewline
119 & 2137 & 2214.95 & -77.9499999999998 \tabularnewline
120 & 492 & 481.222222222222 & 10.7777777777778 \tabularnewline
121 & 3838 & 3283.30769230769 & 554.692307692308 \tabularnewline
122 & 2193 & 2214.95 & -21.9499999999998 \tabularnewline
123 & 1796 & 1838.90909090909 & -42.909090909091 \tabularnewline
124 & 1907 & 1838.90909090909 & 68.090909090909 \tabularnewline
125 & 568 & 481.222222222222 & 86.7777777777778 \tabularnewline
126 & 2602 & 2518.84210526316 & 83.157894736842 \tabularnewline
127 & 2819 & 2518.84210526316 & 300.157894736842 \tabularnewline
128 & 1464 & 1838.90909090909 & -374.909090909091 \tabularnewline
129 & 3946 & 4006.3 & -60.3000000000002 \tabularnewline
130 & 2554 & 2518.84210526316 & 35.1578947368421 \tabularnewline
131 & 3506 & 4006.3 & -500.3 \tabularnewline
132 & 1552 & 1838.90909090909 & -286.909090909091 \tabularnewline
133 & 1389 & 1038.09090909091 & 350.909090909091 \tabularnewline
134 & 3101 & 2999.61538461538 & 101.384615384615 \tabularnewline
135 & 4541 & 4006.3 & 534.7 \tabularnewline
136 & 1872 & 1838.90909090909 & 33.090909090909 \tabularnewline
137 & 4403 & 4006.3 & 396.7 \tabularnewline
138 & 2113 & 1838.90909090909 & 274.090909090909 \tabularnewline
139 & 2046 & 2518.84210526316 & -472.842105263158 \tabularnewline
140 & 2564 & 2518.84210526316 & 45.1578947368421 \tabularnewline
141 & 2145 & 2557.28571428571 & -412.285714285714 \tabularnewline
142 & 4112 & 3283.30769230769 & 828.692307692308 \tabularnewline
143 & 2340 & 2214.95 & 125.05 \tabularnewline
144 & 2035 & 1838.90909090909 & 196.090909090909 \tabularnewline
145 & 3241 & 2999.61538461538 & 241.384615384615 \tabularnewline
146 & 1991 & 1838.90909090909 & 152.090909090909 \tabularnewline
147 & 2864 & 2518.84210526316 & 345.157894736842 \tabularnewline
148 & 2748 & 2999.61538461538 & -251.615384615385 \tabularnewline
149 & 2 & 49.7272727272727 & -47.7272727272727 \tabularnewline
150 & 207 & 49.7272727272727 & 157.272727272727 \tabularnewline
151 & 5 & 49.7272727272727 & -44.7272727272727 \tabularnewline
152 & 8 & 49.7272727272727 & -41.7272727272727 \tabularnewline
153 & 0 & 49.7272727272727 & -49.7272727272727 \tabularnewline
154 & 0 & 49.7272727272727 & -49.7272727272727 \tabularnewline
155 & 2449 & 2518.84210526316 & -69.8421052631579 \tabularnewline
156 & 3490 & 4006.3 & -516.3 \tabularnewline
157 & 0 & 49.7272727272727 & -49.7272727272727 \tabularnewline
158 & 4 & 49.7272727272727 & -45.7272727272727 \tabularnewline
159 & 151 & 49.7272727272727 & 101.272727272727 \tabularnewline
160 & 475 & 481.222222222222 & -6.22222222222223 \tabularnewline
161 & 141 & 49.7272727272727 & 91.2727272727273 \tabularnewline
162 & 1145 & 1038.09090909091 & 106.909090909091 \tabularnewline
163 & 29 & 49.7272727272727 & -20.7272727272727 \tabularnewline
164 & 2080 & 2214.95 & -134.95 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160527&T=2

[TABLE]
[ROW][C]Actuals, Predictions, and Residuals[/C][/ROW]
[ROW][C]#[/C][C]Actuals[/C][C]Forecasts[/C][C]Residuals[/C][/ROW]
[ROW][C]1[/C][C]1818[/C][C]2518.84210526316[/C][C]-700.842105263158[/C][/ROW]
[ROW][C]2[/C][C]1433[/C][C]1838.90909090909[/C][C]-405.909090909091[/C][/ROW]
[ROW][C]3[/C][C]2059[/C][C]2214.95[/C][C]-155.95[/C][/ROW]
[ROW][C]4[/C][C]2733[/C][C]2557.28571428571[/C][C]175.714285714286[/C][/ROW]
[ROW][C]5[/C][C]1399[/C][C]1838.90909090909[/C][C]-439.909090909091[/C][/ROW]
[ROW][C]6[/C][C]631[/C][C]1038.09090909091[/C][C]-407.090909090909[/C][/ROW]
[ROW][C]7[/C][C]5460[/C][C]4006.3[/C][C]1453.7[/C][/ROW]
[ROW][C]8[/C][C]381[/C][C]481.222222222222[/C][C]-100.222222222222[/C][/ROW]
[ROW][C]9[/C][C]2150[/C][C]2214.95[/C][C]-64.9499999999998[/C][/ROW]
[ROW][C]10[/C][C]2042[/C][C]2518.84210526316[/C][C]-476.842105263158[/C][/ROW]
[ROW][C]11[/C][C]2536[/C][C]3283.30769230769[/C][C]-747.307692307692[/C][/ROW]
[ROW][C]12[/C][C]2429[/C][C]2999.61538461538[/C][C]-570.615384615385[/C][/ROW]
[ROW][C]13[/C][C]2100[/C][C]1838.90909090909[/C][C]261.090909090909[/C][/ROW]
[ROW][C]14[/C][C]3020[/C][C]3283.30769230769[/C][C]-263.307692307692[/C][/ROW]
[ROW][C]15[/C][C]2265[/C][C]2518.84210526316[/C][C]-253.842105263158[/C][/ROW]
[ROW][C]16[/C][C]5139[/C][C]4006.3[/C][C]1132.7[/C][/ROW]
[ROW][C]17[/C][C]2363[/C][C]2518.84210526316[/C][C]-155.842105263158[/C][/ROW]
[ROW][C]18[/C][C]3564[/C][C]4006.3[/C][C]-442.3[/C][/ROW]
[ROW][C]19[/C][C]1516[/C][C]1838.90909090909[/C][C]-322.909090909091[/C][/ROW]
[ROW][C]20[/C][C]2398[/C][C]2518.84210526316[/C][C]-120.842105263158[/C][/ROW]
[ROW][C]21[/C][C]2546[/C][C]2518.84210526316[/C][C]27.1578947368421[/C][/ROW]
[ROW][C]22[/C][C]3253[/C][C]4006.3[/C][C]-753.3[/C][/ROW]
[ROW][C]23[/C][C]1705[/C][C]2214.95[/C][C]-509.95[/C][/ROW]
[ROW][C]24[/C][C]1787[/C][C]1838.90909090909[/C][C]-51.909090909091[/C][/ROW]
[ROW][C]25[/C][C]3792[/C][C]2999.61538461538[/C][C]792.384615384615[/C][/ROW]
[ROW][C]26[/C][C]3108[/C][C]2999.61538461538[/C][C]108.384615384615[/C][/ROW]
[ROW][C]27[/C][C]3230[/C][C]2999.61538461538[/C][C]230.384615384615[/C][/ROW]
[ROW][C]28[/C][C]2348[/C][C]2518.84210526316[/C][C]-170.842105263158[/C][/ROW]
[ROW][C]29[/C][C]1780[/C][C]1838.90909090909[/C][C]-58.909090909091[/C][/ROW]
[ROW][C]30[/C][C]3218[/C][C]3283.30769230769[/C][C]-65.3076923076924[/C][/ROW]
[ROW][C]31[/C][C]2692[/C][C]2518.84210526316[/C][C]173.157894736842[/C][/ROW]
[ROW][C]32[/C][C]2187[/C][C]2518.84210526316[/C][C]-331.842105263158[/C][/ROW]
[ROW][C]33[/C][C]2577[/C][C]3283.30769230769[/C][C]-706.307692307692[/C][/ROW]
[ROW][C]34[/C][C]1293[/C][C]1038.09090909091[/C][C]254.909090909091[/C][/ROW]
[ROW][C]35[/C][C]3567[/C][C]4006.3[/C][C]-439.3[/C][/ROW]
[ROW][C]36[/C][C]2764[/C][C]2518.84210526316[/C][C]245.157894736842[/C][/ROW]
[ROW][C]37[/C][C]3755[/C][C]4006.3[/C][C]-251.3[/C][/ROW]
[ROW][C]38[/C][C]2075[/C][C]2214.95[/C][C]-139.95[/C][/ROW]
[ROW][C]39[/C][C]995[/C][C]1038.09090909091[/C][C]-43.090909090909[/C][/ROW]
[ROW][C]40[/C][C]3750[/C][C]3283.30769230769[/C][C]466.692307692308[/C][/ROW]
[ROW][C]41[/C][C]3413[/C][C]2518.84210526316[/C][C]894.157894736842[/C][/ROW]
[ROW][C]42[/C][C]2053[/C][C]2214.95[/C][C]-161.95[/C][/ROW]
[ROW][C]43[/C][C]1984[/C][C]2214.95[/C][C]-230.95[/C][/ROW]
[ROW][C]44[/C][C]1825[/C][C]1838.90909090909[/C][C]-13.909090909091[/C][/ROW]
[ROW][C]45[/C][C]2783[/C][C]1838.90909090909[/C][C]944.090909090909[/C][/ROW]
[ROW][C]46[/C][C]5572[/C][C]4006.3[/C][C]1565.7[/C][/ROW]
[ROW][C]47[/C][C]918[/C][C]1038.09090909091[/C][C]-120.090909090909[/C][/ROW]
[ROW][C]48[/C][C]2685[/C][C]2518.84210526316[/C][C]166.157894736842[/C][/ROW]
[ROW][C]49[/C][C]4145[/C][C]3283.30769230769[/C][C]861.692307692308[/C][/ROW]
[ROW][C]50[/C][C]2841[/C][C]2214.95[/C][C]626.05[/C][/ROW]
[ROW][C]51[/C][C]2175[/C][C]2214.95[/C][C]-39.9499999999998[/C][/ROW]
[ROW][C]52[/C][C]496[/C][C]481.222222222222[/C][C]14.7777777777778[/C][/ROW]
[ROW][C]53[/C][C]2699[/C][C]4006.3[/C][C]-1307.3[/C][/ROW]
[ROW][C]54[/C][C]744[/C][C]1038.09090909091[/C][C]-294.090909090909[/C][/ROW]
[ROW][C]55[/C][C]1161[/C][C]1038.09090909091[/C][C]122.909090909091[/C][/ROW]
[ROW][C]56[/C][C]3333[/C][C]2518.84210526316[/C][C]814.157894736842[/C][/ROW]
[ROW][C]57[/C][C]2970[/C][C]3283.30769230769[/C][C]-313.307692307692[/C][/ROW]
[ROW][C]58[/C][C]3969[/C][C]3283.30769230769[/C][C]685.692307692308[/C][/ROW]
[ROW][C]59[/C][C]2919[/C][C]3283.30769230769[/C][C]-364.307692307692[/C][/ROW]
[ROW][C]60[/C][C]2399[/C][C]2518.84210526316[/C][C]-119.842105263158[/C][/ROW]
[ROW][C]61[/C][C]4121[/C][C]4006.3[/C][C]114.7[/C][/ROW]
[ROW][C]62[/C][C]3323[/C][C]2999.61538461538[/C][C]323.384615384615[/C][/ROW]
[ROW][C]63[/C][C]3132[/C][C]2999.61538461538[/C][C]132.384615384615[/C][/ROW]
[ROW][C]64[/C][C]2868[/C][C]2518.84210526316[/C][C]349.157894736842[/C][/ROW]
[ROW][C]65[/C][C]1778[/C][C]2518.84210526316[/C][C]-740.842105263158[/C][/ROW]
[ROW][C]66[/C][C]2109[/C][C]2518.84210526316[/C][C]-409.842105263158[/C][/ROW]
[ROW][C]67[/C][C]2148[/C][C]2557.28571428571[/C][C]-409.285714285714[/C][/ROW]
[ROW][C]68[/C][C]3009[/C][C]2999.61538461538[/C][C]9.38461538461524[/C][/ROW]
[ROW][C]69[/C][C]2562[/C][C]2518.84210526316[/C][C]43.1578947368421[/C][/ROW]
[ROW][C]70[/C][C]1737[/C][C]1838.90909090909[/C][C]-101.909090909091[/C][/ROW]
[ROW][C]71[/C][C]2680[/C][C]2518.84210526316[/C][C]161.157894736842[/C][/ROW]
[ROW][C]72[/C][C]893[/C][C]1038.09090909091[/C][C]-145.090909090909[/C][/ROW]
[ROW][C]73[/C][C]2389[/C][C]2518.84210526316[/C][C]-129.842105263158[/C][/ROW]
[ROW][C]74[/C][C]2197[/C][C]2214.95[/C][C]-17.9499999999998[/C][/ROW]
[ROW][C]75[/C][C]2227[/C][C]2214.95[/C][C]12.0500000000002[/C][/ROW]
[ROW][C]76[/C][C]2370[/C][C]3283.30769230769[/C][C]-913.307692307692[/C][/ROW]
[ROW][C]77[/C][C]3226[/C][C]4006.3[/C][C]-780.3[/C][/ROW]
[ROW][C]78[/C][C]1978[/C][C]2557.28571428571[/C][C]-579.285714285714[/C][/ROW]
[ROW][C]79[/C][C]2516[/C][C]2214.95[/C][C]301.05[/C][/ROW]
[ROW][C]80[/C][C]2147[/C][C]2214.95[/C][C]-67.9499999999998[/C][/ROW]
[ROW][C]81[/C][C]2150[/C][C]1838.90909090909[/C][C]311.090909090909[/C][/ROW]
[ROW][C]82[/C][C]4229[/C][C]4006.3[/C][C]222.7[/C][/ROW]
[ROW][C]83[/C][C]1380[/C][C]1038.09090909091[/C][C]341.909090909091[/C][/ROW]
[ROW][C]84[/C][C]2449[/C][C]2999.61538461538[/C][C]-550.615384615385[/C][/ROW]
[ROW][C]85[/C][C]870[/C][C]1038.09090909091[/C][C]-168.090909090909[/C][/ROW]
[ROW][C]86[/C][C]2700[/C][C]2214.95[/C][C]485.05[/C][/ROW]
[ROW][C]87[/C][C]1574[/C][C]1838.90909090909[/C][C]-264.909090909091[/C][/ROW]
[ROW][C]88[/C][C]4046[/C][C]4006.3[/C][C]39.6999999999998[/C][/ROW]
[ROW][C]89[/C][C]3259[/C][C]3283.30769230769[/C][C]-24.3076923076924[/C][/ROW]
[ROW][C]90[/C][C]3098[/C][C]2557.28571428571[/C][C]540.714285714286[/C][/ROW]
[ROW][C]91[/C][C]2615[/C][C]2518.84210526316[/C][C]96.157894736842[/C][/ROW]
[ROW][C]92[/C][C]2404[/C][C]2518.84210526316[/C][C]-114.842105263158[/C][/ROW]
[ROW][C]93[/C][C]1932[/C][C]1838.90909090909[/C][C]93.090909090909[/C][/ROW]
[ROW][C]94[/C][C]3147[/C][C]2518.84210526316[/C][C]628.157894736842[/C][/ROW]
[ROW][C]95[/C][C]2598[/C][C]2518.84210526316[/C][C]79.157894736842[/C][/ROW]
[ROW][C]96[/C][C]2108[/C][C]2214.95[/C][C]-106.95[/C][/ROW]
[ROW][C]97[/C][C]2193[/C][C]2518.84210526316[/C][C]-325.842105263158[/C][/ROW]
[ROW][C]98[/C][C]2478[/C][C]2518.84210526316[/C][C]-40.8421052631579[/C][/ROW]
[ROW][C]99[/C][C]4198[/C][C]4006.3[/C][C]191.7[/C][/ROW]
[ROW][C]100[/C][C]4165[/C][C]4006.3[/C][C]158.7[/C][/ROW]
[ROW][C]101[/C][C]2842[/C][C]2999.61538461538[/C][C]-157.615384615385[/C][/ROW]
[ROW][C]102[/C][C]2562[/C][C]2518.84210526316[/C][C]43.1578947368421[/C][/ROW]
[ROW][C]103[/C][C]2449[/C][C]2557.28571428571[/C][C]-108.285714285714[/C][/ROW]
[ROW][C]104[/C][C]602[/C][C]481.222222222222[/C][C]120.777777777778[/C][/ROW]
[ROW][C]105[/C][C]2579[/C][C]2214.95[/C][C]364.05[/C][/ROW]
[ROW][C]106[/C][C]2591[/C][C]2999.61538461538[/C][C]-408.615384615385[/C][/ROW]
[ROW][C]107[/C][C]2957[/C][C]2518.84210526316[/C][C]438.157894736842[/C][/ROW]
[ROW][C]108[/C][C]2786[/C][C]2518.84210526316[/C][C]267.157894736842[/C][/ROW]
[ROW][C]109[/C][C]1477[/C][C]1838.90909090909[/C][C]-361.909090909091[/C][/ROW]
[ROW][C]110[/C][C]3350[/C][C]2557.28571428571[/C][C]792.714285714286[/C][/ROW]
[ROW][C]111[/C][C]2107[/C][C]2518.84210526316[/C][C]-411.842105263158[/C][/ROW]
[ROW][C]112[/C][C]2332[/C][C]2518.84210526316[/C][C]-186.842105263158[/C][/ROW]
[ROW][C]113[/C][C]400[/C][C]481.222222222222[/C][C]-81.2222222222222[/C][/ROW]
[ROW][C]114[/C][C]2233[/C][C]1838.90909090909[/C][C]394.090909090909[/C][/ROW]
[ROW][C]115[/C][C]530[/C][C]481.222222222222[/C][C]48.7777777777778[/C][/ROW]
[ROW][C]116[/C][C]2033[/C][C]2214.95[/C][C]-181.95[/C][/ROW]
[ROW][C]117[/C][C]3246[/C][C]4006.3[/C][C]-760.3[/C][/ROW]
[ROW][C]118[/C][C]387[/C][C]481.222222222222[/C][C]-94.2222222222222[/C][/ROW]
[ROW][C]119[/C][C]2137[/C][C]2214.95[/C][C]-77.9499999999998[/C][/ROW]
[ROW][C]120[/C][C]492[/C][C]481.222222222222[/C][C]10.7777777777778[/C][/ROW]
[ROW][C]121[/C][C]3838[/C][C]3283.30769230769[/C][C]554.692307692308[/C][/ROW]
[ROW][C]122[/C][C]2193[/C][C]2214.95[/C][C]-21.9499999999998[/C][/ROW]
[ROW][C]123[/C][C]1796[/C][C]1838.90909090909[/C][C]-42.909090909091[/C][/ROW]
[ROW][C]124[/C][C]1907[/C][C]1838.90909090909[/C][C]68.090909090909[/C][/ROW]
[ROW][C]125[/C][C]568[/C][C]481.222222222222[/C][C]86.7777777777778[/C][/ROW]
[ROW][C]126[/C][C]2602[/C][C]2518.84210526316[/C][C]83.157894736842[/C][/ROW]
[ROW][C]127[/C][C]2819[/C][C]2518.84210526316[/C][C]300.157894736842[/C][/ROW]
[ROW][C]128[/C][C]1464[/C][C]1838.90909090909[/C][C]-374.909090909091[/C][/ROW]
[ROW][C]129[/C][C]3946[/C][C]4006.3[/C][C]-60.3000000000002[/C][/ROW]
[ROW][C]130[/C][C]2554[/C][C]2518.84210526316[/C][C]35.1578947368421[/C][/ROW]
[ROW][C]131[/C][C]3506[/C][C]4006.3[/C][C]-500.3[/C][/ROW]
[ROW][C]132[/C][C]1552[/C][C]1838.90909090909[/C][C]-286.909090909091[/C][/ROW]
[ROW][C]133[/C][C]1389[/C][C]1038.09090909091[/C][C]350.909090909091[/C][/ROW]
[ROW][C]134[/C][C]3101[/C][C]2999.61538461538[/C][C]101.384615384615[/C][/ROW]
[ROW][C]135[/C][C]4541[/C][C]4006.3[/C][C]534.7[/C][/ROW]
[ROW][C]136[/C][C]1872[/C][C]1838.90909090909[/C][C]33.090909090909[/C][/ROW]
[ROW][C]137[/C][C]4403[/C][C]4006.3[/C][C]396.7[/C][/ROW]
[ROW][C]138[/C][C]2113[/C][C]1838.90909090909[/C][C]274.090909090909[/C][/ROW]
[ROW][C]139[/C][C]2046[/C][C]2518.84210526316[/C][C]-472.842105263158[/C][/ROW]
[ROW][C]140[/C][C]2564[/C][C]2518.84210526316[/C][C]45.1578947368421[/C][/ROW]
[ROW][C]141[/C][C]2145[/C][C]2557.28571428571[/C][C]-412.285714285714[/C][/ROW]
[ROW][C]142[/C][C]4112[/C][C]3283.30769230769[/C][C]828.692307692308[/C][/ROW]
[ROW][C]143[/C][C]2340[/C][C]2214.95[/C][C]125.05[/C][/ROW]
[ROW][C]144[/C][C]2035[/C][C]1838.90909090909[/C][C]196.090909090909[/C][/ROW]
[ROW][C]145[/C][C]3241[/C][C]2999.61538461538[/C][C]241.384615384615[/C][/ROW]
[ROW][C]146[/C][C]1991[/C][C]1838.90909090909[/C][C]152.090909090909[/C][/ROW]
[ROW][C]147[/C][C]2864[/C][C]2518.84210526316[/C][C]345.157894736842[/C][/ROW]
[ROW][C]148[/C][C]2748[/C][C]2999.61538461538[/C][C]-251.615384615385[/C][/ROW]
[ROW][C]149[/C][C]2[/C][C]49.7272727272727[/C][C]-47.7272727272727[/C][/ROW]
[ROW][C]150[/C][C]207[/C][C]49.7272727272727[/C][C]157.272727272727[/C][/ROW]
[ROW][C]151[/C][C]5[/C][C]49.7272727272727[/C][C]-44.7272727272727[/C][/ROW]
[ROW][C]152[/C][C]8[/C][C]49.7272727272727[/C][C]-41.7272727272727[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]49.7272727272727[/C][C]-49.7272727272727[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]49.7272727272727[/C][C]-49.7272727272727[/C][/ROW]
[ROW][C]155[/C][C]2449[/C][C]2518.84210526316[/C][C]-69.8421052631579[/C][/ROW]
[ROW][C]156[/C][C]3490[/C][C]4006.3[/C][C]-516.3[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]49.7272727272727[/C][C]-49.7272727272727[/C][/ROW]
[ROW][C]158[/C][C]4[/C][C]49.7272727272727[/C][C]-45.7272727272727[/C][/ROW]
[ROW][C]159[/C][C]151[/C][C]49.7272727272727[/C][C]101.272727272727[/C][/ROW]
[ROW][C]160[/C][C]475[/C][C]481.222222222222[/C][C]-6.22222222222223[/C][/ROW]
[ROW][C]161[/C][C]141[/C][C]49.7272727272727[/C][C]91.2727272727273[/C][/ROW]
[ROW][C]162[/C][C]1145[/C][C]1038.09090909091[/C][C]106.909090909091[/C][/ROW]
[ROW][C]163[/C][C]29[/C][C]49.7272727272727[/C][C]-20.7272727272727[/C][/ROW]
[ROW][C]164[/C][C]2080[/C][C]2214.95[/C][C]-134.95[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160527&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160527&T=2

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
118182518.84210526316-700.842105263158
214331838.90909090909-405.909090909091
320592214.95-155.95
427332557.28571428571175.714285714286
513991838.90909090909-439.909090909091
66311038.09090909091-407.090909090909
754604006.31453.7
8381481.222222222222-100.222222222222
921502214.95-64.9499999999998
1020422518.84210526316-476.842105263158
1125363283.30769230769-747.307692307692
1224292999.61538461538-570.615384615385
1321001838.90909090909261.090909090909
1430203283.30769230769-263.307692307692
1522652518.84210526316-253.842105263158
1651394006.31132.7
1723632518.84210526316-155.842105263158
1835644006.3-442.3
1915161838.90909090909-322.909090909091
2023982518.84210526316-120.842105263158
2125462518.8421052631627.1578947368421
2232534006.3-753.3
2317052214.95-509.95
2417871838.90909090909-51.909090909091
2537922999.61538461538792.384615384615
2631082999.61538461538108.384615384615
2732302999.61538461538230.384615384615
2823482518.84210526316-170.842105263158
2917801838.90909090909-58.909090909091
3032183283.30769230769-65.3076923076924
3126922518.84210526316173.157894736842
3221872518.84210526316-331.842105263158
3325773283.30769230769-706.307692307692
3412931038.09090909091254.909090909091
3535674006.3-439.3
3627642518.84210526316245.157894736842
3737554006.3-251.3
3820752214.95-139.95
399951038.09090909091-43.090909090909
4037503283.30769230769466.692307692308
4134132518.84210526316894.157894736842
4220532214.95-161.95
4319842214.95-230.95
4418251838.90909090909-13.909090909091
4527831838.90909090909944.090909090909
4655724006.31565.7
479181038.09090909091-120.090909090909
4826852518.84210526316166.157894736842
4941453283.30769230769861.692307692308
5028412214.95626.05
5121752214.95-39.9499999999998
52496481.22222222222214.7777777777778
5326994006.3-1307.3
547441038.09090909091-294.090909090909
5511611038.09090909091122.909090909091
5633332518.84210526316814.157894736842
5729703283.30769230769-313.307692307692
5839693283.30769230769685.692307692308
5929193283.30769230769-364.307692307692
6023992518.84210526316-119.842105263158
6141214006.3114.7
6233232999.61538461538323.384615384615
6331322999.61538461538132.384615384615
6428682518.84210526316349.157894736842
6517782518.84210526316-740.842105263158
6621092518.84210526316-409.842105263158
6721482557.28571428571-409.285714285714
6830092999.615384615389.38461538461524
6925622518.8421052631643.1578947368421
7017371838.90909090909-101.909090909091
7126802518.84210526316161.157894736842
728931038.09090909091-145.090909090909
7323892518.84210526316-129.842105263158
7421972214.95-17.9499999999998
7522272214.9512.0500000000002
7623703283.30769230769-913.307692307692
7732264006.3-780.3
7819782557.28571428571-579.285714285714
7925162214.95301.05
8021472214.95-67.9499999999998
8121501838.90909090909311.090909090909
8242294006.3222.7
8313801038.09090909091341.909090909091
8424492999.61538461538-550.615384615385
858701038.09090909091-168.090909090909
8627002214.95485.05
8715741838.90909090909-264.909090909091
8840464006.339.6999999999998
8932593283.30769230769-24.3076923076924
9030982557.28571428571540.714285714286
9126152518.8421052631696.157894736842
9224042518.84210526316-114.842105263158
9319321838.9090909090993.090909090909
9431472518.84210526316628.157894736842
9525982518.8421052631679.157894736842
9621082214.95-106.95
9721932518.84210526316-325.842105263158
9824782518.84210526316-40.8421052631579
9941984006.3191.7
10041654006.3158.7
10128422999.61538461538-157.615384615385
10225622518.8421052631643.1578947368421
10324492557.28571428571-108.285714285714
104602481.222222222222120.777777777778
10525792214.95364.05
10625912999.61538461538-408.615384615385
10729572518.84210526316438.157894736842
10827862518.84210526316267.157894736842
10914771838.90909090909-361.909090909091
11033502557.28571428571792.714285714286
11121072518.84210526316-411.842105263158
11223322518.84210526316-186.842105263158
113400481.222222222222-81.2222222222222
11422331838.90909090909394.090909090909
115530481.22222222222248.7777777777778
11620332214.95-181.95
11732464006.3-760.3
118387481.222222222222-94.2222222222222
11921372214.95-77.9499999999998
120492481.22222222222210.7777777777778
12138383283.30769230769554.692307692308
12221932214.95-21.9499999999998
12317961838.90909090909-42.909090909091
12419071838.9090909090968.090909090909
125568481.22222222222286.7777777777778
12626022518.8421052631683.157894736842
12728192518.84210526316300.157894736842
12814641838.90909090909-374.909090909091
12939464006.3-60.3000000000002
13025542518.8421052631635.1578947368421
13135064006.3-500.3
13215521838.90909090909-286.909090909091
13313891038.09090909091350.909090909091
13431012999.61538461538101.384615384615
13545414006.3534.7
13618721838.9090909090933.090909090909
13744034006.3396.7
13821131838.90909090909274.090909090909
13920462518.84210526316-472.842105263158
14025642518.8421052631645.1578947368421
14121452557.28571428571-412.285714285714
14241123283.30769230769828.692307692308
14323402214.95125.05
14420351838.90909090909196.090909090909
14532412999.61538461538241.384615384615
14619911838.90909090909152.090909090909
14728642518.84210526316345.157894736842
14827482999.61538461538-251.615384615385
149249.7272727272727-47.7272727272727
15020749.7272727272727157.272727272727
151549.7272727272727-44.7272727272727
152849.7272727272727-41.7272727272727
153049.7272727272727-49.7272727272727
154049.7272727272727-49.7272727272727
15524492518.84210526316-69.8421052631579
15634904006.3-516.3
157049.7272727272727-49.7272727272727
158449.7272727272727-45.7272727272727
15915149.7272727272727101.272727272727
160475481.222222222222-6.22222222222223
16114149.727272727272791.2727272727273
16211451038.09090909091106.909090909091
1632949.7272727272727-20.7272727272727
16420802214.95-134.95



Parameters (Session):
par1 = 1 ; par2 = none ; par3 = 3 ; par4 = no ;
Parameters (R input):
par1 = 1 ; par2 = none ; par3 = 3 ; par4 = no ;
R code (references can be found in the software module):
library(party)
library(Hmisc)
par1 <- as.numeric(par1)
par3 <- as.numeric(par3)
x <- data.frame(t(y))
is.data.frame(x)
x <- x[!is.na(x[,par1]),]
k <- length(x[1,])
n <- length(x[,1])
colnames(x)[par1]
x[,par1]
if (par2 == 'kmeans') {
cl <- kmeans(x[,par1], par3)
print(cl)
clm <- matrix(cbind(cl$centers,1:par3),ncol=2)
clm <- clm[sort.list(clm[,1]),]
for (i in 1:par3) {
cl$cluster[cl$cluster==clm[i,2]] <- paste('C',i,sep='')
}
cl$cluster <- as.factor(cl$cluster)
print(cl$cluster)
x[,par1] <- cl$cluster
}
if (par2 == 'quantiles') {
x[,par1] <- cut2(x[,par1],g=par3)
}
if (par2 == 'hclust') {
hc <- hclust(dist(x[,par1])^2, 'cen')
print(hc)
memb <- cutree(hc, k = par3)
dum <- c(mean(x[memb==1,par1]))
for (i in 2:par3) {
dum <- c(dum, mean(x[memb==i,par1]))
}
hcm <- matrix(cbind(dum,1:par3),ncol=2)
hcm <- hcm[sort.list(hcm[,1]),]
for (i in 1:par3) {
memb[memb==hcm[i,2]] <- paste('C',i,sep='')
}
memb <- as.factor(memb)
print(memb)
x[,par1] <- memb
}
if (par2=='equal') {
ed <- cut(as.numeric(x[,par1]),par3,labels=paste('C',1:par3,sep=''))
x[,par1] <- as.factor(ed)
}
table(x[,par1])
colnames(x)
colnames(x)[par1]
x[,par1]
if (par2 == 'none') {
m <- ctree(as.formula(paste(colnames(x)[par1],' ~ .',sep='')),data = x)
}
load(file='createtable')
if (par2 != 'none') {
m <- ctree(as.formula(paste('as.factor(',colnames(x)[par1],') ~ .',sep='')),data = x)
if (par4=='yes') {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'10-Fold Cross Validation',3+2*par3,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'',1,TRUE)
a<-table.element(a,'Prediction (training)',par3+1,TRUE)
a<-table.element(a,'Prediction (testing)',par3+1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Actual',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,paste('C',jjj,sep=''),1,TRUE)
a<-table.element(a,'CV',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,paste('C',jjj,sep=''),1,TRUE)
a<-table.element(a,'CV',1,TRUE)
a<-table.row.end(a)
for (i in 1:10) {
ind <- sample(2, nrow(x), replace=T, prob=c(0.9,0.1))
m.ct <- ctree(as.formula(paste('as.factor(',colnames(x)[par1],') ~ .',sep='')),data =x[ind==1,])
if (i==1) {
m.ct.i.pred <- predict(m.ct, newdata=x[ind==1,])
m.ct.i.actu <- x[ind==1,par1]
m.ct.x.pred <- predict(m.ct, newdata=x[ind==2,])
m.ct.x.actu <- x[ind==2,par1]
} else {
m.ct.i.pred <- c(m.ct.i.pred,predict(m.ct, newdata=x[ind==1,]))
m.ct.i.actu <- c(m.ct.i.actu,x[ind==1,par1])
m.ct.x.pred <- c(m.ct.x.pred,predict(m.ct, newdata=x[ind==2,]))
m.ct.x.actu <- c(m.ct.x.actu,x[ind==2,par1])
}
}
print(m.ct.i.tab <- table(m.ct.i.actu,m.ct.i.pred))
numer <- 0
for (i in 1:par3) {
print(m.ct.i.tab[i,i] / sum(m.ct.i.tab[i,]))
numer <- numer + m.ct.i.tab[i,i]
}
print(m.ct.i.cp <- numer / sum(m.ct.i.tab))
print(m.ct.x.tab <- table(m.ct.x.actu,m.ct.x.pred))
numer <- 0
for (i in 1:par3) {
print(m.ct.x.tab[i,i] / sum(m.ct.x.tab[i,]))
numer <- numer + m.ct.x.tab[i,i]
}
print(m.ct.x.cp <- numer / sum(m.ct.x.tab))
for (i in 1:par3) {
a<-table.row.start(a)
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
for (jjj in 1:par3) a<-table.element(a,m.ct.i.tab[i,jjj])
a<-table.element(a,round(m.ct.i.tab[i,i]/sum(m.ct.i.tab[i,]),4))
for (jjj in 1:par3) a<-table.element(a,m.ct.x.tab[i,jjj])
a<-table.element(a,round(m.ct.x.tab[i,i]/sum(m.ct.x.tab[i,]),4))
a<-table.row.end(a)
}
a<-table.row.start(a)
a<-table.element(a,'Overall',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,'-')
a<-table.element(a,round(m.ct.i.cp,4))
for (jjj in 1:par3) a<-table.element(a,'-')
a<-table.element(a,round(m.ct.x.cp,4))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
}
}
m
bitmap(file='test1.png')
plot(m)
dev.off()
bitmap(file='test1a.png')
plot(x[,par1] ~ as.factor(where(m)),main='Response by Terminal Node',xlab='Terminal Node',ylab='Response')
dev.off()
if (par2 == 'none') {
forec <- predict(m)
result <- as.data.frame(cbind(x[,par1],forec,x[,par1]-forec))
colnames(result) <- c('Actuals','Forecasts','Residuals')
print(result)
}
if (par2 != 'none') {
print(cbind(as.factor(x[,par1]),predict(m)))
myt <- table(as.factor(x[,par1]),predict(m))
print(myt)
}
bitmap(file='test2.png')
if(par2=='none') {
op <- par(mfrow=c(2,2))
plot(density(result$Actuals),main='Kernel Density Plot of Actuals')
plot(density(result$Residuals),main='Kernel Density Plot of Residuals')
plot(result$Forecasts,result$Actuals,main='Actuals versus Predictions',xlab='Predictions',ylab='Actuals')
plot(density(result$Forecasts),main='Kernel Density Plot of Predictions')
par(op)
}
if(par2!='none') {
plot(myt,main='Confusion Matrix',xlab='Actual',ylab='Predicted')
}
dev.off()
if (par2 == 'none') {
detcoef <- cor(result$Forecasts,result$Actuals)
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Goodness of Fit',2,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Correlation',1,TRUE)
a<-table.element(a,round(detcoef,4))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'R-squared',1,TRUE)
a<-table.element(a,round(detcoef*detcoef,4))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'RMSE',1,TRUE)
a<-table.element(a,round(sqrt(mean((result$Residuals)^2)),4))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable1.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Actuals, Predictions, and Residuals',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'#',header=TRUE)
a<-table.element(a,'Actuals',header=TRUE)
a<-table.element(a,'Forecasts',header=TRUE)
a<-table.element(a,'Residuals',header=TRUE)
a<-table.row.end(a)
for (i in 1:length(result$Actuals)) {
a<-table.row.start(a)
a<-table.element(a,i,header=TRUE)
a<-table.element(a,result$Actuals[i])
a<-table.element(a,result$Forecasts[i])
a<-table.element(a,result$Residuals[i])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable.tab')
}
if (par2 != 'none') {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Confusion Matrix (predicted in columns / actuals in rows)',par3+1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'',1,TRUE)
for (i in 1:par3) {
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
}
a<-table.row.end(a)
for (i in 1:par3) {
a<-table.row.start(a)
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
for (j in 1:par3) {
a<-table.element(a,myt[i,j])
}
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable2.tab')
}