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, 21 Dec 2010 17:52:54 +0000
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2010/Dec/21/t1292953883fkaj5fhdui4nicb.htm/, Retrieved Sun, 19 May 2024 19:50:39 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=113787, Retrieved Sun, 19 May 2024 19:50:39 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact104
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]
-   PD    [Recursive Partitioning (Regression Trees)] [Recursive Partiti...] [2010-12-21 17:52:54] [0605ea080d54454c99180f574351b8e4] [Current]
Feedback Forum

Post a new message
Dataseries X:
15561600	15.73	3.56	142.86
14917500	16.17	1.33	380.71
14805920	12.00	0.00	460.00
16958000	12.86	0.69	361.43
17605000	10.30	10.05	140.00
17131200	12.97	0.51	275.00
18474600	12.06	0.91	274.29
17286700	10.49	2.67	212.86
18574400	5.97	1.39	172.86
18056000	9.26	1.24	186.43
19701600	9.74	2.79	77.14
19061700	5.46	3.37	17.86
19681900	2.71	1.60	37.14
34521200	3.90	4.73	42.86
19922700	1.51	0.79	85.00
20177900	5.01	0.67	45.00
19759900	2.96	0.00	206.43
23076700	-1.97	0.60	178.57
22532000	-4.61	0.40	285.71
22029400	4.27	2.24	58.57
22587000	4.01	5.74	88.57
23256600	0.04	0.06	309.29
22680300	3.04	0.87	58.57
21916400	2.29	4.91	132.14
19640200	4.37	1.93	3.57
18813100	6.39	0.41	102.86
18730000	5.74	1.21	185.71
18154700	7.64	2.01	177.14
17848800	7.07	0.00	530.00
18077500	6.23	6.49	162.86
17133100	10.20	0.00	553.57
16602600	14.07	0.31	258.57
15878900	12.83	4.87	326.43
15789100	12.04	1.37	580.00
15422000	11.97	0.19	286.43
14661400	12.63	0.34	310.71
15879200	13.56	3.60	148.57
14339300	15.66	0.10	627.14
13169600	16.34	2.10	477.86
14528900	14.09	0.10	385.71
13375800	15.03	7.27	327.86
12309900	16.09	0.76	402.14
11933900	19.27	1.09	567.86
10061900	22.50	0.34	678.57
12609600	16.07	4.13	253.57
11156500	19.11	1.89	459.29
12187200	18.66	3.80	331.43
11284300	18.29	2.47	421.43
10177000	20.26	0.00	595.00
10970720	19.20	1.01	425.71
10820680	20.10	1.21	603.57
11492390	17.93	0.54	420.00
14573750	16.11	2.86	308.57
13992820	16.90	0.04	325.00
14727070	16.14	1.03	319.29
15685360	15.04	0.23	452.86
16736210	13.41	0.20	83.57
17950180	14.14	13.87	99.43
17002730	9.59	0.36	312.71
17415160	10.74	0.56	128.00
17929810	11.67	1.98	152.67
17865790	8.09	3.83	135.00
19202360	10.07	1.46	57.71
19085000	11.80	2.00	190.43
18188880	12.01	4.96	12.86
18466410	6.61	2.76	32.43
18520400	6.47	2.10	38.29
20025500	-3.11	2.09	210.14
20636100	1.94	2.21	109.14
20672000	1.10	2.90	71.43
22589100	-3.40	0.57	102.29
21864800	1.64	1.79	48.43
22750100	3.11	0.80	70.43
22548746	-0.16	2.66	139.86
21325495	3.80	1.70	83.14
21556563	-2.39	0.79	27.71
21415269	1.51	0.30	96.14
20401054	7.24	8.09	40.57
19062253	2.00	0.97	364.71
19085706	2.11	0.07	207.43
19279967	10.54	1.47	156.29
18552045	11.10	2.74	229.00
17800733	7.34	3.14	160.43
17142490	9.53	0.96	357.43
17593173	9.71	0.00	542.00
17633859	10.14	0.00	578.43
17336613	13.93	2.80	427.43
17008347	8.33	0.23	130.29
17951965	8.31	2.69	174.29
14520929	13.83	0.23	679.14
16941217	14.50	3.60	389.43
15436824	16.71	0.93	532.57
14744261	16.49	2.56	253.71
14248004	14.57	0.74	414.14
11540953	19.04	0.07	719.71
12881661	22.84	0.76	639.86
15185757	22.23	2.73	619.71
13554339	19.56	4.30	507.14
13575106	19.76	0.19	463.86
12238400	18.36	1.19	254.14
13303614	16.99	1.43	226.29
14151478	16.87	9.63	299.57
14172009	18.50	10.44	274.00
14022320	16.51	4.36	253.29




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time6 seconds
R Server'Sir Ronald Aylmer Fisher' @ 193.190.124.24

