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 computationTue, 13 Dec 2011 14:49:51 -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/13/t1323805833htp4i0rd9v0wa0a.htm/, Retrieved Thu, 02 May 2024 18:31:33 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=154670, Retrieved Thu, 02 May 2024 18:31:33 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact76
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)] [] [2011-12-13 19:49:51] [bd748940d7962893950720dfc8008aaa] [Current]
-           [Recursive Partitioning (Regression Trees)] [] [2011-12-13 19:51:15] [0748461f029d231b348d2f525a63e360]
-   P         [Recursive Partitioning (Regression Trees)] [] [2011-12-13 21:07:48] [0748461f029d231b348d2f525a63e360]
Feedback Forum

Post a new message
Dataseries X:
255202	34	131	104	124252
135248	30	117	111	98956
198520	38	146	93	98073
189326	34	132	119	106816
141365	25	80	57	41449
65295	31	117	80	76173
439387	29	112	107	177551
33186	18	67	22	22807
183696	30	116	103	126938
186657	29	107	72	61680
269127	40	148	129	72117
194414	50	190	168	79738
141409	33	109	100	57793
306730	46	159	143	91677
192691	38	146	79	64631
333497	52	201	183	106385
261835	32	124	123	161961
263451	35	131	81	112669
157448	25	96	74	114029
232190	42	163	158	124550
245725	40	151	133	105416
388603	35	128	128	72875
156540	25	89	84	81964
156189	46	184	184	104880
186381	36	136	127	76302
192167	35	134	128	96740
249893	38	146	118	93071
236812	35	130	125	78912
143160	28	105	89	35224
259667	37	142	122	90694
243020	40	155	151	125369
176062	42	154	122	80849
286683	44	169	162	104434
87485	33	125	121	65702
329737	38	147	144	108179
247082	37	139	110	63583
366219	41	151	141	95066
191653	32	124	80	62486
114673	17	55	46	31081
294371	38	147	140	94584
284195	33	125	103	87408
155568	35	128	95	68966
177306	32	107	100	88766
144595	35	130	102	57139
140319	45	73	45	90586
405267	38	138	122	109249
78800	26	82	66	33032
201970	45	173	159	96056
302705	44	169	153	146648
164733	40	145	131	80613
194221	33	134	113	87026
24188	4	12	7	5950
346142	41	151	147	131106
65029	18	67	61	32551
101097	14	52	41	31701
253745	36	131	117	91072
273513	49	186	184	159803
282220	32	120	115	143950
280928	37	135	132	112368
214872	32	123	113	82124
342048	43	166	149	144068
273924	25	90	65	162627
194396	42	165	94	55062
231162	37	143	126	95329
209798	33	125	112	105612
201345	28	110	81	62853
166424	31	121	116	125976
204441	40	151	132	79146
197813	32	123	104	108461
136421	25	92	80	99971
216092	42	162	145	77826
73566	23	88	67	22618
213998	42	163	159	84892
181728	38	133	90	92059
148758	34	132	120	77993
308343	39	147	129	104155
251437	32	124	118	109840
202388	37	140	112	238712
173286	34	132	123	67486
155529	33	122	98	68007
132672	25	97	78	48194
390163	45	175	138	134796
145905	26	99	99	38692
228012	40	106	81	93587
80953	8	28	27	56622
130805	27	101	77	15986
135163	32	120	118	113402
331003	37	143	137	97967
271806	50	178	103	74844
162828	41	155	143	136051
234092	37	138	85	50548
207158	38	141	131	112215
156583	28	102	81	59591
242395	36	140	135	59938
261601	32	124	116	137639
178489	32	124	123	143372
204221	33	119	119	138599
268066	35	129	100	174110
318087	58	223	221	135062
361799	27	102	95	175681
247131	45	174	153	130307
265849	37	141	118	139141
160309	32	122	50	44244
43287	19	71	64	43750
172244	22	81	34	48029
189021	35	131	76	95216
227681	36	139	112	92288
269329	36	137	115	94588
106503	23	91	69	197426
117891	40	157	123	151244
287201	40	149	143	139206
266805	42	155	110	106271
23623	1	0	0	1168
174954	36	139	94	71764
61857	11	32	30	25162
144889	40	149	106	45635
347988	34	128	91	101817
21054	0	0	0	855
224051	27	99	69	100174
31414	8	25	9	14116
277214	35	132	123	85008
209481	44	167	150	124254
156870	40	151	125	105793
112933	28	103	81	117129
38214	8	27	21	8773
166011	36	135	128	94747
316044	47	178	168	107549
181578	48	185	155	97392
358903	45	175	157	126893
275578	48	187	145	118850
368796	49	182	172	234853
172464	35	135	126	74783
94381	32	118	89	66089
249649	36	140	137	95684
382499	42	158	149	139537
118010	35	132	121	144253
365539	42	156	149	153824
147989	34	123	93	63995
231681	41	151	135	84891
193119	36	129	102	61263
189020	32	125	45	106221
341958	33	128	104	113587
219133	35	129	111	113864
173260	21	79	78	37238
274787	42	162	126	119906
130908	49	188	176	135096
204009	33	122	109	151611
262412	39	144	132	144645
1	0	0	0	0
14688	0	0	0	6023
98	0	0	0	0
455	0	0	0	0
0	0	0	0	0
0	0	0	0	0
195765	33	120	78	77457
330975	45	179	110	62464
0	0	0	0	0
203	0	0	0	0
7199	0	0	0	1644
46660	5	15	13	6179
17547	1	4	4	3926
107465	38	133	65	42087
969	0	0	0	0
179994	28	101	55	87656




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time5 seconds
R Server'George Udny Yule' @ yule.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 & 5 seconds \tabularnewline
R Server & 'George Udny Yule' @ yule.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154670&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]5 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'George Udny Yule' @ yule.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154670&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154670&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 time5 seconds
R Server'George Udny Yule' @ yule.wessa.net







