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 computationThu, 22 Dec 2011 15:26:57 -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/22/t1324585650f4age60e5txuv95.htm/, Retrieved Fri, 03 May 2024 12:39:21 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=159948, Retrieved Fri, 03 May 2024 12:39:21 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact139
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [tree] [2011-12-09 10:01:58] [22f8bc702946f784836540059d0d9516]
- R     [Recursive Partitioning (Regression Trees)] [WS 10 Rec. Partit...] [2011-12-12 14:12:13] [74be16979710d4c4e7c6647856088456]
-    D      [Recursive Partitioning (Regression Trees)] [Recursif] [2011-12-22 20:26:57] [7357ea4f05edbe0d796a101c4acf63d9] [Current]
Feedback Forum

Post a new message
Dataseries X:
279055	96	159	140824	165	165
209884	75	149	110459	135	132
233939	70	178	105079	121	121
222117	134	164	112098	148	145
179751	72	100	43929	73	71
70849	8	129	76173	49	47
568125	169	156	187326	185	177
33186	1	67	22807	5	5
227332	88	148	144408	125	124
258874	98	132	66485	93	92
351915	106	169	79089	154	149
260484	122	230	81625	98	93
203988	57	122	68788	70	70
368577	139	191	103297	148	148
269455	87	162	69446	100	100
394578	176	237	114948	150	142
335567	114	156	167949	197	194
423110	121	157	125081	114	113
182016	103	123	125818	169	162
267365	135	203	136588	200	186
279428	123	187	112431	148	147
506616	97	152	103037	140	137
206722	74	89	82317	74	71
200004	103	227	118906	128	123
257139	158	165	83515	140	134
270815	116	162	104581	116	115
296850	102	174	103129	147	138
307100	132	154	83243	132	125
184160	62	129	37110	70	66
393860	150	174	113344	144	137
320558	141	195	139165	155	152
252512	50	186	86652	165	159
373013	141	197	112302	161	159
115602	48	157	69652	31	31
430118	141	168	119442	199	185
273950	83	159	69867	78	78
428077	112	161	101629	121	117
251349	79	153	70168	112	109
115658	33	55	31081	41	41
388812	149	166	103925	158	149
343783	126	151	92622	123	123
202289	82	148	79011	104	103
214344	84	129	93487	94	87
182398	68	181	64520	73	71
157164	50	93	93473	52	51
459440	101	150	114360	71	70
78800	20	82	33032	21	21
217932	101	229	96125	155	155
368086	150	193	151911	174	172
210554	116	176	89256	136	133
244640	99	179	95676	128	125
24188	8	12	5950	7	7
399093	88	181	149695	165	158
65029	21	67	32551	21	21
101097	30	52	31701	35	35
300488	97	148	100087	137	133
369627	163	230	169707	174	169
367127	132	148	150491	257	256
374158	161	160	120192	207	190
270099	89	155	95893	103	100
391871	160	198	151715	171	171
315924	139	104	176225	279	267
291391	104	169	59900	83	80
286417	100	163	104767	130	126
276201	66	151	114799	131	132
267432	163	116	72128	126	121
215924	93	153	143592	158	156
252767	85	195	89626	138	133
260919	150	149	131072	200	199
182961	143	106	126817	104	98
256967	107	179	81351	111	109
73566	22	88	22618	26	25
272362	85	185	88977	115	113
220707	91	133	92059	127	126
228835	131	164	81897	140	137
371391	140	169	108146	121	121
398210	156	153	126372	183	178
220401	81	166	249771	68	63
229333	137	164	71154	112	109
217623	102	146	71571	103	101
199011	72	141	55918	63	61
483074	161	183	160141	166	157
145943	30	99	38692	38	38
295224	120	134	102812	163	159
80953	49	28	56622	59	58
180759	71	101	15986	27	27
179344	76	139	123534	108	108
415550	85	159	108535	88	83
369093	146	222	93879	92	88
180679	165	171	144551	170	164
299505	89	154	56750	98	96
292260	168	154	127654	205	192
199481	48	129	65594	96	94
282361	149	140	59938	107	107
329281	75	156	146975	150	144
234577	107	156	165904	138	136
297995	116	138	169265	177	171
305984	165	153	183500	213	210
416463	155	251	165986	208	193
412530	165	126	184923	307	297
297080	121	198	140358	125	125
318283	156	168	149959	208	204
214250	85	138	57224	73	70
43287	13	71	43750	49	49
223456	113	90	48029	82	82
258249	112	167	104978	206	205
299566	133	172	100046	112	111
321797	169	162	101047	139	135
174736	30	129	197426	60	59
169545	121	179	160902	70	70
354041	82	163	147172	112	108
303273	148	164	109432	142	141
23668	12	0	1168	11	11
196743	146	155	83248	130	130
61857	23	32	25162	31	28
207339	84	189	45724	132	101
431443	163	140	110529	219	216
21054	4	0	855	4	4
252805	81	111	101382	102	97
31961	18	25	14116	39	39
354622	118	159	89506	125	119
251240	76	183	135356	121	118
187003	55	184	116066	42	41
180842	62	119	144244	111	107
38214	16	27	8773	16	16
278173	98	163	102153	70	69
358276	137	198	117440	162	160
211775	50	205	104128	173	158
445926	152	191	134238	171	161
348017	163	187	134047	172	165
441946	142	210	279488	254	246
208962	77	166	79756	90	89
105332	42	145	66089	50	49
316128	94	187	102070	113	107
466139	128	186	146760	187	182
160799	63	164	154771	16	16
412099	127	172	165933	175	173
173802	59	147	64593	90	90
292443	118	167	92280	140	140
283913	110	158	67150	145	142
234262	44	144	128692	141	126
386740	95	169	124089	125	123
246963	128	145	125386	241	239
173260	41	79	37238	16	15
346748	146	194	140015	175	170
176654	147	212	150047	132	123
264767	121	148	154451	154	151
314070	185	171	156349	198	194
1	0	0	0	0	0
14688	4	0	6023	5	5
98	0	0	0	0	0
455	0	0	0	0	0
0	0	0	0	0	0
0	0	0	0	0	0
284420	85	141	84601	125	122
410509	157	204	68946	174	173
0	0	0	0	0	0
203	0	0	0	0	0
7199	7	0	1644	6	6
46660	12	15	6179	13	13
17547	0	4	3926	3	3
121550	37	172	52789	35	35
969	0	0	0	0	0
242258	62	125	100350	80	72




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159948&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 time4 seconds
R Server'AstonUniversity' @ aston.wessa.net







