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, 13 Dec 2011 04:20:34 -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/13/t1323768065u0wptp8b8kc3gr4.htm/, Retrieved Thu, 02 May 2024 16:40:02 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=154296, Retrieved Thu, 02 May 2024 16:40:02 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact127
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [Workshop 10: Recu...] [2011-12-13 09:20:34] [e048104803f11a6160595af3ccdecef4] [Current]
Feedback Forum

Post a new message
Dataseries X:
1655	64	96
955	60	58
1782	66	69
2465	97	125
1051	48	55
577	27	8
3978	106	135
381	19	1
1860	53	64
1638	41	77
1993	101	90
1896	104	104
1579	64	48
2633	73	113
1718	77	68
4599	170	168
2017	65	111
2538	140	92
1287	51	93
2177	78	135
2309	67	117
2638	99	86
1298	37	50
1628	52	94
2975	109	127
2387	110	81
2654	123	93
1786	79	113
1430	50	52
2235	56	116
2107	71	114
1661	70	44
2012	82	128
866	34	38
2804	88	117
2668	54	83
3414	114	102
1677	77	74
917	31	33
2986	174	111
3034	76	117
1457	61	67
1627	71	69
1488	52	62
2397	75	50
4915	138	91
918	42	20
2086	70	101
3779	110	137
1988	53	93
1653	70	89
496	24	8
2452	297	83
744	17	21
1161	64	30
2723	52	86
2337	79	116
3415	168	115
2240	126	139
1956	76	77
3777	132	147
3010	112	126
2294	95	57
2213	82	67
1317	62	47
1577	63	91
1782	122	79
2428	132	75
1995	71	114
1441	62	127
2396	64	91
893	32	22
2055	75	73
1593	50	77
1612	56	105
2130	74	132
2093	84	94
1735	103	78
2094	59	126
1542	59	71
1572	44	59
3409	104	134
1357	67	30
2050	96	112
870	25	49
1737	51	26
1139	51	70
3402	172	59
2311	98	95
2996	101	161
2176	83	74
1857	70	137
1571	59	37
2914	71	121
2204	73	61
1521	35	78
1526	47	88
1911	70	152
3688	138	151
3373	104	145
2314	110	115
2142	60	140
1955	170	73
602	14	13
2084	73	89
1777	123	86
2326	45	122
2498	85	163
974	57	28
2969	79	116
1825	64	76
2082	78	134
398	11	12
1821	69	120
530	25	23
1551	47	83
2747	105	130
387	16	4
1914	47	73
449	19	18
3106	109	98
1795	59	68
1482	79	55
1521	50	37
568	34	16
1599	37	61
2551	77	128
1223	56	50
3322	76	134
2230	94	139
3180	116	136
1177	33	66
1051	37	42
2732	303	82
3929	158	98
1507	44	49
3904	126	127
1755	74	55
1627	46	104
2080	81	85
1596	109	29
3657	108	95
2022	80	120
2035	63	41
2626	94	132
1603	52	142
2305	77	88
2315	96	170
2	0	0
207	10	4
5	1	0
8	2	0
0	0	0
0	0	0
1819	80	56
2964	135	125
0	0	0
4	4	0
151	5	7
474	20	12
141	5	0
976	38	37
29	2	0
1577	60	47




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gertrude Mary Cox' @ cox.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 & 4 seconds \tabularnewline
R Server & 'Gertrude Mary Cox' @ cox.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154296&T=0

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

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

As an alternative you can also use a QR Code:  

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

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net







