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 computationFri, 23 Dec 2011 07:09:56 -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/23/t1324642504ma1m5425eftx8m9.htm/, Retrieved Mon, 29 Apr 2024 18:57:44 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=160342, Retrieved Mon, 29 Apr 2024 18:57:44 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact79
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Multiple Regression] [multip reg paper ...] [2011-12-20 09:29:41] [63813c3109753b730d344072266dee79]
- RMP     [Recursive Partitioning (Regression Trees)] [paper ba 2 multip...] [2011-12-23 12:09:56] [0e2c18186cab982e7ba7b89fbe242e59] [Current]
-   P       [Recursive Partitioning (Regression Trees)] [] [2011-12-23 12:33:40] [63813c3109753b730d344072266dee79]
Feedback Forum

Post a new message
Dataseries X:
18	1760	89	20465	70
20	1609	56	33629	80
0	192	18	1423	0
26	2182	92	25629	81
31	3367	131	54002	124
36	6727	257	151036	140
23	1619	55	33287	88
30	1507	56	31172	115
30	1682	42	28113	109
26	2812	92	57803	104
24	1943	74	49830	63
30	2017	66	52143	118
21	1702	96	21055	68
25	3034	110	47007	100
18	1379	55	28735	63
19	1517	79	59147	74
33	1637	53	78950	132
15	1169	54	13497	54
34	2384	84	46154	134
18	726	24	53249	57
15	993	55	10726	59
30	2683	96	83700	113
25	1713	70	40400	96
34	2027	50	33797	96
21	1818	81	36205	78
21	1393	28	30165	80
25	2000	154	58534	93
31	1346	85	44663	109
31	2676	115	92556	115
20	2106	43	40078	79
28	1591	43	34711	103
20	1519	43	31076	65
17	2171	101	74608	66
25	3003	121	58092	100
24	2364	52	42009	96
0	1	1	0	0
27	2017	60	36022	105
14	1564	50	23333	51
32	2072	47	53349	108
31	2106	63	92596	124
21	2270	69	49598	81
34	1643	56	44093	136
23	957	29	84205	84
24	2025	77	63369	92
26	1236	46	60132	103
22	1178	91	37403	82
35	744	31	24460	106
21	1976	92	46456	84
31	2224	85	66616	124
26	2561	56	41554	97
22	658	28	22346	82
21	1779	65	30874	79
27	2355	71	68701	97
30	2017	77	35728	107
33	1758	59	29010	126
11	1675	54	23110	40
26	1760	62	38844	96
26	875	23	27084	100
23	1169	65	35139	91
38	2789	93	57476	136
29	1606	56	33277	116
19	2020	76	31141	76
19	1300	58	61281	65
26	1235	35	25820	96
26	1215	32	23284	97
29	1230	38	35378	107
36	2226	67	74990	144
25	2897	65	29653	90
24	1071	38	64622	93
21	340	15	4157	78
19	2704	110	29245	72
12	1247	64	50008	45
30	1422	64	52338	120
21	1535	68	13310	59
34	2593	66	92901	133
32	1397	42	10956	117
28	2162	58	34241	123
28	2513	94	75043	110
21	917	26	21152	75
31	1234	71	42249	114
26	917	66	42005	94
29	1924	59	41152	116
23	853	27	14399	86
25	1398	34	28263	90
22	986	44	17215	87
26	1608	47	48140	99
33	2577	220	62897	132
24	1201	108	22883	96
24	1189	56	41622	91
21	1431	50	40715	77
28	1698	40	65897	104
27	2185	74	76542	97
25	1228	56	37477	94
15	1266	58	53216	60
13	830	36	40911	46
36	2238	111	57021	135
24	1787	68	73116	90
1	223	12	3895	2
24	2254	100	46609	96
31	1952	75	29351	109
4	665	28	2325	15
20	804	22	31747	64
23	1211	49	32665	88
23	1143	57	19249	84
12	710	38	15292	46
16	596	22	5842	59
29	1353	44	33994	116
10	971	32	13018	29
0	0	0	0	0
25	1030	31	98177	91
21	1130	66	37941	76
23	1284	44	31032	83
21	1438	61	32683	84
21	849	57	34545	65
0	78	5	0	0
0	0	0	0	0
23	925	39	27525	84
29	1518	78	66856	99
28	1946	95	28549	112
23	914	37	38610	92
1	778	19	2781	3
29	1713	71	41211	109
17	895	40	22698	71
29	1756	52	41194	106
12	701	40	32689	48
2	285	12	5752	8
21	1774	55	26757	80
25	1071	29	22527	95
29	1582	46	44810	116
2	256	9	0	8
0	98	9	0	0
18	1358	55	100674	56
1	41	3	0	4
21	1771	58	57786	70
0	42	3	0	0
4	528	16	5444	14
0	0	0	0	0
25	1026	45	28470	91
26	1296	38	61849	89
0	81	4	0	0
4	257	13	2179	12
17	914	23	8019	60
21	1178	50	39644	80
22	1080	19	23494	88




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Herman Ole Andreas Wold' @ wold.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 & 'Herman Ole Andreas Wold' @ wold.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160342&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]'Herman Ole Andreas Wold' @ wold.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160342&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160342&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'Herman Ole Andreas Wold' @ wold.wessa.net







