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 computationTue, 01 May 2012 17:32:30 -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/01/t1335907973g0fq08vlsyvs3sg.htm/, Retrieved Sat, 04 May 2024 09:39:50 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=165838, Retrieved Sat, 04 May 2024 09:39:50 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact57
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [] [2012-05-01 21:32:30] [0cc546ba844126e6dd0cea8c652301ec] [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'Gertrude Mary Cox' @ cox.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 4 seconds \tabularnewline
R Server & 'Gertrude Mary Cox' @ cox.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=165838&T=0

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

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

As an alternative you can also use a QR Code:  

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

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







Goodness of Fit
Correlation0.4267
R-squared0.1821
RMSE3369.2787

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

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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165838&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.4267
R-squared0.1821
RMSE3369.2787







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
112999.889249.935147928993749.94485207101
211850.3311027.2140196078823.115980392158
310206.059249.93514792899956.114852071007
48807.349249.93514792899-442.595147928992
59098.89249.93514792899-151.135147928993
68801.089249.93514792899-448.855147928993
77366.23666666679249.93514792899-1883.69848126229
87322.39666666679249.93514792899-1927.53848126229
97790.859249.93514792899-1459.08514792899
1010365.69333333339249.935147928991115.75818540431
119269.429249.9351479289919.4848520710075
1213775.449249.935147928994525.50485207101
138914.539249.93514792899-335.405147928992
1410481.3611027.2140196078-545.854019607841
1512143.469249.935147928992893.52485207101
1613140.569249.935147928993890.62485207101
1713116.69249.935147928993866.66485207101
1810017.999249.93514792899768.054852071007
1913943.589249.935147928994693.64485207101
2015979.329249.935147928996729.38485207101
2113148.729249.935147928993898.78485207101
2212586.2511027.21401960781559.03598039216
2310571.643333333311027.2140196078-455.570686274543
249113.659249.93514792899-136.285147928993
259459.96333333339249.93514792899210.028185404308
269283.799249.9351479289933.8548520710083
2712962.269249.935147928993712.32485207101
2812195.049249.935147928992945.10485207101
2911199.99249.935147928991949.96485207101
3013065.019249.935147928993815.07485207101
319125.10333333339249.93514792899-124.831814595693
3213099.819249.935147928993849.87485207101
3312544.589249.935147928993294.64485207101
348530.769249.93514792899-719.175147928992
3512707.79249.935147928993457.76485207101
363369.0911027.2140196078-7658.12401960784
378611.979249.93514792899-637.965147928991
388556.149249.93514792899-693.795147928993
3911010.329249.935147928991760.38485207101
409455.219249.93514792899205.274852071007
419068.059249.93514792899-181.885147928993
4214218.259249.935147928994968.31485207101
439548.629249.93514792899298.684852071006
449731.549249.93514792899481.604852071008
4512258.499249.935147928993008.55485207101
468426.299249.93514792899-823.645147928992
476566.429249.93514792899-2683.51514792899
4810124.619249.93514792899874.674852071008
498364.279249.93514792899-885.665147928992
509150.969249.93514792899-98.9751479289935
519927.429249.93514792899677.484852071007
528705.1911027.2140196078-2322.02401960784
538853.419249.93514792899-396.525147928993
54112249249.935147928991974.06485207101
555123.19249.93514792899-4126.83514792899
565970.4411027.2140196078-5056.77401960784
5710441.139249.935147928991191.19485207101
587707.269249.93514792899-1542.67514792899
5910489.069249.935147928991239.12485207101
6012247.679249.935147928992997.73485207101
616713.049249.93514792899-2536.89514792899
629370.70333333339249.93514792899120.768185404308
638282.819249.93514792899-967.125147928993
648756.09333333339249.93514792899-493.841814595693
6512624.329249.935147928993374.38485207101
668866.34333333339249.93514792899-383.591814595693
676063.619249.93514792899-3186.32514792899
687018.639249.93514792899-2231.30514792899
695517.959249.93514792899-3731.98514792899
709701.819249.93514792899451.874852071007
719810.069249.93514792899560.124852071007
727446.079249.93514792899-1803.86514792899
737954.659249.93514792899-1295.28514792899
746300.79249.93514792899-2949.23514792899
757142.289249.93514792899-2107.65514792899
769202.329249.93514792899-47.6151479289929
775867.799249.93514792899-3382.14514792899
784481.1311027.2140196078-6546.08401960784
7913707.57333333339249.935147928994457.63818540431
809927.519249.93514792899677.574852071008
818741.73666666679249.93514792899-508.198481262292
827095.669249.93514792899-2154.27514792899
839186.739249.93514792899-63.205147928993
848958.799249.93514792899-291.145147928992
855701.569249.93514792899-3548.37514792899
866940.119249.93514792899-2309.82514792899
878452.869249.93514792899-797.075147928992
8813315.12333333339249.935147928994065.18818540431
896301.379249.93514792899-2948.56514792899
905614.499249.93514792899-3635.44514792899
9110239.7811027.2140196078-787.434019607843
927072.19249.93514792899-2177.83514792899
935381.779249.93514792899-3868.16514792899
9410010.069249.93514792899760.124852071007
954844.839249.93514792899-4405.10514792899
967982.69249.93514792899-1267.33514792899
978956.81333333339249.93514792899-293.121814595694
988350.29249.93514792899-899.735147928992
9913201.799249.935147928993951.85485207101
1005350.289249.93514792899-3899.65514792899
1019404.769249.93514792899154.824852071008
1026740.529249.93514792899-2509.41514792899
10311055.219249.935147928991805.27485207101
10410406.849249.935147928991156.90485207101
1056996.919249.93514792899-2253.02514792899
1066239.879249.93514792899-3010.06514792899
1076184.589249.93514792899-3065.35514792899
1087473.55666666679249.93514792899-1776.37848126229
10911568.249249.935147928992318.30485207101
1108569.54666666679249.93514792899-680.388481262293
11111914.489249.935147928992664.54485207101
1126086.449249.93514792899-3163.49514792899
11312749.669249.935147928993499.72485207101
1145384.019249.93514792899-3865.92514792899
11511344.79249.935147928992094.76485207101
1167137.8215455.136875-8317.316875
1177297.289249.93514792899-1952.65514792899
1187294.089249.93514792899-1955.85514792899
1199876.439249.93514792899626.494852071008
1208047.7411027.2140196078-2979.47401960784
1219801.269249.93514792899551.324852071008
12211924.2415455.136875-3530.896875
12313083.549249.935147928993833.60485207101
1248829.97666666679249.93514792899-419.958481262292
1256959.319249.93514792899-2290.62514792899
1269545.519249.93514792899295.574852071008
1278963.52333333339249.93514792899-286.411814595693
1284868.329249.93514792899-4381.61514792899
1299288.229249.9351479289938.2848520710086
1308351.329249.93514792899-898.615147928993
1318579.569249.93514792899-670.375147928993
13213804.419249.935147928994554.47485207101
1337377.956666666711027.2140196078-3649.25735294114
1347727.83666666679249.93514792899-1522.09848126229
1358735.859249.93514792899-514.085147928992
13613327.653333333311027.21401960782300.43931372546
13711056.5911027.214019607829.3759803921585
1389115.5611027.2140196078-1911.65401960784
13912362.5915455.136875-3092.546875
14018789.5515455.1368753334.413125
14112557.8511027.21401960781530.63598039216
1429958.7111027.2140196078-1068.50401960784
14314214.2311027.21401960783187.01598039216
14411619.0511027.2140196078591.835980392158
14511351.4711027.2140196078324.255980392158
14618802.4311027.21401960787775.21598039216
14717945.889249.935147928998695.944852071
14810657.0411027.2140196078-370.174019607843
14916213.1211027.21401960785185.90598039216
1509462.5311027.2140196078-1564.68401960784
1517472.789249.93514792899-1777.15514792899
15212839.2415455.136875-2615.896875
1537485.879249.93514792899-1764.06514792899
15413290.139249.935147928994040.19485207101
155393.129249.93514792899-8856.81514792899
1564551.8311027.2140196078-6475.38401960784
15717193.029249.935147928997943.08485207101
15810009.1711027.2140196078-1018.04401960784
1596195.699249.93514792899-3054.24514792899
16024073.5315455.1368758618.393125
1617659.059249.93514792899-1590.88514792899
16213109.3411027.21401960782082.12598039216
16313021.6611027.21401960781994.44598039216
1646618.4911027.2140196078-4408.72401960784
16511773.4811027.2140196078746.265980392158
16618620.9415455.1368753165.803125
16710339.7211027.2140196078-687.494019607841
16811423.9711027.2140196078396.755980392158
1698271.059249.93514792899-978.885147928993
17012710.2711027.21401960781683.05598039216
17114125.5411027.21401960783098.32598039216
1729564.6411027.2140196078-1462.57401960784
1736136.4611027.2140196078-4890.75401960784
1747767.919249.93514792899-1482.02514792899
17513043.9811027.21401960782016.76598039216
17612884.319249.935147928993634.37485207101
17718401.7811027.21401960787374.56598039216
17817015.0715455.1368751559.933125
17911913.119249.935147928992663.17485207101
18025701.6715455.13687510246.533125
1817601.0911027.2140196078-3426.12401960784
18212510.8211027.21401960781483.60598039216
18310929.111027.2140196078-98.1140196078413
18411205.4211027.2140196078178.205980392158
18516889.5611027.21401960785862.34598039216
18611753.215455.136875-3701.936875
18711378.5311027.2140196078351.315980392157
1887912.759249.93514792899-1337.18514792899
1899656.569249.93514792899406.624852071007
1906899.689249.93514792899-2350.25514792899
1919994.2811027.2140196078-1032.93401960784
1928914.5415455.136875-6540.596875
1936238.019249.93514792899-3011.92514792899
19416230.9611027.21401960785203.74598039216
19510035.419249.93514792899785.474852071007
1968083.7511027.2140196078-2943.46401960784
19718126.8911027.21401960787099.67598039216
19813696.7611027.21401960782669.54598039216
199474.179249.93514792899-8775.76514792899
2006179.8411027.2140196078-4847.37401960784
2017963.9711027.2140196078-3063.24401960784
20209249.93514792899-9249.93514792899
20317394.2711027.21401960786367.05598039216
2048975.829249.93514792899-274.115147928993
20517338.599249.935147928998088.65485207101
2067967.829249.93514792899-1282.11514792899
20711613.879249.935147928992363.93485207101
2087894.859249.93514792899-1355.08514792899
2098315.499249.93514792899-934.445147928993
21015474.5315455.13687519.3931249999987
2118821.311027.2140196078-2205.91401960784
21211025.4111027.2140196078-1.80401960784184
2139762.979249.93514792899513.034852071009
21412871.9411027.21401960781844.72598039216
21510142.8211027.2140196078-884.394019607842
21610070.7715455.136875-5384.366875
21716068.9111027.21401960785041.69598039216
21811407.4311027.2140196078380.215980392159
2198652.8211027.2140196078-2374.39401960784
22017509.5111027.21401960786482.29598039216
2217451.3811027.2140196078-3575.83401960784
2228114.9711027.2140196078-2912.24401960784
2238409.3711027.2140196078-2617.84401960784
2249447.6511027.2140196078-1579.56401960784
22517281.4815455.1368751826.343125
2265679.419249.93514792899-3570.52514792899
2279826.749249.93514792899576.804852071007
22811758.499249.935147928992508.55485207101
2293928.2711027.2140196078-7098.94401960784
23020683.2415455.1368755228.103125
2316783.199249.93514792899-2466.74514792899
2328665.679249.93514792899-584.265147928993
23314167.739249.935147928994917.79485207101
234362.349249.93514792899-8887.59514792899
2354380.059249.93514792899-4869.88514792899
23614235.29249.935147928994985.26485207101
2375643.249249.93514792899-3606.69514792899
23814639.7815455.136875-815.356875000001
2398517.49249.93514792899-732.535147928993
24012805.959249.935147928993556.01485207101
2415945.5211027.2140196078-5081.69401960784
2427642.439249.93514792899-1607.50514792899
24319226.2911027.21401960788199.07598039216
24413625.039249.935147928994375.09485207101
2458005.469249.93514792899-1244.47514792899
2468254.539249.93514792899-995.405147928994
24715101.5611027.21401960784074.34598039216
24813953.029249.935147928994703.08485207101
24910692.6911027.2140196078-334.524019607843
2509730.579249.93514792899480.634852071007
25112431.059249.935147928993181.11485207101
25210350.389249.935147928991100.44485207101
2537404.669249.93514792899-1845.27514792899

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 12999.88 & 9249.93514792899 & 3749.94485207101 \tabularnewline
2 & 11850.33 & 11027.2140196078 & 823.115980392158 \tabularnewline
3 & 10206.05 & 9249.93514792899 & 956.114852071007 \tabularnewline
4 & 8807.34 & 9249.93514792899 & -442.595147928992 \tabularnewline
5 & 9098.8 & 9249.93514792899 & -151.135147928993 \tabularnewline
6 & 8801.08 & 9249.93514792899 & -448.855147928993 \tabularnewline
7 & 7366.2366666667 & 9249.93514792899 & -1883.69848126229 \tabularnewline
8 & 7322.3966666667 & 9249.93514792899 & -1927.53848126229 \tabularnewline
9 & 7790.85 & 9249.93514792899 & -1459.08514792899 \tabularnewline
10 & 10365.6933333333 & 9249.93514792899 & 1115.75818540431 \tabularnewline
11 & 9269.42 & 9249.93514792899 & 19.4848520710075 \tabularnewline
12 & 13775.44 & 9249.93514792899 & 4525.50485207101 \tabularnewline
13 & 8914.53 & 9249.93514792899 & -335.405147928992 \tabularnewline
14 & 10481.36 & 11027.2140196078 & -545.854019607841 \tabularnewline
15 & 12143.46 & 9249.93514792899 & 2893.52485207101 \tabularnewline
16 & 13140.56 & 9249.93514792899 & 3890.62485207101 \tabularnewline
17 & 13116.6 & 9249.93514792899 & 3866.66485207101 \tabularnewline
18 & 10017.99 & 9249.93514792899 & 768.054852071007 \tabularnewline
19 & 13943.58 & 9249.93514792899 & 4693.64485207101 \tabularnewline
20 & 15979.32 & 9249.93514792899 & 6729.38485207101 \tabularnewline
21 & 13148.72 & 9249.93514792899 & 3898.78485207101 \tabularnewline
22 & 12586.25 & 11027.2140196078 & 1559.03598039216 \tabularnewline
23 & 10571.6433333333 & 11027.2140196078 & -455.570686274543 \tabularnewline
24 & 9113.65 & 9249.93514792899 & -136.285147928993 \tabularnewline
25 & 9459.9633333333 & 9249.93514792899 & 210.028185404308 \tabularnewline
26 & 9283.79 & 9249.93514792899 & 33.8548520710083 \tabularnewline
27 & 12962.26 & 9249.93514792899 & 3712.32485207101 \tabularnewline
28 & 12195.04 & 9249.93514792899 & 2945.10485207101 \tabularnewline
29 & 11199.9 & 9249.93514792899 & 1949.96485207101 \tabularnewline
30 & 13065.01 & 9249.93514792899 & 3815.07485207101 \tabularnewline
31 & 9125.1033333333 & 9249.93514792899 & -124.831814595693 \tabularnewline
32 & 13099.81 & 9249.93514792899 & 3849.87485207101 \tabularnewline
33 & 12544.58 & 9249.93514792899 & 3294.64485207101 \tabularnewline
34 & 8530.76 & 9249.93514792899 & -719.175147928992 \tabularnewline
35 & 12707.7 & 9249.93514792899 & 3457.76485207101 \tabularnewline
36 & 3369.09 & 11027.2140196078 & -7658.12401960784 \tabularnewline
37 & 8611.97 & 9249.93514792899 & -637.965147928991 \tabularnewline
38 & 8556.14 & 9249.93514792899 & -693.795147928993 \tabularnewline
39 & 11010.32 & 9249.93514792899 & 1760.38485207101 \tabularnewline
40 & 9455.21 & 9249.93514792899 & 205.274852071007 \tabularnewline
41 & 9068.05 & 9249.93514792899 & -181.885147928993 \tabularnewline
42 & 14218.25 & 9249.93514792899 & 4968.31485207101 \tabularnewline
43 & 9548.62 & 9249.93514792899 & 298.684852071006 \tabularnewline
44 & 9731.54 & 9249.93514792899 & 481.604852071008 \tabularnewline
45 & 12258.49 & 9249.93514792899 & 3008.55485207101 \tabularnewline
46 & 8426.29 & 9249.93514792899 & -823.645147928992 \tabularnewline
47 & 6566.42 & 9249.93514792899 & -2683.51514792899 \tabularnewline
48 & 10124.61 & 9249.93514792899 & 874.674852071008 \tabularnewline
49 & 8364.27 & 9249.93514792899 & -885.665147928992 \tabularnewline
50 & 9150.96 & 9249.93514792899 & -98.9751479289935 \tabularnewline
51 & 9927.42 & 9249.93514792899 & 677.484852071007 \tabularnewline
52 & 8705.19 & 11027.2140196078 & -2322.02401960784 \tabularnewline
53 & 8853.41 & 9249.93514792899 & -396.525147928993 \tabularnewline
54 & 11224 & 9249.93514792899 & 1974.06485207101 \tabularnewline
55 & 5123.1 & 9249.93514792899 & -4126.83514792899 \tabularnewline
56 & 5970.44 & 11027.2140196078 & -5056.77401960784 \tabularnewline
57 & 10441.13 & 9249.93514792899 & 1191.19485207101 \tabularnewline
58 & 7707.26 & 9249.93514792899 & -1542.67514792899 \tabularnewline
59 & 10489.06 & 9249.93514792899 & 1239.12485207101 \tabularnewline
60 & 12247.67 & 9249.93514792899 & 2997.73485207101 \tabularnewline
61 & 6713.04 & 9249.93514792899 & -2536.89514792899 \tabularnewline
62 & 9370.7033333333 & 9249.93514792899 & 120.768185404308 \tabularnewline
63 & 8282.81 & 9249.93514792899 & -967.125147928993 \tabularnewline
64 & 8756.0933333333 & 9249.93514792899 & -493.841814595693 \tabularnewline
65 & 12624.32 & 9249.93514792899 & 3374.38485207101 \tabularnewline
66 & 8866.3433333333 & 9249.93514792899 & -383.591814595693 \tabularnewline
67 & 6063.61 & 9249.93514792899 & -3186.32514792899 \tabularnewline
68 & 7018.63 & 9249.93514792899 & -2231.30514792899 \tabularnewline
69 & 5517.95 & 9249.93514792899 & -3731.98514792899 \tabularnewline
70 & 9701.81 & 9249.93514792899 & 451.874852071007 \tabularnewline
71 & 9810.06 & 9249.93514792899 & 560.124852071007 \tabularnewline
72 & 7446.07 & 9249.93514792899 & -1803.86514792899 \tabularnewline
73 & 7954.65 & 9249.93514792899 & -1295.28514792899 \tabularnewline
74 & 6300.7 & 9249.93514792899 & -2949.23514792899 \tabularnewline
75 & 7142.28 & 9249.93514792899 & -2107.65514792899 \tabularnewline
76 & 9202.32 & 9249.93514792899 & -47.6151479289929 \tabularnewline
77 & 5867.79 & 9249.93514792899 & -3382.14514792899 \tabularnewline
78 & 4481.13 & 11027.2140196078 & -6546.08401960784 \tabularnewline
79 & 13707.5733333333 & 9249.93514792899 & 4457.63818540431 \tabularnewline
80 & 9927.51 & 9249.93514792899 & 677.574852071008 \tabularnewline
81 & 8741.7366666667 & 9249.93514792899 & -508.198481262292 \tabularnewline
82 & 7095.66 & 9249.93514792899 & -2154.27514792899 \tabularnewline
83 & 9186.73 & 9249.93514792899 & -63.205147928993 \tabularnewline
84 & 8958.79 & 9249.93514792899 & -291.145147928992 \tabularnewline
85 & 5701.56 & 9249.93514792899 & -3548.37514792899 \tabularnewline
86 & 6940.11 & 9249.93514792899 & -2309.82514792899 \tabularnewline
87 & 8452.86 & 9249.93514792899 & -797.075147928992 \tabularnewline
88 & 13315.1233333333 & 9249.93514792899 & 4065.18818540431 \tabularnewline
89 & 6301.37 & 9249.93514792899 & -2948.56514792899 \tabularnewline
90 & 5614.49 & 9249.93514792899 & -3635.44514792899 \tabularnewline
91 & 10239.78 & 11027.2140196078 & -787.434019607843 \tabularnewline
92 & 7072.1 & 9249.93514792899 & -2177.83514792899 \tabularnewline
93 & 5381.77 & 9249.93514792899 & -3868.16514792899 \tabularnewline
94 & 10010.06 & 9249.93514792899 & 760.124852071007 \tabularnewline
95 & 4844.83 & 9249.93514792899 & -4405.10514792899 \tabularnewline
96 & 7982.6 & 9249.93514792899 & -1267.33514792899 \tabularnewline
97 & 8956.8133333333 & 9249.93514792899 & -293.121814595694 \tabularnewline
98 & 8350.2 & 9249.93514792899 & -899.735147928992 \tabularnewline
99 & 13201.79 & 9249.93514792899 & 3951.85485207101 \tabularnewline
100 & 5350.28 & 9249.93514792899 & -3899.65514792899 \tabularnewline
101 & 9404.76 & 9249.93514792899 & 154.824852071008 \tabularnewline
102 & 6740.52 & 9249.93514792899 & -2509.41514792899 \tabularnewline
103 & 11055.21 & 9249.93514792899 & 1805.27485207101 \tabularnewline
104 & 10406.84 & 9249.93514792899 & 1156.90485207101 \tabularnewline
105 & 6996.91 & 9249.93514792899 & -2253.02514792899 \tabularnewline
106 & 6239.87 & 9249.93514792899 & -3010.06514792899 \tabularnewline
107 & 6184.58 & 9249.93514792899 & -3065.35514792899 \tabularnewline
108 & 7473.5566666667 & 9249.93514792899 & -1776.37848126229 \tabularnewline
109 & 11568.24 & 9249.93514792899 & 2318.30485207101 \tabularnewline
110 & 8569.5466666667 & 9249.93514792899 & -680.388481262293 \tabularnewline
111 & 11914.48 & 9249.93514792899 & 2664.54485207101 \tabularnewline
112 & 6086.44 & 9249.93514792899 & -3163.49514792899 \tabularnewline
113 & 12749.66 & 9249.93514792899 & 3499.72485207101 \tabularnewline
114 & 5384.01 & 9249.93514792899 & -3865.92514792899 \tabularnewline
115 & 11344.7 & 9249.93514792899 & 2094.76485207101 \tabularnewline
116 & 7137.82 & 15455.136875 & -8317.316875 \tabularnewline
117 & 7297.28 & 9249.93514792899 & -1952.65514792899 \tabularnewline
118 & 7294.08 & 9249.93514792899 & -1955.85514792899 \tabularnewline
119 & 9876.43 & 9249.93514792899 & 626.494852071008 \tabularnewline
120 & 8047.74 & 11027.2140196078 & -2979.47401960784 \tabularnewline
121 & 9801.26 & 9249.93514792899 & 551.324852071008 \tabularnewline
122 & 11924.24 & 15455.136875 & -3530.896875 \tabularnewline
123 & 13083.54 & 9249.93514792899 & 3833.60485207101 \tabularnewline
124 & 8829.9766666667 & 9249.93514792899 & -419.958481262292 \tabularnewline
125 & 6959.31 & 9249.93514792899 & -2290.62514792899 \tabularnewline
126 & 9545.51 & 9249.93514792899 & 295.574852071008 \tabularnewline
127 & 8963.5233333333 & 9249.93514792899 & -286.411814595693 \tabularnewline
128 & 4868.32 & 9249.93514792899 & -4381.61514792899 \tabularnewline
129 & 9288.22 & 9249.93514792899 & 38.2848520710086 \tabularnewline
130 & 8351.32 & 9249.93514792899 & -898.615147928993 \tabularnewline
131 & 8579.56 & 9249.93514792899 & -670.375147928993 \tabularnewline
132 & 13804.41 & 9249.93514792899 & 4554.47485207101 \tabularnewline
133 & 7377.9566666667 & 11027.2140196078 & -3649.25735294114 \tabularnewline
134 & 7727.8366666667 & 9249.93514792899 & -1522.09848126229 \tabularnewline
135 & 8735.85 & 9249.93514792899 & -514.085147928992 \tabularnewline
136 & 13327.6533333333 & 11027.2140196078 & 2300.43931372546 \tabularnewline
137 & 11056.59 & 11027.2140196078 & 29.3759803921585 \tabularnewline
138 & 9115.56 & 11027.2140196078 & -1911.65401960784 \tabularnewline
139 & 12362.59 & 15455.136875 & -3092.546875 \tabularnewline
140 & 18789.55 & 15455.136875 & 3334.413125 \tabularnewline
141 & 12557.85 & 11027.2140196078 & 1530.63598039216 \tabularnewline
142 & 9958.71 & 11027.2140196078 & -1068.50401960784 \tabularnewline
143 & 14214.23 & 11027.2140196078 & 3187.01598039216 \tabularnewline
144 & 11619.05 & 11027.2140196078 & 591.835980392158 \tabularnewline
145 & 11351.47 & 11027.2140196078 & 324.255980392158 \tabularnewline
146 & 18802.43 & 11027.2140196078 & 7775.21598039216 \tabularnewline
147 & 17945.88 & 9249.93514792899 & 8695.944852071 \tabularnewline
148 & 10657.04 & 11027.2140196078 & -370.174019607843 \tabularnewline
149 & 16213.12 & 11027.2140196078 & 5185.90598039216 \tabularnewline
150 & 9462.53 & 11027.2140196078 & -1564.68401960784 \tabularnewline
151 & 7472.78 & 9249.93514792899 & -1777.15514792899 \tabularnewline
152 & 12839.24 & 15455.136875 & -2615.896875 \tabularnewline
153 & 7485.87 & 9249.93514792899 & -1764.06514792899 \tabularnewline
154 & 13290.13 & 9249.93514792899 & 4040.19485207101 \tabularnewline
155 & 393.12 & 9249.93514792899 & -8856.81514792899 \tabularnewline
156 & 4551.83 & 11027.2140196078 & -6475.38401960784 \tabularnewline
157 & 17193.02 & 9249.93514792899 & 7943.08485207101 \tabularnewline
158 & 10009.17 & 11027.2140196078 & -1018.04401960784 \tabularnewline
159 & 6195.69 & 9249.93514792899 & -3054.24514792899 \tabularnewline
160 & 24073.53 & 15455.136875 & 8618.393125 \tabularnewline
161 & 7659.05 & 9249.93514792899 & -1590.88514792899 \tabularnewline
162 & 13109.34 & 11027.2140196078 & 2082.12598039216 \tabularnewline
163 & 13021.66 & 11027.2140196078 & 1994.44598039216 \tabularnewline
164 & 6618.49 & 11027.2140196078 & -4408.72401960784 \tabularnewline
165 & 11773.48 & 11027.2140196078 & 746.265980392158 \tabularnewline
166 & 18620.94 & 15455.136875 & 3165.803125 \tabularnewline
167 & 10339.72 & 11027.2140196078 & -687.494019607841 \tabularnewline
168 & 11423.97 & 11027.2140196078 & 396.755980392158 \tabularnewline
169 & 8271.05 & 9249.93514792899 & -978.885147928993 \tabularnewline
170 & 12710.27 & 11027.2140196078 & 1683.05598039216 \tabularnewline
171 & 14125.54 & 11027.2140196078 & 3098.32598039216 \tabularnewline
172 & 9564.64 & 11027.2140196078 & -1462.57401960784 \tabularnewline
173 & 6136.46 & 11027.2140196078 & -4890.75401960784 \tabularnewline
174 & 7767.91 & 9249.93514792899 & -1482.02514792899 \tabularnewline
175 & 13043.98 & 11027.2140196078 & 2016.76598039216 \tabularnewline
176 & 12884.31 & 9249.93514792899 & 3634.37485207101 \tabularnewline
177 & 18401.78 & 11027.2140196078 & 7374.56598039216 \tabularnewline
178 & 17015.07 & 15455.136875 & 1559.933125 \tabularnewline
179 & 11913.11 & 9249.93514792899 & 2663.17485207101 \tabularnewline
180 & 25701.67 & 15455.136875 & 10246.533125 \tabularnewline
181 & 7601.09 & 11027.2140196078 & -3426.12401960784 \tabularnewline
182 & 12510.82 & 11027.2140196078 & 1483.60598039216 \tabularnewline
183 & 10929.1 & 11027.2140196078 & -98.1140196078413 \tabularnewline
184 & 11205.42 & 11027.2140196078 & 178.205980392158 \tabularnewline
185 & 16889.56 & 11027.2140196078 & 5862.34598039216 \tabularnewline
186 & 11753.2 & 15455.136875 & -3701.936875 \tabularnewline
187 & 11378.53 & 11027.2140196078 & 351.315980392157 \tabularnewline
188 & 7912.75 & 9249.93514792899 & -1337.18514792899 \tabularnewline
189 & 9656.56 & 9249.93514792899 & 406.624852071007 \tabularnewline
190 & 6899.68 & 9249.93514792899 & -2350.25514792899 \tabularnewline
191 & 9994.28 & 11027.2140196078 & -1032.93401960784 \tabularnewline
192 & 8914.54 & 15455.136875 & -6540.596875 \tabularnewline
193 & 6238.01 & 9249.93514792899 & -3011.92514792899 \tabularnewline
194 & 16230.96 & 11027.2140196078 & 5203.74598039216 \tabularnewline
195 & 10035.41 & 9249.93514792899 & 785.474852071007 \tabularnewline
196 & 8083.75 & 11027.2140196078 & -2943.46401960784 \tabularnewline
197 & 18126.89 & 11027.2140196078 & 7099.67598039216 \tabularnewline
198 & 13696.76 & 11027.2140196078 & 2669.54598039216 \tabularnewline
199 & 474.17 & 9249.93514792899 & -8775.76514792899 \tabularnewline
200 & 6179.84 & 11027.2140196078 & -4847.37401960784 \tabularnewline
201 & 7963.97 & 11027.2140196078 & -3063.24401960784 \tabularnewline
202 & 0 & 9249.93514792899 & -9249.93514792899 \tabularnewline
203 & 17394.27 & 11027.2140196078 & 6367.05598039216 \tabularnewline
204 & 8975.82 & 9249.93514792899 & -274.115147928993 \tabularnewline
205 & 17338.59 & 9249.93514792899 & 8088.65485207101 \tabularnewline
206 & 7967.82 & 9249.93514792899 & -1282.11514792899 \tabularnewline
207 & 11613.87 & 9249.93514792899 & 2363.93485207101 \tabularnewline
208 & 7894.85 & 9249.93514792899 & -1355.08514792899 \tabularnewline
209 & 8315.49 & 9249.93514792899 & -934.445147928993 \tabularnewline
210 & 15474.53 & 15455.136875 & 19.3931249999987 \tabularnewline
211 & 8821.3 & 11027.2140196078 & -2205.91401960784 \tabularnewline
212 & 11025.41 & 11027.2140196078 & -1.80401960784184 \tabularnewline
213 & 9762.97 & 9249.93514792899 & 513.034852071009 \tabularnewline
214 & 12871.94 & 11027.2140196078 & 1844.72598039216 \tabularnewline
215 & 10142.82 & 11027.2140196078 & -884.394019607842 \tabularnewline
216 & 10070.77 & 15455.136875 & -5384.366875 \tabularnewline
217 & 16068.91 & 11027.2140196078 & 5041.69598039216 \tabularnewline
218 & 11407.43 & 11027.2140196078 & 380.215980392159 \tabularnewline
219 & 8652.82 & 11027.2140196078 & -2374.39401960784 \tabularnewline
220 & 17509.51 & 11027.2140196078 & 6482.29598039216 \tabularnewline
221 & 7451.38 & 11027.2140196078 & -3575.83401960784 \tabularnewline
222 & 8114.97 & 11027.2140196078 & -2912.24401960784 \tabularnewline
223 & 8409.37 & 11027.2140196078 & -2617.84401960784 \tabularnewline
224 & 9447.65 & 11027.2140196078 & -1579.56401960784 \tabularnewline
225 & 17281.48 & 15455.136875 & 1826.343125 \tabularnewline
226 & 5679.41 & 9249.93514792899 & -3570.52514792899 \tabularnewline
227 & 9826.74 & 9249.93514792899 & 576.804852071007 \tabularnewline
228 & 11758.49 & 9249.93514792899 & 2508.55485207101 \tabularnewline
229 & 3928.27 & 11027.2140196078 & -7098.94401960784 \tabularnewline
230 & 20683.24 & 15455.136875 & 5228.103125 \tabularnewline
231 & 6783.19 & 9249.93514792899 & -2466.74514792899 \tabularnewline
232 & 8665.67 & 9249.93514792899 & -584.265147928993 \tabularnewline
233 & 14167.73 & 9249.93514792899 & 4917.79485207101 \tabularnewline
234 & 362.34 & 9249.93514792899 & -8887.59514792899 \tabularnewline
235 & 4380.05 & 9249.93514792899 & -4869.88514792899 \tabularnewline
236 & 14235.2 & 9249.93514792899 & 4985.26485207101 \tabularnewline
237 & 5643.24 & 9249.93514792899 & -3606.69514792899 \tabularnewline
238 & 14639.78 & 15455.136875 & -815.356875000001 \tabularnewline
239 & 8517.4 & 9249.93514792899 & -732.535147928993 \tabularnewline
240 & 12805.95 & 9249.93514792899 & 3556.01485207101 \tabularnewline
241 & 5945.52 & 11027.2140196078 & -5081.69401960784 \tabularnewline
242 & 7642.43 & 9249.93514792899 & -1607.50514792899 \tabularnewline
243 & 19226.29 & 11027.2140196078 & 8199.07598039216 \tabularnewline
244 & 13625.03 & 9249.93514792899 & 4375.09485207101 \tabularnewline
245 & 8005.46 & 9249.93514792899 & -1244.47514792899 \tabularnewline
246 & 8254.53 & 9249.93514792899 & -995.405147928994 \tabularnewline
247 & 15101.56 & 11027.2140196078 & 4074.34598039216 \tabularnewline
248 & 13953.02 & 9249.93514792899 & 4703.08485207101 \tabularnewline
249 & 10692.69 & 11027.2140196078 & -334.524019607843 \tabularnewline
250 & 9730.57 & 9249.93514792899 & 480.634852071007 \tabularnewline
251 & 12431.05 & 9249.93514792899 & 3181.11485207101 \tabularnewline
252 & 10350.38 & 9249.93514792899 & 1100.44485207101 \tabularnewline
253 & 7404.66 & 9249.93514792899 & -1845.27514792899 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=165838&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]12999.88[/C][C]9249.93514792899[/C][C]3749.94485207101[/C][/ROW]
[ROW][C]2[/C][C]11850.33[/C][C]11027.2140196078[/C][C]823.115980392158[/C][/ROW]
[ROW][C]3[/C][C]10206.05[/C][C]9249.93514792899[/C][C]956.114852071007[/C][/ROW]
[ROW][C]4[/C][C]8807.34[/C][C]9249.93514792899[/C][C]-442.595147928992[/C][/ROW]
[ROW][C]5[/C][C]9098.8[/C][C]9249.93514792899[/C][C]-151.135147928993[/C][/ROW]
[ROW][C]6[/C][C]8801.08[/C][C]9249.93514792899[/C][C]-448.855147928993[/C][/ROW]
[ROW][C]7[/C][C]7366.2366666667[/C][C]9249.93514792899[/C][C]-1883.69848126229[/C][/ROW]
[ROW][C]8[/C][C]7322.3966666667[/C][C]9249.93514792899[/C][C]-1927.53848126229[/C][/ROW]
[ROW][C]9[/C][C]7790.85[/C][C]9249.93514792899[/C][C]-1459.08514792899[/C][/ROW]
[ROW][C]10[/C][C]10365.6933333333[/C][C]9249.93514792899[/C][C]1115.75818540431[/C][/ROW]
[ROW][C]11[/C][C]9269.42[/C][C]9249.93514792899[/C][C]19.4848520710075[/C][/ROW]
[ROW][C]12[/C][C]13775.44[/C][C]9249.93514792899[/C][C]4525.50485207101[/C][/ROW]
[ROW][C]13[/C][C]8914.53[/C][C]9249.93514792899[/C][C]-335.405147928992[/C][/ROW]
[ROW][C]14[/C][C]10481.36[/C][C]11027.2140196078[/C][C]-545.854019607841[/C][/ROW]
[ROW][C]15[/C][C]12143.46[/C][C]9249.93514792899[/C][C]2893.52485207101[/C][/ROW]
[ROW][C]16[/C][C]13140.56[/C][C]9249.93514792899[/C][C]3890.62485207101[/C][/ROW]
[ROW][C]17[/C][C]13116.6[/C][C]9249.93514792899[/C][C]3866.66485207101[/C][/ROW]
[ROW][C]18[/C][C]10017.99[/C][C]9249.93514792899[/C][C]768.054852071007[/C][/ROW]
[ROW][C]19[/C][C]13943.58[/C][C]9249.93514792899[/C][C]4693.64485207101[/C][/ROW]
[ROW][C]20[/C][C]15979.32[/C][C]9249.93514792899[/C][C]6729.38485207101[/C][/ROW]
[ROW][C]21[/C][C]13148.72[/C][C]9249.93514792899[/C][C]3898.78485207101[/C][/ROW]
[ROW][C]22[/C][C]12586.25[/C][C]11027.2140196078[/C][C]1559.03598039216[/C][/ROW]
[ROW][C]23[/C][C]10571.6433333333[/C][C]11027.2140196078[/C][C]-455.570686274543[/C][/ROW]
[ROW][C]24[/C][C]9113.65[/C][C]9249.93514792899[/C][C]-136.285147928993[/C][/ROW]
[ROW][C]25[/C][C]9459.9633333333[/C][C]9249.93514792899[/C][C]210.028185404308[/C][/ROW]
[ROW][C]26[/C][C]9283.79[/C][C]9249.93514792899[/C][C]33.8548520710083[/C][/ROW]
[ROW][C]27[/C][C]12962.26[/C][C]9249.93514792899[/C][C]3712.32485207101[/C][/ROW]
[ROW][C]28[/C][C]12195.04[/C][C]9249.93514792899[/C][C]2945.10485207101[/C][/ROW]
[ROW][C]29[/C][C]11199.9[/C][C]9249.93514792899[/C][C]1949.96485207101[/C][/ROW]
[ROW][C]30[/C][C]13065.01[/C][C]9249.93514792899[/C][C]3815.07485207101[/C][/ROW]
[ROW][C]31[/C][C]9125.1033333333[/C][C]9249.93514792899[/C][C]-124.831814595693[/C][/ROW]
[ROW][C]32[/C][C]13099.81[/C][C]9249.93514792899[/C][C]3849.87485207101[/C][/ROW]
[ROW][C]33[/C][C]12544.58[/C][C]9249.93514792899[/C][C]3294.64485207101[/C][/ROW]
[ROW][C]34[/C][C]8530.76[/C][C]9249.93514792899[/C][C]-719.175147928992[/C][/ROW]
[ROW][C]35[/C][C]12707.7[/C][C]9249.93514792899[/C][C]3457.76485207101[/C][/ROW]
[ROW][C]36[/C][C]3369.09[/C][C]11027.2140196078[/C][C]-7658.12401960784[/C][/ROW]
[ROW][C]37[/C][C]8611.97[/C][C]9249.93514792899[/C][C]-637.965147928991[/C][/ROW]
[ROW][C]38[/C][C]8556.14[/C][C]9249.93514792899[/C][C]-693.795147928993[/C][/ROW]
[ROW][C]39[/C][C]11010.32[/C][C]9249.93514792899[/C][C]1760.38485207101[/C][/ROW]
[ROW][C]40[/C][C]9455.21[/C][C]9249.93514792899[/C][C]205.274852071007[/C][/ROW]
[ROW][C]41[/C][C]9068.05[/C][C]9249.93514792899[/C][C]-181.885147928993[/C][/ROW]
[ROW][C]42[/C][C]14218.25[/C][C]9249.93514792899[/C][C]4968.31485207101[/C][/ROW]
[ROW][C]43[/C][C]9548.62[/C][C]9249.93514792899[/C][C]298.684852071006[/C][/ROW]
[ROW][C]44[/C][C]9731.54[/C][C]9249.93514792899[/C][C]481.604852071008[/C][/ROW]
[ROW][C]45[/C][C]12258.49[/C][C]9249.93514792899[/C][C]3008.55485207101[/C][/ROW]
[ROW][C]46[/C][C]8426.29[/C][C]9249.93514792899[/C][C]-823.645147928992[/C][/ROW]
[ROW][C]47[/C][C]6566.42[/C][C]9249.93514792899[/C][C]-2683.51514792899[/C][/ROW]
[ROW][C]48[/C][C]10124.61[/C][C]9249.93514792899[/C][C]874.674852071008[/C][/ROW]
[ROW][C]49[/C][C]8364.27[/C][C]9249.93514792899[/C][C]-885.665147928992[/C][/ROW]
[ROW][C]50[/C][C]9150.96[/C][C]9249.93514792899[/C][C]-98.9751479289935[/C][/ROW]
[ROW][C]51[/C][C]9927.42[/C][C]9249.93514792899[/C][C]677.484852071007[/C][/ROW]
[ROW][C]52[/C][C]8705.19[/C][C]11027.2140196078[/C][C]-2322.02401960784[/C][/ROW]
[ROW][C]53[/C][C]8853.41[/C][C]9249.93514792899[/C][C]-396.525147928993[/C][/ROW]
[ROW][C]54[/C][C]11224[/C][C]9249.93514792899[/C][C]1974.06485207101[/C][/ROW]
[ROW][C]55[/C][C]5123.1[/C][C]9249.93514792899[/C][C]-4126.83514792899[/C][/ROW]
[ROW][C]56[/C][C]5970.44[/C][C]11027.2140196078[/C][C]-5056.77401960784[/C][/ROW]
[ROW][C]57[/C][C]10441.13[/C][C]9249.93514792899[/C][C]1191.19485207101[/C][/ROW]
[ROW][C]58[/C][C]7707.26[/C][C]9249.93514792899[/C][C]-1542.67514792899[/C][/ROW]
[ROW][C]59[/C][C]10489.06[/C][C]9249.93514792899[/C][C]1239.12485207101[/C][/ROW]
[ROW][C]60[/C][C]12247.67[/C][C]9249.93514792899[/C][C]2997.73485207101[/C][/ROW]
[ROW][C]61[/C][C]6713.04[/C][C]9249.93514792899[/C][C]-2536.89514792899[/C][/ROW]
[ROW][C]62[/C][C]9370.7033333333[/C][C]9249.93514792899[/C][C]120.768185404308[/C][/ROW]
[ROW][C]63[/C][C]8282.81[/C][C]9249.93514792899[/C][C]-967.125147928993[/C][/ROW]
[ROW][C]64[/C][C]8756.0933333333[/C][C]9249.93514792899[/C][C]-493.841814595693[/C][/ROW]
[ROW][C]65[/C][C]12624.32[/C][C]9249.93514792899[/C][C]3374.38485207101[/C][/ROW]
[ROW][C]66[/C][C]8866.3433333333[/C][C]9249.93514792899[/C][C]-383.591814595693[/C][/ROW]
[ROW][C]67[/C][C]6063.61[/C][C]9249.93514792899[/C][C]-3186.32514792899[/C][/ROW]
[ROW][C]68[/C][C]7018.63[/C][C]9249.93514792899[/C][C]-2231.30514792899[/C][/ROW]
[ROW][C]69[/C][C]5517.95[/C][C]9249.93514792899[/C][C]-3731.98514792899[/C][/ROW]
[ROW][C]70[/C][C]9701.81[/C][C]9249.93514792899[/C][C]451.874852071007[/C][/ROW]
[ROW][C]71[/C][C]9810.06[/C][C]9249.93514792899[/C][C]560.124852071007[/C][/ROW]
[ROW][C]72[/C][C]7446.07[/C][C]9249.93514792899[/C][C]-1803.86514792899[/C][/ROW]
[ROW][C]73[/C][C]7954.65[/C][C]9249.93514792899[/C][C]-1295.28514792899[/C][/ROW]
[ROW][C]74[/C][C]6300.7[/C][C]9249.93514792899[/C][C]-2949.23514792899[/C][/ROW]
[ROW][C]75[/C][C]7142.28[/C][C]9249.93514792899[/C][C]-2107.65514792899[/C][/ROW]
[ROW][C]76[/C][C]9202.32[/C][C]9249.93514792899[/C][C]-47.6151479289929[/C][/ROW]
[ROW][C]77[/C][C]5867.79[/C][C]9249.93514792899[/C][C]-3382.14514792899[/C][/ROW]
[ROW][C]78[/C][C]4481.13[/C][C]11027.2140196078[/C][C]-6546.08401960784[/C][/ROW]
[ROW][C]79[/C][C]13707.5733333333[/C][C]9249.93514792899[/C][C]4457.63818540431[/C][/ROW]
[ROW][C]80[/C][C]9927.51[/C][C]9249.93514792899[/C][C]677.574852071008[/C][/ROW]
[ROW][C]81[/C][C]8741.7366666667[/C][C]9249.93514792899[/C][C]-508.198481262292[/C][/ROW]
[ROW][C]82[/C][C]7095.66[/C][C]9249.93514792899[/C][C]-2154.27514792899[/C][/ROW]
[ROW][C]83[/C][C]9186.73[/C][C]9249.93514792899[/C][C]-63.205147928993[/C][/ROW]
[ROW][C]84[/C][C]8958.79[/C][C]9249.93514792899[/C][C]-291.145147928992[/C][/ROW]
[ROW][C]85[/C][C]5701.56[/C][C]9249.93514792899[/C][C]-3548.37514792899[/C][/ROW]
[ROW][C]86[/C][C]6940.11[/C][C]9249.93514792899[/C][C]-2309.82514792899[/C][/ROW]
[ROW][C]87[/C][C]8452.86[/C][C]9249.93514792899[/C][C]-797.075147928992[/C][/ROW]
[ROW][C]88[/C][C]13315.1233333333[/C][C]9249.93514792899[/C][C]4065.18818540431[/C][/ROW]
[ROW][C]89[/C][C]6301.37[/C][C]9249.93514792899[/C][C]-2948.56514792899[/C][/ROW]
[ROW][C]90[/C][C]5614.49[/C][C]9249.93514792899[/C][C]-3635.44514792899[/C][/ROW]
[ROW][C]91[/C][C]10239.78[/C][C]11027.2140196078[/C][C]-787.434019607843[/C][/ROW]
[ROW][C]92[/C][C]7072.1[/C][C]9249.93514792899[/C][C]-2177.83514792899[/C][/ROW]
[ROW][C]93[/C][C]5381.77[/C][C]9249.93514792899[/C][C]-3868.16514792899[/C][/ROW]
[ROW][C]94[/C][C]10010.06[/C][C]9249.93514792899[/C][C]760.124852071007[/C][/ROW]
[ROW][C]95[/C][C]4844.83[/C][C]9249.93514792899[/C][C]-4405.10514792899[/C][/ROW]
[ROW][C]96[/C][C]7982.6[/C][C]9249.93514792899[/C][C]-1267.33514792899[/C][/ROW]
[ROW][C]97[/C][C]8956.8133333333[/C][C]9249.93514792899[/C][C]-293.121814595694[/C][/ROW]
[ROW][C]98[/C][C]8350.2[/C][C]9249.93514792899[/C][C]-899.735147928992[/C][/ROW]
[ROW][C]99[/C][C]13201.79[/C][C]9249.93514792899[/C][C]3951.85485207101[/C][/ROW]
[ROW][C]100[/C][C]5350.28[/C][C]9249.93514792899[/C][C]-3899.65514792899[/C][/ROW]
[ROW][C]101[/C][C]9404.76[/C][C]9249.93514792899[/C][C]154.824852071008[/C][/ROW]
[ROW][C]102[/C][C]6740.52[/C][C]9249.93514792899[/C][C]-2509.41514792899[/C][/ROW]
[ROW][C]103[/C][C]11055.21[/C][C]9249.93514792899[/C][C]1805.27485207101[/C][/ROW]
[ROW][C]104[/C][C]10406.84[/C][C]9249.93514792899[/C][C]1156.90485207101[/C][/ROW]
[ROW][C]105[/C][C]6996.91[/C][C]9249.93514792899[/C][C]-2253.02514792899[/C][/ROW]
[ROW][C]106[/C][C]6239.87[/C][C]9249.93514792899[/C][C]-3010.06514792899[/C][/ROW]
[ROW][C]107[/C][C]6184.58[/C][C]9249.93514792899[/C][C]-3065.35514792899[/C][/ROW]
[ROW][C]108[/C][C]7473.5566666667[/C][C]9249.93514792899[/C][C]-1776.37848126229[/C][/ROW]
[ROW][C]109[/C][C]11568.24[/C][C]9249.93514792899[/C][C]2318.30485207101[/C][/ROW]
[ROW][C]110[/C][C]8569.5466666667[/C][C]9249.93514792899[/C][C]-680.388481262293[/C][/ROW]
[ROW][C]111[/C][C]11914.48[/C][C]9249.93514792899[/C][C]2664.54485207101[/C][/ROW]
[ROW][C]112[/C][C]6086.44[/C][C]9249.93514792899[/C][C]-3163.49514792899[/C][/ROW]
[ROW][C]113[/C][C]12749.66[/C][C]9249.93514792899[/C][C]3499.72485207101[/C][/ROW]
[ROW][C]114[/C][C]5384.01[/C][C]9249.93514792899[/C][C]-3865.92514792899[/C][/ROW]
[ROW][C]115[/C][C]11344.7[/C][C]9249.93514792899[/C][C]2094.76485207101[/C][/ROW]
[ROW][C]116[/C][C]7137.82[/C][C]15455.136875[/C][C]-8317.316875[/C][/ROW]
[ROW][C]117[/C][C]7297.28[/C][C]9249.93514792899[/C][C]-1952.65514792899[/C][/ROW]
[ROW][C]118[/C][C]7294.08[/C][C]9249.93514792899[/C][C]-1955.85514792899[/C][/ROW]
[ROW][C]119[/C][C]9876.43[/C][C]9249.93514792899[/C][C]626.494852071008[/C][/ROW]
[ROW][C]120[/C][C]8047.74[/C][C]11027.2140196078[/C][C]-2979.47401960784[/C][/ROW]
[ROW][C]121[/C][C]9801.26[/C][C]9249.93514792899[/C][C]551.324852071008[/C][/ROW]
[ROW][C]122[/C][C]11924.24[/C][C]15455.136875[/C][C]-3530.896875[/C][/ROW]
[ROW][C]123[/C][C]13083.54[/C][C]9249.93514792899[/C][C]3833.60485207101[/C][/ROW]
[ROW][C]124[/C][C]8829.9766666667[/C][C]9249.93514792899[/C][C]-419.958481262292[/C][/ROW]
[ROW][C]125[/C][C]6959.31[/C][C]9249.93514792899[/C][C]-2290.62514792899[/C][/ROW]
[ROW][C]126[/C][C]9545.51[/C][C]9249.93514792899[/C][C]295.574852071008[/C][/ROW]
[ROW][C]127[/C][C]8963.5233333333[/C][C]9249.93514792899[/C][C]-286.411814595693[/C][/ROW]
[ROW][C]128[/C][C]4868.32[/C][C]9249.93514792899[/C][C]-4381.61514792899[/C][/ROW]
[ROW][C]129[/C][C]9288.22[/C][C]9249.93514792899[/C][C]38.2848520710086[/C][/ROW]
[ROW][C]130[/C][C]8351.32[/C][C]9249.93514792899[/C][C]-898.615147928993[/C][/ROW]
[ROW][C]131[/C][C]8579.56[/C][C]9249.93514792899[/C][C]-670.375147928993[/C][/ROW]
[ROW][C]132[/C][C]13804.41[/C][C]9249.93514792899[/C][C]4554.47485207101[/C][/ROW]
[ROW][C]133[/C][C]7377.9566666667[/C][C]11027.2140196078[/C][C]-3649.25735294114[/C][/ROW]
[ROW][C]134[/C][C]7727.8366666667[/C][C]9249.93514792899[/C][C]-1522.09848126229[/C][/ROW]
[ROW][C]135[/C][C]8735.85[/C][C]9249.93514792899[/C][C]-514.085147928992[/C][/ROW]
[ROW][C]136[/C][C]13327.6533333333[/C][C]11027.2140196078[/C][C]2300.43931372546[/C][/ROW]
[ROW][C]137[/C][C]11056.59[/C][C]11027.2140196078[/C][C]29.3759803921585[/C][/ROW]
[ROW][C]138[/C][C]9115.56[/C][C]11027.2140196078[/C][C]-1911.65401960784[/C][/ROW]
[ROW][C]139[/C][C]12362.59[/C][C]15455.136875[/C][C]-3092.546875[/C][/ROW]
[ROW][C]140[/C][C]18789.55[/C][C]15455.136875[/C][C]3334.413125[/C][/ROW]
[ROW][C]141[/C][C]12557.85[/C][C]11027.2140196078[/C][C]1530.63598039216[/C][/ROW]
[ROW][C]142[/C][C]9958.71[/C][C]11027.2140196078[/C][C]-1068.50401960784[/C][/ROW]
[ROW][C]143[/C][C]14214.23[/C][C]11027.2140196078[/C][C]3187.01598039216[/C][/ROW]
[ROW][C]144[/C][C]11619.05[/C][C]11027.2140196078[/C][C]591.835980392158[/C][/ROW]
[ROW][C]145[/C][C]11351.47[/C][C]11027.2140196078[/C][C]324.255980392158[/C][/ROW]
[ROW][C]146[/C][C]18802.43[/C][C]11027.2140196078[/C][C]7775.21598039216[/C][/ROW]
[ROW][C]147[/C][C]17945.88[/C][C]9249.93514792899[/C][C]8695.944852071[/C][/ROW]
[ROW][C]148[/C][C]10657.04[/C][C]11027.2140196078[/C][C]-370.174019607843[/C][/ROW]
[ROW][C]149[/C][C]16213.12[/C][C]11027.2140196078[/C][C]5185.90598039216[/C][/ROW]
[ROW][C]150[/C][C]9462.53[/C][C]11027.2140196078[/C][C]-1564.68401960784[/C][/ROW]
[ROW][C]151[/C][C]7472.78[/C][C]9249.93514792899[/C][C]-1777.15514792899[/C][/ROW]
[ROW][C]152[/C][C]12839.24[/C][C]15455.136875[/C][C]-2615.896875[/C][/ROW]
[ROW][C]153[/C][C]7485.87[/C][C]9249.93514792899[/C][C]-1764.06514792899[/C][/ROW]
[ROW][C]154[/C][C]13290.13[/C][C]9249.93514792899[/C][C]4040.19485207101[/C][/ROW]
[ROW][C]155[/C][C]393.12[/C][C]9249.93514792899[/C][C]-8856.81514792899[/C][/ROW]
[ROW][C]156[/C][C]4551.83[/C][C]11027.2140196078[/C][C]-6475.38401960784[/C][/ROW]
[ROW][C]157[/C][C]17193.02[/C][C]9249.93514792899[/C][C]7943.08485207101[/C][/ROW]
[ROW][C]158[/C][C]10009.17[/C][C]11027.2140196078[/C][C]-1018.04401960784[/C][/ROW]
[ROW][C]159[/C][C]6195.69[/C][C]9249.93514792899[/C][C]-3054.24514792899[/C][/ROW]
[ROW][C]160[/C][C]24073.53[/C][C]15455.136875[/C][C]8618.393125[/C][/ROW]
[ROW][C]161[/C][C]7659.05[/C][C]9249.93514792899[/C][C]-1590.88514792899[/C][/ROW]
[ROW][C]162[/C][C]13109.34[/C][C]11027.2140196078[/C][C]2082.12598039216[/C][/ROW]
[ROW][C]163[/C][C]13021.66[/C][C]11027.2140196078[/C][C]1994.44598039216[/C][/ROW]
[ROW][C]164[/C][C]6618.49[/C][C]11027.2140196078[/C][C]-4408.72401960784[/C][/ROW]
[ROW][C]165[/C][C]11773.48[/C][C]11027.2140196078[/C][C]746.265980392158[/C][/ROW]
[ROW][C]166[/C][C]18620.94[/C][C]15455.136875[/C][C]3165.803125[/C][/ROW]
[ROW][C]167[/C][C]10339.72[/C][C]11027.2140196078[/C][C]-687.494019607841[/C][/ROW]
[ROW][C]168[/C][C]11423.97[/C][C]11027.2140196078[/C][C]396.755980392158[/C][/ROW]
[ROW][C]169[/C][C]8271.05[/C][C]9249.93514792899[/C][C]-978.885147928993[/C][/ROW]
[ROW][C]170[/C][C]12710.27[/C][C]11027.2140196078[/C][C]1683.05598039216[/C][/ROW]
[ROW][C]171[/C][C]14125.54[/C][C]11027.2140196078[/C][C]3098.32598039216[/C][/ROW]
[ROW][C]172[/C][C]9564.64[/C][C]11027.2140196078[/C][C]-1462.57401960784[/C][/ROW]
[ROW][C]173[/C][C]6136.46[/C][C]11027.2140196078[/C][C]-4890.75401960784[/C][/ROW]
[ROW][C]174[/C][C]7767.91[/C][C]9249.93514792899[/C][C]-1482.02514792899[/C][/ROW]
[ROW][C]175[/C][C]13043.98[/C][C]11027.2140196078[/C][C]2016.76598039216[/C][/ROW]
[ROW][C]176[/C][C]12884.31[/C][C]9249.93514792899[/C][C]3634.37485207101[/C][/ROW]
[ROW][C]177[/C][C]18401.78[/C][C]11027.2140196078[/C][C]7374.56598039216[/C][/ROW]
[ROW][C]178[/C][C]17015.07[/C][C]15455.136875[/C][C]1559.933125[/C][/ROW]
[ROW][C]179[/C][C]11913.11[/C][C]9249.93514792899[/C][C]2663.17485207101[/C][/ROW]
[ROW][C]180[/C][C]25701.67[/C][C]15455.136875[/C][C]10246.533125[/C][/ROW]
[ROW][C]181[/C][C]7601.09[/C][C]11027.2140196078[/C][C]-3426.12401960784[/C][/ROW]
[ROW][C]182[/C][C]12510.82[/C][C]11027.2140196078[/C][C]1483.60598039216[/C][/ROW]
[ROW][C]183[/C][C]10929.1[/C][C]11027.2140196078[/C][C]-98.1140196078413[/C][/ROW]
[ROW][C]184[/C][C]11205.42[/C][C]11027.2140196078[/C][C]178.205980392158[/C][/ROW]
[ROW][C]185[/C][C]16889.56[/C][C]11027.2140196078[/C][C]5862.34598039216[/C][/ROW]
[ROW][C]186[/C][C]11753.2[/C][C]15455.136875[/C][C]-3701.936875[/C][/ROW]
[ROW][C]187[/C][C]11378.53[/C][C]11027.2140196078[/C][C]351.315980392157[/C][/ROW]
[ROW][C]188[/C][C]7912.75[/C][C]9249.93514792899[/C][C]-1337.18514792899[/C][/ROW]
[ROW][C]189[/C][C]9656.56[/C][C]9249.93514792899[/C][C]406.624852071007[/C][/ROW]
[ROW][C]190[/C][C]6899.68[/C][C]9249.93514792899[/C][C]-2350.25514792899[/C][/ROW]
[ROW][C]191[/C][C]9994.28[/C][C]11027.2140196078[/C][C]-1032.93401960784[/C][/ROW]
[ROW][C]192[/C][C]8914.54[/C][C]15455.136875[/C][C]-6540.596875[/C][/ROW]
[ROW][C]193[/C][C]6238.01[/C][C]9249.93514792899[/C][C]-3011.92514792899[/C][/ROW]
[ROW][C]194[/C][C]16230.96[/C][C]11027.2140196078[/C][C]5203.74598039216[/C][/ROW]
[ROW][C]195[/C][C]10035.41[/C][C]9249.93514792899[/C][C]785.474852071007[/C][/ROW]
[ROW][C]196[/C][C]8083.75[/C][C]11027.2140196078[/C][C]-2943.46401960784[/C][/ROW]
[ROW][C]197[/C][C]18126.89[/C][C]11027.2140196078[/C][C]7099.67598039216[/C][/ROW]
[ROW][C]198[/C][C]13696.76[/C][C]11027.2140196078[/C][C]2669.54598039216[/C][/ROW]
[ROW][C]199[/C][C]474.17[/C][C]9249.93514792899[/C][C]-8775.76514792899[/C][/ROW]
[ROW][C]200[/C][C]6179.84[/C][C]11027.2140196078[/C][C]-4847.37401960784[/C][/ROW]
[ROW][C]201[/C][C]7963.97[/C][C]11027.2140196078[/C][C]-3063.24401960784[/C][/ROW]
[ROW][C]202[/C][C]0[/C][C]9249.93514792899[/C][C]-9249.93514792899[/C][/ROW]
[ROW][C]203[/C][C]17394.27[/C][C]11027.2140196078[/C][C]6367.05598039216[/C][/ROW]
[ROW][C]204[/C][C]8975.82[/C][C]9249.93514792899[/C][C]-274.115147928993[/C][/ROW]
[ROW][C]205[/C][C]17338.59[/C][C]9249.93514792899[/C][C]8088.65485207101[/C][/ROW]
[ROW][C]206[/C][C]7967.82[/C][C]9249.93514792899[/C][C]-1282.11514792899[/C][/ROW]
[ROW][C]207[/C][C]11613.87[/C][C]9249.93514792899[/C][C]2363.93485207101[/C][/ROW]
[ROW][C]208[/C][C]7894.85[/C][C]9249.93514792899[/C][C]-1355.08514792899[/C][/ROW]
[ROW][C]209[/C][C]8315.49[/C][C]9249.93514792899[/C][C]-934.445147928993[/C][/ROW]
[ROW][C]210[/C][C]15474.53[/C][C]15455.136875[/C][C]19.3931249999987[/C][/ROW]
[ROW][C]211[/C][C]8821.3[/C][C]11027.2140196078[/C][C]-2205.91401960784[/C][/ROW]
[ROW][C]212[/C][C]11025.41[/C][C]11027.2140196078[/C][C]-1.80401960784184[/C][/ROW]
[ROW][C]213[/C][C]9762.97[/C][C]9249.93514792899[/C][C]513.034852071009[/C][/ROW]
[ROW][C]214[/C][C]12871.94[/C][C]11027.2140196078[/C][C]1844.72598039216[/C][/ROW]
[ROW][C]215[/C][C]10142.82[/C][C]11027.2140196078[/C][C]-884.394019607842[/C][/ROW]
[ROW][C]216[/C][C]10070.77[/C][C]15455.136875[/C][C]-5384.366875[/C][/ROW]
[ROW][C]217[/C][C]16068.91[/C][C]11027.2140196078[/C][C]5041.69598039216[/C][/ROW]
[ROW][C]218[/C][C]11407.43[/C][C]11027.2140196078[/C][C]380.215980392159[/C][/ROW]
[ROW][C]219[/C][C]8652.82[/C][C]11027.2140196078[/C][C]-2374.39401960784[/C][/ROW]
[ROW][C]220[/C][C]17509.51[/C][C]11027.2140196078[/C][C]6482.29598039216[/C][/ROW]
[ROW][C]221[/C][C]7451.38[/C][C]11027.2140196078[/C][C]-3575.83401960784[/C][/ROW]
[ROW][C]222[/C][C]8114.97[/C][C]11027.2140196078[/C][C]-2912.24401960784[/C][/ROW]
[ROW][C]223[/C][C]8409.37[/C][C]11027.2140196078[/C][C]-2617.84401960784[/C][/ROW]
[ROW][C]224[/C][C]9447.65[/C][C]11027.2140196078[/C][C]-1579.56401960784[/C][/ROW]
[ROW][C]225[/C][C]17281.48[/C][C]15455.136875[/C][C]1826.343125[/C][/ROW]
[ROW][C]226[/C][C]5679.41[/C][C]9249.93514792899[/C][C]-3570.52514792899[/C][/ROW]
[ROW][C]227[/C][C]9826.74[/C][C]9249.93514792899[/C][C]576.804852071007[/C][/ROW]
[ROW][C]228[/C][C]11758.49[/C][C]9249.93514792899[/C][C]2508.55485207101[/C][/ROW]
[ROW][C]229[/C][C]3928.27[/C][C]11027.2140196078[/C][C]-7098.94401960784[/C][/ROW]
[ROW][C]230[/C][C]20683.24[/C][C]15455.136875[/C][C]5228.103125[/C][/ROW]
[ROW][C]231[/C][C]6783.19[/C][C]9249.93514792899[/C][C]-2466.74514792899[/C][/ROW]
[ROW][C]232[/C][C]8665.67[/C][C]9249.93514792899[/C][C]-584.265147928993[/C][/ROW]
[ROW][C]233[/C][C]14167.73[/C][C]9249.93514792899[/C][C]4917.79485207101[/C][/ROW]
[ROW][C]234[/C][C]362.34[/C][C]9249.93514792899[/C][C]-8887.59514792899[/C][/ROW]
[ROW][C]235[/C][C]4380.05[/C][C]9249.93514792899[/C][C]-4869.88514792899[/C][/ROW]
[ROW][C]236[/C][C]14235.2[/C][C]9249.93514792899[/C][C]4985.26485207101[/C][/ROW]
[ROW][C]237[/C][C]5643.24[/C][C]9249.93514792899[/C][C]-3606.69514792899[/C][/ROW]
[ROW][C]238[/C][C]14639.78[/C][C]15455.136875[/C][C]-815.356875000001[/C][/ROW]
[ROW][C]239[/C][C]8517.4[/C][C]9249.93514792899[/C][C]-732.535147928993[/C][/ROW]
[ROW][C]240[/C][C]12805.95[/C][C]9249.93514792899[/C][C]3556.01485207101[/C][/ROW]
[ROW][C]241[/C][C]5945.52[/C][C]11027.2140196078[/C][C]-5081.69401960784[/C][/ROW]
[ROW][C]242[/C][C]7642.43[/C][C]9249.93514792899[/C][C]-1607.50514792899[/C][/ROW]
[ROW][C]243[/C][C]19226.29[/C][C]11027.2140196078[/C][C]8199.07598039216[/C][/ROW]
[ROW][C]244[/C][C]13625.03[/C][C]9249.93514792899[/C][C]4375.09485207101[/C][/ROW]
[ROW][C]245[/C][C]8005.46[/C][C]9249.93514792899[/C][C]-1244.47514792899[/C][/ROW]
[ROW][C]246[/C][C]8254.53[/C][C]9249.93514792899[/C][C]-995.405147928994[/C][/ROW]
[ROW][C]247[/C][C]15101.56[/C][C]11027.2140196078[/C][C]4074.34598039216[/C][/ROW]
[ROW][C]248[/C][C]13953.02[/C][C]9249.93514792899[/C][C]4703.08485207101[/C][/ROW]
[ROW][C]249[/C][C]10692.69[/C][C]11027.2140196078[/C][C]-334.524019607843[/C][/ROW]
[ROW][C]250[/C][C]9730.57[/C][C]9249.93514792899[/C][C]480.634852071007[/C][/ROW]
[ROW][C]251[/C][C]12431.05[/C][C]9249.93514792899[/C][C]3181.11485207101[/C][/ROW]
[ROW][C]252[/C][C]10350.38[/C][C]9249.93514792899[/C][C]1100.44485207101[/C][/ROW]
[ROW][C]253[/C][C]7404.66[/C][C]9249.93514792899[/C][C]-1845.27514792899[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=165838&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165838&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
112999.889249.935147928993749.94485207101
211850.3311027.2140196078823.115980392158
310206.059249.93514792899956.114852071007
48807.349249.93514792899-442.595147928992
59098.89249.93514792899-151.135147928993
68801.089249.93514792899-448.855147928993
77366.23666666679249.93514792899-1883.69848126229
87322.39666666679249.93514792899-1927.53848126229
97790.859249.93514792899-1459.08514792899
1010365.69333333339249.935147928991115.75818540431
119269.429249.9351479289919.4848520710075
1213775.449249.935147928994525.50485207101
138914.539249.93514792899-335.405147928992
1410481.3611027.2140196078-545.854019607841
1512143.469249.935147928992893.52485207101
1613140.569249.935147928993890.62485207101
1713116.69249.935147928993866.66485207101
1810017.999249.93514792899768.054852071007
1913943.589249.935147928994693.64485207101
2015979.329249.935147928996729.38485207101
2113148.729249.935147928993898.78485207101
2212586.2511027.21401960781559.03598039216
2310571.643333333311027.2140196078-455.570686274543
249113.659249.93514792899-136.285147928993
259459.96333333339249.93514792899210.028185404308
269283.799249.9351479289933.8548520710083
2712962.269249.935147928993712.32485207101
2812195.049249.935147928992945.10485207101
2911199.99249.935147928991949.96485207101
3013065.019249.935147928993815.07485207101
319125.10333333339249.93514792899-124.831814595693
3213099.819249.935147928993849.87485207101
3312544.589249.935147928993294.64485207101
348530.769249.93514792899-719.175147928992
3512707.79249.935147928993457.76485207101
363369.0911027.2140196078-7658.12401960784
378611.979249.93514792899-637.965147928991
388556.149249.93514792899-693.795147928993
3911010.329249.935147928991760.38485207101
409455.219249.93514792899205.274852071007
419068.059249.93514792899-181.885147928993
4214218.259249.935147928994968.31485207101
439548.629249.93514792899298.684852071006
449731.549249.93514792899481.604852071008
4512258.499249.935147928993008.55485207101
468426.299249.93514792899-823.645147928992
476566.429249.93514792899-2683.51514792899
4810124.619249.93514792899874.674852071008
498364.279249.93514792899-885.665147928992
509150.969249.93514792899-98.9751479289935
519927.429249.93514792899677.484852071007
528705.1911027.2140196078-2322.02401960784
538853.419249.93514792899-396.525147928993
54112249249.935147928991974.06485207101
555123.19249.93514792899-4126.83514792899
565970.4411027.2140196078-5056.77401960784
5710441.139249.935147928991191.19485207101
587707.269249.93514792899-1542.67514792899
5910489.069249.935147928991239.12485207101
6012247.679249.935147928992997.73485207101
616713.049249.93514792899-2536.89514792899
629370.70333333339249.93514792899120.768185404308
638282.819249.93514792899-967.125147928993
648756.09333333339249.93514792899-493.841814595693
6512624.329249.935147928993374.38485207101
668866.34333333339249.93514792899-383.591814595693
676063.619249.93514792899-3186.32514792899
687018.639249.93514792899-2231.30514792899
695517.959249.93514792899-3731.98514792899
709701.819249.93514792899451.874852071007
719810.069249.93514792899560.124852071007
727446.079249.93514792899-1803.86514792899
737954.659249.93514792899-1295.28514792899
746300.79249.93514792899-2949.23514792899
757142.289249.93514792899-2107.65514792899
769202.329249.93514792899-47.6151479289929
775867.799249.93514792899-3382.14514792899
784481.1311027.2140196078-6546.08401960784
7913707.57333333339249.935147928994457.63818540431
809927.519249.93514792899677.574852071008
818741.73666666679249.93514792899-508.198481262292
827095.669249.93514792899-2154.27514792899
839186.739249.93514792899-63.205147928993
848958.799249.93514792899-291.145147928992
855701.569249.93514792899-3548.37514792899
866940.119249.93514792899-2309.82514792899
878452.869249.93514792899-797.075147928992
8813315.12333333339249.935147928994065.18818540431
896301.379249.93514792899-2948.56514792899
905614.499249.93514792899-3635.44514792899
9110239.7811027.2140196078-787.434019607843
927072.19249.93514792899-2177.83514792899
935381.779249.93514792899-3868.16514792899
9410010.069249.93514792899760.124852071007
954844.839249.93514792899-4405.10514792899
967982.69249.93514792899-1267.33514792899
978956.81333333339249.93514792899-293.121814595694
988350.29249.93514792899-899.735147928992
9913201.799249.935147928993951.85485207101
1005350.289249.93514792899-3899.65514792899
1019404.769249.93514792899154.824852071008
1026740.529249.93514792899-2509.41514792899
10311055.219249.935147928991805.27485207101
10410406.849249.935147928991156.90485207101
1056996.919249.93514792899-2253.02514792899
1066239.879249.93514792899-3010.06514792899
1076184.589249.93514792899-3065.35514792899
1087473.55666666679249.93514792899-1776.37848126229
10911568.249249.935147928992318.30485207101
1108569.54666666679249.93514792899-680.388481262293
11111914.489249.935147928992664.54485207101
1126086.449249.93514792899-3163.49514792899
11312749.669249.935147928993499.72485207101
1145384.019249.93514792899-3865.92514792899
11511344.79249.935147928992094.76485207101
1167137.8215455.136875-8317.316875
1177297.289249.93514792899-1952.65514792899
1187294.089249.93514792899-1955.85514792899
1199876.439249.93514792899626.494852071008
1208047.7411027.2140196078-2979.47401960784
1219801.269249.93514792899551.324852071008
12211924.2415455.136875-3530.896875
12313083.549249.935147928993833.60485207101
1248829.97666666679249.93514792899-419.958481262292
1256959.319249.93514792899-2290.62514792899
1269545.519249.93514792899295.574852071008
1278963.52333333339249.93514792899-286.411814595693
1284868.329249.93514792899-4381.61514792899
1299288.229249.9351479289938.2848520710086
1308351.329249.93514792899-898.615147928993
1318579.569249.93514792899-670.375147928993
13213804.419249.935147928994554.47485207101
1337377.956666666711027.2140196078-3649.25735294114
1347727.83666666679249.93514792899-1522.09848126229
1358735.859249.93514792899-514.085147928992
13613327.653333333311027.21401960782300.43931372546
13711056.5911027.214019607829.3759803921585
1389115.5611027.2140196078-1911.65401960784
13912362.5915455.136875-3092.546875
14018789.5515455.1368753334.413125
14112557.8511027.21401960781530.63598039216
1429958.7111027.2140196078-1068.50401960784
14314214.2311027.21401960783187.01598039216
14411619.0511027.2140196078591.835980392158
14511351.4711027.2140196078324.255980392158
14618802.4311027.21401960787775.21598039216
14717945.889249.935147928998695.944852071
14810657.0411027.2140196078-370.174019607843
14916213.1211027.21401960785185.90598039216
1509462.5311027.2140196078-1564.68401960784
1517472.789249.93514792899-1777.15514792899
15212839.2415455.136875-2615.896875
1537485.879249.93514792899-1764.06514792899
15413290.139249.935147928994040.19485207101
155393.129249.93514792899-8856.81514792899
1564551.8311027.2140196078-6475.38401960784
15717193.029249.935147928997943.08485207101
15810009.1711027.2140196078-1018.04401960784
1596195.699249.93514792899-3054.24514792899
16024073.5315455.1368758618.393125
1617659.059249.93514792899-1590.88514792899
16213109.3411027.21401960782082.12598039216
16313021.6611027.21401960781994.44598039216
1646618.4911027.2140196078-4408.72401960784
16511773.4811027.2140196078746.265980392158
16618620.9415455.1368753165.803125
16710339.7211027.2140196078-687.494019607841
16811423.9711027.2140196078396.755980392158
1698271.059249.93514792899-978.885147928993
17012710.2711027.21401960781683.05598039216
17114125.5411027.21401960783098.32598039216
1729564.6411027.2140196078-1462.57401960784
1736136.4611027.2140196078-4890.75401960784
1747767.919249.93514792899-1482.02514792899
17513043.9811027.21401960782016.76598039216
17612884.319249.935147928993634.37485207101
17718401.7811027.21401960787374.56598039216
17817015.0715455.1368751559.933125
17911913.119249.935147928992663.17485207101
18025701.6715455.13687510246.533125
1817601.0911027.2140196078-3426.12401960784
18212510.8211027.21401960781483.60598039216
18310929.111027.2140196078-98.1140196078413
18411205.4211027.2140196078178.205980392158
18516889.5611027.21401960785862.34598039216
18611753.215455.136875-3701.936875
18711378.5311027.2140196078351.315980392157
1887912.759249.93514792899-1337.18514792899
1899656.569249.93514792899406.624852071007
1906899.689249.93514792899-2350.25514792899
1919994.2811027.2140196078-1032.93401960784
1928914.5415455.136875-6540.596875
1936238.019249.93514792899-3011.92514792899
19416230.9611027.21401960785203.74598039216
19510035.419249.93514792899785.474852071007
1968083.7511027.2140196078-2943.46401960784
19718126.8911027.21401960787099.67598039216
19813696.7611027.21401960782669.54598039216
199474.179249.93514792899-8775.76514792899
2006179.8411027.2140196078-4847.37401960784
2017963.9711027.2140196078-3063.24401960784
20209249.93514792899-9249.93514792899
20317394.2711027.21401960786367.05598039216
2048975.829249.93514792899-274.115147928993
20517338.599249.935147928998088.65485207101
2067967.829249.93514792899-1282.11514792899
20711613.879249.935147928992363.93485207101
2087894.859249.93514792899-1355.08514792899
2098315.499249.93514792899-934.445147928993
21015474.5315455.13687519.3931249999987
2118821.311027.2140196078-2205.91401960784
21211025.4111027.2140196078-1.80401960784184
2139762.979249.93514792899513.034852071009
21412871.9411027.21401960781844.72598039216
21510142.8211027.2140196078-884.394019607842
21610070.7715455.136875-5384.366875
21716068.9111027.21401960785041.69598039216
21811407.4311027.2140196078380.215980392159
2198652.8211027.2140196078-2374.39401960784
22017509.5111027.21401960786482.29598039216
2217451.3811027.2140196078-3575.83401960784
2228114.9711027.2140196078-2912.24401960784
2238409.3711027.2140196078-2617.84401960784
2249447.6511027.2140196078-1579.56401960784
22517281.4815455.1368751826.343125
2265679.419249.93514792899-3570.52514792899
2279826.749249.93514792899576.804852071007
22811758.499249.935147928992508.55485207101
2293928.2711027.2140196078-7098.94401960784
23020683.2415455.1368755228.103125
2316783.199249.93514792899-2466.74514792899
2328665.679249.93514792899-584.265147928993
23314167.739249.935147928994917.79485207101
234362.349249.93514792899-8887.59514792899
2354380.059249.93514792899-4869.88514792899
23614235.29249.935147928994985.26485207101
2375643.249249.93514792899-3606.69514792899
23814639.7815455.136875-815.356875000001
2398517.49249.93514792899-732.535147928993
24012805.959249.935147928993556.01485207101
2415945.5211027.2140196078-5081.69401960784
2427642.439249.93514792899-1607.50514792899
24319226.2911027.21401960788199.07598039216
24413625.039249.935147928994375.09485207101
2458005.469249.93514792899-1244.47514792899
2468254.539249.93514792899-995.405147928994
24715101.5611027.21401960784074.34598039216
24813953.029249.935147928994703.08485207101
24910692.6911027.2140196078-334.524019607843
2509730.579249.93514792899480.634852071007
25112431.059249.935147928993181.11485207101
25210350.389249.935147928991100.44485207101
2537404.669249.93514792899-1845.27514792899



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