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 11:43:38 -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/t1324658712xwdzovz16etdbxq.htm/, Retrieved Mon, 29 Apr 2024 23:59:02 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=160572, Retrieved Mon, 29 Apr 2024 23:59:02 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact57
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 18:59:57] [b98453cac15ba1066b407e146608df68]
- R PD    [Recursive Partitioning (Regression Trees)] [Regression] [2011-12-23 16:43:38] [586f91422d5bd41515f45f36c86ce0c0] [Current]
Feedback Forum

Post a new message
Dataseries X:
48	21	20465	162687
75	24	33629	233285
0	0	1423	7215
79	32	25629	178420
92	33	54002	284907
137	36	151036	547440
65	26	33287	192501
97	35	31172	213538
62	34	28113	182371
72	27	57803	336547
50	28	49830	130487
88	30	52143	203938
83	22	21055	124103
79	28	47007	220796
56	18	28735	174005
54	22	59147	156326
101	37	78950	164063
13	15	13497	90025
80	34	46154	179987
19	18	53249	47066
34	15	10726	111065
99	30	83700	241285
38	25	40400	208339
68	35	33797	164166
54	21	36205	159763
63	21	30165	207078
66	25	58534	220200
90	31	44663	201536
75	31	92556	408960
68	25	40078	250260
69	33	34711	216536
80	22	31076	212949
59	20	74608	166556
135	30	58092	278911
75	26	42009	240943
0	0	0	0
54	31	36022	233971
62	14	23333	149649
46	35	53349	161703
83	34	92596	254893
106	22	49598	269492
51	34	44093	169526
27	23	84205	107893
78	24	63369	229714
71	26	60132	139667
44	25	37403	178553
23	35	24460	81407
78	24	46456	251392
60	31	66616	239807
73	30	41554	172743
12	22	22346	48188
104	23	30874	169355
95	27	68701	335398
57	30	35728	244729
68	34	29010	208286
44	12	23110	159913
62	26	38844	232137
26	29	27084	116156
67	23	35139	157258
36	38	57476	211586
56	32	33277	181076
55	22	31141	158024
54	22	61281	141491
61	26	25820	130108
27	28	23284	166420
64	33	35378	135509
76	36	74990	195043
93	25	29653	138708
59	25	64622	116552
5	21	4157	31970
62	23	29245	291993
47	14	50008	167825
88	30	52338	135926
62	24	13310	141464
81	39	92901	171518
35	37	10956	112714
102	28	34241	183471
73	31	75043	167426
32	21	21152	112510
34	33	42249	92421
80	29	42005	117175
49	29	41152	304603
36	24	14399	110631
77	29	28263	167192
54	22	17215	95827
38	26	48140	173931
63	33	62897	250424
58	24	22883	115367
49	24	41622	125839
46	21	40715	164078
51	28	65897	158931
90	28	76542	190382
45	25	37477	155226
28	15	53216	146159
26	13	40911	62641
54	36	57021	258585
96	27	73116	199841
13	1	3895	19349
43	24	46609	247280
46	31	29351	173152
30	4	2325	72128
59	21	31747	104253
73	27	32665	151090
40	26	19249	147990
36	12	15292	87448
2	16	5842	27676
103	29	33994	170326
30	26	13018	132148
0	0	0	0
78	25	98177	133868
25	21	37941	109001
59	24	31032	158833
60	21	32683	150013
54	21	34545	102573
0	0	0	3616
0	0	0	0
51	26	27525	216535
79	33	66856	177323
30	32	28549	177948
43	25	38610	140106
7	1	2781	43410
92	29	41211	206059
32	20	22698	109873
84	34	41194	157084
3	12	32689	60493
10	2	5752	19764
47	21	26757	177559
44	28	22527	154169
54	35	44810	164249
1	2	0	11796
0	0	0	10674
46	18	100674	151322
0	1	0	6836
51	21	57786	174712
5	0	0	5118
8	4	5444	40248
0	0	0	0
38	29	28470	127628
21	26	61849	88837
0	0	0	7131
0	4	2179	9056
26	19	8019	97191
53	25	39644	157579
31	22	23494	125593




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

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 3 seconds \tabularnewline
R Server & 'Gwilym Jenkins' @ jenkins.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160572&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]3 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Gwilym Jenkins' @ jenkins.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160572&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160572&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 time3 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net







