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, 12 Dec 2011 10:52:44 -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/12/t1323705178kp74gia46f5eft5.htm/, Retrieved Fri, 03 May 2024 10:04:53 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=154061, Retrieved Fri, 03 May 2024 10:04:53 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact109
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Kendall tau Correlation Matrix] [] [2010-12-05 17:44:33] [b98453cac15ba1066b407e146608df68]
F   PD  [Kendall tau Correlation Matrix] [Pearson Correlati...] [2010-12-14 16:44:36] [b8e188bcc949964bed729335b3416734]
- RM D    [Kendall tau Correlation Matrix] [WS10 Kendall] [2011-12-12 15:28:22] [b8fde34a99ee6a7d49500940cae4da2a]
- RMP         [Recursive Partitioning (Regression Trees)] [WS10 RP] [2011-12-12 15:52:44] [1eaf8805ffdd770d1a6587425a1bf41e] [Current]
Feedback Forum

Post a new message
Dataseries X:
1407	118540	20	15	59	18158	22622	30
1072	127145	38	16	64	30461	73570	42
192	7215	0	0	0	1423	1929	0
2032	112861	49	22	68	25629	36294	54
3033	197581	70	25	100	48758	62378	86
5519	377410	104	26	100	129230	167760	157
1321	117604	37	19	72	27376	52443	36
1034	120102	46	25	96	26706	57283	48
1388	96175	42	25	90	26505	36614	45
2552	253517	62	26	104	49801	93268	77
1735	108994	50	20	54	46580	35439	49
1788	156212	65	25	98	48352	72405	77
1292	68810	28	15	49	13899	24044	28
2362	149246	48	21	84	39342	55909	84
1150	125503	42	12	45	27465	44689	31
1374	125769	47	19	74	55211	49319	28
1503	123467	71	28	112	74098	62075	99
965	56088	0	12	45	13497	2341	2
2164	108128	50	28	110	38338	40551	41
633	22762	12	13	39	52505	11621	25
837	48554	16	14	55	10663	18741	16
1991	159102	73	23	87	74484	84202	96
1450	139108	29	25	96	28895	15334	23
1765	92058	38	30	86	32827	28024	33
1612	126311	50	17	64	36188	53306	46
1173	113807	33	17	64	28173	37918	59
1603	133994	44	21	79	54926	54819	72
1046	131810	59	24	87	38900	89058	72
2176	279065	47	22	86	88530	103354	62
1767	158146	40	16	63	35482	70239	55
1167	107352	33	23	87	26730	33045	27
1394	149827	50	18	59	29806	63852	41
1733	90912	41	11	43	41799	30905	51
2374	169510	73	20	80	54289	24242	26
1852	162204	43	20	80	36805	78907	65
1	0	0	0	0	0	0	0
1677	163310	41	24	93	33146	36005	28
1505	92342	44	14	51	23333	31972	44
1813	98357	31	29	98	47686	35853	36
1648	178277	71	31	124	77783	115301	100
1560	134927	61	15	60	36042	47689	104
1301	104577	27	30	120	34541	34223	35
784	81614	21	20	75	75620	43431	69
1580	119111	42	20	78	60610	52220	73
897	83923	40	18	71	55041	33863	106
959	109885	34	19	70	32087	46879	53
567	52851	15	28	84	16356	23228	43
1519	153621	46	18	72	40161	42827	49
1625	152572	43	26	104	55459	65765	38
1817	114073	38	23	87	36679	38167	51
658	48188	12	22	82	22346	14812	14
1187	90994	42	19	73	27377	32615	40
1863	215588	56	20	75	50273	82188	79
1559	176489	41	25	92	32104	51763	52
1340	138871	46	27	105	27016	59325	44
1342	104416	30	10	37	19715	48976	34
1505	156186	44	26	96	33629	43384	47
669	60368	25	21	80	27084	26692	32
814	95391	42	19	76	32352	53279	31
2189	126048	28	32	118	51845	20652	40
1291	96388	33	28	112	26591	38338	42
1378	77353	32	16	64	29677	36735	34
1008	83867	22	16	55	54237	42764	40
823	79772	30	20	75	20284	44331	35
789	96945	13	20	73	22741	41354	11
1135	88300	35	24	90	34178	47879	43
1875	126203	39	31	124	69551	103793	53
2289	110681	68	21	78	29653	52235	82
817	81299	32	21	83	38071	49825	41
340	31970	5	21	78	4157	4105	6
2354	185321	53	15	59	28321	58687	82
992	87611	33	9	33	40195	40745	47
984	73165	44	21	84	48158	33187	108
1357	82167	36	18	52	13310	14063	46
2048	109099	52	27	106	78474	37407	38
933	49164	0	24	88	6386	7190	0
1600	105181	49	22	93	31588	49562	45
1821	105922	29	21	83	61254	76324	57
816	60138	16	21	75	21152	21928	20
1121	73422	33	26	96	41272	27860	56
800	67727	48	22	81	34165	28078	38
1447	188098	33	22	88	37054	49577	42
750	51185	24	20	76	12368	28145	37
1171	84448	33	21	78	23168	36241	36
662	41956	16	19	75	16380	10824	34
1284	110827	32	19	74	41242	46892	53
1980	167055	41	25	100	48259	60865	83
879	63603	36	19	76	20790	22933	36
869	64995	22	21	80	34585	20787	33
1000	93424	26	18	65	35672	43978	57
1240	97229	37	23	88	52168	51305	50
1771	112819	57	18	67	53933	55593	71
945	111538	20	21	81	34474	51648	32
1042	102220	24	12	48	43753	30552	45
629	38721	18	9	33	36456	23470	33
1770	168764	37	26	99	51183	77530	53
1454	151588	70	21	81	52742	57299	64
222	19349	13	1	2	3895	9604	14
1529	125440	18	24	96	37076	34684	38
1303	101954	32	18	65	24079	41094	39
552	43803	8	4	15	2325	3439	8
708	47062	38	15	48	29354	25171	38
998	104220	41	19	73	30341	23437	24
872	85939	24	20	72	18992	34086	22
584	58660	23	12	46	15292	24649	18
596	27676	2	16	59	5842	2342	3
926	93448	52	21	84	28918	45571	49
576	43284	5	9	29	3738	3255	5
0	0	0	0	0	0	0	0
868	64333	43	21	75	95352	30002	47
736	57050	18	17	63	37478	19360	33
998	96933	41	18	68	26839	43320	44
915	70088	45	21	84	26783	35513	56
782	65494	29	17	54	33392	23536	49
78	3616	0	0	0	0	0	0
0	0	0	0	0	0	0	0
782	135104	32	19	72	25446	54438	45
1159	95554	41	26	87	60038	56815	80
1646	120307	17	25	100	28162	33838	51
749	84336	24	20	80	33298	32366	25
778	43410	7	1	3	2781	13	1
1335	131452	62	21	82	37121	55082	62
806	79015	30	14	55	22698	31334	29
1390	88043	49	24	88	27615	16612	26
680	57578	3	12	48	32689	5084	4
285	19764	10	2	8	5752	9927	10
1335	105757	42	16	60	23164	47413	43
840	96410	18	22	84	20304	27389	36
1231	105056	39	28	112	34409	30425	43
256	11796	1	2	8	0	0	0
80	7627	0	0	0	0	0	0
1163	117413	29	17	52	92538	33510	33
41	6836	0	1	4	0	0	0
1540	131955	45	17	57	46037	40389	53
42	5118	5	0	0	0	0	0
528	40248	8	4	14	5444	6012	6
0	0	0	0	0	0	0	0
799	77813	16	21	78	23924	22205	19
1086	67140	16	24	82	52230	17231	26
81	7131	0	0	0	0	0	0
61	4194	0	0	0	0	0	0
849	60378	15	15	54	8019	11017	16
970	96971	40	18	69	34542	46741	84
964	83484	17	19	76	21157	39869	28




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 4 seconds \tabularnewline
R Server & 'Herman Ole Andreas Wold' @ wold.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154061&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]4 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Herman Ole Andreas Wold' @ wold.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154061&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154061&T=0

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net