Goodness of Fit
Correlation0.8631
R-squared0.745
RMSE62681.3977

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8631[/C][/ROW]
[ROW][C]R-squared[/C][C]0.745[/C][/ROW]
[ROW][C]RMSE[/C][C]62681.3977[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159948&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159948&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.8631
R-squared0.745
RMSE62681.3977







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1279055335663.53030303-56608.5303030303
2209884254956.6-45072.6
3233939254956.6-21017.6
4222117335663.53030303-113546.53030303
5179751185994.583333333-6243.58333333334
67084954340.916508.1
7568125335663.53030303232461.46969697
83318654340.9-21154.9
9227332335663.53030303-108331.53030303
10258874273962.454545455-15088.4545454545
11351915273962.45454545577952.5454545455
12260484273962.454545455-13478.4545454545
13203988185994.58333333317993.4166666667
14368577335663.5303030332913.4696969697
15269455273962.454545455-4507.45454545453
16394578335663.5303030358914.4696969697
17335567335663.53030303-96.5303030302748
18423110335663.5303030387446.4696969697
19182016335663.53030303-153647.53030303
20267365335663.53030303-68298.5303030303
21279428335663.53030303-56235.5303030303
22506616335663.53030303170952.46969697
23206722223351.5-16629.5
24200004335663.53030303-135659.53030303
25257139273962.454545455-16823.4545454545
26270815335663.53030303-64848.5303030303
27296850335663.53030303-38813.5303030303
28307100273962.45454545533137.5454545455
29184160185994.583333333-1834.58333333334
30393860335663.5303030358196.4696969697
31320558335663.53030303-15105.5303030303
32252512254956.6-2444.60000000001
33373013335663.5303030337349.4696969697
34115602142534-26932
35430118335663.5303030394454.4696969697
36273950223351.550598.5
37428077335663.5303030392413.4696969697
38251349254956.6-3607.60000000001
39115658142534-26876
40388812335663.5303030353148.4696969697
41343783273962.45454545569820.5454545455
42202289223351.5-21062.5
43214344223351.5-9007.5
44182398185994.583333333-3596.58333333334
45157164185994.583333333-28830.5833333333
46459440335663.53030303123776.46969697
477880054340.924459.1
48217932273962.454545455-56030.4545454545
49368086335663.5303030332422.4696969697
50210554273962.454545455-63408.4545454545
51244640273962.454545455-29322.4545454545
52241887862.1428571428616325.8571428571
53399093335663.5303030363429.4696969697
546502954340.910688.1
55101097142534-41437
56300488273962.45454545526525.5454545455
57369627335663.5303030333963.4696969697
58367127335663.5303030331463.4696969697
59374158335663.5303030338494.4696969697
60270099273962.454545455-3863.45454545453
61391871335663.5303030356207.4696969697
62315924335663.53030303-19739.5303030303
63291391273962.45454545517428.5454545455
64286417335663.53030303-49246.5303030303
65276201254956.621244.4
66267432273962.454545455-6530.45454545453
67215924335663.53030303-119739.53030303
68252767273962.454545455-21195.4545454545
69260919335663.53030303-74744.5303030303
70182961335663.53030303-152702.53030303
71256967273962.454545455-16995.4545454545
727356654340.919225.1
73272362273962.454545455-1600.45454545453
74220707273962.454545455-53255.4545454545
75228835273962.454545455-45127.4545454545
76371391335663.5303030335727.4696969697
77398210335663.5303030362546.4696969697
78220401223351.5-2950.5
79229333273962.454545455-44629.4545454545
80217623273962.454545455-56339.4545454545
81199011185994.58333333313016.4166666667
82483074335663.53030303147410.46969697
831459431425343409
84295224335663.53030303-40439.5303030303
8580953142534-61581
86180759185994.583333333-5235.58333333334
87179344254956.6-75612.6
88415550335663.5303030379886.4696969697
89369093273962.45454545595130.5454545455
90180679335663.53030303-154984.53030303
91299505273962.45454545525542.5454545455
92292260335663.53030303-43403.5303030303
9319948114253456947
94282361273962.4545454558398.54545454547
95329281254956.674324.4
96234577335663.53030303-101086.53030303
97297995335663.53030303-37668.5303030303
98305984335663.53030303-29679.5303030303
99416463335663.5303030380799.4696969697
100412530335663.5303030376866.4696969697
101297080335663.53030303-38583.5303030303
102318283335663.53030303-17380.5303030303
103214250273962.454545455-59712.4545454545
1044328754340.9-11053.9
105223456273962.454545455-50506.4545454545
106258249335663.53030303-77414.5303030303
107299566273962.45454545525603.5454545455
108321797335663.53030303-13866.5303030303
10917473614253432202
110169545335663.53030303-166118.53030303
111354041254956.699084.4
112303273335663.53030303-32390.5303030303
113236687862.1428571428615805.8571428571
114196743273962.454545455-77219.4545454545
1156185754340.97516.1
116207339223351.5-16012.5
117431443335663.5303030395779.4696969697
118210547862.1428571428613191.8571428571
119252805223351.529453.5
1203196154340.9-22379.9
121354622273962.45454545580659.5454545455
122251240254956.6-3716.60000000001
123187003185994.5833333331008.41666666666
124180842185994.583333333-5152.58333333334
1253821454340.9-16126.9
126278173335663.53030303-57490.5303030303
127358276335663.5303030322612.4696969697
128211775254956.6-43181.6
129445926335663.53030303110262.46969697
130348017335663.5303030312353.4696969697
131441946335663.53030303106282.46969697
132208962223351.5-14389.5
133105332142534-37202
134316128335663.53030303-19535.5303030303
135466139335663.53030303130475.46969697
136160799185994.583333333-25195.5833333333
137412099335663.5303030376435.4696969697
138173802185994.583333333-12192.5833333333
139292443273962.45454545518480.5454545455
140283913273962.4545454559950.54545454547
14123426214253491728
142386740335663.5303030351076.4696969697
143246963335663.53030303-88700.5303030303
14417326014253430726
145346748335663.5303030311084.4696969697
146176654335663.53030303-159009.53030303
147264767335663.53030303-70896.5303030303
148314070335663.53030303-21593.5303030303
14917862.14285714286-7861.14285714286
150146887862.142857142866825.85714285714
151987862.14285714286-7764.14285714286
1524557862.14285714286-7407.14285714286
15307862.14285714286-7862.14285714286
15407862.14285714286-7862.14285714286
155284420273962.45454545510457.5454545455
156410509273962.454545455136546.545454545
15707862.14285714286-7862.14285714286
1582037862.14285714286-7659.14285714286
15971997862.14285714286-663.142857142857
1604666054340.9-7680.9
161175477862.142857142869684.85714285714
162121550142534-20984
1639697862.14285714286-6893.14285714286
164242258185994.58333333356263.4166666667

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 279055 & 335663.53030303 & -56608.5303030303 \tabularnewline
2 & 209884 & 254956.6 & -45072.6 \tabularnewline
3 & 233939 & 254956.6 & -21017.6 \tabularnewline
4 & 222117 & 335663.53030303 & -113546.53030303 \tabularnewline
5 & 179751 & 185994.583333333 & -6243.58333333334 \tabularnewline
6 & 70849 & 54340.9 & 16508.1 \tabularnewline
7 & 568125 & 335663.53030303 & 232461.46969697 \tabularnewline
8 & 33186 & 54340.9 & -21154.9 \tabularnewline
9 & 227332 & 335663.53030303 & -108331.53030303 \tabularnewline
10 & 258874 & 273962.454545455 & -15088.4545454545 \tabularnewline
11 & 351915 & 273962.454545455 & 77952.5454545455 \tabularnewline
12 & 260484 & 273962.454545455 & -13478.4545454545 \tabularnewline
13 & 203988 & 185994.583333333 & 17993.4166666667 \tabularnewline
14 & 368577 & 335663.53030303 & 32913.4696969697 \tabularnewline
15 & 269455 & 273962.454545455 & -4507.45454545453 \tabularnewline
16 & 394578 & 335663.53030303 & 58914.4696969697 \tabularnewline
17 & 335567 & 335663.53030303 & -96.5303030302748 \tabularnewline
18 & 423110 & 335663.53030303 & 87446.4696969697 \tabularnewline
19 & 182016 & 335663.53030303 & -153647.53030303 \tabularnewline
20 & 267365 & 335663.53030303 & -68298.5303030303 \tabularnewline
21 & 279428 & 335663.53030303 & -56235.5303030303 \tabularnewline
22 & 506616 & 335663.53030303 & 170952.46969697 \tabularnewline
23 & 206722 & 223351.5 & -16629.5 \tabularnewline
24 & 200004 & 335663.53030303 & -135659.53030303 \tabularnewline
25 & 257139 & 273962.454545455 & -16823.4545454545 \tabularnewline
26 & 270815 & 335663.53030303 & -64848.5303030303 \tabularnewline
27 & 296850 & 335663.53030303 & -38813.5303030303 \tabularnewline
28 & 307100 & 273962.454545455 & 33137.5454545455 \tabularnewline
29 & 184160 & 185994.583333333 & -1834.58333333334 \tabularnewline
30 & 393860 & 335663.53030303 & 58196.4696969697 \tabularnewline
31 & 320558 & 335663.53030303 & -15105.5303030303 \tabularnewline
32 & 252512 & 254956.6 & -2444.60000000001 \tabularnewline
33 & 373013 & 335663.53030303 & 37349.4696969697 \tabularnewline
34 & 115602 & 142534 & -26932 \tabularnewline
35 & 430118 & 335663.53030303 & 94454.4696969697 \tabularnewline
36 & 273950 & 223351.5 & 50598.5 \tabularnewline
37 & 428077 & 335663.53030303 & 92413.4696969697 \tabularnewline
38 & 251349 & 254956.6 & -3607.60000000001 \tabularnewline
39 & 115658 & 142534 & -26876 \tabularnewline
40 & 388812 & 335663.53030303 & 53148.4696969697 \tabularnewline
41 & 343783 & 273962.454545455 & 69820.5454545455 \tabularnewline
42 & 202289 & 223351.5 & -21062.5 \tabularnewline
43 & 214344 & 223351.5 & -9007.5 \tabularnewline
44 & 182398 & 185994.583333333 & -3596.58333333334 \tabularnewline
45 & 157164 & 185994.583333333 & -28830.5833333333 \tabularnewline
46 & 459440 & 335663.53030303 & 123776.46969697 \tabularnewline
47 & 78800 & 54340.9 & 24459.1 \tabularnewline
48 & 217932 & 273962.454545455 & -56030.4545454545 \tabularnewline
49 & 368086 & 335663.53030303 & 32422.4696969697 \tabularnewline
50 & 210554 & 273962.454545455 & -63408.4545454545 \tabularnewline
51 & 244640 & 273962.454545455 & -29322.4545454545 \tabularnewline
52 & 24188 & 7862.14285714286 & 16325.8571428571 \tabularnewline
53 & 399093 & 335663.53030303 & 63429.4696969697 \tabularnewline
54 & 65029 & 54340.9 & 10688.1 \tabularnewline
55 & 101097 & 142534 & -41437 \tabularnewline
56 & 300488 & 273962.454545455 & 26525.5454545455 \tabularnewline
57 & 369627 & 335663.53030303 & 33963.4696969697 \tabularnewline
58 & 367127 & 335663.53030303 & 31463.4696969697 \tabularnewline
59 & 374158 & 335663.53030303 & 38494.4696969697 \tabularnewline
60 & 270099 & 273962.454545455 & -3863.45454545453 \tabularnewline
61 & 391871 & 335663.53030303 & 56207.4696969697 \tabularnewline
62 & 315924 & 335663.53030303 & -19739.5303030303 \tabularnewline
63 & 291391 & 273962.454545455 & 17428.5454545455 \tabularnewline
64 & 286417 & 335663.53030303 & -49246.5303030303 \tabularnewline
65 & 276201 & 254956.6 & 21244.4 \tabularnewline
66 & 267432 & 273962.454545455 & -6530.45454545453 \tabularnewline
67 & 215924 & 335663.53030303 & -119739.53030303 \tabularnewline
68 & 252767 & 273962.454545455 & -21195.4545454545 \tabularnewline
69 & 260919 & 335663.53030303 & -74744.5303030303 \tabularnewline
70 & 182961 & 335663.53030303 & -152702.53030303 \tabularnewline
71 & 256967 & 273962.454545455 & -16995.4545454545 \tabularnewline
72 & 73566 & 54340.9 & 19225.1 \tabularnewline
73 & 272362 & 273962.454545455 & -1600.45454545453 \tabularnewline
74 & 220707 & 273962.454545455 & -53255.4545454545 \tabularnewline
75 & 228835 & 273962.454545455 & -45127.4545454545 \tabularnewline
76 & 371391 & 335663.53030303 & 35727.4696969697 \tabularnewline
77 & 398210 & 335663.53030303 & 62546.4696969697 \tabularnewline
78 & 220401 & 223351.5 & -2950.5 \tabularnewline
79 & 229333 & 273962.454545455 & -44629.4545454545 \tabularnewline
80 & 217623 & 273962.454545455 & -56339.4545454545 \tabularnewline
81 & 199011 & 185994.583333333 & 13016.4166666667 \tabularnewline
82 & 483074 & 335663.53030303 & 147410.46969697 \tabularnewline
83 & 145943 & 142534 & 3409 \tabularnewline
84 & 295224 & 335663.53030303 & -40439.5303030303 \tabularnewline
85 & 80953 & 142534 & -61581 \tabularnewline
86 & 180759 & 185994.583333333 & -5235.58333333334 \tabularnewline
87 & 179344 & 254956.6 & -75612.6 \tabularnewline
88 & 415550 & 335663.53030303 & 79886.4696969697 \tabularnewline
89 & 369093 & 273962.454545455 & 95130.5454545455 \tabularnewline
90 & 180679 & 335663.53030303 & -154984.53030303 \tabularnewline
91 & 299505 & 273962.454545455 & 25542.5454545455 \tabularnewline
92 & 292260 & 335663.53030303 & -43403.5303030303 \tabularnewline
93 & 199481 & 142534 & 56947 \tabularnewline
94 & 282361 & 273962.454545455 & 8398.54545454547 \tabularnewline
95 & 329281 & 254956.6 & 74324.4 \tabularnewline
96 & 234577 & 335663.53030303 & -101086.53030303 \tabularnewline
97 & 297995 & 335663.53030303 & -37668.5303030303 \tabularnewline
98 & 305984 & 335663.53030303 & -29679.5303030303 \tabularnewline
99 & 416463 & 335663.53030303 & 80799.4696969697 \tabularnewline
100 & 412530 & 335663.53030303 & 76866.4696969697 \tabularnewline
101 & 297080 & 335663.53030303 & -38583.5303030303 \tabularnewline
102 & 318283 & 335663.53030303 & -17380.5303030303 \tabularnewline
103 & 214250 & 273962.454545455 & -59712.4545454545 \tabularnewline
104 & 43287 & 54340.9 & -11053.9 \tabularnewline
105 & 223456 & 273962.454545455 & -50506.4545454545 \tabularnewline
106 & 258249 & 335663.53030303 & -77414.5303030303 \tabularnewline
107 & 299566 & 273962.454545455 & 25603.5454545455 \tabularnewline
108 & 321797 & 335663.53030303 & -13866.5303030303 \tabularnewline
109 & 174736 & 142534 & 32202 \tabularnewline
110 & 169545 & 335663.53030303 & -166118.53030303 \tabularnewline
111 & 354041 & 254956.6 & 99084.4 \tabularnewline
112 & 303273 & 335663.53030303 & -32390.5303030303 \tabularnewline
113 & 23668 & 7862.14285714286 & 15805.8571428571 \tabularnewline
114 & 196743 & 273962.454545455 & -77219.4545454545 \tabularnewline
115 & 61857 & 54340.9 & 7516.1 \tabularnewline
116 & 207339 & 223351.5 & -16012.5 \tabularnewline
117 & 431443 & 335663.53030303 & 95779.4696969697 \tabularnewline
118 & 21054 & 7862.14285714286 & 13191.8571428571 \tabularnewline
119 & 252805 & 223351.5 & 29453.5 \tabularnewline
120 & 31961 & 54340.9 & -22379.9 \tabularnewline
121 & 354622 & 273962.454545455 & 80659.5454545455 \tabularnewline
122 & 251240 & 254956.6 & -3716.60000000001 \tabularnewline
123 & 187003 & 185994.583333333 & 1008.41666666666 \tabularnewline
124 & 180842 & 185994.583333333 & -5152.58333333334 \tabularnewline
125 & 38214 & 54340.9 & -16126.9 \tabularnewline
126 & 278173 & 335663.53030303 & -57490.5303030303 \tabularnewline
127 & 358276 & 335663.53030303 & 22612.4696969697 \tabularnewline
128 & 211775 & 254956.6 & -43181.6 \tabularnewline
129 & 445926 & 335663.53030303 & 110262.46969697 \tabularnewline
130 & 348017 & 335663.53030303 & 12353.4696969697 \tabularnewline
131 & 441946 & 335663.53030303 & 106282.46969697 \tabularnewline
132 & 208962 & 223351.5 & -14389.5 \tabularnewline
133 & 105332 & 142534 & -37202 \tabularnewline
134 & 316128 & 335663.53030303 & -19535.5303030303 \tabularnewline
135 & 466139 & 335663.53030303 & 130475.46969697 \tabularnewline
136 & 160799 & 185994.583333333 & -25195.5833333333 \tabularnewline
137 & 412099 & 335663.53030303 & 76435.4696969697 \tabularnewline
138 & 173802 & 185994.583333333 & -12192.5833333333 \tabularnewline
139 & 292443 & 273962.454545455 & 18480.5454545455 \tabularnewline
140 & 283913 & 273962.454545455 & 9950.54545454547 \tabularnewline
141 & 234262 & 142534 & 91728 \tabularnewline
142 & 386740 & 335663.53030303 & 51076.4696969697 \tabularnewline
143 & 246963 & 335663.53030303 & -88700.5303030303 \tabularnewline
144 & 173260 & 142534 & 30726 \tabularnewline
145 & 346748 & 335663.53030303 & 11084.4696969697 \tabularnewline
146 & 176654 & 335663.53030303 & -159009.53030303 \tabularnewline
147 & 264767 & 335663.53030303 & -70896.5303030303 \tabularnewline
148 & 314070 & 335663.53030303 & -21593.5303030303 \tabularnewline
149 & 1 & 7862.14285714286 & -7861.14285714286 \tabularnewline
150 & 14688 & 7862.14285714286 & 6825.85714285714 \tabularnewline
151 & 98 & 7862.14285714286 & -7764.14285714286 \tabularnewline
152 & 455 & 7862.14285714286 & -7407.14285714286 \tabularnewline
153 & 0 & 7862.14285714286 & -7862.14285714286 \tabularnewline
154 & 0 & 7862.14285714286 & -7862.14285714286 \tabularnewline
155 & 284420 & 273962.454545455 & 10457.5454545455 \tabularnewline
156 & 410509 & 273962.454545455 & 136546.545454545 \tabularnewline
157 & 0 & 7862.14285714286 & -7862.14285714286 \tabularnewline
158 & 203 & 7862.14285714286 & -7659.14285714286 \tabularnewline
159 & 7199 & 7862.14285714286 & -663.142857142857 \tabularnewline
160 & 46660 & 54340.9 & -7680.9 \tabularnewline
161 & 17547 & 7862.14285714286 & 9684.85714285714 \tabularnewline
162 & 121550 & 142534 & -20984 \tabularnewline
163 & 969 & 7862.14285714286 & -6893.14285714286 \tabularnewline
164 & 242258 & 185994.583333333 & 56263.4166666667 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=159948&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]279055[/C][C]335663.53030303[/C][C]-56608.5303030303[/C][/ROW]
[ROW][C]2[/C][C]209884[/C][C]254956.6[/C][C]-45072.6[/C][/ROW]
[ROW][C]3[/C][C]233939[/C][C]254956.6[/C][C]-21017.6[/C][/ROW]
[ROW][C]4[/C][C]222117[/C][C]335663.53030303[/C][C]-113546.53030303[/C][/ROW]
[ROW][C]5[/C][C]179751[/C][C]185994.583333333[/C][C]-6243.58333333334[/C][/ROW]
[ROW][C]6[/C][C]70849[/C][C]54340.9[/C][C]16508.1[/C][/ROW]
[ROW][C]7[/C][C]568125[/C][C]335663.53030303[/C][C]232461.46969697[/C][/ROW]
[ROW][C]8[/C][C]33186[/C][C]54340.9[/C][C]-21154.9[/C][/ROW]
[ROW][C]9[/C][C]227332[/C][C]335663.53030303[/C][C]-108331.53030303[/C][/ROW]
[ROW][C]10[/C][C]258874[/C][C]273962.454545455[/C][C]-15088.4545454545[/C][/ROW]
[ROW][C]11[/C][C]351915[/C][C]273962.454545455[/C][C]77952.5454545455[/C][/ROW]
[ROW][C]12[/C][C]260484[/C][C]273962.454545455[/C][C]-13478.4545454545[/C][/ROW]
[ROW][C]13[/C][C]203988[/C][C]185994.583333333[/C][C]17993.4166666667[/C][/ROW]
[ROW][C]14[/C][C]368577[/C][C]335663.53030303[/C][C]32913.4696969697[/C][/ROW]
[ROW][C]15[/C][C]269455[/C][C]273962.454545455[/C][C]-4507.45454545453[/C][/ROW]
[ROW][C]16[/C][C]394578[/C][C]335663.53030303[/C][C]58914.4696969697[/C][/ROW]
[ROW][C]17[/C][C]335567[/C][C]335663.53030303[/C][C]-96.5303030302748[/C][/ROW]
[ROW][C]18[/C][C]423110[/C][C]335663.53030303[/C][C]87446.4696969697[/C][/ROW]
[ROW][C]19[/C][C]182016[/C][C]335663.53030303[/C][C]-153647.53030303[/C][/ROW]
[ROW][C]20[/C][C]267365[/C][C]335663.53030303[/C][C]-68298.5303030303[/C][/ROW]
[ROW][C]21[/C][C]279428[/C][C]335663.53030303[/C][C]-56235.5303030303[/C][/ROW]
[ROW][C]22[/C][C]506616[/C][C]335663.53030303[/C][C]170952.46969697[/C][/ROW]
[ROW][C]23[/C][C]206722[/C][C]223351.5[/C][C]-16629.5[/C][/ROW]
[ROW][C]24[/C][C]200004[/C][C]335663.53030303[/C][C]-135659.53030303[/C][/ROW]
[ROW][C]25[/C][C]257139[/C][C]273962.454545455[/C][C]-16823.4545454545[/C][/ROW]
[ROW][C]26[/C][C]270815[/C][C]335663.53030303[/C][C]-64848.5303030303[/C][/ROW]
[ROW][C]27[/C][C]296850[/C][C]335663.53030303[/C][C]-38813.5303030303[/C][/ROW]
[ROW][C]28[/C][C]307100[/C][C]273962.454545455[/C][C]33137.5454545455[/C][/ROW]
[ROW][C]29[/C][C]184160[/C][C]185994.583333333[/C][C]-1834.58333333334[/C][/ROW]
[ROW][C]30[/C][C]393860[/C][C]335663.53030303[/C][C]58196.4696969697[/C][/ROW]
[ROW][C]31[/C][C]320558[/C][C]335663.53030303[/C][C]-15105.5303030303[/C][/ROW]
[ROW][C]32[/C][C]252512[/C][C]254956.6[/C][C]-2444.60000000001[/C][/ROW]
[ROW][C]33[/C][C]373013[/C][C]335663.53030303[/C][C]37349.4696969697[/C][/ROW]
[ROW][C]34[/C][C]115602[/C][C]142534[/C][C]-26932[/C][/ROW]
[ROW][C]35[/C][C]430118[/C][C]335663.53030303[/C][C]94454.4696969697[/C][/ROW]
[ROW][C]36[/C][C]273950[/C][C]223351.5[/C][C]50598.5[/C][/ROW]
[ROW][C]37[/C][C]428077[/C][C]335663.53030303[/C][C]92413.4696969697[/C][/ROW]
[ROW][C]38[/C][C]251349[/C][C]254956.6[/C][C]-3607.60000000001[/C][/ROW]
[ROW][C]39[/C][C]115658[/C][C]142534[/C][C]-26876[/C][/ROW]
[ROW][C]40[/C][C]388812[/C][C]335663.53030303[/C][C]53148.4696969697[/C][/ROW]
[ROW][C]41[/C][C]343783[/C][C]273962.454545455[/C][C]69820.5454545455[/C][/ROW]
[ROW][C]42[/C][C]202289[/C][C]223351.5[/C][C]-21062.5[/C][/ROW]
[ROW][C]43[/C][C]214344[/C][C]223351.5[/C][C]-9007.5[/C][/ROW]
[ROW][C]44[/C][C]182398[/C][C]185994.583333333[/C][C]-3596.58333333334[/C][/ROW]
[ROW][C]45[/C][C]157164[/C][C]185994.583333333[/C][C]-28830.5833333333[/C][/ROW]
[ROW][C]46[/C][C]459440[/C][C]335663.53030303[/C][C]123776.46969697[/C][/ROW]
[ROW][C]47[/C][C]78800[/C][C]54340.9[/C][C]24459.1[/C][/ROW]
[ROW][C]48[/C][C]217932[/C][C]273962.454545455[/C][C]-56030.4545454545[/C][/ROW]
[ROW][C]49[/C][C]368086[/C][C]335663.53030303[/C][C]32422.4696969697[/C][/ROW]
[ROW][C]50[/C][C]210554[/C][C]273962.454545455[/C][C]-63408.4545454545[/C][/ROW]
[ROW][C]51[/C][C]244640[/C][C]273962.454545455[/C][C]-29322.4545454545[/C][/ROW]
[ROW][C]52[/C][C]24188[/C][C]7862.14285714286[/C][C]16325.8571428571[/C][/ROW]
[ROW][C]53[/C][C]399093[/C][C]335663.53030303[/C][C]63429.4696969697[/C][/ROW]
[ROW][C]54[/C][C]65029[/C][C]54340.9[/C][C]10688.1[/C][/ROW]
[ROW][C]55[/C][C]101097[/C][C]142534[/C][C]-41437[/C][/ROW]
[ROW][C]56[/C][C]300488[/C][C]273962.454545455[/C][C]26525.5454545455[/C][/ROW]
[ROW][C]57[/C][C]369627[/C][C]335663.53030303[/C][C]33963.4696969697[/C][/ROW]
[ROW][C]58[/C][C]367127[/C][C]335663.53030303[/C][C]31463.4696969697[/C][/ROW]
[ROW][C]59[/C][C]374158[/C][C]335663.53030303[/C][C]38494.4696969697[/C][/ROW]
[ROW][C]60[/C][C]270099[/C][C]273962.454545455[/C][C]-3863.45454545453[/C][/ROW]
[ROW][C]61[/C][C]391871[/C][C]335663.53030303[/C][C]56207.4696969697[/C][/ROW]
[ROW][C]62[/C][C]315924[/C][C]335663.53030303[/C][C]-19739.5303030303[/C][/ROW]
[ROW][C]63[/C][C]291391[/C][C]273962.454545455[/C][C]17428.5454545455[/C][/ROW]
[ROW][C]64[/C][C]286417[/C][C]335663.53030303[/C][C]-49246.5303030303[/C][/ROW]
[ROW][C]65[/C][C]276201[/C][C]254956.6[/C][C]21244.4[/C][/ROW]
[ROW][C]66[/C][C]267432[/C][C]273962.454545455[/C][C]-6530.45454545453[/C][/ROW]
[ROW][C]67[/C][C]215924[/C][C]335663.53030303[/C][C]-119739.53030303[/C][/ROW]
[ROW][C]68[/C][C]252767[/C][C]273962.454545455[/C][C]-21195.4545454545[/C][/ROW]
[ROW][C]69[/C][C]260919[/C][C]335663.53030303[/C][C]-74744.5303030303[/C][/ROW]
[ROW][C]70[/C][C]182961[/C][C]335663.53030303[/C][C]-152702.53030303[/C][/ROW]
[ROW][C]71[/C][C]256967[/C][C]273962.454545455[/C][C]-16995.4545454545[/C][/ROW]
[ROW][C]72[/C][C]73566[/C][C]54340.9[/C][C]19225.1[/C][/ROW]
[ROW][C]73[/C][C]272362[/C][C]273962.454545455[/C][C]-1600.45454545453[/C][/ROW]
[ROW][C]74[/C][C]220707[/C][C]273962.454545455[/C][C]-53255.4545454545[/C][/ROW]
[ROW][C]75[/C][C]228835[/C][C]273962.454545455[/C][C]-45127.4545454545[/C][/ROW]
[ROW][C]76[/C][C]371391[/C][C]335663.53030303[/C][C]35727.4696969697[/C][/ROW]
[ROW][C]77[/C][C]398210[/C][C]335663.53030303[/C][C]62546.4696969697[/C][/ROW]
[ROW][C]78[/C][C]220401[/C][C]223351.5[/C][C]-2950.5[/C][/ROW]
[ROW][C]79[/C][C]229333[/C][C]273962.454545455[/C][C]-44629.4545454545[/C][/ROW]
[ROW][C]80[/C][C]217623[/C][C]273962.454545455[/C][C]-56339.4545454545[/C][/ROW]
[ROW][C]81[/C][C]199011[/C][C]185994.583333333[/C][C]13016.4166666667[/C][/ROW]
[ROW][C]82[/C][C]483074[/C][C]335663.53030303[/C][C]147410.46969697[/C][/ROW]
[ROW][C]83[/C][C]145943[/C][C]142534[/C][C]3409[/C][/ROW]
[ROW][C]84[/C][C]295224[/C][C]335663.53030303[/C][C]-40439.5303030303[/C][/ROW]
[ROW][C]85[/C][C]80953[/C][C]142534[/C][C]-61581[/C][/ROW]
[ROW][C]86[/C][C]180759[/C][C]185994.583333333[/C][C]-5235.58333333334[/C][/ROW]
[ROW][C]87[/C][C]179344[/C][C]254956.6[/C][C]-75612.6[/C][/ROW]
[ROW][C]88[/C][C]415550[/C][C]335663.53030303[/C][C]79886.4696969697[/C][/ROW]
[ROW][C]89[/C][C]369093[/C][C]273962.454545455[/C][C]95130.5454545455[/C][/ROW]
[ROW][C]90[/C][C]180679[/C][C]335663.53030303[/C][C]-154984.53030303[/C][/ROW]
[ROW][C]91[/C][C]299505[/C][C]273962.454545455[/C][C]25542.5454545455[/C][/ROW]
[ROW][C]92[/C][C]292260[/C][C]335663.53030303[/C][C]-43403.5303030303[/C][/ROW]
[ROW][C]93[/C][C]199481[/C][C]142534[/C][C]56947[/C][/ROW]
[ROW][C]94[/C][C]282361[/C][C]273962.454545455[/C][C]8398.54545454547[/C][/ROW]
[ROW][C]95[/C][C]329281[/C][C]254956.6[/C][C]74324.4[/C][/ROW]
[ROW][C]96[/C][C]234577[/C][C]335663.53030303[/C][C]-101086.53030303[/C][/ROW]
[ROW][C]97[/C][C]297995[/C][C]335663.53030303[/C][C]-37668.5303030303[/C][/ROW]
[ROW][C]98[/C][C]305984[/C][C]335663.53030303[/C][C]-29679.5303030303[/C][/ROW]
[ROW][C]99[/C][C]416463[/C][C]335663.53030303[/C][C]80799.4696969697[/C][/ROW]
[ROW][C]100[/C][C]412530[/C][C]335663.53030303[/C][C]76866.4696969697[/C][/ROW]
[ROW][C]101[/C][C]297080[/C][C]335663.53030303[/C][C]-38583.5303030303[/C][/ROW]
[ROW][C]102[/C][C]318283[/C][C]335663.53030303[/C][C]-17380.5303030303[/C][/ROW]
[ROW][C]103[/C][C]214250[/C][C]273962.454545455[/C][C]-59712.4545454545[/C][/ROW]
[ROW][C]104[/C][C]43287[/C][C]54340.9[/C][C]-11053.9[/C][/ROW]
[ROW][C]105[/C][C]223456[/C][C]273962.454545455[/C][C]-50506.4545454545[/C][/ROW]
[ROW][C]106[/C][C]258249[/C][C]335663.53030303[/C][C]-77414.5303030303[/C][/ROW]
[ROW][C]107[/C][C]299566[/C][C]273962.454545455[/C][C]25603.5454545455[/C][/ROW]
[ROW][C]108[/C][C]321797[/C][C]335663.53030303[/C][C]-13866.5303030303[/C][/ROW]
[ROW][C]109[/C][C]174736[/C][C]142534[/C][C]32202[/C][/ROW]
[ROW][C]110[/C][C]169545[/C][C]335663.53030303[/C][C]-166118.53030303[/C][/ROW]
[ROW][C]111[/C][C]354041[/C][C]254956.6[/C][C]99084.4[/C][/ROW]
[ROW][C]112[/C][C]303273[/C][C]335663.53030303[/C][C]-32390.5303030303[/C][/ROW]
[ROW][C]113[/C][C]23668[/C][C]7862.14285714286[/C][C]15805.8571428571[/C][/ROW]
[ROW][C]114[/C][C]196743[/C][C]273962.454545455[/C][C]-77219.4545454545[/C][/ROW]
[ROW][C]115[/C][C]61857[/C][C]54340.9[/C][C]7516.1[/C][/ROW]
[ROW][C]116[/C][C]207339[/C][C]223351.5[/C][C]-16012.5[/C][/ROW]
[ROW][C]117[/C][C]431443[/C][C]335663.53030303[/C][C]95779.4696969697[/C][/ROW]
[ROW][C]118[/C][C]21054[/C][C]7862.14285714286[/C][C]13191.8571428571[/C][/ROW]
[ROW][C]119[/C][C]252805[/C][C]223351.5[/C][C]29453.5[/C][/ROW]
[ROW][C]120[/C][C]31961[/C][C]54340.9[/C][C]-22379.9[/C][/ROW]
[ROW][C]121[/C][C]354622[/C][C]273962.454545455[/C][C]80659.5454545455[/C][/ROW]
[ROW][C]122[/C][C]251240[/C][C]254956.6[/C][C]-3716.60000000001[/C][/ROW]
[ROW][C]123[/C][C]187003[/C][C]185994.583333333[/C][C]1008.41666666666[/C][/ROW]
[ROW][C]124[/C][C]180842[/C][C]185994.583333333[/C][C]-5152.58333333334[/C][/ROW]
[ROW][C]125[/C][C]38214[/C][C]54340.9[/C][C]-16126.9[/C][/ROW]
[ROW][C]126[/C][C]278173[/C][C]335663.53030303[/C][C]-57490.5303030303[/C][/ROW]
[ROW][C]127[/C][C]358276[/C][C]335663.53030303[/C][C]22612.4696969697[/C][/ROW]
[ROW][C]128[/C][C]211775[/C][C]254956.6[/C][C]-43181.6[/C][/ROW]
[ROW][C]129[/C][C]445926[/C][C]335663.53030303[/C][C]110262.46969697[/C][/ROW]
[ROW][C]130[/C][C]348017[/C][C]335663.53030303[/C][C]12353.4696969697[/C][/ROW]
[ROW][C]131[/C][C]441946[/C][C]335663.53030303[/C][C]106282.46969697[/C][/ROW]
[ROW][C]132[/C][C]208962[/C][C]223351.5[/C][C]-14389.5[/C][/ROW]
[ROW][C]133[/C][C]105332[/C][C]142534[/C][C]-37202[/C][/ROW]
[ROW][C]134[/C][C]316128[/C][C]335663.53030303[/C][C]-19535.5303030303[/C][/ROW]
[ROW][C]135[/C][C]466139[/C][C]335663.53030303[/C][C]130475.46969697[/C][/ROW]
[ROW][C]136[/C][C]160799[/C][C]185994.583333333[/C][C]-25195.5833333333[/C][/ROW]
[ROW][C]137[/C][C]412099[/C][C]335663.53030303[/C][C]76435.4696969697[/C][/ROW]
[ROW][C]138[/C][C]173802[/C][C]185994.583333333[/C][C]-12192.5833333333[/C][/ROW]
[ROW][C]139[/C][C]292443[/C][C]273962.454545455[/C][C]18480.5454545455[/C][/ROW]
[ROW][C]140[/C][C]283913[/C][C]273962.454545455[/C][C]9950.54545454547[/C][/ROW]
[ROW][C]141[/C][C]234262[/C][C]142534[/C][C]91728[/C][/ROW]
[ROW][C]142[/C][C]386740[/C][C]335663.53030303[/C][C]51076.4696969697[/C][/ROW]
[ROW][C]143[/C][C]246963[/C][C]335663.53030303[/C][C]-88700.5303030303[/C][/ROW]
[ROW][C]144[/C][C]173260[/C][C]142534[/C][C]30726[/C][/ROW]
[ROW][C]145[/C][C]346748[/C][C]335663.53030303[/C][C]11084.4696969697[/C][/ROW]
[ROW][C]146[/C][C]176654[/C][C]335663.53030303[/C][C]-159009.53030303[/C][/ROW]
[ROW][C]147[/C][C]264767[/C][C]335663.53030303[/C][C]-70896.5303030303[/C][/ROW]
[ROW][C]148[/C][C]314070[/C][C]335663.53030303[/C][C]-21593.5303030303[/C][/ROW]
[ROW][C]149[/C][C]1[/C][C]7862.14285714286[/C][C]-7861.14285714286[/C][/ROW]
[ROW][C]150[/C][C]14688[/C][C]7862.14285714286[/C][C]6825.85714285714[/C][/ROW]
[ROW][C]151[/C][C]98[/C][C]7862.14285714286[/C][C]-7764.14285714286[/C][/ROW]
[ROW][C]152[/C][C]455[/C][C]7862.14285714286[/C][C]-7407.14285714286[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]7862.14285714286[/C][C]-7862.14285714286[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]7862.14285714286[/C][C]-7862.14285714286[/C][/ROW]
[ROW][C]155[/C][C]284420[/C][C]273962.454545455[/C][C]10457.5454545455[/C][/ROW]
[ROW][C]156[/C][C]410509[/C][C]273962.454545455[/C][C]136546.545454545[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]7862.14285714286[/C][C]-7862.14285714286[/C][/ROW]
[ROW][C]158[/C][C]203[/C][C]7862.14285714286[/C][C]-7659.14285714286[/C][/ROW]
[ROW][C]159[/C][C]7199[/C][C]7862.14285714286[/C][C]-663.142857142857[/C][/ROW]
[ROW][C]160[/C][C]46660[/C][C]54340.9[/C][C]-7680.9[/C][/ROW]
[ROW][C]161[/C][C]17547[/C][C]7862.14285714286[/C][C]9684.85714285714[/C][/ROW]
[ROW][C]162[/C][C]121550[/C][C]142534[/C][C]-20984[/C][/ROW]
[ROW][C]163[/C][C]969[/C][C]7862.14285714286[/C][C]-6893.14285714286[/C][/ROW]
[ROW][C]164[/C][C]242258[/C][C]185994.583333333[/C][C]56263.4166666667[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159948&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159948&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
1279055335663.53030303-56608.5303030303
2209884254956.6-45072.6
3233939254956.6-21017.6
4222117335663.53030303-113546.53030303
5179751185994.583333333-6243.58333333334
67084954340.916508.1
7568125335663.53030303232461.46969697
83318654340.9-21154.9
9227332335663.53030303-108331.53030303
10258874273962.454545455-15088.4545454545
11351915273962.45454545577952.5454545455
12260484273962.454545455-13478.4545454545
13203988185994.58333333317993.4166666667
14368577335663.5303030332913.4696969697
15269455273962.454545455-4507.45454545453
16394578335663.5303030358914.4696969697
17335567335663.53030303-96.5303030302748
18423110335663.5303030387446.4696969697
19182016335663.53030303-153647.53030303
20267365335663.53030303-68298.5303030303
21279428335663.53030303-56235.5303030303
22506616335663.53030303170952.46969697
23206722223351.5-16629.5
24200004335663.53030303-135659.53030303
25257139273962.454545455-16823.4545454545
26270815335663.53030303-64848.5303030303
27296850335663.53030303-38813.5303030303
28307100273962.45454545533137.5454545455
29184160185994.583333333-1834.58333333334
30393860335663.5303030358196.4696969697
31320558335663.53030303-15105.5303030303
32252512254956.6-2444.60000000001
33373013335663.5303030337349.4696969697
34115602142534-26932
35430118335663.5303030394454.4696969697
36273950223351.550598.5
37428077335663.5303030392413.4696969697
38251349254956.6-3607.60000000001
39115658142534-26876
40388812335663.5303030353148.4696969697
41343783273962.45454545569820.5454545455
42202289223351.5-21062.5
43214344223351.5-9007.5
44182398185994.583333333-3596.58333333334
45157164185994.583333333-28830.5833333333
46459440335663.53030303123776.46969697
477880054340.924459.1
48217932273962.454545455-56030.4545454545
49368086335663.5303030332422.4696969697
50210554273962.454545455-63408.4545454545
51244640273962.454545455-29322.4545454545
52241887862.1428571428616325.8571428571
53399093335663.5303030363429.4696969697
546502954340.910688.1
55101097142534-41437
56300488273962.45454545526525.5454545455
57369627335663.5303030333963.4696969697
58367127335663.5303030331463.4696969697
59374158335663.5303030338494.4696969697
60270099273962.454545455-3863.45454545453
61391871335663.5303030356207.4696969697
62315924335663.53030303-19739.5303030303
63291391273962.45454545517428.5454545455
64286417335663.53030303-49246.5303030303
65276201254956.621244.4
66267432273962.454545455-6530.45454545453
67215924335663.53030303-119739.53030303
68252767273962.454545455-21195.4545454545
69260919335663.53030303-74744.5303030303
70182961335663.53030303-152702.53030303
71256967273962.454545455-16995.4545454545
727356654340.919225.1
73272362273962.454545455-1600.45454545453
74220707273962.454545455-53255.4545454545
75228835273962.454545455-45127.4545454545
76371391335663.5303030335727.4696969697
77398210335663.5303030362546.4696969697
78220401223351.5-2950.5
79229333273962.454545455-44629.4545454545
80217623273962.454545455-56339.4545454545
81199011185994.58333333313016.4166666667
82483074335663.53030303147410.46969697
831459431425343409
84295224335663.53030303-40439.5303030303
8580953142534-61581
86180759185994.583333333-5235.58333333334
87179344254956.6-75612.6
88415550335663.5303030379886.4696969697
89369093273962.45454545595130.5454545455
90180679335663.53030303-154984.53030303
91299505273962.45454545525542.5454545455
92292260335663.53030303-43403.5303030303
9319948114253456947
94282361273962.4545454558398.54545454547
95329281254956.674324.4
96234577335663.53030303-101086.53030303
97297995335663.53030303-37668.5303030303
98305984335663.53030303-29679.5303030303
99416463335663.5303030380799.4696969697
100412530335663.5303030376866.4696969697
101297080335663.53030303-38583.5303030303
102318283335663.53030303-17380.5303030303
103214250273962.454545455-59712.4545454545
1044328754340.9-11053.9
105223456273962.454545455-50506.4545454545
106258249335663.53030303-77414.5303030303
107299566273962.45454545525603.5454545455
108321797335663.53030303-13866.5303030303
10917473614253432202
110169545335663.53030303-166118.53030303
111354041254956.699084.4
112303273335663.53030303-32390.5303030303
113236687862.1428571428615805.8571428571
114196743273962.454545455-77219.4545454545
1156185754340.97516.1
116207339223351.5-16012.5
117431443335663.5303030395779.4696969697
118210547862.1428571428613191.8571428571
119252805223351.529453.5
1203196154340.9-22379.9
121354622273962.45454545580659.5454545455
122251240254956.6-3716.60000000001
123187003185994.5833333331008.41666666666
124180842185994.583333333-5152.58333333334
1253821454340.9-16126.9
126278173335663.53030303-57490.5303030303
127358276335663.5303030322612.4696969697
128211775254956.6-43181.6
129445926335663.53030303110262.46969697
130348017335663.5303030312353.4696969697
131441946335663.53030303106282.46969697
132208962223351.5-14389.5
133105332142534-37202
134316128335663.53030303-19535.5303030303
135466139335663.53030303130475.46969697
136160799185994.583333333-25195.5833333333
137412099335663.5303030376435.4696969697
138173802185994.583333333-12192.5833333333
139292443273962.45454545518480.5454545455
140283913273962.4545454559950.54545454547
14123426214253491728
142386740335663.5303030351076.4696969697
143246963335663.53030303-88700.5303030303
14417326014253430726
145346748335663.5303030311084.4696969697
146176654335663.53030303-159009.53030303
147264767335663.53030303-70896.5303030303
148314070335663.53030303-21593.5303030303
14917862.14285714286-7861.14285714286
150146887862.142857142866825.85714285714
151987862.14285714286-7764.14285714286
1524557862.14285714286-7407.14285714286
15307862.14285714286-7862.14285714286
15407862.14285714286-7862.14285714286
155284420273962.45454545510457.5454545455
156410509273962.454545455136546.545454545
15707862.14285714286-7862.14285714286
1582037862.14285714286-7659.14285714286
15971997862.14285714286-663.142857142857
1604666054340.9-7680.9
161175477862.142857142869684.85714285714
162121550142534-20984
1639697862.14285714286-6893.14285714286
164242258185994.58333333356263.4166666667



Parameters (Session):
par1 = 1 ; par2 = none ; par4 = no ;
Parameters (R input):
par1 = 1 ; par2 = none ; par3 = ; 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')
}