Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationWed, 04 Dec 2013 09:45:33 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2013/Dec/04/t13861683770r7884umx0sinwu.htm/, Retrieved Fri, 19 Apr 2024 07:48:27 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=230621, Retrieved Fri, 19 Apr 2024 07:48:27 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact75
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [Regression tree p...] [2013-12-04 14:45:33] [5951896a36dbcdcb08f65913ac269dbf] [Current]
Feedback Forum

Post a new message
Dataseries X:
119.992 157.302 74.997 0.00784 0.00007 0.0037 0.00554
122.4 148.65 113.819 0.00968 0.00008 0.00465 0.00696
116.682 131.111 111.555 0.0105 0.00009 0.00544 0.00781
116.676 137.871 111.366 0.00997 0.00009 0.00502 0.00698
116.014 141.781 110.655 0.01284 0.00011 0.00655 0.00908
120.552 131.162 113.787 0.00968 0.00008 0.00463 0.0075
120.267 137.244 114.82 0.00333 0.00003 0.00155 0.00202
107.332 113.84 104.315 0.0029 0.00003 0.00144 0.00182
95.73 132.068 91.754 0.00551 0.00006 0.00293 0.00332
95.056 120.103 91.226 0.00532 0.00006 0.00268 0.00332
88.333 112.24 84.072 0.00505 0.00006 0.00254 0.0033
91.904 115.871 86.292 0.0054 0.00006 0.00281 0.00336
136.926 159.866 131.276 0.00293 0.00002 0.00118 0.00153
139.173 179.139 76.556 0.0039 0.00003 0.00165 0.00208
152.845 163.305 75.836 0.00294 0.00002 0.00121 0.00149
142.167 217.455 83.159 0.00369 0.00003 0.00157 0.00203
144.188 349.259 82.764 0.00544 0.00004 0.00211 0.00292
168.778 232.181 75.603 0.00718 0.00004 0.00284 0.00387
153.046 175.829 68.623 0.00742 0.00005 0.00364 0.00432
156.405 189.398 142.822 0.00768 0.00005 0.00372 0.00399
153.848 165.738 65.782 0.0084 0.00005 0.00428 0.0045
153.88 172.86 78.128 0.0048 0.00003 0.00232 0.00267
167.93 193.221 79.068 0.00442 0.00003 0.0022 0.00247
173.917 192.735 86.18 0.00476 0.00003 0.00221 0.00258
163.656 200.841 76.779 0.00742 0.00005 0.0038 0.0039
104.4 206.002 77.968 0.00633 0.00006 0.00316 0.00375
171.041 208.313 75.501 0.00455 0.00003 0.0025 0.00234
146.845 208.701 81.737 0.00496 0.00003 0.0025 0.00275
155.358 227.383 80.055 0.0031 0.00002 0.00159 0.00176
162.568 198.346 77.63 0.00502 0.00003 0.0028 0.00253
197.076 206.896 192.055 0.00289 0.00001 0.00166 0.00168
199.228 209.512 192.091 0.00241 0.00001 0.00134 0.00138
198.383 215.203 193.104 0.00212 0.00001 0.00113 0.00135
202.266 211.604 197.079 0.0018 0.000009 0.00093 0.00107
203.184 211.526 196.16 0.00178 0.000009 0.00094 0.00106
201.464 210.565 195.708 0.00198 0.00001 0.00105 0.00115
177.876 192.921 168.013 0.00411 0.00002 0.00233 0.00241
176.17 185.604 163.564 0.00369 0.00002 0.00205 0.00218
180.198 201.249 175.456 0.00284 0.00002 0.00153 0.00166
187.733 202.324 173.015 0.00316 0.00002 0.00168 0.00182
186.163 197.724 177.584 0.00298 0.00002 0.00165 0.00175
184.055 196.537 166.977 0.00258 0.00001 0.00134 0.00147
237.226 247.326 225.227 0.00298 0.00001 0.00169 0.00182
241.404 248.834 232.483 0.00281 0.00001 0.00157 0.00173
243.439 250.912 232.435 0.0021 0.000009 0.00109 0.00137
242.852 255.034 227.911 0.00225 0.000009 0.00117 0.00139
245.51 262.09 231.848 0.00235 0.00001 0.00127 0.00148
252.455 261.487 182.786 0.00185 0.000007 0.00092 0.00113
122.188 128.611 115.765 0.00524 0.00004 0.00169 0.00203
122.964 130.049 114.676 0.00428 0.00003 0.00124 0.00155
124.445 135.069 117.495 0.00431 0.00003 0.00141 0.00167
126.344 134.231 112.773 0.00448 0.00004 0.00131 0.00169
128.001 138.052 122.08 0.00436 0.00003 0.00137 0.00166
129.336 139.867 118.604 0.0049 0.00004 0.00165 0.00183
108.807 134.656 102.874 0.00761 0.00007 0.00349 0.00486
109.86 126.358 104.437 0.00874 0.00008 0.00398 0.00539
110.417 131.067 103.37 0.00784 0.00007 0.00352 0.00514
117.274 129.916 110.402 0.00752 0.00006 0.00299 0.00469
116.879 131.897 108.153 0.00788 0.00007 0.00334 0.00493
114.847 271.314 104.68 0.00867 0.00008 0.00373 0.0052
209.144 237.494 109.379 0.00282 0.00001 0.00147 0.00152
223.365 238.987 98.664 0.00264 0.00001 0.00154 0.00151
222.236 231.345 205.495 0.00266 0.00001 0.00152 0.00144
228.832 234.619 223.634 0.00296 0.00001 0.00175 0.00155
229.401 252.221 221.156 0.00205 0.000009 0.00114 0.00113
228.969 239.541 113.201 0.00238 0.00001 0.00136 0.0014
140.341 159.774 67.021 0.00817 0.00006 0.0043 0.0044
136.969 166.607 66.004 0.00923 0.00007 0.00507 0.00463
143.533 162.215 65.809 0.01101 0.00008 0.00647 0.00467
148.09 162.824 67.343 0.00762 0.00005 0.00467 0.00354
142.729 162.408 65.476 0.00831 0.00006 0.00469 0.00419
136.358 176.595 65.75 0.00971 0.00007 0.00534 0.00478
120.08 139.71 111.208 0.00405 0.00003 0.0018 0.0022
112.014 588.518 107.024 0.00533 0.00005 0.00268 0.00329
110.793 128.101 107.316 0.00494 0.00004 0.0026 0.00283
110.707 122.611 105.007 0.00516 0.00005 0.00277 0.00289
112.876 148.826 106.981 0.005 0.00004 0.0027 0.00289
110.568 125.394 106.821 0.00462 0.00004 0.00226 0.0028
95.385 102.145 90.264 0.00608 0.00006 0.00331 0.00332
100.77 115.697 85.545 0.01038 0.0001 0.00622 0.00576
96.106 108.664 84.51 0.00694 0.00007 0.00389 0.00415
95.605 107.715 87.549 0.00702 0.00007 0.00428 0.00371
100.96 110.019 95.628 0.00606 0.00006 0.00351 0.00348
98.804 102.305 87.804 0.00432 0.00004 0.00247 0.00258
176.858 205.56 75.344 0.00747 0.00004 0.00418 0.0042
180.978 200.125 155.495 0.00406 0.00002 0.0022 0.00244
178.222 202.45 141.047 0.00321 0.00002 0.00163 0.00194
176.281 227.381 125.61 0.0052 0.00003 0.00287 0.00312
173.898 211.35 74.677 0.00448 0.00003 0.00237 0.00254
179.711 225.93 144.878 0.00709 0.00004 0.00391 0.00419
166.605 206.008 78.032 0.00742 0.00004 0.00387 0.00453
151.955 163.335 147.226 0.00419 0.00003 0.00224 0.00227
148.272 164.989 142.299 0.00459 0.00003 0.0025 0.00256
152.125 161.469 76.596 0.00382 0.00003 0.00191 0.00226
157.821 172.975 68.401 0.00358 0.00002 0.00196 0.00196
157.447 163.267 149.605 0.00369 0.00002 0.00201 0.00197
159.116 168.913 144.811 0.00342 0.00002 0.00178 0.00184
125.036 143.946 116.187 0.0128 0.0001 0.00743 0.00623
125.791 140.557 96.206 0.01378 0.00011 0.00826 0.00655
126.512 141.756 99.77 0.01936 0.00015 0.01159 0.0099
125.641 141.068 116.346 0.03316 0.00026 0.02144 0.01522
128.451 150.449 75.632 0.01551 0.00012 0.00905 0.00909
139.224 586.567 66.157 0.03011 0.00022 0.01854 0.01628
150.258 154.609 75.349 0.00248 0.00002 0.00105 0.00136
154.003 160.267 128.621 0.00183 0.00001 0.00076 0.001
149.689 160.368 133.608 0.00257 0.00002 0.00116 0.00134
155.078 163.736 144.148 0.00168 0.00001 0.00068 0.00092
151.884 157.765 133.751 0.00258 0.00002 0.00115 0.00122
151.989 157.339 132.857 0.00174 0.00001 0.00075 0.00096
193.03 208.9 80.297 0.00766 0.00004 0.0045 0.00389
200.714 223.982 89.686 0.00621 0.00003 0.00371 0.00337
208.519 220.315 199.02 0.00609 0.00003 0.00368 0.00339
204.664 221.3 189.621 0.00841 0.00004 0.00502 0.00485
210.141 232.706 185.258 0.00534 0.00003 0.00321 0.0028
206.327 226.355 92.02 0.00495 0.00002 0.00302 0.00246
151.872 492.892 69.085 0.00856 0.00006 0.00404 0.00385
158.219 442.557 71.948 0.00476 0.00003 0.00214 0.00207
170.756 450.247 79.032 0.00555 0.00003 0.00244 0.00261
178.285 442.824 82.063 0.00462 0.00003 0.00157 0.00194
217.116 233.481 93.978 0.00404 0.00002 0.00127 0.00128
128.94 479.697 88.251 0.00581 0.00005 0.00241 0.00314
176.824 215.293 83.961 0.0046 0.00003 0.00209 0.00221
138.19 203.522 83.34 0.00704 0.00005 0.00406 0.00398
182.018 197.173 79.187 0.00842 0.00005 0.00506 0.00449
156.239 195.107 79.82 0.00694 0.00004 0.00403 0.00395
145.174 198.109 80.637 0.00733 0.00005 0.00414 0.00422
138.145 197.238 81.114 0.00544 0.00004 0.00294 0.00327
166.888 198.966 79.512 0.00638 0.00004 0.00368 0.00351
119.031 127.533 109.216 0.0044 0.00004 0.00214 0.00192
120.078 126.632 105.667 0.0027 0.00002 0.00116 0.00135
120.289 128.143 100.209 0.00492 0.00004 0.00269 0.00238
120.256 125.306 104.773 0.00407 0.00003 0.00224 0.00205
119.056 125.213 86.795 0.00346 0.00003 0.00169 0.0017
118.747 123.723 109.836 0.00331 0.00003 0.00168 0.00171
106.516 112.777 93.105 0.00589 0.00006 0.00291 0.00319
110.453 127.611 105.554 0.00494 0.00004 0.00244 0.00315
113.4 133.344 107.816 0.00451 0.00004 0.00219 0.00283
113.166 130.27 100.673 0.00502 0.00004 0.00257 0.00312
112.239 126.609 104.095 0.00472 0.00004 0.00238 0.0029
116.15 131.731 109.815 0.00381 0.00003 0.00181 0.00232
170.368 268.796 79.543 0.00571 0.00003 0.00232 0.00269
208.083 253.792 91.802 0.00757 0.00004 0.00428 0.00428
198.458 219.29 148.691 0.00376 0.00002 0.00182 0.00215
202.805 231.508 86.232 0.0037 0.00002 0.00189 0.00211
202.544 241.35 164.168 0.00254 0.00001 0.001 0.00133
223.361 263.872 87.638 0.00352 0.00002 0.00169 0.00188
169.774 191.759 151.451 0.01568 0.00009 0.00863 0.00946
183.52 216.814 161.34 0.01466 0.00008 0.00849 0.00819
188.62 216.302 165.982 0.01719 0.00009 0.00996 0.01027
202.632 565.74 177.258 0.01627 0.00008 0.00919 0.00963
186.695 211.961 149.442 0.01872 0.0001 0.01075 0.01154
192.818 224.429 168.793 0.03107 0.00016 0.018 0.01958
198.116 233.099 174.478 0.02714 0.00014 0.01568 0.01699
121.345 139.644 98.25 0.00684 0.00006 0.00388 0.00332
119.1 128.442 88.833 0.00692 0.00006 0.00393 0.003
117.87 127.349 95.654 0.00647 0.00005 0.00356 0.003
122.336 142.369 94.794 0.00727 0.00006 0.00415 0.00339
117.963 134.209 100.757 0.01813 0.00015 0.01117 0.00718
126.144 154.284 97.543 0.00975 0.00008 0.00593 0.00454
127.93 138.752 112.173 0.00605 0.00005 0.00321 0.00318
114.238 124.393 77.022 0.00581 0.00005 0.00299 0.00316
115.322 135.738 107.802 0.00619 0.00005 0.00352 0.00329
114.554 126.778 91.121 0.00651 0.00006 0.00366 0.0034
112.15 131.669 97.527 0.00519 0.00005 0.00291 0.00284
102.273 142.83 85.902 0.00907 0.00009 0.00493 0.00461
236.2 244.663 102.137 0.00277 0.00001 0.00154 0.00153
237.323 243.709 229.256 0.00303 0.00001 0.00173 0.00159
260.105 264.919 237.303 0.00339 0.00001 0.00205 0.00186
197.569 217.627 90.794 0.00803 0.00004 0.0049 0.00448
240.301 245.135 219.783 0.00517 0.00002 0.00316 0.00283
244.99 272.21 239.17 0.00451 0.00002 0.00279 0.00237
112.547 133.374 105.715 0.00355 0.00003 0.00166 0.0019
110.739 113.597 100.139 0.00356 0.00003 0.0017 0.002
113.715 116.443 96.913 0.00349 0.00003 0.00171 0.00203
117.004 144.466 99.923 0.00353 0.00003 0.00176 0.00218
115.38 123.109 108.634 0.00332 0.00003 0.0016 0.00199
116.388 129.038 108.97 0.00346 0.00003 0.00169 0.00213
151.737 190.204 129.859 0.00314 0.00002 0.00135 0.00162
148.79 158.359 138.99 0.00309 0.00002 0.00152 0.00186
148.143 155.982 135.041 0.00392 0.00003 0.00204 0.00231
150.44 163.441 144.736 0.00396 0.00003 0.00206 0.00233
148.462 161.078 141.998 0.00397 0.00003 0.00202 0.00235
149.818 163.417 144.786 0.00336 0.00002 0.00174 0.00198
117.226 123.925 106.656 0.00417 0.00004 0.00186 0.0027
116.848 217.552 99.503 0.00531 0.00005 0.0026 0.00346
116.286 177.291 96.983 0.00314 0.00003 0.00134 0.00192
116.556 592.03 86.228 0.00496 0.00004 0.00254 0.00263
116.342 581.289 94.246 0.00267 0.00002 0.00115 0.00148
114.563 119.167 86.647 0.00327 0.00003 0.00146 0.00184
201.774 262.707 78.228 0.00694 0.00003 0.00412 0.00396
174.188 230.978 94.261 0.00459 0.00003 0.00263 0.00259
209.516 253.017 89.488 0.00564 0.00003 0.00331 0.00292
174.688 240.005 74.287 0.0136 0.00008 0.00624 0.00564
198.764 396.961 74.904 0.0074 0.00004 0.0037 0.0039
214.289 260.277 77.973 0.00567 0.00003 0.00295 0.00317




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

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 15 seconds \tabularnewline
R Server & 'Gertrude Mary Cox' @ cox.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=230621&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]15 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Gertrude Mary Cox' @ cox.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=230621&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=230621&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 time15 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net







