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 computationTue, 20 Dec 2011 12:57:24 -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/20/t1324403916qg2nsfjal0ala7f.htm/, Retrieved Mon, 06 May 2024 04:15:38 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158105, Retrieved Mon, 06 May 2024 04:15:38 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact80
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [Recursive Partiti...] [2011-12-20 17:57:24] [e5e604418bec6ffe5109fb01f8a59ccb] [Current]
Feedback Forum

Post a new message
Dataseries X:
4	30	79	146283	1418
	28	58	98364	869
1	38	60	86146	1530
	30	108	96933	2172
	22	49	79234	901
	26	0	42551	463
3	25	121	195663	3201
	18	1	6853	371
	11	20	21529	1192
3	26	43	95757	1583
4	25	69	85584	1439
4	38	78	143983	1764
	44	86	75851	1495
3	30	44	59238	1373
	40	104	93163	2187
	34	63	96037	1491
2	47	158	151511	4041
4	30	102	136368	1706
4	31	77	112642	2152
	23	82	94728	1036
	36	115	105499	1882
4	36	101	121527	1929
5	30	80	127766	2242
	25	50	98958	1220
	39	83	77900	1289
4	34	123	85646	2515
4	31	73	98579	2147
5	31	81	130767	2352
4	33	105	131741	1638
4	25	47	53907	1222
	33	105	178812	1812
2	35	94	146761	1677
3	42	44	82036	1579
	43	114	163253	1731
	30	38	27032	807
4	33	107	171975	2452
	13	30	65990	829
	32	71	86572	1940
2	36	84	159676	2662
4	0	0	1929	186
	28	59	85371	1499
2	14	33	58391	865
4	17	42	31580	1793
4	32	96	136815	2527
	30	106	120642	2747
4	35	56	69107	1324
3	20	57	50495	2702
4	28	59	108016	1383
5	28	39	46341	1179
	39	34	78348	2099
4	34	76	79336	4308
	26	20	56968	918
5	39	91	93176	1831
	39	115	161632	3373
	33	85	87850	1713
	28	76	127969	1438
	4	8	15049	496
2	39	79	155135	2253
	18	21	25109	744
	14	30	45824	1161
3	29	76	102996	2352
4	44	101	160604	2144
3	21	94	158051	4691
4	16	27	44547	1112
	28	92	162647	2694
4	35	123	174141	1973
	28	75	60622	1769
	38	128	179566	3148
	23	105	184301	2474
	36	55	75661	2084
	32	56	96144	1954
4	29	41	129847	1226
	25	72	117286	1389
5	27	67	71180	1496
	36	75	109377	2269
4	28	114	85298	1833
	23	118	73631	1268
	40	77	86767	1943
2	23	22	23824	893
	40	66	93487	1762
4	28	69	82981	1403
4	34	105	73815	1425
	33	116	94552	1857
4	28	88	132190	1840
	34	73	128754	1502
	30	99	66363	1441
4	33	62	67808	1420
	22	53	61724	1416
4	38	118	131722	2970
	26	30	68580	1317
4	35	100	106175	1644
	8	49	55792	870
2	24	24	25157	1654
2	29	67	76669	1054
4	20	46	57283	937
3	29	57	105805	3004
	45	75	129484	2008
4	37	135	72413	2547
	33	68	87831	1885
2	33	124	96971	1626
3	25	33	71299	1468
2	32	98	77494	2445
4	29	58	120336	1964
4	28	68	93913	1381
	28	81	136048	1369
4	31	131	181248	1659
3	52	110	146123	2888
4	21	37	32036	1290
	24	130	186646	2845
2	41	93	102255	1982
5	33	118	168237	1904
	32	39	64219	1391
	19	13	19630	602
	20	74	76825	1743
4	31	81	115338	1559
	31	109	109427	2014
	32	151	118168	2143
4	18	51	84845	2146
2	23	28	153197	874
4	17	40	29877	1590
4	20	56	63506	1590
2	12	27	22445	1210
	17	37	47695	2072
4	30	83	68370	1281
	31	54	146304	1401
	10	27	38233	834
3	13	28	42071	1105
5	22	59	50517	1272
4	42	133	103950	1944
2	1	12	5841	391
	9	0	2341	761
4	32	106	84396	1605
	11	23	24610	530
4	25	44	35753	1988
4	36	71	55515	1386
4	31	116	209056	2395
	0	4	6622	387
	24	62	115814	1742
2	13	12	11609	620
	8	18	13155	449
4	13	14	18274	800
4	19	60	72875	1684
	18	7	10112	1050
4	33	98	142775	2699
	40	64	68847	1606
	22	29	17659	1502
3	38	32	20112	1204
2	24	25	61023	1138
	8	16	13983	568
	35	48	65176	1459
4	43	100	132432	2158
3	43	46	112494	1111
4	14	45	45109	1421
5	41	129	170875	2833
	38	130	180759	1955
4	45	136	214921	2922
	31	59	100226	1002
	13	25	32043	1060
	28	32	54454	956
4	31	63	78876	2186
	40	95	170745	3604
	30	14	6940	1035
4	16	36	49025	1417
4	37	113	122037	3261
4	30	47	53782	1587
2	35	92	127748	1424
	32	70	86839	1701
	27	19	44830	1249
2	20	50	77395	946
3	18	41	89324	1926
	31	91	103300	3352
1	31	111	112283	1641
3	21	41	10901	2035
3	39	120	120691	2312
	41	135	58106	1369
	13	27	57140	1577
	32	87	122422	2201
3	18	25	25899	961
4	39	131	139296	1900
2	14	45	52678	1254
4	7	29	23853	1335
3	17	58	17306	1597
	0	4	7953	207
4	30	47	89455	1645
4	37	109	147866	2429
	0	7	4245	151
	5	12	21509	474
	1	0	7670	141
	16	37	66675	1639
2	32	37	14336	872
	24	46	53608	1318
4	17	15	30059	1018
	11	42	29668	1383
4	24	7	22097	1314
4	22	54	96841	1335
4	12	54	41907	1403
4	19	14	27080	910
3	13	16	35885	616
	17	33	41247	1407
	15	32	28313	771
	16	21	36845	766
	24	15	16548	473
2	15	38	36134	1376
5	17	22	55764	1232
	18	28	28910	1521
	20	10	13339	572
	16	31	25319	1059
4	16	32	66956	1544
4	18	32	47487	1230
	22	43	52785	1206
	8	27	44683	1205
2	17	37	35619	1255
	18	20	21920	613
3	16	32	45608	721
3	23	0	7721	1109
4	22	5	20634	740
	13	26	29788	1126
3	13	10	31931	728
	16	27	37754	689
	16	11	32505	592
2	20	29	40557	995
5	22	25	94238	1613
4	17	55	44197	2048
	18	23	43228	705
	17	5	4103	301
	12	43	44144	1803
	7	23	32868	799
4	17	34	27640	861
	14	36	14063	1186
5	23	35	28990	1451
4	17	0	4694	628
4	14	37	42648	1161
	15	28	64329	1463
	17	16	21928	742
4	21	26	25836	979
2	18	38	22779	675
2	18	23	40820	1241
	17	22	27530	676
4	17	30	32378	1049
	16	16	10824	620
	15	18	39613	1081
	21	28	60865	1688
	16	32	19787	736
2	14	21	20107	617
	15	23	36605	812
	17	29	40961	1051
4	15	50	48231	1656
2	15	12	39725	705
	10	21	21455	945
	6	18	23430	554
4	22	27	62991	1597
4	21	41	49363	982
	1	13	9604	222
4	18	12	24552	1212
4	17	21	31493	1143
4	4	8	3439	435
5	10	26	19555	532
	16	27	21228	882
	16	13	23177	608
	9	16	22094	459
	16	2	2342	578
	17	42	38798	826
	7	5	3255	509
4	15	37	24261	717
	14	17	18511	637
	14	38	40798	857
4	18	37	28893	830
2	12	29	21425	652
2	16	32	50276	707
	21	35	37643	954
	19	17	30377	1461
	16	20	27126	672
	1	7	13	778
	16	46	42097	1141
	10	24	24451	680
	19	40	14335	1090
	12	3	5084	616
	2	10	9927	285
	14	37	43527	1145
4	17	17	27184	733
	19	28	21610	888
	14	19	20484	849
	11	29	20156	1182
	4	8	6012	528
