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 computationSun, 09 Dec 2012 12:25:55 -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/2012/Dec/09/t1355073995v14oolk7khvq902.htm/, Retrieved Fri, 19 Apr 2024 08:47:16 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=198001, Retrieved Fri, 19 Apr 2024 08:47:16 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact101
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-11 14:43:54] [b4c8fd31b0af00c33711722ddf8d2c4c]
-   PD    [Recursive Partitioning (Regression Trees)] [] [2011-12-12 10:41:43] [74be16979710d4c4e7c6647856088456]
-             [Recursive Partitioning (Regression Trees)] [WS 10 (3)] [2012-12-09 17:25:55] [6b9eda33bf4cae06c9f9f024b199ddfb] [Current]
Feedback Forum

Post a new message
Dataseries X:
0	0	264530	165119
0	0	135248	107269
0	0	207253	93497
0	0	202898	100269
0	0	145249	91627
0	0	65295	47552
0	0	439387	233933
0	0	33186	6853
0	0	183696	104380
0	0	190673	98431
0	0	287239	156949
0	0	205260	81817
0	0	141987	59238
0	0	322679	101138
0	0	199717	107158
0	0	349227	155499
0	0	276709	156274
0	0	273576	121777
0	0	157448	105037
0	0	242782	118661
0	0	256814	131187
0	0	405874	145026
0	0	161189	107016
0	0	156189	87242
0	0	200181	91699
0	0	192645	110087
0	0	249893	145447
0	0	241171	143307
0	0	143182	61678
0	0	285266	210080
0	0	243048	165005
0	0	176062	97806
0	0	305210	184471
0	0	87995	27786
0	0	343613	184458
0	0	264159	98765
0	0	394976	178441
0	0	192718	100619
0	0	114673	58391
0	0	310108	151672
0	0	292891	124437
0	0	157518	79929
0	0	180362	123064
0	0	146175	50466
0	0	140319	100991
0	0	405267	79367
0	0	78800	56968
0	0	201970	106257
0	0	305322	178412
0	0	164733	98520
0	1	199186	153670
0	1	24188	15049
0	1	346142	174478
0	1	65029	25109
0	1	101097	45824
0	1	255082	116772
0	1	287314	189150
1	1	308944	194404
1	1	280943	185881
1	1	225816	67508
1	1	348943	188597
1	1	283283	203618
1	1	199642	87232
1	1	232791	110875
1	1	212262	144756
1	1	201345	129825
1	1	180424	92189
1	1	204450	121158
1	1	197813	96219
1	1	138731	84128
1	1	216153	97960
1	1	73566	23824
1	1	219392	103515
1	1	181728	91313
1	1	150006	85407
1	1	325723	95871
1	1	265348	143846
1	1	202410	155387
1	1	173420	74429
1	1	162366	74004
1	1	136341	71987
1	1	390163	150629
1	1	145905	68580
1	1	238921	119855
1	1	80953	55792
1	1	133301	25157
1	1	138630	90895
1	1	334082	117510
1	1	277542	144774
1	1	170849	77529
1	1	236398	103123
1	1	207178	104669
1	1	157125	82414
1	1	242395	82390
1	1	273632	128446
1	1	178489	111542
1	1	207720	136048
1	1	268066	197257
1	1	349934	162079
1	1	368833	206286
1	1	247804	109858
1	1	265849	182125
1	1	174311	74168
1	1	43287	19630
1	1	176724	88634
1	1	189021	128321
1	1	237531	118936
1	1	279589	127044
1	1	106655	178377
1	1	135798	69581
1	1	290495	168019
1	1	266805	113598
1	1	23623	5841
1	1	174970	93116
1	1	61857	24610
1	1	147760	60611
1	1	358662	226620
1	1	21054	6622
1	1	230091	121996
1	1	31414	13155
1	1	284519	154158
1	1	209481	78489
1	1	161691	22007
1	1	137093	72530
1	1	38214	13983
1	1	166059	73397
1	1	319346	143878
1	1	186273	119956
1	1	374212	181558
1	1	275578	208236
1	1	368863	237085
1	1	179928	110297
1	1	94381	61394
1	1	251253	81420
1	1	382564	191154
1	1	118033	11798
1	1	370878	135724
1	1	147989	68614
1	1	236370	139926
1	1	193220	105203
1	1	189020	80338
1	1	341992	121376
1	1	224936	124922
1	1	173260	10901
1	1	286161	135471
1	1	130908	66395
1	1	209639	134041
1	1	262412	153554
1	1	1	0
1	1	14688	7953
1	1	98	0
1	1	455	0
1	1	0	0
1	1	0	0
1	1	195822	98922
1	1	347930	165395
1	1	0	0
1	1	203	0
1	1	7199	4245
1	1	46660	21509
1	1	17547	7670
1	1	107465	15167
1	1	969	0
1	1	179994	63891




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time5 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net

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

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

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

As an alternative you can also use a QR Code:  

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

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time5 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net







