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:18:20 -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/t13357739427bhwz09omcri2y0.htm/, Retrieved Sun, 28 Apr 2024 20:25:16 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=165193, Retrieved Sun, 28 Apr 2024 20:25:16 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact147
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [female] [2012-04-30 08:18:20] [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=165193&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=165193&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165193&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.2664
R-squared0.071
RMSE20.4489

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.2664[/C][/ROW]
[ROW][C]R-squared[/C][C]0.071[/C][/ROW]
[ROW][C]RMSE[/C][C]20.4489[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=165193&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165193&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.2664
R-squared0.071
RMSE20.4489







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1200179.30379746835420.6962025316456
2169167.8942307692311.10576923076923
3154167.894230769231-13.8942307692308
4162179.303797468354-17.3037974683544
5195179.30379746835415.6962025316456
6175179.303797468354-4.30379746835442
7139179.303797468354-40.3037974683544
8164167.894230769231-3.89423076923077
9143167.894230769231-24.8942307692308
10157167.894230769231-10.8942307692308
11197179.30379746835417.6962025316456
12162167.894230769231-5.89423076923077
13181167.89423076923113.1057692307692
14132167.894230769231-35.8942307692308
15174167.8942307692316.10576923076923
16156167.894230769231-11.8942307692308
17155167.894230769231-12.8942307692308
18151167.894230769231-16.8942307692308
19142167.894230769231-25.8942307692308
20152167.894230769231-15.8942307692308
21147167.894230769231-20.8942307692308
22184167.89423076923116.1057692307692
23157179.303797468354-22.3037974683544
24162179.303797468354-17.3037974683544
25200179.30379746835420.6962025316456
26166179.303797468354-13.3037974683544
27135167.894230769231-32.8942307692308
28179179.303797468354-0.303797468354418
29192179.30379746835412.6962025316456
30176179.303797468354-3.30379746835442
31162167.894230769231-5.89423076923077
32161167.894230769231-6.89423076923077
33168179.303797468354-11.3037974683544
34137179.303797468354-42.3037974683544
35216179.30379746835436.6962025316456
36196179.30379746835416.6962025316456
37208179.30379746835428.6962025316456
38163167.894230769231-4.89423076923077
39149167.894230769231-18.8942307692308
40161167.894230769231-6.89423076923077
41207167.89423076923139.1057692307692
42151167.894230769231-16.8942307692308
43188179.3037974683548.69620253164558
44118179.303797468354-61.3037974683544
45161179.303797468354-18.3037974683544
46155167.894230769231-12.8942307692308
47164167.894230769231-3.89423076923077
48163179.303797468354-16.3037974683544
49181167.89423076923113.1057692307692
50171167.8942307692313.10576923076923
51162179.303797468354-17.3037974683544
52193179.30379746835413.6962025316456
53160167.894230769231-7.89423076923077
54187179.3037974683547.69620253164558
55194179.30379746835414.6962025316456
56168179.303797468354-11.3037974683544
57123179.303797468354-56.3037974683544
58154167.894230769231-13.8942307692308
59181167.89423076923113.1057692307692
60172167.8942307692314.10576923076923
61189179.3037974683549.69620253164558
62170179.303797468354-9.30379746835442
63193167.89423076923125.1057692307692
64170167.8942307692312.10576923076923
65188179.3037974683548.69620253164558
66193179.30379746835413.6962025316456
67178179.303797468354-1.30379746835442
68160167.894230769231-7.89423076923077
69149167.894230769231-18.8942307692308
70145167.894230769231-22.8942307692308
71188179.3037974683548.69620253164558
72181179.3037974683541.69620253164558
73161179.303797468354-18.3037974683544
74197167.89423076923129.1057692307692
75172179.303797468354-7.30379746835442
76169167.8942307692311.10576923076923
77201167.89423076923133.1057692307692
78179179.303797468354-0.303797468354418
79180179.3037974683540.696202531645582
80177179.303797468354-2.30379746835442
81175179.303797468354-4.30379746835442
82201179.30379746835421.6962025316456
83171167.8942307692313.10576923076923
84197167.89423076923129.1057692307692
85208167.89423076923140.1057692307692
86169167.8942307692311.10576923076923
87190179.30379746835410.6962025316456
88199179.30379746835419.6962025316456
89199179.30379746835419.6962025316456
90164167.894230769231-3.89423076923077
91144179.303797468354-35.3037974683544
92163179.303797468354-16.3037974683544
93172179.303797468354-7.30379746835442
94155179.303797468354-24.3037974683544
95167167.894230769231-0.894230769230774
96166167.894230769231-1.89423076923077
97192167.89423076923124.1057692307692
98202179.30379746835422.6962025316456
99191167.89423076923123.1057692307692
100194167.89423076923126.1057692307692
101171167.8942307692313.10576923076923
102164167.894230769231-3.89423076923077
103145167.894230769231-22.8942307692308
104146179.303797468354-33.3037974683544
105181167.89423076923113.1057692307692
106202167.89423076923134.1057692307692
107156167.894230769231-11.8942307692308
108179167.89423076923111.1057692307692
109177167.8942307692319.10576923076923
110169179.303797468354-10.3037974683544
111182167.89423076923114.1057692307692
112142167.894230769231-25.8942307692308
113212179.30379746835432.6962025316456
114177167.8942307692319.10576923076923
115186179.3037974683546.69620253164558
116156167.894230769231-11.8942307692308
117185167.89423076923117.1057692307692
118220167.89423076923152.1057692307692
119196179.30379746835416.6962025316456
120190179.30379746835410.6962025316456
121169167.8942307692311.10576923076923
122174179.303797468354-5.30379746835442
123193179.30379746835413.6962025316456
124182179.3037974683542.69620253164558
125190167.89423076923122.1057692307692
126222179.30379746835442.6962025316456
127157167.894230769231-10.8942307692308
128197167.89423076923129.1057692307692
129197179.30379746835417.6962025316456
130141167.894230769231-26.8942307692308
131182167.89423076923114.1057692307692
132206179.30379746835426.6962025316456
133164179.303797468354-15.3037974683544
134175167.8942307692317.10576923076923
135144167.894230769231-23.8942307692308
136160167.894230769231-7.89423076923077
137168179.303797468354-11.3037974683544
138193167.89423076923125.1057692307692
139215179.30379746835435.6962025316456
140203167.89423076923135.1057692307692
141130167.894230769231-37.8942307692308
142177167.8942307692319.10576923076923
143188167.89423076923120.1057692307692
144166167.894230769231-1.89423076923077
145186179.3037974683546.69620253164558
146207179.30379746835427.6962025316456
147214179.30379746835434.6962025316456
148186179.3037974683546.69620253164558
149180167.89423076923112.1057692307692
15099179.303797468354-80.3037974683544
151205167.89423076923137.1057692307692
152174167.8942307692316.10576923076923
153172167.8942307692314.10576923076923
154172167.8942307692314.10576923076923
155163167.894230769231-4.89423076923077
156158167.894230769231-9.89423076923077
157146167.894230769231-21.8942307692308
158172167.8942307692314.10576923076923
159185179.3037974683545.69620253164558
160159167.894230769231-8.89423076923077
161197167.89423076923129.1057692307692
162164167.894230769231-3.89423076923077
163179167.89423076923111.1057692307692
164137167.894230769231-30.8942307692308
165177179.303797468354-2.30379746835442
166157167.894230769231-10.8942307692308
167165167.894230769231-2.89423076923077
168200179.30379746835420.6962025316456
169172179.303797468354-7.30379746835442
170141167.894230769231-26.8942307692308
171157167.894230769231-10.8942307692308
172163167.894230769231-4.89423076923077
173143167.894230769231-24.8942307692308
174165179.303797468354-14.3037974683544
175167167.894230769231-0.894230769230774
176164167.894230769231-3.89423076923077
177202179.30379746835422.6962025316456
178143167.894230769231-24.8942307692308
179148167.894230769231-19.8942307692308
180173167.8942307692315.10576923076923
181170179.303797468354-9.30379746835442
182169179.303797468354-10.3037974683544
183175179.303797468354-4.30379746835442

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 200 & 179.303797468354 & 20.6962025316456 \tabularnewline
2 & 169 & 167.894230769231 & 1.10576923076923 \tabularnewline
3 & 154 & 167.894230769231 & -13.8942307692308 \tabularnewline
4 & 162 & 179.303797468354 & -17.3037974683544 \tabularnewline
5 & 195 & 179.303797468354 & 15.6962025316456 \tabularnewline
6 & 175 & 179.303797468354 & -4.30379746835442 \tabularnewline
7 & 139 & 179.303797468354 & -40.3037974683544 \tabularnewline
8 & 164 & 167.894230769231 & -3.89423076923077 \tabularnewline
9 & 143 & 167.894230769231 & -24.8942307692308 \tabularnewline
10 & 157 & 167.894230769231 & -10.8942307692308 \tabularnewline
11 & 197 & 179.303797468354 & 17.6962025316456 \tabularnewline
12 & 162 & 167.894230769231 & -5.89423076923077 \tabularnewline
13 & 181 & 167.894230769231 & 13.1057692307692 \tabularnewline
14 & 132 & 167.894230769231 & -35.8942307692308 \tabularnewline
15 & 174 & 167.894230769231 & 6.10576923076923 \tabularnewline
16 & 156 & 167.894230769231 & -11.8942307692308 \tabularnewline
17 & 155 & 167.894230769231 & -12.8942307692308 \tabularnewline
18 & 151 & 167.894230769231 & -16.8942307692308 \tabularnewline
19 & 142 & 167.894230769231 & -25.8942307692308 \tabularnewline
20 & 152 & 167.894230769231 & -15.8942307692308 \tabularnewline
21 & 147 & 167.894230769231 & -20.8942307692308 \tabularnewline
22 & 184 & 167.894230769231 & 16.1057692307692 \tabularnewline
23 & 157 & 179.303797468354 & -22.3037974683544 \tabularnewline
24 & 162 & 179.303797468354 & -17.3037974683544 \tabularnewline
25 & 200 & 179.303797468354 & 20.6962025316456 \tabularnewline
26 & 166 & 179.303797468354 & -13.3037974683544 \tabularnewline
27 & 135 & 167.894230769231 & -32.8942307692308 \tabularnewline
28 & 179 & 179.303797468354 & -0.303797468354418 \tabularnewline
29 & 192 & 179.303797468354 & 12.6962025316456 \tabularnewline
30 & 176 & 179.303797468354 & -3.30379746835442 \tabularnewline
31 & 162 & 167.894230769231 & -5.89423076923077 \tabularnewline
32 & 161 & 167.894230769231 & -6.89423076923077 \tabularnewline
33 & 168 & 179.303797468354 & -11.3037974683544 \tabularnewline
34 & 137 & 179.303797468354 & -42.3037974683544 \tabularnewline
35 & 216 & 179.303797468354 & 36.6962025316456 \tabularnewline
36 & 196 & 179.303797468354 & 16.6962025316456 \tabularnewline
37 & 208 & 179.303797468354 & 28.6962025316456 \tabularnewline
38 & 163 & 167.894230769231 & -4.89423076923077 \tabularnewline
39 & 149 & 167.894230769231 & -18.8942307692308 \tabularnewline
40 & 161 & 167.894230769231 & -6.89423076923077 \tabularnewline
41 & 207 & 167.894230769231 & 39.1057692307692 \tabularnewline
42 & 151 & 167.894230769231 & -16.8942307692308 \tabularnewline
43 & 188 & 179.303797468354 & 8.69620253164558 \tabularnewline
44 & 118 & 179.303797468354 & -61.3037974683544 \tabularnewline
45 & 161 & 179.303797468354 & -18.3037974683544 \tabularnewline
46 & 155 & 167.894230769231 & -12.8942307692308 \tabularnewline
47 & 164 & 167.894230769231 & -3.89423076923077 \tabularnewline
48 & 163 & 179.303797468354 & -16.3037974683544 \tabularnewline
49 & 181 & 167.894230769231 & 13.1057692307692 \tabularnewline
50 & 171 & 167.894230769231 & 3.10576923076923 \tabularnewline
51 & 162 & 179.303797468354 & -17.3037974683544 \tabularnewline
52 & 193 & 179.303797468354 & 13.6962025316456 \tabularnewline
53 & 160 & 167.894230769231 & -7.89423076923077 \tabularnewline
54 & 187 & 179.303797468354 & 7.69620253164558 \tabularnewline
55 & 194 & 179.303797468354 & 14.6962025316456 \tabularnewline
56 & 168 & 179.303797468354 & -11.3037974683544 \tabularnewline
57 & 123 & 179.303797468354 & -56.3037974683544 \tabularnewline
58 & 154 & 167.894230769231 & -13.8942307692308 \tabularnewline
59 & 181 & 167.894230769231 & 13.1057692307692 \tabularnewline
60 & 172 & 167.894230769231 & 4.10576923076923 \tabularnewline
61 & 189 & 179.303797468354 & 9.69620253164558 \tabularnewline
62 & 170 & 179.303797468354 & -9.30379746835442 \tabularnewline
63 & 193 & 167.894230769231 & 25.1057692307692 \tabularnewline
64 & 170 & 167.894230769231 & 2.10576923076923 \tabularnewline
65 & 188 & 179.303797468354 & 8.69620253164558 \tabularnewline
66 & 193 & 179.303797468354 & 13.6962025316456 \tabularnewline
67 & 178 & 179.303797468354 & -1.30379746835442 \tabularnewline
68 & 160 & 167.894230769231 & -7.89423076923077 \tabularnewline
69 & 149 & 167.894230769231 & -18.8942307692308 \tabularnewline
70 & 145 & 167.894230769231 & -22.8942307692308 \tabularnewline
71 & 188 & 179.303797468354 & 8.69620253164558 \tabularnewline
72 & 181 & 179.303797468354 & 1.69620253164558 \tabularnewline
73 & 161 & 179.303797468354 & -18.3037974683544 \tabularnewline
74 & 197 & 167.894230769231 & 29.1057692307692 \tabularnewline
75 & 172 & 179.303797468354 & -7.30379746835442 \tabularnewline
76 & 169 & 167.894230769231 & 1.10576923076923 \tabularnewline
77 & 201 & 167.894230769231 & 33.1057692307692 \tabularnewline
78 & 179 & 179.303797468354 & -0.303797468354418 \tabularnewline
79 & 180 & 179.303797468354 & 0.696202531645582 \tabularnewline
80 & 177 & 179.303797468354 & -2.30379746835442 \tabularnewline
81 & 175 & 179.303797468354 & -4.30379746835442 \tabularnewline
82 & 201 & 179.303797468354 & 21.6962025316456 \tabularnewline
83 & 171 & 167.894230769231 & 3.10576923076923 \tabularnewline
84 & 197 & 167.894230769231 & 29.1057692307692 \tabularnewline
85 & 208 & 167.894230769231 & 40.1057692307692 \tabularnewline
86 & 169 & 167.894230769231 & 1.10576923076923 \tabularnewline
87 & 190 & 179.303797468354 & 10.6962025316456 \tabularnewline
88 & 199 & 179.303797468354 & 19.6962025316456 \tabularnewline
89 & 199 & 179.303797468354 & 19.6962025316456 \tabularnewline
90 & 164 & 167.894230769231 & -3.89423076923077 \tabularnewline
91 & 144 & 179.303797468354 & -35.3037974683544 \tabularnewline
92 & 163 & 179.303797468354 & -16.3037974683544 \tabularnewline
93 & 172 & 179.303797468354 & -7.30379746835442 \tabularnewline
94 & 155 & 179.303797468354 & -24.3037974683544 \tabularnewline
95 & 167 & 167.894230769231 & -0.894230769230774 \tabularnewline
96 & 166 & 167.894230769231 & -1.89423076923077 \tabularnewline
97 & 192 & 167.894230769231 & 24.1057692307692 \tabularnewline
98 & 202 & 179.303797468354 & 22.6962025316456 \tabularnewline
99 & 191 & 167.894230769231 & 23.1057692307692 \tabularnewline
100 & 194 & 167.894230769231 & 26.1057692307692 \tabularnewline
101 & 171 & 167.894230769231 & 3.10576923076923 \tabularnewline
102 & 164 & 167.894230769231 & -3.89423076923077 \tabularnewline
103 & 145 & 167.894230769231 & -22.8942307692308 \tabularnewline
104 & 146 & 179.303797468354 & -33.3037974683544 \tabularnewline
105 & 181 & 167.894230769231 & 13.1057692307692 \tabularnewline
106 & 202 & 167.894230769231 & 34.1057692307692 \tabularnewline
107 & 156 & 167.894230769231 & -11.8942307692308 \tabularnewline
108 & 179 & 167.894230769231 & 11.1057692307692 \tabularnewline
109 & 177 & 167.894230769231 & 9.10576923076923 \tabularnewline
110 & 169 & 179.303797468354 & -10.3037974683544 \tabularnewline
111 & 182 & 167.894230769231 & 14.1057692307692 \tabularnewline
112 & 142 & 167.894230769231 & -25.8942307692308 \tabularnewline
113 & 212 & 179.303797468354 & 32.6962025316456 \tabularnewline
114 & 177 & 167.894230769231 & 9.10576923076923 \tabularnewline
115 & 186 & 179.303797468354 & 6.69620253164558 \tabularnewline
116 & 156 & 167.894230769231 & -11.8942307692308 \tabularnewline
117 & 185 & 167.894230769231 & 17.1057692307692 \tabularnewline
118 & 220 & 167.894230769231 & 52.1057692307692 \tabularnewline
119 & 196 & 179.303797468354 & 16.6962025316456 \tabularnewline
120 & 190 & 179.303797468354 & 10.6962025316456 \tabularnewline
121 & 169 & 167.894230769231 & 1.10576923076923 \tabularnewline
122 & 174 & 179.303797468354 & -5.30379746835442 \tabularnewline
123 & 193 & 179.303797468354 & 13.6962025316456 \tabularnewline
124 & 182 & 179.303797468354 & 2.69620253164558 \tabularnewline
125 & 190 & 167.894230769231 & 22.1057692307692 \tabularnewline
126 & 222 & 179.303797468354 & 42.6962025316456 \tabularnewline
127 & 157 & 167.894230769231 & -10.8942307692308 \tabularnewline
128 & 197 & 167.894230769231 & 29.1057692307692 \tabularnewline
129 & 197 & 179.303797468354 & 17.6962025316456 \tabularnewline
130 & 141 & 167.894230769231 & -26.8942307692308 \tabularnewline
131 & 182 & 167.894230769231 & 14.1057692307692 \tabularnewline
132 & 206 & 179.303797468354 & 26.6962025316456 \tabularnewline
133 & 164 & 179.303797468354 & -15.3037974683544 \tabularnewline
134 & 175 & 167.894230769231 & 7.10576923076923 \tabularnewline
135 & 144 & 167.894230769231 & -23.8942307692308 \tabularnewline
136 & 160 & 167.894230769231 & -7.89423076923077 \tabularnewline
137 & 168 & 179.303797468354 & -11.3037974683544 \tabularnewline
138 & 193 & 167.894230769231 & 25.1057692307692 \tabularnewline
139 & 215 & 179.303797468354 & 35.6962025316456 \tabularnewline
140 & 203 & 167.894230769231 & 35.1057692307692 \tabularnewline
141 & 130 & 167.894230769231 & -37.8942307692308 \tabularnewline
142 & 177 & 167.894230769231 & 9.10576923076923 \tabularnewline
143 & 188 & 167.894230769231 & 20.1057692307692 \tabularnewline
144 & 166 & 167.894230769231 & -1.89423076923077 \tabularnewline
145 & 186 & 179.303797468354 & 6.69620253164558 \tabularnewline
146 & 207 & 179.303797468354 & 27.6962025316456 \tabularnewline
147 & 214 & 179.303797468354 & 34.6962025316456 \tabularnewline
148 & 186 & 179.303797468354 & 6.69620253164558 \tabularnewline
149 & 180 & 167.894230769231 & 12.1057692307692 \tabularnewline
150 & 99 & 179.303797468354 & -80.3037974683544 \tabularnewline
151 & 205 & 167.894230769231 & 37.1057692307692 \tabularnewline
152 & 174 & 167.894230769231 & 6.10576923076923 \tabularnewline
153 & 172 & 167.894230769231 & 4.10576923076923 \tabularnewline
154 & 172 & 167.894230769231 & 4.10576923076923 \tabularnewline
155 & 163 & 167.894230769231 & -4.89423076923077 \tabularnewline
156 & 158 & 167.894230769231 & -9.89423076923077 \tabularnewline
157 & 146 & 167.894230769231 & -21.8942307692308 \tabularnewline
158 & 172 & 167.894230769231 & 4.10576923076923 \tabularnewline
159 & 185 & 179.303797468354 & 5.69620253164558 \tabularnewline
160 & 159 & 167.894230769231 & -8.89423076923077 \tabularnewline
161 & 197 & 167.894230769231 & 29.1057692307692 \tabularnewline
162 & 164 & 167.894230769231 & -3.89423076923077 \tabularnewline
163 & 179 & 167.894230769231 & 11.1057692307692 \tabularnewline
164 & 137 & 167.894230769231 & -30.8942307692308 \tabularnewline
165 & 177 & 179.303797468354 & -2.30379746835442 \tabularnewline
166 & 157 & 167.894230769231 & -10.8942307692308 \tabularnewline
167 & 165 & 167.894230769231 & -2.89423076923077 \tabularnewline
168 & 200 & 179.303797468354 & 20.6962025316456 \tabularnewline
169 & 172 & 179.303797468354 & -7.30379746835442 \tabularnewline
170 & 141 & 167.894230769231 & -26.8942307692308 \tabularnewline
171 & 157 & 167.894230769231 & -10.8942307692308 \tabularnewline
172 & 163 & 167.894230769231 & -4.89423076923077 \tabularnewline
173 & 143 & 167.894230769231 & -24.8942307692308 \tabularnewline
174 & 165 & 179.303797468354 & -14.3037974683544 \tabularnewline
175 & 167 & 167.894230769231 & -0.894230769230774 \tabularnewline
176 & 164 & 167.894230769231 & -3.89423076923077 \tabularnewline
177 & 202 & 179.303797468354 & 22.6962025316456 \tabularnewline
178 & 143 & 167.894230769231 & -24.8942307692308 \tabularnewline
179 & 148 & 167.894230769231 & -19.8942307692308 \tabularnewline
180 & 173 & 167.894230769231 & 5.10576923076923 \tabularnewline
181 & 170 & 179.303797468354 & -9.30379746835442 \tabularnewline
182 & 169 & 179.303797468354 & -10.3037974683544 \tabularnewline
183 & 175 & 179.303797468354 & -4.30379746835442 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=165193&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]200[/C][C]179.303797468354[/C][C]20.6962025316456[/C][/ROW]
[ROW][C]2[/C][C]169[/C][C]167.894230769231[/C][C]1.10576923076923[/C][/ROW]
[ROW][C]3[/C][C]154[/C][C]167.894230769231[/C][C]-13.8942307692308[/C][/ROW]
[ROW][C]4[/C][C]162[/C][C]179.303797468354[/C][C]-17.3037974683544[/C][/ROW]
[ROW][C]5[/C][C]195[/C][C]179.303797468354[/C][C]15.6962025316456[/C][/ROW]
[ROW][C]6[/C][C]175[/C][C]179.303797468354[/C][C]-4.30379746835442[/C][/ROW]
[ROW][C]7[/C][C]139[/C][C]179.303797468354[/C][C]-40.3037974683544[/C][/ROW]
[ROW][C]8[/C][C]164[/C][C]167.894230769231[/C][C]-3.89423076923077[/C][/ROW]
[ROW][C]9[/C][C]143[/C][C]167.894230769231[/C][C]-24.8942307692308[/C][/ROW]
[ROW][C]10[/C][C]157[/C][C]167.894230769231[/C][C]-10.8942307692308[/C][/ROW]
[ROW][C]11[/C][C]197[/C][C]179.303797468354[/C][C]17.6962025316456[/C][/ROW]
[ROW][C]12[/C][C]162[/C][C]167.894230769231[/C][C]-5.89423076923077[/C][/ROW]
[ROW][C]13[/C][C]181[/C][C]167.894230769231[/C][C]13.1057692307692[/C][/ROW]
[ROW][C]14[/C][C]132[/C][C]167.894230769231[/C][C]-35.8942307692308[/C][/ROW]
[ROW][C]15[/C][C]174[/C][C]167.894230769231[/C][C]6.10576923076923[/C][/ROW]
[ROW][C]16[/C][C]156[/C][C]167.894230769231[/C][C]-11.8942307692308[/C][/ROW]
[ROW][C]17[/C][C]155[/C][C]167.894230769231[/C][C]-12.8942307692308[/C][/ROW]
[ROW][C]18[/C][C]151[/C][C]167.894230769231[/C][C]-16.8942307692308[/C][/ROW]
[ROW][C]19[/C][C]142[/C][C]167.894230769231[/C][C]-25.8942307692308[/C][/ROW]
[ROW][C]20[/C][C]152[/C][C]167.894230769231[/C][C]-15.8942307692308[/C][/ROW]
[ROW][C]21[/C][C]147[/C][C]167.894230769231[/C][C]-20.8942307692308[/C][/ROW]
[ROW][C]22[/C][C]184[/C][C]167.894230769231[/C][C]16.1057692307692[/C][/ROW]
[ROW][C]23[/C][C]157[/C][C]179.303797468354[/C][C]-22.3037974683544[/C][/ROW]
[ROW][C]24[/C][C]162[/C][C]179.303797468354[/C][C]-17.3037974683544[/C][/ROW]
[ROW][C]25[/C][C]200[/C][C]179.303797468354[/C][C]20.6962025316456[/C][/ROW]
[ROW][C]26[/C][C]166[/C][C]179.303797468354[/C][C]-13.3037974683544[/C][/ROW]
[ROW][C]27[/C][C]135[/C][C]167.894230769231[/C][C]-32.8942307692308[/C][/ROW]
[ROW][C]28[/C][C]179[/C][C]179.303797468354[/C][C]-0.303797468354418[/C][/ROW]
[ROW][C]29[/C][C]192[/C][C]179.303797468354[/C][C]12.6962025316456[/C][/ROW]
[ROW][C]30[/C][C]176[/C][C]179.303797468354[/C][C]-3.30379746835442[/C][/ROW]
[ROW][C]31[/C][C]162[/C][C]167.894230769231[/C][C]-5.89423076923077[/C][/ROW]
[ROW][C]32[/C][C]161[/C][C]167.894230769231[/C][C]-6.89423076923077[/C][/ROW]
[ROW][C]33[/C][C]168[/C][C]179.303797468354[/C][C]-11.3037974683544[/C][/ROW]
[ROW][C]34[/C][C]137[/C][C]179.303797468354[/C][C]-42.3037974683544[/C][/ROW]
[ROW][C]35[/C][C]216[/C][C]179.303797468354[/C][C]36.6962025316456[/C][/ROW]
[ROW][C]36[/C][C]196[/C][C]179.303797468354[/C][C]16.6962025316456[/C][/ROW]
[ROW][C]37[/C][C]208[/C][C]179.303797468354[/C][C]28.6962025316456[/C][/ROW]
[ROW][C]38[/C][C]163[/C][C]167.894230769231[/C][C]-4.89423076923077[/C][/ROW]
[ROW][C]39[/C][C]149[/C][C]167.894230769231[/C][C]-18.8942307692308[/C][/ROW]
[ROW][C]40[/C][C]161[/C][C]167.894230769231[/C][C]-6.89423076923077[/C][/ROW]
[ROW][C]41[/C][C]207[/C][C]167.894230769231[/C][C]39.1057692307692[/C][/ROW]
[ROW][C]42[/C][C]151[/C][C]167.894230769231[/C][C]-16.8942307692308[/C][/ROW]
[ROW][C]43[/C][C]188[/C][C]179.303797468354[/C][C]8.69620253164558[/C][/ROW]
[ROW][C]44[/C][C]118[/C][C]179.303797468354[/C][C]-61.3037974683544[/C][/ROW]
[ROW][C]45[/C][C]161[/C][C]179.303797468354[/C][C]-18.3037974683544[/C][/ROW]
[ROW][C]46[/C][C]155[/C][C]167.894230769231[/C][C]-12.8942307692308[/C][/ROW]
[ROW][C]47[/C][C]164[/C][C]167.894230769231[/C][C]-3.89423076923077[/C][/ROW]
[ROW][C]48[/C][C]163[/C][C]179.303797468354[/C][C]-16.3037974683544[/C][/ROW]
[ROW][C]49[/C][C]181[/C][C]167.894230769231[/C][C]13.1057692307692[/C][/ROW]
[ROW][C]50[/C][C]171[/C][C]167.894230769231[/C][C]3.10576923076923[/C][/ROW]
[ROW][C]51[/C][C]162[/C][C]179.303797468354[/C][C]-17.3037974683544[/C][/ROW]
[ROW][C]52[/C][C]193[/C][C]179.303797468354[/C][C]13.6962025316456[/C][/ROW]
[ROW][C]53[/C][C]160[/C][C]167.894230769231[/C][C]-7.89423076923077[/C][/ROW]
[ROW][C]54[/C][C]187[/C][C]179.303797468354[/C][C]7.69620253164558[/C][/ROW]
[ROW][C]55[/C][C]194[/C][C]179.303797468354[/C][C]14.6962025316456[/C][/ROW]
[ROW][C]56[/C][C]168[/C][C]179.303797468354[/C][C]-11.3037974683544[/C][/ROW]
[ROW][C]57[/C][C]123[/C][C]179.303797468354[/C][C]-56.3037974683544[/C][/ROW]
[ROW][C]58[/C][C]154[/C][C]167.894230769231[/C][C]-13.8942307692308[/C][/ROW]
[ROW][C]59[/C][C]181[/C][C]167.894230769231[/C][C]13.1057692307692[/C][/ROW]
[ROW][C]60[/C][C]172[/C][C]167.894230769231[/C][C]4.10576923076923[/C][/ROW]
[ROW][C]61[/C][C]189[/C][C]179.303797468354[/C][C]9.69620253164558[/C][/ROW]
[ROW][C]62[/C][C]170[/C][C]179.303797468354[/C][C]-9.30379746835442[/C][/ROW]
[ROW][C]63[/C][C]193[/C][C]167.894230769231[/C][C]25.1057692307692[/C][/ROW]
[ROW][C]64[/C][C]170[/C][C]167.894230769231[/C][C]2.10576923076923[/C][/ROW]
[ROW][C]65[/C][C]188[/C][C]179.303797468354[/C][C]8.69620253164558[/C][/ROW]
[ROW][C]66[/C][C]193[/C][C]179.303797468354[/C][C]13.6962025316456[/C][/ROW]
[ROW][C]67[/C][C]178[/C][C]179.303797468354[/C][C]-1.30379746835442[/C][/ROW]
[ROW][C]68[/C][C]160[/C][C]167.894230769231[/C][C]-7.89423076923077[/C][/ROW]
[ROW][C]69[/C][C]149[/C][C]167.894230769231[/C][C]-18.8942307692308[/C][/ROW]
[ROW][C]70[/C][C]145[/C][C]167.894230769231[/C][C]-22.8942307692308[/C][/ROW]
[ROW][C]71[/C][C]188[/C][C]179.303797468354[/C][C]8.69620253164558[/C][/ROW]
[ROW][C]72[/C][C]181[/C][C]179.303797468354[/C][C]1.69620253164558[/C][/ROW]
[ROW][C]73[/C][C]161[/C][C]179.303797468354[/C][C]-18.3037974683544[/C][/ROW]
[ROW][C]74[/C][C]197[/C][C]167.894230769231[/C][C]29.1057692307692[/C][/ROW]
[ROW][C]75[/C][C]172[/C][C]179.303797468354[/C][C]-7.30379746835442[/C][/ROW]
[ROW][C]76[/C][C]169[/C][C]167.894230769231[/C][C]1.10576923076923[/C][/ROW]
[ROW][C]77[/C][C]201[/C][C]167.894230769231[/C][C]33.1057692307692[/C][/ROW]
[ROW][C]78[/C][C]179[/C][C]179.303797468354[/C][C]-0.303797468354418[/C][/ROW]
[ROW][C]79[/C][C]180[/C][C]179.303797468354[/C][C]0.696202531645582[/C][/ROW]
[ROW][C]80[/C][C]177[/C][C]179.303797468354[/C][C]-2.30379746835442[/C][/ROW]
[ROW][C]81[/C][C]175[/C][C]179.303797468354[/C][C]-4.30379746835442[/C][/ROW]
[ROW][C]82[/C][C]201[/C][C]179.303797468354[/C][C]21.6962025316456[/C][/ROW]
[ROW][C]83[/C][C]171[/C][C]167.894230769231[/C][C]3.10576923076923[/C][/ROW]
[ROW][C]84[/C][C]197[/C][C]167.894230769231[/C][C]29.1057692307692[/C][/ROW]
[ROW][C]85[/C][C]208[/C][C]167.894230769231[/C][C]40.1057692307692[/C][/ROW]
[ROW][C]86[/C][C]169[/C][C]167.894230769231[/C][C]1.10576923076923[/C][/ROW]
[ROW][C]87[/C][C]190[/C][C]179.303797468354[/C][C]10.6962025316456[/C][/ROW]
[ROW][C]88[/C][C]199[/C][C]179.303797468354[/C][C]19.6962025316456[/C][/ROW]
[ROW][C]89[/C][C]199[/C][C]179.303797468354[/C][C]19.6962025316456[/C][/ROW]
[ROW][C]90[/C][C]164[/C][C]167.894230769231[/C][C]-3.89423076923077[/C][/ROW]
[ROW][C]91[/C][C]144[/C][C]179.303797468354[/C][C]-35.3037974683544[/C][/ROW]
[ROW][C]92[/C][C]163[/C][C]179.303797468354[/C][C]-16.3037974683544[/C][/ROW]
[ROW][C]93[/C][C]172[/C][C]179.303797468354[/C][C]-7.30379746835442[/C][/ROW]
[ROW][C]94[/C][C]155[/C][C]179.303797468354[/C][C]-24.3037974683544[/C][/ROW]
[ROW][C]95[/C][C]167[/C][C]167.894230769231[/C][C]-0.894230769230774[/C][/ROW]
[ROW][C]96[/C][C]166[/C][C]167.894230769231[/C][C]-1.89423076923077[/C][/ROW]
[ROW][C]97[/C][C]192[/C][C]167.894230769231[/C][C]24.1057692307692[/C][/ROW]
[ROW][C]98[/C][C]202[/C][C]179.303797468354[/C][C]22.6962025316456[/C][/ROW]
[ROW][C]99[/C][C]191[/C][C]167.894230769231[/C][C]23.1057692307692[/C][/ROW]
[ROW][C]100[/C][C]194[/C][C]167.894230769231[/C][C]26.1057692307692[/C][/ROW]
[ROW][C]101[/C][C]171[/C][C]167.894230769231[/C][C]3.10576923076923[/C][/ROW]
[ROW][C]102[/C][C]164[/C][C]167.894230769231[/C][C]-3.89423076923077[/C][/ROW]
[ROW][C]103[/C][C]145[/C][C]167.894230769231[/C][C]-22.8942307692308[/C][/ROW]
[ROW][C]104[/C][C]146[/C][C]179.303797468354[/C][C]-33.3037974683544[/C][/ROW]
[ROW][C]105[/C][C]181[/C][C]167.894230769231[/C][C]13.1057692307692[/C][/ROW]
[ROW][C]106[/C][C]202[/C][C]167.894230769231[/C][C]34.1057692307692[/C][/ROW]
[ROW][C]107[/C][C]156[/C][C]167.894230769231[/C][C]-11.8942307692308[/C][/ROW]
[ROW][C]108[/C][C]179[/C][C]167.894230769231[/C][C]11.1057692307692[/C][/ROW]
[ROW][C]109[/C][C]177[/C][C]167.894230769231[/C][C]9.10576923076923[/C][/ROW]
[ROW][C]110[/C][C]169[/C][C]179.303797468354[/C][C]-10.3037974683544[/C][/ROW]
[ROW][C]111[/C][C]182[/C][C]167.894230769231[/C][C]14.1057692307692[/C][/ROW]
[ROW][C]112[/C][C]142[/C][C]167.894230769231[/C][C]-25.8942307692308[/C][/ROW]
[ROW][C]113[/C][C]212[/C][C]179.303797468354[/C][C]32.6962025316456[/C][/ROW]
[ROW][C]114[/C][C]177[/C][C]167.894230769231[/C][C]9.10576923076923[/C][/ROW]
[ROW][C]115[/C][C]186[/C][C]179.303797468354[/C][C]6.69620253164558[/C][/ROW]
[ROW][C]116[/C][C]156[/C][C]167.894230769231[/C][C]-11.8942307692308[/C][/ROW]
[ROW][C]117[/C][C]185[/C][C]167.894230769231[/C][C]17.1057692307692[/C][/ROW]
[ROW][C]118[/C][C]220[/C][C]167.894230769231[/C][C]52.1057692307692[/C][/ROW]
[ROW][C]119[/C][C]196[/C][C]179.303797468354[/C][C]16.6962025316456[/C][/ROW]
[ROW][C]120[/C][C]190[/C][C]179.303797468354[/C][C]10.6962025316456[/C][/ROW]
[ROW][C]121[/C][C]169[/C][C]167.894230769231[/C][C]1.10576923076923[/C][/ROW]
[ROW][C]122[/C][C]174[/C][C]179.303797468354[/C][C]-5.30379746835442[/C][/ROW]
[ROW][C]123[/C][C]193[/C][C]179.303797468354[/C][C]13.6962025316456[/C][/ROW]
[ROW][C]124[/C][C]182[/C][C]179.303797468354[/C][C]2.69620253164558[/C][/ROW]
[ROW][C]125[/C][C]190[/C][C]167.894230769231[/C][C]22.1057692307692[/C][/ROW]
[ROW][C]126[/C][C]222[/C][C]179.303797468354[/C][C]42.6962025316456[/C][/ROW]
[ROW][C]127[/C][C]157[/C][C]167.894230769231[/C][C]-10.8942307692308[/C][/ROW]
[ROW][C]128[/C][C]197[/C][C]167.894230769231[/C][C]29.1057692307692[/C][/ROW]
[ROW][C]129[/C][C]197[/C][C]179.303797468354[/C][C]17.6962025316456[/C][/ROW]
[ROW][C]130[/C][C]141[/C][C]167.894230769231[/C][C]-26.8942307692308[/C][/ROW]
[ROW][C]131[/C][C]182[/C][C]167.894230769231[/C][C]14.1057692307692[/C][/ROW]
[ROW][C]132[/C][C]206[/C][C]179.303797468354[/C][C]26.6962025316456[/C][/ROW]
[ROW][C]133[/C][C]164[/C][C]179.303797468354[/C][C]-15.3037974683544[/C][/ROW]
[ROW][C]134[/C][C]175[/C][C]167.894230769231[/C][C]7.10576923076923[/C][/ROW]
[ROW][C]135[/C][C]144[/C][C]167.894230769231[/C][C]-23.8942307692308[/C][/ROW]
[ROW][C]136[/C][C]160[/C][C]167.894230769231[/C][C]-7.89423076923077[/C][/ROW]
[ROW][C]137[/C][C]168[/C][C]179.303797468354[/C][C]-11.3037974683544[/C][/ROW]
[ROW][C]138[/C][C]193[/C][C]167.894230769231[/C][C]25.1057692307692[/C][/ROW]
[ROW][C]139[/C][C]215[/C][C]179.303797468354[/C][C]35.6962025316456[/C][/ROW]
[ROW][C]140[/C][C]203[/C][C]167.894230769231[/C][C]35.1057692307692[/C][/ROW]
[ROW][C]141[/C][C]130[/C][C]167.894230769231[/C][C]-37.8942307692308[/C][/ROW]
[ROW][C]142[/C][C]177[/C][C]167.894230769231[/C][C]9.10576923076923[/C][/ROW]
[ROW][C]143[/C][C]188[/C][C]167.894230769231[/C][C]20.1057692307692[/C][/ROW]
[ROW][C]144[/C][C]166[/C][C]167.894230769231[/C][C]-1.89423076923077[/C][/ROW]
[ROW][C]145[/C][C]186[/C][C]179.303797468354[/C][C]6.69620253164558[/C][/ROW]
[ROW][C]146[/C][C]207[/C][C]179.303797468354[/C][C]27.6962025316456[/C][/ROW]
[ROW][C]147[/C][C]214[/C][C]179.303797468354[/C][C]34.6962025316456[/C][/ROW]
[ROW][C]148[/C][C]186[/C][C]179.303797468354[/C][C]6.69620253164558[/C][/ROW]
[ROW][C]149[/C][C]180[/C][C]167.894230769231[/C][C]12.1057692307692[/C][/ROW]
[ROW][C]150[/C][C]99[/C][C]179.303797468354[/C][C]-80.3037974683544[/C][/ROW]
[ROW][C]151[/C][C]205[/C][C]167.894230769231[/C][C]37.1057692307692[/C][/ROW]
[ROW][C]152[/C][C]174[/C][C]167.894230769231[/C][C]6.10576923076923[/C][/ROW]
[ROW][C]153[/C][C]172[/C][C]167.894230769231[/C][C]4.10576923076923[/C][/ROW]
[ROW][C]154[/C][C]172[/C][C]167.894230769231[/C][C]4.10576923076923[/C][/ROW]
[ROW][C]155[/C][C]163[/C][C]167.894230769231[/C][C]-4.89423076923077[/C][/ROW]
[ROW][C]156[/C][C]158[/C][C]167.894230769231[/C][C]-9.89423076923077[/C][/ROW]
[ROW][C]157[/C][C]146[/C][C]167.894230769231[/C][C]-21.8942307692308[/C][/ROW]
[ROW][C]158[/C][C]172[/C][C]167.894230769231[/C][C]4.10576923076923[/C][/ROW]
[ROW][C]159[/C][C]185[/C][C]179.303797468354[/C][C]5.69620253164558[/C][/ROW]
[ROW][C]160[/C][C]159[/C][C]167.894230769231[/C][C]-8.89423076923077[/C][/ROW]
[ROW][C]161[/C][C]197[/C][C]167.894230769231[/C][C]29.1057692307692[/C][/ROW]
[ROW][C]162[/C][C]164[/C][C]167.894230769231[/C][C]-3.89423076923077[/C][/ROW]
[ROW][C]163[/C][C]179[/C][C]167.894230769231[/C][C]11.1057692307692[/C][/ROW]
[ROW][C]164[/C][C]137[/C][C]167.894230769231[/C][C]-30.8942307692308[/C][/ROW]
[ROW][C]165[/C][C]177[/C][C]179.303797468354[/C][C]-2.30379746835442[/C][/ROW]
[ROW][C]166[/C][C]157[/C][C]167.894230769231[/C][C]-10.8942307692308[/C][/ROW]
[ROW][C]167[/C][C]165[/C][C]167.894230769231[/C][C]-2.89423076923077[/C][/ROW]
[ROW][C]168[/C][C]200[/C][C]179.303797468354[/C][C]20.6962025316456[/C][/ROW]
[ROW][C]169[/C][C]172[/C][C]179.303797468354[/C][C]-7.30379746835442[/C][/ROW]
[ROW][C]170[/C][C]141[/C][C]167.894230769231[/C][C]-26.8942307692308[/C][/ROW]
[ROW][C]171[/C][C]157[/C][C]167.894230769231[/C][C]-10.8942307692308[/C][/ROW]
[ROW][C]172[/C][C]163[/C][C]167.894230769231[/C][C]-4.89423076923077[/C][/ROW]
[ROW][C]173[/C][C]143[/C][C]167.894230769231[/C][C]-24.8942307692308[/C][/ROW]
[ROW][C]174[/C][C]165[/C][C]179.303797468354[/C][C]-14.3037974683544[/C][/ROW]
[ROW][C]175[/C][C]167[/C][C]167.894230769231[/C][C]-0.894230769230774[/C][/ROW]
[ROW][C]176[/C][C]164[/C][C]167.894230769231[/C][C]-3.89423076923077[/C][/ROW]
[ROW][C]177[/C][C]202[/C][C]179.303797468354[/C][C]22.6962025316456[/C][/ROW]
[ROW][C]178[/C][C]143[/C][C]167.894230769231[/C][C]-24.8942307692308[/C][/ROW]
[ROW][C]179[/C][C]148[/C][C]167.894230769231[/C][C]-19.8942307692308[/C][/ROW]
[ROW][C]180[/C][C]173[/C][C]167.894230769231[/C][C]5.10576923076923[/C][/ROW]
[ROW][C]181[/C][C]170[/C][C]179.303797468354[/C][C]-9.30379746835442[/C][/ROW]
[ROW][C]182[/C][C]169[/C][C]179.303797468354[/C][C]-10.3037974683544[/C][/ROW]
[ROW][C]183[/C][C]175[/C][C]179.303797468354[/C][C]-4.30379746835442[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=165193&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165193&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
1200179.30379746835420.6962025316456
2169167.8942307692311.10576923076923
3154167.894230769231-13.8942307692308
4162179.303797468354-17.3037974683544
5195179.30379746835415.6962025316456
6175179.303797468354-4.30379746835442
7139179.303797468354-40.3037974683544
8164167.894230769231-3.89423076923077
9143167.894230769231-24.8942307692308
10157167.894230769231-10.8942307692308
11197179.30379746835417.6962025316456
12162167.894230769231-5.89423076923077
13181167.89423076923113.1057692307692
14132167.894230769231-35.8942307692308
15174167.8942307692316.10576923076923
16156167.894230769231-11.8942307692308
17155167.894230769231-12.8942307692308
18151167.894230769231-16.8942307692308
19142167.894230769231-25.8942307692308
20152167.894230769231-15.8942307692308
21147167.894230769231-20.8942307692308
22184167.89423076923116.1057692307692
23157179.303797468354-22.3037974683544
24162179.303797468354-17.3037974683544
25200179.30379746835420.6962025316456
26166179.303797468354-13.3037974683544
27135167.894230769231-32.8942307692308
28179179.303797468354-0.303797468354418
29192179.30379746835412.6962025316456
30176179.303797468354-3.30379746835442
31162167.894230769231-5.89423076923077
32161167.894230769231-6.89423076923077
33168179.303797468354-11.3037974683544
34137179.303797468354-42.3037974683544
35216179.30379746835436.6962025316456
36196179.30379746835416.6962025316456
37208179.30379746835428.6962025316456
38163167.894230769231-4.89423076923077
39149167.894230769231-18.8942307692308
40161167.894230769231-6.89423076923077
41207167.89423076923139.1057692307692
42151167.894230769231-16.8942307692308
43188179.3037974683548.69620253164558
44118179.303797468354-61.3037974683544
45161179.303797468354-18.3037974683544
46155167.894230769231-12.8942307692308
47164167.894230769231-3.89423076923077
48163179.303797468354-16.3037974683544
49181167.89423076923113.1057692307692
50171167.8942307692313.10576923076923
51162179.303797468354-17.3037974683544
52193179.30379746835413.6962025316456
53160167.894230769231-7.89423076923077
54187179.3037974683547.69620253164558
55194179.30379746835414.6962025316456
56168179.303797468354-11.3037974683544
57123179.303797468354-56.3037974683544
58154167.894230769231-13.8942307692308
59181167.89423076923113.1057692307692
60172167.8942307692314.10576923076923
61189179.3037974683549.69620253164558
62170179.303797468354-9.30379746835442
63193167.89423076923125.1057692307692
64170167.8942307692312.10576923076923
65188179.3037974683548.69620253164558
66193179.30379746835413.6962025316456
67178179.303797468354-1.30379746835442
68160167.894230769231-7.89423076923077
69149167.894230769231-18.8942307692308
70145167.894230769231-22.8942307692308
71188179.3037974683548.69620253164558
72181179.3037974683541.69620253164558
73161179.303797468354-18.3037974683544
74197167.89423076923129.1057692307692
75172179.303797468354-7.30379746835442
76169167.8942307692311.10576923076923
77201167.89423076923133.1057692307692
78179179.303797468354-0.303797468354418
79180179.3037974683540.696202531645582
80177179.303797468354-2.30379746835442
81175179.303797468354-4.30379746835442
82201179.30379746835421.6962025316456
83171167.8942307692313.10576923076923
84197167.89423076923129.1057692307692
85208167.89423076923140.1057692307692
86169167.8942307692311.10576923076923
87190179.30379746835410.6962025316456
88199179.30379746835419.6962025316456
89199179.30379746835419.6962025316456
90164167.894230769231-3.89423076923077
91144179.303797468354-35.3037974683544
92163179.303797468354-16.3037974683544
93172179.303797468354-7.30379746835442
94155179.303797468354-24.3037974683544
95167167.894230769231-0.894230769230774
96166167.894230769231-1.89423076923077
97192167.89423076923124.1057692307692
98202179.30379746835422.6962025316456
99191167.89423076923123.1057692307692
100194167.89423076923126.1057692307692
101171167.8942307692313.10576923076923
102164167.894230769231-3.89423076923077
103145167.894230769231-22.8942307692308
104146179.303797468354-33.3037974683544
105181167.89423076923113.1057692307692
106202167.89423076923134.1057692307692
107156167.894230769231-11.8942307692308
108179167.89423076923111.1057692307692
109177167.8942307692319.10576923076923
110169179.303797468354-10.3037974683544
111182167.89423076923114.1057692307692
112142167.894230769231-25.8942307692308
113212179.30379746835432.6962025316456
114177167.8942307692319.10576923076923
115186179.3037974683546.69620253164558
116156167.894230769231-11.8942307692308
117185167.89423076923117.1057692307692
118220167.89423076923152.1057692307692
119196179.30379746835416.6962025316456
120190179.30379746835410.6962025316456
121169167.8942307692311.10576923076923
122174179.303797468354-5.30379746835442
123193179.30379746835413.6962025316456
124182179.3037974683542.69620253164558
125190167.89423076923122.1057692307692
126222179.30379746835442.6962025316456
127157167.894230769231-10.8942307692308
128197167.89423076923129.1057692307692
129197179.30379746835417.6962025316456
130141167.894230769231-26.8942307692308
131182167.89423076923114.1057692307692
132206179.30379746835426.6962025316456
133164179.303797468354-15.3037974683544
134175167.8942307692317.10576923076923
135144167.894230769231-23.8942307692308
136160167.894230769231-7.89423076923077
137168179.303797468354-11.3037974683544
138193167.89423076923125.1057692307692
139215179.30379746835435.6962025316456
140203167.89423076923135.1057692307692
141130167.894230769231-37.8942307692308
142177167.8942307692319.10576923076923
143188167.89423076923120.1057692307692
144166167.894230769231-1.89423076923077
145186179.3037974683546.69620253164558
146207179.30379746835427.6962025316456
147214179.30379746835434.6962025316456
148186179.3037974683546.69620253164558
149180167.89423076923112.1057692307692
15099179.303797468354-80.3037974683544
151205167.89423076923137.1057692307692
152174167.8942307692316.10576923076923
153172167.8942307692314.10576923076923
154172167.8942307692314.10576923076923
155163167.894230769231-4.89423076923077
156158167.894230769231-9.89423076923077
157146167.894230769231-21.8942307692308
158172167.8942307692314.10576923076923
159185179.3037974683545.69620253164558
160159167.894230769231-8.89423076923077
161197167.89423076923129.1057692307692
162164167.894230769231-3.89423076923077
163179167.89423076923111.1057692307692
164137167.894230769231-30.8942307692308
165177179.303797468354-2.30379746835442
166157167.894230769231-10.8942307692308
167165167.894230769231-2.89423076923077
168200179.30379746835420.6962025316456
169172179.303797468354-7.30379746835442
170141167.894230769231-26.8942307692308
171157167.894230769231-10.8942307692308
172163167.894230769231-4.89423076923077
173143167.894230769231-24.8942307692308
174165179.303797468354-14.3037974683544
175167167.894230769231-0.894230769230774
176164167.894230769231-3.89423076923077
177202179.30379746835422.6962025316456
178143167.894230769231-24.8942307692308
179148167.894230769231-19.8942307692308
180173167.8942307692315.10576923076923
181170179.303797468354-9.30379746835442
182169179.303797468354-10.3037974683544
183175179.303797468354-4.30379746835442



Parameters (Session):
par1 = 0 ; par2 = none ; par3 = 3 ; par4 = no ; par5 = male ; par6 = bachelor ; par7 = all ; par8 = ATTLES all ; par9 = COLLES all ;
Parameters (R input):
par1 = 0 ; par2 = none ; par3 = 3 ; par4 = no ; par5 = male ; 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')
}