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, 21 Dec 2011 09:55:34 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2011/Dec/21/t1324479384rumiahh9sopbpvk.htm/, Retrieved Tue, 07 May 2024 11:11:27 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158789, Retrieved Tue, 07 May 2024 11:11:27 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact64
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [RP] [2011-12-21 14:55:34] [e8e105c2e7d07131df1852088351b05f] [Current]
Feedback Forum

Post a new message
Dataseries X:
1801	159261	91	48	67
1717	189672	59	53	56
192	7215	18	0	0
2295	129098	95	51	63
3450	230632	136	76	116
6861	515038	263	136	138
1795	180745	56	62	71
1681	185559	59	83	107
1897	154581	44	55	50
2974	298001	96	67	79
1946	121844	75	50	58
2330	200907	70	87	91
1839	101647	100	46	41
3183	220269	119	79	100
1486	170952	61	56	61
1567	154647	88	54	74
1756	142018	57	81	131
1247	79030	61	6	45
2779	167047	87	74	110
726	27997	24	13	41
1048	73019	59	22	37
2805	241082	100	99	84
1760	195820	72	38	67
2266	142001	54	59	69
1848	145433	86	50	58
1665	183744	32	50	60
2114	206521	164	63	88
1448	201385	94	90	75
2741	354924	118	60	98
2112	192399	44	52	67
1684	182286	44	61	84
1616	181590	45	60	62
2227	133801	105	53	35
3088	233686	123	76	74
2389	219428	53	63	89
1	0	1	0	0
2099	223044	63	54	79
1669	100129	51	44	39
2137	145864	49	42	101
2153	249965	64	83	135
2390	242379	71	105	76
1701	145794	59	37	118
1049	103623	33	25	76
2161	195891	78	64	65
1276	117156	50	55	97
1190	157787	95	41	67
745	81293	32	23	63
2374	243273	103	77	96
2289	233155	89	59	112
2639	160344	59	68	75
658	48188	28	12	39
1917	161922	69	99	63
2557	307432	74	78	93
2026	235223	79	56	76
1911	195583	59	67	117
1716	146061	56	40	30
1852	208834	67	53	65
981	93764	24	26	78
1177	151985	66	67	87
2849	195506	97	36	85
1688	148922	60	50	115
2162	142670	81	51	62
1331	129561	61	46	60
1307	122204	38	57	67
1256	160930	35	27	90
1294	99184	41	38	100
2311	192811	71	72	135
2897	138708	65	93	71
1103	114408	38	59	75
340	31970	15	5	42
2791	225558	112	53	42
1338	139220	72	40	8
1441	113612	68	72	86
1681	119537	72	53	41
2650	162203	67	81	118
1499	100098	44	27	91
2302	174768	60	94	102
2540	158459	97	71	89
1000	80934	30	20	46
1234	84971	71	34	60
927	80545	68	54	69
2176	287191	64	49	95
957	62974	28	26	17
1551	134091	40	48	61
1014	75555	46	35	55
1772	162154	55	32	55
2630	227638	229	55	124
1205	115367	112	58	73
1392	115603	63	44	73
1524	155537	52	45	67
1829	153133	41	49	66
2229	165618	78	72	75
1233	151517	57	39	83
1365	133686	58	28	55
950	61342	40	24	27
2319	245196	117	52	115
1857	195576	70	96	76
223	19349	12	13	0
2390	225371	105	38	83
1985	153213	78	41	90
700	59117	29	24	4
1062	91762	24	54	60
1311	136769	54	68	63
1157	114798	61	28	52
823	85338	40	36	24
596	27676	22	2	17
1545	153535	48	91	105
1130	122417	37	29	20
0	0	0	0	0
1082	91529	32	46	51
1135	107205	67	25	76
1367	144664	45	51	59
1506	146445	63	60	70
870	76656	60	36	38
78	3616	5	0	0
0	0	0	0	0
1130	183088	44	40	81
1582	144677	84	68	78
2034	159104	98	28	73
970	128944	39	41	89
778	43410	19	7	3
1752	175774	73	70	87
957	95401	42	30	51
2098	134837	55	69	73
731	60493	40	3	32
285	19764	12	10	4
1834	164062	56	46	70
1148	132696	33	34	102
1646	155367	54	54	91
256	11796	9	1	1
98	10674	9	0	0
1404	142261	57	39	39
41	6836	3	0	0
1824	162563	63	48	45
42	5118	3	5	0
528	40248	16	8	7
0	0	0	0	0
1073	122641	47	38	75
1305	88837	38	21	52
81	7131	4	0	0
261	9056	14	0	1
934	76611	24	15	49
1180	132697	51	50	69
1148	100681	20	17	56




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net

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

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

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

As an alternative you can also use a QR Code:  

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

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net