2	16	10	18475	642
	20	15	12645	947
	12	15	11017	819
	15	28	37623	757
	16	17	35873	894




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=158105&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=158105&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158105&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.9206
R-squared0.8475
RMSE16070.87

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.9206[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8475[/C][/ROW]
[ROW][C]RMSE[/C][C]16070.87[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158105&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158105&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.9206
R-squared0.8475
RMSE16070.87







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
14787.95-783.95
22833.03125-5.03125
33833.031254.96875
410883.045454545454524.9545454545455
57923443070.2536163.75
64631881.4375-1418.4375
73201787.952413.05
81115.75-4.75
92633.03125-7.03125
102533.03125-8.03125
113833.031254.96875
128683.04545454545452.95454545454545
1344275.428571428571-231.428571428571
1493163122673.666666667-29510.6666666667
151491787.95703.05
1640411881.43752159.5625
1717061881.4375-175.4375
182152787.951364.05
193633.031252.96875
203633.031252.96875
213033.03125-3.03125
2250275.428571428571-225.428571428571
23779005094726953
2485646123930.764705882-38284.7647058823
2598579123930.764705882-25351.7647058823
26130767123930.7647058826836.23529411765
27131741123930.7647058827810.23529411765
285390722745.714285714331161.2857142857
2918121881.4375-69.4375
3016771881.4375-204.4375
311579787.95791.05
323015.7514.25
333333.03125-0.03125
343083.0454545454545-53.0454545454545
3586572123930.764705882-37358.7647058823
36159676123930.76470588235745.2352941177
37192922745.7142857143-20816.7142857143
3814991253.85245.15
398651253.85-388.85
4017931881.4375-88.4375
412527787.951739.05
424787.95-783.95
433787.95-784.95
444787.95-783.95
455787.95-782.95
463933.031255.96875
473433.031250.96875
482027.8421052631579-7.8421052631579
4991275.428571428571-184.428571428571
50161632122673.66666666738958.3333333333
511713787.95925.05
52415.75-11.75
533933.031255.96875
542127.8421052631579-6.84210526315789
554582450947-5123
56102996123930.764705882-20934.7647058823
57160604123930.76470588236673.2352941177
58158051123930.76470588234120.2352941177
594454722745.714285714321801.2857142857
6026941881.4375812.5625
611973787.951185.05
623833.031254.96875
6310583.045454545454521.9545454545455
6475661122673.666666667-47012.6666666667
6519541881.437572.5625
661226787.95438.05
675787.95-782.95
683633.031252.96875
692833.03125-5.03125
7011883.045454545454534.9545454545455
7186767123930.764705882-37163.7647058823
722382422745.71428571431078.28571428571
7317621881.4375-119.4375
7414031881.4375-478.4375
751425787.95637.05
764787.95-783.95
773433.031250.96875
789983.045454545454515.9545454545455
796283.0454545454545-21.0454545454545
80617245094710777
81131722122673.6666666679048.33333333333
8213171881.4375-564.4375
831644787.95856.05
842787.95-785.95
852787.95-785.95
864787.95-783.95
873787.95-784.95
884533.0312511.96875
893733.031253.96875
906883.0454545454545-15.0454545454545
9112483.045454545454540.9545454545455
923383.0454545454545-50.0454545454545
939883.045454545454514.9545454545455
945883.0454545454545-25.0454545454545
956883.0454545454545-15.0454545454545
961360485094785101
97181248123930.76470588257317.2352941177
98146123123930.76470588222192.2352941177
993203622745.71428571439290.28571428571
10028451881.4375963.5625
101198222745.7142857143-20763.7142857143
1021904787.951116.05
1031915.753.25
1047483.0454545454545-9.04545454545455
10581275.428571428571-194.428571428571
106109427122673.666666667-13246.6666666667
10721431881.4375261.5625
10821461881.4375264.5625
1098741253.85-379.85
11015901253.85336.15
11115901253.85336.15
1121210787.95422.05
1134787.95-783.95
1143133.03125-2.03125
1152727.8421052631579-0.842105263157894
1162827.84210526315790.157894736842106
1175927.842105263157931.1578947368421
11813383.045454545454549.9545454545455
119127.8754.125
120234150947-48606
1218439643070.2541325.75
1225301253.85-723.85
12319881253.85734.15
12413861881.4375-495.4375
1252395787.951607.05
1262433.03125-9.03125
1271315.75-2.75
128187.87510.125
129147.8756.125
1306083.0454545454545-23.0454545454545
1311011250947-40835
132142775122673.66666666720101.3333333333
1331606787.95818.05
1343787.95-784.95
1352787.95-785.95
136815.75-7.75
1374883.0454545454545-35.0454545454545
13810083.045454545454516.9545454545455
1394683.0454545454545-37.0454545454545
1404527.842105263157917.1578947368421
141129275.428571428571-146.428571428571
142180759123930.76470588256828.2352941177
143214921122673.66666666792247.3333333333
1441002787.95214.05
1452833.03125-5.03125
1463133.03125-2.03125
1479583.045454545454511.9545454545455
148694050947-44007
1494902550947-1922
150122037123930.764705882-1893.76470588235
15153782509472835
152127748122673.6666666675074.33333333333
1531701787.95913.05
1542787.95-785.95
1553787.95-784.95
1563133.03125-2.03125
1573133.03125-2.03125
1582115.755.25
1593933.031255.96875
16013583.045454545454551.9545454545455
16157140122673.666666667-65533.6666666667
16222011253.85947.15
1639611881.4375-920.4375
16419001253.85646.15
16512541253.850.150000000000091
16613351253.8581.1500000000001
1671597787.95809.05
1684787.95-783.95
1694787.95-783.95
17007.875-7.875
1711227.8421052631579-15.8421052631579
172767012824.2857142857-5154.28571428571
17316391253.85385.15
174872787.9584.05
1754787.95-783.95
1761115.75-4.75
1772415.758.25
1782233.03125-11.03125
1791215.75-3.75
1801915.753.25
1811315.75-2.75
1823327.84210526315795.15789473684211
1832831343070.25-14757.25
184766787.95-21.95
1852787.95-785.95
1865787.95-782.95
1871815.752.25
188107.8752.125
1892531950947-25628
190669565094716009
1914748743070.254416.75
1921206787.95418.05
1932787.95-785.95
1941815.752.25
1951615.750.25
1962315.757.25
1972215.756.25
1982627.8421052631579-1.84210526315789
1991027.8421052631579-17.8421052631579
2003775443070.25-5316.25
2015921253.85-661.85
20299522745.7142857143-21750.7142857143
20316131253.85359.15
2042048787.951260.05
2051715.751.25
2064327.842105263157915.1578947368421
2073286850947-18079
2082764043070.25-15430.25
209118612824.2857142857-11638.2857142857
2101451275.4285714285711175.57142857143
2116281253.85-625.85
2121161787.95373.05
2131715.751.25
2142115.755.25
2151815.752.25
2161815.752.25
2172227.8421052631579-5.84210526315789
2183027.84210526315792.15789473684211
2191082412824.2857142857-2000.28571428571
2201081787.95293.05
2211615.750.25
2221415.75-1.75
2232327.8421052631579-4.84210526315789
2244096150947-9986
22548231123930.764705882-75699.7647058823
2263972543070.25-3345.25
227945787.95157.05
2284787.95-783.95
2294787.95-783.95
230115.75-14.75
2311815.752.25
2321715.751.25
233415.75-11.75
2341015.75-5.75
2352727.8421052631579-0.842105263157894
2362317712824.285714285710352.7142857143
237459787.95-328.95
2381715.751.25
23957.875-2.875
2403727.84210526315799.1578947368421
2411851112824.28571428575686.71428571429
2428571253.85-396.85
2438301253.85-423.85
2446521253.85-601.85
245707787.95-80.95
2461915.753.25
2472027.8421052631579-7.8421052631579
2481343070.25-43057.25
2491141787.95353.05
2501915.753.25
25137.875-4.875
252992712824.2857142857-2897.28571428571
25311451253.85-108.85
254733787.95-54.95
2551415.75-1.75
2562927.84210526315791.15789473684211
257601250947-44935
2581847512824.28571428575650.71428571429
259947787.95159.05
2601515.75-0.75
2611727.8421052631579-10.8421052631579
2627983.0454545454545-4.04545454545455
263983645094747417
26486146122673.666666667-36527.6666666667
2652172787.951384.05
2662615.7510.25
2672533.03125-8.03125
26817.875-6.875
2692152950947-29418
270957575094744810
271855845094734637
272143983122673.66666666721309.3333333333
27314951253.85241.15
2741373787.95585.05
2753433.031250.96875
2764733.0312513.96875
2773033.03125-3.03125
2783133.03125-2.03125
27982275.428571428571-193.428571428571
280105499123930.764705882-18431.7647058823
281121527123930.764705882-2403.76470588235
282127766122673.6666666675092.33333333333
2831220787.95432.05
284415.75-11.75
2854787.95-783.95
2865787.95-782.95
2874787.95-783.95
2884787.95-783.95
2893333.03125-0.03125

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 4 & 787.95 & -783.95 \tabularnewline
2 & 28 & 33.03125 & -5.03125 \tabularnewline
3 & 38 & 33.03125 & 4.96875 \tabularnewline
4 & 108 & 83.0454545454545 & 24.9545454545455 \tabularnewline
5 & 79234 & 43070.25 & 36163.75 \tabularnewline
6 & 463 & 1881.4375 & -1418.4375 \tabularnewline
7 & 3201 & 787.95 & 2413.05 \tabularnewline
8 & 11 & 15.75 & -4.75 \tabularnewline
9 & 26 & 33.03125 & -7.03125 \tabularnewline
10 & 25 & 33.03125 & -8.03125 \tabularnewline
11 & 38 & 33.03125 & 4.96875 \tabularnewline
12 & 86 & 83.0454545454545 & 2.95454545454545 \tabularnewline
13 & 44 & 275.428571428571 & -231.428571428571 \tabularnewline
14 & 93163 & 122673.666666667 & -29510.6666666667 \tabularnewline
15 & 1491 & 787.95 & 703.05 \tabularnewline
16 & 4041 & 1881.4375 & 2159.5625 \tabularnewline
17 & 1706 & 1881.4375 & -175.4375 \tabularnewline
18 & 2152 & 787.95 & 1364.05 \tabularnewline
19 & 36 & 33.03125 & 2.96875 \tabularnewline
20 & 36 & 33.03125 & 2.96875 \tabularnewline
21 & 30 & 33.03125 & -3.03125 \tabularnewline
22 & 50 & 275.428571428571 & -225.428571428571 \tabularnewline
23 & 77900 & 50947 & 26953 \tabularnewline
24 & 85646 & 123930.764705882 & -38284.7647058823 \tabularnewline
25 & 98579 & 123930.764705882 & -25351.7647058823 \tabularnewline
26 & 130767 & 123930.764705882 & 6836.23529411765 \tabularnewline
27 & 131741 & 123930.764705882 & 7810.23529411765 \tabularnewline
28 & 53907 & 22745.7142857143 & 31161.2857142857 \tabularnewline
29 & 1812 & 1881.4375 & -69.4375 \tabularnewline
30 & 1677 & 1881.4375 & -204.4375 \tabularnewline
31 & 1579 & 787.95 & 791.05 \tabularnewline
32 & 30 & 15.75 & 14.25 \tabularnewline
33 & 33 & 33.03125 & -0.03125 \tabularnewline
34 & 30 & 83.0454545454545 & -53.0454545454545 \tabularnewline
35 & 86572 & 123930.764705882 & -37358.7647058823 \tabularnewline
36 & 159676 & 123930.764705882 & 35745.2352941177 \tabularnewline
37 & 1929 & 22745.7142857143 & -20816.7142857143 \tabularnewline
38 & 1499 & 1253.85 & 245.15 \tabularnewline
39 & 865 & 1253.85 & -388.85 \tabularnewline
40 & 1793 & 1881.4375 & -88.4375 \tabularnewline
41 & 2527 & 787.95 & 1739.05 \tabularnewline
42 & 4 & 787.95 & -783.95 \tabularnewline
43 & 3 & 787.95 & -784.95 \tabularnewline
44 & 4 & 787.95 & -783.95 \tabularnewline
45 & 5 & 787.95 & -782.95 \tabularnewline
46 & 39 & 33.03125 & 5.96875 \tabularnewline
47 & 34 & 33.03125 & 0.96875 \tabularnewline
48 & 20 & 27.8421052631579 & -7.8421052631579 \tabularnewline
49 & 91 & 275.428571428571 & -184.428571428571 \tabularnewline
50 & 161632 & 122673.666666667 & 38958.3333333333 \tabularnewline
51 & 1713 & 787.95 & 925.05 \tabularnewline
52 & 4 & 15.75 & -11.75 \tabularnewline
53 & 39 & 33.03125 & 5.96875 \tabularnewline
54 & 21 & 27.8421052631579 & -6.84210526315789 \tabularnewline
55 & 45824 & 50947 & -5123 \tabularnewline
56 & 102996 & 123930.764705882 & -20934.7647058823 \tabularnewline
57 & 160604 & 123930.764705882 & 36673.2352941177 \tabularnewline
58 & 158051 & 123930.764705882 & 34120.2352941177 \tabularnewline
59 & 44547 & 22745.7142857143 & 21801.2857142857 \tabularnewline
60 & 2694 & 1881.4375 & 812.5625 \tabularnewline
61 & 1973 & 787.95 & 1185.05 \tabularnewline
62 & 38 & 33.03125 & 4.96875 \tabularnewline
63 & 105 & 83.0454545454545 & 21.9545454545455 \tabularnewline
64 & 75661 & 122673.666666667 & -47012.6666666667 \tabularnewline
65 & 1954 & 1881.4375 & 72.5625 \tabularnewline
66 & 1226 & 787.95 & 438.05 \tabularnewline
67 & 5 & 787.95 & -782.95 \tabularnewline
68 & 36 & 33.03125 & 2.96875 \tabularnewline
69 & 28 & 33.03125 & -5.03125 \tabularnewline
70 & 118 & 83.0454545454545 & 34.9545454545455 \tabularnewline
71 & 86767 & 123930.764705882 & -37163.7647058823 \tabularnewline
72 & 23824 & 22745.7142857143 & 1078.28571428571 \tabularnewline
73 & 1762 & 1881.4375 & -119.4375 \tabularnewline
74 & 1403 & 1881.4375 & -478.4375 \tabularnewline
75 & 1425 & 787.95 & 637.05 \tabularnewline
76 & 4 & 787.95 & -783.95 \tabularnewline
77 & 34 & 33.03125 & 0.96875 \tabularnewline
78 & 99 & 83.0454545454545 & 15.9545454545455 \tabularnewline
79 & 62 & 83.0454545454545 & -21.0454545454545 \tabularnewline
80 & 61724 & 50947 & 10777 \tabularnewline
81 & 131722 & 122673.666666667 & 9048.33333333333 \tabularnewline
82 & 1317 & 1881.4375 & -564.4375 \tabularnewline
83 & 1644 & 787.95 & 856.05 \tabularnewline
84 & 2 & 787.95 & -785.95 \tabularnewline
85 & 2 & 787.95 & -785.95 \tabularnewline
86 & 4 & 787.95 & -783.95 \tabularnewline
87 & 3 & 787.95 & -784.95 \tabularnewline
88 & 45 & 33.03125 & 11.96875 \tabularnewline
89 & 37 & 33.03125 & 3.96875 \tabularnewline
90 & 68 & 83.0454545454545 & -15.0454545454545 \tabularnewline
91 & 124 & 83.0454545454545 & 40.9545454545455 \tabularnewline
92 & 33 & 83.0454545454545 & -50.0454545454545 \tabularnewline
93 & 98 & 83.0454545454545 & 14.9545454545455 \tabularnewline
94 & 58 & 83.0454545454545 & -25.0454545454545 \tabularnewline
95 & 68 & 83.0454545454545 & -15.0454545454545 \tabularnewline
96 & 136048 & 50947 & 85101 \tabularnewline
97 & 181248 & 123930.764705882 & 57317.2352941177 \tabularnewline
98 & 146123 & 123930.764705882 & 22192.2352941177 \tabularnewline
99 & 32036 & 22745.7142857143 & 9290.28571428571 \tabularnewline
100 & 2845 & 1881.4375 & 963.5625 \tabularnewline
101 & 1982 & 22745.7142857143 & -20763.7142857143 \tabularnewline
102 & 1904 & 787.95 & 1116.05 \tabularnewline
103 & 19 & 15.75 & 3.25 \tabularnewline
104 & 74 & 83.0454545454545 & -9.04545454545455 \tabularnewline
105 & 81 & 275.428571428571 & -194.428571428571 \tabularnewline
106 & 109427 & 122673.666666667 & -13246.6666666667 \tabularnewline
107 & 2143 & 1881.4375 & 261.5625 \tabularnewline
108 & 2146 & 1881.4375 & 264.5625 \tabularnewline
109 & 874 & 1253.85 & -379.85 \tabularnewline
110 & 1590 & 1253.85 & 336.15 \tabularnewline
111 & 1590 & 1253.85 & 336.15 \tabularnewline
112 & 1210 & 787.95 & 422.05 \tabularnewline
113 & 4 & 787.95 & -783.95 \tabularnewline
114 & 31 & 33.03125 & -2.03125 \tabularnewline
115 & 27 & 27.8421052631579 & -0.842105263157894 \tabularnewline
116 & 28 & 27.8421052631579 & 0.157894736842106 \tabularnewline
117 & 59 & 27.8421052631579 & 31.1578947368421 \tabularnewline
118 & 133 & 83.0454545454545 & 49.9545454545455 \tabularnewline
119 & 12 & 7.875 & 4.125 \tabularnewline
120 & 2341 & 50947 & -48606 \tabularnewline
121 & 84396 & 43070.25 & 41325.75 \tabularnewline
122 & 530 & 1253.85 & -723.85 \tabularnewline
123 & 1988 & 1253.85 & 734.15 \tabularnewline
124 & 1386 & 1881.4375 & -495.4375 \tabularnewline
125 & 2395 & 787.95 & 1607.05 \tabularnewline
126 & 24 & 33.03125 & -9.03125 \tabularnewline
127 & 13 & 15.75 & -2.75 \tabularnewline
128 & 18 & 7.875 & 10.125 \tabularnewline
129 & 14 & 7.875 & 6.125 \tabularnewline
130 & 60 & 83.0454545454545 & -23.0454545454545 \tabularnewline
131 & 10112 & 50947 & -40835 \tabularnewline
132 & 142775 & 122673.666666667 & 20101.3333333333 \tabularnewline
133 & 1606 & 787.95 & 818.05 \tabularnewline
134 & 3 & 787.95 & -784.95 \tabularnewline
135 & 2 & 787.95 & -785.95 \tabularnewline
136 & 8 & 15.75 & -7.75 \tabularnewline
137 & 48 & 83.0454545454545 & -35.0454545454545 \tabularnewline
138 & 100 & 83.0454545454545 & 16.9545454545455 \tabularnewline
139 & 46 & 83.0454545454545 & -37.0454545454545 \tabularnewline
140 & 45 & 27.8421052631579 & 17.1578947368421 \tabularnewline
141 & 129 & 275.428571428571 & -146.428571428571 \tabularnewline
142 & 180759 & 123930.764705882 & 56828.2352941177 \tabularnewline
143 & 214921 & 122673.666666667 & 92247.3333333333 \tabularnewline
144 & 1002 & 787.95 & 214.05 \tabularnewline
145 & 28 & 33.03125 & -5.03125 \tabularnewline
146 & 31 & 33.03125 & -2.03125 \tabularnewline
147 & 95 & 83.0454545454545 & 11.9545454545455 \tabularnewline
148 & 6940 & 50947 & -44007 \tabularnewline
149 & 49025 & 50947 & -1922 \tabularnewline
150 & 122037 & 123930.764705882 & -1893.76470588235 \tabularnewline
151 & 53782 & 50947 & 2835 \tabularnewline
152 & 127748 & 122673.666666667 & 5074.33333333333 \tabularnewline
153 & 1701 & 787.95 & 913.05 \tabularnewline
154 & 2 & 787.95 & -785.95 \tabularnewline
155 & 3 & 787.95 & -784.95 \tabularnewline
156 & 31 & 33.03125 & -2.03125 \tabularnewline
157 & 31 & 33.03125 & -2.03125 \tabularnewline
158 & 21 & 15.75 & 5.25 \tabularnewline
159 & 39 & 33.03125 & 5.96875 \tabularnewline
160 & 135 & 83.0454545454545 & 51.9545454545455 \tabularnewline
161 & 57140 & 122673.666666667 & -65533.6666666667 \tabularnewline
162 & 2201 & 1253.85 & 947.15 \tabularnewline
163 & 961 & 1881.4375 & -920.4375 \tabularnewline
164 & 1900 & 1253.85 & 646.15 \tabularnewline
165 & 1254 & 1253.85 & 0.150000000000091 \tabularnewline
166 & 1335 & 1253.85 & 81.1500000000001 \tabularnewline
167 & 1597 & 787.95 & 809.05 \tabularnewline
168 & 4 & 787.95 & -783.95 \tabularnewline
169 & 4 & 787.95 & -783.95 \tabularnewline
170 & 0 & 7.875 & -7.875 \tabularnewline
171 & 12 & 27.8421052631579 & -15.8421052631579 \tabularnewline
172 & 7670 & 12824.2857142857 & -5154.28571428571 \tabularnewline
173 & 1639 & 1253.85 & 385.15 \tabularnewline
174 & 872 & 787.95 & 84.05 \tabularnewline
175 & 4 & 787.95 & -783.95 \tabularnewline
176 & 11 & 15.75 & -4.75 \tabularnewline
177 & 24 & 15.75 & 8.25 \tabularnewline
178 & 22 & 33.03125 & -11.03125 \tabularnewline
179 & 12 & 15.75 & -3.75 \tabularnewline
180 & 19 & 15.75 & 3.25 \tabularnewline
181 & 13 & 15.75 & -2.75 \tabularnewline
182 & 33 & 27.8421052631579 & 5.15789473684211 \tabularnewline
183 & 28313 & 43070.25 & -14757.25 \tabularnewline
184 & 766 & 787.95 & -21.95 \tabularnewline
185 & 2 & 787.95 & -785.95 \tabularnewline
186 & 5 & 787.95 & -782.95 \tabularnewline
187 & 18 & 15.75 & 2.25 \tabularnewline
188 & 10 & 7.875 & 2.125 \tabularnewline
189 & 25319 & 50947 & -25628 \tabularnewline
190 & 66956 & 50947 & 16009 \tabularnewline
191 & 47487 & 43070.25 & 4416.75 \tabularnewline
192 & 1206 & 787.95 & 418.05 \tabularnewline
193 & 2 & 787.95 & -785.95 \tabularnewline
194 & 18 & 15.75 & 2.25 \tabularnewline
195 & 16 & 15.75 & 0.25 \tabularnewline
196 & 23 & 15.75 & 7.25 \tabularnewline
197 & 22 & 15.75 & 6.25 \tabularnewline
198 & 26 & 27.8421052631579 & -1.84210526315789 \tabularnewline
199 & 10 & 27.8421052631579 & -17.8421052631579 \tabularnewline
200 & 37754 & 43070.25 & -5316.25 \tabularnewline
201 & 592 & 1253.85 & -661.85 \tabularnewline
202 & 995 & 22745.7142857143 & -21750.7142857143 \tabularnewline
203 & 1613 & 1253.85 & 359.15 \tabularnewline
204 & 2048 & 787.95 & 1260.05 \tabularnewline
205 & 17 & 15.75 & 1.25 \tabularnewline
206 & 43 & 27.8421052631579 & 15.1578947368421 \tabularnewline
207 & 32868 & 50947 & -18079 \tabularnewline
208 & 27640 & 43070.25 & -15430.25 \tabularnewline
209 & 1186 & 12824.2857142857 & -11638.2857142857 \tabularnewline
210 & 1451 & 275.428571428571 & 1175.57142857143 \tabularnewline
211 & 628 & 1253.85 & -625.85 \tabularnewline
212 & 1161 & 787.95 & 373.05 \tabularnewline
213 & 17 & 15.75 & 1.25 \tabularnewline
214 & 21 & 15.75 & 5.25 \tabularnewline
215 & 18 & 15.75 & 2.25 \tabularnewline
216 & 18 & 15.75 & 2.25 \tabularnewline
217 & 22 & 27.8421052631579 & -5.84210526315789 \tabularnewline
218 & 30 & 27.8421052631579 & 2.15789473684211 \tabularnewline
219 & 10824 & 12824.2857142857 & -2000.28571428571 \tabularnewline
220 & 1081 & 787.95 & 293.05 \tabularnewline
221 & 16 & 15.75 & 0.25 \tabularnewline
222 & 14 & 15.75 & -1.75 \tabularnewline
223 & 23 & 27.8421052631579 & -4.84210526315789 \tabularnewline
224 & 40961 & 50947 & -9986 \tabularnewline
225 & 48231 & 123930.764705882 & -75699.7647058823 \tabularnewline
226 & 39725 & 43070.25 & -3345.25 \tabularnewline
227 & 945 & 787.95 & 157.05 \tabularnewline
228 & 4 & 787.95 & -783.95 \tabularnewline
229 & 4 & 787.95 & -783.95 \tabularnewline
230 & 1 & 15.75 & -14.75 \tabularnewline
231 & 18 & 15.75 & 2.25 \tabularnewline
232 & 17 & 15.75 & 1.25 \tabularnewline
233 & 4 & 15.75 & -11.75 \tabularnewline
234 & 10 & 15.75 & -5.75 \tabularnewline
235 & 27 & 27.8421052631579 & -0.842105263157894 \tabularnewline
236 & 23177 & 12824.2857142857 & 10352.7142857143 \tabularnewline
237 & 459 & 787.95 & -328.95 \tabularnewline
238 & 17 & 15.75 & 1.25 \tabularnewline
239 & 5 & 7.875 & -2.875 \tabularnewline
240 & 37 & 27.8421052631579 & 9.1578947368421 \tabularnewline
241 & 18511 & 12824.2857142857 & 5686.71428571429 \tabularnewline
242 & 857 & 1253.85 & -396.85 \tabularnewline
243 & 830 & 1253.85 & -423.85 \tabularnewline
244 & 652 & 1253.85 & -601.85 \tabularnewline
245 & 707 & 787.95 & -80.95 \tabularnewline
246 & 19 & 15.75 & 3.25 \tabularnewline
247 & 20 & 27.8421052631579 & -7.8421052631579 \tabularnewline
248 & 13 & 43070.25 & -43057.25 \tabularnewline
249 & 1141 & 787.95 & 353.05 \tabularnewline
250 & 19 & 15.75 & 3.25 \tabularnewline
251 & 3 & 7.875 & -4.875 \tabularnewline
252 & 9927 & 12824.2857142857 & -2897.28571428571 \tabularnewline
253 & 1145 & 1253.85 & -108.85 \tabularnewline
254 & 733 & 787.95 & -54.95 \tabularnewline
255 & 14 & 15.75 & -1.75 \tabularnewline
256 & 29 & 27.8421052631579 & 1.15789473684211 \tabularnewline
257 & 6012 & 50947 & -44935 \tabularnewline
258 & 18475 & 12824.2857142857 & 5650.71428571429 \tabularnewline
259 & 947 & 787.95 & 159.05 \tabularnewline
260 & 15 & 15.75 & -0.75 \tabularnewline
261 & 17 & 27.8421052631579 & -10.8421052631579 \tabularnewline
262 & 79 & 83.0454545454545 & -4.04545454545455 \tabularnewline
263 & 98364 & 50947 & 47417 \tabularnewline
264 & 86146 & 122673.666666667 & -36527.6666666667 \tabularnewline
265 & 2172 & 787.95 & 1384.05 \tabularnewline
266 & 26 & 15.75 & 10.25 \tabularnewline
267 & 25 & 33.03125 & -8.03125 \tabularnewline
268 & 1 & 7.875 & -6.875 \tabularnewline
269 & 21529 & 50947 & -29418 \tabularnewline
270 & 95757 & 50947 & 44810 \tabularnewline
271 & 85584 & 50947 & 34637 \tabularnewline
272 & 143983 & 122673.666666667 & 21309.3333333333 \tabularnewline
273 & 1495 & 1253.85 & 241.15 \tabularnewline
274 & 1373 & 787.95 & 585.05 \tabularnewline
275 & 34 & 33.03125 & 0.96875 \tabularnewline
276 & 47 & 33.03125 & 13.96875 \tabularnewline
277 & 30 & 33.03125 & -3.03125 \tabularnewline
278 & 31 & 33.03125 & -2.03125 \tabularnewline
279 & 82 & 275.428571428571 & -193.428571428571 \tabularnewline
280 & 105499 & 123930.764705882 & -18431.7647058823 \tabularnewline
281 & 121527 & 123930.764705882 & -2403.76470588235 \tabularnewline
282 & 127766 & 122673.666666667 & 5092.33333333333 \tabularnewline
283 & 1220 & 787.95 & 432.05 \tabularnewline
284 & 4 & 15.75 & -11.75 \tabularnewline
285 & 4 & 787.95 & -783.95 \tabularnewline
286 & 5 & 787.95 & -782.95 \tabularnewline
287 & 4 & 787.95 & -783.95 \tabularnewline
288 & 4 & 787.95 & -783.95 \tabularnewline
289 & 33 & 33.03125 & -0.03125 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158105&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]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]2[/C][C]28[/C][C]33.03125[/C][C]-5.03125[/C][/ROW]
[ROW][C]3[/C][C]38[/C][C]33.03125[/C][C]4.96875[/C][/ROW]
[ROW][C]4[/C][C]108[/C][C]83.0454545454545[/C][C]24.9545454545455[/C][/ROW]
[ROW][C]5[/C][C]79234[/C][C]43070.25[/C][C]36163.75[/C][/ROW]
[ROW][C]6[/C][C]463[/C][C]1881.4375[/C][C]-1418.4375[/C][/ROW]
[ROW][C]7[/C][C]3201[/C][C]787.95[/C][C]2413.05[/C][/ROW]
[ROW][C]8[/C][C]11[/C][C]15.75[/C][C]-4.75[/C][/ROW]
[ROW][C]9[/C][C]26[/C][C]33.03125[/C][C]-7.03125[/C][/ROW]
[ROW][C]10[/C][C]25[/C][C]33.03125[/C][C]-8.03125[/C][/ROW]
[ROW][C]11[/C][C]38[/C][C]33.03125[/C][C]4.96875[/C][/ROW]
[ROW][C]12[/C][C]86[/C][C]83.0454545454545[/C][C]2.95454545454545[/C][/ROW]
[ROW][C]13[/C][C]44[/C][C]275.428571428571[/C][C]-231.428571428571[/C][/ROW]
[ROW][C]14[/C][C]93163[/C][C]122673.666666667[/C][C]-29510.6666666667[/C][/ROW]
[ROW][C]15[/C][C]1491[/C][C]787.95[/C][C]703.05[/C][/ROW]
[ROW][C]16[/C][C]4041[/C][C]1881.4375[/C][C]2159.5625[/C][/ROW]
[ROW][C]17[/C][C]1706[/C][C]1881.4375[/C][C]-175.4375[/C][/ROW]
[ROW][C]18[/C][C]2152[/C][C]787.95[/C][C]1364.05[/C][/ROW]
[ROW][C]19[/C][C]36[/C][C]33.03125[/C][C]2.96875[/C][/ROW]
[ROW][C]20[/C][C]36[/C][C]33.03125[/C][C]2.96875[/C][/ROW]
[ROW][C]21[/C][C]30[/C][C]33.03125[/C][C]-3.03125[/C][/ROW]
[ROW][C]22[/C][C]50[/C][C]275.428571428571[/C][C]-225.428571428571[/C][/ROW]
[ROW][C]23[/C][C]77900[/C][C]50947[/C][C]26953[/C][/ROW]
[ROW][C]24[/C][C]85646[/C][C]123930.764705882[/C][C]-38284.7647058823[/C][/ROW]
[ROW][C]25[/C][C]98579[/C][C]123930.764705882[/C][C]-25351.7647058823[/C][/ROW]
[ROW][C]26[/C][C]130767[/C][C]123930.764705882[/C][C]6836.23529411765[/C][/ROW]
[ROW][C]27[/C][C]131741[/C][C]123930.764705882[/C][C]7810.23529411765[/C][/ROW]
[ROW][C]28[/C][C]53907[/C][C]22745.7142857143[/C][C]31161.2857142857[/C][/ROW]
[ROW][C]29[/C][C]1812[/C][C]1881.4375[/C][C]-69.4375[/C][/ROW]
[ROW][C]30[/C][C]1677[/C][C]1881.4375[/C][C]-204.4375[/C][/ROW]
[ROW][C]31[/C][C]1579[/C][C]787.95[/C][C]791.05[/C][/ROW]
[ROW][C]32[/C][C]30[/C][C]15.75[/C][C]14.25[/C][/ROW]
[ROW][C]33[/C][C]33[/C][C]33.03125[/C][C]-0.03125[/C][/ROW]
[ROW][C]34[/C][C]30[/C][C]83.0454545454545[/C][C]-53.0454545454545[/C][/ROW]
[ROW][C]35[/C][C]86572[/C][C]123930.764705882[/C][C]-37358.7647058823[/C][/ROW]
[ROW][C]36[/C][C]159676[/C][C]123930.764705882[/C][C]35745.2352941177[/C][/ROW]
[ROW][C]37[/C][C]1929[/C][C]22745.7142857143[/C][C]-20816.7142857143[/C][/ROW]
[ROW][C]38[/C][C]1499[/C][C]1253.85[/C][C]245.15[/C][/ROW]
[ROW][C]39[/C][C]865[/C][C]1253.85[/C][C]-388.85[/C][/ROW]
[ROW][C]40[/C][C]1793[/C][C]1881.4375[/C][C]-88.4375[/C][/ROW]
[ROW][C]41[/C][C]2527[/C][C]787.95[/C][C]1739.05[/C][/ROW]
[ROW][C]42[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]43[/C][C]3[/C][C]787.95[/C][C]-784.95[/C][/ROW]
[ROW][C]44[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]45[/C][C]5[/C][C]787.95[/C][C]-782.95[/C][/ROW]
[ROW][C]46[/C][C]39[/C][C]33.03125[/C][C]5.96875[/C][/ROW]
[ROW][C]47[/C][C]34[/C][C]33.03125[/C][C]0.96875[/C][/ROW]
[ROW][C]48[/C][C]20[/C][C]27.8421052631579[/C][C]-7.8421052631579[/C][/ROW]
[ROW][C]49[/C][C]91[/C][C]275.428571428571[/C][C]-184.428571428571[/C][/ROW]
[ROW][C]50[/C][C]161632[/C][C]122673.666666667[/C][C]38958.3333333333[/C][/ROW]
[ROW][C]51[/C][C]1713[/C][C]787.95[/C][C]925.05[/C][/ROW]
[ROW][C]52[/C][C]4[/C][C]15.75[/C][C]-11.75[/C][/ROW]
[ROW][C]53[/C][C]39[/C][C]33.03125[/C][C]5.96875[/C][/ROW]
[ROW][C]54[/C][C]21[/C][C]27.8421052631579[/C][C]-6.84210526315789[/C][/ROW]
[ROW][C]55[/C][C]45824[/C][C]50947[/C][C]-5123[/C][/ROW]
[ROW][C]56[/C][C]102996[/C][C]123930.764705882[/C][C]-20934.7647058823[/C][/ROW]
[ROW][C]57[/C][C]160604[/C][C]123930.764705882[/C][C]36673.2352941177[/C][/ROW]
[ROW][C]58[/C][C]158051[/C][C]123930.764705882[/C][C]34120.2352941177[/C][/ROW]
[ROW][C]59[/C][C]44547[/C][C]22745.7142857143[/C][C]21801.2857142857[/C][/ROW]
[ROW][C]60[/C][C]2694[/C][C]1881.4375[/C][C]812.5625[/C][/ROW]
[ROW][C]61[/C][C]1973[/C][C]787.95[/C][C]1185.05[/C][/ROW]
[ROW][C]62[/C][C]38[/C][C]33.03125[/C][C]4.96875[/C][/ROW]
[ROW][C]63[/C][C]105[/C][C]83.0454545454545[/C][C]21.9545454545455[/C][/ROW]
[ROW][C]64[/C][C]75661[/C][C]122673.666666667[/C][C]-47012.6666666667[/C][/ROW]
[ROW][C]65[/C][C]1954[/C][C]1881.4375[/C][C]72.5625[/C][/ROW]
[ROW][C]66[/C][C]1226[/C][C]787.95[/C][C]438.05[/C][/ROW]
[ROW][C]67[/C][C]5[/C][C]787.95[/C][C]-782.95[/C][/ROW]
[ROW][C]68[/C][C]36[/C][C]33.03125[/C][C]2.96875[/C][/ROW]
[ROW][C]69[/C][C]28[/C][C]33.03125[/C][C]-5.03125[/C][/ROW]
[ROW][C]70[/C][C]118[/C][C]83.0454545454545[/C][C]34.9545454545455[/C][/ROW]
[ROW][C]71[/C][C]86767[/C][C]123930.764705882[/C][C]-37163.7647058823[/C][/ROW]
[ROW][C]72[/C][C]23824[/C][C]22745.7142857143[/C][C]1078.28571428571[/C][/ROW]
[ROW][C]73[/C][C]1762[/C][C]1881.4375[/C][C]-119.4375[/C][/ROW]
[ROW][C]74[/C][C]1403[/C][C]1881.4375[/C][C]-478.4375[/C][/ROW]
[ROW][C]75[/C][C]1425[/C][C]787.95[/C][C]637.05[/C][/ROW]
[ROW][C]76[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]77[/C][C]34[/C][C]33.03125[/C][C]0.96875[/C][/ROW]
[ROW][C]78[/C][C]99[/C][C]83.0454545454545[/C][C]15.9545454545455[/C][/ROW]
[ROW][C]79[/C][C]62[/C][C]83.0454545454545[/C][C]-21.0454545454545[/C][/ROW]
[ROW][C]80[/C][C]61724[/C][C]50947[/C][C]10777[/C][/ROW]
[ROW][C]81[/C][C]131722[/C][C]122673.666666667[/C][C]9048.33333333333[/C][/ROW]
[ROW][C]82[/C][C]1317[/C][C]1881.4375[/C][C]-564.4375[/C][/ROW]
[ROW][C]83[/C][C]1644[/C][C]787.95[/C][C]856.05[/C][/ROW]
[ROW][C]84[/C][C]2[/C][C]787.95[/C][C]-785.95[/C][/ROW]
[ROW][C]85[/C][C]2[/C][C]787.95[/C][C]-785.95[/C][/ROW]
[ROW][C]86[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]87[/C][C]3[/C][C]787.95[/C][C]-784.95[/C][/ROW]
[ROW][C]88[/C][C]45[/C][C]33.03125[/C][C]11.96875[/C][/ROW]
[ROW][C]89[/C][C]37[/C][C]33.03125[/C][C]3.96875[/C][/ROW]
[ROW][C]90[/C][C]68[/C][C]83.0454545454545[/C][C]-15.0454545454545[/C][/ROW]
[ROW][C]91[/C][C]124[/C][C]83.0454545454545[/C][C]40.9545454545455[/C][/ROW]
[ROW][C]92[/C][C]33[/C][C]83.0454545454545[/C][C]-50.0454545454545[/C][/ROW]
[ROW][C]93[/C][C]98[/C][C]83.0454545454545[/C][C]14.9545454545455[/C][/ROW]
[ROW][C]94[/C][C]58[/C][C]83.0454545454545[/C][C]-25.0454545454545[/C][/ROW]
[ROW][C]95[/C][C]68[/C][C]83.0454545454545[/C][C]-15.0454545454545[/C][/ROW]
[ROW][C]96[/C][C]136048[/C][C]50947[/C][C]85101[/C][/ROW]
[ROW][C]97[/C][C]181248[/C][C]123930.764705882[/C][C]57317.2352941177[/C][/ROW]
[ROW][C]98[/C][C]146123[/C][C]123930.764705882[/C][C]22192.2352941177[/C][/ROW]
[ROW][C]99[/C][C]32036[/C][C]22745.7142857143[/C][C]9290.28571428571[/C][/ROW]
[ROW][C]100[/C][C]2845[/C][C]1881.4375[/C][C]963.5625[/C][/ROW]
[ROW][C]101[/C][C]1982[/C][C]22745.7142857143[/C][C]-20763.7142857143[/C][/ROW]
[ROW][C]102[/C][C]1904[/C][C]787.95[/C][C]1116.05[/C][/ROW]
[ROW][C]103[/C][C]19[/C][C]15.75[/C][C]3.25[/C][/ROW]
[ROW][C]104[/C][C]74[/C][C]83.0454545454545[/C][C]-9.04545454545455[/C][/ROW]
[ROW][C]105[/C][C]81[/C][C]275.428571428571[/C][C]-194.428571428571[/C][/ROW]
[ROW][C]106[/C][C]109427[/C][C]122673.666666667[/C][C]-13246.6666666667[/C][/ROW]
[ROW][C]107[/C][C]2143[/C][C]1881.4375[/C][C]261.5625[/C][/ROW]
[ROW][C]108[/C][C]2146[/C][C]1881.4375[/C][C]264.5625[/C][/ROW]
[ROW][C]109[/C][C]874[/C][C]1253.85[/C][C]-379.85[/C][/ROW]
[ROW][C]110[/C][C]1590[/C][C]1253.85[/C][C]336.15[/C][/ROW]
[ROW][C]111[/C][C]1590[/C][C]1253.85[/C][C]336.15[/C][/ROW]
[ROW][C]112[/C][C]1210[/C][C]787.95[/C][C]422.05[/C][/ROW]
[ROW][C]113[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]114[/C][C]31[/C][C]33.03125[/C][C]-2.03125[/C][/ROW]
[ROW][C]115[/C][C]27[/C][C]27.8421052631579[/C][C]-0.842105263157894[/C][/ROW]
[ROW][C]116[/C][C]28[/C][C]27.8421052631579[/C][C]0.157894736842106[/C][/ROW]
[ROW][C]117[/C][C]59[/C][C]27.8421052631579[/C][C]31.1578947368421[/C][/ROW]
[ROW][C]118[/C][C]133[/C][C]83.0454545454545[/C][C]49.9545454545455[/C][/ROW]
[ROW][C]119[/C][C]12[/C][C]7.875[/C][C]4.125[/C][/ROW]
[ROW][C]120[/C][C]2341[/C][C]50947[/C][C]-48606[/C][/ROW]
[ROW][C]121[/C][C]84396[/C][C]43070.25[/C][C]41325.75[/C][/ROW]
[ROW][C]122[/C][C]530[/C][C]1253.85[/C][C]-723.85[/C][/ROW]
[ROW][C]123[/C][C]1988[/C][C]1253.85[/C][C]734.15[/C][/ROW]
[ROW][C]124[/C][C]1386[/C][C]1881.4375[/C][C]-495.4375[/C][/ROW]
[ROW][C]125[/C][C]2395[/C][C]787.95[/C][C]1607.05[/C][/ROW]
[ROW][C]126[/C][C]24[/C][C]33.03125[/C][C]-9.03125[/C][/ROW]
[ROW][C]127[/C][C]13[/C][C]15.75[/C][C]-2.75[/C][/ROW]
[ROW][C]128[/C][C]18[/C][C]7.875[/C][C]10.125[/C][/ROW]
[ROW][C]129[/C][C]14[/C][C]7.875[/C][C]6.125[/C][/ROW]
[ROW][C]130[/C][C]60[/C][C]83.0454545454545[/C][C]-23.0454545454545[/C][/ROW]
[ROW][C]131[/C][C]10112[/C][C]50947[/C][C]-40835[/C][/ROW]
[ROW][C]132[/C][C]142775[/C][C]122673.666666667[/C][C]20101.3333333333[/C][/ROW]
[ROW][C]133[/C][C]1606[/C][C]787.95[/C][C]818.05[/C][/ROW]
[ROW][C]134[/C][C]3[/C][C]787.95[/C][C]-784.95[/C][/ROW]
[ROW][C]135[/C][C]2[/C][C]787.95[/C][C]-785.95[/C][/ROW]
[ROW][C]136[/C][C]8[/C][C]15.75[/C][C]-7.75[/C][/ROW]
[ROW][C]137[/C][C]48[/C][C]83.0454545454545[/C][C]-35.0454545454545[/C][/ROW]
[ROW][C]138[/C][C]100[/C][C]83.0454545454545[/C][C]16.9545454545455[/C][/ROW]
[ROW][C]139[/C][C]46[/C][C]83.0454545454545[/C][C]-37.0454545454545[/C][/ROW]
[ROW][C]140[/C][C]45[/C][C]27.8421052631579[/C][C]17.1578947368421[/C][/ROW]
[ROW][C]141[/C][C]129[/C][C]275.428571428571[/C][C]-146.428571428571[/C][/ROW]
[ROW][C]142[/C][C]180759[/C][C]123930.764705882[/C][C]56828.2352941177[/C][/ROW]
[ROW][C]143[/C][C]214921[/C][C]122673.666666667[/C][C]92247.3333333333[/C][/ROW]
[ROW][C]144[/C][C]1002[/C][C]787.95[/C][C]214.05[/C][/ROW]
[ROW][C]145[/C][C]28[/C][C]33.03125[/C][C]-5.03125[/C][/ROW]
[ROW][C]146[/C][C]31[/C][C]33.03125[/C][C]-2.03125[/C][/ROW]
[ROW][C]147[/C][C]95[/C][C]83.0454545454545[/C][C]11.9545454545455[/C][/ROW]
[ROW][C]148[/C][C]6940[/C][C]50947[/C][C]-44007[/C][/ROW]
[ROW][C]149[/C][C]49025[/C][C]50947[/C][C]-1922[/C][/ROW]
[ROW][C]150[/C][C]122037[/C][C]123930.764705882[/C][C]-1893.76470588235[/C][/ROW]
[ROW][C]151[/C][C]53782[/C][C]50947[/C][C]2835[/C][/ROW]
[ROW][C]152[/C][C]127748[/C][C]122673.666666667[/C][C]5074.33333333333[/C][/ROW]
[ROW][C]153[/C][C]1701[/C][C]787.95[/C][C]913.05[/C][/ROW]
[ROW][C]154[/C][C]2[/C][C]787.95[/C][C]-785.95[/C][/ROW]
[ROW][C]155[/C][C]3[/C][C]787.95[/C][C]-784.95[/C][/ROW]
[ROW][C]156[/C][C]31[/C][C]33.03125[/C][C]-2.03125[/C][/ROW]
[ROW][C]157[/C][C]31[/C][C]33.03125[/C][C]-2.03125[/C][/ROW]
[ROW][C]158[/C][C]21[/C][C]15.75[/C][C]5.25[/C][/ROW]
[ROW][C]159[/C][C]39[/C][C]33.03125[/C][C]5.96875[/C][/ROW]
[ROW][C]160[/C][C]135[/C][C]83.0454545454545[/C][C]51.9545454545455[/C][/ROW]
[ROW][C]161[/C][C]57140[/C][C]122673.666666667[/C][C]-65533.6666666667[/C][/ROW]
[ROW][C]162[/C][C]2201[/C][C]1253.85[/C][C]947.15[/C][/ROW]
[ROW][C]163[/C][C]961[/C][C]1881.4375[/C][C]-920.4375[/C][/ROW]
[ROW][C]164[/C][C]1900[/C][C]1253.85[/C][C]646.15[/C][/ROW]
[ROW][C]165[/C][C]1254[/C][C]1253.85[/C][C]0.150000000000091[/C][/ROW]
[ROW][C]166[/C][C]1335[/C][C]1253.85[/C][C]81.1500000000001[/C][/ROW]
[ROW][C]167[/C][C]1597[/C][C]787.95[/C][C]809.05[/C][/ROW]
[ROW][C]168[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]169[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]170[/C][C]0[/C][C]7.875[/C][C]-7.875[/C][/ROW]
[ROW][C]171[/C][C]12[/C][C]27.8421052631579[/C][C]-15.8421052631579[/C][/ROW]
[ROW][C]172[/C][C]7670[/C][C]12824.2857142857[/C][C]-5154.28571428571[/C][/ROW]
[ROW][C]173[/C][C]1639[/C][C]1253.85[/C][C]385.15[/C][/ROW]
[ROW][C]174[/C][C]872[/C][C]787.95[/C][C]84.05[/C][/ROW]
[ROW][C]175[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]176[/C][C]11[/C][C]15.75[/C][C]-4.75[/C][/ROW]
[ROW][C]177[/C][C]24[/C][C]15.75[/C][C]8.25[/C][/ROW]
[ROW][C]178[/C][C]22[/C][C]33.03125[/C][C]-11.03125[/C][/ROW]
[ROW][C]179[/C][C]12[/C][C]15.75[/C][C]-3.75[/C][/ROW]
[ROW][C]180[/C][C]19[/C][C]15.75[/C][C]3.25[/C][/ROW]
[ROW][C]181[/C][C]13[/C][C]15.75[/C][C]-2.75[/C][/ROW]
[ROW][C]182[/C][C]33[/C][C]27.8421052631579[/C][C]5.15789473684211[/C][/ROW]
[ROW][C]183[/C][C]28313[/C][C]43070.25[/C][C]-14757.25[/C][/ROW]
[ROW][C]184[/C][C]766[/C][C]787.95[/C][C]-21.95[/C][/ROW]
[ROW][C]185[/C][C]2[/C][C]787.95[/C][C]-785.95[/C][/ROW]
[ROW][C]186[/C][C]5[/C][C]787.95[/C][C]-782.95[/C][/ROW]
[ROW][C]187[/C][C]18[/C][C]15.75[/C][C]2.25[/C][/ROW]
[ROW][C]188[/C][C]10[/C][C]7.875[/C][C]2.125[/C][/ROW]
[ROW][C]189[/C][C]25319[/C][C]50947[/C][C]-25628[/C][/ROW]
[ROW][C]190[/C][C]66956[/C][C]50947[/C][C]16009[/C][/ROW]
[ROW][C]191[/C][C]47487[/C][C]43070.25[/C][C]4416.75[/C][/ROW]
[ROW][C]192[/C][C]1206[/C][C]787.95[/C][C]418.05[/C][/ROW]
[ROW][C]193[/C][C]2[/C][C]787.95[/C][C]-785.95[/C][/ROW]
[ROW][C]194[/C][C]18[/C][C]15.75[/C][C]2.25[/C][/ROW]
[ROW][C]195[/C][C]16[/C][C]15.75[/C][C]0.25[/C][/ROW]
[ROW][C]196[/C][C]23[/C][C]15.75[/C][C]7.25[/C][/ROW]
[ROW][C]197[/C][C]22[/C][C]15.75[/C][C]6.25[/C][/ROW]
[ROW][C]198[/C][C]26[/C][C]27.8421052631579[/C][C]-1.84210526315789[/C][/ROW]
[ROW][C]199[/C][C]10[/C][C]27.8421052631579[/C][C]-17.8421052631579[/C][/ROW]
[ROW][C]200[/C][C]37754[/C][C]43070.25[/C][C]-5316.25[/C][/ROW]
[ROW][C]201[/C][C]592[/C][C]1253.85[/C][C]-661.85[/C][/ROW]
[ROW][C]202[/C][C]995[/C][C]22745.7142857143[/C][C]-21750.7142857143[/C][/ROW]
[ROW][C]203[/C][C]1613[/C][C]1253.85[/C][C]359.15[/C][/ROW]
[ROW][C]204[/C][C]2048[/C][C]787.95[/C][C]1260.05[/C][/ROW]
[ROW][C]205[/C][C]17[/C][C]15.75[/C][C]1.25[/C][/ROW]
[ROW][C]206[/C][C]43[/C][C]27.8421052631579[/C][C]15.1578947368421[/C][/ROW]
[ROW][C]207[/C][C]32868[/C][C]50947[/C][C]-18079[/C][/ROW]
[ROW][C]208[/C][C]27640[/C][C]43070.25[/C][C]-15430.25[/C][/ROW]
[ROW][C]209[/C][C]1186[/C][C]12824.2857142857[/C][C]-11638.2857142857[/C][/ROW]
[ROW][C]210[/C][C]1451[/C][C]275.428571428571[/C][C]1175.57142857143[/C][/ROW]
[ROW][C]211[/C][C]628[/C][C]1253.85[/C][C]-625.85[/C][/ROW]
[ROW][C]212[/C][C]1161[/C][C]787.95[/C][C]373.05[/C][/ROW]
[ROW][C]213[/C][C]17[/C][C]15.75[/C][C]1.25[/C][/ROW]
[ROW][C]214[/C][C]21[/C][C]15.75[/C][C]5.25[/C][/ROW]
[ROW][C]215[/C][C]18[/C][C]15.75[/C][C]2.25[/C][/ROW]
[ROW][C]216[/C][C]18[/C][C]15.75[/C][C]2.25[/C][/ROW]
[ROW][C]217[/C][C]22[/C][C]27.8421052631579[/C][C]-5.84210526315789[/C][/ROW]
[ROW][C]218[/C][C]30[/C][C]27.8421052631579[/C][C]2.15789473684211[/C][/ROW]
[ROW][C]219[/C][C]10824[/C][C]12824.2857142857[/C][C]-2000.28571428571[/C][/ROW]
[ROW][C]220[/C][C]1081[/C][C]787.95[/C][C]293.05[/C][/ROW]
[ROW][C]221[/C][C]16[/C][C]15.75[/C][C]0.25[/C][/ROW]
[ROW][C]222[/C][C]14[/C][C]15.75[/C][C]-1.75[/C][/ROW]
[ROW][C]223[/C][C]23[/C][C]27.8421052631579[/C][C]-4.84210526315789[/C][/ROW]
[ROW][C]224[/C][C]40961[/C][C]50947[/C][C]-9986[/C][/ROW]
[ROW][C]225[/C][C]48231[/C][C]123930.764705882[/C][C]-75699.7647058823[/C][/ROW]
[ROW][C]226[/C][C]39725[/C][C]43070.25[/C][C]-3345.25[/C][/ROW]
[ROW][C]227[/C][C]945[/C][C]787.95[/C][C]157.05[/C][/ROW]
[ROW][C]228[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]229[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]230[/C][C]1[/C][C]15.75[/C][C]-14.75[/C][/ROW]
[ROW][C]231[/C][C]18[/C][C]15.75[/C][C]2.25[/C][/ROW]
[ROW][C]232[/C][C]17[/C][C]15.75[/C][C]1.25[/C][/ROW]
[ROW][C]233[/C][C]4[/C][C]15.75[/C][C]-11.75[/C][/ROW]
[ROW][C]234[/C][C]10[/C][C]15.75[/C][C]-5.75[/C][/ROW]
[ROW][C]235[/C][C]27[/C][C]27.8421052631579[/C][C]-0.842105263157894[/C][/ROW]
[ROW][C]236[/C][C]23177[/C][C]12824.2857142857[/C][C]10352.7142857143[/C][/ROW]
[ROW][C]237[/C][C]459[/C][C]787.95[/C][C]-328.95[/C][/ROW]
[ROW][C]238[/C][C]17[/C][C]15.75[/C][C]1.25[/C][/ROW]
[ROW][C]239[/C][C]5[/C][C]7.875[/C][C]-2.875[/C][/ROW]
[ROW][C]240[/C][C]37[/C][C]27.8421052631579[/C][C]9.1578947368421[/C][/ROW]
[ROW][C]241[/C][C]18511[/C][C]12824.2857142857[/C][C]5686.71428571429[/C][/ROW]
[ROW][C]242[/C][C]857[/C][C]1253.85[/C][C]-396.85[/C][/ROW]
[ROW][C]243[/C][C]830[/C][C]1253.85[/C][C]-423.85[/C][/ROW]
[ROW][C]244[/C][C]652[/C][C]1253.85[/C][C]-601.85[/C][/ROW]
[ROW][C]245[/C][C]707[/C][C]787.95[/C][C]-80.95[/C][/ROW]
[ROW][C]246[/C][C]19[/C][C]15.75[/C][C]3.25[/C][/ROW]
[ROW][C]247[/C][C]20[/C][C]27.8421052631579[/C][C]-7.8421052631579[/C][/ROW]
[ROW][C]248[/C][C]13[/C][C]43070.25[/C][C]-43057.25[/C][/ROW]
[ROW][C]249[/C][C]1141[/C][C]787.95[/C][C]353.05[/C][/ROW]
[ROW][C]250[/C][C]19[/C][C]15.75[/C][C]3.25[/C][/ROW]
[ROW][C]251[/C][C]3[/C][C]7.875[/C][C]-4.875[/C][/ROW]
[ROW][C]252[/C][C]9927[/C][C]12824.2857142857[/C][C]-2897.28571428571[/C][/ROW]
[ROW][C]253[/C][C]1145[/C][C]1253.85[/C][C]-108.85[/C][/ROW]
[ROW][C]254[/C][C]733[/C][C]787.95[/C][C]-54.95[/C][/ROW]
[ROW][C]255[/C][C]14[/C][C]15.75[/C][C]-1.75[/C][/ROW]
[ROW][C]256[/C][C]29[/C][C]27.8421052631579[/C][C]1.15789473684211[/C][/ROW]
[ROW][C]257[/C][C]6012[/C][C]50947[/C][C]-44935[/C][/ROW]
[ROW][C]258[/C][C]18475[/C][C]12824.2857142857[/C][C]5650.71428571429[/C][/ROW]
[ROW][C]259[/C][C]947[/C][C]787.95[/C][C]159.05[/C][/ROW]
[ROW][C]260[/C][C]15[/C][C]15.75[/C][C]-0.75[/C][/ROW]
[ROW][C]261[/C][C]17[/C][C]27.8421052631579[/C][C]-10.8421052631579[/C][/ROW]
[ROW][C]262[/C][C]79[/C][C]83.0454545454545[/C][C]-4.04545454545455[/C][/ROW]
[ROW][C]263[/C][C]98364[/C][C]50947[/C][C]47417[/C][/ROW]
[ROW][C]264[/C][C]86146[/C][C]122673.666666667[/C][C]-36527.6666666667[/C][/ROW]
[ROW][C]265[/C][C]2172[/C][C]787.95[/C][C]1384.05[/C][/ROW]
[ROW][C]266[/C][C]26[/C][C]15.75[/C][C]10.25[/C][/ROW]
[ROW][C]267[/C][C]25[/C][C]33.03125[/C][C]-8.03125[/C][/ROW]
[ROW][C]268[/C][C]1[/C][C]7.875[/C][C]-6.875[/C][/ROW]
[ROW][C]269[/C][C]21529[/C][C]50947[/C][C]-29418[/C][/ROW]
[ROW][C]270[/C][C]95757[/C][C]50947[/C][C]44810[/C][/ROW]
[ROW][C]271[/C][C]85584[/C][C]50947[/C][C]34637[/C][/ROW]
[ROW][C]272[/C][C]143983[/C][C]122673.666666667[/C][C]21309.3333333333[/C][/ROW]
[ROW][C]273[/C][C]1495[/C][C]1253.85[/C][C]241.15[/C][/ROW]
[ROW][C]274[/C][C]1373[/C][C]787.95[/C][C]585.05[/C][/ROW]
[ROW][C]275[/C][C]34[/C][C]33.03125[/C][C]0.96875[/C][/ROW]
[ROW][C]276[/C][C]47[/C][C]33.03125[/C][C]13.96875[/C][/ROW]
[ROW][C]277[/C][C]30[/C][C]33.03125[/C][C]-3.03125[/C][/ROW]
[ROW][C]278[/C][C]31[/C][C]33.03125[/C][C]-2.03125[/C][/ROW]
[ROW][C]279[/C][C]82[/C][C]275.428571428571[/C][C]-193.428571428571[/C][/ROW]
[ROW][C]280[/C][C]105499[/C][C]123930.764705882[/C][C]-18431.7647058823[/C][/ROW]
[ROW][C]281[/C][C]121527[/C][C]123930.764705882[/C][C]-2403.76470588235[/C][/ROW]
[ROW][C]282[/C][C]127766[/C][C]122673.666666667[/C][C]5092.33333333333[/C][/ROW]
[ROW][C]283[/C][C]1220[/C][C]787.95[/C][C]432.05[/C][/ROW]
[ROW][C]284[/C][C]4[/C][C]15.75[/C][C]-11.75[/C][/ROW]
[ROW][C]285[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]286[/C][C]5[/C][C]787.95[/C][C]-782.95[/C][/ROW]
[ROW][C]287[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]288[/C][C]4[/C][C]787.95[/C][C]-783.95[/C][/ROW]
[ROW][C]289[/C][C]33[/C][C]33.03125[/C][C]-0.03125[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158105&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158105&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
14787.95-783.95
22833.03125-5.03125
33833.031254.96875
410883.045454545454524.9545454545455
57923443070.2536163.75
64631881.4375-1418.4375
73201787.952413.05
81115.75-4.75
92633.03125-7.03125
102533.03125-8.03125
113833.031254.96875
128683.04545454545452.95454545454545
1344275.428571428571-231.428571428571
1493163122673.666666667-29510.6666666667
151491787.95703.05
1640411881.43752159.5625
1717061881.4375-175.4375
182152787.951364.05
193633.031252.96875
203633.031252.96875
213033.03125-3.03125
2250275.428571428571-225.428571428571
23779005094726953
2485646123930.764705882-38284.7647058823
2598579123930.764705882-25351.7647058823
26130767123930.7647058826836.23529411765
27131741123930.7647058827810.23529411765
285390722745.714285714331161.2857142857
2918121881.4375-69.4375
3016771881.4375-204.4375
311579787.95791.05
323015.7514.25
333333.03125-0.03125
343083.0454545454545-53.0454545454545
3586572123930.764705882-37358.7647058823
36159676123930.76470588235745.2352941177
37192922745.7142857143-20816.7142857143
3814991253.85245.15
398651253.85-388.85
4017931881.4375-88.4375
412527787.951739.05
424787.95-783.95
433787.95-784.95
444787.95-783.95
455787.95-782.95
463933.031255.96875
473433.031250.96875
482027.8421052631579-7.8421052631579
4991275.428571428571-184.428571428571
50161632122673.66666666738958.3333333333
511713787.95925.05
52415.75-11.75
533933.031255.96875
542127.8421052631579-6.84210526315789
554582450947-5123
56102996123930.764705882-20934.7647058823
57160604123930.76470588236673.2352941177
58158051123930.76470588234120.2352941177
594454722745.714285714321801.2857142857
6026941881.4375812.5625
611973787.951185.05
623833.031254.96875
6310583.045454545454521.9545454545455
6475661122673.666666667-47012.6666666667
6519541881.437572.5625
661226787.95438.05
675787.95-782.95
683633.031252.96875
692833.03125-5.03125
7011883.045454545454534.9545454545455
7186767123930.764705882-37163.7647058823
722382422745.71428571431078.28571428571
7317621881.4375-119.4375
7414031881.4375-478.4375
751425787.95637.05
764787.95-783.95
773433.031250.96875
789983.045454545454515.9545454545455
796283.0454545454545-21.0454545454545
80617245094710777
81131722122673.6666666679048.33333333333
8213171881.4375-564.4375
831644787.95856.05
842787.95-785.95
852787.95-785.95
864787.95-783.95
873787.95-784.95
884533.0312511.96875
893733.031253.96875
906883.0454545454545-15.0454545454545
9112483.045454545454540.9545454545455
923383.0454545454545-50.0454545454545
939883.045454545454514.9545454545455
945883.0454545454545-25.0454545454545
956883.0454545454545-15.0454545454545
961360485094785101
97181248123930.76470588257317.2352941177
98146123123930.76470588222192.2352941177
993203622745.71428571439290.28571428571
10028451881.4375963.5625
101198222745.7142857143-20763.7142857143
1021904787.951116.05
1031915.753.25
1047483.0454545454545-9.04545454545455
10581275.428571428571-194.428571428571
106109427122673.666666667-13246.6666666667
10721431881.4375261.5625
10821461881.4375264.5625
1098741253.85-379.85
11015901253.85336.15
11115901253.85336.15
1121210787.95422.05
1134787.95-783.95
1143133.03125-2.03125
1152727.8421052631579-0.842105263157894
1162827.84210526315790.157894736842106
1175927.842105263157931.1578947368421
11813383.045454545454549.9545454545455
119127.8754.125
120234150947-48606
1218439643070.2541325.75
1225301253.85-723.85
12319881253.85734.15
12413861881.4375-495.4375
1252395787.951607.05
1262433.03125-9.03125
1271315.75-2.75
128187.87510.125
129147.8756.125
1306083.0454545454545-23.0454545454545
1311011250947-40835
132142775122673.66666666720101.3333333333
1331606787.95818.05
1343787.95-784.95
1352787.95-785.95
136815.75-7.75
1374883.0454545454545-35.0454545454545
13810083.045454545454516.9545454545455
1394683.0454545454545-37.0454545454545
1404527.842105263157917.1578947368421
141129275.428571428571-146.428571428571
142180759123930.76470588256828.2352941177
143214921122673.66666666792247.3333333333
1441002787.95214.05
1452833.03125-5.03125
1463133.03125-2.03125
1479583.045454545454511.9545454545455
148694050947-44007
1494902550947-1922
150122037123930.764705882-1893.76470588235
15153782509472835
152127748122673.6666666675074.33333333333
1531701787.95913.05
1542787.95-785.95
1553787.95-784.95
1563133.03125-2.03125
1573133.03125-2.03125
1582115.755.25
1593933.031255.96875
16013583.045454545454551.9545454545455
16157140122673.666666667-65533.6666666667
16222011253.85947.15
1639611881.4375-920.4375
16419001253.85646.15
16512541253.850.150000000000091
16613351253.8581.1500000000001
1671597787.95809.05
1684787.95-783.95
1694787.95-783.95
17007.875-7.875
1711227.8421052631579-15.8421052631579
172767012824.2857142857-5154.28571428571
17316391253.85385.15
174872787.9584.05
1754787.95-783.95
1761115.75-4.75
1772415.758.25
1782233.03125-11.03125
1791215.75-3.75
1801915.753.25
1811315.75-2.75
1823327.84210526315795.15789473684211
1832831343070.25-14757.25
184766787.95-21.95
1852787.95-785.95
1865787.95-782.95
1871815.752.25
188107.8752.125
1892531950947-25628
190669565094716009
1914748743070.254416.75
1921206787.95418.05
1932787.95-785.95
1941815.752.25
1951615.750.25
1962315.757.25
1972215.756.25
1982627.8421052631579-1.84210526315789
1991027.8421052631579-17.8421052631579
2003775443070.25-5316.25
2015921253.85-661.85
20299522745.7142857143-21750.7142857143
20316131253.85359.15
2042048787.951260.05
2051715.751.25
2064327.842105263157915.1578947368421
2073286850947-18079
2082764043070.25-15430.25
209118612824.2857142857-11638.2857142857
2101451275.4285714285711175.57142857143
2116281253.85-625.85
2121161787.95373.05
2131715.751.25
2142115.755.25
2151815.752.25
2161815.752.25
2172227.8421052631579-5.84210526315789
2183027.84210526315792.15789473684211
2191082412824.2857142857-2000.28571428571
2201081787.95293.05
2211615.750.25
2221415.75-1.75
2232327.8421052631579-4.84210526315789
2244096150947-9986
22548231123930.764705882-75699.7647058823
2263972543070.25-3345.25
227945787.95157.05
2284787.95-783.95
2294787.95-783.95
230115.75-14.75
2311815.752.25
2321715.751.25
233415.75-11.75
2341015.75-5.75
2352727.8421052631579-0.842105263157894
2362317712824.285714285710352.7142857143
237459787.95-328.95
2381715.751.25
23957.875-2.875
2403727.84210526315799.1578947368421
2411851112824.28571428575686.71428571429
2428571253.85-396.85
2438301253.85-423.85
2446521253.85-601.85
245707787.95-80.95
2461915.753.25
2472027.8421052631579-7.8421052631579
2481343070.25-43057.25
2491141787.95353.05
2501915.753.25
25137.875-4.875
252992712824.2857142857-2897.28571428571
25311451253.85-108.85
254733787.95-54.95
2551415.75-1.75
2562927.84210526315791.15789473684211
257601250947-44935
2581847512824.28571428575650.71428571429
259947787.95159.05
2601515.75-0.75
2611727.8421052631579-10.8421052631579
2627983.0454545454545-4.04545454545455
263983645094747417
26486146122673.666666667-36527.6666666667
2652172787.951384.05
2662615.7510.25
2672533.03125-8.03125
26817.875-6.875
2692152950947-29418
270957575094744810
271855845094734637
272143983122673.66666666721309.3333333333
27314951253.85241.15
2741373787.95585.05
2753433.031250.96875
2764733.0312513.96875
2773033.03125-3.03125
2783133.03125-2.03125
27982275.428571428571-193.428571428571
280105499123930.764705882-18431.7647058823
281121527123930.764705882-2403.76470588235
282127766122673.6666666675092.33333333333
2831220787.95432.05
284415.75-11.75
2854787.95-783.95
2865787.95-782.95
2874787.95-783.95
2884787.95-783.95
2893333.03125-0.03125



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