Free Statistics

of Irreproducible Research!

Author's title

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

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact76
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-23 13:49:55] [9aaeed430538c8fa0389aee05c40e1f1] [Current]
Feedback Forum

Post a new message
Dataseries X:
210907	56	30	145	0
120982	56	28	101	0
176508	54	38	98	0
179321	89	30	132	NA
123185	40	22	60	NA
52746	25	26	38	NA
385534	92	25	144	NA
33170	18	18	5	NA
101645	63	11	28	NA
149061	44	26	84	0
165446	33	25	79	NA
237213	84	38	127	0
173326	88	44	78	NA
133131	55	30	60	1
258873	60	40	131	NA
180083	66	34	84	NA
324799	154	47	133	0
230964	53	30	150	0
236785	119	31	91	1
135473	41	23	132	NA
202925	61	36	136	NA
215147	58	36	124	NA
344297	75	30	118	0
153935	33	25	70	NA
132943	40	39	107	NA
174724	92	34	119	0
174415	100	31	89	0
225548	112	31	112	NA
223632	73	33	108	0
124817	40	25	52	0
221698	45	33	112	NA
210767	60	35	116	NA
170266	62	42	123	NA
260561	75	43	125	NA
84853	31	30	27	NA
294424	77	33	162	0
101011	34	13	32	NA
215641	46	32	64	NA
325107	99	36	92	NA
7176	17	0	0	NA
167542	66	28	83	NA
106408	30	14	41	0
96560	76	17	47	0
265769	146	32	120	0
269651	67	30	105	NA
149112	56	35	79	1
175824	107	20	65	0
152871	58	28	70	0
111665	34	28	55	0
116408	61	39	39	NA
362301	119	34	67	0
78800	42	26	21	NA
183167	66	39	127	0
277965	89	39	152	NA
150629	44	33	113	NA
168809	66	28	99	NA
24188	24	4	7	NA
329267	259	39	141	0
65029	17	18	21	NA
101097	64	14	35	NA
218946	41	29	109	1
244052	68	44	133	0
341570	168	21	123	1
103597	43	16	26	0
233328	132	28	230	NA
256462	105	35	166	NA
206161	71	28	68	NA
311473	112	38	147	NA
235800	94	23	179	NA
177939	82	36	61	NA
207176	70	32	101	NA
196553	57	29	108	0
174184	53	25	90	NA
143246	103	27	114	0
187559	121	36	103	NA
187681	62	28	142	NA
119016	52	23	79	NA
182192	52	40	88	NA
73566	32	23	25	NA
194979	62	40	83	NA
167488	45	28	113	0
143756	46	34	118	0
275541	63	33	110	NA
243199	75	28	129	NA
182999	88	34	51	0
135649	46	30	93	NA
152299	53	33	76	0
120221	37	22	49	NA
346485	90	38	118	0
145790	63	26	38	NA
193339	78	35	141	0
80953	25	8	58	NA
122774	45	24	27	0
130585	46	29	91	0
112611	41	20	48	1
286468	144	29	63	0
241066	82	45	56	NA
148446	91	37	144	NA
204713	71	33	73	NA
182079	63	33	168	1
140344	53	25	64	1
220516	62	32	97	0
243060	63	29	117	1
162765	32	28	100	0
182613	39	28	149	NA
232138	62	31	187	NA
265318	117	52	127	NA
85574	34	21	37	0
310839	92	24	245	NA
225060	93	41	87	1
232317	54	33	177	NA
144966	144	32	49	NA
43287	14	19	49	NA
155754	61	20	73	NA
164709	109	31	177	0
201940	38	31	94	NA
235454	73	32	117	NA
220801	75	18	60	0
99466	50	23	55	0
92661	61	17	39	0
133328	55	20	64	1
61361	77	12	26	0
125930	75	17	64	NA
100750	72	30	58	1
224549	50	31	95	NA
82316	32	10	25	NA
102010	53	13	26	NA
101523	42	22	76	0
243511	71	42	129	0
22938	10	1	11	NA
41566	35	9	2	NA
152474	65	32	101	1
61857	25	11	28	NA
99923	66	25	36	0
132487	41	36	89	0
317394	86	31	193	NA
21054	16	0	4	NA
209641	42	24	84	NA
22648	19	13	23	0
31414	19	8	39	NA
46698	45	13	14	NA
131698	65	19	78	1
91735	35	18	14	NA
244749	95	33	101	1
184510	49	40	82	NA
79863	37	22	24	NA
128423	64	38	36	1
97839	38	24	75	1
38214	34	8	16	NA
151101	32	35	55	NA
272458	65	43	131	0
172494	52	43	131	0
108043	62	14	39	0
328107	65	41	144	0
250579	83	38	139	NA
351067	95	45	211	0
158015	29	31	78	NA
98866	18	13	50	NA
85439	33	28	39	NA
229242	247	31	90	0
351619	139	40	166	NA
84207	29	30	12	NA
120445	118	16	57	0
324598	110	37	133	0
131069	67	30	69	0
204271	42	35	119	NA
165543	65	32	119	NA
141722	94	27	65	NA
116048	64	20	61	1
250047	81	18	49	1
299775	95	31	101	0
195838	67	31	196	0
173260	63	21	15	0
254488	83	39	136	0
104389	45	41	89	NA
136084	30	13	40	NA
199476	70	32	123	NA
92499	32	18	21	0
224330	83	39	163	0
135781	31	14	29	0
74408	67	7	35	NA
81240	66	17	13	NA
14688	10	0	5	NA
181633	70	30	96	1
271856	103	37	151	NA
7199	5	0	6	NA
46660	20	5	13	NA
17547	5	1	3	NA
133368	36	16	56	NA
95227	34	32	23	NA
152601	48	24	57	NA
98146	40	17	14	1
79619	43	11	43	NA
59194	31	24	20	0
139942	42	22	72	NA
118612	46	12	87	1
72880	33	19	21	NA
65475	18	13	56	0
99643	55	17	59	NA
71965	35	15	82	NA
77272	59	16	43	NA
49289	19	24	25	NA
135131	66	15	38	NA
108446	60	17	25	0
89746	36	18	38	NA
44296	25	20	12	NA
77648	47	16	29	NA
181528	54	16	47	0
134019	53	18	45	0
124064	40	22	40	NA
92630	40	8	30	NA
121848	39	17	41	0
52915	14	18	25	NA
81872	45	16	23	NA
58981	36	23	14	0
53515	28	22	16	0
60812	44	13	26	NA
56375	30	13	21	0
65490	22	16	27	NA
80949	17	16	9	NA
76302	31	20	33	0
104011	55	22	42	0
98104	54	17	68	0
67989	21	18	32	NA
30989	14	17	6	NA
135458	81	12	67	NA
73504	35	7	33	NA
63123	43	17	77	0
61254	46	14	46	NA
74914	30	23	30	NA
31774	23	17	0	0
81437	38	14	36	0
87186	54	15	46	NA
50090	20	17	18	NA
65745	53	21	48	1
56653	45	18	29	0
158399	39	18	28	1
46455	20	17	34	NA
73624	24	17	33	0
38395	31	16	34	NA
91899	35	15	33	NA
139526	151	21	80	NA
52164	52	16	32	NA
51567	30	14	30	NA
70551	31	15	41	NA
84856	29	17	41	NA
102538	57	15	51	0
86678	40	15	18	0
85709	44	10	34	NA
34662	25	6	31	NA
150580	77	22	39	0
99611	35	21	54	0
19349	11	1	14	NA
99373	63	18	24	0
86230	44	17	24	0
30837	19	4	8	NA
31706	13	10	26	NA
89806	42	16	19	NA
62088	38	16	11	NA
40151	29	9	14	NA
27634	20	16	1	NA
76990	27	17	39	NA
37460	20	7	5	NA
54157	19	15	37	0
49862	37	14	32	NA
84337	26	14	38	NA
64175	42	18	47	0
59382	49	12	47	0
119308	30	16	37	0
76702	49	21	51	NA
103425	67	19	45	NA
70344	28	16	21	NA
43410	19	1	1	NA
104838	49	16	42	NA
62215	27	10	26	NA
69304	30	19	21	NA
53117	22	12	4	NA
19764	12	2	10	NA
86680	31	14	43	NA
84105	20	17	34	0
77945	20	19	31	NA
89113	39	14	19	NA
91005	29	11	34	NA
40248	16	4	6	NA
64187	27	16	11	0
50857	21	20	24	NA
56613	19	12	16	NA
62792	35	15	72	NA
72535	14	16	21	NA




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

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 5 seconds \tabularnewline
R Server & 'AstonUniversity' @ aston.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160410&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]'AstonUniversity' @ aston.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160410&T=0

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







