Free Statistics

of Irreproducible Research!

Author's title

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

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact90
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [] [2012-04-30 16:34:06] [050dc696fa22882d0c3b1ebe5a70a85e] [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 time5 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 & 5 seconds \tabularnewline
R Server & 'Gertrude Mary Cox' @ cox.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=165313&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]5 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=165313&T=0

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







Goodness of Fit
Correlation0.2089
R-squared0.0436
RMSE3062.7694

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

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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165313&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.2089
R-squared0.0436
RMSE3062.7694







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
16704.739279.11738461538-2574.38738461538
27365.29279.11738461538-1913.91738461538
39735.739279.11738461538456.612615384616
45123.19279.11738461538-4156.01738461538
511423.867538.442166666673885.41783333333
68446.739279.11738461538-832.387384615384
75970.449279.11738461538-3308.67738461538
810441.139279.117384615381162.01261538462
98115.679279.11738461538-1163.44738461538
107707.267538.44216666667168.817833333333
117432.149279.11738461538-1846.97738461538
128028.26333333339279.11738461538-1250.85405128208
138106.13333333337538.44216666667567.691166666633
1410489.069279.117384615381209.94261538462
157122.579279.11738461538-2156.54738461538
166550.887538.44216666667-987.562166666668
1712247.679279.117384615382968.55261538462
186713.049279.11738461538-2566.07738461538
197519.279279.11738461538-1759.84738461538
205721.459279.11738461538-3557.66738461538
217941.549279.11738461538-1337.57738461538
226734.77538.44216666667-803.742166666668
239659.927538.442166666672121.47783333333
2410472.949279.117384615381193.82261538462
259370.70333333339279.1173846153891.5859487179168
268282.819279.11738461538-996.307384615384
278756.09333333339279.11738461538-523.024051282084
287171.577538.44216666667-366.872166666668
296905.97538.44216666667-632.542166666668
306411.97538.44216666667-1126.54216666667
3112624.329279.117384615383345.20261538462
328866.34333333339279.11738461538-412.774051282084
334046.337538.44216666667-3492.11216666667
346063.617538.44216666667-1474.83216666667
357018.639279.11738461538-2260.48738461538
364520.679279.11738461538-4758.44738461538
378171.449279.11738461538-1107.67738461538
385517.957538.44216666667-2020.49216666667
399701.819279.11738461538422.692615384616
407045.037538.44216666667-493.412166666667
419810.069279.11738461538530.942615384616
427446.079279.11738461538-1833.04738461538
437954.659279.11738461538-1324.46738461538
446300.79279.11738461538-2978.41738461538
457142.289279.11738461538-2136.83738461538
467138.59279.11738461538-2140.61738461538
479202.329279.11738461538-76.7973846153836
485867.799279.11738461538-3411.32738461538
494481.139279.11738461538-4797.98738461538
503540.177538.44216666667-3998.27216666667
5113707.57333333339279.117384615384428.45594871792
529927.519279.11738461538648.392615384617
5312068.399279.117384615382789.27261538462
548741.73666666679279.11738461538-537.380717948683
556796.879279.11738461538-2482.24738461538
569300.499279.1173846153821.3726153846164
577095.669279.11738461538-2183.45738461538
589186.739279.11738461538-92.3873846153838
598958.797538.442166666671420.34783333333
605701.569279.11738461538-3577.55738461538
616940.117538.44216666667-598.332166666668
628452.869279.11738461538-826.257384615383
6313315.12333333339279.117384615384036.00594871792
646301.379279.11738461538-2977.74738461538
655614.499279.11738461538-3664.62738461538
6610239.789279.11738461538960.662615384615
677072.19279.11738461538-2207.01738461538
685381.779279.11738461538-3897.34738461538
6910010.069279.11738461538730.942615384616
704844.839279.11738461538-4434.28738461538
719678.679279.11738461538399.552615384617
727982.67538.44216666667444.157833333333
7310139.589279.11738461538860.462615384617
749533.689279.11738461538254.562615384617
759268.459279.11738461538-10.6673846153826
765769.629279.11738461538-3509.49738461538
775108.879279.11738461538-4170.24738461538
788956.81333333339279.11738461538-322.304051282084
798350.29279.11738461538-928.917384615383
8013201.799279.117384615383922.67261538462
815350.289279.11738461538-3928.83738461538
829521.079279.11738461538241.952615384616
836015.89279.11738461538-3263.31738461538
847660.529279.11738461538-1618.59738461538
857290.237538.44216666667-248.212166666668
869404.767538.442166666671866.31783333333
879303.939279.1173846153824.8126153846169
8811055.219279.117384615381776.09261538462
8910406.849279.117384615381127.72261538462
906996.919279.11738461538-2282.20738461538
919820.999279.11738461538541.872615384616
926184.587538.44216666667-1353.86216666667
937473.55666666677538.44216666667-64.8854999999676
946982.569279.11738461538-2296.55738461538
956696.297538.44216666667-842.152166666668
968569.54666666679279.11738461538-709.570717948684
9711914.489279.117384615382635.36261538462
986086.447538.44216666667-1452.00216666667
999784.529279.11738461538505.402615384617
1007368.027538.44216666667-170.422166666667
1018711.659279.11738461538-567.467384615384
1025384.019279.11738461538-3895.10738461538
10311344.79279.117384615382065.58261538462
1047137.829279.11738461538-2141.29738461538
1058736.027538.442166666671197.57783333333
1067297.289279.11738461538-1981.83738461538
10712375.849279.117384615383096.72261538462
1087294.089279.11738461538-1985.03738461538
1099876.439279.11738461538597.312615384617
1108047.749279.11738461538-1231.37738461538
1119801.269279.11738461538522.142615384617
11213022.319279.117384615383743.19261538462
11311924.249279.117384615382645.12261538462
1149815.39279.11738461538536.182615384616
1158057.837538.44216666667519.387833333332
1166213.89279.11738461538-3065.31738461538
1179314.649279.1173846153835.5226153846161
11811078.199279.117384615381799.07261538462
1198829.97666666677538.442166666671291.53450000003
1209024.679279.11738461538-254.447384615383
1216959.319279.11738461538-2319.80738461538
1229545.519279.11738461538266.392615384617
1238963.52333333339279.11738461538-315.594051282083
1244868.329279.11738461538-4410.79738461538
1259288.229279.117384615389.10261538461782
1268351.329279.11738461538-927.797384615384
1278579.569279.11738461538-699.557384615384
1288439.69279.11738461538-839.517384615383
1296591.219279.11738461538-2687.90738461538
1306619.79279.11738461538-2659.41738461538
1318972.96333333339279.11738461538-306.154051282083
1326410.887538.44216666667-1127.56216666667
1338098.29279.11738461538-1180.91738461538
1347377.95666666679279.11738461538-1901.16071794868
1357727.83666666679279.11738461538-1551.28071794868
1366317.429279.11738461538-2961.69738461538
1378735.859279.11738461538-543.267384615383
13813327.65333333339279.117384615384048.53594871792
13917394.277538.442166666679855.82783333333
14014159.919279.117384615384880.79261538462
1418975.829279.11738461538-303.297384615384
1427360.029279.11738461538-1919.09738461538
1439096.537538.442166666671558.08783333333
14413043.269279.117384615383764.14261538462
14517338.599279.117384615388059.47261538462
1468228.399279.11738461538-1050.72738461538
1477967.829279.11738461538-1311.29738461538
14811613.879279.117384615382334.75261538462
14911392.949279.117384615382113.82261538462
15014565.629279.117384615385286.50261538462
1516399.887538.44216666667-1138.56216666667
1527894.859279.11738461538-1384.26738461538
1538315.499279.11738461538-963.627384615384
15415474.539279.117384615386195.41261538462
15515740.789279.117384615386461.66261538462
1568821.39279.11738461538-457.817384615384
1579649.989279.11738461538370.862615384616
15812950.099279.117384615383670.97261538462
15911025.419279.117384615381746.29261538462
1609762.979279.11738461538483.852615384618
16110007.327538.442166666672468.87783333333
16214456.699279.117384615385177.57261538462
163312.329279.11738461538-8966.79738461538
1648000.239279.11738461538-1278.88738461538
16512871.949279.117384615383592.82261538462
16612670.059279.117384615383390.93261538462
16710142.829279.11738461538863.702615384616
16810443.829279.117384615381164.70261538462
16910070.779279.11738461538791.652615384617
17012364.379279.117384615383085.25261538462
1717685.119279.11738461538-1594.00738461538
17216068.919279.117384615386789.79261538462
17311407.439279.117384615382128.31261538462
1744260.967538.44216666667-3277.48216666667
1754263.659279.11738461538-5015.46738461538
1768652.829279.11738461538-626.297384615384
1779808.169279.11738461538529.042615384617
1786106.869279.11738461538-3172.25738461538
1799756.579279.11738461538477.452615384616
18017509.519279.117384615388230.39261538462
1817451.389279.11738461538-1827.73738461538
1828409.379279.11738461538-869.747384615384
1837559.889279.11738461538-1719.23738461538
18494809279.11738461538200.882615384617
1859447.659279.11738461538168.532615384616
18610012.887538.442166666672474.43783333333
18714942.569279.117384615385663.44261538462
1885679.417538.44216666667-1859.03216666667
18910118.759279.11738461538839.632615384617
1909826.749279.11738461538547.622615384616
19111758.499279.117384615382479.37261538462
1929503.119279.11738461538223.992615384617
1933928.279279.11738461538-5350.84738461538
1949389.239279.11738461538110.112615384616
19520683.249279.1173846153811404.1226153846
1966783.197538.44216666667-755.252166666667
1972078.37538.44216666667-5460.14216666667
1988665.679279.11738461538-613.447384615383
19914167.739279.117384615384888.61261538462
20011099.229279.117384615381820.10261538462
20112040.957538.442166666674502.50783333333
2027242.249279.11738461538-2036.87738461538
20319323.439279.1173846153810044.3126153846
20414235.29279.117384615384956.08261538462
2055643.249279.11738461538-3635.87738461538
2063626.599279.11738461538-5652.52738461538
20714639.789279.117384615385360.66261538462
208906.049279.11738461538-8373.07738461538
2094100.639279.11738461538-5178.48738461538
21014625.779279.117384615385346.65261538462
2116894.789279.11738461538-2384.33738461538
21212805.959279.117384615383526.83261538462
2137642.439279.11738461538-1636.68738461538
2148562.897538.442166666671024.44783333333
2158514.399279.11738461538-764.727384615384
21619226.299279.117384615389947.17261538462
2175641.349279.11738461538-3637.77738461538
2188592.59279.11738461538-686.617384615383
21913625.039279.117384615384345.91261538462
2208005.469279.11738461538-1273.65738461538
22115285.889279.117384615386006.76261538462
22210996.049279.117384615381716.92261538462
2238228.679279.11738461538-1050.44738461538
2247955.029279.11738461538-1324.09738461538
2257690.879279.11738461538-1588.24738461538
2268254.539279.11738461538-1024.58738461538
22713953.029279.117384615384673.90261538462
22813104.859279.117384615383825.73261538462
2295915.817538.44216666667-1622.63216666667
2305504.239279.11738461538-3774.88738461538
2319730.579279.11738461538451.452615384616
23212431.059279.117384615383151.93261538462
23310350.389279.117384615381071.26261538462
2348117.739279.11738461538-1161.38738461538
2357404.669279.11738461538-1874.45738461538

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 6704.73 & 9279.11738461538 & -2574.38738461538 \tabularnewline
2 & 7365.2 & 9279.11738461538 & -1913.91738461538 \tabularnewline
3 & 9735.73 & 9279.11738461538 & 456.612615384616 \tabularnewline
4 & 5123.1 & 9279.11738461538 & -4156.01738461538 \tabularnewline
5 & 11423.86 & 7538.44216666667 & 3885.41783333333 \tabularnewline
6 & 8446.73 & 9279.11738461538 & -832.387384615384 \tabularnewline
7 & 5970.44 & 9279.11738461538 & -3308.67738461538 \tabularnewline
8 & 10441.13 & 9279.11738461538 & 1162.01261538462 \tabularnewline
9 & 8115.67 & 9279.11738461538 & -1163.44738461538 \tabularnewline
10 & 7707.26 & 7538.44216666667 & 168.817833333333 \tabularnewline
11 & 7432.14 & 9279.11738461538 & -1846.97738461538 \tabularnewline
12 & 8028.2633333333 & 9279.11738461538 & -1250.85405128208 \tabularnewline
13 & 8106.1333333333 & 7538.44216666667 & 567.691166666633 \tabularnewline
14 & 10489.06 & 9279.11738461538 & 1209.94261538462 \tabularnewline
15 & 7122.57 & 9279.11738461538 & -2156.54738461538 \tabularnewline
16 & 6550.88 & 7538.44216666667 & -987.562166666668 \tabularnewline
17 & 12247.67 & 9279.11738461538 & 2968.55261538462 \tabularnewline
18 & 6713.04 & 9279.11738461538 & -2566.07738461538 \tabularnewline
19 & 7519.27 & 9279.11738461538 & -1759.84738461538 \tabularnewline
20 & 5721.45 & 9279.11738461538 & -3557.66738461538 \tabularnewline
21 & 7941.54 & 9279.11738461538 & -1337.57738461538 \tabularnewline
22 & 6734.7 & 7538.44216666667 & -803.742166666668 \tabularnewline
23 & 9659.92 & 7538.44216666667 & 2121.47783333333 \tabularnewline
24 & 10472.94 & 9279.11738461538 & 1193.82261538462 \tabularnewline
25 & 9370.7033333333 & 9279.11738461538 & 91.5859487179168 \tabularnewline
26 & 8282.81 & 9279.11738461538 & -996.307384615384 \tabularnewline
27 & 8756.0933333333 & 9279.11738461538 & -523.024051282084 \tabularnewline
28 & 7171.57 & 7538.44216666667 & -366.872166666668 \tabularnewline
29 & 6905.9 & 7538.44216666667 & -632.542166666668 \tabularnewline
30 & 6411.9 & 7538.44216666667 & -1126.54216666667 \tabularnewline
31 & 12624.32 & 9279.11738461538 & 3345.20261538462 \tabularnewline
32 & 8866.3433333333 & 9279.11738461538 & -412.774051282084 \tabularnewline
33 & 4046.33 & 7538.44216666667 & -3492.11216666667 \tabularnewline
34 & 6063.61 & 7538.44216666667 & -1474.83216666667 \tabularnewline
35 & 7018.63 & 9279.11738461538 & -2260.48738461538 \tabularnewline
36 & 4520.67 & 9279.11738461538 & -4758.44738461538 \tabularnewline
37 & 8171.44 & 9279.11738461538 & -1107.67738461538 \tabularnewline
38 & 5517.95 & 7538.44216666667 & -2020.49216666667 \tabularnewline
39 & 9701.81 & 9279.11738461538 & 422.692615384616 \tabularnewline
40 & 7045.03 & 7538.44216666667 & -493.412166666667 \tabularnewline
41 & 9810.06 & 9279.11738461538 & 530.942615384616 \tabularnewline
42 & 7446.07 & 9279.11738461538 & -1833.04738461538 \tabularnewline
43 & 7954.65 & 9279.11738461538 & -1324.46738461538 \tabularnewline
44 & 6300.7 & 9279.11738461538 & -2978.41738461538 \tabularnewline
45 & 7142.28 & 9279.11738461538 & -2136.83738461538 \tabularnewline
46 & 7138.5 & 9279.11738461538 & -2140.61738461538 \tabularnewline
47 & 9202.32 & 9279.11738461538 & -76.7973846153836 \tabularnewline
48 & 5867.79 & 9279.11738461538 & -3411.32738461538 \tabularnewline
49 & 4481.13 & 9279.11738461538 & -4797.98738461538 \tabularnewline
50 & 3540.17 & 7538.44216666667 & -3998.27216666667 \tabularnewline
51 & 13707.5733333333 & 9279.11738461538 & 4428.45594871792 \tabularnewline
52 & 9927.51 & 9279.11738461538 & 648.392615384617 \tabularnewline
53 & 12068.39 & 9279.11738461538 & 2789.27261538462 \tabularnewline
54 & 8741.7366666667 & 9279.11738461538 & -537.380717948683 \tabularnewline
55 & 6796.87 & 9279.11738461538 & -2482.24738461538 \tabularnewline
56 & 9300.49 & 9279.11738461538 & 21.3726153846164 \tabularnewline
57 & 7095.66 & 9279.11738461538 & -2183.45738461538 \tabularnewline
58 & 9186.73 & 9279.11738461538 & -92.3873846153838 \tabularnewline
59 & 8958.79 & 7538.44216666667 & 1420.34783333333 \tabularnewline
60 & 5701.56 & 9279.11738461538 & -3577.55738461538 \tabularnewline
61 & 6940.11 & 7538.44216666667 & -598.332166666668 \tabularnewline
62 & 8452.86 & 9279.11738461538 & -826.257384615383 \tabularnewline
63 & 13315.1233333333 & 9279.11738461538 & 4036.00594871792 \tabularnewline
64 & 6301.37 & 9279.11738461538 & -2977.74738461538 \tabularnewline
65 & 5614.49 & 9279.11738461538 & -3664.62738461538 \tabularnewline
66 & 10239.78 & 9279.11738461538 & 960.662615384615 \tabularnewline
67 & 7072.1 & 9279.11738461538 & -2207.01738461538 \tabularnewline
68 & 5381.77 & 9279.11738461538 & -3897.34738461538 \tabularnewline
69 & 10010.06 & 9279.11738461538 & 730.942615384616 \tabularnewline
70 & 4844.83 & 9279.11738461538 & -4434.28738461538 \tabularnewline
71 & 9678.67 & 9279.11738461538 & 399.552615384617 \tabularnewline
72 & 7982.6 & 7538.44216666667 & 444.157833333333 \tabularnewline
73 & 10139.58 & 9279.11738461538 & 860.462615384617 \tabularnewline
74 & 9533.68 & 9279.11738461538 & 254.562615384617 \tabularnewline
75 & 9268.45 & 9279.11738461538 & -10.6673846153826 \tabularnewline
76 & 5769.62 & 9279.11738461538 & -3509.49738461538 \tabularnewline
77 & 5108.87 & 9279.11738461538 & -4170.24738461538 \tabularnewline
78 & 8956.8133333333 & 9279.11738461538 & -322.304051282084 \tabularnewline
79 & 8350.2 & 9279.11738461538 & -928.917384615383 \tabularnewline
80 & 13201.79 & 9279.11738461538 & 3922.67261538462 \tabularnewline
81 & 5350.28 & 9279.11738461538 & -3928.83738461538 \tabularnewline
82 & 9521.07 & 9279.11738461538 & 241.952615384616 \tabularnewline
83 & 6015.8 & 9279.11738461538 & -3263.31738461538 \tabularnewline
84 & 7660.52 & 9279.11738461538 & -1618.59738461538 \tabularnewline
85 & 7290.23 & 7538.44216666667 & -248.212166666668 \tabularnewline
86 & 9404.76 & 7538.44216666667 & 1866.31783333333 \tabularnewline
87 & 9303.93 & 9279.11738461538 & 24.8126153846169 \tabularnewline
88 & 11055.21 & 9279.11738461538 & 1776.09261538462 \tabularnewline
89 & 10406.84 & 9279.11738461538 & 1127.72261538462 \tabularnewline
90 & 6996.91 & 9279.11738461538 & -2282.20738461538 \tabularnewline
91 & 9820.99 & 9279.11738461538 & 541.872615384616 \tabularnewline
92 & 6184.58 & 7538.44216666667 & -1353.86216666667 \tabularnewline
93 & 7473.5566666667 & 7538.44216666667 & -64.8854999999676 \tabularnewline
94 & 6982.56 & 9279.11738461538 & -2296.55738461538 \tabularnewline
95 & 6696.29 & 7538.44216666667 & -842.152166666668 \tabularnewline
96 & 8569.5466666667 & 9279.11738461538 & -709.570717948684 \tabularnewline
97 & 11914.48 & 9279.11738461538 & 2635.36261538462 \tabularnewline
98 & 6086.44 & 7538.44216666667 & -1452.00216666667 \tabularnewline
99 & 9784.52 & 9279.11738461538 & 505.402615384617 \tabularnewline
100 & 7368.02 & 7538.44216666667 & -170.422166666667 \tabularnewline
101 & 8711.65 & 9279.11738461538 & -567.467384615384 \tabularnewline
102 & 5384.01 & 9279.11738461538 & -3895.10738461538 \tabularnewline
103 & 11344.7 & 9279.11738461538 & 2065.58261538462 \tabularnewline
104 & 7137.82 & 9279.11738461538 & -2141.29738461538 \tabularnewline
105 & 8736.02 & 7538.44216666667 & 1197.57783333333 \tabularnewline
106 & 7297.28 & 9279.11738461538 & -1981.83738461538 \tabularnewline
107 & 12375.84 & 9279.11738461538 & 3096.72261538462 \tabularnewline
108 & 7294.08 & 9279.11738461538 & -1985.03738461538 \tabularnewline
109 & 9876.43 & 9279.11738461538 & 597.312615384617 \tabularnewline
110 & 8047.74 & 9279.11738461538 & -1231.37738461538 \tabularnewline
111 & 9801.26 & 9279.11738461538 & 522.142615384617 \tabularnewline
112 & 13022.31 & 9279.11738461538 & 3743.19261538462 \tabularnewline
113 & 11924.24 & 9279.11738461538 & 2645.12261538462 \tabularnewline
114 & 9815.3 & 9279.11738461538 & 536.182615384616 \tabularnewline
115 & 8057.83 & 7538.44216666667 & 519.387833333332 \tabularnewline
116 & 6213.8 & 9279.11738461538 & -3065.31738461538 \tabularnewline
117 & 9314.64 & 9279.11738461538 & 35.5226153846161 \tabularnewline
118 & 11078.19 & 9279.11738461538 & 1799.07261538462 \tabularnewline
119 & 8829.9766666667 & 7538.44216666667 & 1291.53450000003 \tabularnewline
120 & 9024.67 & 9279.11738461538 & -254.447384615383 \tabularnewline
121 & 6959.31 & 9279.11738461538 & -2319.80738461538 \tabularnewline
122 & 9545.51 & 9279.11738461538 & 266.392615384617 \tabularnewline
123 & 8963.5233333333 & 9279.11738461538 & -315.594051282083 \tabularnewline
124 & 4868.32 & 9279.11738461538 & -4410.79738461538 \tabularnewline
125 & 9288.22 & 9279.11738461538 & 9.10261538461782 \tabularnewline
126 & 8351.32 & 9279.11738461538 & -927.797384615384 \tabularnewline
127 & 8579.56 & 9279.11738461538 & -699.557384615384 \tabularnewline
128 & 8439.6 & 9279.11738461538 & -839.517384615383 \tabularnewline
129 & 6591.21 & 9279.11738461538 & -2687.90738461538 \tabularnewline
130 & 6619.7 & 9279.11738461538 & -2659.41738461538 \tabularnewline
131 & 8972.9633333333 & 9279.11738461538 & -306.154051282083 \tabularnewline
132 & 6410.88 & 7538.44216666667 & -1127.56216666667 \tabularnewline
133 & 8098.2 & 9279.11738461538 & -1180.91738461538 \tabularnewline
134 & 7377.9566666667 & 9279.11738461538 & -1901.16071794868 \tabularnewline
135 & 7727.8366666667 & 9279.11738461538 & -1551.28071794868 \tabularnewline
136 & 6317.42 & 9279.11738461538 & -2961.69738461538 \tabularnewline
137 & 8735.85 & 9279.11738461538 & -543.267384615383 \tabularnewline
138 & 13327.6533333333 & 9279.11738461538 & 4048.53594871792 \tabularnewline
139 & 17394.27 & 7538.44216666667 & 9855.82783333333 \tabularnewline
140 & 14159.91 & 9279.11738461538 & 4880.79261538462 \tabularnewline
141 & 8975.82 & 9279.11738461538 & -303.297384615384 \tabularnewline
142 & 7360.02 & 9279.11738461538 & -1919.09738461538 \tabularnewline
143 & 9096.53 & 7538.44216666667 & 1558.08783333333 \tabularnewline
144 & 13043.26 & 9279.11738461538 & 3764.14261538462 \tabularnewline
145 & 17338.59 & 9279.11738461538 & 8059.47261538462 \tabularnewline
146 & 8228.39 & 9279.11738461538 & -1050.72738461538 \tabularnewline
147 & 7967.82 & 9279.11738461538 & -1311.29738461538 \tabularnewline
148 & 11613.87 & 9279.11738461538 & 2334.75261538462 \tabularnewline
149 & 11392.94 & 9279.11738461538 & 2113.82261538462 \tabularnewline
150 & 14565.62 & 9279.11738461538 & 5286.50261538462 \tabularnewline
151 & 6399.88 & 7538.44216666667 & -1138.56216666667 \tabularnewline
152 & 7894.85 & 9279.11738461538 & -1384.26738461538 \tabularnewline
153 & 8315.49 & 9279.11738461538 & -963.627384615384 \tabularnewline
154 & 15474.53 & 9279.11738461538 & 6195.41261538462 \tabularnewline
155 & 15740.78 & 9279.11738461538 & 6461.66261538462 \tabularnewline
156 & 8821.3 & 9279.11738461538 & -457.817384615384 \tabularnewline
157 & 9649.98 & 9279.11738461538 & 370.862615384616 \tabularnewline
158 & 12950.09 & 9279.11738461538 & 3670.97261538462 \tabularnewline
159 & 11025.41 & 9279.11738461538 & 1746.29261538462 \tabularnewline
160 & 9762.97 & 9279.11738461538 & 483.852615384618 \tabularnewline
161 & 10007.32 & 7538.44216666667 & 2468.87783333333 \tabularnewline
162 & 14456.69 & 9279.11738461538 & 5177.57261538462 \tabularnewline
163 & 312.32 & 9279.11738461538 & -8966.79738461538 \tabularnewline
164 & 8000.23 & 9279.11738461538 & -1278.88738461538 \tabularnewline
165 & 12871.94 & 9279.11738461538 & 3592.82261538462 \tabularnewline
166 & 12670.05 & 9279.11738461538 & 3390.93261538462 \tabularnewline
167 & 10142.82 & 9279.11738461538 & 863.702615384616 \tabularnewline
168 & 10443.82 & 9279.11738461538 & 1164.70261538462 \tabularnewline
169 & 10070.77 & 9279.11738461538 & 791.652615384617 \tabularnewline
170 & 12364.37 & 9279.11738461538 & 3085.25261538462 \tabularnewline
171 & 7685.11 & 9279.11738461538 & -1594.00738461538 \tabularnewline
172 & 16068.91 & 9279.11738461538 & 6789.79261538462 \tabularnewline
173 & 11407.43 & 9279.11738461538 & 2128.31261538462 \tabularnewline
174 & 4260.96 & 7538.44216666667 & -3277.48216666667 \tabularnewline
175 & 4263.65 & 9279.11738461538 & -5015.46738461538 \tabularnewline
176 & 8652.82 & 9279.11738461538 & -626.297384615384 \tabularnewline
177 & 9808.16 & 9279.11738461538 & 529.042615384617 \tabularnewline
178 & 6106.86 & 9279.11738461538 & -3172.25738461538 \tabularnewline
179 & 9756.57 & 9279.11738461538 & 477.452615384616 \tabularnewline
180 & 17509.51 & 9279.11738461538 & 8230.39261538462 \tabularnewline
181 & 7451.38 & 9279.11738461538 & -1827.73738461538 \tabularnewline
182 & 8409.37 & 9279.11738461538 & -869.747384615384 \tabularnewline
183 & 7559.88 & 9279.11738461538 & -1719.23738461538 \tabularnewline
184 & 9480 & 9279.11738461538 & 200.882615384617 \tabularnewline
185 & 9447.65 & 9279.11738461538 & 168.532615384616 \tabularnewline
186 & 10012.88 & 7538.44216666667 & 2474.43783333333 \tabularnewline
187 & 14942.56 & 9279.11738461538 & 5663.44261538462 \tabularnewline
188 & 5679.41 & 7538.44216666667 & -1859.03216666667 \tabularnewline
189 & 10118.75 & 9279.11738461538 & 839.632615384617 \tabularnewline
190 & 9826.74 & 9279.11738461538 & 547.622615384616 \tabularnewline
191 & 11758.49 & 9279.11738461538 & 2479.37261538462 \tabularnewline
192 & 9503.11 & 9279.11738461538 & 223.992615384617 \tabularnewline
193 & 3928.27 & 9279.11738461538 & -5350.84738461538 \tabularnewline
194 & 9389.23 & 9279.11738461538 & 110.112615384616 \tabularnewline
195 & 20683.24 & 9279.11738461538 & 11404.1226153846 \tabularnewline
196 & 6783.19 & 7538.44216666667 & -755.252166666667 \tabularnewline
197 & 2078.3 & 7538.44216666667 & -5460.14216666667 \tabularnewline
198 & 8665.67 & 9279.11738461538 & -613.447384615383 \tabularnewline
199 & 14167.73 & 9279.11738461538 & 4888.61261538462 \tabularnewline
200 & 11099.22 & 9279.11738461538 & 1820.10261538462 \tabularnewline
201 & 12040.95 & 7538.44216666667 & 4502.50783333333 \tabularnewline
202 & 7242.24 & 9279.11738461538 & -2036.87738461538 \tabularnewline
203 & 19323.43 & 9279.11738461538 & 10044.3126153846 \tabularnewline
204 & 14235.2 & 9279.11738461538 & 4956.08261538462 \tabularnewline
205 & 5643.24 & 9279.11738461538 & -3635.87738461538 \tabularnewline
206 & 3626.59 & 9279.11738461538 & -5652.52738461538 \tabularnewline
207 & 14639.78 & 9279.11738461538 & 5360.66261538462 \tabularnewline
208 & 906.04 & 9279.11738461538 & -8373.07738461538 \tabularnewline
209 & 4100.63 & 9279.11738461538 & -5178.48738461538 \tabularnewline
210 & 14625.77 & 9279.11738461538 & 5346.65261538462 \tabularnewline
211 & 6894.78 & 9279.11738461538 & -2384.33738461538 \tabularnewline
212 & 12805.95 & 9279.11738461538 & 3526.83261538462 \tabularnewline
213 & 7642.43 & 9279.11738461538 & -1636.68738461538 \tabularnewline
214 & 8562.89 & 7538.44216666667 & 1024.44783333333 \tabularnewline
215 & 8514.39 & 9279.11738461538 & -764.727384615384 \tabularnewline
216 & 19226.29 & 9279.11738461538 & 9947.17261538462 \tabularnewline
217 & 5641.34 & 9279.11738461538 & -3637.77738461538 \tabularnewline
218 & 8592.5 & 9279.11738461538 & -686.617384615383 \tabularnewline
219 & 13625.03 & 9279.11738461538 & 4345.91261538462 \tabularnewline
220 & 8005.46 & 9279.11738461538 & -1273.65738461538 \tabularnewline
221 & 15285.88 & 9279.11738461538 & 6006.76261538462 \tabularnewline
222 & 10996.04 & 9279.11738461538 & 1716.92261538462 \tabularnewline
223 & 8228.67 & 9279.11738461538 & -1050.44738461538 \tabularnewline
224 & 7955.02 & 9279.11738461538 & -1324.09738461538 \tabularnewline
225 & 7690.87 & 9279.11738461538 & -1588.24738461538 \tabularnewline
226 & 8254.53 & 9279.11738461538 & -1024.58738461538 \tabularnewline
227 & 13953.02 & 9279.11738461538 & 4673.90261538462 \tabularnewline
228 & 13104.85 & 9279.11738461538 & 3825.73261538462 \tabularnewline
229 & 5915.81 & 7538.44216666667 & -1622.63216666667 \tabularnewline
230 & 5504.23 & 9279.11738461538 & -3774.88738461538 \tabularnewline
231 & 9730.57 & 9279.11738461538 & 451.452615384616 \tabularnewline
232 & 12431.05 & 9279.11738461538 & 3151.93261538462 \tabularnewline
233 & 10350.38 & 9279.11738461538 & 1071.26261538462 \tabularnewline
234 & 8117.73 & 9279.11738461538 & -1161.38738461538 \tabularnewline
235 & 7404.66 & 9279.11738461538 & -1874.45738461538 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=165313&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]6704.73[/C][C]9279.11738461538[/C][C]-2574.38738461538[/C][/ROW]
[ROW][C]2[/C][C]7365.2[/C][C]9279.11738461538[/C][C]-1913.91738461538[/C][/ROW]
[ROW][C]3[/C][C]9735.73[/C][C]9279.11738461538[/C][C]456.612615384616[/C][/ROW]
[ROW][C]4[/C][C]5123.1[/C][C]9279.11738461538[/C][C]-4156.01738461538[/C][/ROW]
[ROW][C]5[/C][C]11423.86[/C][C]7538.44216666667[/C][C]3885.41783333333[/C][/ROW]
[ROW][C]6[/C][C]8446.73[/C][C]9279.11738461538[/C][C]-832.387384615384[/C][/ROW]
[ROW][C]7[/C][C]5970.44[/C][C]9279.11738461538[/C][C]-3308.67738461538[/C][/ROW]
[ROW][C]8[/C][C]10441.13[/C][C]9279.11738461538[/C][C]1162.01261538462[/C][/ROW]
[ROW][C]9[/C][C]8115.67[/C][C]9279.11738461538[/C][C]-1163.44738461538[/C][/ROW]
[ROW][C]10[/C][C]7707.26[/C][C]7538.44216666667[/C][C]168.817833333333[/C][/ROW]
[ROW][C]11[/C][C]7432.14[/C][C]9279.11738461538[/C][C]-1846.97738461538[/C][/ROW]
[ROW][C]12[/C][C]8028.2633333333[/C][C]9279.11738461538[/C][C]-1250.85405128208[/C][/ROW]
[ROW][C]13[/C][C]8106.1333333333[/C][C]7538.44216666667[/C][C]567.691166666633[/C][/ROW]
[ROW][C]14[/C][C]10489.06[/C][C]9279.11738461538[/C][C]1209.94261538462[/C][/ROW]
[ROW][C]15[/C][C]7122.57[/C][C]9279.11738461538[/C][C]-2156.54738461538[/C][/ROW]
[ROW][C]16[/C][C]6550.88[/C][C]7538.44216666667[/C][C]-987.562166666668[/C][/ROW]
[ROW][C]17[/C][C]12247.67[/C][C]9279.11738461538[/C][C]2968.55261538462[/C][/ROW]
[ROW][C]18[/C][C]6713.04[/C][C]9279.11738461538[/C][C]-2566.07738461538[/C][/ROW]
[ROW][C]19[/C][C]7519.27[/C][C]9279.11738461538[/C][C]-1759.84738461538[/C][/ROW]
[ROW][C]20[/C][C]5721.45[/C][C]9279.11738461538[/C][C]-3557.66738461538[/C][/ROW]
[ROW][C]21[/C][C]7941.54[/C][C]9279.11738461538[/C][C]-1337.57738461538[/C][/ROW]
[ROW][C]22[/C][C]6734.7[/C][C]7538.44216666667[/C][C]-803.742166666668[/C][/ROW]
[ROW][C]23[/C][C]9659.92[/C][C]7538.44216666667[/C][C]2121.47783333333[/C][/ROW]
[ROW][C]24[/C][C]10472.94[/C][C]9279.11738461538[/C][C]1193.82261538462[/C][/ROW]
[ROW][C]25[/C][C]9370.7033333333[/C][C]9279.11738461538[/C][C]91.5859487179168[/C][/ROW]
[ROW][C]26[/C][C]8282.81[/C][C]9279.11738461538[/C][C]-996.307384615384[/C][/ROW]
[ROW][C]27[/C][C]8756.0933333333[/C][C]9279.11738461538[/C][C]-523.024051282084[/C][/ROW]
[ROW][C]28[/C][C]7171.57[/C][C]7538.44216666667[/C][C]-366.872166666668[/C][/ROW]
[ROW][C]29[/C][C]6905.9[/C][C]7538.44216666667[/C][C]-632.542166666668[/C][/ROW]
[ROW][C]30[/C][C]6411.9[/C][C]7538.44216666667[/C][C]-1126.54216666667[/C][/ROW]
[ROW][C]31[/C][C]12624.32[/C][C]9279.11738461538[/C][C]3345.20261538462[/C][/ROW]
[ROW][C]32[/C][C]8866.3433333333[/C][C]9279.11738461538[/C][C]-412.774051282084[/C][/ROW]
[ROW][C]33[/C][C]4046.33[/C][C]7538.44216666667[/C][C]-3492.11216666667[/C][/ROW]
[ROW][C]34[/C][C]6063.61[/C][C]7538.44216666667[/C][C]-1474.83216666667[/C][/ROW]
[ROW][C]35[/C][C]7018.63[/C][C]9279.11738461538[/C][C]-2260.48738461538[/C][/ROW]
[ROW][C]36[/C][C]4520.67[/C][C]9279.11738461538[/C][C]-4758.44738461538[/C][/ROW]
[ROW][C]37[/C][C]8171.44[/C][C]9279.11738461538[/C][C]-1107.67738461538[/C][/ROW]
[ROW][C]38[/C][C]5517.95[/C][C]7538.44216666667[/C][C]-2020.49216666667[/C][/ROW]
[ROW][C]39[/C][C]9701.81[/C][C]9279.11738461538[/C][C]422.692615384616[/C][/ROW]
[ROW][C]40[/C][C]7045.03[/C][C]7538.44216666667[/C][C]-493.412166666667[/C][/ROW]
[ROW][C]41[/C][C]9810.06[/C][C]9279.11738461538[/C][C]530.942615384616[/C][/ROW]
[ROW][C]42[/C][C]7446.07[/C][C]9279.11738461538[/C][C]-1833.04738461538[/C][/ROW]
[ROW][C]43[/C][C]7954.65[/C][C]9279.11738461538[/C][C]-1324.46738461538[/C][/ROW]
[ROW][C]44[/C][C]6300.7[/C][C]9279.11738461538[/C][C]-2978.41738461538[/C][/ROW]
[ROW][C]45[/C][C]7142.28[/C][C]9279.11738461538[/C][C]-2136.83738461538[/C][/ROW]
[ROW][C]46[/C][C]7138.5[/C][C]9279.11738461538[/C][C]-2140.61738461538[/C][/ROW]
[ROW][C]47[/C][C]9202.32[/C][C]9279.11738461538[/C][C]-76.7973846153836[/C][/ROW]
[ROW][C]48[/C][C]5867.79[/C][C]9279.11738461538[/C][C]-3411.32738461538[/C][/ROW]
[ROW][C]49[/C][C]4481.13[/C][C]9279.11738461538[/C][C]-4797.98738461538[/C][/ROW]
[ROW][C]50[/C][C]3540.17[/C][C]7538.44216666667[/C][C]-3998.27216666667[/C][/ROW]
[ROW][C]51[/C][C]13707.5733333333[/C][C]9279.11738461538[/C][C]4428.45594871792[/C][/ROW]
[ROW][C]52[/C][C]9927.51[/C][C]9279.11738461538[/C][C]648.392615384617[/C][/ROW]
[ROW][C]53[/C][C]12068.39[/C][C]9279.11738461538[/C][C]2789.27261538462[/C][/ROW]
[ROW][C]54[/C][C]8741.7366666667[/C][C]9279.11738461538[/C][C]-537.380717948683[/C][/ROW]
[ROW][C]55[/C][C]6796.87[/C][C]9279.11738461538[/C][C]-2482.24738461538[/C][/ROW]
[ROW][C]56[/C][C]9300.49[/C][C]9279.11738461538[/C][C]21.3726153846164[/C][/ROW]
[ROW][C]57[/C][C]7095.66[/C][C]9279.11738461538[/C][C]-2183.45738461538[/C][/ROW]
[ROW][C]58[/C][C]9186.73[/C][C]9279.11738461538[/C][C]-92.3873846153838[/C][/ROW]
[ROW][C]59[/C][C]8958.79[/C][C]7538.44216666667[/C][C]1420.34783333333[/C][/ROW]
[ROW][C]60[/C][C]5701.56[/C][C]9279.11738461538[/C][C]-3577.55738461538[/C][/ROW]
[ROW][C]61[/C][C]6940.11[/C][C]7538.44216666667[/C][C]-598.332166666668[/C][/ROW]
[ROW][C]62[/C][C]8452.86[/C][C]9279.11738461538[/C][C]-826.257384615383[/C][/ROW]
[ROW][C]63[/C][C]13315.1233333333[/C][C]9279.11738461538[/C][C]4036.00594871792[/C][/ROW]
[ROW][C]64[/C][C]6301.37[/C][C]9279.11738461538[/C][C]-2977.74738461538[/C][/ROW]
[ROW][C]65[/C][C]5614.49[/C][C]9279.11738461538[/C][C]-3664.62738461538[/C][/ROW]
[ROW][C]66[/C][C]10239.78[/C][C]9279.11738461538[/C][C]960.662615384615[/C][/ROW]
[ROW][C]67[/C][C]7072.1[/C][C]9279.11738461538[/C][C]-2207.01738461538[/C][/ROW]
[ROW][C]68[/C][C]5381.77[/C][C]9279.11738461538[/C][C]-3897.34738461538[/C][/ROW]
[ROW][C]69[/C][C]10010.06[/C][C]9279.11738461538[/C][C]730.942615384616[/C][/ROW]
[ROW][C]70[/C][C]4844.83[/C][C]9279.11738461538[/C][C]-4434.28738461538[/C][/ROW]
[ROW][C]71[/C][C]9678.67[/C][C]9279.11738461538[/C][C]399.552615384617[/C][/ROW]
[ROW][C]72[/C][C]7982.6[/C][C]7538.44216666667[/C][C]444.157833333333[/C][/ROW]
[ROW][C]73[/C][C]10139.58[/C][C]9279.11738461538[/C][C]860.462615384617[/C][/ROW]
[ROW][C]74[/C][C]9533.68[/C][C]9279.11738461538[/C][C]254.562615384617[/C][/ROW]
[ROW][C]75[/C][C]9268.45[/C][C]9279.11738461538[/C][C]-10.6673846153826[/C][/ROW]
[ROW][C]76[/C][C]5769.62[/C][C]9279.11738461538[/C][C]-3509.49738461538[/C][/ROW]
[ROW][C]77[/C][C]5108.87[/C][C]9279.11738461538[/C][C]-4170.24738461538[/C][/ROW]
[ROW][C]78[/C][C]8956.8133333333[/C][C]9279.11738461538[/C][C]-322.304051282084[/C][/ROW]
[ROW][C]79[/C][C]8350.2[/C][C]9279.11738461538[/C][C]-928.917384615383[/C][/ROW]
[ROW][C]80[/C][C]13201.79[/C][C]9279.11738461538[/C][C]3922.67261538462[/C][/ROW]
[ROW][C]81[/C][C]5350.28[/C][C]9279.11738461538[/C][C]-3928.83738461538[/C][/ROW]
[ROW][C]82[/C][C]9521.07[/C][C]9279.11738461538[/C][C]241.952615384616[/C][/ROW]
[ROW][C]83[/C][C]6015.8[/C][C]9279.11738461538[/C][C]-3263.31738461538[/C][/ROW]
[ROW][C]84[/C][C]7660.52[/C][C]9279.11738461538[/C][C]-1618.59738461538[/C][/ROW]
[ROW][C]85[/C][C]7290.23[/C][C]7538.44216666667[/C][C]-248.212166666668[/C][/ROW]
[ROW][C]86[/C][C]9404.76[/C][C]7538.44216666667[/C][C]1866.31783333333[/C][/ROW]
[ROW][C]87[/C][C]9303.93[/C][C]9279.11738461538[/C][C]24.8126153846169[/C][/ROW]
[ROW][C]88[/C][C]11055.21[/C][C]9279.11738461538[/C][C]1776.09261538462[/C][/ROW]
[ROW][C]89[/C][C]10406.84[/C][C]9279.11738461538[/C][C]1127.72261538462[/C][/ROW]
[ROW][C]90[/C][C]6996.91[/C][C]9279.11738461538[/C][C]-2282.20738461538[/C][/ROW]
[ROW][C]91[/C][C]9820.99[/C][C]9279.11738461538[/C][C]541.872615384616[/C][/ROW]
[ROW][C]92[/C][C]6184.58[/C][C]7538.44216666667[/C][C]-1353.86216666667[/C][/ROW]
[ROW][C]93[/C][C]7473.5566666667[/C][C]7538.44216666667[/C][C]-64.8854999999676[/C][/ROW]
[ROW][C]94[/C][C]6982.56[/C][C]9279.11738461538[/C][C]-2296.55738461538[/C][/ROW]
[ROW][C]95[/C][C]6696.29[/C][C]7538.44216666667[/C][C]-842.152166666668[/C][/ROW]
[ROW][C]96[/C][C]8569.5466666667[/C][C]9279.11738461538[/C][C]-709.570717948684[/C][/ROW]
[ROW][C]97[/C][C]11914.48[/C][C]9279.11738461538[/C][C]2635.36261538462[/C][/ROW]
[ROW][C]98[/C][C]6086.44[/C][C]7538.44216666667[/C][C]-1452.00216666667[/C][/ROW]
[ROW][C]99[/C][C]9784.52[/C][C]9279.11738461538[/C][C]505.402615384617[/C][/ROW]
[ROW][C]100[/C][C]7368.02[/C][C]7538.44216666667[/C][C]-170.422166666667[/C][/ROW]
[ROW][C]101[/C][C]8711.65[/C][C]9279.11738461538[/C][C]-567.467384615384[/C][/ROW]
[ROW][C]102[/C][C]5384.01[/C][C]9279.11738461538[/C][C]-3895.10738461538[/C][/ROW]
[ROW][C]103[/C][C]11344.7[/C][C]9279.11738461538[/C][C]2065.58261538462[/C][/ROW]
[ROW][C]104[/C][C]7137.82[/C][C]9279.11738461538[/C][C]-2141.29738461538[/C][/ROW]
[ROW][C]105[/C][C]8736.02[/C][C]7538.44216666667[/C][C]1197.57783333333[/C][/ROW]
[ROW][C]106[/C][C]7297.28[/C][C]9279.11738461538[/C][C]-1981.83738461538[/C][/ROW]
[ROW][C]107[/C][C]12375.84[/C][C]9279.11738461538[/C][C]3096.72261538462[/C][/ROW]
[ROW][C]108[/C][C]7294.08[/C][C]9279.11738461538[/C][C]-1985.03738461538[/C][/ROW]
[ROW][C]109[/C][C]9876.43[/C][C]9279.11738461538[/C][C]597.312615384617[/C][/ROW]
[ROW][C]110[/C][C]8047.74[/C][C]9279.11738461538[/C][C]-1231.37738461538[/C][/ROW]
[ROW][C]111[/C][C]9801.26[/C][C]9279.11738461538[/C][C]522.142615384617[/C][/ROW]
[ROW][C]112[/C][C]13022.31[/C][C]9279.11738461538[/C][C]3743.19261538462[/C][/ROW]
[ROW][C]113[/C][C]11924.24[/C][C]9279.11738461538[/C][C]2645.12261538462[/C][/ROW]
[ROW][C]114[/C][C]9815.3[/C][C]9279.11738461538[/C][C]536.182615384616[/C][/ROW]
[ROW][C]115[/C][C]8057.83[/C][C]7538.44216666667[/C][C]519.387833333332[/C][/ROW]
[ROW][C]116[/C][C]6213.8[/C][C]9279.11738461538[/C][C]-3065.31738461538[/C][/ROW]
[ROW][C]117[/C][C]9314.64[/C][C]9279.11738461538[/C][C]35.5226153846161[/C][/ROW]
[ROW][C]118[/C][C]11078.19[/C][C]9279.11738461538[/C][C]1799.07261538462[/C][/ROW]
[ROW][C]119[/C][C]8829.9766666667[/C][C]7538.44216666667[/C][C]1291.53450000003[/C][/ROW]
[ROW][C]120[/C][C]9024.67[/C][C]9279.11738461538[/C][C]-254.447384615383[/C][/ROW]
[ROW][C]121[/C][C]6959.31[/C][C]9279.11738461538[/C][C]-2319.80738461538[/C][/ROW]
[ROW][C]122[/C][C]9545.51[/C][C]9279.11738461538[/C][C]266.392615384617[/C][/ROW]
[ROW][C]123[/C][C]8963.5233333333[/C][C]9279.11738461538[/C][C]-315.594051282083[/C][/ROW]
[ROW][C]124[/C][C]4868.32[/C][C]9279.11738461538[/C][C]-4410.79738461538[/C][/ROW]
[ROW][C]125[/C][C]9288.22[/C][C]9279.11738461538[/C][C]9.10261538461782[/C][/ROW]
[ROW][C]126[/C][C]8351.32[/C][C]9279.11738461538[/C][C]-927.797384615384[/C][/ROW]
[ROW][C]127[/C][C]8579.56[/C][C]9279.11738461538[/C][C]-699.557384615384[/C][/ROW]
[ROW][C]128[/C][C]8439.6[/C][C]9279.11738461538[/C][C]-839.517384615383[/C][/ROW]
[ROW][C]129[/C][C]6591.21[/C][C]9279.11738461538[/C][C]-2687.90738461538[/C][/ROW]
[ROW][C]130[/C][C]6619.7[/C][C]9279.11738461538[/C][C]-2659.41738461538[/C][/ROW]
[ROW][C]131[/C][C]8972.9633333333[/C][C]9279.11738461538[/C][C]-306.154051282083[/C][/ROW]
[ROW][C]132[/C][C]6410.88[/C][C]7538.44216666667[/C][C]-1127.56216666667[/C][/ROW]
[ROW][C]133[/C][C]8098.2[/C][C]9279.11738461538[/C][C]-1180.91738461538[/C][/ROW]
[ROW][C]134[/C][C]7377.9566666667[/C][C]9279.11738461538[/C][C]-1901.16071794868[/C][/ROW]
[ROW][C]135[/C][C]7727.8366666667[/C][C]9279.11738461538[/C][C]-1551.28071794868[/C][/ROW]
[ROW][C]136[/C][C]6317.42[/C][C]9279.11738461538[/C][C]-2961.69738461538[/C][/ROW]
[ROW][C]137[/C][C]8735.85[/C][C]9279.11738461538[/C][C]-543.267384615383[/C][/ROW]
[ROW][C]138[/C][C]13327.6533333333[/C][C]9279.11738461538[/C][C]4048.53594871792[/C][/ROW]
[ROW][C]139[/C][C]17394.27[/C][C]7538.44216666667[/C][C]9855.82783333333[/C][/ROW]
[ROW][C]140[/C][C]14159.91[/C][C]9279.11738461538[/C][C]4880.79261538462[/C][/ROW]
[ROW][C]141[/C][C]8975.82[/C][C]9279.11738461538[/C][C]-303.297384615384[/C][/ROW]
[ROW][C]142[/C][C]7360.02[/C][C]9279.11738461538[/C][C]-1919.09738461538[/C][/ROW]
[ROW][C]143[/C][C]9096.53[/C][C]7538.44216666667[/C][C]1558.08783333333[/C][/ROW]
[ROW][C]144[/C][C]13043.26[/C][C]9279.11738461538[/C][C]3764.14261538462[/C][/ROW]
[ROW][C]145[/C][C]17338.59[/C][C]9279.11738461538[/C][C]8059.47261538462[/C][/ROW]
[ROW][C]146[/C][C]8228.39[/C][C]9279.11738461538[/C][C]-1050.72738461538[/C][/ROW]
[ROW][C]147[/C][C]7967.82[/C][C]9279.11738461538[/C][C]-1311.29738461538[/C][/ROW]
[ROW][C]148[/C][C]11613.87[/C][C]9279.11738461538[/C][C]2334.75261538462[/C][/ROW]
[ROW][C]149[/C][C]11392.94[/C][C]9279.11738461538[/C][C]2113.82261538462[/C][/ROW]
[ROW][C]150[/C][C]14565.62[/C][C]9279.11738461538[/C][C]5286.50261538462[/C][/ROW]
[ROW][C]151[/C][C]6399.88[/C][C]7538.44216666667[/C][C]-1138.56216666667[/C][/ROW]
[ROW][C]152[/C][C]7894.85[/C][C]9279.11738461538[/C][C]-1384.26738461538[/C][/ROW]
[ROW][C]153[/C][C]8315.49[/C][C]9279.11738461538[/C][C]-963.627384615384[/C][/ROW]
[ROW][C]154[/C][C]15474.53[/C][C]9279.11738461538[/C][C]6195.41261538462[/C][/ROW]
[ROW][C]155[/C][C]15740.78[/C][C]9279.11738461538[/C][C]6461.66261538462[/C][/ROW]
[ROW][C]156[/C][C]8821.3[/C][C]9279.11738461538[/C][C]-457.817384615384[/C][/ROW]
[ROW][C]157[/C][C]9649.98[/C][C]9279.11738461538[/C][C]370.862615384616[/C][/ROW]
[ROW][C]158[/C][C]12950.09[/C][C]9279.11738461538[/C][C]3670.97261538462[/C][/ROW]
[ROW][C]159[/C][C]11025.41[/C][C]9279.11738461538[/C][C]1746.29261538462[/C][/ROW]
[ROW][C]160[/C][C]9762.97[/C][C]9279.11738461538[/C][C]483.852615384618[/C][/ROW]
[ROW][C]161[/C][C]10007.32[/C][C]7538.44216666667[/C][C]2468.87783333333[/C][/ROW]
[ROW][C]162[/C][C]14456.69[/C][C]9279.11738461538[/C][C]5177.57261538462[/C][/ROW]
[ROW][C]163[/C][C]312.32[/C][C]9279.11738461538[/C][C]-8966.79738461538[/C][/ROW]
[ROW][C]164[/C][C]8000.23[/C][C]9279.11738461538[/C][C]-1278.88738461538[/C][/ROW]
[ROW][C]165[/C][C]12871.94[/C][C]9279.11738461538[/C][C]3592.82261538462[/C][/ROW]
[ROW][C]166[/C][C]12670.05[/C][C]9279.11738461538[/C][C]3390.93261538462[/C][/ROW]
[ROW][C]167[/C][C]10142.82[/C][C]9279.11738461538[/C][C]863.702615384616[/C][/ROW]
[ROW][C]168[/C][C]10443.82[/C][C]9279.11738461538[/C][C]1164.70261538462[/C][/ROW]
[ROW][C]169[/C][C]10070.77[/C][C]9279.11738461538[/C][C]791.652615384617[/C][/ROW]
[ROW][C]170[/C][C]12364.37[/C][C]9279.11738461538[/C][C]3085.25261538462[/C][/ROW]
[ROW][C]171[/C][C]7685.11[/C][C]9279.11738461538[/C][C]-1594.00738461538[/C][/ROW]
[ROW][C]172[/C][C]16068.91[/C][C]9279.11738461538[/C][C]6789.79261538462[/C][/ROW]
[ROW][C]173[/C][C]11407.43[/C][C]9279.11738461538[/C][C]2128.31261538462[/C][/ROW]
[ROW][C]174[/C][C]4260.96[/C][C]7538.44216666667[/C][C]-3277.48216666667[/C][/ROW]
[ROW][C]175[/C][C]4263.65[/C][C]9279.11738461538[/C][C]-5015.46738461538[/C][/ROW]
[ROW][C]176[/C][C]8652.82[/C][C]9279.11738461538[/C][C]-626.297384615384[/C][/ROW]
[ROW][C]177[/C][C]9808.16[/C][C]9279.11738461538[/C][C]529.042615384617[/C][/ROW]
[ROW][C]178[/C][C]6106.86[/C][C]9279.11738461538[/C][C]-3172.25738461538[/C][/ROW]
[ROW][C]179[/C][C]9756.57[/C][C]9279.11738461538[/C][C]477.452615384616[/C][/ROW]
[ROW][C]180[/C][C]17509.51[/C][C]9279.11738461538[/C][C]8230.39261538462[/C][/ROW]
[ROW][C]181[/C][C]7451.38[/C][C]9279.11738461538[/C][C]-1827.73738461538[/C][/ROW]
[ROW][C]182[/C][C]8409.37[/C][C]9279.11738461538[/C][C]-869.747384615384[/C][/ROW]
[ROW][C]183[/C][C]7559.88[/C][C]9279.11738461538[/C][C]-1719.23738461538[/C][/ROW]
[ROW][C]184[/C][C]9480[/C][C]9279.11738461538[/C][C]200.882615384617[/C][/ROW]
[ROW][C]185[/C][C]9447.65[/C][C]9279.11738461538[/C][C]168.532615384616[/C][/ROW]
[ROW][C]186[/C][C]10012.88[/C][C]7538.44216666667[/C][C]2474.43783333333[/C][/ROW]
[ROW][C]187[/C][C]14942.56[/C][C]9279.11738461538[/C][C]5663.44261538462[/C][/ROW]
[ROW][C]188[/C][C]5679.41[/C][C]7538.44216666667[/C][C]-1859.03216666667[/C][/ROW]
[ROW][C]189[/C][C]10118.75[/C][C]9279.11738461538[/C][C]839.632615384617[/C][/ROW]
[ROW][C]190[/C][C]9826.74[/C][C]9279.11738461538[/C][C]547.622615384616[/C][/ROW]
[ROW][C]191[/C][C]11758.49[/C][C]9279.11738461538[/C][C]2479.37261538462[/C][/ROW]
[ROW][C]192[/C][C]9503.11[/C][C]9279.11738461538[/C][C]223.992615384617[/C][/ROW]
[ROW][C]193[/C][C]3928.27[/C][C]9279.11738461538[/C][C]-5350.84738461538[/C][/ROW]
[ROW][C]194[/C][C]9389.23[/C][C]9279.11738461538[/C][C]110.112615384616[/C][/ROW]
[ROW][C]195[/C][C]20683.24[/C][C]9279.11738461538[/C][C]11404.1226153846[/C][/ROW]
[ROW][C]196[/C][C]6783.19[/C][C]7538.44216666667[/C][C]-755.252166666667[/C][/ROW]
[ROW][C]197[/C][C]2078.3[/C][C]7538.44216666667[/C][C]-5460.14216666667[/C][/ROW]
[ROW][C]198[/C][C]8665.67[/C][C]9279.11738461538[/C][C]-613.447384615383[/C][/ROW]
[ROW][C]199[/C][C]14167.73[/C][C]9279.11738461538[/C][C]4888.61261538462[/C][/ROW]
[ROW][C]200[/C][C]11099.22[/C][C]9279.11738461538[/C][C]1820.10261538462[/C][/ROW]
[ROW][C]201[/C][C]12040.95[/C][C]7538.44216666667[/C][C]4502.50783333333[/C][/ROW]
[ROW][C]202[/C][C]7242.24[/C][C]9279.11738461538[/C][C]-2036.87738461538[/C][/ROW]
[ROW][C]203[/C][C]19323.43[/C][C]9279.11738461538[/C][C]10044.3126153846[/C][/ROW]
[ROW][C]204[/C][C]14235.2[/C][C]9279.11738461538[/C][C]4956.08261538462[/C][/ROW]
[ROW][C]205[/C][C]5643.24[/C][C]9279.11738461538[/C][C]-3635.87738461538[/C][/ROW]
[ROW][C]206[/C][C]3626.59[/C][C]9279.11738461538[/C][C]-5652.52738461538[/C][/ROW]
[ROW][C]207[/C][C]14639.78[/C][C]9279.11738461538[/C][C]5360.66261538462[/C][/ROW]
[ROW][C]208[/C][C]906.04[/C][C]9279.11738461538[/C][C]-8373.07738461538[/C][/ROW]
[ROW][C]209[/C][C]4100.63[/C][C]9279.11738461538[/C][C]-5178.48738461538[/C][/ROW]
[ROW][C]210[/C][C]14625.77[/C][C]9279.11738461538[/C][C]5346.65261538462[/C][/ROW]
[ROW][C]211[/C][C]6894.78[/C][C]9279.11738461538[/C][C]-2384.33738461538[/C][/ROW]
[ROW][C]212[/C][C]12805.95[/C][C]9279.11738461538[/C][C]3526.83261538462[/C][/ROW]
[ROW][C]213[/C][C]7642.43[/C][C]9279.11738461538[/C][C]-1636.68738461538[/C][/ROW]
[ROW][C]214[/C][C]8562.89[/C][C]7538.44216666667[/C][C]1024.44783333333[/C][/ROW]
[ROW][C]215[/C][C]8514.39[/C][C]9279.11738461538[/C][C]-764.727384615384[/C][/ROW]
[ROW][C]216[/C][C]19226.29[/C][C]9279.11738461538[/C][C]9947.17261538462[/C][/ROW]
[ROW][C]217[/C][C]5641.34[/C][C]9279.11738461538[/C][C]-3637.77738461538[/C][/ROW]
[ROW][C]218[/C][C]8592.5[/C][C]9279.11738461538[/C][C]-686.617384615383[/C][/ROW]
[ROW][C]219[/C][C]13625.03[/C][C]9279.11738461538[/C][C]4345.91261538462[/C][/ROW]
[ROW][C]220[/C][C]8005.46[/C][C]9279.11738461538[/C][C]-1273.65738461538[/C][/ROW]
[ROW][C]221[/C][C]15285.88[/C][C]9279.11738461538[/C][C]6006.76261538462[/C][/ROW]
[ROW][C]222[/C][C]10996.04[/C][C]9279.11738461538[/C][C]1716.92261538462[/C][/ROW]
[ROW][C]223[/C][C]8228.67[/C][C]9279.11738461538[/C][C]-1050.44738461538[/C][/ROW]
[ROW][C]224[/C][C]7955.02[/C][C]9279.11738461538[/C][C]-1324.09738461538[/C][/ROW]
[ROW][C]225[/C][C]7690.87[/C][C]9279.11738461538[/C][C]-1588.24738461538[/C][/ROW]
[ROW][C]226[/C][C]8254.53[/C][C]9279.11738461538[/C][C]-1024.58738461538[/C][/ROW]
[ROW][C]227[/C][C]13953.02[/C][C]9279.11738461538[/C][C]4673.90261538462[/C][/ROW]
[ROW][C]228[/C][C]13104.85[/C][C]9279.11738461538[/C][C]3825.73261538462[/C][/ROW]
[ROW][C]229[/C][C]5915.81[/C][C]7538.44216666667[/C][C]-1622.63216666667[/C][/ROW]
[ROW][C]230[/C][C]5504.23[/C][C]9279.11738461538[/C][C]-3774.88738461538[/C][/ROW]
[ROW][C]231[/C][C]9730.57[/C][C]9279.11738461538[/C][C]451.452615384616[/C][/ROW]
[ROW][C]232[/C][C]12431.05[/C][C]9279.11738461538[/C][C]3151.93261538462[/C][/ROW]
[ROW][C]233[/C][C]10350.38[/C][C]9279.11738461538[/C][C]1071.26261538462[/C][/ROW]
[ROW][C]234[/C][C]8117.73[/C][C]9279.11738461538[/C][C]-1161.38738461538[/C][/ROW]
[ROW][C]235[/C][C]7404.66[/C][C]9279.11738461538[/C][C]-1874.45738461538[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=165313&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165313&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
16704.739279.11738461538-2574.38738461538
27365.29279.11738461538-1913.91738461538
39735.739279.11738461538456.612615384616
45123.19279.11738461538-4156.01738461538
511423.867538.442166666673885.41783333333
68446.739279.11738461538-832.387384615384
75970.449279.11738461538-3308.67738461538
810441.139279.117384615381162.01261538462
98115.679279.11738461538-1163.44738461538
107707.267538.44216666667168.817833333333
117432.149279.11738461538-1846.97738461538
128028.26333333339279.11738461538-1250.85405128208
138106.13333333337538.44216666667567.691166666633
1410489.069279.117384615381209.94261538462
157122.579279.11738461538-2156.54738461538
166550.887538.44216666667-987.562166666668
1712247.679279.117384615382968.55261538462
186713.049279.11738461538-2566.07738461538
197519.279279.11738461538-1759.84738461538
205721.459279.11738461538-3557.66738461538
217941.549279.11738461538-1337.57738461538
226734.77538.44216666667-803.742166666668
239659.927538.442166666672121.47783333333
2410472.949279.117384615381193.82261538462
259370.70333333339279.1173846153891.5859487179168
268282.819279.11738461538-996.307384615384
278756.09333333339279.11738461538-523.024051282084
287171.577538.44216666667-366.872166666668
296905.97538.44216666667-632.542166666668
306411.97538.44216666667-1126.54216666667
3112624.329279.117384615383345.20261538462
328866.34333333339279.11738461538-412.774051282084
334046.337538.44216666667-3492.11216666667
346063.617538.44216666667-1474.83216666667
357018.639279.11738461538-2260.48738461538
364520.679279.11738461538-4758.44738461538
378171.449279.11738461538-1107.67738461538
385517.957538.44216666667-2020.49216666667
399701.819279.11738461538422.692615384616
407045.037538.44216666667-493.412166666667
419810.069279.11738461538530.942615384616
427446.079279.11738461538-1833.04738461538
437954.659279.11738461538-1324.46738461538
446300.79279.11738461538-2978.41738461538
457142.289279.11738461538-2136.83738461538
467138.59279.11738461538-2140.61738461538
479202.329279.11738461538-76.7973846153836
485867.799279.11738461538-3411.32738461538
494481.139279.11738461538-4797.98738461538
503540.177538.44216666667-3998.27216666667
5113707.57333333339279.117384615384428.45594871792
529927.519279.11738461538648.392615384617
5312068.399279.117384615382789.27261538462
548741.73666666679279.11738461538-537.380717948683
556796.879279.11738461538-2482.24738461538
569300.499279.1173846153821.3726153846164
577095.669279.11738461538-2183.45738461538
589186.739279.11738461538-92.3873846153838
598958.797538.442166666671420.34783333333
605701.569279.11738461538-3577.55738461538
616940.117538.44216666667-598.332166666668
628452.869279.11738461538-826.257384615383
6313315.12333333339279.117384615384036.00594871792
646301.379279.11738461538-2977.74738461538
655614.499279.11738461538-3664.62738461538
6610239.789279.11738461538960.662615384615
677072.19279.11738461538-2207.01738461538
685381.779279.11738461538-3897.34738461538
6910010.069279.11738461538730.942615384616
704844.839279.11738461538-4434.28738461538
719678.679279.11738461538399.552615384617
727982.67538.44216666667444.157833333333
7310139.589279.11738461538860.462615384617
749533.689279.11738461538254.562615384617
759268.459279.11738461538-10.6673846153826
765769.629279.11738461538-3509.49738461538
775108.879279.11738461538-4170.24738461538
788956.81333333339279.11738461538-322.304051282084
798350.29279.11738461538-928.917384615383
8013201.799279.117384615383922.67261538462
815350.289279.11738461538-3928.83738461538
829521.079279.11738461538241.952615384616
836015.89279.11738461538-3263.31738461538
847660.529279.11738461538-1618.59738461538
857290.237538.44216666667-248.212166666668
869404.767538.442166666671866.31783333333
879303.939279.1173846153824.8126153846169
8811055.219279.117384615381776.09261538462
8910406.849279.117384615381127.72261538462
906996.919279.11738461538-2282.20738461538
919820.999279.11738461538541.872615384616
926184.587538.44216666667-1353.86216666667
937473.55666666677538.44216666667-64.8854999999676
946982.569279.11738461538-2296.55738461538
956696.297538.44216666667-842.152166666668
968569.54666666679279.11738461538-709.570717948684
9711914.489279.117384615382635.36261538462
986086.447538.44216666667-1452.00216666667
999784.529279.11738461538505.402615384617
1007368.027538.44216666667-170.422166666667
1018711.659279.11738461538-567.467384615384
1025384.019279.11738461538-3895.10738461538
10311344.79279.117384615382065.58261538462
1047137.829279.11738461538-2141.29738461538
1058736.027538.442166666671197.57783333333
1067297.289279.11738461538-1981.83738461538
10712375.849279.117384615383096.72261538462
1087294.089279.11738461538-1985.03738461538
1099876.439279.11738461538597.312615384617
1108047.749279.11738461538-1231.37738461538
1119801.269279.11738461538522.142615384617
11213022.319279.117384615383743.19261538462
11311924.249279.117384615382645.12261538462
1149815.39279.11738461538536.182615384616
1158057.837538.44216666667519.387833333332
1166213.89279.11738461538-3065.31738461538
1179314.649279.1173846153835.5226153846161
11811078.199279.117384615381799.07261538462
1198829.97666666677538.442166666671291.53450000003
1209024.679279.11738461538-254.447384615383
1216959.319279.11738461538-2319.80738461538
1229545.519279.11738461538266.392615384617
1238963.52333333339279.11738461538-315.594051282083
1244868.329279.11738461538-4410.79738461538
1259288.229279.117384615389.10261538461782
1268351.329279.11738461538-927.797384615384
1278579.569279.11738461538-699.557384615384
1288439.69279.11738461538-839.517384615383
1296591.219279.11738461538-2687.90738461538
1306619.79279.11738461538-2659.41738461538
1318972.96333333339279.11738461538-306.154051282083
1326410.887538.44216666667-1127.56216666667
1338098.29279.11738461538-1180.91738461538
1347377.95666666679279.11738461538-1901.16071794868
1357727.83666666679279.11738461538-1551.28071794868
1366317.429279.11738461538-2961.69738461538
1378735.859279.11738461538-543.267384615383
13813327.65333333339279.117384615384048.53594871792
13917394.277538.442166666679855.82783333333
14014159.919279.117384615384880.79261538462
1418975.829279.11738461538-303.297384615384
1427360.029279.11738461538-1919.09738461538
1439096.537538.442166666671558.08783333333
14413043.269279.117384615383764.14261538462
14517338.599279.117384615388059.47261538462
1468228.399279.11738461538-1050.72738461538
1477967.829279.11738461538-1311.29738461538
14811613.879279.117384615382334.75261538462
14911392.949279.117384615382113.82261538462
15014565.629279.117384615385286.50261538462
1516399.887538.44216666667-1138.56216666667
1527894.859279.11738461538-1384.26738461538
1538315.499279.11738461538-963.627384615384
15415474.539279.117384615386195.41261538462
15515740.789279.117384615386461.66261538462
1568821.39279.11738461538-457.817384615384
1579649.989279.11738461538370.862615384616
15812950.099279.117384615383670.97261538462
15911025.419279.117384615381746.29261538462
1609762.979279.11738461538483.852615384618
16110007.327538.442166666672468.87783333333
16214456.699279.117384615385177.57261538462
163312.329279.11738461538-8966.79738461538
1648000.239279.11738461538-1278.88738461538
16512871.949279.117384615383592.82261538462
16612670.059279.117384615383390.93261538462
16710142.829279.11738461538863.702615384616
16810443.829279.117384615381164.70261538462
16910070.779279.11738461538791.652615384617
17012364.379279.117384615383085.25261538462
1717685.119279.11738461538-1594.00738461538
17216068.919279.117384615386789.79261538462
17311407.439279.117384615382128.31261538462
1744260.967538.44216666667-3277.48216666667
1754263.659279.11738461538-5015.46738461538
1768652.829279.11738461538-626.297384615384
1779808.169279.11738461538529.042615384617
1786106.869279.11738461538-3172.25738461538
1799756.579279.11738461538477.452615384616
18017509.519279.117384615388230.39261538462
1817451.389279.11738461538-1827.73738461538
1828409.379279.11738461538-869.747384615384
1837559.889279.11738461538-1719.23738461538
18494809279.11738461538200.882615384617
1859447.659279.11738461538168.532615384616
18610012.887538.442166666672474.43783333333
18714942.569279.117384615385663.44261538462
1885679.417538.44216666667-1859.03216666667
18910118.759279.11738461538839.632615384617
1909826.749279.11738461538547.622615384616
19111758.499279.117384615382479.37261538462
1929503.119279.11738461538223.992615384617
1933928.279279.11738461538-5350.84738461538
1949389.239279.11738461538110.112615384616
19520683.249279.1173846153811404.1226153846
1966783.197538.44216666667-755.252166666667
1972078.37538.44216666667-5460.14216666667
1988665.679279.11738461538-613.447384615383
19914167.739279.117384615384888.61261538462
20011099.229279.117384615381820.10261538462
20112040.957538.442166666674502.50783333333
2027242.249279.11738461538-2036.87738461538
20319323.439279.1173846153810044.3126153846
20414235.29279.117384615384956.08261538462
2055643.249279.11738461538-3635.87738461538
2063626.599279.11738461538-5652.52738461538
20714639.789279.117384615385360.66261538462
208906.049279.11738461538-8373.07738461538
2094100.639279.11738461538-5178.48738461538
21014625.779279.117384615385346.65261538462
2116894.789279.11738461538-2384.33738461538
21212805.959279.117384615383526.83261538462
2137642.439279.11738461538-1636.68738461538
2148562.897538.442166666671024.44783333333
2158514.399279.11738461538-764.727384615384
21619226.299279.117384615389947.17261538462
2175641.349279.11738461538-3637.77738461538
2188592.59279.11738461538-686.617384615383
21913625.039279.117384615384345.91261538462
2208005.469279.11738461538-1273.65738461538
22115285.889279.117384615386006.76261538462
22210996.049279.117384615381716.92261538462
2238228.679279.11738461538-1050.44738461538
2247955.029279.11738461538-1324.09738461538
2257690.879279.11738461538-1588.24738461538
2268254.539279.11738461538-1024.58738461538
22713953.029279.117384615384673.90261538462
22813104.859279.117384615383825.73261538462
2295915.817538.44216666667-1622.63216666667
2305504.239279.11738461538-3774.88738461538
2319730.579279.11738461538451.452615384616
23212431.059279.117384615383151.93261538462
23310350.389279.117384615381071.26261538462
2348117.739279.11738461538-1161.38738461538
2357404.669279.11738461538-1874.45738461538



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