Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationThu, 22 Dec 2011 14:06:51 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2011/Dec/22/t1324580912kqd61w7593d40ep.htm/, Retrieved Fri, 03 May 2024 07:32:50 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=159870, Retrieved Fri, 03 May 2024 07:32:50 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact74
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [regression tree] [2011-12-22 19:06:51] [9aaeed430538c8fa0389aee05c40e1f1] [Current]
Feedback Forum

Post a new message
Dataseries X:
210907	56	396	145	0
120982	56	297	101	0
176508	54	559	98	0
179321	89	967	132	NA
123185	40	270	60	NA
52746	25	143	38	NA
385534	92	1562	144	NA
33170	18	109	5	NA
101645	63	371	28	NA
149061	44	656	84	0
165446	33	511	79	NA
237213	84	655	127	0
173326	88	465	78	NA
133131	55	525	60	1
258873	60	885	131	NA
180083	66	497	84	NA
324799	154	1436	133	0
230964	53	612	150	0
236785	119	865	91	1
135473	41	385	132	NA
202925	61	567	136	NA
215147	58	639	124	NA
344297	75	963	118	0
153935	33	398	70	NA
132943	40	410	107	NA
174724	92	966	119	0
174415	100	801	89	0
225548	112	892	112	NA
223632	73	513	108	0
124817	40	469	52	0
221698	45	683	112	NA
210767	60	643	116	NA
170266	62	535	123	NA
260561	75	625	125	NA
84853	31	264	27	NA
294424	77	992	162	0
101011	34	238	32	NA
215641	46	818	64	NA
325107	99	937	92	NA
7176	17	70	0	NA
167542	66	507	83	NA
106408	30	260	41	0
96560	76	503	47	0
265769	146	927	120	0
269651	67	1269	105	NA
149112	56	537	79	1
175824	107	910	65	0
152871	58	532	70	0
111665	34	345	55	0
116408	61	918	39	NA
362301	119	1635	67	0
78800	42	330	21	NA
183167	66	557	127	0
277965	89	1178	152	NA
150629	44	740	113	NA
168809	66	452	99	NA
24188	24	218	7	NA
329267	259	764	141	0
65029	17	255	21	NA
101097	64	454	35	NA
218946	41	866	109	1
244052	68	574	133	0
341570	168	1276	123	1
103597	43	379	26	0
233328	132	825	230	NA
256462	105	798	166	NA
206161	71	663	68	NA
311473	112	1069	147	NA
235800	94	921	179	NA
177939	82	858	61	NA
207176	70	711	101	NA
196553	57	503	108	0
174184	53	382	90	NA
143246	103	464	114	0
187559	121	717	103	NA
187681	62	690	142	NA
119016	52	462	79	NA
182192	52	657	88	NA
73566	32	385	25	NA
194979	62	577	83	NA
167488	45	619	113	0
143756	46	479	118	0
			110	NA
			129	NA
			51	0
			93	NA
			76	0
			49	NA
			118	0
			38	NA
			141	0
			58	NA
			27	0
			91	0
			48	1
			63	0
			56	NA
			144	NA
			73	NA
			168	1
			64	1
			97	0
			117	1
			100	0
			149	NA
			187	NA
			127	NA
			37	0
			245	NA
			87	1
			177	NA
			49	NA
			49	NA
			73	NA
			177	0
			94	NA
			117	NA
			60	0
			55	0
			39	0
			64	1
			26	0
			64	NA
			58	1
			95	NA
			25	NA
			26	NA
			76	0
			129	0
			11	NA
			2	NA
			101	1
			28	NA
			36	0
			89	0
			193	NA
			4	NA
			84	NA
			23	0
			39	NA
			14	NA
			78	1
			14	NA
			101	1
			82	NA
			24	NA
			36	1
			75	1
			16	NA
			55	NA
			131	0
			131	0
			39	0
			144	0
			139	NA
			211	0
			78	NA
			50	NA
			39	NA
			90	0
			166	NA
			12	NA
			57	0
			133	0
			69	0
			119	NA
			119	NA
			65	NA
			61	1
			49	1
			101	0
			196	0
			15	0
			136	0
			89	NA
			40	NA
			123	NA
			21	0
			163	0
			29	0
			35	NA
			13	NA
			5	NA
			96	1
			151	NA
			6	NA
			13	NA
			3	NA
			56	NA
			23	NA
			57	NA
			14	1
			43	NA
			20	0
			72	NA
			87	1
			21	NA
			56	0
			59	NA
			82	NA
			43	NA
			25	NA
			38	NA
			25	0
			38	NA
			12	NA
			29	NA
			47	0
			45	0
			40	NA
			30	NA
			41	0
			25	NA
			23	NA
			14	0
			16	0
			26	NA
			21	0
			27	NA
			9	NA
			33	0
			42	0
			68	0
			32	NA
			6	NA
			67	NA
			33	NA
			77	0
			46	NA
			30	NA
			0	0
			36	0
			46	NA
			18	NA
			48	1
			29	0
			28	1
			34	NA
			33	0
			34	NA
			33	NA
			80	NA
			32	NA
			30	NA
			41	NA
			41	NA
			51	0
			18	0
			34	NA
			31	NA
			39	0
			54	0
			14	NA
			24	0
			24	0
			8	NA
			26	NA
			19	NA
			11	NA
			14	NA
			1	NA
			39	NA
			5	NA
			37	0
			32	NA
			38	NA
			47	0
			47	0
			37	0
			51	NA
			45	NA
			21	NA
			1	NA
			42	NA
			26	NA
			21	NA
			4	NA
			10	NA
			43	NA
			34	0
			31	NA
			19	NA
			34	NA
			6	NA
			11	0
			24	NA
			16	NA
			72	NA
			21	NA




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'AstonUniversity' @ aston.wessa.net
R Framework error message
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 4 seconds \tabularnewline
R Server & 'AstonUniversity' @ aston.wessa.net \tabularnewline
R Framework error message & 
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.
\tabularnewline \hline \end{tabular} %Source: https://freestatistics.org/blog/index.php?pk=159870&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]4 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'AstonUniversity' @ aston.wessa.net[/C][/ROW]
[ROW][C]R Framework error message[/C][C]
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.
[/C][/ROW] [/TABLE] Source: https://freestatistics.org/blog/index.php?pk=159870&T=0

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

As an alternative you can also use a QR Code:  

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

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'AstonUniversity' @ aston.wessa.net
R Framework error message
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.