Goodness of Fit
Correlation0.6691
R-squared0.4477
RMSE18592.8968

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.6691[/C][/ROW]
[ROW][C]R-squared[/C][C]0.4477[/C][/ROW]
[ROW][C]RMSE[/C][C]18592.8968[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160342&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160342&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.6691
R-squared0.4477
RMSE18592.8968







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
12046537713.28125-17248.28125
23362937713.28125-4084.28125
314232808.57894736842-1385.57894736842
42562956784.5882352941-31155.5882352941
55400268030.6666666667-14028.6666666667
615103668030.666666666783005.3333333333
73328737713.28125-4426.28125
83117237713.28125-6541.28125
92811337713.28125-9600.28125
105780368030.6666666667-10227.6666666667
114983037713.2812512116.71875
125214337713.2812514429.71875
132105537713.28125-16658.28125
144700768030.6666666667-21023.6666666667
152873537713.28125-8978.28125
165914737713.2812521433.71875
177895037713.2812541236.71875
181349737713.28125-24216.28125
194615456784.5882352941-10630.5882352941
205324937713.2812515535.71875
211072637713.28125-26987.28125
228370068030.666666666715669.3333333333
234040037713.281252686.71875
243379737713.28125-3916.28125
253620537713.28125-1508.28125
263016537713.28125-7548.28125
275853437713.2812520820.71875
284466337713.281256949.71875
299255668030.666666666724525.3333333333
304007856784.5882352941-16706.5882352941
313471137713.28125-3002.28125
323107637713.28125-6637.28125
337460856784.588235294117823.4117647059
345809268030.6666666667-9938.66666666667
354200956784.5882352941-14775.5882352941
3602808.57894736842-2808.57894736842
373602237713.28125-1691.28125
382333337713.28125-14380.28125
395334956784.5882352941-3435.58823529412
409259656784.588235294135811.4117647059
414959856784.5882352941-7186.58823529412
424409337713.281256379.71875
438420537713.2812546491.71875
446336937713.2812525655.71875
456013237713.2812522418.71875
463740337713.28125-310.28125
472446037713.28125-13253.28125
484645637713.281258742.71875
496661656784.58823529419831.41176470588
504155456784.5882352941-15230.5882352941
51223462808.5789473684219537.4210526316
523087437713.28125-6839.28125
536870156784.588235294111916.4117647059
543572837713.28125-1985.28125
552901037713.28125-8703.28125
562311037713.28125-14603.28125
573884437713.281251130.71875
582708437713.28125-10629.28125
593513937713.28125-2574.28125
605747668030.6666666667-10554.6666666667
613327737713.28125-4436.28125
623114137713.28125-6572.28125
636128137713.2812523567.71875
642582037713.28125-11893.28125
652328437713.28125-14429.28125
663537837713.28125-2335.28125
677499056784.588235294118205.4117647059
682965368030.6666666667-38377.6666666667
696462237713.2812526908.71875
7041572808.578947368421348.42105263158
712924568030.6666666667-38785.6666666667
725000837713.2812512294.71875
735233837713.2812514624.71875
741331037713.28125-24403.28125
759290168030.666666666724870.3333333333
761095637713.28125-26757.28125
773424156784.5882352941-22543.5882352941
787504356784.588235294118258.4117647059
792115237713.28125-16561.28125
804224937713.281254535.71875
814200537713.281254291.71875
824115237713.281253438.71875
831439937713.28125-23314.28125
842826337713.28125-9450.28125
851721537713.28125-20498.28125
864814037713.2812510426.71875
876289768030.6666666667-5133.66666666667
882288337713.28125-14830.28125
894162237713.281253908.71875
904071537713.281253001.71875
916589737713.2812528183.71875
927654256784.588235294119757.4117647059
933747737713.28125-236.28125
945321637713.2812515502.71875
954091137713.281253197.71875
965702156784.5882352941236.411764705881
977311637713.2812535402.71875
9838952808.578947368421086.42105263158
994660956784.5882352941-10175.5882352941
1002935137713.28125-8362.28125
10123252808.57894736842-483.578947368421
1023174737713.28125-5966.28125
1033266537713.28125-5048.28125
1041924937713.28125-18464.28125
1051529237713.28125-22421.28125
10658422808.578947368423033.42105263158
1073399437713.28125-3719.28125
1081301837713.28125-24695.28125
10902808.57894736842-2808.57894736842
1109817737713.2812560463.71875
1113794137713.28125227.71875
1123103237713.28125-6681.28125
1133268337713.28125-5030.28125
1143454537713.28125-3168.28125
11502808.57894736842-2808.57894736842
11602808.57894736842-2808.57894736842
1172752537713.28125-10188.28125
1186685637713.2812529142.71875
1192854937713.28125-9164.28125
1203861037713.28125896.71875
121278137713.28125-34932.28125
1224121137713.281253497.71875
1232269837713.28125-15015.28125
1244119437713.281253480.71875
1253268937713.28125-5024.28125
12657522808.578947368422943.42105263158
1272675737713.28125-10956.28125
1282252737713.28125-15186.28125
1294481037713.281257096.71875
13002808.57894736842-2808.57894736842
13102808.57894736842-2808.57894736842
13210067437713.2812562960.71875
13302808.57894736842-2808.57894736842
1345778637713.2812520072.71875
13502808.57894736842-2808.57894736842
13654442808.578947368422635.42105263158
13702808.57894736842-2808.57894736842
1382847037713.28125-9243.28125
1396184937713.2812524135.71875
14002808.57894736842-2808.57894736842
14121792808.57894736842-629.578947368421
142801937713.28125-29694.28125
1433964437713.281251930.71875
1442349437713.28125-14219.28125

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 20465 & 37713.28125 & -17248.28125 \tabularnewline
2 & 33629 & 37713.28125 & -4084.28125 \tabularnewline
3 & 1423 & 2808.57894736842 & -1385.57894736842 \tabularnewline
4 & 25629 & 56784.5882352941 & -31155.5882352941 \tabularnewline
5 & 54002 & 68030.6666666667 & -14028.6666666667 \tabularnewline
6 & 151036 & 68030.6666666667 & 83005.3333333333 \tabularnewline
7 & 33287 & 37713.28125 & -4426.28125 \tabularnewline
8 & 31172 & 37713.28125 & -6541.28125 \tabularnewline
9 & 28113 & 37713.28125 & -9600.28125 \tabularnewline
10 & 57803 & 68030.6666666667 & -10227.6666666667 \tabularnewline
11 & 49830 & 37713.28125 & 12116.71875 \tabularnewline
12 & 52143 & 37713.28125 & 14429.71875 \tabularnewline
13 & 21055 & 37713.28125 & -16658.28125 \tabularnewline
14 & 47007 & 68030.6666666667 & -21023.6666666667 \tabularnewline
15 & 28735 & 37713.28125 & -8978.28125 \tabularnewline
16 & 59147 & 37713.28125 & 21433.71875 \tabularnewline
17 & 78950 & 37713.28125 & 41236.71875 \tabularnewline
18 & 13497 & 37713.28125 & -24216.28125 \tabularnewline
19 & 46154 & 56784.5882352941 & -10630.5882352941 \tabularnewline
20 & 53249 & 37713.28125 & 15535.71875 \tabularnewline
21 & 10726 & 37713.28125 & -26987.28125 \tabularnewline
22 & 83700 & 68030.6666666667 & 15669.3333333333 \tabularnewline
23 & 40400 & 37713.28125 & 2686.71875 \tabularnewline
24 & 33797 & 37713.28125 & -3916.28125 \tabularnewline
25 & 36205 & 37713.28125 & -1508.28125 \tabularnewline
26 & 30165 & 37713.28125 & -7548.28125 \tabularnewline
27 & 58534 & 37713.28125 & 20820.71875 \tabularnewline
28 & 44663 & 37713.28125 & 6949.71875 \tabularnewline
29 & 92556 & 68030.6666666667 & 24525.3333333333 \tabularnewline
30 & 40078 & 56784.5882352941 & -16706.5882352941 \tabularnewline
31 & 34711 & 37713.28125 & -3002.28125 \tabularnewline
32 & 31076 & 37713.28125 & -6637.28125 \tabularnewline
33 & 74608 & 56784.5882352941 & 17823.4117647059 \tabularnewline
34 & 58092 & 68030.6666666667 & -9938.66666666667 \tabularnewline
35 & 42009 & 56784.5882352941 & -14775.5882352941 \tabularnewline
36 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
37 & 36022 & 37713.28125 & -1691.28125 \tabularnewline
38 & 23333 & 37713.28125 & -14380.28125 \tabularnewline
39 & 53349 & 56784.5882352941 & -3435.58823529412 \tabularnewline
40 & 92596 & 56784.5882352941 & 35811.4117647059 \tabularnewline
41 & 49598 & 56784.5882352941 & -7186.58823529412 \tabularnewline
42 & 44093 & 37713.28125 & 6379.71875 \tabularnewline
43 & 84205 & 37713.28125 & 46491.71875 \tabularnewline
44 & 63369 & 37713.28125 & 25655.71875 \tabularnewline
45 & 60132 & 37713.28125 & 22418.71875 \tabularnewline
46 & 37403 & 37713.28125 & -310.28125 \tabularnewline
47 & 24460 & 37713.28125 & -13253.28125 \tabularnewline
48 & 46456 & 37713.28125 & 8742.71875 \tabularnewline
49 & 66616 & 56784.5882352941 & 9831.41176470588 \tabularnewline
50 & 41554 & 56784.5882352941 & -15230.5882352941 \tabularnewline
51 & 22346 & 2808.57894736842 & 19537.4210526316 \tabularnewline
52 & 30874 & 37713.28125 & -6839.28125 \tabularnewline
53 & 68701 & 56784.5882352941 & 11916.4117647059 \tabularnewline
54 & 35728 & 37713.28125 & -1985.28125 \tabularnewline
55 & 29010 & 37713.28125 & -8703.28125 \tabularnewline
56 & 23110 & 37713.28125 & -14603.28125 \tabularnewline
57 & 38844 & 37713.28125 & 1130.71875 \tabularnewline
58 & 27084 & 37713.28125 & -10629.28125 \tabularnewline
59 & 35139 & 37713.28125 & -2574.28125 \tabularnewline
60 & 57476 & 68030.6666666667 & -10554.6666666667 \tabularnewline
61 & 33277 & 37713.28125 & -4436.28125 \tabularnewline
62 & 31141 & 37713.28125 & -6572.28125 \tabularnewline
63 & 61281 & 37713.28125 & 23567.71875 \tabularnewline
64 & 25820 & 37713.28125 & -11893.28125 \tabularnewline
65 & 23284 & 37713.28125 & -14429.28125 \tabularnewline
66 & 35378 & 37713.28125 & -2335.28125 \tabularnewline
67 & 74990 & 56784.5882352941 & 18205.4117647059 \tabularnewline
68 & 29653 & 68030.6666666667 & -38377.6666666667 \tabularnewline
69 & 64622 & 37713.28125 & 26908.71875 \tabularnewline
70 & 4157 & 2808.57894736842 & 1348.42105263158 \tabularnewline
71 & 29245 & 68030.6666666667 & -38785.6666666667 \tabularnewline
72 & 50008 & 37713.28125 & 12294.71875 \tabularnewline
73 & 52338 & 37713.28125 & 14624.71875 \tabularnewline
74 & 13310 & 37713.28125 & -24403.28125 \tabularnewline
75 & 92901 & 68030.6666666667 & 24870.3333333333 \tabularnewline
76 & 10956 & 37713.28125 & -26757.28125 \tabularnewline
77 & 34241 & 56784.5882352941 & -22543.5882352941 \tabularnewline
78 & 75043 & 56784.5882352941 & 18258.4117647059 \tabularnewline
79 & 21152 & 37713.28125 & -16561.28125 \tabularnewline
80 & 42249 & 37713.28125 & 4535.71875 \tabularnewline
81 & 42005 & 37713.28125 & 4291.71875 \tabularnewline
82 & 41152 & 37713.28125 & 3438.71875 \tabularnewline
83 & 14399 & 37713.28125 & -23314.28125 \tabularnewline
84 & 28263 & 37713.28125 & -9450.28125 \tabularnewline
85 & 17215 & 37713.28125 & -20498.28125 \tabularnewline
86 & 48140 & 37713.28125 & 10426.71875 \tabularnewline
87 & 62897 & 68030.6666666667 & -5133.66666666667 \tabularnewline
88 & 22883 & 37713.28125 & -14830.28125 \tabularnewline
89 & 41622 & 37713.28125 & 3908.71875 \tabularnewline
90 & 40715 & 37713.28125 & 3001.71875 \tabularnewline
91 & 65897 & 37713.28125 & 28183.71875 \tabularnewline
92 & 76542 & 56784.5882352941 & 19757.4117647059 \tabularnewline
93 & 37477 & 37713.28125 & -236.28125 \tabularnewline
94 & 53216 & 37713.28125 & 15502.71875 \tabularnewline
95 & 40911 & 37713.28125 & 3197.71875 \tabularnewline
96 & 57021 & 56784.5882352941 & 236.411764705881 \tabularnewline
97 & 73116 & 37713.28125 & 35402.71875 \tabularnewline
98 & 3895 & 2808.57894736842 & 1086.42105263158 \tabularnewline
99 & 46609 & 56784.5882352941 & -10175.5882352941 \tabularnewline
100 & 29351 & 37713.28125 & -8362.28125 \tabularnewline
101 & 2325 & 2808.57894736842 & -483.578947368421 \tabularnewline
102 & 31747 & 37713.28125 & -5966.28125 \tabularnewline
103 & 32665 & 37713.28125 & -5048.28125 \tabularnewline
104 & 19249 & 37713.28125 & -18464.28125 \tabularnewline
105 & 15292 & 37713.28125 & -22421.28125 \tabularnewline
106 & 5842 & 2808.57894736842 & 3033.42105263158 \tabularnewline
107 & 33994 & 37713.28125 & -3719.28125 \tabularnewline
108 & 13018 & 37713.28125 & -24695.28125 \tabularnewline
109 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
110 & 98177 & 37713.28125 & 60463.71875 \tabularnewline
111 & 37941 & 37713.28125 & 227.71875 \tabularnewline
112 & 31032 & 37713.28125 & -6681.28125 \tabularnewline
113 & 32683 & 37713.28125 & -5030.28125 \tabularnewline
114 & 34545 & 37713.28125 & -3168.28125 \tabularnewline
115 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
116 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
117 & 27525 & 37713.28125 & -10188.28125 \tabularnewline
118 & 66856 & 37713.28125 & 29142.71875 \tabularnewline
119 & 28549 & 37713.28125 & -9164.28125 \tabularnewline
120 & 38610 & 37713.28125 & 896.71875 \tabularnewline
121 & 2781 & 37713.28125 & -34932.28125 \tabularnewline
122 & 41211 & 37713.28125 & 3497.71875 \tabularnewline
123 & 22698 & 37713.28125 & -15015.28125 \tabularnewline
124 & 41194 & 37713.28125 & 3480.71875 \tabularnewline
125 & 32689 & 37713.28125 & -5024.28125 \tabularnewline
126 & 5752 & 2808.57894736842 & 2943.42105263158 \tabularnewline
127 & 26757 & 37713.28125 & -10956.28125 \tabularnewline
128 & 22527 & 37713.28125 & -15186.28125 \tabularnewline
129 & 44810 & 37713.28125 & 7096.71875 \tabularnewline
130 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
131 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
132 & 100674 & 37713.28125 & 62960.71875 \tabularnewline
133 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
134 & 57786 & 37713.28125 & 20072.71875 \tabularnewline
135 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
136 & 5444 & 2808.57894736842 & 2635.42105263158 \tabularnewline
137 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
138 & 28470 & 37713.28125 & -9243.28125 \tabularnewline
139 & 61849 & 37713.28125 & 24135.71875 \tabularnewline
140 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
141 & 2179 & 2808.57894736842 & -629.578947368421 \tabularnewline
142 & 8019 & 37713.28125 & -29694.28125 \tabularnewline
143 & 39644 & 37713.28125 & 1930.71875 \tabularnewline
144 & 23494 & 37713.28125 & -14219.28125 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160342&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]20465[/C][C]37713.28125[/C][C]-17248.28125[/C][/ROW]
[ROW][C]2[/C][C]33629[/C][C]37713.28125[/C][C]-4084.28125[/C][/ROW]
[ROW][C]3[/C][C]1423[/C][C]2808.57894736842[/C][C]-1385.57894736842[/C][/ROW]
[ROW][C]4[/C][C]25629[/C][C]56784.5882352941[/C][C]-31155.5882352941[/C][/ROW]
[ROW][C]5[/C][C]54002[/C][C]68030.6666666667[/C][C]-14028.6666666667[/C][/ROW]
[ROW][C]6[/C][C]151036[/C][C]68030.6666666667[/C][C]83005.3333333333[/C][/ROW]
[ROW][C]7[/C][C]33287[/C][C]37713.28125[/C][C]-4426.28125[/C][/ROW]
[ROW][C]8[/C][C]31172[/C][C]37713.28125[/C][C]-6541.28125[/C][/ROW]
[ROW][C]9[/C][C]28113[/C][C]37713.28125[/C][C]-9600.28125[/C][/ROW]
[ROW][C]10[/C][C]57803[/C][C]68030.6666666667[/C][C]-10227.6666666667[/C][/ROW]
[ROW][C]11[/C][C]49830[/C][C]37713.28125[/C][C]12116.71875[/C][/ROW]
[ROW][C]12[/C][C]52143[/C][C]37713.28125[/C][C]14429.71875[/C][/ROW]
[ROW][C]13[/C][C]21055[/C][C]37713.28125[/C][C]-16658.28125[/C][/ROW]
[ROW][C]14[/C][C]47007[/C][C]68030.6666666667[/C][C]-21023.6666666667[/C][/ROW]
[ROW][C]15[/C][C]28735[/C][C]37713.28125[/C][C]-8978.28125[/C][/ROW]
[ROW][C]16[/C][C]59147[/C][C]37713.28125[/C][C]21433.71875[/C][/ROW]
[ROW][C]17[/C][C]78950[/C][C]37713.28125[/C][C]41236.71875[/C][/ROW]
[ROW][C]18[/C][C]13497[/C][C]37713.28125[/C][C]-24216.28125[/C][/ROW]
[ROW][C]19[/C][C]46154[/C][C]56784.5882352941[/C][C]-10630.5882352941[/C][/ROW]
[ROW][C]20[/C][C]53249[/C][C]37713.28125[/C][C]15535.71875[/C][/ROW]
[ROW][C]21[/C][C]10726[/C][C]37713.28125[/C][C]-26987.28125[/C][/ROW]
[ROW][C]22[/C][C]83700[/C][C]68030.6666666667[/C][C]15669.3333333333[/C][/ROW]
[ROW][C]23[/C][C]40400[/C][C]37713.28125[/C][C]2686.71875[/C][/ROW]
[ROW][C]24[/C][C]33797[/C][C]37713.28125[/C][C]-3916.28125[/C][/ROW]
[ROW][C]25[/C][C]36205[/C][C]37713.28125[/C][C]-1508.28125[/C][/ROW]
[ROW][C]26[/C][C]30165[/C][C]37713.28125[/C][C]-7548.28125[/C][/ROW]
[ROW][C]27[/C][C]58534[/C][C]37713.28125[/C][C]20820.71875[/C][/ROW]
[ROW][C]28[/C][C]44663[/C][C]37713.28125[/C][C]6949.71875[/C][/ROW]
[ROW][C]29[/C][C]92556[/C][C]68030.6666666667[/C][C]24525.3333333333[/C][/ROW]
[ROW][C]30[/C][C]40078[/C][C]56784.5882352941[/C][C]-16706.5882352941[/C][/ROW]
[ROW][C]31[/C][C]34711[/C][C]37713.28125[/C][C]-3002.28125[/C][/ROW]
[ROW][C]32[/C][C]31076[/C][C]37713.28125[/C][C]-6637.28125[/C][/ROW]
[ROW][C]33[/C][C]74608[/C][C]56784.5882352941[/C][C]17823.4117647059[/C][/ROW]
[ROW][C]34[/C][C]58092[/C][C]68030.6666666667[/C][C]-9938.66666666667[/C][/ROW]
[ROW][C]35[/C][C]42009[/C][C]56784.5882352941[/C][C]-14775.5882352941[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]37[/C][C]36022[/C][C]37713.28125[/C][C]-1691.28125[/C][/ROW]
[ROW][C]38[/C][C]23333[/C][C]37713.28125[/C][C]-14380.28125[/C][/ROW]
[ROW][C]39[/C][C]53349[/C][C]56784.5882352941[/C][C]-3435.58823529412[/C][/ROW]
[ROW][C]40[/C][C]92596[/C][C]56784.5882352941[/C][C]35811.4117647059[/C][/ROW]
[ROW][C]41[/C][C]49598[/C][C]56784.5882352941[/C][C]-7186.58823529412[/C][/ROW]
[ROW][C]42[/C][C]44093[/C][C]37713.28125[/C][C]6379.71875[/C][/ROW]
[ROW][C]43[/C][C]84205[/C][C]37713.28125[/C][C]46491.71875[/C][/ROW]
[ROW][C]44[/C][C]63369[/C][C]37713.28125[/C][C]25655.71875[/C][/ROW]
[ROW][C]45[/C][C]60132[/C][C]37713.28125[/C][C]22418.71875[/C][/ROW]
[ROW][C]46[/C][C]37403[/C][C]37713.28125[/C][C]-310.28125[/C][/ROW]
[ROW][C]47[/C][C]24460[/C][C]37713.28125[/C][C]-13253.28125[/C][/ROW]
[ROW][C]48[/C][C]46456[/C][C]37713.28125[/C][C]8742.71875[/C][/ROW]
[ROW][C]49[/C][C]66616[/C][C]56784.5882352941[/C][C]9831.41176470588[/C][/ROW]
[ROW][C]50[/C][C]41554[/C][C]56784.5882352941[/C][C]-15230.5882352941[/C][/ROW]
[ROW][C]51[/C][C]22346[/C][C]2808.57894736842[/C][C]19537.4210526316[/C][/ROW]
[ROW][C]52[/C][C]30874[/C][C]37713.28125[/C][C]-6839.28125[/C][/ROW]
[ROW][C]53[/C][C]68701[/C][C]56784.5882352941[/C][C]11916.4117647059[/C][/ROW]
[ROW][C]54[/C][C]35728[/C][C]37713.28125[/C][C]-1985.28125[/C][/ROW]
[ROW][C]55[/C][C]29010[/C][C]37713.28125[/C][C]-8703.28125[/C][/ROW]
[ROW][C]56[/C][C]23110[/C][C]37713.28125[/C][C]-14603.28125[/C][/ROW]
[ROW][C]57[/C][C]38844[/C][C]37713.28125[/C][C]1130.71875[/C][/ROW]
[ROW][C]58[/C][C]27084[/C][C]37713.28125[/C][C]-10629.28125[/C][/ROW]
[ROW][C]59[/C][C]35139[/C][C]37713.28125[/C][C]-2574.28125[/C][/ROW]
[ROW][C]60[/C][C]57476[/C][C]68030.6666666667[/C][C]-10554.6666666667[/C][/ROW]
[ROW][C]61[/C][C]33277[/C][C]37713.28125[/C][C]-4436.28125[/C][/ROW]
[ROW][C]62[/C][C]31141[/C][C]37713.28125[/C][C]-6572.28125[/C][/ROW]
[ROW][C]63[/C][C]61281[/C][C]37713.28125[/C][C]23567.71875[/C][/ROW]
[ROW][C]64[/C][C]25820[/C][C]37713.28125[/C][C]-11893.28125[/C][/ROW]
[ROW][C]65[/C][C]23284[/C][C]37713.28125[/C][C]-14429.28125[/C][/ROW]
[ROW][C]66[/C][C]35378[/C][C]37713.28125[/C][C]-2335.28125[/C][/ROW]
[ROW][C]67[/C][C]74990[/C][C]56784.5882352941[/C][C]18205.4117647059[/C][/ROW]
[ROW][C]68[/C][C]29653[/C][C]68030.6666666667[/C][C]-38377.6666666667[/C][/ROW]
[ROW][C]69[/C][C]64622[/C][C]37713.28125[/C][C]26908.71875[/C][/ROW]
[ROW][C]70[/C][C]4157[/C][C]2808.57894736842[/C][C]1348.42105263158[/C][/ROW]
[ROW][C]71[/C][C]29245[/C][C]68030.6666666667[/C][C]-38785.6666666667[/C][/ROW]
[ROW][C]72[/C][C]50008[/C][C]37713.28125[/C][C]12294.71875[/C][/ROW]
[ROW][C]73[/C][C]52338[/C][C]37713.28125[/C][C]14624.71875[/C][/ROW]
[ROW][C]74[/C][C]13310[/C][C]37713.28125[/C][C]-24403.28125[/C][/ROW]
[ROW][C]75[/C][C]92901[/C][C]68030.6666666667[/C][C]24870.3333333333[/C][/ROW]
[ROW][C]76[/C][C]10956[/C][C]37713.28125[/C][C]-26757.28125[/C][/ROW]
[ROW][C]77[/C][C]34241[/C][C]56784.5882352941[/C][C]-22543.5882352941[/C][/ROW]
[ROW][C]78[/C][C]75043[/C][C]56784.5882352941[/C][C]18258.4117647059[/C][/ROW]
[ROW][C]79[/C][C]21152[/C][C]37713.28125[/C][C]-16561.28125[/C][/ROW]
[ROW][C]80[/C][C]42249[/C][C]37713.28125[/C][C]4535.71875[/C][/ROW]
[ROW][C]81[/C][C]42005[/C][C]37713.28125[/C][C]4291.71875[/C][/ROW]
[ROW][C]82[/C][C]41152[/C][C]37713.28125[/C][C]3438.71875[/C][/ROW]
[ROW][C]83[/C][C]14399[/C][C]37713.28125[/C][C]-23314.28125[/C][/ROW]
[ROW][C]84[/C][C]28263[/C][C]37713.28125[/C][C]-9450.28125[/C][/ROW]
[ROW][C]85[/C][C]17215[/C][C]37713.28125[/C][C]-20498.28125[/C][/ROW]
[ROW][C]86[/C][C]48140[/C][C]37713.28125[/C][C]10426.71875[/C][/ROW]
[ROW][C]87[/C][C]62897[/C][C]68030.6666666667[/C][C]-5133.66666666667[/C][/ROW]
[ROW][C]88[/C][C]22883[/C][C]37713.28125[/C][C]-14830.28125[/C][/ROW]
[ROW][C]89[/C][C]41622[/C][C]37713.28125[/C][C]3908.71875[/C][/ROW]
[ROW][C]90[/C][C]40715[/C][C]37713.28125[/C][C]3001.71875[/C][/ROW]
[ROW][C]91[/C][C]65897[/C][C]37713.28125[/C][C]28183.71875[/C][/ROW]
[ROW][C]92[/C][C]76542[/C][C]56784.5882352941[/C][C]19757.4117647059[/C][/ROW]
[ROW][C]93[/C][C]37477[/C][C]37713.28125[/C][C]-236.28125[/C][/ROW]
[ROW][C]94[/C][C]53216[/C][C]37713.28125[/C][C]15502.71875[/C][/ROW]
[ROW][C]95[/C][C]40911[/C][C]37713.28125[/C][C]3197.71875[/C][/ROW]
[ROW][C]96[/C][C]57021[/C][C]56784.5882352941[/C][C]236.411764705881[/C][/ROW]
[ROW][C]97[/C][C]73116[/C][C]37713.28125[/C][C]35402.71875[/C][/ROW]
[ROW][C]98[/C][C]3895[/C][C]2808.57894736842[/C][C]1086.42105263158[/C][/ROW]
[ROW][C]99[/C][C]46609[/C][C]56784.5882352941[/C][C]-10175.5882352941[/C][/ROW]
[ROW][C]100[/C][C]29351[/C][C]37713.28125[/C][C]-8362.28125[/C][/ROW]
[ROW][C]101[/C][C]2325[/C][C]2808.57894736842[/C][C]-483.578947368421[/C][/ROW]
[ROW][C]102[/C][C]31747[/C][C]37713.28125[/C][C]-5966.28125[/C][/ROW]
[ROW][C]103[/C][C]32665[/C][C]37713.28125[/C][C]-5048.28125[/C][/ROW]
[ROW][C]104[/C][C]19249[/C][C]37713.28125[/C][C]-18464.28125[/C][/ROW]
[ROW][C]105[/C][C]15292[/C][C]37713.28125[/C][C]-22421.28125[/C][/ROW]
[ROW][C]106[/C][C]5842[/C][C]2808.57894736842[/C][C]3033.42105263158[/C][/ROW]
[ROW][C]107[/C][C]33994[/C][C]37713.28125[/C][C]-3719.28125[/C][/ROW]
[ROW][C]108[/C][C]13018[/C][C]37713.28125[/C][C]-24695.28125[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]110[/C][C]98177[/C][C]37713.28125[/C][C]60463.71875[/C][/ROW]
[ROW][C]111[/C][C]37941[/C][C]37713.28125[/C][C]227.71875[/C][/ROW]
[ROW][C]112[/C][C]31032[/C][C]37713.28125[/C][C]-6681.28125[/C][/ROW]
[ROW][C]113[/C][C]32683[/C][C]37713.28125[/C][C]-5030.28125[/C][/ROW]
[ROW][C]114[/C][C]34545[/C][C]37713.28125[/C][C]-3168.28125[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]117[/C][C]27525[/C][C]37713.28125[/C][C]-10188.28125[/C][/ROW]
[ROW][C]118[/C][C]66856[/C][C]37713.28125[/C][C]29142.71875[/C][/ROW]
[ROW][C]119[/C][C]28549[/C][C]37713.28125[/C][C]-9164.28125[/C][/ROW]
[ROW][C]120[/C][C]38610[/C][C]37713.28125[/C][C]896.71875[/C][/ROW]
[ROW][C]121[/C][C]2781[/C][C]37713.28125[/C][C]-34932.28125[/C][/ROW]
[ROW][C]122[/C][C]41211[/C][C]37713.28125[/C][C]3497.71875[/C][/ROW]
[ROW][C]123[/C][C]22698[/C][C]37713.28125[/C][C]-15015.28125[/C][/ROW]
[ROW][C]124[/C][C]41194[/C][C]37713.28125[/C][C]3480.71875[/C][/ROW]
[ROW][C]125[/C][C]32689[/C][C]37713.28125[/C][C]-5024.28125[/C][/ROW]
[ROW][C]126[/C][C]5752[/C][C]2808.57894736842[/C][C]2943.42105263158[/C][/ROW]
[ROW][C]127[/C][C]26757[/C][C]37713.28125[/C][C]-10956.28125[/C][/ROW]
[ROW][C]128[/C][C]22527[/C][C]37713.28125[/C][C]-15186.28125[/C][/ROW]
[ROW][C]129[/C][C]44810[/C][C]37713.28125[/C][C]7096.71875[/C][/ROW]
[ROW][C]130[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]132[/C][C]100674[/C][C]37713.28125[/C][C]62960.71875[/C][/ROW]
[ROW][C]133[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]134[/C][C]57786[/C][C]37713.28125[/C][C]20072.71875[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]136[/C][C]5444[/C][C]2808.57894736842[/C][C]2635.42105263158[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]138[/C][C]28470[/C][C]37713.28125[/C][C]-9243.28125[/C][/ROW]
[ROW][C]139[/C][C]61849[/C][C]37713.28125[/C][C]24135.71875[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]141[/C][C]2179[/C][C]2808.57894736842[/C][C]-629.578947368421[/C][/ROW]
[ROW][C]142[/C][C]8019[/C][C]37713.28125[/C][C]-29694.28125[/C][/ROW]
[ROW][C]143[/C][C]39644[/C][C]37713.28125[/C][C]1930.71875[/C][/ROW]
[ROW][C]144[/C][C]23494[/C][C]37713.28125[/C][C]-14219.28125[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160342&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160342&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
12046537713.28125-17248.28125
23362937713.28125-4084.28125
314232808.57894736842-1385.57894736842
42562956784.5882352941-31155.5882352941
55400268030.6666666667-14028.6666666667
615103668030.666666666783005.3333333333
73328737713.28125-4426.28125
83117237713.28125-6541.28125
92811337713.28125-9600.28125
105780368030.6666666667-10227.6666666667
114983037713.2812512116.71875
125214337713.2812514429.71875
132105537713.28125-16658.28125
144700768030.6666666667-21023.6666666667
152873537713.28125-8978.28125
165914737713.2812521433.71875
177895037713.2812541236.71875
181349737713.28125-24216.28125
194615456784.5882352941-10630.5882352941
205324937713.2812515535.71875
211072637713.28125-26987.28125
228370068030.666666666715669.3333333333
234040037713.281252686.71875
243379737713.28125-3916.28125
253620537713.28125-1508.28125
263016537713.28125-7548.28125
275853437713.2812520820.71875
284466337713.281256949.71875
299255668030.666666666724525.3333333333
304007856784.5882352941-16706.5882352941
313471137713.28125-3002.28125
323107637713.28125-6637.28125
337460856784.588235294117823.4117647059
345809268030.6666666667-9938.66666666667
354200956784.5882352941-14775.5882352941
3602808.57894736842-2808.57894736842
373602237713.28125-1691.28125
382333337713.28125-14380.28125
395334956784.5882352941-3435.58823529412
409259656784.588235294135811.4117647059
414959856784.5882352941-7186.58823529412
424409337713.281256379.71875
438420537713.2812546491.71875
446336937713.2812525655.71875
456013237713.2812522418.71875
463740337713.28125-310.28125
472446037713.28125-13253.28125
484645637713.281258742.71875
496661656784.58823529419831.41176470588
504155456784.5882352941-15230.5882352941
51223462808.5789473684219537.4210526316
523087437713.28125-6839.28125
536870156784.588235294111916.4117647059
543572837713.28125-1985.28125
552901037713.28125-8703.28125
562311037713.28125-14603.28125
573884437713.281251130.71875
582708437713.28125-10629.28125
593513937713.28125-2574.28125
605747668030.6666666667-10554.6666666667
613327737713.28125-4436.28125
623114137713.28125-6572.28125
636128137713.2812523567.71875
642582037713.28125-11893.28125
652328437713.28125-14429.28125
663537837713.28125-2335.28125
677499056784.588235294118205.4117647059
682965368030.6666666667-38377.6666666667
696462237713.2812526908.71875
7041572808.578947368421348.42105263158
712924568030.6666666667-38785.6666666667
725000837713.2812512294.71875
735233837713.2812514624.71875
741331037713.28125-24403.28125
759290168030.666666666724870.3333333333
761095637713.28125-26757.28125
773424156784.5882352941-22543.5882352941
787504356784.588235294118258.4117647059
792115237713.28125-16561.28125
804224937713.281254535.71875
814200537713.281254291.71875
824115237713.281253438.71875
831439937713.28125-23314.28125
842826337713.28125-9450.28125
851721537713.28125-20498.28125
864814037713.2812510426.71875
876289768030.6666666667-5133.66666666667
882288337713.28125-14830.28125
894162237713.281253908.71875
904071537713.281253001.71875
916589737713.2812528183.71875
927654256784.588235294119757.4117647059
933747737713.28125-236.28125
945321637713.2812515502.71875
954091137713.281253197.71875
965702156784.5882352941236.411764705881
977311637713.2812535402.71875
9838952808.578947368421086.42105263158
994660956784.5882352941-10175.5882352941
1002935137713.28125-8362.28125
10123252808.57894736842-483.578947368421
1023174737713.28125-5966.28125
1033266537713.28125-5048.28125
1041924937713.28125-18464.28125
1051529237713.28125-22421.28125
10658422808.578947368423033.42105263158
1073399437713.28125-3719.28125
1081301837713.28125-24695.28125
10902808.57894736842-2808.57894736842
1109817737713.2812560463.71875
1113794137713.28125227.71875
1123103237713.28125-6681.28125
1133268337713.28125-5030.28125
1143454537713.28125-3168.28125
11502808.57894736842-2808.57894736842
11602808.57894736842-2808.57894736842
1172752537713.28125-10188.28125
1186685637713.2812529142.71875
1192854937713.28125-9164.28125
1203861037713.28125896.71875
121278137713.28125-34932.28125
1224121137713.281253497.71875
1232269837713.28125-15015.28125
1244119437713.281253480.71875
1253268937713.28125-5024.28125
12657522808.578947368422943.42105263158
1272675737713.28125-10956.28125
1282252737713.28125-15186.28125
1294481037713.281257096.71875
13002808.57894736842-2808.57894736842
13102808.57894736842-2808.57894736842
13210067437713.2812562960.71875
13302808.57894736842-2808.57894736842
1345778637713.2812520072.71875
13502808.57894736842-2808.57894736842
13654442808.578947368422635.42105263158
13702808.57894736842-2808.57894736842
1382847037713.28125-9243.28125
1396184937713.2812524135.71875
14002808.57894736842-2808.57894736842
14121792808.57894736842-629.578947368421
142801937713.28125-29694.28125
1433964437713.281251930.71875
1442349437713.28125-14219.28125



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