Goodness of Fit
Correlation0.7653
R-squared0.5857
RMSE29.3188

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7653[/C][/ROW]
[ROW][C]R-squared[/C][C]0.5857[/C][/ROW]
[ROW][C]RMSE[/C][C]29.3188[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154296&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154296&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.7653
R-squared0.5857
RMSE29.3188







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
16454.31707317073179.68292682926829
26054.31707317073175.68292682926829
36679.7894736842105-13.7894736842105
497120.625-23.625
54854.3170731707317-6.31707317073171
62723.23.8
7106120.625-14.625
81923.2-4.2
95379.7894736842105-26.7894736842105
104154.3170731707317-13.3170731707317
1110179.789473684210521.2105263157895
1210479.789473684210524.2105263157895
136454.31707317073179.68292682926829
1473120.625-47.625
157779.7894736842105-2.78947368421052
16170120.62549.375
176579.7894736842105-14.7894736842105
18140120.62519.375
195154.3170731707317-3.31707317073171
207879.7894736842105-1.78947368421052
216779.7894736842105-12.7894736842105
2299120.625-21.625
233754.3170731707317-17.3170731707317
245254.3170731707317-2.31707317073171
25109120.625-11.625
2611079.789473684210530.2105263157895
27123120.6252.375
287979.7894736842105-0.78947368421052
295054.3170731707317-4.31707317073171
305679.7894736842105-23.7894736842105
317179.7894736842105-8.78947368421052
327079.7894736842105-9.78947368421052
338279.78947368421052.21052631578948
343423.210.8
3588120.625-32.625
3654120.625-66.625
37114120.625-6.625
387779.7894736842105-2.78947368421052
393123.27.8
40174120.62553.375
4176120.625-44.625
426154.31707317073176.68292682926829
437154.317073170731716.6829268292683
445254.3170731707317-2.31707317073171
457579.7894736842105-4.78947368421052
46138120.62517.375
474254.3170731707317-12.3170731707317
487079.7894736842105-9.78947368421052
49110120.625-10.625
505379.7894736842105-26.7894736842105
517054.317073170731715.6829268292683
522423.20.800000000000001
53297120.625176.375
541723.2-6.2
556454.31707317073179.68292682926829
5652120.625-68.625
577979.7894736842105-0.78947368421052
58168120.62547.375
5912679.789473684210546.2105263157895
607679.7894736842105-3.78947368421052
61132120.62511.375
62112120.625-8.625
639579.789473684210515.2105263157895
648279.78947368421052.21052631578948
656254.31707317073177.68292682926829
666354.31707317073178.68292682926829
6712279.789473684210542.2105263157895
68132120.62511.375
697179.7894736842105-8.78947368421052
706254.31707317073177.68292682926829
716479.7894736842105-15.7894736842105
723223.28.8
737579.7894736842105-4.78947368421052
745054.3170731707317-4.31707317073171
755654.31707317073171.68292682926829
767479.7894736842105-5.78947368421052
778479.78947368421054.21052631578948
7810379.789473684210523.2105263157895
795979.7894736842105-20.7894736842105
805954.31707317073174.68292682926829
814454.3170731707317-10.3170731707317
82104120.625-16.625
836754.317073170731712.6829268292683
849679.789473684210516.2105263157895
852523.21.8
865179.7894736842105-28.7894736842105
875154.3170731707317-3.31707317073171
88172120.62551.375
899879.789473684210518.2105263157895
90101120.625-19.625
918379.78947368421053.21052631578948
927079.7894736842105-9.78947368421052
935954.31707317073174.68292682926829
9471120.625-49.625
957379.7894736842105-6.78947368421052
963554.3170731707317-19.3170731707317
974754.3170731707317-7.31707317073171
987079.7894736842105-9.78947368421052
99138120.62517.375
100104120.625-16.625
10111079.789473684210530.2105263157895
1026079.7894736842105-19.7894736842105
10317079.789473684210590.2105263157895
1041423.2-9.2
1057379.7894736842105-6.78947368421052
10612379.789473684210543.2105263157895
1074579.7894736842105-34.7894736842105
10885120.625-35.625
1095754.31707317073172.68292682926829
11079120.625-41.625
1116479.7894736842105-15.7894736842105
1127879.7894736842105-1.78947368421052
1131123.2-12.2
1146979.7894736842105-10.7894736842105
1152523.21.8
1164754.3170731707317-7.31707317073171
117105120.625-15.625
1181623.2-7.2
1194779.7894736842105-32.7894736842105
1201923.2-4.2
121109120.625-11.625
1225979.7894736842105-20.7894736842105
1237954.317073170731724.6829268292683
1245054.3170731707317-4.31707317073171
1253423.210.8
1263754.3170731707317-17.3170731707317
12777120.625-43.625
1285654.31707317073171.68292682926829
12976120.625-44.625
1309479.789473684210514.2105263157895
131116120.625-4.625
1323354.3170731707317-21.3170731707317
1333754.3170731707317-17.3170731707317
134303120.625182.375
135158120.62537.375
1364454.3170731707317-10.3170731707317
137126120.6255.375
1387479.7894736842105-5.78947368421052
1394654.3170731707317-8.31707317073171
1408179.78947368421051.21052631578948
14110954.317073170731754.6829268292683
142108120.625-12.625
1438079.78947368421050.21052631578948
1446379.7894736842105-16.7894736842105
14594120.625-26.625
1465254.3170731707317-2.31707317073171
1477779.7894736842105-2.78947368421052
1489679.789473684210516.2105263157895
14902.63636363636364-2.63636363636364
150102.636363636363647.36363636363636
15112.63636363636364-1.63636363636364
15222.63636363636364-0.636363636363636
15302.63636363636364-2.63636363636364
15402.63636363636364-2.63636363636364
1558079.78947368421050.21052631578948
156135120.62514.375
15702.63636363636364-2.63636363636364
15842.636363636363641.36363636363636
15952.636363636363642.36363636363636
1602023.2-3.2
16152.636363636363642.36363636363636
1623854.3170731707317-16.3170731707317
16322.63636363636364-0.636363636363636
1646054.31707317073175.68292682926829

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 64 & 54.3170731707317 & 9.68292682926829 \tabularnewline
2 & 60 & 54.3170731707317 & 5.68292682926829 \tabularnewline
3 & 66 & 79.7894736842105 & -13.7894736842105 \tabularnewline
4 & 97 & 120.625 & -23.625 \tabularnewline
5 & 48 & 54.3170731707317 & -6.31707317073171 \tabularnewline
6 & 27 & 23.2 & 3.8 \tabularnewline
7 & 106 & 120.625 & -14.625 \tabularnewline
8 & 19 & 23.2 & -4.2 \tabularnewline
9 & 53 & 79.7894736842105 & -26.7894736842105 \tabularnewline
10 & 41 & 54.3170731707317 & -13.3170731707317 \tabularnewline
11 & 101 & 79.7894736842105 & 21.2105263157895 \tabularnewline
12 & 104 & 79.7894736842105 & 24.2105263157895 \tabularnewline
13 & 64 & 54.3170731707317 & 9.68292682926829 \tabularnewline
14 & 73 & 120.625 & -47.625 \tabularnewline
15 & 77 & 79.7894736842105 & -2.78947368421052 \tabularnewline
16 & 170 & 120.625 & 49.375 \tabularnewline
17 & 65 & 79.7894736842105 & -14.7894736842105 \tabularnewline
18 & 140 & 120.625 & 19.375 \tabularnewline
19 & 51 & 54.3170731707317 & -3.31707317073171 \tabularnewline
20 & 78 & 79.7894736842105 & -1.78947368421052 \tabularnewline
21 & 67 & 79.7894736842105 & -12.7894736842105 \tabularnewline
22 & 99 & 120.625 & -21.625 \tabularnewline
23 & 37 & 54.3170731707317 & -17.3170731707317 \tabularnewline
24 & 52 & 54.3170731707317 & -2.31707317073171 \tabularnewline
25 & 109 & 120.625 & -11.625 \tabularnewline
26 & 110 & 79.7894736842105 & 30.2105263157895 \tabularnewline
27 & 123 & 120.625 & 2.375 \tabularnewline
28 & 79 & 79.7894736842105 & -0.78947368421052 \tabularnewline
29 & 50 & 54.3170731707317 & -4.31707317073171 \tabularnewline
30 & 56 & 79.7894736842105 & -23.7894736842105 \tabularnewline
31 & 71 & 79.7894736842105 & -8.78947368421052 \tabularnewline
32 & 70 & 79.7894736842105 & -9.78947368421052 \tabularnewline
33 & 82 & 79.7894736842105 & 2.21052631578948 \tabularnewline
34 & 34 & 23.2 & 10.8 \tabularnewline
35 & 88 & 120.625 & -32.625 \tabularnewline
36 & 54 & 120.625 & -66.625 \tabularnewline
37 & 114 & 120.625 & -6.625 \tabularnewline
38 & 77 & 79.7894736842105 & -2.78947368421052 \tabularnewline
39 & 31 & 23.2 & 7.8 \tabularnewline
40 & 174 & 120.625 & 53.375 \tabularnewline
41 & 76 & 120.625 & -44.625 \tabularnewline
42 & 61 & 54.3170731707317 & 6.68292682926829 \tabularnewline
43 & 71 & 54.3170731707317 & 16.6829268292683 \tabularnewline
44 & 52 & 54.3170731707317 & -2.31707317073171 \tabularnewline
45 & 75 & 79.7894736842105 & -4.78947368421052 \tabularnewline
46 & 138 & 120.625 & 17.375 \tabularnewline
47 & 42 & 54.3170731707317 & -12.3170731707317 \tabularnewline
48 & 70 & 79.7894736842105 & -9.78947368421052 \tabularnewline
49 & 110 & 120.625 & -10.625 \tabularnewline
50 & 53 & 79.7894736842105 & -26.7894736842105 \tabularnewline
51 & 70 & 54.3170731707317 & 15.6829268292683 \tabularnewline
52 & 24 & 23.2 & 0.800000000000001 \tabularnewline
53 & 297 & 120.625 & 176.375 \tabularnewline
54 & 17 & 23.2 & -6.2 \tabularnewline
55 & 64 & 54.3170731707317 & 9.68292682926829 \tabularnewline
56 & 52 & 120.625 & -68.625 \tabularnewline
57 & 79 & 79.7894736842105 & -0.78947368421052 \tabularnewline
58 & 168 & 120.625 & 47.375 \tabularnewline
59 & 126 & 79.7894736842105 & 46.2105263157895 \tabularnewline
60 & 76 & 79.7894736842105 & -3.78947368421052 \tabularnewline
61 & 132 & 120.625 & 11.375 \tabularnewline
62 & 112 & 120.625 & -8.625 \tabularnewline
63 & 95 & 79.7894736842105 & 15.2105263157895 \tabularnewline
64 & 82 & 79.7894736842105 & 2.21052631578948 \tabularnewline
65 & 62 & 54.3170731707317 & 7.68292682926829 \tabularnewline
66 & 63 & 54.3170731707317 & 8.68292682926829 \tabularnewline
67 & 122 & 79.7894736842105 & 42.2105263157895 \tabularnewline
68 & 132 & 120.625 & 11.375 \tabularnewline
69 & 71 & 79.7894736842105 & -8.78947368421052 \tabularnewline
70 & 62 & 54.3170731707317 & 7.68292682926829 \tabularnewline
71 & 64 & 79.7894736842105 & -15.7894736842105 \tabularnewline
72 & 32 & 23.2 & 8.8 \tabularnewline
73 & 75 & 79.7894736842105 & -4.78947368421052 \tabularnewline
74 & 50 & 54.3170731707317 & -4.31707317073171 \tabularnewline
75 & 56 & 54.3170731707317 & 1.68292682926829 \tabularnewline
76 & 74 & 79.7894736842105 & -5.78947368421052 \tabularnewline
77 & 84 & 79.7894736842105 & 4.21052631578948 \tabularnewline
78 & 103 & 79.7894736842105 & 23.2105263157895 \tabularnewline
79 & 59 & 79.7894736842105 & -20.7894736842105 \tabularnewline
80 & 59 & 54.3170731707317 & 4.68292682926829 \tabularnewline
81 & 44 & 54.3170731707317 & -10.3170731707317 \tabularnewline
82 & 104 & 120.625 & -16.625 \tabularnewline
83 & 67 & 54.3170731707317 & 12.6829268292683 \tabularnewline
84 & 96 & 79.7894736842105 & 16.2105263157895 \tabularnewline
85 & 25 & 23.2 & 1.8 \tabularnewline
86 & 51 & 79.7894736842105 & -28.7894736842105 \tabularnewline
87 & 51 & 54.3170731707317 & -3.31707317073171 \tabularnewline
88 & 172 & 120.625 & 51.375 \tabularnewline
89 & 98 & 79.7894736842105 & 18.2105263157895 \tabularnewline
90 & 101 & 120.625 & -19.625 \tabularnewline
91 & 83 & 79.7894736842105 & 3.21052631578948 \tabularnewline
92 & 70 & 79.7894736842105 & -9.78947368421052 \tabularnewline
93 & 59 & 54.3170731707317 & 4.68292682926829 \tabularnewline
94 & 71 & 120.625 & -49.625 \tabularnewline
95 & 73 & 79.7894736842105 & -6.78947368421052 \tabularnewline
96 & 35 & 54.3170731707317 & -19.3170731707317 \tabularnewline
97 & 47 & 54.3170731707317 & -7.31707317073171 \tabularnewline
98 & 70 & 79.7894736842105 & -9.78947368421052 \tabularnewline
99 & 138 & 120.625 & 17.375 \tabularnewline
100 & 104 & 120.625 & -16.625 \tabularnewline
101 & 110 & 79.7894736842105 & 30.2105263157895 \tabularnewline
102 & 60 & 79.7894736842105 & -19.7894736842105 \tabularnewline
103 & 170 & 79.7894736842105 & 90.2105263157895 \tabularnewline
104 & 14 & 23.2 & -9.2 \tabularnewline
105 & 73 & 79.7894736842105 & -6.78947368421052 \tabularnewline
106 & 123 & 79.7894736842105 & 43.2105263157895 \tabularnewline
107 & 45 & 79.7894736842105 & -34.7894736842105 \tabularnewline
108 & 85 & 120.625 & -35.625 \tabularnewline
109 & 57 & 54.3170731707317 & 2.68292682926829 \tabularnewline
110 & 79 & 120.625 & -41.625 \tabularnewline
111 & 64 & 79.7894736842105 & -15.7894736842105 \tabularnewline
112 & 78 & 79.7894736842105 & -1.78947368421052 \tabularnewline
113 & 11 & 23.2 & -12.2 \tabularnewline
114 & 69 & 79.7894736842105 & -10.7894736842105 \tabularnewline
115 & 25 & 23.2 & 1.8 \tabularnewline
116 & 47 & 54.3170731707317 & -7.31707317073171 \tabularnewline
117 & 105 & 120.625 & -15.625 \tabularnewline
118 & 16 & 23.2 & -7.2 \tabularnewline
119 & 47 & 79.7894736842105 & -32.7894736842105 \tabularnewline
120 & 19 & 23.2 & -4.2 \tabularnewline
121 & 109 & 120.625 & -11.625 \tabularnewline
122 & 59 & 79.7894736842105 & -20.7894736842105 \tabularnewline
123 & 79 & 54.3170731707317 & 24.6829268292683 \tabularnewline
124 & 50 & 54.3170731707317 & -4.31707317073171 \tabularnewline
125 & 34 & 23.2 & 10.8 \tabularnewline
126 & 37 & 54.3170731707317 & -17.3170731707317 \tabularnewline
127 & 77 & 120.625 & -43.625 \tabularnewline
128 & 56 & 54.3170731707317 & 1.68292682926829 \tabularnewline
129 & 76 & 120.625 & -44.625 \tabularnewline
130 & 94 & 79.7894736842105 & 14.2105263157895 \tabularnewline
131 & 116 & 120.625 & -4.625 \tabularnewline
132 & 33 & 54.3170731707317 & -21.3170731707317 \tabularnewline
133 & 37 & 54.3170731707317 & -17.3170731707317 \tabularnewline
134 & 303 & 120.625 & 182.375 \tabularnewline
135 & 158 & 120.625 & 37.375 \tabularnewline
136 & 44 & 54.3170731707317 & -10.3170731707317 \tabularnewline
137 & 126 & 120.625 & 5.375 \tabularnewline
138 & 74 & 79.7894736842105 & -5.78947368421052 \tabularnewline
139 & 46 & 54.3170731707317 & -8.31707317073171 \tabularnewline
140 & 81 & 79.7894736842105 & 1.21052631578948 \tabularnewline
141 & 109 & 54.3170731707317 & 54.6829268292683 \tabularnewline
142 & 108 & 120.625 & -12.625 \tabularnewline
143 & 80 & 79.7894736842105 & 0.21052631578948 \tabularnewline
144 & 63 & 79.7894736842105 & -16.7894736842105 \tabularnewline
145 & 94 & 120.625 & -26.625 \tabularnewline
146 & 52 & 54.3170731707317 & -2.31707317073171 \tabularnewline
147 & 77 & 79.7894736842105 & -2.78947368421052 \tabularnewline
148 & 96 & 79.7894736842105 & 16.2105263157895 \tabularnewline
149 & 0 & 2.63636363636364 & -2.63636363636364 \tabularnewline
150 & 10 & 2.63636363636364 & 7.36363636363636 \tabularnewline
151 & 1 & 2.63636363636364 & -1.63636363636364 \tabularnewline
152 & 2 & 2.63636363636364 & -0.636363636363636 \tabularnewline
153 & 0 & 2.63636363636364 & -2.63636363636364 \tabularnewline
154 & 0 & 2.63636363636364 & -2.63636363636364 \tabularnewline
155 & 80 & 79.7894736842105 & 0.21052631578948 \tabularnewline
156 & 135 & 120.625 & 14.375 \tabularnewline
157 & 0 & 2.63636363636364 & -2.63636363636364 \tabularnewline
158 & 4 & 2.63636363636364 & 1.36363636363636 \tabularnewline
159 & 5 & 2.63636363636364 & 2.36363636363636 \tabularnewline
160 & 20 & 23.2 & -3.2 \tabularnewline
161 & 5 & 2.63636363636364 & 2.36363636363636 \tabularnewline
162 & 38 & 54.3170731707317 & -16.3170731707317 \tabularnewline
163 & 2 & 2.63636363636364 & -0.636363636363636 \tabularnewline
164 & 60 & 54.3170731707317 & 5.68292682926829 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154296&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]64[/C][C]54.3170731707317[/C][C]9.68292682926829[/C][/ROW]
[ROW][C]2[/C][C]60[/C][C]54.3170731707317[/C][C]5.68292682926829[/C][/ROW]
[ROW][C]3[/C][C]66[/C][C]79.7894736842105[/C][C]-13.7894736842105[/C][/ROW]
[ROW][C]4[/C][C]97[/C][C]120.625[/C][C]-23.625[/C][/ROW]
[ROW][C]5[/C][C]48[/C][C]54.3170731707317[/C][C]-6.31707317073171[/C][/ROW]
[ROW][C]6[/C][C]27[/C][C]23.2[/C][C]3.8[/C][/ROW]
[ROW][C]7[/C][C]106[/C][C]120.625[/C][C]-14.625[/C][/ROW]
[ROW][C]8[/C][C]19[/C][C]23.2[/C][C]-4.2[/C][/ROW]
[ROW][C]9[/C][C]53[/C][C]79.7894736842105[/C][C]-26.7894736842105[/C][/ROW]
[ROW][C]10[/C][C]41[/C][C]54.3170731707317[/C][C]-13.3170731707317[/C][/ROW]
[ROW][C]11[/C][C]101[/C][C]79.7894736842105[/C][C]21.2105263157895[/C][/ROW]
[ROW][C]12[/C][C]104[/C][C]79.7894736842105[/C][C]24.2105263157895[/C][/ROW]
[ROW][C]13[/C][C]64[/C][C]54.3170731707317[/C][C]9.68292682926829[/C][/ROW]
[ROW][C]14[/C][C]73[/C][C]120.625[/C][C]-47.625[/C][/ROW]
[ROW][C]15[/C][C]77[/C][C]79.7894736842105[/C][C]-2.78947368421052[/C][/ROW]
[ROW][C]16[/C][C]170[/C][C]120.625[/C][C]49.375[/C][/ROW]
[ROW][C]17[/C][C]65[/C][C]79.7894736842105[/C][C]-14.7894736842105[/C][/ROW]
[ROW][C]18[/C][C]140[/C][C]120.625[/C][C]19.375[/C][/ROW]
[ROW][C]19[/C][C]51[/C][C]54.3170731707317[/C][C]-3.31707317073171[/C][/ROW]
[ROW][C]20[/C][C]78[/C][C]79.7894736842105[/C][C]-1.78947368421052[/C][/ROW]
[ROW][C]21[/C][C]67[/C][C]79.7894736842105[/C][C]-12.7894736842105[/C][/ROW]
[ROW][C]22[/C][C]99[/C][C]120.625[/C][C]-21.625[/C][/ROW]
[ROW][C]23[/C][C]37[/C][C]54.3170731707317[/C][C]-17.3170731707317[/C][/ROW]
[ROW][C]24[/C][C]52[/C][C]54.3170731707317[/C][C]-2.31707317073171[/C][/ROW]
[ROW][C]25[/C][C]109[/C][C]120.625[/C][C]-11.625[/C][/ROW]
[ROW][C]26[/C][C]110[/C][C]79.7894736842105[/C][C]30.2105263157895[/C][/ROW]
[ROW][C]27[/C][C]123[/C][C]120.625[/C][C]2.375[/C][/ROW]
[ROW][C]28[/C][C]79[/C][C]79.7894736842105[/C][C]-0.78947368421052[/C][/ROW]
[ROW][C]29[/C][C]50[/C][C]54.3170731707317[/C][C]-4.31707317073171[/C][/ROW]
[ROW][C]30[/C][C]56[/C][C]79.7894736842105[/C][C]-23.7894736842105[/C][/ROW]
[ROW][C]31[/C][C]71[/C][C]79.7894736842105[/C][C]-8.78947368421052[/C][/ROW]
[ROW][C]32[/C][C]70[/C][C]79.7894736842105[/C][C]-9.78947368421052[/C][/ROW]
[ROW][C]33[/C][C]82[/C][C]79.7894736842105[/C][C]2.21052631578948[/C][/ROW]
[ROW][C]34[/C][C]34[/C][C]23.2[/C][C]10.8[/C][/ROW]
[ROW][C]35[/C][C]88[/C][C]120.625[/C][C]-32.625[/C][/ROW]
[ROW][C]36[/C][C]54[/C][C]120.625[/C][C]-66.625[/C][/ROW]
[ROW][C]37[/C][C]114[/C][C]120.625[/C][C]-6.625[/C][/ROW]
[ROW][C]38[/C][C]77[/C][C]79.7894736842105[/C][C]-2.78947368421052[/C][/ROW]
[ROW][C]39[/C][C]31[/C][C]23.2[/C][C]7.8[/C][/ROW]
[ROW][C]40[/C][C]174[/C][C]120.625[/C][C]53.375[/C][/ROW]
[ROW][C]41[/C][C]76[/C][C]120.625[/C][C]-44.625[/C][/ROW]
[ROW][C]42[/C][C]61[/C][C]54.3170731707317[/C][C]6.68292682926829[/C][/ROW]
[ROW][C]43[/C][C]71[/C][C]54.3170731707317[/C][C]16.6829268292683[/C][/ROW]
[ROW][C]44[/C][C]52[/C][C]54.3170731707317[/C][C]-2.31707317073171[/C][/ROW]
[ROW][C]45[/C][C]75[/C][C]79.7894736842105[/C][C]-4.78947368421052[/C][/ROW]
[ROW][C]46[/C][C]138[/C][C]120.625[/C][C]17.375[/C][/ROW]
[ROW][C]47[/C][C]42[/C][C]54.3170731707317[/C][C]-12.3170731707317[/C][/ROW]
[ROW][C]48[/C][C]70[/C][C]79.7894736842105[/C][C]-9.78947368421052[/C][/ROW]
[ROW][C]49[/C][C]110[/C][C]120.625[/C][C]-10.625[/C][/ROW]
[ROW][C]50[/C][C]53[/C][C]79.7894736842105[/C][C]-26.7894736842105[/C][/ROW]
[ROW][C]51[/C][C]70[/C][C]54.3170731707317[/C][C]15.6829268292683[/C][/ROW]
[ROW][C]52[/C][C]24[/C][C]23.2[/C][C]0.800000000000001[/C][/ROW]
[ROW][C]53[/C][C]297[/C][C]120.625[/C][C]176.375[/C][/ROW]
[ROW][C]54[/C][C]17[/C][C]23.2[/C][C]-6.2[/C][/ROW]
[ROW][C]55[/C][C]64[/C][C]54.3170731707317[/C][C]9.68292682926829[/C][/ROW]
[ROW][C]56[/C][C]52[/C][C]120.625[/C][C]-68.625[/C][/ROW]
[ROW][C]57[/C][C]79[/C][C]79.7894736842105[/C][C]-0.78947368421052[/C][/ROW]
[ROW][C]58[/C][C]168[/C][C]120.625[/C][C]47.375[/C][/ROW]
[ROW][C]59[/C][C]126[/C][C]79.7894736842105[/C][C]46.2105263157895[/C][/ROW]
[ROW][C]60[/C][C]76[/C][C]79.7894736842105[/C][C]-3.78947368421052[/C][/ROW]
[ROW][C]61[/C][C]132[/C][C]120.625[/C][C]11.375[/C][/ROW]
[ROW][C]62[/C][C]112[/C][C]120.625[/C][C]-8.625[/C][/ROW]
[ROW][C]63[/C][C]95[/C][C]79.7894736842105[/C][C]15.2105263157895[/C][/ROW]
[ROW][C]64[/C][C]82[/C][C]79.7894736842105[/C][C]2.21052631578948[/C][/ROW]
[ROW][C]65[/C][C]62[/C][C]54.3170731707317[/C][C]7.68292682926829[/C][/ROW]
[ROW][C]66[/C][C]63[/C][C]54.3170731707317[/C][C]8.68292682926829[/C][/ROW]
[ROW][C]67[/C][C]122[/C][C]79.7894736842105[/C][C]42.2105263157895[/C][/ROW]
[ROW][C]68[/C][C]132[/C][C]120.625[/C][C]11.375[/C][/ROW]
[ROW][C]69[/C][C]71[/C][C]79.7894736842105[/C][C]-8.78947368421052[/C][/ROW]
[ROW][C]70[/C][C]62[/C][C]54.3170731707317[/C][C]7.68292682926829[/C][/ROW]
[ROW][C]71[/C][C]64[/C][C]79.7894736842105[/C][C]-15.7894736842105[/C][/ROW]
[ROW][C]72[/C][C]32[/C][C]23.2[/C][C]8.8[/C][/ROW]
[ROW][C]73[/C][C]75[/C][C]79.7894736842105[/C][C]-4.78947368421052[/C][/ROW]
[ROW][C]74[/C][C]50[/C][C]54.3170731707317[/C][C]-4.31707317073171[/C][/ROW]
[ROW][C]75[/C][C]56[/C][C]54.3170731707317[/C][C]1.68292682926829[/C][/ROW]
[ROW][C]76[/C][C]74[/C][C]79.7894736842105[/C][C]-5.78947368421052[/C][/ROW]
[ROW][C]77[/C][C]84[/C][C]79.7894736842105[/C][C]4.21052631578948[/C][/ROW]
[ROW][C]78[/C][C]103[/C][C]79.7894736842105[/C][C]23.2105263157895[/C][/ROW]
[ROW][C]79[/C][C]59[/C][C]79.7894736842105[/C][C]-20.7894736842105[/C][/ROW]
[ROW][C]80[/C][C]59[/C][C]54.3170731707317[/C][C]4.68292682926829[/C][/ROW]
[ROW][C]81[/C][C]44[/C][C]54.3170731707317[/C][C]-10.3170731707317[/C][/ROW]
[ROW][C]82[/C][C]104[/C][C]120.625[/C][C]-16.625[/C][/ROW]
[ROW][C]83[/C][C]67[/C][C]54.3170731707317[/C][C]12.6829268292683[/C][/ROW]
[ROW][C]84[/C][C]96[/C][C]79.7894736842105[/C][C]16.2105263157895[/C][/ROW]
[ROW][C]85[/C][C]25[/C][C]23.2[/C][C]1.8[/C][/ROW]
[ROW][C]86[/C][C]51[/C][C]79.7894736842105[/C][C]-28.7894736842105[/C][/ROW]
[ROW][C]87[/C][C]51[/C][C]54.3170731707317[/C][C]-3.31707317073171[/C][/ROW]
[ROW][C]88[/C][C]172[/C][C]120.625[/C][C]51.375[/C][/ROW]
[ROW][C]89[/C][C]98[/C][C]79.7894736842105[/C][C]18.2105263157895[/C][/ROW]
[ROW][C]90[/C][C]101[/C][C]120.625[/C][C]-19.625[/C][/ROW]
[ROW][C]91[/C][C]83[/C][C]79.7894736842105[/C][C]3.21052631578948[/C][/ROW]
[ROW][C]92[/C][C]70[/C][C]79.7894736842105[/C][C]-9.78947368421052[/C][/ROW]
[ROW][C]93[/C][C]59[/C][C]54.3170731707317[/C][C]4.68292682926829[/C][/ROW]
[ROW][C]94[/C][C]71[/C][C]120.625[/C][C]-49.625[/C][/ROW]
[ROW][C]95[/C][C]73[/C][C]79.7894736842105[/C][C]-6.78947368421052[/C][/ROW]
[ROW][C]96[/C][C]35[/C][C]54.3170731707317[/C][C]-19.3170731707317[/C][/ROW]
[ROW][C]97[/C][C]47[/C][C]54.3170731707317[/C][C]-7.31707317073171[/C][/ROW]
[ROW][C]98[/C][C]70[/C][C]79.7894736842105[/C][C]-9.78947368421052[/C][/ROW]
[ROW][C]99[/C][C]138[/C][C]120.625[/C][C]17.375[/C][/ROW]
[ROW][C]100[/C][C]104[/C][C]120.625[/C][C]-16.625[/C][/ROW]
[ROW][C]101[/C][C]110[/C][C]79.7894736842105[/C][C]30.2105263157895[/C][/ROW]
[ROW][C]102[/C][C]60[/C][C]79.7894736842105[/C][C]-19.7894736842105[/C][/ROW]
[ROW][C]103[/C][C]170[/C][C]79.7894736842105[/C][C]90.2105263157895[/C][/ROW]
[ROW][C]104[/C][C]14[/C][C]23.2[/C][C]-9.2[/C][/ROW]
[ROW][C]105[/C][C]73[/C][C]79.7894736842105[/C][C]-6.78947368421052[/C][/ROW]
[ROW][C]106[/C][C]123[/C][C]79.7894736842105[/C][C]43.2105263157895[/C][/ROW]
[ROW][C]107[/C][C]45[/C][C]79.7894736842105[/C][C]-34.7894736842105[/C][/ROW]
[ROW][C]108[/C][C]85[/C][C]120.625[/C][C]-35.625[/C][/ROW]
[ROW][C]109[/C][C]57[/C][C]54.3170731707317[/C][C]2.68292682926829[/C][/ROW]
[ROW][C]110[/C][C]79[/C][C]120.625[/C][C]-41.625[/C][/ROW]
[ROW][C]111[/C][C]64[/C][C]79.7894736842105[/C][C]-15.7894736842105[/C][/ROW]
[ROW][C]112[/C][C]78[/C][C]79.7894736842105[/C][C]-1.78947368421052[/C][/ROW]
[ROW][C]113[/C][C]11[/C][C]23.2[/C][C]-12.2[/C][/ROW]
[ROW][C]114[/C][C]69[/C][C]79.7894736842105[/C][C]-10.7894736842105[/C][/ROW]
[ROW][C]115[/C][C]25[/C][C]23.2[/C][C]1.8[/C][/ROW]
[ROW][C]116[/C][C]47[/C][C]54.3170731707317[/C][C]-7.31707317073171[/C][/ROW]
[ROW][C]117[/C][C]105[/C][C]120.625[/C][C]-15.625[/C][/ROW]
[ROW][C]118[/C][C]16[/C][C]23.2[/C][C]-7.2[/C][/ROW]
[ROW][C]119[/C][C]47[/C][C]79.7894736842105[/C][C]-32.7894736842105[/C][/ROW]
[ROW][C]120[/C][C]19[/C][C]23.2[/C][C]-4.2[/C][/ROW]
[ROW][C]121[/C][C]109[/C][C]120.625[/C][C]-11.625[/C][/ROW]
[ROW][C]122[/C][C]59[/C][C]79.7894736842105[/C][C]-20.7894736842105[/C][/ROW]
[ROW][C]123[/C][C]79[/C][C]54.3170731707317[/C][C]24.6829268292683[/C][/ROW]
[ROW][C]124[/C][C]50[/C][C]54.3170731707317[/C][C]-4.31707317073171[/C][/ROW]
[ROW][C]125[/C][C]34[/C][C]23.2[/C][C]10.8[/C][/ROW]
[ROW][C]126[/C][C]37[/C][C]54.3170731707317[/C][C]-17.3170731707317[/C][/ROW]
[ROW][C]127[/C][C]77[/C][C]120.625[/C][C]-43.625[/C][/ROW]
[ROW][C]128[/C][C]56[/C][C]54.3170731707317[/C][C]1.68292682926829[/C][/ROW]
[ROW][C]129[/C][C]76[/C][C]120.625[/C][C]-44.625[/C][/ROW]
[ROW][C]130[/C][C]94[/C][C]79.7894736842105[/C][C]14.2105263157895[/C][/ROW]
[ROW][C]131[/C][C]116[/C][C]120.625[/C][C]-4.625[/C][/ROW]
[ROW][C]132[/C][C]33[/C][C]54.3170731707317[/C][C]-21.3170731707317[/C][/ROW]
[ROW][C]133[/C][C]37[/C][C]54.3170731707317[/C][C]-17.3170731707317[/C][/ROW]
[ROW][C]134[/C][C]303[/C][C]120.625[/C][C]182.375[/C][/ROW]
[ROW][C]135[/C][C]158[/C][C]120.625[/C][C]37.375[/C][/ROW]
[ROW][C]136[/C][C]44[/C][C]54.3170731707317[/C][C]-10.3170731707317[/C][/ROW]
[ROW][C]137[/C][C]126[/C][C]120.625[/C][C]5.375[/C][/ROW]
[ROW][C]138[/C][C]74[/C][C]79.7894736842105[/C][C]-5.78947368421052[/C][/ROW]
[ROW][C]139[/C][C]46[/C][C]54.3170731707317[/C][C]-8.31707317073171[/C][/ROW]
[ROW][C]140[/C][C]81[/C][C]79.7894736842105[/C][C]1.21052631578948[/C][/ROW]
[ROW][C]141[/C][C]109[/C][C]54.3170731707317[/C][C]54.6829268292683[/C][/ROW]
[ROW][C]142[/C][C]108[/C][C]120.625[/C][C]-12.625[/C][/ROW]
[ROW][C]143[/C][C]80[/C][C]79.7894736842105[/C][C]0.21052631578948[/C][/ROW]
[ROW][C]144[/C][C]63[/C][C]79.7894736842105[/C][C]-16.7894736842105[/C][/ROW]
[ROW][C]145[/C][C]94[/C][C]120.625[/C][C]-26.625[/C][/ROW]
[ROW][C]146[/C][C]52[/C][C]54.3170731707317[/C][C]-2.31707317073171[/C][/ROW]
[ROW][C]147[/C][C]77[/C][C]79.7894736842105[/C][C]-2.78947368421052[/C][/ROW]
[ROW][C]148[/C][C]96[/C][C]79.7894736842105[/C][C]16.2105263157895[/C][/ROW]
[ROW][C]149[/C][C]0[/C][C]2.63636363636364[/C][C]-2.63636363636364[/C][/ROW]
[ROW][C]150[/C][C]10[/C][C]2.63636363636364[/C][C]7.36363636363636[/C][/ROW]
[ROW][C]151[/C][C]1[/C][C]2.63636363636364[/C][C]-1.63636363636364[/C][/ROW]
[ROW][C]152[/C][C]2[/C][C]2.63636363636364[/C][C]-0.636363636363636[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]2.63636363636364[/C][C]-2.63636363636364[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]2.63636363636364[/C][C]-2.63636363636364[/C][/ROW]
[ROW][C]155[/C][C]80[/C][C]79.7894736842105[/C][C]0.21052631578948[/C][/ROW]
[ROW][C]156[/C][C]135[/C][C]120.625[/C][C]14.375[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]2.63636363636364[/C][C]-2.63636363636364[/C][/ROW]
[ROW][C]158[/C][C]4[/C][C]2.63636363636364[/C][C]1.36363636363636[/C][/ROW]
[ROW][C]159[/C][C]5[/C][C]2.63636363636364[/C][C]2.36363636363636[/C][/ROW]
[ROW][C]160[/C][C]20[/C][C]23.2[/C][C]-3.2[/C][/ROW]
[ROW][C]161[/C][C]5[/C][C]2.63636363636364[/C][C]2.36363636363636[/C][/ROW]
[ROW][C]162[/C][C]38[/C][C]54.3170731707317[/C][C]-16.3170731707317[/C][/ROW]
[ROW][C]163[/C][C]2[/C][C]2.63636363636364[/C][C]-0.636363636363636[/C][/ROW]
[ROW][C]164[/C][C]60[/C][C]54.3170731707317[/C][C]5.68292682926829[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154296&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154296&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
16454.31707317073179.68292682926829
26054.31707317073175.68292682926829
36679.7894736842105-13.7894736842105
497120.625-23.625
54854.3170731707317-6.31707317073171
62723.23.8
7106120.625-14.625
81923.2-4.2
95379.7894736842105-26.7894736842105
104154.3170731707317-13.3170731707317
1110179.789473684210521.2105263157895
1210479.789473684210524.2105263157895
136454.31707317073179.68292682926829
1473120.625-47.625
157779.7894736842105-2.78947368421052
16170120.62549.375
176579.7894736842105-14.7894736842105
18140120.62519.375
195154.3170731707317-3.31707317073171
207879.7894736842105-1.78947368421052
216779.7894736842105-12.7894736842105
2299120.625-21.625
233754.3170731707317-17.3170731707317
245254.3170731707317-2.31707317073171
25109120.625-11.625
2611079.789473684210530.2105263157895
27123120.6252.375
287979.7894736842105-0.78947368421052
295054.3170731707317-4.31707317073171
305679.7894736842105-23.7894736842105
317179.7894736842105-8.78947368421052
327079.7894736842105-9.78947368421052
338279.78947368421052.21052631578948
343423.210.8
3588120.625-32.625
3654120.625-66.625
37114120.625-6.625
387779.7894736842105-2.78947368421052
393123.27.8
40174120.62553.375
4176120.625-44.625
426154.31707317073176.68292682926829
437154.317073170731716.6829268292683
445254.3170731707317-2.31707317073171
457579.7894736842105-4.78947368421052
46138120.62517.375
474254.3170731707317-12.3170731707317
487079.7894736842105-9.78947368421052
49110120.625-10.625
505379.7894736842105-26.7894736842105
517054.317073170731715.6829268292683
522423.20.800000000000001
53297120.625176.375
541723.2-6.2
556454.31707317073179.68292682926829
5652120.625-68.625
577979.7894736842105-0.78947368421052
58168120.62547.375
5912679.789473684210546.2105263157895
607679.7894736842105-3.78947368421052
61132120.62511.375
62112120.625-8.625
639579.789473684210515.2105263157895
648279.78947368421052.21052631578948
656254.31707317073177.68292682926829
666354.31707317073178.68292682926829
6712279.789473684210542.2105263157895
68132120.62511.375
697179.7894736842105-8.78947368421052
706254.31707317073177.68292682926829
716479.7894736842105-15.7894736842105
723223.28.8
737579.7894736842105-4.78947368421052
745054.3170731707317-4.31707317073171
755654.31707317073171.68292682926829
767479.7894736842105-5.78947368421052
778479.78947368421054.21052631578948
7810379.789473684210523.2105263157895
795979.7894736842105-20.7894736842105
805954.31707317073174.68292682926829
814454.3170731707317-10.3170731707317
82104120.625-16.625
836754.317073170731712.6829268292683
849679.789473684210516.2105263157895
852523.21.8
865179.7894736842105-28.7894736842105
875154.3170731707317-3.31707317073171
88172120.62551.375
899879.789473684210518.2105263157895
90101120.625-19.625
918379.78947368421053.21052631578948
927079.7894736842105-9.78947368421052
935954.31707317073174.68292682926829
9471120.625-49.625
957379.7894736842105-6.78947368421052
963554.3170731707317-19.3170731707317
974754.3170731707317-7.31707317073171
987079.7894736842105-9.78947368421052
99138120.62517.375
100104120.625-16.625
10111079.789473684210530.2105263157895
1026079.7894736842105-19.7894736842105
10317079.789473684210590.2105263157895
1041423.2-9.2
1057379.7894736842105-6.78947368421052
10612379.789473684210543.2105263157895
1074579.7894736842105-34.7894736842105
10885120.625-35.625
1095754.31707317073172.68292682926829
11079120.625-41.625
1116479.7894736842105-15.7894736842105
1127879.7894736842105-1.78947368421052
1131123.2-12.2
1146979.7894736842105-10.7894736842105
1152523.21.8
1164754.3170731707317-7.31707317073171
117105120.625-15.625
1181623.2-7.2
1194779.7894736842105-32.7894736842105
1201923.2-4.2
121109120.625-11.625
1225979.7894736842105-20.7894736842105
1237954.317073170731724.6829268292683
1245054.3170731707317-4.31707317073171
1253423.210.8
1263754.3170731707317-17.3170731707317
12777120.625-43.625
1285654.31707317073171.68292682926829
12976120.625-44.625
1309479.789473684210514.2105263157895
131116120.625-4.625
1323354.3170731707317-21.3170731707317
1333754.3170731707317-17.3170731707317
134303120.625182.375
135158120.62537.375
1364454.3170731707317-10.3170731707317
137126120.6255.375
1387479.7894736842105-5.78947368421052
1394654.3170731707317-8.31707317073171
1408179.78947368421051.21052631578948
14110954.317073170731754.6829268292683
142108120.625-12.625
1438079.78947368421050.21052631578948
1446379.7894736842105-16.7894736842105
14594120.625-26.625
1465254.3170731707317-2.31707317073171
1477779.7894736842105-2.78947368421052
1489679.789473684210516.2105263157895
14902.63636363636364-2.63636363636364
150102.636363636363647.36363636363636
15112.63636363636364-1.63636363636364
15222.63636363636364-0.636363636363636
15302.63636363636364-2.63636363636364
15402.63636363636364-2.63636363636364
1558079.78947368421050.21052631578948
156135120.62514.375
15702.63636363636364-2.63636363636364
15842.636363636363641.36363636363636
15952.636363636363642.36363636363636
1602023.2-3.2
16152.636363636363642.36363636363636
1623854.3170731707317-16.3170731707317
16322.63636363636364-0.636363636363636
1646054.31707317073175.68292682926829



Parameters (Session):
par1 = 2 ; par2 = none ; par3 = 3 ; par4 = no ;
Parameters (R input):
par1 = 2 ; par2 = none ; par3 = 3 ; par4 = no ;
R code (references can be found in the software module):
library(party)
library(Hmisc)
par1 <- as.numeric(par1)
par3 <- as.numeric(par3)
x <- data.frame(t(y))
is.data.frame(x)
x <- x[!is.na(x[,par1]),]
k <- length(x[1,])
n <- length(x[,1])
colnames(x)[par1]
x[,par1]
if (par2 == 'kmeans') {
cl <- kmeans(x[,par1], par3)
print(cl)
clm <- matrix(cbind(cl$centers,1:par3),ncol=2)
clm <- clm[sort.list(clm[,1]),]
for (i in 1:par3) {
cl$cluster[cl$cluster==clm[i,2]] <- paste('C',i,sep='')
}
cl$cluster <- as.factor(cl$cluster)
print(cl$cluster)
x[,par1] <- cl$cluster
}
if (par2 == 'quantiles') {
x[,par1] <- cut2(x[,par1],g=par3)
}
if (par2 == 'hclust') {
hc <- hclust(dist(x[,par1])^2, 'cen')
print(hc)
memb <- cutree(hc, k = par3)
dum <- c(mean(x[memb==1,par1]))
for (i in 2:par3) {
dum <- c(dum, mean(x[memb==i,par1]))
}
hcm <- matrix(cbind(dum,1:par3),ncol=2)
hcm <- hcm[sort.list(hcm[,1]),]
for (i in 1:par3) {
memb[memb==hcm[i,2]] <- paste('C',i,sep='')
}
memb <- as.factor(memb)
print(memb)
x[,par1] <- memb
}
if (par2=='equal') {
ed <- cut(as.numeric(x[,par1]),par3,labels=paste('C',1:par3,sep=''))
x[,par1] <- as.factor(ed)
}
table(x[,par1])
colnames(x)
colnames(x)[par1]
x[,par1]
if (par2 == 'none') {
m <- ctree(as.formula(paste(colnames(x)[par1],' ~ .',sep='')),data = x)
}
load(file='createtable')
if (par2 != 'none') {
m <- ctree(as.formula(paste('as.factor(',colnames(x)[par1],') ~ .',sep='')),data = x)
if (par4=='yes') {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'10-Fold Cross Validation',3+2*par3,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'',1,TRUE)
a<-table.element(a,'Prediction (training)',par3+1,TRUE)
a<-table.element(a,'Prediction (testing)',par3+1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Actual',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,paste('C',jjj,sep=''),1,TRUE)
a<-table.element(a,'CV',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,paste('C',jjj,sep=''),1,TRUE)
a<-table.element(a,'CV',1,TRUE)
a<-table.row.end(a)
for (i in 1:10) {
ind <- sample(2, nrow(x), replace=T, prob=c(0.9,0.1))
m.ct <- ctree(as.formula(paste('as.factor(',colnames(x)[par1],') ~ .',sep='')),data =x[ind==1,])
if (i==1) {
m.ct.i.pred <- predict(m.ct, newdata=x[ind==1,])
m.ct.i.actu <- x[ind==1,par1]
m.ct.x.pred <- predict(m.ct, newdata=x[ind==2,])
m.ct.x.actu <- x[ind==2,par1]
} else {
m.ct.i.pred <- c(m.ct.i.pred,predict(m.ct, newdata=x[ind==1,]))
m.ct.i.actu <- c(m.ct.i.actu,x[ind==1,par1])
m.ct.x.pred <- c(m.ct.x.pred,predict(m.ct, newdata=x[ind==2,]))
m.ct.x.actu <- c(m.ct.x.actu,x[ind==2,par1])
}
}
print(m.ct.i.tab <- table(m.ct.i.actu,m.ct.i.pred))
numer <- 0
for (i in 1:par3) {
print(m.ct.i.tab[i,i] / sum(m.ct.i.tab[i,]))
numer <- numer + m.ct.i.tab[i,i]
}
print(m.ct.i.cp <- numer / sum(m.ct.i.tab))
print(m.ct.x.tab <- table(m.ct.x.actu,m.ct.x.pred))
numer <- 0
for (i in 1:par3) {
print(m.ct.x.tab[i,i] / sum(m.ct.x.tab[i,]))
numer <- numer + m.ct.x.tab[i,i]
}
print(m.ct.x.cp <- numer / sum(m.ct.x.tab))
for (i in 1:par3) {
a<-table.row.start(a)
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
for (jjj in 1:par3) a<-table.element(a,m.ct.i.tab[i,jjj])
a<-table.element(a,round(m.ct.i.tab[i,i]/sum(m.ct.i.tab[i,]),4))
for (jjj in 1:par3) a<-table.element(a,m.ct.x.tab[i,jjj])
a<-table.element(a,round(m.ct.x.tab[i,i]/sum(m.ct.x.tab[i,]),4))
a<-table.row.end(a)
}
a<-table.row.start(a)
a<-table.element(a,'Overall',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,'-')
a<-table.element(a,round(m.ct.i.cp,4))
for (jjj in 1:par3) a<-table.element(a,'-')
a<-table.element(a,round(m.ct.x.cp,4))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
}
}
m
bitmap(file='test1.png')
plot(m)
dev.off()
bitmap(file='test1a.png')
plot(x[,par1] ~ as.factor(where(m)),main='Response by Terminal Node',xlab='Terminal Node',ylab='Response')
dev.off()
if (par2 == 'none') {
forec <- predict(m)
result <- as.data.frame(cbind(x[,par1],forec,x[,par1]-forec))
colnames(result) <- c('Actuals','Forecasts','Residuals')
print(result)
}
if (par2 != 'none') {
print(cbind(as.factor(x[,par1]),predict(m)))
myt <- table(as.factor(x[,par1]),predict(m))
print(myt)
}
bitmap(file='test2.png')
if(par2=='none') {
op <- par(mfrow=c(2,2))
plot(density(result$Actuals),main='Kernel Density Plot of Actuals')
plot(density(result$Residuals),main='Kernel Density Plot of Residuals')
plot(result$Forecasts,result$Actuals,main='Actuals versus Predictions',xlab='Predictions',ylab='Actuals')
plot(density(result$Forecasts),main='Kernel Density Plot of Predictions')
par(op)
}
if(par2!='none') {
plot(myt,main='Confusion Matrix',xlab='Actual',ylab='Predicted')
}
dev.off()
if (par2 == 'none') {
detcoef <- cor(result$Forecasts,result$Actuals)
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Goodness of Fit',2,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Correlation',1,TRUE)
a<-table.element(a,round(detcoef,4))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'R-squared',1,TRUE)
a<-table.element(a,round(detcoef*detcoef,4))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'RMSE',1,TRUE)
a<-table.element(a,round(sqrt(mean((result$Residuals)^2)),4))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable1.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Actuals, Predictions, and Residuals',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'#',header=TRUE)
a<-table.element(a,'Actuals',header=TRUE)
a<-table.element(a,'Forecasts',header=TRUE)
a<-table.element(a,'Residuals',header=TRUE)
a<-table.row.end(a)
for (i in 1:length(result$Actuals)) {
a<-table.row.start(a)
a<-table.element(a,i,header=TRUE)
a<-table.element(a,result$Actuals[i])
a<-table.element(a,result$Forecasts[i])
a<-table.element(a,result$Residuals[i])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable.tab')
}
if (par2 != 'none') {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Confusion Matrix (predicted in columns / actuals in rows)',par3+1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'',1,TRUE)
for (i in 1:par3) {
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
}
a<-table.row.end(a)
for (i in 1:par3) {
a<-table.row.start(a)
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
for (j in 1:par3) {
a<-table.element(a,myt[i,j])
}
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable2.tab')
}