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 computationTue, 20 Dec 2011 17:58:18 -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/20/t1324422226dmtw2hovc83ey4z.htm/, Retrieved Mon, 20 May 2024 11:44:47 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158334, Retrieved Mon, 20 May 2024 11:44:47 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact86
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [tree] [2011-12-20 22:58:18] [935c692b8d0e827208dbfd6a4efb0528] [Current]
Feedback Forum

Post a new message
Dataseries X:
158258	48	18	63	20465	23975
186930	53	20	56	33629	85634
7215	0	0	0	1423	1929
128162	51	27	63	25629	36294
226974	76	31	116	54002	72255
500344	125	36	138	151036	189748
171007	59	23	71	33287	61834
179835	80	30	107	31172	68167
154581	55	30	50	28113	38462
278960	67	26	79	57803	101219
121844	50	24	58	49830	43270
183086	77	30	91	52143	76183
98796	44	22	41	21055	31476
209322	79	25	91	47007	62157
157125	51	18	61	28735	46261
154565	54	22	74	59147	50063
134198	75	33	131	78950	64483
69128	2	15	45	13497	2341
150680	73	34	110	46154	48149
27997	13	18	41	53249	12743
69919	19	15	37	10726	18743
233044	93	30	84	83700	97057
195820	38	25	67	40400	17675
127994	48	34	69	33797	33106
145433	50	21	58	36205	53311
170864	48	21	60	30165	42754
199655	60	25	88	58534	59056
188633	81	31	75	44663	101621
354266	60	31	98	92556	118120
192399	52	20	67	40078	79572
165753	50	28	84	34711	42744
173721	60	20	58	31076	65931
126739	53	17	35	74608	38575
224762	76	25	74	58092	28795
219428	63	24	89	42009	94440
0	0	0	0	0	0
217267	54	27	75	36022	38229
99706	44	14	39	23333	31972
136733	36	35	101	53349	40071
249965	83	34	135	92596	132480
232951	105	22	76	49598	62797
143755	37	34	118	44093	40429
95734	25	23	76	84205	45545
191416	63	24	65	63369	57568
114820	55	26	97	60132	39019
157625	41	22	67	37403	53866
81293	23	35	63	24460	38345
210040	63	24	96	46456	50210
223771	54	31	112	66616	80947
160344	68	26	75	41554	43461
48188	12	22	39	22346	14812
145235	84	21	63	30874	37819
287839	66	27	93	68701	102738
235223	56	30	76	35728	54509
195583	67	33	117	29010	62956
145942	40	11	30	23110	55411
207309	53	26	65	38844	50611
93764	26	26	78	27084	26692
151985	67	23	87	35139	60056
190545	36	38	85	57476	25155
146414	50	30	111	33277	42840
130794	48	19	60	31141	39358
124234	46	19	53	61281	47241
112718	53	26	67	25820	49611
160817	27	26	90	23284	41833
99070	38	33	100	35378	48930
178653	68	36	135	74990	110600
138708	93	25	71	29653	52235
114408	59	24	75	64622	53986
31970	5	21	42	4157	4105
224494	53	19	42	29245	59331
123328	36	12	8	50008	47796
113504	72	30	86	52338	38302
105932	49	21	41	13310	14063
162203	81	34	118	92901	54414
100098	27	32	91	10956	9903
174768	94	28	102	34241	53987
156752	71	28	89	75043	88937
77269	18	21	46	21152	21928
84971	34	31	60	42249	29487
80522	54	26	69	42005	35334
276525	44	29	95	41152	57596
62974	26	23	17	14399	29750
120296	44	25	61	28263	41029
75555	35	22	55	17215	12416
157988	32	26	55	48140	51158
223247	55	33	124	62897	79935
115019	58	24	73	22883	26552
99602	44	24	73	41622	25807
151804	39	21	67	40715	50620
146005	49	28	66	65897	61467
163444	72	27	75	76542	65292
151517	39	25	83	37477	55516
133686	28	15	55	53216	42006
58128	24	13	27	40911	26273
234325	49	36	115	57021	90248
195576	96	24	76	73116	61476
19349	13	1	0	3895	9604
213189	32	24	83	46609	45108
151672	41	31	90	29351	47232
59117	24	4	4	2325	3439
71931	52	20	56	31747	30553
126653	57	23	63	32665	24751
113552	28	23	52	19249	34458
85338	36	12	24	15292	24649
27676	2	16	17	5842	2342
138522	80	29	105	33994	52739
122417	29	26	20	13018	6245
0	0	0	0	0	0
87592	46	25	51	98177	35381
107205	25	21	76	37941	19595
144664	51	23	59	31032	50848
136540	59	21	70	32683	39443
71894	36	21	38	34545	27023
3616	0	0	0	0	0
0	0	0	0	0	0
175055	38	23	81	27525	61022
144618	68	33	78	66856	63528
152826	28	28	67	28549	34835
113245	36	23	89	38610	37172
43410	7	1	3	2781	13
175762	70	29	87	41211	62548
93634	30	17	48	22698	31334
117426	59	31	66	41194	20839
60493	3	12	32	32689	5084
19764	10	2	4	5752	9927
164062	46	21	70	26757	53229
128144	34	26	94	22527	29877
154959	54	29	91	44810	37310
11796	1	2	1	0	0
10674	0	0	0	0	0
138547	35	18	39	100674	50067
6836	0	1	0	0	0
154135	48	21	45	57786	47708
5118	5	0	0	0	0
40248	8	4	7	5444	6012
0	0	0	0	0	0
120460	36	25	75	28470	27749
88837	21	26	52	61849	47555
7131	0	0	0	0	0
9056	0	4	1	2179	1336
68916	15	17	49	8019	11017
132697	50	21	69	39644	55184
100681	17	22	56	23494	43485




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158334&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'Gertrude Mary Cox' @ cox.wessa.net







