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 computationWed, 20 Jun 2012 07:43:36 -0400
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/Jun/20/t1340192693x8se0tsc49il20g.htm/, Retrieved Mon, 29 Apr 2024 02:56:48 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=168749, Retrieved Mon, 29 Apr 2024 02:56:48 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact207
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [total time] [2012-06-20 11:43:36] [d76b387543b13b5e3afd8ff9e5fdc89f] [Current]
Feedback Forum

Post a new message
Dataseries X:
182	159	348	198
110	159	327	153
162	161	421	150
155	259	258	148
141	176	206	147
165	131	269	138
101	148	145	137
152	183	244	136
127	177	273	136
128	188	240	135
121	105	206	130
112	153	176	129
142	214	448	127
164	114	218	126
156	157	244	126
161	197	236	122
176	224	213	121
152	163	149	121
155	162	306	121
85	166	185	120
164	134	246	118
155	135	328	118
88	188	257	116
145	203	200	116
122	150	189	115
161	166	217	112
150	179	265	112
132	145	307	112
171	244	255	111
118	164	145	111
96	157	217	110
114	158	115	108
140	156	249	107
139	202	204	107
184	124	264	107
121	187	203	106
139	186	318	106
140	85	244	104
146	187	217	104
148	125	320	104
112	149	165	103
146	162	245	103
126	139	149	103
169	147	146	102
75	162	256	102
83	168	228	101
163	153	212	101
180	151	228	100
181	159	150	99
168	157	257	99
94	188	274	97
114	159	291	97
107	185	132	96
152	145	125	95
186	159	208	95
118	158	184	94
133	153	202	94
90	152	179	91
127	97	84	91
87	191	165	90
121	147	302	90
103	165	167	90
50	186	148	89
134	212	154	89
89	116	120	89
84	109	129	87
163	99	130	87
50	164	146	87
98	161	202	87
96	149	202	86
123	173	180	86
104	108	141	86
122	163	131	86
124	109	182	86
128	139	214	85
123	105	343	85
76	177	210	84
85	110	161	84
121	186	395	84
88	95	155	83
116	165	169	82
137	161	279	82
66	150	196	82
136	213	164	80
159	142	213	79
102	174	184	79
110	124	243	79
104	116	97	79
107	221	272	79
158	167	161	78
126	45	97	77
83	127	76	76
48	60	210	75
97	138	160	74
63	80	145	74
131	156	183	73
93	64	115	72
97	124	124	72
105	94	164	72
88	148	188	72
89	146	313	71
95	163	123	71
70	139	193	71
81	77	103	70
107	171	264	69
84	123	171	69
129	166	143	69
77	119	68	68
134	154	197	67
84	96	153	66
58	162	194	66
69	128	112	65
93	153	359	65
166	163	242	65
40	105	253	65
102	132	111	64
97	83	109	63
75	152	301	63
67	126	99	63
81	112	101	61
146	116	118	60
103	243	197	60
48	111	108	60
63	99	209	58
147	249	226	58
70	153	216	56
64	113	119	56
77	151	189	55
146	105	240	55
103	106	203	54
63	160	275	51
126	148	282	50
41	78	37	50
65	120	109	42
30	99	39	41
35	54	39	40
56	169	232	38
37	101	53	36
30	41	32	28
20	66	33	25
49	27	57	22
8	89	76	20
22	67	23	20
21	61	33	18
23	30	25	17
12	13	6	13
13	64	44	12
16	21	9	11
18	9	14	9
1	22	23	9
12	0	1	7
8	7	6	7
4	0	6	6
4	0	1	6
0	4	4	5
7	0	2	2
0	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=168749&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'Gwilym Jenkins' @ jenkins.wessa.net







