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 computationWed, 22 Dec 2010 17:58:31 +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/22/t12930430811usqngnfibvyhfh.htm/, Retrieved Mon, 06 May 2024 00:30:49 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=114473, Retrieved Mon, 06 May 2024 00:30:49 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact143
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Univariate Explorative Data Analysis] [Monthly US soldie...] [2010-11-02 12:07:39] [b98453cac15ba1066b407e146608df68]
- RMP   [Exponential Smoothing] [Soldiers] [2010-11-30 14:09:25] [b98453cac15ba1066b407e146608df68]
- RMPD      [Recursive Partitioning (Regression Trees)] [BEL20-RP1(no cat)] [2010-12-22 17:58:31] [4c7d8c32b2e34fcaa7f14928b91d45ae] [Current]
-   P         [Recursive Partitioning (Regression Trees)] [BEL20-RP2(cat)] [2010-12-22 18:45:42] [d672a41e0af7ff107c03f1d65e47fd32]
-   P           [Recursive Partitioning (Regression Trees)] [BEL20-RP(crossval...] [2010-12-25 19:22:30] [d672a41e0af7ff107c03f1d65e47fd32]
Feedback Forum

Post a new message
Dataseries X:
3.04	493	9	3.030	9.026	25.64	104.8
3.28	481	11	2.803	9.787	27.97	105.2
3.51	462	13	2.768	9.536	27.62	105.6
3.69	457	12	2.883	9.490	23.31	105.8
3.92	442	13	2.863	9.736	29.07	106.1
4.29	439	15	2.897	9.694	29.58	106.5
4.31	488	13	3.013	9.647	28.63	106.71
4.42	521	16	3.143	9.753	29.92	106.68
4.59	501	10	3.033	10.070	32.68	107.41
4.76	485	14	3.046	10.137	31.54	107.15
4.83	464	14	3.111	9.984	32.43	107.5
4.83	460	45	3.013	9.732	26.54	107.22
4.76	467	13	2.987	9.103	25.85	107.11
4.99	460	8	2.996	9.155	27.60	107.57
4.78	448	7	2.833	9.308	25.71	107.81
5.06	443	3	2.849	9.394	25.38	108.75
4.65	436	3	2.795	9.948	28.57	109.43
4.54	431	4	2.845	10.177	27.64	109.62
4.51	484	4	2.915	10.002	25.36	109.54
4.49	510	0	2.893	9.728	25.90	109.53
3.99	513	-4	2.604	10.002	26.29	109.84
3.97	503	-14	2.642	10.063	21.74	109.67
3.51	471	-18	2.660	10.018	19.20	109.79
3.34	471	-8	2.639	9.960	19.32	109.56
3.29	476	-1	2.720	10.236	19.82	110.22
3.28	475	1	2.746	10.893	20.36	110.4
3.26	470	2	2.736	10.756	24.31	110.69
3.32	461	0	2.812	10.940	25.97	110.72
3.31	455	1	2.799	10.997	25.61	110.89
3.35	456	0	2.555	10.827	24.67	110.58
3.30	517	-1	2.305	10.166	25.59	110.94
3.29	525	-3	2.215	10.186	26.09	110.91
3.32	523	-3	2.066	10.457	28.37	111.22
3.30	519	-3	1.940	10.368	27.34	111.09
3.30	509	-4	2.042	10.244	24.46	111
3.09	512	-8	1.995	10.511	27.46	111.06
2.79	519	-9	1.947	10.812	30.23	111.55
2.76	517	-13	1.766	10.738	32.33	112.32
2.75	510	-18	1.635	10.171	29.87	112.64
2.56	509	-11	1.833	9.721	24.87	112.36
2.56	501	-9	1.910	9.897	25.48	112.04
2.21	507	-10	1.960	9.828	27.28	112.37
2.08	569	-13	1.970	9.924	28.24	112.59
2.10	580	-11	2.061	10.371	29.58	112.89
2.02	578	-5	2.093	10.846	26.95	113.22
2.01	565	-15	2.121	10.413	29.08	112.85
1.97	547	-6	2.175	10.709	28.76	113.06
2.06	555	-6	2.197	10.662	29.59	112.99
2.02	562	-3	2.350	10.570	30.70	113.32
2.03	561	-1	2.440	10.297	30.52	113.74
2.01	555	-3	2.409	10.635	32.67	113.91
2.08	544	-4	2.473	10.872	33.19	114.52
2.02	537	-6	2.408	10.296	37.13	114.96
2.03	543	0	2.455	10.383	35.54	114.91
2.07	594	-4	2.448	10.431	37.75	115.3
2.04	611	-2	2.498	10.574	41.84	115.44
2.05	613	-2	2.646	10.653	42.94	115.52
2.11	611	-6	2.757	10.805	49.14	116.08
2.09	594	-7	2.849	10.872	44.61	115.94
2.05	595	-6	2.921	10.625	40.22	115.56
2.08	591	-6	2.982	10.407	44.23	115.88
2.06	589	-3	3.081	10.463	45.85	116.66
2.06	584	-2	3.106	10.556	53.38	117.41
2.08	573	-5	3.119	10.646	53.26	117.68
2.07	567	-11	3.061	10.702	51.80	117.85
2.06	569	-11	3.097	11.353	55.30	118.21
2.07	621	-11	3.162	11.346	57.81	118.92
2.06	629	-10	3.257	11.451	63.96	119.03
2.09	628	-14	3.277	11.964	63.77	119.17
2.07	612	-8	3.295	12.574	59.15	118.95
2.09	595	-9	3.364	13.031	56.12	118.92
2.28	597	-5	3.494	13.812	57.42	118.9
2.33	593	-1	3.667	14.544	63.52	118.92
2.35	590	-2	3.813	14.931	61.71	119.44
2.52	580	-5	3.918	14.886	63.01	119.40
2.63	574	-4	3.896	16.005	68.18	119.98
2.58	573	-6	3.801	17.064	72.03	120.43
2.70	573	-2	3.570	15.168	69.75	120.41
2.81	620	-2	3.702	16.050	74.41	120.82
2.97	626	-2	3.862	15.839	74.33	120.97
3.04	620	-2	3.970	15.137	64.24	120.63
3.28	588	2	4.139	14.954	60.03	120.38
3.33	566	1	4.200	15.648	59.44	120.68
3.50	557	-8	4.291	15.305	62.50	120.84
3.56	561	-1	4.444	15.579	55.04	120.90
3.57	549	1	4.503	16.348	58.34	121.56
3.69	532	-1	4.357	15.928	61.92	121.57
3.82	526	2	4.591	16.171	67.65	122.12
3.79	511	2	4.697	15.937	67.68	121.97
3.96	499	1	4.621	15.713	70.30	121.96
4.06	555	-1	4.563	15.594	75.26	122.48
4.05	565	-2	4.203	15.683	71.44	122.33
4.03	542	-2	4.296	16.438	76.36	122.44
3.94	527	-1	4.435	17.032	81.71	123.08
4.02	510	-8	4.105	17.696	92.60	124.23
3.88	514	-4	4.117	17.745	90.60	124.58
4.02	517	-6	3.844	19.394	92.23	125.08
4.03	508	-3	3.721	20.148	94.09	125.98
4.09	493	-3	3.674	20.108	102.79	126.90
3.99	490	-7	3.858	18.584	109.65	127.19
4.01	469	-9	3.801	18.441	124.05	128.33
4.01	478	-11	3.504	18.391	132.69	129.04
4.19	528	-13	3.033	19.178	135.81	129.72
4.30	534	-11	3.047	18.079	116.07	128.92
4.27	518	-9	2.962	18.483	101.42	129.13
3.82	506	-17	2.198	19.644	75.73	128.90
3.15	502	-22	2.014	19.195	55.48	128.13
2.49	516	-25	1.863	19.650	43.80	127.85
1.81	528	-20	1.905	20.830	45.29	127.98
1.26	533	-24	1.811	23.595	44.01	128.42
1.06	536	-24	1.670	22.937	47.48	127.68
0.84	537	-22	1.864	21.814	51.07	127.95
0.78	524	-19	2.052	21.928	57.84	127.85
0.70	536	-18	2.030	21.777	69.04	127.61
0.36	587	-17	2.071	21.383	65.61	127.53
0.35	597	-11	2.293	21.467	72.87	127.92
0.36	581	-11	2.443	22.052	68.41	127.59
0.36	564	-12	2.513	22.680	73.25	127.65
0.36	558	-10	2.467	24.320	77.43	127.98
0.35	575	-15	2.503	24.977	75.28	128.19
0.34	580	-15	2.540	25.204	77.33	128.77
0.34	575	-15	2.483	25.739	74.31	129.31
0.35	563	-13	2.626	26.434	79.70	129.80
0.35	552	-8	2.656	27.525	85.47	130.24
0.34	537	-13	2.447	30.695	77.98	130.76
0.35	545	-9	2.467	32.436	75.69	130.75
0.48	601	-7	2.462	30.160	75.20	130.81
0.43	604	-4	2.505	30.236	77.21	130.89
0.45	586	-4	2.579	31.293	77.85	131.30
0.70	564	-2	2.649	31.077	83.53	131.49
0.59	549	0	2.637	32.226	85.99	131.65




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time8 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 & 8 seconds \tabularnewline
R Server & 'George Udny Yule' @ 72.249.76.132 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=114473&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]8 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=114473&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=114473&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 time8 seconds
R Server'George Udny Yule' @ 72.249.76.132