Goodness of Fit
Correlation0.8173
R-squared0.668
RMSE19.4451

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8173[/C][/ROW]
[ROW][C]R-squared[/C][C]0.668[/C][/ROW]
[ROW][C]RMSE[/C][C]19.4451[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158789&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158789&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.8173
R-squared0.668
RMSE19.4451







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
16775.4473684210526-8.44736842105263
25675.4473684210526-19.4473684210526
303.41176470588235-3.41176470588235
46362.39215686274510.607843137254903
511696.119.9
613896.141.9
77175.4473684210526-4.44736842105263
810775.447368421052631.5526315789474
95075.4473684210526-25.4473684210526
107996.1-17.1
115862.3921568627451-4.3921568627451
129196.1-5.09999999999999
134162.3921568627451-21.3921568627451
1410096.13.90000000000001
156175.4473684210526-14.4473684210526
167475.4473684210526-1.44736842105263
1713162.392156862745168.6078431372549
184562.3921568627451-17.3921568627451
1911096.113.9
204126.7514.25
213726.7510.25
228496.1-12.1
236775.4473684210526-8.44736842105263
246962.39215686274516.6078431372549
255862.3921568627451-4.3921568627451
266075.4473684210526-15.4473684210526
278896.1-8.09999999999999
287575.4473684210526-0.44736842105263
299896.11.90000000000001
306775.4473684210526-8.44736842105263
318475.44736842105268.55263157894737
326275.4473684210526-13.4473684210526
333562.3921568627451-27.3921568627451
347496.1-22.1
358996.1-7.09999999999999
3603.41176470588235-3.41176470588235
377975.44736842105263.55263157894737
383962.3921568627451-23.3921568627451
3910196.14.90000000000001
4013596.138.9
417696.1-20.1
4211875.447368421052642.5526315789474
437662.392156862745113.6078431372549
446596.1-31.1
459762.392156862745134.6078431372549
466775.4473684210526-8.44736842105263
476362.39215686274510.607843137254903
489696.1-0.0999999999999943
4911296.115.9
507596.1-21.1
513926.7512.25
526375.4473684210526-12.4473684210526
539396.1-3.09999999999999
547675.44736842105260.55263157894737
5511775.447368421052641.5526315789474
563075.4473684210526-45.4473684210526
576575.4473684210526-10.4473684210526
587862.392156862745115.6078431372549
598775.447368421052611.5526315789474
608596.1-11.1
6111575.447368421052639.5526315789474
626262.3921568627451-0.392156862745097
636062.3921568627451-2.3921568627451
646762.39215686274514.6078431372549
659075.447368421052614.5526315789474
6610062.392156862745137.6078431372549
6713596.138.9
687162.39215686274518.6078431372549
697562.392156862745112.6078431372549
70423.4117647058823538.5882352941176
714296.1-54.1
72862.3921568627451-54.3921568627451
738662.392156862745123.6078431372549
744162.3921568627451-21.3921568627451
7511896.121.9
769162.392156862745128.6078431372549
7710296.15.90000000000001
788996.1-7.09999999999999
794662.3921568627451-16.3921568627451
806062.3921568627451-2.3921568627451
816962.39215686274516.6078431372549
829596.1-1.09999999999999
831726.75-9.75
846162.3921568627451-1.3921568627451
855562.3921568627451-7.3921568627451
865575.4473684210526-20.4473684210526
8712496.127.9
887362.392156862745110.6078431372549
897362.392156862745110.6078431372549
906775.4473684210526-8.44736842105263
916675.4473684210526-9.44736842105263
927596.1-21.1
938375.44736842105267.55263157894737
945562.3921568627451-7.3921568627451
952726.750.25
9611596.118.9
977675.44736842105260.55263157894737
9803.41176470588235-3.41176470588235
998396.1-13.1
1009075.447368421052614.5526315789474
101426.75-22.75
1026062.3921568627451-2.3921568627451
1036362.39215686274510.607843137254903
1045262.3921568627451-10.3921568627451
1052462.3921568627451-38.3921568627451
1061726.75-9.75
10710575.447368421052629.5526315789474
1082062.3921568627451-42.3921568627451
10903.41176470588235-3.41176470588235
1105162.3921568627451-11.3921568627451
1117662.392156862745113.6078431372549
1125962.3921568627451-3.3921568627451
1137075.4473684210526-5.44736842105263
1143862.3921568627451-24.3921568627451
11503.41176470588235-3.41176470588235
11603.41176470588235-3.41176470588235
1178175.44736842105265.55263157894737
1187862.392156862745115.6078431372549
1197375.4473684210526-2.44736842105263
1208962.392156862745126.6078431372549
12133.41176470588235-0.411764705882353
1228775.447368421052611.5526315789474
1235162.3921568627451-11.3921568627451
1247362.392156862745110.6078431372549
1253226.755.25
12643.411764705882350.588235294117647
1277075.4473684210526-5.44736842105263
12810262.392156862745139.6078431372549
1299175.447368421052615.5526315789474
13013.41176470588235-2.41176470588235
13103.41176470588235-3.41176470588235
1323962.3921568627451-23.3921568627451
13303.41176470588235-3.41176470588235
1344575.4473684210526-30.4473684210526
13503.41176470588235-3.41176470588235
13673.411764705882353.58823529411765
13703.41176470588235-3.41176470588235
1387562.392156862745112.6078431372549
1395262.3921568627451-10.3921568627451
14003.41176470588235-3.41176470588235
14113.41176470588235-2.41176470588235
1424962.3921568627451-13.3921568627451
1436962.39215686274516.6078431372549
1445662.3921568627451-6.3921568627451

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 67 & 75.4473684210526 & -8.44736842105263 \tabularnewline
2 & 56 & 75.4473684210526 & -19.4473684210526 \tabularnewline
3 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
4 & 63 & 62.3921568627451 & 0.607843137254903 \tabularnewline
5 & 116 & 96.1 & 19.9 \tabularnewline
6 & 138 & 96.1 & 41.9 \tabularnewline
7 & 71 & 75.4473684210526 & -4.44736842105263 \tabularnewline
8 & 107 & 75.4473684210526 & 31.5526315789474 \tabularnewline
9 & 50 & 75.4473684210526 & -25.4473684210526 \tabularnewline
10 & 79 & 96.1 & -17.1 \tabularnewline
11 & 58 & 62.3921568627451 & -4.3921568627451 \tabularnewline
12 & 91 & 96.1 & -5.09999999999999 \tabularnewline
13 & 41 & 62.3921568627451 & -21.3921568627451 \tabularnewline
14 & 100 & 96.1 & 3.90000000000001 \tabularnewline
15 & 61 & 75.4473684210526 & -14.4473684210526 \tabularnewline
16 & 74 & 75.4473684210526 & -1.44736842105263 \tabularnewline
17 & 131 & 62.3921568627451 & 68.6078431372549 \tabularnewline
18 & 45 & 62.3921568627451 & -17.3921568627451 \tabularnewline
19 & 110 & 96.1 & 13.9 \tabularnewline
20 & 41 & 26.75 & 14.25 \tabularnewline
21 & 37 & 26.75 & 10.25 \tabularnewline
22 & 84 & 96.1 & -12.1 \tabularnewline
23 & 67 & 75.4473684210526 & -8.44736842105263 \tabularnewline
24 & 69 & 62.3921568627451 & 6.6078431372549 \tabularnewline
25 & 58 & 62.3921568627451 & -4.3921568627451 \tabularnewline
26 & 60 & 75.4473684210526 & -15.4473684210526 \tabularnewline
27 & 88 & 96.1 & -8.09999999999999 \tabularnewline
28 & 75 & 75.4473684210526 & -0.44736842105263 \tabularnewline
29 & 98 & 96.1 & 1.90000000000001 \tabularnewline
30 & 67 & 75.4473684210526 & -8.44736842105263 \tabularnewline
31 & 84 & 75.4473684210526 & 8.55263157894737 \tabularnewline
32 & 62 & 75.4473684210526 & -13.4473684210526 \tabularnewline
33 & 35 & 62.3921568627451 & -27.3921568627451 \tabularnewline
34 & 74 & 96.1 & -22.1 \tabularnewline
35 & 89 & 96.1 & -7.09999999999999 \tabularnewline
36 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
37 & 79 & 75.4473684210526 & 3.55263157894737 \tabularnewline
38 & 39 & 62.3921568627451 & -23.3921568627451 \tabularnewline
39 & 101 & 96.1 & 4.90000000000001 \tabularnewline
40 & 135 & 96.1 & 38.9 \tabularnewline
41 & 76 & 96.1 & -20.1 \tabularnewline
42 & 118 & 75.4473684210526 & 42.5526315789474 \tabularnewline
43 & 76 & 62.3921568627451 & 13.6078431372549 \tabularnewline
44 & 65 & 96.1 & -31.1 \tabularnewline
45 & 97 & 62.3921568627451 & 34.6078431372549 \tabularnewline
46 & 67 & 75.4473684210526 & -8.44736842105263 \tabularnewline
47 & 63 & 62.3921568627451 & 0.607843137254903 \tabularnewline
48 & 96 & 96.1 & -0.0999999999999943 \tabularnewline
49 & 112 & 96.1 & 15.9 \tabularnewline
50 & 75 & 96.1 & -21.1 \tabularnewline
51 & 39 & 26.75 & 12.25 \tabularnewline
52 & 63 & 75.4473684210526 & -12.4473684210526 \tabularnewline
53 & 93 & 96.1 & -3.09999999999999 \tabularnewline
54 & 76 & 75.4473684210526 & 0.55263157894737 \tabularnewline
55 & 117 & 75.4473684210526 & 41.5526315789474 \tabularnewline
56 & 30 & 75.4473684210526 & -45.4473684210526 \tabularnewline
57 & 65 & 75.4473684210526 & -10.4473684210526 \tabularnewline
58 & 78 & 62.3921568627451 & 15.6078431372549 \tabularnewline
59 & 87 & 75.4473684210526 & 11.5526315789474 \tabularnewline
60 & 85 & 96.1 & -11.1 \tabularnewline
61 & 115 & 75.4473684210526 & 39.5526315789474 \tabularnewline
62 & 62 & 62.3921568627451 & -0.392156862745097 \tabularnewline
63 & 60 & 62.3921568627451 & -2.3921568627451 \tabularnewline
64 & 67 & 62.3921568627451 & 4.6078431372549 \tabularnewline
65 & 90 & 75.4473684210526 & 14.5526315789474 \tabularnewline
66 & 100 & 62.3921568627451 & 37.6078431372549 \tabularnewline
67 & 135 & 96.1 & 38.9 \tabularnewline
68 & 71 & 62.3921568627451 & 8.6078431372549 \tabularnewline
69 & 75 & 62.3921568627451 & 12.6078431372549 \tabularnewline
70 & 42 & 3.41176470588235 & 38.5882352941176 \tabularnewline
71 & 42 & 96.1 & -54.1 \tabularnewline
72 & 8 & 62.3921568627451 & -54.3921568627451 \tabularnewline
73 & 86 & 62.3921568627451 & 23.6078431372549 \tabularnewline
74 & 41 & 62.3921568627451 & -21.3921568627451 \tabularnewline
75 & 118 & 96.1 & 21.9 \tabularnewline
76 & 91 & 62.3921568627451 & 28.6078431372549 \tabularnewline
77 & 102 & 96.1 & 5.90000000000001 \tabularnewline
78 & 89 & 96.1 & -7.09999999999999 \tabularnewline
79 & 46 & 62.3921568627451 & -16.3921568627451 \tabularnewline
80 & 60 & 62.3921568627451 & -2.3921568627451 \tabularnewline
81 & 69 & 62.3921568627451 & 6.6078431372549 \tabularnewline
82 & 95 & 96.1 & -1.09999999999999 \tabularnewline
83 & 17 & 26.75 & -9.75 \tabularnewline
84 & 61 & 62.3921568627451 & -1.3921568627451 \tabularnewline
85 & 55 & 62.3921568627451 & -7.3921568627451 \tabularnewline
86 & 55 & 75.4473684210526 & -20.4473684210526 \tabularnewline
87 & 124 & 96.1 & 27.9 \tabularnewline
88 & 73 & 62.3921568627451 & 10.6078431372549 \tabularnewline
89 & 73 & 62.3921568627451 & 10.6078431372549 \tabularnewline
90 & 67 & 75.4473684210526 & -8.44736842105263 \tabularnewline
91 & 66 & 75.4473684210526 & -9.44736842105263 \tabularnewline
92 & 75 & 96.1 & -21.1 \tabularnewline
93 & 83 & 75.4473684210526 & 7.55263157894737 \tabularnewline
94 & 55 & 62.3921568627451 & -7.3921568627451 \tabularnewline
95 & 27 & 26.75 & 0.25 \tabularnewline
96 & 115 & 96.1 & 18.9 \tabularnewline
97 & 76 & 75.4473684210526 & 0.55263157894737 \tabularnewline
98 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
99 & 83 & 96.1 & -13.1 \tabularnewline
100 & 90 & 75.4473684210526 & 14.5526315789474 \tabularnewline
101 & 4 & 26.75 & -22.75 \tabularnewline
102 & 60 & 62.3921568627451 & -2.3921568627451 \tabularnewline
103 & 63 & 62.3921568627451 & 0.607843137254903 \tabularnewline
104 & 52 & 62.3921568627451 & -10.3921568627451 \tabularnewline
105 & 24 & 62.3921568627451 & -38.3921568627451 \tabularnewline
106 & 17 & 26.75 & -9.75 \tabularnewline
107 & 105 & 75.4473684210526 & 29.5526315789474 \tabularnewline
108 & 20 & 62.3921568627451 & -42.3921568627451 \tabularnewline
109 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
110 & 51 & 62.3921568627451 & -11.3921568627451 \tabularnewline
111 & 76 & 62.3921568627451 & 13.6078431372549 \tabularnewline
112 & 59 & 62.3921568627451 & -3.3921568627451 \tabularnewline
113 & 70 & 75.4473684210526 & -5.44736842105263 \tabularnewline
114 & 38 & 62.3921568627451 & -24.3921568627451 \tabularnewline
115 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
116 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
117 & 81 & 75.4473684210526 & 5.55263157894737 \tabularnewline
118 & 78 & 62.3921568627451 & 15.6078431372549 \tabularnewline
119 & 73 & 75.4473684210526 & -2.44736842105263 \tabularnewline
120 & 89 & 62.3921568627451 & 26.6078431372549 \tabularnewline
121 & 3 & 3.41176470588235 & -0.411764705882353 \tabularnewline
122 & 87 & 75.4473684210526 & 11.5526315789474 \tabularnewline
123 & 51 & 62.3921568627451 & -11.3921568627451 \tabularnewline
124 & 73 & 62.3921568627451 & 10.6078431372549 \tabularnewline
125 & 32 & 26.75 & 5.25 \tabularnewline
126 & 4 & 3.41176470588235 & 0.588235294117647 \tabularnewline
127 & 70 & 75.4473684210526 & -5.44736842105263 \tabularnewline
128 & 102 & 62.3921568627451 & 39.6078431372549 \tabularnewline
129 & 91 & 75.4473684210526 & 15.5526315789474 \tabularnewline
130 & 1 & 3.41176470588235 & -2.41176470588235 \tabularnewline
131 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
132 & 39 & 62.3921568627451 & -23.3921568627451 \tabularnewline
133 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
134 & 45 & 75.4473684210526 & -30.4473684210526 \tabularnewline
135 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
136 & 7 & 3.41176470588235 & 3.58823529411765 \tabularnewline
137 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
138 & 75 & 62.3921568627451 & 12.6078431372549 \tabularnewline
139 & 52 & 62.3921568627451 & -10.3921568627451 \tabularnewline
140 & 0 & 3.41176470588235 & -3.41176470588235 \tabularnewline
141 & 1 & 3.41176470588235 & -2.41176470588235 \tabularnewline
142 & 49 & 62.3921568627451 & -13.3921568627451 \tabularnewline
143 & 69 & 62.3921568627451 & 6.6078431372549 \tabularnewline
144 & 56 & 62.3921568627451 & -6.3921568627451 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158789&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]67[/C][C]75.4473684210526[/C][C]-8.44736842105263[/C][/ROW]
[ROW][C]2[/C][C]56[/C][C]75.4473684210526[/C][C]-19.4473684210526[/C][/ROW]
[ROW][C]3[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]4[/C][C]63[/C][C]62.3921568627451[/C][C]0.607843137254903[/C][/ROW]
[ROW][C]5[/C][C]116[/C][C]96.1[/C][C]19.9[/C][/ROW]
[ROW][C]6[/C][C]138[/C][C]96.1[/C][C]41.9[/C][/ROW]
[ROW][C]7[/C][C]71[/C][C]75.4473684210526[/C][C]-4.44736842105263[/C][/ROW]
[ROW][C]8[/C][C]107[/C][C]75.4473684210526[/C][C]31.5526315789474[/C][/ROW]
[ROW][C]9[/C][C]50[/C][C]75.4473684210526[/C][C]-25.4473684210526[/C][/ROW]
[ROW][C]10[/C][C]79[/C][C]96.1[/C][C]-17.1[/C][/ROW]
[ROW][C]11[/C][C]58[/C][C]62.3921568627451[/C][C]-4.3921568627451[/C][/ROW]
[ROW][C]12[/C][C]91[/C][C]96.1[/C][C]-5.09999999999999[/C][/ROW]
[ROW][C]13[/C][C]41[/C][C]62.3921568627451[/C][C]-21.3921568627451[/C][/ROW]
[ROW][C]14[/C][C]100[/C][C]96.1[/C][C]3.90000000000001[/C][/ROW]
[ROW][C]15[/C][C]61[/C][C]75.4473684210526[/C][C]-14.4473684210526[/C][/ROW]
[ROW][C]16[/C][C]74[/C][C]75.4473684210526[/C][C]-1.44736842105263[/C][/ROW]
[ROW][C]17[/C][C]131[/C][C]62.3921568627451[/C][C]68.6078431372549[/C][/ROW]
[ROW][C]18[/C][C]45[/C][C]62.3921568627451[/C][C]-17.3921568627451[/C][/ROW]
[ROW][C]19[/C][C]110[/C][C]96.1[/C][C]13.9[/C][/ROW]
[ROW][C]20[/C][C]41[/C][C]26.75[/C][C]14.25[/C][/ROW]
[ROW][C]21[/C][C]37[/C][C]26.75[/C][C]10.25[/C][/ROW]
[ROW][C]22[/C][C]84[/C][C]96.1[/C][C]-12.1[/C][/ROW]
[ROW][C]23[/C][C]67[/C][C]75.4473684210526[/C][C]-8.44736842105263[/C][/ROW]
[ROW][C]24[/C][C]69[/C][C]62.3921568627451[/C][C]6.6078431372549[/C][/ROW]
[ROW][C]25[/C][C]58[/C][C]62.3921568627451[/C][C]-4.3921568627451[/C][/ROW]
[ROW][C]26[/C][C]60[/C][C]75.4473684210526[/C][C]-15.4473684210526[/C][/ROW]
[ROW][C]27[/C][C]88[/C][C]96.1[/C][C]-8.09999999999999[/C][/ROW]
[ROW][C]28[/C][C]75[/C][C]75.4473684210526[/C][C]-0.44736842105263[/C][/ROW]
[ROW][C]29[/C][C]98[/C][C]96.1[/C][C]1.90000000000001[/C][/ROW]
[ROW][C]30[/C][C]67[/C][C]75.4473684210526[/C][C]-8.44736842105263[/C][/ROW]
[ROW][C]31[/C][C]84[/C][C]75.4473684210526[/C][C]8.55263157894737[/C][/ROW]
[ROW][C]32[/C][C]62[/C][C]75.4473684210526[/C][C]-13.4473684210526[/C][/ROW]
[ROW][C]33[/C][C]35[/C][C]62.3921568627451[/C][C]-27.3921568627451[/C][/ROW]
[ROW][C]34[/C][C]74[/C][C]96.1[/C][C]-22.1[/C][/ROW]
[ROW][C]35[/C][C]89[/C][C]96.1[/C][C]-7.09999999999999[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]37[/C][C]79[/C][C]75.4473684210526[/C][C]3.55263157894737[/C][/ROW]
[ROW][C]38[/C][C]39[/C][C]62.3921568627451[/C][C]-23.3921568627451[/C][/ROW]
[ROW][C]39[/C][C]101[/C][C]96.1[/C][C]4.90000000000001[/C][/ROW]
[ROW][C]40[/C][C]135[/C][C]96.1[/C][C]38.9[/C][/ROW]
[ROW][C]41[/C][C]76[/C][C]96.1[/C][C]-20.1[/C][/ROW]
[ROW][C]42[/C][C]118[/C][C]75.4473684210526[/C][C]42.5526315789474[/C][/ROW]
[ROW][C]43[/C][C]76[/C][C]62.3921568627451[/C][C]13.6078431372549[/C][/ROW]
[ROW][C]44[/C][C]65[/C][C]96.1[/C][C]-31.1[/C][/ROW]
[ROW][C]45[/C][C]97[/C][C]62.3921568627451[/C][C]34.6078431372549[/C][/ROW]
[ROW][C]46[/C][C]67[/C][C]75.4473684210526[/C][C]-8.44736842105263[/C][/ROW]
[ROW][C]47[/C][C]63[/C][C]62.3921568627451[/C][C]0.607843137254903[/C][/ROW]
[ROW][C]48[/C][C]96[/C][C]96.1[/C][C]-0.0999999999999943[/C][/ROW]
[ROW][C]49[/C][C]112[/C][C]96.1[/C][C]15.9[/C][/ROW]
[ROW][C]50[/C][C]75[/C][C]96.1[/C][C]-21.1[/C][/ROW]
[ROW][C]51[/C][C]39[/C][C]26.75[/C][C]12.25[/C][/ROW]
[ROW][C]52[/C][C]63[/C][C]75.4473684210526[/C][C]-12.4473684210526[/C][/ROW]
[ROW][C]53[/C][C]93[/C][C]96.1[/C][C]-3.09999999999999[/C][/ROW]
[ROW][C]54[/C][C]76[/C][C]75.4473684210526[/C][C]0.55263157894737[/C][/ROW]
[ROW][C]55[/C][C]117[/C][C]75.4473684210526[/C][C]41.5526315789474[/C][/ROW]
[ROW][C]56[/C][C]30[/C][C]75.4473684210526[/C][C]-45.4473684210526[/C][/ROW]
[ROW][C]57[/C][C]65[/C][C]75.4473684210526[/C][C]-10.4473684210526[/C][/ROW]
[ROW][C]58[/C][C]78[/C][C]62.3921568627451[/C][C]15.6078431372549[/C][/ROW]
[ROW][C]59[/C][C]87[/C][C]75.4473684210526[/C][C]11.5526315789474[/C][/ROW]
[ROW][C]60[/C][C]85[/C][C]96.1[/C][C]-11.1[/C][/ROW]
[ROW][C]61[/C][C]115[/C][C]75.4473684210526[/C][C]39.5526315789474[/C][/ROW]
[ROW][C]62[/C][C]62[/C][C]62.3921568627451[/C][C]-0.392156862745097[/C][/ROW]
[ROW][C]63[/C][C]60[/C][C]62.3921568627451[/C][C]-2.3921568627451[/C][/ROW]
[ROW][C]64[/C][C]67[/C][C]62.3921568627451[/C][C]4.6078431372549[/C][/ROW]
[ROW][C]65[/C][C]90[/C][C]75.4473684210526[/C][C]14.5526315789474[/C][/ROW]
[ROW][C]66[/C][C]100[/C][C]62.3921568627451[/C][C]37.6078431372549[/C][/ROW]
[ROW][C]67[/C][C]135[/C][C]96.1[/C][C]38.9[/C][/ROW]
[ROW][C]68[/C][C]71[/C][C]62.3921568627451[/C][C]8.6078431372549[/C][/ROW]
[ROW][C]69[/C][C]75[/C][C]62.3921568627451[/C][C]12.6078431372549[/C][/ROW]
[ROW][C]70[/C][C]42[/C][C]3.41176470588235[/C][C]38.5882352941176[/C][/ROW]
[ROW][C]71[/C][C]42[/C][C]96.1[/C][C]-54.1[/C][/ROW]
[ROW][C]72[/C][C]8[/C][C]62.3921568627451[/C][C]-54.3921568627451[/C][/ROW]
[ROW][C]73[/C][C]86[/C][C]62.3921568627451[/C][C]23.6078431372549[/C][/ROW]
[ROW][C]74[/C][C]41[/C][C]62.3921568627451[/C][C]-21.3921568627451[/C][/ROW]
[ROW][C]75[/C][C]118[/C][C]96.1[/C][C]21.9[/C][/ROW]
[ROW][C]76[/C][C]91[/C][C]62.3921568627451[/C][C]28.6078431372549[/C][/ROW]
[ROW][C]77[/C][C]102[/C][C]96.1[/C][C]5.90000000000001[/C][/ROW]
[ROW][C]78[/C][C]89[/C][C]96.1[/C][C]-7.09999999999999[/C][/ROW]
[ROW][C]79[/C][C]46[/C][C]62.3921568627451[/C][C]-16.3921568627451[/C][/ROW]
[ROW][C]80[/C][C]60[/C][C]62.3921568627451[/C][C]-2.3921568627451[/C][/ROW]
[ROW][C]81[/C][C]69[/C][C]62.3921568627451[/C][C]6.6078431372549[/C][/ROW]
[ROW][C]82[/C][C]95[/C][C]96.1[/C][C]-1.09999999999999[/C][/ROW]
[ROW][C]83[/C][C]17[/C][C]26.75[/C][C]-9.75[/C][/ROW]
[ROW][C]84[/C][C]61[/C][C]62.3921568627451[/C][C]-1.3921568627451[/C][/ROW]
[ROW][C]85[/C][C]55[/C][C]62.3921568627451[/C][C]-7.3921568627451[/C][/ROW]
[ROW][C]86[/C][C]55[/C][C]75.4473684210526[/C][C]-20.4473684210526[/C][/ROW]
[ROW][C]87[/C][C]124[/C][C]96.1[/C][C]27.9[/C][/ROW]
[ROW][C]88[/C][C]73[/C][C]62.3921568627451[/C][C]10.6078431372549[/C][/ROW]
[ROW][C]89[/C][C]73[/C][C]62.3921568627451[/C][C]10.6078431372549[/C][/ROW]
[ROW][C]90[/C][C]67[/C][C]75.4473684210526[/C][C]-8.44736842105263[/C][/ROW]
[ROW][C]91[/C][C]66[/C][C]75.4473684210526[/C][C]-9.44736842105263[/C][/ROW]
[ROW][C]92[/C][C]75[/C][C]96.1[/C][C]-21.1[/C][/ROW]
[ROW][C]93[/C][C]83[/C][C]75.4473684210526[/C][C]7.55263157894737[/C][/ROW]
[ROW][C]94[/C][C]55[/C][C]62.3921568627451[/C][C]-7.3921568627451[/C][/ROW]
[ROW][C]95[/C][C]27[/C][C]26.75[/C][C]0.25[/C][/ROW]
[ROW][C]96[/C][C]115[/C][C]96.1[/C][C]18.9[/C][/ROW]
[ROW][C]97[/C][C]76[/C][C]75.4473684210526[/C][C]0.55263157894737[/C][/ROW]
[ROW][C]98[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]99[/C][C]83[/C][C]96.1[/C][C]-13.1[/C][/ROW]
[ROW][C]100[/C][C]90[/C][C]75.4473684210526[/C][C]14.5526315789474[/C][/ROW]
[ROW][C]101[/C][C]4[/C][C]26.75[/C][C]-22.75[/C][/ROW]
[ROW][C]102[/C][C]60[/C][C]62.3921568627451[/C][C]-2.3921568627451[/C][/ROW]
[ROW][C]103[/C][C]63[/C][C]62.3921568627451[/C][C]0.607843137254903[/C][/ROW]
[ROW][C]104[/C][C]52[/C][C]62.3921568627451[/C][C]-10.3921568627451[/C][/ROW]
[ROW][C]105[/C][C]24[/C][C]62.3921568627451[/C][C]-38.3921568627451[/C][/ROW]
[ROW][C]106[/C][C]17[/C][C]26.75[/C][C]-9.75[/C][/ROW]
[ROW][C]107[/C][C]105[/C][C]75.4473684210526[/C][C]29.5526315789474[/C][/ROW]
[ROW][C]108[/C][C]20[/C][C]62.3921568627451[/C][C]-42.3921568627451[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]110[/C][C]51[/C][C]62.3921568627451[/C][C]-11.3921568627451[/C][/ROW]
[ROW][C]111[/C][C]76[/C][C]62.3921568627451[/C][C]13.6078431372549[/C][/ROW]
[ROW][C]112[/C][C]59[/C][C]62.3921568627451[/C][C]-3.3921568627451[/C][/ROW]
[ROW][C]113[/C][C]70[/C][C]75.4473684210526[/C][C]-5.44736842105263[/C][/ROW]
[ROW][C]114[/C][C]38[/C][C]62.3921568627451[/C][C]-24.3921568627451[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]117[/C][C]81[/C][C]75.4473684210526[/C][C]5.55263157894737[/C][/ROW]
[ROW][C]118[/C][C]78[/C][C]62.3921568627451[/C][C]15.6078431372549[/C][/ROW]
[ROW][C]119[/C][C]73[/C][C]75.4473684210526[/C][C]-2.44736842105263[/C][/ROW]
[ROW][C]120[/C][C]89[/C][C]62.3921568627451[/C][C]26.6078431372549[/C][/ROW]
[ROW][C]121[/C][C]3[/C][C]3.41176470588235[/C][C]-0.411764705882353[/C][/ROW]
[ROW][C]122[/C][C]87[/C][C]75.4473684210526[/C][C]11.5526315789474[/C][/ROW]
[ROW][C]123[/C][C]51[/C][C]62.3921568627451[/C][C]-11.3921568627451[/C][/ROW]
[ROW][C]124[/C][C]73[/C][C]62.3921568627451[/C][C]10.6078431372549[/C][/ROW]
[ROW][C]125[/C][C]32[/C][C]26.75[/C][C]5.25[/C][/ROW]
[ROW][C]126[/C][C]4[/C][C]3.41176470588235[/C][C]0.588235294117647[/C][/ROW]
[ROW][C]127[/C][C]70[/C][C]75.4473684210526[/C][C]-5.44736842105263[/C][/ROW]
[ROW][C]128[/C][C]102[/C][C]62.3921568627451[/C][C]39.6078431372549[/C][/ROW]
[ROW][C]129[/C][C]91[/C][C]75.4473684210526[/C][C]15.5526315789474[/C][/ROW]
[ROW][C]130[/C][C]1[/C][C]3.41176470588235[/C][C]-2.41176470588235[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]132[/C][C]39[/C][C]62.3921568627451[/C][C]-23.3921568627451[/C][/ROW]
[ROW][C]133[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]134[/C][C]45[/C][C]75.4473684210526[/C][C]-30.4473684210526[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]136[/C][C]7[/C][C]3.41176470588235[/C][C]3.58823529411765[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]138[/C][C]75[/C][C]62.3921568627451[/C][C]12.6078431372549[/C][/ROW]
[ROW][C]139[/C][C]52[/C][C]62.3921568627451[/C][C]-10.3921568627451[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]3.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]141[/C][C]1[/C][C]3.41176470588235[/C][C]-2.41176470588235[/C][/ROW]
[ROW][C]142[/C][C]49[/C][C]62.3921568627451[/C][C]-13.3921568627451[/C][/ROW]
[ROW][C]143[/C][C]69[/C][C]62.3921568627451[/C][C]6.6078431372549[/C][/ROW]
[ROW][C]144[/C][C]56[/C][C]62.3921568627451[/C][C]-6.3921568627451[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158789&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158789&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
16775.4473684210526-8.44736842105263
25675.4473684210526-19.4473684210526
303.41176470588235-3.41176470588235
46362.39215686274510.607843137254903
511696.119.9
613896.141.9
77175.4473684210526-4.44736842105263
810775.447368421052631.5526315789474
95075.4473684210526-25.4473684210526
107996.1-17.1
115862.3921568627451-4.3921568627451
129196.1-5.09999999999999
134162.3921568627451-21.3921568627451
1410096.13.90000000000001
156175.4473684210526-14.4473684210526
167475.4473684210526-1.44736842105263
1713162.392156862745168.6078431372549
184562.3921568627451-17.3921568627451
1911096.113.9
204126.7514.25
213726.7510.25
228496.1-12.1
236775.4473684210526-8.44736842105263
246962.39215686274516.6078431372549
255862.3921568627451-4.3921568627451
266075.4473684210526-15.4473684210526
278896.1-8.09999999999999
287575.4473684210526-0.44736842105263
299896.11.90000000000001
306775.4473684210526-8.44736842105263
318475.44736842105268.55263157894737
326275.4473684210526-13.4473684210526
333562.3921568627451-27.3921568627451
347496.1-22.1
358996.1-7.09999999999999
3603.41176470588235-3.41176470588235
377975.44736842105263.55263157894737
383962.3921568627451-23.3921568627451
3910196.14.90000000000001
4013596.138.9
417696.1-20.1
4211875.447368421052642.5526315789474
437662.392156862745113.6078431372549
446596.1-31.1
459762.392156862745134.6078431372549
466775.4473684210526-8.44736842105263
476362.39215686274510.607843137254903
489696.1-0.0999999999999943
4911296.115.9
507596.1-21.1
513926.7512.25
526375.4473684210526-12.4473684210526
539396.1-3.09999999999999
547675.44736842105260.55263157894737
5511775.447368421052641.5526315789474
563075.4473684210526-45.4473684210526
576575.4473684210526-10.4473684210526
587862.392156862745115.6078431372549
598775.447368421052611.5526315789474
608596.1-11.1
6111575.447368421052639.5526315789474
626262.3921568627451-0.392156862745097
636062.3921568627451-2.3921568627451
646762.39215686274514.6078431372549
659075.447368421052614.5526315789474
6610062.392156862745137.6078431372549
6713596.138.9
687162.39215686274518.6078431372549
697562.392156862745112.6078431372549
70423.4117647058823538.5882352941176
714296.1-54.1
72862.3921568627451-54.3921568627451
738662.392156862745123.6078431372549
744162.3921568627451-21.3921568627451
7511896.121.9
769162.392156862745128.6078431372549
7710296.15.90000000000001
788996.1-7.09999999999999
794662.3921568627451-16.3921568627451
806062.3921568627451-2.3921568627451
816962.39215686274516.6078431372549
829596.1-1.09999999999999
831726.75-9.75
846162.3921568627451-1.3921568627451
855562.3921568627451-7.3921568627451
865575.4473684210526-20.4473684210526
8712496.127.9
887362.392156862745110.6078431372549
897362.392156862745110.6078431372549
906775.4473684210526-8.44736842105263
916675.4473684210526-9.44736842105263
927596.1-21.1
938375.44736842105267.55263157894737
945562.3921568627451-7.3921568627451
952726.750.25
9611596.118.9
977675.44736842105260.55263157894737
9803.41176470588235-3.41176470588235
998396.1-13.1
1009075.447368421052614.5526315789474
101426.75-22.75
1026062.3921568627451-2.3921568627451
1036362.39215686274510.607843137254903
1045262.3921568627451-10.3921568627451
1052462.3921568627451-38.3921568627451
1061726.75-9.75
10710575.447368421052629.5526315789474
1082062.3921568627451-42.3921568627451
10903.41176470588235-3.41176470588235
1105162.3921568627451-11.3921568627451
1117662.392156862745113.6078431372549
1125962.3921568627451-3.3921568627451
1137075.4473684210526-5.44736842105263
1143862.3921568627451-24.3921568627451
11503.41176470588235-3.41176470588235
11603.41176470588235-3.41176470588235
1178175.44736842105265.55263157894737
1187862.392156862745115.6078431372549
1197375.4473684210526-2.44736842105263
1208962.392156862745126.6078431372549
12133.41176470588235-0.411764705882353
1228775.447368421052611.5526315789474
1235162.3921568627451-11.3921568627451
1247362.392156862745110.6078431372549
1253226.755.25
12643.411764705882350.588235294117647
1277075.4473684210526-5.44736842105263
12810262.392156862745139.6078431372549
1299175.447368421052615.5526315789474
13013.41176470588235-2.41176470588235
13103.41176470588235-3.41176470588235
1323962.3921568627451-23.3921568627451
13303.41176470588235-3.41176470588235
1344575.4473684210526-30.4473684210526
13503.41176470588235-3.41176470588235
13673.411764705882353.58823529411765
13703.41176470588235-3.41176470588235
1387562.392156862745112.6078431372549
1395262.3921568627451-10.3921568627451
14003.41176470588235-3.41176470588235
14113.41176470588235-2.41176470588235
1424962.3921568627451-13.3921568627451
1436962.39215686274516.6078431372549
1445662.3921568627451-6.3921568627451



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