Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationMon, 20 Dec 2010 14:38:00 +0000
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2010/Dec/20/t1292855799v00axwvc3mue6z0.htm/, Retrieved Sat, 04 May 2024 02:53:30 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=112969, Retrieved Sat, 04 May 2024 02:53:30 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact116
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [] [2010-12-05 18:59:57] [b98453cac15ba1066b407e146608df68]
-   PD  [Recursive Partitioning (Regression Trees)] [Recursieve Partit...] [2010-12-20 13:43:03] [4f1a20f787b3465111b61213cdeef1a9]
-   P       [Recursive Partitioning (Regression Trees)] [Recursieve Partit...] [2010-12-20 14:38:00] [f0b33ae54e73edcd25a3e2f31270d1c9] [Current]
Feedback Forum

Post a new message
Dataseries X:
22.037	17.759	14.116	104.708	158.620
21.732	17.530	13.504	101.817	154.583
21.172	17.139	13.168	97.898	149.377
21.388	16.916	13.064	95.559	146.927
22.053	16.543	12.828	92.822	144.246
22.687	16.317	12.541	90.848	142.393
24.793	18.161	13.547	101.141	157.642
26.113	19.144	13.710	105.841	164.808
23.708	16.947	12.535	93.647	146.837
23.554	16.491	12.386	90.923	143.354
23.222	16.428	12.253	89.130	141.033
23.363	16.639	12.484	90.212	142.698
24.023	16.821	12.966	93.196	147.006
23.355	16.765	12.770	91.861	144.751
23.276	16.533	12.660	90.593	143.062
23.085	16.554	12.514	89.895	142.048
23.173	16.494	12.430	88.819	140.916
23.487	16.612	12.372	87.924	140.395
25.576	17.933	13.085	96.906	153.500
26.311	19.070	13.454	101.217	160.052
27.109	18.179	13.361	98.709	157.358
27.060	17.830	13.713	98.139	156.742
26.490	17.349	13.601	95.529	152.969
27.157	17.919	14.090	98.577	157.743
26.973	18.269	14.452	100.772	160.466
27.589	18.385	14.108	100.180	160.262
27.246	18.260	14.036	99.200	158.742
26.845	17.905	13.332	96.251	154.333
26.582	17.730	13.421	94.514	152.247
26.544	17.827	13.279	93.780	151.430
29.105	19.978	14.583	105.192	168.858
28.703	20.315	14.991	107.682	171.691
27.921	18.931	14.313	99.687	160.852
28.566	18.732	14.769	99.436	161.503
29.860	19.155	15.365	102.049	166.429
30.194	19.270	15.448	102.673	167.585
31.330	19.754	16.485	105.813	173.382
31.018	19.845	16.493	105.056	172.412
30.954	19.937	16.748	103.916	171.555
31.398	20.097	16.921	103.513	171.929
31.267	19.981	16.906	101.893	170.047
32.069	20.502	17.050	102.503	172.124
34.665	22.712	18.873	113.149	189.399
35.834	23.101	19.684	116.696	195.315
34.034	21.381	18.260	108.500	182.175
34.435	21.255	18.338	107.800	181.828
34.000	21.053	18.358	105.941	179.352
35.216	21.561	19.394	108.742	184.913
35.734	21.923	20.568	111.680	189.905
35.347	22.001	20.956	111.270	189.574
35.357	22.369	21.523	110.698	189.947
34.802	22.320	22.712	108.517	188.351
34.493	22.149	22.382	107.127	186.151
35.047	22.581	23.168	107.088	187.884
37.386	24.896	24.777	116.321	203.380
38.691	26.610	33.608	125.045	223.954
37.249	25.417	33.137	116.779	212.582
37.668	26.484	34.897	122.887	221.936
36.764	26.329	35.344	120.162	218.599
37.926	26.989	36.152	123.198	224.265
38.145	27.180	37.291	123.610	226.226
37.664	27.284	37.625	122.293	224.866
37.449	27.436	38.034	121.289	224.208
37.389	27.082	38.244	119.393	222.108
37.121	26.818	38.461	117.494	219.894
37.447	27.003	39.078	116.693	220.221
39.751	29.344	40.701	125.062	234.858
40.154	29.777	41.686	127.281	238.898
38.814	28.070	41.294	120.195	228.373
38.673	27.993	41.927	119.804	228.397
37.948	27.672	42.339	117.113	225.072
39.161	27.802	43.170	119.240	229.373
37.408	27.328	43.703	115.823	224.262
37.356	27.666	44.177	116.281	225.480
36.606	27.456	44.703	113.816	222.581
37.040	27.796	45.319	114.632	224.787
36.349	27.642	45.790	112.987	222.768
36.158	27.651	45.838	111.633	221.280
37.342	29.604	46.806	116.721	230.473
36.800	29.196	47.014	114.850	227.860
37.135	28.328	47.381	112.797	225.641
34.265	27.986	47.049	105.368	214.668
33.226	27.738	46.910	102.524	210.398
32.357	27.867	46.853	101.327	208.404
36.870	27.580	46.608	98.873	209.931
35.880	27.381	46.139	95.993	205.393
34.808	27.292	45.954	93.244	201.298
34.025	26.944	45.367	90.403	196.739
33.901	26.329	44.538	88.539	193.307
37.459	29.023	45.897	98.106	210.485
37.152	28.705	45.744	96.963	208.564
34.929	27.213	44.819	90.781	197.742
34.116	27.063	44.836	89.253	195.268
33.710	27.010	44.779	87.794	193.293
34.264	27.709	45.383	89.810	197.166
34.826	27.802	45.613	90.864	199.105
34.096	27.687	45.331	89.025	196.139
33.955	27.719	45.212	87.621	194.507
34.111	27.961	45.329	87.718	195.119
32.344	27.203	44.603	83.433	187.583
32.871	27.747	44.405	84.535	189.558
36.244	30.713	45.701	92.223	204.881
35.988	30.395	45.647	91.052	203.082
35.439	28.895	45.186	88.456	197.976
35.692	28.460	45.113	88.706	197.971
35.804	28.286	45.301	89.137	198.528
37.747	28.984	46.342	94.066	207.139
40.673	29.624	47.309	99.258	216.864
41.601	29.734	47.659	100.673	219.667
42.273	30.603	48.106	102.269	223.251
41.952	30.427	48.087	100.833	221.299
41.463	30.269	48.188	99.314	219.234
42.759	30.798	48.917	101.764	224.238
45.434	32.676	50.312	108.242	236.664
45.776	32.680	50.531	108.148	237.135
44.630	30.737	50.005	104.761	230.133
44.793	30.300	50.306	103.772	229.171
44.757	30.321	50.598	103.737	229.413
49.099	31.282	51.856	111.043	243.280
47.974	30.868	52.132	109.906	240.880
47.919	30.749	52.167	109.335	240.170
47.519	30.236	52.149	107.247	237.151
47.136	29.990	51.976	105.690	234.792
45.910	29.427	51.797	102.755	229.889
46.436	29.376	51.907	102.280	229.999
50.334	30.828	53.589	110.590	245.341
50.294	30.532	53.814	109.122	243.762
47.224	29.166	52.436	102.795	231.621
47.030	29.124	52.448	101.416	230.018
45.790	28.904	52.322	99.138	226.154
38.252	27.992	47.040	102.612	215.896




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time15 seconds
R Server'George Udny Yule' @ 72.249.76.132

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 15 seconds \tabularnewline
R Server & 'George Udny Yule' @ 72.249.76.132 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=112969&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]15 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'George Udny Yule' @ 72.249.76.132[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=112969&T=0

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

As an alternative you can also use a QR Code:  

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

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time15 seconds
R Server'George Udny Yule' @ 72.249.76.132







Goodness of Fit
Correlation0.9923
R-squared0.9847
RMSE0.6235

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

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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=112969&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.9923
R-squared0.9847
RMSE0.6235







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
117.75917.8651666666667-0.106166666666667
217.5317.8651666666667-0.335166666666666
317.13916.65707142857140.481928571428572
416.91616.65707142857140.258928571428573
516.54316.6570714285714-0.114071428571428
616.31716.6570714285714-0.340071428571427
718.16117.86516666666670.295833333333334
819.14418.86950.2745
916.94716.65707142857140.289928571428572
1016.49116.6570714285714-0.166071428571428
1116.42816.6570714285714-0.229071428571427
1216.63916.6570714285714-0.0180714285714281
1316.82116.65707142857140.163928571428574
1416.76516.65707142857140.107928571428573
1516.53316.6570714285714-0.124071428571426
1616.55416.6570714285714-0.103071428571429
1716.49416.6570714285714-0.163071428571428
1816.61216.6570714285714-0.0450714285714291
1917.93317.86516666666670.0678333333333327
2019.0718.86950.200500000000002
2118.17917.86516666666670.313833333333331
2217.8317.8651666666667-0.0351666666666688
2317.34917.8651666666667-0.516166666666667
2417.91917.86516666666670.0538333333333334
2518.26918.8695-0.6005
2618.38518.8695-0.484499999999997
2718.2617.86516666666670.394833333333334
2817.90517.86516666666670.0398333333333341
2917.7317.8651666666667-0.135166666666667
3017.82717.8651666666667-0.0381666666666653
3119.97820.1624444444444-0.184444444444445
3220.31520.16244444444440.152555555555555
3318.93118.86950.0615000000000023
3418.73218.8695-0.137499999999999
3519.15518.86950.285500000000003
3619.2718.86950.400500000000001
3719.75420.1624444444444-0.408444444444445
3819.84520.1624444444444-0.317444444444448
3919.93720.1624444444444-0.225444444444445
4020.09720.1624444444444-0.0654444444444451
4119.98120.1624444444444-0.181444444444445
4220.50220.16244444444440.339555555555553
4322.71222.1230.589000000000002
4423.10122.1230.978000000000002
4521.38122.123-0.741999999999997
4621.25522.123-0.867999999999999
4721.05320.16244444444440.890555555555554
4821.56122.123-0.561999999999998
4921.92322.123-0.199999999999999
5022.00122.123-0.121999999999996
5122.36922.1230.246000000000002
5222.3222.1230.197000000000003
5322.14922.1230.0260000000000034
5422.58122.1230.458000000000002
5524.89626.6273333333333-1.73133333333334
5626.6126.6273333333333-0.0173333333333368
5725.41726.6273333333333-1.21033333333333
5826.48426.6273333333333-0.143333333333334
5926.32926.6273333333333-0.298333333333336
6026.98926.62733333333330.361666666666665
6127.1826.62733333333330.552666666666664
6227.28426.62733333333330.656666666666663
6327.43626.62733333333330.808666666666664
6427.08226.62733333333330.454666666666665
6526.81826.62733333333330.190666666666665
6627.00326.62733333333330.375666666666664
6729.34428.49492592592590.849074074074078
6829.77728.49492592592591.28207407407408
6928.0728.4949259259259-0.424925925925923
7027.99328.4949259259259-0.501925925925924
7127.67228.4949259259259-0.822925925925922
7227.80228.4949259259259-0.692925925925923
7327.32828.4949259259259-1.16692592592592
7427.66628.4949259259259-0.828925925925923
7527.45628.4949259259259-1.03892592592592
7627.79628.4949259259259-0.698925925925924
7727.64228.4949259259259-0.852925925925923
7827.65128.4949259259259-0.843925925925923
7929.60428.49492592592591.10907407407408
8029.19628.49492592592590.701074074074079
8128.32828.4949259259259-0.166925925925923
8227.98627.4543750.531625000000002
8327.73827.4543750.283625000000001
8427.86727.4543750.412625000000002
8527.5828.4949259259259-0.914925925925925
8627.38128.4949259259259-1.11392592592592
8727.29227.454375-0.162374999999997
8826.94427.454375-0.510375
8926.32927.454375-1.12537500000000
9029.02328.49492592592590.528074074074077
9128.70528.49492592592590.210074074074075
9227.21327.454375-0.241374999999998
9327.06327.454375-0.391375
9427.0127.454375-0.444374999999997
9527.70927.4543750.254625000000001
9627.80227.4543750.347625000000001
9727.68727.4543750.232625000000002
9827.71927.4543750.264625000000002
9927.96127.4543750.506625
10027.20327.454375-0.251374999999999
10127.74727.4543750.292625000000001
10230.71328.49492592592592.21807407407408
10330.39528.49492592592591.90007407407408
10428.89528.49492592592590.400074074074077
10528.4628.4949259259259-0.034925925925922
10628.28628.4949259259259-0.208925925925922
10728.98428.49492592592590.489074074074079
10829.62428.49492592592591.12907407407408
10929.73429.9608-0.226800000000001
11030.60329.96080.642199999999999
11130.42729.96080.466199999999997
11230.26929.96080.308199999999996
11330.79829.96080.837199999999996
11432.67631.37357142857141.30242857142857
11532.6831.37357142857141.30642857142857
11630.73729.96080.776199999999996
11730.329.96080.339199999999998
11830.32129.96080.360199999999999
11931.28231.3735714285714-0.0915714285714309
12030.86831.3735714285714-0.505571428571432
12130.74931.3735714285714-0.624571428571432
12230.23629.96080.275199999999998
12329.9929.96080.0291999999999959
12429.42729.9608-0.533800000000003
12529.37629.9608-0.584800000000001
12630.82831.3735714285714-0.545571428571431
12730.53231.3735714285714-0.84157142857143
12829.16629.9608-0.794800000000002
12929.12429.9608-0.836800000000004
13028.90429.9608-1.05680000000000
13127.99228.4949259259259-0.502925925925922

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 17.759 & 17.8651666666667 & -0.106166666666667 \tabularnewline
2 & 17.53 & 17.8651666666667 & -0.335166666666666 \tabularnewline
3 & 17.139 & 16.6570714285714 & 0.481928571428572 \tabularnewline
4 & 16.916 & 16.6570714285714 & 0.258928571428573 \tabularnewline
5 & 16.543 & 16.6570714285714 & -0.114071428571428 \tabularnewline
6 & 16.317 & 16.6570714285714 & -0.340071428571427 \tabularnewline
7 & 18.161 & 17.8651666666667 & 0.295833333333334 \tabularnewline
8 & 19.144 & 18.8695 & 0.2745 \tabularnewline
9 & 16.947 & 16.6570714285714 & 0.289928571428572 \tabularnewline
10 & 16.491 & 16.6570714285714 & -0.166071428571428 \tabularnewline
11 & 16.428 & 16.6570714285714 & -0.229071428571427 \tabularnewline
12 & 16.639 & 16.6570714285714 & -0.0180714285714281 \tabularnewline
13 & 16.821 & 16.6570714285714 & 0.163928571428574 \tabularnewline
14 & 16.765 & 16.6570714285714 & 0.107928571428573 \tabularnewline
15 & 16.533 & 16.6570714285714 & -0.124071428571426 \tabularnewline
16 & 16.554 & 16.6570714285714 & -0.103071428571429 \tabularnewline
17 & 16.494 & 16.6570714285714 & -0.163071428571428 \tabularnewline
18 & 16.612 & 16.6570714285714 & -0.0450714285714291 \tabularnewline
19 & 17.933 & 17.8651666666667 & 0.0678333333333327 \tabularnewline
20 & 19.07 & 18.8695 & 0.200500000000002 \tabularnewline
21 & 18.179 & 17.8651666666667 & 0.313833333333331 \tabularnewline
22 & 17.83 & 17.8651666666667 & -0.0351666666666688 \tabularnewline
23 & 17.349 & 17.8651666666667 & -0.516166666666667 \tabularnewline
24 & 17.919 & 17.8651666666667 & 0.0538333333333334 \tabularnewline
25 & 18.269 & 18.8695 & -0.6005 \tabularnewline
26 & 18.385 & 18.8695 & -0.484499999999997 \tabularnewline
27 & 18.26 & 17.8651666666667 & 0.394833333333334 \tabularnewline
28 & 17.905 & 17.8651666666667 & 0.0398333333333341 \tabularnewline
29 & 17.73 & 17.8651666666667 & -0.135166666666667 \tabularnewline
30 & 17.827 & 17.8651666666667 & -0.0381666666666653 \tabularnewline
31 & 19.978 & 20.1624444444444 & -0.184444444444445 \tabularnewline
32 & 20.315 & 20.1624444444444 & 0.152555555555555 \tabularnewline
33 & 18.931 & 18.8695 & 0.0615000000000023 \tabularnewline
34 & 18.732 & 18.8695 & -0.137499999999999 \tabularnewline
35 & 19.155 & 18.8695 & 0.285500000000003 \tabularnewline
36 & 19.27 & 18.8695 & 0.400500000000001 \tabularnewline
37 & 19.754 & 20.1624444444444 & -0.408444444444445 \tabularnewline
38 & 19.845 & 20.1624444444444 & -0.317444444444448 \tabularnewline
39 & 19.937 & 20.1624444444444 & -0.225444444444445 \tabularnewline
40 & 20.097 & 20.1624444444444 & -0.0654444444444451 \tabularnewline
41 & 19.981 & 20.1624444444444 & -0.181444444444445 \tabularnewline
42 & 20.502 & 20.1624444444444 & 0.339555555555553 \tabularnewline
43 & 22.712 & 22.123 & 0.589000000000002 \tabularnewline
44 & 23.101 & 22.123 & 0.978000000000002 \tabularnewline
45 & 21.381 & 22.123 & -0.741999999999997 \tabularnewline
46 & 21.255 & 22.123 & -0.867999999999999 \tabularnewline
47 & 21.053 & 20.1624444444444 & 0.890555555555554 \tabularnewline
48 & 21.561 & 22.123 & -0.561999999999998 \tabularnewline
49 & 21.923 & 22.123 & -0.199999999999999 \tabularnewline
50 & 22.001 & 22.123 & -0.121999999999996 \tabularnewline
51 & 22.369 & 22.123 & 0.246000000000002 \tabularnewline
52 & 22.32 & 22.123 & 0.197000000000003 \tabularnewline
53 & 22.149 & 22.123 & 0.0260000000000034 \tabularnewline
54 & 22.581 & 22.123 & 0.458000000000002 \tabularnewline
55 & 24.896 & 26.6273333333333 & -1.73133333333334 \tabularnewline
56 & 26.61 & 26.6273333333333 & -0.0173333333333368 \tabularnewline
57 & 25.417 & 26.6273333333333 & -1.21033333333333 \tabularnewline
58 & 26.484 & 26.6273333333333 & -0.143333333333334 \tabularnewline
59 & 26.329 & 26.6273333333333 & -0.298333333333336 \tabularnewline
60 & 26.989 & 26.6273333333333 & 0.361666666666665 \tabularnewline
61 & 27.18 & 26.6273333333333 & 0.552666666666664 \tabularnewline
62 & 27.284 & 26.6273333333333 & 0.656666666666663 \tabularnewline
63 & 27.436 & 26.6273333333333 & 0.808666666666664 \tabularnewline
64 & 27.082 & 26.6273333333333 & 0.454666666666665 \tabularnewline
65 & 26.818 & 26.6273333333333 & 0.190666666666665 \tabularnewline
66 & 27.003 & 26.6273333333333 & 0.375666666666664 \tabularnewline
67 & 29.344 & 28.4949259259259 & 0.849074074074078 \tabularnewline
68 & 29.777 & 28.4949259259259 & 1.28207407407408 \tabularnewline
69 & 28.07 & 28.4949259259259 & -0.424925925925923 \tabularnewline
70 & 27.993 & 28.4949259259259 & -0.501925925925924 \tabularnewline
71 & 27.672 & 28.4949259259259 & -0.822925925925922 \tabularnewline
72 & 27.802 & 28.4949259259259 & -0.692925925925923 \tabularnewline
73 & 27.328 & 28.4949259259259 & -1.16692592592592 \tabularnewline
74 & 27.666 & 28.4949259259259 & -0.828925925925923 \tabularnewline
75 & 27.456 & 28.4949259259259 & -1.03892592592592 \tabularnewline
76 & 27.796 & 28.4949259259259 & -0.698925925925924 \tabularnewline
77 & 27.642 & 28.4949259259259 & -0.852925925925923 \tabularnewline
78 & 27.651 & 28.4949259259259 & -0.843925925925923 \tabularnewline
79 & 29.604 & 28.4949259259259 & 1.10907407407408 \tabularnewline
80 & 29.196 & 28.4949259259259 & 0.701074074074079 \tabularnewline
81 & 28.328 & 28.4949259259259 & -0.166925925925923 \tabularnewline
82 & 27.986 & 27.454375 & 0.531625000000002 \tabularnewline
83 & 27.738 & 27.454375 & 0.283625000000001 \tabularnewline
84 & 27.867 & 27.454375 & 0.412625000000002 \tabularnewline
85 & 27.58 & 28.4949259259259 & -0.914925925925925 \tabularnewline
86 & 27.381 & 28.4949259259259 & -1.11392592592592 \tabularnewline
87 & 27.292 & 27.454375 & -0.162374999999997 \tabularnewline
88 & 26.944 & 27.454375 & -0.510375 \tabularnewline
89 & 26.329 & 27.454375 & -1.12537500000000 \tabularnewline
90 & 29.023 & 28.4949259259259 & 0.528074074074077 \tabularnewline
91 & 28.705 & 28.4949259259259 & 0.210074074074075 \tabularnewline
92 & 27.213 & 27.454375 & -0.241374999999998 \tabularnewline
93 & 27.063 & 27.454375 & -0.391375 \tabularnewline
94 & 27.01 & 27.454375 & -0.444374999999997 \tabularnewline
95 & 27.709 & 27.454375 & 0.254625000000001 \tabularnewline
96 & 27.802 & 27.454375 & 0.347625000000001 \tabularnewline
97 & 27.687 & 27.454375 & 0.232625000000002 \tabularnewline
98 & 27.719 & 27.454375 & 0.264625000000002 \tabularnewline
99 & 27.961 & 27.454375 & 0.506625 \tabularnewline
100 & 27.203 & 27.454375 & -0.251374999999999 \tabularnewline
101 & 27.747 & 27.454375 & 0.292625000000001 \tabularnewline
102 & 30.713 & 28.4949259259259 & 2.21807407407408 \tabularnewline
103 & 30.395 & 28.4949259259259 & 1.90007407407408 \tabularnewline
104 & 28.895 & 28.4949259259259 & 0.400074074074077 \tabularnewline
105 & 28.46 & 28.4949259259259 & -0.034925925925922 \tabularnewline
106 & 28.286 & 28.4949259259259 & -0.208925925925922 \tabularnewline
107 & 28.984 & 28.4949259259259 & 0.489074074074079 \tabularnewline
108 & 29.624 & 28.4949259259259 & 1.12907407407408 \tabularnewline
109 & 29.734 & 29.9608 & -0.226800000000001 \tabularnewline
110 & 30.603 & 29.9608 & 0.642199999999999 \tabularnewline
111 & 30.427 & 29.9608 & 0.466199999999997 \tabularnewline
112 & 30.269 & 29.9608 & 0.308199999999996 \tabularnewline
113 & 30.798 & 29.9608 & 0.837199999999996 \tabularnewline
114 & 32.676 & 31.3735714285714 & 1.30242857142857 \tabularnewline
115 & 32.68 & 31.3735714285714 & 1.30642857142857 \tabularnewline
116 & 30.737 & 29.9608 & 0.776199999999996 \tabularnewline
117 & 30.3 & 29.9608 & 0.339199999999998 \tabularnewline
118 & 30.321 & 29.9608 & 0.360199999999999 \tabularnewline
119 & 31.282 & 31.3735714285714 & -0.0915714285714309 \tabularnewline
120 & 30.868 & 31.3735714285714 & -0.505571428571432 \tabularnewline
121 & 30.749 & 31.3735714285714 & -0.624571428571432 \tabularnewline
122 & 30.236 & 29.9608 & 0.275199999999998 \tabularnewline
123 & 29.99 & 29.9608 & 0.0291999999999959 \tabularnewline
124 & 29.427 & 29.9608 & -0.533800000000003 \tabularnewline
125 & 29.376 & 29.9608 & -0.584800000000001 \tabularnewline
126 & 30.828 & 31.3735714285714 & -0.545571428571431 \tabularnewline
127 & 30.532 & 31.3735714285714 & -0.84157142857143 \tabularnewline
128 & 29.166 & 29.9608 & -0.794800000000002 \tabularnewline
129 & 29.124 & 29.9608 & -0.836800000000004 \tabularnewline
130 & 28.904 & 29.9608 & -1.05680000000000 \tabularnewline
131 & 27.992 & 28.4949259259259 & -0.502925925925922 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=112969&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]17.759[/C][C]17.8651666666667[/C][C]-0.106166666666667[/C][/ROW]
[ROW][C]2[/C][C]17.53[/C][C]17.8651666666667[/C][C]-0.335166666666666[/C][/ROW]
[ROW][C]3[/C][C]17.139[/C][C]16.6570714285714[/C][C]0.481928571428572[/C][/ROW]
[ROW][C]4[/C][C]16.916[/C][C]16.6570714285714[/C][C]0.258928571428573[/C][/ROW]
[ROW][C]5[/C][C]16.543[/C][C]16.6570714285714[/C][C]-0.114071428571428[/C][/ROW]
[ROW][C]6[/C][C]16.317[/C][C]16.6570714285714[/C][C]-0.340071428571427[/C][/ROW]
[ROW][C]7[/C][C]18.161[/C][C]17.8651666666667[/C][C]0.295833333333334[/C][/ROW]
[ROW][C]8[/C][C]19.144[/C][C]18.8695[/C][C]0.2745[/C][/ROW]
[ROW][C]9[/C][C]16.947[/C][C]16.6570714285714[/C][C]0.289928571428572[/C][/ROW]
[ROW][C]10[/C][C]16.491[/C][C]16.6570714285714[/C][C]-0.166071428571428[/C][/ROW]
[ROW][C]11[/C][C]16.428[/C][C]16.6570714285714[/C][C]-0.229071428571427[/C][/ROW]
[ROW][C]12[/C][C]16.639[/C][C]16.6570714285714[/C][C]-0.0180714285714281[/C][/ROW]
[ROW][C]13[/C][C]16.821[/C][C]16.6570714285714[/C][C]0.163928571428574[/C][/ROW]
[ROW][C]14[/C][C]16.765[/C][C]16.6570714285714[/C][C]0.107928571428573[/C][/ROW]
[ROW][C]15[/C][C]16.533[/C][C]16.6570714285714[/C][C]-0.124071428571426[/C][/ROW]
[ROW][C]16[/C][C]16.554[/C][C]16.6570714285714[/C][C]-0.103071428571429[/C][/ROW]
[ROW][C]17[/C][C]16.494[/C][C]16.6570714285714[/C][C]-0.163071428571428[/C][/ROW]
[ROW][C]18[/C][C]16.612[/C][C]16.6570714285714[/C][C]-0.0450714285714291[/C][/ROW]
[ROW][C]19[/C][C]17.933[/C][C]17.8651666666667[/C][C]0.0678333333333327[/C][/ROW]
[ROW][C]20[/C][C]19.07[/C][C]18.8695[/C][C]0.200500000000002[/C][/ROW]
[ROW][C]21[/C][C]18.179[/C][C]17.8651666666667[/C][C]0.313833333333331[/C][/ROW]
[ROW][C]22[/C][C]17.83[/C][C]17.8651666666667[/C][C]-0.0351666666666688[/C][/ROW]
[ROW][C]23[/C][C]17.349[/C][C]17.8651666666667[/C][C]-0.516166666666667[/C][/ROW]
[ROW][C]24[/C][C]17.919[/C][C]17.8651666666667[/C][C]0.0538333333333334[/C][/ROW]
[ROW][C]25[/C][C]18.269[/C][C]18.8695[/C][C]-0.6005[/C][/ROW]
[ROW][C]26[/C][C]18.385[/C][C]18.8695[/C][C]-0.484499999999997[/C][/ROW]
[ROW][C]27[/C][C]18.26[/C][C]17.8651666666667[/C][C]0.394833333333334[/C][/ROW]
[ROW][C]28[/C][C]17.905[/C][C]17.8651666666667[/C][C]0.0398333333333341[/C][/ROW]
[ROW][C]29[/C][C]17.73[/C][C]17.8651666666667[/C][C]-0.135166666666667[/C][/ROW]
[ROW][C]30[/C][C]17.827[/C][C]17.8651666666667[/C][C]-0.0381666666666653[/C][/ROW]
[ROW][C]31[/C][C]19.978[/C][C]20.1624444444444[/C][C]-0.184444444444445[/C][/ROW]
[ROW][C]32[/C][C]20.315[/C][C]20.1624444444444[/C][C]0.152555555555555[/C][/ROW]
[ROW][C]33[/C][C]18.931[/C][C]18.8695[/C][C]0.0615000000000023[/C][/ROW]
[ROW][C]34[/C][C]18.732[/C][C]18.8695[/C][C]-0.137499999999999[/C][/ROW]
[ROW][C]35[/C][C]19.155[/C][C]18.8695[/C][C]0.285500000000003[/C][/ROW]
[ROW][C]36[/C][C]19.27[/C][C]18.8695[/C][C]0.400500000000001[/C][/ROW]
[ROW][C]37[/C][C]19.754[/C][C]20.1624444444444[/C][C]-0.408444444444445[/C][/ROW]
[ROW][C]38[/C][C]19.845[/C][C]20.1624444444444[/C][C]-0.317444444444448[/C][/ROW]
[ROW][C]39[/C][C]19.937[/C][C]20.1624444444444[/C][C]-0.225444444444445[/C][/ROW]
[ROW][C]40[/C][C]20.097[/C][C]20.1624444444444[/C][C]-0.0654444444444451[/C][/ROW]
[ROW][C]41[/C][C]19.981[/C][C]20.1624444444444[/C][C]-0.181444444444445[/C][/ROW]
[ROW][C]42[/C][C]20.502[/C][C]20.1624444444444[/C][C]0.339555555555553[/C][/ROW]
[ROW][C]43[/C][C]22.712[/C][C]22.123[/C][C]0.589000000000002[/C][/ROW]
[ROW][C]44[/C][C]23.101[/C][C]22.123[/C][C]0.978000000000002[/C][/ROW]
[ROW][C]45[/C][C]21.381[/C][C]22.123[/C][C]-0.741999999999997[/C][/ROW]
[ROW][C]46[/C][C]21.255[/C][C]22.123[/C][C]-0.867999999999999[/C][/ROW]
[ROW][C]47[/C][C]21.053[/C][C]20.1624444444444[/C][C]0.890555555555554[/C][/ROW]
[ROW][C]48[/C][C]21.561[/C][C]22.123[/C][C]-0.561999999999998[/C][/ROW]
[ROW][C]49[/C][C]21.923[/C][C]22.123[/C][C]-0.199999999999999[/C][/ROW]
[ROW][C]50[/C][C]22.001[/C][C]22.123[/C][C]-0.121999999999996[/C][/ROW]
[ROW][C]51[/C][C]22.369[/C][C]22.123[/C][C]0.246000000000002[/C][/ROW]
[ROW][C]52[/C][C]22.32[/C][C]22.123[/C][C]0.197000000000003[/C][/ROW]
[ROW][C]53[/C][C]22.149[/C][C]22.123[/C][C]0.0260000000000034[/C][/ROW]
[ROW][C]54[/C][C]22.581[/C][C]22.123[/C][C]0.458000000000002[/C][/ROW]
[ROW][C]55[/C][C]24.896[/C][C]26.6273333333333[/C][C]-1.73133333333334[/C][/ROW]
[ROW][C]56[/C][C]26.61[/C][C]26.6273333333333[/C][C]-0.0173333333333368[/C][/ROW]
[ROW][C]57[/C][C]25.417[/C][C]26.6273333333333[/C][C]-1.21033333333333[/C][/ROW]
[ROW][C]58[/C][C]26.484[/C][C]26.6273333333333[/C][C]-0.143333333333334[/C][/ROW]
[ROW][C]59[/C][C]26.329[/C][C]26.6273333333333[/C][C]-0.298333333333336[/C][/ROW]
[ROW][C]60[/C][C]26.989[/C][C]26.6273333333333[/C][C]0.361666666666665[/C][/ROW]
[ROW][C]61[/C][C]27.18[/C][C]26.6273333333333[/C][C]0.552666666666664[/C][/ROW]
[ROW][C]62[/C][C]27.284[/C][C]26.6273333333333[/C][C]0.656666666666663[/C][/ROW]
[ROW][C]63[/C][C]27.436[/C][C]26.6273333333333[/C][C]0.808666666666664[/C][/ROW]
[ROW][C]64[/C][C]27.082[/C][C]26.6273333333333[/C][C]0.454666666666665[/C][/ROW]
[ROW][C]65[/C][C]26.818[/C][C]26.6273333333333[/C][C]0.190666666666665[/C][/ROW]
[ROW][C]66[/C][C]27.003[/C][C]26.6273333333333[/C][C]0.375666666666664[/C][/ROW]
[ROW][C]67[/C][C]29.344[/C][C]28.4949259259259[/C][C]0.849074074074078[/C][/ROW]
[ROW][C]68[/C][C]29.777[/C][C]28.4949259259259[/C][C]1.28207407407408[/C][/ROW]
[ROW][C]69[/C][C]28.07[/C][C]28.4949259259259[/C][C]-0.424925925925923[/C][/ROW]
[ROW][C]70[/C][C]27.993[/C][C]28.4949259259259[/C][C]-0.501925925925924[/C][/ROW]
[ROW][C]71[/C][C]27.672[/C][C]28.4949259259259[/C][C]-0.822925925925922[/C][/ROW]
[ROW][C]72[/C][C]27.802[/C][C]28.4949259259259[/C][C]-0.692925925925923[/C][/ROW]
[ROW][C]73[/C][C]27.328[/C][C]28.4949259259259[/C][C]-1.16692592592592[/C][/ROW]
[ROW][C]74[/C][C]27.666[/C][C]28.4949259259259[/C][C]-0.828925925925923[/C][/ROW]
[ROW][C]75[/C][C]27.456[/C][C]28.4949259259259[/C][C]-1.03892592592592[/C][/ROW]
[ROW][C]76[/C][C]27.796[/C][C]28.4949259259259[/C][C]-0.698925925925924[/C][/ROW]
[ROW][C]77[/C][C]27.642[/C][C]28.4949259259259[/C][C]-0.852925925925923[/C][/ROW]
[ROW][C]78[/C][C]27.651[/C][C]28.4949259259259[/C][C]-0.843925925925923[/C][/ROW]
[ROW][C]79[/C][C]29.604[/C][C]28.4949259259259[/C][C]1.10907407407408[/C][/ROW]
[ROW][C]80[/C][C]29.196[/C][C]28.4949259259259[/C][C]0.701074074074079[/C][/ROW]
[ROW][C]81[/C][C]28.328[/C][C]28.4949259259259[/C][C]-0.166925925925923[/C][/ROW]
[ROW][C]82[/C][C]27.986[/C][C]27.454375[/C][C]0.531625000000002[/C][/ROW]
[ROW][C]83[/C][C]27.738[/C][C]27.454375[/C][C]0.283625000000001[/C][/ROW]
[ROW][C]84[/C][C]27.867[/C][C]27.454375[/C][C]0.412625000000002[/C][/ROW]
[ROW][C]85[/C][C]27.58[/C][C]28.4949259259259[/C][C]-0.914925925925925[/C][/ROW]
[ROW][C]86[/C][C]27.381[/C][C]28.4949259259259[/C][C]-1.11392592592592[/C][/ROW]
[ROW][C]87[/C][C]27.292[/C][C]27.454375[/C][C]-0.162374999999997[/C][/ROW]
[ROW][C]88[/C][C]26.944[/C][C]27.454375[/C][C]-0.510375[/C][/ROW]
[ROW][C]89[/C][C]26.329[/C][C]27.454375[/C][C]-1.12537500000000[/C][/ROW]
[ROW][C]90[/C][C]29.023[/C][C]28.4949259259259[/C][C]0.528074074074077[/C][/ROW]
[ROW][C]91[/C][C]28.705[/C][C]28.4949259259259[/C][C]0.210074074074075[/C][/ROW]
[ROW][C]92[/C][C]27.213[/C][C]27.454375[/C][C]-0.241374999999998[/C][/ROW]
[ROW][C]93[/C][C]27.063[/C][C]27.454375[/C][C]-0.391375[/C][/ROW]
[ROW][C]94[/C][C]27.01[/C][C]27.454375[/C][C]-0.444374999999997[/C][/ROW]
[ROW][C]95[/C][C]27.709[/C][C]27.454375[/C][C]0.254625000000001[/C][/ROW]
[ROW][C]96[/C][C]27.802[/C][C]27.454375[/C][C]0.347625000000001[/C][/ROW]
[ROW][C]97[/C][C]27.687[/C][C]27.454375[/C][C]0.232625000000002[/C][/ROW]
[ROW][C]98[/C][C]27.719[/C][C]27.454375[/C][C]0.264625000000002[/C][/ROW]
[ROW][C]99[/C][C]27.961[/C][C]27.454375[/C][C]0.506625[/C][/ROW]
[ROW][C]100[/C][C]27.203[/C][C]27.454375[/C][C]-0.251374999999999[/C][/ROW]
[ROW][C]101[/C][C]27.747[/C][C]27.454375[/C][C]0.292625000000001[/C][/ROW]
[ROW][C]102[/C][C]30.713[/C][C]28.4949259259259[/C][C]2.21807407407408[/C][/ROW]
[ROW][C]103[/C][C]30.395[/C][C]28.4949259259259[/C][C]1.90007407407408[/C][/ROW]
[ROW][C]104[/C][C]28.895[/C][C]28.4949259259259[/C][C]0.400074074074077[/C][/ROW]
[ROW][C]105[/C][C]28.46[/C][C]28.4949259259259[/C][C]-0.034925925925922[/C][/ROW]
[ROW][C]106[/C][C]28.286[/C][C]28.4949259259259[/C][C]-0.208925925925922[/C][/ROW]
[ROW][C]107[/C][C]28.984[/C][C]28.4949259259259[/C][C]0.489074074074079[/C][/ROW]
[ROW][C]108[/C][C]29.624[/C][C]28.4949259259259[/C][C]1.12907407407408[/C][/ROW]
[ROW][C]109[/C][C]29.734[/C][C]29.9608[/C][C]-0.226800000000001[/C][/ROW]
[ROW][C]110[/C][C]30.603[/C][C]29.9608[/C][C]0.642199999999999[/C][/ROW]
[ROW][C]111[/C][C]30.427[/C][C]29.9608[/C][C]0.466199999999997[/C][/ROW]
[ROW][C]112[/C][C]30.269[/C][C]29.9608[/C][C]0.308199999999996[/C][/ROW]
[ROW][C]113[/C][C]30.798[/C][C]29.9608[/C][C]0.837199999999996[/C][/ROW]
[ROW][C]114[/C][C]32.676[/C][C]31.3735714285714[/C][C]1.30242857142857[/C][/ROW]
[ROW][C]115[/C][C]32.68[/C][C]31.3735714285714[/C][C]1.30642857142857[/C][/ROW]
[ROW][C]116[/C][C]30.737[/C][C]29.9608[/C][C]0.776199999999996[/C][/ROW]
[ROW][C]117[/C][C]30.3[/C][C]29.9608[/C][C]0.339199999999998[/C][/ROW]
[ROW][C]118[/C][C]30.321[/C][C]29.9608[/C][C]0.360199999999999[/C][/ROW]
[ROW][C]119[/C][C]31.282[/C][C]31.3735714285714[/C][C]-0.0915714285714309[/C][/ROW]
[ROW][C]120[/C][C]30.868[/C][C]31.3735714285714[/C][C]-0.505571428571432[/C][/ROW]
[ROW][C]121[/C][C]30.749[/C][C]31.3735714285714[/C][C]-0.624571428571432[/C][/ROW]
[ROW][C]122[/C][C]30.236[/C][C]29.9608[/C][C]0.275199999999998[/C][/ROW]
[ROW][C]123[/C][C]29.99[/C][C]29.9608[/C][C]0.0291999999999959[/C][/ROW]
[ROW][C]124[/C][C]29.427[/C][C]29.9608[/C][C]-0.533800000000003[/C][/ROW]
[ROW][C]125[/C][C]29.376[/C][C]29.9608[/C][C]-0.584800000000001[/C][/ROW]
[ROW][C]126[/C][C]30.828[/C][C]31.3735714285714[/C][C]-0.545571428571431[/C][/ROW]
[ROW][C]127[/C][C]30.532[/C][C]31.3735714285714[/C][C]-0.84157142857143[/C][/ROW]
[ROW][C]128[/C][C]29.166[/C][C]29.9608[/C][C]-0.794800000000002[/C][/ROW]
[ROW][C]129[/C][C]29.124[/C][C]29.9608[/C][C]-0.836800000000004[/C][/ROW]
[ROW][C]130[/C][C]28.904[/C][C]29.9608[/C][C]-1.05680000000000[/C][/ROW]
[ROW][C]131[/C][C]27.992[/C][C]28.4949259259259[/C][C]-0.502925925925922[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=112969&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=112969&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
117.75917.8651666666667-0.106166666666667
217.5317.8651666666667-0.335166666666666
317.13916.65707142857140.481928571428572
416.91616.65707142857140.258928571428573
516.54316.6570714285714-0.114071428571428
616.31716.6570714285714-0.340071428571427
718.16117.86516666666670.295833333333334
819.14418.86950.2745
916.94716.65707142857140.289928571428572
1016.49116.6570714285714-0.166071428571428
1116.42816.6570714285714-0.229071428571427
1216.63916.6570714285714-0.0180714285714281
1316.82116.65707142857140.163928571428574
1416.76516.65707142857140.107928571428573
1516.53316.6570714285714-0.124071428571426
1616.55416.6570714285714-0.103071428571429
1716.49416.6570714285714-0.163071428571428
1816.61216.6570714285714-0.0450714285714291
1917.93317.86516666666670.0678333333333327
2019.0718.86950.200500000000002
2118.17917.86516666666670.313833333333331
2217.8317.8651666666667-0.0351666666666688
2317.34917.8651666666667-0.516166666666667
2417.91917.86516666666670.0538333333333334
2518.26918.8695-0.6005
2618.38518.8695-0.484499999999997
2718.2617.86516666666670.394833333333334
2817.90517.86516666666670.0398333333333341
2917.7317.8651666666667-0.135166666666667
3017.82717.8651666666667-0.0381666666666653
3119.97820.1624444444444-0.184444444444445
3220.31520.16244444444440.152555555555555
3318.93118.86950.0615000000000023
3418.73218.8695-0.137499999999999
3519.15518.86950.285500000000003
3619.2718.86950.400500000000001
3719.75420.1624444444444-0.408444444444445
3819.84520.1624444444444-0.317444444444448
3919.93720.1624444444444-0.225444444444445
4020.09720.1624444444444-0.0654444444444451
4119.98120.1624444444444-0.181444444444445
4220.50220.16244444444440.339555555555553
4322.71222.1230.589000000000002
4423.10122.1230.978000000000002
4521.38122.123-0.741999999999997
4621.25522.123-0.867999999999999
4721.05320.16244444444440.890555555555554
4821.56122.123-0.561999999999998
4921.92322.123-0.199999999999999
5022.00122.123-0.121999999999996
5122.36922.1230.246000000000002
5222.3222.1230.197000000000003
5322.14922.1230.0260000000000034
5422.58122.1230.458000000000002
5524.89626.6273333333333-1.73133333333334
5626.6126.6273333333333-0.0173333333333368
5725.41726.6273333333333-1.21033333333333
5826.48426.6273333333333-0.143333333333334
5926.32926.6273333333333-0.298333333333336
6026.98926.62733333333330.361666666666665
6127.1826.62733333333330.552666666666664
6227.28426.62733333333330.656666666666663
6327.43626.62733333333330.808666666666664
6427.08226.62733333333330.454666666666665
6526.81826.62733333333330.190666666666665
6627.00326.62733333333330.375666666666664
6729.34428.49492592592590.849074074074078
6829.77728.49492592592591.28207407407408
6928.0728.4949259259259-0.424925925925923
7027.99328.4949259259259-0.501925925925924
7127.67228.4949259259259-0.822925925925922
7227.80228.4949259259259-0.692925925925923
7327.32828.4949259259259-1.16692592592592
7427.66628.4949259259259-0.828925925925923
7527.45628.4949259259259-1.03892592592592
7627.79628.4949259259259-0.698925925925924
7727.64228.4949259259259-0.852925925925923
7827.65128.4949259259259-0.843925925925923
7929.60428.49492592592591.10907407407408
8029.19628.49492592592590.701074074074079
8128.32828.4949259259259-0.166925925925923
8227.98627.4543750.531625000000002
8327.73827.4543750.283625000000001
8427.86727.4543750.412625000000002
8527.5828.4949259259259-0.914925925925925
8627.38128.4949259259259-1.11392592592592
8727.29227.454375-0.162374999999997
8826.94427.454375-0.510375
8926.32927.454375-1.12537500000000
9029.02328.49492592592590.528074074074077
9128.70528.49492592592590.210074074074075
9227.21327.454375-0.241374999999998
9327.06327.454375-0.391375
9427.0127.454375-0.444374999999997
9527.70927.4543750.254625000000001
9627.80227.4543750.347625000000001
9727.68727.4543750.232625000000002
9827.71927.4543750.264625000000002
9927.96127.4543750.506625
10027.20327.454375-0.251374999999999
10127.74727.4543750.292625000000001
10230.71328.49492592592592.21807407407408
10330.39528.49492592592591.90007407407408
10428.89528.49492592592590.400074074074077
10528.4628.4949259259259-0.034925925925922
10628.28628.4949259259259-0.208925925925922
10728.98428.49492592592590.489074074074079
10829.62428.49492592592591.12907407407408
10929.73429.9608-0.226800000000001
11030.60329.96080.642199999999999
11130.42729.96080.466199999999997
11230.26929.96080.308199999999996
11330.79829.96080.837199999999996
11432.67631.37357142857141.30242857142857
11532.6831.37357142857141.30642857142857
11630.73729.96080.776199999999996
11730.329.96080.339199999999998
11830.32129.96080.360199999999999
11931.28231.3735714285714-0.0915714285714309
12030.86831.3735714285714-0.505571428571432
12130.74931.3735714285714-0.624571428571432
12230.23629.96080.275199999999998
12329.9929.96080.0291999999999959
12429.42729.9608-0.533800000000003
12529.37629.9608-0.584800000000001
12630.82831.3735714285714-0.545571428571431
12730.53231.3735714285714-0.84157142857143
12829.16629.9608-0.794800000000002
12929.12429.9608-0.836800000000004
13028.90429.9608-1.05680000000000
13127.99228.4949259259259-0.502925925925922



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