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:31: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/May/01/t1335907913gayi3tt5r6gxr2f.htm/, Retrieved Sat, 04 May 2024 08:23:56 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=165837, Retrieved Sat, 04 May 2024 08:23:56 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact83
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:31:06] [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 time7 seconds
R Server'AstonUniversity' @ aston.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 & 7 seconds \tabularnewline
R Server & 'AstonUniversity' @ aston.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=165837&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]7 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'AstonUniversity' @ aston.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=165837&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165837&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 time7 seconds
R Server'AstonUniversity' @ aston.wessa.net







Goodness of Fit
Correlation0.3147
R-squared0.0991
RMSE3738.4495

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

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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165837&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.3147
R-squared0.0991
RMSE3738.4495







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
110628.079993.52320457797634.546795422031
29399.629993.52320457797-593.90320457797
310195.349993.52320457797201.816795422032
49859.719993.52320457797-133.813204577969
514035.068418.033672316385617.02632768362
67098.60666666679993.52320457797-2894.91653791127
712238.729993.523204577972245.19679542203
810065.469993.5232045779771.9367954220306
910073.389993.5232045779779.8567954220325
108967.419993.52320457797-1026.11320457797
1110297.379993.52320457797303.84679542203
1213269.699993.523204577973276.16679542203
1312220.89993.523204577972227.27679542203
1412925.839993.523204577972932.30679542203
157725.89993.52320457797-2267.72320457797
166719.818418.03367231638-1698.22367231638
1713210.448418.033672316384792.40632768362
1811290.569993.523204577971297.03679542203
196876.919993.52320457797-3116.61320457797
208625.929993.52320457797-1367.60320457797
218878.88418.03367231638460.766327683616
2211981.929993.523204577971988.39679542203
2311012.179993.523204577971018.64679542203
247462.039993.52320457797-2531.49320457797
2512684.498418.033672316384266.45632768362
2613609.259993.523204577973615.72679542203
279328.759993.52320457797-664.773204577968
2813535.149993.523204577973541.61679542203
298075.948418.03367231638-342.093672316383
3013289.549993.523204577973296.01679542203
3113032.89993.523204577973039.27679542203
3213561.749993.523204577973568.21679542203
3310938.218418.033672316382520.17632768362
346828.138418.03367231638-1589.90367231638
358162.559993.52320457797-1830.97320457797
369266.219993.52320457797-727.31320457797
379939.79333333339993.52320457797-53.7298712446682
388418.699993.52320457797-1574.83320457797
3910601.959993.52320457797608.426795422032
409099.529993.52320457797-894.003204577968
4111031.59993.523204577971037.97679542203
4210263.759993.52320457797270.226795422032
4313712.339993.523204577973718.80679542203
4413481.519993.523204577973487.98679542203
457375.389993.52320457797-2618.14320457797
468474.099993.52320457797-1519.43320457797
4710880.469993.52320457797886.936795422031
489359.29993.52320457797-634.323204577968
495612.469993.52320457797-4381.06320457797
509902.159993.52320457797-91.3732045779689
5113675.219993.523204577973681.68679542203
529109.939993.52320457797-883.593204577968
539922.738418.033672316381504.69632768362
546490.879993.52320457797-3502.65320457797
557402.259993.52320457797-2591.27320457797
5614693.649993.523204577974700.11679542203
5710816.99993.52320457797823.376795422031
589453.049993.52320457797-540.483204577968
596392.329993.52320457797-3601.20320457797
607995.499993.52320457797-1998.03320457797
616378.659993.52320457797-3614.87320457797
628154.588418.03367231638-263.453672316384
6310001.779993.523204577978.24679542203194
647749.299993.52320457797-2244.23320457797
658335.49993.52320457797-1658.12320457797
668633.029993.52320457797-1360.50320457797
679496.439993.52320457797-497.093204577968
685485.099993.52320457797-4508.43320457797
6912899.689993.523204577972906.15679542203
709319.59993.52320457797-674.023204577968
719648.488418.033672316381230.44632768362
7215259.569993.523204577975266.03679542203
737341.859993.52320457797-2651.67320457797
7410623.548418.033672316382205.50632768362
758495.38418.0336723163877.2663276836156
7611227.399993.523204577971233.86679542203
778649.589993.52320457797-1343.94320457797
7810651.688418.033672316382233.64632768362
7912959.458418.033672316384541.41632768362
8010425.989993.52320457797432.456795422031
818437.099993.52320457797-1556.43320457797
826704.739993.52320457797-3288.79320457797
837365.29993.52320457797-2628.32320457797
849735.738418.033672316381317.69632768362
8511423.869993.523204577971430.33679542203
868446.739993.52320457797-1546.79320457797
878115.679993.52320457797-1877.85320457797
887432.149993.52320457797-2561.38320457797
898028.26333333338418.03367231638-389.770338983083
908106.13333333339993.52320457797-1887.38987124467
917122.578418.03367231638-1295.46367231638
926550.888418.03367231638-1867.15367231638
937519.279993.52320457797-2474.25320457797
945721.458418.03367231638-2696.58367231638
957941.549993.52320457797-2051.98320457797
966734.78418.03367231638-1683.33367231638
979659.928418.033672316381241.88632768362
9810472.948418.033672316382054.90632768362
998335.45333333339993.52320457797-1658.06987124467
1007171.578418.03367231638-1246.46367231638
1014366.988418.03367231638-4051.05367231638
1026905.99993.52320457797-3087.62320457797
1036411.99993.52320457797-3581.62320457797
1044046.339993.52320457797-5947.19320457797
1054520.679993.52320457797-5472.85320457797
1068171.448418.03367231638-246.593672316383
1077045.039993.52320457797-2948.49320457797
1087138.59993.52320457797-2855.02320457797
1093540.178418.03367231638-4877.86367231638
11012068.398418.033672316383650.35632768362
1116796.878418.03367231638-1621.16367231638
1129300.498418.03367231638882.456327683616
1138714.348418.03367231638296.306327683616
1147139.69993.52320457797-2853.92320457797
1159678.679993.52320457797-314.853204577968
11610139.589993.52320457797146.056795422031
1179533.689993.52320457797-459.843204577968
1189268.459993.52320457797-725.073204577968
1195769.629993.52320457797-4223.90320457797
1205108.879993.52320457797-4884.65320457797
1219521.079993.52320457797-472.453204577969
1226015.89993.52320457797-3977.72320457797
1237660.529993.52320457797-2333.00320457797
1247290.238418.03367231638-1127.80367231638
1259303.939993.52320457797-689.593204577968
1269820.999993.52320457797-172.533204577969
1276982.568418.03367231638-1435.47367231638
1286696.299993.52320457797-3297.23320457797
1296068.499993.52320457797-3925.03320457797
1309784.529993.52320457797-209.003204577968
1317368.028418.03367231638-1050.01367231638
1328711.659993.52320457797-1281.87320457797
1337038.449993.52320457797-2955.08320457797
1348736.029993.52320457797-1257.50320457797
13512375.849993.523204577972382.31679542203
13613022.319993.523204577973028.78679542203
1379815.39993.52320457797-178.223204577969
1388057.838418.03367231638-360.203672316384
1396213.88418.03367231638-2204.23367231638
1409314.649993.52320457797-678.883204577969
14111078.199993.523204577971084.66679542203
1429024.679993.52320457797-968.853204577968
1438439.68418.0336723163821.5663276836167
1446591.219993.52320457797-3402.31320457797
1456619.78418.03367231638-1798.33367231638
1465469.098418.03367231638-2948.94367231638
1478972.96333333338418.03367231638554.929661016917
1486410.888418.03367231638-2007.15367231638
1498098.29993.52320457797-1895.32320457797
1506317.429993.52320457797-3676.10320457797
15112560.839993.523204577972567.30679542203
1526746.349993.52320457797-3247.18320457797
1539605.049993.52320457797-388.483204577968
1548805.959993.52320457797-1187.57320457797
1559692.119993.52320457797-301.413204577968
1567445.259993.52320457797-2548.27320457797
15710211.759993.52320457797218.226795422032
15811412.219993.523204577971418.68679542203
15913530.699993.523204577973537.16679542203
1609906.749993.52320457797-86.7832045779687
16114131.199993.523204577974137.66679542203
16210637.989993.52320457797644.456795422031
1639859.079993.52320457797-134.453204577969
1642559.379993.52320457797-7434.15320457797
16533644.969993.5232045779723651.436795422
16610267.259993.52320457797273.726795422032
16711146.338418.033672316382728.29632768362
16852419993.52320457797-4752.52320457797
16913003.979993.523204577973010.44679542203
17018688.759993.523204577978695.22679542203
1717199.969993.52320457797-2793.56320457797
1726908.189993.52320457797-3085.34320457797
1739877.239993.52320457797-116.293204577969
17410827.259993.52320457797833.726795422032
1757794.099993.52320457797-2199.43320457797
1769646.549993.52320457797-346.983204577968
1776696.474162.10252534.3675
17818584.879993.523204577978591.34679542203
1799530.239993.52320457797-463.293204577969
18018205.979993.523204577978212.44679542203
1816135.089993.52320457797-3858.44320457797
1827490.624162.10253328.5175
183298418.03367231638-8389.03367231638
18413299.39993.523204577973305.77679542203
18512630.989993.523204577972637.45679542203
18610972.359993.52320457797978.826795422032
187114162.1025-4151.1025
18813588.919993.523204577973595.38679542203
18913512.249993.523204577973518.71679542203
19017165.869993.523204577977172.33679542203
1918309.268418.03367231638-108.773672316383
1928792.239993.52320457797-1201.29320457797
1936454.779993.52320457797-3538.75320457797
19432946.369993.5232045779722952.836795422
1957921.974162.10253759.8675
19611123.149993.523204577971129.61679542203
19710573.359993.52320457797579.826795422032
19812378.919993.523204577972385.38679542203
1991455.689993.52320457797-8537.84320457797
2007217.39993.52320457797-2776.22320457797
20111346.259993.523204577971352.72679542203
20216131.859993.523204577976138.32679542203
2036925.639993.52320457797-3067.89320457797
20412370.829993.523204577972377.29679542203
2059622.889993.52320457797-370.643204577967
2068248.469993.52320457797-1745.06320457797
20711662.129993.523204577971668.59679542203
20811351.189993.523204577971357.65679542203
20910341.699993.52320457797348.166795422032
21022073.749993.5232045779712080.216795422
21111089.449993.523204577971095.91679542203
21212054.649993.523204577972061.11679542203
21319061.329993.523204577979067.79679542203
21413629.678418.033672316385211.63632768362
2157570.859993.52320457797-2422.67320457797
21611334.089993.523204577971340.55679542203
21712604.639993.523204577972611.10679542203
21811526.619993.523204577971533.08679542203
21918940.159993.523204577978946.62679542203
22004162.1025-4162.1025
22112121.618418.033672316383703.57632768362
2229688.369993.52320457797-305.163204577968
22313803.768418.033672316385385.72632768362
22410129.269993.52320457797135.736795422032
2257444.329993.52320457797-2549.20320457797
22614591.699993.523204577974598.16679542203
2278870.348418.03367231638452.306327683616
2289752.659993.52320457797-240.873204577969
2297683.239993.52320457797-2310.29320457797
23010226.029993.52320457797232.496795422032
2317141.969993.52320457797-2851.56320457797
23214159.919993.523204577974166.38679542203
2339635.529993.52320457797-358.003204577968
2347360.024162.10253197.9175
23510485.319993.52320457797491.786795422033
2369096.539993.52320457797-896.99320457797
23713043.269993.523204577973049.73679542203
2388228.399993.52320457797-1765.13320457797
23911392.949993.523204577971399.41679542203
24014565.629993.523204577974572.09679542203
2416399.888418.03367231638-2018.15367231638
2428761.838418.03367231638343.796327683616
2434324.318418.03367231638-4093.72367231638
24415740.788418.033672316387322.74632768362
2459649.989993.52320457797-343.543204577969
24612950.099993.523204577972956.56679542203
24710007.329993.5232045779713.7967954220312
24813029.749993.523204577973036.21679542203
24914456.699993.523204577974463.16679542203
250312.329993.52320457797-9681.20320457797
2518000.239993.52320457797-1993.29320457797
25212670.059993.523204577972676.52679542203
25310443.829993.52320457797450.296795422031
2547380.89993.52320457797-2612.72320457797
25512364.379993.523204577972370.84679542203
2567685.119993.52320457797-2308.41320457797
25713917.629993.523204577973924.09679542203
2584260.969993.52320457797-5732.56320457797
2594263.659993.52320457797-5729.87320457797
2609808.169993.52320457797-185.363204577969
261503.934162.1025-3658.1725
2626106.869993.52320457797-3886.66320457797
2639756.579993.52320457797-236.953204577969
2647559.889993.52320457797-2433.64320457797
26594809993.52320457797-513.523204577968
26610012.889993.5232045779719.3567954220325
26714942.569993.523204577974949.03679542203
26810118.759993.52320457797125.226795422032
2699503.118418.033672316381085.07632768362
2709389.238418.03367231638971.196327683616
2712078.39993.52320457797-7915.22320457797
2725959.48418.03367231638-2458.63367231638
2734008.64162.1025-153.5025
27411099.229993.523204577971105.69679542203
27512040.959993.523204577972047.42679542203
2767242.249993.52320457797-2751.28320457797
27719323.439993.523204577979329.90679542203
2788379.818418.03367231638-38.2236723163824
2793626.598418.03367231638-4791.44367231638
280906.048418.03367231638-7511.99367231638
2814100.639993.52320457797-5892.89320457797
28214625.779993.523204577974632.24679542203
2836894.789993.52320457797-3098.74320457797
2847148.29993.52320457797-2845.32320457797
2858562.899993.52320457797-1430.63320457797
2868514.399993.52320457797-1479.13320457797
2875641.349993.52320457797-4352.18320457797
2888592.59993.52320457797-1401.02320457797
28913820.839993.523204577973827.30679542203
29015285.889993.523204577975292.35679542203
29110996.049993.523204577971002.51679542203
2928228.679993.52320457797-1764.85320457797
2937955.028418.03367231638-463.013672316383
2947690.874162.10253528.7675
29509993.52320457797-9993.52320457797
2967861.39993.52320457797-2132.22320457797
29713104.859993.523204577973111.32679542203
2985915.814162.10251753.7075
2995504.239993.52320457797-4489.29320457797
300402.044162.1025-3760.0625
3016631.449993.52320457797-3362.08320457797
3028687.319993.52320457797-1306.21320457797
3031943.94162.1025-2218.2025
3048117.739993.52320457797-1875.79320457797

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 10628.07 & 9993.52320457797 & 634.546795422031 \tabularnewline
2 & 9399.62 & 9993.52320457797 & -593.90320457797 \tabularnewline
3 & 10195.34 & 9993.52320457797 & 201.816795422032 \tabularnewline
4 & 9859.71 & 9993.52320457797 & -133.813204577969 \tabularnewline
5 & 14035.06 & 8418.03367231638 & 5617.02632768362 \tabularnewline
6 & 7098.6066666667 & 9993.52320457797 & -2894.91653791127 \tabularnewline
7 & 12238.72 & 9993.52320457797 & 2245.19679542203 \tabularnewline
8 & 10065.46 & 9993.52320457797 & 71.9367954220306 \tabularnewline
9 & 10073.38 & 9993.52320457797 & 79.8567954220325 \tabularnewline
10 & 8967.41 & 9993.52320457797 & -1026.11320457797 \tabularnewline
11 & 10297.37 & 9993.52320457797 & 303.84679542203 \tabularnewline
12 & 13269.69 & 9993.52320457797 & 3276.16679542203 \tabularnewline
13 & 12220.8 & 9993.52320457797 & 2227.27679542203 \tabularnewline
14 & 12925.83 & 9993.52320457797 & 2932.30679542203 \tabularnewline
15 & 7725.8 & 9993.52320457797 & -2267.72320457797 \tabularnewline
16 & 6719.81 & 8418.03367231638 & -1698.22367231638 \tabularnewline
17 & 13210.44 & 8418.03367231638 & 4792.40632768362 \tabularnewline
18 & 11290.56 & 9993.52320457797 & 1297.03679542203 \tabularnewline
19 & 6876.91 & 9993.52320457797 & -3116.61320457797 \tabularnewline
20 & 8625.92 & 9993.52320457797 & -1367.60320457797 \tabularnewline
21 & 8878.8 & 8418.03367231638 & 460.766327683616 \tabularnewline
22 & 11981.92 & 9993.52320457797 & 1988.39679542203 \tabularnewline
23 & 11012.17 & 9993.52320457797 & 1018.64679542203 \tabularnewline
24 & 7462.03 & 9993.52320457797 & -2531.49320457797 \tabularnewline
25 & 12684.49 & 8418.03367231638 & 4266.45632768362 \tabularnewline
26 & 13609.25 & 9993.52320457797 & 3615.72679542203 \tabularnewline
27 & 9328.75 & 9993.52320457797 & -664.773204577968 \tabularnewline
28 & 13535.14 & 9993.52320457797 & 3541.61679542203 \tabularnewline
29 & 8075.94 & 8418.03367231638 & -342.093672316383 \tabularnewline
30 & 13289.54 & 9993.52320457797 & 3296.01679542203 \tabularnewline
31 & 13032.8 & 9993.52320457797 & 3039.27679542203 \tabularnewline
32 & 13561.74 & 9993.52320457797 & 3568.21679542203 \tabularnewline
33 & 10938.21 & 8418.03367231638 & 2520.17632768362 \tabularnewline
34 & 6828.13 & 8418.03367231638 & -1589.90367231638 \tabularnewline
35 & 8162.55 & 9993.52320457797 & -1830.97320457797 \tabularnewline
36 & 9266.21 & 9993.52320457797 & -727.31320457797 \tabularnewline
37 & 9939.7933333333 & 9993.52320457797 & -53.7298712446682 \tabularnewline
38 & 8418.69 & 9993.52320457797 & -1574.83320457797 \tabularnewline
39 & 10601.95 & 9993.52320457797 & 608.426795422032 \tabularnewline
40 & 9099.52 & 9993.52320457797 & -894.003204577968 \tabularnewline
41 & 11031.5 & 9993.52320457797 & 1037.97679542203 \tabularnewline
42 & 10263.75 & 9993.52320457797 & 270.226795422032 \tabularnewline
43 & 13712.33 & 9993.52320457797 & 3718.80679542203 \tabularnewline
44 & 13481.51 & 9993.52320457797 & 3487.98679542203 \tabularnewline
45 & 7375.38 & 9993.52320457797 & -2618.14320457797 \tabularnewline
46 & 8474.09 & 9993.52320457797 & -1519.43320457797 \tabularnewline
47 & 10880.46 & 9993.52320457797 & 886.936795422031 \tabularnewline
48 & 9359.2 & 9993.52320457797 & -634.323204577968 \tabularnewline
49 & 5612.46 & 9993.52320457797 & -4381.06320457797 \tabularnewline
50 & 9902.15 & 9993.52320457797 & -91.3732045779689 \tabularnewline
51 & 13675.21 & 9993.52320457797 & 3681.68679542203 \tabularnewline
52 & 9109.93 & 9993.52320457797 & -883.593204577968 \tabularnewline
53 & 9922.73 & 8418.03367231638 & 1504.69632768362 \tabularnewline
54 & 6490.87 & 9993.52320457797 & -3502.65320457797 \tabularnewline
55 & 7402.25 & 9993.52320457797 & -2591.27320457797 \tabularnewline
56 & 14693.64 & 9993.52320457797 & 4700.11679542203 \tabularnewline
57 & 10816.9 & 9993.52320457797 & 823.376795422031 \tabularnewline
58 & 9453.04 & 9993.52320457797 & -540.483204577968 \tabularnewline
59 & 6392.32 & 9993.52320457797 & -3601.20320457797 \tabularnewline
60 & 7995.49 & 9993.52320457797 & -1998.03320457797 \tabularnewline
61 & 6378.65 & 9993.52320457797 & -3614.87320457797 \tabularnewline
62 & 8154.58 & 8418.03367231638 & -263.453672316384 \tabularnewline
63 & 10001.77 & 9993.52320457797 & 8.24679542203194 \tabularnewline
64 & 7749.29 & 9993.52320457797 & -2244.23320457797 \tabularnewline
65 & 8335.4 & 9993.52320457797 & -1658.12320457797 \tabularnewline
66 & 8633.02 & 9993.52320457797 & -1360.50320457797 \tabularnewline
67 & 9496.43 & 9993.52320457797 & -497.093204577968 \tabularnewline
68 & 5485.09 & 9993.52320457797 & -4508.43320457797 \tabularnewline
69 & 12899.68 & 9993.52320457797 & 2906.15679542203 \tabularnewline
70 & 9319.5 & 9993.52320457797 & -674.023204577968 \tabularnewline
71 & 9648.48 & 8418.03367231638 & 1230.44632768362 \tabularnewline
72 & 15259.56 & 9993.52320457797 & 5266.03679542203 \tabularnewline
73 & 7341.85 & 9993.52320457797 & -2651.67320457797 \tabularnewline
74 & 10623.54 & 8418.03367231638 & 2205.50632768362 \tabularnewline
75 & 8495.3 & 8418.03367231638 & 77.2663276836156 \tabularnewline
76 & 11227.39 & 9993.52320457797 & 1233.86679542203 \tabularnewline
77 & 8649.58 & 9993.52320457797 & -1343.94320457797 \tabularnewline
78 & 10651.68 & 8418.03367231638 & 2233.64632768362 \tabularnewline
79 & 12959.45 & 8418.03367231638 & 4541.41632768362 \tabularnewline
80 & 10425.98 & 9993.52320457797 & 432.456795422031 \tabularnewline
81 & 8437.09 & 9993.52320457797 & -1556.43320457797 \tabularnewline
82 & 6704.73 & 9993.52320457797 & -3288.79320457797 \tabularnewline
83 & 7365.2 & 9993.52320457797 & -2628.32320457797 \tabularnewline
84 & 9735.73 & 8418.03367231638 & 1317.69632768362 \tabularnewline
85 & 11423.86 & 9993.52320457797 & 1430.33679542203 \tabularnewline
86 & 8446.73 & 9993.52320457797 & -1546.79320457797 \tabularnewline
87 & 8115.67 & 9993.52320457797 & -1877.85320457797 \tabularnewline
88 & 7432.14 & 9993.52320457797 & -2561.38320457797 \tabularnewline
89 & 8028.2633333333 & 8418.03367231638 & -389.770338983083 \tabularnewline
90 & 8106.1333333333 & 9993.52320457797 & -1887.38987124467 \tabularnewline
91 & 7122.57 & 8418.03367231638 & -1295.46367231638 \tabularnewline
92 & 6550.88 & 8418.03367231638 & -1867.15367231638 \tabularnewline
93 & 7519.27 & 9993.52320457797 & -2474.25320457797 \tabularnewline
94 & 5721.45 & 8418.03367231638 & -2696.58367231638 \tabularnewline
95 & 7941.54 & 9993.52320457797 & -2051.98320457797 \tabularnewline
96 & 6734.7 & 8418.03367231638 & -1683.33367231638 \tabularnewline
97 & 9659.92 & 8418.03367231638 & 1241.88632768362 \tabularnewline
98 & 10472.94 & 8418.03367231638 & 2054.90632768362 \tabularnewline
99 & 8335.4533333333 & 9993.52320457797 & -1658.06987124467 \tabularnewline
100 & 7171.57 & 8418.03367231638 & -1246.46367231638 \tabularnewline
101 & 4366.98 & 8418.03367231638 & -4051.05367231638 \tabularnewline
102 & 6905.9 & 9993.52320457797 & -3087.62320457797 \tabularnewline
103 & 6411.9 & 9993.52320457797 & -3581.62320457797 \tabularnewline
104 & 4046.33 & 9993.52320457797 & -5947.19320457797 \tabularnewline
105 & 4520.67 & 9993.52320457797 & -5472.85320457797 \tabularnewline
106 & 8171.44 & 8418.03367231638 & -246.593672316383 \tabularnewline
107 & 7045.03 & 9993.52320457797 & -2948.49320457797 \tabularnewline
108 & 7138.5 & 9993.52320457797 & -2855.02320457797 \tabularnewline
109 & 3540.17 & 8418.03367231638 & -4877.86367231638 \tabularnewline
110 & 12068.39 & 8418.03367231638 & 3650.35632768362 \tabularnewline
111 & 6796.87 & 8418.03367231638 & -1621.16367231638 \tabularnewline
112 & 9300.49 & 8418.03367231638 & 882.456327683616 \tabularnewline
113 & 8714.34 & 8418.03367231638 & 296.306327683616 \tabularnewline
114 & 7139.6 & 9993.52320457797 & -2853.92320457797 \tabularnewline
115 & 9678.67 & 9993.52320457797 & -314.853204577968 \tabularnewline
116 & 10139.58 & 9993.52320457797 & 146.056795422031 \tabularnewline
117 & 9533.68 & 9993.52320457797 & -459.843204577968 \tabularnewline
118 & 9268.45 & 9993.52320457797 & -725.073204577968 \tabularnewline
119 & 5769.62 & 9993.52320457797 & -4223.90320457797 \tabularnewline
120 & 5108.87 & 9993.52320457797 & -4884.65320457797 \tabularnewline
121 & 9521.07 & 9993.52320457797 & -472.453204577969 \tabularnewline
122 & 6015.8 & 9993.52320457797 & -3977.72320457797 \tabularnewline
123 & 7660.52 & 9993.52320457797 & -2333.00320457797 \tabularnewline
124 & 7290.23 & 8418.03367231638 & -1127.80367231638 \tabularnewline
125 & 9303.93 & 9993.52320457797 & -689.593204577968 \tabularnewline
126 & 9820.99 & 9993.52320457797 & -172.533204577969 \tabularnewline
127 & 6982.56 & 8418.03367231638 & -1435.47367231638 \tabularnewline
128 & 6696.29 & 9993.52320457797 & -3297.23320457797 \tabularnewline
129 & 6068.49 & 9993.52320457797 & -3925.03320457797 \tabularnewline
130 & 9784.52 & 9993.52320457797 & -209.003204577968 \tabularnewline
131 & 7368.02 & 8418.03367231638 & -1050.01367231638 \tabularnewline
132 & 8711.65 & 9993.52320457797 & -1281.87320457797 \tabularnewline
133 & 7038.44 & 9993.52320457797 & -2955.08320457797 \tabularnewline
134 & 8736.02 & 9993.52320457797 & -1257.50320457797 \tabularnewline
135 & 12375.84 & 9993.52320457797 & 2382.31679542203 \tabularnewline
136 & 13022.31 & 9993.52320457797 & 3028.78679542203 \tabularnewline
137 & 9815.3 & 9993.52320457797 & -178.223204577969 \tabularnewline
138 & 8057.83 & 8418.03367231638 & -360.203672316384 \tabularnewline
139 & 6213.8 & 8418.03367231638 & -2204.23367231638 \tabularnewline
140 & 9314.64 & 9993.52320457797 & -678.883204577969 \tabularnewline
141 & 11078.19 & 9993.52320457797 & 1084.66679542203 \tabularnewline
142 & 9024.67 & 9993.52320457797 & -968.853204577968 \tabularnewline
143 & 8439.6 & 8418.03367231638 & 21.5663276836167 \tabularnewline
144 & 6591.21 & 9993.52320457797 & -3402.31320457797 \tabularnewline
145 & 6619.7 & 8418.03367231638 & -1798.33367231638 \tabularnewline
146 & 5469.09 & 8418.03367231638 & -2948.94367231638 \tabularnewline
147 & 8972.9633333333 & 8418.03367231638 & 554.929661016917 \tabularnewline
148 & 6410.88 & 8418.03367231638 & -2007.15367231638 \tabularnewline
149 & 8098.2 & 9993.52320457797 & -1895.32320457797 \tabularnewline
150 & 6317.42 & 9993.52320457797 & -3676.10320457797 \tabularnewline
151 & 12560.83 & 9993.52320457797 & 2567.30679542203 \tabularnewline
152 & 6746.34 & 9993.52320457797 & -3247.18320457797 \tabularnewline
153 & 9605.04 & 9993.52320457797 & -388.483204577968 \tabularnewline
154 & 8805.95 & 9993.52320457797 & -1187.57320457797 \tabularnewline
155 & 9692.11 & 9993.52320457797 & -301.413204577968 \tabularnewline
156 & 7445.25 & 9993.52320457797 & -2548.27320457797 \tabularnewline
157 & 10211.75 & 9993.52320457797 & 218.226795422032 \tabularnewline
158 & 11412.21 & 9993.52320457797 & 1418.68679542203 \tabularnewline
159 & 13530.69 & 9993.52320457797 & 3537.16679542203 \tabularnewline
160 & 9906.74 & 9993.52320457797 & -86.7832045779687 \tabularnewline
161 & 14131.19 & 9993.52320457797 & 4137.66679542203 \tabularnewline
162 & 10637.98 & 9993.52320457797 & 644.456795422031 \tabularnewline
163 & 9859.07 & 9993.52320457797 & -134.453204577969 \tabularnewline
164 & 2559.37 & 9993.52320457797 & -7434.15320457797 \tabularnewline
165 & 33644.96 & 9993.52320457797 & 23651.436795422 \tabularnewline
166 & 10267.25 & 9993.52320457797 & 273.726795422032 \tabularnewline
167 & 11146.33 & 8418.03367231638 & 2728.29632768362 \tabularnewline
168 & 5241 & 9993.52320457797 & -4752.52320457797 \tabularnewline
169 & 13003.97 & 9993.52320457797 & 3010.44679542203 \tabularnewline
170 & 18688.75 & 9993.52320457797 & 8695.22679542203 \tabularnewline
171 & 7199.96 & 9993.52320457797 & -2793.56320457797 \tabularnewline
172 & 6908.18 & 9993.52320457797 & -3085.34320457797 \tabularnewline
173 & 9877.23 & 9993.52320457797 & -116.293204577969 \tabularnewline
174 & 10827.25 & 9993.52320457797 & 833.726795422032 \tabularnewline
175 & 7794.09 & 9993.52320457797 & -2199.43320457797 \tabularnewline
176 & 9646.54 & 9993.52320457797 & -346.983204577968 \tabularnewline
177 & 6696.47 & 4162.1025 & 2534.3675 \tabularnewline
178 & 18584.87 & 9993.52320457797 & 8591.34679542203 \tabularnewline
179 & 9530.23 & 9993.52320457797 & -463.293204577969 \tabularnewline
180 & 18205.97 & 9993.52320457797 & 8212.44679542203 \tabularnewline
181 & 6135.08 & 9993.52320457797 & -3858.44320457797 \tabularnewline
182 & 7490.62 & 4162.1025 & 3328.5175 \tabularnewline
183 & 29 & 8418.03367231638 & -8389.03367231638 \tabularnewline
184 & 13299.3 & 9993.52320457797 & 3305.77679542203 \tabularnewline
185 & 12630.98 & 9993.52320457797 & 2637.45679542203 \tabularnewline
186 & 10972.35 & 9993.52320457797 & 978.826795422032 \tabularnewline
187 & 11 & 4162.1025 & -4151.1025 \tabularnewline
188 & 13588.91 & 9993.52320457797 & 3595.38679542203 \tabularnewline
189 & 13512.24 & 9993.52320457797 & 3518.71679542203 \tabularnewline
190 & 17165.86 & 9993.52320457797 & 7172.33679542203 \tabularnewline
191 & 8309.26 & 8418.03367231638 & -108.773672316383 \tabularnewline
192 & 8792.23 & 9993.52320457797 & -1201.29320457797 \tabularnewline
193 & 6454.77 & 9993.52320457797 & -3538.75320457797 \tabularnewline
194 & 32946.36 & 9993.52320457797 & 22952.836795422 \tabularnewline
195 & 7921.97 & 4162.1025 & 3759.8675 \tabularnewline
196 & 11123.14 & 9993.52320457797 & 1129.61679542203 \tabularnewline
197 & 10573.35 & 9993.52320457797 & 579.826795422032 \tabularnewline
198 & 12378.91 & 9993.52320457797 & 2385.38679542203 \tabularnewline
199 & 1455.68 & 9993.52320457797 & -8537.84320457797 \tabularnewline
200 & 7217.3 & 9993.52320457797 & -2776.22320457797 \tabularnewline
201 & 11346.25 & 9993.52320457797 & 1352.72679542203 \tabularnewline
202 & 16131.85 & 9993.52320457797 & 6138.32679542203 \tabularnewline
203 & 6925.63 & 9993.52320457797 & -3067.89320457797 \tabularnewline
204 & 12370.82 & 9993.52320457797 & 2377.29679542203 \tabularnewline
205 & 9622.88 & 9993.52320457797 & -370.643204577967 \tabularnewline
206 & 8248.46 & 9993.52320457797 & -1745.06320457797 \tabularnewline
207 & 11662.12 & 9993.52320457797 & 1668.59679542203 \tabularnewline
208 & 11351.18 & 9993.52320457797 & 1357.65679542203 \tabularnewline
209 & 10341.69 & 9993.52320457797 & 348.166795422032 \tabularnewline
210 & 22073.74 & 9993.52320457797 & 12080.216795422 \tabularnewline
211 & 11089.44 & 9993.52320457797 & 1095.91679542203 \tabularnewline
212 & 12054.64 & 9993.52320457797 & 2061.11679542203 \tabularnewline
213 & 19061.32 & 9993.52320457797 & 9067.79679542203 \tabularnewline
214 & 13629.67 & 8418.03367231638 & 5211.63632768362 \tabularnewline
215 & 7570.85 & 9993.52320457797 & -2422.67320457797 \tabularnewline
216 & 11334.08 & 9993.52320457797 & 1340.55679542203 \tabularnewline
217 & 12604.63 & 9993.52320457797 & 2611.10679542203 \tabularnewline
218 & 11526.61 & 9993.52320457797 & 1533.08679542203 \tabularnewline
219 & 18940.15 & 9993.52320457797 & 8946.62679542203 \tabularnewline
220 & 0 & 4162.1025 & -4162.1025 \tabularnewline
221 & 12121.61 & 8418.03367231638 & 3703.57632768362 \tabularnewline
222 & 9688.36 & 9993.52320457797 & -305.163204577968 \tabularnewline
223 & 13803.76 & 8418.03367231638 & 5385.72632768362 \tabularnewline
224 & 10129.26 & 9993.52320457797 & 135.736795422032 \tabularnewline
225 & 7444.32 & 9993.52320457797 & -2549.20320457797 \tabularnewline
226 & 14591.69 & 9993.52320457797 & 4598.16679542203 \tabularnewline
227 & 8870.34 & 8418.03367231638 & 452.306327683616 \tabularnewline
228 & 9752.65 & 9993.52320457797 & -240.873204577969 \tabularnewline
229 & 7683.23 & 9993.52320457797 & -2310.29320457797 \tabularnewline
230 & 10226.02 & 9993.52320457797 & 232.496795422032 \tabularnewline
231 & 7141.96 & 9993.52320457797 & -2851.56320457797 \tabularnewline
232 & 14159.91 & 9993.52320457797 & 4166.38679542203 \tabularnewline
233 & 9635.52 & 9993.52320457797 & -358.003204577968 \tabularnewline
234 & 7360.02 & 4162.1025 & 3197.9175 \tabularnewline
235 & 10485.31 & 9993.52320457797 & 491.786795422033 \tabularnewline
236 & 9096.53 & 9993.52320457797 & -896.99320457797 \tabularnewline
237 & 13043.26 & 9993.52320457797 & 3049.73679542203 \tabularnewline
238 & 8228.39 & 9993.52320457797 & -1765.13320457797 \tabularnewline
239 & 11392.94 & 9993.52320457797 & 1399.41679542203 \tabularnewline
240 & 14565.62 & 9993.52320457797 & 4572.09679542203 \tabularnewline
241 & 6399.88 & 8418.03367231638 & -2018.15367231638 \tabularnewline
242 & 8761.83 & 8418.03367231638 & 343.796327683616 \tabularnewline
243 & 4324.31 & 8418.03367231638 & -4093.72367231638 \tabularnewline
244 & 15740.78 & 8418.03367231638 & 7322.74632768362 \tabularnewline
245 & 9649.98 & 9993.52320457797 & -343.543204577969 \tabularnewline
246 & 12950.09 & 9993.52320457797 & 2956.56679542203 \tabularnewline
247 & 10007.32 & 9993.52320457797 & 13.7967954220312 \tabularnewline
248 & 13029.74 & 9993.52320457797 & 3036.21679542203 \tabularnewline
249 & 14456.69 & 9993.52320457797 & 4463.16679542203 \tabularnewline
250 & 312.32 & 9993.52320457797 & -9681.20320457797 \tabularnewline
251 & 8000.23 & 9993.52320457797 & -1993.29320457797 \tabularnewline
252 & 12670.05 & 9993.52320457797 & 2676.52679542203 \tabularnewline
253 & 10443.82 & 9993.52320457797 & 450.296795422031 \tabularnewline
254 & 7380.8 & 9993.52320457797 & -2612.72320457797 \tabularnewline
255 & 12364.37 & 9993.52320457797 & 2370.84679542203 \tabularnewline
256 & 7685.11 & 9993.52320457797 & -2308.41320457797 \tabularnewline
257 & 13917.62 & 9993.52320457797 & 3924.09679542203 \tabularnewline
258 & 4260.96 & 9993.52320457797 & -5732.56320457797 \tabularnewline
259 & 4263.65 & 9993.52320457797 & -5729.87320457797 \tabularnewline
260 & 9808.16 & 9993.52320457797 & -185.363204577969 \tabularnewline
261 & 503.93 & 4162.1025 & -3658.1725 \tabularnewline
262 & 6106.86 & 9993.52320457797 & -3886.66320457797 \tabularnewline
263 & 9756.57 & 9993.52320457797 & -236.953204577969 \tabularnewline
264 & 7559.88 & 9993.52320457797 & -2433.64320457797 \tabularnewline
265 & 9480 & 9993.52320457797 & -513.523204577968 \tabularnewline
266 & 10012.88 & 9993.52320457797 & 19.3567954220325 \tabularnewline
267 & 14942.56 & 9993.52320457797 & 4949.03679542203 \tabularnewline
268 & 10118.75 & 9993.52320457797 & 125.226795422032 \tabularnewline
269 & 9503.11 & 8418.03367231638 & 1085.07632768362 \tabularnewline
270 & 9389.23 & 8418.03367231638 & 971.196327683616 \tabularnewline
271 & 2078.3 & 9993.52320457797 & -7915.22320457797 \tabularnewline
272 & 5959.4 & 8418.03367231638 & -2458.63367231638 \tabularnewline
273 & 4008.6 & 4162.1025 & -153.5025 \tabularnewline
274 & 11099.22 & 9993.52320457797 & 1105.69679542203 \tabularnewline
275 & 12040.95 & 9993.52320457797 & 2047.42679542203 \tabularnewline
276 & 7242.24 & 9993.52320457797 & -2751.28320457797 \tabularnewline
277 & 19323.43 & 9993.52320457797 & 9329.90679542203 \tabularnewline
278 & 8379.81 & 8418.03367231638 & -38.2236723163824 \tabularnewline
279 & 3626.59 & 8418.03367231638 & -4791.44367231638 \tabularnewline
280 & 906.04 & 8418.03367231638 & -7511.99367231638 \tabularnewline
281 & 4100.63 & 9993.52320457797 & -5892.89320457797 \tabularnewline
282 & 14625.77 & 9993.52320457797 & 4632.24679542203 \tabularnewline
283 & 6894.78 & 9993.52320457797 & -3098.74320457797 \tabularnewline
284 & 7148.2 & 9993.52320457797 & -2845.32320457797 \tabularnewline
285 & 8562.89 & 9993.52320457797 & -1430.63320457797 \tabularnewline
286 & 8514.39 & 9993.52320457797 & -1479.13320457797 \tabularnewline
287 & 5641.34 & 9993.52320457797 & -4352.18320457797 \tabularnewline
288 & 8592.5 & 9993.52320457797 & -1401.02320457797 \tabularnewline
289 & 13820.83 & 9993.52320457797 & 3827.30679542203 \tabularnewline
290 & 15285.88 & 9993.52320457797 & 5292.35679542203 \tabularnewline
291 & 10996.04 & 9993.52320457797 & 1002.51679542203 \tabularnewline
292 & 8228.67 & 9993.52320457797 & -1764.85320457797 \tabularnewline
293 & 7955.02 & 8418.03367231638 & -463.013672316383 \tabularnewline
294 & 7690.87 & 4162.1025 & 3528.7675 \tabularnewline
295 & 0 & 9993.52320457797 & -9993.52320457797 \tabularnewline
296 & 7861.3 & 9993.52320457797 & -2132.22320457797 \tabularnewline
297 & 13104.85 & 9993.52320457797 & 3111.32679542203 \tabularnewline
298 & 5915.81 & 4162.1025 & 1753.7075 \tabularnewline
299 & 5504.23 & 9993.52320457797 & -4489.29320457797 \tabularnewline
300 & 402.04 & 4162.1025 & -3760.0625 \tabularnewline
301 & 6631.44 & 9993.52320457797 & -3362.08320457797 \tabularnewline
302 & 8687.31 & 9993.52320457797 & -1306.21320457797 \tabularnewline
303 & 1943.9 & 4162.1025 & -2218.2025 \tabularnewline
304 & 8117.73 & 9993.52320457797 & -1875.79320457797 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=165837&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]10628.07[/C][C]9993.52320457797[/C][C]634.546795422031[/C][/ROW]
[ROW][C]2[/C][C]9399.62[/C][C]9993.52320457797[/C][C]-593.90320457797[/C][/ROW]
[ROW][C]3[/C][C]10195.34[/C][C]9993.52320457797[/C][C]201.816795422032[/C][/ROW]
[ROW][C]4[/C][C]9859.71[/C][C]9993.52320457797[/C][C]-133.813204577969[/C][/ROW]
[ROW][C]5[/C][C]14035.06[/C][C]8418.03367231638[/C][C]5617.02632768362[/C][/ROW]
[ROW][C]6[/C][C]7098.6066666667[/C][C]9993.52320457797[/C][C]-2894.91653791127[/C][/ROW]
[ROW][C]7[/C][C]12238.72[/C][C]9993.52320457797[/C][C]2245.19679542203[/C][/ROW]
[ROW][C]8[/C][C]10065.46[/C][C]9993.52320457797[/C][C]71.9367954220306[/C][/ROW]
[ROW][C]9[/C][C]10073.38[/C][C]9993.52320457797[/C][C]79.8567954220325[/C][/ROW]
[ROW][C]10[/C][C]8967.41[/C][C]9993.52320457797[/C][C]-1026.11320457797[/C][/ROW]
[ROW][C]11[/C][C]10297.37[/C][C]9993.52320457797[/C][C]303.84679542203[/C][/ROW]
[ROW][C]12[/C][C]13269.69[/C][C]9993.52320457797[/C][C]3276.16679542203[/C][/ROW]
[ROW][C]13[/C][C]12220.8[/C][C]9993.52320457797[/C][C]2227.27679542203[/C][/ROW]
[ROW][C]14[/C][C]12925.83[/C][C]9993.52320457797[/C][C]2932.30679542203[/C][/ROW]
[ROW][C]15[/C][C]7725.8[/C][C]9993.52320457797[/C][C]-2267.72320457797[/C][/ROW]
[ROW][C]16[/C][C]6719.81[/C][C]8418.03367231638[/C][C]-1698.22367231638[/C][/ROW]
[ROW][C]17[/C][C]13210.44[/C][C]8418.03367231638[/C][C]4792.40632768362[/C][/ROW]
[ROW][C]18[/C][C]11290.56[/C][C]9993.52320457797[/C][C]1297.03679542203[/C][/ROW]
[ROW][C]19[/C][C]6876.91[/C][C]9993.52320457797[/C][C]-3116.61320457797[/C][/ROW]
[ROW][C]20[/C][C]8625.92[/C][C]9993.52320457797[/C][C]-1367.60320457797[/C][/ROW]
[ROW][C]21[/C][C]8878.8[/C][C]8418.03367231638[/C][C]460.766327683616[/C][/ROW]
[ROW][C]22[/C][C]11981.92[/C][C]9993.52320457797[/C][C]1988.39679542203[/C][/ROW]
[ROW][C]23[/C][C]11012.17[/C][C]9993.52320457797[/C][C]1018.64679542203[/C][/ROW]
[ROW][C]24[/C][C]7462.03[/C][C]9993.52320457797[/C][C]-2531.49320457797[/C][/ROW]
[ROW][C]25[/C][C]12684.49[/C][C]8418.03367231638[/C][C]4266.45632768362[/C][/ROW]
[ROW][C]26[/C][C]13609.25[/C][C]9993.52320457797[/C][C]3615.72679542203[/C][/ROW]
[ROW][C]27[/C][C]9328.75[/C][C]9993.52320457797[/C][C]-664.773204577968[/C][/ROW]
[ROW][C]28[/C][C]13535.14[/C][C]9993.52320457797[/C][C]3541.61679542203[/C][/ROW]
[ROW][C]29[/C][C]8075.94[/C][C]8418.03367231638[/C][C]-342.093672316383[/C][/ROW]
[ROW][C]30[/C][C]13289.54[/C][C]9993.52320457797[/C][C]3296.01679542203[/C][/ROW]
[ROW][C]31[/C][C]13032.8[/C][C]9993.52320457797[/C][C]3039.27679542203[/C][/ROW]
[ROW][C]32[/C][C]13561.74[/C][C]9993.52320457797[/C][C]3568.21679542203[/C][/ROW]
[ROW][C]33[/C][C]10938.21[/C][C]8418.03367231638[/C][C]2520.17632768362[/C][/ROW]
[ROW][C]34[/C][C]6828.13[/C][C]8418.03367231638[/C][C]-1589.90367231638[/C][/ROW]
[ROW][C]35[/C][C]8162.55[/C][C]9993.52320457797[/C][C]-1830.97320457797[/C][/ROW]
[ROW][C]36[/C][C]9266.21[/C][C]9993.52320457797[/C][C]-727.31320457797[/C][/ROW]
[ROW][C]37[/C][C]9939.7933333333[/C][C]9993.52320457797[/C][C]-53.7298712446682[/C][/ROW]
[ROW][C]38[/C][C]8418.69[/C][C]9993.52320457797[/C][C]-1574.83320457797[/C][/ROW]
[ROW][C]39[/C][C]10601.95[/C][C]9993.52320457797[/C][C]608.426795422032[/C][/ROW]
[ROW][C]40[/C][C]9099.52[/C][C]9993.52320457797[/C][C]-894.003204577968[/C][/ROW]
[ROW][C]41[/C][C]11031.5[/C][C]9993.52320457797[/C][C]1037.97679542203[/C][/ROW]
[ROW][C]42[/C][C]10263.75[/C][C]9993.52320457797[/C][C]270.226795422032[/C][/ROW]
[ROW][C]43[/C][C]13712.33[/C][C]9993.52320457797[/C][C]3718.80679542203[/C][/ROW]
[ROW][C]44[/C][C]13481.51[/C][C]9993.52320457797[/C][C]3487.98679542203[/C][/ROW]
[ROW][C]45[/C][C]7375.38[/C][C]9993.52320457797[/C][C]-2618.14320457797[/C][/ROW]
[ROW][C]46[/C][C]8474.09[/C][C]9993.52320457797[/C][C]-1519.43320457797[/C][/ROW]
[ROW][C]47[/C][C]10880.46[/C][C]9993.52320457797[/C][C]886.936795422031[/C][/ROW]
[ROW][C]48[/C][C]9359.2[/C][C]9993.52320457797[/C][C]-634.323204577968[/C][/ROW]
[ROW][C]49[/C][C]5612.46[/C][C]9993.52320457797[/C][C]-4381.06320457797[/C][/ROW]
[ROW][C]50[/C][C]9902.15[/C][C]9993.52320457797[/C][C]-91.3732045779689[/C][/ROW]
[ROW][C]51[/C][C]13675.21[/C][C]9993.52320457797[/C][C]3681.68679542203[/C][/ROW]
[ROW][C]52[/C][C]9109.93[/C][C]9993.52320457797[/C][C]-883.593204577968[/C][/ROW]
[ROW][C]53[/C][C]9922.73[/C][C]8418.03367231638[/C][C]1504.69632768362[/C][/ROW]
[ROW][C]54[/C][C]6490.87[/C][C]9993.52320457797[/C][C]-3502.65320457797[/C][/ROW]
[ROW][C]55[/C][C]7402.25[/C][C]9993.52320457797[/C][C]-2591.27320457797[/C][/ROW]
[ROW][C]56[/C][C]14693.64[/C][C]9993.52320457797[/C][C]4700.11679542203[/C][/ROW]
[ROW][C]57[/C][C]10816.9[/C][C]9993.52320457797[/C][C]823.376795422031[/C][/ROW]
[ROW][C]58[/C][C]9453.04[/C][C]9993.52320457797[/C][C]-540.483204577968[/C][/ROW]
[ROW][C]59[/C][C]6392.32[/C][C]9993.52320457797[/C][C]-3601.20320457797[/C][/ROW]
[ROW][C]60[/C][C]7995.49[/C][C]9993.52320457797[/C][C]-1998.03320457797[/C][/ROW]
[ROW][C]61[/C][C]6378.65[/C][C]9993.52320457797[/C][C]-3614.87320457797[/C][/ROW]
[ROW][C]62[/C][C]8154.58[/C][C]8418.03367231638[/C][C]-263.453672316384[/C][/ROW]
[ROW][C]63[/C][C]10001.77[/C][C]9993.52320457797[/C][C]8.24679542203194[/C][/ROW]
[ROW][C]64[/C][C]7749.29[/C][C]9993.52320457797[/C][C]-2244.23320457797[/C][/ROW]
[ROW][C]65[/C][C]8335.4[/C][C]9993.52320457797[/C][C]-1658.12320457797[/C][/ROW]
[ROW][C]66[/C][C]8633.02[/C][C]9993.52320457797[/C][C]-1360.50320457797[/C][/ROW]
[ROW][C]67[/C][C]9496.43[/C][C]9993.52320457797[/C][C]-497.093204577968[/C][/ROW]
[ROW][C]68[/C][C]5485.09[/C][C]9993.52320457797[/C][C]-4508.43320457797[/C][/ROW]
[ROW][C]69[/C][C]12899.68[/C][C]9993.52320457797[/C][C]2906.15679542203[/C][/ROW]
[ROW][C]70[/C][C]9319.5[/C][C]9993.52320457797[/C][C]-674.023204577968[/C][/ROW]
[ROW][C]71[/C][C]9648.48[/C][C]8418.03367231638[/C][C]1230.44632768362[/C][/ROW]
[ROW][C]72[/C][C]15259.56[/C][C]9993.52320457797[/C][C]5266.03679542203[/C][/ROW]
[ROW][C]73[/C][C]7341.85[/C][C]9993.52320457797[/C][C]-2651.67320457797[/C][/ROW]
[ROW][C]74[/C][C]10623.54[/C][C]8418.03367231638[/C][C]2205.50632768362[/C][/ROW]
[ROW][C]75[/C][C]8495.3[/C][C]8418.03367231638[/C][C]77.2663276836156[/C][/ROW]
[ROW][C]76[/C][C]11227.39[/C][C]9993.52320457797[/C][C]1233.86679542203[/C][/ROW]
[ROW][C]77[/C][C]8649.58[/C][C]9993.52320457797[/C][C]-1343.94320457797[/C][/ROW]
[ROW][C]78[/C][C]10651.68[/C][C]8418.03367231638[/C][C]2233.64632768362[/C][/ROW]
[ROW][C]79[/C][C]12959.45[/C][C]8418.03367231638[/C][C]4541.41632768362[/C][/ROW]
[ROW][C]80[/C][C]10425.98[/C][C]9993.52320457797[/C][C]432.456795422031[/C][/ROW]
[ROW][C]81[/C][C]8437.09[/C][C]9993.52320457797[/C][C]-1556.43320457797[/C][/ROW]
[ROW][C]82[/C][C]6704.73[/C][C]9993.52320457797[/C][C]-3288.79320457797[/C][/ROW]
[ROW][C]83[/C][C]7365.2[/C][C]9993.52320457797[/C][C]-2628.32320457797[/C][/ROW]
[ROW][C]84[/C][C]9735.73[/C][C]8418.03367231638[/C][C]1317.69632768362[/C][/ROW]
[ROW][C]85[/C][C]11423.86[/C][C]9993.52320457797[/C][C]1430.33679542203[/C][/ROW]
[ROW][C]86[/C][C]8446.73[/C][C]9993.52320457797[/C][C]-1546.79320457797[/C][/ROW]
[ROW][C]87[/C][C]8115.67[/C][C]9993.52320457797[/C][C]-1877.85320457797[/C][/ROW]
[ROW][C]88[/C][C]7432.14[/C][C]9993.52320457797[/C][C]-2561.38320457797[/C][/ROW]
[ROW][C]89[/C][C]8028.2633333333[/C][C]8418.03367231638[/C][C]-389.770338983083[/C][/ROW]
[ROW][C]90[/C][C]8106.1333333333[/C][C]9993.52320457797[/C][C]-1887.38987124467[/C][/ROW]
[ROW][C]91[/C][C]7122.57[/C][C]8418.03367231638[/C][C]-1295.46367231638[/C][/ROW]
[ROW][C]92[/C][C]6550.88[/C][C]8418.03367231638[/C][C]-1867.15367231638[/C][/ROW]
[ROW][C]93[/C][C]7519.27[/C][C]9993.52320457797[/C][C]-2474.25320457797[/C][/ROW]
[ROW][C]94[/C][C]5721.45[/C][C]8418.03367231638[/C][C]-2696.58367231638[/C][/ROW]
[ROW][C]95[/C][C]7941.54[/C][C]9993.52320457797[/C][C]-2051.98320457797[/C][/ROW]
[ROW][C]96[/C][C]6734.7[/C][C]8418.03367231638[/C][C]-1683.33367231638[/C][/ROW]
[ROW][C]97[/C][C]9659.92[/C][C]8418.03367231638[/C][C]1241.88632768362[/C][/ROW]
[ROW][C]98[/C][C]10472.94[/C][C]8418.03367231638[/C][C]2054.90632768362[/C][/ROW]
[ROW][C]99[/C][C]8335.4533333333[/C][C]9993.52320457797[/C][C]-1658.06987124467[/C][/ROW]
[ROW][C]100[/C][C]7171.57[/C][C]8418.03367231638[/C][C]-1246.46367231638[/C][/ROW]
[ROW][C]101[/C][C]4366.98[/C][C]8418.03367231638[/C][C]-4051.05367231638[/C][/ROW]
[ROW][C]102[/C][C]6905.9[/C][C]9993.52320457797[/C][C]-3087.62320457797[/C][/ROW]
[ROW][C]103[/C][C]6411.9[/C][C]9993.52320457797[/C][C]-3581.62320457797[/C][/ROW]
[ROW][C]104[/C][C]4046.33[/C][C]9993.52320457797[/C][C]-5947.19320457797[/C][/ROW]
[ROW][C]105[/C][C]4520.67[/C][C]9993.52320457797[/C][C]-5472.85320457797[/C][/ROW]
[ROW][C]106[/C][C]8171.44[/C][C]8418.03367231638[/C][C]-246.593672316383[/C][/ROW]
[ROW][C]107[/C][C]7045.03[/C][C]9993.52320457797[/C][C]-2948.49320457797[/C][/ROW]
[ROW][C]108[/C][C]7138.5[/C][C]9993.52320457797[/C][C]-2855.02320457797[/C][/ROW]
[ROW][C]109[/C][C]3540.17[/C][C]8418.03367231638[/C][C]-4877.86367231638[/C][/ROW]
[ROW][C]110[/C][C]12068.39[/C][C]8418.03367231638[/C][C]3650.35632768362[/C][/ROW]
[ROW][C]111[/C][C]6796.87[/C][C]8418.03367231638[/C][C]-1621.16367231638[/C][/ROW]
[ROW][C]112[/C][C]9300.49[/C][C]8418.03367231638[/C][C]882.456327683616[/C][/ROW]
[ROW][C]113[/C][C]8714.34[/C][C]8418.03367231638[/C][C]296.306327683616[/C][/ROW]
[ROW][C]114[/C][C]7139.6[/C][C]9993.52320457797[/C][C]-2853.92320457797[/C][/ROW]
[ROW][C]115[/C][C]9678.67[/C][C]9993.52320457797[/C][C]-314.853204577968[/C][/ROW]
[ROW][C]116[/C][C]10139.58[/C][C]9993.52320457797[/C][C]146.056795422031[/C][/ROW]
[ROW][C]117[/C][C]9533.68[/C][C]9993.52320457797[/C][C]-459.843204577968[/C][/ROW]
[ROW][C]118[/C][C]9268.45[/C][C]9993.52320457797[/C][C]-725.073204577968[/C][/ROW]
[ROW][C]119[/C][C]5769.62[/C][C]9993.52320457797[/C][C]-4223.90320457797[/C][/ROW]
[ROW][C]120[/C][C]5108.87[/C][C]9993.52320457797[/C][C]-4884.65320457797[/C][/ROW]
[ROW][C]121[/C][C]9521.07[/C][C]9993.52320457797[/C][C]-472.453204577969[/C][/ROW]
[ROW][C]122[/C][C]6015.8[/C][C]9993.52320457797[/C][C]-3977.72320457797[/C][/ROW]
[ROW][C]123[/C][C]7660.52[/C][C]9993.52320457797[/C][C]-2333.00320457797[/C][/ROW]
[ROW][C]124[/C][C]7290.23[/C][C]8418.03367231638[/C][C]-1127.80367231638[/C][/ROW]
[ROW][C]125[/C][C]9303.93[/C][C]9993.52320457797[/C][C]-689.593204577968[/C][/ROW]
[ROW][C]126[/C][C]9820.99[/C][C]9993.52320457797[/C][C]-172.533204577969[/C][/ROW]
[ROW][C]127[/C][C]6982.56[/C][C]8418.03367231638[/C][C]-1435.47367231638[/C][/ROW]
[ROW][C]128[/C][C]6696.29[/C][C]9993.52320457797[/C][C]-3297.23320457797[/C][/ROW]
[ROW][C]129[/C][C]6068.49[/C][C]9993.52320457797[/C][C]-3925.03320457797[/C][/ROW]
[ROW][C]130[/C][C]9784.52[/C][C]9993.52320457797[/C][C]-209.003204577968[/C][/ROW]
[ROW][C]131[/C][C]7368.02[/C][C]8418.03367231638[/C][C]-1050.01367231638[/C][/ROW]
[ROW][C]132[/C][C]8711.65[/C][C]9993.52320457797[/C][C]-1281.87320457797[/C][/ROW]
[ROW][C]133[/C][C]7038.44[/C][C]9993.52320457797[/C][C]-2955.08320457797[/C][/ROW]
[ROW][C]134[/C][C]8736.02[/C][C]9993.52320457797[/C][C]-1257.50320457797[/C][/ROW]
[ROW][C]135[/C][C]12375.84[/C][C]9993.52320457797[/C][C]2382.31679542203[/C][/ROW]
[ROW][C]136[/C][C]13022.31[/C][C]9993.52320457797[/C][C]3028.78679542203[/C][/ROW]
[ROW][C]137[/C][C]9815.3[/C][C]9993.52320457797[/C][C]-178.223204577969[/C][/ROW]
[ROW][C]138[/C][C]8057.83[/C][C]8418.03367231638[/C][C]-360.203672316384[/C][/ROW]
[ROW][C]139[/C][C]6213.8[/C][C]8418.03367231638[/C][C]-2204.23367231638[/C][/ROW]
[ROW][C]140[/C][C]9314.64[/C][C]9993.52320457797[/C][C]-678.883204577969[/C][/ROW]
[ROW][C]141[/C][C]11078.19[/C][C]9993.52320457797[/C][C]1084.66679542203[/C][/ROW]
[ROW][C]142[/C][C]9024.67[/C][C]9993.52320457797[/C][C]-968.853204577968[/C][/ROW]
[ROW][C]143[/C][C]8439.6[/C][C]8418.03367231638[/C][C]21.5663276836167[/C][/ROW]
[ROW][C]144[/C][C]6591.21[/C][C]9993.52320457797[/C][C]-3402.31320457797[/C][/ROW]
[ROW][C]145[/C][C]6619.7[/C][C]8418.03367231638[/C][C]-1798.33367231638[/C][/ROW]
[ROW][C]146[/C][C]5469.09[/C][C]8418.03367231638[/C][C]-2948.94367231638[/C][/ROW]
[ROW][C]147[/C][C]8972.9633333333[/C][C]8418.03367231638[/C][C]554.929661016917[/C][/ROW]
[ROW][C]148[/C][C]6410.88[/C][C]8418.03367231638[/C][C]-2007.15367231638[/C][/ROW]
[ROW][C]149[/C][C]8098.2[/C][C]9993.52320457797[/C][C]-1895.32320457797[/C][/ROW]
[ROW][C]150[/C][C]6317.42[/C][C]9993.52320457797[/C][C]-3676.10320457797[/C][/ROW]
[ROW][C]151[/C][C]12560.83[/C][C]9993.52320457797[/C][C]2567.30679542203[/C][/ROW]
[ROW][C]152[/C][C]6746.34[/C][C]9993.52320457797[/C][C]-3247.18320457797[/C][/ROW]
[ROW][C]153[/C][C]9605.04[/C][C]9993.52320457797[/C][C]-388.483204577968[/C][/ROW]
[ROW][C]154[/C][C]8805.95[/C][C]9993.52320457797[/C][C]-1187.57320457797[/C][/ROW]
[ROW][C]155[/C][C]9692.11[/C][C]9993.52320457797[/C][C]-301.413204577968[/C][/ROW]
[ROW][C]156[/C][C]7445.25[/C][C]9993.52320457797[/C][C]-2548.27320457797[/C][/ROW]
[ROW][C]157[/C][C]10211.75[/C][C]9993.52320457797[/C][C]218.226795422032[/C][/ROW]
[ROW][C]158[/C][C]11412.21[/C][C]9993.52320457797[/C][C]1418.68679542203[/C][/ROW]
[ROW][C]159[/C][C]13530.69[/C][C]9993.52320457797[/C][C]3537.16679542203[/C][/ROW]
[ROW][C]160[/C][C]9906.74[/C][C]9993.52320457797[/C][C]-86.7832045779687[/C][/ROW]
[ROW][C]161[/C][C]14131.19[/C][C]9993.52320457797[/C][C]4137.66679542203[/C][/ROW]
[ROW][C]162[/C][C]10637.98[/C][C]9993.52320457797[/C][C]644.456795422031[/C][/ROW]
[ROW][C]163[/C][C]9859.07[/C][C]9993.52320457797[/C][C]-134.453204577969[/C][/ROW]
[ROW][C]164[/C][C]2559.37[/C][C]9993.52320457797[/C][C]-7434.15320457797[/C][/ROW]
[ROW][C]165[/C][C]33644.96[/C][C]9993.52320457797[/C][C]23651.436795422[/C][/ROW]
[ROW][C]166[/C][C]10267.25[/C][C]9993.52320457797[/C][C]273.726795422032[/C][/ROW]
[ROW][C]167[/C][C]11146.33[/C][C]8418.03367231638[/C][C]2728.29632768362[/C][/ROW]
[ROW][C]168[/C][C]5241[/C][C]9993.52320457797[/C][C]-4752.52320457797[/C][/ROW]
[ROW][C]169[/C][C]13003.97[/C][C]9993.52320457797[/C][C]3010.44679542203[/C][/ROW]
[ROW][C]170[/C][C]18688.75[/C][C]9993.52320457797[/C][C]8695.22679542203[/C][/ROW]
[ROW][C]171[/C][C]7199.96[/C][C]9993.52320457797[/C][C]-2793.56320457797[/C][/ROW]
[ROW][C]172[/C][C]6908.18[/C][C]9993.52320457797[/C][C]-3085.34320457797[/C][/ROW]
[ROW][C]173[/C][C]9877.23[/C][C]9993.52320457797[/C][C]-116.293204577969[/C][/ROW]
[ROW][C]174[/C][C]10827.25[/C][C]9993.52320457797[/C][C]833.726795422032[/C][/ROW]
[ROW][C]175[/C][C]7794.09[/C][C]9993.52320457797[/C][C]-2199.43320457797[/C][/ROW]
[ROW][C]176[/C][C]9646.54[/C][C]9993.52320457797[/C][C]-346.983204577968[/C][/ROW]
[ROW][C]177[/C][C]6696.47[/C][C]4162.1025[/C][C]2534.3675[/C][/ROW]
[ROW][C]178[/C][C]18584.87[/C][C]9993.52320457797[/C][C]8591.34679542203[/C][/ROW]
[ROW][C]179[/C][C]9530.23[/C][C]9993.52320457797[/C][C]-463.293204577969[/C][/ROW]
[ROW][C]180[/C][C]18205.97[/C][C]9993.52320457797[/C][C]8212.44679542203[/C][/ROW]
[ROW][C]181[/C][C]6135.08[/C][C]9993.52320457797[/C][C]-3858.44320457797[/C][/ROW]
[ROW][C]182[/C][C]7490.62[/C][C]4162.1025[/C][C]3328.5175[/C][/ROW]
[ROW][C]183[/C][C]29[/C][C]8418.03367231638[/C][C]-8389.03367231638[/C][/ROW]
[ROW][C]184[/C][C]13299.3[/C][C]9993.52320457797[/C][C]3305.77679542203[/C][/ROW]
[ROW][C]185[/C][C]12630.98[/C][C]9993.52320457797[/C][C]2637.45679542203[/C][/ROW]
[ROW][C]186[/C][C]10972.35[/C][C]9993.52320457797[/C][C]978.826795422032[/C][/ROW]
[ROW][C]187[/C][C]11[/C][C]4162.1025[/C][C]-4151.1025[/C][/ROW]
[ROW][C]188[/C][C]13588.91[/C][C]9993.52320457797[/C][C]3595.38679542203[/C][/ROW]
[ROW][C]189[/C][C]13512.24[/C][C]9993.52320457797[/C][C]3518.71679542203[/C][/ROW]
[ROW][C]190[/C][C]17165.86[/C][C]9993.52320457797[/C][C]7172.33679542203[/C][/ROW]
[ROW][C]191[/C][C]8309.26[/C][C]8418.03367231638[/C][C]-108.773672316383[/C][/ROW]
[ROW][C]192[/C][C]8792.23[/C][C]9993.52320457797[/C][C]-1201.29320457797[/C][/ROW]
[ROW][C]193[/C][C]6454.77[/C][C]9993.52320457797[/C][C]-3538.75320457797[/C][/ROW]
[ROW][C]194[/C][C]32946.36[/C][C]9993.52320457797[/C][C]22952.836795422[/C][/ROW]
[ROW][C]195[/C][C]7921.97[/C][C]4162.1025[/C][C]3759.8675[/C][/ROW]
[ROW][C]196[/C][C]11123.14[/C][C]9993.52320457797[/C][C]1129.61679542203[/C][/ROW]
[ROW][C]197[/C][C]10573.35[/C][C]9993.52320457797[/C][C]579.826795422032[/C][/ROW]
[ROW][C]198[/C][C]12378.91[/C][C]9993.52320457797[/C][C]2385.38679542203[/C][/ROW]
[ROW][C]199[/C][C]1455.68[/C][C]9993.52320457797[/C][C]-8537.84320457797[/C][/ROW]
[ROW][C]200[/C][C]7217.3[/C][C]9993.52320457797[/C][C]-2776.22320457797[/C][/ROW]
[ROW][C]201[/C][C]11346.25[/C][C]9993.52320457797[/C][C]1352.72679542203[/C][/ROW]
[ROW][C]202[/C][C]16131.85[/C][C]9993.52320457797[/C][C]6138.32679542203[/C][/ROW]
[ROW][C]203[/C][C]6925.63[/C][C]9993.52320457797[/C][C]-3067.89320457797[/C][/ROW]
[ROW][C]204[/C][C]12370.82[/C][C]9993.52320457797[/C][C]2377.29679542203[/C][/ROW]
[ROW][C]205[/C][C]9622.88[/C][C]9993.52320457797[/C][C]-370.643204577967[/C][/ROW]
[ROW][C]206[/C][C]8248.46[/C][C]9993.52320457797[/C][C]-1745.06320457797[/C][/ROW]
[ROW][C]207[/C][C]11662.12[/C][C]9993.52320457797[/C][C]1668.59679542203[/C][/ROW]
[ROW][C]208[/C][C]11351.18[/C][C]9993.52320457797[/C][C]1357.65679542203[/C][/ROW]
[ROW][C]209[/C][C]10341.69[/C][C]9993.52320457797[/C][C]348.166795422032[/C][/ROW]
[ROW][C]210[/C][C]22073.74[/C][C]9993.52320457797[/C][C]12080.216795422[/C][/ROW]
[ROW][C]211[/C][C]11089.44[/C][C]9993.52320457797[/C][C]1095.91679542203[/C][/ROW]
[ROW][C]212[/C][C]12054.64[/C][C]9993.52320457797[/C][C]2061.11679542203[/C][/ROW]
[ROW][C]213[/C][C]19061.32[/C][C]9993.52320457797[/C][C]9067.79679542203[/C][/ROW]
[ROW][C]214[/C][C]13629.67[/C][C]8418.03367231638[/C][C]5211.63632768362[/C][/ROW]
[ROW][C]215[/C][C]7570.85[/C][C]9993.52320457797[/C][C]-2422.67320457797[/C][/ROW]
[ROW][C]216[/C][C]11334.08[/C][C]9993.52320457797[/C][C]1340.55679542203[/C][/ROW]
[ROW][C]217[/C][C]12604.63[/C][C]9993.52320457797[/C][C]2611.10679542203[/C][/ROW]
[ROW][C]218[/C][C]11526.61[/C][C]9993.52320457797[/C][C]1533.08679542203[/C][/ROW]
[ROW][C]219[/C][C]18940.15[/C][C]9993.52320457797[/C][C]8946.62679542203[/C][/ROW]
[ROW][C]220[/C][C]0[/C][C]4162.1025[/C][C]-4162.1025[/C][/ROW]
[ROW][C]221[/C][C]12121.61[/C][C]8418.03367231638[/C][C]3703.57632768362[/C][/ROW]
[ROW][C]222[/C][C]9688.36[/C][C]9993.52320457797[/C][C]-305.163204577968[/C][/ROW]
[ROW][C]223[/C][C]13803.76[/C][C]8418.03367231638[/C][C]5385.72632768362[/C][/ROW]
[ROW][C]224[/C][C]10129.26[/C][C]9993.52320457797[/C][C]135.736795422032[/C][/ROW]
[ROW][C]225[/C][C]7444.32[/C][C]9993.52320457797[/C][C]-2549.20320457797[/C][/ROW]
[ROW][C]226[/C][C]14591.69[/C][C]9993.52320457797[/C][C]4598.16679542203[/C][/ROW]
[ROW][C]227[/C][C]8870.34[/C][C]8418.03367231638[/C][C]452.306327683616[/C][/ROW]
[ROW][C]228[/C][C]9752.65[/C][C]9993.52320457797[/C][C]-240.873204577969[/C][/ROW]
[ROW][C]229[/C][C]7683.23[/C][C]9993.52320457797[/C][C]-2310.29320457797[/C][/ROW]
[ROW][C]230[/C][C]10226.02[/C][C]9993.52320457797[/C][C]232.496795422032[/C][/ROW]
[ROW][C]231[/C][C]7141.96[/C][C]9993.52320457797[/C][C]-2851.56320457797[/C][/ROW]
[ROW][C]232[/C][C]14159.91[/C][C]9993.52320457797[/C][C]4166.38679542203[/C][/ROW]
[ROW][C]233[/C][C]9635.52[/C][C]9993.52320457797[/C][C]-358.003204577968[/C][/ROW]
[ROW][C]234[/C][C]7360.02[/C][C]4162.1025[/C][C]3197.9175[/C][/ROW]
[ROW][C]235[/C][C]10485.31[/C][C]9993.52320457797[/C][C]491.786795422033[/C][/ROW]
[ROW][C]236[/C][C]9096.53[/C][C]9993.52320457797[/C][C]-896.99320457797[/C][/ROW]
[ROW][C]237[/C][C]13043.26[/C][C]9993.52320457797[/C][C]3049.73679542203[/C][/ROW]
[ROW][C]238[/C][C]8228.39[/C][C]9993.52320457797[/C][C]-1765.13320457797[/C][/ROW]
[ROW][C]239[/C][C]11392.94[/C][C]9993.52320457797[/C][C]1399.41679542203[/C][/ROW]
[ROW][C]240[/C][C]14565.62[/C][C]9993.52320457797[/C][C]4572.09679542203[/C][/ROW]
[ROW][C]241[/C][C]6399.88[/C][C]8418.03367231638[/C][C]-2018.15367231638[/C][/ROW]
[ROW][C]242[/C][C]8761.83[/C][C]8418.03367231638[/C][C]343.796327683616[/C][/ROW]
[ROW][C]243[/C][C]4324.31[/C][C]8418.03367231638[/C][C]-4093.72367231638[/C][/ROW]
[ROW][C]244[/C][C]15740.78[/C][C]8418.03367231638[/C][C]7322.74632768362[/C][/ROW]
[ROW][C]245[/C][C]9649.98[/C][C]9993.52320457797[/C][C]-343.543204577969[/C][/ROW]
[ROW][C]246[/C][C]12950.09[/C][C]9993.52320457797[/C][C]2956.56679542203[/C][/ROW]
[ROW][C]247[/C][C]10007.32[/C][C]9993.52320457797[/C][C]13.7967954220312[/C][/ROW]
[ROW][C]248[/C][C]13029.74[/C][C]9993.52320457797[/C][C]3036.21679542203[/C][/ROW]
[ROW][C]249[/C][C]14456.69[/C][C]9993.52320457797[/C][C]4463.16679542203[/C][/ROW]
[ROW][C]250[/C][C]312.32[/C][C]9993.52320457797[/C][C]-9681.20320457797[/C][/ROW]
[ROW][C]251[/C][C]8000.23[/C][C]9993.52320457797[/C][C]-1993.29320457797[/C][/ROW]
[ROW][C]252[/C][C]12670.05[/C][C]9993.52320457797[/C][C]2676.52679542203[/C][/ROW]
[ROW][C]253[/C][C]10443.82[/C][C]9993.52320457797[/C][C]450.296795422031[/C][/ROW]
[ROW][C]254[/C][C]7380.8[/C][C]9993.52320457797[/C][C]-2612.72320457797[/C][/ROW]
[ROW][C]255[/C][C]12364.37[/C][C]9993.52320457797[/C][C]2370.84679542203[/C][/ROW]
[ROW][C]256[/C][C]7685.11[/C][C]9993.52320457797[/C][C]-2308.41320457797[/C][/ROW]
[ROW][C]257[/C][C]13917.62[/C][C]9993.52320457797[/C][C]3924.09679542203[/C][/ROW]
[ROW][C]258[/C][C]4260.96[/C][C]9993.52320457797[/C][C]-5732.56320457797[/C][/ROW]
[ROW][C]259[/C][C]4263.65[/C][C]9993.52320457797[/C][C]-5729.87320457797[/C][/ROW]
[ROW][C]260[/C][C]9808.16[/C][C]9993.52320457797[/C][C]-185.363204577969[/C][/ROW]
[ROW][C]261[/C][C]503.93[/C][C]4162.1025[/C][C]-3658.1725[/C][/ROW]
[ROW][C]262[/C][C]6106.86[/C][C]9993.52320457797[/C][C]-3886.66320457797[/C][/ROW]
[ROW][C]263[/C][C]9756.57[/C][C]9993.52320457797[/C][C]-236.953204577969[/C][/ROW]
[ROW][C]264[/C][C]7559.88[/C][C]9993.52320457797[/C][C]-2433.64320457797[/C][/ROW]
[ROW][C]265[/C][C]9480[/C][C]9993.52320457797[/C][C]-513.523204577968[/C][/ROW]
[ROW][C]266[/C][C]10012.88[/C][C]9993.52320457797[/C][C]19.3567954220325[/C][/ROW]
[ROW][C]267[/C][C]14942.56[/C][C]9993.52320457797[/C][C]4949.03679542203[/C][/ROW]
[ROW][C]268[/C][C]10118.75[/C][C]9993.52320457797[/C][C]125.226795422032[/C][/ROW]
[ROW][C]269[/C][C]9503.11[/C][C]8418.03367231638[/C][C]1085.07632768362[/C][/ROW]
[ROW][C]270[/C][C]9389.23[/C][C]8418.03367231638[/C][C]971.196327683616[/C][/ROW]
[ROW][C]271[/C][C]2078.3[/C][C]9993.52320457797[/C][C]-7915.22320457797[/C][/ROW]
[ROW][C]272[/C][C]5959.4[/C][C]8418.03367231638[/C][C]-2458.63367231638[/C][/ROW]
[ROW][C]273[/C][C]4008.6[/C][C]4162.1025[/C][C]-153.5025[/C][/ROW]
[ROW][C]274[/C][C]11099.22[/C][C]9993.52320457797[/C][C]1105.69679542203[/C][/ROW]
[ROW][C]275[/C][C]12040.95[/C][C]9993.52320457797[/C][C]2047.42679542203[/C][/ROW]
[ROW][C]276[/C][C]7242.24[/C][C]9993.52320457797[/C][C]-2751.28320457797[/C][/ROW]
[ROW][C]277[/C][C]19323.43[/C][C]9993.52320457797[/C][C]9329.90679542203[/C][/ROW]
[ROW][C]278[/C][C]8379.81[/C][C]8418.03367231638[/C][C]-38.2236723163824[/C][/ROW]
[ROW][C]279[/C][C]3626.59[/C][C]8418.03367231638[/C][C]-4791.44367231638[/C][/ROW]
[ROW][C]280[/C][C]906.04[/C][C]8418.03367231638[/C][C]-7511.99367231638[/C][/ROW]
[ROW][C]281[/C][C]4100.63[/C][C]9993.52320457797[/C][C]-5892.89320457797[/C][/ROW]
[ROW][C]282[/C][C]14625.77[/C][C]9993.52320457797[/C][C]4632.24679542203[/C][/ROW]
[ROW][C]283[/C][C]6894.78[/C][C]9993.52320457797[/C][C]-3098.74320457797[/C][/ROW]
[ROW][C]284[/C][C]7148.2[/C][C]9993.52320457797[/C][C]-2845.32320457797[/C][/ROW]
[ROW][C]285[/C][C]8562.89[/C][C]9993.52320457797[/C][C]-1430.63320457797[/C][/ROW]
[ROW][C]286[/C][C]8514.39[/C][C]9993.52320457797[/C][C]-1479.13320457797[/C][/ROW]
[ROW][C]287[/C][C]5641.34[/C][C]9993.52320457797[/C][C]-4352.18320457797[/C][/ROW]
[ROW][C]288[/C][C]8592.5[/C][C]9993.52320457797[/C][C]-1401.02320457797[/C][/ROW]
[ROW][C]289[/C][C]13820.83[/C][C]9993.52320457797[/C][C]3827.30679542203[/C][/ROW]
[ROW][C]290[/C][C]15285.88[/C][C]9993.52320457797[/C][C]5292.35679542203[/C][/ROW]
[ROW][C]291[/C][C]10996.04[/C][C]9993.52320457797[/C][C]1002.51679542203[/C][/ROW]
[ROW][C]292[/C][C]8228.67[/C][C]9993.52320457797[/C][C]-1764.85320457797[/C][/ROW]
[ROW][C]293[/C][C]7955.02[/C][C]8418.03367231638[/C][C]-463.013672316383[/C][/ROW]
[ROW][C]294[/C][C]7690.87[/C][C]4162.1025[/C][C]3528.7675[/C][/ROW]
[ROW][C]295[/C][C]0[/C][C]9993.52320457797[/C][C]-9993.52320457797[/C][/ROW]
[ROW][C]296[/C][C]7861.3[/C][C]9993.52320457797[/C][C]-2132.22320457797[/C][/ROW]
[ROW][C]297[/C][C]13104.85[/C][C]9993.52320457797[/C][C]3111.32679542203[/C][/ROW]
[ROW][C]298[/C][C]5915.81[/C][C]4162.1025[/C][C]1753.7075[/C][/ROW]
[ROW][C]299[/C][C]5504.23[/C][C]9993.52320457797[/C][C]-4489.29320457797[/C][/ROW]
[ROW][C]300[/C][C]402.04[/C][C]4162.1025[/C][C]-3760.0625[/C][/ROW]
[ROW][C]301[/C][C]6631.44[/C][C]9993.52320457797[/C][C]-3362.08320457797[/C][/ROW]
[ROW][C]302[/C][C]8687.31[/C][C]9993.52320457797[/C][C]-1306.21320457797[/C][/ROW]
[ROW][C]303[/C][C]1943.9[/C][C]4162.1025[/C][C]-2218.2025[/C][/ROW]
[ROW][C]304[/C][C]8117.73[/C][C]9993.52320457797[/C][C]-1875.79320457797[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=165837&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=165837&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
110628.079993.52320457797634.546795422031
29399.629993.52320457797-593.90320457797
310195.349993.52320457797201.816795422032
49859.719993.52320457797-133.813204577969
514035.068418.033672316385617.02632768362
67098.60666666679993.52320457797-2894.91653791127
712238.729993.523204577972245.19679542203
810065.469993.5232045779771.9367954220306
910073.389993.5232045779779.8567954220325
108967.419993.52320457797-1026.11320457797
1110297.379993.52320457797303.84679542203
1213269.699993.523204577973276.16679542203
1312220.89993.523204577972227.27679542203
1412925.839993.523204577972932.30679542203
157725.89993.52320457797-2267.72320457797
166719.818418.03367231638-1698.22367231638
1713210.448418.033672316384792.40632768362
1811290.569993.523204577971297.03679542203
196876.919993.52320457797-3116.61320457797
208625.929993.52320457797-1367.60320457797
218878.88418.03367231638460.766327683616
2211981.929993.523204577971988.39679542203
2311012.179993.523204577971018.64679542203
247462.039993.52320457797-2531.49320457797
2512684.498418.033672316384266.45632768362
2613609.259993.523204577973615.72679542203
279328.759993.52320457797-664.773204577968
2813535.149993.523204577973541.61679542203
298075.948418.03367231638-342.093672316383
3013289.549993.523204577973296.01679542203
3113032.89993.523204577973039.27679542203
3213561.749993.523204577973568.21679542203
3310938.218418.033672316382520.17632768362
346828.138418.03367231638-1589.90367231638
358162.559993.52320457797-1830.97320457797
369266.219993.52320457797-727.31320457797
379939.79333333339993.52320457797-53.7298712446682
388418.699993.52320457797-1574.83320457797
3910601.959993.52320457797608.426795422032
409099.529993.52320457797-894.003204577968
4111031.59993.523204577971037.97679542203
4210263.759993.52320457797270.226795422032
4313712.339993.523204577973718.80679542203
4413481.519993.523204577973487.98679542203
457375.389993.52320457797-2618.14320457797
468474.099993.52320457797-1519.43320457797
4710880.469993.52320457797886.936795422031
489359.29993.52320457797-634.323204577968
495612.469993.52320457797-4381.06320457797
509902.159993.52320457797-91.3732045779689
5113675.219993.523204577973681.68679542203
529109.939993.52320457797-883.593204577968
539922.738418.033672316381504.69632768362
546490.879993.52320457797-3502.65320457797
557402.259993.52320457797-2591.27320457797
5614693.649993.523204577974700.11679542203
5710816.99993.52320457797823.376795422031
589453.049993.52320457797-540.483204577968
596392.329993.52320457797-3601.20320457797
607995.499993.52320457797-1998.03320457797
616378.659993.52320457797-3614.87320457797
628154.588418.03367231638-263.453672316384
6310001.779993.523204577978.24679542203194
647749.299993.52320457797-2244.23320457797
658335.49993.52320457797-1658.12320457797
668633.029993.52320457797-1360.50320457797
679496.439993.52320457797-497.093204577968
685485.099993.52320457797-4508.43320457797
6912899.689993.523204577972906.15679542203
709319.59993.52320457797-674.023204577968
719648.488418.033672316381230.44632768362
7215259.569993.523204577975266.03679542203
737341.859993.52320457797-2651.67320457797
7410623.548418.033672316382205.50632768362
758495.38418.0336723163877.2663276836156
7611227.399993.523204577971233.86679542203
778649.589993.52320457797-1343.94320457797
7810651.688418.033672316382233.64632768362
7912959.458418.033672316384541.41632768362
8010425.989993.52320457797432.456795422031
818437.099993.52320457797-1556.43320457797
826704.739993.52320457797-3288.79320457797
837365.29993.52320457797-2628.32320457797
849735.738418.033672316381317.69632768362
8511423.869993.523204577971430.33679542203
868446.739993.52320457797-1546.79320457797
878115.679993.52320457797-1877.85320457797
887432.149993.52320457797-2561.38320457797
898028.26333333338418.03367231638-389.770338983083
908106.13333333339993.52320457797-1887.38987124467
917122.578418.03367231638-1295.46367231638
926550.888418.03367231638-1867.15367231638
937519.279993.52320457797-2474.25320457797
945721.458418.03367231638-2696.58367231638
957941.549993.52320457797-2051.98320457797
966734.78418.03367231638-1683.33367231638
979659.928418.033672316381241.88632768362
9810472.948418.033672316382054.90632768362
998335.45333333339993.52320457797-1658.06987124467
1007171.578418.03367231638-1246.46367231638
1014366.988418.03367231638-4051.05367231638
1026905.99993.52320457797-3087.62320457797
1036411.99993.52320457797-3581.62320457797
1044046.339993.52320457797-5947.19320457797
1054520.679993.52320457797-5472.85320457797
1068171.448418.03367231638-246.593672316383
1077045.039993.52320457797-2948.49320457797
1087138.59993.52320457797-2855.02320457797
1093540.178418.03367231638-4877.86367231638
11012068.398418.033672316383650.35632768362
1116796.878418.03367231638-1621.16367231638
1129300.498418.03367231638882.456327683616
1138714.348418.03367231638296.306327683616
1147139.69993.52320457797-2853.92320457797
1159678.679993.52320457797-314.853204577968
11610139.589993.52320457797146.056795422031
1179533.689993.52320457797-459.843204577968
1189268.459993.52320457797-725.073204577968
1195769.629993.52320457797-4223.90320457797
1205108.879993.52320457797-4884.65320457797
1219521.079993.52320457797-472.453204577969
1226015.89993.52320457797-3977.72320457797
1237660.529993.52320457797-2333.00320457797
1247290.238418.03367231638-1127.80367231638
1259303.939993.52320457797-689.593204577968
1269820.999993.52320457797-172.533204577969
1276982.568418.03367231638-1435.47367231638
1286696.299993.52320457797-3297.23320457797
1296068.499993.52320457797-3925.03320457797
1309784.529993.52320457797-209.003204577968
1317368.028418.03367231638-1050.01367231638
1328711.659993.52320457797-1281.87320457797
1337038.449993.52320457797-2955.08320457797
1348736.029993.52320457797-1257.50320457797
13512375.849993.523204577972382.31679542203
13613022.319993.523204577973028.78679542203
1379815.39993.52320457797-178.223204577969
1388057.838418.03367231638-360.203672316384
1396213.88418.03367231638-2204.23367231638
1409314.649993.52320457797-678.883204577969
14111078.199993.523204577971084.66679542203
1429024.679993.52320457797-968.853204577968
1438439.68418.0336723163821.5663276836167
1446591.219993.52320457797-3402.31320457797
1456619.78418.03367231638-1798.33367231638
1465469.098418.03367231638-2948.94367231638
1478972.96333333338418.03367231638554.929661016917
1486410.888418.03367231638-2007.15367231638
1498098.29993.52320457797-1895.32320457797
1506317.429993.52320457797-3676.10320457797
15112560.839993.523204577972567.30679542203
1526746.349993.52320457797-3247.18320457797
1539605.049993.52320457797-388.483204577968
1548805.959993.52320457797-1187.57320457797
1559692.119993.52320457797-301.413204577968
1567445.259993.52320457797-2548.27320457797
15710211.759993.52320457797218.226795422032
15811412.219993.523204577971418.68679542203
15913530.699993.523204577973537.16679542203
1609906.749993.52320457797-86.7832045779687
16114131.199993.523204577974137.66679542203
16210637.989993.52320457797644.456795422031
1639859.079993.52320457797-134.453204577969
1642559.379993.52320457797-7434.15320457797
16533644.969993.5232045779723651.436795422
16610267.259993.52320457797273.726795422032
16711146.338418.033672316382728.29632768362
16852419993.52320457797-4752.52320457797
16913003.979993.523204577973010.44679542203
17018688.759993.523204577978695.22679542203
1717199.969993.52320457797-2793.56320457797
1726908.189993.52320457797-3085.34320457797
1739877.239993.52320457797-116.293204577969
17410827.259993.52320457797833.726795422032
1757794.099993.52320457797-2199.43320457797
1769646.549993.52320457797-346.983204577968
1776696.474162.10252534.3675
17818584.879993.523204577978591.34679542203
1799530.239993.52320457797-463.293204577969
18018205.979993.523204577978212.44679542203
1816135.089993.52320457797-3858.44320457797
1827490.624162.10253328.5175
183298418.03367231638-8389.03367231638
18413299.39993.523204577973305.77679542203
18512630.989993.523204577972637.45679542203
18610972.359993.52320457797978.826795422032
187114162.1025-4151.1025
18813588.919993.523204577973595.38679542203
18913512.249993.523204577973518.71679542203
19017165.869993.523204577977172.33679542203
1918309.268418.03367231638-108.773672316383
1928792.239993.52320457797-1201.29320457797
1936454.779993.52320457797-3538.75320457797
19432946.369993.5232045779722952.836795422
1957921.974162.10253759.8675
19611123.149993.523204577971129.61679542203
19710573.359993.52320457797579.826795422032
19812378.919993.523204577972385.38679542203
1991455.689993.52320457797-8537.84320457797
2007217.39993.52320457797-2776.22320457797
20111346.259993.523204577971352.72679542203
20216131.859993.523204577976138.32679542203
2036925.639993.52320457797-3067.89320457797
20412370.829993.523204577972377.29679542203
2059622.889993.52320457797-370.643204577967
2068248.469993.52320457797-1745.06320457797
20711662.129993.523204577971668.59679542203
20811351.189993.523204577971357.65679542203
20910341.699993.52320457797348.166795422032
21022073.749993.5232045779712080.216795422
21111089.449993.523204577971095.91679542203
21212054.649993.523204577972061.11679542203
21319061.329993.523204577979067.79679542203
21413629.678418.033672316385211.63632768362
2157570.859993.52320457797-2422.67320457797
21611334.089993.523204577971340.55679542203
21712604.639993.523204577972611.10679542203
21811526.619993.523204577971533.08679542203
21918940.159993.523204577978946.62679542203
22004162.1025-4162.1025
22112121.618418.033672316383703.57632768362
2229688.369993.52320457797-305.163204577968
22313803.768418.033672316385385.72632768362
22410129.269993.52320457797135.736795422032
2257444.329993.52320457797-2549.20320457797
22614591.699993.523204577974598.16679542203
2278870.348418.03367231638452.306327683616
2289752.659993.52320457797-240.873204577969
2297683.239993.52320457797-2310.29320457797
23010226.029993.52320457797232.496795422032
2317141.969993.52320457797-2851.56320457797
23214159.919993.523204577974166.38679542203
2339635.529993.52320457797-358.003204577968
2347360.024162.10253197.9175
23510485.319993.52320457797491.786795422033
2369096.539993.52320457797-896.99320457797
23713043.269993.523204577973049.73679542203
2388228.399993.52320457797-1765.13320457797
23911392.949993.523204577971399.41679542203
24014565.629993.523204577974572.09679542203
2416399.888418.03367231638-2018.15367231638
2428761.838418.03367231638343.796327683616
2434324.318418.03367231638-4093.72367231638
24415740.788418.033672316387322.74632768362
2459649.989993.52320457797-343.543204577969
24612950.099993.523204577972956.56679542203
24710007.329993.5232045779713.7967954220312
24813029.749993.523204577973036.21679542203
24914456.699993.523204577974463.16679542203
250312.329993.52320457797-9681.20320457797
2518000.239993.52320457797-1993.29320457797
25212670.059993.523204577972676.52679542203
25310443.829993.52320457797450.296795422031
2547380.89993.52320457797-2612.72320457797
25512364.379993.523204577972370.84679542203
2567685.119993.52320457797-2308.41320457797
25713917.629993.523204577973924.09679542203
2584260.969993.52320457797-5732.56320457797
2594263.659993.52320457797-5729.87320457797
2609808.169993.52320457797-185.363204577969
261503.934162.1025-3658.1725
2626106.869993.52320457797-3886.66320457797
2639756.579993.52320457797-236.953204577969
2647559.889993.52320457797-2433.64320457797
26594809993.52320457797-513.523204577968
26610012.889993.5232045779719.3567954220325
26714942.569993.523204577974949.03679542203
26810118.759993.52320457797125.226795422032
2699503.118418.033672316381085.07632768362
2709389.238418.03367231638971.196327683616
2712078.39993.52320457797-7915.22320457797
2725959.48418.03367231638-2458.63367231638
2734008.64162.1025-153.5025
27411099.229993.523204577971105.69679542203
27512040.959993.523204577972047.42679542203
2767242.249993.52320457797-2751.28320457797
27719323.439993.523204577979329.90679542203
2788379.818418.03367231638-38.2236723163824
2793626.598418.03367231638-4791.44367231638
280906.048418.03367231638-7511.99367231638
2814100.639993.52320457797-5892.89320457797
28214625.779993.523204577974632.24679542203
2836894.789993.52320457797-3098.74320457797
2847148.29993.52320457797-2845.32320457797
2858562.899993.52320457797-1430.63320457797
2868514.399993.52320457797-1479.13320457797
2875641.349993.52320457797-4352.18320457797
2888592.59993.52320457797-1401.02320457797
28913820.839993.523204577973827.30679542203
29015285.889993.523204577975292.35679542203
29110996.049993.523204577971002.51679542203
2928228.679993.52320457797-1764.85320457797
2937955.028418.03367231638-463.013672316383
2947690.874162.10253528.7675
29509993.52320457797-9993.52320457797
2967861.39993.52320457797-2132.22320457797
29713104.859993.523204577973111.32679542203
2985915.814162.10251753.7075
2995504.239993.52320457797-4489.29320457797
300402.044162.1025-3760.0625
3016631.449993.52320457797-3362.08320457797
3028687.319993.52320457797-1306.21320457797
3031943.94162.1025-2218.2025
3048117.739993.52320457797-1875.79320457797



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