Goodness of Fit
Correlation0.9731
R-squared0.947
RMSE22397.4735

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.9731[/C][/ROW]
[ROW][C]R-squared[/C][C]0.947[/C][/ROW]
[ROW][C]RMSE[/C][C]22397.4735[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159870&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159870&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.9731
R-squared0.947
RMSE22397.4735







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1210907158867.37552039.625
2120982158867.375-37885.375
3176508197916.625-21408.625
4179321292338.214285714-113017.214285714
512318510586117324
652746595.68604651162852150.3139534884
7385534292338.21428571493195.7857142857
833170595.68604651162832574.3139534884
9101645105861-4216
10149061197916.625-48855.625
11165446158867.3756578.625
12237213217205.52941176520007.4705882353
13173326217205.529411765-43879.5294117647
1413313110586127270
15258873197916.62560956.375
16180083158867.37521215.625
17324799292338.21428571432460.7857142857
18230964197916.62533047.375
19236785217205.52941176519579.4705882353
20135473158867.375-23394.375
21202925197916.6255008.375
22215147197916.62517230.375
23344297292338.21428571451958.7857142857
24153935158867.375-4932.375
25132943158867.375-25924.375
26174724292338.214285714-117614.214285714
27174415217205.529411765-42790.5294117647
28225548217205.5294117658342.4705882353
29223632217205.5294117656426.4705882353
3012481710586118956
31221698197916.62523781.375
32210767197916.62512850.375
33170266158867.37511398.625
34260561217205.52941176543355.4705882353
358485354522.571428571430330.4285714286
36294424292338.2142857142085.78571428574
3710101154522.571428571446488.4285714286
38215641197916.62517724.375
39325107292338.21428571432768.7857142857
407176595.6860465116286580.31395348837
41167542158867.3758674.625
4210640854522.571428571451885.4285714286
4396560105861-9301
44265769292338.214285714-26569.2142857143
45269651292338.214285714-22687.2142857143
46149112158867.375-9755.375
47175824217205.529411765-41381.5294117647
48152871158867.375-5996.375
491116651058615804
5011640810586110547
51362301292338.21428571469962.7857142857
5278800105861-27061
53183167197916.625-14749.625
54277965292338.214285714-14373.2142857143
55150629197916.625-47287.625
56168809158867.3759941.625
572418854522.5714285714-30334.5714285714
58329267217205.529411765112061.470588235
596502954522.571428571410506.4285714286
60101097105861-4764
61218946197916.62521029.375
62244052217205.52941176526846.4705882353
63341570292338.21428571449231.7857142857
64103597105861-2264
65233328217205.52941176516122.4705882353
66256462217205.52941176539256.4705882353
67206161217205.529411765-11044.5294117647
68311473292338.21428571419134.7857142857
69235800292338.214285714-56538.2142857143
70177939217205.529411765-39266.5294117647
71207176217205.529411765-10029.5294117647
72196553158867.37537685.625
73174184158867.37515316.625
74143246217205.529411765-73959.5294117647
75187559217205.529411765-29646.5294117647
76187681197916.625-10235.625
77119016158867.375-39851.375
78182192197916.625-15724.625
7973566105861-32295
80194979197916.625-2937.625
81167488197916.625-30428.625
82143756158867.375-15111.375
83110595.686046511628-485.686046511628
840595.686046511628-595.686046511628
8549595.686046511628-546.686046511628
8627595.686046511628-568.686046511628
871595.686046511628-594.686046511628
88144595.686046511628-451.686046511628
891595.686046511628-594.686046511628
90117595.686046511628-478.686046511628
913754522.5714285714-54485.5714285714
921595.686046511628-594.686046511628
9349595.686046511628-546.686046511628
940595.686046511628-595.686046511628
9560595.686046511628-535.686046511628
960595.686046511628-595.686046511628
9764595.686046511628-531.686046511628
9876595.686046511628-519.686046511628
9928595.686046511628-567.686046511628
1000595.686046511628-595.686046511628
10184595.686046511628-511.686046511628
10214595.686046511628-581.686046511628
10375595.686046511628-520.686046511628
10439595.686046511628-556.686046511628
10550595.686046511628-545.686046511628
1060595.686046511628-595.686046511628
10757595.686046511628-538.686046511628
1080595.686046511628-595.686046511628
10965595.686046511628-530.686046511628
1101595.686046511628-594.686046511628
11115595.686046511628-580.686046511628
11221595.686046511628-574.686046511628
1130595.686046511628-595.686046511628
1145595.686046511628-590.686046511628
1153595.686046511628-592.686046511628
11643595.686046511628-552.686046511628
11756595.686046511628-539.686046511628
11838595.686046511628-557.686046511628
11947595.686046511628-548.686046511628
12025595.686046511628-570.686046511628
1210595.686046511628-595.686046511628
12221595.686046511628-574.686046511628
12368595.686046511628-527.686046511628
12477595.686046511628-518.686046511628
12546595.686046511628-549.686046511628
1261595.686046511628-594.686046511628
12734595.686046511628-561.686046511628
12832595.686046511628-563.686046511628
12918595.686046511628-577.686046511628
13014595.686046511628-581.686046511628
1310595.686046511628-595.686046511628
13219595.686046511628-576.686046511628
1335595.686046511628-590.686046511628
13447595.686046511628-548.686046511628
1351595.686046511628-594.686046511628
13610595.686046511628-585.686046511628
1370595.686046511628-595.686046511628
13834595.686046511628-561.686046511628
1390595.686046511628-595.686046511628
14072595.686046511628-523.686046511628
14156595.686046511628-539.686046511628
14256595.686046511628-539.686046511628
14354595.686046511628-541.686046511628
14489595.686046511628-506.686046511628
14540595.686046511628-555.686046511628
14625595.686046511628-570.686046511628
14792595.686046511628-503.686046511628
14818595.686046511628-577.686046511628
14963595.686046511628-532.686046511628
15044595.686046511628-551.686046511628
15133595.686046511628-562.686046511628
15284595.686046511628-511.686046511628
15388595.686046511628-507.686046511628
15455595.686046511628-540.686046511628
15560595.686046511628-535.686046511628
15666595.686046511628-529.686046511628
157154595.686046511628-441.686046511628
15853595.686046511628-542.686046511628
159119595.686046511628-476.686046511628
16041595.686046511628-554.686046511628
16161595.686046511628-534.686046511628
16258595.686046511628-537.686046511628
16375595.686046511628-520.686046511628
16433595.686046511628-562.686046511628
16540595.686046511628-555.686046511628
16692595.686046511628-503.686046511628
167100595.686046511628-495.686046511628
168112595.686046511628-483.686046511628
16973595.686046511628-522.686046511628
17040595.686046511628-555.686046511628
17145595.686046511628-550.686046511628
17260595.686046511628-535.686046511628
17362595.686046511628-533.686046511628
17475595.686046511628-520.686046511628
17531595.686046511628-564.686046511628
17677595.686046511628-518.686046511628
17734595.686046511628-561.686046511628
17846595.686046511628-549.686046511628
17999595.686046511628-496.686046511628
18017595.686046511628-578.686046511628
18166595.686046511628-529.686046511628
18230595.686046511628-565.686046511628
18376595.686046511628-519.686046511628
184146595.686046511628-449.686046511628
18567595.686046511628-528.686046511628
18656595.686046511628-539.686046511628
187107595.686046511628-488.686046511628
18858595.686046511628-537.686046511628
18934595.686046511628-561.686046511628
19061595.686046511628-534.686046511628
191119595.686046511628-476.686046511628
19242595.686046511628-553.686046511628
19366595.686046511628-529.686046511628
19489595.686046511628-506.686046511628
19544595.686046511628-551.686046511628
19666595.686046511628-529.686046511628
19724595.686046511628-571.686046511628
198259595.686046511628-336.686046511628
19917595.686046511628-578.686046511628
20064595.686046511628-531.686046511628
20141595.686046511628-554.686046511628
20268595.686046511628-527.686046511628
203168595.686046511628-427.686046511628
20443595.686046511628-552.686046511628
20513254522.5714285714-54390.5714285714
206105595.686046511628-490.686046511628
20771595.686046511628-524.686046511628
208112595.686046511628-483.686046511628
20994595.686046511628-501.686046511628
21082595.686046511628-513.686046511628
21170595.686046511628-525.686046511628
21257595.686046511628-538.686046511628
21353595.686046511628-542.686046511628
214103595.686046511628-492.686046511628
215121595.686046511628-474.686046511628
21662595.686046511628-533.686046511628
21752595.686046511628-543.686046511628
21852595.686046511628-543.686046511628
21932595.686046511628-563.686046511628
22062595.686046511628-533.686046511628
22145595.686046511628-550.686046511628
22246595.686046511628-549.686046511628
22393595.686046511628-502.686046511628
224141595.686046511628-454.686046511628
2250595.686046511628-595.686046511628
22663595.686046511628-532.686046511628
22764595.686046511628-531.686046511628
2281595.686046511628-594.686046511628
229187595.686046511628-408.686046511628
2300595.686046511628-595.686046511628
231177595.686046511628-418.686046511628
23294595.686046511628-501.686046511628
2330595.686046511628-595.686046511628
23464595.686046511628-531.686046511628
23525595.686046511628-570.686046511628
2360595.686046511628-595.686046511628
2372595.686046511628-593.686046511628
238193595.686046511628-402.686046511628
23914595.686046511628-581.686046511628
24024595.686046511628-571.686046511628
2411595.686046511628-594.686046511628
242131595.686046511628-464.686046511628
2430595.686046511628-595.686046511628
244211595.686046511628-384.686046511628
245166595.686046511628-429.686046511628
2460595.686046511628-595.686046511628
247119595.686046511628-476.686046511628
248101595.686046511628-494.686046511628
2490595.686046511628-595.686046511628
25040595.686046511628-555.686046511628
2510595.686046511628-595.686046511628
25235595.686046511628-560.686046511628
2536595.686046511628-589.686046511628

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 210907 & 158867.375 & 52039.625 \tabularnewline
2 & 120982 & 158867.375 & -37885.375 \tabularnewline
3 & 176508 & 197916.625 & -21408.625 \tabularnewline
4 & 179321 & 292338.214285714 & -113017.214285714 \tabularnewline
5 & 123185 & 105861 & 17324 \tabularnewline
6 & 52746 & 595.686046511628 & 52150.3139534884 \tabularnewline
7 & 385534 & 292338.214285714 & 93195.7857142857 \tabularnewline
8 & 33170 & 595.686046511628 & 32574.3139534884 \tabularnewline
9 & 101645 & 105861 & -4216 \tabularnewline
10 & 149061 & 197916.625 & -48855.625 \tabularnewline
11 & 165446 & 158867.375 & 6578.625 \tabularnewline
12 & 237213 & 217205.529411765 & 20007.4705882353 \tabularnewline
13 & 173326 & 217205.529411765 & -43879.5294117647 \tabularnewline
14 & 133131 & 105861 & 27270 \tabularnewline
15 & 258873 & 197916.625 & 60956.375 \tabularnewline
16 & 180083 & 158867.375 & 21215.625 \tabularnewline
17 & 324799 & 292338.214285714 & 32460.7857142857 \tabularnewline
18 & 230964 & 197916.625 & 33047.375 \tabularnewline
19 & 236785 & 217205.529411765 & 19579.4705882353 \tabularnewline
20 & 135473 & 158867.375 & -23394.375 \tabularnewline
21 & 202925 & 197916.625 & 5008.375 \tabularnewline
22 & 215147 & 197916.625 & 17230.375 \tabularnewline
23 & 344297 & 292338.214285714 & 51958.7857142857 \tabularnewline
24 & 153935 & 158867.375 & -4932.375 \tabularnewline
25 & 132943 & 158867.375 & -25924.375 \tabularnewline
26 & 174724 & 292338.214285714 & -117614.214285714 \tabularnewline
27 & 174415 & 217205.529411765 & -42790.5294117647 \tabularnewline
28 & 225548 & 217205.529411765 & 8342.4705882353 \tabularnewline
29 & 223632 & 217205.529411765 & 6426.4705882353 \tabularnewline
30 & 124817 & 105861 & 18956 \tabularnewline
31 & 221698 & 197916.625 & 23781.375 \tabularnewline
32 & 210767 & 197916.625 & 12850.375 \tabularnewline
33 & 170266 & 158867.375 & 11398.625 \tabularnewline
34 & 260561 & 217205.529411765 & 43355.4705882353 \tabularnewline
35 & 84853 & 54522.5714285714 & 30330.4285714286 \tabularnewline
36 & 294424 & 292338.214285714 & 2085.78571428574 \tabularnewline
37 & 101011 & 54522.5714285714 & 46488.4285714286 \tabularnewline
38 & 215641 & 197916.625 & 17724.375 \tabularnewline
39 & 325107 & 292338.214285714 & 32768.7857142857 \tabularnewline
40 & 7176 & 595.686046511628 & 6580.31395348837 \tabularnewline
41 & 167542 & 158867.375 & 8674.625 \tabularnewline
42 & 106408 & 54522.5714285714 & 51885.4285714286 \tabularnewline
43 & 96560 & 105861 & -9301 \tabularnewline
44 & 265769 & 292338.214285714 & -26569.2142857143 \tabularnewline
45 & 269651 & 292338.214285714 & -22687.2142857143 \tabularnewline
46 & 149112 & 158867.375 & -9755.375 \tabularnewline
47 & 175824 & 217205.529411765 & -41381.5294117647 \tabularnewline
48 & 152871 & 158867.375 & -5996.375 \tabularnewline
49 & 111665 & 105861 & 5804 \tabularnewline
50 & 116408 & 105861 & 10547 \tabularnewline
51 & 362301 & 292338.214285714 & 69962.7857142857 \tabularnewline
52 & 78800 & 105861 & -27061 \tabularnewline
53 & 183167 & 197916.625 & -14749.625 \tabularnewline
54 & 277965 & 292338.214285714 & -14373.2142857143 \tabularnewline
55 & 150629 & 197916.625 & -47287.625 \tabularnewline
56 & 168809 & 158867.375 & 9941.625 \tabularnewline
57 & 24188 & 54522.5714285714 & -30334.5714285714 \tabularnewline
58 & 329267 & 217205.529411765 & 112061.470588235 \tabularnewline
59 & 65029 & 54522.5714285714 & 10506.4285714286 \tabularnewline
60 & 101097 & 105861 & -4764 \tabularnewline
61 & 218946 & 197916.625 & 21029.375 \tabularnewline
62 & 244052 & 217205.529411765 & 26846.4705882353 \tabularnewline
63 & 341570 & 292338.214285714 & 49231.7857142857 \tabularnewline
64 & 103597 & 105861 & -2264 \tabularnewline
65 & 233328 & 217205.529411765 & 16122.4705882353 \tabularnewline
66 & 256462 & 217205.529411765 & 39256.4705882353 \tabularnewline
67 & 206161 & 217205.529411765 & -11044.5294117647 \tabularnewline
68 & 311473 & 292338.214285714 & 19134.7857142857 \tabularnewline
69 & 235800 & 292338.214285714 & -56538.2142857143 \tabularnewline
70 & 177939 & 217205.529411765 & -39266.5294117647 \tabularnewline
71 & 207176 & 217205.529411765 & -10029.5294117647 \tabularnewline
72 & 196553 & 158867.375 & 37685.625 \tabularnewline
73 & 174184 & 158867.375 & 15316.625 \tabularnewline
74 & 143246 & 217205.529411765 & -73959.5294117647 \tabularnewline
75 & 187559 & 217205.529411765 & -29646.5294117647 \tabularnewline
76 & 187681 & 197916.625 & -10235.625 \tabularnewline
77 & 119016 & 158867.375 & -39851.375 \tabularnewline
78 & 182192 & 197916.625 & -15724.625 \tabularnewline
79 & 73566 & 105861 & -32295 \tabularnewline
80 & 194979 & 197916.625 & -2937.625 \tabularnewline
81 & 167488 & 197916.625 & -30428.625 \tabularnewline
82 & 143756 & 158867.375 & -15111.375 \tabularnewline
83 & 110 & 595.686046511628 & -485.686046511628 \tabularnewline
84 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
85 & 49 & 595.686046511628 & -546.686046511628 \tabularnewline
86 & 27 & 595.686046511628 & -568.686046511628 \tabularnewline
87 & 1 & 595.686046511628 & -594.686046511628 \tabularnewline
88 & 144 & 595.686046511628 & -451.686046511628 \tabularnewline
89 & 1 & 595.686046511628 & -594.686046511628 \tabularnewline
90 & 117 & 595.686046511628 & -478.686046511628 \tabularnewline
91 & 37 & 54522.5714285714 & -54485.5714285714 \tabularnewline
92 & 1 & 595.686046511628 & -594.686046511628 \tabularnewline
93 & 49 & 595.686046511628 & -546.686046511628 \tabularnewline
94 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
95 & 60 & 595.686046511628 & -535.686046511628 \tabularnewline
96 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
97 & 64 & 595.686046511628 & -531.686046511628 \tabularnewline
98 & 76 & 595.686046511628 & -519.686046511628 \tabularnewline
99 & 28 & 595.686046511628 & -567.686046511628 \tabularnewline
100 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
101 & 84 & 595.686046511628 & -511.686046511628 \tabularnewline
102 & 14 & 595.686046511628 & -581.686046511628 \tabularnewline
103 & 75 & 595.686046511628 & -520.686046511628 \tabularnewline
104 & 39 & 595.686046511628 & -556.686046511628 \tabularnewline
105 & 50 & 595.686046511628 & -545.686046511628 \tabularnewline
106 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
107 & 57 & 595.686046511628 & -538.686046511628 \tabularnewline
108 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
109 & 65 & 595.686046511628 & -530.686046511628 \tabularnewline
110 & 1 & 595.686046511628 & -594.686046511628 \tabularnewline
111 & 15 & 595.686046511628 & -580.686046511628 \tabularnewline
112 & 21 & 595.686046511628 & -574.686046511628 \tabularnewline
113 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
114 & 5 & 595.686046511628 & -590.686046511628 \tabularnewline
115 & 3 & 595.686046511628 & -592.686046511628 \tabularnewline
116 & 43 & 595.686046511628 & -552.686046511628 \tabularnewline
117 & 56 & 595.686046511628 & -539.686046511628 \tabularnewline
118 & 38 & 595.686046511628 & -557.686046511628 \tabularnewline
119 & 47 & 595.686046511628 & -548.686046511628 \tabularnewline
120 & 25 & 595.686046511628 & -570.686046511628 \tabularnewline
121 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
122 & 21 & 595.686046511628 & -574.686046511628 \tabularnewline
123 & 68 & 595.686046511628 & -527.686046511628 \tabularnewline
124 & 77 & 595.686046511628 & -518.686046511628 \tabularnewline
125 & 46 & 595.686046511628 & -549.686046511628 \tabularnewline
126 & 1 & 595.686046511628 & -594.686046511628 \tabularnewline
127 & 34 & 595.686046511628 & -561.686046511628 \tabularnewline
128 & 32 & 595.686046511628 & -563.686046511628 \tabularnewline
129 & 18 & 595.686046511628 & -577.686046511628 \tabularnewline
130 & 14 & 595.686046511628 & -581.686046511628 \tabularnewline
131 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
132 & 19 & 595.686046511628 & -576.686046511628 \tabularnewline
133 & 5 & 595.686046511628 & -590.686046511628 \tabularnewline
134 & 47 & 595.686046511628 & -548.686046511628 \tabularnewline
135 & 1 & 595.686046511628 & -594.686046511628 \tabularnewline
136 & 10 & 595.686046511628 & -585.686046511628 \tabularnewline
137 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
138 & 34 & 595.686046511628 & -561.686046511628 \tabularnewline
139 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
140 & 72 & 595.686046511628 & -523.686046511628 \tabularnewline
141 & 56 & 595.686046511628 & -539.686046511628 \tabularnewline
142 & 56 & 595.686046511628 & -539.686046511628 \tabularnewline
143 & 54 & 595.686046511628 & -541.686046511628 \tabularnewline
144 & 89 & 595.686046511628 & -506.686046511628 \tabularnewline
145 & 40 & 595.686046511628 & -555.686046511628 \tabularnewline
146 & 25 & 595.686046511628 & -570.686046511628 \tabularnewline
147 & 92 & 595.686046511628 & -503.686046511628 \tabularnewline
148 & 18 & 595.686046511628 & -577.686046511628 \tabularnewline
149 & 63 & 595.686046511628 & -532.686046511628 \tabularnewline
150 & 44 & 595.686046511628 & -551.686046511628 \tabularnewline
151 & 33 & 595.686046511628 & -562.686046511628 \tabularnewline
152 & 84 & 595.686046511628 & -511.686046511628 \tabularnewline
153 & 88 & 595.686046511628 & -507.686046511628 \tabularnewline
154 & 55 & 595.686046511628 & -540.686046511628 \tabularnewline
155 & 60 & 595.686046511628 & -535.686046511628 \tabularnewline
156 & 66 & 595.686046511628 & -529.686046511628 \tabularnewline
157 & 154 & 595.686046511628 & -441.686046511628 \tabularnewline
158 & 53 & 595.686046511628 & -542.686046511628 \tabularnewline
159 & 119 & 595.686046511628 & -476.686046511628 \tabularnewline
160 & 41 & 595.686046511628 & -554.686046511628 \tabularnewline
161 & 61 & 595.686046511628 & -534.686046511628 \tabularnewline
162 & 58 & 595.686046511628 & -537.686046511628 \tabularnewline
163 & 75 & 595.686046511628 & -520.686046511628 \tabularnewline
164 & 33 & 595.686046511628 & -562.686046511628 \tabularnewline
165 & 40 & 595.686046511628 & -555.686046511628 \tabularnewline
166 & 92 & 595.686046511628 & -503.686046511628 \tabularnewline
167 & 100 & 595.686046511628 & -495.686046511628 \tabularnewline
168 & 112 & 595.686046511628 & -483.686046511628 \tabularnewline
169 & 73 & 595.686046511628 & -522.686046511628 \tabularnewline
170 & 40 & 595.686046511628 & -555.686046511628 \tabularnewline
171 & 45 & 595.686046511628 & -550.686046511628 \tabularnewline
172 & 60 & 595.686046511628 & -535.686046511628 \tabularnewline
173 & 62 & 595.686046511628 & -533.686046511628 \tabularnewline
174 & 75 & 595.686046511628 & -520.686046511628 \tabularnewline
175 & 31 & 595.686046511628 & -564.686046511628 \tabularnewline
176 & 77 & 595.686046511628 & -518.686046511628 \tabularnewline
177 & 34 & 595.686046511628 & -561.686046511628 \tabularnewline
178 & 46 & 595.686046511628 & -549.686046511628 \tabularnewline
179 & 99 & 595.686046511628 & -496.686046511628 \tabularnewline
180 & 17 & 595.686046511628 & -578.686046511628 \tabularnewline
181 & 66 & 595.686046511628 & -529.686046511628 \tabularnewline
182 & 30 & 595.686046511628 & -565.686046511628 \tabularnewline
183 & 76 & 595.686046511628 & -519.686046511628 \tabularnewline
184 & 146 & 595.686046511628 & -449.686046511628 \tabularnewline
185 & 67 & 595.686046511628 & -528.686046511628 \tabularnewline
186 & 56 & 595.686046511628 & -539.686046511628 \tabularnewline
187 & 107 & 595.686046511628 & -488.686046511628 \tabularnewline
188 & 58 & 595.686046511628 & -537.686046511628 \tabularnewline
189 & 34 & 595.686046511628 & -561.686046511628 \tabularnewline
190 & 61 & 595.686046511628 & -534.686046511628 \tabularnewline
191 & 119 & 595.686046511628 & -476.686046511628 \tabularnewline
192 & 42 & 595.686046511628 & -553.686046511628 \tabularnewline
193 & 66 & 595.686046511628 & -529.686046511628 \tabularnewline
194 & 89 & 595.686046511628 & -506.686046511628 \tabularnewline
195 & 44 & 595.686046511628 & -551.686046511628 \tabularnewline
196 & 66 & 595.686046511628 & -529.686046511628 \tabularnewline
197 & 24 & 595.686046511628 & -571.686046511628 \tabularnewline
198 & 259 & 595.686046511628 & -336.686046511628 \tabularnewline
199 & 17 & 595.686046511628 & -578.686046511628 \tabularnewline
200 & 64 & 595.686046511628 & -531.686046511628 \tabularnewline
201 & 41 & 595.686046511628 & -554.686046511628 \tabularnewline
202 & 68 & 595.686046511628 & -527.686046511628 \tabularnewline
203 & 168 & 595.686046511628 & -427.686046511628 \tabularnewline
204 & 43 & 595.686046511628 & -552.686046511628 \tabularnewline
205 & 132 & 54522.5714285714 & -54390.5714285714 \tabularnewline
206 & 105 & 595.686046511628 & -490.686046511628 \tabularnewline
207 & 71 & 595.686046511628 & -524.686046511628 \tabularnewline
208 & 112 & 595.686046511628 & -483.686046511628 \tabularnewline
209 & 94 & 595.686046511628 & -501.686046511628 \tabularnewline
210 & 82 & 595.686046511628 & -513.686046511628 \tabularnewline
211 & 70 & 595.686046511628 & -525.686046511628 \tabularnewline
212 & 57 & 595.686046511628 & -538.686046511628 \tabularnewline
213 & 53 & 595.686046511628 & -542.686046511628 \tabularnewline
214 & 103 & 595.686046511628 & -492.686046511628 \tabularnewline
215 & 121 & 595.686046511628 & -474.686046511628 \tabularnewline
216 & 62 & 595.686046511628 & -533.686046511628 \tabularnewline
217 & 52 & 595.686046511628 & -543.686046511628 \tabularnewline
218 & 52 & 595.686046511628 & -543.686046511628 \tabularnewline
219 & 32 & 595.686046511628 & -563.686046511628 \tabularnewline
220 & 62 & 595.686046511628 & -533.686046511628 \tabularnewline
221 & 45 & 595.686046511628 & -550.686046511628 \tabularnewline
222 & 46 & 595.686046511628 & -549.686046511628 \tabularnewline
223 & 93 & 595.686046511628 & -502.686046511628 \tabularnewline
224 & 141 & 595.686046511628 & -454.686046511628 \tabularnewline
225 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
226 & 63 & 595.686046511628 & -532.686046511628 \tabularnewline
227 & 64 & 595.686046511628 & -531.686046511628 \tabularnewline
228 & 1 & 595.686046511628 & -594.686046511628 \tabularnewline
229 & 187 & 595.686046511628 & -408.686046511628 \tabularnewline
230 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
231 & 177 & 595.686046511628 & -418.686046511628 \tabularnewline
232 & 94 & 595.686046511628 & -501.686046511628 \tabularnewline
233 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
234 & 64 & 595.686046511628 & -531.686046511628 \tabularnewline
235 & 25 & 595.686046511628 & -570.686046511628 \tabularnewline
236 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
237 & 2 & 595.686046511628 & -593.686046511628 \tabularnewline
238 & 193 & 595.686046511628 & -402.686046511628 \tabularnewline
239 & 14 & 595.686046511628 & -581.686046511628 \tabularnewline
240 & 24 & 595.686046511628 & -571.686046511628 \tabularnewline
241 & 1 & 595.686046511628 & -594.686046511628 \tabularnewline
242 & 131 & 595.686046511628 & -464.686046511628 \tabularnewline
243 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
244 & 211 & 595.686046511628 & -384.686046511628 \tabularnewline
245 & 166 & 595.686046511628 & -429.686046511628 \tabularnewline
246 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
247 & 119 & 595.686046511628 & -476.686046511628 \tabularnewline
248 & 101 & 595.686046511628 & -494.686046511628 \tabularnewline
249 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
250 & 40 & 595.686046511628 & -555.686046511628 \tabularnewline
251 & 0 & 595.686046511628 & -595.686046511628 \tabularnewline
252 & 35 & 595.686046511628 & -560.686046511628 \tabularnewline
253 & 6 & 595.686046511628 & -589.686046511628 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=159870&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]210907[/C][C]158867.375[/C][C]52039.625[/C][/ROW]
[ROW][C]2[/C][C]120982[/C][C]158867.375[/C][C]-37885.375[/C][/ROW]
[ROW][C]3[/C][C]176508[/C][C]197916.625[/C][C]-21408.625[/C][/ROW]
[ROW][C]4[/C][C]179321[/C][C]292338.214285714[/C][C]-113017.214285714[/C][/ROW]
[ROW][C]5[/C][C]123185[/C][C]105861[/C][C]17324[/C][/ROW]
[ROW][C]6[/C][C]52746[/C][C]595.686046511628[/C][C]52150.3139534884[/C][/ROW]
[ROW][C]7[/C][C]385534[/C][C]292338.214285714[/C][C]93195.7857142857[/C][/ROW]
[ROW][C]8[/C][C]33170[/C][C]595.686046511628[/C][C]32574.3139534884[/C][/ROW]
[ROW][C]9[/C][C]101645[/C][C]105861[/C][C]-4216[/C][/ROW]
[ROW][C]10[/C][C]149061[/C][C]197916.625[/C][C]-48855.625[/C][/ROW]
[ROW][C]11[/C][C]165446[/C][C]158867.375[/C][C]6578.625[/C][/ROW]
[ROW][C]12[/C][C]237213[/C][C]217205.529411765[/C][C]20007.4705882353[/C][/ROW]
[ROW][C]13[/C][C]173326[/C][C]217205.529411765[/C][C]-43879.5294117647[/C][/ROW]
[ROW][C]14[/C][C]133131[/C][C]105861[/C][C]27270[/C][/ROW]
[ROW][C]15[/C][C]258873[/C][C]197916.625[/C][C]60956.375[/C][/ROW]
[ROW][C]16[/C][C]180083[/C][C]158867.375[/C][C]21215.625[/C][/ROW]
[ROW][C]17[/C][C]324799[/C][C]292338.214285714[/C][C]32460.7857142857[/C][/ROW]
[ROW][C]18[/C][C]230964[/C][C]197916.625[/C][C]33047.375[/C][/ROW]
[ROW][C]19[/C][C]236785[/C][C]217205.529411765[/C][C]19579.4705882353[/C][/ROW]
[ROW][C]20[/C][C]135473[/C][C]158867.375[/C][C]-23394.375[/C][/ROW]
[ROW][C]21[/C][C]202925[/C][C]197916.625[/C][C]5008.375[/C][/ROW]
[ROW][C]22[/C][C]215147[/C][C]197916.625[/C][C]17230.375[/C][/ROW]
[ROW][C]23[/C][C]344297[/C][C]292338.214285714[/C][C]51958.7857142857[/C][/ROW]
[ROW][C]24[/C][C]153935[/C][C]158867.375[/C][C]-4932.375[/C][/ROW]
[ROW][C]25[/C][C]132943[/C][C]158867.375[/C][C]-25924.375[/C][/ROW]
[ROW][C]26[/C][C]174724[/C][C]292338.214285714[/C][C]-117614.214285714[/C][/ROW]
[ROW][C]27[/C][C]174415[/C][C]217205.529411765[/C][C]-42790.5294117647[/C][/ROW]
[ROW][C]28[/C][C]225548[/C][C]217205.529411765[/C][C]8342.4705882353[/C][/ROW]
[ROW][C]29[/C][C]223632[/C][C]217205.529411765[/C][C]6426.4705882353[/C][/ROW]
[ROW][C]30[/C][C]124817[/C][C]105861[/C][C]18956[/C][/ROW]
[ROW][C]31[/C][C]221698[/C][C]197916.625[/C][C]23781.375[/C][/ROW]
[ROW][C]32[/C][C]210767[/C][C]197916.625[/C][C]12850.375[/C][/ROW]
[ROW][C]33[/C][C]170266[/C][C]158867.375[/C][C]11398.625[/C][/ROW]
[ROW][C]34[/C][C]260561[/C][C]217205.529411765[/C][C]43355.4705882353[/C][/ROW]
[ROW][C]35[/C][C]84853[/C][C]54522.5714285714[/C][C]30330.4285714286[/C][/ROW]
[ROW][C]36[/C][C]294424[/C][C]292338.214285714[/C][C]2085.78571428574[/C][/ROW]
[ROW][C]37[/C][C]101011[/C][C]54522.5714285714[/C][C]46488.4285714286[/C][/ROW]
[ROW][C]38[/C][C]215641[/C][C]197916.625[/C][C]17724.375[/C][/ROW]
[ROW][C]39[/C][C]325107[/C][C]292338.214285714[/C][C]32768.7857142857[/C][/ROW]
[ROW][C]40[/C][C]7176[/C][C]595.686046511628[/C][C]6580.31395348837[/C][/ROW]
[ROW][C]41[/C][C]167542[/C][C]158867.375[/C][C]8674.625[/C][/ROW]
[ROW][C]42[/C][C]106408[/C][C]54522.5714285714[/C][C]51885.4285714286[/C][/ROW]
[ROW][C]43[/C][C]96560[/C][C]105861[/C][C]-9301[/C][/ROW]
[ROW][C]44[/C][C]265769[/C][C]292338.214285714[/C][C]-26569.2142857143[/C][/ROW]
[ROW][C]45[/C][C]269651[/C][C]292338.214285714[/C][C]-22687.2142857143[/C][/ROW]
[ROW][C]46[/C][C]149112[/C][C]158867.375[/C][C]-9755.375[/C][/ROW]
[ROW][C]47[/C][C]175824[/C][C]217205.529411765[/C][C]-41381.5294117647[/C][/ROW]
[ROW][C]48[/C][C]152871[/C][C]158867.375[/C][C]-5996.375[/C][/ROW]
[ROW][C]49[/C][C]111665[/C][C]105861[/C][C]5804[/C][/ROW]
[ROW][C]50[/C][C]116408[/C][C]105861[/C][C]10547[/C][/ROW]
[ROW][C]51[/C][C]362301[/C][C]292338.214285714[/C][C]69962.7857142857[/C][/ROW]
[ROW][C]52[/C][C]78800[/C][C]105861[/C][C]-27061[/C][/ROW]
[ROW][C]53[/C][C]183167[/C][C]197916.625[/C][C]-14749.625[/C][/ROW]
[ROW][C]54[/C][C]277965[/C][C]292338.214285714[/C][C]-14373.2142857143[/C][/ROW]
[ROW][C]55[/C][C]150629[/C][C]197916.625[/C][C]-47287.625[/C][/ROW]
[ROW][C]56[/C][C]168809[/C][C]158867.375[/C][C]9941.625[/C][/ROW]
[ROW][C]57[/C][C]24188[/C][C]54522.5714285714[/C][C]-30334.5714285714[/C][/ROW]
[ROW][C]58[/C][C]329267[/C][C]217205.529411765[/C][C]112061.470588235[/C][/ROW]
[ROW][C]59[/C][C]65029[/C][C]54522.5714285714[/C][C]10506.4285714286[/C][/ROW]
[ROW][C]60[/C][C]101097[/C][C]105861[/C][C]-4764[/C][/ROW]
[ROW][C]61[/C][C]218946[/C][C]197916.625[/C][C]21029.375[/C][/ROW]
[ROW][C]62[/C][C]244052[/C][C]217205.529411765[/C][C]26846.4705882353[/C][/ROW]
[ROW][C]63[/C][C]341570[/C][C]292338.214285714[/C][C]49231.7857142857[/C][/ROW]
[ROW][C]64[/C][C]103597[/C][C]105861[/C][C]-2264[/C][/ROW]
[ROW][C]65[/C][C]233328[/C][C]217205.529411765[/C][C]16122.4705882353[/C][/ROW]
[ROW][C]66[/C][C]256462[/C][C]217205.529411765[/C][C]39256.4705882353[/C][/ROW]
[ROW][C]67[/C][C]206161[/C][C]217205.529411765[/C][C]-11044.5294117647[/C][/ROW]
[ROW][C]68[/C][C]311473[/C][C]292338.214285714[/C][C]19134.7857142857[/C][/ROW]
[ROW][C]69[/C][C]235800[/C][C]292338.214285714[/C][C]-56538.2142857143[/C][/ROW]
[ROW][C]70[/C][C]177939[/C][C]217205.529411765[/C][C]-39266.5294117647[/C][/ROW]
[ROW][C]71[/C][C]207176[/C][C]217205.529411765[/C][C]-10029.5294117647[/C][/ROW]
[ROW][C]72[/C][C]196553[/C][C]158867.375[/C][C]37685.625[/C][/ROW]
[ROW][C]73[/C][C]174184[/C][C]158867.375[/C][C]15316.625[/C][/ROW]
[ROW][C]74[/C][C]143246[/C][C]217205.529411765[/C][C]-73959.5294117647[/C][/ROW]
[ROW][C]75[/C][C]187559[/C][C]217205.529411765[/C][C]-29646.5294117647[/C][/ROW]
[ROW][C]76[/C][C]187681[/C][C]197916.625[/C][C]-10235.625[/C][/ROW]
[ROW][C]77[/C][C]119016[/C][C]158867.375[/C][C]-39851.375[/C][/ROW]
[ROW][C]78[/C][C]182192[/C][C]197916.625[/C][C]-15724.625[/C][/ROW]
[ROW][C]79[/C][C]73566[/C][C]105861[/C][C]-32295[/C][/ROW]
[ROW][C]80[/C][C]194979[/C][C]197916.625[/C][C]-2937.625[/C][/ROW]
[ROW][C]81[/C][C]167488[/C][C]197916.625[/C][C]-30428.625[/C][/ROW]
[ROW][C]82[/C][C]143756[/C][C]158867.375[/C][C]-15111.375[/C][/ROW]
[ROW][C]83[/C][C]110[/C][C]595.686046511628[/C][C]-485.686046511628[/C][/ROW]
[ROW][C]84[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]85[/C][C]49[/C][C]595.686046511628[/C][C]-546.686046511628[/C][/ROW]
[ROW][C]86[/C][C]27[/C][C]595.686046511628[/C][C]-568.686046511628[/C][/ROW]
[ROW][C]87[/C][C]1[/C][C]595.686046511628[/C][C]-594.686046511628[/C][/ROW]
[ROW][C]88[/C][C]144[/C][C]595.686046511628[/C][C]-451.686046511628[/C][/ROW]
[ROW][C]89[/C][C]1[/C][C]595.686046511628[/C][C]-594.686046511628[/C][/ROW]
[ROW][C]90[/C][C]117[/C][C]595.686046511628[/C][C]-478.686046511628[/C][/ROW]
[ROW][C]91[/C][C]37[/C][C]54522.5714285714[/C][C]-54485.5714285714[/C][/ROW]
[ROW][C]92[/C][C]1[/C][C]595.686046511628[/C][C]-594.686046511628[/C][/ROW]
[ROW][C]93[/C][C]49[/C][C]595.686046511628[/C][C]-546.686046511628[/C][/ROW]
[ROW][C]94[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]95[/C][C]60[/C][C]595.686046511628[/C][C]-535.686046511628[/C][/ROW]
[ROW][C]96[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]97[/C][C]64[/C][C]595.686046511628[/C][C]-531.686046511628[/C][/ROW]
[ROW][C]98[/C][C]76[/C][C]595.686046511628[/C][C]-519.686046511628[/C][/ROW]
[ROW][C]99[/C][C]28[/C][C]595.686046511628[/C][C]-567.686046511628[/C][/ROW]
[ROW][C]100[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]101[/C][C]84[/C][C]595.686046511628[/C][C]-511.686046511628[/C][/ROW]
[ROW][C]102[/C][C]14[/C][C]595.686046511628[/C][C]-581.686046511628[/C][/ROW]
[ROW][C]103[/C][C]75[/C][C]595.686046511628[/C][C]-520.686046511628[/C][/ROW]
[ROW][C]104[/C][C]39[/C][C]595.686046511628[/C][C]-556.686046511628[/C][/ROW]
[ROW][C]105[/C][C]50[/C][C]595.686046511628[/C][C]-545.686046511628[/C][/ROW]
[ROW][C]106[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]107[/C][C]57[/C][C]595.686046511628[/C][C]-538.686046511628[/C][/ROW]
[ROW][C]108[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]109[/C][C]65[/C][C]595.686046511628[/C][C]-530.686046511628[/C][/ROW]
[ROW][C]110[/C][C]1[/C][C]595.686046511628[/C][C]-594.686046511628[/C][/ROW]
[ROW][C]111[/C][C]15[/C][C]595.686046511628[/C][C]-580.686046511628[/C][/ROW]
[ROW][C]112[/C][C]21[/C][C]595.686046511628[/C][C]-574.686046511628[/C][/ROW]
[ROW][C]113[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]114[/C][C]5[/C][C]595.686046511628[/C][C]-590.686046511628[/C][/ROW]
[ROW][C]115[/C][C]3[/C][C]595.686046511628[/C][C]-592.686046511628[/C][/ROW]
[ROW][C]116[/C][C]43[/C][C]595.686046511628[/C][C]-552.686046511628[/C][/ROW]
[ROW][C]117[/C][C]56[/C][C]595.686046511628[/C][C]-539.686046511628[/C][/ROW]
[ROW][C]118[/C][C]38[/C][C]595.686046511628[/C][C]-557.686046511628[/C][/ROW]
[ROW][C]119[/C][C]47[/C][C]595.686046511628[/C][C]-548.686046511628[/C][/ROW]
[ROW][C]120[/C][C]25[/C][C]595.686046511628[/C][C]-570.686046511628[/C][/ROW]
[ROW][C]121[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]122[/C][C]21[/C][C]595.686046511628[/C][C]-574.686046511628[/C][/ROW]
[ROW][C]123[/C][C]68[/C][C]595.686046511628[/C][C]-527.686046511628[/C][/ROW]
[ROW][C]124[/C][C]77[/C][C]595.686046511628[/C][C]-518.686046511628[/C][/ROW]
[ROW][C]125[/C][C]46[/C][C]595.686046511628[/C][C]-549.686046511628[/C][/ROW]
[ROW][C]126[/C][C]1[/C][C]595.686046511628[/C][C]-594.686046511628[/C][/ROW]
[ROW][C]127[/C][C]34[/C][C]595.686046511628[/C][C]-561.686046511628[/C][/ROW]
[ROW][C]128[/C][C]32[/C][C]595.686046511628[/C][C]-563.686046511628[/C][/ROW]
[ROW][C]129[/C][C]18[/C][C]595.686046511628[/C][C]-577.686046511628[/C][/ROW]
[ROW][C]130[/C][C]14[/C][C]595.686046511628[/C][C]-581.686046511628[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]132[/C][C]19[/C][C]595.686046511628[/C][C]-576.686046511628[/C][/ROW]
[ROW][C]133[/C][C]5[/C][C]595.686046511628[/C][C]-590.686046511628[/C][/ROW]
[ROW][C]134[/C][C]47[/C][C]595.686046511628[/C][C]-548.686046511628[/C][/ROW]
[ROW][C]135[/C][C]1[/C][C]595.686046511628[/C][C]-594.686046511628[/C][/ROW]
[ROW][C]136[/C][C]10[/C][C]595.686046511628[/C][C]-585.686046511628[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]138[/C][C]34[/C][C]595.686046511628[/C][C]-561.686046511628[/C][/ROW]
[ROW][C]139[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]140[/C][C]72[/C][C]595.686046511628[/C][C]-523.686046511628[/C][/ROW]
[ROW][C]141[/C][C]56[/C][C]595.686046511628[/C][C]-539.686046511628[/C][/ROW]
[ROW][C]142[/C][C]56[/C][C]595.686046511628[/C][C]-539.686046511628[/C][/ROW]
[ROW][C]143[/C][C]54[/C][C]595.686046511628[/C][C]-541.686046511628[/C][/ROW]
[ROW][C]144[/C][C]89[/C][C]595.686046511628[/C][C]-506.686046511628[/C][/ROW]
[ROW][C]145[/C][C]40[/C][C]595.686046511628[/C][C]-555.686046511628[/C][/ROW]
[ROW][C]146[/C][C]25[/C][C]595.686046511628[/C][C]-570.686046511628[/C][/ROW]
[ROW][C]147[/C][C]92[/C][C]595.686046511628[/C][C]-503.686046511628[/C][/ROW]
[ROW][C]148[/C][C]18[/C][C]595.686046511628[/C][C]-577.686046511628[/C][/ROW]
[ROW][C]149[/C][C]63[/C][C]595.686046511628[/C][C]-532.686046511628[/C][/ROW]
[ROW][C]150[/C][C]44[/C][C]595.686046511628[/C][C]-551.686046511628[/C][/ROW]
[ROW][C]151[/C][C]33[/C][C]595.686046511628[/C][C]-562.686046511628[/C][/ROW]
[ROW][C]152[/C][C]84[/C][C]595.686046511628[/C][C]-511.686046511628[/C][/ROW]
[ROW][C]153[/C][C]88[/C][C]595.686046511628[/C][C]-507.686046511628[/C][/ROW]
[ROW][C]154[/C][C]55[/C][C]595.686046511628[/C][C]-540.686046511628[/C][/ROW]
[ROW][C]155[/C][C]60[/C][C]595.686046511628[/C][C]-535.686046511628[/C][/ROW]
[ROW][C]156[/C][C]66[/C][C]595.686046511628[/C][C]-529.686046511628[/C][/ROW]
[ROW][C]157[/C][C]154[/C][C]595.686046511628[/C][C]-441.686046511628[/C][/ROW]
[ROW][C]158[/C][C]53[/C][C]595.686046511628[/C][C]-542.686046511628[/C][/ROW]
[ROW][C]159[/C][C]119[/C][C]595.686046511628[/C][C]-476.686046511628[/C][/ROW]
[ROW][C]160[/C][C]41[/C][C]595.686046511628[/C][C]-554.686046511628[/C][/ROW]
[ROW][C]161[/C][C]61[/C][C]595.686046511628[/C][C]-534.686046511628[/C][/ROW]
[ROW][C]162[/C][C]58[/C][C]595.686046511628[/C][C]-537.686046511628[/C][/ROW]
[ROW][C]163[/C][C]75[/C][C]595.686046511628[/C][C]-520.686046511628[/C][/ROW]
[ROW][C]164[/C][C]33[/C][C]595.686046511628[/C][C]-562.686046511628[/C][/ROW]
[ROW][C]165[/C][C]40[/C][C]595.686046511628[/C][C]-555.686046511628[/C][/ROW]
[ROW][C]166[/C][C]92[/C][C]595.686046511628[/C][C]-503.686046511628[/C][/ROW]
[ROW][C]167[/C][C]100[/C][C]595.686046511628[/C][C]-495.686046511628[/C][/ROW]
[ROW][C]168[/C][C]112[/C][C]595.686046511628[/C][C]-483.686046511628[/C][/ROW]
[ROW][C]169[/C][C]73[/C][C]595.686046511628[/C][C]-522.686046511628[/C][/ROW]
[ROW][C]170[/C][C]40[/C][C]595.686046511628[/C][C]-555.686046511628[/C][/ROW]
[ROW][C]171[/C][C]45[/C][C]595.686046511628[/C][C]-550.686046511628[/C][/ROW]
[ROW][C]172[/C][C]60[/C][C]595.686046511628[/C][C]-535.686046511628[/C][/ROW]
[ROW][C]173[/C][C]62[/C][C]595.686046511628[/C][C]-533.686046511628[/C][/ROW]
[ROW][C]174[/C][C]75[/C][C]595.686046511628[/C][C]-520.686046511628[/C][/ROW]
[ROW][C]175[/C][C]31[/C][C]595.686046511628[/C][C]-564.686046511628[/C][/ROW]
[ROW][C]176[/C][C]77[/C][C]595.686046511628[/C][C]-518.686046511628[/C][/ROW]
[ROW][C]177[/C][C]34[/C][C]595.686046511628[/C][C]-561.686046511628[/C][/ROW]
[ROW][C]178[/C][C]46[/C][C]595.686046511628[/C][C]-549.686046511628[/C][/ROW]
[ROW][C]179[/C][C]99[/C][C]595.686046511628[/C][C]-496.686046511628[/C][/ROW]
[ROW][C]180[/C][C]17[/C][C]595.686046511628[/C][C]-578.686046511628[/C][/ROW]
[ROW][C]181[/C][C]66[/C][C]595.686046511628[/C][C]-529.686046511628[/C][/ROW]
[ROW][C]182[/C][C]30[/C][C]595.686046511628[/C][C]-565.686046511628[/C][/ROW]
[ROW][C]183[/C][C]76[/C][C]595.686046511628[/C][C]-519.686046511628[/C][/ROW]
[ROW][C]184[/C][C]146[/C][C]595.686046511628[/C][C]-449.686046511628[/C][/ROW]
[ROW][C]185[/C][C]67[/C][C]595.686046511628[/C][C]-528.686046511628[/C][/ROW]
[ROW][C]186[/C][C]56[/C][C]595.686046511628[/C][C]-539.686046511628[/C][/ROW]
[ROW][C]187[/C][C]107[/C][C]595.686046511628[/C][C]-488.686046511628[/C][/ROW]
[ROW][C]188[/C][C]58[/C][C]595.686046511628[/C][C]-537.686046511628[/C][/ROW]
[ROW][C]189[/C][C]34[/C][C]595.686046511628[/C][C]-561.686046511628[/C][/ROW]
[ROW][C]190[/C][C]61[/C][C]595.686046511628[/C][C]-534.686046511628[/C][/ROW]
[ROW][C]191[/C][C]119[/C][C]595.686046511628[/C][C]-476.686046511628[/C][/ROW]
[ROW][C]192[/C][C]42[/C][C]595.686046511628[/C][C]-553.686046511628[/C][/ROW]
[ROW][C]193[/C][C]66[/C][C]595.686046511628[/C][C]-529.686046511628[/C][/ROW]
[ROW][C]194[/C][C]89[/C][C]595.686046511628[/C][C]-506.686046511628[/C][/ROW]
[ROW][C]195[/C][C]44[/C][C]595.686046511628[/C][C]-551.686046511628[/C][/ROW]
[ROW][C]196[/C][C]66[/C][C]595.686046511628[/C][C]-529.686046511628[/C][/ROW]
[ROW][C]197[/C][C]24[/C][C]595.686046511628[/C][C]-571.686046511628[/C][/ROW]
[ROW][C]198[/C][C]259[/C][C]595.686046511628[/C][C]-336.686046511628[/C][/ROW]
[ROW][C]199[/C][C]17[/C][C]595.686046511628[/C][C]-578.686046511628[/C][/ROW]
[ROW][C]200[/C][C]64[/C][C]595.686046511628[/C][C]-531.686046511628[/C][/ROW]
[ROW][C]201[/C][C]41[/C][C]595.686046511628[/C][C]-554.686046511628[/C][/ROW]
[ROW][C]202[/C][C]68[/C][C]595.686046511628[/C][C]-527.686046511628[/C][/ROW]
[ROW][C]203[/C][C]168[/C][C]595.686046511628[/C][C]-427.686046511628[/C][/ROW]
[ROW][C]204[/C][C]43[/C][C]595.686046511628[/C][C]-552.686046511628[/C][/ROW]
[ROW][C]205[/C][C]132[/C][C]54522.5714285714[/C][C]-54390.5714285714[/C][/ROW]
[ROW][C]206[/C][C]105[/C][C]595.686046511628[/C][C]-490.686046511628[/C][/ROW]
[ROW][C]207[/C][C]71[/C][C]595.686046511628[/C][C]-524.686046511628[/C][/ROW]
[ROW][C]208[/C][C]112[/C][C]595.686046511628[/C][C]-483.686046511628[/C][/ROW]
[ROW][C]209[/C][C]94[/C][C]595.686046511628[/C][C]-501.686046511628[/C][/ROW]
[ROW][C]210[/C][C]82[/C][C]595.686046511628[/C][C]-513.686046511628[/C][/ROW]
[ROW][C]211[/C][C]70[/C][C]595.686046511628[/C][C]-525.686046511628[/C][/ROW]
[ROW][C]212[/C][C]57[/C][C]595.686046511628[/C][C]-538.686046511628[/C][/ROW]
[ROW][C]213[/C][C]53[/C][C]595.686046511628[/C][C]-542.686046511628[/C][/ROW]
[ROW][C]214[/C][C]103[/C][C]595.686046511628[/C][C]-492.686046511628[/C][/ROW]
[ROW][C]215[/C][C]121[/C][C]595.686046511628[/C][C]-474.686046511628[/C][/ROW]
[ROW][C]216[/C][C]62[/C][C]595.686046511628[/C][C]-533.686046511628[/C][/ROW]
[ROW][C]217[/C][C]52[/C][C]595.686046511628[/C][C]-543.686046511628[/C][/ROW]
[ROW][C]218[/C][C]52[/C][C]595.686046511628[/C][C]-543.686046511628[/C][/ROW]
[ROW][C]219[/C][C]32[/C][C]595.686046511628[/C][C]-563.686046511628[/C][/ROW]
[ROW][C]220[/C][C]62[/C][C]595.686046511628[/C][C]-533.686046511628[/C][/ROW]
[ROW][C]221[/C][C]45[/C][C]595.686046511628[/C][C]-550.686046511628[/C][/ROW]
[ROW][C]222[/C][C]46[/C][C]595.686046511628[/C][C]-549.686046511628[/C][/ROW]
[ROW][C]223[/C][C]93[/C][C]595.686046511628[/C][C]-502.686046511628[/C][/ROW]
[ROW][C]224[/C][C]141[/C][C]595.686046511628[/C][C]-454.686046511628[/C][/ROW]
[ROW][C]225[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]226[/C][C]63[/C][C]595.686046511628[/C][C]-532.686046511628[/C][/ROW]
[ROW][C]227[/C][C]64[/C][C]595.686046511628[/C][C]-531.686046511628[/C][/ROW]
[ROW][C]228[/C][C]1[/C][C]595.686046511628[/C][C]-594.686046511628[/C][/ROW]
[ROW][C]229[/C][C]187[/C][C]595.686046511628[/C][C]-408.686046511628[/C][/ROW]
[ROW][C]230[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]231[/C][C]177[/C][C]595.686046511628[/C][C]-418.686046511628[/C][/ROW]
[ROW][C]232[/C][C]94[/C][C]595.686046511628[/C][C]-501.686046511628[/C][/ROW]
[ROW][C]233[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]234[/C][C]64[/C][C]595.686046511628[/C][C]-531.686046511628[/C][/ROW]
[ROW][C]235[/C][C]25[/C][C]595.686046511628[/C][C]-570.686046511628[/C][/ROW]
[ROW][C]236[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]237[/C][C]2[/C][C]595.686046511628[/C][C]-593.686046511628[/C][/ROW]
[ROW][C]238[/C][C]193[/C][C]595.686046511628[/C][C]-402.686046511628[/C][/ROW]
[ROW][C]239[/C][C]14[/C][C]595.686046511628[/C][C]-581.686046511628[/C][/ROW]
[ROW][C]240[/C][C]24[/C][C]595.686046511628[/C][C]-571.686046511628[/C][/ROW]
[ROW][C]241[/C][C]1[/C][C]595.686046511628[/C][C]-594.686046511628[/C][/ROW]
[ROW][C]242[/C][C]131[/C][C]595.686046511628[/C][C]-464.686046511628[/C][/ROW]
[ROW][C]243[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]244[/C][C]211[/C][C]595.686046511628[/C][C]-384.686046511628[/C][/ROW]
[ROW][C]245[/C][C]166[/C][C]595.686046511628[/C][C]-429.686046511628[/C][/ROW]
[ROW][C]246[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]247[/C][C]119[/C][C]595.686046511628[/C][C]-476.686046511628[/C][/ROW]
[ROW][C]248[/C][C]101[/C][C]595.686046511628[/C][C]-494.686046511628[/C][/ROW]
[ROW][C]249[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]250[/C][C]40[/C][C]595.686046511628[/C][C]-555.686046511628[/C][/ROW]
[ROW][C]251[/C][C]0[/C][C]595.686046511628[/C][C]-595.686046511628[/C][/ROW]
[ROW][C]252[/C][C]35[/C][C]595.686046511628[/C][C]-560.686046511628[/C][/ROW]
[ROW][C]253[/C][C]6[/C][C]595.686046511628[/C][C]-589.686046511628[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159870&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159870&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
1210907158867.37552039.625
2120982158867.375-37885.375
3176508197916.625-21408.625
4179321292338.214285714-113017.214285714
512318510586117324
652746595.68604651162852150.3139534884
7385534292338.21428571493195.7857142857
833170595.68604651162832574.3139534884
9101645105861-4216
10149061197916.625-48855.625
11165446158867.3756578.625
12237213217205.52941176520007.4705882353
13173326217205.529411765-43879.5294117647
1413313110586127270
15258873197916.62560956.375
16180083158867.37521215.625
17324799292338.21428571432460.7857142857
18230964197916.62533047.375
19236785217205.52941176519579.4705882353
20135473158867.375-23394.375
21202925197916.6255008.375
22215147197916.62517230.375
23344297292338.21428571451958.7857142857
24153935158867.375-4932.375
25132943158867.375-25924.375
26174724292338.214285714-117614.214285714
27174415217205.529411765-42790.5294117647
28225548217205.5294117658342.4705882353
29223632217205.5294117656426.4705882353
3012481710586118956
31221698197916.62523781.375
32210767197916.62512850.375
33170266158867.37511398.625
34260561217205.52941176543355.4705882353
358485354522.571428571430330.4285714286
36294424292338.2142857142085.78571428574
3710101154522.571428571446488.4285714286
38215641197916.62517724.375
39325107292338.21428571432768.7857142857
407176595.6860465116286580.31395348837
41167542158867.3758674.625
4210640854522.571428571451885.4285714286
4396560105861-9301
44265769292338.214285714-26569.2142857143
45269651292338.214285714-22687.2142857143
46149112158867.375-9755.375
47175824217205.529411765-41381.5294117647
48152871158867.375-5996.375
491116651058615804
5011640810586110547
51362301292338.21428571469962.7857142857
5278800105861-27061
53183167197916.625-14749.625
54277965292338.214285714-14373.2142857143
55150629197916.625-47287.625
56168809158867.3759941.625
572418854522.5714285714-30334.5714285714
58329267217205.529411765112061.470588235
596502954522.571428571410506.4285714286
60101097105861-4764
61218946197916.62521029.375
62244052217205.52941176526846.4705882353
63341570292338.21428571449231.7857142857
64103597105861-2264
65233328217205.52941176516122.4705882353
66256462217205.52941176539256.4705882353
67206161217205.529411765-11044.5294117647
68311473292338.21428571419134.7857142857
69235800292338.214285714-56538.2142857143
70177939217205.529411765-39266.5294117647
71207176217205.529411765-10029.5294117647
72196553158867.37537685.625
73174184158867.37515316.625
74143246217205.529411765-73959.5294117647
75187559217205.529411765-29646.5294117647
76187681197916.625-10235.625
77119016158867.375-39851.375
78182192197916.625-15724.625
7973566105861-32295
80194979197916.625-2937.625
81167488197916.625-30428.625
82143756158867.375-15111.375
83110595.686046511628-485.686046511628
840595.686046511628-595.686046511628
8549595.686046511628-546.686046511628
8627595.686046511628-568.686046511628
871595.686046511628-594.686046511628
88144595.686046511628-451.686046511628
891595.686046511628-594.686046511628
90117595.686046511628-478.686046511628
913754522.5714285714-54485.5714285714
921595.686046511628-594.686046511628
9349595.686046511628-546.686046511628
940595.686046511628-595.686046511628
9560595.686046511628-535.686046511628
960595.686046511628-595.686046511628
9764595.686046511628-531.686046511628
9876595.686046511628-519.686046511628
9928595.686046511628-567.686046511628
1000595.686046511628-595.686046511628
10184595.686046511628-511.686046511628
10214595.686046511628-581.686046511628
10375595.686046511628-520.686046511628
10439595.686046511628-556.686046511628
10550595.686046511628-545.686046511628
1060595.686046511628-595.686046511628
10757595.686046511628-538.686046511628
1080595.686046511628-595.686046511628
10965595.686046511628-530.686046511628
1101595.686046511628-594.686046511628
11115595.686046511628-580.686046511628
11221595.686046511628-574.686046511628
1130595.686046511628-595.686046511628
1145595.686046511628-590.686046511628
1153595.686046511628-592.686046511628
11643595.686046511628-552.686046511628
11756595.686046511628-539.686046511628
11838595.686046511628-557.686046511628
11947595.686046511628-548.686046511628
12025595.686046511628-570.686046511628
1210595.686046511628-595.686046511628
12221595.686046511628-574.686046511628
12368595.686046511628-527.686046511628
12477595.686046511628-518.686046511628
12546595.686046511628-549.686046511628
1261595.686046511628-594.686046511628
12734595.686046511628-561.686046511628
12832595.686046511628-563.686046511628
12918595.686046511628-577.686046511628
13014595.686046511628-581.686046511628
1310595.686046511628-595.686046511628
13219595.686046511628-576.686046511628
1335595.686046511628-590.686046511628
13447595.686046511628-548.686046511628
1351595.686046511628-594.686046511628
13610595.686046511628-585.686046511628
1370595.686046511628-595.686046511628
13834595.686046511628-561.686046511628
1390595.686046511628-595.686046511628
14072595.686046511628-523.686046511628
14156595.686046511628-539.686046511628
14256595.686046511628-539.686046511628
14354595.686046511628-541.686046511628
14489595.686046511628-506.686046511628
14540595.686046511628-555.686046511628
14625595.686046511628-570.686046511628
14792595.686046511628-503.686046511628
14818595.686046511628-577.686046511628
14963595.686046511628-532.686046511628
15044595.686046511628-551.686046511628
15133595.686046511628-562.686046511628
15284595.686046511628-511.686046511628
15388595.686046511628-507.686046511628
15455595.686046511628-540.686046511628
15560595.686046511628-535.686046511628
15666595.686046511628-529.686046511628
157154595.686046511628-441.686046511628
15853595.686046511628-542.686046511628
159119595.686046511628-476.686046511628
16041595.686046511628-554.686046511628
16161595.686046511628-534.686046511628
16258595.686046511628-537.686046511628
16375595.686046511628-520.686046511628
16433595.686046511628-562.686046511628
16540595.686046511628-555.686046511628
16692595.686046511628-503.686046511628
167100595.686046511628-495.686046511628
168112595.686046511628-483.686046511628
16973595.686046511628-522.686046511628
17040595.686046511628-555.686046511628
17145595.686046511628-550.686046511628
17260595.686046511628-535.686046511628
17362595.686046511628-533.686046511628
17475595.686046511628-520.686046511628
17531595.686046511628-564.686046511628
17677595.686046511628-518.686046511628
17734595.686046511628-561.686046511628
17846595.686046511628-549.686046511628
17999595.686046511628-496.686046511628
18017595.686046511628-578.686046511628
18166595.686046511628-529.686046511628
18230595.686046511628-565.686046511628
18376595.686046511628-519.686046511628
184146595.686046511628-449.686046511628
18567595.686046511628-528.686046511628
18656595.686046511628-539.686046511628
187107595.686046511628-488.686046511628
18858595.686046511628-537.686046511628
18934595.686046511628-561.686046511628
19061595.686046511628-534.686046511628
191119595.686046511628-476.686046511628
19242595.686046511628-553.686046511628
19366595.686046511628-529.686046511628
19489595.686046511628-506.686046511628
19544595.686046511628-551.686046511628
19666595.686046511628-529.686046511628
19724595.686046511628-571.686046511628
198259595.686046511628-336.686046511628
19917595.686046511628-578.686046511628
20064595.686046511628-531.686046511628
20141595.686046511628-554.686046511628
20268595.686046511628-527.686046511628
203168595.686046511628-427.686046511628
20443595.686046511628-552.686046511628
20513254522.5714285714-54390.5714285714
206105595.686046511628-490.686046511628
20771595.686046511628-524.686046511628
208112595.686046511628-483.686046511628
20994595.686046511628-501.686046511628
21082595.686046511628-513.686046511628
21170595.686046511628-525.686046511628
21257595.686046511628-538.686046511628
21353595.686046511628-542.686046511628
214103595.686046511628-492.686046511628
215121595.686046511628-474.686046511628
21662595.686046511628-533.686046511628
21752595.686046511628-543.686046511628
21852595.686046511628-543.686046511628
21932595.686046511628-563.686046511628
22062595.686046511628-533.686046511628
22145595.686046511628-550.686046511628
22246595.686046511628-549.686046511628
22393595.686046511628-502.686046511628
224141595.686046511628-454.686046511628
2250595.686046511628-595.686046511628
22663595.686046511628-532.686046511628
22764595.686046511628-531.686046511628
2281595.686046511628-594.686046511628
229187595.686046511628-408.686046511628
2300595.686046511628-595.686046511628
231177595.686046511628-418.686046511628
23294595.686046511628-501.686046511628
2330595.686046511628-595.686046511628
23464595.686046511628-531.686046511628
23525595.686046511628-570.686046511628
2360595.686046511628-595.686046511628
2372595.686046511628-593.686046511628
238193595.686046511628-402.686046511628
23914595.686046511628-581.686046511628
24024595.686046511628-571.686046511628
2411595.686046511628-594.686046511628
242131595.686046511628-464.686046511628
2430595.686046511628-595.686046511628
244211595.686046511628-384.686046511628
245166595.686046511628-429.686046511628
2460595.686046511628-595.686046511628
247119595.686046511628-476.686046511628
248101595.686046511628-494.686046511628
2490595.686046511628-595.686046511628
25040595.686046511628-555.686046511628
2510595.686046511628-595.686046511628
25235595.686046511628-560.686046511628
2536595.686046511628-589.686046511628



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