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 computationMon, 10 Dec 2012 09:59: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/2012/Dec/10/t13551515908nnv6oohxcrzomj.htm/, Retrieved Fri, 19 Apr 2024 20:17:01 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=198177, Retrieved Fri, 19 Apr 2024 20:17:01 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact89
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)] [WS 10 No ] [2012-12-10 14:59:18] [885fe6c051c4f145d5c497ce1b2b5522] [Current]
Feedback Forum

Post a new message
Dataseries X:
18897	22424	19364	19434	22831	23072	37471	14690
17518	22125	18586	18389	22727	22551	36160	13824
8632	7653	8225	8405	8344	8695	9197	9477
832	554	822	854	830	935	1051	1150
3351	3357	3270	3346	3235	3329	3480	3447
8	8	3	4	5	5	4	4
1	1	1	1	1	1	1	2
7	10	11	9	10	9	10	9
217	222	204	205	191	197	196	191
911	947	918	939	937	967	1007	962
1932	1901	1862	1921	1823	1879	1982	2003
274	267	270	267	269	271	281	276
131	109	87	66	68	64	76	81
1708	1668	1738	1715	1726	1771	1861	2079
2609	1965	2308	2424	2486	2594	2729	2720
133	32	119	89	93	107	102	23
2476	1933	2189	2335	2393	2487	2627	2697
10	37	23	21	22	27	21	18
1510	1616	1378	1605	1534	1654	1421	1650
6427	7719	8279	6133	11706	9235	24339	1324
3812	5127	5890	4487	7888	6772	9522	3656
724	99	154	157	367	153	171	-211
1560	1996	1917	1223	2860	1964	13508	-2076
156	113	166	116	435	166	975	-178
3	3	2	2	15	13	27	13
172	380	151	148	141	167	137	120
65	1700	163	568	80	2043	768	338
593	2931	292	1348	774	631	122	698
281	469	227	309	266	267	292	321
1191	145	747	874	38	275	423	218
72	57	2	32	32	57	16	21
113	-6	27	120	32	184	860	604
19	86	2	18	3	3	12	246
97	11	27	120	32	185	860	381
18897	22424	19364	19434	22831	23072	37471	14690
16770	18775	17704	16289	21687	20252	35933	13873
6132	5145	5705	5818	5817	6171	6504	6749
648	299	484	535	511	548	638	758
1739	1710	1776	1910	1843	1990	2141	2097
160	167	176	193	183	202	163	179
621	570	592	743	655	735	851	835
804	821	842	831	847	869	886	881
3	3	3	3	3	3	3	3
150	149	163	140	156	182	238	199
549	528	558	354	470	438	450	453
95	80	132	-46	88	49	57	62
354	353	339	323	308	314	325	322
100	95	87	77	73	75	68	70
342	343	357	354	339	343	343	305
2854	2265	2530	2664	2653	2852	2932	3135
167	99	168	132	137	147	132	35
2687	2166	2362	2533	2516	2705	2799	3100
645	770	634	680	581	675	814	677
6113	7729	8065	5931	11602	9279	24726	1473
3567	4697	5792	4959	8473	6753	9199	3926
472	241	87	262	330	64	172	-142
1665	2360	1934	584	2229	1972	13856	-2338
328	318	154	6	256	181	1301	-241
0	1	0	0	12	10	21	10
81	112	99	120	302	300	177	259
1322	1286	1317	1325	1314	1322	1308	1370
154	143	156	152	144	151	151	171
1277	1448	1340	1689	1529	1544	1264	1656
1127	2253	486	694	699	1110	1165	1776
456	1356	63	2861	89	82	1019	926
224	200	149	91	165	216	94	131
1444	1990	1445	176	888	2517	413	-264
3	8	4	7	40	38	-64	-10
1444	2084	1443	187	850	2483	489	-231






Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time5 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net
R Framework error message
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.

