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 computationThu, 17 May 2012 10:06:32 -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/May/17/t1337263612ab7b45m6r2seomj.htm/, Retrieved Mon, 29 Apr 2024 22:48:00 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=166621, Retrieved Mon, 29 Apr 2024 22:48:00 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact102
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Social Networking] [] [2012-05-17 13:38:59] [518aa67394b1ff91cc885d6a199d84d8]
- RMP     [Recursive Partitioning (Regression Trees)] [] [2012-05-17 14:06:32] [bd7a66e2f212a6bc9afe853e3942ee45] [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'Herman Ole Andreas Wold' @ wold.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 & 'Herman Ole Andreas Wold' @ wold.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=166621&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]'Herman Ole Andreas Wold' @ wold.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=166621&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=166621&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'Herman Ole Andreas Wold' @ wold.wessa.net







Goodness of Fit
CorrelationNA
R-squaredNA
RMSE4614.4978

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

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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=166621&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
CorrelationNA
R-squaredNA
RMSE4614.4978







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
112560.8311206.36433789951354.46566210046
26746.3411206.3643378995-4460.02433789954
311056.5911206.3643378995-149.774337899544
49605.0411206.3643378995-1601.32433789954
59115.5611206.3643378995-2090.80433789954
68805.9511206.3643378995-2400.41433789954
712362.5911206.36433789951156.22566210046
89692.1111206.3643378995-1514.25433789954
97445.2511206.3643378995-3761.11433789954
1010211.7511206.3643378995-994.614337899544
1118789.5511206.36433789957583.18566210046
1211412.2111206.3643378995205.845662100455
1312557.8511206.36433789951351.48566210046
1413530.6911206.36433789952324.32566210046
159906.7411206.3643378995-1299.62433789954
169958.7111206.3643378995-1247.65433789954
1714131.1911206.36433789952924.82566210046
1810637.9811206.3643378995-568.384337899544
199859.0711206.3643378995-1347.29433789954
2014214.2311206.36433789953007.86566210046
2111619.0511206.3643378995412.685662100455
2233644.9611206.364337899522438.5956621005
2310267.2511206.3643378995-939.114337899544
2411146.3311206.3643378995-60.034337899544
2511351.4711206.3643378995145.105662100455
2618802.4311206.36433789957596.06566210046
27524111206.3643378995-5965.36433789954
2813003.9711206.36433789951797.60566210046
2918688.7511206.36433789957482.38566210046
3017945.8811206.36433789956739.51566210045
3116213.1211206.36433789955006.75566210046
329462.5311206.3643378995-1743.83433789955
3312839.2411206.36433789951632.87566210046
346908.1811206.3643378995-4298.18433789954
359877.2311206.3643378995-1329.13433789954
3610827.2511206.3643378995-379.114337899544
377485.8711206.3643378995-3720.49433789954
3818584.8711206.36433789957378.50566210046
399530.2311206.3643378995-1676.13433789954
4018205.9711206.36433789956999.60566210046
416135.0811206.3643378995-5071.28433789954
424551.8311206.3643378995-6654.53433789954
437490.6211206.3643378995-3715.74433789954
4413299.311206.36433789952092.93566210046
4512630.9811206.36433789951424.61566210046
4610972.3511206.3643378995-234.014337899544
4717193.0211206.36433789955986.65566210046
4813588.9111206.36433789952382.54566210046
4913512.2411206.36433789952305.87566210046
5017165.8611206.36433789955959.49566210046
5110009.1711206.3643378995-1197.19433789954
526195.6911206.3643378995-5010.67433789954
5324073.5311206.364337899512867.1656621005
547659.0511206.3643378995-3547.31433789954
5513109.3411206.36433789951902.97566210046
5613021.6611206.36433789951815.29566210046
576454.7711206.3643378995-4751.59433789954
586618.4911206.3643378995-4587.87433789954
5911773.4811206.3643378995567.115662100456
6032946.3611206.364337899521739.9956621005
6118620.9411206.36433789957414.57566210046
6210339.7211206.3643378995-866.644337899543
6311123.1411206.3643378995-83.2243378995445
6410573.3511206.3643378995-633.014337899544
6512378.9111206.36433789951172.54566210046
661455.6811206.3643378995-9750.68433789954
6711423.9711206.3643378995217.605662100455
688271.0511206.3643378995-2935.31433789954
6912710.2711206.36433789951503.90566210046
7011346.2511206.3643378995139.885662100456
7114125.5411206.36433789952919.17566210046
729564.6411206.3643378995-1641.72433789954
7316131.8511206.36433789954925.48566210046
746925.6311206.3643378995-4280.73433789954
756136.4611206.3643378995-5069.90433789954
767767.9111206.3643378995-3438.45433789954
7713043.9811206.36433789951837.61566210046
7812884.3111206.36433789951677.94566210046
7918401.7811206.36433789957195.41566210045
8017015.0711206.36433789955808.70566210046
819622.8811206.3643378995-1583.48433789954
828248.4611206.3643378995-2957.90433789954
8311913.1111206.3643378995706.745662100457
8411662.1211206.3643378995455.755662100455
8525701.6711206.364337899514495.3056621005
867601.0911206.3643378995-3605.27433789954
8711351.1811206.3643378995144.815662100456
8812510.8211206.36433789951304.45566210046
8922073.7411206.364337899510867.3756621005
9010929.111206.3643378995-277.264337899544
9111205.4211206.3643378995-0.944337899543825
9216889.5611206.36433789955683.19566210045
9311089.4411206.3643378995-116.924337899543
9412054.6411206.3643378995848.275662100456
9519061.3211206.36433789957854.95566210046
9613629.6711206.36433789952423.30566210046
977570.8511206.3643378995-3635.51433789954
9811334.0811206.3643378995127.715662100456
9912604.6311206.36433789951398.26566210046
10011378.5311206.3643378995172.165662100455
1017912.7511206.3643378995-3293.61433789954
10211526.6111206.3643378995320.245662100457
1039656.5611206.3643378995-1549.80433789954
10418940.1511206.36433789957733.78566210046
1056899.6811206.3643378995-4306.68433789954
1069994.2811206.3643378995-1212.08433789954
1078914.5411206.3643378995-2291.82433789954
1086238.0111206.3643378995-4968.35433789954
10912121.6111206.3643378995915.245662100457
11016230.9611206.36433789955024.59566210046
11110035.4111206.3643378995-1170.95433789954
1128083.7511206.3643378995-3122.61433789954
1139688.3611206.3643378995-1518.00433789954
11413803.7611206.36433789952597.39566210046
11518126.8911206.36433789956920.52566210046
11610129.2611206.3643378995-1077.10433789954
11713696.7611206.36433789952490.39566210046
1187444.3211206.3643378995-3762.04433789954
11914591.6911206.36433789953385.32566210045
1208870.3411206.3643378995-2336.02433789954
1219752.6511206.3643378995-1453.71433789954
1226179.8411206.3643378995-5026.52433789954
1237683.2311206.3643378995-3523.13433789954
12410226.0211206.3643378995-980.344337899543
1257141.9611206.3643378995-4064.40433789954
12617394.2711206.36433789956187.90566210046
12714159.9111206.36433789952953.54566210046
1288975.8211206.3643378995-2230.54433789954
1299635.5211206.3643378995-1570.84433789954
13010485.3111206.3643378995-721.054337899543
1319096.5311206.3643378995-2109.83433789955
13213043.2611206.36433789951836.89566210046
13317338.5911206.36433789956132.22566210046
1348228.3911206.3643378995-2977.97433789954
1357967.8211206.3643378995-3238.54433789954
13611613.8711206.3643378995407.505662100455
13711392.9411206.3643378995186.575662100457
13814565.6211206.36433789953359.25566210046
1398315.4911206.3643378995-2890.87433789954
14015474.5311206.36433789954268.16566210045
14115740.7811206.36433789954534.41566210046
1428821.311206.3643378995-2385.06433789954
1439649.9811206.3643378995-1556.38433789954
14412950.0911206.36433789951743.72566210046
14511025.4111206.3643378995-180.954337899544
1469762.9711206.3643378995-1443.39433789954
14710007.3211206.3643378995-1199.04433789954
14814456.6911206.36433789953250.32566210046
149312.3211206.3643378995-10894.0443378995
1508000.2311206.3643378995-3206.13433789954
15112871.9411206.36433789951665.57566210046
15212670.0511206.36433789951463.68566210046
15310142.8211206.3643378995-1063.54433789954
15410443.8211206.3643378995-762.544337899544
15510070.7711206.3643378995-1135.59433789954
15612364.3711206.36433789951158.00566210046
1577685.1111206.3643378995-3521.25433789954
15816068.9111206.36433789954862.54566210046
1594260.9611206.3643378995-6945.40433789954
1604263.6511206.3643378995-6942.71433789954
1618652.8211206.3643378995-2553.54433789954
1629808.1611206.3643378995-1398.20433789954
1636106.8611206.3643378995-5099.50433789954
1649756.5711206.3643378995-1449.79433789954
16517509.5111206.36433789956303.14566210046
1667451.3811206.3643378995-3754.98433789954
1677559.8811206.3643378995-3646.48433789954
168948011206.3643378995-1726.36433789954
1699447.6511206.3643378995-1758.71433789954
17017281.4811206.36433789956075.11566210046
17110012.8811206.3643378995-1193.48433789954
17214942.5611206.36433789953736.19566210046
1735679.4111206.3643378995-5526.95433789954
17410118.7511206.3643378995-1087.61433789954
1759826.7411206.3643378995-1379.62433789954
17611758.4911206.3643378995552.125662100456
1779503.1111206.3643378995-1703.25433789954
1783928.2711206.3643378995-7278.09433789954
1799389.2311206.3643378995-1817.13433789954
18020683.2411206.36433789959476.87566210045
1816783.1911206.3643378995-4423.17433789954
1822078.311206.3643378995-9128.06433789954
1838665.6711206.3643378995-2540.69433789954
18414167.7311206.36433789952961.36566210046
18511099.2211206.3643378995-107.144337899543
18612040.9511206.3643378995834.585662100457
1877242.2411206.3643378995-3964.12433789954
18819323.4311206.36433789958117.06566210046
1894380.0511206.3643378995-6826.31433789954
1905643.2411206.3643378995-5563.12433789954
1913626.5911206.3643378995-7579.77433789954
19214639.7811206.36433789953433.41566210045
193906.0411206.3643378995-10300.3243378995
19414625.7711206.36433789953419.40566210046
1956894.7811206.3643378995-4311.58433789954
19612805.9511206.36433789951599.58566210046
1977642.4311206.3643378995-3563.93433789954
1988562.8911206.3643378995-2643.47433789954
1998514.3911206.3643378995-2691.97433789954
20019226.2911206.36433789958019.92566210046
2015641.3411206.3643378995-5565.02433789954
2028592.511206.3643378995-2613.86433789954
2038005.4611206.3643378995-3200.90433789954
20415285.8811206.36433789954079.51566210046
2058228.6711206.3643378995-2977.69433789954
2067955.0211206.3643378995-3251.34433789954
2077690.8711206.3643378995-3515.49433789954
2088254.5311206.3643378995-2951.83433789955
20915101.5611206.36433789953895.19566210046
21013953.0211206.36433789952746.65566210046
21113104.8511206.36433789951898.48566210046
2125915.8111206.3643378995-5290.55433789954
2135504.2311206.3643378995-5702.13433789954
21410692.6911206.3643378995-513.674337899545
2159730.5711206.3643378995-1475.79433789954
21612431.0511206.36433789951224.68566210046
21710350.3811206.3643378995-855.984337899543
2188117.7311206.3643378995-3088.63433789954
2197404.6611206.3643378995-3801.70433789954

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 12560.83 & 11206.3643378995 & 1354.46566210046 \tabularnewline
2 & 6746.34 & 11206.3643378995 & -4460.02433789954 \tabularnewline
3 & 11056.59 & 11206.3643378995 & -149.774337899544 \tabularnewline
4 & 9605.04 & 11206.3643378995 & -1601.32433789954 \tabularnewline
5 & 9115.56 & 11206.3643378995 & -2090.80433789954 \tabularnewline
6 & 8805.95 & 11206.3643378995 & -2400.41433789954 \tabularnewline
7 & 12362.59 & 11206.3643378995 & 1156.22566210046 \tabularnewline
8 & 9692.11 & 11206.3643378995 & -1514.25433789954 \tabularnewline
9 & 7445.25 & 11206.3643378995 & -3761.11433789954 \tabularnewline
10 & 10211.75 & 11206.3643378995 & -994.614337899544 \tabularnewline
11 & 18789.55 & 11206.3643378995 & 7583.18566210046 \tabularnewline
12 & 11412.21 & 11206.3643378995 & 205.845662100455 \tabularnewline
13 & 12557.85 & 11206.3643378995 & 1351.48566210046 \tabularnewline
14 & 13530.69 & 11206.3643378995 & 2324.32566210046 \tabularnewline
15 & 9906.74 & 11206.3643378995 & -1299.62433789954 \tabularnewline
16 & 9958.71 & 11206.3643378995 & -1247.65433789954 \tabularnewline
17 & 14131.19 & 11206.3643378995 & 2924.82566210046 \tabularnewline
18 & 10637.98 & 11206.3643378995 & -568.384337899544 \tabularnewline
19 & 9859.07 & 11206.3643378995 & -1347.29433789954 \tabularnewline
20 & 14214.23 & 11206.3643378995 & 3007.86566210046 \tabularnewline
21 & 11619.05 & 11206.3643378995 & 412.685662100455 \tabularnewline
22 & 33644.96 & 11206.3643378995 & 22438.5956621005 \tabularnewline
23 & 10267.25 & 11206.3643378995 & -939.114337899544 \tabularnewline
24 & 11146.33 & 11206.3643378995 & -60.034337899544 \tabularnewline
25 & 11351.47 & 11206.3643378995 & 145.105662100455 \tabularnewline
26 & 18802.43 & 11206.3643378995 & 7596.06566210046 \tabularnewline
27 & 5241 & 11206.3643378995 & -5965.36433789954 \tabularnewline
28 & 13003.97 & 11206.3643378995 & 1797.60566210046 \tabularnewline
29 & 18688.75 & 11206.3643378995 & 7482.38566210046 \tabularnewline
30 & 17945.88 & 11206.3643378995 & 6739.51566210045 \tabularnewline
31 & 16213.12 & 11206.3643378995 & 5006.75566210046 \tabularnewline
32 & 9462.53 & 11206.3643378995 & -1743.83433789955 \tabularnewline
33 & 12839.24 & 11206.3643378995 & 1632.87566210046 \tabularnewline
34 & 6908.18 & 11206.3643378995 & -4298.18433789954 \tabularnewline
35 & 9877.23 & 11206.3643378995 & -1329.13433789954 \tabularnewline
36 & 10827.25 & 11206.3643378995 & -379.114337899544 \tabularnewline
37 & 7485.87 & 11206.3643378995 & -3720.49433789954 \tabularnewline
38 & 18584.87 & 11206.3643378995 & 7378.50566210046 \tabularnewline
39 & 9530.23 & 11206.3643378995 & -1676.13433789954 \tabularnewline
40 & 18205.97 & 11206.3643378995 & 6999.60566210046 \tabularnewline
41 & 6135.08 & 11206.3643378995 & -5071.28433789954 \tabularnewline
42 & 4551.83 & 11206.3643378995 & -6654.53433789954 \tabularnewline
43 & 7490.62 & 11206.3643378995 & -3715.74433789954 \tabularnewline
44 & 13299.3 & 11206.3643378995 & 2092.93566210046 \tabularnewline
45 & 12630.98 & 11206.3643378995 & 1424.61566210046 \tabularnewline
46 & 10972.35 & 11206.3643378995 & -234.014337899544 \tabularnewline
47 & 17193.02 & 11206.3643378995 & 5986.65566210046 \tabularnewline
48 & 13588.91 & 11206.3643378995 & 2382.54566210046 \tabularnewline
49 & 13512.24 & 11206.3643378995 & 2305.87566210046 \tabularnewline
50 & 17165.86 & 11206.3643378995 & 5959.49566210046 \tabularnewline
51 & 10009.17 & 11206.3643378995 & -1197.19433789954 \tabularnewline
52 & 6195.69 & 11206.3643378995 & -5010.67433789954 \tabularnewline
53 & 24073.53 & 11206.3643378995 & 12867.1656621005 \tabularnewline
54 & 7659.05 & 11206.3643378995 & -3547.31433789954 \tabularnewline
55 & 13109.34 & 11206.3643378995 & 1902.97566210046 \tabularnewline
56 & 13021.66 & 11206.3643378995 & 1815.29566210046 \tabularnewline
57 & 6454.77 & 11206.3643378995 & -4751.59433789954 \tabularnewline
58 & 6618.49 & 11206.3643378995 & -4587.87433789954 \tabularnewline
59 & 11773.48 & 11206.3643378995 & 567.115662100456 \tabularnewline
60 & 32946.36 & 11206.3643378995 & 21739.9956621005 \tabularnewline
61 & 18620.94 & 11206.3643378995 & 7414.57566210046 \tabularnewline
62 & 10339.72 & 11206.3643378995 & -866.644337899543 \tabularnewline
63 & 11123.14 & 11206.3643378995 & -83.2243378995445 \tabularnewline
64 & 10573.35 & 11206.3643378995 & -633.014337899544 \tabularnewline
65 & 12378.91 & 11206.3643378995 & 1172.54566210046 \tabularnewline
66 & 1455.68 & 11206.3643378995 & -9750.68433789954 \tabularnewline
67 & 11423.97 & 11206.3643378995 & 217.605662100455 \tabularnewline
68 & 8271.05 & 11206.3643378995 & -2935.31433789954 \tabularnewline
69 & 12710.27 & 11206.3643378995 & 1503.90566210046 \tabularnewline
70 & 11346.25 & 11206.3643378995 & 139.885662100456 \tabularnewline
71 & 14125.54 & 11206.3643378995 & 2919.17566210046 \tabularnewline
72 & 9564.64 & 11206.3643378995 & -1641.72433789954 \tabularnewline
73 & 16131.85 & 11206.3643378995 & 4925.48566210046 \tabularnewline
74 & 6925.63 & 11206.3643378995 & -4280.73433789954 \tabularnewline
75 & 6136.46 & 11206.3643378995 & -5069.90433789954 \tabularnewline
76 & 7767.91 & 11206.3643378995 & -3438.45433789954 \tabularnewline
77 & 13043.98 & 11206.3643378995 & 1837.61566210046 \tabularnewline
78 & 12884.31 & 11206.3643378995 & 1677.94566210046 \tabularnewline
79 & 18401.78 & 11206.3643378995 & 7195.41566210045 \tabularnewline
80 & 17015.07 & 11206.3643378995 & 5808.70566210046 \tabularnewline
81 & 9622.88 & 11206.3643378995 & -1583.48433789954 \tabularnewline
82 & 8248.46 & 11206.3643378995 & -2957.90433789954 \tabularnewline
83 & 11913.11 & 11206.3643378995 & 706.745662100457 \tabularnewline
84 & 11662.12 & 11206.3643378995 & 455.755662100455 \tabularnewline
85 & 25701.67 & 11206.3643378995 & 14495.3056621005 \tabularnewline
86 & 7601.09 & 11206.3643378995 & -3605.27433789954 \tabularnewline
87 & 11351.18 & 11206.3643378995 & 144.815662100456 \tabularnewline
88 & 12510.82 & 11206.3643378995 & 1304.45566210046 \tabularnewline
89 & 22073.74 & 11206.3643378995 & 10867.3756621005 \tabularnewline
90 & 10929.1 & 11206.3643378995 & -277.264337899544 \tabularnewline
91 & 11205.42 & 11206.3643378995 & -0.944337899543825 \tabularnewline
92 & 16889.56 & 11206.3643378995 & 5683.19566210045 \tabularnewline
93 & 11089.44 & 11206.3643378995 & -116.924337899543 \tabularnewline
94 & 12054.64 & 11206.3643378995 & 848.275662100456 \tabularnewline
95 & 19061.32 & 11206.3643378995 & 7854.95566210046 \tabularnewline
96 & 13629.67 & 11206.3643378995 & 2423.30566210046 \tabularnewline
97 & 7570.85 & 11206.3643378995 & -3635.51433789954 \tabularnewline
98 & 11334.08 & 11206.3643378995 & 127.715662100456 \tabularnewline
99 & 12604.63 & 11206.3643378995 & 1398.26566210046 \tabularnewline
100 & 11378.53 & 11206.3643378995 & 172.165662100455 \tabularnewline
101 & 7912.75 & 11206.3643378995 & -3293.61433789954 \tabularnewline
102 & 11526.61 & 11206.3643378995 & 320.245662100457 \tabularnewline
103 & 9656.56 & 11206.3643378995 & -1549.80433789954 \tabularnewline
104 & 18940.15 & 11206.3643378995 & 7733.78566210046 \tabularnewline
105 & 6899.68 & 11206.3643378995 & -4306.68433789954 \tabularnewline
106 & 9994.28 & 11206.3643378995 & -1212.08433789954 \tabularnewline
107 & 8914.54 & 11206.3643378995 & -2291.82433789954 \tabularnewline
108 & 6238.01 & 11206.3643378995 & -4968.35433789954 \tabularnewline
109 & 12121.61 & 11206.3643378995 & 915.245662100457 \tabularnewline
110 & 16230.96 & 11206.3643378995 & 5024.59566210046 \tabularnewline
111 & 10035.41 & 11206.3643378995 & -1170.95433789954 \tabularnewline
112 & 8083.75 & 11206.3643378995 & -3122.61433789954 \tabularnewline
113 & 9688.36 & 11206.3643378995 & -1518.00433789954 \tabularnewline
114 & 13803.76 & 11206.3643378995 & 2597.39566210046 \tabularnewline
115 & 18126.89 & 11206.3643378995 & 6920.52566210046 \tabularnewline
116 & 10129.26 & 11206.3643378995 & -1077.10433789954 \tabularnewline
117 & 13696.76 & 11206.3643378995 & 2490.39566210046 \tabularnewline
118 & 7444.32 & 11206.3643378995 & -3762.04433789954 \tabularnewline
119 & 14591.69 & 11206.3643378995 & 3385.32566210045 \tabularnewline
120 & 8870.34 & 11206.3643378995 & -2336.02433789954 \tabularnewline
121 & 9752.65 & 11206.3643378995 & -1453.71433789954 \tabularnewline
122 & 6179.84 & 11206.3643378995 & -5026.52433789954 \tabularnewline
123 & 7683.23 & 11206.3643378995 & -3523.13433789954 \tabularnewline
124 & 10226.02 & 11206.3643378995 & -980.344337899543 \tabularnewline
125 & 7141.96 & 11206.3643378995 & -4064.40433789954 \tabularnewline
126 & 17394.27 & 11206.3643378995 & 6187.90566210046 \tabularnewline
127 & 14159.91 & 11206.3643378995 & 2953.54566210046 \tabularnewline
128 & 8975.82 & 11206.3643378995 & -2230.54433789954 \tabularnewline
129 & 9635.52 & 11206.3643378995 & -1570.84433789954 \tabularnewline
130 & 10485.31 & 11206.3643378995 & -721.054337899543 \tabularnewline
131 & 9096.53 & 11206.3643378995 & -2109.83433789955 \tabularnewline
132 & 13043.26 & 11206.3643378995 & 1836.89566210046 \tabularnewline
133 & 17338.59 & 11206.3643378995 & 6132.22566210046 \tabularnewline
134 & 8228.39 & 11206.3643378995 & -2977.97433789954 \tabularnewline
135 & 7967.82 & 11206.3643378995 & -3238.54433789954 \tabularnewline
136 & 11613.87 & 11206.3643378995 & 407.505662100455 \tabularnewline
137 & 11392.94 & 11206.3643378995 & 186.575662100457 \tabularnewline
138 & 14565.62 & 11206.3643378995 & 3359.25566210046 \tabularnewline
139 & 8315.49 & 11206.3643378995 & -2890.87433789954 \tabularnewline
140 & 15474.53 & 11206.3643378995 & 4268.16566210045 \tabularnewline
141 & 15740.78 & 11206.3643378995 & 4534.41566210046 \tabularnewline
142 & 8821.3 & 11206.3643378995 & -2385.06433789954 \tabularnewline
143 & 9649.98 & 11206.3643378995 & -1556.38433789954 \tabularnewline
144 & 12950.09 & 11206.3643378995 & 1743.72566210046 \tabularnewline
145 & 11025.41 & 11206.3643378995 & -180.954337899544 \tabularnewline
146 & 9762.97 & 11206.3643378995 & -1443.39433789954 \tabularnewline
147 & 10007.32 & 11206.3643378995 & -1199.04433789954 \tabularnewline
148 & 14456.69 & 11206.3643378995 & 3250.32566210046 \tabularnewline
149 & 312.32 & 11206.3643378995 & -10894.0443378995 \tabularnewline
150 & 8000.23 & 11206.3643378995 & -3206.13433789954 \tabularnewline
151 & 12871.94 & 11206.3643378995 & 1665.57566210046 \tabularnewline
152 & 12670.05 & 11206.3643378995 & 1463.68566210046 \tabularnewline
153 & 10142.82 & 11206.3643378995 & -1063.54433789954 \tabularnewline
154 & 10443.82 & 11206.3643378995 & -762.544337899544 \tabularnewline
155 & 10070.77 & 11206.3643378995 & -1135.59433789954 \tabularnewline
156 & 12364.37 & 11206.3643378995 & 1158.00566210046 \tabularnewline
157 & 7685.11 & 11206.3643378995 & -3521.25433789954 \tabularnewline
158 & 16068.91 & 11206.3643378995 & 4862.54566210046 \tabularnewline
159 & 4260.96 & 11206.3643378995 & -6945.40433789954 \tabularnewline
160 & 4263.65 & 11206.3643378995 & -6942.71433789954 \tabularnewline
161 & 8652.82 & 11206.3643378995 & -2553.54433789954 \tabularnewline
162 & 9808.16 & 11206.3643378995 & -1398.20433789954 \tabularnewline
163 & 6106.86 & 11206.3643378995 & -5099.50433789954 \tabularnewline
164 & 9756.57 & 11206.3643378995 & -1449.79433789954 \tabularnewline
165 & 17509.51 & 11206.3643378995 & 6303.14566210046 \tabularnewline
166 & 7451.38 & 11206.3643378995 & -3754.98433789954 \tabularnewline
167 & 7559.88 & 11206.3643378995 & -3646.48433789954 \tabularnewline
168 & 9480 & 11206.3643378995 & -1726.36433789954 \tabularnewline
169 & 9447.65 & 11206.3643378995 & -1758.71433789954 \tabularnewline
170 & 17281.48 & 11206.3643378995 & 6075.11566210046 \tabularnewline
171 & 10012.88 & 11206.3643378995 & -1193.48433789954 \tabularnewline
172 & 14942.56 & 11206.3643378995 & 3736.19566210046 \tabularnewline
173 & 5679.41 & 11206.3643378995 & -5526.95433789954 \tabularnewline
174 & 10118.75 & 11206.3643378995 & -1087.61433789954 \tabularnewline
175 & 9826.74 & 11206.3643378995 & -1379.62433789954 \tabularnewline
176 & 11758.49 & 11206.3643378995 & 552.125662100456 \tabularnewline
177 & 9503.11 & 11206.3643378995 & -1703.25433789954 \tabularnewline
178 & 3928.27 & 11206.3643378995 & -7278.09433789954 \tabularnewline
179 & 9389.23 & 11206.3643378995 & -1817.13433789954 \tabularnewline
180 & 20683.24 & 11206.3643378995 & 9476.87566210045 \tabularnewline
181 & 6783.19 & 11206.3643378995 & -4423.17433789954 \tabularnewline
182 & 2078.3 & 11206.3643378995 & -9128.06433789954 \tabularnewline
183 & 8665.67 & 11206.3643378995 & -2540.69433789954 \tabularnewline
184 & 14167.73 & 11206.3643378995 & 2961.36566210046 \tabularnewline
185 & 11099.22 & 11206.3643378995 & -107.144337899543 \tabularnewline
186 & 12040.95 & 11206.3643378995 & 834.585662100457 \tabularnewline
187 & 7242.24 & 11206.3643378995 & -3964.12433789954 \tabularnewline
188 & 19323.43 & 11206.3643378995 & 8117.06566210046 \tabularnewline
189 & 4380.05 & 11206.3643378995 & -6826.31433789954 \tabularnewline
190 & 5643.24 & 11206.3643378995 & -5563.12433789954 \tabularnewline
191 & 3626.59 & 11206.3643378995 & -7579.77433789954 \tabularnewline
192 & 14639.78 & 11206.3643378995 & 3433.41566210045 \tabularnewline
193 & 906.04 & 11206.3643378995 & -10300.3243378995 \tabularnewline
194 & 14625.77 & 11206.3643378995 & 3419.40566210046 \tabularnewline
195 & 6894.78 & 11206.3643378995 & -4311.58433789954 \tabularnewline
196 & 12805.95 & 11206.3643378995 & 1599.58566210046 \tabularnewline
197 & 7642.43 & 11206.3643378995 & -3563.93433789954 \tabularnewline
198 & 8562.89 & 11206.3643378995 & -2643.47433789954 \tabularnewline
199 & 8514.39 & 11206.3643378995 & -2691.97433789954 \tabularnewline
200 & 19226.29 & 11206.3643378995 & 8019.92566210046 \tabularnewline
201 & 5641.34 & 11206.3643378995 & -5565.02433789954 \tabularnewline
202 & 8592.5 & 11206.3643378995 & -2613.86433789954 \tabularnewline
203 & 8005.46 & 11206.3643378995 & -3200.90433789954 \tabularnewline
204 & 15285.88 & 11206.3643378995 & 4079.51566210046 \tabularnewline
205 & 8228.67 & 11206.3643378995 & -2977.69433789954 \tabularnewline
206 & 7955.02 & 11206.3643378995 & -3251.34433789954 \tabularnewline
207 & 7690.87 & 11206.3643378995 & -3515.49433789954 \tabularnewline
208 & 8254.53 & 11206.3643378995 & -2951.83433789955 \tabularnewline
209 & 15101.56 & 11206.3643378995 & 3895.19566210046 \tabularnewline
210 & 13953.02 & 11206.3643378995 & 2746.65566210046 \tabularnewline
211 & 13104.85 & 11206.3643378995 & 1898.48566210046 \tabularnewline
212 & 5915.81 & 11206.3643378995 & -5290.55433789954 \tabularnewline
213 & 5504.23 & 11206.3643378995 & -5702.13433789954 \tabularnewline
214 & 10692.69 & 11206.3643378995 & -513.674337899545 \tabularnewline
215 & 9730.57 & 11206.3643378995 & -1475.79433789954 \tabularnewline
216 & 12431.05 & 11206.3643378995 & 1224.68566210046 \tabularnewline
217 & 10350.38 & 11206.3643378995 & -855.984337899543 \tabularnewline
218 & 8117.73 & 11206.3643378995 & -3088.63433789954 \tabularnewline
219 & 7404.66 & 11206.3643378995 & -3801.70433789954 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=166621&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]12560.83[/C][C]11206.3643378995[/C][C]1354.46566210046[/C][/ROW]
[ROW][C]2[/C][C]6746.34[/C][C]11206.3643378995[/C][C]-4460.02433789954[/C][/ROW]
[ROW][C]3[/C][C]11056.59[/C][C]11206.3643378995[/C][C]-149.774337899544[/C][/ROW]
[ROW][C]4[/C][C]9605.04[/C][C]11206.3643378995[/C][C]-1601.32433789954[/C][/ROW]
[ROW][C]5[/C][C]9115.56[/C][C]11206.3643378995[/C][C]-2090.80433789954[/C][/ROW]
[ROW][C]6[/C][C]8805.95[/C][C]11206.3643378995[/C][C]-2400.41433789954[/C][/ROW]
[ROW][C]7[/C][C]12362.59[/C][C]11206.3643378995[/C][C]1156.22566210046[/C][/ROW]
[ROW][C]8[/C][C]9692.11[/C][C]11206.3643378995[/C][C]-1514.25433789954[/C][/ROW]
[ROW][C]9[/C][C]7445.25[/C][C]11206.3643378995[/C][C]-3761.11433789954[/C][/ROW]
[ROW][C]10[/C][C]10211.75[/C][C]11206.3643378995[/C][C]-994.614337899544[/C][/ROW]
[ROW][C]11[/C][C]18789.55[/C][C]11206.3643378995[/C][C]7583.18566210046[/C][/ROW]
[ROW][C]12[/C][C]11412.21[/C][C]11206.3643378995[/C][C]205.845662100455[/C][/ROW]
[ROW][C]13[/C][C]12557.85[/C][C]11206.3643378995[/C][C]1351.48566210046[/C][/ROW]
[ROW][C]14[/C][C]13530.69[/C][C]11206.3643378995[/C][C]2324.32566210046[/C][/ROW]
[ROW][C]15[/C][C]9906.74[/C][C]11206.3643378995[/C][C]-1299.62433789954[/C][/ROW]
[ROW][C]16[/C][C]9958.71[/C][C]11206.3643378995[/C][C]-1247.65433789954[/C][/ROW]
[ROW][C]17[/C][C]14131.19[/C][C]11206.3643378995[/C][C]2924.82566210046[/C][/ROW]
[ROW][C]18[/C][C]10637.98[/C][C]11206.3643378995[/C][C]-568.384337899544[/C][/ROW]
[ROW][C]19[/C][C]9859.07[/C][C]11206.3643378995[/C][C]-1347.29433789954[/C][/ROW]
[ROW][C]20[/C][C]14214.23[/C][C]11206.3643378995[/C][C]3007.86566210046[/C][/ROW]
[ROW][C]21[/C][C]11619.05[/C][C]11206.3643378995[/C][C]412.685662100455[/C][/ROW]
[ROW][C]22[/C][C]33644.96[/C][C]11206.3643378995[/C][C]22438.5956621005[/C][/ROW]
[ROW][C]23[/C][C]10267.25[/C][C]11206.3643378995[/C][C]-939.114337899544[/C][/ROW]
[ROW][C]24[/C][C]11146.33[/C][C]11206.3643378995[/C][C]-60.034337899544[/C][/ROW]
[ROW][C]25[/C][C]11351.47[/C][C]11206.3643378995[/C][C]145.105662100455[/C][/ROW]
[ROW][C]26[/C][C]18802.43[/C][C]11206.3643378995[/C][C]7596.06566210046[/C][/ROW]
[ROW][C]27[/C][C]5241[/C][C]11206.3643378995[/C][C]-5965.36433789954[/C][/ROW]
[ROW][C]28[/C][C]13003.97[/C][C]11206.3643378995[/C][C]1797.60566210046[/C][/ROW]
[ROW][C]29[/C][C]18688.75[/C][C]11206.3643378995[/C][C]7482.38566210046[/C][/ROW]
[ROW][C]30[/C][C]17945.88[/C][C]11206.3643378995[/C][C]6739.51566210045[/C][/ROW]
[ROW][C]31[/C][C]16213.12[/C][C]11206.3643378995[/C][C]5006.75566210046[/C][/ROW]
[ROW][C]32[/C][C]9462.53[/C][C]11206.3643378995[/C][C]-1743.83433789955[/C][/ROW]
[ROW][C]33[/C][C]12839.24[/C][C]11206.3643378995[/C][C]1632.87566210046[/C][/ROW]
[ROW][C]34[/C][C]6908.18[/C][C]11206.3643378995[/C][C]-4298.18433789954[/C][/ROW]
[ROW][C]35[/C][C]9877.23[/C][C]11206.3643378995[/C][C]-1329.13433789954[/C][/ROW]
[ROW][C]36[/C][C]10827.25[/C][C]11206.3643378995[/C][C]-379.114337899544[/C][/ROW]
[ROW][C]37[/C][C]7485.87[/C][C]11206.3643378995[/C][C]-3720.49433789954[/C][/ROW]
[ROW][C]38[/C][C]18584.87[/C][C]11206.3643378995[/C][C]7378.50566210046[/C][/ROW]
[ROW][C]39[/C][C]9530.23[/C][C]11206.3643378995[/C][C]-1676.13433789954[/C][/ROW]
[ROW][C]40[/C][C]18205.97[/C][C]11206.3643378995[/C][C]6999.60566210046[/C][/ROW]
[ROW][C]41[/C][C]6135.08[/C][C]11206.3643378995[/C][C]-5071.28433789954[/C][/ROW]
[ROW][C]42[/C][C]4551.83[/C][C]11206.3643378995[/C][C]-6654.53433789954[/C][/ROW]
[ROW][C]43[/C][C]7490.62[/C][C]11206.3643378995[/C][C]-3715.74433789954[/C][/ROW]
[ROW][C]44[/C][C]13299.3[/C][C]11206.3643378995[/C][C]2092.93566210046[/C][/ROW]
[ROW][C]45[/C][C]12630.98[/C][C]11206.3643378995[/C][C]1424.61566210046[/C][/ROW]
[ROW][C]46[/C][C]10972.35[/C][C]11206.3643378995[/C][C]-234.014337899544[/C][/ROW]
[ROW][C]47[/C][C]17193.02[/C][C]11206.3643378995[/C][C]5986.65566210046[/C][/ROW]
[ROW][C]48[/C][C]13588.91[/C][C]11206.3643378995[/C][C]2382.54566210046[/C][/ROW]
[ROW][C]49[/C][C]13512.24[/C][C]11206.3643378995[/C][C]2305.87566210046[/C][/ROW]
[ROW][C]50[/C][C]17165.86[/C][C]11206.3643378995[/C][C]5959.49566210046[/C][/ROW]
[ROW][C]51[/C][C]10009.17[/C][C]11206.3643378995[/C][C]-1197.19433789954[/C][/ROW]
[ROW][C]52[/C][C]6195.69[/C][C]11206.3643378995[/C][C]-5010.67433789954[/C][/ROW]
[ROW][C]53[/C][C]24073.53[/C][C]11206.3643378995[/C][C]12867.1656621005[/C][/ROW]
[ROW][C]54[/C][C]7659.05[/C][C]11206.3643378995[/C][C]-3547.31433789954[/C][/ROW]
[ROW][C]55[/C][C]13109.34[/C][C]11206.3643378995[/C][C]1902.97566210046[/C][/ROW]
[ROW][C]56[/C][C]13021.66[/C][C]11206.3643378995[/C][C]1815.29566210046[/C][/ROW]
[ROW][C]57[/C][C]6454.77[/C][C]11206.3643378995[/C][C]-4751.59433789954[/C][/ROW]
[ROW][C]58[/C][C]6618.49[/C][C]11206.3643378995[/C][C]-4587.87433789954[/C][/ROW]
[ROW][C]59[/C][C]11773.48[/C][C]11206.3643378995[/C][C]567.115662100456[/C][/ROW]
[ROW][C]60[/C][C]32946.36[/C][C]11206.3643378995[/C][C]21739.9956621005[/C][/ROW]
[ROW][C]61[/C][C]18620.94[/C][C]11206.3643378995[/C][C]7414.57566210046[/C][/ROW]
[ROW][C]62[/C][C]10339.72[/C][C]11206.3643378995[/C][C]-866.644337899543[/C][/ROW]
[ROW][C]63[/C][C]11123.14[/C][C]11206.3643378995[/C][C]-83.2243378995445[/C][/ROW]
[ROW][C]64[/C][C]10573.35[/C][C]11206.3643378995[/C][C]-633.014337899544[/C][/ROW]
[ROW][C]65[/C][C]12378.91[/C][C]11206.3643378995[/C][C]1172.54566210046[/C][/ROW]
[ROW][C]66[/C][C]1455.68[/C][C]11206.3643378995[/C][C]-9750.68433789954[/C][/ROW]
[ROW][C]67[/C][C]11423.97[/C][C]11206.3643378995[/C][C]217.605662100455[/C][/ROW]
[ROW][C]68[/C][C]8271.05[/C][C]11206.3643378995[/C][C]-2935.31433789954[/C][/ROW]
[ROW][C]69[/C][C]12710.27[/C][C]11206.3643378995[/C][C]1503.90566210046[/C][/ROW]
[ROW][C]70[/C][C]11346.25[/C][C]11206.3643378995[/C][C]139.885662100456[/C][/ROW]
[ROW][C]71[/C][C]14125.54[/C][C]11206.3643378995[/C][C]2919.17566210046[/C][/ROW]
[ROW][C]72[/C][C]9564.64[/C][C]11206.3643378995[/C][C]-1641.72433789954[/C][/ROW]
[ROW][C]73[/C][C]16131.85[/C][C]11206.3643378995[/C][C]4925.48566210046[/C][/ROW]
[ROW][C]74[/C][C]6925.63[/C][C]11206.3643378995[/C][C]-4280.73433789954[/C][/ROW]
[ROW][C]75[/C][C]6136.46[/C][C]11206.3643378995[/C][C]-5069.90433789954[/C][/ROW]
[ROW][C]76[/C][C]7767.91[/C][C]11206.3643378995[/C][C]-3438.45433789954[/C][/ROW]
[ROW][C]77[/C][C]13043.98[/C][C]11206.3643378995[/C][C]1837.61566210046[/C][/ROW]
[ROW][C]78[/C][C]12884.31[/C][C]11206.3643378995[/C][C]1677.94566210046[/C][/ROW]
[ROW][C]79[/C][C]18401.78[/C][C]11206.3643378995[/C][C]7195.41566210045[/C][/ROW]
[ROW][C]80[/C][C]17015.07[/C][C]11206.3643378995[/C][C]5808.70566210046[/C][/ROW]
[ROW][C]81[/C][C]9622.88[/C][C]11206.3643378995[/C][C]-1583.48433789954[/C][/ROW]
[ROW][C]82[/C][C]8248.46[/C][C]11206.3643378995[/C][C]-2957.90433789954[/C][/ROW]
[ROW][C]83[/C][C]11913.11[/C][C]11206.3643378995[/C][C]706.745662100457[/C][/ROW]
[ROW][C]84[/C][C]11662.12[/C][C]11206.3643378995[/C][C]455.755662100455[/C][/ROW]
[ROW][C]85[/C][C]25701.67[/C][C]11206.3643378995[/C][C]14495.3056621005[/C][/ROW]
[ROW][C]86[/C][C]7601.09[/C][C]11206.3643378995[/C][C]-3605.27433789954[/C][/ROW]
[ROW][C]87[/C][C]11351.18[/C][C]11206.3643378995[/C][C]144.815662100456[/C][/ROW]
[ROW][C]88[/C][C]12510.82[/C][C]11206.3643378995[/C][C]1304.45566210046[/C][/ROW]
[ROW][C]89[/C][C]22073.74[/C][C]11206.3643378995[/C][C]10867.3756621005[/C][/ROW]
[ROW][C]90[/C][C]10929.1[/C][C]11206.3643378995[/C][C]-277.264337899544[/C][/ROW]
[ROW][C]91[/C][C]11205.42[/C][C]11206.3643378995[/C][C]-0.944337899543825[/C][/ROW]
[ROW][C]92[/C][C]16889.56[/C][C]11206.3643378995[/C][C]5683.19566210045[/C][/ROW]
[ROW][C]93[/C][C]11089.44[/C][C]11206.3643378995[/C][C]-116.924337899543[/C][/ROW]
[ROW][C]94[/C][C]12054.64[/C][C]11206.3643378995[/C][C]848.275662100456[/C][/ROW]
[ROW][C]95[/C][C]19061.32[/C][C]11206.3643378995[/C][C]7854.95566210046[/C][/ROW]
[ROW][C]96[/C][C]13629.67[/C][C]11206.3643378995[/C][C]2423.30566210046[/C][/ROW]
[ROW][C]97[/C][C]7570.85[/C][C]11206.3643378995[/C][C]-3635.51433789954[/C][/ROW]
[ROW][C]98[/C][C]11334.08[/C][C]11206.3643378995[/C][C]127.715662100456[/C][/ROW]
[ROW][C]99[/C][C]12604.63[/C][C]11206.3643378995[/C][C]1398.26566210046[/C][/ROW]
[ROW][C]100[/C][C]11378.53[/C][C]11206.3643378995[/C][C]172.165662100455[/C][/ROW]
[ROW][C]101[/C][C]7912.75[/C][C]11206.3643378995[/C][C]-3293.61433789954[/C][/ROW]
[ROW][C]102[/C][C]11526.61[/C][C]11206.3643378995[/C][C]320.245662100457[/C][/ROW]
[ROW][C]103[/C][C]9656.56[/C][C]11206.3643378995[/C][C]-1549.80433789954[/C][/ROW]
[ROW][C]104[/C][C]18940.15[/C][C]11206.3643378995[/C][C]7733.78566210046[/C][/ROW]
[ROW][C]105[/C][C]6899.68[/C][C]11206.3643378995[/C][C]-4306.68433789954[/C][/ROW]
[ROW][C]106[/C][C]9994.28[/C][C]11206.3643378995[/C][C]-1212.08433789954[/C][/ROW]
[ROW][C]107[/C][C]8914.54[/C][C]11206.3643378995[/C][C]-2291.82433789954[/C][/ROW]
[ROW][C]108[/C][C]6238.01[/C][C]11206.3643378995[/C][C]-4968.35433789954[/C][/ROW]
[ROW][C]109[/C][C]12121.61[/C][C]11206.3643378995[/C][C]915.245662100457[/C][/ROW]
[ROW][C]110[/C][C]16230.96[/C][C]11206.3643378995[/C][C]5024.59566210046[/C][/ROW]
[ROW][C]111[/C][C]10035.41[/C][C]11206.3643378995[/C][C]-1170.95433789954[/C][/ROW]
[ROW][C]112[/C][C]8083.75[/C][C]11206.3643378995[/C][C]-3122.61433789954[/C][/ROW]
[ROW][C]113[/C][C]9688.36[/C][C]11206.3643378995[/C][C]-1518.00433789954[/C][/ROW]
[ROW][C]114[/C][C]13803.76[/C][C]11206.3643378995[/C][C]2597.39566210046[/C][/ROW]
[ROW][C]115[/C][C]18126.89[/C][C]11206.3643378995[/C][C]6920.52566210046[/C][/ROW]
[ROW][C]116[/C][C]10129.26[/C][C]11206.3643378995[/C][C]-1077.10433789954[/C][/ROW]
[ROW][C]117[/C][C]13696.76[/C][C]11206.3643378995[/C][C]2490.39566210046[/C][/ROW]
[ROW][C]118[/C][C]7444.32[/C][C]11206.3643378995[/C][C]-3762.04433789954[/C][/ROW]
[ROW][C]119[/C][C]14591.69[/C][C]11206.3643378995[/C][C]3385.32566210045[/C][/ROW]
[ROW][C]120[/C][C]8870.34[/C][C]11206.3643378995[/C][C]-2336.02433789954[/C][/ROW]
[ROW][C]121[/C][C]9752.65[/C][C]11206.3643378995[/C][C]-1453.71433789954[/C][/ROW]
[ROW][C]122[/C][C]6179.84[/C][C]11206.3643378995[/C][C]-5026.52433789954[/C][/ROW]
[ROW][C]123[/C][C]7683.23[/C][C]11206.3643378995[/C][C]-3523.13433789954[/C][/ROW]
[ROW][C]124[/C][C]10226.02[/C][C]11206.3643378995[/C][C]-980.344337899543[/C][/ROW]
[ROW][C]125[/C][C]7141.96[/C][C]11206.3643378995[/C][C]-4064.40433789954[/C][/ROW]
[ROW][C]126[/C][C]17394.27[/C][C]11206.3643378995[/C][C]6187.90566210046[/C][/ROW]
[ROW][C]127[/C][C]14159.91[/C][C]11206.3643378995[/C][C]2953.54566210046[/C][/ROW]
[ROW][C]128[/C][C]8975.82[/C][C]11206.3643378995[/C][C]-2230.54433789954[/C][/ROW]
[ROW][C]129[/C][C]9635.52[/C][C]11206.3643378995[/C][C]-1570.84433789954[/C][/ROW]
[ROW][C]130[/C][C]10485.31[/C][C]11206.3643378995[/C][C]-721.054337899543[/C][/ROW]
[ROW][C]131[/C][C]9096.53[/C][C]11206.3643378995[/C][C]-2109.83433789955[/C][/ROW]
[ROW][C]132[/C][C]13043.26[/C][C]11206.3643378995[/C][C]1836.89566210046[/C][/ROW]
[ROW][C]133[/C][C]17338.59[/C][C]11206.3643378995[/C][C]6132.22566210046[/C][/ROW]
[ROW][C]134[/C][C]8228.39[/C][C]11206.3643378995[/C][C]-2977.97433789954[/C][/ROW]
[ROW][C]135[/C][C]7967.82[/C][C]11206.3643378995[/C][C]-3238.54433789954[/C][/ROW]
[ROW][C]136[/C][C]11613.87[/C][C]11206.3643378995[/C][C]407.505662100455[/C][/ROW]
[ROW][C]137[/C][C]11392.94[/C][C]11206.3643378995[/C][C]186.575662100457[/C][/ROW]
[ROW][C]138[/C][C]14565.62[/C][C]11206.3643378995[/C][C]3359.25566210046[/C][/ROW]
[ROW][C]139[/C][C]8315.49[/C][C]11206.3643378995[/C][C]-2890.87433789954[/C][/ROW]
[ROW][C]140[/C][C]15474.53[/C][C]11206.3643378995[/C][C]4268.16566210045[/C][/ROW]
[ROW][C]141[/C][C]15740.78[/C][C]11206.3643378995[/C][C]4534.41566210046[/C][/ROW]
[ROW][C]142[/C][C]8821.3[/C][C]11206.3643378995[/C][C]-2385.06433789954[/C][/ROW]
[ROW][C]143[/C][C]9649.98[/C][C]11206.3643378995[/C][C]-1556.38433789954[/C][/ROW]
[ROW][C]144[/C][C]12950.09[/C][C]11206.3643378995[/C][C]1743.72566210046[/C][/ROW]
[ROW][C]145[/C][C]11025.41[/C][C]11206.3643378995[/C][C]-180.954337899544[/C][/ROW]
[ROW][C]146[/C][C]9762.97[/C][C]11206.3643378995[/C][C]-1443.39433789954[/C][/ROW]
[ROW][C]147[/C][C]10007.32[/C][C]11206.3643378995[/C][C]-1199.04433789954[/C][/ROW]
[ROW][C]148[/C][C]14456.69[/C][C]11206.3643378995[/C][C]3250.32566210046[/C][/ROW]
[ROW][C]149[/C][C]312.32[/C][C]11206.3643378995[/C][C]-10894.0443378995[/C][/ROW]
[ROW][C]150[/C][C]8000.23[/C][C]11206.3643378995[/C][C]-3206.13433789954[/C][/ROW]
[ROW][C]151[/C][C]12871.94[/C][C]11206.3643378995[/C][C]1665.57566210046[/C][/ROW]
[ROW][C]152[/C][C]12670.05[/C][C]11206.3643378995[/C][C]1463.68566210046[/C][/ROW]
[ROW][C]153[/C][C]10142.82[/C][C]11206.3643378995[/C][C]-1063.54433789954[/C][/ROW]
[ROW][C]154[/C][C]10443.82[/C][C]11206.3643378995[/C][C]-762.544337899544[/C][/ROW]
[ROW][C]155[/C][C]10070.77[/C][C]11206.3643378995[/C][C]-1135.59433789954[/C][/ROW]
[ROW][C]156[/C][C]12364.37[/C][C]11206.3643378995[/C][C]1158.00566210046[/C][/ROW]
[ROW][C]157[/C][C]7685.11[/C][C]11206.3643378995[/C][C]-3521.25433789954[/C][/ROW]
[ROW][C]158[/C][C]16068.91[/C][C]11206.3643378995[/C][C]4862.54566210046[/C][/ROW]
[ROW][C]159[/C][C]4260.96[/C][C]11206.3643378995[/C][C]-6945.40433789954[/C][/ROW]
[ROW][C]160[/C][C]4263.65[/C][C]11206.3643378995[/C][C]-6942.71433789954[/C][/ROW]
[ROW][C]161[/C][C]8652.82[/C][C]11206.3643378995[/C][C]-2553.54433789954[/C][/ROW]
[ROW][C]162[/C][C]9808.16[/C][C]11206.3643378995[/C][C]-1398.20433789954[/C][/ROW]
[ROW][C]163[/C][C]6106.86[/C][C]11206.3643378995[/C][C]-5099.50433789954[/C][/ROW]
[ROW][C]164[/C][C]9756.57[/C][C]11206.3643378995[/C][C]-1449.79433789954[/C][/ROW]
[ROW][C]165[/C][C]17509.51[/C][C]11206.3643378995[/C][C]6303.14566210046[/C][/ROW]
[ROW][C]166[/C][C]7451.38[/C][C]11206.3643378995[/C][C]-3754.98433789954[/C][/ROW]
[ROW][C]167[/C][C]7559.88[/C][C]11206.3643378995[/C][C]-3646.48433789954[/C][/ROW]
[ROW][C]168[/C][C]9480[/C][C]11206.3643378995[/C][C]-1726.36433789954[/C][/ROW]
[ROW][C]169[/C][C]9447.65[/C][C]11206.3643378995[/C][C]-1758.71433789954[/C][/ROW]
[ROW][C]170[/C][C]17281.48[/C][C]11206.3643378995[/C][C]6075.11566210046[/C][/ROW]
[ROW][C]171[/C][C]10012.88[/C][C]11206.3643378995[/C][C]-1193.48433789954[/C][/ROW]
[ROW][C]172[/C][C]14942.56[/C][C]11206.3643378995[/C][C]3736.19566210046[/C][/ROW]
[ROW][C]173[/C][C]5679.41[/C][C]11206.3643378995[/C][C]-5526.95433789954[/C][/ROW]
[ROW][C]174[/C][C]10118.75[/C][C]11206.3643378995[/C][C]-1087.61433789954[/C][/ROW]
[ROW][C]175[/C][C]9826.74[/C][C]11206.3643378995[/C][C]-1379.62433789954[/C][/ROW]
[ROW][C]176[/C][C]11758.49[/C][C]11206.3643378995[/C][C]552.125662100456[/C][/ROW]
[ROW][C]177[/C][C]9503.11[/C][C]11206.3643378995[/C][C]-1703.25433789954[/C][/ROW]
[ROW][C]178[/C][C]3928.27[/C][C]11206.3643378995[/C][C]-7278.09433789954[/C][/ROW]
[ROW][C]179[/C][C]9389.23[/C][C]11206.3643378995[/C][C]-1817.13433789954[/C][/ROW]
[ROW][C]180[/C][C]20683.24[/C][C]11206.3643378995[/C][C]9476.87566210045[/C][/ROW]
[ROW][C]181[/C][C]6783.19[/C][C]11206.3643378995[/C][C]-4423.17433789954[/C][/ROW]
[ROW][C]182[/C][C]2078.3[/C][C]11206.3643378995[/C][C]-9128.06433789954[/C][/ROW]
[ROW][C]183[/C][C]8665.67[/C][C]11206.3643378995[/C][C]-2540.69433789954[/C][/ROW]
[ROW][C]184[/C][C]14167.73[/C][C]11206.3643378995[/C][C]2961.36566210046[/C][/ROW]
[ROW][C]185[/C][C]11099.22[/C][C]11206.3643378995[/C][C]-107.144337899543[/C][/ROW]
[ROW][C]186[/C][C]12040.95[/C][C]11206.3643378995[/C][C]834.585662100457[/C][/ROW]
[ROW][C]187[/C][C]7242.24[/C][C]11206.3643378995[/C][C]-3964.12433789954[/C][/ROW]
[ROW][C]188[/C][C]19323.43[/C][C]11206.3643378995[/C][C]8117.06566210046[/C][/ROW]
[ROW][C]189[/C][C]4380.05[/C][C]11206.3643378995[/C][C]-6826.31433789954[/C][/ROW]
[ROW][C]190[/C][C]5643.24[/C][C]11206.3643378995[/C][C]-5563.12433789954[/C][/ROW]
[ROW][C]191[/C][C]3626.59[/C][C]11206.3643378995[/C][C]-7579.77433789954[/C][/ROW]
[ROW][C]192[/C][C]14639.78[/C][C]11206.3643378995[/C][C]3433.41566210045[/C][/ROW]
[ROW][C]193[/C][C]906.04[/C][C]11206.3643378995[/C][C]-10300.3243378995[/C][/ROW]
[ROW][C]194[/C][C]14625.77[/C][C]11206.3643378995[/C][C]3419.40566210046[/C][/ROW]
[ROW][C]195[/C][C]6894.78[/C][C]11206.3643378995[/C][C]-4311.58433789954[/C][/ROW]
[ROW][C]196[/C][C]12805.95[/C][C]11206.3643378995[/C][C]1599.58566210046[/C][/ROW]
[ROW][C]197[/C][C]7642.43[/C][C]11206.3643378995[/C][C]-3563.93433789954[/C][/ROW]
[ROW][C]198[/C][C]8562.89[/C][C]11206.3643378995[/C][C]-2643.47433789954[/C][/ROW]
[ROW][C]199[/C][C]8514.39[/C][C]11206.3643378995[/C][C]-2691.97433789954[/C][/ROW]
[ROW][C]200[/C][C]19226.29[/C][C]11206.3643378995[/C][C]8019.92566210046[/C][/ROW]
[ROW][C]201[/C][C]5641.34[/C][C]11206.3643378995[/C][C]-5565.02433789954[/C][/ROW]
[ROW][C]202[/C][C]8592.5[/C][C]11206.3643378995[/C][C]-2613.86433789954[/C][/ROW]
[ROW][C]203[/C][C]8005.46[/C][C]11206.3643378995[/C][C]-3200.90433789954[/C][/ROW]
[ROW][C]204[/C][C]15285.88[/C][C]11206.3643378995[/C][C]4079.51566210046[/C][/ROW]
[ROW][C]205[/C][C]8228.67[/C][C]11206.3643378995[/C][C]-2977.69433789954[/C][/ROW]
[ROW][C]206[/C][C]7955.02[/C][C]11206.3643378995[/C][C]-3251.34433789954[/C][/ROW]
[ROW][C]207[/C][C]7690.87[/C][C]11206.3643378995[/C][C]-3515.49433789954[/C][/ROW]
[ROW][C]208[/C][C]8254.53[/C][C]11206.3643378995[/C][C]-2951.83433789955[/C][/ROW]
[ROW][C]209[/C][C]15101.56[/C][C]11206.3643378995[/C][C]3895.19566210046[/C][/ROW]
[ROW][C]210[/C][C]13953.02[/C][C]11206.3643378995[/C][C]2746.65566210046[/C][/ROW]
[ROW][C]211[/C][C]13104.85[/C][C]11206.3643378995[/C][C]1898.48566210046[/C][/ROW]
[ROW][C]212[/C][C]5915.81[/C][C]11206.3643378995[/C][C]-5290.55433789954[/C][/ROW]
[ROW][C]213[/C][C]5504.23[/C][C]11206.3643378995[/C][C]-5702.13433789954[/C][/ROW]
[ROW][C]214[/C][C]10692.69[/C][C]11206.3643378995[/C][C]-513.674337899545[/C][/ROW]
[ROW][C]215[/C][C]9730.57[/C][C]11206.3643378995[/C][C]-1475.79433789954[/C][/ROW]
[ROW][C]216[/C][C]12431.05[/C][C]11206.3643378995[/C][C]1224.68566210046[/C][/ROW]
[ROW][C]217[/C][C]10350.38[/C][C]11206.3643378995[/C][C]-855.984337899543[/C][/ROW]
[ROW][C]218[/C][C]8117.73[/C][C]11206.3643378995[/C][C]-3088.63433789954[/C][/ROW]
[ROW][C]219[/C][C]7404.66[/C][C]11206.3643378995[/C][C]-3801.70433789954[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=166621&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=166621&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
112560.8311206.36433789951354.46566210046
26746.3411206.3643378995-4460.02433789954
311056.5911206.3643378995-149.774337899544
49605.0411206.3643378995-1601.32433789954
59115.5611206.3643378995-2090.80433789954
68805.9511206.3643378995-2400.41433789954
712362.5911206.36433789951156.22566210046
89692.1111206.3643378995-1514.25433789954
97445.2511206.3643378995-3761.11433789954
1010211.7511206.3643378995-994.614337899544
1118789.5511206.36433789957583.18566210046
1211412.2111206.3643378995205.845662100455
1312557.8511206.36433789951351.48566210046
1413530.6911206.36433789952324.32566210046
159906.7411206.3643378995-1299.62433789954
169958.7111206.3643378995-1247.65433789954
1714131.1911206.36433789952924.82566210046
1810637.9811206.3643378995-568.384337899544
199859.0711206.3643378995-1347.29433789954
2014214.2311206.36433789953007.86566210046
2111619.0511206.3643378995412.685662100455
2233644.9611206.364337899522438.5956621005
2310267.2511206.3643378995-939.114337899544
2411146.3311206.3643378995-60.034337899544
2511351.4711206.3643378995145.105662100455
2618802.4311206.36433789957596.06566210046
27524111206.3643378995-5965.36433789954
2813003.9711206.36433789951797.60566210046
2918688.7511206.36433789957482.38566210046
3017945.8811206.36433789956739.51566210045
3116213.1211206.36433789955006.75566210046
329462.5311206.3643378995-1743.83433789955
3312839.2411206.36433789951632.87566210046
346908.1811206.3643378995-4298.18433789954
359877.2311206.3643378995-1329.13433789954
3610827.2511206.3643378995-379.114337899544
377485.8711206.3643378995-3720.49433789954
3818584.8711206.36433789957378.50566210046
399530.2311206.3643378995-1676.13433789954
4018205.9711206.36433789956999.60566210046
416135.0811206.3643378995-5071.28433789954
424551.8311206.3643378995-6654.53433789954
437490.6211206.3643378995-3715.74433789954
4413299.311206.36433789952092.93566210046
4512630.9811206.36433789951424.61566210046
4610972.3511206.3643378995-234.014337899544
4717193.0211206.36433789955986.65566210046
4813588.9111206.36433789952382.54566210046
4913512.2411206.36433789952305.87566210046
5017165.8611206.36433789955959.49566210046
5110009.1711206.3643378995-1197.19433789954
526195.6911206.3643378995-5010.67433789954
5324073.5311206.364337899512867.1656621005
547659.0511206.3643378995-3547.31433789954
5513109.3411206.36433789951902.97566210046
5613021.6611206.36433789951815.29566210046
576454.7711206.3643378995-4751.59433789954
586618.4911206.3643378995-4587.87433789954
5911773.4811206.3643378995567.115662100456
6032946.3611206.364337899521739.9956621005
6118620.9411206.36433789957414.57566210046
6210339.7211206.3643378995-866.644337899543
6311123.1411206.3643378995-83.2243378995445
6410573.3511206.3643378995-633.014337899544
6512378.9111206.36433789951172.54566210046
661455.6811206.3643378995-9750.68433789954
6711423.9711206.3643378995217.605662100455
688271.0511206.3643378995-2935.31433789954
6912710.2711206.36433789951503.90566210046
7011346.2511206.3643378995139.885662100456
7114125.5411206.36433789952919.17566210046
729564.6411206.3643378995-1641.72433789954
7316131.8511206.36433789954925.48566210046
746925.6311206.3643378995-4280.73433789954
756136.4611206.3643378995-5069.90433789954
767767.9111206.3643378995-3438.45433789954
7713043.9811206.36433789951837.61566210046
7812884.3111206.36433789951677.94566210046
7918401.7811206.36433789957195.41566210045
8017015.0711206.36433789955808.70566210046
819622.8811206.3643378995-1583.48433789954
828248.4611206.3643378995-2957.90433789954
8311913.1111206.3643378995706.745662100457
8411662.1211206.3643378995455.755662100455
8525701.6711206.364337899514495.3056621005
867601.0911206.3643378995-3605.27433789954
8711351.1811206.3643378995144.815662100456
8812510.8211206.36433789951304.45566210046
8922073.7411206.364337899510867.3756621005
9010929.111206.3643378995-277.264337899544
9111205.4211206.3643378995-0.944337899543825
9216889.5611206.36433789955683.19566210045
9311089.4411206.3643378995-116.924337899543
9412054.6411206.3643378995848.275662100456
9519061.3211206.36433789957854.95566210046
9613629.6711206.36433789952423.30566210046
977570.8511206.3643378995-3635.51433789954
9811334.0811206.3643378995127.715662100456
9912604.6311206.36433789951398.26566210046
10011378.5311206.3643378995172.165662100455
1017912.7511206.3643378995-3293.61433789954
10211526.6111206.3643378995320.245662100457
1039656.5611206.3643378995-1549.80433789954
10418940.1511206.36433789957733.78566210046
1056899.6811206.3643378995-4306.68433789954
1069994.2811206.3643378995-1212.08433789954
1078914.5411206.3643378995-2291.82433789954
1086238.0111206.3643378995-4968.35433789954
10912121.6111206.3643378995915.245662100457
11016230.9611206.36433789955024.59566210046
11110035.4111206.3643378995-1170.95433789954
1128083.7511206.3643378995-3122.61433789954
1139688.3611206.3643378995-1518.00433789954
11413803.7611206.36433789952597.39566210046
11518126.8911206.36433789956920.52566210046
11610129.2611206.3643378995-1077.10433789954
11713696.7611206.36433789952490.39566210046
1187444.3211206.3643378995-3762.04433789954
11914591.6911206.36433789953385.32566210045
1208870.3411206.3643378995-2336.02433789954
1219752.6511206.3643378995-1453.71433789954
1226179.8411206.3643378995-5026.52433789954
1237683.2311206.3643378995-3523.13433789954
12410226.0211206.3643378995-980.344337899543
1257141.9611206.3643378995-4064.40433789954
12617394.2711206.36433789956187.90566210046
12714159.9111206.36433789952953.54566210046
1288975.8211206.3643378995-2230.54433789954
1299635.5211206.3643378995-1570.84433789954
13010485.3111206.3643378995-721.054337899543
1319096.5311206.3643378995-2109.83433789955
13213043.2611206.36433789951836.89566210046
13317338.5911206.36433789956132.22566210046
1348228.3911206.3643378995-2977.97433789954
1357967.8211206.3643378995-3238.54433789954
13611613.8711206.3643378995407.505662100455
13711392.9411206.3643378995186.575662100457
13814565.6211206.36433789953359.25566210046
1398315.4911206.3643378995-2890.87433789954
14015474.5311206.36433789954268.16566210045
14115740.7811206.36433789954534.41566210046
1428821.311206.3643378995-2385.06433789954
1439649.9811206.3643378995-1556.38433789954
14412950.0911206.36433789951743.72566210046
14511025.4111206.3643378995-180.954337899544
1469762.9711206.3643378995-1443.39433789954
14710007.3211206.3643378995-1199.04433789954
14814456.6911206.36433789953250.32566210046
149312.3211206.3643378995-10894.0443378995
1508000.2311206.3643378995-3206.13433789954
15112871.9411206.36433789951665.57566210046
15212670.0511206.36433789951463.68566210046
15310142.8211206.3643378995-1063.54433789954
15410443.8211206.3643378995-762.544337899544
15510070.7711206.3643378995-1135.59433789954
15612364.3711206.36433789951158.00566210046
1577685.1111206.3643378995-3521.25433789954
15816068.9111206.36433789954862.54566210046
1594260.9611206.3643378995-6945.40433789954
1604263.6511206.3643378995-6942.71433789954
1618652.8211206.3643378995-2553.54433789954
1629808.1611206.3643378995-1398.20433789954
1636106.8611206.3643378995-5099.50433789954
1649756.5711206.3643378995-1449.79433789954
16517509.5111206.36433789956303.14566210046
1667451.3811206.3643378995-3754.98433789954
1677559.8811206.3643378995-3646.48433789954
168948011206.3643378995-1726.36433789954
1699447.6511206.3643378995-1758.71433789954
17017281.4811206.36433789956075.11566210046
17110012.8811206.3643378995-1193.48433789954
17214942.5611206.36433789953736.19566210046
1735679.4111206.3643378995-5526.95433789954
17410118.7511206.3643378995-1087.61433789954
1759826.7411206.3643378995-1379.62433789954
17611758.4911206.3643378995552.125662100456
1779503.1111206.3643378995-1703.25433789954
1783928.2711206.3643378995-7278.09433789954
1799389.2311206.3643378995-1817.13433789954
18020683.2411206.36433789959476.87566210045
1816783.1911206.3643378995-4423.17433789954
1822078.311206.3643378995-9128.06433789954
1838665.6711206.3643378995-2540.69433789954
18414167.7311206.36433789952961.36566210046
18511099.2211206.3643378995-107.144337899543
18612040.9511206.3643378995834.585662100457
1877242.2411206.3643378995-3964.12433789954
18819323.4311206.36433789958117.06566210046
1894380.0511206.3643378995-6826.31433789954
1905643.2411206.3643378995-5563.12433789954
1913626.5911206.3643378995-7579.77433789954
19214639.7811206.36433789953433.41566210045
193906.0411206.3643378995-10300.3243378995
19414625.7711206.36433789953419.40566210046
1956894.7811206.3643378995-4311.58433789954
19612805.9511206.36433789951599.58566210046
1977642.4311206.3643378995-3563.93433789954
1988562.8911206.3643378995-2643.47433789954
1998514.3911206.3643378995-2691.97433789954
20019226.2911206.36433789958019.92566210046
2015641.3411206.3643378995-5565.02433789954
2028592.511206.3643378995-2613.86433789954
2038005.4611206.3643378995-3200.90433789954
20415285.8811206.36433789954079.51566210046
2058228.6711206.3643378995-2977.69433789954
2067955.0211206.3643378995-3251.34433789954
2077690.8711206.3643378995-3515.49433789954
2088254.5311206.3643378995-2951.83433789955
20915101.5611206.36433789953895.19566210046
21013953.0211206.36433789952746.65566210046
21113104.8511206.36433789951898.48566210046
2125915.8111206.3643378995-5290.55433789954
2135504.2311206.3643378995-5702.13433789954
21410692.6911206.3643378995-513.674337899545
2159730.5711206.3643378995-1475.79433789954
21612431.0511206.36433789951224.68566210046
21710350.3811206.3643378995-855.984337899543
2188117.7311206.3643378995-3088.63433789954
2197404.6611206.3643378995-3801.70433789954



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