Free Statistics

of Irreproducible Research!

Author's title

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

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact107
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 20:21:33] [b98453cac15ba1066b407e146608df68]
- R PD    [Recursive Partitioning (Regression Trees)] [] [2011-12-23 17:07:52] [4e9c66f629a65accb54345f95205ea1a] [Current]
Feedback Forum

Post a new message
Dataseries X:
140824	186099	38	165
110459	113854	34	135
105079	99776	42	121
112098	106194	38	148
43929	100792	27	73
76173	47552	35	49
187326	250931	33	185
22807	6853	18	5
144408	115466	34	125
66485	110896	33	93
79089	169351	46	154
81625	94853	55	98
68788	72591	37	70
103297	101345	55	148
69446	113713	44	100
114948	165354	59	150
167949	164263	36	197
125081	135213	39	114
125818	111669	29	169
136588	134163	51	200
112431	140303	49	148
103037	150773	39	140
82317	111848	25	74
118906	102509	52	128
83515	96785	45	140
104581	116136	38	116
103129	158376	41	147
83243	153990	43	132
37110	64057	32	70
113344	230054	41	144
139165	184531	47	155
86652	114198	50	165
112302	198299	48	161
69652	33750	37	31
119442	189723	43	199
69867	100826	42	78
101629	188355	44	121
70168	104470	36	112
31081	58391	17	41
103925	164808	42	158
92622	134097	39	123
79011	80238	41	104
93487	133252	36	94
64520	54518	47	73
93473	121850	45	52
114360	79367	41	71
33032	56968	26	21
96125	106314	52	155
151911	191889	47	174
89256	104864	45	136
95671	160791	40	128
5950	15049	4	7
149695	191179	44	165
32551	25109	18	21
31701	45824	14	35
100087	129711	37	137
169707	210012	61	174
150491	194679	39	257
120192	197680	42	207
95893	81180	36	103
151715	197765	49	171
176225	214738	28	279
59900	96252	43	83
104767	124527	42	130
114799	153242	37	131
72128	145707	30	126
143592	113963	35	158
89626	134904	44	138
131072	114268	36	200
126817	94333	28	104
81351	102204	45	111
22618	23824	23	26
88977	111563	45	115
92059	91313	38	127
81897	89770	38	140
108146	100125	46	121
126372	165278	36	183
249771	181712	41	68
71154	80906	38	112
71571	75881	37	103
55918	83963	28	63
160141	175721	45	166
38692	68580	26	38
102812	136323	44	163
56622	55792	8	59
15986	25157	27	27
123534	100922	38	108
108535	118845	37	88
93879	170492	57	92
144551	81716	45	170
56750	115750	37	98
127654	105590	40	205
65594	92795	31	96
59938	82390	36	107
146975	135599	40	150
143372	111542	36	123
168553	162519	35	176
183500	211381	39	213
165986	189944	65	208
184923	226168	30	307
140358	117495	51	125
149959	195894	41	208
57224	80684	36	73
43750	19630	19	49
48029	88634	23	82
104978	139292	44	206
100046	128602	40	112
101047	135848	40	139
197426	178377	30	60
160902	106330	41	70
147172	178303	40	112
109432	116938	45	142
1168	5841	1	11
83248	106020	40	130
25162	24610	11	31
45724	74151	45	132
110529	232241	38	219
855	6622	0	4
101382	127097	30	102
14116	13155	8	39
89506	160501	39	125
135356	91502	48	121
116066	24469	48	42
144244	88229	29	111
8773	13983	8	16
102153	80716	43	70
117440	157384	52	162
104128	122975	53	173
134238	191469	48	171
134047	231257	48	172
279488	258287	50	254
79756	122531	40	90
66089	61394	36	50
102070	86480	40	113
146760	195791	46	187
154771	18284	42	16
165933	147581	46	175
64593	72558	39	90
92280	147341	41	140
67150	114651	46	145
128692	100187	32	141
124089	130332	39	125
125386	134218	39	241
37238	10901	21	16
140015	145758	45	175
150047	75767	50	132
154451	134969	36	154
156349	169216	44	198
0	0	0	0
6023	7953	0	5
0	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0
84601	105406	37	125
68946	174586	52	174
0	0	0	0
0	0	0	0
1644	4245	0	6
6179	21509	5	13
3926	7670	1	3
52789	15673	43	35
0	0	0	0
100350	75882	34	80




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 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 & 3 seconds \tabularnewline
R Server & 'Gertrude Mary Cox' @ cox.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160589&T=0

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

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

As an alternative you can also use a QR Code:  

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

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