\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 & 6 seconds \tabularnewline
R Server & 'Sir Ronald Aylmer Fisher' @ 193.190.124.24 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=113787&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]6 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Sir Ronald Aylmer Fisher' @ 193.190.124.24[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=113787&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=113787&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 time6 seconds
R Server'Sir Ronald Aylmer Fisher' @ 193.190.124.24







Goodness of Fit
Correlation0.8876
R-squared0.7879
RMSE1720765.7442

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8876[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7879[/C][/ROW]
[ROW][C]RMSE[/C][C]1720765.7442[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=113787&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=113787&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.8876
R-squared0.7879
RMSE1720765.7442







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
11556160017065558.75-1503958.75
21491750012899698.28571432017801.71428571
31480592015320817.3571429-514897.357142856
41695800015320817.35714291637182.64285714
51760500017896694.0454545-291694.045454547
61713120017065558.7565641.25
71847460017065558.751409041.25
81728670017896694.0454545-609994.045454547
91857440017896694.0454545677705.954545453
101805600017896694.0454545159305.954545453
111970160019331636369964
121906170019331636-269936
131968190021978075.3043478-2296175.30434782
143452120021978075.304347812543124.6956522
151992270021978075.3043478-2055375.30434782
162017790019331636846264
171975990021978075.3043478-2218175.30434782
182307670021978075.30434781098624.69565218
192253200021978075.3043478553924.695652176
202202940021978075.304347851324.6956521757
212258700021978075.3043478608924.695652176
222325660021978075.30434781278524.69565218
232268030021978075.3043478702224.695652176
242191640021978075.3043478-61675.3043478243
251964020019331636308564
261881310019331636-518536
271873000017896694.0454545833305.954545453
281815470017896694.0454545258005.954545453
291784880017896694.0454545-47894.0454545468
301807750017896694.0454545180805.954545453
311713310017896694.0454545-763594.045454547
321660260017065558.75-462958.75
331587890015320817.3571429558082.642857144
341578910015320817.3571429468282.642857144
351542200015320817.3571429101182.642857144
361466140015320817.3571429-659417.357142856
371587920017065558.75-1186358.75
381433930015320817.3571429-981517.357142856
391316960012899698.2857143269901.714285715
401452890015320817.3571429-791917.357142856
411337580015320817.3571429-1945017.35714286
421230990012899698.2857143-589798.285714285
431193390012899698.2857143-965798.285714285
441006190012899698.2857143-2837798.28571429
451260960012899698.2857143-290098.285714285
461115650012899698.2857143-1743198.28571429
471218720012899698.2857143-712498.285714285
481128430012899698.2857143-1615398.28571429
491017700012899698.2857143-2722698.28571429
501097072012899698.2857143-1928978.28571429
511082068012899698.2857143-2079018.28571429
521149239012899698.2857143-1407308.28571429
531457375012899698.28571431674051.71428571
541399282012899698.28571431093121.71428571
551472707012899698.28571431827371.71428571
561568536015320817.3571429364542.642857144
571673621017065558.75-329348.75
581795018017065558.75884621.25
591700273017896694.0454545-893964.045454547
601741516017896694.0454545-481534.045454547
611792981017896694.045454533115.9545454532
621786579017896694.0454545-30904.0454545468
631920236019331636-129276
641908500017896694.04545451188305.95454545
651818888017065558.751123321.25
661846641019331636-865226
671852040019331636-811236
682002550021978075.3043478-1952575.30434782
692063610021978075.3043478-1341975.30434782
702067200021978075.3043478-1306075.30434782
712258910021978075.3043478611024.695652176
722186480021978075.3043478-113275.304347824
732275010021978075.3043478772024.695652176
742254874621978075.3043478570670.695652176
752132549521978075.3043478-652580.304347824
762155656321978075.3043478-421512.304347824
772141526921978075.3043478-562806.304347824
7820401054193316361069418
791906225321978075.3043478-2915822.30434782
801908570621978075.3043478-2892369.30434782
811927996717896694.04545451383272.95454545
821855204517896694.0454545655350.954545453
831780073317896694.0454545-95961.0454545468
841714249017896694.0454545-754204.045454547
851759317317896694.0454545-303521.045454547
861763385917896694.0454545-262835.045454547
871733661315320817.35714292015795.64285714
881700834717896694.0454545-888347.045454547
891795196517896694.045454555270.9545454532
901452092915320817.3571429-799888.357142856
911694121715320817.35714291620399.64285714
921543682412899698.28571432537125.71428571
931474426112899698.28571431844562.71428571
941424800415320817.3571429-1072813.35714286
951154095312899698.2857143-1358745.28571429
961288166112899698.2857143-18037.2857142854
971518575712899698.28571432286058.71428571
981355433912899698.2857143654640.714285715
991357510612899698.2857143675407.714285715
1001223840012899698.2857143-661298.285714285
1011330361412899698.2857143403915.714285715
1021415147812899698.28571431251779.71428571
1031417200912899698.28571431272310.71428571
1041402232012899698.28571431122621.71428571

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 15561600 & 17065558.75 & -1503958.75 \tabularnewline
2 & 14917500 & 12899698.2857143 & 2017801.71428571 \tabularnewline
3 & 14805920 & 15320817.3571429 & -514897.357142856 \tabularnewline
4 & 16958000 & 15320817.3571429 & 1637182.64285714 \tabularnewline
5 & 17605000 & 17896694.0454545 & -291694.045454547 \tabularnewline
6 & 17131200 & 17065558.75 & 65641.25 \tabularnewline
7 & 18474600 & 17065558.75 & 1409041.25 \tabularnewline
8 & 17286700 & 17896694.0454545 & -609994.045454547 \tabularnewline
9 & 18574400 & 17896694.0454545 & 677705.954545453 \tabularnewline
10 & 18056000 & 17896694.0454545 & 159305.954545453 \tabularnewline
11 & 19701600 & 19331636 & 369964 \tabularnewline
12 & 19061700 & 19331636 & -269936 \tabularnewline
13 & 19681900 & 21978075.3043478 & -2296175.30434782 \tabularnewline
14 & 34521200 & 21978075.3043478 & 12543124.6956522 \tabularnewline
15 & 19922700 & 21978075.3043478 & -2055375.30434782 \tabularnewline
16 & 20177900 & 19331636 & 846264 \tabularnewline
17 & 19759900 & 21978075.3043478 & -2218175.30434782 \tabularnewline
18 & 23076700 & 21978075.3043478 & 1098624.69565218 \tabularnewline
19 & 22532000 & 21978075.3043478 & 553924.695652176 \tabularnewline
20 & 22029400 & 21978075.3043478 & 51324.6956521757 \tabularnewline
21 & 22587000 & 21978075.3043478 & 608924.695652176 \tabularnewline
22 & 23256600 & 21978075.3043478 & 1278524.69565218 \tabularnewline
23 & 22680300 & 21978075.3043478 & 702224.695652176 \tabularnewline
24 & 21916400 & 21978075.3043478 & -61675.3043478243 \tabularnewline
25 & 19640200 & 19331636 & 308564 \tabularnewline
26 & 18813100 & 19331636 & -518536 \tabularnewline
27 & 18730000 & 17896694.0454545 & 833305.954545453 \tabularnewline
28 & 18154700 & 17896694.0454545 & 258005.954545453 \tabularnewline
29 & 17848800 & 17896694.0454545 & -47894.0454545468 \tabularnewline
30 & 18077500 & 17896694.0454545 & 180805.954545453 \tabularnewline
31 & 17133100 & 17896694.0454545 & -763594.045454547 \tabularnewline
32 & 16602600 & 17065558.75 & -462958.75 \tabularnewline
33 & 15878900 & 15320817.3571429 & 558082.642857144 \tabularnewline
34 & 15789100 & 15320817.3571429 & 468282.642857144 \tabularnewline
35 & 15422000 & 15320817.3571429 & 101182.642857144 \tabularnewline
36 & 14661400 & 15320817.3571429 & -659417.357142856 \tabularnewline
37 & 15879200 & 17065558.75 & -1186358.75 \tabularnewline
38 & 14339300 & 15320817.3571429 & -981517.357142856 \tabularnewline
39 & 13169600 & 12899698.2857143 & 269901.714285715 \tabularnewline
40 & 14528900 & 15320817.3571429 & -791917.357142856 \tabularnewline
41 & 13375800 & 15320817.3571429 & -1945017.35714286 \tabularnewline
42 & 12309900 & 12899698.2857143 & -589798.285714285 \tabularnewline
43 & 11933900 & 12899698.2857143 & -965798.285714285 \tabularnewline
44 & 10061900 & 12899698.2857143 & -2837798.28571429 \tabularnewline
45 & 12609600 & 12899698.2857143 & -290098.285714285 \tabularnewline
46 & 11156500 & 12899698.2857143 & -1743198.28571429 \tabularnewline
47 & 12187200 & 12899698.2857143 & -712498.285714285 \tabularnewline
48 & 11284300 & 12899698.2857143 & -1615398.28571429 \tabularnewline
49 & 10177000 & 12899698.2857143 & -2722698.28571429 \tabularnewline
50 & 10970720 & 12899698.2857143 & -1928978.28571429 \tabularnewline
51 & 10820680 & 12899698.2857143 & -2079018.28571429 \tabularnewline
52 & 11492390 & 12899698.2857143 & -1407308.28571429 \tabularnewline
53 & 14573750 & 12899698.2857143 & 1674051.71428571 \tabularnewline
54 & 13992820 & 12899698.2857143 & 1093121.71428571 \tabularnewline
55 & 14727070 & 12899698.2857143 & 1827371.71428571 \tabularnewline
56 & 15685360 & 15320817.3571429 & 364542.642857144 \tabularnewline
57 & 16736210 & 17065558.75 & -329348.75 \tabularnewline
58 & 17950180 & 17065558.75 & 884621.25 \tabularnewline
59 & 17002730 & 17896694.0454545 & -893964.045454547 \tabularnewline
60 & 17415160 & 17896694.0454545 & -481534.045454547 \tabularnewline
61 & 17929810 & 17896694.0454545 & 33115.9545454532 \tabularnewline
62 & 17865790 & 17896694.0454545 & -30904.0454545468 \tabularnewline
63 & 19202360 & 19331636 & -129276 \tabularnewline
64 & 19085000 & 17896694.0454545 & 1188305.95454545 \tabularnewline
65 & 18188880 & 17065558.75 & 1123321.25 \tabularnewline
66 & 18466410 & 19331636 & -865226 \tabularnewline
67 & 18520400 & 19331636 & -811236 \tabularnewline
68 & 20025500 & 21978075.3043478 & -1952575.30434782 \tabularnewline
69 & 20636100 & 21978075.3043478 & -1341975.30434782 \tabularnewline
70 & 20672000 & 21978075.3043478 & -1306075.30434782 \tabularnewline
71 & 22589100 & 21978075.3043478 & 611024.695652176 \tabularnewline
72 & 21864800 & 21978075.3043478 & -113275.304347824 \tabularnewline
73 & 22750100 & 21978075.3043478 & 772024.695652176 \tabularnewline
74 & 22548746 & 21978075.3043478 & 570670.695652176 \tabularnewline
75 & 21325495 & 21978075.3043478 & -652580.304347824 \tabularnewline
76 & 21556563 & 21978075.3043478 & -421512.304347824 \tabularnewline
77 & 21415269 & 21978075.3043478 & -562806.304347824 \tabularnewline
78 & 20401054 & 19331636 & 1069418 \tabularnewline
79 & 19062253 & 21978075.3043478 & -2915822.30434782 \tabularnewline
80 & 19085706 & 21978075.3043478 & -2892369.30434782 \tabularnewline
81 & 19279967 & 17896694.0454545 & 1383272.95454545 \tabularnewline
82 & 18552045 & 17896694.0454545 & 655350.954545453 \tabularnewline
83 & 17800733 & 17896694.0454545 & -95961.0454545468 \tabularnewline
84 & 17142490 & 17896694.0454545 & -754204.045454547 \tabularnewline
85 & 17593173 & 17896694.0454545 & -303521.045454547 \tabularnewline
86 & 17633859 & 17896694.0454545 & -262835.045454547 \tabularnewline
87 & 17336613 & 15320817.3571429 & 2015795.64285714 \tabularnewline
88 & 17008347 & 17896694.0454545 & -888347.045454547 \tabularnewline
89 & 17951965 & 17896694.0454545 & 55270.9545454532 \tabularnewline
90 & 14520929 & 15320817.3571429 & -799888.357142856 \tabularnewline
91 & 16941217 & 15320817.3571429 & 1620399.64285714 \tabularnewline
92 & 15436824 & 12899698.2857143 & 2537125.71428571 \tabularnewline
93 & 14744261 & 12899698.2857143 & 1844562.71428571 \tabularnewline
94 & 14248004 & 15320817.3571429 & -1072813.35714286 \tabularnewline
95 & 11540953 & 12899698.2857143 & -1358745.28571429 \tabularnewline
96 & 12881661 & 12899698.2857143 & -18037.2857142854 \tabularnewline
97 & 15185757 & 12899698.2857143 & 2286058.71428571 \tabularnewline
98 & 13554339 & 12899698.2857143 & 654640.714285715 \tabularnewline
99 & 13575106 & 12899698.2857143 & 675407.714285715 \tabularnewline
100 & 12238400 & 12899698.2857143 & -661298.285714285 \tabularnewline
101 & 13303614 & 12899698.2857143 & 403915.714285715 \tabularnewline
102 & 14151478 & 12899698.2857143 & 1251779.71428571 \tabularnewline
103 & 14172009 & 12899698.2857143 & 1272310.71428571 \tabularnewline
104 & 14022320 & 12899698.2857143 & 1122621.71428571 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=113787&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]15561600[/C][C]17065558.75[/C][C]-1503958.75[/C][/ROW]
[ROW][C]2[/C][C]14917500[/C][C]12899698.2857143[/C][C]2017801.71428571[/C][/ROW]
[ROW][C]3[/C][C]14805920[/C][C]15320817.3571429[/C][C]-514897.357142856[/C][/ROW]
[ROW][C]4[/C][C]16958000[/C][C]15320817.3571429[/C][C]1637182.64285714[/C][/ROW]
[ROW][C]5[/C][C]17605000[/C][C]17896694.0454545[/C][C]-291694.045454547[/C][/ROW]
[ROW][C]6[/C][C]17131200[/C][C]17065558.75[/C][C]65641.25[/C][/ROW]
[ROW][C]7[/C][C]18474600[/C][C]17065558.75[/C][C]1409041.25[/C][/ROW]
[ROW][C]8[/C][C]17286700[/C][C]17896694.0454545[/C][C]-609994.045454547[/C][/ROW]
[ROW][C]9[/C][C]18574400[/C][C]17896694.0454545[/C][C]677705.954545453[/C][/ROW]
[ROW][C]10[/C][C]18056000[/C][C]17896694.0454545[/C][C]159305.954545453[/C][/ROW]
[ROW][C]11[/C][C]19701600[/C][C]19331636[/C][C]369964[/C][/ROW]
[ROW][C]12[/C][C]19061700[/C][C]19331636[/C][C]-269936[/C][/ROW]
[ROW][C]13[/C][C]19681900[/C][C]21978075.3043478[/C][C]-2296175.30434782[/C][/ROW]
[ROW][C]14[/C][C]34521200[/C][C]21978075.3043478[/C][C]12543124.6956522[/C][/ROW]
[ROW][C]15[/C][C]19922700[/C][C]21978075.3043478[/C][C]-2055375.30434782[/C][/ROW]
[ROW][C]16[/C][C]20177900[/C][C]19331636[/C][C]846264[/C][/ROW]
[ROW][C]17[/C][C]19759900[/C][C]21978075.3043478[/C][C]-2218175.30434782[/C][/ROW]
[ROW][C]18[/C][C]23076700[/C][C]21978075.3043478[/C][C]1098624.69565218[/C][/ROW]
[ROW][C]19[/C][C]22532000[/C][C]21978075.3043478[/C][C]553924.695652176[/C][/ROW]
[ROW][C]20[/C][C]22029400[/C][C]21978075.3043478[/C][C]51324.6956521757[/C][/ROW]
[ROW][C]21[/C][C]22587000[/C][C]21978075.3043478[/C][C]608924.695652176[/C][/ROW]
[ROW][C]22[/C][C]23256600[/C][C]21978075.3043478[/C][C]1278524.69565218[/C][/ROW]
[ROW][C]23[/C][C]22680300[/C][C]21978075.3043478[/C][C]702224.695652176[/C][/ROW]
[ROW][C]24[/C][C]21916400[/C][C]21978075.3043478[/C][C]-61675.3043478243[/C][/ROW]
[ROW][C]25[/C][C]19640200[/C][C]19331636[/C][C]308564[/C][/ROW]
[ROW][C]26[/C][C]18813100[/C][C]19331636[/C][C]-518536[/C][/ROW]
[ROW][C]27[/C][C]18730000[/C][C]17896694.0454545[/C][C]833305.954545453[/C][/ROW]
[ROW][C]28[/C][C]18154700[/C][C]17896694.0454545[/C][C]258005.954545453[/C][/ROW]
[ROW][C]29[/C][C]17848800[/C][C]17896694.0454545[/C][C]-47894.0454545468[/C][/ROW]
[ROW][C]30[/C][C]18077500[/C][C]17896694.0454545[/C][C]180805.954545453[/C][/ROW]
[ROW][C]31[/C][C]17133100[/C][C]17896694.0454545[/C][C]-763594.045454547[/C][/ROW]
[ROW][C]32[/C][C]16602600[/C][C]17065558.75[/C][C]-462958.75[/C][/ROW]
[ROW][C]33[/C][C]15878900[/C][C]15320817.3571429[/C][C]558082.642857144[/C][/ROW]
[ROW][C]34[/C][C]15789100[/C][C]15320817.3571429[/C][C]468282.642857144[/C][/ROW]
[ROW][C]35[/C][C]15422000[/C][C]15320817.3571429[/C][C]101182.642857144[/C][/ROW]
[ROW][C]36[/C][C]14661400[/C][C]15320817.3571429[/C][C]-659417.357142856[/C][/ROW]
[ROW][C]37[/C][C]15879200[/C][C]17065558.75[/C][C]-1186358.75[/C][/ROW]
[ROW][C]38[/C][C]14339300[/C][C]15320817.3571429[/C][C]-981517.357142856[/C][/ROW]
[ROW][C]39[/C][C]13169600[/C][C]12899698.2857143[/C][C]269901.714285715[/C][/ROW]
[ROW][C]40[/C][C]14528900[/C][C]15320817.3571429[/C][C]-791917.357142856[/C][/ROW]
[ROW][C]41[/C][C]13375800[/C][C]15320817.3571429[/C][C]-1945017.35714286[/C][/ROW]
[ROW][C]42[/C][C]12309900[/C][C]12899698.2857143[/C][C]-589798.285714285[/C][/ROW]
[ROW][C]43[/C][C]11933900[/C][C]12899698.2857143[/C][C]-965798.285714285[/C][/ROW]
[ROW][C]44[/C][C]10061900[/C][C]12899698.2857143[/C][C]-2837798.28571429[/C][/ROW]
[ROW][C]45[/C][C]12609600[/C][C]12899698.2857143[/C][C]-290098.285714285[/C][/ROW]
[ROW][C]46[/C][C]11156500[/C][C]12899698.2857143[/C][C]-1743198.28571429[/C][/ROW]
[ROW][C]47[/C][C]12187200[/C][C]12899698.2857143[/C][C]-712498.285714285[/C][/ROW]
[ROW][C]48[/C][C]11284300[/C][C]12899698.2857143[/C][C]-1615398.28571429[/C][/ROW]
[ROW][C]49[/C][C]10177000[/C][C]12899698.2857143[/C][C]-2722698.28571429[/C][/ROW]
[ROW][C]50[/C][C]10970720[/C][C]12899698.2857143[/C][C]-1928978.28571429[/C][/ROW]
[ROW][C]51[/C][C]10820680[/C][C]12899698.2857143[/C][C]-2079018.28571429[/C][/ROW]
[ROW][C]52[/C][C]11492390[/C][C]12899698.2857143[/C][C]-1407308.28571429[/C][/ROW]
[ROW][C]53[/C][C]14573750[/C][C]12899698.2857143[/C][C]1674051.71428571[/C][/ROW]
[ROW][C]54[/C][C]13992820[/C][C]12899698.2857143[/C][C]1093121.71428571[/C][/ROW]
[ROW][C]55[/C][C]14727070[/C][C]12899698.2857143[/C][C]1827371.71428571[/C][/ROW]
[ROW][C]56[/C][C]15685360[/C][C]15320817.3571429[/C][C]364542.642857144[/C][/ROW]
[ROW][C]57[/C][C]16736210[/C][C]17065558.75[/C][C]-329348.75[/C][/ROW]
[ROW][C]58[/C][C]17950180[/C][C]17065558.75[/C][C]884621.25[/C][/ROW]
[ROW][C]59[/C][C]17002730[/C][C]17896694.0454545[/C][C]-893964.045454547[/C][/ROW]
[ROW][C]60[/C][C]17415160[/C][C]17896694.0454545[/C][C]-481534.045454547[/C][/ROW]
[ROW][C]61[/C][C]17929810[/C][C]17896694.0454545[/C][C]33115.9545454532[/C][/ROW]
[ROW][C]62[/C][C]17865790[/C][C]17896694.0454545[/C][C]-30904.0454545468[/C][/ROW]
[ROW][C]63[/C][C]19202360[/C][C]19331636[/C][C]-129276[/C][/ROW]
[ROW][C]64[/C][C]19085000[/C][C]17896694.0454545[/C][C]1188305.95454545[/C][/ROW]
[ROW][C]65[/C][C]18188880[/C][C]17065558.75[/C][C]1123321.25[/C][/ROW]
[ROW][C]66[/C][C]18466410[/C][C]19331636[/C][C]-865226[/C][/ROW]
[ROW][C]67[/C][C]18520400[/C][C]19331636[/C][C]-811236[/C][/ROW]
[ROW][C]68[/C][C]20025500[/C][C]21978075.3043478[/C][C]-1952575.30434782[/C][/ROW]
[ROW][C]69[/C][C]20636100[/C][C]21978075.3043478[/C][C]-1341975.30434782[/C][/ROW]
[ROW][C]70[/C][C]20672000[/C][C]21978075.3043478[/C][C]-1306075.30434782[/C][/ROW]
[ROW][C]71[/C][C]22589100[/C][C]21978075.3043478[/C][C]611024.695652176[/C][/ROW]
[ROW][C]72[/C][C]21864800[/C][C]21978075.3043478[/C][C]-113275.304347824[/C][/ROW]
[ROW][C]73[/C][C]22750100[/C][C]21978075.3043478[/C][C]772024.695652176[/C][/ROW]
[ROW][C]74[/C][C]22548746[/C][C]21978075.3043478[/C][C]570670.695652176[/C][/ROW]
[ROW][C]75[/C][C]21325495[/C][C]21978075.3043478[/C][C]-652580.304347824[/C][/ROW]
[ROW][C]76[/C][C]21556563[/C][C]21978075.3043478[/C][C]-421512.304347824[/C][/ROW]
[ROW][C]77[/C][C]21415269[/C][C]21978075.3043478[/C][C]-562806.304347824[/C][/ROW]
[ROW][C]78[/C][C]20401054[/C][C]19331636[/C][C]1069418[/C][/ROW]
[ROW][C]79[/C][C]19062253[/C][C]21978075.3043478[/C][C]-2915822.30434782[/C][/ROW]
[ROW][C]80[/C][C]19085706[/C][C]21978075.3043478[/C][C]-2892369.30434782[/C][/ROW]
[ROW][C]81[/C][C]19279967[/C][C]17896694.0454545[/C][C]1383272.95454545[/C][/ROW]
[ROW][C]82[/C][C]18552045[/C][C]17896694.0454545[/C][C]655350.954545453[/C][/ROW]
[ROW][C]83[/C][C]17800733[/C][C]17896694.0454545[/C][C]-95961.0454545468[/C][/ROW]
[ROW][C]84[/C][C]17142490[/C][C]17896694.0454545[/C][C]-754204.045454547[/C][/ROW]
[ROW][C]85[/C][C]17593173[/C][C]17896694.0454545[/C][C]-303521.045454547[/C][/ROW]
[ROW][C]86[/C][C]17633859[/C][C]17896694.0454545[/C][C]-262835.045454547[/C][/ROW]
[ROW][C]87[/C][C]17336613[/C][C]15320817.3571429[/C][C]2015795.64285714[/C][/ROW]
[ROW][C]88[/C][C]17008347[/C][C]17896694.0454545[/C][C]-888347.045454547[/C][/ROW]
[ROW][C]89[/C][C]17951965[/C][C]17896694.0454545[/C][C]55270.9545454532[/C][/ROW]
[ROW][C]90[/C][C]14520929[/C][C]15320817.3571429[/C][C]-799888.357142856[/C][/ROW]
[ROW][C]91[/C][C]16941217[/C][C]15320817.3571429[/C][C]1620399.64285714[/C][/ROW]
[ROW][C]92[/C][C]15436824[/C][C]12899698.2857143[/C][C]2537125.71428571[/C][/ROW]
[ROW][C]93[/C][C]14744261[/C][C]12899698.2857143[/C][C]1844562.71428571[/C][/ROW]
[ROW][C]94[/C][C]14248004[/C][C]15320817.3571429[/C][C]-1072813.35714286[/C][/ROW]
[ROW][C]95[/C][C]11540953[/C][C]12899698.2857143[/C][C]-1358745.28571429[/C][/ROW]
[ROW][C]96[/C][C]12881661[/C][C]12899698.2857143[/C][C]-18037.2857142854[/C][/ROW]
[ROW][C]97[/C][C]15185757[/C][C]12899698.2857143[/C][C]2286058.71428571[/C][/ROW]
[ROW][C]98[/C][C]13554339[/C][C]12899698.2857143[/C][C]654640.714285715[/C][/ROW]
[ROW][C]99[/C][C]13575106[/C][C]12899698.2857143[/C][C]675407.714285715[/C][/ROW]
[ROW][C]100[/C][C]12238400[/C][C]12899698.2857143[/C][C]-661298.285714285[/C][/ROW]
[ROW][C]101[/C][C]13303614[/C][C]12899698.2857143[/C][C]403915.714285715[/C][/ROW]
[ROW][C]102[/C][C]14151478[/C][C]12899698.2857143[/C][C]1251779.71428571[/C][/ROW]
[ROW][C]103[/C][C]14172009[/C][C]12899698.2857143[/C][C]1272310.71428571[/C][/ROW]
[ROW][C]104[/C][C]14022320[/C][C]12899698.2857143[/C][C]1122621.71428571[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=113787&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=113787&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
11556160017065558.75-1503958.75
21491750012899698.28571432017801.71428571
31480592015320817.3571429-514897.357142856
41695800015320817.35714291637182.64285714
51760500017896694.0454545-291694.045454547
61713120017065558.7565641.25
71847460017065558.751409041.25
81728670017896694.0454545-609994.045454547
91857440017896694.0454545677705.954545453
101805600017896694.0454545159305.954545453
111970160019331636369964
121906170019331636-269936
131968190021978075.3043478-2296175.30434782
143452120021978075.304347812543124.6956522
151992270021978075.3043478-2055375.30434782
162017790019331636846264
171975990021978075.3043478-2218175.30434782
182307670021978075.30434781098624.69565218
192253200021978075.3043478553924.695652176
202202940021978075.304347851324.6956521757
212258700021978075.3043478608924.695652176
222325660021978075.30434781278524.69565218
232268030021978075.3043478702224.695652176
242191640021978075.3043478-61675.3043478243
251964020019331636308564
261881310019331636-518536
271873000017896694.0454545833305.954545453
281815470017896694.0454545258005.954545453
291784880017896694.0454545-47894.0454545468
301807750017896694.0454545180805.954545453
311713310017896694.0454545-763594.045454547
321660260017065558.75-462958.75
331587890015320817.3571429558082.642857144
341578910015320817.3571429468282.642857144
351542200015320817.3571429101182.642857144
361466140015320817.3571429-659417.357142856
371587920017065558.75-1186358.75
381433930015320817.3571429-981517.357142856
391316960012899698.2857143269901.714285715
401452890015320817.3571429-791917.357142856
411337580015320817.3571429-1945017.35714286
421230990012899698.2857143-589798.285714285
431193390012899698.2857143-965798.285714285
441006190012899698.2857143-2837798.28571429
451260960012899698.2857143-290098.285714285
461115650012899698.2857143-1743198.28571429
471218720012899698.2857143-712498.285714285
481128430012899698.2857143-1615398.28571429
491017700012899698.2857143-2722698.28571429
501097072012899698.2857143-1928978.28571429
511082068012899698.2857143-2079018.28571429
521149239012899698.2857143-1407308.28571429
531457375012899698.28571431674051.71428571
541399282012899698.28571431093121.71428571
551472707012899698.28571431827371.71428571
561568536015320817.3571429364542.642857144
571673621017065558.75-329348.75
581795018017065558.75884621.25
591700273017896694.0454545-893964.045454547
601741516017896694.0454545-481534.045454547
611792981017896694.045454533115.9545454532
621786579017896694.0454545-30904.0454545468
631920236019331636-129276
641908500017896694.04545451188305.95454545
651818888017065558.751123321.25
661846641019331636-865226
671852040019331636-811236
682002550021978075.3043478-1952575.30434782
692063610021978075.3043478-1341975.30434782
702067200021978075.3043478-1306075.30434782
712258910021978075.3043478611024.695652176
722186480021978075.3043478-113275.304347824
732275010021978075.3043478772024.695652176
742254874621978075.3043478570670.695652176
752132549521978075.3043478-652580.304347824
762155656321978075.3043478-421512.304347824
772141526921978075.3043478-562806.304347824
7820401054193316361069418
791906225321978075.3043478-2915822.30434782
801908570621978075.3043478-2892369.30434782
811927996717896694.04545451383272.95454545
821855204517896694.0454545655350.954545453
831780073317896694.0454545-95961.0454545468
841714249017896694.0454545-754204.045454547
851759317317896694.0454545-303521.045454547
861763385917896694.0454545-262835.045454547
871733661315320817.35714292015795.64285714
881700834717896694.0454545-888347.045454547
891795196517896694.045454555270.9545454532
901452092915320817.3571429-799888.357142856
911694121715320817.35714291620399.64285714
921543682412899698.28571432537125.71428571
931474426112899698.28571431844562.71428571
941424800415320817.3571429-1072813.35714286
951154095312899698.2857143-1358745.28571429
961288166112899698.2857143-18037.2857142854
971518575712899698.28571432286058.71428571
981355433912899698.2857143654640.714285715
991357510612899698.2857143675407.714285715
1001223840012899698.2857143-661298.285714285
1011330361412899698.2857143403915.714285715
1021415147812899698.28571431251779.71428571
1031417200912899698.28571431272310.71428571
1041402232012899698.28571431122621.71428571



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')
}