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 computationMon, 12 Dec 2011 06:02:39 -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/12/t1323687805k6epx27fzxoioae.htm/, Retrieved Fri, 03 May 2024 09:29:43 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=153913, Retrieved Fri, 03 May 2024 09:29:43 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact120
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [] [2010-12-05 20:13:50] [b98453cac15ba1066b407e146608df68]
- R PD  [Recursive Partitioning (Regression Trees)] [ws10] [2011-12-12 10:07:37] [7e261c986c934df955dd3ac53e9d45c6]
-   P       [Recursive Partitioning (Regression Trees)] [ws10] [2011-12-12 11:02:39] [13dfa60174f50d862e8699db2153bfc5] [Current]
Feedback Forum

Post a new message
Dataseries X:
11.5	8	350	165	3693
11	8	318	150	3436
10.5	8	302	140	3449
10	8	429	198	4341
8.5	8	440	215	4312
10	8	455	225	4425
10	8	383	170	3563
8	8	340	160	3609
10	8	455	225	3086
15	4	113	95	2372
15.5	6	199	97	2774
20.5	4	97	46	1835
17.5	4	110	87	2672
17.5	4	104	95	2375
12.5	4	121	113	2234
14	8	360	215	4615
15	8	307	200	4376
18.5	8	304	193	4732
14.5	4	97	88	2130
14	4	113	95	2228
15.5	6	250	100	3329
15.5	6	232	100	3288
12	8	350	165	4209
13	8	318	150	4096
12	8	400	170	4746
12	8	400	175	5140
19	4	140	72	2408
15	6	250	100	3282
14	4	122	86	2220
14	4	116	90	2123
14.5	4	88	76	2065
19	4	71	65	1773
19	4	97	60	1834
20.5	4	91	70	1955
17	4	97.5	80	2126
16.5	4	122	86	2226
12	8	350	165	4274
13.5	8	318	150	4135
13	8	351	153	4129
11	8	429	208	4633
13.5	8	350	155	4502
12.5	8	400	190	4422
13.5	3	70	97	2330
14	8	307	130	4098
16	8	302	140	4294
14.5	4	121	112	2933
18	4	121	76	2511
16	4	122	86	2395
14.5	4	120	97	2506
15	4	98	80	2164
13	8	350	175	4100
11.5	8	304	150	3672
14.5	8	302	137	4042
12.5	8	318	150	3777
12	8	400	150	4464
13	8	351	158	4363
11	8	440	215	4735
11	8	455	225	4951
16.5	6	225	105	3121
18	6	250	100	3278
16.5	6	250	88	3021
16	6	198	95	2904
14	8	400	150	4997
12.5	8	350	180	4499
15	6	232	100	2789
19.5	4	140	72	2401
16.5	4	108	94	2379
18.5	4	122	85	2310
14	6	155	107	2472
13	8	350	145	4082
9.5	8	400	230	4278
15.5	4	116	75	2158
14	4	114	91	2582
11	8	318	150	3399
14	4	121	110	2660
11	8	350	180	3664
16.5	6	198	95	3102
16	6	232	100	2901
16.5	4	122	80	2451
21	4	71	65	1836
17	6	250	100	3781
18	6	258	110	3632
14	8	302	140	4141
14.5	8	350	150	4699
16	8	302	140	4638
15.5	8	304	150	4257
15.5	4	79	67	1963
14.5	4	97	78	2300
19	4	83	61	2003
14.5	4	90	75	2125
14	4	116	75	2246
15	4	120	97	2489
16	4	79	67	2000
16	6	225	95	3264
19.5	6	250	72	3158
11.5	8	400	170	4668
14	8	350	145	4440
13.5	8	351	148	4657
21	6	231	110	3907
19	6	258	110	3730
19	6	225	95	3785
13.5	8	262	110	3221
12	8	302	129	3169
17	4	140	83	2639
16	6	232	100	2914
13.5	4	134	96	2702
16.5	4	90	71	2223
14.5	6	171	97	2984
15	4	115	95	2694
17	4	120	88	2957
13.5	4	121	115	2671
17.5	4	91	53	1795
16.9	4	116	81	2220
14.9	4	140	92	2572
15.3	4	101	83	2202
13	8	305	140	4215
13.9	8	304	120	3962
12.8	8	351	152	4215
14.5	6	250	105	3353
17.6	6	200	81	3012
22.2	4	85	52	2035
22.1	4	98	60	2164
17.7	6	225	100	3651
16.2	6	250	110	3645
17.8	6	258	95	3193
17	4	85	70	1990
16.4	4	97	75	2155
15.7	4	130	102	3150
13.2	8	318	150	3940
16.7	6	168	120	3820
12.1	8	350	180	4380
15	8	302	130	3870
14	8	318	150	3755
14.8	4	111	80	2155
18.6	4	79	58	1825
16.8	4	85	70	1945
12.5	8	305	145	3880
13.7	8	318	145	4140
16.9	6	231	105	3425
17.7	6	225	100	3630
11.1	8	400	180	4220
11.4	8	350	170	4165
14.5	8	351	149	4335
14.5	4	97	78	1940
18.2	4	97	75	2265
15.8	4	140	89	2755
15.9	4	98	83	2075
16.4	4	97	67	1985
14.5	6	146	97	2815
12.8	4	121	110	2600
21.5	4	90	48	1985
14.4	4	98	66	1800
18.6	4	85	70	2070
13.2	8	318	140	3735
12.8	8	302	139	3570
18.2	6	200	95	3155
15.8	6	200	85	2965
17.2	6	225	100	3430
17.2	6	232	90	3210
16.7	6	200	85	3070
18.7	6	225	110	3620
13.2	8	305	145	3425
13.4	6	231	165	3445
13.7	8	318	140	4080
16.5	4	98	68	2155
14.7	4	119	97	2300
14.5	4	105	75	2230
17.6	4	151	85	2855
15.9	5	131	103	2830
13.6	6	163	125	3140
15.8	6	163	133	3410
14.9	4	89	71	1990
16.6	4	98	68	2135
18.2	6	200	85	2990
17.3	4	140	88	2890
16.6	6	225	110	3360
15.4	8	305	130	3840
13.2	8	351	138	3955
15.2	8	318	135	3830
14.3	8	351	142	4054
15	8	267	125	3605
14	4	89	71	1925
15.2	4	86	65	1975
15	4	121	80	2670
24.8	4	141	71	3190
22.2	8	260	90	3420
14.9	4	105	70	2150
19.2	4	85	65	2020
16	4	151	90	2670
11.3	6	173	115	2595
13.2	4	151	90	2556
14.7	4	98	76	2144
15.5	4	98	70	2120
16.4	4	86	65	2019
18.1	4	140	88	2870
20.1	4	151	90	3003
15.8	4	97	78	2188
15.5	4	134	90	2711
15	4	119	92	2434
15.2	4	108	75	2265
14.4	4	156	105	2800
19.2	4	85	65	2110
19.9	5	121	67	2950
13.8	4	91	67	1850
15.3	4	89	62	1845
15.1	4	122	88	2500
15.7	4	135	84	2490
16.4	4	151	84	2635
12.6	6	173	110	2725
12.9	4	135	84	2385
16.4	4	86	64	1875
16.1	4	81	60	1760
19.4	4	85	65	1975
17.3	4	89	62	2050
14.9	4	105	63	2215
16.2	4	98	65	2045
14.2	4	105	74	2190
14.8	4	119	100	2615
20.4	4	141	80	3230
13.8	6	146	120	2930
15.8	6	231	110	3415
17.1	6	200	88	3060
16.6	6	225	85	3465
18.6	4	112	88	2640
18	4	112	88	2395
16	4	135	84	2525
18	4	151	90	2735
15.3	4	105	74	1980
17.6	4	91	68	1970
14.7	4	105	63	2125
14.5	4	120	88	2160
14.5	4	107	75	2205
15.7	4	91	67	1965
16.4	6	181	110	2945
17	6	262	85	3015
13.9	4	144	96	2665
17.3	4	151	90	2950
15.6	4	140	86	2790
11.6	4	135	84	2295
18.6	4	120	79	2625




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

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 5 seconds \tabularnewline
R Server & 'Gwilym Jenkins' @ jenkins.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=153913&T=0

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

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

As an alternative you can also use a QR Code:  

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

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