Goodness of Fit
Correlation0.87
R-squared0.7568
RMSE36826.4422

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.87[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7568[/C][/ROW]
[ROW][C]RMSE[/C][C]36826.4422[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158334&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158334&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.87
R-squared0.7568
RMSE36826.4422







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1158258120285.537972.5
2186930193611-6681
3721514313.5294117647-7098.52941176471
4128162120285.57876.5
522697419361133363
6500344291237.142857143209106.857142857
7171007193611-22604
8179835193611-13776
9154581150364.2765957454216.72340425532
10278960291237.142857143-12277.1428571428
11121844150364.276595745-28520.2765957447
12183086193611-10525
1398796120285.5-21489.5
1420932219361115711
15157125150364.2765957456760.72340425532
16154565150364.2765957454200.72340425532
17134198193611-59413
186912867124.54545454552003.45454545454
19150680150364.276595745315.723404255317
202799767124.5454545455-39127.5454545455
216991983580.4-13661.4
2223304419361139433
23195820120285.575534.5
24127994120285.57708.5
25145433150364.276595745-4931.27659574468
26170864150364.27659574520499.7234042553
271996551936116044
28188633291237.142857143-102604.142857143
29354266291237.14285714363028.8571428572
30192399193611-1212
31165753150364.27659574515388.7234042553
32173721193611-19890
33126739150364.276595745-23625.2765957447
34224762120285.5104476.5
3521942819361125817
36014313.5294117647-14313.5294117647
37217267150364.27659574566902.7234042553
3899706120285.5-20579.5
39136733150364.276595745-13631.2765957447
40249965291237.142857143-41272.1428571428
4123295119361139340
42143755150364.276595745-6609.27659574468
439573483580.412153.6
44191416193611-2195
45114820150364.276595745-35544.2765957447
46157625150364.2765957457260.72340425532
478129383580.4-2287.39999999999
48210040150364.27659574559675.7234042553
4922377119361130160
50160344150364.2765957459979.72340425532
514818867124.5454545455-18936.5454545455
52145235150364.276595745-5129.27659574468
53287839291237.142857143-3398.14285714284
54235223150364.27659574584858.7234042553
551955831936111972
56145942150364.276595745-4422.27659574468
57207309150364.27659574556944.7234042553
589376483580.410183.6
59151985193611-41626
60190545120285.570259.5
61146414150364.276595745-3950.27659574468
62130794150364.276595745-19570.2765957447
63124234150364.276595745-26130.2765957447
64112718150364.276595745-37646.2765957447
65160817150364.27659574510452.7234042553
6699070150364.276595745-51294.2765957447
67178653291237.142857143-112584.142857143
68138708150364.276595745-11656.2765957447
69114408150364.276595745-35956.2765957447
703197067124.5454545455-35154.5454545455
7122449419361130883
72123328150364.276595745-27036.2765957447
73113504150364.276595745-36860.2765957447
7410593267124.545454545538807.4545454545
75162203150364.27659574511838.7234042553
7610009867124.545454545532973.4545454545
77174768150364.27659574524403.7234042553
78156752193611-36859
797726983580.4-6311.39999999999
8084971120285.5-35314.5
8180522120285.5-39763.5
8227652519361182914
836297483580.4-20606.4
84120296150364.276595745-30068.2765957447
857555567124.54545454558430.45454545454
86157988150364.2765957457623.72340425532
8722324719361129636
88115019120285.5-5266.5
8999602120285.5-20683.5
90151804150364.2765957451439.72340425532
91146005193611-47606
92163444193611-30167
93151517150364.2765957451152.72340425532
94133686150364.276595745-16678.2765957447
955812883580.4-25452.4
9623432519361140714
971955761936111965
981934914313.52941176475035.47058823529
99213189150364.27659574562824.7234042553
100151672150364.2765957451307.72340425532
1015911714313.529411764744803.4705882353
10271931120285.5-48354.5
103126653120285.56367.5
104113552120285.5-6733.5
10585338120285.5-34947.5
1062767667124.5454545455-39448.5454545455
107138522150364.276595745-11842.2765957447
10812241767124.545454545555292.4545454545
109014313.5294117647-14313.5294117647
11087592120285.5-32693.5
11110720583580.423624.6
112144664150364.276595745-5700.27659574468
113136540150364.276595745-13824.2765957447
11471894120285.5-48391.5
115361614313.5294117647-10697.5294117647
116014313.5294117647-14313.5294117647
117175055193611-18556
118144618193611-48993
119152826120285.532540.5
120113245120285.5-7040.5
1214341014313.529411764729096.4705882353
122175762193611-17849
12393634120285.5-26651.5
124117426120285.5-2859.5
1256049367124.5454545455-6631.54545454546
1261976414313.52941176475450.47058823529
127164062150364.27659574513697.7234042553
128128144120285.57858.5
129154959150364.2765957454594.72340425532
1301179614313.5294117647-2517.52941176471
1311067414313.5294117647-3639.52941176471
132138547150364.276595745-11817.2765957447
133683614313.5294117647-7477.52941176471
134154135150364.2765957453770.72340425532
135511814313.5294117647-9195.52941176471
1364024814313.529411764725934.4705882353
137014313.5294117647-14313.5294117647
138120460120285.5174.5
1398883783580.45256.60000000001
140713114313.5294117647-7182.52941176471
141905614313.5294117647-5257.52941176471
1426891667124.54545454551791.45454545454
143132697150364.276595745-17667.2765957447
14410068183580.417100.6

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 158258 & 120285.5 & 37972.5 \tabularnewline
2 & 186930 & 193611 & -6681 \tabularnewline
3 & 7215 & 14313.5294117647 & -7098.52941176471 \tabularnewline
4 & 128162 & 120285.5 & 7876.5 \tabularnewline
5 & 226974 & 193611 & 33363 \tabularnewline
6 & 500344 & 291237.142857143 & 209106.857142857 \tabularnewline
7 & 171007 & 193611 & -22604 \tabularnewline
8 & 179835 & 193611 & -13776 \tabularnewline
9 & 154581 & 150364.276595745 & 4216.72340425532 \tabularnewline
10 & 278960 & 291237.142857143 & -12277.1428571428 \tabularnewline
11 & 121844 & 150364.276595745 & -28520.2765957447 \tabularnewline
12 & 183086 & 193611 & -10525 \tabularnewline
13 & 98796 & 120285.5 & -21489.5 \tabularnewline
14 & 209322 & 193611 & 15711 \tabularnewline
15 & 157125 & 150364.276595745 & 6760.72340425532 \tabularnewline
16 & 154565 & 150364.276595745 & 4200.72340425532 \tabularnewline
17 & 134198 & 193611 & -59413 \tabularnewline
18 & 69128 & 67124.5454545455 & 2003.45454545454 \tabularnewline
19 & 150680 & 150364.276595745 & 315.723404255317 \tabularnewline
20 & 27997 & 67124.5454545455 & -39127.5454545455 \tabularnewline
21 & 69919 & 83580.4 & -13661.4 \tabularnewline
22 & 233044 & 193611 & 39433 \tabularnewline
23 & 195820 & 120285.5 & 75534.5 \tabularnewline
24 & 127994 & 120285.5 & 7708.5 \tabularnewline
25 & 145433 & 150364.276595745 & -4931.27659574468 \tabularnewline
26 & 170864 & 150364.276595745 & 20499.7234042553 \tabularnewline
27 & 199655 & 193611 & 6044 \tabularnewline
28 & 188633 & 291237.142857143 & -102604.142857143 \tabularnewline
29 & 354266 & 291237.142857143 & 63028.8571428572 \tabularnewline
30 & 192399 & 193611 & -1212 \tabularnewline
31 & 165753 & 150364.276595745 & 15388.7234042553 \tabularnewline
32 & 173721 & 193611 & -19890 \tabularnewline
33 & 126739 & 150364.276595745 & -23625.2765957447 \tabularnewline
34 & 224762 & 120285.5 & 104476.5 \tabularnewline
35 & 219428 & 193611 & 25817 \tabularnewline
36 & 0 & 14313.5294117647 & -14313.5294117647 \tabularnewline
37 & 217267 & 150364.276595745 & 66902.7234042553 \tabularnewline
38 & 99706 & 120285.5 & -20579.5 \tabularnewline
39 & 136733 & 150364.276595745 & -13631.2765957447 \tabularnewline
40 & 249965 & 291237.142857143 & -41272.1428571428 \tabularnewline
41 & 232951 & 193611 & 39340 \tabularnewline
42 & 143755 & 150364.276595745 & -6609.27659574468 \tabularnewline
43 & 95734 & 83580.4 & 12153.6 \tabularnewline
44 & 191416 & 193611 & -2195 \tabularnewline
45 & 114820 & 150364.276595745 & -35544.2765957447 \tabularnewline
46 & 157625 & 150364.276595745 & 7260.72340425532 \tabularnewline
47 & 81293 & 83580.4 & -2287.39999999999 \tabularnewline
48 & 210040 & 150364.276595745 & 59675.7234042553 \tabularnewline
49 & 223771 & 193611 & 30160 \tabularnewline
50 & 160344 & 150364.276595745 & 9979.72340425532 \tabularnewline
51 & 48188 & 67124.5454545455 & -18936.5454545455 \tabularnewline
52 & 145235 & 150364.276595745 & -5129.27659574468 \tabularnewline
53 & 287839 & 291237.142857143 & -3398.14285714284 \tabularnewline
54 & 235223 & 150364.276595745 & 84858.7234042553 \tabularnewline
55 & 195583 & 193611 & 1972 \tabularnewline
56 & 145942 & 150364.276595745 & -4422.27659574468 \tabularnewline
57 & 207309 & 150364.276595745 & 56944.7234042553 \tabularnewline
58 & 93764 & 83580.4 & 10183.6 \tabularnewline
59 & 151985 & 193611 & -41626 \tabularnewline
60 & 190545 & 120285.5 & 70259.5 \tabularnewline
61 & 146414 & 150364.276595745 & -3950.27659574468 \tabularnewline
62 & 130794 & 150364.276595745 & -19570.2765957447 \tabularnewline
63 & 124234 & 150364.276595745 & -26130.2765957447 \tabularnewline
64 & 112718 & 150364.276595745 & -37646.2765957447 \tabularnewline
65 & 160817 & 150364.276595745 & 10452.7234042553 \tabularnewline
66 & 99070 & 150364.276595745 & -51294.2765957447 \tabularnewline
67 & 178653 & 291237.142857143 & -112584.142857143 \tabularnewline
68 & 138708 & 150364.276595745 & -11656.2765957447 \tabularnewline
69 & 114408 & 150364.276595745 & -35956.2765957447 \tabularnewline
70 & 31970 & 67124.5454545455 & -35154.5454545455 \tabularnewline
71 & 224494 & 193611 & 30883 \tabularnewline
72 & 123328 & 150364.276595745 & -27036.2765957447 \tabularnewline
73 & 113504 & 150364.276595745 & -36860.2765957447 \tabularnewline
74 & 105932 & 67124.5454545455 & 38807.4545454545 \tabularnewline
75 & 162203 & 150364.276595745 & 11838.7234042553 \tabularnewline
76 & 100098 & 67124.5454545455 & 32973.4545454545 \tabularnewline
77 & 174768 & 150364.276595745 & 24403.7234042553 \tabularnewline
78 & 156752 & 193611 & -36859 \tabularnewline
79 & 77269 & 83580.4 & -6311.39999999999 \tabularnewline
80 & 84971 & 120285.5 & -35314.5 \tabularnewline
81 & 80522 & 120285.5 & -39763.5 \tabularnewline
82 & 276525 & 193611 & 82914 \tabularnewline
83 & 62974 & 83580.4 & -20606.4 \tabularnewline
84 & 120296 & 150364.276595745 & -30068.2765957447 \tabularnewline
85 & 75555 & 67124.5454545455 & 8430.45454545454 \tabularnewline
86 & 157988 & 150364.276595745 & 7623.72340425532 \tabularnewline
87 & 223247 & 193611 & 29636 \tabularnewline
88 & 115019 & 120285.5 & -5266.5 \tabularnewline
89 & 99602 & 120285.5 & -20683.5 \tabularnewline
90 & 151804 & 150364.276595745 & 1439.72340425532 \tabularnewline
91 & 146005 & 193611 & -47606 \tabularnewline
92 & 163444 & 193611 & -30167 \tabularnewline
93 & 151517 & 150364.276595745 & 1152.72340425532 \tabularnewline
94 & 133686 & 150364.276595745 & -16678.2765957447 \tabularnewline
95 & 58128 & 83580.4 & -25452.4 \tabularnewline
96 & 234325 & 193611 & 40714 \tabularnewline
97 & 195576 & 193611 & 1965 \tabularnewline
98 & 19349 & 14313.5294117647 & 5035.47058823529 \tabularnewline
99 & 213189 & 150364.276595745 & 62824.7234042553 \tabularnewline
100 & 151672 & 150364.276595745 & 1307.72340425532 \tabularnewline
101 & 59117 & 14313.5294117647 & 44803.4705882353 \tabularnewline
102 & 71931 & 120285.5 & -48354.5 \tabularnewline
103 & 126653 & 120285.5 & 6367.5 \tabularnewline
104 & 113552 & 120285.5 & -6733.5 \tabularnewline
105 & 85338 & 120285.5 & -34947.5 \tabularnewline
106 & 27676 & 67124.5454545455 & -39448.5454545455 \tabularnewline
107 & 138522 & 150364.276595745 & -11842.2765957447 \tabularnewline
108 & 122417 & 67124.5454545455 & 55292.4545454545 \tabularnewline
109 & 0 & 14313.5294117647 & -14313.5294117647 \tabularnewline
110 & 87592 & 120285.5 & -32693.5 \tabularnewline
111 & 107205 & 83580.4 & 23624.6 \tabularnewline
112 & 144664 & 150364.276595745 & -5700.27659574468 \tabularnewline
113 & 136540 & 150364.276595745 & -13824.2765957447 \tabularnewline
114 & 71894 & 120285.5 & -48391.5 \tabularnewline
115 & 3616 & 14313.5294117647 & -10697.5294117647 \tabularnewline
116 & 0 & 14313.5294117647 & -14313.5294117647 \tabularnewline
117 & 175055 & 193611 & -18556 \tabularnewline
118 & 144618 & 193611 & -48993 \tabularnewline
119 & 152826 & 120285.5 & 32540.5 \tabularnewline
120 & 113245 & 120285.5 & -7040.5 \tabularnewline
121 & 43410 & 14313.5294117647 & 29096.4705882353 \tabularnewline
122 & 175762 & 193611 & -17849 \tabularnewline
123 & 93634 & 120285.5 & -26651.5 \tabularnewline
124 & 117426 & 120285.5 & -2859.5 \tabularnewline
125 & 60493 & 67124.5454545455 & -6631.54545454546 \tabularnewline
126 & 19764 & 14313.5294117647 & 5450.47058823529 \tabularnewline
127 & 164062 & 150364.276595745 & 13697.7234042553 \tabularnewline
128 & 128144 & 120285.5 & 7858.5 \tabularnewline
129 & 154959 & 150364.276595745 & 4594.72340425532 \tabularnewline
130 & 11796 & 14313.5294117647 & -2517.52941176471 \tabularnewline
131 & 10674 & 14313.5294117647 & -3639.52941176471 \tabularnewline
132 & 138547 & 150364.276595745 & -11817.2765957447 \tabularnewline
133 & 6836 & 14313.5294117647 & -7477.52941176471 \tabularnewline
134 & 154135 & 150364.276595745 & 3770.72340425532 \tabularnewline
135 & 5118 & 14313.5294117647 & -9195.52941176471 \tabularnewline
136 & 40248 & 14313.5294117647 & 25934.4705882353 \tabularnewline
137 & 0 & 14313.5294117647 & -14313.5294117647 \tabularnewline
138 & 120460 & 120285.5 & 174.5 \tabularnewline
139 & 88837 & 83580.4 & 5256.60000000001 \tabularnewline
140 & 7131 & 14313.5294117647 & -7182.52941176471 \tabularnewline
141 & 9056 & 14313.5294117647 & -5257.52941176471 \tabularnewline
142 & 68916 & 67124.5454545455 & 1791.45454545454 \tabularnewline
143 & 132697 & 150364.276595745 & -17667.2765957447 \tabularnewline
144 & 100681 & 83580.4 & 17100.6 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158334&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]158258[/C][C]120285.5[/C][C]37972.5[/C][/ROW]
[ROW][C]2[/C][C]186930[/C][C]193611[/C][C]-6681[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]14313.5294117647[/C][C]-7098.52941176471[/C][/ROW]
[ROW][C]4[/C][C]128162[/C][C]120285.5[/C][C]7876.5[/C][/ROW]
[ROW][C]5[/C][C]226974[/C][C]193611[/C][C]33363[/C][/ROW]
[ROW][C]6[/C][C]500344[/C][C]291237.142857143[/C][C]209106.857142857[/C][/ROW]
[ROW][C]7[/C][C]171007[/C][C]193611[/C][C]-22604[/C][/ROW]
[ROW][C]8[/C][C]179835[/C][C]193611[/C][C]-13776[/C][/ROW]
[ROW][C]9[/C][C]154581[/C][C]150364.276595745[/C][C]4216.72340425532[/C][/ROW]
[ROW][C]10[/C][C]278960[/C][C]291237.142857143[/C][C]-12277.1428571428[/C][/ROW]
[ROW][C]11[/C][C]121844[/C][C]150364.276595745[/C][C]-28520.2765957447[/C][/ROW]
[ROW][C]12[/C][C]183086[/C][C]193611[/C][C]-10525[/C][/ROW]
[ROW][C]13[/C][C]98796[/C][C]120285.5[/C][C]-21489.5[/C][/ROW]
[ROW][C]14[/C][C]209322[/C][C]193611[/C][C]15711[/C][/ROW]
[ROW][C]15[/C][C]157125[/C][C]150364.276595745[/C][C]6760.72340425532[/C][/ROW]
[ROW][C]16[/C][C]154565[/C][C]150364.276595745[/C][C]4200.72340425532[/C][/ROW]
[ROW][C]17[/C][C]134198[/C][C]193611[/C][C]-59413[/C][/ROW]
[ROW][C]18[/C][C]69128[/C][C]67124.5454545455[/C][C]2003.45454545454[/C][/ROW]
[ROW][C]19[/C][C]150680[/C][C]150364.276595745[/C][C]315.723404255317[/C][/ROW]
[ROW][C]20[/C][C]27997[/C][C]67124.5454545455[/C][C]-39127.5454545455[/C][/ROW]
[ROW][C]21[/C][C]69919[/C][C]83580.4[/C][C]-13661.4[/C][/ROW]
[ROW][C]22[/C][C]233044[/C][C]193611[/C][C]39433[/C][/ROW]
[ROW][C]23[/C][C]195820[/C][C]120285.5[/C][C]75534.5[/C][/ROW]
[ROW][C]24[/C][C]127994[/C][C]120285.5[/C][C]7708.5[/C][/ROW]
[ROW][C]25[/C][C]145433[/C][C]150364.276595745[/C][C]-4931.27659574468[/C][/ROW]
[ROW][C]26[/C][C]170864[/C][C]150364.276595745[/C][C]20499.7234042553[/C][/ROW]
[ROW][C]27[/C][C]199655[/C][C]193611[/C][C]6044[/C][/ROW]
[ROW][C]28[/C][C]188633[/C][C]291237.142857143[/C][C]-102604.142857143[/C][/ROW]
[ROW][C]29[/C][C]354266[/C][C]291237.142857143[/C][C]63028.8571428572[/C][/ROW]
[ROW][C]30[/C][C]192399[/C][C]193611[/C][C]-1212[/C][/ROW]
[ROW][C]31[/C][C]165753[/C][C]150364.276595745[/C][C]15388.7234042553[/C][/ROW]
[ROW][C]32[/C][C]173721[/C][C]193611[/C][C]-19890[/C][/ROW]
[ROW][C]33[/C][C]126739[/C][C]150364.276595745[/C][C]-23625.2765957447[/C][/ROW]
[ROW][C]34[/C][C]224762[/C][C]120285.5[/C][C]104476.5[/C][/ROW]
[ROW][C]35[/C][C]219428[/C][C]193611[/C][C]25817[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]14313.5294117647[/C][C]-14313.5294117647[/C][/ROW]
[ROW][C]37[/C][C]217267[/C][C]150364.276595745[/C][C]66902.7234042553[/C][/ROW]
[ROW][C]38[/C][C]99706[/C][C]120285.5[/C][C]-20579.5[/C][/ROW]
[ROW][C]39[/C][C]136733[/C][C]150364.276595745[/C][C]-13631.2765957447[/C][/ROW]
[ROW][C]40[/C][C]249965[/C][C]291237.142857143[/C][C]-41272.1428571428[/C][/ROW]
[ROW][C]41[/C][C]232951[/C][C]193611[/C][C]39340[/C][/ROW]
[ROW][C]42[/C][C]143755[/C][C]150364.276595745[/C][C]-6609.27659574468[/C][/ROW]
[ROW][C]43[/C][C]95734[/C][C]83580.4[/C][C]12153.6[/C][/ROW]
[ROW][C]44[/C][C]191416[/C][C]193611[/C][C]-2195[/C][/ROW]
[ROW][C]45[/C][C]114820[/C][C]150364.276595745[/C][C]-35544.2765957447[/C][/ROW]
[ROW][C]46[/C][C]157625[/C][C]150364.276595745[/C][C]7260.72340425532[/C][/ROW]
[ROW][C]47[/C][C]81293[/C][C]83580.4[/C][C]-2287.39999999999[/C][/ROW]
[ROW][C]48[/C][C]210040[/C][C]150364.276595745[/C][C]59675.7234042553[/C][/ROW]
[ROW][C]49[/C][C]223771[/C][C]193611[/C][C]30160[/C][/ROW]
[ROW][C]50[/C][C]160344[/C][C]150364.276595745[/C][C]9979.72340425532[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]67124.5454545455[/C][C]-18936.5454545455[/C][/ROW]
[ROW][C]52[/C][C]145235[/C][C]150364.276595745[/C][C]-5129.27659574468[/C][/ROW]
[ROW][C]53[/C][C]287839[/C][C]291237.142857143[/C][C]-3398.14285714284[/C][/ROW]
[ROW][C]54[/C][C]235223[/C][C]150364.276595745[/C][C]84858.7234042553[/C][/ROW]
[ROW][C]55[/C][C]195583[/C][C]193611[/C][C]1972[/C][/ROW]
[ROW][C]56[/C][C]145942[/C][C]150364.276595745[/C][C]-4422.27659574468[/C][/ROW]
[ROW][C]57[/C][C]207309[/C][C]150364.276595745[/C][C]56944.7234042553[/C][/ROW]
[ROW][C]58[/C][C]93764[/C][C]83580.4[/C][C]10183.6[/C][/ROW]
[ROW][C]59[/C][C]151985[/C][C]193611[/C][C]-41626[/C][/ROW]
[ROW][C]60[/C][C]190545[/C][C]120285.5[/C][C]70259.5[/C][/ROW]
[ROW][C]61[/C][C]146414[/C][C]150364.276595745[/C][C]-3950.27659574468[/C][/ROW]
[ROW][C]62[/C][C]130794[/C][C]150364.276595745[/C][C]-19570.2765957447[/C][/ROW]
[ROW][C]63[/C][C]124234[/C][C]150364.276595745[/C][C]-26130.2765957447[/C][/ROW]
[ROW][C]64[/C][C]112718[/C][C]150364.276595745[/C][C]-37646.2765957447[/C][/ROW]
[ROW][C]65[/C][C]160817[/C][C]150364.276595745[/C][C]10452.7234042553[/C][/ROW]
[ROW][C]66[/C][C]99070[/C][C]150364.276595745[/C][C]-51294.2765957447[/C][/ROW]
[ROW][C]67[/C][C]178653[/C][C]291237.142857143[/C][C]-112584.142857143[/C][/ROW]
[ROW][C]68[/C][C]138708[/C][C]150364.276595745[/C][C]-11656.2765957447[/C][/ROW]
[ROW][C]69[/C][C]114408[/C][C]150364.276595745[/C][C]-35956.2765957447[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]67124.5454545455[/C][C]-35154.5454545455[/C][/ROW]
[ROW][C]71[/C][C]224494[/C][C]193611[/C][C]30883[/C][/ROW]
[ROW][C]72[/C][C]123328[/C][C]150364.276595745[/C][C]-27036.2765957447[/C][/ROW]
[ROW][C]73[/C][C]113504[/C][C]150364.276595745[/C][C]-36860.2765957447[/C][/ROW]
[ROW][C]74[/C][C]105932[/C][C]67124.5454545455[/C][C]38807.4545454545[/C][/ROW]
[ROW][C]75[/C][C]162203[/C][C]150364.276595745[/C][C]11838.7234042553[/C][/ROW]
[ROW][C]76[/C][C]100098[/C][C]67124.5454545455[/C][C]32973.4545454545[/C][/ROW]
[ROW][C]77[/C][C]174768[/C][C]150364.276595745[/C][C]24403.7234042553[/C][/ROW]
[ROW][C]78[/C][C]156752[/C][C]193611[/C][C]-36859[/C][/ROW]
[ROW][C]79[/C][C]77269[/C][C]83580.4[/C][C]-6311.39999999999[/C][/ROW]
[ROW][C]80[/C][C]84971[/C][C]120285.5[/C][C]-35314.5[/C][/ROW]
[ROW][C]81[/C][C]80522[/C][C]120285.5[/C][C]-39763.5[/C][/ROW]
[ROW][C]82[/C][C]276525[/C][C]193611[/C][C]82914[/C][/ROW]
[ROW][C]83[/C][C]62974[/C][C]83580.4[/C][C]-20606.4[/C][/ROW]
[ROW][C]84[/C][C]120296[/C][C]150364.276595745[/C][C]-30068.2765957447[/C][/ROW]
[ROW][C]85[/C][C]75555[/C][C]67124.5454545455[/C][C]8430.45454545454[/C][/ROW]
[ROW][C]86[/C][C]157988[/C][C]150364.276595745[/C][C]7623.72340425532[/C][/ROW]
[ROW][C]87[/C][C]223247[/C][C]193611[/C][C]29636[/C][/ROW]
[ROW][C]88[/C][C]115019[/C][C]120285.5[/C][C]-5266.5[/C][/ROW]
[ROW][C]89[/C][C]99602[/C][C]120285.5[/C][C]-20683.5[/C][/ROW]
[ROW][C]90[/C][C]151804[/C][C]150364.276595745[/C][C]1439.72340425532[/C][/ROW]
[ROW][C]91[/C][C]146005[/C][C]193611[/C][C]-47606[/C][/ROW]
[ROW][C]92[/C][C]163444[/C][C]193611[/C][C]-30167[/C][/ROW]
[ROW][C]93[/C][C]151517[/C][C]150364.276595745[/C][C]1152.72340425532[/C][/ROW]
[ROW][C]94[/C][C]133686[/C][C]150364.276595745[/C][C]-16678.2765957447[/C][/ROW]
[ROW][C]95[/C][C]58128[/C][C]83580.4[/C][C]-25452.4[/C][/ROW]
[ROW][C]96[/C][C]234325[/C][C]193611[/C][C]40714[/C][/ROW]
[ROW][C]97[/C][C]195576[/C][C]193611[/C][C]1965[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]14313.5294117647[/C][C]5035.47058823529[/C][/ROW]
[ROW][C]99[/C][C]213189[/C][C]150364.276595745[/C][C]62824.7234042553[/C][/ROW]
[ROW][C]100[/C][C]151672[/C][C]150364.276595745[/C][C]1307.72340425532[/C][/ROW]
[ROW][C]101[/C][C]59117[/C][C]14313.5294117647[/C][C]44803.4705882353[/C][/ROW]
[ROW][C]102[/C][C]71931[/C][C]120285.5[/C][C]-48354.5[/C][/ROW]
[ROW][C]103[/C][C]126653[/C][C]120285.5[/C][C]6367.5[/C][/ROW]
[ROW][C]104[/C][C]113552[/C][C]120285.5[/C][C]-6733.5[/C][/ROW]
[ROW][C]105[/C][C]85338[/C][C]120285.5[/C][C]-34947.5[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]67124.5454545455[/C][C]-39448.5454545455[/C][/ROW]
[ROW][C]107[/C][C]138522[/C][C]150364.276595745[/C][C]-11842.2765957447[/C][/ROW]
[ROW][C]108[/C][C]122417[/C][C]67124.5454545455[/C][C]55292.4545454545[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]14313.5294117647[/C][C]-14313.5294117647[/C][/ROW]
[ROW][C]110[/C][C]87592[/C][C]120285.5[/C][C]-32693.5[/C][/ROW]
[ROW][C]111[/C][C]107205[/C][C]83580.4[/C][C]23624.6[/C][/ROW]
[ROW][C]112[/C][C]144664[/C][C]150364.276595745[/C][C]-5700.27659574468[/C][/ROW]
[ROW][C]113[/C][C]136540[/C][C]150364.276595745[/C][C]-13824.2765957447[/C][/ROW]
[ROW][C]114[/C][C]71894[/C][C]120285.5[/C][C]-48391.5[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]14313.5294117647[/C][C]-10697.5294117647[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]14313.5294117647[/C][C]-14313.5294117647[/C][/ROW]
[ROW][C]117[/C][C]175055[/C][C]193611[/C][C]-18556[/C][/ROW]
[ROW][C]118[/C][C]144618[/C][C]193611[/C][C]-48993[/C][/ROW]
[ROW][C]119[/C][C]152826[/C][C]120285.5[/C][C]32540.5[/C][/ROW]
[ROW][C]120[/C][C]113245[/C][C]120285.5[/C][C]-7040.5[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]14313.5294117647[/C][C]29096.4705882353[/C][/ROW]
[ROW][C]122[/C][C]175762[/C][C]193611[/C][C]-17849[/C][/ROW]
[ROW][C]123[/C][C]93634[/C][C]120285.5[/C][C]-26651.5[/C][/ROW]
[ROW][C]124[/C][C]117426[/C][C]120285.5[/C][C]-2859.5[/C][/ROW]
[ROW][C]125[/C][C]60493[/C][C]67124.5454545455[/C][C]-6631.54545454546[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]14313.5294117647[/C][C]5450.47058823529[/C][/ROW]
[ROW][C]127[/C][C]164062[/C][C]150364.276595745[/C][C]13697.7234042553[/C][/ROW]
[ROW][C]128[/C][C]128144[/C][C]120285.5[/C][C]7858.5[/C][/ROW]
[ROW][C]129[/C][C]154959[/C][C]150364.276595745[/C][C]4594.72340425532[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]14313.5294117647[/C][C]-2517.52941176471[/C][/ROW]
[ROW][C]131[/C][C]10674[/C][C]14313.5294117647[/C][C]-3639.52941176471[/C][/ROW]
[ROW][C]132[/C][C]138547[/C][C]150364.276595745[/C][C]-11817.2765957447[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]14313.5294117647[/C][C]-7477.52941176471[/C][/ROW]
[ROW][C]134[/C][C]154135[/C][C]150364.276595745[/C][C]3770.72340425532[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]14313.5294117647[/C][C]-9195.52941176471[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]14313.5294117647[/C][C]25934.4705882353[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]14313.5294117647[/C][C]-14313.5294117647[/C][/ROW]
[ROW][C]138[/C][C]120460[/C][C]120285.5[/C][C]174.5[/C][/ROW]
[ROW][C]139[/C][C]88837[/C][C]83580.4[/C][C]5256.60000000001[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]14313.5294117647[/C][C]-7182.52941176471[/C][/ROW]
[ROW][C]141[/C][C]9056[/C][C]14313.5294117647[/C][C]-5257.52941176471[/C][/ROW]
[ROW][C]142[/C][C]68916[/C][C]67124.5454545455[/C][C]1791.45454545454[/C][/ROW]
[ROW][C]143[/C][C]132697[/C][C]150364.276595745[/C][C]-17667.2765957447[/C][/ROW]
[ROW][C]144[/C][C]100681[/C][C]83580.4[/C][C]17100.6[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158334&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158334&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
1158258120285.537972.5
2186930193611-6681
3721514313.5294117647-7098.52941176471
4128162120285.57876.5
522697419361133363
6500344291237.142857143209106.857142857
7171007193611-22604
8179835193611-13776
9154581150364.2765957454216.72340425532
10278960291237.142857143-12277.1428571428
11121844150364.276595745-28520.2765957447
12183086193611-10525
1398796120285.5-21489.5
1420932219361115711
15157125150364.2765957456760.72340425532
16154565150364.2765957454200.72340425532
17134198193611-59413
186912867124.54545454552003.45454545454
19150680150364.276595745315.723404255317
202799767124.5454545455-39127.5454545455
216991983580.4-13661.4
2223304419361139433
23195820120285.575534.5
24127994120285.57708.5
25145433150364.276595745-4931.27659574468
26170864150364.27659574520499.7234042553
271996551936116044
28188633291237.142857143-102604.142857143
29354266291237.14285714363028.8571428572
30192399193611-1212
31165753150364.27659574515388.7234042553
32173721193611-19890
33126739150364.276595745-23625.2765957447
34224762120285.5104476.5
3521942819361125817
36014313.5294117647-14313.5294117647
37217267150364.27659574566902.7234042553
3899706120285.5-20579.5
39136733150364.276595745-13631.2765957447
40249965291237.142857143-41272.1428571428
4123295119361139340
42143755150364.276595745-6609.27659574468
439573483580.412153.6
44191416193611-2195
45114820150364.276595745-35544.2765957447
46157625150364.2765957457260.72340425532
478129383580.4-2287.39999999999
48210040150364.27659574559675.7234042553
4922377119361130160
50160344150364.2765957459979.72340425532
514818867124.5454545455-18936.5454545455
52145235150364.276595745-5129.27659574468
53287839291237.142857143-3398.14285714284
54235223150364.27659574584858.7234042553
551955831936111972
56145942150364.276595745-4422.27659574468
57207309150364.27659574556944.7234042553
589376483580.410183.6
59151985193611-41626
60190545120285.570259.5
61146414150364.276595745-3950.27659574468
62130794150364.276595745-19570.2765957447
63124234150364.276595745-26130.2765957447
64112718150364.276595745-37646.2765957447
65160817150364.27659574510452.7234042553
6699070150364.276595745-51294.2765957447
67178653291237.142857143-112584.142857143
68138708150364.276595745-11656.2765957447
69114408150364.276595745-35956.2765957447
703197067124.5454545455-35154.5454545455
7122449419361130883
72123328150364.276595745-27036.2765957447
73113504150364.276595745-36860.2765957447
7410593267124.545454545538807.4545454545
75162203150364.27659574511838.7234042553
7610009867124.545454545532973.4545454545
77174768150364.27659574524403.7234042553
78156752193611-36859
797726983580.4-6311.39999999999
8084971120285.5-35314.5
8180522120285.5-39763.5
8227652519361182914
836297483580.4-20606.4
84120296150364.276595745-30068.2765957447
857555567124.54545454558430.45454545454
86157988150364.2765957457623.72340425532
8722324719361129636
88115019120285.5-5266.5
8999602120285.5-20683.5
90151804150364.2765957451439.72340425532
91146005193611-47606
92163444193611-30167
93151517150364.2765957451152.72340425532
94133686150364.276595745-16678.2765957447
955812883580.4-25452.4
9623432519361140714
971955761936111965
981934914313.52941176475035.47058823529
99213189150364.27659574562824.7234042553
100151672150364.2765957451307.72340425532
1015911714313.529411764744803.4705882353
10271931120285.5-48354.5
103126653120285.56367.5
104113552120285.5-6733.5
10585338120285.5-34947.5
1062767667124.5454545455-39448.5454545455
107138522150364.276595745-11842.2765957447
10812241767124.545454545555292.4545454545
109014313.5294117647-14313.5294117647
11087592120285.5-32693.5
11110720583580.423624.6
112144664150364.276595745-5700.27659574468
113136540150364.276595745-13824.2765957447
11471894120285.5-48391.5
115361614313.5294117647-10697.5294117647
116014313.5294117647-14313.5294117647
117175055193611-18556
118144618193611-48993
119152826120285.532540.5
120113245120285.5-7040.5
1214341014313.529411764729096.4705882353
122175762193611-17849
12393634120285.5-26651.5
124117426120285.5-2859.5
1256049367124.5454545455-6631.54545454546
1261976414313.52941176475450.47058823529
127164062150364.27659574513697.7234042553
128128144120285.57858.5
129154959150364.2765957454594.72340425532
1301179614313.5294117647-2517.52941176471
1311067414313.5294117647-3639.52941176471
132138547150364.276595745-11817.2765957447
133683614313.5294117647-7477.52941176471
134154135150364.2765957453770.72340425532
135511814313.5294117647-9195.52941176471
1364024814313.529411764725934.4705882353
137014313.5294117647-14313.5294117647
138120460120285.5174.5
1398883783580.45256.60000000001
140713114313.5294117647-7182.52941176471
141905614313.5294117647-5257.52941176471
1426891667124.54545454551791.45454545454
143132697150364.276595745-17667.2765957447
14410068183580.417100.6



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