Goodness of Fit
Correlation0.8696
R-squared0.7562
RMSE25604.7044

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8696[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7562[/C][/ROW]
[ROW][C]RMSE[/C][C]25604.7044[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160589&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160589&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.8696
R-squared0.7562
RMSE25604.7044







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1140824156589.185185185-15765.1851851852
2110459106279.5932203394179.40677966102
3105079106279.593220339-1200.59322033898
4112098106279.5932203395818.40677966102
54392982910.7777777778-38981.7777777778
67617377916.5-1743.5
7187326156589.18518518530736.8148148148
8228073034.519772.5
9144408106279.59322033938128.406779661
106648582910.7777777778-16425.7777777778
1179089106279.593220339-27190.593220339
128162582910.7777777778-1285.77777777778
136878877916.5-9128.5
14103297106279.593220339-2982.59322033898
156944682910.7777777778-13464.7777777778
16114948106279.5932203398668.40677966102
17167949140986.27272727326962.7272727273
18125081106279.59322033918801.406779661
19125818106279.59322033919538.406779661
20136588140986.272727273-4398.27272727274
21112431106279.5932203396151.40677966102
22103037106279.593220339-3242.59322033898
238231782910.7777777778-593.777777777781
24118906106279.59322033912626.406779661
2583515106279.593220339-22764.593220339
26104581106279.593220339-1698.59322033898
27103129106279.593220339-3150.59322033898
2883243106279.593220339-23036.593220339
293711030602.28571428576507.71428571429
30113344156589.185185185-43245.1851851852
31139165156589.185185185-17424.1851851852
3286652106279.593220339-19627.593220339
33112302156589.185185185-44287.1851851852
346965277916.5-8264.5
35119442156589.185185185-37147.1851851852
366986782910.7777777778-13043.7777777778
37101629156589.185185185-54960.1851851852
3870168106279.593220339-36111.593220339
393108130602.2857142857478.714285714286
40103925106279.593220339-2354.59322033898
4192622106279.593220339-13657.593220339
427901182910.7777777778-3899.77777777778
439348782910.777777777810576.2222222222
446452077916.5-13396.5
459347382910.777777777810562.2222222222
4611436082910.777777777831449.2222222222
473303230602.28571428572429.71428571429
4896125106279.593220339-10154.593220339
49151911156589.185185185-4678.1851851852
5089256106279.593220339-17023.593220339
5195671106279.593220339-10608.593220339
5259503034.52915.5
53149695156589.185185185-6894.1851851852
543255130602.28571428571948.71428571429
553170130602.28571428571098.71428571429
56100087106279.593220339-6192.59322033898
57169707156589.18518518513117.8148148148
58150491156589.185185185-6098.1851851852
59120192156589.185185185-36397.1851851852
609589382910.777777777812982.2222222222
61151715156589.185185185-4874.1851851852
62176225156589.18518518519635.8148148148
635990082910.7777777778-23010.7777777778
64104767106279.593220339-1512.59322033898
65114799106279.5932203398519.40677966102
6672128106279.593220339-34151.593220339
67143592106279.59322033937312.406779661
6889626106279.593220339-16653.593220339
69131072140986.272727273-9914.27272727274
7012681782910.777777777843906.2222222222
7181351106279.593220339-24928.593220339
722261830602.2857142857-7984.28571428571
7388977106279.593220339-17302.593220339
7492059106279.593220339-14220.593220339
7581897106279.593220339-24382.593220339
76108146106279.5932203391866.40677966102
77126372140986.272727273-14614.2727272727
78249771156589.18518518593181.8148148148
7971154106279.593220339-35125.593220339
807157182910.7777777778-11339.7777777778
815591882910.7777777778-26992.7777777778
82160141156589.1851851853551.8148148148
833869230602.28571428578089.71428571429
84102812106279.593220339-3467.59322033898
855662230602.285714285726019.7142857143
861598630602.2857142857-14616.2857142857
87123534106279.59322033917254.406779661
8810853582910.777777777825624.2222222222
899387982910.777777777810968.2222222222
90144551106279.59322033938271.406779661
915675082910.7777777778-26160.7777777778
92127654140986.272727273-13332.2727272727
936559482910.7777777778-17316.7777777778
945993882910.7777777778-22972.7777777778
95146975106279.59322033940695.406779661
96143372106279.59322033937092.406779661
97168553140986.27272727327566.7272727273
98183500156589.18518518526910.8148148148
99165986156589.1851851859396.8148148148
100184923156589.18518518528333.8148148148
101140358106279.59322033934078.406779661
102149959156589.185185185-6630.1851851852
1035722482910.7777777778-25686.7777777778
1044375030602.285714285713147.7142857143
1054802982910.7777777778-34881.7777777778
106104978140986.272727273-36008.2727272727
107100046106279.593220339-6233.59322033898
108101047106279.593220339-5232.59322033898
109197426156589.18518518540836.8148148148
11016090282910.777777777877991.2222222222
111147172156589.185185185-9417.1851851852
112109432106279.5932203393152.40677966102
11311683034.5-1866.5
11483248106279.593220339-23031.593220339
1152516230602.2857142857-5440.28571428571
1164572477916.5-32192.5
117110529156589.185185185-46060.1851851852
1188553034.5-2179.5
11910138282910.777777777818471.2222222222
1201411630602.2857142857-16486.2857142857
12189506106279.593220339-16773.593220339
122135356106279.59322033929076.406779661
12311606677916.538149.5
124144244106279.59322033937964.406779661
125877330602.2857142857-21829.2857142857
12610215382910.777777777819242.2222222222
127117440106279.59322033911160.406779661
128104128106279.593220339-2151.59322033898
129134238156589.185185185-22351.1851851852
130134047156589.185185185-22542.1851851852
131279488156589.185185185122898.814814815
1327975682910.7777777778-3154.77777777778
1336608977916.5-11827.5
134102070106279.593220339-4209.59322033898
135146760156589.185185185-9829.1851851852
13615477177916.576854.5
137165933140986.27272727324946.7272727273
1386459377916.5-13323.5
13992280106279.593220339-13999.593220339
14067150106279.593220339-39129.593220339
141128692106279.59322033922412.406779661
142124089106279.59322033917809.406779661
143125386140986.272727273-15600.2727272727
1443723830602.28571428576635.71428571429
145140015140986.272727273-971.272727272735
146150047106279.59322033943767.406779661
147154451106279.59322033948171.406779661
148156349140986.27272727315362.7272727273
14903034.5-3034.5
15060233034.52988.5
15103034.5-3034.5
15203034.5-3034.5
15303034.5-3034.5
15403034.5-3034.5
15584601106279.593220339-21678.593220339
15668946106279.593220339-37333.593220339
15703034.5-3034.5
15803034.5-3034.5
15916443034.5-1390.5
16061793034.53144.5
16139263034.5891.5
1625278977916.5-25127.5
16303034.5-3034.5
16410035082910.777777777817439.2222222222

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 140824 & 156589.185185185 & -15765.1851851852 \tabularnewline
2 & 110459 & 106279.593220339 & 4179.40677966102 \tabularnewline
3 & 105079 & 106279.593220339 & -1200.59322033898 \tabularnewline
4 & 112098 & 106279.593220339 & 5818.40677966102 \tabularnewline
5 & 43929 & 82910.7777777778 & -38981.7777777778 \tabularnewline
6 & 76173 & 77916.5 & -1743.5 \tabularnewline
7 & 187326 & 156589.185185185 & 30736.8148148148 \tabularnewline
8 & 22807 & 3034.5 & 19772.5 \tabularnewline
9 & 144408 & 106279.593220339 & 38128.406779661 \tabularnewline
10 & 66485 & 82910.7777777778 & -16425.7777777778 \tabularnewline
11 & 79089 & 106279.593220339 & -27190.593220339 \tabularnewline
12 & 81625 & 82910.7777777778 & -1285.77777777778 \tabularnewline
13 & 68788 & 77916.5 & -9128.5 \tabularnewline
14 & 103297 & 106279.593220339 & -2982.59322033898 \tabularnewline
15 & 69446 & 82910.7777777778 & -13464.7777777778 \tabularnewline
16 & 114948 & 106279.593220339 & 8668.40677966102 \tabularnewline
17 & 167949 & 140986.272727273 & 26962.7272727273 \tabularnewline
18 & 125081 & 106279.593220339 & 18801.406779661 \tabularnewline
19 & 125818 & 106279.593220339 & 19538.406779661 \tabularnewline
20 & 136588 & 140986.272727273 & -4398.27272727274 \tabularnewline
21 & 112431 & 106279.593220339 & 6151.40677966102 \tabularnewline
22 & 103037 & 106279.593220339 & -3242.59322033898 \tabularnewline
23 & 82317 & 82910.7777777778 & -593.777777777781 \tabularnewline
24 & 118906 & 106279.593220339 & 12626.406779661 \tabularnewline
25 & 83515 & 106279.593220339 & -22764.593220339 \tabularnewline
26 & 104581 & 106279.593220339 & -1698.59322033898 \tabularnewline
27 & 103129 & 106279.593220339 & -3150.59322033898 \tabularnewline
28 & 83243 & 106279.593220339 & -23036.593220339 \tabularnewline
29 & 37110 & 30602.2857142857 & 6507.71428571429 \tabularnewline
30 & 113344 & 156589.185185185 & -43245.1851851852 \tabularnewline
31 & 139165 & 156589.185185185 & -17424.1851851852 \tabularnewline
32 & 86652 & 106279.593220339 & -19627.593220339 \tabularnewline
33 & 112302 & 156589.185185185 & -44287.1851851852 \tabularnewline
34 & 69652 & 77916.5 & -8264.5 \tabularnewline
35 & 119442 & 156589.185185185 & -37147.1851851852 \tabularnewline
36 & 69867 & 82910.7777777778 & -13043.7777777778 \tabularnewline
37 & 101629 & 156589.185185185 & -54960.1851851852 \tabularnewline
38 & 70168 & 106279.593220339 & -36111.593220339 \tabularnewline
39 & 31081 & 30602.2857142857 & 478.714285714286 \tabularnewline
40 & 103925 & 106279.593220339 & -2354.59322033898 \tabularnewline
41 & 92622 & 106279.593220339 & -13657.593220339 \tabularnewline
42 & 79011 & 82910.7777777778 & -3899.77777777778 \tabularnewline
43 & 93487 & 82910.7777777778 & 10576.2222222222 \tabularnewline
44 & 64520 & 77916.5 & -13396.5 \tabularnewline
45 & 93473 & 82910.7777777778 & 10562.2222222222 \tabularnewline
46 & 114360 & 82910.7777777778 & 31449.2222222222 \tabularnewline
47 & 33032 & 30602.2857142857 & 2429.71428571429 \tabularnewline
48 & 96125 & 106279.593220339 & -10154.593220339 \tabularnewline
49 & 151911 & 156589.185185185 & -4678.1851851852 \tabularnewline
50 & 89256 & 106279.593220339 & -17023.593220339 \tabularnewline
51 & 95671 & 106279.593220339 & -10608.593220339 \tabularnewline
52 & 5950 & 3034.5 & 2915.5 \tabularnewline
53 & 149695 & 156589.185185185 & -6894.1851851852 \tabularnewline
54 & 32551 & 30602.2857142857 & 1948.71428571429 \tabularnewline
55 & 31701 & 30602.2857142857 & 1098.71428571429 \tabularnewline
56 & 100087 & 106279.593220339 & -6192.59322033898 \tabularnewline
57 & 169707 & 156589.185185185 & 13117.8148148148 \tabularnewline
58 & 150491 & 156589.185185185 & -6098.1851851852 \tabularnewline
59 & 120192 & 156589.185185185 & -36397.1851851852 \tabularnewline
60 & 95893 & 82910.7777777778 & 12982.2222222222 \tabularnewline
61 & 151715 & 156589.185185185 & -4874.1851851852 \tabularnewline
62 & 176225 & 156589.185185185 & 19635.8148148148 \tabularnewline
63 & 59900 & 82910.7777777778 & -23010.7777777778 \tabularnewline
64 & 104767 & 106279.593220339 & -1512.59322033898 \tabularnewline
65 & 114799 & 106279.593220339 & 8519.40677966102 \tabularnewline
66 & 72128 & 106279.593220339 & -34151.593220339 \tabularnewline
67 & 143592 & 106279.593220339 & 37312.406779661 \tabularnewline
68 & 89626 & 106279.593220339 & -16653.593220339 \tabularnewline
69 & 131072 & 140986.272727273 & -9914.27272727274 \tabularnewline
70 & 126817 & 82910.7777777778 & 43906.2222222222 \tabularnewline
71 & 81351 & 106279.593220339 & -24928.593220339 \tabularnewline
72 & 22618 & 30602.2857142857 & -7984.28571428571 \tabularnewline
73 & 88977 & 106279.593220339 & -17302.593220339 \tabularnewline
74 & 92059 & 106279.593220339 & -14220.593220339 \tabularnewline
75 & 81897 & 106279.593220339 & -24382.593220339 \tabularnewline
76 & 108146 & 106279.593220339 & 1866.40677966102 \tabularnewline
77 & 126372 & 140986.272727273 & -14614.2727272727 \tabularnewline
78 & 249771 & 156589.185185185 & 93181.8148148148 \tabularnewline
79 & 71154 & 106279.593220339 & -35125.593220339 \tabularnewline
80 & 71571 & 82910.7777777778 & -11339.7777777778 \tabularnewline
81 & 55918 & 82910.7777777778 & -26992.7777777778 \tabularnewline
82 & 160141 & 156589.185185185 & 3551.8148148148 \tabularnewline
83 & 38692 & 30602.2857142857 & 8089.71428571429 \tabularnewline
84 & 102812 & 106279.593220339 & -3467.59322033898 \tabularnewline
85 & 56622 & 30602.2857142857 & 26019.7142857143 \tabularnewline
86 & 15986 & 30602.2857142857 & -14616.2857142857 \tabularnewline
87 & 123534 & 106279.593220339 & 17254.406779661 \tabularnewline
88 & 108535 & 82910.7777777778 & 25624.2222222222 \tabularnewline
89 & 93879 & 82910.7777777778 & 10968.2222222222 \tabularnewline
90 & 144551 & 106279.593220339 & 38271.406779661 \tabularnewline
91 & 56750 & 82910.7777777778 & -26160.7777777778 \tabularnewline
92 & 127654 & 140986.272727273 & -13332.2727272727 \tabularnewline
93 & 65594 & 82910.7777777778 & -17316.7777777778 \tabularnewline
94 & 59938 & 82910.7777777778 & -22972.7777777778 \tabularnewline
95 & 146975 & 106279.593220339 & 40695.406779661 \tabularnewline
96 & 143372 & 106279.593220339 & 37092.406779661 \tabularnewline
97 & 168553 & 140986.272727273 & 27566.7272727273 \tabularnewline
98 & 183500 & 156589.185185185 & 26910.8148148148 \tabularnewline
99 & 165986 & 156589.185185185 & 9396.8148148148 \tabularnewline
100 & 184923 & 156589.185185185 & 28333.8148148148 \tabularnewline
101 & 140358 & 106279.593220339 & 34078.406779661 \tabularnewline
102 & 149959 & 156589.185185185 & -6630.1851851852 \tabularnewline
103 & 57224 & 82910.7777777778 & -25686.7777777778 \tabularnewline
104 & 43750 & 30602.2857142857 & 13147.7142857143 \tabularnewline
105 & 48029 & 82910.7777777778 & -34881.7777777778 \tabularnewline
106 & 104978 & 140986.272727273 & -36008.2727272727 \tabularnewline
107 & 100046 & 106279.593220339 & -6233.59322033898 \tabularnewline
108 & 101047 & 106279.593220339 & -5232.59322033898 \tabularnewline
109 & 197426 & 156589.185185185 & 40836.8148148148 \tabularnewline
110 & 160902 & 82910.7777777778 & 77991.2222222222 \tabularnewline
111 & 147172 & 156589.185185185 & -9417.1851851852 \tabularnewline
112 & 109432 & 106279.593220339 & 3152.40677966102 \tabularnewline
113 & 1168 & 3034.5 & -1866.5 \tabularnewline
114 & 83248 & 106279.593220339 & -23031.593220339 \tabularnewline
115 & 25162 & 30602.2857142857 & -5440.28571428571 \tabularnewline
116 & 45724 & 77916.5 & -32192.5 \tabularnewline
117 & 110529 & 156589.185185185 & -46060.1851851852 \tabularnewline
118 & 855 & 3034.5 & -2179.5 \tabularnewline
119 & 101382 & 82910.7777777778 & 18471.2222222222 \tabularnewline
120 & 14116 & 30602.2857142857 & -16486.2857142857 \tabularnewline
121 & 89506 & 106279.593220339 & -16773.593220339 \tabularnewline
122 & 135356 & 106279.593220339 & 29076.406779661 \tabularnewline
123 & 116066 & 77916.5 & 38149.5 \tabularnewline
124 & 144244 & 106279.593220339 & 37964.406779661 \tabularnewline
125 & 8773 & 30602.2857142857 & -21829.2857142857 \tabularnewline
126 & 102153 & 82910.7777777778 & 19242.2222222222 \tabularnewline
127 & 117440 & 106279.593220339 & 11160.406779661 \tabularnewline
128 & 104128 & 106279.593220339 & -2151.59322033898 \tabularnewline
129 & 134238 & 156589.185185185 & -22351.1851851852 \tabularnewline
130 & 134047 & 156589.185185185 & -22542.1851851852 \tabularnewline
131 & 279488 & 156589.185185185 & 122898.814814815 \tabularnewline
132 & 79756 & 82910.7777777778 & -3154.77777777778 \tabularnewline
133 & 66089 & 77916.5 & -11827.5 \tabularnewline
134 & 102070 & 106279.593220339 & -4209.59322033898 \tabularnewline
135 & 146760 & 156589.185185185 & -9829.1851851852 \tabularnewline
136 & 154771 & 77916.5 & 76854.5 \tabularnewline
137 & 165933 & 140986.272727273 & 24946.7272727273 \tabularnewline
138 & 64593 & 77916.5 & -13323.5 \tabularnewline
139 & 92280 & 106279.593220339 & -13999.593220339 \tabularnewline
140 & 67150 & 106279.593220339 & -39129.593220339 \tabularnewline
141 & 128692 & 106279.593220339 & 22412.406779661 \tabularnewline
142 & 124089 & 106279.593220339 & 17809.406779661 \tabularnewline
143 & 125386 & 140986.272727273 & -15600.2727272727 \tabularnewline
144 & 37238 & 30602.2857142857 & 6635.71428571429 \tabularnewline
145 & 140015 & 140986.272727273 & -971.272727272735 \tabularnewline
146 & 150047 & 106279.593220339 & 43767.406779661 \tabularnewline
147 & 154451 & 106279.593220339 & 48171.406779661 \tabularnewline
148 & 156349 & 140986.272727273 & 15362.7272727273 \tabularnewline
149 & 0 & 3034.5 & -3034.5 \tabularnewline
150 & 6023 & 3034.5 & 2988.5 \tabularnewline
151 & 0 & 3034.5 & -3034.5 \tabularnewline
152 & 0 & 3034.5 & -3034.5 \tabularnewline
153 & 0 & 3034.5 & -3034.5 \tabularnewline
154 & 0 & 3034.5 & -3034.5 \tabularnewline
155 & 84601 & 106279.593220339 & -21678.593220339 \tabularnewline
156 & 68946 & 106279.593220339 & -37333.593220339 \tabularnewline
157 & 0 & 3034.5 & -3034.5 \tabularnewline
158 & 0 & 3034.5 & -3034.5 \tabularnewline
159 & 1644 & 3034.5 & -1390.5 \tabularnewline
160 & 6179 & 3034.5 & 3144.5 \tabularnewline
161 & 3926 & 3034.5 & 891.5 \tabularnewline
162 & 52789 & 77916.5 & -25127.5 \tabularnewline
163 & 0 & 3034.5 & -3034.5 \tabularnewline
164 & 100350 & 82910.7777777778 & 17439.2222222222 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160589&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]140824[/C][C]156589.185185185[/C][C]-15765.1851851852[/C][/ROW]
[ROW][C]2[/C][C]110459[/C][C]106279.593220339[/C][C]4179.40677966102[/C][/ROW]
[ROW][C]3[/C][C]105079[/C][C]106279.593220339[/C][C]-1200.59322033898[/C][/ROW]
[ROW][C]4[/C][C]112098[/C][C]106279.593220339[/C][C]5818.40677966102[/C][/ROW]
[ROW][C]5[/C][C]43929[/C][C]82910.7777777778[/C][C]-38981.7777777778[/C][/ROW]
[ROW][C]6[/C][C]76173[/C][C]77916.5[/C][C]-1743.5[/C][/ROW]
[ROW][C]7[/C][C]187326[/C][C]156589.185185185[/C][C]30736.8148148148[/C][/ROW]
[ROW][C]8[/C][C]22807[/C][C]3034.5[/C][C]19772.5[/C][/ROW]
[ROW][C]9[/C][C]144408[/C][C]106279.593220339[/C][C]38128.406779661[/C][/ROW]
[ROW][C]10[/C][C]66485[/C][C]82910.7777777778[/C][C]-16425.7777777778[/C][/ROW]
[ROW][C]11[/C][C]79089[/C][C]106279.593220339[/C][C]-27190.593220339[/C][/ROW]
[ROW][C]12[/C][C]81625[/C][C]82910.7777777778[/C][C]-1285.77777777778[/C][/ROW]
[ROW][C]13[/C][C]68788[/C][C]77916.5[/C][C]-9128.5[/C][/ROW]
[ROW][C]14[/C][C]103297[/C][C]106279.593220339[/C][C]-2982.59322033898[/C][/ROW]
[ROW][C]15[/C][C]69446[/C][C]82910.7777777778[/C][C]-13464.7777777778[/C][/ROW]
[ROW][C]16[/C][C]114948[/C][C]106279.593220339[/C][C]8668.40677966102[/C][/ROW]
[ROW][C]17[/C][C]167949[/C][C]140986.272727273[/C][C]26962.7272727273[/C][/ROW]
[ROW][C]18[/C][C]125081[/C][C]106279.593220339[/C][C]18801.406779661[/C][/ROW]
[ROW][C]19[/C][C]125818[/C][C]106279.593220339[/C][C]19538.406779661[/C][/ROW]
[ROW][C]20[/C][C]136588[/C][C]140986.272727273[/C][C]-4398.27272727274[/C][/ROW]
[ROW][C]21[/C][C]112431[/C][C]106279.593220339[/C][C]6151.40677966102[/C][/ROW]
[ROW][C]22[/C][C]103037[/C][C]106279.593220339[/C][C]-3242.59322033898[/C][/ROW]
[ROW][C]23[/C][C]82317[/C][C]82910.7777777778[/C][C]-593.777777777781[/C][/ROW]
[ROW][C]24[/C][C]118906[/C][C]106279.593220339[/C][C]12626.406779661[/C][/ROW]
[ROW][C]25[/C][C]83515[/C][C]106279.593220339[/C][C]-22764.593220339[/C][/ROW]
[ROW][C]26[/C][C]104581[/C][C]106279.593220339[/C][C]-1698.59322033898[/C][/ROW]
[ROW][C]27[/C][C]103129[/C][C]106279.593220339[/C][C]-3150.59322033898[/C][/ROW]
[ROW][C]28[/C][C]83243[/C][C]106279.593220339[/C][C]-23036.593220339[/C][/ROW]
[ROW][C]29[/C][C]37110[/C][C]30602.2857142857[/C][C]6507.71428571429[/C][/ROW]
[ROW][C]30[/C][C]113344[/C][C]156589.185185185[/C][C]-43245.1851851852[/C][/ROW]
[ROW][C]31[/C][C]139165[/C][C]156589.185185185[/C][C]-17424.1851851852[/C][/ROW]
[ROW][C]32[/C][C]86652[/C][C]106279.593220339[/C][C]-19627.593220339[/C][/ROW]
[ROW][C]33[/C][C]112302[/C][C]156589.185185185[/C][C]-44287.1851851852[/C][/ROW]
[ROW][C]34[/C][C]69652[/C][C]77916.5[/C][C]-8264.5[/C][/ROW]
[ROW][C]35[/C][C]119442[/C][C]156589.185185185[/C][C]-37147.1851851852[/C][/ROW]
[ROW][C]36[/C][C]69867[/C][C]82910.7777777778[/C][C]-13043.7777777778[/C][/ROW]
[ROW][C]37[/C][C]101629[/C][C]156589.185185185[/C][C]-54960.1851851852[/C][/ROW]
[ROW][C]38[/C][C]70168[/C][C]106279.593220339[/C][C]-36111.593220339[/C][/ROW]
[ROW][C]39[/C][C]31081[/C][C]30602.2857142857[/C][C]478.714285714286[/C][/ROW]
[ROW][C]40[/C][C]103925[/C][C]106279.593220339[/C][C]-2354.59322033898[/C][/ROW]
[ROW][C]41[/C][C]92622[/C][C]106279.593220339[/C][C]-13657.593220339[/C][/ROW]
[ROW][C]42[/C][C]79011[/C][C]82910.7777777778[/C][C]-3899.77777777778[/C][/ROW]
[ROW][C]43[/C][C]93487[/C][C]82910.7777777778[/C][C]10576.2222222222[/C][/ROW]
[ROW][C]44[/C][C]64520[/C][C]77916.5[/C][C]-13396.5[/C][/ROW]
[ROW][C]45[/C][C]93473[/C][C]82910.7777777778[/C][C]10562.2222222222[/C][/ROW]
[ROW][C]46[/C][C]114360[/C][C]82910.7777777778[/C][C]31449.2222222222[/C][/ROW]
[ROW][C]47[/C][C]33032[/C][C]30602.2857142857[/C][C]2429.71428571429[/C][/ROW]
[ROW][C]48[/C][C]96125[/C][C]106279.593220339[/C][C]-10154.593220339[/C][/ROW]
[ROW][C]49[/C][C]151911[/C][C]156589.185185185[/C][C]-4678.1851851852[/C][/ROW]
[ROW][C]50[/C][C]89256[/C][C]106279.593220339[/C][C]-17023.593220339[/C][/ROW]
[ROW][C]51[/C][C]95671[/C][C]106279.593220339[/C][C]-10608.593220339[/C][/ROW]
[ROW][C]52[/C][C]5950[/C][C]3034.5[/C][C]2915.5[/C][/ROW]
[ROW][C]53[/C][C]149695[/C][C]156589.185185185[/C][C]-6894.1851851852[/C][/ROW]
[ROW][C]54[/C][C]32551[/C][C]30602.2857142857[/C][C]1948.71428571429[/C][/ROW]
[ROW][C]55[/C][C]31701[/C][C]30602.2857142857[/C][C]1098.71428571429[/C][/ROW]
[ROW][C]56[/C][C]100087[/C][C]106279.593220339[/C][C]-6192.59322033898[/C][/ROW]
[ROW][C]57[/C][C]169707[/C][C]156589.185185185[/C][C]13117.8148148148[/C][/ROW]
[ROW][C]58[/C][C]150491[/C][C]156589.185185185[/C][C]-6098.1851851852[/C][/ROW]
[ROW][C]59[/C][C]120192[/C][C]156589.185185185[/C][C]-36397.1851851852[/C][/ROW]
[ROW][C]60[/C][C]95893[/C][C]82910.7777777778[/C][C]12982.2222222222[/C][/ROW]
[ROW][C]61[/C][C]151715[/C][C]156589.185185185[/C][C]-4874.1851851852[/C][/ROW]
[ROW][C]62[/C][C]176225[/C][C]156589.185185185[/C][C]19635.8148148148[/C][/ROW]
[ROW][C]63[/C][C]59900[/C][C]82910.7777777778[/C][C]-23010.7777777778[/C][/ROW]
[ROW][C]64[/C][C]104767[/C][C]106279.593220339[/C][C]-1512.59322033898[/C][/ROW]
[ROW][C]65[/C][C]114799[/C][C]106279.593220339[/C][C]8519.40677966102[/C][/ROW]
[ROW][C]66[/C][C]72128[/C][C]106279.593220339[/C][C]-34151.593220339[/C][/ROW]
[ROW][C]67[/C][C]143592[/C][C]106279.593220339[/C][C]37312.406779661[/C][/ROW]
[ROW][C]68[/C][C]89626[/C][C]106279.593220339[/C][C]-16653.593220339[/C][/ROW]
[ROW][C]69[/C][C]131072[/C][C]140986.272727273[/C][C]-9914.27272727274[/C][/ROW]
[ROW][C]70[/C][C]126817[/C][C]82910.7777777778[/C][C]43906.2222222222[/C][/ROW]
[ROW][C]71[/C][C]81351[/C][C]106279.593220339[/C][C]-24928.593220339[/C][/ROW]
[ROW][C]72[/C][C]22618[/C][C]30602.2857142857[/C][C]-7984.28571428571[/C][/ROW]
[ROW][C]73[/C][C]88977[/C][C]106279.593220339[/C][C]-17302.593220339[/C][/ROW]
[ROW][C]74[/C][C]92059[/C][C]106279.593220339[/C][C]-14220.593220339[/C][/ROW]
[ROW][C]75[/C][C]81897[/C][C]106279.593220339[/C][C]-24382.593220339[/C][/ROW]
[ROW][C]76[/C][C]108146[/C][C]106279.593220339[/C][C]1866.40677966102[/C][/ROW]
[ROW][C]77[/C][C]126372[/C][C]140986.272727273[/C][C]-14614.2727272727[/C][/ROW]
[ROW][C]78[/C][C]249771[/C][C]156589.185185185[/C][C]93181.8148148148[/C][/ROW]
[ROW][C]79[/C][C]71154[/C][C]106279.593220339[/C][C]-35125.593220339[/C][/ROW]
[ROW][C]80[/C][C]71571[/C][C]82910.7777777778[/C][C]-11339.7777777778[/C][/ROW]
[ROW][C]81[/C][C]55918[/C][C]82910.7777777778[/C][C]-26992.7777777778[/C][/ROW]
[ROW][C]82[/C][C]160141[/C][C]156589.185185185[/C][C]3551.8148148148[/C][/ROW]
[ROW][C]83[/C][C]38692[/C][C]30602.2857142857[/C][C]8089.71428571429[/C][/ROW]
[ROW][C]84[/C][C]102812[/C][C]106279.593220339[/C][C]-3467.59322033898[/C][/ROW]
[ROW][C]85[/C][C]56622[/C][C]30602.2857142857[/C][C]26019.7142857143[/C][/ROW]
[ROW][C]86[/C][C]15986[/C][C]30602.2857142857[/C][C]-14616.2857142857[/C][/ROW]
[ROW][C]87[/C][C]123534[/C][C]106279.593220339[/C][C]17254.406779661[/C][/ROW]
[ROW][C]88[/C][C]108535[/C][C]82910.7777777778[/C][C]25624.2222222222[/C][/ROW]
[ROW][C]89[/C][C]93879[/C][C]82910.7777777778[/C][C]10968.2222222222[/C][/ROW]
[ROW][C]90[/C][C]144551[/C][C]106279.593220339[/C][C]38271.406779661[/C][/ROW]
[ROW][C]91[/C][C]56750[/C][C]82910.7777777778[/C][C]-26160.7777777778[/C][/ROW]
[ROW][C]92[/C][C]127654[/C][C]140986.272727273[/C][C]-13332.2727272727[/C][/ROW]
[ROW][C]93[/C][C]65594[/C][C]82910.7777777778[/C][C]-17316.7777777778[/C][/ROW]
[ROW][C]94[/C][C]59938[/C][C]82910.7777777778[/C][C]-22972.7777777778[/C][/ROW]
[ROW][C]95[/C][C]146975[/C][C]106279.593220339[/C][C]40695.406779661[/C][/ROW]
[ROW][C]96[/C][C]143372[/C][C]106279.593220339[/C][C]37092.406779661[/C][/ROW]
[ROW][C]97[/C][C]168553[/C][C]140986.272727273[/C][C]27566.7272727273[/C][/ROW]
[ROW][C]98[/C][C]183500[/C][C]156589.185185185[/C][C]26910.8148148148[/C][/ROW]
[ROW][C]99[/C][C]165986[/C][C]156589.185185185[/C][C]9396.8148148148[/C][/ROW]
[ROW][C]100[/C][C]184923[/C][C]156589.185185185[/C][C]28333.8148148148[/C][/ROW]
[ROW][C]101[/C][C]140358[/C][C]106279.593220339[/C][C]34078.406779661[/C][/ROW]
[ROW][C]102[/C][C]149959[/C][C]156589.185185185[/C][C]-6630.1851851852[/C][/ROW]
[ROW][C]103[/C][C]57224[/C][C]82910.7777777778[/C][C]-25686.7777777778[/C][/ROW]
[ROW][C]104[/C][C]43750[/C][C]30602.2857142857[/C][C]13147.7142857143[/C][/ROW]
[ROW][C]105[/C][C]48029[/C][C]82910.7777777778[/C][C]-34881.7777777778[/C][/ROW]
[ROW][C]106[/C][C]104978[/C][C]140986.272727273[/C][C]-36008.2727272727[/C][/ROW]
[ROW][C]107[/C][C]100046[/C][C]106279.593220339[/C][C]-6233.59322033898[/C][/ROW]
[ROW][C]108[/C][C]101047[/C][C]106279.593220339[/C][C]-5232.59322033898[/C][/ROW]
[ROW][C]109[/C][C]197426[/C][C]156589.185185185[/C][C]40836.8148148148[/C][/ROW]
[ROW][C]110[/C][C]160902[/C][C]82910.7777777778[/C][C]77991.2222222222[/C][/ROW]
[ROW][C]111[/C][C]147172[/C][C]156589.185185185[/C][C]-9417.1851851852[/C][/ROW]
[ROW][C]112[/C][C]109432[/C][C]106279.593220339[/C][C]3152.40677966102[/C][/ROW]
[ROW][C]113[/C][C]1168[/C][C]3034.5[/C][C]-1866.5[/C][/ROW]
[ROW][C]114[/C][C]83248[/C][C]106279.593220339[/C][C]-23031.593220339[/C][/ROW]
[ROW][C]115[/C][C]25162[/C][C]30602.2857142857[/C][C]-5440.28571428571[/C][/ROW]
[ROW][C]116[/C][C]45724[/C][C]77916.5[/C][C]-32192.5[/C][/ROW]
[ROW][C]117[/C][C]110529[/C][C]156589.185185185[/C][C]-46060.1851851852[/C][/ROW]
[ROW][C]118[/C][C]855[/C][C]3034.5[/C][C]-2179.5[/C][/ROW]
[ROW][C]119[/C][C]101382[/C][C]82910.7777777778[/C][C]18471.2222222222[/C][/ROW]
[ROW][C]120[/C][C]14116[/C][C]30602.2857142857[/C][C]-16486.2857142857[/C][/ROW]
[ROW][C]121[/C][C]89506[/C][C]106279.593220339[/C][C]-16773.593220339[/C][/ROW]
[ROW][C]122[/C][C]135356[/C][C]106279.593220339[/C][C]29076.406779661[/C][/ROW]
[ROW][C]123[/C][C]116066[/C][C]77916.5[/C][C]38149.5[/C][/ROW]
[ROW][C]124[/C][C]144244[/C][C]106279.593220339[/C][C]37964.406779661[/C][/ROW]
[ROW][C]125[/C][C]8773[/C][C]30602.2857142857[/C][C]-21829.2857142857[/C][/ROW]
[ROW][C]126[/C][C]102153[/C][C]82910.7777777778[/C][C]19242.2222222222[/C][/ROW]
[ROW][C]127[/C][C]117440[/C][C]106279.593220339[/C][C]11160.406779661[/C][/ROW]
[ROW][C]128[/C][C]104128[/C][C]106279.593220339[/C][C]-2151.59322033898[/C][/ROW]
[ROW][C]129[/C][C]134238[/C][C]156589.185185185[/C][C]-22351.1851851852[/C][/ROW]
[ROW][C]130[/C][C]134047[/C][C]156589.185185185[/C][C]-22542.1851851852[/C][/ROW]
[ROW][C]131[/C][C]279488[/C][C]156589.185185185[/C][C]122898.814814815[/C][/ROW]
[ROW][C]132[/C][C]79756[/C][C]82910.7777777778[/C][C]-3154.77777777778[/C][/ROW]
[ROW][C]133[/C][C]66089[/C][C]77916.5[/C][C]-11827.5[/C][/ROW]
[ROW][C]134[/C][C]102070[/C][C]106279.593220339[/C][C]-4209.59322033898[/C][/ROW]
[ROW][C]135[/C][C]146760[/C][C]156589.185185185[/C][C]-9829.1851851852[/C][/ROW]
[ROW][C]136[/C][C]154771[/C][C]77916.5[/C][C]76854.5[/C][/ROW]
[ROW][C]137[/C][C]165933[/C][C]140986.272727273[/C][C]24946.7272727273[/C][/ROW]
[ROW][C]138[/C][C]64593[/C][C]77916.5[/C][C]-13323.5[/C][/ROW]
[ROW][C]139[/C][C]92280[/C][C]106279.593220339[/C][C]-13999.593220339[/C][/ROW]
[ROW][C]140[/C][C]67150[/C][C]106279.593220339[/C][C]-39129.593220339[/C][/ROW]
[ROW][C]141[/C][C]128692[/C][C]106279.593220339[/C][C]22412.406779661[/C][/ROW]
[ROW][C]142[/C][C]124089[/C][C]106279.593220339[/C][C]17809.406779661[/C][/ROW]
[ROW][C]143[/C][C]125386[/C][C]140986.272727273[/C][C]-15600.2727272727[/C][/ROW]
[ROW][C]144[/C][C]37238[/C][C]30602.2857142857[/C][C]6635.71428571429[/C][/ROW]
[ROW][C]145[/C][C]140015[/C][C]140986.272727273[/C][C]-971.272727272735[/C][/ROW]
[ROW][C]146[/C][C]150047[/C][C]106279.593220339[/C][C]43767.406779661[/C][/ROW]
[ROW][C]147[/C][C]154451[/C][C]106279.593220339[/C][C]48171.406779661[/C][/ROW]
[ROW][C]148[/C][C]156349[/C][C]140986.272727273[/C][C]15362.7272727273[/C][/ROW]
[ROW][C]149[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]150[/C][C]6023[/C][C]3034.5[/C][C]2988.5[/C][/ROW]
[ROW][C]151[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]152[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]155[/C][C]84601[/C][C]106279.593220339[/C][C]-21678.593220339[/C][/ROW]
[ROW][C]156[/C][C]68946[/C][C]106279.593220339[/C][C]-37333.593220339[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]158[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]159[/C][C]1644[/C][C]3034.5[/C][C]-1390.5[/C][/ROW]
[ROW][C]160[/C][C]6179[/C][C]3034.5[/C][C]3144.5[/C][/ROW]
[ROW][C]161[/C][C]3926[/C][C]3034.5[/C][C]891.5[/C][/ROW]
[ROW][C]162[/C][C]52789[/C][C]77916.5[/C][C]-25127.5[/C][/ROW]
[ROW][C]163[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]164[/C][C]100350[/C][C]82910.7777777778[/C][C]17439.2222222222[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160589&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160589&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
1140824156589.185185185-15765.1851851852
2110459106279.5932203394179.40677966102
3105079106279.593220339-1200.59322033898
4112098106279.5932203395818.40677966102
54392982910.7777777778-38981.7777777778
67617377916.5-1743.5
7187326156589.18518518530736.8148148148
8228073034.519772.5
9144408106279.59322033938128.406779661
106648582910.7777777778-16425.7777777778
1179089106279.593220339-27190.593220339
128162582910.7777777778-1285.77777777778
136878877916.5-9128.5
14103297106279.593220339-2982.59322033898
156944682910.7777777778-13464.7777777778
16114948106279.5932203398668.40677966102
17167949140986.27272727326962.7272727273
18125081106279.59322033918801.406779661
19125818106279.59322033919538.406779661
20136588140986.272727273-4398.27272727274
21112431106279.5932203396151.40677966102
22103037106279.593220339-3242.59322033898
238231782910.7777777778-593.777777777781
24118906106279.59322033912626.406779661
2583515106279.593220339-22764.593220339
26104581106279.593220339-1698.59322033898
27103129106279.593220339-3150.59322033898
2883243106279.593220339-23036.593220339
293711030602.28571428576507.71428571429
30113344156589.185185185-43245.1851851852
31139165156589.185185185-17424.1851851852
3286652106279.593220339-19627.593220339
33112302156589.185185185-44287.1851851852
346965277916.5-8264.5
35119442156589.185185185-37147.1851851852
366986782910.7777777778-13043.7777777778
37101629156589.185185185-54960.1851851852
3870168106279.593220339-36111.593220339
393108130602.2857142857478.714285714286
40103925106279.593220339-2354.59322033898
4192622106279.593220339-13657.593220339
427901182910.7777777778-3899.77777777778
439348782910.777777777810576.2222222222
446452077916.5-13396.5
459347382910.777777777810562.2222222222
4611436082910.777777777831449.2222222222
473303230602.28571428572429.71428571429
4896125106279.593220339-10154.593220339
49151911156589.185185185-4678.1851851852
5089256106279.593220339-17023.593220339
5195671106279.593220339-10608.593220339
5259503034.52915.5
53149695156589.185185185-6894.1851851852
543255130602.28571428571948.71428571429
553170130602.28571428571098.71428571429
56100087106279.593220339-6192.59322033898
57169707156589.18518518513117.8148148148
58150491156589.185185185-6098.1851851852
59120192156589.185185185-36397.1851851852
609589382910.777777777812982.2222222222
61151715156589.185185185-4874.1851851852
62176225156589.18518518519635.8148148148
635990082910.7777777778-23010.7777777778
64104767106279.593220339-1512.59322033898
65114799106279.5932203398519.40677966102
6672128106279.593220339-34151.593220339
67143592106279.59322033937312.406779661
6889626106279.593220339-16653.593220339
69131072140986.272727273-9914.27272727274
7012681782910.777777777843906.2222222222
7181351106279.593220339-24928.593220339
722261830602.2857142857-7984.28571428571
7388977106279.593220339-17302.593220339
7492059106279.593220339-14220.593220339
7581897106279.593220339-24382.593220339
76108146106279.5932203391866.40677966102
77126372140986.272727273-14614.2727272727
78249771156589.18518518593181.8148148148
7971154106279.593220339-35125.593220339
807157182910.7777777778-11339.7777777778
815591882910.7777777778-26992.7777777778
82160141156589.1851851853551.8148148148
833869230602.28571428578089.71428571429
84102812106279.593220339-3467.59322033898
855662230602.285714285726019.7142857143
861598630602.2857142857-14616.2857142857
87123534106279.59322033917254.406779661
8810853582910.777777777825624.2222222222
899387982910.777777777810968.2222222222
90144551106279.59322033938271.406779661
915675082910.7777777778-26160.7777777778
92127654140986.272727273-13332.2727272727
936559482910.7777777778-17316.7777777778
945993882910.7777777778-22972.7777777778
95146975106279.59322033940695.406779661
96143372106279.59322033937092.406779661
97168553140986.27272727327566.7272727273
98183500156589.18518518526910.8148148148
99165986156589.1851851859396.8148148148
100184923156589.18518518528333.8148148148
101140358106279.59322033934078.406779661
102149959156589.185185185-6630.1851851852
1035722482910.7777777778-25686.7777777778
1044375030602.285714285713147.7142857143
1054802982910.7777777778-34881.7777777778
106104978140986.272727273-36008.2727272727
107100046106279.593220339-6233.59322033898
108101047106279.593220339-5232.59322033898
109197426156589.18518518540836.8148148148
11016090282910.777777777877991.2222222222
111147172156589.185185185-9417.1851851852
112109432106279.5932203393152.40677966102
11311683034.5-1866.5
11483248106279.593220339-23031.593220339
1152516230602.2857142857-5440.28571428571
1164572477916.5-32192.5
117110529156589.185185185-46060.1851851852
1188553034.5-2179.5
11910138282910.777777777818471.2222222222
1201411630602.2857142857-16486.2857142857
12189506106279.593220339-16773.593220339
122135356106279.59322033929076.406779661
12311606677916.538149.5
124144244106279.59322033937964.406779661
125877330602.2857142857-21829.2857142857
12610215382910.777777777819242.2222222222
127117440106279.59322033911160.406779661
128104128106279.593220339-2151.59322033898
129134238156589.185185185-22351.1851851852
130134047156589.185185185-22542.1851851852
131279488156589.185185185122898.814814815
1327975682910.7777777778-3154.77777777778
1336608977916.5-11827.5
134102070106279.593220339-4209.59322033898
135146760156589.185185185-9829.1851851852
13615477177916.576854.5
137165933140986.27272727324946.7272727273
1386459377916.5-13323.5
13992280106279.593220339-13999.593220339
14067150106279.593220339-39129.593220339
141128692106279.59322033922412.406779661
142124089106279.59322033917809.406779661
143125386140986.272727273-15600.2727272727
1443723830602.28571428576635.71428571429
145140015140986.272727273-971.272727272735
146150047106279.59322033943767.406779661
147154451106279.59322033948171.406779661
148156349140986.27272727315362.7272727273
14903034.5-3034.5
15060233034.52988.5
15103034.5-3034.5
15203034.5-3034.5
15303034.5-3034.5
15403034.5-3034.5
15584601106279.593220339-21678.593220339
15668946106279.593220339-37333.593220339
15703034.5-3034.5
15803034.5-3034.5
15916443034.5-1390.5
16061793034.53144.5
16139263034.5891.5
1625278977916.5-25127.5
16303034.5-3034.5
16410035082910.777777777817439.2222222222



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