Goodness of Fit
Correlation0.9377
R-squared0.8793
RMSE0.2628

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

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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=114473&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.9377
R-squared0.8793
RMSE0.2628







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
13.032.744888888888890.285111111111111
22.8032.744888888888890.0581111111111108
32.7682.744888888888890.0231111111111106
42.8832.94794117647059-0.0649411764705885
52.8632.94794117647059-0.0849411764705885
62.8972.94794117647059-0.0509411764705887
73.0132.947941176470590.0650588235294114
83.1432.947941176470590.195058823529411
93.0332.947941176470590.0850588235294114
103.0462.947941176470590.0980588235294113
113.1112.947941176470590.163058823529412
123.0132.947941176470590.0650588235294114
132.9872.947941176470590.0390588235294116
142.9962.947941176470590.0480588235294115
152.8332.94794117647059-0.114941176470588
162.8492.94794117647059-0.0989411764705883
172.7952.94794117647059-0.152941176470589
182.8452.94794117647059-0.102941176470588
192.9152.94794117647059-0.0329411764705885
202.8932.94794117647059-0.0549411764705887
212.6042.306611111111110.297388888888888
222.6421.9761250.665875
232.661.9761250.683875
242.6392.306611111111110.332388888888888
252.722.306611111111110.413388888888889
262.7462.744888888888890.00111111111111084
272.7362.74488888888889-0.00888888888888895
282.8122.744888888888890.0671111111111107
292.7992.744888888888890.0541111111111108
302.5552.74488888888889-0.189888888888889
312.3052.30661111111111-0.00161111111111145
322.2152.30661111111111-0.0916111111111118
332.0662.30661111111111-0.240611111111112
341.942.30661111111111-0.366611111111112
352.0422.30661111111111-0.264611111111112
361.9952.30661111111111-0.311611111111112
371.9471.976125-0.0291249999999998
381.7661.976125-0.210125
391.6351.976125-0.341125
401.8331.976125-0.143125
411.911.976125-0.066125
421.961.976125-0.0161249999999999
431.971.976125-0.00612499999999994
442.0611.9761250.084875
452.0932.30661111111111-0.213611111111112
462.1211.9761250.144875
472.1752.30661111111111-0.131611111111112
482.1972.30661111111111-0.109611111111112
492.352.306611111111110.0433888888888885
502.442.306611111111110.133388888888888
512.4092.306611111111110.102388888888888
522.4732.306611111111110.166388888888888
532.4082.306611111111110.101388888888888
542.4552.74488888888889-0.289888888888889
552.4482.306611111111110.141388888888888
562.4982.81914285714286-0.321142857142857
572.6462.81914285714286-0.173142857142857
582.7572.81914285714286-0.0621428571428568
592.8492.819142857142860.0298571428571432
602.9212.819142857142860.101857142857143
612.9822.819142857142860.162857142857143
623.0812.819142857142860.261857142857143
633.1062.778666666666670.327333333333333
643.1192.778666666666670.340333333333333
653.0612.93450.1265
663.0972.93450.1625
673.1622.93450.2275
683.2572.93450.3225
693.2772.93450.3425
703.2952.778666666666670.516333333333333
713.3642.93450.4295
723.4943.7693-0.275300000000000
733.6673.7693-0.1023
743.8133.76930.0437000000000003
753.9183.76930.148700000000000
763.8963.76930.1267
773.8013.76930.0317000000000003
783.573.7693-0.1993
793.7023.7693-0.0672999999999999
803.8623.76930.0927000000000002
813.973.76930.200700000000000
824.1394.24521052631579-0.10621052631579
834.24.24521052631579-0.04521052631579
844.2914.245210526315790.0457894736842102
854.4444.245210526315790.198789473684210
864.5034.245210526315790.25778947368421
874.3574.245210526315790.11178947368421
884.5914.245210526315790.34578947368421
894.6974.245210526315790.45178947368421
904.6214.245210526315790.37578947368421
914.5634.245210526315790.317789473684210
924.2034.24521052631579-0.0422105263157899
934.2964.245210526315790.05078947368421
944.4354.245210526315790.189789473684209
954.1054.24521052631579-0.140210526315790
964.1174.24521052631579-0.128210526315790
973.8444.24521052631579-0.401210526315790
983.7214.24521052631579-0.52421052631579
993.6744.24521052631579-0.57121052631579
1003.8584.24521052631579-0.38721052631579
1013.8012.93450.8665
1023.5042.93450.5695
1033.0332.93450.0985
1043.0472.93450.112500000000000
1052.9622.93450.0275000000000003
1062.1982.236375-0.0383749999999998
1072.0142.236375-0.222375
1081.8631.976125-0.113125
1091.9051.976125-0.0711249999999999
1101.8111.976125-0.165125
1111.671.976125-0.306125
1121.8641.976125-0.112125000000000
1132.0522.236375-0.184375000000000
1142.032.236375-0.206375
1152.0712.236375-0.165375000000000
1162.2932.9345-0.6415
1172.4432.9345-0.4915
1182.5132.9345-0.4215
1192.4672.9345-0.4675
1202.5032.2363750.266625000000000
1212.542.2363750.303625
1222.4832.2363750.246625000000000
1232.6262.9345-0.3085
1242.6562.77866666666667-0.122666666666667
1252.4472.9345-0.4875
1262.4672.9345-0.4675
1272.4622.77866666666667-0.316666666666667
1282.5052.77866666666667-0.273666666666667
1292.5792.77866666666667-0.199666666666667
1302.6492.77866666666667-0.129666666666667
1312.6372.77866666666667-0.141666666666667

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 3.03 & 2.74488888888889 & 0.285111111111111 \tabularnewline
2 & 2.803 & 2.74488888888889 & 0.0581111111111108 \tabularnewline
3 & 2.768 & 2.74488888888889 & 0.0231111111111106 \tabularnewline
4 & 2.883 & 2.94794117647059 & -0.0649411764705885 \tabularnewline
5 & 2.863 & 2.94794117647059 & -0.0849411764705885 \tabularnewline
6 & 2.897 & 2.94794117647059 & -0.0509411764705887 \tabularnewline
7 & 3.013 & 2.94794117647059 & 0.0650588235294114 \tabularnewline
8 & 3.143 & 2.94794117647059 & 0.195058823529411 \tabularnewline
9 & 3.033 & 2.94794117647059 & 0.0850588235294114 \tabularnewline
10 & 3.046 & 2.94794117647059 & 0.0980588235294113 \tabularnewline
11 & 3.111 & 2.94794117647059 & 0.163058823529412 \tabularnewline
12 & 3.013 & 2.94794117647059 & 0.0650588235294114 \tabularnewline
13 & 2.987 & 2.94794117647059 & 0.0390588235294116 \tabularnewline
14 & 2.996 & 2.94794117647059 & 0.0480588235294115 \tabularnewline
15 & 2.833 & 2.94794117647059 & -0.114941176470588 \tabularnewline
16 & 2.849 & 2.94794117647059 & -0.0989411764705883 \tabularnewline
17 & 2.795 & 2.94794117647059 & -0.152941176470589 \tabularnewline
18 & 2.845 & 2.94794117647059 & -0.102941176470588 \tabularnewline
19 & 2.915 & 2.94794117647059 & -0.0329411764705885 \tabularnewline
20 & 2.893 & 2.94794117647059 & -0.0549411764705887 \tabularnewline
21 & 2.604 & 2.30661111111111 & 0.297388888888888 \tabularnewline
22 & 2.642 & 1.976125 & 0.665875 \tabularnewline
23 & 2.66 & 1.976125 & 0.683875 \tabularnewline
24 & 2.639 & 2.30661111111111 & 0.332388888888888 \tabularnewline
25 & 2.72 & 2.30661111111111 & 0.413388888888889 \tabularnewline
26 & 2.746 & 2.74488888888889 & 0.00111111111111084 \tabularnewline
27 & 2.736 & 2.74488888888889 & -0.00888888888888895 \tabularnewline
28 & 2.812 & 2.74488888888889 & 0.0671111111111107 \tabularnewline
29 & 2.799 & 2.74488888888889 & 0.0541111111111108 \tabularnewline
30 & 2.555 & 2.74488888888889 & -0.189888888888889 \tabularnewline
31 & 2.305 & 2.30661111111111 & -0.00161111111111145 \tabularnewline
32 & 2.215 & 2.30661111111111 & -0.0916111111111118 \tabularnewline
33 & 2.066 & 2.30661111111111 & -0.240611111111112 \tabularnewline
34 & 1.94 & 2.30661111111111 & -0.366611111111112 \tabularnewline
35 & 2.042 & 2.30661111111111 & -0.264611111111112 \tabularnewline
36 & 1.995 & 2.30661111111111 & -0.311611111111112 \tabularnewline
37 & 1.947 & 1.976125 & -0.0291249999999998 \tabularnewline
38 & 1.766 & 1.976125 & -0.210125 \tabularnewline
39 & 1.635 & 1.976125 & -0.341125 \tabularnewline
40 & 1.833 & 1.976125 & -0.143125 \tabularnewline
41 & 1.91 & 1.976125 & -0.066125 \tabularnewline
42 & 1.96 & 1.976125 & -0.0161249999999999 \tabularnewline
43 & 1.97 & 1.976125 & -0.00612499999999994 \tabularnewline
44 & 2.061 & 1.976125 & 0.084875 \tabularnewline
45 & 2.093 & 2.30661111111111 & -0.213611111111112 \tabularnewline
46 & 2.121 & 1.976125 & 0.144875 \tabularnewline
47 & 2.175 & 2.30661111111111 & -0.131611111111112 \tabularnewline
48 & 2.197 & 2.30661111111111 & -0.109611111111112 \tabularnewline
49 & 2.35 & 2.30661111111111 & 0.0433888888888885 \tabularnewline
50 & 2.44 & 2.30661111111111 & 0.133388888888888 \tabularnewline
51 & 2.409 & 2.30661111111111 & 0.102388888888888 \tabularnewline
52 & 2.473 & 2.30661111111111 & 0.166388888888888 \tabularnewline
53 & 2.408 & 2.30661111111111 & 0.101388888888888 \tabularnewline
54 & 2.455 & 2.74488888888889 & -0.289888888888889 \tabularnewline
55 & 2.448 & 2.30661111111111 & 0.141388888888888 \tabularnewline
56 & 2.498 & 2.81914285714286 & -0.321142857142857 \tabularnewline
57 & 2.646 & 2.81914285714286 & -0.173142857142857 \tabularnewline
58 & 2.757 & 2.81914285714286 & -0.0621428571428568 \tabularnewline
59 & 2.849 & 2.81914285714286 & 0.0298571428571432 \tabularnewline
60 & 2.921 & 2.81914285714286 & 0.101857142857143 \tabularnewline
61 & 2.982 & 2.81914285714286 & 0.162857142857143 \tabularnewline
62 & 3.081 & 2.81914285714286 & 0.261857142857143 \tabularnewline
63 & 3.106 & 2.77866666666667 & 0.327333333333333 \tabularnewline
64 & 3.119 & 2.77866666666667 & 0.340333333333333 \tabularnewline
65 & 3.061 & 2.9345 & 0.1265 \tabularnewline
66 & 3.097 & 2.9345 & 0.1625 \tabularnewline
67 & 3.162 & 2.9345 & 0.2275 \tabularnewline
68 & 3.257 & 2.9345 & 0.3225 \tabularnewline
69 & 3.277 & 2.9345 & 0.3425 \tabularnewline
70 & 3.295 & 2.77866666666667 & 0.516333333333333 \tabularnewline
71 & 3.364 & 2.9345 & 0.4295 \tabularnewline
72 & 3.494 & 3.7693 & -0.275300000000000 \tabularnewline
73 & 3.667 & 3.7693 & -0.1023 \tabularnewline
74 & 3.813 & 3.7693 & 0.0437000000000003 \tabularnewline
75 & 3.918 & 3.7693 & 0.148700000000000 \tabularnewline
76 & 3.896 & 3.7693 & 0.1267 \tabularnewline
77 & 3.801 & 3.7693 & 0.0317000000000003 \tabularnewline
78 & 3.57 & 3.7693 & -0.1993 \tabularnewline
79 & 3.702 & 3.7693 & -0.0672999999999999 \tabularnewline
80 & 3.862 & 3.7693 & 0.0927000000000002 \tabularnewline
81 & 3.97 & 3.7693 & 0.200700000000000 \tabularnewline
82 & 4.139 & 4.24521052631579 & -0.10621052631579 \tabularnewline
83 & 4.2 & 4.24521052631579 & -0.04521052631579 \tabularnewline
84 & 4.291 & 4.24521052631579 & 0.0457894736842102 \tabularnewline
85 & 4.444 & 4.24521052631579 & 0.198789473684210 \tabularnewline
86 & 4.503 & 4.24521052631579 & 0.25778947368421 \tabularnewline
87 & 4.357 & 4.24521052631579 & 0.11178947368421 \tabularnewline
88 & 4.591 & 4.24521052631579 & 0.34578947368421 \tabularnewline
89 & 4.697 & 4.24521052631579 & 0.45178947368421 \tabularnewline
90 & 4.621 & 4.24521052631579 & 0.37578947368421 \tabularnewline
91 & 4.563 & 4.24521052631579 & 0.317789473684210 \tabularnewline
92 & 4.203 & 4.24521052631579 & -0.0422105263157899 \tabularnewline
93 & 4.296 & 4.24521052631579 & 0.05078947368421 \tabularnewline
94 & 4.435 & 4.24521052631579 & 0.189789473684209 \tabularnewline
95 & 4.105 & 4.24521052631579 & -0.140210526315790 \tabularnewline
96 & 4.117 & 4.24521052631579 & -0.128210526315790 \tabularnewline
97 & 3.844 & 4.24521052631579 & -0.401210526315790 \tabularnewline
98 & 3.721 & 4.24521052631579 & -0.52421052631579 \tabularnewline
99 & 3.674 & 4.24521052631579 & -0.57121052631579 \tabularnewline
100 & 3.858 & 4.24521052631579 & -0.38721052631579 \tabularnewline
101 & 3.801 & 2.9345 & 0.8665 \tabularnewline
102 & 3.504 & 2.9345 & 0.5695 \tabularnewline
103 & 3.033 & 2.9345 & 0.0985 \tabularnewline
104 & 3.047 & 2.9345 & 0.112500000000000 \tabularnewline
105 & 2.962 & 2.9345 & 0.0275000000000003 \tabularnewline
106 & 2.198 & 2.236375 & -0.0383749999999998 \tabularnewline
107 & 2.014 & 2.236375 & -0.222375 \tabularnewline
108 & 1.863 & 1.976125 & -0.113125 \tabularnewline
109 & 1.905 & 1.976125 & -0.0711249999999999 \tabularnewline
110 & 1.811 & 1.976125 & -0.165125 \tabularnewline
111 & 1.67 & 1.976125 & -0.306125 \tabularnewline
112 & 1.864 & 1.976125 & -0.112125000000000 \tabularnewline
113 & 2.052 & 2.236375 & -0.184375000000000 \tabularnewline
114 & 2.03 & 2.236375 & -0.206375 \tabularnewline
115 & 2.071 & 2.236375 & -0.165375000000000 \tabularnewline
116 & 2.293 & 2.9345 & -0.6415 \tabularnewline
117 & 2.443 & 2.9345 & -0.4915 \tabularnewline
118 & 2.513 & 2.9345 & -0.4215 \tabularnewline
119 & 2.467 & 2.9345 & -0.4675 \tabularnewline
120 & 2.503 & 2.236375 & 0.266625000000000 \tabularnewline
121 & 2.54 & 2.236375 & 0.303625 \tabularnewline
122 & 2.483 & 2.236375 & 0.246625000000000 \tabularnewline
123 & 2.626 & 2.9345 & -0.3085 \tabularnewline
124 & 2.656 & 2.77866666666667 & -0.122666666666667 \tabularnewline
125 & 2.447 & 2.9345 & -0.4875 \tabularnewline
126 & 2.467 & 2.9345 & -0.4675 \tabularnewline
127 & 2.462 & 2.77866666666667 & -0.316666666666667 \tabularnewline
128 & 2.505 & 2.77866666666667 & -0.273666666666667 \tabularnewline
129 & 2.579 & 2.77866666666667 & -0.199666666666667 \tabularnewline
130 & 2.649 & 2.77866666666667 & -0.129666666666667 \tabularnewline
131 & 2.637 & 2.77866666666667 & -0.141666666666667 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=114473&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]3.03[/C][C]2.74488888888889[/C][C]0.285111111111111[/C][/ROW]
[ROW][C]2[/C][C]2.803[/C][C]2.74488888888889[/C][C]0.0581111111111108[/C][/ROW]
[ROW][C]3[/C][C]2.768[/C][C]2.74488888888889[/C][C]0.0231111111111106[/C][/ROW]
[ROW][C]4[/C][C]2.883[/C][C]2.94794117647059[/C][C]-0.0649411764705885[/C][/ROW]
[ROW][C]5[/C][C]2.863[/C][C]2.94794117647059[/C][C]-0.0849411764705885[/C][/ROW]
[ROW][C]6[/C][C]2.897[/C][C]2.94794117647059[/C][C]-0.0509411764705887[/C][/ROW]
[ROW][C]7[/C][C]3.013[/C][C]2.94794117647059[/C][C]0.0650588235294114[/C][/ROW]
[ROW][C]8[/C][C]3.143[/C][C]2.94794117647059[/C][C]0.195058823529411[/C][/ROW]
[ROW][C]9[/C][C]3.033[/C][C]2.94794117647059[/C][C]0.0850588235294114[/C][/ROW]
[ROW][C]10[/C][C]3.046[/C][C]2.94794117647059[/C][C]0.0980588235294113[/C][/ROW]
[ROW][C]11[/C][C]3.111[/C][C]2.94794117647059[/C][C]0.163058823529412[/C][/ROW]
[ROW][C]12[/C][C]3.013[/C][C]2.94794117647059[/C][C]0.0650588235294114[/C][/ROW]
[ROW][C]13[/C][C]2.987[/C][C]2.94794117647059[/C][C]0.0390588235294116[/C][/ROW]
[ROW][C]14[/C][C]2.996[/C][C]2.94794117647059[/C][C]0.0480588235294115[/C][/ROW]
[ROW][C]15[/C][C]2.833[/C][C]2.94794117647059[/C][C]-0.114941176470588[/C][/ROW]
[ROW][C]16[/C][C]2.849[/C][C]2.94794117647059[/C][C]-0.0989411764705883[/C][/ROW]
[ROW][C]17[/C][C]2.795[/C][C]2.94794117647059[/C][C]-0.152941176470589[/C][/ROW]
[ROW][C]18[/C][C]2.845[/C][C]2.94794117647059[/C][C]-0.102941176470588[/C][/ROW]
[ROW][C]19[/C][C]2.915[/C][C]2.94794117647059[/C][C]-0.0329411764705885[/C][/ROW]
[ROW][C]20[/C][C]2.893[/C][C]2.94794117647059[/C][C]-0.0549411764705887[/C][/ROW]
[ROW][C]21[/C][C]2.604[/C][C]2.30661111111111[/C][C]0.297388888888888[/C][/ROW]
[ROW][C]22[/C][C]2.642[/C][C]1.976125[/C][C]0.665875[/C][/ROW]
[ROW][C]23[/C][C]2.66[/C][C]1.976125[/C][C]0.683875[/C][/ROW]
[ROW][C]24[/C][C]2.639[/C][C]2.30661111111111[/C][C]0.332388888888888[/C][/ROW]
[ROW][C]25[/C][C]2.72[/C][C]2.30661111111111[/C][C]0.413388888888889[/C][/ROW]
[ROW][C]26[/C][C]2.746[/C][C]2.74488888888889[/C][C]0.00111111111111084[/C][/ROW]
[ROW][C]27[/C][C]2.736[/C][C]2.74488888888889[/C][C]-0.00888888888888895[/C][/ROW]
[ROW][C]28[/C][C]2.812[/C][C]2.74488888888889[/C][C]0.0671111111111107[/C][/ROW]
[ROW][C]29[/C][C]2.799[/C][C]2.74488888888889[/C][C]0.0541111111111108[/C][/ROW]
[ROW][C]30[/C][C]2.555[/C][C]2.74488888888889[/C][C]-0.189888888888889[/C][/ROW]
[ROW][C]31[/C][C]2.305[/C][C]2.30661111111111[/C][C]-0.00161111111111145[/C][/ROW]
[ROW][C]32[/C][C]2.215[/C][C]2.30661111111111[/C][C]-0.0916111111111118[/C][/ROW]
[ROW][C]33[/C][C]2.066[/C][C]2.30661111111111[/C][C]-0.240611111111112[/C][/ROW]
[ROW][C]34[/C][C]1.94[/C][C]2.30661111111111[/C][C]-0.366611111111112[/C][/ROW]
[ROW][C]35[/C][C]2.042[/C][C]2.30661111111111[/C][C]-0.264611111111112[/C][/ROW]
[ROW][C]36[/C][C]1.995[/C][C]2.30661111111111[/C][C]-0.311611111111112[/C][/ROW]
[ROW][C]37[/C][C]1.947[/C][C]1.976125[/C][C]-0.0291249999999998[/C][/ROW]
[ROW][C]38[/C][C]1.766[/C][C]1.976125[/C][C]-0.210125[/C][/ROW]
[ROW][C]39[/C][C]1.635[/C][C]1.976125[/C][C]-0.341125[/C][/ROW]
[ROW][C]40[/C][C]1.833[/C][C]1.976125[/C][C]-0.143125[/C][/ROW]
[ROW][C]41[/C][C]1.91[/C][C]1.976125[/C][C]-0.066125[/C][/ROW]
[ROW][C]42[/C][C]1.96[/C][C]1.976125[/C][C]-0.0161249999999999[/C][/ROW]
[ROW][C]43[/C][C]1.97[/C][C]1.976125[/C][C]-0.00612499999999994[/C][/ROW]
[ROW][C]44[/C][C]2.061[/C][C]1.976125[/C][C]0.084875[/C][/ROW]
[ROW][C]45[/C][C]2.093[/C][C]2.30661111111111[/C][C]-0.213611111111112[/C][/ROW]
[ROW][C]46[/C][C]2.121[/C][C]1.976125[/C][C]0.144875[/C][/ROW]
[ROW][C]47[/C][C]2.175[/C][C]2.30661111111111[/C][C]-0.131611111111112[/C][/ROW]
[ROW][C]48[/C][C]2.197[/C][C]2.30661111111111[/C][C]-0.109611111111112[/C][/ROW]
[ROW][C]49[/C][C]2.35[/C][C]2.30661111111111[/C][C]0.0433888888888885[/C][/ROW]
[ROW][C]50[/C][C]2.44[/C][C]2.30661111111111[/C][C]0.133388888888888[/C][/ROW]
[ROW][C]51[/C][C]2.409[/C][C]2.30661111111111[/C][C]0.102388888888888[/C][/ROW]
[ROW][C]52[/C][C]2.473[/C][C]2.30661111111111[/C][C]0.166388888888888[/C][/ROW]
[ROW][C]53[/C][C]2.408[/C][C]2.30661111111111[/C][C]0.101388888888888[/C][/ROW]
[ROW][C]54[/C][C]2.455[/C][C]2.74488888888889[/C][C]-0.289888888888889[/C][/ROW]
[ROW][C]55[/C][C]2.448[/C][C]2.30661111111111[/C][C]0.141388888888888[/C][/ROW]
[ROW][C]56[/C][C]2.498[/C][C]2.81914285714286[/C][C]-0.321142857142857[/C][/ROW]
[ROW][C]57[/C][C]2.646[/C][C]2.81914285714286[/C][C]-0.173142857142857[/C][/ROW]
[ROW][C]58[/C][C]2.757[/C][C]2.81914285714286[/C][C]-0.0621428571428568[/C][/ROW]
[ROW][C]59[/C][C]2.849[/C][C]2.81914285714286[/C][C]0.0298571428571432[/C][/ROW]
[ROW][C]60[/C][C]2.921[/C][C]2.81914285714286[/C][C]0.101857142857143[/C][/ROW]
[ROW][C]61[/C][C]2.982[/C][C]2.81914285714286[/C][C]0.162857142857143[/C][/ROW]
[ROW][C]62[/C][C]3.081[/C][C]2.81914285714286[/C][C]0.261857142857143[/C][/ROW]
[ROW][C]63[/C][C]3.106[/C][C]2.77866666666667[/C][C]0.327333333333333[/C][/ROW]
[ROW][C]64[/C][C]3.119[/C][C]2.77866666666667[/C][C]0.340333333333333[/C][/ROW]
[ROW][C]65[/C][C]3.061[/C][C]2.9345[/C][C]0.1265[/C][/ROW]
[ROW][C]66[/C][C]3.097[/C][C]2.9345[/C][C]0.1625[/C][/ROW]
[ROW][C]67[/C][C]3.162[/C][C]2.9345[/C][C]0.2275[/C][/ROW]
[ROW][C]68[/C][C]3.257[/C][C]2.9345[/C][C]0.3225[/C][/ROW]
[ROW][C]69[/C][C]3.277[/C][C]2.9345[/C][C]0.3425[/C][/ROW]
[ROW][C]70[/C][C]3.295[/C][C]2.77866666666667[/C][C]0.516333333333333[/C][/ROW]
[ROW][C]71[/C][C]3.364[/C][C]2.9345[/C][C]0.4295[/C][/ROW]
[ROW][C]72[/C][C]3.494[/C][C]3.7693[/C][C]-0.275300000000000[/C][/ROW]
[ROW][C]73[/C][C]3.667[/C][C]3.7693[/C][C]-0.1023[/C][/ROW]
[ROW][C]74[/C][C]3.813[/C][C]3.7693[/C][C]0.0437000000000003[/C][/ROW]
[ROW][C]75[/C][C]3.918[/C][C]3.7693[/C][C]0.148700000000000[/C][/ROW]
[ROW][C]76[/C][C]3.896[/C][C]3.7693[/C][C]0.1267[/C][/ROW]
[ROW][C]77[/C][C]3.801[/C][C]3.7693[/C][C]0.0317000000000003[/C][/ROW]
[ROW][C]78[/C][C]3.57[/C][C]3.7693[/C][C]-0.1993[/C][/ROW]
[ROW][C]79[/C][C]3.702[/C][C]3.7693[/C][C]-0.0672999999999999[/C][/ROW]
[ROW][C]80[/C][C]3.862[/C][C]3.7693[/C][C]0.0927000000000002[/C][/ROW]
[ROW][C]81[/C][C]3.97[/C][C]3.7693[/C][C]0.200700000000000[/C][/ROW]
[ROW][C]82[/C][C]4.139[/C][C]4.24521052631579[/C][C]-0.10621052631579[/C][/ROW]
[ROW][C]83[/C][C]4.2[/C][C]4.24521052631579[/C][C]-0.04521052631579[/C][/ROW]
[ROW][C]84[/C][C]4.291[/C][C]4.24521052631579[/C][C]0.0457894736842102[/C][/ROW]
[ROW][C]85[/C][C]4.444[/C][C]4.24521052631579[/C][C]0.198789473684210[/C][/ROW]
[ROW][C]86[/C][C]4.503[/C][C]4.24521052631579[/C][C]0.25778947368421[/C][/ROW]
[ROW][C]87[/C][C]4.357[/C][C]4.24521052631579[/C][C]0.11178947368421[/C][/ROW]
[ROW][C]88[/C][C]4.591[/C][C]4.24521052631579[/C][C]0.34578947368421[/C][/ROW]
[ROW][C]89[/C][C]4.697[/C][C]4.24521052631579[/C][C]0.45178947368421[/C][/ROW]
[ROW][C]90[/C][C]4.621[/C][C]4.24521052631579[/C][C]0.37578947368421[/C][/ROW]
[ROW][C]91[/C][C]4.563[/C][C]4.24521052631579[/C][C]0.317789473684210[/C][/ROW]
[ROW][C]92[/C][C]4.203[/C][C]4.24521052631579[/C][C]-0.0422105263157899[/C][/ROW]
[ROW][C]93[/C][C]4.296[/C][C]4.24521052631579[/C][C]0.05078947368421[/C][/ROW]
[ROW][C]94[/C][C]4.435[/C][C]4.24521052631579[/C][C]0.189789473684209[/C][/ROW]
[ROW][C]95[/C][C]4.105[/C][C]4.24521052631579[/C][C]-0.140210526315790[/C][/ROW]
[ROW][C]96[/C][C]4.117[/C][C]4.24521052631579[/C][C]-0.128210526315790[/C][/ROW]
[ROW][C]97[/C][C]3.844[/C][C]4.24521052631579[/C][C]-0.401210526315790[/C][/ROW]
[ROW][C]98[/C][C]3.721[/C][C]4.24521052631579[/C][C]-0.52421052631579[/C][/ROW]
[ROW][C]99[/C][C]3.674[/C][C]4.24521052631579[/C][C]-0.57121052631579[/C][/ROW]
[ROW][C]100[/C][C]3.858[/C][C]4.24521052631579[/C][C]-0.38721052631579[/C][/ROW]
[ROW][C]101[/C][C]3.801[/C][C]2.9345[/C][C]0.8665[/C][/ROW]
[ROW][C]102[/C][C]3.504[/C][C]2.9345[/C][C]0.5695[/C][/ROW]
[ROW][C]103[/C][C]3.033[/C][C]2.9345[/C][C]0.0985[/C][/ROW]
[ROW][C]104[/C][C]3.047[/C][C]2.9345[/C][C]0.112500000000000[/C][/ROW]
[ROW][C]105[/C][C]2.962[/C][C]2.9345[/C][C]0.0275000000000003[/C][/ROW]
[ROW][C]106[/C][C]2.198[/C][C]2.236375[/C][C]-0.0383749999999998[/C][/ROW]
[ROW][C]107[/C][C]2.014[/C][C]2.236375[/C][C]-0.222375[/C][/ROW]
[ROW][C]108[/C][C]1.863[/C][C]1.976125[/C][C]-0.113125[/C][/ROW]
[ROW][C]109[/C][C]1.905[/C][C]1.976125[/C][C]-0.0711249999999999[/C][/ROW]
[ROW][C]110[/C][C]1.811[/C][C]1.976125[/C][C]-0.165125[/C][/ROW]
[ROW][C]111[/C][C]1.67[/C][C]1.976125[/C][C]-0.306125[/C][/ROW]
[ROW][C]112[/C][C]1.864[/C][C]1.976125[/C][C]-0.112125000000000[/C][/ROW]
[ROW][C]113[/C][C]2.052[/C][C]2.236375[/C][C]-0.184375000000000[/C][/ROW]
[ROW][C]114[/C][C]2.03[/C][C]2.236375[/C][C]-0.206375[/C][/ROW]
[ROW][C]115[/C][C]2.071[/C][C]2.236375[/C][C]-0.165375000000000[/C][/ROW]
[ROW][C]116[/C][C]2.293[/C][C]2.9345[/C][C]-0.6415[/C][/ROW]
[ROW][C]117[/C][C]2.443[/C][C]2.9345[/C][C]-0.4915[/C][/ROW]
[ROW][C]118[/C][C]2.513[/C][C]2.9345[/C][C]-0.4215[/C][/ROW]
[ROW][C]119[/C][C]2.467[/C][C]2.9345[/C][C]-0.4675[/C][/ROW]
[ROW][C]120[/C][C]2.503[/C][C]2.236375[/C][C]0.266625000000000[/C][/ROW]
[ROW][C]121[/C][C]2.54[/C][C]2.236375[/C][C]0.303625[/C][/ROW]
[ROW][C]122[/C][C]2.483[/C][C]2.236375[/C][C]0.246625000000000[/C][/ROW]
[ROW][C]123[/C][C]2.626[/C][C]2.9345[/C][C]-0.3085[/C][/ROW]
[ROW][C]124[/C][C]2.656[/C][C]2.77866666666667[/C][C]-0.122666666666667[/C][/ROW]
[ROW][C]125[/C][C]2.447[/C][C]2.9345[/C][C]-0.4875[/C][/ROW]
[ROW][C]126[/C][C]2.467[/C][C]2.9345[/C][C]-0.4675[/C][/ROW]
[ROW][C]127[/C][C]2.462[/C][C]2.77866666666667[/C][C]-0.316666666666667[/C][/ROW]
[ROW][C]128[/C][C]2.505[/C][C]2.77866666666667[/C][C]-0.273666666666667[/C][/ROW]
[ROW][C]129[/C][C]2.579[/C][C]2.77866666666667[/C][C]-0.199666666666667[/C][/ROW]
[ROW][C]130[/C][C]2.649[/C][C]2.77866666666667[/C][C]-0.129666666666667[/C][/ROW]
[ROW][C]131[/C][C]2.637[/C][C]2.77866666666667[/C][C]-0.141666666666667[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=114473&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=114473&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
13.032.744888888888890.285111111111111
22.8032.744888888888890.0581111111111108
32.7682.744888888888890.0231111111111106
42.8832.94794117647059-0.0649411764705885
52.8632.94794117647059-0.0849411764705885
62.8972.94794117647059-0.0509411764705887
73.0132.947941176470590.0650588235294114
83.1432.947941176470590.195058823529411
93.0332.947941176470590.0850588235294114
103.0462.947941176470590.0980588235294113
113.1112.947941176470590.163058823529412
123.0132.947941176470590.0650588235294114
132.9872.947941176470590.0390588235294116
142.9962.947941176470590.0480588235294115
152.8332.94794117647059-0.114941176470588
162.8492.94794117647059-0.0989411764705883
172.7952.94794117647059-0.152941176470589
182.8452.94794117647059-0.102941176470588
192.9152.94794117647059-0.0329411764705885
202.8932.94794117647059-0.0549411764705887
212.6042.306611111111110.297388888888888
222.6421.9761250.665875
232.661.9761250.683875
242.6392.306611111111110.332388888888888
252.722.306611111111110.413388888888889
262.7462.744888888888890.00111111111111084
272.7362.74488888888889-0.00888888888888895
282.8122.744888888888890.0671111111111107
292.7992.744888888888890.0541111111111108
302.5552.74488888888889-0.189888888888889
312.3052.30661111111111-0.00161111111111145
322.2152.30661111111111-0.0916111111111118
332.0662.30661111111111-0.240611111111112
341.942.30661111111111-0.366611111111112
352.0422.30661111111111-0.264611111111112
361.9952.30661111111111-0.311611111111112
371.9471.976125-0.0291249999999998
381.7661.976125-0.210125
391.6351.976125-0.341125
401.8331.976125-0.143125
411.911.976125-0.066125
421.961.976125-0.0161249999999999
431.971.976125-0.00612499999999994
442.0611.9761250.084875
452.0932.30661111111111-0.213611111111112
462.1211.9761250.144875
472.1752.30661111111111-0.131611111111112
482.1972.30661111111111-0.109611111111112
492.352.306611111111110.0433888888888885
502.442.306611111111110.133388888888888
512.4092.306611111111110.102388888888888
522.4732.306611111111110.166388888888888
532.4082.306611111111110.101388888888888
542.4552.74488888888889-0.289888888888889
552.4482.306611111111110.141388888888888
562.4982.81914285714286-0.321142857142857
572.6462.81914285714286-0.173142857142857
582.7572.81914285714286-0.0621428571428568
592.8492.819142857142860.0298571428571432
602.9212.819142857142860.101857142857143
612.9822.819142857142860.162857142857143
623.0812.819142857142860.261857142857143
633.1062.778666666666670.327333333333333
643.1192.778666666666670.340333333333333
653.0612.93450.1265
663.0972.93450.1625
673.1622.93450.2275
683.2572.93450.3225
693.2772.93450.3425
703.2952.778666666666670.516333333333333
713.3642.93450.4295
723.4943.7693-0.275300000000000
733.6673.7693-0.1023
743.8133.76930.0437000000000003
753.9183.76930.148700000000000
763.8963.76930.1267
773.8013.76930.0317000000000003
783.573.7693-0.1993
793.7023.7693-0.0672999999999999
803.8623.76930.0927000000000002
813.973.76930.200700000000000
824.1394.24521052631579-0.10621052631579
834.24.24521052631579-0.04521052631579
844.2914.245210526315790.0457894736842102
854.4444.245210526315790.198789473684210
864.5034.245210526315790.25778947368421
874.3574.245210526315790.11178947368421
884.5914.245210526315790.34578947368421
894.6974.245210526315790.45178947368421
904.6214.245210526315790.37578947368421
914.5634.245210526315790.317789473684210
924.2034.24521052631579-0.0422105263157899
934.2964.245210526315790.05078947368421
944.4354.245210526315790.189789473684209
954.1054.24521052631579-0.140210526315790
964.1174.24521052631579-0.128210526315790
973.8444.24521052631579-0.401210526315790
983.7214.24521052631579-0.52421052631579
993.6744.24521052631579-0.57121052631579
1003.8584.24521052631579-0.38721052631579
1013.8012.93450.8665
1023.5042.93450.5695
1033.0332.93450.0985
1043.0472.93450.112500000000000
1052.9622.93450.0275000000000003
1062.1982.236375-0.0383749999999998
1072.0142.236375-0.222375
1081.8631.976125-0.113125
1091.9051.976125-0.0711249999999999
1101.8111.976125-0.165125
1111.671.976125-0.306125
1121.8641.976125-0.112125000000000
1132.0522.236375-0.184375000000000
1142.032.236375-0.206375
1152.0712.236375-0.165375000000000
1162.2932.9345-0.6415
1172.4432.9345-0.4915
1182.5132.9345-0.4215
1192.4672.9345-0.4675
1202.5032.2363750.266625000000000
1212.542.2363750.303625
1222.4832.2363750.246625000000000
1232.6262.9345-0.3085
1242.6562.77866666666667-0.122666666666667
1252.4472.9345-0.4875
1262.4672.9345-0.4675
1272.4622.77866666666667-0.316666666666667
1282.5052.77866666666667-0.273666666666667
1292.5792.77866666666667-0.199666666666667
1302.6492.77866666666667-0.129666666666667
1312.6372.77866666666667-0.141666666666667



Parameters (Session):
par1 = 4 ; par2 = none ; par3 = 3 ; par4 = no ;
Parameters (R input):
par1 = 4 ; 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')
}