Goodness of Fit
Correlation0.8745
R-squared0.7648
RMSE49515.1377

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8745[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7648[/C][/ROW]
[ROW][C]RMSE[/C][C]49515.1377[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=198001&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=198001&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.8745
R-squared0.7648
RMSE49515.1377







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1264530300632.608695652-36102.6086956522
2135248196748.384615385-61500.3846153846
3207253196748.38461538510504.6153846154
4202898196748.3846153856149.61538461538
5145249196748.384615385-51499.3846153846
66529587647.65-22352.65
7439387300632.608695652138754.391304348
8331868501.6428571428624684.3571428571
9183696196748.384615385-13052.3846153846
10190673196748.384615385-6075.38461538462
11287239300632.608695652-13393.6086956522
12205260196748.3846153858511.61538461538
13141987147262.833333333-5275.83333333334
14322679196748.384615385125930.615384615
15199717196748.3846153852968.61538461538
16349227300632.60869565248594.3913043478
17276709300632.608695652-23923.6086956522
18273576245990.727585.3
19157448196748.384615385-39300.3846153846
20242782245990.7-3208.70000000001
21256814245990.710823.3
22405874300632.608695652105241.391304348
23161189196748.384615385-35559.3846153846
24156189196748.384615385-40559.3846153846
25200181196748.3846153853432.61538461538
26192645196748.384615385-4103.38461538462
27249893300632.608695652-50739.6086956522
28241171300632.608695652-59461.6086956522
29143182147262.833333333-4080.83333333334
30285266300632.608695652-15366.6086956522
31243048300632.608695652-57584.6086956522
32176062196748.384615385-20686.3846153846
33305210300632.6086956524577.39130434784
348799587647.65347.350000000006
35343613300632.60869565242980.3913043478
36264159196748.38461538567410.6153846154
37394976300632.60869565294343.3913043478
38192718196748.384615385-4030.38461538462
3911467387647.6527025.35
40310108300632.6086956529475.39130434784
41292891245990.746900.3
42157518196748.384615385-39230.3846153846
43180362245990.7-65628.7
4414617587647.6558527.35
45140319196748.384615385-56429.3846153846
46405267196748.384615385208518.615384615
477880087647.65-8847.64999999999
48201970196748.3846153855221.61538461538
49305322300632.6086956524689.39130434784
50164733196748.384615385-32015.3846153846
51199186300632.608695652-101446.608695652
522418887647.65-63459.65
53346142300632.60869565245509.3913043478
546502987647.65-22618.65
5510109787647.6513449.35
56255082245990.79091.29999999999
57287314300632.608695652-13318.6086956522
58308944300632.6086956528311.39130434784
59280943300632.608695652-19689.6086956522
60225816147262.83333333378553.1666666667
61348943300632.60869565248310.3913043478
62283283300632.608695652-17349.6086956522
63199642196748.3846153852893.61538461538
64232791196748.38461538536042.6153846154
65212262300632.608695652-88370.6086956522
66201345245990.7-44645.7
67180424196748.384615385-16324.3846153846
68204450245990.7-41540.7
69197813196748.3846153851064.61538461538
70138731196748.384615385-58017.3846153846
71216153196748.38461538519404.6153846154
727356687647.65-14081.65
73219392196748.38461538522643.6153846154
74181728196748.384615385-15020.3846153846
75150006196748.384615385-46742.3846153846
76325723196748.384615385128974.615384615
77265348300632.608695652-35284.6086956522
78202410300632.608695652-98222.6086956522
79173420196748.384615385-23328.3846153846
80162366196748.384615385-34382.3846153846
81136341147262.833333333-10921.8333333333
82390163300632.60869565289530.3913043478
83145905147262.833333333-1357.83333333334
84238921245990.7-7069.70000000001
858095387647.65-6694.64999999999
8613330187647.6545653.35
87138630196748.384615385-58118.3846153846
88334082245990.788091.3
89277542300632.608695652-23090.6086956522
90170849196748.384615385-25899.3846153846
91236398196748.38461538539649.6153846154
92207178196748.38461538510429.6153846154
93157125196748.384615385-39623.3846153846
94242395196748.38461538545646.6153846154
95273632245990.727641.3
96178489196748.384615385-18259.3846153846
97207720300632.608695652-92912.6086956522
98268066300632.608695652-32566.6086956522
99349934300632.60869565249301.3913043478
100368833300632.60869565268200.3913043478
101247804196748.38461538551055.6153846154
102265849300632.608695652-34783.6086956522
103174311196748.384615385-22437.3846153846
1044328787647.65-44360.65
105176724196748.384615385-20024.3846153846
106189021245990.7-56969.7
107237531245990.7-8459.70000000001
108279589245990.733598.3
109106655300632.608695652-193977.608695652
110135798147262.833333333-11464.8333333333
111290495300632.608695652-10137.6086956522
112266805245990.720814.3
113236238501.6428571428615121.3571428571
114174970196748.384615385-21778.3846153846
1156185787647.65-25790.65
116147760147262.833333333497.166666666657
117358662300632.60869565258029.3913043478
118210548501.6428571428612552.3571428571
119230091245990.7-15899.7
1203141487647.65-56233.65
121284519300632.608695652-16113.6086956522
122209481196748.38461538512732.6153846154
12316169187647.6574043.35
124137093147262.833333333-10169.8333333333
1253821487647.65-49433.65
126166059196748.384615385-30689.3846153846
127319346300632.60869565218713.3913043478
128186273245990.7-59717.7
129374212300632.60869565273579.3913043478
130275578300632.608695652-25054.6086956522
131368863300632.60869565268230.3913043478
132179928196748.384615385-16820.3846153846
13394381147262.833333333-52881.8333333333
134251253196748.38461538554504.6153846154
135382564300632.60869565281931.3913043478
13611803387647.6530385.35
137370878300632.60869565270245.3913043478
138147989147262.833333333726.166666666657
139236370300632.608695652-64262.6086956522
140193220196748.384615385-3528.38461538462
141189020196748.384615385-7728.38461538462
142341992245990.796001.3
143224936245990.7-21054.7
14417326087647.6585612.35
145286161300632.608695652-14471.6086956522
146130908147262.833333333-16354.8333333333
147209639245990.7-36351.7
148262412300632.608695652-38220.6086956522
14918501.64285714286-8500.64285714286
150146888501.642857142866186.35714285714
151988501.64285714286-8403.64285714286
1524558501.64285714286-8046.64285714286
15308501.64285714286-8501.64285714286
15408501.64285714286-8501.64285714286
155195822196748.384615385-926.384615384624
156347930300632.60869565247297.3913043478
15708501.64285714286-8501.64285714286
1582038501.64285714286-8298.64285714286
15971998501.64285714286-1302.64285714286
1604666087647.65-40987.65
161175478501.642857142869045.35714285714
16210746587647.6519817.35
1639698501.64285714286-7532.64285714286
164179994147262.83333333332731.1666666667

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 264530 & 300632.608695652 & -36102.6086956522 \tabularnewline
2 & 135248 & 196748.384615385 & -61500.3846153846 \tabularnewline
3 & 207253 & 196748.384615385 & 10504.6153846154 \tabularnewline
4 & 202898 & 196748.384615385 & 6149.61538461538 \tabularnewline
5 & 145249 & 196748.384615385 & -51499.3846153846 \tabularnewline
6 & 65295 & 87647.65 & -22352.65 \tabularnewline
7 & 439387 & 300632.608695652 & 138754.391304348 \tabularnewline
8 & 33186 & 8501.64285714286 & 24684.3571428571 \tabularnewline
9 & 183696 & 196748.384615385 & -13052.3846153846 \tabularnewline
10 & 190673 & 196748.384615385 & -6075.38461538462 \tabularnewline
11 & 287239 & 300632.608695652 & -13393.6086956522 \tabularnewline
12 & 205260 & 196748.384615385 & 8511.61538461538 \tabularnewline
13 & 141987 & 147262.833333333 & -5275.83333333334 \tabularnewline
14 & 322679 & 196748.384615385 & 125930.615384615 \tabularnewline
15 & 199717 & 196748.384615385 & 2968.61538461538 \tabularnewline
16 & 349227 & 300632.608695652 & 48594.3913043478 \tabularnewline
17 & 276709 & 300632.608695652 & -23923.6086956522 \tabularnewline
18 & 273576 & 245990.7 & 27585.3 \tabularnewline
19 & 157448 & 196748.384615385 & -39300.3846153846 \tabularnewline
20 & 242782 & 245990.7 & -3208.70000000001 \tabularnewline
21 & 256814 & 245990.7 & 10823.3 \tabularnewline
22 & 405874 & 300632.608695652 & 105241.391304348 \tabularnewline
23 & 161189 & 196748.384615385 & -35559.3846153846 \tabularnewline
24 & 156189 & 196748.384615385 & -40559.3846153846 \tabularnewline
25 & 200181 & 196748.384615385 & 3432.61538461538 \tabularnewline
26 & 192645 & 196748.384615385 & -4103.38461538462 \tabularnewline
27 & 249893 & 300632.608695652 & -50739.6086956522 \tabularnewline
28 & 241171 & 300632.608695652 & -59461.6086956522 \tabularnewline
29 & 143182 & 147262.833333333 & -4080.83333333334 \tabularnewline
30 & 285266 & 300632.608695652 & -15366.6086956522 \tabularnewline
31 & 243048 & 300632.608695652 & -57584.6086956522 \tabularnewline
32 & 176062 & 196748.384615385 & -20686.3846153846 \tabularnewline
33 & 305210 & 300632.608695652 & 4577.39130434784 \tabularnewline
34 & 87995 & 87647.65 & 347.350000000006 \tabularnewline
35 & 343613 & 300632.608695652 & 42980.3913043478 \tabularnewline
36 & 264159 & 196748.384615385 & 67410.6153846154 \tabularnewline
37 & 394976 & 300632.608695652 & 94343.3913043478 \tabularnewline
38 & 192718 & 196748.384615385 & -4030.38461538462 \tabularnewline
39 & 114673 & 87647.65 & 27025.35 \tabularnewline
40 & 310108 & 300632.608695652 & 9475.39130434784 \tabularnewline
41 & 292891 & 245990.7 & 46900.3 \tabularnewline
42 & 157518 & 196748.384615385 & -39230.3846153846 \tabularnewline
43 & 180362 & 245990.7 & -65628.7 \tabularnewline
44 & 146175 & 87647.65 & 58527.35 \tabularnewline
45 & 140319 & 196748.384615385 & -56429.3846153846 \tabularnewline
46 & 405267 & 196748.384615385 & 208518.615384615 \tabularnewline
47 & 78800 & 87647.65 & -8847.64999999999 \tabularnewline
48 & 201970 & 196748.384615385 & 5221.61538461538 \tabularnewline
49 & 305322 & 300632.608695652 & 4689.39130434784 \tabularnewline
50 & 164733 & 196748.384615385 & -32015.3846153846 \tabularnewline
51 & 199186 & 300632.608695652 & -101446.608695652 \tabularnewline
52 & 24188 & 87647.65 & -63459.65 \tabularnewline
53 & 346142 & 300632.608695652 & 45509.3913043478 \tabularnewline
54 & 65029 & 87647.65 & -22618.65 \tabularnewline
55 & 101097 & 87647.65 & 13449.35 \tabularnewline
56 & 255082 & 245990.7 & 9091.29999999999 \tabularnewline
57 & 287314 & 300632.608695652 & -13318.6086956522 \tabularnewline
58 & 308944 & 300632.608695652 & 8311.39130434784 \tabularnewline
59 & 280943 & 300632.608695652 & -19689.6086956522 \tabularnewline
60 & 225816 & 147262.833333333 & 78553.1666666667 \tabularnewline
61 & 348943 & 300632.608695652 & 48310.3913043478 \tabularnewline
62 & 283283 & 300632.608695652 & -17349.6086956522 \tabularnewline
63 & 199642 & 196748.384615385 & 2893.61538461538 \tabularnewline
64 & 232791 & 196748.384615385 & 36042.6153846154 \tabularnewline
65 & 212262 & 300632.608695652 & -88370.6086956522 \tabularnewline
66 & 201345 & 245990.7 & -44645.7 \tabularnewline
67 & 180424 & 196748.384615385 & -16324.3846153846 \tabularnewline
68 & 204450 & 245990.7 & -41540.7 \tabularnewline
69 & 197813 & 196748.384615385 & 1064.61538461538 \tabularnewline
70 & 138731 & 196748.384615385 & -58017.3846153846 \tabularnewline
71 & 216153 & 196748.384615385 & 19404.6153846154 \tabularnewline
72 & 73566 & 87647.65 & -14081.65 \tabularnewline
73 & 219392 & 196748.384615385 & 22643.6153846154 \tabularnewline
74 & 181728 & 196748.384615385 & -15020.3846153846 \tabularnewline
75 & 150006 & 196748.384615385 & -46742.3846153846 \tabularnewline
76 & 325723 & 196748.384615385 & 128974.615384615 \tabularnewline
77 & 265348 & 300632.608695652 & -35284.6086956522 \tabularnewline
78 & 202410 & 300632.608695652 & -98222.6086956522 \tabularnewline
79 & 173420 & 196748.384615385 & -23328.3846153846 \tabularnewline
80 & 162366 & 196748.384615385 & -34382.3846153846 \tabularnewline
81 & 136341 & 147262.833333333 & -10921.8333333333 \tabularnewline
82 & 390163 & 300632.608695652 & 89530.3913043478 \tabularnewline
83 & 145905 & 147262.833333333 & -1357.83333333334 \tabularnewline
84 & 238921 & 245990.7 & -7069.70000000001 \tabularnewline
85 & 80953 & 87647.65 & -6694.64999999999 \tabularnewline
86 & 133301 & 87647.65 & 45653.35 \tabularnewline
87 & 138630 & 196748.384615385 & -58118.3846153846 \tabularnewline
88 & 334082 & 245990.7 & 88091.3 \tabularnewline
89 & 277542 & 300632.608695652 & -23090.6086956522 \tabularnewline
90 & 170849 & 196748.384615385 & -25899.3846153846 \tabularnewline
91 & 236398 & 196748.384615385 & 39649.6153846154 \tabularnewline
92 & 207178 & 196748.384615385 & 10429.6153846154 \tabularnewline
93 & 157125 & 196748.384615385 & -39623.3846153846 \tabularnewline
94 & 242395 & 196748.384615385 & 45646.6153846154 \tabularnewline
95 & 273632 & 245990.7 & 27641.3 \tabularnewline
96 & 178489 & 196748.384615385 & -18259.3846153846 \tabularnewline
97 & 207720 & 300632.608695652 & -92912.6086956522 \tabularnewline
98 & 268066 & 300632.608695652 & -32566.6086956522 \tabularnewline
99 & 349934 & 300632.608695652 & 49301.3913043478 \tabularnewline
100 & 368833 & 300632.608695652 & 68200.3913043478 \tabularnewline
101 & 247804 & 196748.384615385 & 51055.6153846154 \tabularnewline
102 & 265849 & 300632.608695652 & -34783.6086956522 \tabularnewline
103 & 174311 & 196748.384615385 & -22437.3846153846 \tabularnewline
104 & 43287 & 87647.65 & -44360.65 \tabularnewline
105 & 176724 & 196748.384615385 & -20024.3846153846 \tabularnewline
106 & 189021 & 245990.7 & -56969.7 \tabularnewline
107 & 237531 & 245990.7 & -8459.70000000001 \tabularnewline
108 & 279589 & 245990.7 & 33598.3 \tabularnewline
109 & 106655 & 300632.608695652 & -193977.608695652 \tabularnewline
110 & 135798 & 147262.833333333 & -11464.8333333333 \tabularnewline
111 & 290495 & 300632.608695652 & -10137.6086956522 \tabularnewline
112 & 266805 & 245990.7 & 20814.3 \tabularnewline
113 & 23623 & 8501.64285714286 & 15121.3571428571 \tabularnewline
114 & 174970 & 196748.384615385 & -21778.3846153846 \tabularnewline
115 & 61857 & 87647.65 & -25790.65 \tabularnewline
116 & 147760 & 147262.833333333 & 497.166666666657 \tabularnewline
117 & 358662 & 300632.608695652 & 58029.3913043478 \tabularnewline
118 & 21054 & 8501.64285714286 & 12552.3571428571 \tabularnewline
119 & 230091 & 245990.7 & -15899.7 \tabularnewline
120 & 31414 & 87647.65 & -56233.65 \tabularnewline
121 & 284519 & 300632.608695652 & -16113.6086956522 \tabularnewline
122 & 209481 & 196748.384615385 & 12732.6153846154 \tabularnewline
123 & 161691 & 87647.65 & 74043.35 \tabularnewline
124 & 137093 & 147262.833333333 & -10169.8333333333 \tabularnewline
125 & 38214 & 87647.65 & -49433.65 \tabularnewline
126 & 166059 & 196748.384615385 & -30689.3846153846 \tabularnewline
127 & 319346 & 300632.608695652 & 18713.3913043478 \tabularnewline
128 & 186273 & 245990.7 & -59717.7 \tabularnewline
129 & 374212 & 300632.608695652 & 73579.3913043478 \tabularnewline
130 & 275578 & 300632.608695652 & -25054.6086956522 \tabularnewline
131 & 368863 & 300632.608695652 & 68230.3913043478 \tabularnewline
132 & 179928 & 196748.384615385 & -16820.3846153846 \tabularnewline
133 & 94381 & 147262.833333333 & -52881.8333333333 \tabularnewline
134 & 251253 & 196748.384615385 & 54504.6153846154 \tabularnewline
135 & 382564 & 300632.608695652 & 81931.3913043478 \tabularnewline
136 & 118033 & 87647.65 & 30385.35 \tabularnewline
137 & 370878 & 300632.608695652 & 70245.3913043478 \tabularnewline
138 & 147989 & 147262.833333333 & 726.166666666657 \tabularnewline
139 & 236370 & 300632.608695652 & -64262.6086956522 \tabularnewline
140 & 193220 & 196748.384615385 & -3528.38461538462 \tabularnewline
141 & 189020 & 196748.384615385 & -7728.38461538462 \tabularnewline
142 & 341992 & 245990.7 & 96001.3 \tabularnewline
143 & 224936 & 245990.7 & -21054.7 \tabularnewline
144 & 173260 & 87647.65 & 85612.35 \tabularnewline
145 & 286161 & 300632.608695652 & -14471.6086956522 \tabularnewline
146 & 130908 & 147262.833333333 & -16354.8333333333 \tabularnewline
147 & 209639 & 245990.7 & -36351.7 \tabularnewline
148 & 262412 & 300632.608695652 & -38220.6086956522 \tabularnewline
149 & 1 & 8501.64285714286 & -8500.64285714286 \tabularnewline
150 & 14688 & 8501.64285714286 & 6186.35714285714 \tabularnewline
151 & 98 & 8501.64285714286 & -8403.64285714286 \tabularnewline
152 & 455 & 8501.64285714286 & -8046.64285714286 \tabularnewline
153 & 0 & 8501.64285714286 & -8501.64285714286 \tabularnewline
154 & 0 & 8501.64285714286 & -8501.64285714286 \tabularnewline
155 & 195822 & 196748.384615385 & -926.384615384624 \tabularnewline
156 & 347930 & 300632.608695652 & 47297.3913043478 \tabularnewline
157 & 0 & 8501.64285714286 & -8501.64285714286 \tabularnewline
158 & 203 & 8501.64285714286 & -8298.64285714286 \tabularnewline
159 & 7199 & 8501.64285714286 & -1302.64285714286 \tabularnewline
160 & 46660 & 87647.65 & -40987.65 \tabularnewline
161 & 17547 & 8501.64285714286 & 9045.35714285714 \tabularnewline
162 & 107465 & 87647.65 & 19817.35 \tabularnewline
163 & 969 & 8501.64285714286 & -7532.64285714286 \tabularnewline
164 & 179994 & 147262.833333333 & 32731.1666666667 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=198001&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]300632.608695652[/C][C]-36102.6086956522[/C][/ROW]
[ROW][C]2[/C][C]135248[/C][C]196748.384615385[/C][C]-61500.3846153846[/C][/ROW]
[ROW][C]3[/C][C]207253[/C][C]196748.384615385[/C][C]10504.6153846154[/C][/ROW]
[ROW][C]4[/C][C]202898[/C][C]196748.384615385[/C][C]6149.61538461538[/C][/ROW]
[ROW][C]5[/C][C]145249[/C][C]196748.384615385[/C][C]-51499.3846153846[/C][/ROW]
[ROW][C]6[/C][C]65295[/C][C]87647.65[/C][C]-22352.65[/C][/ROW]
[ROW][C]7[/C][C]439387[/C][C]300632.608695652[/C][C]138754.391304348[/C][/ROW]
[ROW][C]8[/C][C]33186[/C][C]8501.64285714286[/C][C]24684.3571428571[/C][/ROW]
[ROW][C]9[/C][C]183696[/C][C]196748.384615385[/C][C]-13052.3846153846[/C][/ROW]
[ROW][C]10[/C][C]190673[/C][C]196748.384615385[/C][C]-6075.38461538462[/C][/ROW]
[ROW][C]11[/C][C]287239[/C][C]300632.608695652[/C][C]-13393.6086956522[/C][/ROW]
[ROW][C]12[/C][C]205260[/C][C]196748.384615385[/C][C]8511.61538461538[/C][/ROW]
[ROW][C]13[/C][C]141987[/C][C]147262.833333333[/C][C]-5275.83333333334[/C][/ROW]
[ROW][C]14[/C][C]322679[/C][C]196748.384615385[/C][C]125930.615384615[/C][/ROW]
[ROW][C]15[/C][C]199717[/C][C]196748.384615385[/C][C]2968.61538461538[/C][/ROW]
[ROW][C]16[/C][C]349227[/C][C]300632.608695652[/C][C]48594.3913043478[/C][/ROW]
[ROW][C]17[/C][C]276709[/C][C]300632.608695652[/C][C]-23923.6086956522[/C][/ROW]
[ROW][C]18[/C][C]273576[/C][C]245990.7[/C][C]27585.3[/C][/ROW]
[ROW][C]19[/C][C]157448[/C][C]196748.384615385[/C][C]-39300.3846153846[/C][/ROW]
[ROW][C]20[/C][C]242782[/C][C]245990.7[/C][C]-3208.70000000001[/C][/ROW]
[ROW][C]21[/C][C]256814[/C][C]245990.7[/C][C]10823.3[/C][/ROW]
[ROW][C]22[/C][C]405874[/C][C]300632.608695652[/C][C]105241.391304348[/C][/ROW]
[ROW][C]23[/C][C]161189[/C][C]196748.384615385[/C][C]-35559.3846153846[/C][/ROW]
[ROW][C]24[/C][C]156189[/C][C]196748.384615385[/C][C]-40559.3846153846[/C][/ROW]
[ROW][C]25[/C][C]200181[/C][C]196748.384615385[/C][C]3432.61538461538[/C][/ROW]
[ROW][C]26[/C][C]192645[/C][C]196748.384615385[/C][C]-4103.38461538462[/C][/ROW]
[ROW][C]27[/C][C]249893[/C][C]300632.608695652[/C][C]-50739.6086956522[/C][/ROW]
[ROW][C]28[/C][C]241171[/C][C]300632.608695652[/C][C]-59461.6086956522[/C][/ROW]
[ROW][C]29[/C][C]143182[/C][C]147262.833333333[/C][C]-4080.83333333334[/C][/ROW]
[ROW][C]30[/C][C]285266[/C][C]300632.608695652[/C][C]-15366.6086956522[/C][/ROW]
[ROW][C]31[/C][C]243048[/C][C]300632.608695652[/C][C]-57584.6086956522[/C][/ROW]
[ROW][C]32[/C][C]176062[/C][C]196748.384615385[/C][C]-20686.3846153846[/C][/ROW]
[ROW][C]33[/C][C]305210[/C][C]300632.608695652[/C][C]4577.39130434784[/C][/ROW]
[ROW][C]34[/C][C]87995[/C][C]87647.65[/C][C]347.350000000006[/C][/ROW]
[ROW][C]35[/C][C]343613[/C][C]300632.608695652[/C][C]42980.3913043478[/C][/ROW]
[ROW][C]36[/C][C]264159[/C][C]196748.384615385[/C][C]67410.6153846154[/C][/ROW]
[ROW][C]37[/C][C]394976[/C][C]300632.608695652[/C][C]94343.3913043478[/C][/ROW]
[ROW][C]38[/C][C]192718[/C][C]196748.384615385[/C][C]-4030.38461538462[/C][/ROW]
[ROW][C]39[/C][C]114673[/C][C]87647.65[/C][C]27025.35[/C][/ROW]
[ROW][C]40[/C][C]310108[/C][C]300632.608695652[/C][C]9475.39130434784[/C][/ROW]
[ROW][C]41[/C][C]292891[/C][C]245990.7[/C][C]46900.3[/C][/ROW]
[ROW][C]42[/C][C]157518[/C][C]196748.384615385[/C][C]-39230.3846153846[/C][/ROW]
[ROW][C]43[/C][C]180362[/C][C]245990.7[/C][C]-65628.7[/C][/ROW]
[ROW][C]44[/C][C]146175[/C][C]87647.65[/C][C]58527.35[/C][/ROW]
[ROW][C]45[/C][C]140319[/C][C]196748.384615385[/C][C]-56429.3846153846[/C][/ROW]
[ROW][C]46[/C][C]405267[/C][C]196748.384615385[/C][C]208518.615384615[/C][/ROW]
[ROW][C]47[/C][C]78800[/C][C]87647.65[/C][C]-8847.64999999999[/C][/ROW]
[ROW][C]48[/C][C]201970[/C][C]196748.384615385[/C][C]5221.61538461538[/C][/ROW]
[ROW][C]49[/C][C]305322[/C][C]300632.608695652[/C][C]4689.39130434784[/C][/ROW]
[ROW][C]50[/C][C]164733[/C][C]196748.384615385[/C][C]-32015.3846153846[/C][/ROW]
[ROW][C]51[/C][C]199186[/C][C]300632.608695652[/C][C]-101446.608695652[/C][/ROW]
[ROW][C]52[/C][C]24188[/C][C]87647.65[/C][C]-63459.65[/C][/ROW]
[ROW][C]53[/C][C]346142[/C][C]300632.608695652[/C][C]45509.3913043478[/C][/ROW]
[ROW][C]54[/C][C]65029[/C][C]87647.65[/C][C]-22618.65[/C][/ROW]
[ROW][C]55[/C][C]101097[/C][C]87647.65[/C][C]13449.35[/C][/ROW]
[ROW][C]56[/C][C]255082[/C][C]245990.7[/C][C]9091.29999999999[/C][/ROW]
[ROW][C]57[/C][C]287314[/C][C]300632.608695652[/C][C]-13318.6086956522[/C][/ROW]
[ROW][C]58[/C][C]308944[/C][C]300632.608695652[/C][C]8311.39130434784[/C][/ROW]
[ROW][C]59[/C][C]280943[/C][C]300632.608695652[/C][C]-19689.6086956522[/C][/ROW]
[ROW][C]60[/C][C]225816[/C][C]147262.833333333[/C][C]78553.1666666667[/C][/ROW]
[ROW][C]61[/C][C]348943[/C][C]300632.608695652[/C][C]48310.3913043478[/C][/ROW]
[ROW][C]62[/C][C]283283[/C][C]300632.608695652[/C][C]-17349.6086956522[/C][/ROW]
[ROW][C]63[/C][C]199642[/C][C]196748.384615385[/C][C]2893.61538461538[/C][/ROW]
[ROW][C]64[/C][C]232791[/C][C]196748.384615385[/C][C]36042.6153846154[/C][/ROW]
[ROW][C]65[/C][C]212262[/C][C]300632.608695652[/C][C]-88370.6086956522[/C][/ROW]
[ROW][C]66[/C][C]201345[/C][C]245990.7[/C][C]-44645.7[/C][/ROW]
[ROW][C]67[/C][C]180424[/C][C]196748.384615385[/C][C]-16324.3846153846[/C][/ROW]
[ROW][C]68[/C][C]204450[/C][C]245990.7[/C][C]-41540.7[/C][/ROW]
[ROW][C]69[/C][C]197813[/C][C]196748.384615385[/C][C]1064.61538461538[/C][/ROW]
[ROW][C]70[/C][C]138731[/C][C]196748.384615385[/C][C]-58017.3846153846[/C][/ROW]
[ROW][C]71[/C][C]216153[/C][C]196748.384615385[/C][C]19404.6153846154[/C][/ROW]
[ROW][C]72[/C][C]73566[/C][C]87647.65[/C][C]-14081.65[/C][/ROW]
[ROW][C]73[/C][C]219392[/C][C]196748.384615385[/C][C]22643.6153846154[/C][/ROW]
[ROW][C]74[/C][C]181728[/C][C]196748.384615385[/C][C]-15020.3846153846[/C][/ROW]
[ROW][C]75[/C][C]150006[/C][C]196748.384615385[/C][C]-46742.3846153846[/C][/ROW]
[ROW][C]76[/C][C]325723[/C][C]196748.384615385[/C][C]128974.615384615[/C][/ROW]
[ROW][C]77[/C][C]265348[/C][C]300632.608695652[/C][C]-35284.6086956522[/C][/ROW]
[ROW][C]78[/C][C]202410[/C][C]300632.608695652[/C][C]-98222.6086956522[/C][/ROW]
[ROW][C]79[/C][C]173420[/C][C]196748.384615385[/C][C]-23328.3846153846[/C][/ROW]
[ROW][C]80[/C][C]162366[/C][C]196748.384615385[/C][C]-34382.3846153846[/C][/ROW]
[ROW][C]81[/C][C]136341[/C][C]147262.833333333[/C][C]-10921.8333333333[/C][/ROW]
[ROW][C]82[/C][C]390163[/C][C]300632.608695652[/C][C]89530.3913043478[/C][/ROW]
[ROW][C]83[/C][C]145905[/C][C]147262.833333333[/C][C]-1357.83333333334[/C][/ROW]
[ROW][C]84[/C][C]238921[/C][C]245990.7[/C][C]-7069.70000000001[/C][/ROW]
[ROW][C]85[/C][C]80953[/C][C]87647.65[/C][C]-6694.64999999999[/C][/ROW]
[ROW][C]86[/C][C]133301[/C][C]87647.65[/C][C]45653.35[/C][/ROW]
[ROW][C]87[/C][C]138630[/C][C]196748.384615385[/C][C]-58118.3846153846[/C][/ROW]
[ROW][C]88[/C][C]334082[/C][C]245990.7[/C][C]88091.3[/C][/ROW]
[ROW][C]89[/C][C]277542[/C][C]300632.608695652[/C][C]-23090.6086956522[/C][/ROW]
[ROW][C]90[/C][C]170849[/C][C]196748.384615385[/C][C]-25899.3846153846[/C][/ROW]
[ROW][C]91[/C][C]236398[/C][C]196748.384615385[/C][C]39649.6153846154[/C][/ROW]
[ROW][C]92[/C][C]207178[/C][C]196748.384615385[/C][C]10429.6153846154[/C][/ROW]
[ROW][C]93[/C][C]157125[/C][C]196748.384615385[/C][C]-39623.3846153846[/C][/ROW]
[ROW][C]94[/C][C]242395[/C][C]196748.384615385[/C][C]45646.6153846154[/C][/ROW]
[ROW][C]95[/C][C]273632[/C][C]245990.7[/C][C]27641.3[/C][/ROW]
[ROW][C]96[/C][C]178489[/C][C]196748.384615385[/C][C]-18259.3846153846[/C][/ROW]
[ROW][C]97[/C][C]207720[/C][C]300632.608695652[/C][C]-92912.6086956522[/C][/ROW]
[ROW][C]98[/C][C]268066[/C][C]300632.608695652[/C][C]-32566.6086956522[/C][/ROW]
[ROW][C]99[/C][C]349934[/C][C]300632.608695652[/C][C]49301.3913043478[/C][/ROW]
[ROW][C]100[/C][C]368833[/C][C]300632.608695652[/C][C]68200.3913043478[/C][/ROW]
[ROW][C]101[/C][C]247804[/C][C]196748.384615385[/C][C]51055.6153846154[/C][/ROW]
[ROW][C]102[/C][C]265849[/C][C]300632.608695652[/C][C]-34783.6086956522[/C][/ROW]
[ROW][C]103[/C][C]174311[/C][C]196748.384615385[/C][C]-22437.3846153846[/C][/ROW]
[ROW][C]104[/C][C]43287[/C][C]87647.65[/C][C]-44360.65[/C][/ROW]
[ROW][C]105[/C][C]176724[/C][C]196748.384615385[/C][C]-20024.3846153846[/C][/ROW]
[ROW][C]106[/C][C]189021[/C][C]245990.7[/C][C]-56969.7[/C][/ROW]
[ROW][C]107[/C][C]237531[/C][C]245990.7[/C][C]-8459.70000000001[/C][/ROW]
[ROW][C]108[/C][C]279589[/C][C]245990.7[/C][C]33598.3[/C][/ROW]
[ROW][C]109[/C][C]106655[/C][C]300632.608695652[/C][C]-193977.608695652[/C][/ROW]
[ROW][C]110[/C][C]135798[/C][C]147262.833333333[/C][C]-11464.8333333333[/C][/ROW]
[ROW][C]111[/C][C]290495[/C][C]300632.608695652[/C][C]-10137.6086956522[/C][/ROW]
[ROW][C]112[/C][C]266805[/C][C]245990.7[/C][C]20814.3[/C][/ROW]
[ROW][C]113[/C][C]23623[/C][C]8501.64285714286[/C][C]15121.3571428571[/C][/ROW]
[ROW][C]114[/C][C]174970[/C][C]196748.384615385[/C][C]-21778.3846153846[/C][/ROW]
[ROW][C]115[/C][C]61857[/C][C]87647.65[/C][C]-25790.65[/C][/ROW]
[ROW][C]116[/C][C]147760[/C][C]147262.833333333[/C][C]497.166666666657[/C][/ROW]
[ROW][C]117[/C][C]358662[/C][C]300632.608695652[/C][C]58029.3913043478[/C][/ROW]
[ROW][C]118[/C][C]21054[/C][C]8501.64285714286[/C][C]12552.3571428571[/C][/ROW]
[ROW][C]119[/C][C]230091[/C][C]245990.7[/C][C]-15899.7[/C][/ROW]
[ROW][C]120[/C][C]31414[/C][C]87647.65[/C][C]-56233.65[/C][/ROW]
[ROW][C]121[/C][C]284519[/C][C]300632.608695652[/C][C]-16113.6086956522[/C][/ROW]
[ROW][C]122[/C][C]209481[/C][C]196748.384615385[/C][C]12732.6153846154[/C][/ROW]
[ROW][C]123[/C][C]161691[/C][C]87647.65[/C][C]74043.35[/C][/ROW]
[ROW][C]124[/C][C]137093[/C][C]147262.833333333[/C][C]-10169.8333333333[/C][/ROW]
[ROW][C]125[/C][C]38214[/C][C]87647.65[/C][C]-49433.65[/C][/ROW]
[ROW][C]126[/C][C]166059[/C][C]196748.384615385[/C][C]-30689.3846153846[/C][/ROW]
[ROW][C]127[/C][C]319346[/C][C]300632.608695652[/C][C]18713.3913043478[/C][/ROW]
[ROW][C]128[/C][C]186273[/C][C]245990.7[/C][C]-59717.7[/C][/ROW]
[ROW][C]129[/C][C]374212[/C][C]300632.608695652[/C][C]73579.3913043478[/C][/ROW]
[ROW][C]130[/C][C]275578[/C][C]300632.608695652[/C][C]-25054.6086956522[/C][/ROW]
[ROW][C]131[/C][C]368863[/C][C]300632.608695652[/C][C]68230.3913043478[/C][/ROW]
[ROW][C]132[/C][C]179928[/C][C]196748.384615385[/C][C]-16820.3846153846[/C][/ROW]
[ROW][C]133[/C][C]94381[/C][C]147262.833333333[/C][C]-52881.8333333333[/C][/ROW]
[ROW][C]134[/C][C]251253[/C][C]196748.384615385[/C][C]54504.6153846154[/C][/ROW]
[ROW][C]135[/C][C]382564[/C][C]300632.608695652[/C][C]81931.3913043478[/C][/ROW]
[ROW][C]136[/C][C]118033[/C][C]87647.65[/C][C]30385.35[/C][/ROW]
[ROW][C]137[/C][C]370878[/C][C]300632.608695652[/C][C]70245.3913043478[/C][/ROW]
[ROW][C]138[/C][C]147989[/C][C]147262.833333333[/C][C]726.166666666657[/C][/ROW]
[ROW][C]139[/C][C]236370[/C][C]300632.608695652[/C][C]-64262.6086956522[/C][/ROW]
[ROW][C]140[/C][C]193220[/C][C]196748.384615385[/C][C]-3528.38461538462[/C][/ROW]
[ROW][C]141[/C][C]189020[/C][C]196748.384615385[/C][C]-7728.38461538462[/C][/ROW]
[ROW][C]142[/C][C]341992[/C][C]245990.7[/C][C]96001.3[/C][/ROW]
[ROW][C]143[/C][C]224936[/C][C]245990.7[/C][C]-21054.7[/C][/ROW]
[ROW][C]144[/C][C]173260[/C][C]87647.65[/C][C]85612.35[/C][/ROW]
[ROW][C]145[/C][C]286161[/C][C]300632.608695652[/C][C]-14471.6086956522[/C][/ROW]
[ROW][C]146[/C][C]130908[/C][C]147262.833333333[/C][C]-16354.8333333333[/C][/ROW]
[ROW][C]147[/C][C]209639[/C][C]245990.7[/C][C]-36351.7[/C][/ROW]
[ROW][C]148[/C][C]262412[/C][C]300632.608695652[/C][C]-38220.6086956522[/C][/ROW]
[ROW][C]149[/C][C]1[/C][C]8501.64285714286[/C][C]-8500.64285714286[/C][/ROW]
[ROW][C]150[/C][C]14688[/C][C]8501.64285714286[/C][C]6186.35714285714[/C][/ROW]
[ROW][C]151[/C][C]98[/C][C]8501.64285714286[/C][C]-8403.64285714286[/C][/ROW]
[ROW][C]152[/C][C]455[/C][C]8501.64285714286[/C][C]-8046.64285714286[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]8501.64285714286[/C][C]-8501.64285714286[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]8501.64285714286[/C][C]-8501.64285714286[/C][/ROW]
[ROW][C]155[/C][C]195822[/C][C]196748.384615385[/C][C]-926.384615384624[/C][/ROW]
[ROW][C]156[/C][C]347930[/C][C]300632.608695652[/C][C]47297.3913043478[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]8501.64285714286[/C][C]-8501.64285714286[/C][/ROW]
[ROW][C]158[/C][C]203[/C][C]8501.64285714286[/C][C]-8298.64285714286[/C][/ROW]
[ROW][C]159[/C][C]7199[/C][C]8501.64285714286[/C][C]-1302.64285714286[/C][/ROW]
[ROW][C]160[/C][C]46660[/C][C]87647.65[/C][C]-40987.65[/C][/ROW]
[ROW][C]161[/C][C]17547[/C][C]8501.64285714286[/C][C]9045.35714285714[/C][/ROW]
[ROW][C]162[/C][C]107465[/C][C]87647.65[/C][C]19817.35[/C][/ROW]
[ROW][C]163[/C][C]969[/C][C]8501.64285714286[/C][C]-7532.64285714286[/C][/ROW]
[ROW][C]164[/C][C]179994[/C][C]147262.833333333[/C][C]32731.1666666667[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=198001&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=198001&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
1264530300632.608695652-36102.6086956522
2135248196748.384615385-61500.3846153846
3207253196748.38461538510504.6153846154
4202898196748.3846153856149.61538461538
5145249196748.384615385-51499.3846153846
66529587647.65-22352.65
7439387300632.608695652138754.391304348
8331868501.6428571428624684.3571428571
9183696196748.384615385-13052.3846153846
10190673196748.384615385-6075.38461538462
11287239300632.608695652-13393.6086956522
12205260196748.3846153858511.61538461538
13141987147262.833333333-5275.83333333334
14322679196748.384615385125930.615384615
15199717196748.3846153852968.61538461538
16349227300632.60869565248594.3913043478
17276709300632.608695652-23923.6086956522
18273576245990.727585.3
19157448196748.384615385-39300.3846153846
20242782245990.7-3208.70000000001
21256814245990.710823.3
22405874300632.608695652105241.391304348
23161189196748.384615385-35559.3846153846
24156189196748.384615385-40559.3846153846
25200181196748.3846153853432.61538461538
26192645196748.384615385-4103.38461538462
27249893300632.608695652-50739.6086956522
28241171300632.608695652-59461.6086956522
29143182147262.833333333-4080.83333333334
30285266300632.608695652-15366.6086956522
31243048300632.608695652-57584.6086956522
32176062196748.384615385-20686.3846153846
33305210300632.6086956524577.39130434784
348799587647.65347.350000000006
35343613300632.60869565242980.3913043478
36264159196748.38461538567410.6153846154
37394976300632.60869565294343.3913043478
38192718196748.384615385-4030.38461538462
3911467387647.6527025.35
40310108300632.6086956529475.39130434784
41292891245990.746900.3
42157518196748.384615385-39230.3846153846
43180362245990.7-65628.7
4414617587647.6558527.35
45140319196748.384615385-56429.3846153846
46405267196748.384615385208518.615384615
477880087647.65-8847.64999999999
48201970196748.3846153855221.61538461538
49305322300632.6086956524689.39130434784
50164733196748.384615385-32015.3846153846
51199186300632.608695652-101446.608695652
522418887647.65-63459.65
53346142300632.60869565245509.3913043478
546502987647.65-22618.65
5510109787647.6513449.35
56255082245990.79091.29999999999
57287314300632.608695652-13318.6086956522
58308944300632.6086956528311.39130434784
59280943300632.608695652-19689.6086956522
60225816147262.83333333378553.1666666667
61348943300632.60869565248310.3913043478
62283283300632.608695652-17349.6086956522
63199642196748.3846153852893.61538461538
64232791196748.38461538536042.6153846154
65212262300632.608695652-88370.6086956522
66201345245990.7-44645.7
67180424196748.384615385-16324.3846153846
68204450245990.7-41540.7
69197813196748.3846153851064.61538461538
70138731196748.384615385-58017.3846153846
71216153196748.38461538519404.6153846154
727356687647.65-14081.65
73219392196748.38461538522643.6153846154
74181728196748.384615385-15020.3846153846
75150006196748.384615385-46742.3846153846
76325723196748.384615385128974.615384615
77265348300632.608695652-35284.6086956522
78202410300632.608695652-98222.6086956522
79173420196748.384615385-23328.3846153846
80162366196748.384615385-34382.3846153846
81136341147262.833333333-10921.8333333333
82390163300632.60869565289530.3913043478
83145905147262.833333333-1357.83333333334
84238921245990.7-7069.70000000001
858095387647.65-6694.64999999999
8613330187647.6545653.35
87138630196748.384615385-58118.3846153846
88334082245990.788091.3
89277542300632.608695652-23090.6086956522
90170849196748.384615385-25899.3846153846
91236398196748.38461538539649.6153846154
92207178196748.38461538510429.6153846154
93157125196748.384615385-39623.3846153846
94242395196748.38461538545646.6153846154
95273632245990.727641.3
96178489196748.384615385-18259.3846153846
97207720300632.608695652-92912.6086956522
98268066300632.608695652-32566.6086956522
99349934300632.60869565249301.3913043478
100368833300632.60869565268200.3913043478
101247804196748.38461538551055.6153846154
102265849300632.608695652-34783.6086956522
103174311196748.384615385-22437.3846153846
1044328787647.65-44360.65
105176724196748.384615385-20024.3846153846
106189021245990.7-56969.7
107237531245990.7-8459.70000000001
108279589245990.733598.3
109106655300632.608695652-193977.608695652
110135798147262.833333333-11464.8333333333
111290495300632.608695652-10137.6086956522
112266805245990.720814.3
113236238501.6428571428615121.3571428571
114174970196748.384615385-21778.3846153846
1156185787647.65-25790.65
116147760147262.833333333497.166666666657
117358662300632.60869565258029.3913043478
118210548501.6428571428612552.3571428571
119230091245990.7-15899.7
1203141487647.65-56233.65
121284519300632.608695652-16113.6086956522
122209481196748.38461538512732.6153846154
12316169187647.6574043.35
124137093147262.833333333-10169.8333333333
1253821487647.65-49433.65
126166059196748.384615385-30689.3846153846
127319346300632.60869565218713.3913043478
128186273245990.7-59717.7
129374212300632.60869565273579.3913043478
130275578300632.608695652-25054.6086956522
131368863300632.60869565268230.3913043478
132179928196748.384615385-16820.3846153846
13394381147262.833333333-52881.8333333333
134251253196748.38461538554504.6153846154
135382564300632.60869565281931.3913043478
13611803387647.6530385.35
137370878300632.60869565270245.3913043478
138147989147262.833333333726.166666666657
139236370300632.608695652-64262.6086956522
140193220196748.384615385-3528.38461538462
141189020196748.384615385-7728.38461538462
142341992245990.796001.3
143224936245990.7-21054.7
14417326087647.6585612.35
145286161300632.608695652-14471.6086956522
146130908147262.833333333-16354.8333333333
147209639245990.7-36351.7
148262412300632.608695652-38220.6086956522
14918501.64285714286-8500.64285714286
150146888501.642857142866186.35714285714
151988501.64285714286-8403.64285714286
1524558501.64285714286-8046.64285714286
15308501.64285714286-8501.64285714286
15408501.64285714286-8501.64285714286
155195822196748.384615385-926.384615384624
156347930300632.60869565247297.3913043478
15708501.64285714286-8501.64285714286
1582038501.64285714286-8298.64285714286
15971998501.64285714286-1302.64285714286
1604666087647.65-40987.65
161175478501.642857142869045.35714285714
16210746587647.6519817.35
1639698501.64285714286-7532.64285714286
164179994147262.83333333332731.1666666667



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