\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 & 5 seconds \tabularnewline
R Server & 'Herman Ole Andreas Wold' @ wold.wessa.net \tabularnewline
R Framework error message & 
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.
\tabularnewline \hline \end{tabular} %Source: https://freestatistics.org/blog/index.php?pk=198177&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]5 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Herman Ole Andreas Wold' @ wold.wessa.net[/C][/ROW]
[ROW][C]R Framework error message[/C][C]
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.
[/C][/ROW] [/TABLE] Source: https://freestatistics.org/blog/index.php?pk=198177&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=198177&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 time5 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net
R Framework error message
Warning: there are blank lines in the 'Data X' field.
Please, use NA for missing data - blank lines are simply
 deleted and are NOT treated as missing values.







Goodness of Fit
Correlation0.9242
R-squared0.8542
RMSE2114.561

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.9242[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8542[/C][/ROW]
[ROW][C]RMSE[/C][C]2114.561[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=198177&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=198177&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.9242
R-squared0.8542
RMSE2114.561







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
12283117389.71428571435441.28571428571
22272717389.71428571435337.28571428571
3834417389.7142857143-9045.71428571429
48301283.72727272727-453.727272727273
532354055-820
6522.7692307692308-17.7692307692308
7122.7692307692308-21.7692307692308
81022.7692307692308-12.7692307692308
9191197.052631578947-6.05263157894737
109371283.72727272727-346.727272727273
1118231283.72727272727539.272727272727
12269197.05263157894771.9473684210526
1368197.052631578947-129.052631578947
1417261283.72727272727442.272727272727
1524864055-1569
1693197.052631578947-104.052631578947
1723934055-1662
182222.7692307692308-0.76923076923077
1915341283.72727272727250.272727272727
201170617389.7142857143-5683.71428571429
21788840553833
22367197.052631578947169.947368421053
2328604055-1195
24435197.052631578947237.947368421053
251522.7692307692308-7.76923076923077
26141197.052631578947-56.0526315789474
2780197.052631578947-117.052631578947
28774486.111111111111287.888888888889
29266197.05263157894768.9473684210526
3038486.111111111111-448.111111111111
313222.76923076923089.23076923076923
323222.76923076923089.23076923076923
33322.7692307692308-19.7692307692308
343222.76923076923089.23076923076923
352283117389.71428571435441.28571428571
362168717389.71428571434297.28571428571
37581740551762
38511486.11111111111124.8888888888889
3918431283.72727272727559.272727272727
40183197.052631578947-14.0526315789474
41655486.111111111111168.888888888889
428471283.72727272727-436.727272727273
43322.7692307692308-19.7692307692308
44156197.052631578947-41.0526315789474
45470486.111111111111-16.1111111111111
4688197.052631578947-109.052631578947
47308486.111111111111-178.111111111111
4873197.052631578947-124.052631578947
49339486.111111111111-147.111111111111
5026534055-1402
51137197.052631578947-60.0526315789474
5225164055-1539
53581486.11111111111194.8888888888889
541160217389.7142857143-5787.71428571429
55847340554418
56330197.052631578947132.947368421053
5722294055-1826
58256197.05263157894758.9473684210526
591222.7692307692308-10.7692307692308
60302197.052631578947104.947368421053
6113141283.7272727272730.2727272727273
62144197.052631578947-53.0526315789474
6315291283.72727272727245.272727272727
64699486.111111111111212.888888888889
658922.769230769230866.2307692307692
66165197.052631578947-32.0526315789474
678881283.72727272727-395.727272727273
684022.769230769230817.2307692307692
698501283.72727272727-433.727272727273

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 22831 & 17389.7142857143 & 5441.28571428571 \tabularnewline
2 & 22727 & 17389.7142857143 & 5337.28571428571 \tabularnewline
3 & 8344 & 17389.7142857143 & -9045.71428571429 \tabularnewline
4 & 830 & 1283.72727272727 & -453.727272727273 \tabularnewline
5 & 3235 & 4055 & -820 \tabularnewline
6 & 5 & 22.7692307692308 & -17.7692307692308 \tabularnewline
7 & 1 & 22.7692307692308 & -21.7692307692308 \tabularnewline
8 & 10 & 22.7692307692308 & -12.7692307692308 \tabularnewline
9 & 191 & 197.052631578947 & -6.05263157894737 \tabularnewline
10 & 937 & 1283.72727272727 & -346.727272727273 \tabularnewline
11 & 1823 & 1283.72727272727 & 539.272727272727 \tabularnewline
12 & 269 & 197.052631578947 & 71.9473684210526 \tabularnewline
13 & 68 & 197.052631578947 & -129.052631578947 \tabularnewline
14 & 1726 & 1283.72727272727 & 442.272727272727 \tabularnewline
15 & 2486 & 4055 & -1569 \tabularnewline
16 & 93 & 197.052631578947 & -104.052631578947 \tabularnewline
17 & 2393 & 4055 & -1662 \tabularnewline
18 & 22 & 22.7692307692308 & -0.76923076923077 \tabularnewline
19 & 1534 & 1283.72727272727 & 250.272727272727 \tabularnewline
20 & 11706 & 17389.7142857143 & -5683.71428571429 \tabularnewline
21 & 7888 & 4055 & 3833 \tabularnewline
22 & 367 & 197.052631578947 & 169.947368421053 \tabularnewline
23 & 2860 & 4055 & -1195 \tabularnewline
24 & 435 & 197.052631578947 & 237.947368421053 \tabularnewline
25 & 15 & 22.7692307692308 & -7.76923076923077 \tabularnewline
26 & 141 & 197.052631578947 & -56.0526315789474 \tabularnewline
27 & 80 & 197.052631578947 & -117.052631578947 \tabularnewline
28 & 774 & 486.111111111111 & 287.888888888889 \tabularnewline
29 & 266 & 197.052631578947 & 68.9473684210526 \tabularnewline
30 & 38 & 486.111111111111 & -448.111111111111 \tabularnewline
31 & 32 & 22.7692307692308 & 9.23076923076923 \tabularnewline
32 & 32 & 22.7692307692308 & 9.23076923076923 \tabularnewline
33 & 3 & 22.7692307692308 & -19.7692307692308 \tabularnewline
34 & 32 & 22.7692307692308 & 9.23076923076923 \tabularnewline
35 & 22831 & 17389.7142857143 & 5441.28571428571 \tabularnewline
36 & 21687 & 17389.7142857143 & 4297.28571428571 \tabularnewline
37 & 5817 & 4055 & 1762 \tabularnewline
38 & 511 & 486.111111111111 & 24.8888888888889 \tabularnewline
39 & 1843 & 1283.72727272727 & 559.272727272727 \tabularnewline
40 & 183 & 197.052631578947 & -14.0526315789474 \tabularnewline
41 & 655 & 486.111111111111 & 168.888888888889 \tabularnewline
42 & 847 & 1283.72727272727 & -436.727272727273 \tabularnewline
43 & 3 & 22.7692307692308 & -19.7692307692308 \tabularnewline
44 & 156 & 197.052631578947 & -41.0526315789474 \tabularnewline
45 & 470 & 486.111111111111 & -16.1111111111111 \tabularnewline
46 & 88 & 197.052631578947 & -109.052631578947 \tabularnewline
47 & 308 & 486.111111111111 & -178.111111111111 \tabularnewline
48 & 73 & 197.052631578947 & -124.052631578947 \tabularnewline
49 & 339 & 486.111111111111 & -147.111111111111 \tabularnewline
50 & 2653 & 4055 & -1402 \tabularnewline
51 & 137 & 197.052631578947 & -60.0526315789474 \tabularnewline
52 & 2516 & 4055 & -1539 \tabularnewline
53 & 581 & 486.111111111111 & 94.8888888888889 \tabularnewline
54 & 11602 & 17389.7142857143 & -5787.71428571429 \tabularnewline
55 & 8473 & 4055 & 4418 \tabularnewline
56 & 330 & 197.052631578947 & 132.947368421053 \tabularnewline
57 & 2229 & 4055 & -1826 \tabularnewline
58 & 256 & 197.052631578947 & 58.9473684210526 \tabularnewline
59 & 12 & 22.7692307692308 & -10.7692307692308 \tabularnewline
60 & 302 & 197.052631578947 & 104.947368421053 \tabularnewline
61 & 1314 & 1283.72727272727 & 30.2727272727273 \tabularnewline
62 & 144 & 197.052631578947 & -53.0526315789474 \tabularnewline
63 & 1529 & 1283.72727272727 & 245.272727272727 \tabularnewline
64 & 699 & 486.111111111111 & 212.888888888889 \tabularnewline
65 & 89 & 22.7692307692308 & 66.2307692307692 \tabularnewline
66 & 165 & 197.052631578947 & -32.0526315789474 \tabularnewline
67 & 888 & 1283.72727272727 & -395.727272727273 \tabularnewline
68 & 40 & 22.7692307692308 & 17.2307692307692 \tabularnewline
69 & 850 & 1283.72727272727 & -433.727272727273 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=198177&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]22831[/C][C]17389.7142857143[/C][C]5441.28571428571[/C][/ROW]
[ROW][C]2[/C][C]22727[/C][C]17389.7142857143[/C][C]5337.28571428571[/C][/ROW]
[ROW][C]3[/C][C]8344[/C][C]17389.7142857143[/C][C]-9045.71428571429[/C][/ROW]
[ROW][C]4[/C][C]830[/C][C]1283.72727272727[/C][C]-453.727272727273[/C][/ROW]
[ROW][C]5[/C][C]3235[/C][C]4055[/C][C]-820[/C][/ROW]
[ROW][C]6[/C][C]5[/C][C]22.7692307692308[/C][C]-17.7692307692308[/C][/ROW]
[ROW][C]7[/C][C]1[/C][C]22.7692307692308[/C][C]-21.7692307692308[/C][/ROW]
[ROW][C]8[/C][C]10[/C][C]22.7692307692308[/C][C]-12.7692307692308[/C][/ROW]
[ROW][C]9[/C][C]191[/C][C]197.052631578947[/C][C]-6.05263157894737[/C][/ROW]
[ROW][C]10[/C][C]937[/C][C]1283.72727272727[/C][C]-346.727272727273[/C][/ROW]
[ROW][C]11[/C][C]1823[/C][C]1283.72727272727[/C][C]539.272727272727[/C][/ROW]
[ROW][C]12[/C][C]269[/C][C]197.052631578947[/C][C]71.9473684210526[/C][/ROW]
[ROW][C]13[/C][C]68[/C][C]197.052631578947[/C][C]-129.052631578947[/C][/ROW]
[ROW][C]14[/C][C]1726[/C][C]1283.72727272727[/C][C]442.272727272727[/C][/ROW]
[ROW][C]15[/C][C]2486[/C][C]4055[/C][C]-1569[/C][/ROW]
[ROW][C]16[/C][C]93[/C][C]197.052631578947[/C][C]-104.052631578947[/C][/ROW]
[ROW][C]17[/C][C]2393[/C][C]4055[/C][C]-1662[/C][/ROW]
[ROW][C]18[/C][C]22[/C][C]22.7692307692308[/C][C]-0.76923076923077[/C][/ROW]
[ROW][C]19[/C][C]1534[/C][C]1283.72727272727[/C][C]250.272727272727[/C][/ROW]
[ROW][C]20[/C][C]11706[/C][C]17389.7142857143[/C][C]-5683.71428571429[/C][/ROW]
[ROW][C]21[/C][C]7888[/C][C]4055[/C][C]3833[/C][/ROW]
[ROW][C]22[/C][C]367[/C][C]197.052631578947[/C][C]169.947368421053[/C][/ROW]
[ROW][C]23[/C][C]2860[/C][C]4055[/C][C]-1195[/C][/ROW]
[ROW][C]24[/C][C]435[/C][C]197.052631578947[/C][C]237.947368421053[/C][/ROW]
[ROW][C]25[/C][C]15[/C][C]22.7692307692308[/C][C]-7.76923076923077[/C][/ROW]
[ROW][C]26[/C][C]141[/C][C]197.052631578947[/C][C]-56.0526315789474[/C][/ROW]
[ROW][C]27[/C][C]80[/C][C]197.052631578947[/C][C]-117.052631578947[/C][/ROW]
[ROW][C]28[/C][C]774[/C][C]486.111111111111[/C][C]287.888888888889[/C][/ROW]
[ROW][C]29[/C][C]266[/C][C]197.052631578947[/C][C]68.9473684210526[/C][/ROW]
[ROW][C]30[/C][C]38[/C][C]486.111111111111[/C][C]-448.111111111111[/C][/ROW]
[ROW][C]31[/C][C]32[/C][C]22.7692307692308[/C][C]9.23076923076923[/C][/ROW]
[ROW][C]32[/C][C]32[/C][C]22.7692307692308[/C][C]9.23076923076923[/C][/ROW]
[ROW][C]33[/C][C]3[/C][C]22.7692307692308[/C][C]-19.7692307692308[/C][/ROW]
[ROW][C]34[/C][C]32[/C][C]22.7692307692308[/C][C]9.23076923076923[/C][/ROW]
[ROW][C]35[/C][C]22831[/C][C]17389.7142857143[/C][C]5441.28571428571[/C][/ROW]
[ROW][C]36[/C][C]21687[/C][C]17389.7142857143[/C][C]4297.28571428571[/C][/ROW]
[ROW][C]37[/C][C]5817[/C][C]4055[/C][C]1762[/C][/ROW]
[ROW][C]38[/C][C]511[/C][C]486.111111111111[/C][C]24.8888888888889[/C][/ROW]
[ROW][C]39[/C][C]1843[/C][C]1283.72727272727[/C][C]559.272727272727[/C][/ROW]
[ROW][C]40[/C][C]183[/C][C]197.052631578947[/C][C]-14.0526315789474[/C][/ROW]
[ROW][C]41[/C][C]655[/C][C]486.111111111111[/C][C]168.888888888889[/C][/ROW]
[ROW][C]42[/C][C]847[/C][C]1283.72727272727[/C][C]-436.727272727273[/C][/ROW]
[ROW][C]43[/C][C]3[/C][C]22.7692307692308[/C][C]-19.7692307692308[/C][/ROW]
[ROW][C]44[/C][C]156[/C][C]197.052631578947[/C][C]-41.0526315789474[/C][/ROW]
[ROW][C]45[/C][C]470[/C][C]486.111111111111[/C][C]-16.1111111111111[/C][/ROW]
[ROW][C]46[/C][C]88[/C][C]197.052631578947[/C][C]-109.052631578947[/C][/ROW]
[ROW][C]47[/C][C]308[/C][C]486.111111111111[/C][C]-178.111111111111[/C][/ROW]
[ROW][C]48[/C][C]73[/C][C]197.052631578947[/C][C]-124.052631578947[/C][/ROW]
[ROW][C]49[/C][C]339[/C][C]486.111111111111[/C][C]-147.111111111111[/C][/ROW]
[ROW][C]50[/C][C]2653[/C][C]4055[/C][C]-1402[/C][/ROW]
[ROW][C]51[/C][C]137[/C][C]197.052631578947[/C][C]-60.0526315789474[/C][/ROW]
[ROW][C]52[/C][C]2516[/C][C]4055[/C][C]-1539[/C][/ROW]
[ROW][C]53[/C][C]581[/C][C]486.111111111111[/C][C]94.8888888888889[/C][/ROW]
[ROW][C]54[/C][C]11602[/C][C]17389.7142857143[/C][C]-5787.71428571429[/C][/ROW]
[ROW][C]55[/C][C]8473[/C][C]4055[/C][C]4418[/C][/ROW]
[ROW][C]56[/C][C]330[/C][C]197.052631578947[/C][C]132.947368421053[/C][/ROW]
[ROW][C]57[/C][C]2229[/C][C]4055[/C][C]-1826[/C][/ROW]
[ROW][C]58[/C][C]256[/C][C]197.052631578947[/C][C]58.9473684210526[/C][/ROW]
[ROW][C]59[/C][C]12[/C][C]22.7692307692308[/C][C]-10.7692307692308[/C][/ROW]
[ROW][C]60[/C][C]302[/C][C]197.052631578947[/C][C]104.947368421053[/C][/ROW]
[ROW][C]61[/C][C]1314[/C][C]1283.72727272727[/C][C]30.2727272727273[/C][/ROW]
[ROW][C]62[/C][C]144[/C][C]197.052631578947[/C][C]-53.0526315789474[/C][/ROW]
[ROW][C]63[/C][C]1529[/C][C]1283.72727272727[/C][C]245.272727272727[/C][/ROW]
[ROW][C]64[/C][C]699[/C][C]486.111111111111[/C][C]212.888888888889[/C][/ROW]
[ROW][C]65[/C][C]89[/C][C]22.7692307692308[/C][C]66.2307692307692[/C][/ROW]
[ROW][C]66[/C][C]165[/C][C]197.052631578947[/C][C]-32.0526315789474[/C][/ROW]
[ROW][C]67[/C][C]888[/C][C]1283.72727272727[/C][C]-395.727272727273[/C][/ROW]
[ROW][C]68[/C][C]40[/C][C]22.7692307692308[/C][C]17.2307692307692[/C][/ROW]
[ROW][C]69[/C][C]850[/C][C]1283.72727272727[/C][C]-433.727272727273[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=198177&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=198177&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
12283117389.71428571435441.28571428571
22272717389.71428571435337.28571428571
3834417389.7142857143-9045.71428571429
48301283.72727272727-453.727272727273
532354055-820
6522.7692307692308-17.7692307692308
7122.7692307692308-21.7692307692308
81022.7692307692308-12.7692307692308
9191197.052631578947-6.05263157894737
109371283.72727272727-346.727272727273
1118231283.72727272727539.272727272727
12269197.05263157894771.9473684210526
1368197.052631578947-129.052631578947
1417261283.72727272727442.272727272727
1524864055-1569
1693197.052631578947-104.052631578947
1723934055-1662
182222.7692307692308-0.76923076923077
1915341283.72727272727250.272727272727
201170617389.7142857143-5683.71428571429
21788840553833
22367197.052631578947169.947368421053
2328604055-1195
24435197.052631578947237.947368421053
251522.7692307692308-7.76923076923077
26141197.052631578947-56.0526315789474
2780197.052631578947-117.052631578947
28774486.111111111111287.888888888889
29266197.05263157894768.9473684210526
3038486.111111111111-448.111111111111
313222.76923076923089.23076923076923
323222.76923076923089.23076923076923
33322.7692307692308-19.7692307692308
343222.76923076923089.23076923076923
352283117389.71428571435441.28571428571
362168717389.71428571434297.28571428571
37581740551762
38511486.11111111111124.8888888888889
3918431283.72727272727559.272727272727
40183197.052631578947-14.0526315789474
41655486.111111111111168.888888888889
428471283.72727272727-436.727272727273
43322.7692307692308-19.7692307692308
44156197.052631578947-41.0526315789474
45470486.111111111111-16.1111111111111
4688197.052631578947-109.052631578947
47308486.111111111111-178.111111111111
4873197.052631578947-124.052631578947
49339486.111111111111-147.111111111111
5026534055-1402
51137197.052631578947-60.0526315789474
5225164055-1539
53581486.11111111111194.8888888888889
541160217389.7142857143-5787.71428571429
55847340554418
56330197.052631578947132.947368421053
5722294055-1826
58256197.05263157894758.9473684210526
591222.7692307692308-10.7692307692308
60302197.052631578947104.947368421053
6113141283.7272727272730.2727272727273
62144197.052631578947-53.0526315789474
6315291283.72727272727245.272727272727
64699486.111111111111212.888888888889
658922.769230769230866.2307692307692
66165197.052631578947-32.0526315789474
678881283.72727272727-395.727272727273
684022.769230769230817.2307692307692
698501283.72727272727-433.727272727273



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