Goodness of Fit
Correlation0.8015
R-squared0.6424
RMSE59255.9948

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8015[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6424[/C][/ROW]
[ROW][C]RMSE[/C][C]59255.9948[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154670&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154670&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.8015
R-squared0.6424
RMSE59255.9948







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1255202226094.16981132129107.8301886792
2135248226094.169811321-90846.1698113208
3198520226094.169811321-27574.1698113208
4189326226094.169811321-36768.1698113208
514136598433.538461538542931.4615384615
665295153021.96-87726.96
7439387226094.169811321213292.830188679
83318698433.5384615385-65247.5384615385
9183696226094.169811321-42398.1698113208
10186657153021.9633635.04
11269127269100.65217391326.3478260869742
12194414269100.652173913-74686.652173913
13141409153021.96-11612.96
14306730269100.65217391337629.347826087
15192691215332.8-22641.8
16333497269100.65217391364396.347826087
17261835226094.16981132135740.8301886792
18263451226094.16981132137356.8301886792
19157448226094.169811321-68646.1698113208
20232190269100.652173913-36910.652173913
21245725269100.652173913-23375.652173913
22388603269100.652173913119502.347826087
23156540153021.963518.04000000001
24156189269100.652173913-112911.652173913
25186381215332.8-28951.8
26192167269100.652173913-76933.652173913
27249893226094.16981132123798.8301886792
28236812153021.9683790.04
29143160153021.96-9861.96
30259667226094.16981132133572.8301886792
31243020269100.652173913-26080.652173913
32176062215332.8-39270.8
33286683269100.65217391317582.347826087
3487485153021.96-65536.96
35329737269100.65217391360636.347826087
36247082215332.831749.2
37366219269100.65217391397118.347826087
38191653153021.9638631.04
3911467398433.538461538516239.4615384615
40294371269100.65217391325270.347826087
41284195226094.16981132158100.8301886792
42155568153021.962546.04000000001
43177306226094.169811321-48788.1698113208
44144595153021.96-8426.96
4514031998433.538461538541885.4615384615
46405267226094.169811321179172.830188679
477880098433.5384615385-19633.5384615385
48201970269100.652173913-67130.652173913
49302705269100.65217391333604.347826087
50164733269100.652173913-104367.652173913
51194221226094.169811321-31873.1698113208
522418813312.529411764710875.4705882353
53346142269100.65217391377041.347826087
546502998433.5384615385-33404.5384615385
5510109798433.53846153852663.46153846153
56253745226094.16981132127650.8301886792
57273513269100.6521739134412.34782608697
58282220226094.16981132156125.8301886792
59280928269100.65217391311827.347826087
60214872226094.169811321-11222.1698113208
61342048269100.65217391372947.347826087
62273924226094.16981132147829.8301886792
63194396215332.8-20936.8
64231162226094.1698113215067.83018867925
65209798226094.169811321-16296.1698113208
66201345153021.9648323.04
67166424226094.169811321-59670.1698113208
68204441269100.652173913-64659.652173913
69197813226094.169811321-28281.1698113208
70136421226094.169811321-89673.1698113208
71216092269100.652173913-53008.652173913
727356698433.5384615385-24867.5384615385
73213998269100.652173913-55102.652173913
74181728226094.169811321-44366.1698113208
75148758153021.96-4263.95999999999
76308343269100.65217391339242.347826087
77251437226094.16981132125342.8301886792
78202388226094.169811321-23706.1698113208
79173286153021.9620264.04
80155529153021.962507.04000000001
81132672153021.96-20349.96
82390163269100.652173913121062.347826087
83145905153021.96-7116.95999999999
84228012226094.1698113211917.83018867925
858095398433.5384615385-17480.5384615385
86130805153021.96-22216.96
87135163226094.169811321-90931.1698113208
88331003269100.65217391361902.347826087
89271806215332.856473.2
90162828269100.652173913-106272.652173913
91234092215332.818759.2
92207158269100.652173913-61942.652173913
93156583153021.963561.04000000001
94242395269100.652173913-26705.652173913
95261601226094.16981132135506.8301886792
96178489226094.169811321-47605.1698113208
97204221226094.169811321-21873.1698113208
98268066226094.16981132141971.8301886792
99318087269100.65217391348986.347826087
100361799226094.169811321135704.830188679
101247131269100.652173913-21969.652173913
102265849226094.16981132139754.8301886792
103160309153021.967287.04
1044328798433.5384615385-55146.5384615385
10517224498433.538461538573810.4615384615
106189021226094.169811321-37073.1698113208
107227681226094.1698113211586.83018867925
108269329226094.16981132143234.8301886792
109106503226094.169811321-119591.169811321
110117891226094.169811321-108203.169811321
111287201269100.65217391318100.347826087
112266805226094.16981132140710.8301886792
1132362313312.529411764710310.4705882353
114174954215332.8-40378.8
1156185798433.5384615385-36576.5384615385
116144889215332.8-70443.8
117347988226094.169811321121893.830188679
1182105413312.52941176477741.47058823529
119224051226094.169811321-2043.16981132075
1203141413312.529411764718101.4705882353
121277214226094.16981132151119.8301886792
122209481269100.652173913-59619.652173913
123156870226094.169811321-69224.1698113208
124112933226094.169811321-113161.169811321
1253821413312.529411764724901.4705882353
126166011269100.652173913-103089.652173913
127316044269100.65217391346943.347826087
128181578269100.652173913-87522.652173913
129358903269100.65217391389802.347826087
130275578269100.6521739136477.34782608697
131368796269100.65217391399695.347826087
132172464153021.9619442.04
13394381153021.96-58640.96
134249649269100.652173913-19451.652173913
135382499269100.652173913113398.347826087
136118010226094.169811321-108084.169811321
137365539269100.65217391396438.347826087
138147989153021.96-5032.95999999999
139231681269100.652173913-37419.652173913
140193119153021.9640097.04
141189020226094.169811321-37074.1698113208
142341958226094.169811321115863.830188679
143219133226094.169811321-6961.16981132075
14417326098433.538461538574826.4615384615
145274787226094.16981132148692.8301886792
146130908269100.652173913-138192.652173913
147204009226094.169811321-22085.1698113208
148262412269100.652173913-6688.65217391303
149113312.5294117647-13311.5294117647
1501468813312.52941176471375.47058823529
1519813312.5294117647-13214.5294117647
15245513312.5294117647-12857.5294117647
153013312.5294117647-13312.5294117647
154013312.5294117647-13312.5294117647
155195765153021.9642743.04
156330975215332.8115642.2
157013312.5294117647-13312.5294117647
15820313312.5294117647-13109.5294117647
159719913312.5294117647-6113.52941176471
1604666013312.529411764733347.4705882353
1611754713312.52941176474234.47058823529
162107465153021.96-45556.96
16396913312.5294117647-12343.5294117647
164179994226094.169811321-46100.1698113208

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 255202 & 226094.169811321 & 29107.8301886792 \tabularnewline
2 & 135248 & 226094.169811321 & -90846.1698113208 \tabularnewline
3 & 198520 & 226094.169811321 & -27574.1698113208 \tabularnewline
4 & 189326 & 226094.169811321 & -36768.1698113208 \tabularnewline
5 & 141365 & 98433.5384615385 & 42931.4615384615 \tabularnewline
6 & 65295 & 153021.96 & -87726.96 \tabularnewline
7 & 439387 & 226094.169811321 & 213292.830188679 \tabularnewline
8 & 33186 & 98433.5384615385 & -65247.5384615385 \tabularnewline
9 & 183696 & 226094.169811321 & -42398.1698113208 \tabularnewline
10 & 186657 & 153021.96 & 33635.04 \tabularnewline
11 & 269127 & 269100.652173913 & 26.3478260869742 \tabularnewline
12 & 194414 & 269100.652173913 & -74686.652173913 \tabularnewline
13 & 141409 & 153021.96 & -11612.96 \tabularnewline
14 & 306730 & 269100.652173913 & 37629.347826087 \tabularnewline
15 & 192691 & 215332.8 & -22641.8 \tabularnewline
16 & 333497 & 269100.652173913 & 64396.347826087 \tabularnewline
17 & 261835 & 226094.169811321 & 35740.8301886792 \tabularnewline
18 & 263451 & 226094.169811321 & 37356.8301886792 \tabularnewline
19 & 157448 & 226094.169811321 & -68646.1698113208 \tabularnewline
20 & 232190 & 269100.652173913 & -36910.652173913 \tabularnewline
21 & 245725 & 269100.652173913 & -23375.652173913 \tabularnewline
22 & 388603 & 269100.652173913 & 119502.347826087 \tabularnewline
23 & 156540 & 153021.96 & 3518.04000000001 \tabularnewline
24 & 156189 & 269100.652173913 & -112911.652173913 \tabularnewline
25 & 186381 & 215332.8 & -28951.8 \tabularnewline
26 & 192167 & 269100.652173913 & -76933.652173913 \tabularnewline
27 & 249893 & 226094.169811321 & 23798.8301886792 \tabularnewline
28 & 236812 & 153021.96 & 83790.04 \tabularnewline
29 & 143160 & 153021.96 & -9861.96 \tabularnewline
30 & 259667 & 226094.169811321 & 33572.8301886792 \tabularnewline
31 & 243020 & 269100.652173913 & -26080.652173913 \tabularnewline
32 & 176062 & 215332.8 & -39270.8 \tabularnewline
33 & 286683 & 269100.652173913 & 17582.347826087 \tabularnewline
34 & 87485 & 153021.96 & -65536.96 \tabularnewline
35 & 329737 & 269100.652173913 & 60636.347826087 \tabularnewline
36 & 247082 & 215332.8 & 31749.2 \tabularnewline
37 & 366219 & 269100.652173913 & 97118.347826087 \tabularnewline
38 & 191653 & 153021.96 & 38631.04 \tabularnewline
39 & 114673 & 98433.5384615385 & 16239.4615384615 \tabularnewline
40 & 294371 & 269100.652173913 & 25270.347826087 \tabularnewline
41 & 284195 & 226094.169811321 & 58100.8301886792 \tabularnewline
42 & 155568 & 153021.96 & 2546.04000000001 \tabularnewline
43 & 177306 & 226094.169811321 & -48788.1698113208 \tabularnewline
44 & 144595 & 153021.96 & -8426.96 \tabularnewline
45 & 140319 & 98433.5384615385 & 41885.4615384615 \tabularnewline
46 & 405267 & 226094.169811321 & 179172.830188679 \tabularnewline
47 & 78800 & 98433.5384615385 & -19633.5384615385 \tabularnewline
48 & 201970 & 269100.652173913 & -67130.652173913 \tabularnewline
49 & 302705 & 269100.652173913 & 33604.347826087 \tabularnewline
50 & 164733 & 269100.652173913 & -104367.652173913 \tabularnewline
51 & 194221 & 226094.169811321 & -31873.1698113208 \tabularnewline
52 & 24188 & 13312.5294117647 & 10875.4705882353 \tabularnewline
53 & 346142 & 269100.652173913 & 77041.347826087 \tabularnewline
54 & 65029 & 98433.5384615385 & -33404.5384615385 \tabularnewline
55 & 101097 & 98433.5384615385 & 2663.46153846153 \tabularnewline
56 & 253745 & 226094.169811321 & 27650.8301886792 \tabularnewline
57 & 273513 & 269100.652173913 & 4412.34782608697 \tabularnewline
58 & 282220 & 226094.169811321 & 56125.8301886792 \tabularnewline
59 & 280928 & 269100.652173913 & 11827.347826087 \tabularnewline
60 & 214872 & 226094.169811321 & -11222.1698113208 \tabularnewline
61 & 342048 & 269100.652173913 & 72947.347826087 \tabularnewline
62 & 273924 & 226094.169811321 & 47829.8301886792 \tabularnewline
63 & 194396 & 215332.8 & -20936.8 \tabularnewline
64 & 231162 & 226094.169811321 & 5067.83018867925 \tabularnewline
65 & 209798 & 226094.169811321 & -16296.1698113208 \tabularnewline
66 & 201345 & 153021.96 & 48323.04 \tabularnewline
67 & 166424 & 226094.169811321 & -59670.1698113208 \tabularnewline
68 & 204441 & 269100.652173913 & -64659.652173913 \tabularnewline
69 & 197813 & 226094.169811321 & -28281.1698113208 \tabularnewline
70 & 136421 & 226094.169811321 & -89673.1698113208 \tabularnewline
71 & 216092 & 269100.652173913 & -53008.652173913 \tabularnewline
72 & 73566 & 98433.5384615385 & -24867.5384615385 \tabularnewline
73 & 213998 & 269100.652173913 & -55102.652173913 \tabularnewline
74 & 181728 & 226094.169811321 & -44366.1698113208 \tabularnewline
75 & 148758 & 153021.96 & -4263.95999999999 \tabularnewline
76 & 308343 & 269100.652173913 & 39242.347826087 \tabularnewline
77 & 251437 & 226094.169811321 & 25342.8301886792 \tabularnewline
78 & 202388 & 226094.169811321 & -23706.1698113208 \tabularnewline
79 & 173286 & 153021.96 & 20264.04 \tabularnewline
80 & 155529 & 153021.96 & 2507.04000000001 \tabularnewline
81 & 132672 & 153021.96 & -20349.96 \tabularnewline
82 & 390163 & 269100.652173913 & 121062.347826087 \tabularnewline
83 & 145905 & 153021.96 & -7116.95999999999 \tabularnewline
84 & 228012 & 226094.169811321 & 1917.83018867925 \tabularnewline
85 & 80953 & 98433.5384615385 & -17480.5384615385 \tabularnewline
86 & 130805 & 153021.96 & -22216.96 \tabularnewline
87 & 135163 & 226094.169811321 & -90931.1698113208 \tabularnewline
88 & 331003 & 269100.652173913 & 61902.347826087 \tabularnewline
89 & 271806 & 215332.8 & 56473.2 \tabularnewline
90 & 162828 & 269100.652173913 & -106272.652173913 \tabularnewline
91 & 234092 & 215332.8 & 18759.2 \tabularnewline
92 & 207158 & 269100.652173913 & -61942.652173913 \tabularnewline
93 & 156583 & 153021.96 & 3561.04000000001 \tabularnewline
94 & 242395 & 269100.652173913 & -26705.652173913 \tabularnewline
95 & 261601 & 226094.169811321 & 35506.8301886792 \tabularnewline
96 & 178489 & 226094.169811321 & -47605.1698113208 \tabularnewline
97 & 204221 & 226094.169811321 & -21873.1698113208 \tabularnewline
98 & 268066 & 226094.169811321 & 41971.8301886792 \tabularnewline
99 & 318087 & 269100.652173913 & 48986.347826087 \tabularnewline
100 & 361799 & 226094.169811321 & 135704.830188679 \tabularnewline
101 & 247131 & 269100.652173913 & -21969.652173913 \tabularnewline
102 & 265849 & 226094.169811321 & 39754.8301886792 \tabularnewline
103 & 160309 & 153021.96 & 7287.04 \tabularnewline
104 & 43287 & 98433.5384615385 & -55146.5384615385 \tabularnewline
105 & 172244 & 98433.5384615385 & 73810.4615384615 \tabularnewline
106 & 189021 & 226094.169811321 & -37073.1698113208 \tabularnewline
107 & 227681 & 226094.169811321 & 1586.83018867925 \tabularnewline
108 & 269329 & 226094.169811321 & 43234.8301886792 \tabularnewline
109 & 106503 & 226094.169811321 & -119591.169811321 \tabularnewline
110 & 117891 & 226094.169811321 & -108203.169811321 \tabularnewline
111 & 287201 & 269100.652173913 & 18100.347826087 \tabularnewline
112 & 266805 & 226094.169811321 & 40710.8301886792 \tabularnewline
113 & 23623 & 13312.5294117647 & 10310.4705882353 \tabularnewline
114 & 174954 & 215332.8 & -40378.8 \tabularnewline
115 & 61857 & 98433.5384615385 & -36576.5384615385 \tabularnewline
116 & 144889 & 215332.8 & -70443.8 \tabularnewline
117 & 347988 & 226094.169811321 & 121893.830188679 \tabularnewline
118 & 21054 & 13312.5294117647 & 7741.47058823529 \tabularnewline
119 & 224051 & 226094.169811321 & -2043.16981132075 \tabularnewline
120 & 31414 & 13312.5294117647 & 18101.4705882353 \tabularnewline
121 & 277214 & 226094.169811321 & 51119.8301886792 \tabularnewline
122 & 209481 & 269100.652173913 & -59619.652173913 \tabularnewline
123 & 156870 & 226094.169811321 & -69224.1698113208 \tabularnewline
124 & 112933 & 226094.169811321 & -113161.169811321 \tabularnewline
125 & 38214 & 13312.5294117647 & 24901.4705882353 \tabularnewline
126 & 166011 & 269100.652173913 & -103089.652173913 \tabularnewline
127 & 316044 & 269100.652173913 & 46943.347826087 \tabularnewline
128 & 181578 & 269100.652173913 & -87522.652173913 \tabularnewline
129 & 358903 & 269100.652173913 & 89802.347826087 \tabularnewline
130 & 275578 & 269100.652173913 & 6477.34782608697 \tabularnewline
131 & 368796 & 269100.652173913 & 99695.347826087 \tabularnewline
132 & 172464 & 153021.96 & 19442.04 \tabularnewline
133 & 94381 & 153021.96 & -58640.96 \tabularnewline
134 & 249649 & 269100.652173913 & -19451.652173913 \tabularnewline
135 & 382499 & 269100.652173913 & 113398.347826087 \tabularnewline
136 & 118010 & 226094.169811321 & -108084.169811321 \tabularnewline
137 & 365539 & 269100.652173913 & 96438.347826087 \tabularnewline
138 & 147989 & 153021.96 & -5032.95999999999 \tabularnewline
139 & 231681 & 269100.652173913 & -37419.652173913 \tabularnewline
140 & 193119 & 153021.96 & 40097.04 \tabularnewline
141 & 189020 & 226094.169811321 & -37074.1698113208 \tabularnewline
142 & 341958 & 226094.169811321 & 115863.830188679 \tabularnewline
143 & 219133 & 226094.169811321 & -6961.16981132075 \tabularnewline
144 & 173260 & 98433.5384615385 & 74826.4615384615 \tabularnewline
145 & 274787 & 226094.169811321 & 48692.8301886792 \tabularnewline
146 & 130908 & 269100.652173913 & -138192.652173913 \tabularnewline
147 & 204009 & 226094.169811321 & -22085.1698113208 \tabularnewline
148 & 262412 & 269100.652173913 & -6688.65217391303 \tabularnewline
149 & 1 & 13312.5294117647 & -13311.5294117647 \tabularnewline
150 & 14688 & 13312.5294117647 & 1375.47058823529 \tabularnewline
151 & 98 & 13312.5294117647 & -13214.5294117647 \tabularnewline
152 & 455 & 13312.5294117647 & -12857.5294117647 \tabularnewline
153 & 0 & 13312.5294117647 & -13312.5294117647 \tabularnewline
154 & 0 & 13312.5294117647 & -13312.5294117647 \tabularnewline
155 & 195765 & 153021.96 & 42743.04 \tabularnewline
156 & 330975 & 215332.8 & 115642.2 \tabularnewline
157 & 0 & 13312.5294117647 & -13312.5294117647 \tabularnewline
158 & 203 & 13312.5294117647 & -13109.5294117647 \tabularnewline
159 & 7199 & 13312.5294117647 & -6113.52941176471 \tabularnewline
160 & 46660 & 13312.5294117647 & 33347.4705882353 \tabularnewline
161 & 17547 & 13312.5294117647 & 4234.47058823529 \tabularnewline
162 & 107465 & 153021.96 & -45556.96 \tabularnewline
163 & 969 & 13312.5294117647 & -12343.5294117647 \tabularnewline
164 & 179994 & 226094.169811321 & -46100.1698113208 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154670&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]255202[/C][C]226094.169811321[/C][C]29107.8301886792[/C][/ROW]
[ROW][C]2[/C][C]135248[/C][C]226094.169811321[/C][C]-90846.1698113208[/C][/ROW]
[ROW][C]3[/C][C]198520[/C][C]226094.169811321[/C][C]-27574.1698113208[/C][/ROW]
[ROW][C]4[/C][C]189326[/C][C]226094.169811321[/C][C]-36768.1698113208[/C][/ROW]
[ROW][C]5[/C][C]141365[/C][C]98433.5384615385[/C][C]42931.4615384615[/C][/ROW]
[ROW][C]6[/C][C]65295[/C][C]153021.96[/C][C]-87726.96[/C][/ROW]
[ROW][C]7[/C][C]439387[/C][C]226094.169811321[/C][C]213292.830188679[/C][/ROW]
[ROW][C]8[/C][C]33186[/C][C]98433.5384615385[/C][C]-65247.5384615385[/C][/ROW]
[ROW][C]9[/C][C]183696[/C][C]226094.169811321[/C][C]-42398.1698113208[/C][/ROW]
[ROW][C]10[/C][C]186657[/C][C]153021.96[/C][C]33635.04[/C][/ROW]
[ROW][C]11[/C][C]269127[/C][C]269100.652173913[/C][C]26.3478260869742[/C][/ROW]
[ROW][C]12[/C][C]194414[/C][C]269100.652173913[/C][C]-74686.652173913[/C][/ROW]
[ROW][C]13[/C][C]141409[/C][C]153021.96[/C][C]-11612.96[/C][/ROW]
[ROW][C]14[/C][C]306730[/C][C]269100.652173913[/C][C]37629.347826087[/C][/ROW]
[ROW][C]15[/C][C]192691[/C][C]215332.8[/C][C]-22641.8[/C][/ROW]
[ROW][C]16[/C][C]333497[/C][C]269100.652173913[/C][C]64396.347826087[/C][/ROW]
[ROW][C]17[/C][C]261835[/C][C]226094.169811321[/C][C]35740.8301886792[/C][/ROW]
[ROW][C]18[/C][C]263451[/C][C]226094.169811321[/C][C]37356.8301886792[/C][/ROW]
[ROW][C]19[/C][C]157448[/C][C]226094.169811321[/C][C]-68646.1698113208[/C][/ROW]
[ROW][C]20[/C][C]232190[/C][C]269100.652173913[/C][C]-36910.652173913[/C][/ROW]
[ROW][C]21[/C][C]245725[/C][C]269100.652173913[/C][C]-23375.652173913[/C][/ROW]
[ROW][C]22[/C][C]388603[/C][C]269100.652173913[/C][C]119502.347826087[/C][/ROW]
[ROW][C]23[/C][C]156540[/C][C]153021.96[/C][C]3518.04000000001[/C][/ROW]
[ROW][C]24[/C][C]156189[/C][C]269100.652173913[/C][C]-112911.652173913[/C][/ROW]
[ROW][C]25[/C][C]186381[/C][C]215332.8[/C][C]-28951.8[/C][/ROW]
[ROW][C]26[/C][C]192167[/C][C]269100.652173913[/C][C]-76933.652173913[/C][/ROW]
[ROW][C]27[/C][C]249893[/C][C]226094.169811321[/C][C]23798.8301886792[/C][/ROW]
[ROW][C]28[/C][C]236812[/C][C]153021.96[/C][C]83790.04[/C][/ROW]
[ROW][C]29[/C][C]143160[/C][C]153021.96[/C][C]-9861.96[/C][/ROW]
[ROW][C]30[/C][C]259667[/C][C]226094.169811321[/C][C]33572.8301886792[/C][/ROW]
[ROW][C]31[/C][C]243020[/C][C]269100.652173913[/C][C]-26080.652173913[/C][/ROW]
[ROW][C]32[/C][C]176062[/C][C]215332.8[/C][C]-39270.8[/C][/ROW]
[ROW][C]33[/C][C]286683[/C][C]269100.652173913[/C][C]17582.347826087[/C][/ROW]
[ROW][C]34[/C][C]87485[/C][C]153021.96[/C][C]-65536.96[/C][/ROW]
[ROW][C]35[/C][C]329737[/C][C]269100.652173913[/C][C]60636.347826087[/C][/ROW]
[ROW][C]36[/C][C]247082[/C][C]215332.8[/C][C]31749.2[/C][/ROW]
[ROW][C]37[/C][C]366219[/C][C]269100.652173913[/C][C]97118.347826087[/C][/ROW]
[ROW][C]38[/C][C]191653[/C][C]153021.96[/C][C]38631.04[/C][/ROW]
[ROW][C]39[/C][C]114673[/C][C]98433.5384615385[/C][C]16239.4615384615[/C][/ROW]
[ROW][C]40[/C][C]294371[/C][C]269100.652173913[/C][C]25270.347826087[/C][/ROW]
[ROW][C]41[/C][C]284195[/C][C]226094.169811321[/C][C]58100.8301886792[/C][/ROW]
[ROW][C]42[/C][C]155568[/C][C]153021.96[/C][C]2546.04000000001[/C][/ROW]
[ROW][C]43[/C][C]177306[/C][C]226094.169811321[/C][C]-48788.1698113208[/C][/ROW]
[ROW][C]44[/C][C]144595[/C][C]153021.96[/C][C]-8426.96[/C][/ROW]
[ROW][C]45[/C][C]140319[/C][C]98433.5384615385[/C][C]41885.4615384615[/C][/ROW]
[ROW][C]46[/C][C]405267[/C][C]226094.169811321[/C][C]179172.830188679[/C][/ROW]
[ROW][C]47[/C][C]78800[/C][C]98433.5384615385[/C][C]-19633.5384615385[/C][/ROW]
[ROW][C]48[/C][C]201970[/C][C]269100.652173913[/C][C]-67130.652173913[/C][/ROW]
[ROW][C]49[/C][C]302705[/C][C]269100.652173913[/C][C]33604.347826087[/C][/ROW]
[ROW][C]50[/C][C]164733[/C][C]269100.652173913[/C][C]-104367.652173913[/C][/ROW]
[ROW][C]51[/C][C]194221[/C][C]226094.169811321[/C][C]-31873.1698113208[/C][/ROW]
[ROW][C]52[/C][C]24188[/C][C]13312.5294117647[/C][C]10875.4705882353[/C][/ROW]
[ROW][C]53[/C][C]346142[/C][C]269100.652173913[/C][C]77041.347826087[/C][/ROW]
[ROW][C]54[/C][C]65029[/C][C]98433.5384615385[/C][C]-33404.5384615385[/C][/ROW]
[ROW][C]55[/C][C]101097[/C][C]98433.5384615385[/C][C]2663.46153846153[/C][/ROW]
[ROW][C]56[/C][C]253745[/C][C]226094.169811321[/C][C]27650.8301886792[/C][/ROW]
[ROW][C]57[/C][C]273513[/C][C]269100.652173913[/C][C]4412.34782608697[/C][/ROW]
[ROW][C]58[/C][C]282220[/C][C]226094.169811321[/C][C]56125.8301886792[/C][/ROW]
[ROW][C]59[/C][C]280928[/C][C]269100.652173913[/C][C]11827.347826087[/C][/ROW]
[ROW][C]60[/C][C]214872[/C][C]226094.169811321[/C][C]-11222.1698113208[/C][/ROW]
[ROW][C]61[/C][C]342048[/C][C]269100.652173913[/C][C]72947.347826087[/C][/ROW]
[ROW][C]62[/C][C]273924[/C][C]226094.169811321[/C][C]47829.8301886792[/C][/ROW]
[ROW][C]63[/C][C]194396[/C][C]215332.8[/C][C]-20936.8[/C][/ROW]
[ROW][C]64[/C][C]231162[/C][C]226094.169811321[/C][C]5067.83018867925[/C][/ROW]
[ROW][C]65[/C][C]209798[/C][C]226094.169811321[/C][C]-16296.1698113208[/C][/ROW]
[ROW][C]66[/C][C]201345[/C][C]153021.96[/C][C]48323.04[/C][/ROW]
[ROW][C]67[/C][C]166424[/C][C]226094.169811321[/C][C]-59670.1698113208[/C][/ROW]
[ROW][C]68[/C][C]204441[/C][C]269100.652173913[/C][C]-64659.652173913[/C][/ROW]
[ROW][C]69[/C][C]197813[/C][C]226094.169811321[/C][C]-28281.1698113208[/C][/ROW]
[ROW][C]70[/C][C]136421[/C][C]226094.169811321[/C][C]-89673.1698113208[/C][/ROW]
[ROW][C]71[/C][C]216092[/C][C]269100.652173913[/C][C]-53008.652173913[/C][/ROW]
[ROW][C]72[/C][C]73566[/C][C]98433.5384615385[/C][C]-24867.5384615385[/C][/ROW]
[ROW][C]73[/C][C]213998[/C][C]269100.652173913[/C][C]-55102.652173913[/C][/ROW]
[ROW][C]74[/C][C]181728[/C][C]226094.169811321[/C][C]-44366.1698113208[/C][/ROW]
[ROW][C]75[/C][C]148758[/C][C]153021.96[/C][C]-4263.95999999999[/C][/ROW]
[ROW][C]76[/C][C]308343[/C][C]269100.652173913[/C][C]39242.347826087[/C][/ROW]
[ROW][C]77[/C][C]251437[/C][C]226094.169811321[/C][C]25342.8301886792[/C][/ROW]
[ROW][C]78[/C][C]202388[/C][C]226094.169811321[/C][C]-23706.1698113208[/C][/ROW]
[ROW][C]79[/C][C]173286[/C][C]153021.96[/C][C]20264.04[/C][/ROW]
[ROW][C]80[/C][C]155529[/C][C]153021.96[/C][C]2507.04000000001[/C][/ROW]
[ROW][C]81[/C][C]132672[/C][C]153021.96[/C][C]-20349.96[/C][/ROW]
[ROW][C]82[/C][C]390163[/C][C]269100.652173913[/C][C]121062.347826087[/C][/ROW]
[ROW][C]83[/C][C]145905[/C][C]153021.96[/C][C]-7116.95999999999[/C][/ROW]
[ROW][C]84[/C][C]228012[/C][C]226094.169811321[/C][C]1917.83018867925[/C][/ROW]
[ROW][C]85[/C][C]80953[/C][C]98433.5384615385[/C][C]-17480.5384615385[/C][/ROW]
[ROW][C]86[/C][C]130805[/C][C]153021.96[/C][C]-22216.96[/C][/ROW]
[ROW][C]87[/C][C]135163[/C][C]226094.169811321[/C][C]-90931.1698113208[/C][/ROW]
[ROW][C]88[/C][C]331003[/C][C]269100.652173913[/C][C]61902.347826087[/C][/ROW]
[ROW][C]89[/C][C]271806[/C][C]215332.8[/C][C]56473.2[/C][/ROW]
[ROW][C]90[/C][C]162828[/C][C]269100.652173913[/C][C]-106272.652173913[/C][/ROW]
[ROW][C]91[/C][C]234092[/C][C]215332.8[/C][C]18759.2[/C][/ROW]
[ROW][C]92[/C][C]207158[/C][C]269100.652173913[/C][C]-61942.652173913[/C][/ROW]
[ROW][C]93[/C][C]156583[/C][C]153021.96[/C][C]3561.04000000001[/C][/ROW]
[ROW][C]94[/C][C]242395[/C][C]269100.652173913[/C][C]-26705.652173913[/C][/ROW]
[ROW][C]95[/C][C]261601[/C][C]226094.169811321[/C][C]35506.8301886792[/C][/ROW]
[ROW][C]96[/C][C]178489[/C][C]226094.169811321[/C][C]-47605.1698113208[/C][/ROW]
[ROW][C]97[/C][C]204221[/C][C]226094.169811321[/C][C]-21873.1698113208[/C][/ROW]
[ROW][C]98[/C][C]268066[/C][C]226094.169811321[/C][C]41971.8301886792[/C][/ROW]
[ROW][C]99[/C][C]318087[/C][C]269100.652173913[/C][C]48986.347826087[/C][/ROW]
[ROW][C]100[/C][C]361799[/C][C]226094.169811321[/C][C]135704.830188679[/C][/ROW]
[ROW][C]101[/C][C]247131[/C][C]269100.652173913[/C][C]-21969.652173913[/C][/ROW]
[ROW][C]102[/C][C]265849[/C][C]226094.169811321[/C][C]39754.8301886792[/C][/ROW]
[ROW][C]103[/C][C]160309[/C][C]153021.96[/C][C]7287.04[/C][/ROW]
[ROW][C]104[/C][C]43287[/C][C]98433.5384615385[/C][C]-55146.5384615385[/C][/ROW]
[ROW][C]105[/C][C]172244[/C][C]98433.5384615385[/C][C]73810.4615384615[/C][/ROW]
[ROW][C]106[/C][C]189021[/C][C]226094.169811321[/C][C]-37073.1698113208[/C][/ROW]
[ROW][C]107[/C][C]227681[/C][C]226094.169811321[/C][C]1586.83018867925[/C][/ROW]
[ROW][C]108[/C][C]269329[/C][C]226094.169811321[/C][C]43234.8301886792[/C][/ROW]
[ROW][C]109[/C][C]106503[/C][C]226094.169811321[/C][C]-119591.169811321[/C][/ROW]
[ROW][C]110[/C][C]117891[/C][C]226094.169811321[/C][C]-108203.169811321[/C][/ROW]
[ROW][C]111[/C][C]287201[/C][C]269100.652173913[/C][C]18100.347826087[/C][/ROW]
[ROW][C]112[/C][C]266805[/C][C]226094.169811321[/C][C]40710.8301886792[/C][/ROW]
[ROW][C]113[/C][C]23623[/C][C]13312.5294117647[/C][C]10310.4705882353[/C][/ROW]
[ROW][C]114[/C][C]174954[/C][C]215332.8[/C][C]-40378.8[/C][/ROW]
[ROW][C]115[/C][C]61857[/C][C]98433.5384615385[/C][C]-36576.5384615385[/C][/ROW]
[ROW][C]116[/C][C]144889[/C][C]215332.8[/C][C]-70443.8[/C][/ROW]
[ROW][C]117[/C][C]347988[/C][C]226094.169811321[/C][C]121893.830188679[/C][/ROW]
[ROW][C]118[/C][C]21054[/C][C]13312.5294117647[/C][C]7741.47058823529[/C][/ROW]
[ROW][C]119[/C][C]224051[/C][C]226094.169811321[/C][C]-2043.16981132075[/C][/ROW]
[ROW][C]120[/C][C]31414[/C][C]13312.5294117647[/C][C]18101.4705882353[/C][/ROW]
[ROW][C]121[/C][C]277214[/C][C]226094.169811321[/C][C]51119.8301886792[/C][/ROW]
[ROW][C]122[/C][C]209481[/C][C]269100.652173913[/C][C]-59619.652173913[/C][/ROW]
[ROW][C]123[/C][C]156870[/C][C]226094.169811321[/C][C]-69224.1698113208[/C][/ROW]
[ROW][C]124[/C][C]112933[/C][C]226094.169811321[/C][C]-113161.169811321[/C][/ROW]
[ROW][C]125[/C][C]38214[/C][C]13312.5294117647[/C][C]24901.4705882353[/C][/ROW]
[ROW][C]126[/C][C]166011[/C][C]269100.652173913[/C][C]-103089.652173913[/C][/ROW]
[ROW][C]127[/C][C]316044[/C][C]269100.652173913[/C][C]46943.347826087[/C][/ROW]
[ROW][C]128[/C][C]181578[/C][C]269100.652173913[/C][C]-87522.652173913[/C][/ROW]
[ROW][C]129[/C][C]358903[/C][C]269100.652173913[/C][C]89802.347826087[/C][/ROW]
[ROW][C]130[/C][C]275578[/C][C]269100.652173913[/C][C]6477.34782608697[/C][/ROW]
[ROW][C]131[/C][C]368796[/C][C]269100.652173913[/C][C]99695.347826087[/C][/ROW]
[ROW][C]132[/C][C]172464[/C][C]153021.96[/C][C]19442.04[/C][/ROW]
[ROW][C]133[/C][C]94381[/C][C]153021.96[/C][C]-58640.96[/C][/ROW]
[ROW][C]134[/C][C]249649[/C][C]269100.652173913[/C][C]-19451.652173913[/C][/ROW]
[ROW][C]135[/C][C]382499[/C][C]269100.652173913[/C][C]113398.347826087[/C][/ROW]
[ROW][C]136[/C][C]118010[/C][C]226094.169811321[/C][C]-108084.169811321[/C][/ROW]
[ROW][C]137[/C][C]365539[/C][C]269100.652173913[/C][C]96438.347826087[/C][/ROW]
[ROW][C]138[/C][C]147989[/C][C]153021.96[/C][C]-5032.95999999999[/C][/ROW]
[ROW][C]139[/C][C]231681[/C][C]269100.652173913[/C][C]-37419.652173913[/C][/ROW]
[ROW][C]140[/C][C]193119[/C][C]153021.96[/C][C]40097.04[/C][/ROW]
[ROW][C]141[/C][C]189020[/C][C]226094.169811321[/C][C]-37074.1698113208[/C][/ROW]
[ROW][C]142[/C][C]341958[/C][C]226094.169811321[/C][C]115863.830188679[/C][/ROW]
[ROW][C]143[/C][C]219133[/C][C]226094.169811321[/C][C]-6961.16981132075[/C][/ROW]
[ROW][C]144[/C][C]173260[/C][C]98433.5384615385[/C][C]74826.4615384615[/C][/ROW]
[ROW][C]145[/C][C]274787[/C][C]226094.169811321[/C][C]48692.8301886792[/C][/ROW]
[ROW][C]146[/C][C]130908[/C][C]269100.652173913[/C][C]-138192.652173913[/C][/ROW]
[ROW][C]147[/C][C]204009[/C][C]226094.169811321[/C][C]-22085.1698113208[/C][/ROW]
[ROW][C]148[/C][C]262412[/C][C]269100.652173913[/C][C]-6688.65217391303[/C][/ROW]
[ROW][C]149[/C][C]1[/C][C]13312.5294117647[/C][C]-13311.5294117647[/C][/ROW]
[ROW][C]150[/C][C]14688[/C][C]13312.5294117647[/C][C]1375.47058823529[/C][/ROW]
[ROW][C]151[/C][C]98[/C][C]13312.5294117647[/C][C]-13214.5294117647[/C][/ROW]
[ROW][C]152[/C][C]455[/C][C]13312.5294117647[/C][C]-12857.5294117647[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]13312.5294117647[/C][C]-13312.5294117647[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]13312.5294117647[/C][C]-13312.5294117647[/C][/ROW]
[ROW][C]155[/C][C]195765[/C][C]153021.96[/C][C]42743.04[/C][/ROW]
[ROW][C]156[/C][C]330975[/C][C]215332.8[/C][C]115642.2[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]13312.5294117647[/C][C]-13312.5294117647[/C][/ROW]
[ROW][C]158[/C][C]203[/C][C]13312.5294117647[/C][C]-13109.5294117647[/C][/ROW]
[ROW][C]159[/C][C]7199[/C][C]13312.5294117647[/C][C]-6113.52941176471[/C][/ROW]
[ROW][C]160[/C][C]46660[/C][C]13312.5294117647[/C][C]33347.4705882353[/C][/ROW]
[ROW][C]161[/C][C]17547[/C][C]13312.5294117647[/C][C]4234.47058823529[/C][/ROW]
[ROW][C]162[/C][C]107465[/C][C]153021.96[/C][C]-45556.96[/C][/ROW]
[ROW][C]163[/C][C]969[/C][C]13312.5294117647[/C][C]-12343.5294117647[/C][/ROW]
[ROW][C]164[/C][C]179994[/C][C]226094.169811321[/C][C]-46100.1698113208[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154670&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154670&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
1255202226094.16981132129107.8301886792
2135248226094.169811321-90846.1698113208
3198520226094.169811321-27574.1698113208
4189326226094.169811321-36768.1698113208
514136598433.538461538542931.4615384615
665295153021.96-87726.96
7439387226094.169811321213292.830188679
83318698433.5384615385-65247.5384615385
9183696226094.169811321-42398.1698113208
10186657153021.9633635.04
11269127269100.65217391326.3478260869742
12194414269100.652173913-74686.652173913
13141409153021.96-11612.96
14306730269100.65217391337629.347826087
15192691215332.8-22641.8
16333497269100.65217391364396.347826087
17261835226094.16981132135740.8301886792
18263451226094.16981132137356.8301886792
19157448226094.169811321-68646.1698113208
20232190269100.652173913-36910.652173913
21245725269100.652173913-23375.652173913
22388603269100.652173913119502.347826087
23156540153021.963518.04000000001
24156189269100.652173913-112911.652173913
25186381215332.8-28951.8
26192167269100.652173913-76933.652173913
27249893226094.16981132123798.8301886792
28236812153021.9683790.04
29143160153021.96-9861.96
30259667226094.16981132133572.8301886792
31243020269100.652173913-26080.652173913
32176062215332.8-39270.8
33286683269100.65217391317582.347826087
3487485153021.96-65536.96
35329737269100.65217391360636.347826087
36247082215332.831749.2
37366219269100.65217391397118.347826087
38191653153021.9638631.04
3911467398433.538461538516239.4615384615
40294371269100.65217391325270.347826087
41284195226094.16981132158100.8301886792
42155568153021.962546.04000000001
43177306226094.169811321-48788.1698113208
44144595153021.96-8426.96
4514031998433.538461538541885.4615384615
46405267226094.169811321179172.830188679
477880098433.5384615385-19633.5384615385
48201970269100.652173913-67130.652173913
49302705269100.65217391333604.347826087
50164733269100.652173913-104367.652173913
51194221226094.169811321-31873.1698113208
522418813312.529411764710875.4705882353
53346142269100.65217391377041.347826087
546502998433.5384615385-33404.5384615385
5510109798433.53846153852663.46153846153
56253745226094.16981132127650.8301886792
57273513269100.6521739134412.34782608697
58282220226094.16981132156125.8301886792
59280928269100.65217391311827.347826087
60214872226094.169811321-11222.1698113208
61342048269100.65217391372947.347826087
62273924226094.16981132147829.8301886792
63194396215332.8-20936.8
64231162226094.1698113215067.83018867925
65209798226094.169811321-16296.1698113208
66201345153021.9648323.04
67166424226094.169811321-59670.1698113208
68204441269100.652173913-64659.652173913
69197813226094.169811321-28281.1698113208
70136421226094.169811321-89673.1698113208
71216092269100.652173913-53008.652173913
727356698433.5384615385-24867.5384615385
73213998269100.652173913-55102.652173913
74181728226094.169811321-44366.1698113208
75148758153021.96-4263.95999999999
76308343269100.65217391339242.347826087
77251437226094.16981132125342.8301886792
78202388226094.169811321-23706.1698113208
79173286153021.9620264.04
80155529153021.962507.04000000001
81132672153021.96-20349.96
82390163269100.652173913121062.347826087
83145905153021.96-7116.95999999999
84228012226094.1698113211917.83018867925
858095398433.5384615385-17480.5384615385
86130805153021.96-22216.96
87135163226094.169811321-90931.1698113208
88331003269100.65217391361902.347826087
89271806215332.856473.2
90162828269100.652173913-106272.652173913
91234092215332.818759.2
92207158269100.652173913-61942.652173913
93156583153021.963561.04000000001
94242395269100.652173913-26705.652173913
95261601226094.16981132135506.8301886792
96178489226094.169811321-47605.1698113208
97204221226094.169811321-21873.1698113208
98268066226094.16981132141971.8301886792
99318087269100.65217391348986.347826087
100361799226094.169811321135704.830188679
101247131269100.652173913-21969.652173913
102265849226094.16981132139754.8301886792
103160309153021.967287.04
1044328798433.5384615385-55146.5384615385
10517224498433.538461538573810.4615384615
106189021226094.169811321-37073.1698113208
107227681226094.1698113211586.83018867925
108269329226094.16981132143234.8301886792
109106503226094.169811321-119591.169811321
110117891226094.169811321-108203.169811321
111287201269100.65217391318100.347826087
112266805226094.16981132140710.8301886792
1132362313312.529411764710310.4705882353
114174954215332.8-40378.8
1156185798433.5384615385-36576.5384615385
116144889215332.8-70443.8
117347988226094.169811321121893.830188679
1182105413312.52941176477741.47058823529
119224051226094.169811321-2043.16981132075
1203141413312.529411764718101.4705882353
121277214226094.16981132151119.8301886792
122209481269100.652173913-59619.652173913
123156870226094.169811321-69224.1698113208
124112933226094.169811321-113161.169811321
1253821413312.529411764724901.4705882353
126166011269100.652173913-103089.652173913
127316044269100.65217391346943.347826087
128181578269100.652173913-87522.652173913
129358903269100.65217391389802.347826087
130275578269100.6521739136477.34782608697
131368796269100.65217391399695.347826087
132172464153021.9619442.04
13394381153021.96-58640.96
134249649269100.652173913-19451.652173913
135382499269100.652173913113398.347826087
136118010226094.169811321-108084.169811321
137365539269100.65217391396438.347826087
138147989153021.96-5032.95999999999
139231681269100.652173913-37419.652173913
140193119153021.9640097.04
141189020226094.169811321-37074.1698113208
142341958226094.169811321115863.830188679
143219133226094.169811321-6961.16981132075
14417326098433.538461538574826.4615384615
145274787226094.16981132148692.8301886792
146130908269100.652173913-138192.652173913
147204009226094.169811321-22085.1698113208
148262412269100.652173913-6688.65217391303
149113312.5294117647-13311.5294117647
1501468813312.52941176471375.47058823529
1519813312.5294117647-13214.5294117647
15245513312.5294117647-12857.5294117647
153013312.5294117647-13312.5294117647
154013312.5294117647-13312.5294117647
155195765153021.9642743.04
156330975215332.8115642.2
157013312.5294117647-13312.5294117647
15820313312.5294117647-13109.5294117647
159719913312.5294117647-6113.52941176471
1604666013312.529411764733347.4705882353
1611754713312.52941176474234.47058823529
162107465153021.96-45556.96
16396913312.5294117647-12343.5294117647
164179994226094.169811321-46100.1698113208



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')
}