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, 14 Dec 2011 10:10:21 -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/14/t1323875436t8760st7aei7ck2.htm/, Retrieved Wed, 01 May 2024 18:10:09 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=155037, Retrieved Wed, 01 May 2024 18:10:09 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact118
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [] [2010-12-05 20:21:33] [b98453cac15ba1066b407e146608df68]
-   PD    [Recursive Partitioning (Regression Trees)] [Recursive Partiti...] [2011-12-14 15:10:21] [050dc696fa22882d0c3b1ebe5a70a85e] [Current]
-   PD      [Recursive Partitioning (Regression Trees)] [recursive partiti...] [2011-12-23 15:22:25] [7ead21d528290ed5f4bbc64b680f15e5]
-   P         [Recursive Partitioning (Regression Trees)] [categorization] [2011-12-23 16:23:15] [7ead21d528290ed5f4bbc64b680f15e5]
-   P           [Recursive Partitioning (Regression Trees)] [] [2011-12-23 16:37:22] [7ead21d528290ed5f4bbc64b680f15e5]
Feedback Forum

Post a new message
Dataseries X:
127476	20	17	59	18158
130358	38	17	50	30461
7215	0	0	0	1423
112861	49	22	51	25629
210171	74	30	112	48758
393802	104	31	118	129230
117604	37	19	59	27376
126029	53	25	90	26706
99729	42	30	50	26505
256310	62	26	79	49801
113066	50	20	49	46580
156212	65	25	74	48352
69952	28	15	32	13899
152673	48	22	82	39342
125841	42	12	43	27465
125769	47	19	65	55211
123467	71	28	111	74098
56232	0	12	36	13497
108244	50	28	89	38338
22762	12	13	28	52505
48554	16	14	35	10663
178697	76	27	78	74484
140857	29	25	67	28895
93773	38	30	61	32827
133398	50	21	58	36188
113933	33	17	49	28173
144781	45	22	77	54926
140711	59	28	71	38900
283337	49	25	82	88530
158146	40	16	53	35482
123344	40	23	71	26730
157640	51	20	58	29806
91279	41	11	25	41799
189374	73	20	59	54289
167915	43	21	77	36805
0	0	0	0	0
175403	46	27	75	33146
92342	44	14	39	23333
100023	31	29	83	47686
178277	71	31	123	77783
145062	61	19	67	36042
110980	28	30	105	34541
86039	21	23	76	75620
120821	42	20	54	60610
95535	44	22	82	55041
109894	34	19	57	32087
61554	15	32	57	16356
156520	46	18	72	40161
159121	43	26	94	55459
129362	47	25	72	36679
48188	12	22	39	22346
95461	46	19	60	27377
229864	56	24	84	50273
180317	41	26	69	32104
150640	48	27	102	27016
104416	30	10	28	19715
165098	44	26	65	33629
63205	25	23	67	27084
100056	42	21	80	32352
137214	28	34	79	51845
99630	33	29	107	26591
84557	32	18	57	29677
91199	28	16	44	54237
83419	31	23	59	20284
101723	13	22	80	22741
94982	38	29	89	34178
129700	39	31	115	69551
110708	68	21	59	29653
81518	32	21	66	38071
31970	5	21	42	4157
192268	53	15	35	28321
87611	33	9	3	40195
77890	48	21	68	48158
83261	36	18	38	13310
116290	52	31	107	78474
56544	0	25	73	6386
116173	52	24	80	31588
111488	45	22	69	61254
60138	16	21	46	21152
73422	33	26	52	41272
67751	48	22	58	34165
213351	33	26	85	37054
51185	24	20	13	12368
97181	37	25	61	23168
45100	17	19	49	16380
115801	32	22	47	41242
185664	55	25	93	48450
71960	39	22	65	20790
76441	29	21	64	34585
103613	26	20	64	35672
98707	37	23	57	52168
126527	58	22	61	53933
136781	35	21	71	34474
105863	24	12	43	43753
38775	18	9	18	36456
179984	37	32	103	51183
164808	86	24	76	52742
19349	13	1	0	3895
146824	20	24	83	37076
108660	32	22	70	24079
43803	8	4	4	2325
47062	38	15	41	29354
110845	45	21	57	30341
92517	24	23	52	18992
58660	23	12	24	15292
27676	2	16	17	5842
98550	52	24	89	28918
43284	5	9	20	3738
0	0	0	0	0
66016	43	22	45	95352
57359	18	17	63	37478
96933	41	18	48	26839
70369	45	21	70	26783
65494	29	17	32	33392
3616	0	0	0	0
0	0	0	0	0
143931	32	20	72	25446
109894	58	26	56	59847
122973	17	26	64	28162
84336	24	20	77	33298
43410	7	1	3	2781
136250	62	24	73	37121
79015	30	14	37	22698
92937	49	26	54	27615
57586	3	12	32	32689
19764	10	2	4	5752
105757	42	16	55	23164
97213	18	22	81	20304
113402	40	28	90	34409
11796	1	2	1	0
7627	0	0	0	0
121085	29	17	38	92538
6836	0	1	0	0
139563	46	17	36	46037
5118	5	0	0	0
40248	8	4	7	5444
0	0	0	0	0
95079	21	25	75	23924
80750	21	26	52	52230
7131	0	0	0	0
4194	0	0	0	0
60378	15	15	45	8019
96971	40	18	60	34542
83484	17	19	48	21157




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=155037&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=155037&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155037&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.7978
R-squared0.6365
RMSE35524.2325

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7978[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6365[/C][/ROW]
[ROW][C]RMSE[/C][C]35524.2325[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155037&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155037&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.7978
R-squared0.6365
RMSE35524.2325







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
112747691305.9062536170.09375
213035891305.9062539052.09375
372154401.363636363642813.63636363636
41128611111871674
5210171176531.31578947433639.6842105263
6393802176531.315789474217270.684210526
711760491305.9062526298.09375
8126029176531.315789474-50502.3157894737
999729111187-11458
10256310176531.31578947479778.6842105263
111130661111871879
12156212176531.315789474-20319.3157894737
136995291305.90625-21353.90625
14152673132029.54285714320643.4571428571
1512584111118714654
1612576911118714582
17123467176531.315789474-53064.3157894737
185623265933.0666666667-9701.06666666667
19108244132029.542857143-23785.5428571429
202276230418.9-7656.9
214855465933.0666666667-17379.0666666667
22178697176531.3157894742165.68421052632
2314085791305.9062549551.09375
249377391305.906252467.09375
2513339811118722211
2611393391305.9062522627.09375
27144781132029.54285714312751.4571428571
28140711176531.315789474-35820.3157894737
29283337132029.542857143151307.457142857
3015814611118746959
31123344132029.542857143-8685.54285714286
3215764011118746453
3391279111187-19908
34189374176531.31578947412842.6842105263
35167915132029.54285714335885.4571428571
3604401.36363636364-4401.36363636364
37175403132029.54285714343373.4571428571
3892342111187-18845
39100023132029.542857143-32006.5428571429
40178277176531.3157894741745.68421052632
41145062176531.315789474-31469.3157894737
42110980132029.542857143-21049.5428571429
4386039132029.542857143-45990.5428571429
441208211111879634
4595535132029.542857143-36494.5428571429
4610989491305.9062518588.09375
476155465933.0666666667-4379.06666666667
48156520132029.54285714324490.4571428571
49159121132029.54285714327091.4571428571
50129362132029.542857143-2667.54285714286
514818865933.0666666667-17745.0666666667
5295461111187-15726
53229864176531.31578947453332.6842105263
54180317132029.54285714348287.4571428571
55150640132029.54285714318610.4571428571
5610441691305.9062513110.09375
5716509811118753911
586320591305.90625-28100.90625
59100056132029.542857143-31973.5428571429
60137214132029.5428571435184.45714285714
6199630132029.542857143-32399.5428571429
628455791305.90625-6748.90625
639119991305.90625-106.90625
648341991305.90625-7886.90625
6510172365933.066666666735789.9333333333
6694982132029.542857143-37047.5428571429
67129700132029.542857143-2329.54285714286
68110708176531.315789474-65823.3157894737
698151891305.90625-9787.90625
703197065933.0666666667-33963.0666666667
71192268176531.31578947415736.6842105263
728761191305.90625-3694.90625
7377890111187-33297
748326191305.90625-8044.90625
75116290132029.542857143-15739.5428571429
765654465933.0666666667-9389.06666666667
77116173132029.542857143-15856.5428571429
78111488132029.542857143-20541.5428571429
796013865933.0666666667-5795.06666666667
807342291305.90625-17883.90625
8167751111187-43436
82213351132029.54285714381321.4571428571
835118591305.90625-40120.90625
849718191305.906255875.09375
854510065933.0666666667-20833.0666666667
8611580191305.9062524495.09375
87185664176531.3157894749132.68421052632
887196091305.90625-19345.90625
897644191305.90625-14864.90625
9010361391305.9062512307.09375
919870791305.906257401.09375
92126527176531.315789474-50004.3157894737
93136781132029.5428571434751.45714285714
9410586391305.9062514557.09375
953877530418.98356.1
96179984132029.54285714347954.4571428571
97164808176531.315789474-11723.3157894737
981934930418.9-11069.9
99146824132029.54285714314794.4571428571
100108660132029.542857143-23369.5428571429
1014380330418.913384.1
1024706291305.90625-44243.90625
103110845111187-342
1049251791305.906251211.09375
1055866091305.90625-32645.90625
1062767630418.9-2742.9
10798550132029.542857143-33479.5428571429
1084328430418.912865.1
10904401.36363636364-4401.36363636364
11066016111187-45171
1115735965933.0666666667-8574.06666666667
11296933111187-14254
11370369132029.542857143-61660.5428571429
1146549491305.90625-25811.90625
11536164401.36363636364-785.363636363636
11604401.36363636364-4401.36363636364
117143931132029.54285714311901.4571428571
118109894176531.315789474-66637.3157894737
11912297365933.066666666757039.9333333333
12084336132029.542857143-47693.5428571429
1214341030418.912991.1
122136250176531.315789474-40281.3157894737
1237901591305.90625-12290.90625
12492937111187-18250
1255758665933.0666666667-8347.06666666667
1261976430418.9-10654.9
127105757111187-5430
1289721365933.066666666731279.9333333333
129113402132029.542857143-18627.5428571429
130117964401.363636363647394.63636363636
13176274401.363636363643225.63636363636
13212108591305.9062529779.09375
13368364401.363636363642434.63636363636
13413956311118728376
135511830418.9-25300.9
1364024830418.99829.1
13704401.36363636364-4401.36363636364
13895079132029.542857143-36950.5428571429
1398075091305.90625-10555.90625
14071314401.363636363642729.63636363636
14141944401.36363636364-207.363636363636
1426037865933.0666666667-5555.06666666667
14396971111187-14216
1448348465933.066666666717550.9333333333

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 127476 & 91305.90625 & 36170.09375 \tabularnewline
2 & 130358 & 91305.90625 & 39052.09375 \tabularnewline
3 & 7215 & 4401.36363636364 & 2813.63636363636 \tabularnewline
4 & 112861 & 111187 & 1674 \tabularnewline
5 & 210171 & 176531.315789474 & 33639.6842105263 \tabularnewline
6 & 393802 & 176531.315789474 & 217270.684210526 \tabularnewline
7 & 117604 & 91305.90625 & 26298.09375 \tabularnewline
8 & 126029 & 176531.315789474 & -50502.3157894737 \tabularnewline
9 & 99729 & 111187 & -11458 \tabularnewline
10 & 256310 & 176531.315789474 & 79778.6842105263 \tabularnewline
11 & 113066 & 111187 & 1879 \tabularnewline
12 & 156212 & 176531.315789474 & -20319.3157894737 \tabularnewline
13 & 69952 & 91305.90625 & -21353.90625 \tabularnewline
14 & 152673 & 132029.542857143 & 20643.4571428571 \tabularnewline
15 & 125841 & 111187 & 14654 \tabularnewline
16 & 125769 & 111187 & 14582 \tabularnewline
17 & 123467 & 176531.315789474 & -53064.3157894737 \tabularnewline
18 & 56232 & 65933.0666666667 & -9701.06666666667 \tabularnewline
19 & 108244 & 132029.542857143 & -23785.5428571429 \tabularnewline
20 & 22762 & 30418.9 & -7656.9 \tabularnewline
21 & 48554 & 65933.0666666667 & -17379.0666666667 \tabularnewline
22 & 178697 & 176531.315789474 & 2165.68421052632 \tabularnewline
23 & 140857 & 91305.90625 & 49551.09375 \tabularnewline
24 & 93773 & 91305.90625 & 2467.09375 \tabularnewline
25 & 133398 & 111187 & 22211 \tabularnewline
26 & 113933 & 91305.90625 & 22627.09375 \tabularnewline
27 & 144781 & 132029.542857143 & 12751.4571428571 \tabularnewline
28 & 140711 & 176531.315789474 & -35820.3157894737 \tabularnewline
29 & 283337 & 132029.542857143 & 151307.457142857 \tabularnewline
30 & 158146 & 111187 & 46959 \tabularnewline
31 & 123344 & 132029.542857143 & -8685.54285714286 \tabularnewline
32 & 157640 & 111187 & 46453 \tabularnewline
33 & 91279 & 111187 & -19908 \tabularnewline
34 & 189374 & 176531.315789474 & 12842.6842105263 \tabularnewline
35 & 167915 & 132029.542857143 & 35885.4571428571 \tabularnewline
36 & 0 & 4401.36363636364 & -4401.36363636364 \tabularnewline
37 & 175403 & 132029.542857143 & 43373.4571428571 \tabularnewline
38 & 92342 & 111187 & -18845 \tabularnewline
39 & 100023 & 132029.542857143 & -32006.5428571429 \tabularnewline
40 & 178277 & 176531.315789474 & 1745.68421052632 \tabularnewline
41 & 145062 & 176531.315789474 & -31469.3157894737 \tabularnewline
42 & 110980 & 132029.542857143 & -21049.5428571429 \tabularnewline
43 & 86039 & 132029.542857143 & -45990.5428571429 \tabularnewline
44 & 120821 & 111187 & 9634 \tabularnewline
45 & 95535 & 132029.542857143 & -36494.5428571429 \tabularnewline
46 & 109894 & 91305.90625 & 18588.09375 \tabularnewline
47 & 61554 & 65933.0666666667 & -4379.06666666667 \tabularnewline
48 & 156520 & 132029.542857143 & 24490.4571428571 \tabularnewline
49 & 159121 & 132029.542857143 & 27091.4571428571 \tabularnewline
50 & 129362 & 132029.542857143 & -2667.54285714286 \tabularnewline
51 & 48188 & 65933.0666666667 & -17745.0666666667 \tabularnewline
52 & 95461 & 111187 & -15726 \tabularnewline
53 & 229864 & 176531.315789474 & 53332.6842105263 \tabularnewline
54 & 180317 & 132029.542857143 & 48287.4571428571 \tabularnewline
55 & 150640 & 132029.542857143 & 18610.4571428571 \tabularnewline
56 & 104416 & 91305.90625 & 13110.09375 \tabularnewline
57 & 165098 & 111187 & 53911 \tabularnewline
58 & 63205 & 91305.90625 & -28100.90625 \tabularnewline
59 & 100056 & 132029.542857143 & -31973.5428571429 \tabularnewline
60 & 137214 & 132029.542857143 & 5184.45714285714 \tabularnewline
61 & 99630 & 132029.542857143 & -32399.5428571429 \tabularnewline
62 & 84557 & 91305.90625 & -6748.90625 \tabularnewline
63 & 91199 & 91305.90625 & -106.90625 \tabularnewline
64 & 83419 & 91305.90625 & -7886.90625 \tabularnewline
65 & 101723 & 65933.0666666667 & 35789.9333333333 \tabularnewline
66 & 94982 & 132029.542857143 & -37047.5428571429 \tabularnewline
67 & 129700 & 132029.542857143 & -2329.54285714286 \tabularnewline
68 & 110708 & 176531.315789474 & -65823.3157894737 \tabularnewline
69 & 81518 & 91305.90625 & -9787.90625 \tabularnewline
70 & 31970 & 65933.0666666667 & -33963.0666666667 \tabularnewline
71 & 192268 & 176531.315789474 & 15736.6842105263 \tabularnewline
72 & 87611 & 91305.90625 & -3694.90625 \tabularnewline
73 & 77890 & 111187 & -33297 \tabularnewline
74 & 83261 & 91305.90625 & -8044.90625 \tabularnewline
75 & 116290 & 132029.542857143 & -15739.5428571429 \tabularnewline
76 & 56544 & 65933.0666666667 & -9389.06666666667 \tabularnewline
77 & 116173 & 132029.542857143 & -15856.5428571429 \tabularnewline
78 & 111488 & 132029.542857143 & -20541.5428571429 \tabularnewline
79 & 60138 & 65933.0666666667 & -5795.06666666667 \tabularnewline
80 & 73422 & 91305.90625 & -17883.90625 \tabularnewline
81 & 67751 & 111187 & -43436 \tabularnewline
82 & 213351 & 132029.542857143 & 81321.4571428571 \tabularnewline
83 & 51185 & 91305.90625 & -40120.90625 \tabularnewline
84 & 97181 & 91305.90625 & 5875.09375 \tabularnewline
85 & 45100 & 65933.0666666667 & -20833.0666666667 \tabularnewline
86 & 115801 & 91305.90625 & 24495.09375 \tabularnewline
87 & 185664 & 176531.315789474 & 9132.68421052632 \tabularnewline
88 & 71960 & 91305.90625 & -19345.90625 \tabularnewline
89 & 76441 & 91305.90625 & -14864.90625 \tabularnewline
90 & 103613 & 91305.90625 & 12307.09375 \tabularnewline
91 & 98707 & 91305.90625 & 7401.09375 \tabularnewline
92 & 126527 & 176531.315789474 & -50004.3157894737 \tabularnewline
93 & 136781 & 132029.542857143 & 4751.45714285714 \tabularnewline
94 & 105863 & 91305.90625 & 14557.09375 \tabularnewline
95 & 38775 & 30418.9 & 8356.1 \tabularnewline
96 & 179984 & 132029.542857143 & 47954.4571428571 \tabularnewline
97 & 164808 & 176531.315789474 & -11723.3157894737 \tabularnewline
98 & 19349 & 30418.9 & -11069.9 \tabularnewline
99 & 146824 & 132029.542857143 & 14794.4571428571 \tabularnewline
100 & 108660 & 132029.542857143 & -23369.5428571429 \tabularnewline
101 & 43803 & 30418.9 & 13384.1 \tabularnewline
102 & 47062 & 91305.90625 & -44243.90625 \tabularnewline
103 & 110845 & 111187 & -342 \tabularnewline
104 & 92517 & 91305.90625 & 1211.09375 \tabularnewline
105 & 58660 & 91305.90625 & -32645.90625 \tabularnewline
106 & 27676 & 30418.9 & -2742.9 \tabularnewline
107 & 98550 & 132029.542857143 & -33479.5428571429 \tabularnewline
108 & 43284 & 30418.9 & 12865.1 \tabularnewline
109 & 0 & 4401.36363636364 & -4401.36363636364 \tabularnewline
110 & 66016 & 111187 & -45171 \tabularnewline
111 & 57359 & 65933.0666666667 & -8574.06666666667 \tabularnewline
112 & 96933 & 111187 & -14254 \tabularnewline
113 & 70369 & 132029.542857143 & -61660.5428571429 \tabularnewline
114 & 65494 & 91305.90625 & -25811.90625 \tabularnewline
115 & 3616 & 4401.36363636364 & -785.363636363636 \tabularnewline
116 & 0 & 4401.36363636364 & -4401.36363636364 \tabularnewline
117 & 143931 & 132029.542857143 & 11901.4571428571 \tabularnewline
118 & 109894 & 176531.315789474 & -66637.3157894737 \tabularnewline
119 & 122973 & 65933.0666666667 & 57039.9333333333 \tabularnewline
120 & 84336 & 132029.542857143 & -47693.5428571429 \tabularnewline
121 & 43410 & 30418.9 & 12991.1 \tabularnewline
122 & 136250 & 176531.315789474 & -40281.3157894737 \tabularnewline
123 & 79015 & 91305.90625 & -12290.90625 \tabularnewline
124 & 92937 & 111187 & -18250 \tabularnewline
125 & 57586 & 65933.0666666667 & -8347.06666666667 \tabularnewline
126 & 19764 & 30418.9 & -10654.9 \tabularnewline
127 & 105757 & 111187 & -5430 \tabularnewline
128 & 97213 & 65933.0666666667 & 31279.9333333333 \tabularnewline
129 & 113402 & 132029.542857143 & -18627.5428571429 \tabularnewline
130 & 11796 & 4401.36363636364 & 7394.63636363636 \tabularnewline
131 & 7627 & 4401.36363636364 & 3225.63636363636 \tabularnewline
132 & 121085 & 91305.90625 & 29779.09375 \tabularnewline
133 & 6836 & 4401.36363636364 & 2434.63636363636 \tabularnewline
134 & 139563 & 111187 & 28376 \tabularnewline
135 & 5118 & 30418.9 & -25300.9 \tabularnewline
136 & 40248 & 30418.9 & 9829.1 \tabularnewline
137 & 0 & 4401.36363636364 & -4401.36363636364 \tabularnewline
138 & 95079 & 132029.542857143 & -36950.5428571429 \tabularnewline
139 & 80750 & 91305.90625 & -10555.90625 \tabularnewline
140 & 7131 & 4401.36363636364 & 2729.63636363636 \tabularnewline
141 & 4194 & 4401.36363636364 & -207.363636363636 \tabularnewline
142 & 60378 & 65933.0666666667 & -5555.06666666667 \tabularnewline
143 & 96971 & 111187 & -14216 \tabularnewline
144 & 83484 & 65933.0666666667 & 17550.9333333333 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155037&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]127476[/C][C]91305.90625[/C][C]36170.09375[/C][/ROW]
[ROW][C]2[/C][C]130358[/C][C]91305.90625[/C][C]39052.09375[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]4401.36363636364[/C][C]2813.63636363636[/C][/ROW]
[ROW][C]4[/C][C]112861[/C][C]111187[/C][C]1674[/C][/ROW]
[ROW][C]5[/C][C]210171[/C][C]176531.315789474[/C][C]33639.6842105263[/C][/ROW]
[ROW][C]6[/C][C]393802[/C][C]176531.315789474[/C][C]217270.684210526[/C][/ROW]
[ROW][C]7[/C][C]117604[/C][C]91305.90625[/C][C]26298.09375[/C][/ROW]
[ROW][C]8[/C][C]126029[/C][C]176531.315789474[/C][C]-50502.3157894737[/C][/ROW]
[ROW][C]9[/C][C]99729[/C][C]111187[/C][C]-11458[/C][/ROW]
[ROW][C]10[/C][C]256310[/C][C]176531.315789474[/C][C]79778.6842105263[/C][/ROW]
[ROW][C]11[/C][C]113066[/C][C]111187[/C][C]1879[/C][/ROW]
[ROW][C]12[/C][C]156212[/C][C]176531.315789474[/C][C]-20319.3157894737[/C][/ROW]
[ROW][C]13[/C][C]69952[/C][C]91305.90625[/C][C]-21353.90625[/C][/ROW]
[ROW][C]14[/C][C]152673[/C][C]132029.542857143[/C][C]20643.4571428571[/C][/ROW]
[ROW][C]15[/C][C]125841[/C][C]111187[/C][C]14654[/C][/ROW]
[ROW][C]16[/C][C]125769[/C][C]111187[/C][C]14582[/C][/ROW]
[ROW][C]17[/C][C]123467[/C][C]176531.315789474[/C][C]-53064.3157894737[/C][/ROW]
[ROW][C]18[/C][C]56232[/C][C]65933.0666666667[/C][C]-9701.06666666667[/C][/ROW]
[ROW][C]19[/C][C]108244[/C][C]132029.542857143[/C][C]-23785.5428571429[/C][/ROW]
[ROW][C]20[/C][C]22762[/C][C]30418.9[/C][C]-7656.9[/C][/ROW]
[ROW][C]21[/C][C]48554[/C][C]65933.0666666667[/C][C]-17379.0666666667[/C][/ROW]
[ROW][C]22[/C][C]178697[/C][C]176531.315789474[/C][C]2165.68421052632[/C][/ROW]
[ROW][C]23[/C][C]140857[/C][C]91305.90625[/C][C]49551.09375[/C][/ROW]
[ROW][C]24[/C][C]93773[/C][C]91305.90625[/C][C]2467.09375[/C][/ROW]
[ROW][C]25[/C][C]133398[/C][C]111187[/C][C]22211[/C][/ROW]
[ROW][C]26[/C][C]113933[/C][C]91305.90625[/C][C]22627.09375[/C][/ROW]
[ROW][C]27[/C][C]144781[/C][C]132029.542857143[/C][C]12751.4571428571[/C][/ROW]
[ROW][C]28[/C][C]140711[/C][C]176531.315789474[/C][C]-35820.3157894737[/C][/ROW]
[ROW][C]29[/C][C]283337[/C][C]132029.542857143[/C][C]151307.457142857[/C][/ROW]
[ROW][C]30[/C][C]158146[/C][C]111187[/C][C]46959[/C][/ROW]
[ROW][C]31[/C][C]123344[/C][C]132029.542857143[/C][C]-8685.54285714286[/C][/ROW]
[ROW][C]32[/C][C]157640[/C][C]111187[/C][C]46453[/C][/ROW]
[ROW][C]33[/C][C]91279[/C][C]111187[/C][C]-19908[/C][/ROW]
[ROW][C]34[/C][C]189374[/C][C]176531.315789474[/C][C]12842.6842105263[/C][/ROW]
[ROW][C]35[/C][C]167915[/C][C]132029.542857143[/C][C]35885.4571428571[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]4401.36363636364[/C][C]-4401.36363636364[/C][/ROW]
[ROW][C]37[/C][C]175403[/C][C]132029.542857143[/C][C]43373.4571428571[/C][/ROW]
[ROW][C]38[/C][C]92342[/C][C]111187[/C][C]-18845[/C][/ROW]
[ROW][C]39[/C][C]100023[/C][C]132029.542857143[/C][C]-32006.5428571429[/C][/ROW]
[ROW][C]40[/C][C]178277[/C][C]176531.315789474[/C][C]1745.68421052632[/C][/ROW]
[ROW][C]41[/C][C]145062[/C][C]176531.315789474[/C][C]-31469.3157894737[/C][/ROW]
[ROW][C]42[/C][C]110980[/C][C]132029.542857143[/C][C]-21049.5428571429[/C][/ROW]
[ROW][C]43[/C][C]86039[/C][C]132029.542857143[/C][C]-45990.5428571429[/C][/ROW]
[ROW][C]44[/C][C]120821[/C][C]111187[/C][C]9634[/C][/ROW]
[ROW][C]45[/C][C]95535[/C][C]132029.542857143[/C][C]-36494.5428571429[/C][/ROW]
[ROW][C]46[/C][C]109894[/C][C]91305.90625[/C][C]18588.09375[/C][/ROW]
[ROW][C]47[/C][C]61554[/C][C]65933.0666666667[/C][C]-4379.06666666667[/C][/ROW]
[ROW][C]48[/C][C]156520[/C][C]132029.542857143[/C][C]24490.4571428571[/C][/ROW]
[ROW][C]49[/C][C]159121[/C][C]132029.542857143[/C][C]27091.4571428571[/C][/ROW]
[ROW][C]50[/C][C]129362[/C][C]132029.542857143[/C][C]-2667.54285714286[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]65933.0666666667[/C][C]-17745.0666666667[/C][/ROW]
[ROW][C]52[/C][C]95461[/C][C]111187[/C][C]-15726[/C][/ROW]
[ROW][C]53[/C][C]229864[/C][C]176531.315789474[/C][C]53332.6842105263[/C][/ROW]
[ROW][C]54[/C][C]180317[/C][C]132029.542857143[/C][C]48287.4571428571[/C][/ROW]
[ROW][C]55[/C][C]150640[/C][C]132029.542857143[/C][C]18610.4571428571[/C][/ROW]
[ROW][C]56[/C][C]104416[/C][C]91305.90625[/C][C]13110.09375[/C][/ROW]
[ROW][C]57[/C][C]165098[/C][C]111187[/C][C]53911[/C][/ROW]
[ROW][C]58[/C][C]63205[/C][C]91305.90625[/C][C]-28100.90625[/C][/ROW]
[ROW][C]59[/C][C]100056[/C][C]132029.542857143[/C][C]-31973.5428571429[/C][/ROW]
[ROW][C]60[/C][C]137214[/C][C]132029.542857143[/C][C]5184.45714285714[/C][/ROW]
[ROW][C]61[/C][C]99630[/C][C]132029.542857143[/C][C]-32399.5428571429[/C][/ROW]
[ROW][C]62[/C][C]84557[/C][C]91305.90625[/C][C]-6748.90625[/C][/ROW]
[ROW][C]63[/C][C]91199[/C][C]91305.90625[/C][C]-106.90625[/C][/ROW]
[ROW][C]64[/C][C]83419[/C][C]91305.90625[/C][C]-7886.90625[/C][/ROW]
[ROW][C]65[/C][C]101723[/C][C]65933.0666666667[/C][C]35789.9333333333[/C][/ROW]
[ROW][C]66[/C][C]94982[/C][C]132029.542857143[/C][C]-37047.5428571429[/C][/ROW]
[ROW][C]67[/C][C]129700[/C][C]132029.542857143[/C][C]-2329.54285714286[/C][/ROW]
[ROW][C]68[/C][C]110708[/C][C]176531.315789474[/C][C]-65823.3157894737[/C][/ROW]
[ROW][C]69[/C][C]81518[/C][C]91305.90625[/C][C]-9787.90625[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]65933.0666666667[/C][C]-33963.0666666667[/C][/ROW]
[ROW][C]71[/C][C]192268[/C][C]176531.315789474[/C][C]15736.6842105263[/C][/ROW]
[ROW][C]72[/C][C]87611[/C][C]91305.90625[/C][C]-3694.90625[/C][/ROW]
[ROW][C]73[/C][C]77890[/C][C]111187[/C][C]-33297[/C][/ROW]
[ROW][C]74[/C][C]83261[/C][C]91305.90625[/C][C]-8044.90625[/C][/ROW]
[ROW][C]75[/C][C]116290[/C][C]132029.542857143[/C][C]-15739.5428571429[/C][/ROW]
[ROW][C]76[/C][C]56544[/C][C]65933.0666666667[/C][C]-9389.06666666667[/C][/ROW]
[ROW][C]77[/C][C]116173[/C][C]132029.542857143[/C][C]-15856.5428571429[/C][/ROW]
[ROW][C]78[/C][C]111488[/C][C]132029.542857143[/C][C]-20541.5428571429[/C][/ROW]
[ROW][C]79[/C][C]60138[/C][C]65933.0666666667[/C][C]-5795.06666666667[/C][/ROW]
[ROW][C]80[/C][C]73422[/C][C]91305.90625[/C][C]-17883.90625[/C][/ROW]
[ROW][C]81[/C][C]67751[/C][C]111187[/C][C]-43436[/C][/ROW]
[ROW][C]82[/C][C]213351[/C][C]132029.542857143[/C][C]81321.4571428571[/C][/ROW]
[ROW][C]83[/C][C]51185[/C][C]91305.90625[/C][C]-40120.90625[/C][/ROW]
[ROW][C]84[/C][C]97181[/C][C]91305.90625[/C][C]5875.09375[/C][/ROW]
[ROW][C]85[/C][C]45100[/C][C]65933.0666666667[/C][C]-20833.0666666667[/C][/ROW]
[ROW][C]86[/C][C]115801[/C][C]91305.90625[/C][C]24495.09375[/C][/ROW]
[ROW][C]87[/C][C]185664[/C][C]176531.315789474[/C][C]9132.68421052632[/C][/ROW]
[ROW][C]88[/C][C]71960[/C][C]91305.90625[/C][C]-19345.90625[/C][/ROW]
[ROW][C]89[/C][C]76441[/C][C]91305.90625[/C][C]-14864.90625[/C][/ROW]
[ROW][C]90[/C][C]103613[/C][C]91305.90625[/C][C]12307.09375[/C][/ROW]
[ROW][C]91[/C][C]98707[/C][C]91305.90625[/C][C]7401.09375[/C][/ROW]
[ROW][C]92[/C][C]126527[/C][C]176531.315789474[/C][C]-50004.3157894737[/C][/ROW]
[ROW][C]93[/C][C]136781[/C][C]132029.542857143[/C][C]4751.45714285714[/C][/ROW]
[ROW][C]94[/C][C]105863[/C][C]91305.90625[/C][C]14557.09375[/C][/ROW]
[ROW][C]95[/C][C]38775[/C][C]30418.9[/C][C]8356.1[/C][/ROW]
[ROW][C]96[/C][C]179984[/C][C]132029.542857143[/C][C]47954.4571428571[/C][/ROW]
[ROW][C]97[/C][C]164808[/C][C]176531.315789474[/C][C]-11723.3157894737[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]30418.9[/C][C]-11069.9[/C][/ROW]
[ROW][C]99[/C][C]146824[/C][C]132029.542857143[/C][C]14794.4571428571[/C][/ROW]
[ROW][C]100[/C][C]108660[/C][C]132029.542857143[/C][C]-23369.5428571429[/C][/ROW]
[ROW][C]101[/C][C]43803[/C][C]30418.9[/C][C]13384.1[/C][/ROW]
[ROW][C]102[/C][C]47062[/C][C]91305.90625[/C][C]-44243.90625[/C][/ROW]
[ROW][C]103[/C][C]110845[/C][C]111187[/C][C]-342[/C][/ROW]
[ROW][C]104[/C][C]92517[/C][C]91305.90625[/C][C]1211.09375[/C][/ROW]
[ROW][C]105[/C][C]58660[/C][C]91305.90625[/C][C]-32645.90625[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]30418.9[/C][C]-2742.9[/C][/ROW]
[ROW][C]107[/C][C]98550[/C][C]132029.542857143[/C][C]-33479.5428571429[/C][/ROW]
[ROW][C]108[/C][C]43284[/C][C]30418.9[/C][C]12865.1[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]4401.36363636364[/C][C]-4401.36363636364[/C][/ROW]
[ROW][C]110[/C][C]66016[/C][C]111187[/C][C]-45171[/C][/ROW]
[ROW][C]111[/C][C]57359[/C][C]65933.0666666667[/C][C]-8574.06666666667[/C][/ROW]
[ROW][C]112[/C][C]96933[/C][C]111187[/C][C]-14254[/C][/ROW]
[ROW][C]113[/C][C]70369[/C][C]132029.542857143[/C][C]-61660.5428571429[/C][/ROW]
[ROW][C]114[/C][C]65494[/C][C]91305.90625[/C][C]-25811.90625[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]4401.36363636364[/C][C]-785.363636363636[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]4401.36363636364[/C][C]-4401.36363636364[/C][/ROW]
[ROW][C]117[/C][C]143931[/C][C]132029.542857143[/C][C]11901.4571428571[/C][/ROW]
[ROW][C]118[/C][C]109894[/C][C]176531.315789474[/C][C]-66637.3157894737[/C][/ROW]
[ROW][C]119[/C][C]122973[/C][C]65933.0666666667[/C][C]57039.9333333333[/C][/ROW]
[ROW][C]120[/C][C]84336[/C][C]132029.542857143[/C][C]-47693.5428571429[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]30418.9[/C][C]12991.1[/C][/ROW]
[ROW][C]122[/C][C]136250[/C][C]176531.315789474[/C][C]-40281.3157894737[/C][/ROW]
[ROW][C]123[/C][C]79015[/C][C]91305.90625[/C][C]-12290.90625[/C][/ROW]
[ROW][C]124[/C][C]92937[/C][C]111187[/C][C]-18250[/C][/ROW]
[ROW][C]125[/C][C]57586[/C][C]65933.0666666667[/C][C]-8347.06666666667[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]30418.9[/C][C]-10654.9[/C][/ROW]
[ROW][C]127[/C][C]105757[/C][C]111187[/C][C]-5430[/C][/ROW]
[ROW][C]128[/C][C]97213[/C][C]65933.0666666667[/C][C]31279.9333333333[/C][/ROW]
[ROW][C]129[/C][C]113402[/C][C]132029.542857143[/C][C]-18627.5428571429[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]4401.36363636364[/C][C]7394.63636363636[/C][/ROW]
[ROW][C]131[/C][C]7627[/C][C]4401.36363636364[/C][C]3225.63636363636[/C][/ROW]
[ROW][C]132[/C][C]121085[/C][C]91305.90625[/C][C]29779.09375[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]4401.36363636364[/C][C]2434.63636363636[/C][/ROW]
[ROW][C]134[/C][C]139563[/C][C]111187[/C][C]28376[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]30418.9[/C][C]-25300.9[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]30418.9[/C][C]9829.1[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]4401.36363636364[/C][C]-4401.36363636364[/C][/ROW]
[ROW][C]138[/C][C]95079[/C][C]132029.542857143[/C][C]-36950.5428571429[/C][/ROW]
[ROW][C]139[/C][C]80750[/C][C]91305.90625[/C][C]-10555.90625[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]4401.36363636364[/C][C]2729.63636363636[/C][/ROW]
[ROW][C]141[/C][C]4194[/C][C]4401.36363636364[/C][C]-207.363636363636[/C][/ROW]
[ROW][C]142[/C][C]60378[/C][C]65933.0666666667[/C][C]-5555.06666666667[/C][/ROW]
[ROW][C]143[/C][C]96971[/C][C]111187[/C][C]-14216[/C][/ROW]
[ROW][C]144[/C][C]83484[/C][C]65933.0666666667[/C][C]17550.9333333333[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155037&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155037&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
112747691305.9062536170.09375
213035891305.9062539052.09375
372154401.363636363642813.63636363636
41128611111871674
5210171176531.31578947433639.6842105263
6393802176531.315789474217270.684210526
711760491305.9062526298.09375
8126029176531.315789474-50502.3157894737
999729111187-11458
10256310176531.31578947479778.6842105263
111130661111871879
12156212176531.315789474-20319.3157894737
136995291305.90625-21353.90625
14152673132029.54285714320643.4571428571
1512584111118714654
1612576911118714582
17123467176531.315789474-53064.3157894737
185623265933.0666666667-9701.06666666667
19108244132029.542857143-23785.5428571429
202276230418.9-7656.9
214855465933.0666666667-17379.0666666667
22178697176531.3157894742165.68421052632
2314085791305.9062549551.09375
249377391305.906252467.09375
2513339811118722211
2611393391305.9062522627.09375
27144781132029.54285714312751.4571428571
28140711176531.315789474-35820.3157894737
29283337132029.542857143151307.457142857
3015814611118746959
31123344132029.542857143-8685.54285714286
3215764011118746453
3391279111187-19908
34189374176531.31578947412842.6842105263
35167915132029.54285714335885.4571428571
3604401.36363636364-4401.36363636364
37175403132029.54285714343373.4571428571
3892342111187-18845
39100023132029.542857143-32006.5428571429
40178277176531.3157894741745.68421052632
41145062176531.315789474-31469.3157894737
42110980132029.542857143-21049.5428571429
4386039132029.542857143-45990.5428571429
441208211111879634
4595535132029.542857143-36494.5428571429
4610989491305.9062518588.09375
476155465933.0666666667-4379.06666666667
48156520132029.54285714324490.4571428571
49159121132029.54285714327091.4571428571
50129362132029.542857143-2667.54285714286
514818865933.0666666667-17745.0666666667
5295461111187-15726
53229864176531.31578947453332.6842105263
54180317132029.54285714348287.4571428571
55150640132029.54285714318610.4571428571
5610441691305.9062513110.09375
5716509811118753911
586320591305.90625-28100.90625
59100056132029.542857143-31973.5428571429
60137214132029.5428571435184.45714285714
6199630132029.542857143-32399.5428571429
628455791305.90625-6748.90625
639119991305.90625-106.90625
648341991305.90625-7886.90625
6510172365933.066666666735789.9333333333
6694982132029.542857143-37047.5428571429
67129700132029.542857143-2329.54285714286
68110708176531.315789474-65823.3157894737
698151891305.90625-9787.90625
703197065933.0666666667-33963.0666666667
71192268176531.31578947415736.6842105263
728761191305.90625-3694.90625
7377890111187-33297
748326191305.90625-8044.90625
75116290132029.542857143-15739.5428571429
765654465933.0666666667-9389.06666666667
77116173132029.542857143-15856.5428571429
78111488132029.542857143-20541.5428571429
796013865933.0666666667-5795.06666666667
807342291305.90625-17883.90625
8167751111187-43436
82213351132029.54285714381321.4571428571
835118591305.90625-40120.90625
849718191305.906255875.09375
854510065933.0666666667-20833.0666666667
8611580191305.9062524495.09375
87185664176531.3157894749132.68421052632
887196091305.90625-19345.90625
897644191305.90625-14864.90625
9010361391305.9062512307.09375
919870791305.906257401.09375
92126527176531.315789474-50004.3157894737
93136781132029.5428571434751.45714285714
9410586391305.9062514557.09375
953877530418.98356.1
96179984132029.54285714347954.4571428571
97164808176531.315789474-11723.3157894737
981934930418.9-11069.9
99146824132029.54285714314794.4571428571
100108660132029.542857143-23369.5428571429
1014380330418.913384.1
1024706291305.90625-44243.90625
103110845111187-342
1049251791305.906251211.09375
1055866091305.90625-32645.90625
1062767630418.9-2742.9
10798550132029.542857143-33479.5428571429
1084328430418.912865.1
10904401.36363636364-4401.36363636364
11066016111187-45171
1115735965933.0666666667-8574.06666666667
11296933111187-14254
11370369132029.542857143-61660.5428571429
1146549491305.90625-25811.90625
11536164401.36363636364-785.363636363636
11604401.36363636364-4401.36363636364
117143931132029.54285714311901.4571428571
118109894176531.315789474-66637.3157894737
11912297365933.066666666757039.9333333333
12084336132029.542857143-47693.5428571429
1214341030418.912991.1
122136250176531.315789474-40281.3157894737
1237901591305.90625-12290.90625
12492937111187-18250
1255758665933.0666666667-8347.06666666667
1261976430418.9-10654.9
127105757111187-5430
1289721365933.066666666731279.9333333333
129113402132029.542857143-18627.5428571429
130117964401.363636363647394.63636363636
13176274401.363636363643225.63636363636
13212108591305.9062529779.09375
13368364401.363636363642434.63636363636
13413956311118728376
135511830418.9-25300.9
1364024830418.99829.1
13704401.36363636364-4401.36363636364
13895079132029.542857143-36950.5428571429
1398075091305.90625-10555.90625
14071314401.363636363642729.63636363636
14141944401.36363636364-207.363636363636
1426037865933.0666666667-5555.06666666667
14396971111187-14216
1448348465933.066666666717550.9333333333



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