Goodness of Fit
Correlation0.8303
R-squared0.6894
RMSE16.5134

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8303[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6894[/C][/ROW]
[ROW][C]RMSE[/C][C]16.5134[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160572&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160572&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.8303
R-squared0.6894
RMSE16.5134







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
14854.2439024390244-6.24390243902439
27571.72727272727273.27272727272727
300.5-0.5
47966.913043478260912.0869565217391
59271.727272727272720.2727272727273
613793.87543.125
76571.7272727272727-6.72727272727273
89771.727272727272725.2727272727273
96266.9130434782609-4.91304347826087
107271.72727272727270.272727272727266
115054.2439024390244-4.24390243902439
128871.727272727272716.2727272727273
138354.243902439024428.7560975609756
147971.72727272727277.27272727272727
155654.24390243902441.75609756097561
165454.2439024390244-0.243902439024389
1710166.913043478260934.0869565217391
181333.1666666666667-20.1666666666667
198066.913043478260913.0869565217391
20198.7777777777777810.2222222222222
213433.16666666666670.833333333333336
229993.8755.125
233871.7272727272727-33.7272727272727
246866.91304347826091.08695652173913
255454.2439024390244-0.243902439024389
266371.7272727272727-8.72727272727273
276671.7272727272727-5.72727272727273
289071.727272727272718.2727272727273
297593.875-18.875
306871.7272727272727-3.72727272727273
316971.7272727272727-2.72727272727273
328071.72727272727278.27272727272727
335954.24390243902444.75609756097561
3413571.727272727272763.2727272727273
357571.72727272727273.27272727272727
3600.5-0.5
375471.7272727272727-17.7272727272727
386254.24390243902447.75609756097561
394666.9130434782609-20.9130434782609
408393.875-10.875
4110671.727272727272734.2727272727273
425166.9130434782609-15.9130434782609
432733.1666666666667-6.16666666666666
447871.72727272727276.27272727272727
457154.243902439024416.7560975609756
464454.2439024390244-10.2439024390244
472333.1666666666667-10.1666666666667
487871.72727272727276.27272727272727
496071.7272727272727-11.7272727272727
507366.91304347826096.08695652173913
51128.777777777777783.22222222222222
5210454.243902439024449.7560975609756
539593.8751.125
545771.7272727272727-14.7272727272727
556871.7272727272727-3.72727272727273
564454.2439024390244-10.2439024390244
576271.7272727272727-9.72727272727273
582666.9130434782609-40.9130434782609
596754.243902439024412.7560975609756
603671.7272727272727-35.7272727272727
615666.9130434782609-10.9130434782609
625554.24390243902440.756097560975611
635454.2439024390244-0.243902439024389
646154.24390243902446.75609756097561
652754.2439024390244-27.2439024390244
666466.9130434782609-2.91304347826087
677693.875-17.875
689354.243902439024438.7560975609756
695954.24390243902444.75609756097561
7058.77777777777778-3.77777777777778
716271.7272727272727-9.72727272727273
724754.2439024390244-7.24390243902439
738866.913043478260921.0869565217391
746254.24390243902447.75609756097561
758166.913043478260914.0869565217391
763533.16666666666671.83333333333334
7710271.727272727272730.2727272727273
787366.91304347826096.08695652173913
793233.1666666666667-1.16666666666666
803433.16666666666670.833333333333336
818066.913043478260913.0869565217391
824971.7272727272727-22.7272727272727
833633.16666666666672.83333333333334
847766.913043478260910.0869565217391
855433.166666666666720.8333333333333
863854.2439024390244-16.2439024390244
876371.7272727272727-8.72727272727273
885854.24390243902443.75609756097561
894954.2439024390244-5.24390243902439
904654.2439024390244-8.24390243902439
915154.2439024390244-3.24390243902439
929093.875-3.875
934554.2439024390244-9.24390243902439
942854.2439024390244-26.2439024390244
952633.1666666666667-7.16666666666666
965471.7272727272727-17.7272727272727
979693.8752.125
98138.777777777777784.22222222222222
994371.7272727272727-28.7272727272727
1004666.9130434782609-20.9130434782609
1013033.1666666666667-3.16666666666666
1025933.166666666666725.8333333333333
1037354.243902439024418.7560975609756
1044054.2439024390244-14.2439024390244
1053633.16666666666672.83333333333334
10628.77777777777778-6.77777777777778
10710366.913043478260936.0869565217391
1083054.2439024390244-24.2439024390244
10900.5-0.5
1107854.243902439024423.7560975609756
1112533.1666666666667-8.16666666666666
1125954.24390243902444.75609756097561
1136054.24390243902445.75609756097561
1145433.166666666666720.8333333333333
11500.5-0.5
11600.5-0.5
1175171.7272727272727-20.7272727272727
1187966.913043478260912.0869565217391
1193066.9130434782609-36.9130434782609
1204354.2439024390244-11.2439024390244
12178.77777777777778-1.77777777777778
1229271.727272727272720.2727272727273
1233233.1666666666667-1.16666666666666
1248466.913043478260917.0869565217391
12538.77777777777778-5.77777777777778
126108.777777777777781.22222222222222
1274754.2439024390244-7.24390243902439
1284454.2439024390244-10.2439024390244
1295466.9130434782609-12.9130434782609
13010.50.5
13100.5-0.5
1324654.2439024390244-8.24390243902439
13300.5-0.5
1345154.2439024390244-3.24390243902439
13550.54.5
13688.77777777777778-0.777777777777779
13700.5-0.5
1383866.9130434782609-28.9130434782609
1392133.1666666666667-12.1666666666667
14000.5-0.5
14100.5-0.5
1422633.1666666666667-7.16666666666666
1435354.2439024390244-1.24390243902439
1443154.2439024390244-23.2439024390244

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 48 & 54.2439024390244 & -6.24390243902439 \tabularnewline
2 & 75 & 71.7272727272727 & 3.27272727272727 \tabularnewline
3 & 0 & 0.5 & -0.5 \tabularnewline
4 & 79 & 66.9130434782609 & 12.0869565217391 \tabularnewline
5 & 92 & 71.7272727272727 & 20.2727272727273 \tabularnewline
6 & 137 & 93.875 & 43.125 \tabularnewline
7 & 65 & 71.7272727272727 & -6.72727272727273 \tabularnewline
8 & 97 & 71.7272727272727 & 25.2727272727273 \tabularnewline
9 & 62 & 66.9130434782609 & -4.91304347826087 \tabularnewline
10 & 72 & 71.7272727272727 & 0.272727272727266 \tabularnewline
11 & 50 & 54.2439024390244 & -4.24390243902439 \tabularnewline
12 & 88 & 71.7272727272727 & 16.2727272727273 \tabularnewline
13 & 83 & 54.2439024390244 & 28.7560975609756 \tabularnewline
14 & 79 & 71.7272727272727 & 7.27272727272727 \tabularnewline
15 & 56 & 54.2439024390244 & 1.75609756097561 \tabularnewline
16 & 54 & 54.2439024390244 & -0.243902439024389 \tabularnewline
17 & 101 & 66.9130434782609 & 34.0869565217391 \tabularnewline
18 & 13 & 33.1666666666667 & -20.1666666666667 \tabularnewline
19 & 80 & 66.9130434782609 & 13.0869565217391 \tabularnewline
20 & 19 & 8.77777777777778 & 10.2222222222222 \tabularnewline
21 & 34 & 33.1666666666667 & 0.833333333333336 \tabularnewline
22 & 99 & 93.875 & 5.125 \tabularnewline
23 & 38 & 71.7272727272727 & -33.7272727272727 \tabularnewline
24 & 68 & 66.9130434782609 & 1.08695652173913 \tabularnewline
25 & 54 & 54.2439024390244 & -0.243902439024389 \tabularnewline
26 & 63 & 71.7272727272727 & -8.72727272727273 \tabularnewline
27 & 66 & 71.7272727272727 & -5.72727272727273 \tabularnewline
28 & 90 & 71.7272727272727 & 18.2727272727273 \tabularnewline
29 & 75 & 93.875 & -18.875 \tabularnewline
30 & 68 & 71.7272727272727 & -3.72727272727273 \tabularnewline
31 & 69 & 71.7272727272727 & -2.72727272727273 \tabularnewline
32 & 80 & 71.7272727272727 & 8.27272727272727 \tabularnewline
33 & 59 & 54.2439024390244 & 4.75609756097561 \tabularnewline
34 & 135 & 71.7272727272727 & 63.2727272727273 \tabularnewline
35 & 75 & 71.7272727272727 & 3.27272727272727 \tabularnewline
36 & 0 & 0.5 & -0.5 \tabularnewline
37 & 54 & 71.7272727272727 & -17.7272727272727 \tabularnewline
38 & 62 & 54.2439024390244 & 7.75609756097561 \tabularnewline
39 & 46 & 66.9130434782609 & -20.9130434782609 \tabularnewline
40 & 83 & 93.875 & -10.875 \tabularnewline
41 & 106 & 71.7272727272727 & 34.2727272727273 \tabularnewline
42 & 51 & 66.9130434782609 & -15.9130434782609 \tabularnewline
43 & 27 & 33.1666666666667 & -6.16666666666666 \tabularnewline
44 & 78 & 71.7272727272727 & 6.27272727272727 \tabularnewline
45 & 71 & 54.2439024390244 & 16.7560975609756 \tabularnewline
46 & 44 & 54.2439024390244 & -10.2439024390244 \tabularnewline
47 & 23 & 33.1666666666667 & -10.1666666666667 \tabularnewline
48 & 78 & 71.7272727272727 & 6.27272727272727 \tabularnewline
49 & 60 & 71.7272727272727 & -11.7272727272727 \tabularnewline
50 & 73 & 66.9130434782609 & 6.08695652173913 \tabularnewline
51 & 12 & 8.77777777777778 & 3.22222222222222 \tabularnewline
52 & 104 & 54.2439024390244 & 49.7560975609756 \tabularnewline
53 & 95 & 93.875 & 1.125 \tabularnewline
54 & 57 & 71.7272727272727 & -14.7272727272727 \tabularnewline
55 & 68 & 71.7272727272727 & -3.72727272727273 \tabularnewline
56 & 44 & 54.2439024390244 & -10.2439024390244 \tabularnewline
57 & 62 & 71.7272727272727 & -9.72727272727273 \tabularnewline
58 & 26 & 66.9130434782609 & -40.9130434782609 \tabularnewline
59 & 67 & 54.2439024390244 & 12.7560975609756 \tabularnewline
60 & 36 & 71.7272727272727 & -35.7272727272727 \tabularnewline
61 & 56 & 66.9130434782609 & -10.9130434782609 \tabularnewline
62 & 55 & 54.2439024390244 & 0.756097560975611 \tabularnewline
63 & 54 & 54.2439024390244 & -0.243902439024389 \tabularnewline
64 & 61 & 54.2439024390244 & 6.75609756097561 \tabularnewline
65 & 27 & 54.2439024390244 & -27.2439024390244 \tabularnewline
66 & 64 & 66.9130434782609 & -2.91304347826087 \tabularnewline
67 & 76 & 93.875 & -17.875 \tabularnewline
68 & 93 & 54.2439024390244 & 38.7560975609756 \tabularnewline
69 & 59 & 54.2439024390244 & 4.75609756097561 \tabularnewline
70 & 5 & 8.77777777777778 & -3.77777777777778 \tabularnewline
71 & 62 & 71.7272727272727 & -9.72727272727273 \tabularnewline
72 & 47 & 54.2439024390244 & -7.24390243902439 \tabularnewline
73 & 88 & 66.9130434782609 & 21.0869565217391 \tabularnewline
74 & 62 & 54.2439024390244 & 7.75609756097561 \tabularnewline
75 & 81 & 66.9130434782609 & 14.0869565217391 \tabularnewline
76 & 35 & 33.1666666666667 & 1.83333333333334 \tabularnewline
77 & 102 & 71.7272727272727 & 30.2727272727273 \tabularnewline
78 & 73 & 66.9130434782609 & 6.08695652173913 \tabularnewline
79 & 32 & 33.1666666666667 & -1.16666666666666 \tabularnewline
80 & 34 & 33.1666666666667 & 0.833333333333336 \tabularnewline
81 & 80 & 66.9130434782609 & 13.0869565217391 \tabularnewline
82 & 49 & 71.7272727272727 & -22.7272727272727 \tabularnewline
83 & 36 & 33.1666666666667 & 2.83333333333334 \tabularnewline
84 & 77 & 66.9130434782609 & 10.0869565217391 \tabularnewline
85 & 54 & 33.1666666666667 & 20.8333333333333 \tabularnewline
86 & 38 & 54.2439024390244 & -16.2439024390244 \tabularnewline
87 & 63 & 71.7272727272727 & -8.72727272727273 \tabularnewline
88 & 58 & 54.2439024390244 & 3.75609756097561 \tabularnewline
89 & 49 & 54.2439024390244 & -5.24390243902439 \tabularnewline
90 & 46 & 54.2439024390244 & -8.24390243902439 \tabularnewline
91 & 51 & 54.2439024390244 & -3.24390243902439 \tabularnewline
92 & 90 & 93.875 & -3.875 \tabularnewline
93 & 45 & 54.2439024390244 & -9.24390243902439 \tabularnewline
94 & 28 & 54.2439024390244 & -26.2439024390244 \tabularnewline
95 & 26 & 33.1666666666667 & -7.16666666666666 \tabularnewline
96 & 54 & 71.7272727272727 & -17.7272727272727 \tabularnewline
97 & 96 & 93.875 & 2.125 \tabularnewline
98 & 13 & 8.77777777777778 & 4.22222222222222 \tabularnewline
99 & 43 & 71.7272727272727 & -28.7272727272727 \tabularnewline
100 & 46 & 66.9130434782609 & -20.9130434782609 \tabularnewline
101 & 30 & 33.1666666666667 & -3.16666666666666 \tabularnewline
102 & 59 & 33.1666666666667 & 25.8333333333333 \tabularnewline
103 & 73 & 54.2439024390244 & 18.7560975609756 \tabularnewline
104 & 40 & 54.2439024390244 & -14.2439024390244 \tabularnewline
105 & 36 & 33.1666666666667 & 2.83333333333334 \tabularnewline
106 & 2 & 8.77777777777778 & -6.77777777777778 \tabularnewline
107 & 103 & 66.9130434782609 & 36.0869565217391 \tabularnewline
108 & 30 & 54.2439024390244 & -24.2439024390244 \tabularnewline
109 & 0 & 0.5 & -0.5 \tabularnewline
110 & 78 & 54.2439024390244 & 23.7560975609756 \tabularnewline
111 & 25 & 33.1666666666667 & -8.16666666666666 \tabularnewline
112 & 59 & 54.2439024390244 & 4.75609756097561 \tabularnewline
113 & 60 & 54.2439024390244 & 5.75609756097561 \tabularnewline
114 & 54 & 33.1666666666667 & 20.8333333333333 \tabularnewline
115 & 0 & 0.5 & -0.5 \tabularnewline
116 & 0 & 0.5 & -0.5 \tabularnewline
117 & 51 & 71.7272727272727 & -20.7272727272727 \tabularnewline
118 & 79 & 66.9130434782609 & 12.0869565217391 \tabularnewline
119 & 30 & 66.9130434782609 & -36.9130434782609 \tabularnewline
120 & 43 & 54.2439024390244 & -11.2439024390244 \tabularnewline
121 & 7 & 8.77777777777778 & -1.77777777777778 \tabularnewline
122 & 92 & 71.7272727272727 & 20.2727272727273 \tabularnewline
123 & 32 & 33.1666666666667 & -1.16666666666666 \tabularnewline
124 & 84 & 66.9130434782609 & 17.0869565217391 \tabularnewline
125 & 3 & 8.77777777777778 & -5.77777777777778 \tabularnewline
126 & 10 & 8.77777777777778 & 1.22222222222222 \tabularnewline
127 & 47 & 54.2439024390244 & -7.24390243902439 \tabularnewline
128 & 44 & 54.2439024390244 & -10.2439024390244 \tabularnewline
129 & 54 & 66.9130434782609 & -12.9130434782609 \tabularnewline
130 & 1 & 0.5 & 0.5 \tabularnewline
131 & 0 & 0.5 & -0.5 \tabularnewline
132 & 46 & 54.2439024390244 & -8.24390243902439 \tabularnewline
133 & 0 & 0.5 & -0.5 \tabularnewline
134 & 51 & 54.2439024390244 & -3.24390243902439 \tabularnewline
135 & 5 & 0.5 & 4.5 \tabularnewline
136 & 8 & 8.77777777777778 & -0.777777777777779 \tabularnewline
137 & 0 & 0.5 & -0.5 \tabularnewline
138 & 38 & 66.9130434782609 & -28.9130434782609 \tabularnewline
139 & 21 & 33.1666666666667 & -12.1666666666667 \tabularnewline
140 & 0 & 0.5 & -0.5 \tabularnewline
141 & 0 & 0.5 & -0.5 \tabularnewline
142 & 26 & 33.1666666666667 & -7.16666666666666 \tabularnewline
143 & 53 & 54.2439024390244 & -1.24390243902439 \tabularnewline
144 & 31 & 54.2439024390244 & -23.2439024390244 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160572&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]48[/C][C]54.2439024390244[/C][C]-6.24390243902439[/C][/ROW]
[ROW][C]2[/C][C]75[/C][C]71.7272727272727[/C][C]3.27272727272727[/C][/ROW]
[ROW][C]3[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]4[/C][C]79[/C][C]66.9130434782609[/C][C]12.0869565217391[/C][/ROW]
[ROW][C]5[/C][C]92[/C][C]71.7272727272727[/C][C]20.2727272727273[/C][/ROW]
[ROW][C]6[/C][C]137[/C][C]93.875[/C][C]43.125[/C][/ROW]
[ROW][C]7[/C][C]65[/C][C]71.7272727272727[/C][C]-6.72727272727273[/C][/ROW]
[ROW][C]8[/C][C]97[/C][C]71.7272727272727[/C][C]25.2727272727273[/C][/ROW]
[ROW][C]9[/C][C]62[/C][C]66.9130434782609[/C][C]-4.91304347826087[/C][/ROW]
[ROW][C]10[/C][C]72[/C][C]71.7272727272727[/C][C]0.272727272727266[/C][/ROW]
[ROW][C]11[/C][C]50[/C][C]54.2439024390244[/C][C]-4.24390243902439[/C][/ROW]
[ROW][C]12[/C][C]88[/C][C]71.7272727272727[/C][C]16.2727272727273[/C][/ROW]
[ROW][C]13[/C][C]83[/C][C]54.2439024390244[/C][C]28.7560975609756[/C][/ROW]
[ROW][C]14[/C][C]79[/C][C]71.7272727272727[/C][C]7.27272727272727[/C][/ROW]
[ROW][C]15[/C][C]56[/C][C]54.2439024390244[/C][C]1.75609756097561[/C][/ROW]
[ROW][C]16[/C][C]54[/C][C]54.2439024390244[/C][C]-0.243902439024389[/C][/ROW]
[ROW][C]17[/C][C]101[/C][C]66.9130434782609[/C][C]34.0869565217391[/C][/ROW]
[ROW][C]18[/C][C]13[/C][C]33.1666666666667[/C][C]-20.1666666666667[/C][/ROW]
[ROW][C]19[/C][C]80[/C][C]66.9130434782609[/C][C]13.0869565217391[/C][/ROW]
[ROW][C]20[/C][C]19[/C][C]8.77777777777778[/C][C]10.2222222222222[/C][/ROW]
[ROW][C]21[/C][C]34[/C][C]33.1666666666667[/C][C]0.833333333333336[/C][/ROW]
[ROW][C]22[/C][C]99[/C][C]93.875[/C][C]5.125[/C][/ROW]
[ROW][C]23[/C][C]38[/C][C]71.7272727272727[/C][C]-33.7272727272727[/C][/ROW]
[ROW][C]24[/C][C]68[/C][C]66.9130434782609[/C][C]1.08695652173913[/C][/ROW]
[ROW][C]25[/C][C]54[/C][C]54.2439024390244[/C][C]-0.243902439024389[/C][/ROW]
[ROW][C]26[/C][C]63[/C][C]71.7272727272727[/C][C]-8.72727272727273[/C][/ROW]
[ROW][C]27[/C][C]66[/C][C]71.7272727272727[/C][C]-5.72727272727273[/C][/ROW]
[ROW][C]28[/C][C]90[/C][C]71.7272727272727[/C][C]18.2727272727273[/C][/ROW]
[ROW][C]29[/C][C]75[/C][C]93.875[/C][C]-18.875[/C][/ROW]
[ROW][C]30[/C][C]68[/C][C]71.7272727272727[/C][C]-3.72727272727273[/C][/ROW]
[ROW][C]31[/C][C]69[/C][C]71.7272727272727[/C][C]-2.72727272727273[/C][/ROW]
[ROW][C]32[/C][C]80[/C][C]71.7272727272727[/C][C]8.27272727272727[/C][/ROW]
[ROW][C]33[/C][C]59[/C][C]54.2439024390244[/C][C]4.75609756097561[/C][/ROW]
[ROW][C]34[/C][C]135[/C][C]71.7272727272727[/C][C]63.2727272727273[/C][/ROW]
[ROW][C]35[/C][C]75[/C][C]71.7272727272727[/C][C]3.27272727272727[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]37[/C][C]54[/C][C]71.7272727272727[/C][C]-17.7272727272727[/C][/ROW]
[ROW][C]38[/C][C]62[/C][C]54.2439024390244[/C][C]7.75609756097561[/C][/ROW]
[ROW][C]39[/C][C]46[/C][C]66.9130434782609[/C][C]-20.9130434782609[/C][/ROW]
[ROW][C]40[/C][C]83[/C][C]93.875[/C][C]-10.875[/C][/ROW]
[ROW][C]41[/C][C]106[/C][C]71.7272727272727[/C][C]34.2727272727273[/C][/ROW]
[ROW][C]42[/C][C]51[/C][C]66.9130434782609[/C][C]-15.9130434782609[/C][/ROW]
[ROW][C]43[/C][C]27[/C][C]33.1666666666667[/C][C]-6.16666666666666[/C][/ROW]
[ROW][C]44[/C][C]78[/C][C]71.7272727272727[/C][C]6.27272727272727[/C][/ROW]
[ROW][C]45[/C][C]71[/C][C]54.2439024390244[/C][C]16.7560975609756[/C][/ROW]
[ROW][C]46[/C][C]44[/C][C]54.2439024390244[/C][C]-10.2439024390244[/C][/ROW]
[ROW][C]47[/C][C]23[/C][C]33.1666666666667[/C][C]-10.1666666666667[/C][/ROW]
[ROW][C]48[/C][C]78[/C][C]71.7272727272727[/C][C]6.27272727272727[/C][/ROW]
[ROW][C]49[/C][C]60[/C][C]71.7272727272727[/C][C]-11.7272727272727[/C][/ROW]
[ROW][C]50[/C][C]73[/C][C]66.9130434782609[/C][C]6.08695652173913[/C][/ROW]
[ROW][C]51[/C][C]12[/C][C]8.77777777777778[/C][C]3.22222222222222[/C][/ROW]
[ROW][C]52[/C][C]104[/C][C]54.2439024390244[/C][C]49.7560975609756[/C][/ROW]
[ROW][C]53[/C][C]95[/C][C]93.875[/C][C]1.125[/C][/ROW]
[ROW][C]54[/C][C]57[/C][C]71.7272727272727[/C][C]-14.7272727272727[/C][/ROW]
[ROW][C]55[/C][C]68[/C][C]71.7272727272727[/C][C]-3.72727272727273[/C][/ROW]
[ROW][C]56[/C][C]44[/C][C]54.2439024390244[/C][C]-10.2439024390244[/C][/ROW]
[ROW][C]57[/C][C]62[/C][C]71.7272727272727[/C][C]-9.72727272727273[/C][/ROW]
[ROW][C]58[/C][C]26[/C][C]66.9130434782609[/C][C]-40.9130434782609[/C][/ROW]
[ROW][C]59[/C][C]67[/C][C]54.2439024390244[/C][C]12.7560975609756[/C][/ROW]
[ROW][C]60[/C][C]36[/C][C]71.7272727272727[/C][C]-35.7272727272727[/C][/ROW]
[ROW][C]61[/C][C]56[/C][C]66.9130434782609[/C][C]-10.9130434782609[/C][/ROW]
[ROW][C]62[/C][C]55[/C][C]54.2439024390244[/C][C]0.756097560975611[/C][/ROW]
[ROW][C]63[/C][C]54[/C][C]54.2439024390244[/C][C]-0.243902439024389[/C][/ROW]
[ROW][C]64[/C][C]61[/C][C]54.2439024390244[/C][C]6.75609756097561[/C][/ROW]
[ROW][C]65[/C][C]27[/C][C]54.2439024390244[/C][C]-27.2439024390244[/C][/ROW]
[ROW][C]66[/C][C]64[/C][C]66.9130434782609[/C][C]-2.91304347826087[/C][/ROW]
[ROW][C]67[/C][C]76[/C][C]93.875[/C][C]-17.875[/C][/ROW]
[ROW][C]68[/C][C]93[/C][C]54.2439024390244[/C][C]38.7560975609756[/C][/ROW]
[ROW][C]69[/C][C]59[/C][C]54.2439024390244[/C][C]4.75609756097561[/C][/ROW]
[ROW][C]70[/C][C]5[/C][C]8.77777777777778[/C][C]-3.77777777777778[/C][/ROW]
[ROW][C]71[/C][C]62[/C][C]71.7272727272727[/C][C]-9.72727272727273[/C][/ROW]
[ROW][C]72[/C][C]47[/C][C]54.2439024390244[/C][C]-7.24390243902439[/C][/ROW]
[ROW][C]73[/C][C]88[/C][C]66.9130434782609[/C][C]21.0869565217391[/C][/ROW]
[ROW][C]74[/C][C]62[/C][C]54.2439024390244[/C][C]7.75609756097561[/C][/ROW]
[ROW][C]75[/C][C]81[/C][C]66.9130434782609[/C][C]14.0869565217391[/C][/ROW]
[ROW][C]76[/C][C]35[/C][C]33.1666666666667[/C][C]1.83333333333334[/C][/ROW]
[ROW][C]77[/C][C]102[/C][C]71.7272727272727[/C][C]30.2727272727273[/C][/ROW]
[ROW][C]78[/C][C]73[/C][C]66.9130434782609[/C][C]6.08695652173913[/C][/ROW]
[ROW][C]79[/C][C]32[/C][C]33.1666666666667[/C][C]-1.16666666666666[/C][/ROW]
[ROW][C]80[/C][C]34[/C][C]33.1666666666667[/C][C]0.833333333333336[/C][/ROW]
[ROW][C]81[/C][C]80[/C][C]66.9130434782609[/C][C]13.0869565217391[/C][/ROW]
[ROW][C]82[/C][C]49[/C][C]71.7272727272727[/C][C]-22.7272727272727[/C][/ROW]
[ROW][C]83[/C][C]36[/C][C]33.1666666666667[/C][C]2.83333333333334[/C][/ROW]
[ROW][C]84[/C][C]77[/C][C]66.9130434782609[/C][C]10.0869565217391[/C][/ROW]
[ROW][C]85[/C][C]54[/C][C]33.1666666666667[/C][C]20.8333333333333[/C][/ROW]
[ROW][C]86[/C][C]38[/C][C]54.2439024390244[/C][C]-16.2439024390244[/C][/ROW]
[ROW][C]87[/C][C]63[/C][C]71.7272727272727[/C][C]-8.72727272727273[/C][/ROW]
[ROW][C]88[/C][C]58[/C][C]54.2439024390244[/C][C]3.75609756097561[/C][/ROW]
[ROW][C]89[/C][C]49[/C][C]54.2439024390244[/C][C]-5.24390243902439[/C][/ROW]
[ROW][C]90[/C][C]46[/C][C]54.2439024390244[/C][C]-8.24390243902439[/C][/ROW]
[ROW][C]91[/C][C]51[/C][C]54.2439024390244[/C][C]-3.24390243902439[/C][/ROW]
[ROW][C]92[/C][C]90[/C][C]93.875[/C][C]-3.875[/C][/ROW]
[ROW][C]93[/C][C]45[/C][C]54.2439024390244[/C][C]-9.24390243902439[/C][/ROW]
[ROW][C]94[/C][C]28[/C][C]54.2439024390244[/C][C]-26.2439024390244[/C][/ROW]
[ROW][C]95[/C][C]26[/C][C]33.1666666666667[/C][C]-7.16666666666666[/C][/ROW]
[ROW][C]96[/C][C]54[/C][C]71.7272727272727[/C][C]-17.7272727272727[/C][/ROW]
[ROW][C]97[/C][C]96[/C][C]93.875[/C][C]2.125[/C][/ROW]
[ROW][C]98[/C][C]13[/C][C]8.77777777777778[/C][C]4.22222222222222[/C][/ROW]
[ROW][C]99[/C][C]43[/C][C]71.7272727272727[/C][C]-28.7272727272727[/C][/ROW]
[ROW][C]100[/C][C]46[/C][C]66.9130434782609[/C][C]-20.9130434782609[/C][/ROW]
[ROW][C]101[/C][C]30[/C][C]33.1666666666667[/C][C]-3.16666666666666[/C][/ROW]
[ROW][C]102[/C][C]59[/C][C]33.1666666666667[/C][C]25.8333333333333[/C][/ROW]
[ROW][C]103[/C][C]73[/C][C]54.2439024390244[/C][C]18.7560975609756[/C][/ROW]
[ROW][C]104[/C][C]40[/C][C]54.2439024390244[/C][C]-14.2439024390244[/C][/ROW]
[ROW][C]105[/C][C]36[/C][C]33.1666666666667[/C][C]2.83333333333334[/C][/ROW]
[ROW][C]106[/C][C]2[/C][C]8.77777777777778[/C][C]-6.77777777777778[/C][/ROW]
[ROW][C]107[/C][C]103[/C][C]66.9130434782609[/C][C]36.0869565217391[/C][/ROW]
[ROW][C]108[/C][C]30[/C][C]54.2439024390244[/C][C]-24.2439024390244[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]110[/C][C]78[/C][C]54.2439024390244[/C][C]23.7560975609756[/C][/ROW]
[ROW][C]111[/C][C]25[/C][C]33.1666666666667[/C][C]-8.16666666666666[/C][/ROW]
[ROW][C]112[/C][C]59[/C][C]54.2439024390244[/C][C]4.75609756097561[/C][/ROW]
[ROW][C]113[/C][C]60[/C][C]54.2439024390244[/C][C]5.75609756097561[/C][/ROW]
[ROW][C]114[/C][C]54[/C][C]33.1666666666667[/C][C]20.8333333333333[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]117[/C][C]51[/C][C]71.7272727272727[/C][C]-20.7272727272727[/C][/ROW]
[ROW][C]118[/C][C]79[/C][C]66.9130434782609[/C][C]12.0869565217391[/C][/ROW]
[ROW][C]119[/C][C]30[/C][C]66.9130434782609[/C][C]-36.9130434782609[/C][/ROW]
[ROW][C]120[/C][C]43[/C][C]54.2439024390244[/C][C]-11.2439024390244[/C][/ROW]
[ROW][C]121[/C][C]7[/C][C]8.77777777777778[/C][C]-1.77777777777778[/C][/ROW]
[ROW][C]122[/C][C]92[/C][C]71.7272727272727[/C][C]20.2727272727273[/C][/ROW]
[ROW][C]123[/C][C]32[/C][C]33.1666666666667[/C][C]-1.16666666666666[/C][/ROW]
[ROW][C]124[/C][C]84[/C][C]66.9130434782609[/C][C]17.0869565217391[/C][/ROW]
[ROW][C]125[/C][C]3[/C][C]8.77777777777778[/C][C]-5.77777777777778[/C][/ROW]
[ROW][C]126[/C][C]10[/C][C]8.77777777777778[/C][C]1.22222222222222[/C][/ROW]
[ROW][C]127[/C][C]47[/C][C]54.2439024390244[/C][C]-7.24390243902439[/C][/ROW]
[ROW][C]128[/C][C]44[/C][C]54.2439024390244[/C][C]-10.2439024390244[/C][/ROW]
[ROW][C]129[/C][C]54[/C][C]66.9130434782609[/C][C]-12.9130434782609[/C][/ROW]
[ROW][C]130[/C][C]1[/C][C]0.5[/C][C]0.5[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]132[/C][C]46[/C][C]54.2439024390244[/C][C]-8.24390243902439[/C][/ROW]
[ROW][C]133[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]134[/C][C]51[/C][C]54.2439024390244[/C][C]-3.24390243902439[/C][/ROW]
[ROW][C]135[/C][C]5[/C][C]0.5[/C][C]4.5[/C][/ROW]
[ROW][C]136[/C][C]8[/C][C]8.77777777777778[/C][C]-0.777777777777779[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]138[/C][C]38[/C][C]66.9130434782609[/C][C]-28.9130434782609[/C][/ROW]
[ROW][C]139[/C][C]21[/C][C]33.1666666666667[/C][C]-12.1666666666667[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]141[/C][C]0[/C][C]0.5[/C][C]-0.5[/C][/ROW]
[ROW][C]142[/C][C]26[/C][C]33.1666666666667[/C][C]-7.16666666666666[/C][/ROW]
[ROW][C]143[/C][C]53[/C][C]54.2439024390244[/C][C]-1.24390243902439[/C][/ROW]
[ROW][C]144[/C][C]31[/C][C]54.2439024390244[/C][C]-23.2439024390244[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160572&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160572&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
14854.2439024390244-6.24390243902439
27571.72727272727273.27272727272727
300.5-0.5
47966.913043478260912.0869565217391
59271.727272727272720.2727272727273
613793.87543.125
76571.7272727272727-6.72727272727273
89771.727272727272725.2727272727273
96266.9130434782609-4.91304347826087
107271.72727272727270.272727272727266
115054.2439024390244-4.24390243902439
128871.727272727272716.2727272727273
138354.243902439024428.7560975609756
147971.72727272727277.27272727272727
155654.24390243902441.75609756097561
165454.2439024390244-0.243902439024389
1710166.913043478260934.0869565217391
181333.1666666666667-20.1666666666667
198066.913043478260913.0869565217391
20198.7777777777777810.2222222222222
213433.16666666666670.833333333333336
229993.8755.125
233871.7272727272727-33.7272727272727
246866.91304347826091.08695652173913
255454.2439024390244-0.243902439024389
266371.7272727272727-8.72727272727273
276671.7272727272727-5.72727272727273
289071.727272727272718.2727272727273
297593.875-18.875
306871.7272727272727-3.72727272727273
316971.7272727272727-2.72727272727273
328071.72727272727278.27272727272727
335954.24390243902444.75609756097561
3413571.727272727272763.2727272727273
357571.72727272727273.27272727272727
3600.5-0.5
375471.7272727272727-17.7272727272727
386254.24390243902447.75609756097561
394666.9130434782609-20.9130434782609
408393.875-10.875
4110671.727272727272734.2727272727273
425166.9130434782609-15.9130434782609
432733.1666666666667-6.16666666666666
447871.72727272727276.27272727272727
457154.243902439024416.7560975609756
464454.2439024390244-10.2439024390244
472333.1666666666667-10.1666666666667
487871.72727272727276.27272727272727
496071.7272727272727-11.7272727272727
507366.91304347826096.08695652173913
51128.777777777777783.22222222222222
5210454.243902439024449.7560975609756
539593.8751.125
545771.7272727272727-14.7272727272727
556871.7272727272727-3.72727272727273
564454.2439024390244-10.2439024390244
576271.7272727272727-9.72727272727273
582666.9130434782609-40.9130434782609
596754.243902439024412.7560975609756
603671.7272727272727-35.7272727272727
615666.9130434782609-10.9130434782609
625554.24390243902440.756097560975611
635454.2439024390244-0.243902439024389
646154.24390243902446.75609756097561
652754.2439024390244-27.2439024390244
666466.9130434782609-2.91304347826087
677693.875-17.875
689354.243902439024438.7560975609756
695954.24390243902444.75609756097561
7058.77777777777778-3.77777777777778
716271.7272727272727-9.72727272727273
724754.2439024390244-7.24390243902439
738866.913043478260921.0869565217391
746254.24390243902447.75609756097561
758166.913043478260914.0869565217391
763533.16666666666671.83333333333334
7710271.727272727272730.2727272727273
787366.91304347826096.08695652173913
793233.1666666666667-1.16666666666666
803433.16666666666670.833333333333336
818066.913043478260913.0869565217391
824971.7272727272727-22.7272727272727
833633.16666666666672.83333333333334
847766.913043478260910.0869565217391
855433.166666666666720.8333333333333
863854.2439024390244-16.2439024390244
876371.7272727272727-8.72727272727273
885854.24390243902443.75609756097561
894954.2439024390244-5.24390243902439
904654.2439024390244-8.24390243902439
915154.2439024390244-3.24390243902439
929093.875-3.875
934554.2439024390244-9.24390243902439
942854.2439024390244-26.2439024390244
952633.1666666666667-7.16666666666666
965471.7272727272727-17.7272727272727
979693.8752.125
98138.777777777777784.22222222222222
994371.7272727272727-28.7272727272727
1004666.9130434782609-20.9130434782609
1013033.1666666666667-3.16666666666666
1025933.166666666666725.8333333333333
1037354.243902439024418.7560975609756
1044054.2439024390244-14.2439024390244
1053633.16666666666672.83333333333334
10628.77777777777778-6.77777777777778
10710366.913043478260936.0869565217391
1083054.2439024390244-24.2439024390244
10900.5-0.5
1107854.243902439024423.7560975609756
1112533.1666666666667-8.16666666666666
1125954.24390243902444.75609756097561
1136054.24390243902445.75609756097561
1145433.166666666666720.8333333333333
11500.5-0.5
11600.5-0.5
1175171.7272727272727-20.7272727272727
1187966.913043478260912.0869565217391
1193066.9130434782609-36.9130434782609
1204354.2439024390244-11.2439024390244
12178.77777777777778-1.77777777777778
1229271.727272727272720.2727272727273
1233233.1666666666667-1.16666666666666
1248466.913043478260917.0869565217391
12538.77777777777778-5.77777777777778
126108.777777777777781.22222222222222
1274754.2439024390244-7.24390243902439
1284454.2439024390244-10.2439024390244
1295466.9130434782609-12.9130434782609
13010.50.5
13100.5-0.5
1324654.2439024390244-8.24390243902439
13300.5-0.5
1345154.2439024390244-3.24390243902439
13550.54.5
13688.77777777777778-0.777777777777779
13700.5-0.5
1383866.9130434782609-28.9130434782609
1392133.1666666666667-12.1666666666667
14000.5-0.5
14100.5-0.5
1422633.1666666666667-7.16666666666666
1435354.2439024390244-1.24390243902439
1443154.2439024390244-23.2439024390244



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