Goodness of Fit
Correlation0.9818
R-squared0.964
RMSE1.485

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.9818[/C][/ROW]
[ROW][C]R-squared[/C][C]0.964[/C][/ROW]
[ROW][C]RMSE[/C][C]1.485[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154061&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154061&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.9818
R-squared0.964
RMSE1.485







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
11516.3461538461538-1.34615384615385
21616.3461538461538-0.346153846153847
300.882352941176471-0.882352941176471
42219.3752.625
52525.6428571428571-0.642857142857142
62625.64285714285710.357142857142858
71919.375-0.375
82525.6428571428571-0.642857142857142
92523.54545454545451.45454545454545
102625.64285714285710.357142857142858
112016.34615384615383.65384615384615
122525.6428571428571-0.642857142857142
131516.3461538461538-1.34615384615385
142123.5454545454545-2.54545454545455
151211.33333333333330.666666666666666
161919.375-0.375
172829-1
181211.33333333333330.666666666666666
192829-1
201311.33333333333331.66666666666667
211416.3461538461538-2.34615384615385
222323.5454545454545-0.545454545454547
232525.6428571428571-0.642857142857142
243023.54545454545456.45454545454545
251716.34615384615380.653846153846153
261716.34615384615380.653846153846153
272121.0526315789474-0.0526315789473699
282423.54545454545450.454545454545453
292223.5454545454545-1.54545454545455
301616.3461538461538-0.346153846153847
312323.5454545454545-0.545454545454547
321816.34615384615381.65384615384615
331111.3333333333333-0.333333333333334
342021.0526315789474-1.05263157894737
352021.0526315789474-1.05263157894737
3600.882352941176471-0.882352941176471
372423.54545454545450.454545454545453
381416.3461538461538-2.34615384615385
392925.64285714285713.35714285714286
4031292
411516.3461538461538-1.34615384615385
4230291
432019.3750.625
442021.0526315789474-1.05263157894737
451819.375-1.375
461919.375-0.375
472823.54545454545454.45454545454545
481819.375-1.375
492625.64285714285710.357142857142858
502323.5454545454545-0.545454545454547
512221.05263157894740.94736842105263
521919.375-0.375
532019.3750.625
542523.54545454545451.45454545454545
552729-2
561011.3333333333333-1.33333333333333
572625.64285714285710.357142857142858
582121.0526315789474-0.0526315789473699
591919.375-0.375
6032293
612829-1
621616.3461538461538-0.346153846153847
631616.3461538461538-0.346153846153847
642019.3750.625
652019.3750.625
662423.54545454545450.454545454545453
6731292
682121.0526315789474-0.0526315789473699
692121.0526315789474-0.0526315789473699
702121.0526315789474-0.0526315789473699
711516.3461538461538-1.34615384615385
72911.3333333333333-2.33333333333333
732123.5454545454545-2.54545454545455
741816.34615384615381.65384615384615
752729-2
762423.54545454545450.454545454545453
772223.5454545454545-1.54545454545455
782121.0526315789474-0.0526315789473699
792119.3751.625
802625.64285714285710.357142857142858
812221.05263157894740.94736842105263
822223.5454545454545-1.54545454545455
832019.3750.625
842121.0526315789474-0.0526315789473699
851919.375-0.375
861919.375-0.375
872525.6428571428571-0.642857142857142
881919.375-0.375
892121.0526315789474-0.0526315789473699
901816.34615384615381.65384615384615
912323.5454545454545-0.545454545454547
921816.34615384615381.65384615384615
932121.0526315789474-0.0526315789473699
941211.33333333333330.666666666666666
95911.3333333333333-2.33333333333333
962625.64285714285710.357142857142858
972121.0526315789474-0.0526315789473699
9810.8823529411764710.117647058823529
992425.6428571428571-1.64285714285714
1001816.34615384615381.65384615384615
10140.8823529411764713.11764705882353
1021511.33333333333333.66666666666667
1031919.375-0.375
1042019.3750.625
1051211.33333333333330.666666666666666
1061616.3461538461538-0.346153846153847
1072123.5454545454545-2.54545454545455
108911.3333333333333-2.33333333333333
10900.882352941176471-0.882352941176471
1102119.3751.625
1111716.34615384615380.653846153846153
1121819.375-1.375
1132123.5454545454545-2.54545454545455
1141716.34615384615380.653846153846153
11500.882352941176471-0.882352941176471
11600.882352941176471-0.882352941176471
1171919.375-0.375
1182623.54545454545452.45454545454545
1192525.6428571428571-0.642857142857142
1202021.0526315789474-1.05263157894737
12110.8823529411764710.117647058823529
1222121.0526315789474-0.0526315789473699
1231416.3461538461538-2.34615384615385
1242423.54545454545450.454545454545453
1251211.33333333333330.666666666666666
12620.8823529411764711.11764705882353
1271616.3461538461538-0.346153846153847
1282223.5454545454545-1.54545454545455
1292829-1
13020.8823529411764711.11764705882353
13100.882352941176471-0.882352941176471
1321716.34615384615380.653846153846153
13310.8823529411764710.117647058823529
1341716.34615384615380.653846153846153
13500.882352941176471-0.882352941176471
13640.8823529411764713.11764705882353
13700.882352941176471-0.882352941176471
1382121.0526315789474-0.0526315789473699
1392421.05263157894742.94736842105263
14000.882352941176471-0.882352941176471
14100.882352941176471-0.882352941176471
1421516.3461538461538-1.34615384615385
1431819.375-1.375
1441919.375-0.375

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 15 & 16.3461538461538 & -1.34615384615385 \tabularnewline
2 & 16 & 16.3461538461538 & -0.346153846153847 \tabularnewline
3 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
4 & 22 & 19.375 & 2.625 \tabularnewline
5 & 25 & 25.6428571428571 & -0.642857142857142 \tabularnewline
6 & 26 & 25.6428571428571 & 0.357142857142858 \tabularnewline
7 & 19 & 19.375 & -0.375 \tabularnewline
8 & 25 & 25.6428571428571 & -0.642857142857142 \tabularnewline
9 & 25 & 23.5454545454545 & 1.45454545454545 \tabularnewline
10 & 26 & 25.6428571428571 & 0.357142857142858 \tabularnewline
11 & 20 & 16.3461538461538 & 3.65384615384615 \tabularnewline
12 & 25 & 25.6428571428571 & -0.642857142857142 \tabularnewline
13 & 15 & 16.3461538461538 & -1.34615384615385 \tabularnewline
14 & 21 & 23.5454545454545 & -2.54545454545455 \tabularnewline
15 & 12 & 11.3333333333333 & 0.666666666666666 \tabularnewline
16 & 19 & 19.375 & -0.375 \tabularnewline
17 & 28 & 29 & -1 \tabularnewline
18 & 12 & 11.3333333333333 & 0.666666666666666 \tabularnewline
19 & 28 & 29 & -1 \tabularnewline
20 & 13 & 11.3333333333333 & 1.66666666666667 \tabularnewline
21 & 14 & 16.3461538461538 & -2.34615384615385 \tabularnewline
22 & 23 & 23.5454545454545 & -0.545454545454547 \tabularnewline
23 & 25 & 25.6428571428571 & -0.642857142857142 \tabularnewline
24 & 30 & 23.5454545454545 & 6.45454545454545 \tabularnewline
25 & 17 & 16.3461538461538 & 0.653846153846153 \tabularnewline
26 & 17 & 16.3461538461538 & 0.653846153846153 \tabularnewline
27 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
28 & 24 & 23.5454545454545 & 0.454545454545453 \tabularnewline
29 & 22 & 23.5454545454545 & -1.54545454545455 \tabularnewline
30 & 16 & 16.3461538461538 & -0.346153846153847 \tabularnewline
31 & 23 & 23.5454545454545 & -0.545454545454547 \tabularnewline
32 & 18 & 16.3461538461538 & 1.65384615384615 \tabularnewline
33 & 11 & 11.3333333333333 & -0.333333333333334 \tabularnewline
34 & 20 & 21.0526315789474 & -1.05263157894737 \tabularnewline
35 & 20 & 21.0526315789474 & -1.05263157894737 \tabularnewline
36 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
37 & 24 & 23.5454545454545 & 0.454545454545453 \tabularnewline
38 & 14 & 16.3461538461538 & -2.34615384615385 \tabularnewline
39 & 29 & 25.6428571428571 & 3.35714285714286 \tabularnewline
40 & 31 & 29 & 2 \tabularnewline
41 & 15 & 16.3461538461538 & -1.34615384615385 \tabularnewline
42 & 30 & 29 & 1 \tabularnewline
43 & 20 & 19.375 & 0.625 \tabularnewline
44 & 20 & 21.0526315789474 & -1.05263157894737 \tabularnewline
45 & 18 & 19.375 & -1.375 \tabularnewline
46 & 19 & 19.375 & -0.375 \tabularnewline
47 & 28 & 23.5454545454545 & 4.45454545454545 \tabularnewline
48 & 18 & 19.375 & -1.375 \tabularnewline
49 & 26 & 25.6428571428571 & 0.357142857142858 \tabularnewline
50 & 23 & 23.5454545454545 & -0.545454545454547 \tabularnewline
51 & 22 & 21.0526315789474 & 0.94736842105263 \tabularnewline
52 & 19 & 19.375 & -0.375 \tabularnewline
53 & 20 & 19.375 & 0.625 \tabularnewline
54 & 25 & 23.5454545454545 & 1.45454545454545 \tabularnewline
55 & 27 & 29 & -2 \tabularnewline
56 & 10 & 11.3333333333333 & -1.33333333333333 \tabularnewline
57 & 26 & 25.6428571428571 & 0.357142857142858 \tabularnewline
58 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
59 & 19 & 19.375 & -0.375 \tabularnewline
60 & 32 & 29 & 3 \tabularnewline
61 & 28 & 29 & -1 \tabularnewline
62 & 16 & 16.3461538461538 & -0.346153846153847 \tabularnewline
63 & 16 & 16.3461538461538 & -0.346153846153847 \tabularnewline
64 & 20 & 19.375 & 0.625 \tabularnewline
65 & 20 & 19.375 & 0.625 \tabularnewline
66 & 24 & 23.5454545454545 & 0.454545454545453 \tabularnewline
67 & 31 & 29 & 2 \tabularnewline
68 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
69 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
70 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
71 & 15 & 16.3461538461538 & -1.34615384615385 \tabularnewline
72 & 9 & 11.3333333333333 & -2.33333333333333 \tabularnewline
73 & 21 & 23.5454545454545 & -2.54545454545455 \tabularnewline
74 & 18 & 16.3461538461538 & 1.65384615384615 \tabularnewline
75 & 27 & 29 & -2 \tabularnewline
76 & 24 & 23.5454545454545 & 0.454545454545453 \tabularnewline
77 & 22 & 23.5454545454545 & -1.54545454545455 \tabularnewline
78 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
79 & 21 & 19.375 & 1.625 \tabularnewline
80 & 26 & 25.6428571428571 & 0.357142857142858 \tabularnewline
81 & 22 & 21.0526315789474 & 0.94736842105263 \tabularnewline
82 & 22 & 23.5454545454545 & -1.54545454545455 \tabularnewline
83 & 20 & 19.375 & 0.625 \tabularnewline
84 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
85 & 19 & 19.375 & -0.375 \tabularnewline
86 & 19 & 19.375 & -0.375 \tabularnewline
87 & 25 & 25.6428571428571 & -0.642857142857142 \tabularnewline
88 & 19 & 19.375 & -0.375 \tabularnewline
89 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
90 & 18 & 16.3461538461538 & 1.65384615384615 \tabularnewline
91 & 23 & 23.5454545454545 & -0.545454545454547 \tabularnewline
92 & 18 & 16.3461538461538 & 1.65384615384615 \tabularnewline
93 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
94 & 12 & 11.3333333333333 & 0.666666666666666 \tabularnewline
95 & 9 & 11.3333333333333 & -2.33333333333333 \tabularnewline
96 & 26 & 25.6428571428571 & 0.357142857142858 \tabularnewline
97 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
98 & 1 & 0.882352941176471 & 0.117647058823529 \tabularnewline
99 & 24 & 25.6428571428571 & -1.64285714285714 \tabularnewline
100 & 18 & 16.3461538461538 & 1.65384615384615 \tabularnewline
101 & 4 & 0.882352941176471 & 3.11764705882353 \tabularnewline
102 & 15 & 11.3333333333333 & 3.66666666666667 \tabularnewline
103 & 19 & 19.375 & -0.375 \tabularnewline
104 & 20 & 19.375 & 0.625 \tabularnewline
105 & 12 & 11.3333333333333 & 0.666666666666666 \tabularnewline
106 & 16 & 16.3461538461538 & -0.346153846153847 \tabularnewline
107 & 21 & 23.5454545454545 & -2.54545454545455 \tabularnewline
108 & 9 & 11.3333333333333 & -2.33333333333333 \tabularnewline
109 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
110 & 21 & 19.375 & 1.625 \tabularnewline
111 & 17 & 16.3461538461538 & 0.653846153846153 \tabularnewline
112 & 18 & 19.375 & -1.375 \tabularnewline
113 & 21 & 23.5454545454545 & -2.54545454545455 \tabularnewline
114 & 17 & 16.3461538461538 & 0.653846153846153 \tabularnewline
115 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
116 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
117 & 19 & 19.375 & -0.375 \tabularnewline
118 & 26 & 23.5454545454545 & 2.45454545454545 \tabularnewline
119 & 25 & 25.6428571428571 & -0.642857142857142 \tabularnewline
120 & 20 & 21.0526315789474 & -1.05263157894737 \tabularnewline
121 & 1 & 0.882352941176471 & 0.117647058823529 \tabularnewline
122 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
123 & 14 & 16.3461538461538 & -2.34615384615385 \tabularnewline
124 & 24 & 23.5454545454545 & 0.454545454545453 \tabularnewline
125 & 12 & 11.3333333333333 & 0.666666666666666 \tabularnewline
126 & 2 & 0.882352941176471 & 1.11764705882353 \tabularnewline
127 & 16 & 16.3461538461538 & -0.346153846153847 \tabularnewline
128 & 22 & 23.5454545454545 & -1.54545454545455 \tabularnewline
129 & 28 & 29 & -1 \tabularnewline
130 & 2 & 0.882352941176471 & 1.11764705882353 \tabularnewline
131 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
132 & 17 & 16.3461538461538 & 0.653846153846153 \tabularnewline
133 & 1 & 0.882352941176471 & 0.117647058823529 \tabularnewline
134 & 17 & 16.3461538461538 & 0.653846153846153 \tabularnewline
135 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
136 & 4 & 0.882352941176471 & 3.11764705882353 \tabularnewline
137 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
138 & 21 & 21.0526315789474 & -0.0526315789473699 \tabularnewline
139 & 24 & 21.0526315789474 & 2.94736842105263 \tabularnewline
140 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
141 & 0 & 0.882352941176471 & -0.882352941176471 \tabularnewline
142 & 15 & 16.3461538461538 & -1.34615384615385 \tabularnewline
143 & 18 & 19.375 & -1.375 \tabularnewline
144 & 19 & 19.375 & -0.375 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154061&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]15[/C][C]16.3461538461538[/C][C]-1.34615384615385[/C][/ROW]
[ROW][C]2[/C][C]16[/C][C]16.3461538461538[/C][C]-0.346153846153847[/C][/ROW]
[ROW][C]3[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]4[/C][C]22[/C][C]19.375[/C][C]2.625[/C][/ROW]
[ROW][C]5[/C][C]25[/C][C]25.6428571428571[/C][C]-0.642857142857142[/C][/ROW]
[ROW][C]6[/C][C]26[/C][C]25.6428571428571[/C][C]0.357142857142858[/C][/ROW]
[ROW][C]7[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]8[/C][C]25[/C][C]25.6428571428571[/C][C]-0.642857142857142[/C][/ROW]
[ROW][C]9[/C][C]25[/C][C]23.5454545454545[/C][C]1.45454545454545[/C][/ROW]
[ROW][C]10[/C][C]26[/C][C]25.6428571428571[/C][C]0.357142857142858[/C][/ROW]
[ROW][C]11[/C][C]20[/C][C]16.3461538461538[/C][C]3.65384615384615[/C][/ROW]
[ROW][C]12[/C][C]25[/C][C]25.6428571428571[/C][C]-0.642857142857142[/C][/ROW]
[ROW][C]13[/C][C]15[/C][C]16.3461538461538[/C][C]-1.34615384615385[/C][/ROW]
[ROW][C]14[/C][C]21[/C][C]23.5454545454545[/C][C]-2.54545454545455[/C][/ROW]
[ROW][C]15[/C][C]12[/C][C]11.3333333333333[/C][C]0.666666666666666[/C][/ROW]
[ROW][C]16[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]17[/C][C]28[/C][C]29[/C][C]-1[/C][/ROW]
[ROW][C]18[/C][C]12[/C][C]11.3333333333333[/C][C]0.666666666666666[/C][/ROW]
[ROW][C]19[/C][C]28[/C][C]29[/C][C]-1[/C][/ROW]
[ROW][C]20[/C][C]13[/C][C]11.3333333333333[/C][C]1.66666666666667[/C][/ROW]
[ROW][C]21[/C][C]14[/C][C]16.3461538461538[/C][C]-2.34615384615385[/C][/ROW]
[ROW][C]22[/C][C]23[/C][C]23.5454545454545[/C][C]-0.545454545454547[/C][/ROW]
[ROW][C]23[/C][C]25[/C][C]25.6428571428571[/C][C]-0.642857142857142[/C][/ROW]
[ROW][C]24[/C][C]30[/C][C]23.5454545454545[/C][C]6.45454545454545[/C][/ROW]
[ROW][C]25[/C][C]17[/C][C]16.3461538461538[/C][C]0.653846153846153[/C][/ROW]
[ROW][C]26[/C][C]17[/C][C]16.3461538461538[/C][C]0.653846153846153[/C][/ROW]
[ROW][C]27[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]28[/C][C]24[/C][C]23.5454545454545[/C][C]0.454545454545453[/C][/ROW]
[ROW][C]29[/C][C]22[/C][C]23.5454545454545[/C][C]-1.54545454545455[/C][/ROW]
[ROW][C]30[/C][C]16[/C][C]16.3461538461538[/C][C]-0.346153846153847[/C][/ROW]
[ROW][C]31[/C][C]23[/C][C]23.5454545454545[/C][C]-0.545454545454547[/C][/ROW]
[ROW][C]32[/C][C]18[/C][C]16.3461538461538[/C][C]1.65384615384615[/C][/ROW]
[ROW][C]33[/C][C]11[/C][C]11.3333333333333[/C][C]-0.333333333333334[/C][/ROW]
[ROW][C]34[/C][C]20[/C][C]21.0526315789474[/C][C]-1.05263157894737[/C][/ROW]
[ROW][C]35[/C][C]20[/C][C]21.0526315789474[/C][C]-1.05263157894737[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]37[/C][C]24[/C][C]23.5454545454545[/C][C]0.454545454545453[/C][/ROW]
[ROW][C]38[/C][C]14[/C][C]16.3461538461538[/C][C]-2.34615384615385[/C][/ROW]
[ROW][C]39[/C][C]29[/C][C]25.6428571428571[/C][C]3.35714285714286[/C][/ROW]
[ROW][C]40[/C][C]31[/C][C]29[/C][C]2[/C][/ROW]
[ROW][C]41[/C][C]15[/C][C]16.3461538461538[/C][C]-1.34615384615385[/C][/ROW]
[ROW][C]42[/C][C]30[/C][C]29[/C][C]1[/C][/ROW]
[ROW][C]43[/C][C]20[/C][C]19.375[/C][C]0.625[/C][/ROW]
[ROW][C]44[/C][C]20[/C][C]21.0526315789474[/C][C]-1.05263157894737[/C][/ROW]
[ROW][C]45[/C][C]18[/C][C]19.375[/C][C]-1.375[/C][/ROW]
[ROW][C]46[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]47[/C][C]28[/C][C]23.5454545454545[/C][C]4.45454545454545[/C][/ROW]
[ROW][C]48[/C][C]18[/C][C]19.375[/C][C]-1.375[/C][/ROW]
[ROW][C]49[/C][C]26[/C][C]25.6428571428571[/C][C]0.357142857142858[/C][/ROW]
[ROW][C]50[/C][C]23[/C][C]23.5454545454545[/C][C]-0.545454545454547[/C][/ROW]
[ROW][C]51[/C][C]22[/C][C]21.0526315789474[/C][C]0.94736842105263[/C][/ROW]
[ROW][C]52[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]53[/C][C]20[/C][C]19.375[/C][C]0.625[/C][/ROW]
[ROW][C]54[/C][C]25[/C][C]23.5454545454545[/C][C]1.45454545454545[/C][/ROW]
[ROW][C]55[/C][C]27[/C][C]29[/C][C]-2[/C][/ROW]
[ROW][C]56[/C][C]10[/C][C]11.3333333333333[/C][C]-1.33333333333333[/C][/ROW]
[ROW][C]57[/C][C]26[/C][C]25.6428571428571[/C][C]0.357142857142858[/C][/ROW]
[ROW][C]58[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]59[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]60[/C][C]32[/C][C]29[/C][C]3[/C][/ROW]
[ROW][C]61[/C][C]28[/C][C]29[/C][C]-1[/C][/ROW]
[ROW][C]62[/C][C]16[/C][C]16.3461538461538[/C][C]-0.346153846153847[/C][/ROW]
[ROW][C]63[/C][C]16[/C][C]16.3461538461538[/C][C]-0.346153846153847[/C][/ROW]
[ROW][C]64[/C][C]20[/C][C]19.375[/C][C]0.625[/C][/ROW]
[ROW][C]65[/C][C]20[/C][C]19.375[/C][C]0.625[/C][/ROW]
[ROW][C]66[/C][C]24[/C][C]23.5454545454545[/C][C]0.454545454545453[/C][/ROW]
[ROW][C]67[/C][C]31[/C][C]29[/C][C]2[/C][/ROW]
[ROW][C]68[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]69[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]70[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]71[/C][C]15[/C][C]16.3461538461538[/C][C]-1.34615384615385[/C][/ROW]
[ROW][C]72[/C][C]9[/C][C]11.3333333333333[/C][C]-2.33333333333333[/C][/ROW]
[ROW][C]73[/C][C]21[/C][C]23.5454545454545[/C][C]-2.54545454545455[/C][/ROW]
[ROW][C]74[/C][C]18[/C][C]16.3461538461538[/C][C]1.65384615384615[/C][/ROW]
[ROW][C]75[/C][C]27[/C][C]29[/C][C]-2[/C][/ROW]
[ROW][C]76[/C][C]24[/C][C]23.5454545454545[/C][C]0.454545454545453[/C][/ROW]
[ROW][C]77[/C][C]22[/C][C]23.5454545454545[/C][C]-1.54545454545455[/C][/ROW]
[ROW][C]78[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]79[/C][C]21[/C][C]19.375[/C][C]1.625[/C][/ROW]
[ROW][C]80[/C][C]26[/C][C]25.6428571428571[/C][C]0.357142857142858[/C][/ROW]
[ROW][C]81[/C][C]22[/C][C]21.0526315789474[/C][C]0.94736842105263[/C][/ROW]
[ROW][C]82[/C][C]22[/C][C]23.5454545454545[/C][C]-1.54545454545455[/C][/ROW]
[ROW][C]83[/C][C]20[/C][C]19.375[/C][C]0.625[/C][/ROW]
[ROW][C]84[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]85[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]86[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]87[/C][C]25[/C][C]25.6428571428571[/C][C]-0.642857142857142[/C][/ROW]
[ROW][C]88[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]89[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]90[/C][C]18[/C][C]16.3461538461538[/C][C]1.65384615384615[/C][/ROW]
[ROW][C]91[/C][C]23[/C][C]23.5454545454545[/C][C]-0.545454545454547[/C][/ROW]
[ROW][C]92[/C][C]18[/C][C]16.3461538461538[/C][C]1.65384615384615[/C][/ROW]
[ROW][C]93[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]94[/C][C]12[/C][C]11.3333333333333[/C][C]0.666666666666666[/C][/ROW]
[ROW][C]95[/C][C]9[/C][C]11.3333333333333[/C][C]-2.33333333333333[/C][/ROW]
[ROW][C]96[/C][C]26[/C][C]25.6428571428571[/C][C]0.357142857142858[/C][/ROW]
[ROW][C]97[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]98[/C][C]1[/C][C]0.882352941176471[/C][C]0.117647058823529[/C][/ROW]
[ROW][C]99[/C][C]24[/C][C]25.6428571428571[/C][C]-1.64285714285714[/C][/ROW]
[ROW][C]100[/C][C]18[/C][C]16.3461538461538[/C][C]1.65384615384615[/C][/ROW]
[ROW][C]101[/C][C]4[/C][C]0.882352941176471[/C][C]3.11764705882353[/C][/ROW]
[ROW][C]102[/C][C]15[/C][C]11.3333333333333[/C][C]3.66666666666667[/C][/ROW]
[ROW][C]103[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]104[/C][C]20[/C][C]19.375[/C][C]0.625[/C][/ROW]
[ROW][C]105[/C][C]12[/C][C]11.3333333333333[/C][C]0.666666666666666[/C][/ROW]
[ROW][C]106[/C][C]16[/C][C]16.3461538461538[/C][C]-0.346153846153847[/C][/ROW]
[ROW][C]107[/C][C]21[/C][C]23.5454545454545[/C][C]-2.54545454545455[/C][/ROW]
[ROW][C]108[/C][C]9[/C][C]11.3333333333333[/C][C]-2.33333333333333[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]110[/C][C]21[/C][C]19.375[/C][C]1.625[/C][/ROW]
[ROW][C]111[/C][C]17[/C][C]16.3461538461538[/C][C]0.653846153846153[/C][/ROW]
[ROW][C]112[/C][C]18[/C][C]19.375[/C][C]-1.375[/C][/ROW]
[ROW][C]113[/C][C]21[/C][C]23.5454545454545[/C][C]-2.54545454545455[/C][/ROW]
[ROW][C]114[/C][C]17[/C][C]16.3461538461538[/C][C]0.653846153846153[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]117[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[ROW][C]118[/C][C]26[/C][C]23.5454545454545[/C][C]2.45454545454545[/C][/ROW]
[ROW][C]119[/C][C]25[/C][C]25.6428571428571[/C][C]-0.642857142857142[/C][/ROW]
[ROW][C]120[/C][C]20[/C][C]21.0526315789474[/C][C]-1.05263157894737[/C][/ROW]
[ROW][C]121[/C][C]1[/C][C]0.882352941176471[/C][C]0.117647058823529[/C][/ROW]
[ROW][C]122[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]123[/C][C]14[/C][C]16.3461538461538[/C][C]-2.34615384615385[/C][/ROW]
[ROW][C]124[/C][C]24[/C][C]23.5454545454545[/C][C]0.454545454545453[/C][/ROW]
[ROW][C]125[/C][C]12[/C][C]11.3333333333333[/C][C]0.666666666666666[/C][/ROW]
[ROW][C]126[/C][C]2[/C][C]0.882352941176471[/C][C]1.11764705882353[/C][/ROW]
[ROW][C]127[/C][C]16[/C][C]16.3461538461538[/C][C]-0.346153846153847[/C][/ROW]
[ROW][C]128[/C][C]22[/C][C]23.5454545454545[/C][C]-1.54545454545455[/C][/ROW]
[ROW][C]129[/C][C]28[/C][C]29[/C][C]-1[/C][/ROW]
[ROW][C]130[/C][C]2[/C][C]0.882352941176471[/C][C]1.11764705882353[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]132[/C][C]17[/C][C]16.3461538461538[/C][C]0.653846153846153[/C][/ROW]
[ROW][C]133[/C][C]1[/C][C]0.882352941176471[/C][C]0.117647058823529[/C][/ROW]
[ROW][C]134[/C][C]17[/C][C]16.3461538461538[/C][C]0.653846153846153[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]136[/C][C]4[/C][C]0.882352941176471[/C][C]3.11764705882353[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]138[/C][C]21[/C][C]21.0526315789474[/C][C]-0.0526315789473699[/C][/ROW]
[ROW][C]139[/C][C]24[/C][C]21.0526315789474[/C][C]2.94736842105263[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]141[/C][C]0[/C][C]0.882352941176471[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]142[/C][C]15[/C][C]16.3461538461538[/C][C]-1.34615384615385[/C][/ROW]
[ROW][C]143[/C][C]18[/C][C]19.375[/C][C]-1.375[/C][/ROW]
[ROW][C]144[/C][C]19[/C][C]19.375[/C][C]-0.375[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154061&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154061&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
11516.3461538461538-1.34615384615385
21616.3461538461538-0.346153846153847
300.882352941176471-0.882352941176471
42219.3752.625
52525.6428571428571-0.642857142857142
62625.64285714285710.357142857142858
71919.375-0.375
82525.6428571428571-0.642857142857142
92523.54545454545451.45454545454545
102625.64285714285710.357142857142858
112016.34615384615383.65384615384615
122525.6428571428571-0.642857142857142
131516.3461538461538-1.34615384615385
142123.5454545454545-2.54545454545455
151211.33333333333330.666666666666666
161919.375-0.375
172829-1
181211.33333333333330.666666666666666
192829-1
201311.33333333333331.66666666666667
211416.3461538461538-2.34615384615385
222323.5454545454545-0.545454545454547
232525.6428571428571-0.642857142857142
243023.54545454545456.45454545454545
251716.34615384615380.653846153846153
261716.34615384615380.653846153846153
272121.0526315789474-0.0526315789473699
282423.54545454545450.454545454545453
292223.5454545454545-1.54545454545455
301616.3461538461538-0.346153846153847
312323.5454545454545-0.545454545454547
321816.34615384615381.65384615384615
331111.3333333333333-0.333333333333334
342021.0526315789474-1.05263157894737
352021.0526315789474-1.05263157894737
3600.882352941176471-0.882352941176471
372423.54545454545450.454545454545453
381416.3461538461538-2.34615384615385
392925.64285714285713.35714285714286
4031292
411516.3461538461538-1.34615384615385
4230291
432019.3750.625
442021.0526315789474-1.05263157894737
451819.375-1.375
461919.375-0.375
472823.54545454545454.45454545454545
481819.375-1.375
492625.64285714285710.357142857142858
502323.5454545454545-0.545454545454547
512221.05263157894740.94736842105263
521919.375-0.375
532019.3750.625
542523.54545454545451.45454545454545
552729-2
561011.3333333333333-1.33333333333333
572625.64285714285710.357142857142858
582121.0526315789474-0.0526315789473699
591919.375-0.375
6032293
612829-1
621616.3461538461538-0.346153846153847
631616.3461538461538-0.346153846153847
642019.3750.625
652019.3750.625
662423.54545454545450.454545454545453
6731292
682121.0526315789474-0.0526315789473699
692121.0526315789474-0.0526315789473699
702121.0526315789474-0.0526315789473699
711516.3461538461538-1.34615384615385
72911.3333333333333-2.33333333333333
732123.5454545454545-2.54545454545455
741816.34615384615381.65384615384615
752729-2
762423.54545454545450.454545454545453
772223.5454545454545-1.54545454545455
782121.0526315789474-0.0526315789473699
792119.3751.625
802625.64285714285710.357142857142858
812221.05263157894740.94736842105263
822223.5454545454545-1.54545454545455
832019.3750.625
842121.0526315789474-0.0526315789473699
851919.375-0.375
861919.375-0.375
872525.6428571428571-0.642857142857142
881919.375-0.375
892121.0526315789474-0.0526315789473699
901816.34615384615381.65384615384615
912323.5454545454545-0.545454545454547
921816.34615384615381.65384615384615
932121.0526315789474-0.0526315789473699
941211.33333333333330.666666666666666
95911.3333333333333-2.33333333333333
962625.64285714285710.357142857142858
972121.0526315789474-0.0526315789473699
9810.8823529411764710.117647058823529
992425.6428571428571-1.64285714285714
1001816.34615384615381.65384615384615
10140.8823529411764713.11764705882353
1021511.33333333333333.66666666666667
1031919.375-0.375
1042019.3750.625
1051211.33333333333330.666666666666666
1061616.3461538461538-0.346153846153847
1072123.5454545454545-2.54545454545455
108911.3333333333333-2.33333333333333
10900.882352941176471-0.882352941176471
1102119.3751.625
1111716.34615384615380.653846153846153
1121819.375-1.375
1132123.5454545454545-2.54545454545455
1141716.34615384615380.653846153846153
11500.882352941176471-0.882352941176471
11600.882352941176471-0.882352941176471
1171919.375-0.375
1182623.54545454545452.45454545454545
1192525.6428571428571-0.642857142857142
1202021.0526315789474-1.05263157894737
12110.8823529411764710.117647058823529
1222121.0526315789474-0.0526315789473699
1231416.3461538461538-2.34615384615385
1242423.54545454545450.454545454545453
1251211.33333333333330.666666666666666
12620.8823529411764711.11764705882353
1271616.3461538461538-0.346153846153847
1282223.5454545454545-1.54545454545455
1292829-1
13020.8823529411764711.11764705882353
13100.882352941176471-0.882352941176471
1321716.34615384615380.653846153846153
13310.8823529411764710.117647058823529
1341716.34615384615380.653846153846153
13500.882352941176471-0.882352941176471
13640.8823529411764713.11764705882353
13700.882352941176471-0.882352941176471
1382121.0526315789474-0.0526315789473699
1392421.05263157894742.94736842105263
14000.882352941176471-0.882352941176471
14100.882352941176471-0.882352941176471
1421516.3461538461538-1.34615384615385
1431819.375-1.375
1441919.375-0.375



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