Goodness of Fit
Correlation0.8666
R-squared0.7509
RMSE19.3524

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8666[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7509[/C][/ROW]
[ROW][C]RMSE[/C][C]19.3524[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=168749&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=168749&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.8666
R-squared0.7509
RMSE19.3524







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1198115.07142857142982.9285714285714
2153115.07142857142937.9285714285714
3150115.07142857142934.9285714285714
4148115.07142857142932.9285714285714
514796.260869565217450.7391304347826
6138115.07142857142922.9285714285714
713782.694444444444454.3055555555556
8136115.07142857142920.9285714285714
9136115.07142857142920.9285714285714
1013596.260869565217438.7391304347826
1113096.260869565217433.7391304347826
1212996.260869565217432.7391304347826
13127115.07142857142911.9285714285714
1412696.260869565217429.7391304347826
15126115.07142857142910.9285714285714
1612296.260869565217425.7391304347826
1712196.260869565217424.7391304347826
1812196.260869565217424.7391304347826
19121115.0714285714295.92857142857143
2012082.694444444444437.3055555555556
21118115.0714285714292.92857142857143
22118115.0714285714292.92857142857143
2311682.694444444444433.3055555555556
2411696.260869565217419.7391304347826
2511596.260869565217418.7391304347826
2611296.260869565217415.7391304347826
27112115.071428571429-3.07142857142857
28112115.071428571429-3.07142857142857
29111115.071428571429-4.07142857142857
3011196.260869565217414.7391304347826
3111082.694444444444427.3055555555556
3210896.260869565217411.7391304347826
33107115.071428571429-8.07142857142857
3410796.260869565217410.7391304347826
35107115.071428571429-8.07142857142857
3610696.26086956521749.73913043478261
37106115.071428571429-9.07142857142857
38104115.071428571429-11.0714285714286
3910496.26086956521747.73913043478261
40104115.071428571429-11.0714285714286
4110396.26086956521746.73913043478261
42103115.071428571429-12.0714285714286
4310396.26086956521746.73913043478261
4410296.26086956521745.73913043478261
4510264.346153846153837.6538461538462
4610182.694444444444418.3055555555556
4710196.26086956521744.73913043478261
4810096.26086956521743.73913043478261
499996.26086956521742.73913043478261
5099115.071428571429-16.0714285714286
519782.694444444444414.3055555555556
5297115.071428571429-18.0714285714286
539682.694444444444413.3055555555556
549596.2608695652174-1.26086956521739
559596.2608695652174-1.26086956521739
569496.2608695652174-2.26086956521739
579496.2608695652174-2.26086956521739
589182.69444444444448.30555555555556
599196.2608695652174-5.26086956521739
609082.69444444444447.30555555555556
6190115.071428571429-25.0714285714286
629082.69444444444447.30555555555556
638964.346153846153824.6538461538462
648996.2608695652174-7.26086956521739
658982.69444444444446.30555555555556
668782.69444444444444.30555555555556
678796.2608695652174-9.26086956521739
688764.346153846153822.6538461538462
698782.69444444444444.30555555555556
708682.69444444444443.30555555555556
718696.2608695652174-10.2608695652174
728682.69444444444443.30555555555556
738696.2608695652174-10.2608695652174
748696.2608695652174-10.2608695652174
758596.2608695652174-11.2608695652174
7685115.071428571429-30.0714285714286
778464.346153846153819.6538461538462
788482.69444444444441.30555555555556
7984115.071428571429-31.0714285714286
808382.69444444444440.305555555555557
818296.2608695652174-14.2608695652174
8282115.071428571429-33.0714285714286
838264.346153846153817.6538461538462
848096.2608695652174-16.2608695652174
857996.2608695652174-17.2608695652174
867982.6944444444444-3.69444444444444
877996.2608695652174-17.2608695652174
887982.6944444444444-3.69444444444444
897982.6944444444444-3.69444444444444
907896.2608695652174-18.2608695652174
917796.2608695652174-19.2608695652174
927682.6944444444444-6.69444444444444
937564.346153846153810.6538461538462
947482.6944444444444-8.69444444444444
957464.34615384615389.65384615384616
967396.2608695652174-23.2608695652174
977282.6944444444444-10.6944444444444
987282.6944444444444-10.6944444444444
997282.6944444444444-10.6944444444444
1007282.6944444444444-10.6944444444444
1017182.6944444444444-11.6944444444444
1027182.6944444444444-11.6944444444444
1037164.34615384615386.65384615384616
1047064.34615384615385.65384615384616
1056982.6944444444444-13.6944444444444
1066982.6944444444444-13.6944444444444
1076996.2608695652174-27.2608695652174
1086864.34615384615383.65384615384616
1096796.2608695652174-29.2608695652174
1106682.6944444444444-16.6944444444444
1116664.34615384615381.65384615384616
1126564.34615384615380.65384615384616
1136582.6944444444444-17.6944444444444
1146596.2608695652174-31.2608695652174
1156564.34615384615380.65384615384616
1166482.6944444444444-18.6944444444444
1176382.6944444444444-19.6944444444444
1186364.3461538461538-1.34615384615384
1196364.3461538461538-1.34615384615384
1206164.3461538461538-3.34615384615384
1216096.2608695652174-36.2608695652174
1226082.6944444444444-22.6944444444444
1236064.3461538461538-4.34615384615384
1245864.3461538461538-6.34615384615384
1255896.2608695652174-38.2608695652174
1265664.3461538461538-8.34615384615384
1275664.3461538461538-8.34615384615384
1285564.3461538461538-9.34615384615384
1295596.2608695652174-41.2608695652174
1305482.6944444444444-28.6944444444444
1315164.3461538461538-13.3461538461538
13250115.071428571429-65.0714285714286
1335064.3461538461538-14.3461538461538
1344264.3461538461538-22.3461538461538
1354128.12512.875
1364028.12511.875
1373864.3461538461538-26.3461538461538
1383628.1257.875
1392828.125-0.125
1402528.125-3.125
1412264.3461538461538-42.3461538461538
1422011.57142857142868.42857142857143
1432028.125-8.125
1441828.125-10.125
1451728.125-11.125
1461311.57142857142861.42857142857143
1471211.57142857142860.428571428571429
1481111.5714285714286-0.571428571428571
149911.5714285714286-2.57142857142857
150911.5714285714286-2.57142857142857
151725
152711.5714285714286-4.57142857142857
153624
154624
155523
156220
15702-2
15802-2
15902-2
16002-2
16102-2
16202-2
16302-2
16402-2

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 198 & 115.071428571429 & 82.9285714285714 \tabularnewline
2 & 153 & 115.071428571429 & 37.9285714285714 \tabularnewline
3 & 150 & 115.071428571429 & 34.9285714285714 \tabularnewline
4 & 148 & 115.071428571429 & 32.9285714285714 \tabularnewline
5 & 147 & 96.2608695652174 & 50.7391304347826 \tabularnewline
6 & 138 & 115.071428571429 & 22.9285714285714 \tabularnewline
7 & 137 & 82.6944444444444 & 54.3055555555556 \tabularnewline
8 & 136 & 115.071428571429 & 20.9285714285714 \tabularnewline
9 & 136 & 115.071428571429 & 20.9285714285714 \tabularnewline
10 & 135 & 96.2608695652174 & 38.7391304347826 \tabularnewline
11 & 130 & 96.2608695652174 & 33.7391304347826 \tabularnewline
12 & 129 & 96.2608695652174 & 32.7391304347826 \tabularnewline
13 & 127 & 115.071428571429 & 11.9285714285714 \tabularnewline
14 & 126 & 96.2608695652174 & 29.7391304347826 \tabularnewline
15 & 126 & 115.071428571429 & 10.9285714285714 \tabularnewline
16 & 122 & 96.2608695652174 & 25.7391304347826 \tabularnewline
17 & 121 & 96.2608695652174 & 24.7391304347826 \tabularnewline
18 & 121 & 96.2608695652174 & 24.7391304347826 \tabularnewline
19 & 121 & 115.071428571429 & 5.92857142857143 \tabularnewline
20 & 120 & 82.6944444444444 & 37.3055555555556 \tabularnewline
21 & 118 & 115.071428571429 & 2.92857142857143 \tabularnewline
22 & 118 & 115.071428571429 & 2.92857142857143 \tabularnewline
23 & 116 & 82.6944444444444 & 33.3055555555556 \tabularnewline
24 & 116 & 96.2608695652174 & 19.7391304347826 \tabularnewline
25 & 115 & 96.2608695652174 & 18.7391304347826 \tabularnewline
26 & 112 & 96.2608695652174 & 15.7391304347826 \tabularnewline
27 & 112 & 115.071428571429 & -3.07142857142857 \tabularnewline
28 & 112 & 115.071428571429 & -3.07142857142857 \tabularnewline
29 & 111 & 115.071428571429 & -4.07142857142857 \tabularnewline
30 & 111 & 96.2608695652174 & 14.7391304347826 \tabularnewline
31 & 110 & 82.6944444444444 & 27.3055555555556 \tabularnewline
32 & 108 & 96.2608695652174 & 11.7391304347826 \tabularnewline
33 & 107 & 115.071428571429 & -8.07142857142857 \tabularnewline
34 & 107 & 96.2608695652174 & 10.7391304347826 \tabularnewline
35 & 107 & 115.071428571429 & -8.07142857142857 \tabularnewline
36 & 106 & 96.2608695652174 & 9.73913043478261 \tabularnewline
37 & 106 & 115.071428571429 & -9.07142857142857 \tabularnewline
38 & 104 & 115.071428571429 & -11.0714285714286 \tabularnewline
39 & 104 & 96.2608695652174 & 7.73913043478261 \tabularnewline
40 & 104 & 115.071428571429 & -11.0714285714286 \tabularnewline
41 & 103 & 96.2608695652174 & 6.73913043478261 \tabularnewline
42 & 103 & 115.071428571429 & -12.0714285714286 \tabularnewline
43 & 103 & 96.2608695652174 & 6.73913043478261 \tabularnewline
44 & 102 & 96.2608695652174 & 5.73913043478261 \tabularnewline
45 & 102 & 64.3461538461538 & 37.6538461538462 \tabularnewline
46 & 101 & 82.6944444444444 & 18.3055555555556 \tabularnewline
47 & 101 & 96.2608695652174 & 4.73913043478261 \tabularnewline
48 & 100 & 96.2608695652174 & 3.73913043478261 \tabularnewline
49 & 99 & 96.2608695652174 & 2.73913043478261 \tabularnewline
50 & 99 & 115.071428571429 & -16.0714285714286 \tabularnewline
51 & 97 & 82.6944444444444 & 14.3055555555556 \tabularnewline
52 & 97 & 115.071428571429 & -18.0714285714286 \tabularnewline
53 & 96 & 82.6944444444444 & 13.3055555555556 \tabularnewline
54 & 95 & 96.2608695652174 & -1.26086956521739 \tabularnewline
55 & 95 & 96.2608695652174 & -1.26086956521739 \tabularnewline
56 & 94 & 96.2608695652174 & -2.26086956521739 \tabularnewline
57 & 94 & 96.2608695652174 & -2.26086956521739 \tabularnewline
58 & 91 & 82.6944444444444 & 8.30555555555556 \tabularnewline
59 & 91 & 96.2608695652174 & -5.26086956521739 \tabularnewline
60 & 90 & 82.6944444444444 & 7.30555555555556 \tabularnewline
61 & 90 & 115.071428571429 & -25.0714285714286 \tabularnewline
62 & 90 & 82.6944444444444 & 7.30555555555556 \tabularnewline
63 & 89 & 64.3461538461538 & 24.6538461538462 \tabularnewline
64 & 89 & 96.2608695652174 & -7.26086956521739 \tabularnewline
65 & 89 & 82.6944444444444 & 6.30555555555556 \tabularnewline
66 & 87 & 82.6944444444444 & 4.30555555555556 \tabularnewline
67 & 87 & 96.2608695652174 & -9.26086956521739 \tabularnewline
68 & 87 & 64.3461538461538 & 22.6538461538462 \tabularnewline
69 & 87 & 82.6944444444444 & 4.30555555555556 \tabularnewline
70 & 86 & 82.6944444444444 & 3.30555555555556 \tabularnewline
71 & 86 & 96.2608695652174 & -10.2608695652174 \tabularnewline
72 & 86 & 82.6944444444444 & 3.30555555555556 \tabularnewline
73 & 86 & 96.2608695652174 & -10.2608695652174 \tabularnewline
74 & 86 & 96.2608695652174 & -10.2608695652174 \tabularnewline
75 & 85 & 96.2608695652174 & -11.2608695652174 \tabularnewline
76 & 85 & 115.071428571429 & -30.0714285714286 \tabularnewline
77 & 84 & 64.3461538461538 & 19.6538461538462 \tabularnewline
78 & 84 & 82.6944444444444 & 1.30555555555556 \tabularnewline
79 & 84 & 115.071428571429 & -31.0714285714286 \tabularnewline
80 & 83 & 82.6944444444444 & 0.305555555555557 \tabularnewline
81 & 82 & 96.2608695652174 & -14.2608695652174 \tabularnewline
82 & 82 & 115.071428571429 & -33.0714285714286 \tabularnewline
83 & 82 & 64.3461538461538 & 17.6538461538462 \tabularnewline
84 & 80 & 96.2608695652174 & -16.2608695652174 \tabularnewline
85 & 79 & 96.2608695652174 & -17.2608695652174 \tabularnewline
86 & 79 & 82.6944444444444 & -3.69444444444444 \tabularnewline
87 & 79 & 96.2608695652174 & -17.2608695652174 \tabularnewline
88 & 79 & 82.6944444444444 & -3.69444444444444 \tabularnewline
89 & 79 & 82.6944444444444 & -3.69444444444444 \tabularnewline
90 & 78 & 96.2608695652174 & -18.2608695652174 \tabularnewline
91 & 77 & 96.2608695652174 & -19.2608695652174 \tabularnewline
92 & 76 & 82.6944444444444 & -6.69444444444444 \tabularnewline
93 & 75 & 64.3461538461538 & 10.6538461538462 \tabularnewline
94 & 74 & 82.6944444444444 & -8.69444444444444 \tabularnewline
95 & 74 & 64.3461538461538 & 9.65384615384616 \tabularnewline
96 & 73 & 96.2608695652174 & -23.2608695652174 \tabularnewline
97 & 72 & 82.6944444444444 & -10.6944444444444 \tabularnewline
98 & 72 & 82.6944444444444 & -10.6944444444444 \tabularnewline
99 & 72 & 82.6944444444444 & -10.6944444444444 \tabularnewline
100 & 72 & 82.6944444444444 & -10.6944444444444 \tabularnewline
101 & 71 & 82.6944444444444 & -11.6944444444444 \tabularnewline
102 & 71 & 82.6944444444444 & -11.6944444444444 \tabularnewline
103 & 71 & 64.3461538461538 & 6.65384615384616 \tabularnewline
104 & 70 & 64.3461538461538 & 5.65384615384616 \tabularnewline
105 & 69 & 82.6944444444444 & -13.6944444444444 \tabularnewline
106 & 69 & 82.6944444444444 & -13.6944444444444 \tabularnewline
107 & 69 & 96.2608695652174 & -27.2608695652174 \tabularnewline
108 & 68 & 64.3461538461538 & 3.65384615384616 \tabularnewline
109 & 67 & 96.2608695652174 & -29.2608695652174 \tabularnewline
110 & 66 & 82.6944444444444 & -16.6944444444444 \tabularnewline
111 & 66 & 64.3461538461538 & 1.65384615384616 \tabularnewline
112 & 65 & 64.3461538461538 & 0.65384615384616 \tabularnewline
113 & 65 & 82.6944444444444 & -17.6944444444444 \tabularnewline
114 & 65 & 96.2608695652174 & -31.2608695652174 \tabularnewline
115 & 65 & 64.3461538461538 & 0.65384615384616 \tabularnewline
116 & 64 & 82.6944444444444 & -18.6944444444444 \tabularnewline
117 & 63 & 82.6944444444444 & -19.6944444444444 \tabularnewline
118 & 63 & 64.3461538461538 & -1.34615384615384 \tabularnewline
119 & 63 & 64.3461538461538 & -1.34615384615384 \tabularnewline
120 & 61 & 64.3461538461538 & -3.34615384615384 \tabularnewline
121 & 60 & 96.2608695652174 & -36.2608695652174 \tabularnewline
122 & 60 & 82.6944444444444 & -22.6944444444444 \tabularnewline
123 & 60 & 64.3461538461538 & -4.34615384615384 \tabularnewline
124 & 58 & 64.3461538461538 & -6.34615384615384 \tabularnewline
125 & 58 & 96.2608695652174 & -38.2608695652174 \tabularnewline
126 & 56 & 64.3461538461538 & -8.34615384615384 \tabularnewline
127 & 56 & 64.3461538461538 & -8.34615384615384 \tabularnewline
128 & 55 & 64.3461538461538 & -9.34615384615384 \tabularnewline
129 & 55 & 96.2608695652174 & -41.2608695652174 \tabularnewline
130 & 54 & 82.6944444444444 & -28.6944444444444 \tabularnewline
131 & 51 & 64.3461538461538 & -13.3461538461538 \tabularnewline
132 & 50 & 115.071428571429 & -65.0714285714286 \tabularnewline
133 & 50 & 64.3461538461538 & -14.3461538461538 \tabularnewline
134 & 42 & 64.3461538461538 & -22.3461538461538 \tabularnewline
135 & 41 & 28.125 & 12.875 \tabularnewline
136 & 40 & 28.125 & 11.875 \tabularnewline
137 & 38 & 64.3461538461538 & -26.3461538461538 \tabularnewline
138 & 36 & 28.125 & 7.875 \tabularnewline
139 & 28 & 28.125 & -0.125 \tabularnewline
140 & 25 & 28.125 & -3.125 \tabularnewline
141 & 22 & 64.3461538461538 & -42.3461538461538 \tabularnewline
142 & 20 & 11.5714285714286 & 8.42857142857143 \tabularnewline
143 & 20 & 28.125 & -8.125 \tabularnewline
144 & 18 & 28.125 & -10.125 \tabularnewline
145 & 17 & 28.125 & -11.125 \tabularnewline
146 & 13 & 11.5714285714286 & 1.42857142857143 \tabularnewline
147 & 12 & 11.5714285714286 & 0.428571428571429 \tabularnewline
148 & 11 & 11.5714285714286 & -0.571428571428571 \tabularnewline
149 & 9 & 11.5714285714286 & -2.57142857142857 \tabularnewline
150 & 9 & 11.5714285714286 & -2.57142857142857 \tabularnewline
151 & 7 & 2 & 5 \tabularnewline
152 & 7 & 11.5714285714286 & -4.57142857142857 \tabularnewline
153 & 6 & 2 & 4 \tabularnewline
154 & 6 & 2 & 4 \tabularnewline
155 & 5 & 2 & 3 \tabularnewline
156 & 2 & 2 & 0 \tabularnewline
157 & 0 & 2 & -2 \tabularnewline
158 & 0 & 2 & -2 \tabularnewline
159 & 0 & 2 & -2 \tabularnewline
160 & 0 & 2 & -2 \tabularnewline
161 & 0 & 2 & -2 \tabularnewline
162 & 0 & 2 & -2 \tabularnewline
163 & 0 & 2 & -2 \tabularnewline
164 & 0 & 2 & -2 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=168749&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]198[/C][C]115.071428571429[/C][C]82.9285714285714[/C][/ROW]
[ROW][C]2[/C][C]153[/C][C]115.071428571429[/C][C]37.9285714285714[/C][/ROW]
[ROW][C]3[/C][C]150[/C][C]115.071428571429[/C][C]34.9285714285714[/C][/ROW]
[ROW][C]4[/C][C]148[/C][C]115.071428571429[/C][C]32.9285714285714[/C][/ROW]
[ROW][C]5[/C][C]147[/C][C]96.2608695652174[/C][C]50.7391304347826[/C][/ROW]
[ROW][C]6[/C][C]138[/C][C]115.071428571429[/C][C]22.9285714285714[/C][/ROW]
[ROW][C]7[/C][C]137[/C][C]82.6944444444444[/C][C]54.3055555555556[/C][/ROW]
[ROW][C]8[/C][C]136[/C][C]115.071428571429[/C][C]20.9285714285714[/C][/ROW]
[ROW][C]9[/C][C]136[/C][C]115.071428571429[/C][C]20.9285714285714[/C][/ROW]
[ROW][C]10[/C][C]135[/C][C]96.2608695652174[/C][C]38.7391304347826[/C][/ROW]
[ROW][C]11[/C][C]130[/C][C]96.2608695652174[/C][C]33.7391304347826[/C][/ROW]
[ROW][C]12[/C][C]129[/C][C]96.2608695652174[/C][C]32.7391304347826[/C][/ROW]
[ROW][C]13[/C][C]127[/C][C]115.071428571429[/C][C]11.9285714285714[/C][/ROW]
[ROW][C]14[/C][C]126[/C][C]96.2608695652174[/C][C]29.7391304347826[/C][/ROW]
[ROW][C]15[/C][C]126[/C][C]115.071428571429[/C][C]10.9285714285714[/C][/ROW]
[ROW][C]16[/C][C]122[/C][C]96.2608695652174[/C][C]25.7391304347826[/C][/ROW]
[ROW][C]17[/C][C]121[/C][C]96.2608695652174[/C][C]24.7391304347826[/C][/ROW]
[ROW][C]18[/C][C]121[/C][C]96.2608695652174[/C][C]24.7391304347826[/C][/ROW]
[ROW][C]19[/C][C]121[/C][C]115.071428571429[/C][C]5.92857142857143[/C][/ROW]
[ROW][C]20[/C][C]120[/C][C]82.6944444444444[/C][C]37.3055555555556[/C][/ROW]
[ROW][C]21[/C][C]118[/C][C]115.071428571429[/C][C]2.92857142857143[/C][/ROW]
[ROW][C]22[/C][C]118[/C][C]115.071428571429[/C][C]2.92857142857143[/C][/ROW]
[ROW][C]23[/C][C]116[/C][C]82.6944444444444[/C][C]33.3055555555556[/C][/ROW]
[ROW][C]24[/C][C]116[/C][C]96.2608695652174[/C][C]19.7391304347826[/C][/ROW]
[ROW][C]25[/C][C]115[/C][C]96.2608695652174[/C][C]18.7391304347826[/C][/ROW]
[ROW][C]26[/C][C]112[/C][C]96.2608695652174[/C][C]15.7391304347826[/C][/ROW]
[ROW][C]27[/C][C]112[/C][C]115.071428571429[/C][C]-3.07142857142857[/C][/ROW]
[ROW][C]28[/C][C]112[/C][C]115.071428571429[/C][C]-3.07142857142857[/C][/ROW]
[ROW][C]29[/C][C]111[/C][C]115.071428571429[/C][C]-4.07142857142857[/C][/ROW]
[ROW][C]30[/C][C]111[/C][C]96.2608695652174[/C][C]14.7391304347826[/C][/ROW]
[ROW][C]31[/C][C]110[/C][C]82.6944444444444[/C][C]27.3055555555556[/C][/ROW]
[ROW][C]32[/C][C]108[/C][C]96.2608695652174[/C][C]11.7391304347826[/C][/ROW]
[ROW][C]33[/C][C]107[/C][C]115.071428571429[/C][C]-8.07142857142857[/C][/ROW]
[ROW][C]34[/C][C]107[/C][C]96.2608695652174[/C][C]10.7391304347826[/C][/ROW]
[ROW][C]35[/C][C]107[/C][C]115.071428571429[/C][C]-8.07142857142857[/C][/ROW]
[ROW][C]36[/C][C]106[/C][C]96.2608695652174[/C][C]9.73913043478261[/C][/ROW]
[ROW][C]37[/C][C]106[/C][C]115.071428571429[/C][C]-9.07142857142857[/C][/ROW]
[ROW][C]38[/C][C]104[/C][C]115.071428571429[/C][C]-11.0714285714286[/C][/ROW]
[ROW][C]39[/C][C]104[/C][C]96.2608695652174[/C][C]7.73913043478261[/C][/ROW]
[ROW][C]40[/C][C]104[/C][C]115.071428571429[/C][C]-11.0714285714286[/C][/ROW]
[ROW][C]41[/C][C]103[/C][C]96.2608695652174[/C][C]6.73913043478261[/C][/ROW]
[ROW][C]42[/C][C]103[/C][C]115.071428571429[/C][C]-12.0714285714286[/C][/ROW]
[ROW][C]43[/C][C]103[/C][C]96.2608695652174[/C][C]6.73913043478261[/C][/ROW]
[ROW][C]44[/C][C]102[/C][C]96.2608695652174[/C][C]5.73913043478261[/C][/ROW]
[ROW][C]45[/C][C]102[/C][C]64.3461538461538[/C][C]37.6538461538462[/C][/ROW]
[ROW][C]46[/C][C]101[/C][C]82.6944444444444[/C][C]18.3055555555556[/C][/ROW]
[ROW][C]47[/C][C]101[/C][C]96.2608695652174[/C][C]4.73913043478261[/C][/ROW]
[ROW][C]48[/C][C]100[/C][C]96.2608695652174[/C][C]3.73913043478261[/C][/ROW]
[ROW][C]49[/C][C]99[/C][C]96.2608695652174[/C][C]2.73913043478261[/C][/ROW]
[ROW][C]50[/C][C]99[/C][C]115.071428571429[/C][C]-16.0714285714286[/C][/ROW]
[ROW][C]51[/C][C]97[/C][C]82.6944444444444[/C][C]14.3055555555556[/C][/ROW]
[ROW][C]52[/C][C]97[/C][C]115.071428571429[/C][C]-18.0714285714286[/C][/ROW]
[ROW][C]53[/C][C]96[/C][C]82.6944444444444[/C][C]13.3055555555556[/C][/ROW]
[ROW][C]54[/C][C]95[/C][C]96.2608695652174[/C][C]-1.26086956521739[/C][/ROW]
[ROW][C]55[/C][C]95[/C][C]96.2608695652174[/C][C]-1.26086956521739[/C][/ROW]
[ROW][C]56[/C][C]94[/C][C]96.2608695652174[/C][C]-2.26086956521739[/C][/ROW]
[ROW][C]57[/C][C]94[/C][C]96.2608695652174[/C][C]-2.26086956521739[/C][/ROW]
[ROW][C]58[/C][C]91[/C][C]82.6944444444444[/C][C]8.30555555555556[/C][/ROW]
[ROW][C]59[/C][C]91[/C][C]96.2608695652174[/C][C]-5.26086956521739[/C][/ROW]
[ROW][C]60[/C][C]90[/C][C]82.6944444444444[/C][C]7.30555555555556[/C][/ROW]
[ROW][C]61[/C][C]90[/C][C]115.071428571429[/C][C]-25.0714285714286[/C][/ROW]
[ROW][C]62[/C][C]90[/C][C]82.6944444444444[/C][C]7.30555555555556[/C][/ROW]
[ROW][C]63[/C][C]89[/C][C]64.3461538461538[/C][C]24.6538461538462[/C][/ROW]
[ROW][C]64[/C][C]89[/C][C]96.2608695652174[/C][C]-7.26086956521739[/C][/ROW]
[ROW][C]65[/C][C]89[/C][C]82.6944444444444[/C][C]6.30555555555556[/C][/ROW]
[ROW][C]66[/C][C]87[/C][C]82.6944444444444[/C][C]4.30555555555556[/C][/ROW]
[ROW][C]67[/C][C]87[/C][C]96.2608695652174[/C][C]-9.26086956521739[/C][/ROW]
[ROW][C]68[/C][C]87[/C][C]64.3461538461538[/C][C]22.6538461538462[/C][/ROW]
[ROW][C]69[/C][C]87[/C][C]82.6944444444444[/C][C]4.30555555555556[/C][/ROW]
[ROW][C]70[/C][C]86[/C][C]82.6944444444444[/C][C]3.30555555555556[/C][/ROW]
[ROW][C]71[/C][C]86[/C][C]96.2608695652174[/C][C]-10.2608695652174[/C][/ROW]
[ROW][C]72[/C][C]86[/C][C]82.6944444444444[/C][C]3.30555555555556[/C][/ROW]
[ROW][C]73[/C][C]86[/C][C]96.2608695652174[/C][C]-10.2608695652174[/C][/ROW]
[ROW][C]74[/C][C]86[/C][C]96.2608695652174[/C][C]-10.2608695652174[/C][/ROW]
[ROW][C]75[/C][C]85[/C][C]96.2608695652174[/C][C]-11.2608695652174[/C][/ROW]
[ROW][C]76[/C][C]85[/C][C]115.071428571429[/C][C]-30.0714285714286[/C][/ROW]
[ROW][C]77[/C][C]84[/C][C]64.3461538461538[/C][C]19.6538461538462[/C][/ROW]
[ROW][C]78[/C][C]84[/C][C]82.6944444444444[/C][C]1.30555555555556[/C][/ROW]
[ROW][C]79[/C][C]84[/C][C]115.071428571429[/C][C]-31.0714285714286[/C][/ROW]
[ROW][C]80[/C][C]83[/C][C]82.6944444444444[/C][C]0.305555555555557[/C][/ROW]
[ROW][C]81[/C][C]82[/C][C]96.2608695652174[/C][C]-14.2608695652174[/C][/ROW]
[ROW][C]82[/C][C]82[/C][C]115.071428571429[/C][C]-33.0714285714286[/C][/ROW]
[ROW][C]83[/C][C]82[/C][C]64.3461538461538[/C][C]17.6538461538462[/C][/ROW]
[ROW][C]84[/C][C]80[/C][C]96.2608695652174[/C][C]-16.2608695652174[/C][/ROW]
[ROW][C]85[/C][C]79[/C][C]96.2608695652174[/C][C]-17.2608695652174[/C][/ROW]
[ROW][C]86[/C][C]79[/C][C]82.6944444444444[/C][C]-3.69444444444444[/C][/ROW]
[ROW][C]87[/C][C]79[/C][C]96.2608695652174[/C][C]-17.2608695652174[/C][/ROW]
[ROW][C]88[/C][C]79[/C][C]82.6944444444444[/C][C]-3.69444444444444[/C][/ROW]
[ROW][C]89[/C][C]79[/C][C]82.6944444444444[/C][C]-3.69444444444444[/C][/ROW]
[ROW][C]90[/C][C]78[/C][C]96.2608695652174[/C][C]-18.2608695652174[/C][/ROW]
[ROW][C]91[/C][C]77[/C][C]96.2608695652174[/C][C]-19.2608695652174[/C][/ROW]
[ROW][C]92[/C][C]76[/C][C]82.6944444444444[/C][C]-6.69444444444444[/C][/ROW]
[ROW][C]93[/C][C]75[/C][C]64.3461538461538[/C][C]10.6538461538462[/C][/ROW]
[ROW][C]94[/C][C]74[/C][C]82.6944444444444[/C][C]-8.69444444444444[/C][/ROW]
[ROW][C]95[/C][C]74[/C][C]64.3461538461538[/C][C]9.65384615384616[/C][/ROW]
[ROW][C]96[/C][C]73[/C][C]96.2608695652174[/C][C]-23.2608695652174[/C][/ROW]
[ROW][C]97[/C][C]72[/C][C]82.6944444444444[/C][C]-10.6944444444444[/C][/ROW]
[ROW][C]98[/C][C]72[/C][C]82.6944444444444[/C][C]-10.6944444444444[/C][/ROW]
[ROW][C]99[/C][C]72[/C][C]82.6944444444444[/C][C]-10.6944444444444[/C][/ROW]
[ROW][C]100[/C][C]72[/C][C]82.6944444444444[/C][C]-10.6944444444444[/C][/ROW]
[ROW][C]101[/C][C]71[/C][C]82.6944444444444[/C][C]-11.6944444444444[/C][/ROW]
[ROW][C]102[/C][C]71[/C][C]82.6944444444444[/C][C]-11.6944444444444[/C][/ROW]
[ROW][C]103[/C][C]71[/C][C]64.3461538461538[/C][C]6.65384615384616[/C][/ROW]
[ROW][C]104[/C][C]70[/C][C]64.3461538461538[/C][C]5.65384615384616[/C][/ROW]
[ROW][C]105[/C][C]69[/C][C]82.6944444444444[/C][C]-13.6944444444444[/C][/ROW]
[ROW][C]106[/C][C]69[/C][C]82.6944444444444[/C][C]-13.6944444444444[/C][/ROW]
[ROW][C]107[/C][C]69[/C][C]96.2608695652174[/C][C]-27.2608695652174[/C][/ROW]
[ROW][C]108[/C][C]68[/C][C]64.3461538461538[/C][C]3.65384615384616[/C][/ROW]
[ROW][C]109[/C][C]67[/C][C]96.2608695652174[/C][C]-29.2608695652174[/C][/ROW]
[ROW][C]110[/C][C]66[/C][C]82.6944444444444[/C][C]-16.6944444444444[/C][/ROW]
[ROW][C]111[/C][C]66[/C][C]64.3461538461538[/C][C]1.65384615384616[/C][/ROW]
[ROW][C]112[/C][C]65[/C][C]64.3461538461538[/C][C]0.65384615384616[/C][/ROW]
[ROW][C]113[/C][C]65[/C][C]82.6944444444444[/C][C]-17.6944444444444[/C][/ROW]
[ROW][C]114[/C][C]65[/C][C]96.2608695652174[/C][C]-31.2608695652174[/C][/ROW]
[ROW][C]115[/C][C]65[/C][C]64.3461538461538[/C][C]0.65384615384616[/C][/ROW]
[ROW][C]116[/C][C]64[/C][C]82.6944444444444[/C][C]-18.6944444444444[/C][/ROW]
[ROW][C]117[/C][C]63[/C][C]82.6944444444444[/C][C]-19.6944444444444[/C][/ROW]
[ROW][C]118[/C][C]63[/C][C]64.3461538461538[/C][C]-1.34615384615384[/C][/ROW]
[ROW][C]119[/C][C]63[/C][C]64.3461538461538[/C][C]-1.34615384615384[/C][/ROW]
[ROW][C]120[/C][C]61[/C][C]64.3461538461538[/C][C]-3.34615384615384[/C][/ROW]
[ROW][C]121[/C][C]60[/C][C]96.2608695652174[/C][C]-36.2608695652174[/C][/ROW]
[ROW][C]122[/C][C]60[/C][C]82.6944444444444[/C][C]-22.6944444444444[/C][/ROW]
[ROW][C]123[/C][C]60[/C][C]64.3461538461538[/C][C]-4.34615384615384[/C][/ROW]
[ROW][C]124[/C][C]58[/C][C]64.3461538461538[/C][C]-6.34615384615384[/C][/ROW]
[ROW][C]125[/C][C]58[/C][C]96.2608695652174[/C][C]-38.2608695652174[/C][/ROW]
[ROW][C]126[/C][C]56[/C][C]64.3461538461538[/C][C]-8.34615384615384[/C][/ROW]
[ROW][C]127[/C][C]56[/C][C]64.3461538461538[/C][C]-8.34615384615384[/C][/ROW]
[ROW][C]128[/C][C]55[/C][C]64.3461538461538[/C][C]-9.34615384615384[/C][/ROW]
[ROW][C]129[/C][C]55[/C][C]96.2608695652174[/C][C]-41.2608695652174[/C][/ROW]
[ROW][C]130[/C][C]54[/C][C]82.6944444444444[/C][C]-28.6944444444444[/C][/ROW]
[ROW][C]131[/C][C]51[/C][C]64.3461538461538[/C][C]-13.3461538461538[/C][/ROW]
[ROW][C]132[/C][C]50[/C][C]115.071428571429[/C][C]-65.0714285714286[/C][/ROW]
[ROW][C]133[/C][C]50[/C][C]64.3461538461538[/C][C]-14.3461538461538[/C][/ROW]
[ROW][C]134[/C][C]42[/C][C]64.3461538461538[/C][C]-22.3461538461538[/C][/ROW]
[ROW][C]135[/C][C]41[/C][C]28.125[/C][C]12.875[/C][/ROW]
[ROW][C]136[/C][C]40[/C][C]28.125[/C][C]11.875[/C][/ROW]
[ROW][C]137[/C][C]38[/C][C]64.3461538461538[/C][C]-26.3461538461538[/C][/ROW]
[ROW][C]138[/C][C]36[/C][C]28.125[/C][C]7.875[/C][/ROW]
[ROW][C]139[/C][C]28[/C][C]28.125[/C][C]-0.125[/C][/ROW]
[ROW][C]140[/C][C]25[/C][C]28.125[/C][C]-3.125[/C][/ROW]
[ROW][C]141[/C][C]22[/C][C]64.3461538461538[/C][C]-42.3461538461538[/C][/ROW]
[ROW][C]142[/C][C]20[/C][C]11.5714285714286[/C][C]8.42857142857143[/C][/ROW]
[ROW][C]143[/C][C]20[/C][C]28.125[/C][C]-8.125[/C][/ROW]
[ROW][C]144[/C][C]18[/C][C]28.125[/C][C]-10.125[/C][/ROW]
[ROW][C]145[/C][C]17[/C][C]28.125[/C][C]-11.125[/C][/ROW]
[ROW][C]146[/C][C]13[/C][C]11.5714285714286[/C][C]1.42857142857143[/C][/ROW]
[ROW][C]147[/C][C]12[/C][C]11.5714285714286[/C][C]0.428571428571429[/C][/ROW]
[ROW][C]148[/C][C]11[/C][C]11.5714285714286[/C][C]-0.571428571428571[/C][/ROW]
[ROW][C]149[/C][C]9[/C][C]11.5714285714286[/C][C]-2.57142857142857[/C][/ROW]
[ROW][C]150[/C][C]9[/C][C]11.5714285714286[/C][C]-2.57142857142857[/C][/ROW]
[ROW][C]151[/C][C]7[/C][C]2[/C][C]5[/C][/ROW]
[ROW][C]152[/C][C]7[/C][C]11.5714285714286[/C][C]-4.57142857142857[/C][/ROW]
[ROW][C]153[/C][C]6[/C][C]2[/C][C]4[/C][/ROW]
[ROW][C]154[/C][C]6[/C][C]2[/C][C]4[/C][/ROW]
[ROW][C]155[/C][C]5[/C][C]2[/C][C]3[/C][/ROW]
[ROW][C]156[/C][C]2[/C][C]2[/C][C]0[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]2[/C][C]-2[/C][/ROW]
[ROW][C]158[/C][C]0[/C][C]2[/C][C]-2[/C][/ROW]
[ROW][C]159[/C][C]0[/C][C]2[/C][C]-2[/C][/ROW]
[ROW][C]160[/C][C]0[/C][C]2[/C][C]-2[/C][/ROW]
[ROW][C]161[/C][C]0[/C][C]2[/C][C]-2[/C][/ROW]
[ROW][C]162[/C][C]0[/C][C]2[/C][C]-2[/C][/ROW]
[ROW][C]163[/C][C]0[/C][C]2[/C][C]-2[/C][/ROW]
[ROW][C]164[/C][C]0[/C][C]2[/C][C]-2[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=168749&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=168749&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
1198115.07142857142982.9285714285714
2153115.07142857142937.9285714285714
3150115.07142857142934.9285714285714
4148115.07142857142932.9285714285714
514796.260869565217450.7391304347826
6138115.07142857142922.9285714285714
713782.694444444444454.3055555555556
8136115.07142857142920.9285714285714
9136115.07142857142920.9285714285714
1013596.260869565217438.7391304347826
1113096.260869565217433.7391304347826
1212996.260869565217432.7391304347826
13127115.07142857142911.9285714285714
1412696.260869565217429.7391304347826
15126115.07142857142910.9285714285714
1612296.260869565217425.7391304347826
1712196.260869565217424.7391304347826
1812196.260869565217424.7391304347826
19121115.0714285714295.92857142857143
2012082.694444444444437.3055555555556
21118115.0714285714292.92857142857143
22118115.0714285714292.92857142857143
2311682.694444444444433.3055555555556
2411696.260869565217419.7391304347826
2511596.260869565217418.7391304347826
2611296.260869565217415.7391304347826
27112115.071428571429-3.07142857142857
28112115.071428571429-3.07142857142857
29111115.071428571429-4.07142857142857
3011196.260869565217414.7391304347826
3111082.694444444444427.3055555555556
3210896.260869565217411.7391304347826
33107115.071428571429-8.07142857142857
3410796.260869565217410.7391304347826
35107115.071428571429-8.07142857142857
3610696.26086956521749.73913043478261
37106115.071428571429-9.07142857142857
38104115.071428571429-11.0714285714286
3910496.26086956521747.73913043478261
40104115.071428571429-11.0714285714286
4110396.26086956521746.73913043478261
42103115.071428571429-12.0714285714286
4310396.26086956521746.73913043478261
4410296.26086956521745.73913043478261
4510264.346153846153837.6538461538462
4610182.694444444444418.3055555555556
4710196.26086956521744.73913043478261
4810096.26086956521743.73913043478261
499996.26086956521742.73913043478261
5099115.071428571429-16.0714285714286
519782.694444444444414.3055555555556
5297115.071428571429-18.0714285714286
539682.694444444444413.3055555555556
549596.2608695652174-1.26086956521739
559596.2608695652174-1.26086956521739
569496.2608695652174-2.26086956521739
579496.2608695652174-2.26086956521739
589182.69444444444448.30555555555556
599196.2608695652174-5.26086956521739
609082.69444444444447.30555555555556
6190115.071428571429-25.0714285714286
629082.69444444444447.30555555555556
638964.346153846153824.6538461538462
648996.2608695652174-7.26086956521739
658982.69444444444446.30555555555556
668782.69444444444444.30555555555556
678796.2608695652174-9.26086956521739
688764.346153846153822.6538461538462
698782.69444444444444.30555555555556
708682.69444444444443.30555555555556
718696.2608695652174-10.2608695652174
728682.69444444444443.30555555555556
738696.2608695652174-10.2608695652174
748696.2608695652174-10.2608695652174
758596.2608695652174-11.2608695652174
7685115.071428571429-30.0714285714286
778464.346153846153819.6538461538462
788482.69444444444441.30555555555556
7984115.071428571429-31.0714285714286
808382.69444444444440.305555555555557
818296.2608695652174-14.2608695652174
8282115.071428571429-33.0714285714286
838264.346153846153817.6538461538462
848096.2608695652174-16.2608695652174
857996.2608695652174-17.2608695652174
867982.6944444444444-3.69444444444444
877996.2608695652174-17.2608695652174
887982.6944444444444-3.69444444444444
897982.6944444444444-3.69444444444444
907896.2608695652174-18.2608695652174
917796.2608695652174-19.2608695652174
927682.6944444444444-6.69444444444444
937564.346153846153810.6538461538462
947482.6944444444444-8.69444444444444
957464.34615384615389.65384615384616
967396.2608695652174-23.2608695652174
977282.6944444444444-10.6944444444444
987282.6944444444444-10.6944444444444
997282.6944444444444-10.6944444444444
1007282.6944444444444-10.6944444444444
1017182.6944444444444-11.6944444444444
1027182.6944444444444-11.6944444444444
1037164.34615384615386.65384615384616
1047064.34615384615385.65384615384616
1056982.6944444444444-13.6944444444444
1066982.6944444444444-13.6944444444444
1076996.2608695652174-27.2608695652174
1086864.34615384615383.65384615384616
1096796.2608695652174-29.2608695652174
1106682.6944444444444-16.6944444444444
1116664.34615384615381.65384615384616
1126564.34615384615380.65384615384616
1136582.6944444444444-17.6944444444444
1146596.2608695652174-31.2608695652174
1156564.34615384615380.65384615384616
1166482.6944444444444-18.6944444444444
1176382.6944444444444-19.6944444444444
1186364.3461538461538-1.34615384615384
1196364.3461538461538-1.34615384615384
1206164.3461538461538-3.34615384615384
1216096.2608695652174-36.2608695652174
1226082.6944444444444-22.6944444444444
1236064.3461538461538-4.34615384615384
1245864.3461538461538-6.34615384615384
1255896.2608695652174-38.2608695652174
1265664.3461538461538-8.34615384615384
1275664.3461538461538-8.34615384615384
1285564.3461538461538-9.34615384615384
1295596.2608695652174-41.2608695652174
1305482.6944444444444-28.6944444444444
1315164.3461538461538-13.3461538461538
13250115.071428571429-65.0714285714286
1335064.3461538461538-14.3461538461538
1344264.3461538461538-22.3461538461538
1354128.12512.875
1364028.12511.875
1373864.3461538461538-26.3461538461538
1383628.1257.875
1392828.125-0.125
1402528.125-3.125
1412264.3461538461538-42.3461538461538
1422011.57142857142868.42857142857143
1432028.125-8.125
1441828.125-10.125
1451728.125-11.125
1461311.57142857142861.42857142857143
1471211.57142857142860.428571428571429
1481111.5714285714286-0.571428571428571
149911.5714285714286-2.57142857142857
150911.5714285714286-2.57142857142857
151725
152711.5714285714286-4.57142857142857
153624
154624
155523
156220
15702-2
15802-2
15902-2
16002-2
16102-2
16202-2
16302-2
16402-2



Parameters (Session):
par1 = 4 ; par2 = none ; par3 = 3 ; par4 = no ;
Parameters (R input):
par1 = 4 ; par2 = none ; par3 = 3 ; par4 = no ;
R code (references can be found in the software module):
par4 <- 'no'
par3 <- '3'
par2 <- 'none'
par1 <- '5'
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')
}