Goodness of Fit
Correlation0.8946
R-squared0.8003
RMSE18.4481

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8946[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8003[/C][/ROW]
[ROW][C]RMSE[/C][C]18.4481[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=230621&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=230621&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.8946
R-squared0.8003
RMSE18.4481







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1119.992141.053727272727-21.0617272727273
2122.4121.6133333333330.786666666666676
3116.682115.4298857142861.25211428571428
4116.676121.613333333333-4.93733333333333
5116.014121.613333333333-5.59933333333333
6120.552115.4298857142865.12211428571429
7120.267121.613333333333-1.34633333333333
8107.332101.1277142857146.2042857142857
995.73115.429885714286-19.6998857142857
1095.056101.127714285714-6.07171428571429
1188.333101.127714285714-12.7947142857143
1291.904101.127714285714-9.22371428571429
13136.926169.638953125-32.712953125
14139.173169.638953125-30.465953125
15152.845169.638953125-16.793953125
16142.167169.638953125-27.471953125
17144.188169.638953125-25.450953125
18168.778169.638953125-0.860953125000009
19153.046141.05372727272711.9922727272727
20156.405141.05372727272715.3512727272727
21153.848141.05372727272712.7942727272727
22153.88169.638953125-15.758953125
23167.93169.638953125-1.70895312499999
24173.917169.6389531254.278046875
25163.656141.05372727272722.6022727272727
26104.4141.053727272727-36.6537272727273
27171.041169.6389531251.402046875
28146.845169.638953125-22.793953125
29155.358169.638953125-14.280953125
30162.568169.638953125-7.07095312499999
31197.076207.738-10.662
32199.228207.738-8.50999999999999
33198.383207.738-9.35499999999999
34202.266207.738-5.47200000000001
35203.184207.738-4.554
36201.464207.738-6.274
37177.876185.517470588235-7.64147058823531
38176.17185.517470588235-9.34747058823532
39180.198185.517470588235-5.3194705882353
40187.733185.5174705882352.21552941176469
41186.163185.5174705882350.645529411764699
42184.055185.517470588235-1.46247058823531
43237.226239.46825-2.24225000000001
44241.404239.468251.93574999999998
45243.439239.468253.97074999999998
46242.852239.468253.38374999999999
47245.51239.468256.04174999999998
48252.455207.73844.717
49122.188115.4298857142866.75811428571429
50122.964115.4298857142867.53411428571428
51124.445121.6133333333332.83166666666666
52126.344115.42988571428610.9141142857143
53128.001121.6133333333336.38766666666668
54129.336121.6133333333337.72266666666668
55108.807115.429885714286-6.62288571428572
56109.86115.429885714286-5.56988571428572
57110.417115.429885714286-5.01288571428572
58117.274115.4298857142861.84411428571428
59116.879115.4298857142861.44911428571429
60114.847141.053727272727-26.2067272727273
61209.144169.63895312539.505046875
62223.365169.63895312553.726046875
63222.236239.46825-17.23225
64228.832239.46825-10.63625
65229.401239.46825-10.06725
66228.969169.63895312559.330046875
67140.341141.053727272727-0.712727272727278
68136.969141.053727272727-4.08472727272729
69143.533141.0537272727272.4792727272727
70148.09141.0537272727277.03627272727272
71142.729141.0537272727271.67527272727273
72136.358141.053727272727-4.69572727272728
73120.08121.613333333333-1.53333333333333
74112.014141.053727272727-29.0397272727273
75110.793115.429885714286-4.63688571428571
76110.707115.429885714286-4.72288571428572
77112.876121.613333333333-8.73733333333332
78110.568115.429885714286-4.86188571428572
7995.385101.127714285714-5.74271428571429
80100.77101.127714285714-0.357714285714295
8196.106101.127714285714-5.0217142857143
8295.605101.127714285714-5.52271428571429
83100.96101.127714285714-0.167714285714297
8498.804101.127714285714-2.32371428571429
85176.858169.6389531257.219046875
86180.978185.517470588235-4.5394705882353
87178.222169.6389531258.58304687500001
88176.281169.6389531256.64204687500001
89173.898169.6389531254.259046875
90179.711169.63895312510.072046875
91166.605169.638953125-3.03395312500001
92151.955169.638953125-17.683953125
93148.272169.638953125-21.366953125
94152.125169.638953125-17.513953125
95157.821169.638953125-11.817953125
96157.447185.517470588235-28.0704705882353
97159.116169.638953125-10.522953125
98125.036121.6133333333333.42266666666667
99125.791121.6133333333334.17766666666667
100126.512121.6133333333334.89866666666667
101125.641121.6133333333334.02766666666668
102128.451121.6133333333336.83766666666666
103139.224141.053727272727-1.8297272727273
104150.258169.638953125-19.380953125
105154.003169.638953125-15.635953125
106149.689169.638953125-19.949953125
107155.078169.638953125-14.560953125
108151.884169.638953125-17.754953125
109151.989169.638953125-17.649953125
110193.03169.63895312523.391046875
111200.714169.63895312531.075046875
112208.519207.7380.781000000000006
113204.664207.738-3.07400000000001
114210.141207.7382.40299999999999
115206.327169.63895312536.688046875
116151.872141.05372727272710.8182727272727
117158.219169.638953125-11.419953125
118170.756169.6389531251.117046875
119178.285169.6389531258.646046875
120217.116169.63895312547.477046875
121128.94141.053727272727-12.1137272727273
122176.824169.6389531257.18504687500001
123138.19141.053727272727-2.86372727272729
124182.018141.05372727272740.9642727272727
125156.239169.638953125-13.399953125
126145.174141.0537272727274.12027272727272
127138.145169.638953125-31.493953125
128166.888169.638953125-2.750953125
129119.031115.4298857142863.60111428571429
130120.078115.4298857142864.64811428571429
131120.289115.4298857142864.85911428571428
132120.256115.4298857142864.82611428571428
133119.056115.4298857142863.62611428571428
134118.747115.4298857142863.31711428571428
135106.516101.1277142857145.38828571428571
136110.453115.429885714286-4.97688571428571
137113.4115.429885714286-2.02988571428571
138113.166115.429885714286-2.26388571428572
139112.239115.429885714286-3.19088571428571
140116.15115.4298857142860.720114285714288
141170.368169.6389531250.729046874999995
142208.083169.63895312538.444046875
143198.458185.51747058823512.9405294117647
144202.805169.63895312533.166046875
145202.544185.51747058823517.0265294117647
146223.361169.63895312553.722046875
147169.774185.517470588235-15.7434705882353
148183.52185.517470588235-1.9974705882353
149188.62185.5174705882353.10252941176469
150202.632185.51747058823517.1145294117647
151186.695185.5174705882351.17752941176468
152192.818185.5174705882357.3005294117647
153198.116185.51747058823512.5985294117647
154121.345121.613333333333-0.268333333333331
155119.1115.4298857142863.67011428571428
156117.87115.4298857142862.44011428571429
157122.336121.6133333333330.722666666666669
158117.963115.4298857142862.53311428571428
159126.144121.6133333333334.53066666666668
160127.93121.6133333333336.31666666666668
161114.238115.429885714286-1.19188571428572
162115.322121.613333333333-6.29133333333333
163114.554115.429885714286-0.875885714285715
164112.15115.429885714286-3.27988571428571
165102.273121.613333333333-19.3403333333333
166236.2169.63895312566.561046875
167237.323239.46825-2.14525
168260.105239.4682520.63675
169197.569169.63895312527.930046875
170240.301239.468250.832749999999976
171244.99239.468255.52175
172112.547115.429885714286-2.88288571428572
173110.739101.1277142857149.61128571428571
174113.715101.12771428571412.5872857142857
175117.004121.613333333333-4.60933333333332
176115.38115.429885714286-0.0498857142857219
177116.388115.4298857142860.958114285714288
178151.737169.638953125-17.901953125
179148.79169.638953125-20.848953125
180148.143169.638953125-21.495953125
181150.44169.638953125-19.198953125
182148.462169.638953125-21.176953125
183149.818169.638953125-19.820953125
184117.226115.4298857142861.79611428571428
185116.848141.053727272727-24.2057272727273
186116.286169.638953125-53.352953125
187116.556169.638953125-53.082953125
188116.342169.638953125-53.296953125
189114.563101.12771428571413.4352857142857
190201.774169.63895312532.135046875
191174.188169.6389531254.54904687499999
192209.516169.63895312539.877046875
193174.688141.05372727272733.6342727272727
194198.764169.63895312529.125046875
195214.289169.63895312544.650046875

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 119.992 & 141.053727272727 & -21.0617272727273 \tabularnewline
2 & 122.4 & 121.613333333333 & 0.786666666666676 \tabularnewline
3 & 116.682 & 115.429885714286 & 1.25211428571428 \tabularnewline
4 & 116.676 & 121.613333333333 & -4.93733333333333 \tabularnewline
5 & 116.014 & 121.613333333333 & -5.59933333333333 \tabularnewline
6 & 120.552 & 115.429885714286 & 5.12211428571429 \tabularnewline
7 & 120.267 & 121.613333333333 & -1.34633333333333 \tabularnewline
8 & 107.332 & 101.127714285714 & 6.2042857142857 \tabularnewline
9 & 95.73 & 115.429885714286 & -19.6998857142857 \tabularnewline
10 & 95.056 & 101.127714285714 & -6.07171428571429 \tabularnewline
11 & 88.333 & 101.127714285714 & -12.7947142857143 \tabularnewline
12 & 91.904 & 101.127714285714 & -9.22371428571429 \tabularnewline
13 & 136.926 & 169.638953125 & -32.712953125 \tabularnewline
14 & 139.173 & 169.638953125 & -30.465953125 \tabularnewline
15 & 152.845 & 169.638953125 & -16.793953125 \tabularnewline
16 & 142.167 & 169.638953125 & -27.471953125 \tabularnewline
17 & 144.188 & 169.638953125 & -25.450953125 \tabularnewline
18 & 168.778 & 169.638953125 & -0.860953125000009 \tabularnewline
19 & 153.046 & 141.053727272727 & 11.9922727272727 \tabularnewline
20 & 156.405 & 141.053727272727 & 15.3512727272727 \tabularnewline
21 & 153.848 & 141.053727272727 & 12.7942727272727 \tabularnewline
22 & 153.88 & 169.638953125 & -15.758953125 \tabularnewline
23 & 167.93 & 169.638953125 & -1.70895312499999 \tabularnewline
24 & 173.917 & 169.638953125 & 4.278046875 \tabularnewline
25 & 163.656 & 141.053727272727 & 22.6022727272727 \tabularnewline
26 & 104.4 & 141.053727272727 & -36.6537272727273 \tabularnewline
27 & 171.041 & 169.638953125 & 1.402046875 \tabularnewline
28 & 146.845 & 169.638953125 & -22.793953125 \tabularnewline
29 & 155.358 & 169.638953125 & -14.280953125 \tabularnewline
30 & 162.568 & 169.638953125 & -7.07095312499999 \tabularnewline
31 & 197.076 & 207.738 & -10.662 \tabularnewline
32 & 199.228 & 207.738 & -8.50999999999999 \tabularnewline
33 & 198.383 & 207.738 & -9.35499999999999 \tabularnewline
34 & 202.266 & 207.738 & -5.47200000000001 \tabularnewline
35 & 203.184 & 207.738 & -4.554 \tabularnewline
36 & 201.464 & 207.738 & -6.274 \tabularnewline
37 & 177.876 & 185.517470588235 & -7.64147058823531 \tabularnewline
38 & 176.17 & 185.517470588235 & -9.34747058823532 \tabularnewline
39 & 180.198 & 185.517470588235 & -5.3194705882353 \tabularnewline
40 & 187.733 & 185.517470588235 & 2.21552941176469 \tabularnewline
41 & 186.163 & 185.517470588235 & 0.645529411764699 \tabularnewline
42 & 184.055 & 185.517470588235 & -1.46247058823531 \tabularnewline
43 & 237.226 & 239.46825 & -2.24225000000001 \tabularnewline
44 & 241.404 & 239.46825 & 1.93574999999998 \tabularnewline
45 & 243.439 & 239.46825 & 3.97074999999998 \tabularnewline
46 & 242.852 & 239.46825 & 3.38374999999999 \tabularnewline
47 & 245.51 & 239.46825 & 6.04174999999998 \tabularnewline
48 & 252.455 & 207.738 & 44.717 \tabularnewline
49 & 122.188 & 115.429885714286 & 6.75811428571429 \tabularnewline
50 & 122.964 & 115.429885714286 & 7.53411428571428 \tabularnewline
51 & 124.445 & 121.613333333333 & 2.83166666666666 \tabularnewline
52 & 126.344 & 115.429885714286 & 10.9141142857143 \tabularnewline
53 & 128.001 & 121.613333333333 & 6.38766666666668 \tabularnewline
54 & 129.336 & 121.613333333333 & 7.72266666666668 \tabularnewline
55 & 108.807 & 115.429885714286 & -6.62288571428572 \tabularnewline
56 & 109.86 & 115.429885714286 & -5.56988571428572 \tabularnewline
57 & 110.417 & 115.429885714286 & -5.01288571428572 \tabularnewline
58 & 117.274 & 115.429885714286 & 1.84411428571428 \tabularnewline
59 & 116.879 & 115.429885714286 & 1.44911428571429 \tabularnewline
60 & 114.847 & 141.053727272727 & -26.2067272727273 \tabularnewline
61 & 209.144 & 169.638953125 & 39.505046875 \tabularnewline
62 & 223.365 & 169.638953125 & 53.726046875 \tabularnewline
63 & 222.236 & 239.46825 & -17.23225 \tabularnewline
64 & 228.832 & 239.46825 & -10.63625 \tabularnewline
65 & 229.401 & 239.46825 & -10.06725 \tabularnewline
66 & 228.969 & 169.638953125 & 59.330046875 \tabularnewline
67 & 140.341 & 141.053727272727 & -0.712727272727278 \tabularnewline
68 & 136.969 & 141.053727272727 & -4.08472727272729 \tabularnewline
69 & 143.533 & 141.053727272727 & 2.4792727272727 \tabularnewline
70 & 148.09 & 141.053727272727 & 7.03627272727272 \tabularnewline
71 & 142.729 & 141.053727272727 & 1.67527272727273 \tabularnewline
72 & 136.358 & 141.053727272727 & -4.69572727272728 \tabularnewline
73 & 120.08 & 121.613333333333 & -1.53333333333333 \tabularnewline
74 & 112.014 & 141.053727272727 & -29.0397272727273 \tabularnewline
75 & 110.793 & 115.429885714286 & -4.63688571428571 \tabularnewline
76 & 110.707 & 115.429885714286 & -4.72288571428572 \tabularnewline
77 & 112.876 & 121.613333333333 & -8.73733333333332 \tabularnewline
78 & 110.568 & 115.429885714286 & -4.86188571428572 \tabularnewline
79 & 95.385 & 101.127714285714 & -5.74271428571429 \tabularnewline
80 & 100.77 & 101.127714285714 & -0.357714285714295 \tabularnewline
81 & 96.106 & 101.127714285714 & -5.0217142857143 \tabularnewline
82 & 95.605 & 101.127714285714 & -5.52271428571429 \tabularnewline
83 & 100.96 & 101.127714285714 & -0.167714285714297 \tabularnewline
84 & 98.804 & 101.127714285714 & -2.32371428571429 \tabularnewline
85 & 176.858 & 169.638953125 & 7.219046875 \tabularnewline
86 & 180.978 & 185.517470588235 & -4.5394705882353 \tabularnewline
87 & 178.222 & 169.638953125 & 8.58304687500001 \tabularnewline
88 & 176.281 & 169.638953125 & 6.64204687500001 \tabularnewline
89 & 173.898 & 169.638953125 & 4.259046875 \tabularnewline
90 & 179.711 & 169.638953125 & 10.072046875 \tabularnewline
91 & 166.605 & 169.638953125 & -3.03395312500001 \tabularnewline
92 & 151.955 & 169.638953125 & -17.683953125 \tabularnewline
93 & 148.272 & 169.638953125 & -21.366953125 \tabularnewline
94 & 152.125 & 169.638953125 & -17.513953125 \tabularnewline
95 & 157.821 & 169.638953125 & -11.817953125 \tabularnewline
96 & 157.447 & 185.517470588235 & -28.0704705882353 \tabularnewline
97 & 159.116 & 169.638953125 & -10.522953125 \tabularnewline
98 & 125.036 & 121.613333333333 & 3.42266666666667 \tabularnewline
99 & 125.791 & 121.613333333333 & 4.17766666666667 \tabularnewline
100 & 126.512 & 121.613333333333 & 4.89866666666667 \tabularnewline
101 & 125.641 & 121.613333333333 & 4.02766666666668 \tabularnewline
102 & 128.451 & 121.613333333333 & 6.83766666666666 \tabularnewline
103 & 139.224 & 141.053727272727 & -1.8297272727273 \tabularnewline
104 & 150.258 & 169.638953125 & -19.380953125 \tabularnewline
105 & 154.003 & 169.638953125 & -15.635953125 \tabularnewline
106 & 149.689 & 169.638953125 & -19.949953125 \tabularnewline
107 & 155.078 & 169.638953125 & -14.560953125 \tabularnewline
108 & 151.884 & 169.638953125 & -17.754953125 \tabularnewline
109 & 151.989 & 169.638953125 & -17.649953125 \tabularnewline
110 & 193.03 & 169.638953125 & 23.391046875 \tabularnewline
111 & 200.714 & 169.638953125 & 31.075046875 \tabularnewline
112 & 208.519 & 207.738 & 0.781000000000006 \tabularnewline
113 & 204.664 & 207.738 & -3.07400000000001 \tabularnewline
114 & 210.141 & 207.738 & 2.40299999999999 \tabularnewline
115 & 206.327 & 169.638953125 & 36.688046875 \tabularnewline
116 & 151.872 & 141.053727272727 & 10.8182727272727 \tabularnewline
117 & 158.219 & 169.638953125 & -11.419953125 \tabularnewline
118 & 170.756 & 169.638953125 & 1.117046875 \tabularnewline
119 & 178.285 & 169.638953125 & 8.646046875 \tabularnewline
120 & 217.116 & 169.638953125 & 47.477046875 \tabularnewline
121 & 128.94 & 141.053727272727 & -12.1137272727273 \tabularnewline
122 & 176.824 & 169.638953125 & 7.18504687500001 \tabularnewline
123 & 138.19 & 141.053727272727 & -2.86372727272729 \tabularnewline
124 & 182.018 & 141.053727272727 & 40.9642727272727 \tabularnewline
125 & 156.239 & 169.638953125 & -13.399953125 \tabularnewline
126 & 145.174 & 141.053727272727 & 4.12027272727272 \tabularnewline
127 & 138.145 & 169.638953125 & -31.493953125 \tabularnewline
128 & 166.888 & 169.638953125 & -2.750953125 \tabularnewline
129 & 119.031 & 115.429885714286 & 3.60111428571429 \tabularnewline
130 & 120.078 & 115.429885714286 & 4.64811428571429 \tabularnewline
131 & 120.289 & 115.429885714286 & 4.85911428571428 \tabularnewline
132 & 120.256 & 115.429885714286 & 4.82611428571428 \tabularnewline
133 & 119.056 & 115.429885714286 & 3.62611428571428 \tabularnewline
134 & 118.747 & 115.429885714286 & 3.31711428571428 \tabularnewline
135 & 106.516 & 101.127714285714 & 5.38828571428571 \tabularnewline
136 & 110.453 & 115.429885714286 & -4.97688571428571 \tabularnewline
137 & 113.4 & 115.429885714286 & -2.02988571428571 \tabularnewline
138 & 113.166 & 115.429885714286 & -2.26388571428572 \tabularnewline
139 & 112.239 & 115.429885714286 & -3.19088571428571 \tabularnewline
140 & 116.15 & 115.429885714286 & 0.720114285714288 \tabularnewline
141 & 170.368 & 169.638953125 & 0.729046874999995 \tabularnewline
142 & 208.083 & 169.638953125 & 38.444046875 \tabularnewline
143 & 198.458 & 185.517470588235 & 12.9405294117647 \tabularnewline
144 & 202.805 & 169.638953125 & 33.166046875 \tabularnewline
145 & 202.544 & 185.517470588235 & 17.0265294117647 \tabularnewline
146 & 223.361 & 169.638953125 & 53.722046875 \tabularnewline
147 & 169.774 & 185.517470588235 & -15.7434705882353 \tabularnewline
148 & 183.52 & 185.517470588235 & -1.9974705882353 \tabularnewline
149 & 188.62 & 185.517470588235 & 3.10252941176469 \tabularnewline
150 & 202.632 & 185.517470588235 & 17.1145294117647 \tabularnewline
151 & 186.695 & 185.517470588235 & 1.17752941176468 \tabularnewline
152 & 192.818 & 185.517470588235 & 7.3005294117647 \tabularnewline
153 & 198.116 & 185.517470588235 & 12.5985294117647 \tabularnewline
154 & 121.345 & 121.613333333333 & -0.268333333333331 \tabularnewline
155 & 119.1 & 115.429885714286 & 3.67011428571428 \tabularnewline
156 & 117.87 & 115.429885714286 & 2.44011428571429 \tabularnewline
157 & 122.336 & 121.613333333333 & 0.722666666666669 \tabularnewline
158 & 117.963 & 115.429885714286 & 2.53311428571428 \tabularnewline
159 & 126.144 & 121.613333333333 & 4.53066666666668 \tabularnewline
160 & 127.93 & 121.613333333333 & 6.31666666666668 \tabularnewline
161 & 114.238 & 115.429885714286 & -1.19188571428572 \tabularnewline
162 & 115.322 & 121.613333333333 & -6.29133333333333 \tabularnewline
163 & 114.554 & 115.429885714286 & -0.875885714285715 \tabularnewline
164 & 112.15 & 115.429885714286 & -3.27988571428571 \tabularnewline
165 & 102.273 & 121.613333333333 & -19.3403333333333 \tabularnewline
166 & 236.2 & 169.638953125 & 66.561046875 \tabularnewline
167 & 237.323 & 239.46825 & -2.14525 \tabularnewline
168 & 260.105 & 239.46825 & 20.63675 \tabularnewline
169 & 197.569 & 169.638953125 & 27.930046875 \tabularnewline
170 & 240.301 & 239.46825 & 0.832749999999976 \tabularnewline
171 & 244.99 & 239.46825 & 5.52175 \tabularnewline
172 & 112.547 & 115.429885714286 & -2.88288571428572 \tabularnewline
173 & 110.739 & 101.127714285714 & 9.61128571428571 \tabularnewline
174 & 113.715 & 101.127714285714 & 12.5872857142857 \tabularnewline
175 & 117.004 & 121.613333333333 & -4.60933333333332 \tabularnewline
176 & 115.38 & 115.429885714286 & -0.0498857142857219 \tabularnewline
177 & 116.388 & 115.429885714286 & 0.958114285714288 \tabularnewline
178 & 151.737 & 169.638953125 & -17.901953125 \tabularnewline
179 & 148.79 & 169.638953125 & -20.848953125 \tabularnewline
180 & 148.143 & 169.638953125 & -21.495953125 \tabularnewline
181 & 150.44 & 169.638953125 & -19.198953125 \tabularnewline
182 & 148.462 & 169.638953125 & -21.176953125 \tabularnewline
183 & 149.818 & 169.638953125 & -19.820953125 \tabularnewline
184 & 117.226 & 115.429885714286 & 1.79611428571428 \tabularnewline
185 & 116.848 & 141.053727272727 & -24.2057272727273 \tabularnewline
186 & 116.286 & 169.638953125 & -53.352953125 \tabularnewline
187 & 116.556 & 169.638953125 & -53.082953125 \tabularnewline
188 & 116.342 & 169.638953125 & -53.296953125 \tabularnewline
189 & 114.563 & 101.127714285714 & 13.4352857142857 \tabularnewline
190 & 201.774 & 169.638953125 & 32.135046875 \tabularnewline
191 & 174.188 & 169.638953125 & 4.54904687499999 \tabularnewline
192 & 209.516 & 169.638953125 & 39.877046875 \tabularnewline
193 & 174.688 & 141.053727272727 & 33.6342727272727 \tabularnewline
194 & 198.764 & 169.638953125 & 29.125046875 \tabularnewline
195 & 214.289 & 169.638953125 & 44.650046875 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=230621&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]119.992[/C][C]141.053727272727[/C][C]-21.0617272727273[/C][/ROW]
[ROW][C]2[/C][C]122.4[/C][C]121.613333333333[/C][C]0.786666666666676[/C][/ROW]
[ROW][C]3[/C][C]116.682[/C][C]115.429885714286[/C][C]1.25211428571428[/C][/ROW]
[ROW][C]4[/C][C]116.676[/C][C]121.613333333333[/C][C]-4.93733333333333[/C][/ROW]
[ROW][C]5[/C][C]116.014[/C][C]121.613333333333[/C][C]-5.59933333333333[/C][/ROW]
[ROW][C]6[/C][C]120.552[/C][C]115.429885714286[/C][C]5.12211428571429[/C][/ROW]
[ROW][C]7[/C][C]120.267[/C][C]121.613333333333[/C][C]-1.34633333333333[/C][/ROW]
[ROW][C]8[/C][C]107.332[/C][C]101.127714285714[/C][C]6.2042857142857[/C][/ROW]
[ROW][C]9[/C][C]95.73[/C][C]115.429885714286[/C][C]-19.6998857142857[/C][/ROW]
[ROW][C]10[/C][C]95.056[/C][C]101.127714285714[/C][C]-6.07171428571429[/C][/ROW]
[ROW][C]11[/C][C]88.333[/C][C]101.127714285714[/C][C]-12.7947142857143[/C][/ROW]
[ROW][C]12[/C][C]91.904[/C][C]101.127714285714[/C][C]-9.22371428571429[/C][/ROW]
[ROW][C]13[/C][C]136.926[/C][C]169.638953125[/C][C]-32.712953125[/C][/ROW]
[ROW][C]14[/C][C]139.173[/C][C]169.638953125[/C][C]-30.465953125[/C][/ROW]
[ROW][C]15[/C][C]152.845[/C][C]169.638953125[/C][C]-16.793953125[/C][/ROW]
[ROW][C]16[/C][C]142.167[/C][C]169.638953125[/C][C]-27.471953125[/C][/ROW]
[ROW][C]17[/C][C]144.188[/C][C]169.638953125[/C][C]-25.450953125[/C][/ROW]
[ROW][C]18[/C][C]168.778[/C][C]169.638953125[/C][C]-0.860953125000009[/C][/ROW]
[ROW][C]19[/C][C]153.046[/C][C]141.053727272727[/C][C]11.9922727272727[/C][/ROW]
[ROW][C]20[/C][C]156.405[/C][C]141.053727272727[/C][C]15.3512727272727[/C][/ROW]
[ROW][C]21[/C][C]153.848[/C][C]141.053727272727[/C][C]12.7942727272727[/C][/ROW]
[ROW][C]22[/C][C]153.88[/C][C]169.638953125[/C][C]-15.758953125[/C][/ROW]
[ROW][C]23[/C][C]167.93[/C][C]169.638953125[/C][C]-1.70895312499999[/C][/ROW]
[ROW][C]24[/C][C]173.917[/C][C]169.638953125[/C][C]4.278046875[/C][/ROW]
[ROW][C]25[/C][C]163.656[/C][C]141.053727272727[/C][C]22.6022727272727[/C][/ROW]
[ROW][C]26[/C][C]104.4[/C][C]141.053727272727[/C][C]-36.6537272727273[/C][/ROW]
[ROW][C]27[/C][C]171.041[/C][C]169.638953125[/C][C]1.402046875[/C][/ROW]
[ROW][C]28[/C][C]146.845[/C][C]169.638953125[/C][C]-22.793953125[/C][/ROW]
[ROW][C]29[/C][C]155.358[/C][C]169.638953125[/C][C]-14.280953125[/C][/ROW]
[ROW][C]30[/C][C]162.568[/C][C]169.638953125[/C][C]-7.07095312499999[/C][/ROW]
[ROW][C]31[/C][C]197.076[/C][C]207.738[/C][C]-10.662[/C][/ROW]
[ROW][C]32[/C][C]199.228[/C][C]207.738[/C][C]-8.50999999999999[/C][/ROW]
[ROW][C]33[/C][C]198.383[/C][C]207.738[/C][C]-9.35499999999999[/C][/ROW]
[ROW][C]34[/C][C]202.266[/C][C]207.738[/C][C]-5.47200000000001[/C][/ROW]
[ROW][C]35[/C][C]203.184[/C][C]207.738[/C][C]-4.554[/C][/ROW]
[ROW][C]36[/C][C]201.464[/C][C]207.738[/C][C]-6.274[/C][/ROW]
[ROW][C]37[/C][C]177.876[/C][C]185.517470588235[/C][C]-7.64147058823531[/C][/ROW]
[ROW][C]38[/C][C]176.17[/C][C]185.517470588235[/C][C]-9.34747058823532[/C][/ROW]
[ROW][C]39[/C][C]180.198[/C][C]185.517470588235[/C][C]-5.3194705882353[/C][/ROW]
[ROW][C]40[/C][C]187.733[/C][C]185.517470588235[/C][C]2.21552941176469[/C][/ROW]
[ROW][C]41[/C][C]186.163[/C][C]185.517470588235[/C][C]0.645529411764699[/C][/ROW]
[ROW][C]42[/C][C]184.055[/C][C]185.517470588235[/C][C]-1.46247058823531[/C][/ROW]
[ROW][C]43[/C][C]237.226[/C][C]239.46825[/C][C]-2.24225000000001[/C][/ROW]
[ROW][C]44[/C][C]241.404[/C][C]239.46825[/C][C]1.93574999999998[/C][/ROW]
[ROW][C]45[/C][C]243.439[/C][C]239.46825[/C][C]3.97074999999998[/C][/ROW]
[ROW][C]46[/C][C]242.852[/C][C]239.46825[/C][C]3.38374999999999[/C][/ROW]
[ROW][C]47[/C][C]245.51[/C][C]239.46825[/C][C]6.04174999999998[/C][/ROW]
[ROW][C]48[/C][C]252.455[/C][C]207.738[/C][C]44.717[/C][/ROW]
[ROW][C]49[/C][C]122.188[/C][C]115.429885714286[/C][C]6.75811428571429[/C][/ROW]
[ROW][C]50[/C][C]122.964[/C][C]115.429885714286[/C][C]7.53411428571428[/C][/ROW]
[ROW][C]51[/C][C]124.445[/C][C]121.613333333333[/C][C]2.83166666666666[/C][/ROW]
[ROW][C]52[/C][C]126.344[/C][C]115.429885714286[/C][C]10.9141142857143[/C][/ROW]
[ROW][C]53[/C][C]128.001[/C][C]121.613333333333[/C][C]6.38766666666668[/C][/ROW]
[ROW][C]54[/C][C]129.336[/C][C]121.613333333333[/C][C]7.72266666666668[/C][/ROW]
[ROW][C]55[/C][C]108.807[/C][C]115.429885714286[/C][C]-6.62288571428572[/C][/ROW]
[ROW][C]56[/C][C]109.86[/C][C]115.429885714286[/C][C]-5.56988571428572[/C][/ROW]
[ROW][C]57[/C][C]110.417[/C][C]115.429885714286[/C][C]-5.01288571428572[/C][/ROW]
[ROW][C]58[/C][C]117.274[/C][C]115.429885714286[/C][C]1.84411428571428[/C][/ROW]
[ROW][C]59[/C][C]116.879[/C][C]115.429885714286[/C][C]1.44911428571429[/C][/ROW]
[ROW][C]60[/C][C]114.847[/C][C]141.053727272727[/C][C]-26.2067272727273[/C][/ROW]
[ROW][C]61[/C][C]209.144[/C][C]169.638953125[/C][C]39.505046875[/C][/ROW]
[ROW][C]62[/C][C]223.365[/C][C]169.638953125[/C][C]53.726046875[/C][/ROW]
[ROW][C]63[/C][C]222.236[/C][C]239.46825[/C][C]-17.23225[/C][/ROW]
[ROW][C]64[/C][C]228.832[/C][C]239.46825[/C][C]-10.63625[/C][/ROW]
[ROW][C]65[/C][C]229.401[/C][C]239.46825[/C][C]-10.06725[/C][/ROW]
[ROW][C]66[/C][C]228.969[/C][C]169.638953125[/C][C]59.330046875[/C][/ROW]
[ROW][C]67[/C][C]140.341[/C][C]141.053727272727[/C][C]-0.712727272727278[/C][/ROW]
[ROW][C]68[/C][C]136.969[/C][C]141.053727272727[/C][C]-4.08472727272729[/C][/ROW]
[ROW][C]69[/C][C]143.533[/C][C]141.053727272727[/C][C]2.4792727272727[/C][/ROW]
[ROW][C]70[/C][C]148.09[/C][C]141.053727272727[/C][C]7.03627272727272[/C][/ROW]
[ROW][C]71[/C][C]142.729[/C][C]141.053727272727[/C][C]1.67527272727273[/C][/ROW]
[ROW][C]72[/C][C]136.358[/C][C]141.053727272727[/C][C]-4.69572727272728[/C][/ROW]
[ROW][C]73[/C][C]120.08[/C][C]121.613333333333[/C][C]-1.53333333333333[/C][/ROW]
[ROW][C]74[/C][C]112.014[/C][C]141.053727272727[/C][C]-29.0397272727273[/C][/ROW]
[ROW][C]75[/C][C]110.793[/C][C]115.429885714286[/C][C]-4.63688571428571[/C][/ROW]
[ROW][C]76[/C][C]110.707[/C][C]115.429885714286[/C][C]-4.72288571428572[/C][/ROW]
[ROW][C]77[/C][C]112.876[/C][C]121.613333333333[/C][C]-8.73733333333332[/C][/ROW]
[ROW][C]78[/C][C]110.568[/C][C]115.429885714286[/C][C]-4.86188571428572[/C][/ROW]
[ROW][C]79[/C][C]95.385[/C][C]101.127714285714[/C][C]-5.74271428571429[/C][/ROW]
[ROW][C]80[/C][C]100.77[/C][C]101.127714285714[/C][C]-0.357714285714295[/C][/ROW]
[ROW][C]81[/C][C]96.106[/C][C]101.127714285714[/C][C]-5.0217142857143[/C][/ROW]
[ROW][C]82[/C][C]95.605[/C][C]101.127714285714[/C][C]-5.52271428571429[/C][/ROW]
[ROW][C]83[/C][C]100.96[/C][C]101.127714285714[/C][C]-0.167714285714297[/C][/ROW]
[ROW][C]84[/C][C]98.804[/C][C]101.127714285714[/C][C]-2.32371428571429[/C][/ROW]
[ROW][C]85[/C][C]176.858[/C][C]169.638953125[/C][C]7.219046875[/C][/ROW]
[ROW][C]86[/C][C]180.978[/C][C]185.517470588235[/C][C]-4.5394705882353[/C][/ROW]
[ROW][C]87[/C][C]178.222[/C][C]169.638953125[/C][C]8.58304687500001[/C][/ROW]
[ROW][C]88[/C][C]176.281[/C][C]169.638953125[/C][C]6.64204687500001[/C][/ROW]
[ROW][C]89[/C][C]173.898[/C][C]169.638953125[/C][C]4.259046875[/C][/ROW]
[ROW][C]90[/C][C]179.711[/C][C]169.638953125[/C][C]10.072046875[/C][/ROW]
[ROW][C]91[/C][C]166.605[/C][C]169.638953125[/C][C]-3.03395312500001[/C][/ROW]
[ROW][C]92[/C][C]151.955[/C][C]169.638953125[/C][C]-17.683953125[/C][/ROW]
[ROW][C]93[/C][C]148.272[/C][C]169.638953125[/C][C]-21.366953125[/C][/ROW]
[ROW][C]94[/C][C]152.125[/C][C]169.638953125[/C][C]-17.513953125[/C][/ROW]
[ROW][C]95[/C][C]157.821[/C][C]169.638953125[/C][C]-11.817953125[/C][/ROW]
[ROW][C]96[/C][C]157.447[/C][C]185.517470588235[/C][C]-28.0704705882353[/C][/ROW]
[ROW][C]97[/C][C]159.116[/C][C]169.638953125[/C][C]-10.522953125[/C][/ROW]
[ROW][C]98[/C][C]125.036[/C][C]121.613333333333[/C][C]3.42266666666667[/C][/ROW]
[ROW][C]99[/C][C]125.791[/C][C]121.613333333333[/C][C]4.17766666666667[/C][/ROW]
[ROW][C]100[/C][C]126.512[/C][C]121.613333333333[/C][C]4.89866666666667[/C][/ROW]
[ROW][C]101[/C][C]125.641[/C][C]121.613333333333[/C][C]4.02766666666668[/C][/ROW]
[ROW][C]102[/C][C]128.451[/C][C]121.613333333333[/C][C]6.83766666666666[/C][/ROW]
[ROW][C]103[/C][C]139.224[/C][C]141.053727272727[/C][C]-1.8297272727273[/C][/ROW]
[ROW][C]104[/C][C]150.258[/C][C]169.638953125[/C][C]-19.380953125[/C][/ROW]
[ROW][C]105[/C][C]154.003[/C][C]169.638953125[/C][C]-15.635953125[/C][/ROW]
[ROW][C]106[/C][C]149.689[/C][C]169.638953125[/C][C]-19.949953125[/C][/ROW]
[ROW][C]107[/C][C]155.078[/C][C]169.638953125[/C][C]-14.560953125[/C][/ROW]
[ROW][C]108[/C][C]151.884[/C][C]169.638953125[/C][C]-17.754953125[/C][/ROW]
[ROW][C]109[/C][C]151.989[/C][C]169.638953125[/C][C]-17.649953125[/C][/ROW]
[ROW][C]110[/C][C]193.03[/C][C]169.638953125[/C][C]23.391046875[/C][/ROW]
[ROW][C]111[/C][C]200.714[/C][C]169.638953125[/C][C]31.075046875[/C][/ROW]
[ROW][C]112[/C][C]208.519[/C][C]207.738[/C][C]0.781000000000006[/C][/ROW]
[ROW][C]113[/C][C]204.664[/C][C]207.738[/C][C]-3.07400000000001[/C][/ROW]
[ROW][C]114[/C][C]210.141[/C][C]207.738[/C][C]2.40299999999999[/C][/ROW]
[ROW][C]115[/C][C]206.327[/C][C]169.638953125[/C][C]36.688046875[/C][/ROW]
[ROW][C]116[/C][C]151.872[/C][C]141.053727272727[/C][C]10.8182727272727[/C][/ROW]
[ROW][C]117[/C][C]158.219[/C][C]169.638953125[/C][C]-11.419953125[/C][/ROW]
[ROW][C]118[/C][C]170.756[/C][C]169.638953125[/C][C]1.117046875[/C][/ROW]
[ROW][C]119[/C][C]178.285[/C][C]169.638953125[/C][C]8.646046875[/C][/ROW]
[ROW][C]120[/C][C]217.116[/C][C]169.638953125[/C][C]47.477046875[/C][/ROW]
[ROW][C]121[/C][C]128.94[/C][C]141.053727272727[/C][C]-12.1137272727273[/C][/ROW]
[ROW][C]122[/C][C]176.824[/C][C]169.638953125[/C][C]7.18504687500001[/C][/ROW]
[ROW][C]123[/C][C]138.19[/C][C]141.053727272727[/C][C]-2.86372727272729[/C][/ROW]
[ROW][C]124[/C][C]182.018[/C][C]141.053727272727[/C][C]40.9642727272727[/C][/ROW]
[ROW][C]125[/C][C]156.239[/C][C]169.638953125[/C][C]-13.399953125[/C][/ROW]
[ROW][C]126[/C][C]145.174[/C][C]141.053727272727[/C][C]4.12027272727272[/C][/ROW]
[ROW][C]127[/C][C]138.145[/C][C]169.638953125[/C][C]-31.493953125[/C][/ROW]
[ROW][C]128[/C][C]166.888[/C][C]169.638953125[/C][C]-2.750953125[/C][/ROW]
[ROW][C]129[/C][C]119.031[/C][C]115.429885714286[/C][C]3.60111428571429[/C][/ROW]
[ROW][C]130[/C][C]120.078[/C][C]115.429885714286[/C][C]4.64811428571429[/C][/ROW]
[ROW][C]131[/C][C]120.289[/C][C]115.429885714286[/C][C]4.85911428571428[/C][/ROW]
[ROW][C]132[/C][C]120.256[/C][C]115.429885714286[/C][C]4.82611428571428[/C][/ROW]
[ROW][C]133[/C][C]119.056[/C][C]115.429885714286[/C][C]3.62611428571428[/C][/ROW]
[ROW][C]134[/C][C]118.747[/C][C]115.429885714286[/C][C]3.31711428571428[/C][/ROW]
[ROW][C]135[/C][C]106.516[/C][C]101.127714285714[/C][C]5.38828571428571[/C][/ROW]
[ROW][C]136[/C][C]110.453[/C][C]115.429885714286[/C][C]-4.97688571428571[/C][/ROW]
[ROW][C]137[/C][C]113.4[/C][C]115.429885714286[/C][C]-2.02988571428571[/C][/ROW]
[ROW][C]138[/C][C]113.166[/C][C]115.429885714286[/C][C]-2.26388571428572[/C][/ROW]
[ROW][C]139[/C][C]112.239[/C][C]115.429885714286[/C][C]-3.19088571428571[/C][/ROW]
[ROW][C]140[/C][C]116.15[/C][C]115.429885714286[/C][C]0.720114285714288[/C][/ROW]
[ROW][C]141[/C][C]170.368[/C][C]169.638953125[/C][C]0.729046874999995[/C][/ROW]
[ROW][C]142[/C][C]208.083[/C][C]169.638953125[/C][C]38.444046875[/C][/ROW]
[ROW][C]143[/C][C]198.458[/C][C]185.517470588235[/C][C]12.9405294117647[/C][/ROW]
[ROW][C]144[/C][C]202.805[/C][C]169.638953125[/C][C]33.166046875[/C][/ROW]
[ROW][C]145[/C][C]202.544[/C][C]185.517470588235[/C][C]17.0265294117647[/C][/ROW]
[ROW][C]146[/C][C]223.361[/C][C]169.638953125[/C][C]53.722046875[/C][/ROW]
[ROW][C]147[/C][C]169.774[/C][C]185.517470588235[/C][C]-15.7434705882353[/C][/ROW]
[ROW][C]148[/C][C]183.52[/C][C]185.517470588235[/C][C]-1.9974705882353[/C][/ROW]
[ROW][C]149[/C][C]188.62[/C][C]185.517470588235[/C][C]3.10252941176469[/C][/ROW]
[ROW][C]150[/C][C]202.632[/C][C]185.517470588235[/C][C]17.1145294117647[/C][/ROW]
[ROW][C]151[/C][C]186.695[/C][C]185.517470588235[/C][C]1.17752941176468[/C][/ROW]
[ROW][C]152[/C][C]192.818[/C][C]185.517470588235[/C][C]7.3005294117647[/C][/ROW]
[ROW][C]153[/C][C]198.116[/C][C]185.517470588235[/C][C]12.5985294117647[/C][/ROW]
[ROW][C]154[/C][C]121.345[/C][C]121.613333333333[/C][C]-0.268333333333331[/C][/ROW]
[ROW][C]155[/C][C]119.1[/C][C]115.429885714286[/C][C]3.67011428571428[/C][/ROW]
[ROW][C]156[/C][C]117.87[/C][C]115.429885714286[/C][C]2.44011428571429[/C][/ROW]
[ROW][C]157[/C][C]122.336[/C][C]121.613333333333[/C][C]0.722666666666669[/C][/ROW]
[ROW][C]158[/C][C]117.963[/C][C]115.429885714286[/C][C]2.53311428571428[/C][/ROW]
[ROW][C]159[/C][C]126.144[/C][C]121.613333333333[/C][C]4.53066666666668[/C][/ROW]
[ROW][C]160[/C][C]127.93[/C][C]121.613333333333[/C][C]6.31666666666668[/C][/ROW]
[ROW][C]161[/C][C]114.238[/C][C]115.429885714286[/C][C]-1.19188571428572[/C][/ROW]
[ROW][C]162[/C][C]115.322[/C][C]121.613333333333[/C][C]-6.29133333333333[/C][/ROW]
[ROW][C]163[/C][C]114.554[/C][C]115.429885714286[/C][C]-0.875885714285715[/C][/ROW]
[ROW][C]164[/C][C]112.15[/C][C]115.429885714286[/C][C]-3.27988571428571[/C][/ROW]
[ROW][C]165[/C][C]102.273[/C][C]121.613333333333[/C][C]-19.3403333333333[/C][/ROW]
[ROW][C]166[/C][C]236.2[/C][C]169.638953125[/C][C]66.561046875[/C][/ROW]
[ROW][C]167[/C][C]237.323[/C][C]239.46825[/C][C]-2.14525[/C][/ROW]
[ROW][C]168[/C][C]260.105[/C][C]239.46825[/C][C]20.63675[/C][/ROW]
[ROW][C]169[/C][C]197.569[/C][C]169.638953125[/C][C]27.930046875[/C][/ROW]
[ROW][C]170[/C][C]240.301[/C][C]239.46825[/C][C]0.832749999999976[/C][/ROW]
[ROW][C]171[/C][C]244.99[/C][C]239.46825[/C][C]5.52175[/C][/ROW]
[ROW][C]172[/C][C]112.547[/C][C]115.429885714286[/C][C]-2.88288571428572[/C][/ROW]
[ROW][C]173[/C][C]110.739[/C][C]101.127714285714[/C][C]9.61128571428571[/C][/ROW]
[ROW][C]174[/C][C]113.715[/C][C]101.127714285714[/C][C]12.5872857142857[/C][/ROW]
[ROW][C]175[/C][C]117.004[/C][C]121.613333333333[/C][C]-4.60933333333332[/C][/ROW]
[ROW][C]176[/C][C]115.38[/C][C]115.429885714286[/C][C]-0.0498857142857219[/C][/ROW]
[ROW][C]177[/C][C]116.388[/C][C]115.429885714286[/C][C]0.958114285714288[/C][/ROW]
[ROW][C]178[/C][C]151.737[/C][C]169.638953125[/C][C]-17.901953125[/C][/ROW]
[ROW][C]179[/C][C]148.79[/C][C]169.638953125[/C][C]-20.848953125[/C][/ROW]
[ROW][C]180[/C][C]148.143[/C][C]169.638953125[/C][C]-21.495953125[/C][/ROW]
[ROW][C]181[/C][C]150.44[/C][C]169.638953125[/C][C]-19.198953125[/C][/ROW]
[ROW][C]182[/C][C]148.462[/C][C]169.638953125[/C][C]-21.176953125[/C][/ROW]
[ROW][C]183[/C][C]149.818[/C][C]169.638953125[/C][C]-19.820953125[/C][/ROW]
[ROW][C]184[/C][C]117.226[/C][C]115.429885714286[/C][C]1.79611428571428[/C][/ROW]
[ROW][C]185[/C][C]116.848[/C][C]141.053727272727[/C][C]-24.2057272727273[/C][/ROW]
[ROW][C]186[/C][C]116.286[/C][C]169.638953125[/C][C]-53.352953125[/C][/ROW]
[ROW][C]187[/C][C]116.556[/C][C]169.638953125[/C][C]-53.082953125[/C][/ROW]
[ROW][C]188[/C][C]116.342[/C][C]169.638953125[/C][C]-53.296953125[/C][/ROW]
[ROW][C]189[/C][C]114.563[/C][C]101.127714285714[/C][C]13.4352857142857[/C][/ROW]
[ROW][C]190[/C][C]201.774[/C][C]169.638953125[/C][C]32.135046875[/C][/ROW]
[ROW][C]191[/C][C]174.188[/C][C]169.638953125[/C][C]4.54904687499999[/C][/ROW]
[ROW][C]192[/C][C]209.516[/C][C]169.638953125[/C][C]39.877046875[/C][/ROW]
[ROW][C]193[/C][C]174.688[/C][C]141.053727272727[/C][C]33.6342727272727[/C][/ROW]
[ROW][C]194[/C][C]198.764[/C][C]169.638953125[/C][C]29.125046875[/C][/ROW]
[ROW][C]195[/C][C]214.289[/C][C]169.638953125[/C][C]44.650046875[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=230621&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=230621&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
1119.992141.053727272727-21.0617272727273
2122.4121.6133333333330.786666666666676
3116.682115.4298857142861.25211428571428
4116.676121.613333333333-4.93733333333333
5116.014121.613333333333-5.59933333333333
6120.552115.4298857142865.12211428571429
7120.267121.613333333333-1.34633333333333
8107.332101.1277142857146.2042857142857
995.73115.429885714286-19.6998857142857
1095.056101.127714285714-6.07171428571429
1188.333101.127714285714-12.7947142857143
1291.904101.127714285714-9.22371428571429
13136.926169.638953125-32.712953125
14139.173169.638953125-30.465953125
15152.845169.638953125-16.793953125
16142.167169.638953125-27.471953125
17144.188169.638953125-25.450953125
18168.778169.638953125-0.860953125000009
19153.046141.05372727272711.9922727272727
20156.405141.05372727272715.3512727272727
21153.848141.05372727272712.7942727272727
22153.88169.638953125-15.758953125
23167.93169.638953125-1.70895312499999
24173.917169.6389531254.278046875
25163.656141.05372727272722.6022727272727
26104.4141.053727272727-36.6537272727273
27171.041169.6389531251.402046875
28146.845169.638953125-22.793953125
29155.358169.638953125-14.280953125
30162.568169.638953125-7.07095312499999
31197.076207.738-10.662
32199.228207.738-8.50999999999999
33198.383207.738-9.35499999999999
34202.266207.738-5.47200000000001
35203.184207.738-4.554
36201.464207.738-6.274
37177.876185.517470588235-7.64147058823531
38176.17185.517470588235-9.34747058823532
39180.198185.517470588235-5.3194705882353
40187.733185.5174705882352.21552941176469
41186.163185.5174705882350.645529411764699
42184.055185.517470588235-1.46247058823531
43237.226239.46825-2.24225000000001
44241.404239.468251.93574999999998
45243.439239.468253.97074999999998
46242.852239.468253.38374999999999
47245.51239.468256.04174999999998
48252.455207.73844.717
49122.188115.4298857142866.75811428571429
50122.964115.4298857142867.53411428571428
51124.445121.6133333333332.83166666666666
52126.344115.42988571428610.9141142857143
53128.001121.6133333333336.38766666666668
54129.336121.6133333333337.72266666666668
55108.807115.429885714286-6.62288571428572
56109.86115.429885714286-5.56988571428572
57110.417115.429885714286-5.01288571428572
58117.274115.4298857142861.84411428571428
59116.879115.4298857142861.44911428571429
60114.847141.053727272727-26.2067272727273
61209.144169.63895312539.505046875
62223.365169.63895312553.726046875
63222.236239.46825-17.23225
64228.832239.46825-10.63625
65229.401239.46825-10.06725
66228.969169.63895312559.330046875
67140.341141.053727272727-0.712727272727278
68136.969141.053727272727-4.08472727272729
69143.533141.0537272727272.4792727272727
70148.09141.0537272727277.03627272727272
71142.729141.0537272727271.67527272727273
72136.358141.053727272727-4.69572727272728
73120.08121.613333333333-1.53333333333333
74112.014141.053727272727-29.0397272727273
75110.793115.429885714286-4.63688571428571
76110.707115.429885714286-4.72288571428572
77112.876121.613333333333-8.73733333333332
78110.568115.429885714286-4.86188571428572
7995.385101.127714285714-5.74271428571429
80100.77101.127714285714-0.357714285714295
8196.106101.127714285714-5.0217142857143
8295.605101.127714285714-5.52271428571429
83100.96101.127714285714-0.167714285714297
8498.804101.127714285714-2.32371428571429
85176.858169.6389531257.219046875
86180.978185.517470588235-4.5394705882353
87178.222169.6389531258.58304687500001
88176.281169.6389531256.64204687500001
89173.898169.6389531254.259046875
90179.711169.63895312510.072046875
91166.605169.638953125-3.03395312500001
92151.955169.638953125-17.683953125
93148.272169.638953125-21.366953125
94152.125169.638953125-17.513953125
95157.821169.638953125-11.817953125
96157.447185.517470588235-28.0704705882353
97159.116169.638953125-10.522953125
98125.036121.6133333333333.42266666666667
99125.791121.6133333333334.17766666666667
100126.512121.6133333333334.89866666666667
101125.641121.6133333333334.02766666666668
102128.451121.6133333333336.83766666666666
103139.224141.053727272727-1.8297272727273
104150.258169.638953125-19.380953125
105154.003169.638953125-15.635953125
106149.689169.638953125-19.949953125
107155.078169.638953125-14.560953125
108151.884169.638953125-17.754953125
109151.989169.638953125-17.649953125
110193.03169.63895312523.391046875
111200.714169.63895312531.075046875
112208.519207.7380.781000000000006
113204.664207.738-3.07400000000001
114210.141207.7382.40299999999999
115206.327169.63895312536.688046875
116151.872141.05372727272710.8182727272727
117158.219169.638953125-11.419953125
118170.756169.6389531251.117046875
119178.285169.6389531258.646046875
120217.116169.63895312547.477046875
121128.94141.053727272727-12.1137272727273
122176.824169.6389531257.18504687500001
123138.19141.053727272727-2.86372727272729
124182.018141.05372727272740.9642727272727
125156.239169.638953125-13.399953125
126145.174141.0537272727274.12027272727272
127138.145169.638953125-31.493953125
128166.888169.638953125-2.750953125
129119.031115.4298857142863.60111428571429
130120.078115.4298857142864.64811428571429
131120.289115.4298857142864.85911428571428
132120.256115.4298857142864.82611428571428
133119.056115.4298857142863.62611428571428
134118.747115.4298857142863.31711428571428
135106.516101.1277142857145.38828571428571
136110.453115.429885714286-4.97688571428571
137113.4115.429885714286-2.02988571428571
138113.166115.429885714286-2.26388571428572
139112.239115.429885714286-3.19088571428571
140116.15115.4298857142860.720114285714288
141170.368169.6389531250.729046874999995
142208.083169.63895312538.444046875
143198.458185.51747058823512.9405294117647
144202.805169.63895312533.166046875
145202.544185.51747058823517.0265294117647
146223.361169.63895312553.722046875
147169.774185.517470588235-15.7434705882353
148183.52185.517470588235-1.9974705882353
149188.62185.5174705882353.10252941176469
150202.632185.51747058823517.1145294117647
151186.695185.5174705882351.17752941176468
152192.818185.5174705882357.3005294117647
153198.116185.51747058823512.5985294117647
154121.345121.613333333333-0.268333333333331
155119.1115.4298857142863.67011428571428
156117.87115.4298857142862.44011428571429
157122.336121.6133333333330.722666666666669
158117.963115.4298857142862.53311428571428
159126.144121.6133333333334.53066666666668
160127.93121.6133333333336.31666666666668
161114.238115.429885714286-1.19188571428572
162115.322121.613333333333-6.29133333333333
163114.554115.429885714286-0.875885714285715
164112.15115.429885714286-3.27988571428571
165102.273121.613333333333-19.3403333333333
166236.2169.63895312566.561046875
167237.323239.46825-2.14525
168260.105239.4682520.63675
169197.569169.63895312527.930046875
170240.301239.468250.832749999999976
171244.99239.468255.52175
172112.547115.429885714286-2.88288571428572
173110.739101.1277142857149.61128571428571
174113.715101.12771428571412.5872857142857
175117.004121.613333333333-4.60933333333332
176115.38115.429885714286-0.0498857142857219
177116.388115.4298857142860.958114285714288
178151.737169.638953125-17.901953125
179148.79169.638953125-20.848953125
180148.143169.638953125-21.495953125
181150.44169.638953125-19.198953125
182148.462169.638953125-21.176953125
183149.818169.638953125-19.820953125
184117.226115.4298857142861.79611428571428
185116.848141.053727272727-24.2057272727273
186116.286169.638953125-53.352953125
187116.556169.638953125-53.082953125
188116.342169.638953125-53.296953125
189114.563101.12771428571413.4352857142857
190201.774169.63895312532.135046875
191174.188169.6389531254.54904687499999
192209.516169.63895312539.877046875
193174.688141.05372727272733.6342727272727
194198.764169.63895312529.125046875
195214.289169.63895312544.650046875



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