Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1dm.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationMon, 30 Apr 2012 04:16:22 -0400
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2012/Apr/30/t1335773826nyqkgx374emsan0.htm/, Retrieved Mon, 29 Apr 2024 01:27:27 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=165192, Retrieved Mon, 29 Apr 2024 01:27:27 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact144
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [male] [2012-04-30 08:16:22] [d861fb3c1cdd18b4ea6f62eadbbffc7b] [Current]
Feedback Forum

Post a new message




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

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







Goodness of Fit
Correlation0.369
R-squared0.1361
RMSE18.7189

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.369[/C][/ROW]
[ROW][C]R-squared[/C][C]0.1361[/C][/ROW]
[ROW][C]RMSE[/C][C]18.7189[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=165192&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165192&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.369
R-squared0.1361
RMSE18.7189







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1176189.1-13.1
2150171.426229508197-21.4262295081967
3156171.426229508197-15.4262295081967
4172171.4262295081970.573770491803288
5177171.4262295081975.57377049180329
6208171.42622950819736.5737704918033
7165171.426229508197-6.42622950819671
8192184.906257.09375
9174171.4262295081972.57377049180329
10140171.426229508197-31.4262295081967
11183171.42622950819711.5737704918033
12173171.4262295081971.57377049180329
13152171.426229508197-19.4262295081967
14161171.426229508197-10.4262295081967
15144171.426229508197-27.4262295081967
16163171.426229508197-8.42622950819671
17159171.426229508197-12.4262295081967
18170171.426229508197-1.42622950819671
19129171.426229508197-42.4262295081967
20170171.426229508197-1.42622950819671
21174171.4262295081972.57377049180329
22181184.90625-3.90625
23144171.426229508197-27.4262295081967
24164184.90625-20.90625
25165189.1-24.1
26162171.426229508197-9.42622950819671
27163171.426229508197-8.42622950819671
28188171.42622950819716.5737704918033
29149171.426229508197-22.4262295081967
30165171.426229508197-6.42622950819671
31161171.426229508197-10.4262295081967
32158184.90625-26.90625
33170171.426229508197-1.42622950819671
34180171.4262295081978.57377049180329
35176171.4262295081974.57377049180329
36159171.426229508197-12.4262295081967
37172171.4262295081970.573770491803288
38162171.426229508197-9.42622950819671
39180184.90625-4.90625
40198184.9062513.09375
41124171.426229508197-47.4262295081967
42159171.426229508197-12.4262295081967
43178171.4262295081976.57377049180329
44180171.4262295081978.57377049180329
45176171.4262295081974.57377049180329
46183171.42622950819711.5737704918033
47149171.426229508197-22.4262295081967
48168184.90625-16.90625
49186171.42622950819714.5737704918033
50159171.426229508197-12.4262295081967
51163171.426229508197-8.42622950819671
52155171.426229508197-16.4262295081967
53167171.426229508197-4.42622950819671
54199171.42622950819727.5737704918033
55182171.42622950819710.5737704918033
56192171.42622950819720.5737704918033
57144184.90625-40.90625
58218184.9062533.09375
59184184.90625-0.90625
60162171.426229508197-9.42622950819671
61227184.9062542.09375
62153171.426229508197-18.4262295081967
63193189.13.90000000000001
64206184.9062521.09375
65144171.426229508197-27.4262295081967
66170171.426229508197-1.42622950819671
67169171.426229508197-2.42622950819671
68169171.426229508197-2.42622950819671
69179184.90625-5.90625
70154171.426229508197-17.4262295081967
71205171.42622950819733.5737704918033
72144171.426229508197-27.4262295081967
73185171.42622950819713.5737704918033
74174171.4262295081972.57377049180329
75169184.90625-15.90625
76185171.42622950819713.5737704918033
77176171.4262295081974.57377049180329
78184184.90625-0.90625
79177171.4262295081975.57377049180329
80178171.4262295081976.57377049180329
81182171.42622950819710.5737704918033
82168171.426229508197-3.42622950819671
83189171.42622950819717.5737704918033
84179184.90625-5.90625
85167171.426229508197-4.42622950819671
86176171.4262295081974.57377049180329
87188171.42622950819716.5737704918033
88115171.426229508197-56.4262295081967
89222189.132.9
90172171.4262295081970.573770491803288
91168171.426229508197-3.42622950819671
92219189.129.9
93197184.9062512.09375
94158171.426229508197-13.4262295081967
95169171.426229508197-2.42622950819671
96193189.13.90000000000001
97169189.1-20.1
98179189.1-10.1
99170184.90625-14.90625
100160171.426229508197-11.4262295081967
101180171.4262295081978.57377049180329
102183189.1-6.09999999999999
103166171.426229508197-5.42622950819671
104191189.11.90000000000001
105181171.4262295081979.57377049180329
106180184.90625-4.90625
107158171.426229508197-13.4262295081967
108159189.1-30.1
109175189.1-14.1
110178171.4262295081976.57377049180329
111182184.90625-2.90625
112184171.42622950819712.5737704918033
113189189.1-0.0999999999999943
114181171.4262295081979.57377049180329
115193171.42622950819721.5737704918033
116175171.4262295081973.57377049180329
117167189.1-22.1
118160171.426229508197-11.4262295081967
119163184.90625-21.90625
120202171.42622950819730.5737704918033
121176171.4262295081974.57377049180329
122181171.4262295081979.57377049180329
123146171.426229508197-25.4262295081967
124194189.14.90000000000001
125202184.9062517.09375
126185189.1-4.09999999999999
127216189.126.9
128141171.426229508197-30.4262295081967
129190189.10.900000000000006
130176189.1-13.1
131207171.42622950819735.5737704918033
132163171.426229508197-8.42622950819671
133210189.120.9
134196184.9062511.09375
135163189.1-26.1
136197171.42622950819725.5737704918033
137215171.42622950819743.5737704918033
138171184.90625-13.90625
139211171.42622950819739.5737704918033
140189189.1-0.0999999999999943
141169171.426229508197-2.42622950819671
142189171.42622950819717.5737704918033
143141171.426229508197-30.4262295081967
144194189.14.90000000000001
145171184.90625-13.90625
146141171.426229508197-30.4262295081967
147207171.42622950819735.5737704918033
148170171.426229508197-1.42622950819671
149187171.42622950819715.5737704918033
150188189.1-1.09999999999999
151188189.1-1.09999999999999
152204171.42622950819732.5737704918033
153163184.90625-21.90625
154214184.9062529.09375
155172171.4262295081970.573770491803288
156173171.4262295081971.57377049180329
157188171.42622950819716.5737704918033
158202184.9062517.09375
159211184.9062526.09375
160173171.4262295081971.57377049180329
161186184.906251.09375
162192189.12.90000000000001
163219171.42622950819747.5737704918033
164180171.4262295081978.57377049180329
165210189.120.9
166164184.90625-20.90625
167175171.4262295081973.57377049180329
168198189.18.90000000000001
169214184.9062529.09375
170180171.4262295081978.57377049180329
171210171.42622950819738.5737704918033
172197189.17.90000000000001
173146171.426229508197-25.4262295081967
174203189.113.9
175211171.42622950819739.5737704918033
176165171.426229508197-6.42622950819671
177169171.426229508197-2.42622950819671
178163171.426229508197-8.42622950819671
179176171.4262295081974.57377049180329
180181171.4262295081979.57377049180329
181148171.426229508197-23.4262295081967
182167171.426229508197-4.42622950819671
183144171.426229508197-27.4262295081967
184191171.42622950819719.5737704918033

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 176 & 189.1 & -13.1 \tabularnewline
2 & 150 & 171.426229508197 & -21.4262295081967 \tabularnewline
3 & 156 & 171.426229508197 & -15.4262295081967 \tabularnewline
4 & 172 & 171.426229508197 & 0.573770491803288 \tabularnewline
5 & 177 & 171.426229508197 & 5.57377049180329 \tabularnewline
6 & 208 & 171.426229508197 & 36.5737704918033 \tabularnewline
7 & 165 & 171.426229508197 & -6.42622950819671 \tabularnewline
8 & 192 & 184.90625 & 7.09375 \tabularnewline
9 & 174 & 171.426229508197 & 2.57377049180329 \tabularnewline
10 & 140 & 171.426229508197 & -31.4262295081967 \tabularnewline
11 & 183 & 171.426229508197 & 11.5737704918033 \tabularnewline
12 & 173 & 171.426229508197 & 1.57377049180329 \tabularnewline
13 & 152 & 171.426229508197 & -19.4262295081967 \tabularnewline
14 & 161 & 171.426229508197 & -10.4262295081967 \tabularnewline
15 & 144 & 171.426229508197 & -27.4262295081967 \tabularnewline
16 & 163 & 171.426229508197 & -8.42622950819671 \tabularnewline
17 & 159 & 171.426229508197 & -12.4262295081967 \tabularnewline
18 & 170 & 171.426229508197 & -1.42622950819671 \tabularnewline
19 & 129 & 171.426229508197 & -42.4262295081967 \tabularnewline
20 & 170 & 171.426229508197 & -1.42622950819671 \tabularnewline
21 & 174 & 171.426229508197 & 2.57377049180329 \tabularnewline
22 & 181 & 184.90625 & -3.90625 \tabularnewline
23 & 144 & 171.426229508197 & -27.4262295081967 \tabularnewline
24 & 164 & 184.90625 & -20.90625 \tabularnewline
25 & 165 & 189.1 & -24.1 \tabularnewline
26 & 162 & 171.426229508197 & -9.42622950819671 \tabularnewline
27 & 163 & 171.426229508197 & -8.42622950819671 \tabularnewline
28 & 188 & 171.426229508197 & 16.5737704918033 \tabularnewline
29 & 149 & 171.426229508197 & -22.4262295081967 \tabularnewline
30 & 165 & 171.426229508197 & -6.42622950819671 \tabularnewline
31 & 161 & 171.426229508197 & -10.4262295081967 \tabularnewline
32 & 158 & 184.90625 & -26.90625 \tabularnewline
33 & 170 & 171.426229508197 & -1.42622950819671 \tabularnewline
34 & 180 & 171.426229508197 & 8.57377049180329 \tabularnewline
35 & 176 & 171.426229508197 & 4.57377049180329 \tabularnewline
36 & 159 & 171.426229508197 & -12.4262295081967 \tabularnewline
37 & 172 & 171.426229508197 & 0.573770491803288 \tabularnewline
38 & 162 & 171.426229508197 & -9.42622950819671 \tabularnewline
39 & 180 & 184.90625 & -4.90625 \tabularnewline
40 & 198 & 184.90625 & 13.09375 \tabularnewline
41 & 124 & 171.426229508197 & -47.4262295081967 \tabularnewline
42 & 159 & 171.426229508197 & -12.4262295081967 \tabularnewline
43 & 178 & 171.426229508197 & 6.57377049180329 \tabularnewline
44 & 180 & 171.426229508197 & 8.57377049180329 \tabularnewline
45 & 176 & 171.426229508197 & 4.57377049180329 \tabularnewline
46 & 183 & 171.426229508197 & 11.5737704918033 \tabularnewline
47 & 149 & 171.426229508197 & -22.4262295081967 \tabularnewline
48 & 168 & 184.90625 & -16.90625 \tabularnewline
49 & 186 & 171.426229508197 & 14.5737704918033 \tabularnewline
50 & 159 & 171.426229508197 & -12.4262295081967 \tabularnewline
51 & 163 & 171.426229508197 & -8.42622950819671 \tabularnewline
52 & 155 & 171.426229508197 & -16.4262295081967 \tabularnewline
53 & 167 & 171.426229508197 & -4.42622950819671 \tabularnewline
54 & 199 & 171.426229508197 & 27.5737704918033 \tabularnewline
55 & 182 & 171.426229508197 & 10.5737704918033 \tabularnewline
56 & 192 & 171.426229508197 & 20.5737704918033 \tabularnewline
57 & 144 & 184.90625 & -40.90625 \tabularnewline
58 & 218 & 184.90625 & 33.09375 \tabularnewline
59 & 184 & 184.90625 & -0.90625 \tabularnewline
60 & 162 & 171.426229508197 & -9.42622950819671 \tabularnewline
61 & 227 & 184.90625 & 42.09375 \tabularnewline
62 & 153 & 171.426229508197 & -18.4262295081967 \tabularnewline
63 & 193 & 189.1 & 3.90000000000001 \tabularnewline
64 & 206 & 184.90625 & 21.09375 \tabularnewline
65 & 144 & 171.426229508197 & -27.4262295081967 \tabularnewline
66 & 170 & 171.426229508197 & -1.42622950819671 \tabularnewline
67 & 169 & 171.426229508197 & -2.42622950819671 \tabularnewline
68 & 169 & 171.426229508197 & -2.42622950819671 \tabularnewline
69 & 179 & 184.90625 & -5.90625 \tabularnewline
70 & 154 & 171.426229508197 & -17.4262295081967 \tabularnewline
71 & 205 & 171.426229508197 & 33.5737704918033 \tabularnewline
72 & 144 & 171.426229508197 & -27.4262295081967 \tabularnewline
73 & 185 & 171.426229508197 & 13.5737704918033 \tabularnewline
74 & 174 & 171.426229508197 & 2.57377049180329 \tabularnewline
75 & 169 & 184.90625 & -15.90625 \tabularnewline
76 & 185 & 171.426229508197 & 13.5737704918033 \tabularnewline
77 & 176 & 171.426229508197 & 4.57377049180329 \tabularnewline
78 & 184 & 184.90625 & -0.90625 \tabularnewline
79 & 177 & 171.426229508197 & 5.57377049180329 \tabularnewline
80 & 178 & 171.426229508197 & 6.57377049180329 \tabularnewline
81 & 182 & 171.426229508197 & 10.5737704918033 \tabularnewline
82 & 168 & 171.426229508197 & -3.42622950819671 \tabularnewline
83 & 189 & 171.426229508197 & 17.5737704918033 \tabularnewline
84 & 179 & 184.90625 & -5.90625 \tabularnewline
85 & 167 & 171.426229508197 & -4.42622950819671 \tabularnewline
86 & 176 & 171.426229508197 & 4.57377049180329 \tabularnewline
87 & 188 & 171.426229508197 & 16.5737704918033 \tabularnewline
88 & 115 & 171.426229508197 & -56.4262295081967 \tabularnewline
89 & 222 & 189.1 & 32.9 \tabularnewline
90 & 172 & 171.426229508197 & 0.573770491803288 \tabularnewline
91 & 168 & 171.426229508197 & -3.42622950819671 \tabularnewline
92 & 219 & 189.1 & 29.9 \tabularnewline
93 & 197 & 184.90625 & 12.09375 \tabularnewline
94 & 158 & 171.426229508197 & -13.4262295081967 \tabularnewline
95 & 169 & 171.426229508197 & -2.42622950819671 \tabularnewline
96 & 193 & 189.1 & 3.90000000000001 \tabularnewline
97 & 169 & 189.1 & -20.1 \tabularnewline
98 & 179 & 189.1 & -10.1 \tabularnewline
99 & 170 & 184.90625 & -14.90625 \tabularnewline
100 & 160 & 171.426229508197 & -11.4262295081967 \tabularnewline
101 & 180 & 171.426229508197 & 8.57377049180329 \tabularnewline
102 & 183 & 189.1 & -6.09999999999999 \tabularnewline
103 & 166 & 171.426229508197 & -5.42622950819671 \tabularnewline
104 & 191 & 189.1 & 1.90000000000001 \tabularnewline
105 & 181 & 171.426229508197 & 9.57377049180329 \tabularnewline
106 & 180 & 184.90625 & -4.90625 \tabularnewline
107 & 158 & 171.426229508197 & -13.4262295081967 \tabularnewline
108 & 159 & 189.1 & -30.1 \tabularnewline
109 & 175 & 189.1 & -14.1 \tabularnewline
110 & 178 & 171.426229508197 & 6.57377049180329 \tabularnewline
111 & 182 & 184.90625 & -2.90625 \tabularnewline
112 & 184 & 171.426229508197 & 12.5737704918033 \tabularnewline
113 & 189 & 189.1 & -0.0999999999999943 \tabularnewline
114 & 181 & 171.426229508197 & 9.57377049180329 \tabularnewline
115 & 193 & 171.426229508197 & 21.5737704918033 \tabularnewline
116 & 175 & 171.426229508197 & 3.57377049180329 \tabularnewline
117 & 167 & 189.1 & -22.1 \tabularnewline
118 & 160 & 171.426229508197 & -11.4262295081967 \tabularnewline
119 & 163 & 184.90625 & -21.90625 \tabularnewline
120 & 202 & 171.426229508197 & 30.5737704918033 \tabularnewline
121 & 176 & 171.426229508197 & 4.57377049180329 \tabularnewline
122 & 181 & 171.426229508197 & 9.57377049180329 \tabularnewline
123 & 146 & 171.426229508197 & -25.4262295081967 \tabularnewline
124 & 194 & 189.1 & 4.90000000000001 \tabularnewline
125 & 202 & 184.90625 & 17.09375 \tabularnewline
126 & 185 & 189.1 & -4.09999999999999 \tabularnewline
127 & 216 & 189.1 & 26.9 \tabularnewline
128 & 141 & 171.426229508197 & -30.4262295081967 \tabularnewline
129 & 190 & 189.1 & 0.900000000000006 \tabularnewline
130 & 176 & 189.1 & -13.1 \tabularnewline
131 & 207 & 171.426229508197 & 35.5737704918033 \tabularnewline
132 & 163 & 171.426229508197 & -8.42622950819671 \tabularnewline
133 & 210 & 189.1 & 20.9 \tabularnewline
134 & 196 & 184.90625 & 11.09375 \tabularnewline
135 & 163 & 189.1 & -26.1 \tabularnewline
136 & 197 & 171.426229508197 & 25.5737704918033 \tabularnewline
137 & 215 & 171.426229508197 & 43.5737704918033 \tabularnewline
138 & 171 & 184.90625 & -13.90625 \tabularnewline
139 & 211 & 171.426229508197 & 39.5737704918033 \tabularnewline
140 & 189 & 189.1 & -0.0999999999999943 \tabularnewline
141 & 169 & 171.426229508197 & -2.42622950819671 \tabularnewline
142 & 189 & 171.426229508197 & 17.5737704918033 \tabularnewline
143 & 141 & 171.426229508197 & -30.4262295081967 \tabularnewline
144 & 194 & 189.1 & 4.90000000000001 \tabularnewline
145 & 171 & 184.90625 & -13.90625 \tabularnewline
146 & 141 & 171.426229508197 & -30.4262295081967 \tabularnewline
147 & 207 & 171.426229508197 & 35.5737704918033 \tabularnewline
148 & 170 & 171.426229508197 & -1.42622950819671 \tabularnewline
149 & 187 & 171.426229508197 & 15.5737704918033 \tabularnewline
150 & 188 & 189.1 & -1.09999999999999 \tabularnewline
151 & 188 & 189.1 & -1.09999999999999 \tabularnewline
152 & 204 & 171.426229508197 & 32.5737704918033 \tabularnewline
153 & 163 & 184.90625 & -21.90625 \tabularnewline
154 & 214 & 184.90625 & 29.09375 \tabularnewline
155 & 172 & 171.426229508197 & 0.573770491803288 \tabularnewline
156 & 173 & 171.426229508197 & 1.57377049180329 \tabularnewline
157 & 188 & 171.426229508197 & 16.5737704918033 \tabularnewline
158 & 202 & 184.90625 & 17.09375 \tabularnewline
159 & 211 & 184.90625 & 26.09375 \tabularnewline
160 & 173 & 171.426229508197 & 1.57377049180329 \tabularnewline
161 & 186 & 184.90625 & 1.09375 \tabularnewline
162 & 192 & 189.1 & 2.90000000000001 \tabularnewline
163 & 219 & 171.426229508197 & 47.5737704918033 \tabularnewline
164 & 180 & 171.426229508197 & 8.57377049180329 \tabularnewline
165 & 210 & 189.1 & 20.9 \tabularnewline
166 & 164 & 184.90625 & -20.90625 \tabularnewline
167 & 175 & 171.426229508197 & 3.57377049180329 \tabularnewline
168 & 198 & 189.1 & 8.90000000000001 \tabularnewline
169 & 214 & 184.90625 & 29.09375 \tabularnewline
170 & 180 & 171.426229508197 & 8.57377049180329 \tabularnewline
171 & 210 & 171.426229508197 & 38.5737704918033 \tabularnewline
172 & 197 & 189.1 & 7.90000000000001 \tabularnewline
173 & 146 & 171.426229508197 & -25.4262295081967 \tabularnewline
174 & 203 & 189.1 & 13.9 \tabularnewline
175 & 211 & 171.426229508197 & 39.5737704918033 \tabularnewline
176 & 165 & 171.426229508197 & -6.42622950819671 \tabularnewline
177 & 169 & 171.426229508197 & -2.42622950819671 \tabularnewline
178 & 163 & 171.426229508197 & -8.42622950819671 \tabularnewline
179 & 176 & 171.426229508197 & 4.57377049180329 \tabularnewline
180 & 181 & 171.426229508197 & 9.57377049180329 \tabularnewline
181 & 148 & 171.426229508197 & -23.4262295081967 \tabularnewline
182 & 167 & 171.426229508197 & -4.42622950819671 \tabularnewline
183 & 144 & 171.426229508197 & -27.4262295081967 \tabularnewline
184 & 191 & 171.426229508197 & 19.5737704918033 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=165192&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]176[/C][C]189.1[/C][C]-13.1[/C][/ROW]
[ROW][C]2[/C][C]150[/C][C]171.426229508197[/C][C]-21.4262295081967[/C][/ROW]
[ROW][C]3[/C][C]156[/C][C]171.426229508197[/C][C]-15.4262295081967[/C][/ROW]
[ROW][C]4[/C][C]172[/C][C]171.426229508197[/C][C]0.573770491803288[/C][/ROW]
[ROW][C]5[/C][C]177[/C][C]171.426229508197[/C][C]5.57377049180329[/C][/ROW]
[ROW][C]6[/C][C]208[/C][C]171.426229508197[/C][C]36.5737704918033[/C][/ROW]
[ROW][C]7[/C][C]165[/C][C]171.426229508197[/C][C]-6.42622950819671[/C][/ROW]
[ROW][C]8[/C][C]192[/C][C]184.90625[/C][C]7.09375[/C][/ROW]
[ROW][C]9[/C][C]174[/C][C]171.426229508197[/C][C]2.57377049180329[/C][/ROW]
[ROW][C]10[/C][C]140[/C][C]171.426229508197[/C][C]-31.4262295081967[/C][/ROW]
[ROW][C]11[/C][C]183[/C][C]171.426229508197[/C][C]11.5737704918033[/C][/ROW]
[ROW][C]12[/C][C]173[/C][C]171.426229508197[/C][C]1.57377049180329[/C][/ROW]
[ROW][C]13[/C][C]152[/C][C]171.426229508197[/C][C]-19.4262295081967[/C][/ROW]
[ROW][C]14[/C][C]161[/C][C]171.426229508197[/C][C]-10.4262295081967[/C][/ROW]
[ROW][C]15[/C][C]144[/C][C]171.426229508197[/C][C]-27.4262295081967[/C][/ROW]
[ROW][C]16[/C][C]163[/C][C]171.426229508197[/C][C]-8.42622950819671[/C][/ROW]
[ROW][C]17[/C][C]159[/C][C]171.426229508197[/C][C]-12.4262295081967[/C][/ROW]
[ROW][C]18[/C][C]170[/C][C]171.426229508197[/C][C]-1.42622950819671[/C][/ROW]
[ROW][C]19[/C][C]129[/C][C]171.426229508197[/C][C]-42.4262295081967[/C][/ROW]
[ROW][C]20[/C][C]170[/C][C]171.426229508197[/C][C]-1.42622950819671[/C][/ROW]
[ROW][C]21[/C][C]174[/C][C]171.426229508197[/C][C]2.57377049180329[/C][/ROW]
[ROW][C]22[/C][C]181[/C][C]184.90625[/C][C]-3.90625[/C][/ROW]
[ROW][C]23[/C][C]144[/C][C]171.426229508197[/C][C]-27.4262295081967[/C][/ROW]
[ROW][C]24[/C][C]164[/C][C]184.90625[/C][C]-20.90625[/C][/ROW]
[ROW][C]25[/C][C]165[/C][C]189.1[/C][C]-24.1[/C][/ROW]
[ROW][C]26[/C][C]162[/C][C]171.426229508197[/C][C]-9.42622950819671[/C][/ROW]
[ROW][C]27[/C][C]163[/C][C]171.426229508197[/C][C]-8.42622950819671[/C][/ROW]
[ROW][C]28[/C][C]188[/C][C]171.426229508197[/C][C]16.5737704918033[/C][/ROW]
[ROW][C]29[/C][C]149[/C][C]171.426229508197[/C][C]-22.4262295081967[/C][/ROW]
[ROW][C]30[/C][C]165[/C][C]171.426229508197[/C][C]-6.42622950819671[/C][/ROW]
[ROW][C]31[/C][C]161[/C][C]171.426229508197[/C][C]-10.4262295081967[/C][/ROW]
[ROW][C]32[/C][C]158[/C][C]184.90625[/C][C]-26.90625[/C][/ROW]
[ROW][C]33[/C][C]170[/C][C]171.426229508197[/C][C]-1.42622950819671[/C][/ROW]
[ROW][C]34[/C][C]180[/C][C]171.426229508197[/C][C]8.57377049180329[/C][/ROW]
[ROW][C]35[/C][C]176[/C][C]171.426229508197[/C][C]4.57377049180329[/C][/ROW]
[ROW][C]36[/C][C]159[/C][C]171.426229508197[/C][C]-12.4262295081967[/C][/ROW]
[ROW][C]37[/C][C]172[/C][C]171.426229508197[/C][C]0.573770491803288[/C][/ROW]
[ROW][C]38[/C][C]162[/C][C]171.426229508197[/C][C]-9.42622950819671[/C][/ROW]
[ROW][C]39[/C][C]180[/C][C]184.90625[/C][C]-4.90625[/C][/ROW]
[ROW][C]40[/C][C]198[/C][C]184.90625[/C][C]13.09375[/C][/ROW]
[ROW][C]41[/C][C]124[/C][C]171.426229508197[/C][C]-47.4262295081967[/C][/ROW]
[ROW][C]42[/C][C]159[/C][C]171.426229508197[/C][C]-12.4262295081967[/C][/ROW]
[ROW][C]43[/C][C]178[/C][C]171.426229508197[/C][C]6.57377049180329[/C][/ROW]
[ROW][C]44[/C][C]180[/C][C]171.426229508197[/C][C]8.57377049180329[/C][/ROW]
[ROW][C]45[/C][C]176[/C][C]171.426229508197[/C][C]4.57377049180329[/C][/ROW]
[ROW][C]46[/C][C]183[/C][C]171.426229508197[/C][C]11.5737704918033[/C][/ROW]
[ROW][C]47[/C][C]149[/C][C]171.426229508197[/C][C]-22.4262295081967[/C][/ROW]
[ROW][C]48[/C][C]168[/C][C]184.90625[/C][C]-16.90625[/C][/ROW]
[ROW][C]49[/C][C]186[/C][C]171.426229508197[/C][C]14.5737704918033[/C][/ROW]
[ROW][C]50[/C][C]159[/C][C]171.426229508197[/C][C]-12.4262295081967[/C][/ROW]
[ROW][C]51[/C][C]163[/C][C]171.426229508197[/C][C]-8.42622950819671[/C][/ROW]
[ROW][C]52[/C][C]155[/C][C]171.426229508197[/C][C]-16.4262295081967[/C][/ROW]
[ROW][C]53[/C][C]167[/C][C]171.426229508197[/C][C]-4.42622950819671[/C][/ROW]
[ROW][C]54[/C][C]199[/C][C]171.426229508197[/C][C]27.5737704918033[/C][/ROW]
[ROW][C]55[/C][C]182[/C][C]171.426229508197[/C][C]10.5737704918033[/C][/ROW]
[ROW][C]56[/C][C]192[/C][C]171.426229508197[/C][C]20.5737704918033[/C][/ROW]
[ROW][C]57[/C][C]144[/C][C]184.90625[/C][C]-40.90625[/C][/ROW]
[ROW][C]58[/C][C]218[/C][C]184.90625[/C][C]33.09375[/C][/ROW]
[ROW][C]59[/C][C]184[/C][C]184.90625[/C][C]-0.90625[/C][/ROW]
[ROW][C]60[/C][C]162[/C][C]171.426229508197[/C][C]-9.42622950819671[/C][/ROW]
[ROW][C]61[/C][C]227[/C][C]184.90625[/C][C]42.09375[/C][/ROW]
[ROW][C]62[/C][C]153[/C][C]171.426229508197[/C][C]-18.4262295081967[/C][/ROW]
[ROW][C]63[/C][C]193[/C][C]189.1[/C][C]3.90000000000001[/C][/ROW]
[ROW][C]64[/C][C]206[/C][C]184.90625[/C][C]21.09375[/C][/ROW]
[ROW][C]65[/C][C]144[/C][C]171.426229508197[/C][C]-27.4262295081967[/C][/ROW]
[ROW][C]66[/C][C]170[/C][C]171.426229508197[/C][C]-1.42622950819671[/C][/ROW]
[ROW][C]67[/C][C]169[/C][C]171.426229508197[/C][C]-2.42622950819671[/C][/ROW]
[ROW][C]68[/C][C]169[/C][C]171.426229508197[/C][C]-2.42622950819671[/C][/ROW]
[ROW][C]69[/C][C]179[/C][C]184.90625[/C][C]-5.90625[/C][/ROW]
[ROW][C]70[/C][C]154[/C][C]171.426229508197[/C][C]-17.4262295081967[/C][/ROW]
[ROW][C]71[/C][C]205[/C][C]171.426229508197[/C][C]33.5737704918033[/C][/ROW]
[ROW][C]72[/C][C]144[/C][C]171.426229508197[/C][C]-27.4262295081967[/C][/ROW]
[ROW][C]73[/C][C]185[/C][C]171.426229508197[/C][C]13.5737704918033[/C][/ROW]
[ROW][C]74[/C][C]174[/C][C]171.426229508197[/C][C]2.57377049180329[/C][/ROW]
[ROW][C]75[/C][C]169[/C][C]184.90625[/C][C]-15.90625[/C][/ROW]
[ROW][C]76[/C][C]185[/C][C]171.426229508197[/C][C]13.5737704918033[/C][/ROW]
[ROW][C]77[/C][C]176[/C][C]171.426229508197[/C][C]4.57377049180329[/C][/ROW]
[ROW][C]78[/C][C]184[/C][C]184.90625[/C][C]-0.90625[/C][/ROW]
[ROW][C]79[/C][C]177[/C][C]171.426229508197[/C][C]5.57377049180329[/C][/ROW]
[ROW][C]80[/C][C]178[/C][C]171.426229508197[/C][C]6.57377049180329[/C][/ROW]
[ROW][C]81[/C][C]182[/C][C]171.426229508197[/C][C]10.5737704918033[/C][/ROW]
[ROW][C]82[/C][C]168[/C][C]171.426229508197[/C][C]-3.42622950819671[/C][/ROW]
[ROW][C]83[/C][C]189[/C][C]171.426229508197[/C][C]17.5737704918033[/C][/ROW]
[ROW][C]84[/C][C]179[/C][C]184.90625[/C][C]-5.90625[/C][/ROW]
[ROW][C]85[/C][C]167[/C][C]171.426229508197[/C][C]-4.42622950819671[/C][/ROW]
[ROW][C]86[/C][C]176[/C][C]171.426229508197[/C][C]4.57377049180329[/C][/ROW]
[ROW][C]87[/C][C]188[/C][C]171.426229508197[/C][C]16.5737704918033[/C][/ROW]
[ROW][C]88[/C][C]115[/C][C]171.426229508197[/C][C]-56.4262295081967[/C][/ROW]
[ROW][C]89[/C][C]222[/C][C]189.1[/C][C]32.9[/C][/ROW]
[ROW][C]90[/C][C]172[/C][C]171.426229508197[/C][C]0.573770491803288[/C][/ROW]
[ROW][C]91[/C][C]168[/C][C]171.426229508197[/C][C]-3.42622950819671[/C][/ROW]
[ROW][C]92[/C][C]219[/C][C]189.1[/C][C]29.9[/C][/ROW]
[ROW][C]93[/C][C]197[/C][C]184.90625[/C][C]12.09375[/C][/ROW]
[ROW][C]94[/C][C]158[/C][C]171.426229508197[/C][C]-13.4262295081967[/C][/ROW]
[ROW][C]95[/C][C]169[/C][C]171.426229508197[/C][C]-2.42622950819671[/C][/ROW]
[ROW][C]96[/C][C]193[/C][C]189.1[/C][C]3.90000000000001[/C][/ROW]
[ROW][C]97[/C][C]169[/C][C]189.1[/C][C]-20.1[/C][/ROW]
[ROW][C]98[/C][C]179[/C][C]189.1[/C][C]-10.1[/C][/ROW]
[ROW][C]99[/C][C]170[/C][C]184.90625[/C][C]-14.90625[/C][/ROW]
[ROW][C]100[/C][C]160[/C][C]171.426229508197[/C][C]-11.4262295081967[/C][/ROW]
[ROW][C]101[/C][C]180[/C][C]171.426229508197[/C][C]8.57377049180329[/C][/ROW]
[ROW][C]102[/C][C]183[/C][C]189.1[/C][C]-6.09999999999999[/C][/ROW]
[ROW][C]103[/C][C]166[/C][C]171.426229508197[/C][C]-5.42622950819671[/C][/ROW]
[ROW][C]104[/C][C]191[/C][C]189.1[/C][C]1.90000000000001[/C][/ROW]
[ROW][C]105[/C][C]181[/C][C]171.426229508197[/C][C]9.57377049180329[/C][/ROW]
[ROW][C]106[/C][C]180[/C][C]184.90625[/C][C]-4.90625[/C][/ROW]
[ROW][C]107[/C][C]158[/C][C]171.426229508197[/C][C]-13.4262295081967[/C][/ROW]
[ROW][C]108[/C][C]159[/C][C]189.1[/C][C]-30.1[/C][/ROW]
[ROW][C]109[/C][C]175[/C][C]189.1[/C][C]-14.1[/C][/ROW]
[ROW][C]110[/C][C]178[/C][C]171.426229508197[/C][C]6.57377049180329[/C][/ROW]
[ROW][C]111[/C][C]182[/C][C]184.90625[/C][C]-2.90625[/C][/ROW]
[ROW][C]112[/C][C]184[/C][C]171.426229508197[/C][C]12.5737704918033[/C][/ROW]
[ROW][C]113[/C][C]189[/C][C]189.1[/C][C]-0.0999999999999943[/C][/ROW]
[ROW][C]114[/C][C]181[/C][C]171.426229508197[/C][C]9.57377049180329[/C][/ROW]
[ROW][C]115[/C][C]193[/C][C]171.426229508197[/C][C]21.5737704918033[/C][/ROW]
[ROW][C]116[/C][C]175[/C][C]171.426229508197[/C][C]3.57377049180329[/C][/ROW]
[ROW][C]117[/C][C]167[/C][C]189.1[/C][C]-22.1[/C][/ROW]
[ROW][C]118[/C][C]160[/C][C]171.426229508197[/C][C]-11.4262295081967[/C][/ROW]
[ROW][C]119[/C][C]163[/C][C]184.90625[/C][C]-21.90625[/C][/ROW]
[ROW][C]120[/C][C]202[/C][C]171.426229508197[/C][C]30.5737704918033[/C][/ROW]
[ROW][C]121[/C][C]176[/C][C]171.426229508197[/C][C]4.57377049180329[/C][/ROW]
[ROW][C]122[/C][C]181[/C][C]171.426229508197[/C][C]9.57377049180329[/C][/ROW]
[ROW][C]123[/C][C]146[/C][C]171.426229508197[/C][C]-25.4262295081967[/C][/ROW]
[ROW][C]124[/C][C]194[/C][C]189.1[/C][C]4.90000000000001[/C][/ROW]
[ROW][C]125[/C][C]202[/C][C]184.90625[/C][C]17.09375[/C][/ROW]
[ROW][C]126[/C][C]185[/C][C]189.1[/C][C]-4.09999999999999[/C][/ROW]
[ROW][C]127[/C][C]216[/C][C]189.1[/C][C]26.9[/C][/ROW]
[ROW][C]128[/C][C]141[/C][C]171.426229508197[/C][C]-30.4262295081967[/C][/ROW]
[ROW][C]129[/C][C]190[/C][C]189.1[/C][C]0.900000000000006[/C][/ROW]
[ROW][C]130[/C][C]176[/C][C]189.1[/C][C]-13.1[/C][/ROW]
[ROW][C]131[/C][C]207[/C][C]171.426229508197[/C][C]35.5737704918033[/C][/ROW]
[ROW][C]132[/C][C]163[/C][C]171.426229508197[/C][C]-8.42622950819671[/C][/ROW]
[ROW][C]133[/C][C]210[/C][C]189.1[/C][C]20.9[/C][/ROW]
[ROW][C]134[/C][C]196[/C][C]184.90625[/C][C]11.09375[/C][/ROW]
[ROW][C]135[/C][C]163[/C][C]189.1[/C][C]-26.1[/C][/ROW]
[ROW][C]136[/C][C]197[/C][C]171.426229508197[/C][C]25.5737704918033[/C][/ROW]
[ROW][C]137[/C][C]215[/C][C]171.426229508197[/C][C]43.5737704918033[/C][/ROW]
[ROW][C]138[/C][C]171[/C][C]184.90625[/C][C]-13.90625[/C][/ROW]
[ROW][C]139[/C][C]211[/C][C]171.426229508197[/C][C]39.5737704918033[/C][/ROW]
[ROW][C]140[/C][C]189[/C][C]189.1[/C][C]-0.0999999999999943[/C][/ROW]
[ROW][C]141[/C][C]169[/C][C]171.426229508197[/C][C]-2.42622950819671[/C][/ROW]
[ROW][C]142[/C][C]189[/C][C]171.426229508197[/C][C]17.5737704918033[/C][/ROW]
[ROW][C]143[/C][C]141[/C][C]171.426229508197[/C][C]-30.4262295081967[/C][/ROW]
[ROW][C]144[/C][C]194[/C][C]189.1[/C][C]4.90000000000001[/C][/ROW]
[ROW][C]145[/C][C]171[/C][C]184.90625[/C][C]-13.90625[/C][/ROW]
[ROW][C]146[/C][C]141[/C][C]171.426229508197[/C][C]-30.4262295081967[/C][/ROW]
[ROW][C]147[/C][C]207[/C][C]171.426229508197[/C][C]35.5737704918033[/C][/ROW]
[ROW][C]148[/C][C]170[/C][C]171.426229508197[/C][C]-1.42622950819671[/C][/ROW]
[ROW][C]149[/C][C]187[/C][C]171.426229508197[/C][C]15.5737704918033[/C][/ROW]
[ROW][C]150[/C][C]188[/C][C]189.1[/C][C]-1.09999999999999[/C][/ROW]
[ROW][C]151[/C][C]188[/C][C]189.1[/C][C]-1.09999999999999[/C][/ROW]
[ROW][C]152[/C][C]204[/C][C]171.426229508197[/C][C]32.5737704918033[/C][/ROW]
[ROW][C]153[/C][C]163[/C][C]184.90625[/C][C]-21.90625[/C][/ROW]
[ROW][C]154[/C][C]214[/C][C]184.90625[/C][C]29.09375[/C][/ROW]
[ROW][C]155[/C][C]172[/C][C]171.426229508197[/C][C]0.573770491803288[/C][/ROW]
[ROW][C]156[/C][C]173[/C][C]171.426229508197[/C][C]1.57377049180329[/C][/ROW]
[ROW][C]157[/C][C]188[/C][C]171.426229508197[/C][C]16.5737704918033[/C][/ROW]
[ROW][C]158[/C][C]202[/C][C]184.90625[/C][C]17.09375[/C][/ROW]
[ROW][C]159[/C][C]211[/C][C]184.90625[/C][C]26.09375[/C][/ROW]
[ROW][C]160[/C][C]173[/C][C]171.426229508197[/C][C]1.57377049180329[/C][/ROW]
[ROW][C]161[/C][C]186[/C][C]184.90625[/C][C]1.09375[/C][/ROW]
[ROW][C]162[/C][C]192[/C][C]189.1[/C][C]2.90000000000001[/C][/ROW]
[ROW][C]163[/C][C]219[/C][C]171.426229508197[/C][C]47.5737704918033[/C][/ROW]
[ROW][C]164[/C][C]180[/C][C]171.426229508197[/C][C]8.57377049180329[/C][/ROW]
[ROW][C]165[/C][C]210[/C][C]189.1[/C][C]20.9[/C][/ROW]
[ROW][C]166[/C][C]164[/C][C]184.90625[/C][C]-20.90625[/C][/ROW]
[ROW][C]167[/C][C]175[/C][C]171.426229508197[/C][C]3.57377049180329[/C][/ROW]
[ROW][C]168[/C][C]198[/C][C]189.1[/C][C]8.90000000000001[/C][/ROW]
[ROW][C]169[/C][C]214[/C][C]184.90625[/C][C]29.09375[/C][/ROW]
[ROW][C]170[/C][C]180[/C][C]171.426229508197[/C][C]8.57377049180329[/C][/ROW]
[ROW][C]171[/C][C]210[/C][C]171.426229508197[/C][C]38.5737704918033[/C][/ROW]
[ROW][C]172[/C][C]197[/C][C]189.1[/C][C]7.90000000000001[/C][/ROW]
[ROW][C]173[/C][C]146[/C][C]171.426229508197[/C][C]-25.4262295081967[/C][/ROW]
[ROW][C]174[/C][C]203[/C][C]189.1[/C][C]13.9[/C][/ROW]
[ROW][C]175[/C][C]211[/C][C]171.426229508197[/C][C]39.5737704918033[/C][/ROW]
[ROW][C]176[/C][C]165[/C][C]171.426229508197[/C][C]-6.42622950819671[/C][/ROW]
[ROW][C]177[/C][C]169[/C][C]171.426229508197[/C][C]-2.42622950819671[/C][/ROW]
[ROW][C]178[/C][C]163[/C][C]171.426229508197[/C][C]-8.42622950819671[/C][/ROW]
[ROW][C]179[/C][C]176[/C][C]171.426229508197[/C][C]4.57377049180329[/C][/ROW]
[ROW][C]180[/C][C]181[/C][C]171.426229508197[/C][C]9.57377049180329[/C][/ROW]
[ROW][C]181[/C][C]148[/C][C]171.426229508197[/C][C]-23.4262295081967[/C][/ROW]
[ROW][C]182[/C][C]167[/C][C]171.426229508197[/C][C]-4.42622950819671[/C][/ROW]
[ROW][C]183[/C][C]144[/C][C]171.426229508197[/C][C]-27.4262295081967[/C][/ROW]
[ROW][C]184[/C][C]191[/C][C]171.426229508197[/C][C]19.5737704918033[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=165192&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165192&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
1176189.1-13.1
2150171.426229508197-21.4262295081967
3156171.426229508197-15.4262295081967
4172171.4262295081970.573770491803288
5177171.4262295081975.57377049180329
6208171.42622950819736.5737704918033
7165171.426229508197-6.42622950819671
8192184.906257.09375
9174171.4262295081972.57377049180329
10140171.426229508197-31.4262295081967
11183171.42622950819711.5737704918033
12173171.4262295081971.57377049180329
13152171.426229508197-19.4262295081967
14161171.426229508197-10.4262295081967
15144171.426229508197-27.4262295081967
16163171.426229508197-8.42622950819671
17159171.426229508197-12.4262295081967
18170171.426229508197-1.42622950819671
19129171.426229508197-42.4262295081967
20170171.426229508197-1.42622950819671
21174171.4262295081972.57377049180329
22181184.90625-3.90625
23144171.426229508197-27.4262295081967
24164184.90625-20.90625
25165189.1-24.1
26162171.426229508197-9.42622950819671
27163171.426229508197-8.42622950819671
28188171.42622950819716.5737704918033
29149171.426229508197-22.4262295081967
30165171.426229508197-6.42622950819671
31161171.426229508197-10.4262295081967
32158184.90625-26.90625
33170171.426229508197-1.42622950819671
34180171.4262295081978.57377049180329
35176171.4262295081974.57377049180329
36159171.426229508197-12.4262295081967
37172171.4262295081970.573770491803288
38162171.426229508197-9.42622950819671
39180184.90625-4.90625
40198184.9062513.09375
41124171.426229508197-47.4262295081967
42159171.426229508197-12.4262295081967
43178171.4262295081976.57377049180329
44180171.4262295081978.57377049180329
45176171.4262295081974.57377049180329
46183171.42622950819711.5737704918033
47149171.426229508197-22.4262295081967
48168184.90625-16.90625
49186171.42622950819714.5737704918033
50159171.426229508197-12.4262295081967
51163171.426229508197-8.42622950819671
52155171.426229508197-16.4262295081967
53167171.426229508197-4.42622950819671
54199171.42622950819727.5737704918033
55182171.42622950819710.5737704918033
56192171.42622950819720.5737704918033
57144184.90625-40.90625
58218184.9062533.09375
59184184.90625-0.90625
60162171.426229508197-9.42622950819671
61227184.9062542.09375
62153171.426229508197-18.4262295081967
63193189.13.90000000000001
64206184.9062521.09375
65144171.426229508197-27.4262295081967
66170171.426229508197-1.42622950819671
67169171.426229508197-2.42622950819671
68169171.426229508197-2.42622950819671
69179184.90625-5.90625
70154171.426229508197-17.4262295081967
71205171.42622950819733.5737704918033
72144171.426229508197-27.4262295081967
73185171.42622950819713.5737704918033
74174171.4262295081972.57377049180329
75169184.90625-15.90625
76185171.42622950819713.5737704918033
77176171.4262295081974.57377049180329
78184184.90625-0.90625
79177171.4262295081975.57377049180329
80178171.4262295081976.57377049180329
81182171.42622950819710.5737704918033
82168171.426229508197-3.42622950819671
83189171.42622950819717.5737704918033
84179184.90625-5.90625
85167171.426229508197-4.42622950819671
86176171.4262295081974.57377049180329
87188171.42622950819716.5737704918033
88115171.426229508197-56.4262295081967
89222189.132.9
90172171.4262295081970.573770491803288
91168171.426229508197-3.42622950819671
92219189.129.9
93197184.9062512.09375
94158171.426229508197-13.4262295081967
95169171.426229508197-2.42622950819671
96193189.13.90000000000001
97169189.1-20.1
98179189.1-10.1
99170184.90625-14.90625
100160171.426229508197-11.4262295081967
101180171.4262295081978.57377049180329
102183189.1-6.09999999999999
103166171.426229508197-5.42622950819671
104191189.11.90000000000001
105181171.4262295081979.57377049180329
106180184.90625-4.90625
107158171.426229508197-13.4262295081967
108159189.1-30.1
109175189.1-14.1
110178171.4262295081976.57377049180329
111182184.90625-2.90625
112184171.42622950819712.5737704918033
113189189.1-0.0999999999999943
114181171.4262295081979.57377049180329
115193171.42622950819721.5737704918033
116175171.4262295081973.57377049180329
117167189.1-22.1
118160171.426229508197-11.4262295081967
119163184.90625-21.90625
120202171.42622950819730.5737704918033
121176171.4262295081974.57377049180329
122181171.4262295081979.57377049180329
123146171.426229508197-25.4262295081967
124194189.14.90000000000001
125202184.9062517.09375
126185189.1-4.09999999999999
127216189.126.9
128141171.426229508197-30.4262295081967
129190189.10.900000000000006
130176189.1-13.1
131207171.42622950819735.5737704918033
132163171.426229508197-8.42622950819671
133210189.120.9
134196184.9062511.09375
135163189.1-26.1
136197171.42622950819725.5737704918033
137215171.42622950819743.5737704918033
138171184.90625-13.90625
139211171.42622950819739.5737704918033
140189189.1-0.0999999999999943
141169171.426229508197-2.42622950819671
142189171.42622950819717.5737704918033
143141171.426229508197-30.4262295081967
144194189.14.90000000000001
145171184.90625-13.90625
146141171.426229508197-30.4262295081967
147207171.42622950819735.5737704918033
148170171.426229508197-1.42622950819671
149187171.42622950819715.5737704918033
150188189.1-1.09999999999999
151188189.1-1.09999999999999
152204171.42622950819732.5737704918033
153163184.90625-21.90625
154214184.9062529.09375
155172171.4262295081970.573770491803288
156173171.4262295081971.57377049180329
157188171.42622950819716.5737704918033
158202184.9062517.09375
159211184.9062526.09375
160173171.4262295081971.57377049180329
161186184.906251.09375
162192189.12.90000000000001
163219171.42622950819747.5737704918033
164180171.4262295081978.57377049180329
165210189.120.9
166164184.90625-20.90625
167175171.4262295081973.57377049180329
168198189.18.90000000000001
169214184.9062529.09375
170180171.4262295081978.57377049180329
171210171.42622950819738.5737704918033
172197189.17.90000000000001
173146171.426229508197-25.4262295081967
174203189.113.9
175211171.42622950819739.5737704918033
176165171.426229508197-6.42622950819671
177169171.426229508197-2.42622950819671
178163171.426229508197-8.42622950819671
179176171.4262295081974.57377049180329
180181171.4262295081979.57377049180329
181148171.426229508197-23.4262295081967
182167171.426229508197-4.42622950819671
183144171.426229508197-27.4262295081967
184191171.42622950819719.5737704918033



Parameters (Session):
par1 = 0 ; par2 = none ; par3 = 3 ; par4 = no ; par5 = female ; par6 = bachelor ; par7 = all ; par8 = ATTLES all ; par9 = COLLES all ;
Parameters (R input):
par1 = 0 ; par2 = none ; par3 = 3 ; par4 = no ; par5 = female ; par6 = bachelor ; par7 = all ; par8 = ATTLES all ; par9 = COLLES all ;
R code (references can be found in the software module):
library(party)
library(Hmisc)
par1 <- as.numeric(par1)
par3 <- as.numeric(par3)
x <- as.data.frame(read.table(file='https://automated.biganalytics.eu/download/utaut.csv',sep=',',header=T))
x$U25 <- 6-x$U25
if(par5 == 'female') x <- x[x$Gender==0,]
if(par5 == 'male') x <- x[x$Gender==1,]
if(par6 == 'prep') x <- x[x$Pop==1,]
if(par6 == 'bachelor') x <- x[x$Pop==0,]
if(par7 != 'all') {
x <- x[x$Year==as.numeric(par7),]
}
cAc <- with(x,cbind( A1, A2, A3, A4, A5, A6, A7, A8, A9,A10))
cAs <- with(x,cbind(A11,A12,A13,A14,A15,A16,A17,A18,A19,A20))
cA <- cbind(cAc,cAs)
cCa <- with(x,cbind(C1,C3,C5,C7, C9,C11,C13,C15,C17,C19,C21,C23,C25,C27,C29,C31,C33,C35,C37,C39,C41,C43,C45,C47))
cCp <- with(x,cbind(C2,C4,C6,C8,C10,C12,C14,C16,C18,C20,C22,C24,C26,C28,C30,C32,C34,C36,C38,C40,C42,C44,C46,C48))
cC <- cbind(cCa,cCp)
cU <- with(x,cbind(U1,U2,U3,U4,U5,U6,U7,U8,U9,U10,U11,U12,U13,U14,U15,U16,U17,U18,U19,U20,U21,U22,U23,U24,U25,U26,U27,U28,U29,U30,U31,U32,U33))
cE <- with(x,cbind(BC,NNZFG,MRT,AFL,LPM,LPC,W,WPA))
cX <- with(x,cbind(X1,X2,X3,X4,X5,X6,X7,X8,X9,X10,X11,X12,X13,X14,X15,X16,X17,X18))
if (par8=='ATTLES connected') x <- cAc
if (par8=='ATTLES separate') x <- cAs
if (par8=='ATTLES all') x <- cA
if (par8=='COLLES actuals') x <- cCa
if (par8=='COLLES preferred') x <- cCp
if (par8=='COLLES all') x <- cC
if (par8=='CSUQ') x <- cU
if (par8=='Learning Activities') x <- cE
if (par8=='Exam Items') x <- cX
if (par9=='ATTLES connected') y <- cAc
if (par9=='ATTLES separate') y <- cAs
if (par9=='ATTLES all') y <- cA
if (par9=='COLLES actuals') y <- cCa
if (par9=='COLLES preferred') y <- cCp
if (par9=='COLLES all') y <- cC
if (par9=='CSUQ') y <- cU
if (par9=='Learning Activities') y <- cE
if (par9=='Exam Items') y <- cX
if (par1==0) {
nr <- length(y[,1])
nc <- length(y[1,])
mysum <- array(0,dim=nr)
for(jjj in 1:nr) {
for(iii in 1:nc) {
mysum[jjj] = mysum[jjj] + y[jjj,iii]
}
}
y <- mysum
} else {
y <- y[,par1]
}
nx <- cbind(y,x)
colnames(nx) <- c('endo',colnames(x))
x <- nx
par1=1
ncol <- length(x[1,])
for (jjj in 1:ncol) {
x <- x[!is.na(x[,jjj]),]
}
x <- as.data.frame(x)
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')
}