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 computationWed, 21 Dec 2011 10:38:26 -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/21/t1324481944mqhlvwcua7eh1of.htm/, Retrieved Tue, 07 May 2024 17:36:24 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158835, Retrieved Tue, 07 May 2024 17:36:24 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact70
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]
- RMPD  [Kendall tau Correlation Matrix] [] [2011-12-21 14:27:57] [d67971843857ce8a39847b8686da437b]
- RM        [Recursive Partitioning (Regression Trees)] [] [2011-12-21 15:38:26] [ca36d8cfd9bd2eaa3526f9b8acfa6465] [Current]
Feedback Forum

Post a new message
Dataseries X:
1801	159261	91	19	6200	0	37
1717	189672	59	20	10265	1	43
192	7215	18	0	603	0	0
2295	129098	95	27	8874	0	54
3450	230632	136	31	20323	0	86
6861	515038	263	36	26258	1	181
1795	180745	56	23	10165	1	42
1681	185559	59	30	8247	0	59
1897	154581	44	30	8683	0	46
2974	298001	96	26	16957	1	77
1946	121844	75	24	8058	2	49
2148	184039	69	30	20488	0	79
1832	100324	98	22	7945	0	37
3183	220269	119	28	13448	4	92
1476	168265	58	18	5389	4	31
1567	154647	88	22	6185	3	28
1756	142018	57	33	24369	0	103
1247	79030	61	15	70	5	2
2779	167047	87	34	17327	0	48
726	27997	24	18	3878	0	25
1048	73019	59	15	3149	0	16
2805	241082	100	30	20517	0	106
1760	195820	72	25	2570	0	35
2266	142001	54	34	5162	1	33
1848	145433	86	21	5299	1	45
1665	183744	32	21	7233	0	64
2084	202357	163	25	15657	0	73
1440	199532	93	31	15329	0	78
2741	354924	118	31	14881	0	63
2112	192399	44	20	16318	0	69
1684	182286	44	28	9556	0	36
1616	181590	45	22	10462	2	41
2227	133801	105	17	7192	4	59
3088	233686	123	25	4362	0	33
2389	219428	53	24	14349	1	76
1	0	1	0	0	0	0
2099	223044	63	28	10881	0	27
1669	100129	51	14	8022	3	44
2137	145864	49	35	13073	9	43
2153	249965	64	34	26641	0	104
2390	242379	71	22	14426	2	120
1701	145794	59	34	15604	0	44
983	96404	32	23	9184	2	71
2161	195891	78	24	5989	1	78
1276	117156	50	26	11270	2	106
1190	157787	95	22	13958	2	61
745	81293	32	35	7162	1	53
2330	237435	101	24	13275	0	51
2289	233155	89	31	21224	1	46
2639	160344	59	26	10615	8	55
658	48188	28	22	2102	0	14
1917	161922	69	21	12396	0	44
2557	307432	74	27	18717	0	113
2026	235223	79	30	9724	0	55
1911	195583	59	33	9863	1	46
1716	146061	56	11	8374	8	39
1852	208834	67	26	8030	0	51
981	93764	24	26	7509	1	31
1177	151985	66	23	14146	0	36
2833	193222	96	38	7768	10	47
1688	148922	60	31	13823	6	53
2097	132856	80	20	7230	0	38
1331	129561	61	22	10170	11	52
1244	112718	37	26	7573	3	37
1256	160930	35	26	5753	0	11
1294	99184	41	33	9791	0	45
2303	192535	70	36	19365	8	59
2897	138708	65	25	9422	2	82
1103	114408	38	24	12310	0	49
340	31970	15	21	1283	0	6
2791	225558	112	19	6372	3	81
1338	139220	72	12	5413	1	56
1441	113612	68	30	10837	2	105
1623	108641	71	21	3394	1	46
2650	162203	67	34	12964	0	46
1499	100098	44	32	3495	2	2
2302	174768	60	28	11580	1	51
2540	158459	97	28	9970	0	95
1000	80934	30	21	4911	0	18
1234	84971	71	31	10138	0	55
927	80545	68	26	14697	0	48
2176	287191	64	29	8464	0	48
957	62974	28	23	4204	1	39
1551	134091	40	25	10226	0	40
1014	75555	46	22	3456	0	36
1771	162154	54	26	8895	0	60
2613	226638	227	33	22557	0	114
1205	115367	112	24	6900	0	39
1337	108749	62	24	8620	7	45
1524	155537	52	21	7820	0	59
1829	153133	41	28	12112	5	59
2229	165618	78	27	13178	1	93
1233	151517	57	25	7028	0	35
1365	133686	58	15	6616	0	47
950	61342	40	13	9570	0	36
2319	245196	117	36	14612	0	59
1857	195576	70	24	11219	0	79
223	19349	12	1	786	0	14
2390	225371	105	24	11252	3	42
1985	153213	78	31	9289	0	41
700	59117	29	4	593	0	8
1062	91762	24	21	6562	0	41
1311	136769	54	23	8208	0	24
1157	114798	61	23	7488	1	22
823	85338	40	12	4574	1	18
596	27676	22	16	522	0	1
1545	153535	48	29	12840	0	53
1130	122417	37	26	1350	0	6
0	0	0	0	0	0	0
1082	91529	32	25	10623	0	49
1135	107205	67	21	5322	0	33
1367	144664	45	23	7987	0	50
1506	146445	63	21	10566	1	64
870	76656	60	21	1900	0	53
78	3616	5	0	0	0	0
0	0	0	0	0	0	0
1130	183088	44	23	10698	0	48
1582	144677	84	33	14884	0	90
2034	159104	98	30	6852	2	46
919	113273	38	23	6873	0	29
778	43410	19	1	4	0	1
1752	175774	73	29	9188	1	64
957	95401	42	18	5141	0	29
2098	134837	55	33	4260	8	27
731	60493	40	12	443	3	4
285	19764	12	2	2416	1	10
1834	164062	56	21	9831	3	47
1148	132696	33	28	5953	0	44
1646	155367	54	29	9435	0	51
256	11796	9	2	0	0	0
98	10674	9	0	0	0	0
1404	142261	57	18	7642	0	38
41	6836	3	1	0	0	0
1824	162563	63	21	6837	6	57
42	5118	3	0	0	0	0
528	40248	16	4	775	1	6
0	0	0	0	0	0	0
1073	122641	47	25	8191	0	22
1305	88837	38	26	1661	0	34
81	7131	4	0	0	1	0
261	9056	14	4	548	0	10
934	76611	24	17	3080	1	16
1180	132697	51	21	13400	0	93
1147	100681	19	22	8181	1	22




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

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

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