Goodness of Fit
Correlation0.7911
R-squared0.6259
RMSE1.6141

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7911[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6259[/C][/ROW]
[ROW][C]RMSE[/C][C]1.6141[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=153913&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=153913&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.7911
R-squared0.6259
RMSE1.6141







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
111.512.6461538461538-1.14615384615385
21113.5877551020408-2.58775510204082
310.513.5877551020408-3.08775510204082
41010.7214285714286-0.721428571428572
58.510.7214285714286-2.22142857142857
61010.7214285714286-0.721428571428572
71010.7214285714286-0.721428571428572
8812.6461538461538-4.64615384615385
91010.7214285714286-0.721428571428572
101515.2875-0.2875
1115.515.28750.2125
1220.519.61111111111110.888888888888889
1317.515.28752.2125
1417.515.28752.2125
1512.513.5877551020408-1.08775510204082
161412.64615384615381.35384615384615
171512.64615384615382.35384615384615
1818.512.64615384615385.85384615384615
1914.515.2875-0.7875
201415.2875-1.2875
2115.516.045-0.545000000000002
2215.516.045-0.545000000000002
231212.6461538461538-0.646153846153846
241313.5877551020408-0.587755102040816
251210.72142857142861.27857142857143
261210.72142857142861.27857142857143
271916.78484848484852.21515151515151
281516.045-1.045
291415.2875-1.2875
301415.2875-1.2875
3114.515.2875-0.7875
321916.78484848484852.21515151515151
331919.6111111111111-0.611111111111111
3420.516.78484848484853.71515151515151
351715.28751.7125
3616.515.28751.2125
371212.6461538461538-0.646153846153846
3813.513.5877551020408-0.0877551020408163
391313.5877551020408-0.587755102040816
401110.72142857142860.278571428571428
4113.513.5877551020408-0.0877551020408163
4212.510.72142857142861.77857142857143
4313.515.2875-1.7875
441413.58775510204080.412244897959184
451613.58775510204082.41224489795918
4614.513.58775510204080.912244897959184
471815.28752.7125
481615.28750.7125
4914.515.2875-0.7875
501515.2875-0.2875
511312.64615384615380.353846153846154
5211.513.5877551020408-2.08775510204082
5314.513.58775510204080.912244897959184
5412.513.5877551020408-1.08775510204082
551213.5877551020408-1.58775510204082
561313.5877551020408-0.587755102040816
571110.72142857142860.278571428571428
581110.72142857142860.278571428571428
5916.516.0450.454999999999998
601816.0451.955
6116.518.345-1.845
621616.045-0.0450000000000017
631413.58775510204080.412244897959184
6412.512.6461538461538-0.146153846153846
651515.2875-0.2875
6619.516.78484848484852.71515151515151
6716.515.28751.2125
6818.515.28753.2125
691415.2875-1.2875
701313.5877551020408-0.587755102040816
719.510.7214285714286-1.22142857142857
7215.515.28750.2125
731415.2875-1.2875
741113.5877551020408-2.58775510204082
751415.2875-1.2875
761112.6461538461538-1.64615384615385
7716.516.0450.454999999999998
781616.045-0.0450000000000017
7916.515.28751.2125
802116.78484848484854.21515151515151
811718.15-1.15
821818.15-0.149999999999999
831413.58775510204080.412244897959184
8414.513.58775510204080.912244897959184
851613.58775510204082.41224489795918
8615.513.58775510204081.91224489795918
8715.516.7848484848485-1.28484848484849
8814.515.2875-0.7875
891919.6111111111111-0.611111111111111
9014.515.2875-0.7875
911415.2875-1.2875
921515.2875-0.2875
931616.7848484848485-0.784848484848485
941616.045-0.0450000000000017
9519.518.3451.155
9611.510.72142857142860.778571428571428
971413.58775510204080.412244897959184
9813.513.5877551020408-0.0877551020408163
992118.152.85
1001918.150.850000000000001
1011918.150.850000000000001
10213.516.045-2.545
1031213.5877551020408-1.58775510204082
1041715.28751.7125
1051616.045-0.0450000000000017
10613.515.2875-1.7875
10716.516.7848484848485-0.284848484848485
10814.516.045-1.545
1091515.2875-0.2875
1101718.345-1.345
11113.513.5877551020408-0.0877551020408163
11217.519.6111111111111-2.11111111111111
11316.915.28751.6125
11414.915.2875-0.387499999999999
11515.315.28750.0125000000000011
1161313.5877551020408-0.587755102040816
11713.913.58775510204080.312244897959184
11812.813.5877551020408-0.787755102040816
11914.516.045-1.545
12017.618.345-0.744999999999997
12122.219.61111111111112.58888888888889
12222.119.61111111111112.48888888888889
12317.718.15-0.449999999999999
12416.218.15-1.95
12517.816.0451.755
1261716.78484848484850.215151515151515
12716.415.28751.1125
12815.716.045-0.345000000000002
12913.213.5877551020408-0.387755102040817
13016.713.58775510204083.11224489795918
13112.112.6461538461538-0.546153846153846
1321513.58775510204081.41224489795918
1331413.58775510204080.412244897959184
13414.815.2875-0.487499999999999
13518.619.6111111111111-1.01111111111111
13616.816.78484848484850.0151515151515156
13712.513.5877551020408-1.08775510204082
13813.713.58775510204080.112244897959183
13916.916.0450.854999999999997
14017.718.15-0.449999999999999
14111.110.72142857142860.378571428571428
14211.412.6461538461538-1.24615384615385
14314.513.58775510204080.912244897959184
14414.515.2875-0.7875
14518.215.28752.9125
14615.815.28750.512500000000001
14715.915.28750.612500000000001
14816.416.7848484848485-0.384848484848487
14914.515.2875-0.7875
15012.815.2875-2.4875
15121.519.61111111111111.88888888888889
15214.416.7848484848485-2.38484848484848
15318.616.78484848484851.81515151515152
15413.213.5877551020408-0.387755102040817
15512.813.5877551020408-0.787755102040816
15618.216.0452.155
15715.818.345-2.545
15817.218.15-0.949999999999999
15917.218.345-1.145
16016.718.345-1.645
16118.718.150.550000000000001
16213.213.5877551020408-0.387755102040817
16313.412.64615384615380.753846153846155
16413.713.58775510204080.112244897959183
16516.516.7848484848485-0.284848484848485
16614.715.2875-0.5875
16714.515.2875-0.7875
16817.618.345-0.744999999999997
16915.915.28750.612500000000001
17013.613.58775510204080.0122448979591834
17115.813.58775510204082.21224489795918
17214.916.7848484848485-1.88484848484848
17316.616.7848484848485-0.184848484848484
17418.218.345-0.145
17517.318.345-1.045
17616.616.0450.555
17715.413.58775510204081.81224489795918
17813.213.5877551020408-0.387755102040817
17915.213.58775510204081.61224489795918
18014.313.58775510204080.712244897959184
1811513.58775510204081.41224489795918
1821416.7848484848485-2.78484848484849
18315.216.7848484848485-1.58484848484849
1841515.2875-0.2875
18524.818.3456.455
18622.218.3453.855
18714.916.7848484848485-1.88484848484848
18819.216.78484848484852.41515151515151
1891615.28750.7125
19011.313.5877551020408-2.28775510204082
19113.215.2875-2.0875
19214.715.2875-0.5875
19315.516.7848484848485-1.28484848484849
19416.416.7848484848485-0.384848484848487
19518.118.345-0.244999999999997
19620.118.3451.755
19715.815.28750.512500000000001
19815.515.28750.2125
1991515.2875-0.2875
20015.215.2875-0.0875000000000004
20114.415.2875-0.887499999999999
20219.216.78484848484852.41515151515151
20319.918.3451.555
20413.816.7848484848485-2.98484848484848
20515.316.7848484848485-1.48484848484848
20615.115.2875-0.1875
20715.715.28750.4125
20816.415.28751.1125
20912.615.2875-2.6875
21012.915.2875-2.3875
21116.416.7848484848485-0.384848484848487
21216.119.6111111111111-3.51111111111111
21319.416.78484848484852.61515151515151
21417.316.78484848484850.515151515151516
21514.916.7848484848485-1.88484848484848
21616.216.7848484848485-0.584848484848486
21714.215.2875-1.0875
21814.815.2875-0.487499999999999
21920.418.3452.055
22013.813.58775510204080.212244897959184
22115.816.045-0.245000000000001
22217.118.345-1.245
22316.618.345-1.745
22418.615.28753.3125
2251815.28752.7125
2261615.28750.7125
2271815.28752.7125
22815.315.28750.0125000000000011
22917.616.78484848484850.815151515151516
23014.716.7848484848485-2.08484848484849
23114.515.2875-0.7875
23214.515.2875-0.7875
23315.716.7848484848485-1.08484848484849
23416.416.0450.354999999999997
2351718.345-1.345
23613.915.2875-1.3875
23717.318.345-1.045
23815.615.28750.3125
23911.615.2875-3.6875
24018.615.28753.3125

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 11.5 & 12.6461538461538 & -1.14615384615385 \tabularnewline
2 & 11 & 13.5877551020408 & -2.58775510204082 \tabularnewline
3 & 10.5 & 13.5877551020408 & -3.08775510204082 \tabularnewline
4 & 10 & 10.7214285714286 & -0.721428571428572 \tabularnewline
5 & 8.5 & 10.7214285714286 & -2.22142857142857 \tabularnewline
6 & 10 & 10.7214285714286 & -0.721428571428572 \tabularnewline
7 & 10 & 10.7214285714286 & -0.721428571428572 \tabularnewline
8 & 8 & 12.6461538461538 & -4.64615384615385 \tabularnewline
9 & 10 & 10.7214285714286 & -0.721428571428572 \tabularnewline
10 & 15 & 15.2875 & -0.2875 \tabularnewline
11 & 15.5 & 15.2875 & 0.2125 \tabularnewline
12 & 20.5 & 19.6111111111111 & 0.888888888888889 \tabularnewline
13 & 17.5 & 15.2875 & 2.2125 \tabularnewline
14 & 17.5 & 15.2875 & 2.2125 \tabularnewline
15 & 12.5 & 13.5877551020408 & -1.08775510204082 \tabularnewline
16 & 14 & 12.6461538461538 & 1.35384615384615 \tabularnewline
17 & 15 & 12.6461538461538 & 2.35384615384615 \tabularnewline
18 & 18.5 & 12.6461538461538 & 5.85384615384615 \tabularnewline
19 & 14.5 & 15.2875 & -0.7875 \tabularnewline
20 & 14 & 15.2875 & -1.2875 \tabularnewline
21 & 15.5 & 16.045 & -0.545000000000002 \tabularnewline
22 & 15.5 & 16.045 & -0.545000000000002 \tabularnewline
23 & 12 & 12.6461538461538 & -0.646153846153846 \tabularnewline
24 & 13 & 13.5877551020408 & -0.587755102040816 \tabularnewline
25 & 12 & 10.7214285714286 & 1.27857142857143 \tabularnewline
26 & 12 & 10.7214285714286 & 1.27857142857143 \tabularnewline
27 & 19 & 16.7848484848485 & 2.21515151515151 \tabularnewline
28 & 15 & 16.045 & -1.045 \tabularnewline
29 & 14 & 15.2875 & -1.2875 \tabularnewline
30 & 14 & 15.2875 & -1.2875 \tabularnewline
31 & 14.5 & 15.2875 & -0.7875 \tabularnewline
32 & 19 & 16.7848484848485 & 2.21515151515151 \tabularnewline
33 & 19 & 19.6111111111111 & -0.611111111111111 \tabularnewline
34 & 20.5 & 16.7848484848485 & 3.71515151515151 \tabularnewline
35 & 17 & 15.2875 & 1.7125 \tabularnewline
36 & 16.5 & 15.2875 & 1.2125 \tabularnewline
37 & 12 & 12.6461538461538 & -0.646153846153846 \tabularnewline
38 & 13.5 & 13.5877551020408 & -0.0877551020408163 \tabularnewline
39 & 13 & 13.5877551020408 & -0.587755102040816 \tabularnewline
40 & 11 & 10.7214285714286 & 0.278571428571428 \tabularnewline
41 & 13.5 & 13.5877551020408 & -0.0877551020408163 \tabularnewline
42 & 12.5 & 10.7214285714286 & 1.77857142857143 \tabularnewline
43 & 13.5 & 15.2875 & -1.7875 \tabularnewline
44 & 14 & 13.5877551020408 & 0.412244897959184 \tabularnewline
45 & 16 & 13.5877551020408 & 2.41224489795918 \tabularnewline
46 & 14.5 & 13.5877551020408 & 0.912244897959184 \tabularnewline
47 & 18 & 15.2875 & 2.7125 \tabularnewline
48 & 16 & 15.2875 & 0.7125 \tabularnewline
49 & 14.5 & 15.2875 & -0.7875 \tabularnewline
50 & 15 & 15.2875 & -0.2875 \tabularnewline
51 & 13 & 12.6461538461538 & 0.353846153846154 \tabularnewline
52 & 11.5 & 13.5877551020408 & -2.08775510204082 \tabularnewline
53 & 14.5 & 13.5877551020408 & 0.912244897959184 \tabularnewline
54 & 12.5 & 13.5877551020408 & -1.08775510204082 \tabularnewline
55 & 12 & 13.5877551020408 & -1.58775510204082 \tabularnewline
56 & 13 & 13.5877551020408 & -0.587755102040816 \tabularnewline
57 & 11 & 10.7214285714286 & 0.278571428571428 \tabularnewline
58 & 11 & 10.7214285714286 & 0.278571428571428 \tabularnewline
59 & 16.5 & 16.045 & 0.454999999999998 \tabularnewline
60 & 18 & 16.045 & 1.955 \tabularnewline
61 & 16.5 & 18.345 & -1.845 \tabularnewline
62 & 16 & 16.045 & -0.0450000000000017 \tabularnewline
63 & 14 & 13.5877551020408 & 0.412244897959184 \tabularnewline
64 & 12.5 & 12.6461538461538 & -0.146153846153846 \tabularnewline
65 & 15 & 15.2875 & -0.2875 \tabularnewline
66 & 19.5 & 16.7848484848485 & 2.71515151515151 \tabularnewline
67 & 16.5 & 15.2875 & 1.2125 \tabularnewline
68 & 18.5 & 15.2875 & 3.2125 \tabularnewline
69 & 14 & 15.2875 & -1.2875 \tabularnewline
70 & 13 & 13.5877551020408 & -0.587755102040816 \tabularnewline
71 & 9.5 & 10.7214285714286 & -1.22142857142857 \tabularnewline
72 & 15.5 & 15.2875 & 0.2125 \tabularnewline
73 & 14 & 15.2875 & -1.2875 \tabularnewline
74 & 11 & 13.5877551020408 & -2.58775510204082 \tabularnewline
75 & 14 & 15.2875 & -1.2875 \tabularnewline
76 & 11 & 12.6461538461538 & -1.64615384615385 \tabularnewline
77 & 16.5 & 16.045 & 0.454999999999998 \tabularnewline
78 & 16 & 16.045 & -0.0450000000000017 \tabularnewline
79 & 16.5 & 15.2875 & 1.2125 \tabularnewline
80 & 21 & 16.7848484848485 & 4.21515151515151 \tabularnewline
81 & 17 & 18.15 & -1.15 \tabularnewline
82 & 18 & 18.15 & -0.149999999999999 \tabularnewline
83 & 14 & 13.5877551020408 & 0.412244897959184 \tabularnewline
84 & 14.5 & 13.5877551020408 & 0.912244897959184 \tabularnewline
85 & 16 & 13.5877551020408 & 2.41224489795918 \tabularnewline
86 & 15.5 & 13.5877551020408 & 1.91224489795918 \tabularnewline
87 & 15.5 & 16.7848484848485 & -1.28484848484849 \tabularnewline
88 & 14.5 & 15.2875 & -0.7875 \tabularnewline
89 & 19 & 19.6111111111111 & -0.611111111111111 \tabularnewline
90 & 14.5 & 15.2875 & -0.7875 \tabularnewline
91 & 14 & 15.2875 & -1.2875 \tabularnewline
92 & 15 & 15.2875 & -0.2875 \tabularnewline
93 & 16 & 16.7848484848485 & -0.784848484848485 \tabularnewline
94 & 16 & 16.045 & -0.0450000000000017 \tabularnewline
95 & 19.5 & 18.345 & 1.155 \tabularnewline
96 & 11.5 & 10.7214285714286 & 0.778571428571428 \tabularnewline
97 & 14 & 13.5877551020408 & 0.412244897959184 \tabularnewline
98 & 13.5 & 13.5877551020408 & -0.0877551020408163 \tabularnewline
99 & 21 & 18.15 & 2.85 \tabularnewline
100 & 19 & 18.15 & 0.850000000000001 \tabularnewline
101 & 19 & 18.15 & 0.850000000000001 \tabularnewline
102 & 13.5 & 16.045 & -2.545 \tabularnewline
103 & 12 & 13.5877551020408 & -1.58775510204082 \tabularnewline
104 & 17 & 15.2875 & 1.7125 \tabularnewline
105 & 16 & 16.045 & -0.0450000000000017 \tabularnewline
106 & 13.5 & 15.2875 & -1.7875 \tabularnewline
107 & 16.5 & 16.7848484848485 & -0.284848484848485 \tabularnewline
108 & 14.5 & 16.045 & -1.545 \tabularnewline
109 & 15 & 15.2875 & -0.2875 \tabularnewline
110 & 17 & 18.345 & -1.345 \tabularnewline
111 & 13.5 & 13.5877551020408 & -0.0877551020408163 \tabularnewline
112 & 17.5 & 19.6111111111111 & -2.11111111111111 \tabularnewline
113 & 16.9 & 15.2875 & 1.6125 \tabularnewline
114 & 14.9 & 15.2875 & -0.387499999999999 \tabularnewline
115 & 15.3 & 15.2875 & 0.0125000000000011 \tabularnewline
116 & 13 & 13.5877551020408 & -0.587755102040816 \tabularnewline
117 & 13.9 & 13.5877551020408 & 0.312244897959184 \tabularnewline
118 & 12.8 & 13.5877551020408 & -0.787755102040816 \tabularnewline
119 & 14.5 & 16.045 & -1.545 \tabularnewline
120 & 17.6 & 18.345 & -0.744999999999997 \tabularnewline
121 & 22.2 & 19.6111111111111 & 2.58888888888889 \tabularnewline
122 & 22.1 & 19.6111111111111 & 2.48888888888889 \tabularnewline
123 & 17.7 & 18.15 & -0.449999999999999 \tabularnewline
124 & 16.2 & 18.15 & -1.95 \tabularnewline
125 & 17.8 & 16.045 & 1.755 \tabularnewline
126 & 17 & 16.7848484848485 & 0.215151515151515 \tabularnewline
127 & 16.4 & 15.2875 & 1.1125 \tabularnewline
128 & 15.7 & 16.045 & -0.345000000000002 \tabularnewline
129 & 13.2 & 13.5877551020408 & -0.387755102040817 \tabularnewline
130 & 16.7 & 13.5877551020408 & 3.11224489795918 \tabularnewline
131 & 12.1 & 12.6461538461538 & -0.546153846153846 \tabularnewline
132 & 15 & 13.5877551020408 & 1.41224489795918 \tabularnewline
133 & 14 & 13.5877551020408 & 0.412244897959184 \tabularnewline
134 & 14.8 & 15.2875 & -0.487499999999999 \tabularnewline
135 & 18.6 & 19.6111111111111 & -1.01111111111111 \tabularnewline
136 & 16.8 & 16.7848484848485 & 0.0151515151515156 \tabularnewline
137 & 12.5 & 13.5877551020408 & -1.08775510204082 \tabularnewline
138 & 13.7 & 13.5877551020408 & 0.112244897959183 \tabularnewline
139 & 16.9 & 16.045 & 0.854999999999997 \tabularnewline
140 & 17.7 & 18.15 & -0.449999999999999 \tabularnewline
141 & 11.1 & 10.7214285714286 & 0.378571428571428 \tabularnewline
142 & 11.4 & 12.6461538461538 & -1.24615384615385 \tabularnewline
143 & 14.5 & 13.5877551020408 & 0.912244897959184 \tabularnewline
144 & 14.5 & 15.2875 & -0.7875 \tabularnewline
145 & 18.2 & 15.2875 & 2.9125 \tabularnewline
146 & 15.8 & 15.2875 & 0.512500000000001 \tabularnewline
147 & 15.9 & 15.2875 & 0.612500000000001 \tabularnewline
148 & 16.4 & 16.7848484848485 & -0.384848484848487 \tabularnewline
149 & 14.5 & 15.2875 & -0.7875 \tabularnewline
150 & 12.8 & 15.2875 & -2.4875 \tabularnewline
151 & 21.5 & 19.6111111111111 & 1.88888888888889 \tabularnewline
152 & 14.4 & 16.7848484848485 & -2.38484848484848 \tabularnewline
153 & 18.6 & 16.7848484848485 & 1.81515151515152 \tabularnewline
154 & 13.2 & 13.5877551020408 & -0.387755102040817 \tabularnewline
155 & 12.8 & 13.5877551020408 & -0.787755102040816 \tabularnewline
156 & 18.2 & 16.045 & 2.155 \tabularnewline
157 & 15.8 & 18.345 & -2.545 \tabularnewline
158 & 17.2 & 18.15 & -0.949999999999999 \tabularnewline
159 & 17.2 & 18.345 & -1.145 \tabularnewline
160 & 16.7 & 18.345 & -1.645 \tabularnewline
161 & 18.7 & 18.15 & 0.550000000000001 \tabularnewline
162 & 13.2 & 13.5877551020408 & -0.387755102040817 \tabularnewline
163 & 13.4 & 12.6461538461538 & 0.753846153846155 \tabularnewline
164 & 13.7 & 13.5877551020408 & 0.112244897959183 \tabularnewline
165 & 16.5 & 16.7848484848485 & -0.284848484848485 \tabularnewline
166 & 14.7 & 15.2875 & -0.5875 \tabularnewline
167 & 14.5 & 15.2875 & -0.7875 \tabularnewline
168 & 17.6 & 18.345 & -0.744999999999997 \tabularnewline
169 & 15.9 & 15.2875 & 0.612500000000001 \tabularnewline
170 & 13.6 & 13.5877551020408 & 0.0122448979591834 \tabularnewline
171 & 15.8 & 13.5877551020408 & 2.21224489795918 \tabularnewline
172 & 14.9 & 16.7848484848485 & -1.88484848484848 \tabularnewline
173 & 16.6 & 16.7848484848485 & -0.184848484848484 \tabularnewline
174 & 18.2 & 18.345 & -0.145 \tabularnewline
175 & 17.3 & 18.345 & -1.045 \tabularnewline
176 & 16.6 & 16.045 & 0.555 \tabularnewline
177 & 15.4 & 13.5877551020408 & 1.81224489795918 \tabularnewline
178 & 13.2 & 13.5877551020408 & -0.387755102040817 \tabularnewline
179 & 15.2 & 13.5877551020408 & 1.61224489795918 \tabularnewline
180 & 14.3 & 13.5877551020408 & 0.712244897959184 \tabularnewline
181 & 15 & 13.5877551020408 & 1.41224489795918 \tabularnewline
182 & 14 & 16.7848484848485 & -2.78484848484849 \tabularnewline
183 & 15.2 & 16.7848484848485 & -1.58484848484849 \tabularnewline
184 & 15 & 15.2875 & -0.2875 \tabularnewline
185 & 24.8 & 18.345 & 6.455 \tabularnewline
186 & 22.2 & 18.345 & 3.855 \tabularnewline
187 & 14.9 & 16.7848484848485 & -1.88484848484848 \tabularnewline
188 & 19.2 & 16.7848484848485 & 2.41515151515151 \tabularnewline
189 & 16 & 15.2875 & 0.7125 \tabularnewline
190 & 11.3 & 13.5877551020408 & -2.28775510204082 \tabularnewline
191 & 13.2 & 15.2875 & -2.0875 \tabularnewline
192 & 14.7 & 15.2875 & -0.5875 \tabularnewline
193 & 15.5 & 16.7848484848485 & -1.28484848484849 \tabularnewline
194 & 16.4 & 16.7848484848485 & -0.384848484848487 \tabularnewline
195 & 18.1 & 18.345 & -0.244999999999997 \tabularnewline
196 & 20.1 & 18.345 & 1.755 \tabularnewline
197 & 15.8 & 15.2875 & 0.512500000000001 \tabularnewline
198 & 15.5 & 15.2875 & 0.2125 \tabularnewline
199 & 15 & 15.2875 & -0.2875 \tabularnewline
200 & 15.2 & 15.2875 & -0.0875000000000004 \tabularnewline
201 & 14.4 & 15.2875 & -0.887499999999999 \tabularnewline
202 & 19.2 & 16.7848484848485 & 2.41515151515151 \tabularnewline
203 & 19.9 & 18.345 & 1.555 \tabularnewline
204 & 13.8 & 16.7848484848485 & -2.98484848484848 \tabularnewline
205 & 15.3 & 16.7848484848485 & -1.48484848484848 \tabularnewline
206 & 15.1 & 15.2875 & -0.1875 \tabularnewline
207 & 15.7 & 15.2875 & 0.4125 \tabularnewline
208 & 16.4 & 15.2875 & 1.1125 \tabularnewline
209 & 12.6 & 15.2875 & -2.6875 \tabularnewline
210 & 12.9 & 15.2875 & -2.3875 \tabularnewline
211 & 16.4 & 16.7848484848485 & -0.384848484848487 \tabularnewline
212 & 16.1 & 19.6111111111111 & -3.51111111111111 \tabularnewline
213 & 19.4 & 16.7848484848485 & 2.61515151515151 \tabularnewline
214 & 17.3 & 16.7848484848485 & 0.515151515151516 \tabularnewline
215 & 14.9 & 16.7848484848485 & -1.88484848484848 \tabularnewline
216 & 16.2 & 16.7848484848485 & -0.584848484848486 \tabularnewline
217 & 14.2 & 15.2875 & -1.0875 \tabularnewline
218 & 14.8 & 15.2875 & -0.487499999999999 \tabularnewline
219 & 20.4 & 18.345 & 2.055 \tabularnewline
220 & 13.8 & 13.5877551020408 & 0.212244897959184 \tabularnewline
221 & 15.8 & 16.045 & -0.245000000000001 \tabularnewline
222 & 17.1 & 18.345 & -1.245 \tabularnewline
223 & 16.6 & 18.345 & -1.745 \tabularnewline
224 & 18.6 & 15.2875 & 3.3125 \tabularnewline
225 & 18 & 15.2875 & 2.7125 \tabularnewline
226 & 16 & 15.2875 & 0.7125 \tabularnewline
227 & 18 & 15.2875 & 2.7125 \tabularnewline
228 & 15.3 & 15.2875 & 0.0125000000000011 \tabularnewline
229 & 17.6 & 16.7848484848485 & 0.815151515151516 \tabularnewline
230 & 14.7 & 16.7848484848485 & -2.08484848484849 \tabularnewline
231 & 14.5 & 15.2875 & -0.7875 \tabularnewline
232 & 14.5 & 15.2875 & -0.7875 \tabularnewline
233 & 15.7 & 16.7848484848485 & -1.08484848484849 \tabularnewline
234 & 16.4 & 16.045 & 0.354999999999997 \tabularnewline
235 & 17 & 18.345 & -1.345 \tabularnewline
236 & 13.9 & 15.2875 & -1.3875 \tabularnewline
237 & 17.3 & 18.345 & -1.045 \tabularnewline
238 & 15.6 & 15.2875 & 0.3125 \tabularnewline
239 & 11.6 & 15.2875 & -3.6875 \tabularnewline
240 & 18.6 & 15.2875 & 3.3125 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=153913&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]11.5[/C][C]12.6461538461538[/C][C]-1.14615384615385[/C][/ROW]
[ROW][C]2[/C][C]11[/C][C]13.5877551020408[/C][C]-2.58775510204082[/C][/ROW]
[ROW][C]3[/C][C]10.5[/C][C]13.5877551020408[/C][C]-3.08775510204082[/C][/ROW]
[ROW][C]4[/C][C]10[/C][C]10.7214285714286[/C][C]-0.721428571428572[/C][/ROW]
[ROW][C]5[/C][C]8.5[/C][C]10.7214285714286[/C][C]-2.22142857142857[/C][/ROW]
[ROW][C]6[/C][C]10[/C][C]10.7214285714286[/C][C]-0.721428571428572[/C][/ROW]
[ROW][C]7[/C][C]10[/C][C]10.7214285714286[/C][C]-0.721428571428572[/C][/ROW]
[ROW][C]8[/C][C]8[/C][C]12.6461538461538[/C][C]-4.64615384615385[/C][/ROW]
[ROW][C]9[/C][C]10[/C][C]10.7214285714286[/C][C]-0.721428571428572[/C][/ROW]
[ROW][C]10[/C][C]15[/C][C]15.2875[/C][C]-0.2875[/C][/ROW]
[ROW][C]11[/C][C]15.5[/C][C]15.2875[/C][C]0.2125[/C][/ROW]
[ROW][C]12[/C][C]20.5[/C][C]19.6111111111111[/C][C]0.888888888888889[/C][/ROW]
[ROW][C]13[/C][C]17.5[/C][C]15.2875[/C][C]2.2125[/C][/ROW]
[ROW][C]14[/C][C]17.5[/C][C]15.2875[/C][C]2.2125[/C][/ROW]
[ROW][C]15[/C][C]12.5[/C][C]13.5877551020408[/C][C]-1.08775510204082[/C][/ROW]
[ROW][C]16[/C][C]14[/C][C]12.6461538461538[/C][C]1.35384615384615[/C][/ROW]
[ROW][C]17[/C][C]15[/C][C]12.6461538461538[/C][C]2.35384615384615[/C][/ROW]
[ROW][C]18[/C][C]18.5[/C][C]12.6461538461538[/C][C]5.85384615384615[/C][/ROW]
[ROW][C]19[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]20[/C][C]14[/C][C]15.2875[/C][C]-1.2875[/C][/ROW]
[ROW][C]21[/C][C]15.5[/C][C]16.045[/C][C]-0.545000000000002[/C][/ROW]
[ROW][C]22[/C][C]15.5[/C][C]16.045[/C][C]-0.545000000000002[/C][/ROW]
[ROW][C]23[/C][C]12[/C][C]12.6461538461538[/C][C]-0.646153846153846[/C][/ROW]
[ROW][C]24[/C][C]13[/C][C]13.5877551020408[/C][C]-0.587755102040816[/C][/ROW]
[ROW][C]25[/C][C]12[/C][C]10.7214285714286[/C][C]1.27857142857143[/C][/ROW]
[ROW][C]26[/C][C]12[/C][C]10.7214285714286[/C][C]1.27857142857143[/C][/ROW]
[ROW][C]27[/C][C]19[/C][C]16.7848484848485[/C][C]2.21515151515151[/C][/ROW]
[ROW][C]28[/C][C]15[/C][C]16.045[/C][C]-1.045[/C][/ROW]
[ROW][C]29[/C][C]14[/C][C]15.2875[/C][C]-1.2875[/C][/ROW]
[ROW][C]30[/C][C]14[/C][C]15.2875[/C][C]-1.2875[/C][/ROW]
[ROW][C]31[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]32[/C][C]19[/C][C]16.7848484848485[/C][C]2.21515151515151[/C][/ROW]
[ROW][C]33[/C][C]19[/C][C]19.6111111111111[/C][C]-0.611111111111111[/C][/ROW]
[ROW][C]34[/C][C]20.5[/C][C]16.7848484848485[/C][C]3.71515151515151[/C][/ROW]
[ROW][C]35[/C][C]17[/C][C]15.2875[/C][C]1.7125[/C][/ROW]
[ROW][C]36[/C][C]16.5[/C][C]15.2875[/C][C]1.2125[/C][/ROW]
[ROW][C]37[/C][C]12[/C][C]12.6461538461538[/C][C]-0.646153846153846[/C][/ROW]
[ROW][C]38[/C][C]13.5[/C][C]13.5877551020408[/C][C]-0.0877551020408163[/C][/ROW]
[ROW][C]39[/C][C]13[/C][C]13.5877551020408[/C][C]-0.587755102040816[/C][/ROW]
[ROW][C]40[/C][C]11[/C][C]10.7214285714286[/C][C]0.278571428571428[/C][/ROW]
[ROW][C]41[/C][C]13.5[/C][C]13.5877551020408[/C][C]-0.0877551020408163[/C][/ROW]
[ROW][C]42[/C][C]12.5[/C][C]10.7214285714286[/C][C]1.77857142857143[/C][/ROW]
[ROW][C]43[/C][C]13.5[/C][C]15.2875[/C][C]-1.7875[/C][/ROW]
[ROW][C]44[/C][C]14[/C][C]13.5877551020408[/C][C]0.412244897959184[/C][/ROW]
[ROW][C]45[/C][C]16[/C][C]13.5877551020408[/C][C]2.41224489795918[/C][/ROW]
[ROW][C]46[/C][C]14.5[/C][C]13.5877551020408[/C][C]0.912244897959184[/C][/ROW]
[ROW][C]47[/C][C]18[/C][C]15.2875[/C][C]2.7125[/C][/ROW]
[ROW][C]48[/C][C]16[/C][C]15.2875[/C][C]0.7125[/C][/ROW]
[ROW][C]49[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]50[/C][C]15[/C][C]15.2875[/C][C]-0.2875[/C][/ROW]
[ROW][C]51[/C][C]13[/C][C]12.6461538461538[/C][C]0.353846153846154[/C][/ROW]
[ROW][C]52[/C][C]11.5[/C][C]13.5877551020408[/C][C]-2.08775510204082[/C][/ROW]
[ROW][C]53[/C][C]14.5[/C][C]13.5877551020408[/C][C]0.912244897959184[/C][/ROW]
[ROW][C]54[/C][C]12.5[/C][C]13.5877551020408[/C][C]-1.08775510204082[/C][/ROW]
[ROW][C]55[/C][C]12[/C][C]13.5877551020408[/C][C]-1.58775510204082[/C][/ROW]
[ROW][C]56[/C][C]13[/C][C]13.5877551020408[/C][C]-0.587755102040816[/C][/ROW]
[ROW][C]57[/C][C]11[/C][C]10.7214285714286[/C][C]0.278571428571428[/C][/ROW]
[ROW][C]58[/C][C]11[/C][C]10.7214285714286[/C][C]0.278571428571428[/C][/ROW]
[ROW][C]59[/C][C]16.5[/C][C]16.045[/C][C]0.454999999999998[/C][/ROW]
[ROW][C]60[/C][C]18[/C][C]16.045[/C][C]1.955[/C][/ROW]
[ROW][C]61[/C][C]16.5[/C][C]18.345[/C][C]-1.845[/C][/ROW]
[ROW][C]62[/C][C]16[/C][C]16.045[/C][C]-0.0450000000000017[/C][/ROW]
[ROW][C]63[/C][C]14[/C][C]13.5877551020408[/C][C]0.412244897959184[/C][/ROW]
[ROW][C]64[/C][C]12.5[/C][C]12.6461538461538[/C][C]-0.146153846153846[/C][/ROW]
[ROW][C]65[/C][C]15[/C][C]15.2875[/C][C]-0.2875[/C][/ROW]
[ROW][C]66[/C][C]19.5[/C][C]16.7848484848485[/C][C]2.71515151515151[/C][/ROW]
[ROW][C]67[/C][C]16.5[/C][C]15.2875[/C][C]1.2125[/C][/ROW]
[ROW][C]68[/C][C]18.5[/C][C]15.2875[/C][C]3.2125[/C][/ROW]
[ROW][C]69[/C][C]14[/C][C]15.2875[/C][C]-1.2875[/C][/ROW]
[ROW][C]70[/C][C]13[/C][C]13.5877551020408[/C][C]-0.587755102040816[/C][/ROW]
[ROW][C]71[/C][C]9.5[/C][C]10.7214285714286[/C][C]-1.22142857142857[/C][/ROW]
[ROW][C]72[/C][C]15.5[/C][C]15.2875[/C][C]0.2125[/C][/ROW]
[ROW][C]73[/C][C]14[/C][C]15.2875[/C][C]-1.2875[/C][/ROW]
[ROW][C]74[/C][C]11[/C][C]13.5877551020408[/C][C]-2.58775510204082[/C][/ROW]
[ROW][C]75[/C][C]14[/C][C]15.2875[/C][C]-1.2875[/C][/ROW]
[ROW][C]76[/C][C]11[/C][C]12.6461538461538[/C][C]-1.64615384615385[/C][/ROW]
[ROW][C]77[/C][C]16.5[/C][C]16.045[/C][C]0.454999999999998[/C][/ROW]
[ROW][C]78[/C][C]16[/C][C]16.045[/C][C]-0.0450000000000017[/C][/ROW]
[ROW][C]79[/C][C]16.5[/C][C]15.2875[/C][C]1.2125[/C][/ROW]
[ROW][C]80[/C][C]21[/C][C]16.7848484848485[/C][C]4.21515151515151[/C][/ROW]
[ROW][C]81[/C][C]17[/C][C]18.15[/C][C]-1.15[/C][/ROW]
[ROW][C]82[/C][C]18[/C][C]18.15[/C][C]-0.149999999999999[/C][/ROW]
[ROW][C]83[/C][C]14[/C][C]13.5877551020408[/C][C]0.412244897959184[/C][/ROW]
[ROW][C]84[/C][C]14.5[/C][C]13.5877551020408[/C][C]0.912244897959184[/C][/ROW]
[ROW][C]85[/C][C]16[/C][C]13.5877551020408[/C][C]2.41224489795918[/C][/ROW]
[ROW][C]86[/C][C]15.5[/C][C]13.5877551020408[/C][C]1.91224489795918[/C][/ROW]
[ROW][C]87[/C][C]15.5[/C][C]16.7848484848485[/C][C]-1.28484848484849[/C][/ROW]
[ROW][C]88[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]89[/C][C]19[/C][C]19.6111111111111[/C][C]-0.611111111111111[/C][/ROW]
[ROW][C]90[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]91[/C][C]14[/C][C]15.2875[/C][C]-1.2875[/C][/ROW]
[ROW][C]92[/C][C]15[/C][C]15.2875[/C][C]-0.2875[/C][/ROW]
[ROW][C]93[/C][C]16[/C][C]16.7848484848485[/C][C]-0.784848484848485[/C][/ROW]
[ROW][C]94[/C][C]16[/C][C]16.045[/C][C]-0.0450000000000017[/C][/ROW]
[ROW][C]95[/C][C]19.5[/C][C]18.345[/C][C]1.155[/C][/ROW]
[ROW][C]96[/C][C]11.5[/C][C]10.7214285714286[/C][C]0.778571428571428[/C][/ROW]
[ROW][C]97[/C][C]14[/C][C]13.5877551020408[/C][C]0.412244897959184[/C][/ROW]
[ROW][C]98[/C][C]13.5[/C][C]13.5877551020408[/C][C]-0.0877551020408163[/C][/ROW]
[ROW][C]99[/C][C]21[/C][C]18.15[/C][C]2.85[/C][/ROW]
[ROW][C]100[/C][C]19[/C][C]18.15[/C][C]0.850000000000001[/C][/ROW]
[ROW][C]101[/C][C]19[/C][C]18.15[/C][C]0.850000000000001[/C][/ROW]
[ROW][C]102[/C][C]13.5[/C][C]16.045[/C][C]-2.545[/C][/ROW]
[ROW][C]103[/C][C]12[/C][C]13.5877551020408[/C][C]-1.58775510204082[/C][/ROW]
[ROW][C]104[/C][C]17[/C][C]15.2875[/C][C]1.7125[/C][/ROW]
[ROW][C]105[/C][C]16[/C][C]16.045[/C][C]-0.0450000000000017[/C][/ROW]
[ROW][C]106[/C][C]13.5[/C][C]15.2875[/C][C]-1.7875[/C][/ROW]
[ROW][C]107[/C][C]16.5[/C][C]16.7848484848485[/C][C]-0.284848484848485[/C][/ROW]
[ROW][C]108[/C][C]14.5[/C][C]16.045[/C][C]-1.545[/C][/ROW]
[ROW][C]109[/C][C]15[/C][C]15.2875[/C][C]-0.2875[/C][/ROW]
[ROW][C]110[/C][C]17[/C][C]18.345[/C][C]-1.345[/C][/ROW]
[ROW][C]111[/C][C]13.5[/C][C]13.5877551020408[/C][C]-0.0877551020408163[/C][/ROW]
[ROW][C]112[/C][C]17.5[/C][C]19.6111111111111[/C][C]-2.11111111111111[/C][/ROW]
[ROW][C]113[/C][C]16.9[/C][C]15.2875[/C][C]1.6125[/C][/ROW]
[ROW][C]114[/C][C]14.9[/C][C]15.2875[/C][C]-0.387499999999999[/C][/ROW]
[ROW][C]115[/C][C]15.3[/C][C]15.2875[/C][C]0.0125000000000011[/C][/ROW]
[ROW][C]116[/C][C]13[/C][C]13.5877551020408[/C][C]-0.587755102040816[/C][/ROW]
[ROW][C]117[/C][C]13.9[/C][C]13.5877551020408[/C][C]0.312244897959184[/C][/ROW]
[ROW][C]118[/C][C]12.8[/C][C]13.5877551020408[/C][C]-0.787755102040816[/C][/ROW]
[ROW][C]119[/C][C]14.5[/C][C]16.045[/C][C]-1.545[/C][/ROW]
[ROW][C]120[/C][C]17.6[/C][C]18.345[/C][C]-0.744999999999997[/C][/ROW]
[ROW][C]121[/C][C]22.2[/C][C]19.6111111111111[/C][C]2.58888888888889[/C][/ROW]
[ROW][C]122[/C][C]22.1[/C][C]19.6111111111111[/C][C]2.48888888888889[/C][/ROW]
[ROW][C]123[/C][C]17.7[/C][C]18.15[/C][C]-0.449999999999999[/C][/ROW]
[ROW][C]124[/C][C]16.2[/C][C]18.15[/C][C]-1.95[/C][/ROW]
[ROW][C]125[/C][C]17.8[/C][C]16.045[/C][C]1.755[/C][/ROW]
[ROW][C]126[/C][C]17[/C][C]16.7848484848485[/C][C]0.215151515151515[/C][/ROW]
[ROW][C]127[/C][C]16.4[/C][C]15.2875[/C][C]1.1125[/C][/ROW]
[ROW][C]128[/C][C]15.7[/C][C]16.045[/C][C]-0.345000000000002[/C][/ROW]
[ROW][C]129[/C][C]13.2[/C][C]13.5877551020408[/C][C]-0.387755102040817[/C][/ROW]
[ROW][C]130[/C][C]16.7[/C][C]13.5877551020408[/C][C]3.11224489795918[/C][/ROW]
[ROW][C]131[/C][C]12.1[/C][C]12.6461538461538[/C][C]-0.546153846153846[/C][/ROW]
[ROW][C]132[/C][C]15[/C][C]13.5877551020408[/C][C]1.41224489795918[/C][/ROW]
[ROW][C]133[/C][C]14[/C][C]13.5877551020408[/C][C]0.412244897959184[/C][/ROW]
[ROW][C]134[/C][C]14.8[/C][C]15.2875[/C][C]-0.487499999999999[/C][/ROW]
[ROW][C]135[/C][C]18.6[/C][C]19.6111111111111[/C][C]-1.01111111111111[/C][/ROW]
[ROW][C]136[/C][C]16.8[/C][C]16.7848484848485[/C][C]0.0151515151515156[/C][/ROW]
[ROW][C]137[/C][C]12.5[/C][C]13.5877551020408[/C][C]-1.08775510204082[/C][/ROW]
[ROW][C]138[/C][C]13.7[/C][C]13.5877551020408[/C][C]0.112244897959183[/C][/ROW]
[ROW][C]139[/C][C]16.9[/C][C]16.045[/C][C]0.854999999999997[/C][/ROW]
[ROW][C]140[/C][C]17.7[/C][C]18.15[/C][C]-0.449999999999999[/C][/ROW]
[ROW][C]141[/C][C]11.1[/C][C]10.7214285714286[/C][C]0.378571428571428[/C][/ROW]
[ROW][C]142[/C][C]11.4[/C][C]12.6461538461538[/C][C]-1.24615384615385[/C][/ROW]
[ROW][C]143[/C][C]14.5[/C][C]13.5877551020408[/C][C]0.912244897959184[/C][/ROW]
[ROW][C]144[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]145[/C][C]18.2[/C][C]15.2875[/C][C]2.9125[/C][/ROW]
[ROW][C]146[/C][C]15.8[/C][C]15.2875[/C][C]0.512500000000001[/C][/ROW]
[ROW][C]147[/C][C]15.9[/C][C]15.2875[/C][C]0.612500000000001[/C][/ROW]
[ROW][C]148[/C][C]16.4[/C][C]16.7848484848485[/C][C]-0.384848484848487[/C][/ROW]
[ROW][C]149[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]150[/C][C]12.8[/C][C]15.2875[/C][C]-2.4875[/C][/ROW]
[ROW][C]151[/C][C]21.5[/C][C]19.6111111111111[/C][C]1.88888888888889[/C][/ROW]
[ROW][C]152[/C][C]14.4[/C][C]16.7848484848485[/C][C]-2.38484848484848[/C][/ROW]
[ROW][C]153[/C][C]18.6[/C][C]16.7848484848485[/C][C]1.81515151515152[/C][/ROW]
[ROW][C]154[/C][C]13.2[/C][C]13.5877551020408[/C][C]-0.387755102040817[/C][/ROW]
[ROW][C]155[/C][C]12.8[/C][C]13.5877551020408[/C][C]-0.787755102040816[/C][/ROW]
[ROW][C]156[/C][C]18.2[/C][C]16.045[/C][C]2.155[/C][/ROW]
[ROW][C]157[/C][C]15.8[/C][C]18.345[/C][C]-2.545[/C][/ROW]
[ROW][C]158[/C][C]17.2[/C][C]18.15[/C][C]-0.949999999999999[/C][/ROW]
[ROW][C]159[/C][C]17.2[/C][C]18.345[/C][C]-1.145[/C][/ROW]
[ROW][C]160[/C][C]16.7[/C][C]18.345[/C][C]-1.645[/C][/ROW]
[ROW][C]161[/C][C]18.7[/C][C]18.15[/C][C]0.550000000000001[/C][/ROW]
[ROW][C]162[/C][C]13.2[/C][C]13.5877551020408[/C][C]-0.387755102040817[/C][/ROW]
[ROW][C]163[/C][C]13.4[/C][C]12.6461538461538[/C][C]0.753846153846155[/C][/ROW]
[ROW][C]164[/C][C]13.7[/C][C]13.5877551020408[/C][C]0.112244897959183[/C][/ROW]
[ROW][C]165[/C][C]16.5[/C][C]16.7848484848485[/C][C]-0.284848484848485[/C][/ROW]
[ROW][C]166[/C][C]14.7[/C][C]15.2875[/C][C]-0.5875[/C][/ROW]
[ROW][C]167[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]168[/C][C]17.6[/C][C]18.345[/C][C]-0.744999999999997[/C][/ROW]
[ROW][C]169[/C][C]15.9[/C][C]15.2875[/C][C]0.612500000000001[/C][/ROW]
[ROW][C]170[/C][C]13.6[/C][C]13.5877551020408[/C][C]0.0122448979591834[/C][/ROW]
[ROW][C]171[/C][C]15.8[/C][C]13.5877551020408[/C][C]2.21224489795918[/C][/ROW]
[ROW][C]172[/C][C]14.9[/C][C]16.7848484848485[/C][C]-1.88484848484848[/C][/ROW]
[ROW][C]173[/C][C]16.6[/C][C]16.7848484848485[/C][C]-0.184848484848484[/C][/ROW]
[ROW][C]174[/C][C]18.2[/C][C]18.345[/C][C]-0.145[/C][/ROW]
[ROW][C]175[/C][C]17.3[/C][C]18.345[/C][C]-1.045[/C][/ROW]
[ROW][C]176[/C][C]16.6[/C][C]16.045[/C][C]0.555[/C][/ROW]
[ROW][C]177[/C][C]15.4[/C][C]13.5877551020408[/C][C]1.81224489795918[/C][/ROW]
[ROW][C]178[/C][C]13.2[/C][C]13.5877551020408[/C][C]-0.387755102040817[/C][/ROW]
[ROW][C]179[/C][C]15.2[/C][C]13.5877551020408[/C][C]1.61224489795918[/C][/ROW]
[ROW][C]180[/C][C]14.3[/C][C]13.5877551020408[/C][C]0.712244897959184[/C][/ROW]
[ROW][C]181[/C][C]15[/C][C]13.5877551020408[/C][C]1.41224489795918[/C][/ROW]
[ROW][C]182[/C][C]14[/C][C]16.7848484848485[/C][C]-2.78484848484849[/C][/ROW]
[ROW][C]183[/C][C]15.2[/C][C]16.7848484848485[/C][C]-1.58484848484849[/C][/ROW]
[ROW][C]184[/C][C]15[/C][C]15.2875[/C][C]-0.2875[/C][/ROW]
[ROW][C]185[/C][C]24.8[/C][C]18.345[/C][C]6.455[/C][/ROW]
[ROW][C]186[/C][C]22.2[/C][C]18.345[/C][C]3.855[/C][/ROW]
[ROW][C]187[/C][C]14.9[/C][C]16.7848484848485[/C][C]-1.88484848484848[/C][/ROW]
[ROW][C]188[/C][C]19.2[/C][C]16.7848484848485[/C][C]2.41515151515151[/C][/ROW]
[ROW][C]189[/C][C]16[/C][C]15.2875[/C][C]0.7125[/C][/ROW]
[ROW][C]190[/C][C]11.3[/C][C]13.5877551020408[/C][C]-2.28775510204082[/C][/ROW]
[ROW][C]191[/C][C]13.2[/C][C]15.2875[/C][C]-2.0875[/C][/ROW]
[ROW][C]192[/C][C]14.7[/C][C]15.2875[/C][C]-0.5875[/C][/ROW]
[ROW][C]193[/C][C]15.5[/C][C]16.7848484848485[/C][C]-1.28484848484849[/C][/ROW]
[ROW][C]194[/C][C]16.4[/C][C]16.7848484848485[/C][C]-0.384848484848487[/C][/ROW]
[ROW][C]195[/C][C]18.1[/C][C]18.345[/C][C]-0.244999999999997[/C][/ROW]
[ROW][C]196[/C][C]20.1[/C][C]18.345[/C][C]1.755[/C][/ROW]
[ROW][C]197[/C][C]15.8[/C][C]15.2875[/C][C]0.512500000000001[/C][/ROW]
[ROW][C]198[/C][C]15.5[/C][C]15.2875[/C][C]0.2125[/C][/ROW]
[ROW][C]199[/C][C]15[/C][C]15.2875[/C][C]-0.2875[/C][/ROW]
[ROW][C]200[/C][C]15.2[/C][C]15.2875[/C][C]-0.0875000000000004[/C][/ROW]
[ROW][C]201[/C][C]14.4[/C][C]15.2875[/C][C]-0.887499999999999[/C][/ROW]
[ROW][C]202[/C][C]19.2[/C][C]16.7848484848485[/C][C]2.41515151515151[/C][/ROW]
[ROW][C]203[/C][C]19.9[/C][C]18.345[/C][C]1.555[/C][/ROW]
[ROW][C]204[/C][C]13.8[/C][C]16.7848484848485[/C][C]-2.98484848484848[/C][/ROW]
[ROW][C]205[/C][C]15.3[/C][C]16.7848484848485[/C][C]-1.48484848484848[/C][/ROW]
[ROW][C]206[/C][C]15.1[/C][C]15.2875[/C][C]-0.1875[/C][/ROW]
[ROW][C]207[/C][C]15.7[/C][C]15.2875[/C][C]0.4125[/C][/ROW]
[ROW][C]208[/C][C]16.4[/C][C]15.2875[/C][C]1.1125[/C][/ROW]
[ROW][C]209[/C][C]12.6[/C][C]15.2875[/C][C]-2.6875[/C][/ROW]
[ROW][C]210[/C][C]12.9[/C][C]15.2875[/C][C]-2.3875[/C][/ROW]
[ROW][C]211[/C][C]16.4[/C][C]16.7848484848485[/C][C]-0.384848484848487[/C][/ROW]
[ROW][C]212[/C][C]16.1[/C][C]19.6111111111111[/C][C]-3.51111111111111[/C][/ROW]
[ROW][C]213[/C][C]19.4[/C][C]16.7848484848485[/C][C]2.61515151515151[/C][/ROW]
[ROW][C]214[/C][C]17.3[/C][C]16.7848484848485[/C][C]0.515151515151516[/C][/ROW]
[ROW][C]215[/C][C]14.9[/C][C]16.7848484848485[/C][C]-1.88484848484848[/C][/ROW]
[ROW][C]216[/C][C]16.2[/C][C]16.7848484848485[/C][C]-0.584848484848486[/C][/ROW]
[ROW][C]217[/C][C]14.2[/C][C]15.2875[/C][C]-1.0875[/C][/ROW]
[ROW][C]218[/C][C]14.8[/C][C]15.2875[/C][C]-0.487499999999999[/C][/ROW]
[ROW][C]219[/C][C]20.4[/C][C]18.345[/C][C]2.055[/C][/ROW]
[ROW][C]220[/C][C]13.8[/C][C]13.5877551020408[/C][C]0.212244897959184[/C][/ROW]
[ROW][C]221[/C][C]15.8[/C][C]16.045[/C][C]-0.245000000000001[/C][/ROW]
[ROW][C]222[/C][C]17.1[/C][C]18.345[/C][C]-1.245[/C][/ROW]
[ROW][C]223[/C][C]16.6[/C][C]18.345[/C][C]-1.745[/C][/ROW]
[ROW][C]224[/C][C]18.6[/C][C]15.2875[/C][C]3.3125[/C][/ROW]
[ROW][C]225[/C][C]18[/C][C]15.2875[/C][C]2.7125[/C][/ROW]
[ROW][C]226[/C][C]16[/C][C]15.2875[/C][C]0.7125[/C][/ROW]
[ROW][C]227[/C][C]18[/C][C]15.2875[/C][C]2.7125[/C][/ROW]
[ROW][C]228[/C][C]15.3[/C][C]15.2875[/C][C]0.0125000000000011[/C][/ROW]
[ROW][C]229[/C][C]17.6[/C][C]16.7848484848485[/C][C]0.815151515151516[/C][/ROW]
[ROW][C]230[/C][C]14.7[/C][C]16.7848484848485[/C][C]-2.08484848484849[/C][/ROW]
[ROW][C]231[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]232[/C][C]14.5[/C][C]15.2875[/C][C]-0.7875[/C][/ROW]
[ROW][C]233[/C][C]15.7[/C][C]16.7848484848485[/C][C]-1.08484848484849[/C][/ROW]
[ROW][C]234[/C][C]16.4[/C][C]16.045[/C][C]0.354999999999997[/C][/ROW]
[ROW][C]235[/C][C]17[/C][C]18.345[/C][C]-1.345[/C][/ROW]
[ROW][C]236[/C][C]13.9[/C][C]15.2875[/C][C]-1.3875[/C][/ROW]
[ROW][C]237[/C][C]17.3[/C][C]18.345[/C][C]-1.045[/C][/ROW]
[ROW][C]238[/C][C]15.6[/C][C]15.2875[/C][C]0.3125[/C][/ROW]
[ROW][C]239[/C][C]11.6[/C][C]15.2875[/C][C]-3.6875[/C][/ROW]
[ROW][C]240[/C][C]18.6[/C][C]15.2875[/C][C]3.3125[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=153913&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=153913&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
111.512.6461538461538-1.14615384615385
21113.5877551020408-2.58775510204082
310.513.5877551020408-3.08775510204082
41010.7214285714286-0.721428571428572
58.510.7214285714286-2.22142857142857
61010.7214285714286-0.721428571428572
71010.7214285714286-0.721428571428572
8812.6461538461538-4.64615384615385
91010.7214285714286-0.721428571428572
101515.2875-0.2875
1115.515.28750.2125
1220.519.61111111111110.888888888888889
1317.515.28752.2125
1417.515.28752.2125
1512.513.5877551020408-1.08775510204082
161412.64615384615381.35384615384615
171512.64615384615382.35384615384615
1818.512.64615384615385.85384615384615
1914.515.2875-0.7875
201415.2875-1.2875
2115.516.045-0.545000000000002
2215.516.045-0.545000000000002
231212.6461538461538-0.646153846153846
241313.5877551020408-0.587755102040816
251210.72142857142861.27857142857143
261210.72142857142861.27857142857143
271916.78484848484852.21515151515151
281516.045-1.045
291415.2875-1.2875
301415.2875-1.2875
3114.515.2875-0.7875
321916.78484848484852.21515151515151
331919.6111111111111-0.611111111111111
3420.516.78484848484853.71515151515151
351715.28751.7125
3616.515.28751.2125
371212.6461538461538-0.646153846153846
3813.513.5877551020408-0.0877551020408163
391313.5877551020408-0.587755102040816
401110.72142857142860.278571428571428
4113.513.5877551020408-0.0877551020408163
4212.510.72142857142861.77857142857143
4313.515.2875-1.7875
441413.58775510204080.412244897959184
451613.58775510204082.41224489795918
4614.513.58775510204080.912244897959184
471815.28752.7125
481615.28750.7125
4914.515.2875-0.7875
501515.2875-0.2875
511312.64615384615380.353846153846154
5211.513.5877551020408-2.08775510204082
5314.513.58775510204080.912244897959184
5412.513.5877551020408-1.08775510204082
551213.5877551020408-1.58775510204082
561313.5877551020408-0.587755102040816
571110.72142857142860.278571428571428
581110.72142857142860.278571428571428
5916.516.0450.454999999999998
601816.0451.955
6116.518.345-1.845
621616.045-0.0450000000000017
631413.58775510204080.412244897959184
6412.512.6461538461538-0.146153846153846
651515.2875-0.2875
6619.516.78484848484852.71515151515151
6716.515.28751.2125
6818.515.28753.2125
691415.2875-1.2875
701313.5877551020408-0.587755102040816
719.510.7214285714286-1.22142857142857
7215.515.28750.2125
731415.2875-1.2875
741113.5877551020408-2.58775510204082
751415.2875-1.2875
761112.6461538461538-1.64615384615385
7716.516.0450.454999999999998
781616.045-0.0450000000000017
7916.515.28751.2125
802116.78484848484854.21515151515151
811718.15-1.15
821818.15-0.149999999999999
831413.58775510204080.412244897959184
8414.513.58775510204080.912244897959184
851613.58775510204082.41224489795918
8615.513.58775510204081.91224489795918
8715.516.7848484848485-1.28484848484849
8814.515.2875-0.7875
891919.6111111111111-0.611111111111111
9014.515.2875-0.7875
911415.2875-1.2875
921515.2875-0.2875
931616.7848484848485-0.784848484848485
941616.045-0.0450000000000017
9519.518.3451.155
9611.510.72142857142860.778571428571428
971413.58775510204080.412244897959184
9813.513.5877551020408-0.0877551020408163
992118.152.85
1001918.150.850000000000001
1011918.150.850000000000001
10213.516.045-2.545
1031213.5877551020408-1.58775510204082
1041715.28751.7125
1051616.045-0.0450000000000017
10613.515.2875-1.7875
10716.516.7848484848485-0.284848484848485
10814.516.045-1.545
1091515.2875-0.2875
1101718.345-1.345
11113.513.5877551020408-0.0877551020408163
11217.519.6111111111111-2.11111111111111
11316.915.28751.6125
11414.915.2875-0.387499999999999
11515.315.28750.0125000000000011
1161313.5877551020408-0.587755102040816
11713.913.58775510204080.312244897959184
11812.813.5877551020408-0.787755102040816
11914.516.045-1.545
12017.618.345-0.744999999999997
12122.219.61111111111112.58888888888889
12222.119.61111111111112.48888888888889
12317.718.15-0.449999999999999
12416.218.15-1.95
12517.816.0451.755
1261716.78484848484850.215151515151515
12716.415.28751.1125
12815.716.045-0.345000000000002
12913.213.5877551020408-0.387755102040817
13016.713.58775510204083.11224489795918
13112.112.6461538461538-0.546153846153846
1321513.58775510204081.41224489795918
1331413.58775510204080.412244897959184
13414.815.2875-0.487499999999999
13518.619.6111111111111-1.01111111111111
13616.816.78484848484850.0151515151515156
13712.513.5877551020408-1.08775510204082
13813.713.58775510204080.112244897959183
13916.916.0450.854999999999997
14017.718.15-0.449999999999999
14111.110.72142857142860.378571428571428
14211.412.6461538461538-1.24615384615385
14314.513.58775510204080.912244897959184
14414.515.2875-0.7875
14518.215.28752.9125
14615.815.28750.512500000000001
14715.915.28750.612500000000001
14816.416.7848484848485-0.384848484848487
14914.515.2875-0.7875
15012.815.2875-2.4875
15121.519.61111111111111.88888888888889
15214.416.7848484848485-2.38484848484848
15318.616.78484848484851.81515151515152
15413.213.5877551020408-0.387755102040817
15512.813.5877551020408-0.787755102040816
15618.216.0452.155
15715.818.345-2.545
15817.218.15-0.949999999999999
15917.218.345-1.145
16016.718.345-1.645
16118.718.150.550000000000001
16213.213.5877551020408-0.387755102040817
16313.412.64615384615380.753846153846155
16413.713.58775510204080.112244897959183
16516.516.7848484848485-0.284848484848485
16614.715.2875-0.5875
16714.515.2875-0.7875
16817.618.345-0.744999999999997
16915.915.28750.612500000000001
17013.613.58775510204080.0122448979591834
17115.813.58775510204082.21224489795918
17214.916.7848484848485-1.88484848484848
17316.616.7848484848485-0.184848484848484
17418.218.345-0.145
17517.318.345-1.045
17616.616.0450.555
17715.413.58775510204081.81224489795918
17813.213.5877551020408-0.387755102040817
17915.213.58775510204081.61224489795918
18014.313.58775510204080.712244897959184
1811513.58775510204081.41224489795918
1821416.7848484848485-2.78484848484849
18315.216.7848484848485-1.58484848484849
1841515.2875-0.2875
18524.818.3456.455
18622.218.3453.855
18714.916.7848484848485-1.88484848484848
18819.216.78484848484852.41515151515151
1891615.28750.7125
19011.313.5877551020408-2.28775510204082
19113.215.2875-2.0875
19214.715.2875-0.5875
19315.516.7848484848485-1.28484848484849
19416.416.7848484848485-0.384848484848487
19518.118.345-0.244999999999997
19620.118.3451.755
19715.815.28750.512500000000001
19815.515.28750.2125
1991515.2875-0.2875
20015.215.2875-0.0875000000000004
20114.415.2875-0.887499999999999
20219.216.78484848484852.41515151515151
20319.918.3451.555
20413.816.7848484848485-2.98484848484848
20515.316.7848484848485-1.48484848484848
20615.115.2875-0.1875
20715.715.28750.4125
20816.415.28751.1125
20912.615.2875-2.6875
21012.915.2875-2.3875
21116.416.7848484848485-0.384848484848487
21216.119.6111111111111-3.51111111111111
21319.416.78484848484852.61515151515151
21417.316.78484848484850.515151515151516
21514.916.7848484848485-1.88484848484848
21616.216.7848484848485-0.584848484848486
21714.215.2875-1.0875
21814.815.2875-0.487499999999999
21920.418.3452.055
22013.813.58775510204080.212244897959184
22115.816.045-0.245000000000001
22217.118.345-1.245
22316.618.345-1.745
22418.615.28753.3125
2251815.28752.7125
2261615.28750.7125
2271815.28752.7125
22815.315.28750.0125000000000011
22917.616.78484848484850.815151515151516
23014.716.7848484848485-2.08484848484849
23114.515.2875-0.7875
23214.515.2875-0.7875
23315.716.7848484848485-1.08484848484849
23416.416.0450.354999999999997
2351718.345-1.345
23613.915.2875-1.3875
23717.318.345-1.045
23815.615.28750.3125
23911.615.2875-3.6875
24018.615.28753.3125



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