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 15:44:18 -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/t132380907079qm1rnvscdn6vh.htm/, Retrieved Thu, 02 May 2024 16:06:35 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=154710, Retrieved Thu, 02 May 2024 16:06:35 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact74
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-12 15:13:28] [d623f9be707a26b8ffaece1fc4d5a7ee]
-           [Recursive Partitioning (Regression Trees)] [] [2011-12-13 20:44:18] [4cf172296f32adf71d8383c359dbb80f] [Current]
Feedback Forum

Post a new message
Dataseries X:
264530	34	124252
135248	30	98956
207253	42	98073
202898	35	106816
145249	26	41449
65295	31	76173
439387	29	177551
33186	18	22807
183696	30	126938
190673	29	61680
287239	42	72117
205260	50	79738
141987	33	57793
322679	49	91677
199717	40	64631
349227	52	106385
276709	33	161961
273576	35	112669
157448	25	114029
242782	43	124550
256814	40	105416
405942	37	72875
161189	25	81964
156389	46	104880
200181	41	76302
192645	35	96740
249893	38	93071
241171	36	78912
143182	28	35224
285266	37	90694
243048	40	125369
176062	42	80849
305210	48	104434
87995	33	65702
343613	39	108179
264159	37	63583
394976	41	95066
192718	32	62486
114673	17	31081
310108	39	94584
292891	36	87408
157518	38	68966
180362	36	88766
146175	35	57139
140319	45	90586
405267	38	109249
78800	26	33032
201970	45	96056
309762	46	146648
166270	41	80613
199186	34	87026
24188	4	5950
346142	41	131106
65029	18	32551
101097	14	31701
255082	37	91072
287314	53	159803
308944	36	143950
280943	37	112368
225816	36	82124
348955	46	144068
283283	28	162627
199642	42	55062
232791	38	95329
212262	33	105612
201345	28	62853
180424	31	125976
204450	40	79146
197813	32	108461
138731	25	99971
219074	43	77826
73566	23	22618
219392	42	84892
181728	38	92059
150006	34	77993
325723	40	104155
265348	36	109840
202410	37	238712
173420	34	67486
162366	37	68007
136341	25	48194
390163	45	134796
145905	26	38692
248834	40	93587
80953	8	56622
133301	27	15986
138630	32	113402
334082	37	97967
277542	57	74844
170849	41	136051
236398	37	50548
207178	38	112215
157125	28	59591
242395	36	59938
273632	33	137639
178489	32	143372
210247	34	138599
268066	35	174110
351056	58	135062
368833	30	175681
247842	45	130307
268118	37	139141
174311	36	44244
43287	19	43750
182915	23	48029
189021	35	95216
237531	36	92288
279589	36	94588
106655	23	197426
135798	41	151244
292930	40	139206
266805	42	106271
23623	1	1168
174970	36	71764
61857	11	25162
147760	42	45635
358662	34	101817
21054	0	855
230091	27	100174
31414	8	14116
284519	38	85008
209481	44	124254
161691	40	105793
137093	28	117129
38214	8	8773
166059	36	94747
319346	47	107549
186273	48	97392
374269	45	126893
275578	48	118850
371645	50	234853
179928	40	74783
94381	32	66089
269169	37	95684
382564	42	139537
118033	35	144253
370878	42	153824
147989	34	63995
236370	41	84891
193456	36	61263
189020	32	106221
344751	35	113587
224936	35	113864
173260	21	37238
291777	45	119906
130908	49	135096
209639	36	151611
262412	39	144645
1	0	0
14688	0	6023
98	0	0
455	0	0
0	0	0
0	0	0
195822	33	77457
347930	47	62464
0	0	0
203	0	0
7199	0	1644
46660	5	6179
17547	1	3926
107465	38	42087
969	0	0
179994	28	87656




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=154710&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=154710&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154710&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.8201
R-squared0.6725
RMSE58564.7658

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8201[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6725[/C][/ROW]
[ROW][C]RMSE[/C][C]58564.7658[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154710&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154710&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.8201
R-squared0.6725
RMSE58564.7658







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1264530219424.62545105.375
2135248219424.625-84176.625
3207253276836.551020408-69583.5510204082
4202898219424.625-16526.625
51452491363698880
665295152976.117647059-87681.1176470588
7439387284111.75155275.25
83318661637-28451
9183696219424.625-35728.625
10190673152976.11764705937696.8823529412
11287239217770.16129032369468.8387096774
12205260217770.161290323-12510.1612903226
13141987152976.117647059-10989.1176470588
14322679276836.55102040845842.4489795918
15199717217770.161290323-18053.1612903226
16349227276836.55102040872390.4489795918
17276709284111.75-7402.75
18273576219424.62554151.375
1915744813636921079
20242782276836.551020408-34054.5510204082
21256814276836.551020408-20022.5510204082
22405942217770.161290323188171.838709677
2316118913636924820
24156389276836.551020408-120447.551020408
25200181217770.161290323-17589.1612903226
26192645219424.625-26779.625
27249893276836.551020408-26943.5510204082
28241171217770.16129032323400.8387096774
29143182152976.117647059-9794.11764705883
30285266276836.5510204088429.44897959183
31243048276836.551020408-33788.5510204082
32176062217770.161290323-41708.1612903226
33305210276836.55102040828373.4489795918
3487995152976.117647059-64981.1176470588
35343613276836.55102040866776.4489795918
36264159217770.16129032346388.8387096774
37394976276836.551020408118139.448979592
38192718152976.11764705939741.8823529412
391146736163753036
40310108276836.55102040833271.4489795918
41292891217770.16129032375120.8387096774
42157518217770.161290323-60252.1612903226
43180362217770.161290323-37408.1612903226
44146175152976.117647059-6801.11764705883
45140319217770.161290323-77451.1612903226
46405267276836.551020408128430.448979592
4778800136369-57569
48201970276836.551020408-74866.5510204082
49309762276836.55102040832925.4489795918
50166270217770.161290323-51500.1612903226
51199186152976.11764705946209.8823529412
52241887858.9285714285716329.0714285714
53346142276836.55102040869305.4489795918
5465029616373392
551010976163739460
56255082276836.551020408-21754.5510204082
57287314276836.55102040810477.4489795918
58308944284111.7524832.25
59280943276836.5510204084106.44897959183
60225816217770.1612903238045.83870967742
61348955276836.55102040872118.4489795918
62283283284111.75-828.75
63199642217770.161290323-18128.1612903226
64232791276836.551020408-44045.5510204082
65212262219424.625-7162.625
66201345152976.11764705948368.8823529412
67180424219424.625-39000.625
68204450217770.161290323-13320.1612903226
69197813219424.625-21611.625
701387311363692362
71219074217770.1612903231303.83870967742
7273566136369-62803
73219392217770.1612903231621.83870967742
74181728276836.551020408-95108.5510204082
75150006152976.117647059-2970.11764705883
76325723276836.55102040848886.4489795918
77265348219424.62545923.375
78202410276836.551020408-74426.5510204082
79173420152976.11764705920443.8823529412
80162366217770.161290323-55404.1612903226
81136341136369-28
82390163276836.551020408113326.448979592
831459051363699536
84248834276836.551020408-28002.5510204082
85809536163719316
86133301152976.117647059-19675.1176470588
87138630219424.625-80794.625
88334082276836.55102040857245.4489795918
89277542217770.16129032359771.8387096774
90170849276836.551020408-105987.551020408
91236398217770.16129032318627.8387096774
92207178276836.551020408-69658.5510204082
93157125152976.1176470594148.88235294117
94242395217770.16129032324624.8387096774
95273632219424.62554207.375
96178489219424.625-40935.625
97210247219424.625-9177.625
98268066284111.75-16045.75
99351056276836.55102040874219.4489795918
100368833284111.7584721.25
101247842276836.551020408-28994.5510204082
102268118276836.551020408-8718.55102040817
103174311217770.161290323-43459.1612903226
1044328761637-18350
10518291513636946546
106189021219424.625-30403.625
107237531219424.62518106.375
108279589219424.62560164.375
109106655136369-29714
110135798276836.551020408-141038.551020408
111292930276836.55102040816093.4489795918
112266805276836.551020408-10031.5510204082
113236237858.9285714285715764.0714285714
114174970217770.161290323-42800.1612903226
1156185761637220
116147760217770.161290323-70010.1612903226
117358662219424.625139237.375
118210547858.9285714285713195.0714285714
119230091219424.62510666.375
1203141461637-30223
121284519217770.16129032366748.8387096774
122209481276836.551020408-67355.5510204082
123161691276836.551020408-115145.551020408
124137093219424.625-82331.625
1253821461637-23423
126166059219424.625-53365.625
127319346276836.55102040842509.4489795918
128186273276836.551020408-90563.5510204082
129374269276836.55102040897432.4489795918
130275578276836.551020408-1258.55102040817
131371645276836.55102040894808.4489795918
132179928217770.161290323-37842.1612903226
13394381152976.117647059-58595.1176470588
134269169276836.551020408-7667.55102040817
135382564276836.551020408105727.448979592
136118033284111.75-166078.75
137370878276836.55102040894041.4489795918
138147989152976.117647059-4987.11764705883
139236370217770.16129032318599.8387096774
140193456217770.161290323-24314.1612903226
141189020219424.625-30404.625
142344751219424.625125326.375
143224936219424.6255511.375
14417326013636936891
145291777276836.55102040814940.4489795918
146130908276836.551020408-145928.551020408
147209639284111.75-74472.75
148262412276836.551020408-14424.5510204082
14917858.92857142857-7857.92857142857
150146887858.928571428576829.07142857143
151987858.92857142857-7760.92857142857
1524557858.92857142857-7403.92857142857
15307858.92857142857-7858.92857142857
15407858.92857142857-7858.92857142857
155195822152976.11764705942845.8823529412
156347930217770.161290323130159.838709677
15707858.92857142857-7858.92857142857
1582037858.92857142857-7655.92857142857
15971997858.92857142857-659.928571428572
1604666061637-14977
161175477858.928571428579688.07142857143
162107465217770.161290323-110305.161290323
1639697858.92857142857-6889.92857142857
164179994152976.11764705927017.8823529412

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 264530 & 219424.625 & 45105.375 \tabularnewline
2 & 135248 & 219424.625 & -84176.625 \tabularnewline
3 & 207253 & 276836.551020408 & -69583.5510204082 \tabularnewline
4 & 202898 & 219424.625 & -16526.625 \tabularnewline
5 & 145249 & 136369 & 8880 \tabularnewline
6 & 65295 & 152976.117647059 & -87681.1176470588 \tabularnewline
7 & 439387 & 284111.75 & 155275.25 \tabularnewline
8 & 33186 & 61637 & -28451 \tabularnewline
9 & 183696 & 219424.625 & -35728.625 \tabularnewline
10 & 190673 & 152976.117647059 & 37696.8823529412 \tabularnewline
11 & 287239 & 217770.161290323 & 69468.8387096774 \tabularnewline
12 & 205260 & 217770.161290323 & -12510.1612903226 \tabularnewline
13 & 141987 & 152976.117647059 & -10989.1176470588 \tabularnewline
14 & 322679 & 276836.551020408 & 45842.4489795918 \tabularnewline
15 & 199717 & 217770.161290323 & -18053.1612903226 \tabularnewline
16 & 349227 & 276836.551020408 & 72390.4489795918 \tabularnewline
17 & 276709 & 284111.75 & -7402.75 \tabularnewline
18 & 273576 & 219424.625 & 54151.375 \tabularnewline
19 & 157448 & 136369 & 21079 \tabularnewline
20 & 242782 & 276836.551020408 & -34054.5510204082 \tabularnewline
21 & 256814 & 276836.551020408 & -20022.5510204082 \tabularnewline
22 & 405942 & 217770.161290323 & 188171.838709677 \tabularnewline
23 & 161189 & 136369 & 24820 \tabularnewline
24 & 156389 & 276836.551020408 & -120447.551020408 \tabularnewline
25 & 200181 & 217770.161290323 & -17589.1612903226 \tabularnewline
26 & 192645 & 219424.625 & -26779.625 \tabularnewline
27 & 249893 & 276836.551020408 & -26943.5510204082 \tabularnewline
28 & 241171 & 217770.161290323 & 23400.8387096774 \tabularnewline
29 & 143182 & 152976.117647059 & -9794.11764705883 \tabularnewline
30 & 285266 & 276836.551020408 & 8429.44897959183 \tabularnewline
31 & 243048 & 276836.551020408 & -33788.5510204082 \tabularnewline
32 & 176062 & 217770.161290323 & -41708.1612903226 \tabularnewline
33 & 305210 & 276836.551020408 & 28373.4489795918 \tabularnewline
34 & 87995 & 152976.117647059 & -64981.1176470588 \tabularnewline
35 & 343613 & 276836.551020408 & 66776.4489795918 \tabularnewline
36 & 264159 & 217770.161290323 & 46388.8387096774 \tabularnewline
37 & 394976 & 276836.551020408 & 118139.448979592 \tabularnewline
38 & 192718 & 152976.117647059 & 39741.8823529412 \tabularnewline
39 & 114673 & 61637 & 53036 \tabularnewline
40 & 310108 & 276836.551020408 & 33271.4489795918 \tabularnewline
41 & 292891 & 217770.161290323 & 75120.8387096774 \tabularnewline
42 & 157518 & 217770.161290323 & -60252.1612903226 \tabularnewline
43 & 180362 & 217770.161290323 & -37408.1612903226 \tabularnewline
44 & 146175 & 152976.117647059 & -6801.11764705883 \tabularnewline
45 & 140319 & 217770.161290323 & -77451.1612903226 \tabularnewline
46 & 405267 & 276836.551020408 & 128430.448979592 \tabularnewline
47 & 78800 & 136369 & -57569 \tabularnewline
48 & 201970 & 276836.551020408 & -74866.5510204082 \tabularnewline
49 & 309762 & 276836.551020408 & 32925.4489795918 \tabularnewline
50 & 166270 & 217770.161290323 & -51500.1612903226 \tabularnewline
51 & 199186 & 152976.117647059 & 46209.8823529412 \tabularnewline
52 & 24188 & 7858.92857142857 & 16329.0714285714 \tabularnewline
53 & 346142 & 276836.551020408 & 69305.4489795918 \tabularnewline
54 & 65029 & 61637 & 3392 \tabularnewline
55 & 101097 & 61637 & 39460 \tabularnewline
56 & 255082 & 276836.551020408 & -21754.5510204082 \tabularnewline
57 & 287314 & 276836.551020408 & 10477.4489795918 \tabularnewline
58 & 308944 & 284111.75 & 24832.25 \tabularnewline
59 & 280943 & 276836.551020408 & 4106.44897959183 \tabularnewline
60 & 225816 & 217770.161290323 & 8045.83870967742 \tabularnewline
61 & 348955 & 276836.551020408 & 72118.4489795918 \tabularnewline
62 & 283283 & 284111.75 & -828.75 \tabularnewline
63 & 199642 & 217770.161290323 & -18128.1612903226 \tabularnewline
64 & 232791 & 276836.551020408 & -44045.5510204082 \tabularnewline
65 & 212262 & 219424.625 & -7162.625 \tabularnewline
66 & 201345 & 152976.117647059 & 48368.8823529412 \tabularnewline
67 & 180424 & 219424.625 & -39000.625 \tabularnewline
68 & 204450 & 217770.161290323 & -13320.1612903226 \tabularnewline
69 & 197813 & 219424.625 & -21611.625 \tabularnewline
70 & 138731 & 136369 & 2362 \tabularnewline
71 & 219074 & 217770.161290323 & 1303.83870967742 \tabularnewline
72 & 73566 & 136369 & -62803 \tabularnewline
73 & 219392 & 217770.161290323 & 1621.83870967742 \tabularnewline
74 & 181728 & 276836.551020408 & -95108.5510204082 \tabularnewline
75 & 150006 & 152976.117647059 & -2970.11764705883 \tabularnewline
76 & 325723 & 276836.551020408 & 48886.4489795918 \tabularnewline
77 & 265348 & 219424.625 & 45923.375 \tabularnewline
78 & 202410 & 276836.551020408 & -74426.5510204082 \tabularnewline
79 & 173420 & 152976.117647059 & 20443.8823529412 \tabularnewline
80 & 162366 & 217770.161290323 & -55404.1612903226 \tabularnewline
81 & 136341 & 136369 & -28 \tabularnewline
82 & 390163 & 276836.551020408 & 113326.448979592 \tabularnewline
83 & 145905 & 136369 & 9536 \tabularnewline
84 & 248834 & 276836.551020408 & -28002.5510204082 \tabularnewline
85 & 80953 & 61637 & 19316 \tabularnewline
86 & 133301 & 152976.117647059 & -19675.1176470588 \tabularnewline
87 & 138630 & 219424.625 & -80794.625 \tabularnewline
88 & 334082 & 276836.551020408 & 57245.4489795918 \tabularnewline
89 & 277542 & 217770.161290323 & 59771.8387096774 \tabularnewline
90 & 170849 & 276836.551020408 & -105987.551020408 \tabularnewline
91 & 236398 & 217770.161290323 & 18627.8387096774 \tabularnewline
92 & 207178 & 276836.551020408 & -69658.5510204082 \tabularnewline
93 & 157125 & 152976.117647059 & 4148.88235294117 \tabularnewline
94 & 242395 & 217770.161290323 & 24624.8387096774 \tabularnewline
95 & 273632 & 219424.625 & 54207.375 \tabularnewline
96 & 178489 & 219424.625 & -40935.625 \tabularnewline
97 & 210247 & 219424.625 & -9177.625 \tabularnewline
98 & 268066 & 284111.75 & -16045.75 \tabularnewline
99 & 351056 & 276836.551020408 & 74219.4489795918 \tabularnewline
100 & 368833 & 284111.75 & 84721.25 \tabularnewline
101 & 247842 & 276836.551020408 & -28994.5510204082 \tabularnewline
102 & 268118 & 276836.551020408 & -8718.55102040817 \tabularnewline
103 & 174311 & 217770.161290323 & -43459.1612903226 \tabularnewline
104 & 43287 & 61637 & -18350 \tabularnewline
105 & 182915 & 136369 & 46546 \tabularnewline
106 & 189021 & 219424.625 & -30403.625 \tabularnewline
107 & 237531 & 219424.625 & 18106.375 \tabularnewline
108 & 279589 & 219424.625 & 60164.375 \tabularnewline
109 & 106655 & 136369 & -29714 \tabularnewline
110 & 135798 & 276836.551020408 & -141038.551020408 \tabularnewline
111 & 292930 & 276836.551020408 & 16093.4489795918 \tabularnewline
112 & 266805 & 276836.551020408 & -10031.5510204082 \tabularnewline
113 & 23623 & 7858.92857142857 & 15764.0714285714 \tabularnewline
114 & 174970 & 217770.161290323 & -42800.1612903226 \tabularnewline
115 & 61857 & 61637 & 220 \tabularnewline
116 & 147760 & 217770.161290323 & -70010.1612903226 \tabularnewline
117 & 358662 & 219424.625 & 139237.375 \tabularnewline
118 & 21054 & 7858.92857142857 & 13195.0714285714 \tabularnewline
119 & 230091 & 219424.625 & 10666.375 \tabularnewline
120 & 31414 & 61637 & -30223 \tabularnewline
121 & 284519 & 217770.161290323 & 66748.8387096774 \tabularnewline
122 & 209481 & 276836.551020408 & -67355.5510204082 \tabularnewline
123 & 161691 & 276836.551020408 & -115145.551020408 \tabularnewline
124 & 137093 & 219424.625 & -82331.625 \tabularnewline
125 & 38214 & 61637 & -23423 \tabularnewline
126 & 166059 & 219424.625 & -53365.625 \tabularnewline
127 & 319346 & 276836.551020408 & 42509.4489795918 \tabularnewline
128 & 186273 & 276836.551020408 & -90563.5510204082 \tabularnewline
129 & 374269 & 276836.551020408 & 97432.4489795918 \tabularnewline
130 & 275578 & 276836.551020408 & -1258.55102040817 \tabularnewline
131 & 371645 & 276836.551020408 & 94808.4489795918 \tabularnewline
132 & 179928 & 217770.161290323 & -37842.1612903226 \tabularnewline
133 & 94381 & 152976.117647059 & -58595.1176470588 \tabularnewline
134 & 269169 & 276836.551020408 & -7667.55102040817 \tabularnewline
135 & 382564 & 276836.551020408 & 105727.448979592 \tabularnewline
136 & 118033 & 284111.75 & -166078.75 \tabularnewline
137 & 370878 & 276836.551020408 & 94041.4489795918 \tabularnewline
138 & 147989 & 152976.117647059 & -4987.11764705883 \tabularnewline
139 & 236370 & 217770.161290323 & 18599.8387096774 \tabularnewline
140 & 193456 & 217770.161290323 & -24314.1612903226 \tabularnewline
141 & 189020 & 219424.625 & -30404.625 \tabularnewline
142 & 344751 & 219424.625 & 125326.375 \tabularnewline
143 & 224936 & 219424.625 & 5511.375 \tabularnewline
144 & 173260 & 136369 & 36891 \tabularnewline
145 & 291777 & 276836.551020408 & 14940.4489795918 \tabularnewline
146 & 130908 & 276836.551020408 & -145928.551020408 \tabularnewline
147 & 209639 & 284111.75 & -74472.75 \tabularnewline
148 & 262412 & 276836.551020408 & -14424.5510204082 \tabularnewline
149 & 1 & 7858.92857142857 & -7857.92857142857 \tabularnewline
150 & 14688 & 7858.92857142857 & 6829.07142857143 \tabularnewline
151 & 98 & 7858.92857142857 & -7760.92857142857 \tabularnewline
152 & 455 & 7858.92857142857 & -7403.92857142857 \tabularnewline
153 & 0 & 7858.92857142857 & -7858.92857142857 \tabularnewline
154 & 0 & 7858.92857142857 & -7858.92857142857 \tabularnewline
155 & 195822 & 152976.117647059 & 42845.8823529412 \tabularnewline
156 & 347930 & 217770.161290323 & 130159.838709677 \tabularnewline
157 & 0 & 7858.92857142857 & -7858.92857142857 \tabularnewline
158 & 203 & 7858.92857142857 & -7655.92857142857 \tabularnewline
159 & 7199 & 7858.92857142857 & -659.928571428572 \tabularnewline
160 & 46660 & 61637 & -14977 \tabularnewline
161 & 17547 & 7858.92857142857 & 9688.07142857143 \tabularnewline
162 & 107465 & 217770.161290323 & -110305.161290323 \tabularnewline
163 & 969 & 7858.92857142857 & -6889.92857142857 \tabularnewline
164 & 179994 & 152976.117647059 & 27017.8823529412 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154710&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]264530[/C][C]219424.625[/C][C]45105.375[/C][/ROW]
[ROW][C]2[/C][C]135248[/C][C]219424.625[/C][C]-84176.625[/C][/ROW]
[ROW][C]3[/C][C]207253[/C][C]276836.551020408[/C][C]-69583.5510204082[/C][/ROW]
[ROW][C]4[/C][C]202898[/C][C]219424.625[/C][C]-16526.625[/C][/ROW]
[ROW][C]5[/C][C]145249[/C][C]136369[/C][C]8880[/C][/ROW]
[ROW][C]6[/C][C]65295[/C][C]152976.117647059[/C][C]-87681.1176470588[/C][/ROW]
[ROW][C]7[/C][C]439387[/C][C]284111.75[/C][C]155275.25[/C][/ROW]
[ROW][C]8[/C][C]33186[/C][C]61637[/C][C]-28451[/C][/ROW]
[ROW][C]9[/C][C]183696[/C][C]219424.625[/C][C]-35728.625[/C][/ROW]
[ROW][C]10[/C][C]190673[/C][C]152976.117647059[/C][C]37696.8823529412[/C][/ROW]
[ROW][C]11[/C][C]287239[/C][C]217770.161290323[/C][C]69468.8387096774[/C][/ROW]
[ROW][C]12[/C][C]205260[/C][C]217770.161290323[/C][C]-12510.1612903226[/C][/ROW]
[ROW][C]13[/C][C]141987[/C][C]152976.117647059[/C][C]-10989.1176470588[/C][/ROW]
[ROW][C]14[/C][C]322679[/C][C]276836.551020408[/C][C]45842.4489795918[/C][/ROW]
[ROW][C]15[/C][C]199717[/C][C]217770.161290323[/C][C]-18053.1612903226[/C][/ROW]
[ROW][C]16[/C][C]349227[/C][C]276836.551020408[/C][C]72390.4489795918[/C][/ROW]
[ROW][C]17[/C][C]276709[/C][C]284111.75[/C][C]-7402.75[/C][/ROW]
[ROW][C]18[/C][C]273576[/C][C]219424.625[/C][C]54151.375[/C][/ROW]
[ROW][C]19[/C][C]157448[/C][C]136369[/C][C]21079[/C][/ROW]
[ROW][C]20[/C][C]242782[/C][C]276836.551020408[/C][C]-34054.5510204082[/C][/ROW]
[ROW][C]21[/C][C]256814[/C][C]276836.551020408[/C][C]-20022.5510204082[/C][/ROW]
[ROW][C]22[/C][C]405942[/C][C]217770.161290323[/C][C]188171.838709677[/C][/ROW]
[ROW][C]23[/C][C]161189[/C][C]136369[/C][C]24820[/C][/ROW]
[ROW][C]24[/C][C]156389[/C][C]276836.551020408[/C][C]-120447.551020408[/C][/ROW]
[ROW][C]25[/C][C]200181[/C][C]217770.161290323[/C][C]-17589.1612903226[/C][/ROW]
[ROW][C]26[/C][C]192645[/C][C]219424.625[/C][C]-26779.625[/C][/ROW]
[ROW][C]27[/C][C]249893[/C][C]276836.551020408[/C][C]-26943.5510204082[/C][/ROW]
[ROW][C]28[/C][C]241171[/C][C]217770.161290323[/C][C]23400.8387096774[/C][/ROW]
[ROW][C]29[/C][C]143182[/C][C]152976.117647059[/C][C]-9794.11764705883[/C][/ROW]
[ROW][C]30[/C][C]285266[/C][C]276836.551020408[/C][C]8429.44897959183[/C][/ROW]
[ROW][C]31[/C][C]243048[/C][C]276836.551020408[/C][C]-33788.5510204082[/C][/ROW]
[ROW][C]32[/C][C]176062[/C][C]217770.161290323[/C][C]-41708.1612903226[/C][/ROW]
[ROW][C]33[/C][C]305210[/C][C]276836.551020408[/C][C]28373.4489795918[/C][/ROW]
[ROW][C]34[/C][C]87995[/C][C]152976.117647059[/C][C]-64981.1176470588[/C][/ROW]
[ROW][C]35[/C][C]343613[/C][C]276836.551020408[/C][C]66776.4489795918[/C][/ROW]
[ROW][C]36[/C][C]264159[/C][C]217770.161290323[/C][C]46388.8387096774[/C][/ROW]
[ROW][C]37[/C][C]394976[/C][C]276836.551020408[/C][C]118139.448979592[/C][/ROW]
[ROW][C]38[/C][C]192718[/C][C]152976.117647059[/C][C]39741.8823529412[/C][/ROW]
[ROW][C]39[/C][C]114673[/C][C]61637[/C][C]53036[/C][/ROW]
[ROW][C]40[/C][C]310108[/C][C]276836.551020408[/C][C]33271.4489795918[/C][/ROW]
[ROW][C]41[/C][C]292891[/C][C]217770.161290323[/C][C]75120.8387096774[/C][/ROW]
[ROW][C]42[/C][C]157518[/C][C]217770.161290323[/C][C]-60252.1612903226[/C][/ROW]
[ROW][C]43[/C][C]180362[/C][C]217770.161290323[/C][C]-37408.1612903226[/C][/ROW]
[ROW][C]44[/C][C]146175[/C][C]152976.117647059[/C][C]-6801.11764705883[/C][/ROW]
[ROW][C]45[/C][C]140319[/C][C]217770.161290323[/C][C]-77451.1612903226[/C][/ROW]
[ROW][C]46[/C][C]405267[/C][C]276836.551020408[/C][C]128430.448979592[/C][/ROW]
[ROW][C]47[/C][C]78800[/C][C]136369[/C][C]-57569[/C][/ROW]
[ROW][C]48[/C][C]201970[/C][C]276836.551020408[/C][C]-74866.5510204082[/C][/ROW]
[ROW][C]49[/C][C]309762[/C][C]276836.551020408[/C][C]32925.4489795918[/C][/ROW]
[ROW][C]50[/C][C]166270[/C][C]217770.161290323[/C][C]-51500.1612903226[/C][/ROW]
[ROW][C]51[/C][C]199186[/C][C]152976.117647059[/C][C]46209.8823529412[/C][/ROW]
[ROW][C]52[/C][C]24188[/C][C]7858.92857142857[/C][C]16329.0714285714[/C][/ROW]
[ROW][C]53[/C][C]346142[/C][C]276836.551020408[/C][C]69305.4489795918[/C][/ROW]
[ROW][C]54[/C][C]65029[/C][C]61637[/C][C]3392[/C][/ROW]
[ROW][C]55[/C][C]101097[/C][C]61637[/C][C]39460[/C][/ROW]
[ROW][C]56[/C][C]255082[/C][C]276836.551020408[/C][C]-21754.5510204082[/C][/ROW]
[ROW][C]57[/C][C]287314[/C][C]276836.551020408[/C][C]10477.4489795918[/C][/ROW]
[ROW][C]58[/C][C]308944[/C][C]284111.75[/C][C]24832.25[/C][/ROW]
[ROW][C]59[/C][C]280943[/C][C]276836.551020408[/C][C]4106.44897959183[/C][/ROW]
[ROW][C]60[/C][C]225816[/C][C]217770.161290323[/C][C]8045.83870967742[/C][/ROW]
[ROW][C]61[/C][C]348955[/C][C]276836.551020408[/C][C]72118.4489795918[/C][/ROW]
[ROW][C]62[/C][C]283283[/C][C]284111.75[/C][C]-828.75[/C][/ROW]
[ROW][C]63[/C][C]199642[/C][C]217770.161290323[/C][C]-18128.1612903226[/C][/ROW]
[ROW][C]64[/C][C]232791[/C][C]276836.551020408[/C][C]-44045.5510204082[/C][/ROW]
[ROW][C]65[/C][C]212262[/C][C]219424.625[/C][C]-7162.625[/C][/ROW]
[ROW][C]66[/C][C]201345[/C][C]152976.117647059[/C][C]48368.8823529412[/C][/ROW]
[ROW][C]67[/C][C]180424[/C][C]219424.625[/C][C]-39000.625[/C][/ROW]
[ROW][C]68[/C][C]204450[/C][C]217770.161290323[/C][C]-13320.1612903226[/C][/ROW]
[ROW][C]69[/C][C]197813[/C][C]219424.625[/C][C]-21611.625[/C][/ROW]
[ROW][C]70[/C][C]138731[/C][C]136369[/C][C]2362[/C][/ROW]
[ROW][C]71[/C][C]219074[/C][C]217770.161290323[/C][C]1303.83870967742[/C][/ROW]
[ROW][C]72[/C][C]73566[/C][C]136369[/C][C]-62803[/C][/ROW]
[ROW][C]73[/C][C]219392[/C][C]217770.161290323[/C][C]1621.83870967742[/C][/ROW]
[ROW][C]74[/C][C]181728[/C][C]276836.551020408[/C][C]-95108.5510204082[/C][/ROW]
[ROW][C]75[/C][C]150006[/C][C]152976.117647059[/C][C]-2970.11764705883[/C][/ROW]
[ROW][C]76[/C][C]325723[/C][C]276836.551020408[/C][C]48886.4489795918[/C][/ROW]
[ROW][C]77[/C][C]265348[/C][C]219424.625[/C][C]45923.375[/C][/ROW]
[ROW][C]78[/C][C]202410[/C][C]276836.551020408[/C][C]-74426.5510204082[/C][/ROW]
[ROW][C]79[/C][C]173420[/C][C]152976.117647059[/C][C]20443.8823529412[/C][/ROW]
[ROW][C]80[/C][C]162366[/C][C]217770.161290323[/C][C]-55404.1612903226[/C][/ROW]
[ROW][C]81[/C][C]136341[/C][C]136369[/C][C]-28[/C][/ROW]
[ROW][C]82[/C][C]390163[/C][C]276836.551020408[/C][C]113326.448979592[/C][/ROW]
[ROW][C]83[/C][C]145905[/C][C]136369[/C][C]9536[/C][/ROW]
[ROW][C]84[/C][C]248834[/C][C]276836.551020408[/C][C]-28002.5510204082[/C][/ROW]
[ROW][C]85[/C][C]80953[/C][C]61637[/C][C]19316[/C][/ROW]
[ROW][C]86[/C][C]133301[/C][C]152976.117647059[/C][C]-19675.1176470588[/C][/ROW]
[ROW][C]87[/C][C]138630[/C][C]219424.625[/C][C]-80794.625[/C][/ROW]
[ROW][C]88[/C][C]334082[/C][C]276836.551020408[/C][C]57245.4489795918[/C][/ROW]
[ROW][C]89[/C][C]277542[/C][C]217770.161290323[/C][C]59771.8387096774[/C][/ROW]
[ROW][C]90[/C][C]170849[/C][C]276836.551020408[/C][C]-105987.551020408[/C][/ROW]
[ROW][C]91[/C][C]236398[/C][C]217770.161290323[/C][C]18627.8387096774[/C][/ROW]
[ROW][C]92[/C][C]207178[/C][C]276836.551020408[/C][C]-69658.5510204082[/C][/ROW]
[ROW][C]93[/C][C]157125[/C][C]152976.117647059[/C][C]4148.88235294117[/C][/ROW]
[ROW][C]94[/C][C]242395[/C][C]217770.161290323[/C][C]24624.8387096774[/C][/ROW]
[ROW][C]95[/C][C]273632[/C][C]219424.625[/C][C]54207.375[/C][/ROW]
[ROW][C]96[/C][C]178489[/C][C]219424.625[/C][C]-40935.625[/C][/ROW]
[ROW][C]97[/C][C]210247[/C][C]219424.625[/C][C]-9177.625[/C][/ROW]
[ROW][C]98[/C][C]268066[/C][C]284111.75[/C][C]-16045.75[/C][/ROW]
[ROW][C]99[/C][C]351056[/C][C]276836.551020408[/C][C]74219.4489795918[/C][/ROW]
[ROW][C]100[/C][C]368833[/C][C]284111.75[/C][C]84721.25[/C][/ROW]
[ROW][C]101[/C][C]247842[/C][C]276836.551020408[/C][C]-28994.5510204082[/C][/ROW]
[ROW][C]102[/C][C]268118[/C][C]276836.551020408[/C][C]-8718.55102040817[/C][/ROW]
[ROW][C]103[/C][C]174311[/C][C]217770.161290323[/C][C]-43459.1612903226[/C][/ROW]
[ROW][C]104[/C][C]43287[/C][C]61637[/C][C]-18350[/C][/ROW]
[ROW][C]105[/C][C]182915[/C][C]136369[/C][C]46546[/C][/ROW]
[ROW][C]106[/C][C]189021[/C][C]219424.625[/C][C]-30403.625[/C][/ROW]
[ROW][C]107[/C][C]237531[/C][C]219424.625[/C][C]18106.375[/C][/ROW]
[ROW][C]108[/C][C]279589[/C][C]219424.625[/C][C]60164.375[/C][/ROW]
[ROW][C]109[/C][C]106655[/C][C]136369[/C][C]-29714[/C][/ROW]
[ROW][C]110[/C][C]135798[/C][C]276836.551020408[/C][C]-141038.551020408[/C][/ROW]
[ROW][C]111[/C][C]292930[/C][C]276836.551020408[/C][C]16093.4489795918[/C][/ROW]
[ROW][C]112[/C][C]266805[/C][C]276836.551020408[/C][C]-10031.5510204082[/C][/ROW]
[ROW][C]113[/C][C]23623[/C][C]7858.92857142857[/C][C]15764.0714285714[/C][/ROW]
[ROW][C]114[/C][C]174970[/C][C]217770.161290323[/C][C]-42800.1612903226[/C][/ROW]
[ROW][C]115[/C][C]61857[/C][C]61637[/C][C]220[/C][/ROW]
[ROW][C]116[/C][C]147760[/C][C]217770.161290323[/C][C]-70010.1612903226[/C][/ROW]
[ROW][C]117[/C][C]358662[/C][C]219424.625[/C][C]139237.375[/C][/ROW]
[ROW][C]118[/C][C]21054[/C][C]7858.92857142857[/C][C]13195.0714285714[/C][/ROW]
[ROW][C]119[/C][C]230091[/C][C]219424.625[/C][C]10666.375[/C][/ROW]
[ROW][C]120[/C][C]31414[/C][C]61637[/C][C]-30223[/C][/ROW]
[ROW][C]121[/C][C]284519[/C][C]217770.161290323[/C][C]66748.8387096774[/C][/ROW]
[ROW][C]122[/C][C]209481[/C][C]276836.551020408[/C][C]-67355.5510204082[/C][/ROW]
[ROW][C]123[/C][C]161691[/C][C]276836.551020408[/C][C]-115145.551020408[/C][/ROW]
[ROW][C]124[/C][C]137093[/C][C]219424.625[/C][C]-82331.625[/C][/ROW]
[ROW][C]125[/C][C]38214[/C][C]61637[/C][C]-23423[/C][/ROW]
[ROW][C]126[/C][C]166059[/C][C]219424.625[/C][C]-53365.625[/C][/ROW]
[ROW][C]127[/C][C]319346[/C][C]276836.551020408[/C][C]42509.4489795918[/C][/ROW]
[ROW][C]128[/C][C]186273[/C][C]276836.551020408[/C][C]-90563.5510204082[/C][/ROW]
[ROW][C]129[/C][C]374269[/C][C]276836.551020408[/C][C]97432.4489795918[/C][/ROW]
[ROW][C]130[/C][C]275578[/C][C]276836.551020408[/C][C]-1258.55102040817[/C][/ROW]
[ROW][C]131[/C][C]371645[/C][C]276836.551020408[/C][C]94808.4489795918[/C][/ROW]
[ROW][C]132[/C][C]179928[/C][C]217770.161290323[/C][C]-37842.1612903226[/C][/ROW]
[ROW][C]133[/C][C]94381[/C][C]152976.117647059[/C][C]-58595.1176470588[/C][/ROW]
[ROW][C]134[/C][C]269169[/C][C]276836.551020408[/C][C]-7667.55102040817[/C][/ROW]
[ROW][C]135[/C][C]382564[/C][C]276836.551020408[/C][C]105727.448979592[/C][/ROW]
[ROW][C]136[/C][C]118033[/C][C]284111.75[/C][C]-166078.75[/C][/ROW]
[ROW][C]137[/C][C]370878[/C][C]276836.551020408[/C][C]94041.4489795918[/C][/ROW]
[ROW][C]138[/C][C]147989[/C][C]152976.117647059[/C][C]-4987.11764705883[/C][/ROW]
[ROW][C]139[/C][C]236370[/C][C]217770.161290323[/C][C]18599.8387096774[/C][/ROW]
[ROW][C]140[/C][C]193456[/C][C]217770.161290323[/C][C]-24314.1612903226[/C][/ROW]
[ROW][C]141[/C][C]189020[/C][C]219424.625[/C][C]-30404.625[/C][/ROW]
[ROW][C]142[/C][C]344751[/C][C]219424.625[/C][C]125326.375[/C][/ROW]
[ROW][C]143[/C][C]224936[/C][C]219424.625[/C][C]5511.375[/C][/ROW]
[ROW][C]144[/C][C]173260[/C][C]136369[/C][C]36891[/C][/ROW]
[ROW][C]145[/C][C]291777[/C][C]276836.551020408[/C][C]14940.4489795918[/C][/ROW]
[ROW][C]146[/C][C]130908[/C][C]276836.551020408[/C][C]-145928.551020408[/C][/ROW]
[ROW][C]147[/C][C]209639[/C][C]284111.75[/C][C]-74472.75[/C][/ROW]
[ROW][C]148[/C][C]262412[/C][C]276836.551020408[/C][C]-14424.5510204082[/C][/ROW]
[ROW][C]149[/C][C]1[/C][C]7858.92857142857[/C][C]-7857.92857142857[/C][/ROW]
[ROW][C]150[/C][C]14688[/C][C]7858.92857142857[/C][C]6829.07142857143[/C][/ROW]
[ROW][C]151[/C][C]98[/C][C]7858.92857142857[/C][C]-7760.92857142857[/C][/ROW]
[ROW][C]152[/C][C]455[/C][C]7858.92857142857[/C][C]-7403.92857142857[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]7858.92857142857[/C][C]-7858.92857142857[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]7858.92857142857[/C][C]-7858.92857142857[/C][/ROW]
[ROW][C]155[/C][C]195822[/C][C]152976.117647059[/C][C]42845.8823529412[/C][/ROW]
[ROW][C]156[/C][C]347930[/C][C]217770.161290323[/C][C]130159.838709677[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]7858.92857142857[/C][C]-7858.92857142857[/C][/ROW]
[ROW][C]158[/C][C]203[/C][C]7858.92857142857[/C][C]-7655.92857142857[/C][/ROW]
[ROW][C]159[/C][C]7199[/C][C]7858.92857142857[/C][C]-659.928571428572[/C][/ROW]
[ROW][C]160[/C][C]46660[/C][C]61637[/C][C]-14977[/C][/ROW]
[ROW][C]161[/C][C]17547[/C][C]7858.92857142857[/C][C]9688.07142857143[/C][/ROW]
[ROW][C]162[/C][C]107465[/C][C]217770.161290323[/C][C]-110305.161290323[/C][/ROW]
[ROW][C]163[/C][C]969[/C][C]7858.92857142857[/C][C]-6889.92857142857[/C][/ROW]
[ROW][C]164[/C][C]179994[/C][C]152976.117647059[/C][C]27017.8823529412[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154710&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154710&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
1264530219424.62545105.375
2135248219424.625-84176.625
3207253276836.551020408-69583.5510204082
4202898219424.625-16526.625
51452491363698880
665295152976.117647059-87681.1176470588
7439387284111.75155275.25
83318661637-28451
9183696219424.625-35728.625
10190673152976.11764705937696.8823529412
11287239217770.16129032369468.8387096774
12205260217770.161290323-12510.1612903226
13141987152976.117647059-10989.1176470588
14322679276836.55102040845842.4489795918
15199717217770.161290323-18053.1612903226
16349227276836.55102040872390.4489795918
17276709284111.75-7402.75
18273576219424.62554151.375
1915744813636921079
20242782276836.551020408-34054.5510204082
21256814276836.551020408-20022.5510204082
22405942217770.161290323188171.838709677
2316118913636924820
24156389276836.551020408-120447.551020408
25200181217770.161290323-17589.1612903226
26192645219424.625-26779.625
27249893276836.551020408-26943.5510204082
28241171217770.16129032323400.8387096774
29143182152976.117647059-9794.11764705883
30285266276836.5510204088429.44897959183
31243048276836.551020408-33788.5510204082
32176062217770.161290323-41708.1612903226
33305210276836.55102040828373.4489795918
3487995152976.117647059-64981.1176470588
35343613276836.55102040866776.4489795918
36264159217770.16129032346388.8387096774
37394976276836.551020408118139.448979592
38192718152976.11764705939741.8823529412
391146736163753036
40310108276836.55102040833271.4489795918
41292891217770.16129032375120.8387096774
42157518217770.161290323-60252.1612903226
43180362217770.161290323-37408.1612903226
44146175152976.117647059-6801.11764705883
45140319217770.161290323-77451.1612903226
46405267276836.551020408128430.448979592
4778800136369-57569
48201970276836.551020408-74866.5510204082
49309762276836.55102040832925.4489795918
50166270217770.161290323-51500.1612903226
51199186152976.11764705946209.8823529412
52241887858.9285714285716329.0714285714
53346142276836.55102040869305.4489795918
5465029616373392
551010976163739460
56255082276836.551020408-21754.5510204082
57287314276836.55102040810477.4489795918
58308944284111.7524832.25
59280943276836.5510204084106.44897959183
60225816217770.1612903238045.83870967742
61348955276836.55102040872118.4489795918
62283283284111.75-828.75
63199642217770.161290323-18128.1612903226
64232791276836.551020408-44045.5510204082
65212262219424.625-7162.625
66201345152976.11764705948368.8823529412
67180424219424.625-39000.625
68204450217770.161290323-13320.1612903226
69197813219424.625-21611.625
701387311363692362
71219074217770.1612903231303.83870967742
7273566136369-62803
73219392217770.1612903231621.83870967742
74181728276836.551020408-95108.5510204082
75150006152976.117647059-2970.11764705883
76325723276836.55102040848886.4489795918
77265348219424.62545923.375
78202410276836.551020408-74426.5510204082
79173420152976.11764705920443.8823529412
80162366217770.161290323-55404.1612903226
81136341136369-28
82390163276836.551020408113326.448979592
831459051363699536
84248834276836.551020408-28002.5510204082
85809536163719316
86133301152976.117647059-19675.1176470588
87138630219424.625-80794.625
88334082276836.55102040857245.4489795918
89277542217770.16129032359771.8387096774
90170849276836.551020408-105987.551020408
91236398217770.16129032318627.8387096774
92207178276836.551020408-69658.5510204082
93157125152976.1176470594148.88235294117
94242395217770.16129032324624.8387096774
95273632219424.62554207.375
96178489219424.625-40935.625
97210247219424.625-9177.625
98268066284111.75-16045.75
99351056276836.55102040874219.4489795918
100368833284111.7584721.25
101247842276836.551020408-28994.5510204082
102268118276836.551020408-8718.55102040817
103174311217770.161290323-43459.1612903226
1044328761637-18350
10518291513636946546
106189021219424.625-30403.625
107237531219424.62518106.375
108279589219424.62560164.375
109106655136369-29714
110135798276836.551020408-141038.551020408
111292930276836.55102040816093.4489795918
112266805276836.551020408-10031.5510204082
113236237858.9285714285715764.0714285714
114174970217770.161290323-42800.1612903226
1156185761637220
116147760217770.161290323-70010.1612903226
117358662219424.625139237.375
118210547858.9285714285713195.0714285714
119230091219424.62510666.375
1203141461637-30223
121284519217770.16129032366748.8387096774
122209481276836.551020408-67355.5510204082
123161691276836.551020408-115145.551020408
124137093219424.625-82331.625
1253821461637-23423
126166059219424.625-53365.625
127319346276836.55102040842509.4489795918
128186273276836.551020408-90563.5510204082
129374269276836.55102040897432.4489795918
130275578276836.551020408-1258.55102040817
131371645276836.55102040894808.4489795918
132179928217770.161290323-37842.1612903226
13394381152976.117647059-58595.1176470588
134269169276836.551020408-7667.55102040817
135382564276836.551020408105727.448979592
136118033284111.75-166078.75
137370878276836.55102040894041.4489795918
138147989152976.117647059-4987.11764705883
139236370217770.16129032318599.8387096774
140193456217770.161290323-24314.1612903226
141189020219424.625-30404.625
142344751219424.625125326.375
143224936219424.6255511.375
14417326013636936891
145291777276836.55102040814940.4489795918
146130908276836.551020408-145928.551020408
147209639284111.75-74472.75
148262412276836.551020408-14424.5510204082
14917858.92857142857-7857.92857142857
150146887858.928571428576829.07142857143
151987858.92857142857-7760.92857142857
1524557858.92857142857-7403.92857142857
15307858.92857142857-7858.92857142857
15407858.92857142857-7858.92857142857
155195822152976.11764705942845.8823529412
156347930217770.161290323130159.838709677
15707858.92857142857-7858.92857142857
1582037858.92857142857-7655.92857142857
15971997858.92857142857-659.928571428572
1604666061637-14977
161175477858.928571428579688.07142857143
162107465217770.161290323-110305.161290323
1639697858.92857142857-6889.92857142857
164179994152976.11764705927017.8823529412



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