Goodness of Fit
Correlation0.8875
R-squared0.7877
RMSE37872.9614

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8875[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7877[/C][/ROW]
[ROW][C]RMSE[/C][C]37872.9614[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160410&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160410&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.8875
R-squared0.7877
RMSE37872.9614







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1210907209753.1612903231153.83870967742
2120982164010.787878788-43028.7878787879
3176508164010.78787878812497.2121212121
4179321272321.375-93000.375
5123185112183.07142857111001.9285714286
65274659934.7586206897-7188.75862068965
7385534272321.375113212.625
83317045023.6-11853.6
9101645109181.8-7536.8
10149061164010.787878788-14949.7878787879
11165446164010.7878787881435.21212121213
12237213272321.375-35108.375
13173326212530.875-39204.875
14133131164010.787878788-30879.7878787879
15258873209753.16129032349119.8387096774
16180083164010.78787878816072.2121212121
17324799272321.37552477.625
18230964209753.16129032321210.8387096774
19236785212530.87524254.125
20135473112183.07142857123289.9285714286
21202925209753.161290323-6828.16129032258
22215147209753.1612903235393.83870967742
23344297272321.37571975.625
24153935164010.787878788-10075.7878787879
25132943209753.161290323-76810.1612903226
26174724272321.375-97597.375
27174415212530.875-38115.875
28225548212530.87513017.125
29223632212530.87511101.125
30124817136000.352941176-11183.3529411765
31221698209753.16129032311944.8387096774
32210767209753.1612903231013.83870967742
33170266209753.161290323-39487.1612903226
34260561272321.375-11760.375
3584853824012452
36294424272321.37522102.625
371010118240118610
38215641164010.78787878851630.2121212121
39325107212530.875112576.125
40717622366.5-15190.5
41167542164010.7878787883531.21212121213
421064088240124007
4396560109181.8-12621.8
44265769272321.375-6552.375
45269651209753.16129032359897.8387096774
46149112164010.787878788-14898.7878787879
47175824212530.875-36706.875
48152871164010.787878788-11139.7878787879
49111665136000.352941176-24335.3529411765
50116408109181.87226.2
51362301212530.875149770.125
527880082401-3601
53183167209753.161290323-26586.1612903226
54277965272321.3755643.625
55150629209753.161290323-59124.1612903226
56168809164010.7878787884798.21212121213
572418822366.51821.5
58329267272321.37556945.625
596502959934.75862068975094.24137931035
60101097109181.8-8084.8
61218946209753.1612903239192.83870967742
62244052209753.16129032334298.8387096774
63341570272321.37569248.625
641035978240121196
65233328272321.375-38993.375
66256462272321.375-15859.375
67206161212530.875-6369.875
68311473272321.37539151.625
69235800272321.375-36521.375
70177939212530.875-34591.875
71207176164010.78787878843165.2121212121
72196553209753.161290323-13200.1612903226
73174184164010.78787878810173.2121212121
74143246212530.875-69284.875
75187559212530.875-24971.875
76187681209753.161290323-22072.1612903226
77119016112183.0714285716832.92857142857
78182192164010.78787878818181.2121212121
797356682401-8835
80194979164010.78787878830968.2121212121
81167488209753.161290323-42265.1612903226
82143756209753.161290323-65997.1612903226
83275541209753.16129032365787.8387096774
84243199272321.375-29122.375
85182999136000.35294117646998.6470588235
86135649164010.787878788-28361.7878787879
87152299164010.787878788-11711.7878787879
88120221136000.352941176-15779.3529411765
89346485272321.37574163.625
90145790109181.836608.2
91193339272321.375-78982.375
928095359934.758620689721018.2413793103
931227748240140373
94130585164010.787878788-33425.7878787879
951126118240130210
96286468212530.87573937.125
97241066136000.352941176105065.647058824
98148446272321.375-123875.375
99204713212530.875-7817.875
100182079209753.161290323-27674.1612903226
101140344164010.787878788-23666.7878787879
102220516164010.78787878856505.2121212121
103243060209753.16129032333306.8387096774
104162765164010.787878788-1245.78787878787
105182613209753.161290323-27140.1612903226
106232138209753.16129032322384.8387096774
107265318272321.375-7003.375
10885574824013173
109310839272321.37538517.625
110225060212530.87512529.125
111232317209753.16129032322563.8387096774
112144966136000.3529411768965.64705882352
1134328759934.7586206897-16647.7586206897
114155754112183.07142857143570.9285714286
115164709272321.375-107612.375
116201940164010.78787878837929.2121212121
117235454212530.87522923.125
118220801212530.8758270.125
11999466136000.352941176-36534.3529411765
12092661109181.8-16520.8
121133328112183.07142857121144.9285714286
12261361109181.8-47820.8
123125930212530.875-86600.875
124100750136000.352941176-35250.3529411765
125224549164010.78787878860538.2121212121
1268231682401-85
127102010109181.8-7171.8
128101523112183.071428571-10660.0714285714
129243511272321.375-28810.375
1302293822366.5571.5
1314156682401-40835
132152474164010.787878788-11536.7878787879
1336185759934.75862068971922.24137931035
13499923109181.8-9258.8
135132487164010.787878788-31523.7878787879
136317394272321.37545072.625
1372105422366.5-1312.5
138209641164010.78787878845630.2121212121
1392264859934.7586206897-37286.7586206897
1403141459934.7586206897-28520.7586206897
1414669882401-35703
142131698112183.07142857119514.9285714286
14391735824019334
144244749212530.87532218.125
145184510164010.78787878820499.2121212121
1467986382401-2538
147128423109181.819241.2
14897839164010.787878788-66171.7878787879
1493821482401-44187
150151101136000.35294117615100.6470588235
151272458209753.16129032362704.8387096774
152172494209753.161290323-37259.1612903226
153108043109181.8-1138.8
154328107209753.161290323118353.838709677
155250579272321.375-21742.375
156351067272321.37578745.625
157158015164010.787878788-5995.78787878787
1589886659934.758620689738931.2413793103
15985439824013038
160229242212530.87516711.125
161351619272321.37579297.625
16284207824011806
163120445136000.352941176-15555.3529411765
164324598272321.37552276.625
165131069164010.787878788-32941.7878787879
166204271209753.161290323-5482.16129032258
167165543209753.161290323-44210.1612903226
168141722212530.875-70808.875
169116048112183.0714285713864.92857142857
170250047136000.352941176114046.647058824
171299775212530.87587244.125
172195838209753.161290323-13915.1612903226
173173260109181.864078.2
174254488272321.375-17833.375
175104389164010.787878788-59621.7878787879
1761360848240153683
177199476209753.161290323-10277.1612903226
178924998240110098
179224330272321.375-47991.375
1801357818240153380
18174408109181.8-34773.8
18281240109181.8-27941.8
1831468822366.5-7678.5
184181633164010.78787878817622.2121212121
185271856272321.375-465.375
186719922366.5-15167.5
1874666045023.61636.4
1881754722366.5-4819.5
189133368136000.352941176-2632.35294117648
190952278240112826
191152601136000.35294117616600.6470588235
192981468240115745
1937961982401-2782
1945919482401-23207
195139942112183.07142857127758.9285714286
196118612112183.0714285716428.92857142857
1977288082401-9521
1986547559934.75862068975540.24137931035
19999643136000.352941176-36357.3529411765
20071965112183.071428571-40218.0714285714
20177272109181.8-31909.8
2024928959934.7586206897-10645.7586206897
203135131109181.825949.2
204108446109181.8-735.800000000003
20589746824017345
2064429645023.6-727.599999999999
2077764882401-4753
208181528109181.872346.2
209134019109181.824837.2
2101240648240141663
211926308240110229
2121218488240139447
2135291559934.7586206897-7019.75862068965
2148187282401-529
2155898182401-23420
2165351559934.7586206897-6419.75862068965
2176081282401-21589
2185637582401-26026
2196549059934.75862068975555.24137931035
2208094945023.635925.4
2217630282401-6099
222104011109181.8-5170.8
22398104112183.071428571-14079.0714285714
2246798959934.75862068978054.24137931035
2253098945023.6-14034.6
226135458212530.875-77072.875
2277350482401-8897
22863123112183.071428571-49060.0714285714
2296125482401-21147
2307491482401-7487
2313177445023.6-13249.6
2328143782401-964
23387186109181.8-21995.8
2345009059934.7586206897-9844.75862068965
23565745109181.8-43436.8
2365665382401-25748
2371583998240175998
2384645559934.7586206897-13479.7586206897
2397362459934.758620689713689.2413793103
2403839582401-44006
24191899824019498
242139526212530.875-73004.875
2435216482401-30237
2445156782401-30834
2457055182401-11850
24684856824012455
247102538136000.352941176-33462.3529411765
24886678824014277
24985709824013308
2503466259934.7586206897-25272.7586206897
251150580109181.841398.2
25299611136000.352941176-36389.3529411765
2531934922366.5-3017.5
25499373109181.8-9808.8
25586230824013829
2563083722366.58470.5
2573170659934.7586206897-28228.7586206897
25889806824017405
2596208882401-20313
2604015182401-42250
2612763445023.6-17389.6
2627699059934.758620689717055.2413793103
2633746045023.6-7563.6
2645415759934.7586206897-5777.75862068965
2654986282401-32539
2668433759934.758620689724402.2413793103
2676417582401-18226
2685938282401-23019
2691193088240136907
27076702136000.352941176-59298.3529411765
271103425109181.8-5756.8
2727034459934.758620689710409.2413793103
2734341022366.521043.5
2741048388240122437
2756221559934.75862068972280.24137931035
2766930482401-13097
2775311745023.68093.4
2781976422366.5-2602.5
27986680824014279
2808410559934.758620689724170.2413793103
2817794559934.758620689718010.2413793103
28289113824016712
28391005824018604
2844024822366.517881.5
2856418745023.619163.4
2865085759934.7586206897-9077.75862068965
2875661359934.7586206897-3321.75862068965
28862792112183.071428571-49391.0714285714
2897253559934.758620689712600.2413793103

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 210907 & 209753.161290323 & 1153.83870967742 \tabularnewline
2 & 120982 & 164010.787878788 & -43028.7878787879 \tabularnewline
3 & 176508 & 164010.787878788 & 12497.2121212121 \tabularnewline
4 & 179321 & 272321.375 & -93000.375 \tabularnewline
5 & 123185 & 112183.071428571 & 11001.9285714286 \tabularnewline
6 & 52746 & 59934.7586206897 & -7188.75862068965 \tabularnewline
7 & 385534 & 272321.375 & 113212.625 \tabularnewline
8 & 33170 & 45023.6 & -11853.6 \tabularnewline
9 & 101645 & 109181.8 & -7536.8 \tabularnewline
10 & 149061 & 164010.787878788 & -14949.7878787879 \tabularnewline
11 & 165446 & 164010.787878788 & 1435.21212121213 \tabularnewline
12 & 237213 & 272321.375 & -35108.375 \tabularnewline
13 & 173326 & 212530.875 & -39204.875 \tabularnewline
14 & 133131 & 164010.787878788 & -30879.7878787879 \tabularnewline
15 & 258873 & 209753.161290323 & 49119.8387096774 \tabularnewline
16 & 180083 & 164010.787878788 & 16072.2121212121 \tabularnewline
17 & 324799 & 272321.375 & 52477.625 \tabularnewline
18 & 230964 & 209753.161290323 & 21210.8387096774 \tabularnewline
19 & 236785 & 212530.875 & 24254.125 \tabularnewline
20 & 135473 & 112183.071428571 & 23289.9285714286 \tabularnewline
21 & 202925 & 209753.161290323 & -6828.16129032258 \tabularnewline
22 & 215147 & 209753.161290323 & 5393.83870967742 \tabularnewline
23 & 344297 & 272321.375 & 71975.625 \tabularnewline
24 & 153935 & 164010.787878788 & -10075.7878787879 \tabularnewline
25 & 132943 & 209753.161290323 & -76810.1612903226 \tabularnewline
26 & 174724 & 272321.375 & -97597.375 \tabularnewline
27 & 174415 & 212530.875 & -38115.875 \tabularnewline
28 & 225548 & 212530.875 & 13017.125 \tabularnewline
29 & 223632 & 212530.875 & 11101.125 \tabularnewline
30 & 124817 & 136000.352941176 & -11183.3529411765 \tabularnewline
31 & 221698 & 209753.161290323 & 11944.8387096774 \tabularnewline
32 & 210767 & 209753.161290323 & 1013.83870967742 \tabularnewline
33 & 170266 & 209753.161290323 & -39487.1612903226 \tabularnewline
34 & 260561 & 272321.375 & -11760.375 \tabularnewline
35 & 84853 & 82401 & 2452 \tabularnewline
36 & 294424 & 272321.375 & 22102.625 \tabularnewline
37 & 101011 & 82401 & 18610 \tabularnewline
38 & 215641 & 164010.787878788 & 51630.2121212121 \tabularnewline
39 & 325107 & 212530.875 & 112576.125 \tabularnewline
40 & 7176 & 22366.5 & -15190.5 \tabularnewline
41 & 167542 & 164010.787878788 & 3531.21212121213 \tabularnewline
42 & 106408 & 82401 & 24007 \tabularnewline
43 & 96560 & 109181.8 & -12621.8 \tabularnewline
44 & 265769 & 272321.375 & -6552.375 \tabularnewline
45 & 269651 & 209753.161290323 & 59897.8387096774 \tabularnewline
46 & 149112 & 164010.787878788 & -14898.7878787879 \tabularnewline
47 & 175824 & 212530.875 & -36706.875 \tabularnewline
48 & 152871 & 164010.787878788 & -11139.7878787879 \tabularnewline
49 & 111665 & 136000.352941176 & -24335.3529411765 \tabularnewline
50 & 116408 & 109181.8 & 7226.2 \tabularnewline
51 & 362301 & 212530.875 & 149770.125 \tabularnewline
52 & 78800 & 82401 & -3601 \tabularnewline
53 & 183167 & 209753.161290323 & -26586.1612903226 \tabularnewline
54 & 277965 & 272321.375 & 5643.625 \tabularnewline
55 & 150629 & 209753.161290323 & -59124.1612903226 \tabularnewline
56 & 168809 & 164010.787878788 & 4798.21212121213 \tabularnewline
57 & 24188 & 22366.5 & 1821.5 \tabularnewline
58 & 329267 & 272321.375 & 56945.625 \tabularnewline
59 & 65029 & 59934.7586206897 & 5094.24137931035 \tabularnewline
60 & 101097 & 109181.8 & -8084.8 \tabularnewline
61 & 218946 & 209753.161290323 & 9192.83870967742 \tabularnewline
62 & 244052 & 209753.161290323 & 34298.8387096774 \tabularnewline
63 & 341570 & 272321.375 & 69248.625 \tabularnewline
64 & 103597 & 82401 & 21196 \tabularnewline
65 & 233328 & 272321.375 & -38993.375 \tabularnewline
66 & 256462 & 272321.375 & -15859.375 \tabularnewline
67 & 206161 & 212530.875 & -6369.875 \tabularnewline
68 & 311473 & 272321.375 & 39151.625 \tabularnewline
69 & 235800 & 272321.375 & -36521.375 \tabularnewline
70 & 177939 & 212530.875 & -34591.875 \tabularnewline
71 & 207176 & 164010.787878788 & 43165.2121212121 \tabularnewline
72 & 196553 & 209753.161290323 & -13200.1612903226 \tabularnewline
73 & 174184 & 164010.787878788 & 10173.2121212121 \tabularnewline
74 & 143246 & 212530.875 & -69284.875 \tabularnewline
75 & 187559 & 212530.875 & -24971.875 \tabularnewline
76 & 187681 & 209753.161290323 & -22072.1612903226 \tabularnewline
77 & 119016 & 112183.071428571 & 6832.92857142857 \tabularnewline
78 & 182192 & 164010.787878788 & 18181.2121212121 \tabularnewline
79 & 73566 & 82401 & -8835 \tabularnewline
80 & 194979 & 164010.787878788 & 30968.2121212121 \tabularnewline
81 & 167488 & 209753.161290323 & -42265.1612903226 \tabularnewline
82 & 143756 & 209753.161290323 & -65997.1612903226 \tabularnewline
83 & 275541 & 209753.161290323 & 65787.8387096774 \tabularnewline
84 & 243199 & 272321.375 & -29122.375 \tabularnewline
85 & 182999 & 136000.352941176 & 46998.6470588235 \tabularnewline
86 & 135649 & 164010.787878788 & -28361.7878787879 \tabularnewline
87 & 152299 & 164010.787878788 & -11711.7878787879 \tabularnewline
88 & 120221 & 136000.352941176 & -15779.3529411765 \tabularnewline
89 & 346485 & 272321.375 & 74163.625 \tabularnewline
90 & 145790 & 109181.8 & 36608.2 \tabularnewline
91 & 193339 & 272321.375 & -78982.375 \tabularnewline
92 & 80953 & 59934.7586206897 & 21018.2413793103 \tabularnewline
93 & 122774 & 82401 & 40373 \tabularnewline
94 & 130585 & 164010.787878788 & -33425.7878787879 \tabularnewline
95 & 112611 & 82401 & 30210 \tabularnewline
96 & 286468 & 212530.875 & 73937.125 \tabularnewline
97 & 241066 & 136000.352941176 & 105065.647058824 \tabularnewline
98 & 148446 & 272321.375 & -123875.375 \tabularnewline
99 & 204713 & 212530.875 & -7817.875 \tabularnewline
100 & 182079 & 209753.161290323 & -27674.1612903226 \tabularnewline
101 & 140344 & 164010.787878788 & -23666.7878787879 \tabularnewline
102 & 220516 & 164010.787878788 & 56505.2121212121 \tabularnewline
103 & 243060 & 209753.161290323 & 33306.8387096774 \tabularnewline
104 & 162765 & 164010.787878788 & -1245.78787878787 \tabularnewline
105 & 182613 & 209753.161290323 & -27140.1612903226 \tabularnewline
106 & 232138 & 209753.161290323 & 22384.8387096774 \tabularnewline
107 & 265318 & 272321.375 & -7003.375 \tabularnewline
108 & 85574 & 82401 & 3173 \tabularnewline
109 & 310839 & 272321.375 & 38517.625 \tabularnewline
110 & 225060 & 212530.875 & 12529.125 \tabularnewline
111 & 232317 & 209753.161290323 & 22563.8387096774 \tabularnewline
112 & 144966 & 136000.352941176 & 8965.64705882352 \tabularnewline
113 & 43287 & 59934.7586206897 & -16647.7586206897 \tabularnewline
114 & 155754 & 112183.071428571 & 43570.9285714286 \tabularnewline
115 & 164709 & 272321.375 & -107612.375 \tabularnewline
116 & 201940 & 164010.787878788 & 37929.2121212121 \tabularnewline
117 & 235454 & 212530.875 & 22923.125 \tabularnewline
118 & 220801 & 212530.875 & 8270.125 \tabularnewline
119 & 99466 & 136000.352941176 & -36534.3529411765 \tabularnewline
120 & 92661 & 109181.8 & -16520.8 \tabularnewline
121 & 133328 & 112183.071428571 & 21144.9285714286 \tabularnewline
122 & 61361 & 109181.8 & -47820.8 \tabularnewline
123 & 125930 & 212530.875 & -86600.875 \tabularnewline
124 & 100750 & 136000.352941176 & -35250.3529411765 \tabularnewline
125 & 224549 & 164010.787878788 & 60538.2121212121 \tabularnewline
126 & 82316 & 82401 & -85 \tabularnewline
127 & 102010 & 109181.8 & -7171.8 \tabularnewline
128 & 101523 & 112183.071428571 & -10660.0714285714 \tabularnewline
129 & 243511 & 272321.375 & -28810.375 \tabularnewline
130 & 22938 & 22366.5 & 571.5 \tabularnewline
131 & 41566 & 82401 & -40835 \tabularnewline
132 & 152474 & 164010.787878788 & -11536.7878787879 \tabularnewline
133 & 61857 & 59934.7586206897 & 1922.24137931035 \tabularnewline
134 & 99923 & 109181.8 & -9258.8 \tabularnewline
135 & 132487 & 164010.787878788 & -31523.7878787879 \tabularnewline
136 & 317394 & 272321.375 & 45072.625 \tabularnewline
137 & 21054 & 22366.5 & -1312.5 \tabularnewline
138 & 209641 & 164010.787878788 & 45630.2121212121 \tabularnewline
139 & 22648 & 59934.7586206897 & -37286.7586206897 \tabularnewline
140 & 31414 & 59934.7586206897 & -28520.7586206897 \tabularnewline
141 & 46698 & 82401 & -35703 \tabularnewline
142 & 131698 & 112183.071428571 & 19514.9285714286 \tabularnewline
143 & 91735 & 82401 & 9334 \tabularnewline
144 & 244749 & 212530.875 & 32218.125 \tabularnewline
145 & 184510 & 164010.787878788 & 20499.2121212121 \tabularnewline
146 & 79863 & 82401 & -2538 \tabularnewline
147 & 128423 & 109181.8 & 19241.2 \tabularnewline
148 & 97839 & 164010.787878788 & -66171.7878787879 \tabularnewline
149 & 38214 & 82401 & -44187 \tabularnewline
150 & 151101 & 136000.352941176 & 15100.6470588235 \tabularnewline
151 & 272458 & 209753.161290323 & 62704.8387096774 \tabularnewline
152 & 172494 & 209753.161290323 & -37259.1612903226 \tabularnewline
153 & 108043 & 109181.8 & -1138.8 \tabularnewline
154 & 328107 & 209753.161290323 & 118353.838709677 \tabularnewline
155 & 250579 & 272321.375 & -21742.375 \tabularnewline
156 & 351067 & 272321.375 & 78745.625 \tabularnewline
157 & 158015 & 164010.787878788 & -5995.78787878787 \tabularnewline
158 & 98866 & 59934.7586206897 & 38931.2413793103 \tabularnewline
159 & 85439 & 82401 & 3038 \tabularnewline
160 & 229242 & 212530.875 & 16711.125 \tabularnewline
161 & 351619 & 272321.375 & 79297.625 \tabularnewline
162 & 84207 & 82401 & 1806 \tabularnewline
163 & 120445 & 136000.352941176 & -15555.3529411765 \tabularnewline
164 & 324598 & 272321.375 & 52276.625 \tabularnewline
165 & 131069 & 164010.787878788 & -32941.7878787879 \tabularnewline
166 & 204271 & 209753.161290323 & -5482.16129032258 \tabularnewline
167 & 165543 & 209753.161290323 & -44210.1612903226 \tabularnewline
168 & 141722 & 212530.875 & -70808.875 \tabularnewline
169 & 116048 & 112183.071428571 & 3864.92857142857 \tabularnewline
170 & 250047 & 136000.352941176 & 114046.647058824 \tabularnewline
171 & 299775 & 212530.875 & 87244.125 \tabularnewline
172 & 195838 & 209753.161290323 & -13915.1612903226 \tabularnewline
173 & 173260 & 109181.8 & 64078.2 \tabularnewline
174 & 254488 & 272321.375 & -17833.375 \tabularnewline
175 & 104389 & 164010.787878788 & -59621.7878787879 \tabularnewline
176 & 136084 & 82401 & 53683 \tabularnewline
177 & 199476 & 209753.161290323 & -10277.1612903226 \tabularnewline
178 & 92499 & 82401 & 10098 \tabularnewline
179 & 224330 & 272321.375 & -47991.375 \tabularnewline
180 & 135781 & 82401 & 53380 \tabularnewline
181 & 74408 & 109181.8 & -34773.8 \tabularnewline
182 & 81240 & 109181.8 & -27941.8 \tabularnewline
183 & 14688 & 22366.5 & -7678.5 \tabularnewline
184 & 181633 & 164010.787878788 & 17622.2121212121 \tabularnewline
185 & 271856 & 272321.375 & -465.375 \tabularnewline
186 & 7199 & 22366.5 & -15167.5 \tabularnewline
187 & 46660 & 45023.6 & 1636.4 \tabularnewline
188 & 17547 & 22366.5 & -4819.5 \tabularnewline
189 & 133368 & 136000.352941176 & -2632.35294117648 \tabularnewline
190 & 95227 & 82401 & 12826 \tabularnewline
191 & 152601 & 136000.352941176 & 16600.6470588235 \tabularnewline
192 & 98146 & 82401 & 15745 \tabularnewline
193 & 79619 & 82401 & -2782 \tabularnewline
194 & 59194 & 82401 & -23207 \tabularnewline
195 & 139942 & 112183.071428571 & 27758.9285714286 \tabularnewline
196 & 118612 & 112183.071428571 & 6428.92857142857 \tabularnewline
197 & 72880 & 82401 & -9521 \tabularnewline
198 & 65475 & 59934.7586206897 & 5540.24137931035 \tabularnewline
199 & 99643 & 136000.352941176 & -36357.3529411765 \tabularnewline
200 & 71965 & 112183.071428571 & -40218.0714285714 \tabularnewline
201 & 77272 & 109181.8 & -31909.8 \tabularnewline
202 & 49289 & 59934.7586206897 & -10645.7586206897 \tabularnewline
203 & 135131 & 109181.8 & 25949.2 \tabularnewline
204 & 108446 & 109181.8 & -735.800000000003 \tabularnewline
205 & 89746 & 82401 & 7345 \tabularnewline
206 & 44296 & 45023.6 & -727.599999999999 \tabularnewline
207 & 77648 & 82401 & -4753 \tabularnewline
208 & 181528 & 109181.8 & 72346.2 \tabularnewline
209 & 134019 & 109181.8 & 24837.2 \tabularnewline
210 & 124064 & 82401 & 41663 \tabularnewline
211 & 92630 & 82401 & 10229 \tabularnewline
212 & 121848 & 82401 & 39447 \tabularnewline
213 & 52915 & 59934.7586206897 & -7019.75862068965 \tabularnewline
214 & 81872 & 82401 & -529 \tabularnewline
215 & 58981 & 82401 & -23420 \tabularnewline
216 & 53515 & 59934.7586206897 & -6419.75862068965 \tabularnewline
217 & 60812 & 82401 & -21589 \tabularnewline
218 & 56375 & 82401 & -26026 \tabularnewline
219 & 65490 & 59934.7586206897 & 5555.24137931035 \tabularnewline
220 & 80949 & 45023.6 & 35925.4 \tabularnewline
221 & 76302 & 82401 & -6099 \tabularnewline
222 & 104011 & 109181.8 & -5170.8 \tabularnewline
223 & 98104 & 112183.071428571 & -14079.0714285714 \tabularnewline
224 & 67989 & 59934.7586206897 & 8054.24137931035 \tabularnewline
225 & 30989 & 45023.6 & -14034.6 \tabularnewline
226 & 135458 & 212530.875 & -77072.875 \tabularnewline
227 & 73504 & 82401 & -8897 \tabularnewline
228 & 63123 & 112183.071428571 & -49060.0714285714 \tabularnewline
229 & 61254 & 82401 & -21147 \tabularnewline
230 & 74914 & 82401 & -7487 \tabularnewline
231 & 31774 & 45023.6 & -13249.6 \tabularnewline
232 & 81437 & 82401 & -964 \tabularnewline
233 & 87186 & 109181.8 & -21995.8 \tabularnewline
234 & 50090 & 59934.7586206897 & -9844.75862068965 \tabularnewline
235 & 65745 & 109181.8 & -43436.8 \tabularnewline
236 & 56653 & 82401 & -25748 \tabularnewline
237 & 158399 & 82401 & 75998 \tabularnewline
238 & 46455 & 59934.7586206897 & -13479.7586206897 \tabularnewline
239 & 73624 & 59934.7586206897 & 13689.2413793103 \tabularnewline
240 & 38395 & 82401 & -44006 \tabularnewline
241 & 91899 & 82401 & 9498 \tabularnewline
242 & 139526 & 212530.875 & -73004.875 \tabularnewline
243 & 52164 & 82401 & -30237 \tabularnewline
244 & 51567 & 82401 & -30834 \tabularnewline
245 & 70551 & 82401 & -11850 \tabularnewline
246 & 84856 & 82401 & 2455 \tabularnewline
247 & 102538 & 136000.352941176 & -33462.3529411765 \tabularnewline
248 & 86678 & 82401 & 4277 \tabularnewline
249 & 85709 & 82401 & 3308 \tabularnewline
250 & 34662 & 59934.7586206897 & -25272.7586206897 \tabularnewline
251 & 150580 & 109181.8 & 41398.2 \tabularnewline
252 & 99611 & 136000.352941176 & -36389.3529411765 \tabularnewline
253 & 19349 & 22366.5 & -3017.5 \tabularnewline
254 & 99373 & 109181.8 & -9808.8 \tabularnewline
255 & 86230 & 82401 & 3829 \tabularnewline
256 & 30837 & 22366.5 & 8470.5 \tabularnewline
257 & 31706 & 59934.7586206897 & -28228.7586206897 \tabularnewline
258 & 89806 & 82401 & 7405 \tabularnewline
259 & 62088 & 82401 & -20313 \tabularnewline
260 & 40151 & 82401 & -42250 \tabularnewline
261 & 27634 & 45023.6 & -17389.6 \tabularnewline
262 & 76990 & 59934.7586206897 & 17055.2413793103 \tabularnewline
263 & 37460 & 45023.6 & -7563.6 \tabularnewline
264 & 54157 & 59934.7586206897 & -5777.75862068965 \tabularnewline
265 & 49862 & 82401 & -32539 \tabularnewline
266 & 84337 & 59934.7586206897 & 24402.2413793103 \tabularnewline
267 & 64175 & 82401 & -18226 \tabularnewline
268 & 59382 & 82401 & -23019 \tabularnewline
269 & 119308 & 82401 & 36907 \tabularnewline
270 & 76702 & 136000.352941176 & -59298.3529411765 \tabularnewline
271 & 103425 & 109181.8 & -5756.8 \tabularnewline
272 & 70344 & 59934.7586206897 & 10409.2413793103 \tabularnewline
273 & 43410 & 22366.5 & 21043.5 \tabularnewline
274 & 104838 & 82401 & 22437 \tabularnewline
275 & 62215 & 59934.7586206897 & 2280.24137931035 \tabularnewline
276 & 69304 & 82401 & -13097 \tabularnewline
277 & 53117 & 45023.6 & 8093.4 \tabularnewline
278 & 19764 & 22366.5 & -2602.5 \tabularnewline
279 & 86680 & 82401 & 4279 \tabularnewline
280 & 84105 & 59934.7586206897 & 24170.2413793103 \tabularnewline
281 & 77945 & 59934.7586206897 & 18010.2413793103 \tabularnewline
282 & 89113 & 82401 & 6712 \tabularnewline
283 & 91005 & 82401 & 8604 \tabularnewline
284 & 40248 & 22366.5 & 17881.5 \tabularnewline
285 & 64187 & 45023.6 & 19163.4 \tabularnewline
286 & 50857 & 59934.7586206897 & -9077.75862068965 \tabularnewline
287 & 56613 & 59934.7586206897 & -3321.75862068965 \tabularnewline
288 & 62792 & 112183.071428571 & -49391.0714285714 \tabularnewline
289 & 72535 & 59934.7586206897 & 12600.2413793103 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160410&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]209753.161290323[/C][C]1153.83870967742[/C][/ROW]
[ROW][C]2[/C][C]120982[/C][C]164010.787878788[/C][C]-43028.7878787879[/C][/ROW]
[ROW][C]3[/C][C]176508[/C][C]164010.787878788[/C][C]12497.2121212121[/C][/ROW]
[ROW][C]4[/C][C]179321[/C][C]272321.375[/C][C]-93000.375[/C][/ROW]
[ROW][C]5[/C][C]123185[/C][C]112183.071428571[/C][C]11001.9285714286[/C][/ROW]
[ROW][C]6[/C][C]52746[/C][C]59934.7586206897[/C][C]-7188.75862068965[/C][/ROW]
[ROW][C]7[/C][C]385534[/C][C]272321.375[/C][C]113212.625[/C][/ROW]
[ROW][C]8[/C][C]33170[/C][C]45023.6[/C][C]-11853.6[/C][/ROW]
[ROW][C]9[/C][C]101645[/C][C]109181.8[/C][C]-7536.8[/C][/ROW]
[ROW][C]10[/C][C]149061[/C][C]164010.787878788[/C][C]-14949.7878787879[/C][/ROW]
[ROW][C]11[/C][C]165446[/C][C]164010.787878788[/C][C]1435.21212121213[/C][/ROW]
[ROW][C]12[/C][C]237213[/C][C]272321.375[/C][C]-35108.375[/C][/ROW]
[ROW][C]13[/C][C]173326[/C][C]212530.875[/C][C]-39204.875[/C][/ROW]
[ROW][C]14[/C][C]133131[/C][C]164010.787878788[/C][C]-30879.7878787879[/C][/ROW]
[ROW][C]15[/C][C]258873[/C][C]209753.161290323[/C][C]49119.8387096774[/C][/ROW]
[ROW][C]16[/C][C]180083[/C][C]164010.787878788[/C][C]16072.2121212121[/C][/ROW]
[ROW][C]17[/C][C]324799[/C][C]272321.375[/C][C]52477.625[/C][/ROW]
[ROW][C]18[/C][C]230964[/C][C]209753.161290323[/C][C]21210.8387096774[/C][/ROW]
[ROW][C]19[/C][C]236785[/C][C]212530.875[/C][C]24254.125[/C][/ROW]
[ROW][C]20[/C][C]135473[/C][C]112183.071428571[/C][C]23289.9285714286[/C][/ROW]
[ROW][C]21[/C][C]202925[/C][C]209753.161290323[/C][C]-6828.16129032258[/C][/ROW]
[ROW][C]22[/C][C]215147[/C][C]209753.161290323[/C][C]5393.83870967742[/C][/ROW]
[ROW][C]23[/C][C]344297[/C][C]272321.375[/C][C]71975.625[/C][/ROW]
[ROW][C]24[/C][C]153935[/C][C]164010.787878788[/C][C]-10075.7878787879[/C][/ROW]
[ROW][C]25[/C][C]132943[/C][C]209753.161290323[/C][C]-76810.1612903226[/C][/ROW]
[ROW][C]26[/C][C]174724[/C][C]272321.375[/C][C]-97597.375[/C][/ROW]
[ROW][C]27[/C][C]174415[/C][C]212530.875[/C][C]-38115.875[/C][/ROW]
[ROW][C]28[/C][C]225548[/C][C]212530.875[/C][C]13017.125[/C][/ROW]
[ROW][C]29[/C][C]223632[/C][C]212530.875[/C][C]11101.125[/C][/ROW]
[ROW][C]30[/C][C]124817[/C][C]136000.352941176[/C][C]-11183.3529411765[/C][/ROW]
[ROW][C]31[/C][C]221698[/C][C]209753.161290323[/C][C]11944.8387096774[/C][/ROW]
[ROW][C]32[/C][C]210767[/C][C]209753.161290323[/C][C]1013.83870967742[/C][/ROW]
[ROW][C]33[/C][C]170266[/C][C]209753.161290323[/C][C]-39487.1612903226[/C][/ROW]
[ROW][C]34[/C][C]260561[/C][C]272321.375[/C][C]-11760.375[/C][/ROW]
[ROW][C]35[/C][C]84853[/C][C]82401[/C][C]2452[/C][/ROW]
[ROW][C]36[/C][C]294424[/C][C]272321.375[/C][C]22102.625[/C][/ROW]
[ROW][C]37[/C][C]101011[/C][C]82401[/C][C]18610[/C][/ROW]
[ROW][C]38[/C][C]215641[/C][C]164010.787878788[/C][C]51630.2121212121[/C][/ROW]
[ROW][C]39[/C][C]325107[/C][C]212530.875[/C][C]112576.125[/C][/ROW]
[ROW][C]40[/C][C]7176[/C][C]22366.5[/C][C]-15190.5[/C][/ROW]
[ROW][C]41[/C][C]167542[/C][C]164010.787878788[/C][C]3531.21212121213[/C][/ROW]
[ROW][C]42[/C][C]106408[/C][C]82401[/C][C]24007[/C][/ROW]
[ROW][C]43[/C][C]96560[/C][C]109181.8[/C][C]-12621.8[/C][/ROW]
[ROW][C]44[/C][C]265769[/C][C]272321.375[/C][C]-6552.375[/C][/ROW]
[ROW][C]45[/C][C]269651[/C][C]209753.161290323[/C][C]59897.8387096774[/C][/ROW]
[ROW][C]46[/C][C]149112[/C][C]164010.787878788[/C][C]-14898.7878787879[/C][/ROW]
[ROW][C]47[/C][C]175824[/C][C]212530.875[/C][C]-36706.875[/C][/ROW]
[ROW][C]48[/C][C]152871[/C][C]164010.787878788[/C][C]-11139.7878787879[/C][/ROW]
[ROW][C]49[/C][C]111665[/C][C]136000.352941176[/C][C]-24335.3529411765[/C][/ROW]
[ROW][C]50[/C][C]116408[/C][C]109181.8[/C][C]7226.2[/C][/ROW]
[ROW][C]51[/C][C]362301[/C][C]212530.875[/C][C]149770.125[/C][/ROW]
[ROW][C]52[/C][C]78800[/C][C]82401[/C][C]-3601[/C][/ROW]
[ROW][C]53[/C][C]183167[/C][C]209753.161290323[/C][C]-26586.1612903226[/C][/ROW]
[ROW][C]54[/C][C]277965[/C][C]272321.375[/C][C]5643.625[/C][/ROW]
[ROW][C]55[/C][C]150629[/C][C]209753.161290323[/C][C]-59124.1612903226[/C][/ROW]
[ROW][C]56[/C][C]168809[/C][C]164010.787878788[/C][C]4798.21212121213[/C][/ROW]
[ROW][C]57[/C][C]24188[/C][C]22366.5[/C][C]1821.5[/C][/ROW]
[ROW][C]58[/C][C]329267[/C][C]272321.375[/C][C]56945.625[/C][/ROW]
[ROW][C]59[/C][C]65029[/C][C]59934.7586206897[/C][C]5094.24137931035[/C][/ROW]
[ROW][C]60[/C][C]101097[/C][C]109181.8[/C][C]-8084.8[/C][/ROW]
[ROW][C]61[/C][C]218946[/C][C]209753.161290323[/C][C]9192.83870967742[/C][/ROW]
[ROW][C]62[/C][C]244052[/C][C]209753.161290323[/C][C]34298.8387096774[/C][/ROW]
[ROW][C]63[/C][C]341570[/C][C]272321.375[/C][C]69248.625[/C][/ROW]
[ROW][C]64[/C][C]103597[/C][C]82401[/C][C]21196[/C][/ROW]
[ROW][C]65[/C][C]233328[/C][C]272321.375[/C][C]-38993.375[/C][/ROW]
[ROW][C]66[/C][C]256462[/C][C]272321.375[/C][C]-15859.375[/C][/ROW]
[ROW][C]67[/C][C]206161[/C][C]212530.875[/C][C]-6369.875[/C][/ROW]
[ROW][C]68[/C][C]311473[/C][C]272321.375[/C][C]39151.625[/C][/ROW]
[ROW][C]69[/C][C]235800[/C][C]272321.375[/C][C]-36521.375[/C][/ROW]
[ROW][C]70[/C][C]177939[/C][C]212530.875[/C][C]-34591.875[/C][/ROW]
[ROW][C]71[/C][C]207176[/C][C]164010.787878788[/C][C]43165.2121212121[/C][/ROW]
[ROW][C]72[/C][C]196553[/C][C]209753.161290323[/C][C]-13200.1612903226[/C][/ROW]
[ROW][C]73[/C][C]174184[/C][C]164010.787878788[/C][C]10173.2121212121[/C][/ROW]
[ROW][C]74[/C][C]143246[/C][C]212530.875[/C][C]-69284.875[/C][/ROW]
[ROW][C]75[/C][C]187559[/C][C]212530.875[/C][C]-24971.875[/C][/ROW]
[ROW][C]76[/C][C]187681[/C][C]209753.161290323[/C][C]-22072.1612903226[/C][/ROW]
[ROW][C]77[/C][C]119016[/C][C]112183.071428571[/C][C]6832.92857142857[/C][/ROW]
[ROW][C]78[/C][C]182192[/C][C]164010.787878788[/C][C]18181.2121212121[/C][/ROW]
[ROW][C]79[/C][C]73566[/C][C]82401[/C][C]-8835[/C][/ROW]
[ROW][C]80[/C][C]194979[/C][C]164010.787878788[/C][C]30968.2121212121[/C][/ROW]
[ROW][C]81[/C][C]167488[/C][C]209753.161290323[/C][C]-42265.1612903226[/C][/ROW]
[ROW][C]82[/C][C]143756[/C][C]209753.161290323[/C][C]-65997.1612903226[/C][/ROW]
[ROW][C]83[/C][C]275541[/C][C]209753.161290323[/C][C]65787.8387096774[/C][/ROW]
[ROW][C]84[/C][C]243199[/C][C]272321.375[/C][C]-29122.375[/C][/ROW]
[ROW][C]85[/C][C]182999[/C][C]136000.352941176[/C][C]46998.6470588235[/C][/ROW]
[ROW][C]86[/C][C]135649[/C][C]164010.787878788[/C][C]-28361.7878787879[/C][/ROW]
[ROW][C]87[/C][C]152299[/C][C]164010.787878788[/C][C]-11711.7878787879[/C][/ROW]
[ROW][C]88[/C][C]120221[/C][C]136000.352941176[/C][C]-15779.3529411765[/C][/ROW]
[ROW][C]89[/C][C]346485[/C][C]272321.375[/C][C]74163.625[/C][/ROW]
[ROW][C]90[/C][C]145790[/C][C]109181.8[/C][C]36608.2[/C][/ROW]
[ROW][C]91[/C][C]193339[/C][C]272321.375[/C][C]-78982.375[/C][/ROW]
[ROW][C]92[/C][C]80953[/C][C]59934.7586206897[/C][C]21018.2413793103[/C][/ROW]
[ROW][C]93[/C][C]122774[/C][C]82401[/C][C]40373[/C][/ROW]
[ROW][C]94[/C][C]130585[/C][C]164010.787878788[/C][C]-33425.7878787879[/C][/ROW]
[ROW][C]95[/C][C]112611[/C][C]82401[/C][C]30210[/C][/ROW]
[ROW][C]96[/C][C]286468[/C][C]212530.875[/C][C]73937.125[/C][/ROW]
[ROW][C]97[/C][C]241066[/C][C]136000.352941176[/C][C]105065.647058824[/C][/ROW]
[ROW][C]98[/C][C]148446[/C][C]272321.375[/C][C]-123875.375[/C][/ROW]
[ROW][C]99[/C][C]204713[/C][C]212530.875[/C][C]-7817.875[/C][/ROW]
[ROW][C]100[/C][C]182079[/C][C]209753.161290323[/C][C]-27674.1612903226[/C][/ROW]
[ROW][C]101[/C][C]140344[/C][C]164010.787878788[/C][C]-23666.7878787879[/C][/ROW]
[ROW][C]102[/C][C]220516[/C][C]164010.787878788[/C][C]56505.2121212121[/C][/ROW]
[ROW][C]103[/C][C]243060[/C][C]209753.161290323[/C][C]33306.8387096774[/C][/ROW]
[ROW][C]104[/C][C]162765[/C][C]164010.787878788[/C][C]-1245.78787878787[/C][/ROW]
[ROW][C]105[/C][C]182613[/C][C]209753.161290323[/C][C]-27140.1612903226[/C][/ROW]
[ROW][C]106[/C][C]232138[/C][C]209753.161290323[/C][C]22384.8387096774[/C][/ROW]
[ROW][C]107[/C][C]265318[/C][C]272321.375[/C][C]-7003.375[/C][/ROW]
[ROW][C]108[/C][C]85574[/C][C]82401[/C][C]3173[/C][/ROW]
[ROW][C]109[/C][C]310839[/C][C]272321.375[/C][C]38517.625[/C][/ROW]
[ROW][C]110[/C][C]225060[/C][C]212530.875[/C][C]12529.125[/C][/ROW]
[ROW][C]111[/C][C]232317[/C][C]209753.161290323[/C][C]22563.8387096774[/C][/ROW]
[ROW][C]112[/C][C]144966[/C][C]136000.352941176[/C][C]8965.64705882352[/C][/ROW]
[ROW][C]113[/C][C]43287[/C][C]59934.7586206897[/C][C]-16647.7586206897[/C][/ROW]
[ROW][C]114[/C][C]155754[/C][C]112183.071428571[/C][C]43570.9285714286[/C][/ROW]
[ROW][C]115[/C][C]164709[/C][C]272321.375[/C][C]-107612.375[/C][/ROW]
[ROW][C]116[/C][C]201940[/C][C]164010.787878788[/C][C]37929.2121212121[/C][/ROW]
[ROW][C]117[/C][C]235454[/C][C]212530.875[/C][C]22923.125[/C][/ROW]
[ROW][C]118[/C][C]220801[/C][C]212530.875[/C][C]8270.125[/C][/ROW]
[ROW][C]119[/C][C]99466[/C][C]136000.352941176[/C][C]-36534.3529411765[/C][/ROW]
[ROW][C]120[/C][C]92661[/C][C]109181.8[/C][C]-16520.8[/C][/ROW]
[ROW][C]121[/C][C]133328[/C][C]112183.071428571[/C][C]21144.9285714286[/C][/ROW]
[ROW][C]122[/C][C]61361[/C][C]109181.8[/C][C]-47820.8[/C][/ROW]
[ROW][C]123[/C][C]125930[/C][C]212530.875[/C][C]-86600.875[/C][/ROW]
[ROW][C]124[/C][C]100750[/C][C]136000.352941176[/C][C]-35250.3529411765[/C][/ROW]
[ROW][C]125[/C][C]224549[/C][C]164010.787878788[/C][C]60538.2121212121[/C][/ROW]
[ROW][C]126[/C][C]82316[/C][C]82401[/C][C]-85[/C][/ROW]
[ROW][C]127[/C][C]102010[/C][C]109181.8[/C][C]-7171.8[/C][/ROW]
[ROW][C]128[/C][C]101523[/C][C]112183.071428571[/C][C]-10660.0714285714[/C][/ROW]
[ROW][C]129[/C][C]243511[/C][C]272321.375[/C][C]-28810.375[/C][/ROW]
[ROW][C]130[/C][C]22938[/C][C]22366.5[/C][C]571.5[/C][/ROW]
[ROW][C]131[/C][C]41566[/C][C]82401[/C][C]-40835[/C][/ROW]
[ROW][C]132[/C][C]152474[/C][C]164010.787878788[/C][C]-11536.7878787879[/C][/ROW]
[ROW][C]133[/C][C]61857[/C][C]59934.7586206897[/C][C]1922.24137931035[/C][/ROW]
[ROW][C]134[/C][C]99923[/C][C]109181.8[/C][C]-9258.8[/C][/ROW]
[ROW][C]135[/C][C]132487[/C][C]164010.787878788[/C][C]-31523.7878787879[/C][/ROW]
[ROW][C]136[/C][C]317394[/C][C]272321.375[/C][C]45072.625[/C][/ROW]
[ROW][C]137[/C][C]21054[/C][C]22366.5[/C][C]-1312.5[/C][/ROW]
[ROW][C]138[/C][C]209641[/C][C]164010.787878788[/C][C]45630.2121212121[/C][/ROW]
[ROW][C]139[/C][C]22648[/C][C]59934.7586206897[/C][C]-37286.7586206897[/C][/ROW]
[ROW][C]140[/C][C]31414[/C][C]59934.7586206897[/C][C]-28520.7586206897[/C][/ROW]
[ROW][C]141[/C][C]46698[/C][C]82401[/C][C]-35703[/C][/ROW]
[ROW][C]142[/C][C]131698[/C][C]112183.071428571[/C][C]19514.9285714286[/C][/ROW]
[ROW][C]143[/C][C]91735[/C][C]82401[/C][C]9334[/C][/ROW]
[ROW][C]144[/C][C]244749[/C][C]212530.875[/C][C]32218.125[/C][/ROW]
[ROW][C]145[/C][C]184510[/C][C]164010.787878788[/C][C]20499.2121212121[/C][/ROW]
[ROW][C]146[/C][C]79863[/C][C]82401[/C][C]-2538[/C][/ROW]
[ROW][C]147[/C][C]128423[/C][C]109181.8[/C][C]19241.2[/C][/ROW]
[ROW][C]148[/C][C]97839[/C][C]164010.787878788[/C][C]-66171.7878787879[/C][/ROW]
[ROW][C]149[/C][C]38214[/C][C]82401[/C][C]-44187[/C][/ROW]
[ROW][C]150[/C][C]151101[/C][C]136000.352941176[/C][C]15100.6470588235[/C][/ROW]
[ROW][C]151[/C][C]272458[/C][C]209753.161290323[/C][C]62704.8387096774[/C][/ROW]
[ROW][C]152[/C][C]172494[/C][C]209753.161290323[/C][C]-37259.1612903226[/C][/ROW]
[ROW][C]153[/C][C]108043[/C][C]109181.8[/C][C]-1138.8[/C][/ROW]
[ROW][C]154[/C][C]328107[/C][C]209753.161290323[/C][C]118353.838709677[/C][/ROW]
[ROW][C]155[/C][C]250579[/C][C]272321.375[/C][C]-21742.375[/C][/ROW]
[ROW][C]156[/C][C]351067[/C][C]272321.375[/C][C]78745.625[/C][/ROW]
[ROW][C]157[/C][C]158015[/C][C]164010.787878788[/C][C]-5995.78787878787[/C][/ROW]
[ROW][C]158[/C][C]98866[/C][C]59934.7586206897[/C][C]38931.2413793103[/C][/ROW]
[ROW][C]159[/C][C]85439[/C][C]82401[/C][C]3038[/C][/ROW]
[ROW][C]160[/C][C]229242[/C][C]212530.875[/C][C]16711.125[/C][/ROW]
[ROW][C]161[/C][C]351619[/C][C]272321.375[/C][C]79297.625[/C][/ROW]
[ROW][C]162[/C][C]84207[/C][C]82401[/C][C]1806[/C][/ROW]
[ROW][C]163[/C][C]120445[/C][C]136000.352941176[/C][C]-15555.3529411765[/C][/ROW]
[ROW][C]164[/C][C]324598[/C][C]272321.375[/C][C]52276.625[/C][/ROW]
[ROW][C]165[/C][C]131069[/C][C]164010.787878788[/C][C]-32941.7878787879[/C][/ROW]
[ROW][C]166[/C][C]204271[/C][C]209753.161290323[/C][C]-5482.16129032258[/C][/ROW]
[ROW][C]167[/C][C]165543[/C][C]209753.161290323[/C][C]-44210.1612903226[/C][/ROW]
[ROW][C]168[/C][C]141722[/C][C]212530.875[/C][C]-70808.875[/C][/ROW]
[ROW][C]169[/C][C]116048[/C][C]112183.071428571[/C][C]3864.92857142857[/C][/ROW]
[ROW][C]170[/C][C]250047[/C][C]136000.352941176[/C][C]114046.647058824[/C][/ROW]
[ROW][C]171[/C][C]299775[/C][C]212530.875[/C][C]87244.125[/C][/ROW]
[ROW][C]172[/C][C]195838[/C][C]209753.161290323[/C][C]-13915.1612903226[/C][/ROW]
[ROW][C]173[/C][C]173260[/C][C]109181.8[/C][C]64078.2[/C][/ROW]
[ROW][C]174[/C][C]254488[/C][C]272321.375[/C][C]-17833.375[/C][/ROW]
[ROW][C]175[/C][C]104389[/C][C]164010.787878788[/C][C]-59621.7878787879[/C][/ROW]
[ROW][C]176[/C][C]136084[/C][C]82401[/C][C]53683[/C][/ROW]
[ROW][C]177[/C][C]199476[/C][C]209753.161290323[/C][C]-10277.1612903226[/C][/ROW]
[ROW][C]178[/C][C]92499[/C][C]82401[/C][C]10098[/C][/ROW]
[ROW][C]179[/C][C]224330[/C][C]272321.375[/C][C]-47991.375[/C][/ROW]
[ROW][C]180[/C][C]135781[/C][C]82401[/C][C]53380[/C][/ROW]
[ROW][C]181[/C][C]74408[/C][C]109181.8[/C][C]-34773.8[/C][/ROW]
[ROW][C]182[/C][C]81240[/C][C]109181.8[/C][C]-27941.8[/C][/ROW]
[ROW][C]183[/C][C]14688[/C][C]22366.5[/C][C]-7678.5[/C][/ROW]
[ROW][C]184[/C][C]181633[/C][C]164010.787878788[/C][C]17622.2121212121[/C][/ROW]
[ROW][C]185[/C][C]271856[/C][C]272321.375[/C][C]-465.375[/C][/ROW]
[ROW][C]186[/C][C]7199[/C][C]22366.5[/C][C]-15167.5[/C][/ROW]
[ROW][C]187[/C][C]46660[/C][C]45023.6[/C][C]1636.4[/C][/ROW]
[ROW][C]188[/C][C]17547[/C][C]22366.5[/C][C]-4819.5[/C][/ROW]
[ROW][C]189[/C][C]133368[/C][C]136000.352941176[/C][C]-2632.35294117648[/C][/ROW]
[ROW][C]190[/C][C]95227[/C][C]82401[/C][C]12826[/C][/ROW]
[ROW][C]191[/C][C]152601[/C][C]136000.352941176[/C][C]16600.6470588235[/C][/ROW]
[ROW][C]192[/C][C]98146[/C][C]82401[/C][C]15745[/C][/ROW]
[ROW][C]193[/C][C]79619[/C][C]82401[/C][C]-2782[/C][/ROW]
[ROW][C]194[/C][C]59194[/C][C]82401[/C][C]-23207[/C][/ROW]
[ROW][C]195[/C][C]139942[/C][C]112183.071428571[/C][C]27758.9285714286[/C][/ROW]
[ROW][C]196[/C][C]118612[/C][C]112183.071428571[/C][C]6428.92857142857[/C][/ROW]
[ROW][C]197[/C][C]72880[/C][C]82401[/C][C]-9521[/C][/ROW]
[ROW][C]198[/C][C]65475[/C][C]59934.7586206897[/C][C]5540.24137931035[/C][/ROW]
[ROW][C]199[/C][C]99643[/C][C]136000.352941176[/C][C]-36357.3529411765[/C][/ROW]
[ROW][C]200[/C][C]71965[/C][C]112183.071428571[/C][C]-40218.0714285714[/C][/ROW]
[ROW][C]201[/C][C]77272[/C][C]109181.8[/C][C]-31909.8[/C][/ROW]
[ROW][C]202[/C][C]49289[/C][C]59934.7586206897[/C][C]-10645.7586206897[/C][/ROW]
[ROW][C]203[/C][C]135131[/C][C]109181.8[/C][C]25949.2[/C][/ROW]
[ROW][C]204[/C][C]108446[/C][C]109181.8[/C][C]-735.800000000003[/C][/ROW]
[ROW][C]205[/C][C]89746[/C][C]82401[/C][C]7345[/C][/ROW]
[ROW][C]206[/C][C]44296[/C][C]45023.6[/C][C]-727.599999999999[/C][/ROW]
[ROW][C]207[/C][C]77648[/C][C]82401[/C][C]-4753[/C][/ROW]
[ROW][C]208[/C][C]181528[/C][C]109181.8[/C][C]72346.2[/C][/ROW]
[ROW][C]209[/C][C]134019[/C][C]109181.8[/C][C]24837.2[/C][/ROW]
[ROW][C]210[/C][C]124064[/C][C]82401[/C][C]41663[/C][/ROW]
[ROW][C]211[/C][C]92630[/C][C]82401[/C][C]10229[/C][/ROW]
[ROW][C]212[/C][C]121848[/C][C]82401[/C][C]39447[/C][/ROW]
[ROW][C]213[/C][C]52915[/C][C]59934.7586206897[/C][C]-7019.75862068965[/C][/ROW]
[ROW][C]214[/C][C]81872[/C][C]82401[/C][C]-529[/C][/ROW]
[ROW][C]215[/C][C]58981[/C][C]82401[/C][C]-23420[/C][/ROW]
[ROW][C]216[/C][C]53515[/C][C]59934.7586206897[/C][C]-6419.75862068965[/C][/ROW]
[ROW][C]217[/C][C]60812[/C][C]82401[/C][C]-21589[/C][/ROW]
[ROW][C]218[/C][C]56375[/C][C]82401[/C][C]-26026[/C][/ROW]
[ROW][C]219[/C][C]65490[/C][C]59934.7586206897[/C][C]5555.24137931035[/C][/ROW]
[ROW][C]220[/C][C]80949[/C][C]45023.6[/C][C]35925.4[/C][/ROW]
[ROW][C]221[/C][C]76302[/C][C]82401[/C][C]-6099[/C][/ROW]
[ROW][C]222[/C][C]104011[/C][C]109181.8[/C][C]-5170.8[/C][/ROW]
[ROW][C]223[/C][C]98104[/C][C]112183.071428571[/C][C]-14079.0714285714[/C][/ROW]
[ROW][C]224[/C][C]67989[/C][C]59934.7586206897[/C][C]8054.24137931035[/C][/ROW]
[ROW][C]225[/C][C]30989[/C][C]45023.6[/C][C]-14034.6[/C][/ROW]
[ROW][C]226[/C][C]135458[/C][C]212530.875[/C][C]-77072.875[/C][/ROW]
[ROW][C]227[/C][C]73504[/C][C]82401[/C][C]-8897[/C][/ROW]
[ROW][C]228[/C][C]63123[/C][C]112183.071428571[/C][C]-49060.0714285714[/C][/ROW]
[ROW][C]229[/C][C]61254[/C][C]82401[/C][C]-21147[/C][/ROW]
[ROW][C]230[/C][C]74914[/C][C]82401[/C][C]-7487[/C][/ROW]
[ROW][C]231[/C][C]31774[/C][C]45023.6[/C][C]-13249.6[/C][/ROW]
[ROW][C]232[/C][C]81437[/C][C]82401[/C][C]-964[/C][/ROW]
[ROW][C]233[/C][C]87186[/C][C]109181.8[/C][C]-21995.8[/C][/ROW]
[ROW][C]234[/C][C]50090[/C][C]59934.7586206897[/C][C]-9844.75862068965[/C][/ROW]
[ROW][C]235[/C][C]65745[/C][C]109181.8[/C][C]-43436.8[/C][/ROW]
[ROW][C]236[/C][C]56653[/C][C]82401[/C][C]-25748[/C][/ROW]
[ROW][C]237[/C][C]158399[/C][C]82401[/C][C]75998[/C][/ROW]
[ROW][C]238[/C][C]46455[/C][C]59934.7586206897[/C][C]-13479.7586206897[/C][/ROW]
[ROW][C]239[/C][C]73624[/C][C]59934.7586206897[/C][C]13689.2413793103[/C][/ROW]
[ROW][C]240[/C][C]38395[/C][C]82401[/C][C]-44006[/C][/ROW]
[ROW][C]241[/C][C]91899[/C][C]82401[/C][C]9498[/C][/ROW]
[ROW][C]242[/C][C]139526[/C][C]212530.875[/C][C]-73004.875[/C][/ROW]
[ROW][C]243[/C][C]52164[/C][C]82401[/C][C]-30237[/C][/ROW]
[ROW][C]244[/C][C]51567[/C][C]82401[/C][C]-30834[/C][/ROW]
[ROW][C]245[/C][C]70551[/C][C]82401[/C][C]-11850[/C][/ROW]
[ROW][C]246[/C][C]84856[/C][C]82401[/C][C]2455[/C][/ROW]
[ROW][C]247[/C][C]102538[/C][C]136000.352941176[/C][C]-33462.3529411765[/C][/ROW]
[ROW][C]248[/C][C]86678[/C][C]82401[/C][C]4277[/C][/ROW]
[ROW][C]249[/C][C]85709[/C][C]82401[/C][C]3308[/C][/ROW]
[ROW][C]250[/C][C]34662[/C][C]59934.7586206897[/C][C]-25272.7586206897[/C][/ROW]
[ROW][C]251[/C][C]150580[/C][C]109181.8[/C][C]41398.2[/C][/ROW]
[ROW][C]252[/C][C]99611[/C][C]136000.352941176[/C][C]-36389.3529411765[/C][/ROW]
[ROW][C]253[/C][C]19349[/C][C]22366.5[/C][C]-3017.5[/C][/ROW]
[ROW][C]254[/C][C]99373[/C][C]109181.8[/C][C]-9808.8[/C][/ROW]
[ROW][C]255[/C][C]86230[/C][C]82401[/C][C]3829[/C][/ROW]
[ROW][C]256[/C][C]30837[/C][C]22366.5[/C][C]8470.5[/C][/ROW]
[ROW][C]257[/C][C]31706[/C][C]59934.7586206897[/C][C]-28228.7586206897[/C][/ROW]
[ROW][C]258[/C][C]89806[/C][C]82401[/C][C]7405[/C][/ROW]
[ROW][C]259[/C][C]62088[/C][C]82401[/C][C]-20313[/C][/ROW]
[ROW][C]260[/C][C]40151[/C][C]82401[/C][C]-42250[/C][/ROW]
[ROW][C]261[/C][C]27634[/C][C]45023.6[/C][C]-17389.6[/C][/ROW]
[ROW][C]262[/C][C]76990[/C][C]59934.7586206897[/C][C]17055.2413793103[/C][/ROW]
[ROW][C]263[/C][C]37460[/C][C]45023.6[/C][C]-7563.6[/C][/ROW]
[ROW][C]264[/C][C]54157[/C][C]59934.7586206897[/C][C]-5777.75862068965[/C][/ROW]
[ROW][C]265[/C][C]49862[/C][C]82401[/C][C]-32539[/C][/ROW]
[ROW][C]266[/C][C]84337[/C][C]59934.7586206897[/C][C]24402.2413793103[/C][/ROW]
[ROW][C]267[/C][C]64175[/C][C]82401[/C][C]-18226[/C][/ROW]
[ROW][C]268[/C][C]59382[/C][C]82401[/C][C]-23019[/C][/ROW]
[ROW][C]269[/C][C]119308[/C][C]82401[/C][C]36907[/C][/ROW]
[ROW][C]270[/C][C]76702[/C][C]136000.352941176[/C][C]-59298.3529411765[/C][/ROW]
[ROW][C]271[/C][C]103425[/C][C]109181.8[/C][C]-5756.8[/C][/ROW]
[ROW][C]272[/C][C]70344[/C][C]59934.7586206897[/C][C]10409.2413793103[/C][/ROW]
[ROW][C]273[/C][C]43410[/C][C]22366.5[/C][C]21043.5[/C][/ROW]
[ROW][C]274[/C][C]104838[/C][C]82401[/C][C]22437[/C][/ROW]
[ROW][C]275[/C][C]62215[/C][C]59934.7586206897[/C][C]2280.24137931035[/C][/ROW]
[ROW][C]276[/C][C]69304[/C][C]82401[/C][C]-13097[/C][/ROW]
[ROW][C]277[/C][C]53117[/C][C]45023.6[/C][C]8093.4[/C][/ROW]
[ROW][C]278[/C][C]19764[/C][C]22366.5[/C][C]-2602.5[/C][/ROW]
[ROW][C]279[/C][C]86680[/C][C]82401[/C][C]4279[/C][/ROW]
[ROW][C]280[/C][C]84105[/C][C]59934.7586206897[/C][C]24170.2413793103[/C][/ROW]
[ROW][C]281[/C][C]77945[/C][C]59934.7586206897[/C][C]18010.2413793103[/C][/ROW]
[ROW][C]282[/C][C]89113[/C][C]82401[/C][C]6712[/C][/ROW]
[ROW][C]283[/C][C]91005[/C][C]82401[/C][C]8604[/C][/ROW]
[ROW][C]284[/C][C]40248[/C][C]22366.5[/C][C]17881.5[/C][/ROW]
[ROW][C]285[/C][C]64187[/C][C]45023.6[/C][C]19163.4[/C][/ROW]
[ROW][C]286[/C][C]50857[/C][C]59934.7586206897[/C][C]-9077.75862068965[/C][/ROW]
[ROW][C]287[/C][C]56613[/C][C]59934.7586206897[/C][C]-3321.75862068965[/C][/ROW]
[ROW][C]288[/C][C]62792[/C][C]112183.071428571[/C][C]-49391.0714285714[/C][/ROW]
[ROW][C]289[/C][C]72535[/C][C]59934.7586206897[/C][C]12600.2413793103[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160410&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160410&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
1210907209753.1612903231153.83870967742
2120982164010.787878788-43028.7878787879
3176508164010.78787878812497.2121212121
4179321272321.375-93000.375
5123185112183.07142857111001.9285714286
65274659934.7586206897-7188.75862068965
7385534272321.375113212.625
83317045023.6-11853.6
9101645109181.8-7536.8
10149061164010.787878788-14949.7878787879
11165446164010.7878787881435.21212121213
12237213272321.375-35108.375
13173326212530.875-39204.875
14133131164010.787878788-30879.7878787879
15258873209753.16129032349119.8387096774
16180083164010.78787878816072.2121212121
17324799272321.37552477.625
18230964209753.16129032321210.8387096774
19236785212530.87524254.125
20135473112183.07142857123289.9285714286
21202925209753.161290323-6828.16129032258
22215147209753.1612903235393.83870967742
23344297272321.37571975.625
24153935164010.787878788-10075.7878787879
25132943209753.161290323-76810.1612903226
26174724272321.375-97597.375
27174415212530.875-38115.875
28225548212530.87513017.125
29223632212530.87511101.125
30124817136000.352941176-11183.3529411765
31221698209753.16129032311944.8387096774
32210767209753.1612903231013.83870967742
33170266209753.161290323-39487.1612903226
34260561272321.375-11760.375
3584853824012452
36294424272321.37522102.625
371010118240118610
38215641164010.78787878851630.2121212121
39325107212530.875112576.125
40717622366.5-15190.5
41167542164010.7878787883531.21212121213
421064088240124007
4396560109181.8-12621.8
44265769272321.375-6552.375
45269651209753.16129032359897.8387096774
46149112164010.787878788-14898.7878787879
47175824212530.875-36706.875
48152871164010.787878788-11139.7878787879
49111665136000.352941176-24335.3529411765
50116408109181.87226.2
51362301212530.875149770.125
527880082401-3601
53183167209753.161290323-26586.1612903226
54277965272321.3755643.625
55150629209753.161290323-59124.1612903226
56168809164010.7878787884798.21212121213
572418822366.51821.5
58329267272321.37556945.625
596502959934.75862068975094.24137931035
60101097109181.8-8084.8
61218946209753.1612903239192.83870967742
62244052209753.16129032334298.8387096774
63341570272321.37569248.625
641035978240121196
65233328272321.375-38993.375
66256462272321.375-15859.375
67206161212530.875-6369.875
68311473272321.37539151.625
69235800272321.375-36521.375
70177939212530.875-34591.875
71207176164010.78787878843165.2121212121
72196553209753.161290323-13200.1612903226
73174184164010.78787878810173.2121212121
74143246212530.875-69284.875
75187559212530.875-24971.875
76187681209753.161290323-22072.1612903226
77119016112183.0714285716832.92857142857
78182192164010.78787878818181.2121212121
797356682401-8835
80194979164010.78787878830968.2121212121
81167488209753.161290323-42265.1612903226
82143756209753.161290323-65997.1612903226
83275541209753.16129032365787.8387096774
84243199272321.375-29122.375
85182999136000.35294117646998.6470588235
86135649164010.787878788-28361.7878787879
87152299164010.787878788-11711.7878787879
88120221136000.352941176-15779.3529411765
89346485272321.37574163.625
90145790109181.836608.2
91193339272321.375-78982.375
928095359934.758620689721018.2413793103
931227748240140373
94130585164010.787878788-33425.7878787879
951126118240130210
96286468212530.87573937.125
97241066136000.352941176105065.647058824
98148446272321.375-123875.375
99204713212530.875-7817.875
100182079209753.161290323-27674.1612903226
101140344164010.787878788-23666.7878787879
102220516164010.78787878856505.2121212121
103243060209753.16129032333306.8387096774
104162765164010.787878788-1245.78787878787
105182613209753.161290323-27140.1612903226
106232138209753.16129032322384.8387096774
107265318272321.375-7003.375
10885574824013173
109310839272321.37538517.625
110225060212530.87512529.125
111232317209753.16129032322563.8387096774
112144966136000.3529411768965.64705882352
1134328759934.7586206897-16647.7586206897
114155754112183.07142857143570.9285714286
115164709272321.375-107612.375
116201940164010.78787878837929.2121212121
117235454212530.87522923.125
118220801212530.8758270.125
11999466136000.352941176-36534.3529411765
12092661109181.8-16520.8
121133328112183.07142857121144.9285714286
12261361109181.8-47820.8
123125930212530.875-86600.875
124100750136000.352941176-35250.3529411765
125224549164010.78787878860538.2121212121
1268231682401-85
127102010109181.8-7171.8
128101523112183.071428571-10660.0714285714
129243511272321.375-28810.375
1302293822366.5571.5
1314156682401-40835
132152474164010.787878788-11536.7878787879
1336185759934.75862068971922.24137931035
13499923109181.8-9258.8
135132487164010.787878788-31523.7878787879
136317394272321.37545072.625
1372105422366.5-1312.5
138209641164010.78787878845630.2121212121
1392264859934.7586206897-37286.7586206897
1403141459934.7586206897-28520.7586206897
1414669882401-35703
142131698112183.07142857119514.9285714286
14391735824019334
144244749212530.87532218.125
145184510164010.78787878820499.2121212121
1467986382401-2538
147128423109181.819241.2
14897839164010.787878788-66171.7878787879
1493821482401-44187
150151101136000.35294117615100.6470588235
151272458209753.16129032362704.8387096774
152172494209753.161290323-37259.1612903226
153108043109181.8-1138.8
154328107209753.161290323118353.838709677
155250579272321.375-21742.375
156351067272321.37578745.625
157158015164010.787878788-5995.78787878787
1589886659934.758620689738931.2413793103
15985439824013038
160229242212530.87516711.125
161351619272321.37579297.625
16284207824011806
163120445136000.352941176-15555.3529411765
164324598272321.37552276.625
165131069164010.787878788-32941.7878787879
166204271209753.161290323-5482.16129032258
167165543209753.161290323-44210.1612903226
168141722212530.875-70808.875
169116048112183.0714285713864.92857142857
170250047136000.352941176114046.647058824
171299775212530.87587244.125
172195838209753.161290323-13915.1612903226
173173260109181.864078.2
174254488272321.375-17833.375
175104389164010.787878788-59621.7878787879
1761360848240153683
177199476209753.161290323-10277.1612903226
178924998240110098
179224330272321.375-47991.375
1801357818240153380
18174408109181.8-34773.8
18281240109181.8-27941.8
1831468822366.5-7678.5
184181633164010.78787878817622.2121212121
185271856272321.375-465.375
186719922366.5-15167.5
1874666045023.61636.4
1881754722366.5-4819.5
189133368136000.352941176-2632.35294117648
190952278240112826
191152601136000.35294117616600.6470588235
192981468240115745
1937961982401-2782
1945919482401-23207
195139942112183.07142857127758.9285714286
196118612112183.0714285716428.92857142857
1977288082401-9521
1986547559934.75862068975540.24137931035
19999643136000.352941176-36357.3529411765
20071965112183.071428571-40218.0714285714
20177272109181.8-31909.8
2024928959934.7586206897-10645.7586206897
203135131109181.825949.2
204108446109181.8-735.800000000003
20589746824017345
2064429645023.6-727.599999999999
2077764882401-4753
208181528109181.872346.2
209134019109181.824837.2
2101240648240141663
211926308240110229
2121218488240139447
2135291559934.7586206897-7019.75862068965
2148187282401-529
2155898182401-23420
2165351559934.7586206897-6419.75862068965
2176081282401-21589
2185637582401-26026
2196549059934.75862068975555.24137931035
2208094945023.635925.4
2217630282401-6099
222104011109181.8-5170.8
22398104112183.071428571-14079.0714285714
2246798959934.75862068978054.24137931035
2253098945023.6-14034.6
226135458212530.875-77072.875
2277350482401-8897
22863123112183.071428571-49060.0714285714
2296125482401-21147
2307491482401-7487
2313177445023.6-13249.6
2328143782401-964
23387186109181.8-21995.8
2345009059934.7586206897-9844.75862068965
23565745109181.8-43436.8
2365665382401-25748
2371583998240175998
2384645559934.7586206897-13479.7586206897
2397362459934.758620689713689.2413793103
2403839582401-44006
24191899824019498
242139526212530.875-73004.875
2435216482401-30237
2445156782401-30834
2457055182401-11850
24684856824012455
247102538136000.352941176-33462.3529411765
24886678824014277
24985709824013308
2503466259934.7586206897-25272.7586206897
251150580109181.841398.2
25299611136000.352941176-36389.3529411765
2531934922366.5-3017.5
25499373109181.8-9808.8
25586230824013829
2563083722366.58470.5
2573170659934.7586206897-28228.7586206897
25889806824017405
2596208882401-20313
2604015182401-42250
2612763445023.6-17389.6
2627699059934.758620689717055.2413793103
2633746045023.6-7563.6
2645415759934.7586206897-5777.75862068965
2654986282401-32539
2668433759934.758620689724402.2413793103
2676417582401-18226
2685938282401-23019
2691193088240136907
27076702136000.352941176-59298.3529411765
271103425109181.8-5756.8
2727034459934.758620689710409.2413793103
2734341022366.521043.5
2741048388240122437
2756221559934.75862068972280.24137931035
2766930482401-13097
2775311745023.68093.4
2781976422366.5-2602.5
27986680824014279
2808410559934.758620689724170.2413793103
2817794559934.758620689718010.2413793103
28289113824016712
28391005824018604
2844024822366.517881.5
2856418745023.619163.4
2865085759934.7586206897-9077.75862068965
2875661359934.7586206897-3321.75862068965
28862792112183.071428571-49391.0714285714
2897253559934.758620689712600.2413793103



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