Goodness of Fit
Correlation0.7686
R-squared0.5908
RMSE23.9621

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7686[/C][/ROW]
[ROW][C]R-squared[/C][C]0.5908[/C][/ROW]
[ROW][C]RMSE[/C][C]23.9621[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158835&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158835&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.7686
R-squared0.5908
RMSE23.9621







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
19160.842105263157930.1578947368421
25960.8421052631579-1.8421052631579
3188.411764705882359.58823529411765
49579.571428571428615.4285714285714
5136119.14285714285716.8571428571429
6263119.142857142857143.857142857143
75660.8421052631579-4.8421052631579
85960.8421052631579-1.8421052631579
94460.8421052631579-16.8421052631579
1096119.142857142857-23.1428571428571
117579.5714285714286-4.57142857142857
126979.5714285714286-10.5714285714286
139860.842105263157937.1578947368421
14119119.142857142857-0.142857142857139
155860.8421052631579-2.8421052631579
168860.842105263157927.1578947368421
175760.8421052631579-3.8421052631579
186160.84210526315790.157894736842103
1987119.142857142857-32.1428571428571
202437.2857142857143-13.2857142857143
215937.285714285714321.7142857142857
22100119.142857142857-19.1428571428571
237260.842105263157911.1578947368421
245479.5714285714286-25.5714285714286
258660.842105263157925.1578947368421
263260.8421052631579-28.8421052631579
2716379.571428571428683.4285714285714
289360.842105263157932.1578947368421
29118119.142857142857-1.14285714285714
304479.5714285714286-35.5714285714286
314460.8421052631579-16.8421052631579
324560.8421052631579-15.8421052631579
3310579.571428571428625.4285714285714
34123119.1428571428573.85714285714286
355379.5714285714286-26.5714285714286
3618.41176470588235-7.41176470588235
376379.5714285714286-16.5714285714286
385160.8421052631579-9.8421052631579
394979.5714285714286-30.5714285714286
406479.5714285714286-15.5714285714286
417179.5714285714286-8.57142857142857
425960.8421052631579-1.8421052631579
433237.2857142857143-5.28571428571428
447879.5714285714286-1.57142857142857
455060.8421052631579-10.8421052631579
469560.842105263157934.1578947368421
473237.2857142857143-5.28571428571428
4810179.571428571428621.4285714285714
498979.57142857142869.42857142857143
5059119.142857142857-60.1428571428571
512837.2857142857143-9.28571428571428
526960.84210526315798.1578947368421
537479.5714285714286-5.57142857142857
547979.5714285714286-0.571428571428569
555960.8421052631579-1.8421052631579
565660.8421052631579-4.8421052631579
576760.84210526315796.1578947368421
582437.2857142857143-13.2857142857143
596660.84210526315795.1578947368421
6096119.142857142857-23.1428571428571
616060.8421052631579-0.842105263157897
628079.57142857142860.428571428571431
636160.84210526315790.157894736842103
643760.8421052631579-23.8421052631579
653560.8421052631579-25.8421052631579
664160.8421052631579-19.8421052631579
677079.5714285714286-9.57142857142857
6865119.142857142857-54.1428571428571
693837.28571428571430.714285714285715
70158.411764705882356.58823529411765
71112119.142857142857-7.14285714285714
727260.842105263157911.1578947368421
736860.84210526315797.1578947368421
747160.842105263157910.1578947368421
7567119.142857142857-52.1428571428571
764460.8421052631579-16.8421052631579
776079.5714285714286-19.5714285714286
789779.571428571428617.4285714285714
793037.2857142857143-7.28571428571428
807160.842105263157910.1578947368421
816837.285714285714330.7142857142857
826479.5714285714286-15.5714285714286
832837.2857142857143-9.28571428571428
844060.8421052631579-20.8421052631579
854637.28571428571438.71428571428572
865460.8421052631579-6.8421052631579
87227119.142857142857107.857142857143
8811260.842105263157951.1578947368421
896260.84210526315791.1578947368421
905260.8421052631579-8.8421052631579
914160.8421052631579-19.8421052631579
927879.5714285714286-1.57142857142857
935760.8421052631579-3.8421052631579
945860.8421052631579-2.8421052631579
954037.28571428571432.71428571428572
9611779.571428571428637.4285714285714
977060.84210526315799.1578947368421
98128.411764705882353.58823529411765
9910579.571428571428625.4285714285714
1007879.5714285714286-1.57142857142857
1012937.2857142857143-8.28571428571428
1022437.2857142857143-13.2857142857143
1035460.8421052631579-6.8421052631579
1046160.84210526315790.157894736842103
1054037.28571428571432.71428571428572
106228.4117647058823513.5882352941176
1074860.8421052631579-12.8421052631579
1083737.2857142857143-0.285714285714285
10908.41176470588235-8.41176470588235
1103237.2857142857143-5.28571428571428
1116737.285714285714329.7142857142857
1124560.8421052631579-15.8421052631579
1136360.84210526315792.1578947368421
1146037.285714285714322.7142857142857
11558.41176470588235-3.41176470588235
11608.41176470588235-8.41176470588235
1174437.28571428571436.71428571428572
1188460.842105263157923.1578947368421
1199879.571428571428618.4285714285714
1203837.28571428571430.714285714285715
1211937.2857142857143-18.2857142857143
1227360.842105263157912.1578947368421
1234237.28571428571434.71428571428572
1245579.5714285714286-24.5714285714286
1254037.28571428571432.71428571428572
126128.411764705882353.58823529411765
1275660.8421052631579-4.8421052631579
1283337.2857142857143-4.28571428571428
1295460.8421052631579-6.8421052631579
13098.411764705882350.588235294117647
13198.411764705882350.588235294117647
1325760.8421052631579-3.8421052631579
13338.41176470588235-5.41176470588235
1346360.84210526315792.1578947368421
13538.41176470588235-5.41176470588235
136168.411764705882357.58823529411765
13708.41176470588235-8.41176470588235
1384737.28571428571439.71428571428572
1393860.8421052631579-22.8421052631579
14048.41176470588235-4.41176470588235
141148.411764705882355.58823529411765
1422437.2857142857143-13.2857142857143
1435160.8421052631579-9.8421052631579
1441937.2857142857143-18.2857142857143

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 91 & 60.8421052631579 & 30.1578947368421 \tabularnewline
2 & 59 & 60.8421052631579 & -1.8421052631579 \tabularnewline
3 & 18 & 8.41176470588235 & 9.58823529411765 \tabularnewline
4 & 95 & 79.5714285714286 & 15.4285714285714 \tabularnewline
5 & 136 & 119.142857142857 & 16.8571428571429 \tabularnewline
6 & 263 & 119.142857142857 & 143.857142857143 \tabularnewline
7 & 56 & 60.8421052631579 & -4.8421052631579 \tabularnewline
8 & 59 & 60.8421052631579 & -1.8421052631579 \tabularnewline
9 & 44 & 60.8421052631579 & -16.8421052631579 \tabularnewline
10 & 96 & 119.142857142857 & -23.1428571428571 \tabularnewline
11 & 75 & 79.5714285714286 & -4.57142857142857 \tabularnewline
12 & 69 & 79.5714285714286 & -10.5714285714286 \tabularnewline
13 & 98 & 60.8421052631579 & 37.1578947368421 \tabularnewline
14 & 119 & 119.142857142857 & -0.142857142857139 \tabularnewline
15 & 58 & 60.8421052631579 & -2.8421052631579 \tabularnewline
16 & 88 & 60.8421052631579 & 27.1578947368421 \tabularnewline
17 & 57 & 60.8421052631579 & -3.8421052631579 \tabularnewline
18 & 61 & 60.8421052631579 & 0.157894736842103 \tabularnewline
19 & 87 & 119.142857142857 & -32.1428571428571 \tabularnewline
20 & 24 & 37.2857142857143 & -13.2857142857143 \tabularnewline
21 & 59 & 37.2857142857143 & 21.7142857142857 \tabularnewline
22 & 100 & 119.142857142857 & -19.1428571428571 \tabularnewline
23 & 72 & 60.8421052631579 & 11.1578947368421 \tabularnewline
24 & 54 & 79.5714285714286 & -25.5714285714286 \tabularnewline
25 & 86 & 60.8421052631579 & 25.1578947368421 \tabularnewline
26 & 32 & 60.8421052631579 & -28.8421052631579 \tabularnewline
27 & 163 & 79.5714285714286 & 83.4285714285714 \tabularnewline
28 & 93 & 60.8421052631579 & 32.1578947368421 \tabularnewline
29 & 118 & 119.142857142857 & -1.14285714285714 \tabularnewline
30 & 44 & 79.5714285714286 & -35.5714285714286 \tabularnewline
31 & 44 & 60.8421052631579 & -16.8421052631579 \tabularnewline
32 & 45 & 60.8421052631579 & -15.8421052631579 \tabularnewline
33 & 105 & 79.5714285714286 & 25.4285714285714 \tabularnewline
34 & 123 & 119.142857142857 & 3.85714285714286 \tabularnewline
35 & 53 & 79.5714285714286 & -26.5714285714286 \tabularnewline
36 & 1 & 8.41176470588235 & -7.41176470588235 \tabularnewline
37 & 63 & 79.5714285714286 & -16.5714285714286 \tabularnewline
38 & 51 & 60.8421052631579 & -9.8421052631579 \tabularnewline
39 & 49 & 79.5714285714286 & -30.5714285714286 \tabularnewline
40 & 64 & 79.5714285714286 & -15.5714285714286 \tabularnewline
41 & 71 & 79.5714285714286 & -8.57142857142857 \tabularnewline
42 & 59 & 60.8421052631579 & -1.8421052631579 \tabularnewline
43 & 32 & 37.2857142857143 & -5.28571428571428 \tabularnewline
44 & 78 & 79.5714285714286 & -1.57142857142857 \tabularnewline
45 & 50 & 60.8421052631579 & -10.8421052631579 \tabularnewline
46 & 95 & 60.8421052631579 & 34.1578947368421 \tabularnewline
47 & 32 & 37.2857142857143 & -5.28571428571428 \tabularnewline
48 & 101 & 79.5714285714286 & 21.4285714285714 \tabularnewline
49 & 89 & 79.5714285714286 & 9.42857142857143 \tabularnewline
50 & 59 & 119.142857142857 & -60.1428571428571 \tabularnewline
51 & 28 & 37.2857142857143 & -9.28571428571428 \tabularnewline
52 & 69 & 60.8421052631579 & 8.1578947368421 \tabularnewline
53 & 74 & 79.5714285714286 & -5.57142857142857 \tabularnewline
54 & 79 & 79.5714285714286 & -0.571428571428569 \tabularnewline
55 & 59 & 60.8421052631579 & -1.8421052631579 \tabularnewline
56 & 56 & 60.8421052631579 & -4.8421052631579 \tabularnewline
57 & 67 & 60.8421052631579 & 6.1578947368421 \tabularnewline
58 & 24 & 37.2857142857143 & -13.2857142857143 \tabularnewline
59 & 66 & 60.8421052631579 & 5.1578947368421 \tabularnewline
60 & 96 & 119.142857142857 & -23.1428571428571 \tabularnewline
61 & 60 & 60.8421052631579 & -0.842105263157897 \tabularnewline
62 & 80 & 79.5714285714286 & 0.428571428571431 \tabularnewline
63 & 61 & 60.8421052631579 & 0.157894736842103 \tabularnewline
64 & 37 & 60.8421052631579 & -23.8421052631579 \tabularnewline
65 & 35 & 60.8421052631579 & -25.8421052631579 \tabularnewline
66 & 41 & 60.8421052631579 & -19.8421052631579 \tabularnewline
67 & 70 & 79.5714285714286 & -9.57142857142857 \tabularnewline
68 & 65 & 119.142857142857 & -54.1428571428571 \tabularnewline
69 & 38 & 37.2857142857143 & 0.714285714285715 \tabularnewline
70 & 15 & 8.41176470588235 & 6.58823529411765 \tabularnewline
71 & 112 & 119.142857142857 & -7.14285714285714 \tabularnewline
72 & 72 & 60.8421052631579 & 11.1578947368421 \tabularnewline
73 & 68 & 60.8421052631579 & 7.1578947368421 \tabularnewline
74 & 71 & 60.8421052631579 & 10.1578947368421 \tabularnewline
75 & 67 & 119.142857142857 & -52.1428571428571 \tabularnewline
76 & 44 & 60.8421052631579 & -16.8421052631579 \tabularnewline
77 & 60 & 79.5714285714286 & -19.5714285714286 \tabularnewline
78 & 97 & 79.5714285714286 & 17.4285714285714 \tabularnewline
79 & 30 & 37.2857142857143 & -7.28571428571428 \tabularnewline
80 & 71 & 60.8421052631579 & 10.1578947368421 \tabularnewline
81 & 68 & 37.2857142857143 & 30.7142857142857 \tabularnewline
82 & 64 & 79.5714285714286 & -15.5714285714286 \tabularnewline
83 & 28 & 37.2857142857143 & -9.28571428571428 \tabularnewline
84 & 40 & 60.8421052631579 & -20.8421052631579 \tabularnewline
85 & 46 & 37.2857142857143 & 8.71428571428572 \tabularnewline
86 & 54 & 60.8421052631579 & -6.8421052631579 \tabularnewline
87 & 227 & 119.142857142857 & 107.857142857143 \tabularnewline
88 & 112 & 60.8421052631579 & 51.1578947368421 \tabularnewline
89 & 62 & 60.8421052631579 & 1.1578947368421 \tabularnewline
90 & 52 & 60.8421052631579 & -8.8421052631579 \tabularnewline
91 & 41 & 60.8421052631579 & -19.8421052631579 \tabularnewline
92 & 78 & 79.5714285714286 & -1.57142857142857 \tabularnewline
93 & 57 & 60.8421052631579 & -3.8421052631579 \tabularnewline
94 & 58 & 60.8421052631579 & -2.8421052631579 \tabularnewline
95 & 40 & 37.2857142857143 & 2.71428571428572 \tabularnewline
96 & 117 & 79.5714285714286 & 37.4285714285714 \tabularnewline
97 & 70 & 60.8421052631579 & 9.1578947368421 \tabularnewline
98 & 12 & 8.41176470588235 & 3.58823529411765 \tabularnewline
99 & 105 & 79.5714285714286 & 25.4285714285714 \tabularnewline
100 & 78 & 79.5714285714286 & -1.57142857142857 \tabularnewline
101 & 29 & 37.2857142857143 & -8.28571428571428 \tabularnewline
102 & 24 & 37.2857142857143 & -13.2857142857143 \tabularnewline
103 & 54 & 60.8421052631579 & -6.8421052631579 \tabularnewline
104 & 61 & 60.8421052631579 & 0.157894736842103 \tabularnewline
105 & 40 & 37.2857142857143 & 2.71428571428572 \tabularnewline
106 & 22 & 8.41176470588235 & 13.5882352941176 \tabularnewline
107 & 48 & 60.8421052631579 & -12.8421052631579 \tabularnewline
108 & 37 & 37.2857142857143 & -0.285714285714285 \tabularnewline
109 & 0 & 8.41176470588235 & -8.41176470588235 \tabularnewline
110 & 32 & 37.2857142857143 & -5.28571428571428 \tabularnewline
111 & 67 & 37.2857142857143 & 29.7142857142857 \tabularnewline
112 & 45 & 60.8421052631579 & -15.8421052631579 \tabularnewline
113 & 63 & 60.8421052631579 & 2.1578947368421 \tabularnewline
114 & 60 & 37.2857142857143 & 22.7142857142857 \tabularnewline
115 & 5 & 8.41176470588235 & -3.41176470588235 \tabularnewline
116 & 0 & 8.41176470588235 & -8.41176470588235 \tabularnewline
117 & 44 & 37.2857142857143 & 6.71428571428572 \tabularnewline
118 & 84 & 60.8421052631579 & 23.1578947368421 \tabularnewline
119 & 98 & 79.5714285714286 & 18.4285714285714 \tabularnewline
120 & 38 & 37.2857142857143 & 0.714285714285715 \tabularnewline
121 & 19 & 37.2857142857143 & -18.2857142857143 \tabularnewline
122 & 73 & 60.8421052631579 & 12.1578947368421 \tabularnewline
123 & 42 & 37.2857142857143 & 4.71428571428572 \tabularnewline
124 & 55 & 79.5714285714286 & -24.5714285714286 \tabularnewline
125 & 40 & 37.2857142857143 & 2.71428571428572 \tabularnewline
126 & 12 & 8.41176470588235 & 3.58823529411765 \tabularnewline
127 & 56 & 60.8421052631579 & -4.8421052631579 \tabularnewline
128 & 33 & 37.2857142857143 & -4.28571428571428 \tabularnewline
129 & 54 & 60.8421052631579 & -6.8421052631579 \tabularnewline
130 & 9 & 8.41176470588235 & 0.588235294117647 \tabularnewline
131 & 9 & 8.41176470588235 & 0.588235294117647 \tabularnewline
132 & 57 & 60.8421052631579 & -3.8421052631579 \tabularnewline
133 & 3 & 8.41176470588235 & -5.41176470588235 \tabularnewline
134 & 63 & 60.8421052631579 & 2.1578947368421 \tabularnewline
135 & 3 & 8.41176470588235 & -5.41176470588235 \tabularnewline
136 & 16 & 8.41176470588235 & 7.58823529411765 \tabularnewline
137 & 0 & 8.41176470588235 & -8.41176470588235 \tabularnewline
138 & 47 & 37.2857142857143 & 9.71428571428572 \tabularnewline
139 & 38 & 60.8421052631579 & -22.8421052631579 \tabularnewline
140 & 4 & 8.41176470588235 & -4.41176470588235 \tabularnewline
141 & 14 & 8.41176470588235 & 5.58823529411765 \tabularnewline
142 & 24 & 37.2857142857143 & -13.2857142857143 \tabularnewline
143 & 51 & 60.8421052631579 & -9.8421052631579 \tabularnewline
144 & 19 & 37.2857142857143 & -18.2857142857143 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158835&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]91[/C][C]60.8421052631579[/C][C]30.1578947368421[/C][/ROW]
[ROW][C]2[/C][C]59[/C][C]60.8421052631579[/C][C]-1.8421052631579[/C][/ROW]
[ROW][C]3[/C][C]18[/C][C]8.41176470588235[/C][C]9.58823529411765[/C][/ROW]
[ROW][C]4[/C][C]95[/C][C]79.5714285714286[/C][C]15.4285714285714[/C][/ROW]
[ROW][C]5[/C][C]136[/C][C]119.142857142857[/C][C]16.8571428571429[/C][/ROW]
[ROW][C]6[/C][C]263[/C][C]119.142857142857[/C][C]143.857142857143[/C][/ROW]
[ROW][C]7[/C][C]56[/C][C]60.8421052631579[/C][C]-4.8421052631579[/C][/ROW]
[ROW][C]8[/C][C]59[/C][C]60.8421052631579[/C][C]-1.8421052631579[/C][/ROW]
[ROW][C]9[/C][C]44[/C][C]60.8421052631579[/C][C]-16.8421052631579[/C][/ROW]
[ROW][C]10[/C][C]96[/C][C]119.142857142857[/C][C]-23.1428571428571[/C][/ROW]
[ROW][C]11[/C][C]75[/C][C]79.5714285714286[/C][C]-4.57142857142857[/C][/ROW]
[ROW][C]12[/C][C]69[/C][C]79.5714285714286[/C][C]-10.5714285714286[/C][/ROW]
[ROW][C]13[/C][C]98[/C][C]60.8421052631579[/C][C]37.1578947368421[/C][/ROW]
[ROW][C]14[/C][C]119[/C][C]119.142857142857[/C][C]-0.142857142857139[/C][/ROW]
[ROW][C]15[/C][C]58[/C][C]60.8421052631579[/C][C]-2.8421052631579[/C][/ROW]
[ROW][C]16[/C][C]88[/C][C]60.8421052631579[/C][C]27.1578947368421[/C][/ROW]
[ROW][C]17[/C][C]57[/C][C]60.8421052631579[/C][C]-3.8421052631579[/C][/ROW]
[ROW][C]18[/C][C]61[/C][C]60.8421052631579[/C][C]0.157894736842103[/C][/ROW]
[ROW][C]19[/C][C]87[/C][C]119.142857142857[/C][C]-32.1428571428571[/C][/ROW]
[ROW][C]20[/C][C]24[/C][C]37.2857142857143[/C][C]-13.2857142857143[/C][/ROW]
[ROW][C]21[/C][C]59[/C][C]37.2857142857143[/C][C]21.7142857142857[/C][/ROW]
[ROW][C]22[/C][C]100[/C][C]119.142857142857[/C][C]-19.1428571428571[/C][/ROW]
[ROW][C]23[/C][C]72[/C][C]60.8421052631579[/C][C]11.1578947368421[/C][/ROW]
[ROW][C]24[/C][C]54[/C][C]79.5714285714286[/C][C]-25.5714285714286[/C][/ROW]
[ROW][C]25[/C][C]86[/C][C]60.8421052631579[/C][C]25.1578947368421[/C][/ROW]
[ROW][C]26[/C][C]32[/C][C]60.8421052631579[/C][C]-28.8421052631579[/C][/ROW]
[ROW][C]27[/C][C]163[/C][C]79.5714285714286[/C][C]83.4285714285714[/C][/ROW]
[ROW][C]28[/C][C]93[/C][C]60.8421052631579[/C][C]32.1578947368421[/C][/ROW]
[ROW][C]29[/C][C]118[/C][C]119.142857142857[/C][C]-1.14285714285714[/C][/ROW]
[ROW][C]30[/C][C]44[/C][C]79.5714285714286[/C][C]-35.5714285714286[/C][/ROW]
[ROW][C]31[/C][C]44[/C][C]60.8421052631579[/C][C]-16.8421052631579[/C][/ROW]
[ROW][C]32[/C][C]45[/C][C]60.8421052631579[/C][C]-15.8421052631579[/C][/ROW]
[ROW][C]33[/C][C]105[/C][C]79.5714285714286[/C][C]25.4285714285714[/C][/ROW]
[ROW][C]34[/C][C]123[/C][C]119.142857142857[/C][C]3.85714285714286[/C][/ROW]
[ROW][C]35[/C][C]53[/C][C]79.5714285714286[/C][C]-26.5714285714286[/C][/ROW]
[ROW][C]36[/C][C]1[/C][C]8.41176470588235[/C][C]-7.41176470588235[/C][/ROW]
[ROW][C]37[/C][C]63[/C][C]79.5714285714286[/C][C]-16.5714285714286[/C][/ROW]
[ROW][C]38[/C][C]51[/C][C]60.8421052631579[/C][C]-9.8421052631579[/C][/ROW]
[ROW][C]39[/C][C]49[/C][C]79.5714285714286[/C][C]-30.5714285714286[/C][/ROW]
[ROW][C]40[/C][C]64[/C][C]79.5714285714286[/C][C]-15.5714285714286[/C][/ROW]
[ROW][C]41[/C][C]71[/C][C]79.5714285714286[/C][C]-8.57142857142857[/C][/ROW]
[ROW][C]42[/C][C]59[/C][C]60.8421052631579[/C][C]-1.8421052631579[/C][/ROW]
[ROW][C]43[/C][C]32[/C][C]37.2857142857143[/C][C]-5.28571428571428[/C][/ROW]
[ROW][C]44[/C][C]78[/C][C]79.5714285714286[/C][C]-1.57142857142857[/C][/ROW]
[ROW][C]45[/C][C]50[/C][C]60.8421052631579[/C][C]-10.8421052631579[/C][/ROW]
[ROW][C]46[/C][C]95[/C][C]60.8421052631579[/C][C]34.1578947368421[/C][/ROW]
[ROW][C]47[/C][C]32[/C][C]37.2857142857143[/C][C]-5.28571428571428[/C][/ROW]
[ROW][C]48[/C][C]101[/C][C]79.5714285714286[/C][C]21.4285714285714[/C][/ROW]
[ROW][C]49[/C][C]89[/C][C]79.5714285714286[/C][C]9.42857142857143[/C][/ROW]
[ROW][C]50[/C][C]59[/C][C]119.142857142857[/C][C]-60.1428571428571[/C][/ROW]
[ROW][C]51[/C][C]28[/C][C]37.2857142857143[/C][C]-9.28571428571428[/C][/ROW]
[ROW][C]52[/C][C]69[/C][C]60.8421052631579[/C][C]8.1578947368421[/C][/ROW]
[ROW][C]53[/C][C]74[/C][C]79.5714285714286[/C][C]-5.57142857142857[/C][/ROW]
[ROW][C]54[/C][C]79[/C][C]79.5714285714286[/C][C]-0.571428571428569[/C][/ROW]
[ROW][C]55[/C][C]59[/C][C]60.8421052631579[/C][C]-1.8421052631579[/C][/ROW]
[ROW][C]56[/C][C]56[/C][C]60.8421052631579[/C][C]-4.8421052631579[/C][/ROW]
[ROW][C]57[/C][C]67[/C][C]60.8421052631579[/C][C]6.1578947368421[/C][/ROW]
[ROW][C]58[/C][C]24[/C][C]37.2857142857143[/C][C]-13.2857142857143[/C][/ROW]
[ROW][C]59[/C][C]66[/C][C]60.8421052631579[/C][C]5.1578947368421[/C][/ROW]
[ROW][C]60[/C][C]96[/C][C]119.142857142857[/C][C]-23.1428571428571[/C][/ROW]
[ROW][C]61[/C][C]60[/C][C]60.8421052631579[/C][C]-0.842105263157897[/C][/ROW]
[ROW][C]62[/C][C]80[/C][C]79.5714285714286[/C][C]0.428571428571431[/C][/ROW]
[ROW][C]63[/C][C]61[/C][C]60.8421052631579[/C][C]0.157894736842103[/C][/ROW]
[ROW][C]64[/C][C]37[/C][C]60.8421052631579[/C][C]-23.8421052631579[/C][/ROW]
[ROW][C]65[/C][C]35[/C][C]60.8421052631579[/C][C]-25.8421052631579[/C][/ROW]
[ROW][C]66[/C][C]41[/C][C]60.8421052631579[/C][C]-19.8421052631579[/C][/ROW]
[ROW][C]67[/C][C]70[/C][C]79.5714285714286[/C][C]-9.57142857142857[/C][/ROW]
[ROW][C]68[/C][C]65[/C][C]119.142857142857[/C][C]-54.1428571428571[/C][/ROW]
[ROW][C]69[/C][C]38[/C][C]37.2857142857143[/C][C]0.714285714285715[/C][/ROW]
[ROW][C]70[/C][C]15[/C][C]8.41176470588235[/C][C]6.58823529411765[/C][/ROW]
[ROW][C]71[/C][C]112[/C][C]119.142857142857[/C][C]-7.14285714285714[/C][/ROW]
[ROW][C]72[/C][C]72[/C][C]60.8421052631579[/C][C]11.1578947368421[/C][/ROW]
[ROW][C]73[/C][C]68[/C][C]60.8421052631579[/C][C]7.1578947368421[/C][/ROW]
[ROW][C]74[/C][C]71[/C][C]60.8421052631579[/C][C]10.1578947368421[/C][/ROW]
[ROW][C]75[/C][C]67[/C][C]119.142857142857[/C][C]-52.1428571428571[/C][/ROW]
[ROW][C]76[/C][C]44[/C][C]60.8421052631579[/C][C]-16.8421052631579[/C][/ROW]
[ROW][C]77[/C][C]60[/C][C]79.5714285714286[/C][C]-19.5714285714286[/C][/ROW]
[ROW][C]78[/C][C]97[/C][C]79.5714285714286[/C][C]17.4285714285714[/C][/ROW]
[ROW][C]79[/C][C]30[/C][C]37.2857142857143[/C][C]-7.28571428571428[/C][/ROW]
[ROW][C]80[/C][C]71[/C][C]60.8421052631579[/C][C]10.1578947368421[/C][/ROW]
[ROW][C]81[/C][C]68[/C][C]37.2857142857143[/C][C]30.7142857142857[/C][/ROW]
[ROW][C]82[/C][C]64[/C][C]79.5714285714286[/C][C]-15.5714285714286[/C][/ROW]
[ROW][C]83[/C][C]28[/C][C]37.2857142857143[/C][C]-9.28571428571428[/C][/ROW]
[ROW][C]84[/C][C]40[/C][C]60.8421052631579[/C][C]-20.8421052631579[/C][/ROW]
[ROW][C]85[/C][C]46[/C][C]37.2857142857143[/C][C]8.71428571428572[/C][/ROW]
[ROW][C]86[/C][C]54[/C][C]60.8421052631579[/C][C]-6.8421052631579[/C][/ROW]
[ROW][C]87[/C][C]227[/C][C]119.142857142857[/C][C]107.857142857143[/C][/ROW]
[ROW][C]88[/C][C]112[/C][C]60.8421052631579[/C][C]51.1578947368421[/C][/ROW]
[ROW][C]89[/C][C]62[/C][C]60.8421052631579[/C][C]1.1578947368421[/C][/ROW]
[ROW][C]90[/C][C]52[/C][C]60.8421052631579[/C][C]-8.8421052631579[/C][/ROW]
[ROW][C]91[/C][C]41[/C][C]60.8421052631579[/C][C]-19.8421052631579[/C][/ROW]
[ROW][C]92[/C][C]78[/C][C]79.5714285714286[/C][C]-1.57142857142857[/C][/ROW]
[ROW][C]93[/C][C]57[/C][C]60.8421052631579[/C][C]-3.8421052631579[/C][/ROW]
[ROW][C]94[/C][C]58[/C][C]60.8421052631579[/C][C]-2.8421052631579[/C][/ROW]
[ROW][C]95[/C][C]40[/C][C]37.2857142857143[/C][C]2.71428571428572[/C][/ROW]
[ROW][C]96[/C][C]117[/C][C]79.5714285714286[/C][C]37.4285714285714[/C][/ROW]
[ROW][C]97[/C][C]70[/C][C]60.8421052631579[/C][C]9.1578947368421[/C][/ROW]
[ROW][C]98[/C][C]12[/C][C]8.41176470588235[/C][C]3.58823529411765[/C][/ROW]
[ROW][C]99[/C][C]105[/C][C]79.5714285714286[/C][C]25.4285714285714[/C][/ROW]
[ROW][C]100[/C][C]78[/C][C]79.5714285714286[/C][C]-1.57142857142857[/C][/ROW]
[ROW][C]101[/C][C]29[/C][C]37.2857142857143[/C][C]-8.28571428571428[/C][/ROW]
[ROW][C]102[/C][C]24[/C][C]37.2857142857143[/C][C]-13.2857142857143[/C][/ROW]
[ROW][C]103[/C][C]54[/C][C]60.8421052631579[/C][C]-6.8421052631579[/C][/ROW]
[ROW][C]104[/C][C]61[/C][C]60.8421052631579[/C][C]0.157894736842103[/C][/ROW]
[ROW][C]105[/C][C]40[/C][C]37.2857142857143[/C][C]2.71428571428572[/C][/ROW]
[ROW][C]106[/C][C]22[/C][C]8.41176470588235[/C][C]13.5882352941176[/C][/ROW]
[ROW][C]107[/C][C]48[/C][C]60.8421052631579[/C][C]-12.8421052631579[/C][/ROW]
[ROW][C]108[/C][C]37[/C][C]37.2857142857143[/C][C]-0.285714285714285[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]8.41176470588235[/C][C]-8.41176470588235[/C][/ROW]
[ROW][C]110[/C][C]32[/C][C]37.2857142857143[/C][C]-5.28571428571428[/C][/ROW]
[ROW][C]111[/C][C]67[/C][C]37.2857142857143[/C][C]29.7142857142857[/C][/ROW]
[ROW][C]112[/C][C]45[/C][C]60.8421052631579[/C][C]-15.8421052631579[/C][/ROW]
[ROW][C]113[/C][C]63[/C][C]60.8421052631579[/C][C]2.1578947368421[/C][/ROW]
[ROW][C]114[/C][C]60[/C][C]37.2857142857143[/C][C]22.7142857142857[/C][/ROW]
[ROW][C]115[/C][C]5[/C][C]8.41176470588235[/C][C]-3.41176470588235[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]8.41176470588235[/C][C]-8.41176470588235[/C][/ROW]
[ROW][C]117[/C][C]44[/C][C]37.2857142857143[/C][C]6.71428571428572[/C][/ROW]
[ROW][C]118[/C][C]84[/C][C]60.8421052631579[/C][C]23.1578947368421[/C][/ROW]
[ROW][C]119[/C][C]98[/C][C]79.5714285714286[/C][C]18.4285714285714[/C][/ROW]
[ROW][C]120[/C][C]38[/C][C]37.2857142857143[/C][C]0.714285714285715[/C][/ROW]
[ROW][C]121[/C][C]19[/C][C]37.2857142857143[/C][C]-18.2857142857143[/C][/ROW]
[ROW][C]122[/C][C]73[/C][C]60.8421052631579[/C][C]12.1578947368421[/C][/ROW]
[ROW][C]123[/C][C]42[/C][C]37.2857142857143[/C][C]4.71428571428572[/C][/ROW]
[ROW][C]124[/C][C]55[/C][C]79.5714285714286[/C][C]-24.5714285714286[/C][/ROW]
[ROW][C]125[/C][C]40[/C][C]37.2857142857143[/C][C]2.71428571428572[/C][/ROW]
[ROW][C]126[/C][C]12[/C][C]8.41176470588235[/C][C]3.58823529411765[/C][/ROW]
[ROW][C]127[/C][C]56[/C][C]60.8421052631579[/C][C]-4.8421052631579[/C][/ROW]
[ROW][C]128[/C][C]33[/C][C]37.2857142857143[/C][C]-4.28571428571428[/C][/ROW]
[ROW][C]129[/C][C]54[/C][C]60.8421052631579[/C][C]-6.8421052631579[/C][/ROW]
[ROW][C]130[/C][C]9[/C][C]8.41176470588235[/C][C]0.588235294117647[/C][/ROW]
[ROW][C]131[/C][C]9[/C][C]8.41176470588235[/C][C]0.588235294117647[/C][/ROW]
[ROW][C]132[/C][C]57[/C][C]60.8421052631579[/C][C]-3.8421052631579[/C][/ROW]
[ROW][C]133[/C][C]3[/C][C]8.41176470588235[/C][C]-5.41176470588235[/C][/ROW]
[ROW][C]134[/C][C]63[/C][C]60.8421052631579[/C][C]2.1578947368421[/C][/ROW]
[ROW][C]135[/C][C]3[/C][C]8.41176470588235[/C][C]-5.41176470588235[/C][/ROW]
[ROW][C]136[/C][C]16[/C][C]8.41176470588235[/C][C]7.58823529411765[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]8.41176470588235[/C][C]-8.41176470588235[/C][/ROW]
[ROW][C]138[/C][C]47[/C][C]37.2857142857143[/C][C]9.71428571428572[/C][/ROW]
[ROW][C]139[/C][C]38[/C][C]60.8421052631579[/C][C]-22.8421052631579[/C][/ROW]
[ROW][C]140[/C][C]4[/C][C]8.41176470588235[/C][C]-4.41176470588235[/C][/ROW]
[ROW][C]141[/C][C]14[/C][C]8.41176470588235[/C][C]5.58823529411765[/C][/ROW]
[ROW][C]142[/C][C]24[/C][C]37.2857142857143[/C][C]-13.2857142857143[/C][/ROW]
[ROW][C]143[/C][C]51[/C][C]60.8421052631579[/C][C]-9.8421052631579[/C][/ROW]
[ROW][C]144[/C][C]19[/C][C]37.2857142857143[/C][C]-18.2857142857143[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158835&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158835&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
19160.842105263157930.1578947368421
25960.8421052631579-1.8421052631579
3188.411764705882359.58823529411765
49579.571428571428615.4285714285714
5136119.14285714285716.8571428571429
6263119.142857142857143.857142857143
75660.8421052631579-4.8421052631579
85960.8421052631579-1.8421052631579
94460.8421052631579-16.8421052631579
1096119.142857142857-23.1428571428571
117579.5714285714286-4.57142857142857
126979.5714285714286-10.5714285714286
139860.842105263157937.1578947368421
14119119.142857142857-0.142857142857139
155860.8421052631579-2.8421052631579
168860.842105263157927.1578947368421
175760.8421052631579-3.8421052631579
186160.84210526315790.157894736842103
1987119.142857142857-32.1428571428571
202437.2857142857143-13.2857142857143
215937.285714285714321.7142857142857
22100119.142857142857-19.1428571428571
237260.842105263157911.1578947368421
245479.5714285714286-25.5714285714286
258660.842105263157925.1578947368421
263260.8421052631579-28.8421052631579
2716379.571428571428683.4285714285714
289360.842105263157932.1578947368421
29118119.142857142857-1.14285714285714
304479.5714285714286-35.5714285714286
314460.8421052631579-16.8421052631579
324560.8421052631579-15.8421052631579
3310579.571428571428625.4285714285714
34123119.1428571428573.85714285714286
355379.5714285714286-26.5714285714286
3618.41176470588235-7.41176470588235
376379.5714285714286-16.5714285714286
385160.8421052631579-9.8421052631579
394979.5714285714286-30.5714285714286
406479.5714285714286-15.5714285714286
417179.5714285714286-8.57142857142857
425960.8421052631579-1.8421052631579
433237.2857142857143-5.28571428571428
447879.5714285714286-1.57142857142857
455060.8421052631579-10.8421052631579
469560.842105263157934.1578947368421
473237.2857142857143-5.28571428571428
4810179.571428571428621.4285714285714
498979.57142857142869.42857142857143
5059119.142857142857-60.1428571428571
512837.2857142857143-9.28571428571428
526960.84210526315798.1578947368421
537479.5714285714286-5.57142857142857
547979.5714285714286-0.571428571428569
555960.8421052631579-1.8421052631579
565660.8421052631579-4.8421052631579
576760.84210526315796.1578947368421
582437.2857142857143-13.2857142857143
596660.84210526315795.1578947368421
6096119.142857142857-23.1428571428571
616060.8421052631579-0.842105263157897
628079.57142857142860.428571428571431
636160.84210526315790.157894736842103
643760.8421052631579-23.8421052631579
653560.8421052631579-25.8421052631579
664160.8421052631579-19.8421052631579
677079.5714285714286-9.57142857142857
6865119.142857142857-54.1428571428571
693837.28571428571430.714285714285715
70158.411764705882356.58823529411765
71112119.142857142857-7.14285714285714
727260.842105263157911.1578947368421
736860.84210526315797.1578947368421
747160.842105263157910.1578947368421
7567119.142857142857-52.1428571428571
764460.8421052631579-16.8421052631579
776079.5714285714286-19.5714285714286
789779.571428571428617.4285714285714
793037.2857142857143-7.28571428571428
807160.842105263157910.1578947368421
816837.285714285714330.7142857142857
826479.5714285714286-15.5714285714286
832837.2857142857143-9.28571428571428
844060.8421052631579-20.8421052631579
854637.28571428571438.71428571428572
865460.8421052631579-6.8421052631579
87227119.142857142857107.857142857143
8811260.842105263157951.1578947368421
896260.84210526315791.1578947368421
905260.8421052631579-8.8421052631579
914160.8421052631579-19.8421052631579
927879.5714285714286-1.57142857142857
935760.8421052631579-3.8421052631579
945860.8421052631579-2.8421052631579
954037.28571428571432.71428571428572
9611779.571428571428637.4285714285714
977060.84210526315799.1578947368421
98128.411764705882353.58823529411765
9910579.571428571428625.4285714285714
1007879.5714285714286-1.57142857142857
1012937.2857142857143-8.28571428571428
1022437.2857142857143-13.2857142857143
1035460.8421052631579-6.8421052631579
1046160.84210526315790.157894736842103
1054037.28571428571432.71428571428572
106228.4117647058823513.5882352941176
1074860.8421052631579-12.8421052631579
1083737.2857142857143-0.285714285714285
10908.41176470588235-8.41176470588235
1103237.2857142857143-5.28571428571428
1116737.285714285714329.7142857142857
1124560.8421052631579-15.8421052631579
1136360.84210526315792.1578947368421
1146037.285714285714322.7142857142857
11558.41176470588235-3.41176470588235
11608.41176470588235-8.41176470588235
1174437.28571428571436.71428571428572
1188460.842105263157923.1578947368421
1199879.571428571428618.4285714285714
1203837.28571428571430.714285714285715
1211937.2857142857143-18.2857142857143
1227360.842105263157912.1578947368421
1234237.28571428571434.71428571428572
1245579.5714285714286-24.5714285714286
1254037.28571428571432.71428571428572
126128.411764705882353.58823529411765
1275660.8421052631579-4.8421052631579
1283337.2857142857143-4.28571428571428
1295460.8421052631579-6.8421052631579
13098.411764705882350.588235294117647
13198.411764705882350.588235294117647
1325760.8421052631579-3.8421052631579
13338.41176470588235-5.41176470588235
1346360.84210526315792.1578947368421
13538.41176470588235-5.41176470588235
136168.411764705882357.58823529411765
13708.41176470588235-8.41176470588235
1384737.28571428571439.71428571428572
1393860.8421052631579-22.8421052631579
14048.41176470588235-4.41176470588235
141148.411764705882355.58823529411765
1422437.2857142857143-13.2857142857143
1435160.8421052631579-9.8421052631579
1441937.2857142857143-18.2857142857143



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