Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationFri, 23 Dec 2011 06:46:03 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2011/Dec/23/t1324640901gmidg1ntp9omclk.htm/, Retrieved Mon, 29 Apr 2024 18:51:47 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=160309, Retrieved Mon, 29 Apr 2024 18:51:47 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact74
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Multiple Regression] [Multiple regression] [2011-12-21 15:21:41] [1ed874da5cc4aa1cd1ced057f766d90b]
- RMP   [Recursive Partitioning (Regression Trees)] [Regression Tree] [2011-12-21 15:39:02] [1ed874da5cc4aa1cd1ced057f766d90b]
-   P       [Recursive Partitioning (Regression Trees)] [regression tree] [2011-12-23 11:46:03] [452d9c400285ceb08a690c4b81b76477] [Current]
Feedback Forum

Post a new message
Dataseries X:
1801	159261	91	586	111	0	74
1717	189672	59	520	76	1	80
192	7215	18	72	1	0	0
2295	129098	95	645	155	0	84
3450	230632	136	1163	125	0	124
6861	515038	263	1945	278	1	140
1795	180745	56	585	89	1	88
1681	185559	59	470	59	0	115
1897	154581	44	612	87	0	109
2974	298001	96	992	129	1	104
1946	121844	75	634	158	2	63
2148	184039	69	677	120	0	118
1832	100324	98	665	87	0	71
3183	220269	119	1079	264	4	112
1476	168265	58	413	51	4	63
1567	154647	88	469	85	3	86
1756	142018	57	431	96	0	132
1247	79030	61	361	72	5	54
2779	167047	87	877	147	0	134
726	27997	24	221	49	0	57
1048	73019	59	366	40	0	59
2805	241082	100	846	99	0	113
1760	195820	72	642	127	0	96
2266	142001	54	689	164	1	96
1848	145433	86	576	41	1	78
1665	183744	32	610	160	0	80
2084	202357	163	673	92	0	93
1440	199532	93	361	59	0	109
2741	354924	118	907	89	0	115
2112	192399	44	882	90	0	79
1684	182286	44	490	76	0	103
1616	181590	45	548	116	2	71
2227	133801	105	723	92	4	66
3088	233686	123	918	344	0	100
2389	219428	53	787	84	1	96
1	0	1	0	0	0	0
2099	223044	63	983	61	0	109
1669	100129	51	539	138	3	51
2137	145864	49	515	270	9	119
2153	249965	64	795	64	0	136
2390	242379	71	753	96	2	84
1701	145794	59	635	62	0	136
983	96404	32	361	35	2	84
2161	195891	78	804	59	1	92
1276	117156	50	394	56	2	103
1190	157787	95	320	40	2	82
745	81293	32	212	49	1	106
2330	237435	101	772	121	0	96
2289	233155	89	740	113	1	124
2639	160344	59	938	172	8	97
658	48188	28	205	37	0	82
1917	161922	69	492	51	0	79
2557	307432	74	818	89	0	97
2026	235223	79	680	73	0	107
1911	195583	59	691	49	1	126
1716	146061	56	534	74	8	40
1852	208834	67	487	58	0	96
981	93764	24	301	72	1	100
1177	151985	66	421	32	0	91
2833	193222	96	947	59	10	136
1688	148922	60	492	70	6	124
2097	132856	80	790	85	0	79
1331	129561	61	362	87	11	74
1244	112718	37	430	48	3	96
1256	160930	35	416	56	0	97
1294	99184	41	409	41	0	122
2303	192535	70	498	86	8	144
2897	138708	65	887	152	2	90
1103	114408	38	267	48	0	93
340	31970	15	101	40	0	78
2791	225558	112	1000	135	3	72
1338	139220	72	416	83	1	45
1441	113612	68	480	62	2	120
1623	108641	71	454	91	1	59
2650	162203	67	671	91	0	133
1499	100098	44	413	82	2	117
2302	174768	60	677	112	1	123
2540	158459	97	820	69	0	110
1000	80934	30	316	78	0	75
1234	84971	71	395	105	0	114
927	80545	68	217	49	0	94
2176	287191	64	818	60	0	116
957	62974	28	292	49	1	86
1551	134091	40	513	132	0	90
1014	75555	46	345	49	0	87
1771	162154	54	557	71	0	99
2613	226638	227	645	100	0	132
1205	115367	112	284	74	0	96
1337	108749	62	424	49	7	91
1524	155537	52	614	72	0	77
1829	153133	41	672	59	5	104
2229	165618	78	649	90	1	97
1233	151517	57	415	68	0	94
1365	133686	58	505	81	0	60
950	61342	40	387	33	0	46
2319	245196	117	730	166	0	135
1857	195576	70	563	94	0	90
223	19349	12	67	15	0	2
2390	225371	105	812	104	3	96
1985	153213	78	811	61	0	109
700	59117	29	281	11	0	15
1062	91762	24	338	45	0	68
1311	136769	54	413	84	0	88
1157	114798	61	298	66	1	84
823	85338	40	223	27	1	46
596	27676	22	194	59	0	59
1545	153535	48	371	127	0	116
1130	122417	37	268	48	0	29
0	0	0	0	0	0	0
1082	91529	32	332	58	0	91
1135	107205	67	371	57	0	76
1367	144664	45	465	59	0	83
1506	146445	63	447	76	1	84
870	76656	60	295	71	0	65
78	3616	5	14	5	0	0
0	0	0	0	0	0	0
1130	183088	44	388	70	0	84
1582	144677	84	564	76	0	114
2034	159104	98	562	122	2	124
919	113273	38	288	56	0	92
778	43410	19	292	63	0	3
1752	175774	73	530	92	1	109
957	95401	42	256	54	0	74
2098	134837	55	602	64	8	121
731	60493	40	174	29	3	48
285	19764	12	75	19	1	8
1834	164062	56	565	64	3	80
1148	132696	33	377	79	0	107
1646	155367	54	544	97	0	116
256	11796	9	79	22	0	8
98	10674	9	33	7	0	0
1404	142261	57	479	37	0	56
41	6836	3	11	5	0	4
1824	162563	63	626	48	6	70
42	5118	3	6	1	0	0
528	40248	16	183	34	1	14
0	0	0	0	0	0	0
1073	122641	47	334	49	0	91
1305	88837	38	269	44	0	89
81	7131	4	27	0	1	0
261	9056	14	99	18	0	12
934	76611	24	260	48	1	60
1180	132697	51	290	54	0	80
1147	100681	19	414	50	1	88




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=160309&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=160309&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160309&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.8859
R-squared0.7849
RMSE35732.7852

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8859[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7849[/C][/ROW]
[ROW][C]RMSE[/C][C]35732.7852[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160309&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160309&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.8859
R-squared0.7849
RMSE35732.7852







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1159261158311.869565217949.130434782623
2189672158311.86956521731360.1304347826
372157038.38461538462176.615384615385
4129098165656.5-36558.5
5230632289329-58697
6515038289329225709
7180745158311.86956521722433.1304347826
8185559158311.86956521727247.1304347826
9154581158311.869565217-3730.86956521738
10298001220586.27777777877414.7222222222
11121844158311.869565217-36467.8695652174
12184039165656.518382.5
13100324158311.869565217-57987.8695652174
14220269289329-69060
15168265158311.8695652179953.13043478262
16154647158311.869565217-3664.86956521738
17142018158311.869565217-16293.8695652174
1879030123977.375-44947.375
19167047220586.277777778-53539.2777777778
202799734893.1428571429-6896.14285714286
217301982260.2105263158-9241.21052631579
22241082220586.27777777820495.7222222222
23195820158311.86956521737508.1304347826
24142001165656.5-23655.5
25145433158311.869565217-12878.8695652174
26183744158311.86956521725432.1304347826
27202357158311.86956521744045.1304347826
28199532158311.86956521741220.1304347826
2935492428932965595
30192399220586.277777778-28187.2777777778
31182286158311.86956521723974.1304347826
32181590158311.86956521723278.1304347826
33133801165656.5-31855.5
34233686289329-55643
35219428220586.277777778-1158.27777777778
3607038.38461538462-7038.38461538462
37223044220586.2777777782457.72222222222
38100129158311.869565217-58182.8695652174
39145864165656.5-19792.5
40249965220586.27777777829378.7222222222
41242379220586.27777777821792.7222222222
42145794158311.869565217-12517.8695652174
439640482260.210526315814143.7894736842
44195891220586.277777778-24695.2777777778
45117156123977.375-6821.375
46157787123977.37533809.625
478129382260.2105263158-967.210526315786
48237435220586.27777777816848.7222222222
49233155220586.27777777812568.7222222222
50160344220586.277777778-60242.2777777778
514818834893.142857142913294.8571428571
52161922158311.8695652173610.13043478262
53307432220586.27777777886845.7222222222
54235223158311.86956521776911.1304347826
55195583158311.86956521737271.1304347826
56146061158311.869565217-12250.8695652174
57208834158311.86956521750522.1304347826
589376482260.210526315811503.7894736842
59151985123977.37528007.625
60193222220586.277777778-27364.2777777778
61148922158311.869565217-9389.86956521738
62132856158311.869565217-25455.8695652174
63129561123977.3755583.625
64112718123977.375-11259.375
65160930123977.37536952.625
6699184123977.375-24793.375
67192535165656.526878.5
68138708220586.277777778-81878.2777777778
69114408123977.375-9569.375
703197034893.1428571429-2923.14285714286
71225558289329-63771
72139220123977.37515242.625
73113612158311.869565217-44699.8695652174
74108641158311.869565217-49670.8695652174
75162203165656.5-3453.5
76100098158311.869565217-58213.8695652174
77174768165656.59111.5
78158459220586.277777778-62127.2777777778
798093482260.2105263158-1326.21052631579
8084971123977.375-39006.375
818054582260.2105263158-1715.21052631579
82287191220586.27777777866604.7222222222
836297482260.2105263158-19286.2105263158
84134091158311.869565217-24220.8695652174
857555582260.2105263158-6705.21052631579
86162154158311.8695652173842.13043478262
87226638165656.560981.5
88115367123977.375-8610.375
89108749123977.375-15228.375
90155537158311.869565217-2774.86956521738
91153133158311.869565217-5178.86956521738
92165618165656.5-38.5
93151517123977.37527539.625
94133686123977.3759708.625
956134282260.2105263158-20918.2105263158
96245196289329-44133
97195576158311.86956521737264.1304347826
98193497038.3846153846212310.6153846154
99225371220586.2777777784784.72222222222
100153213158311.869565217-5098.86956521738
1015911734893.142857142924223.8571428571
1029176282260.21052631589501.78947368421
103136769123977.37512791.625
104114798123977.375-9179.375
1058533882260.21052631583077.78947368421
1062767634893.1428571429-7217.14285714286
107153535158311.869565217-4776.86956521738
108122417123977.375-1560.375
10907038.38461538462-7038.38461538462
1109152982260.21052631589268.78947368421
111107205123977.375-16772.375
112144664158311.869565217-13647.8695652174
113146445158311.869565217-11866.8695652174
1147665682260.2105263158-5604.21052631579
11536167038.38461538462-3422.38461538462
11607038.38461538462-7038.38461538462
117183088123977.37559110.625
118144677158311.869565217-13634.8695652174
119159104158311.869565217792.130434782623
12011327382260.210526315831012.7894736842
1214341082260.2105263158-38850.2105263158
122175774158311.86956521717462.1304347826
1239540182260.210526315813140.7894736842
124134837158311.869565217-23474.8695652174
1256049382260.2105263158-21767.2105263158
126197647038.3846153846212725.6153846154
127164062158311.8695652175750.13043478262
128132696123977.3758718.625
129155367158311.869565217-2944.86956521738
130117967038.384615384624757.61538461538
131106747038.384615384623635.61538461538
132142261158311.869565217-16050.8695652174
13368367038.38461538462-202.384615384615
134162563158311.8695652174251.13043478262
13551187038.38461538462-1920.38461538462
1364024834893.14285714295354.85714285714
13707038.38461538462-7038.38461538462
13812264182260.210526315840380.7894736842
13988837123977.375-35140.375
14071317038.3846153846292.6153846153848
141905634893.1428571429-25837.1428571429
1427661182260.2105263158-5649.21052631579
143132697123977.3758719.625
144100681123977.375-23296.375

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 159261 & 158311.869565217 & 949.130434782623 \tabularnewline
2 & 189672 & 158311.869565217 & 31360.1304347826 \tabularnewline
3 & 7215 & 7038.38461538462 & 176.615384615385 \tabularnewline
4 & 129098 & 165656.5 & -36558.5 \tabularnewline
5 & 230632 & 289329 & -58697 \tabularnewline
6 & 515038 & 289329 & 225709 \tabularnewline
7 & 180745 & 158311.869565217 & 22433.1304347826 \tabularnewline
8 & 185559 & 158311.869565217 & 27247.1304347826 \tabularnewline
9 & 154581 & 158311.869565217 & -3730.86956521738 \tabularnewline
10 & 298001 & 220586.277777778 & 77414.7222222222 \tabularnewline
11 & 121844 & 158311.869565217 & -36467.8695652174 \tabularnewline
12 & 184039 & 165656.5 & 18382.5 \tabularnewline
13 & 100324 & 158311.869565217 & -57987.8695652174 \tabularnewline
14 & 220269 & 289329 & -69060 \tabularnewline
15 & 168265 & 158311.869565217 & 9953.13043478262 \tabularnewline
16 & 154647 & 158311.869565217 & -3664.86956521738 \tabularnewline
17 & 142018 & 158311.869565217 & -16293.8695652174 \tabularnewline
18 & 79030 & 123977.375 & -44947.375 \tabularnewline
19 & 167047 & 220586.277777778 & -53539.2777777778 \tabularnewline
20 & 27997 & 34893.1428571429 & -6896.14285714286 \tabularnewline
21 & 73019 & 82260.2105263158 & -9241.21052631579 \tabularnewline
22 & 241082 & 220586.277777778 & 20495.7222222222 \tabularnewline
23 & 195820 & 158311.869565217 & 37508.1304347826 \tabularnewline
24 & 142001 & 165656.5 & -23655.5 \tabularnewline
25 & 145433 & 158311.869565217 & -12878.8695652174 \tabularnewline
26 & 183744 & 158311.869565217 & 25432.1304347826 \tabularnewline
27 & 202357 & 158311.869565217 & 44045.1304347826 \tabularnewline
28 & 199532 & 158311.869565217 & 41220.1304347826 \tabularnewline
29 & 354924 & 289329 & 65595 \tabularnewline
30 & 192399 & 220586.277777778 & -28187.2777777778 \tabularnewline
31 & 182286 & 158311.869565217 & 23974.1304347826 \tabularnewline
32 & 181590 & 158311.869565217 & 23278.1304347826 \tabularnewline
33 & 133801 & 165656.5 & -31855.5 \tabularnewline
34 & 233686 & 289329 & -55643 \tabularnewline
35 & 219428 & 220586.277777778 & -1158.27777777778 \tabularnewline
36 & 0 & 7038.38461538462 & -7038.38461538462 \tabularnewline
37 & 223044 & 220586.277777778 & 2457.72222222222 \tabularnewline
38 & 100129 & 158311.869565217 & -58182.8695652174 \tabularnewline
39 & 145864 & 165656.5 & -19792.5 \tabularnewline
40 & 249965 & 220586.277777778 & 29378.7222222222 \tabularnewline
41 & 242379 & 220586.277777778 & 21792.7222222222 \tabularnewline
42 & 145794 & 158311.869565217 & -12517.8695652174 \tabularnewline
43 & 96404 & 82260.2105263158 & 14143.7894736842 \tabularnewline
44 & 195891 & 220586.277777778 & -24695.2777777778 \tabularnewline
45 & 117156 & 123977.375 & -6821.375 \tabularnewline
46 & 157787 & 123977.375 & 33809.625 \tabularnewline
47 & 81293 & 82260.2105263158 & -967.210526315786 \tabularnewline
48 & 237435 & 220586.277777778 & 16848.7222222222 \tabularnewline
49 & 233155 & 220586.277777778 & 12568.7222222222 \tabularnewline
50 & 160344 & 220586.277777778 & -60242.2777777778 \tabularnewline
51 & 48188 & 34893.1428571429 & 13294.8571428571 \tabularnewline
52 & 161922 & 158311.869565217 & 3610.13043478262 \tabularnewline
53 & 307432 & 220586.277777778 & 86845.7222222222 \tabularnewline
54 & 235223 & 158311.869565217 & 76911.1304347826 \tabularnewline
55 & 195583 & 158311.869565217 & 37271.1304347826 \tabularnewline
56 & 146061 & 158311.869565217 & -12250.8695652174 \tabularnewline
57 & 208834 & 158311.869565217 & 50522.1304347826 \tabularnewline
58 & 93764 & 82260.2105263158 & 11503.7894736842 \tabularnewline
59 & 151985 & 123977.375 & 28007.625 \tabularnewline
60 & 193222 & 220586.277777778 & -27364.2777777778 \tabularnewline
61 & 148922 & 158311.869565217 & -9389.86956521738 \tabularnewline
62 & 132856 & 158311.869565217 & -25455.8695652174 \tabularnewline
63 & 129561 & 123977.375 & 5583.625 \tabularnewline
64 & 112718 & 123977.375 & -11259.375 \tabularnewline
65 & 160930 & 123977.375 & 36952.625 \tabularnewline
66 & 99184 & 123977.375 & -24793.375 \tabularnewline
67 & 192535 & 165656.5 & 26878.5 \tabularnewline
68 & 138708 & 220586.277777778 & -81878.2777777778 \tabularnewline
69 & 114408 & 123977.375 & -9569.375 \tabularnewline
70 & 31970 & 34893.1428571429 & -2923.14285714286 \tabularnewline
71 & 225558 & 289329 & -63771 \tabularnewline
72 & 139220 & 123977.375 & 15242.625 \tabularnewline
73 & 113612 & 158311.869565217 & -44699.8695652174 \tabularnewline
74 & 108641 & 158311.869565217 & -49670.8695652174 \tabularnewline
75 & 162203 & 165656.5 & -3453.5 \tabularnewline
76 & 100098 & 158311.869565217 & -58213.8695652174 \tabularnewline
77 & 174768 & 165656.5 & 9111.5 \tabularnewline
78 & 158459 & 220586.277777778 & -62127.2777777778 \tabularnewline
79 & 80934 & 82260.2105263158 & -1326.21052631579 \tabularnewline
80 & 84971 & 123977.375 & -39006.375 \tabularnewline
81 & 80545 & 82260.2105263158 & -1715.21052631579 \tabularnewline
82 & 287191 & 220586.277777778 & 66604.7222222222 \tabularnewline
83 & 62974 & 82260.2105263158 & -19286.2105263158 \tabularnewline
84 & 134091 & 158311.869565217 & -24220.8695652174 \tabularnewline
85 & 75555 & 82260.2105263158 & -6705.21052631579 \tabularnewline
86 & 162154 & 158311.869565217 & 3842.13043478262 \tabularnewline
87 & 226638 & 165656.5 & 60981.5 \tabularnewline
88 & 115367 & 123977.375 & -8610.375 \tabularnewline
89 & 108749 & 123977.375 & -15228.375 \tabularnewline
90 & 155537 & 158311.869565217 & -2774.86956521738 \tabularnewline
91 & 153133 & 158311.869565217 & -5178.86956521738 \tabularnewline
92 & 165618 & 165656.5 & -38.5 \tabularnewline
93 & 151517 & 123977.375 & 27539.625 \tabularnewline
94 & 133686 & 123977.375 & 9708.625 \tabularnewline
95 & 61342 & 82260.2105263158 & -20918.2105263158 \tabularnewline
96 & 245196 & 289329 & -44133 \tabularnewline
97 & 195576 & 158311.869565217 & 37264.1304347826 \tabularnewline
98 & 19349 & 7038.38461538462 & 12310.6153846154 \tabularnewline
99 & 225371 & 220586.277777778 & 4784.72222222222 \tabularnewline
100 & 153213 & 158311.869565217 & -5098.86956521738 \tabularnewline
101 & 59117 & 34893.1428571429 & 24223.8571428571 \tabularnewline
102 & 91762 & 82260.2105263158 & 9501.78947368421 \tabularnewline
103 & 136769 & 123977.375 & 12791.625 \tabularnewline
104 & 114798 & 123977.375 & -9179.375 \tabularnewline
105 & 85338 & 82260.2105263158 & 3077.78947368421 \tabularnewline
106 & 27676 & 34893.1428571429 & -7217.14285714286 \tabularnewline
107 & 153535 & 158311.869565217 & -4776.86956521738 \tabularnewline
108 & 122417 & 123977.375 & -1560.375 \tabularnewline
109 & 0 & 7038.38461538462 & -7038.38461538462 \tabularnewline
110 & 91529 & 82260.2105263158 & 9268.78947368421 \tabularnewline
111 & 107205 & 123977.375 & -16772.375 \tabularnewline
112 & 144664 & 158311.869565217 & -13647.8695652174 \tabularnewline
113 & 146445 & 158311.869565217 & -11866.8695652174 \tabularnewline
114 & 76656 & 82260.2105263158 & -5604.21052631579 \tabularnewline
115 & 3616 & 7038.38461538462 & -3422.38461538462 \tabularnewline
116 & 0 & 7038.38461538462 & -7038.38461538462 \tabularnewline
117 & 183088 & 123977.375 & 59110.625 \tabularnewline
118 & 144677 & 158311.869565217 & -13634.8695652174 \tabularnewline
119 & 159104 & 158311.869565217 & 792.130434782623 \tabularnewline
120 & 113273 & 82260.2105263158 & 31012.7894736842 \tabularnewline
121 & 43410 & 82260.2105263158 & -38850.2105263158 \tabularnewline
122 & 175774 & 158311.869565217 & 17462.1304347826 \tabularnewline
123 & 95401 & 82260.2105263158 & 13140.7894736842 \tabularnewline
124 & 134837 & 158311.869565217 & -23474.8695652174 \tabularnewline
125 & 60493 & 82260.2105263158 & -21767.2105263158 \tabularnewline
126 & 19764 & 7038.38461538462 & 12725.6153846154 \tabularnewline
127 & 164062 & 158311.869565217 & 5750.13043478262 \tabularnewline
128 & 132696 & 123977.375 & 8718.625 \tabularnewline
129 & 155367 & 158311.869565217 & -2944.86956521738 \tabularnewline
130 & 11796 & 7038.38461538462 & 4757.61538461538 \tabularnewline
131 & 10674 & 7038.38461538462 & 3635.61538461538 \tabularnewline
132 & 142261 & 158311.869565217 & -16050.8695652174 \tabularnewline
133 & 6836 & 7038.38461538462 & -202.384615384615 \tabularnewline
134 & 162563 & 158311.869565217 & 4251.13043478262 \tabularnewline
135 & 5118 & 7038.38461538462 & -1920.38461538462 \tabularnewline
136 & 40248 & 34893.1428571429 & 5354.85714285714 \tabularnewline
137 & 0 & 7038.38461538462 & -7038.38461538462 \tabularnewline
138 & 122641 & 82260.2105263158 & 40380.7894736842 \tabularnewline
139 & 88837 & 123977.375 & -35140.375 \tabularnewline
140 & 7131 & 7038.38461538462 & 92.6153846153848 \tabularnewline
141 & 9056 & 34893.1428571429 & -25837.1428571429 \tabularnewline
142 & 76611 & 82260.2105263158 & -5649.21052631579 \tabularnewline
143 & 132697 & 123977.375 & 8719.625 \tabularnewline
144 & 100681 & 123977.375 & -23296.375 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160309&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]159261[/C][C]158311.869565217[/C][C]949.130434782623[/C][/ROW]
[ROW][C]2[/C][C]189672[/C][C]158311.869565217[/C][C]31360.1304347826[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]7038.38461538462[/C][C]176.615384615385[/C][/ROW]
[ROW][C]4[/C][C]129098[/C][C]165656.5[/C][C]-36558.5[/C][/ROW]
[ROW][C]5[/C][C]230632[/C][C]289329[/C][C]-58697[/C][/ROW]
[ROW][C]6[/C][C]515038[/C][C]289329[/C][C]225709[/C][/ROW]
[ROW][C]7[/C][C]180745[/C][C]158311.869565217[/C][C]22433.1304347826[/C][/ROW]
[ROW][C]8[/C][C]185559[/C][C]158311.869565217[/C][C]27247.1304347826[/C][/ROW]
[ROW][C]9[/C][C]154581[/C][C]158311.869565217[/C][C]-3730.86956521738[/C][/ROW]
[ROW][C]10[/C][C]298001[/C][C]220586.277777778[/C][C]77414.7222222222[/C][/ROW]
[ROW][C]11[/C][C]121844[/C][C]158311.869565217[/C][C]-36467.8695652174[/C][/ROW]
[ROW][C]12[/C][C]184039[/C][C]165656.5[/C][C]18382.5[/C][/ROW]
[ROW][C]13[/C][C]100324[/C][C]158311.869565217[/C][C]-57987.8695652174[/C][/ROW]
[ROW][C]14[/C][C]220269[/C][C]289329[/C][C]-69060[/C][/ROW]
[ROW][C]15[/C][C]168265[/C][C]158311.869565217[/C][C]9953.13043478262[/C][/ROW]
[ROW][C]16[/C][C]154647[/C][C]158311.869565217[/C][C]-3664.86956521738[/C][/ROW]
[ROW][C]17[/C][C]142018[/C][C]158311.869565217[/C][C]-16293.8695652174[/C][/ROW]
[ROW][C]18[/C][C]79030[/C][C]123977.375[/C][C]-44947.375[/C][/ROW]
[ROW][C]19[/C][C]167047[/C][C]220586.277777778[/C][C]-53539.2777777778[/C][/ROW]
[ROW][C]20[/C][C]27997[/C][C]34893.1428571429[/C][C]-6896.14285714286[/C][/ROW]
[ROW][C]21[/C][C]73019[/C][C]82260.2105263158[/C][C]-9241.21052631579[/C][/ROW]
[ROW][C]22[/C][C]241082[/C][C]220586.277777778[/C][C]20495.7222222222[/C][/ROW]
[ROW][C]23[/C][C]195820[/C][C]158311.869565217[/C][C]37508.1304347826[/C][/ROW]
[ROW][C]24[/C][C]142001[/C][C]165656.5[/C][C]-23655.5[/C][/ROW]
[ROW][C]25[/C][C]145433[/C][C]158311.869565217[/C][C]-12878.8695652174[/C][/ROW]
[ROW][C]26[/C][C]183744[/C][C]158311.869565217[/C][C]25432.1304347826[/C][/ROW]
[ROW][C]27[/C][C]202357[/C][C]158311.869565217[/C][C]44045.1304347826[/C][/ROW]
[ROW][C]28[/C][C]199532[/C][C]158311.869565217[/C][C]41220.1304347826[/C][/ROW]
[ROW][C]29[/C][C]354924[/C][C]289329[/C][C]65595[/C][/ROW]
[ROW][C]30[/C][C]192399[/C][C]220586.277777778[/C][C]-28187.2777777778[/C][/ROW]
[ROW][C]31[/C][C]182286[/C][C]158311.869565217[/C][C]23974.1304347826[/C][/ROW]
[ROW][C]32[/C][C]181590[/C][C]158311.869565217[/C][C]23278.1304347826[/C][/ROW]
[ROW][C]33[/C][C]133801[/C][C]165656.5[/C][C]-31855.5[/C][/ROW]
[ROW][C]34[/C][C]233686[/C][C]289329[/C][C]-55643[/C][/ROW]
[ROW][C]35[/C][C]219428[/C][C]220586.277777778[/C][C]-1158.27777777778[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]7038.38461538462[/C][C]-7038.38461538462[/C][/ROW]
[ROW][C]37[/C][C]223044[/C][C]220586.277777778[/C][C]2457.72222222222[/C][/ROW]
[ROW][C]38[/C][C]100129[/C][C]158311.869565217[/C][C]-58182.8695652174[/C][/ROW]
[ROW][C]39[/C][C]145864[/C][C]165656.5[/C][C]-19792.5[/C][/ROW]
[ROW][C]40[/C][C]249965[/C][C]220586.277777778[/C][C]29378.7222222222[/C][/ROW]
[ROW][C]41[/C][C]242379[/C][C]220586.277777778[/C][C]21792.7222222222[/C][/ROW]
[ROW][C]42[/C][C]145794[/C][C]158311.869565217[/C][C]-12517.8695652174[/C][/ROW]
[ROW][C]43[/C][C]96404[/C][C]82260.2105263158[/C][C]14143.7894736842[/C][/ROW]
[ROW][C]44[/C][C]195891[/C][C]220586.277777778[/C][C]-24695.2777777778[/C][/ROW]
[ROW][C]45[/C][C]117156[/C][C]123977.375[/C][C]-6821.375[/C][/ROW]
[ROW][C]46[/C][C]157787[/C][C]123977.375[/C][C]33809.625[/C][/ROW]
[ROW][C]47[/C][C]81293[/C][C]82260.2105263158[/C][C]-967.210526315786[/C][/ROW]
[ROW][C]48[/C][C]237435[/C][C]220586.277777778[/C][C]16848.7222222222[/C][/ROW]
[ROW][C]49[/C][C]233155[/C][C]220586.277777778[/C][C]12568.7222222222[/C][/ROW]
[ROW][C]50[/C][C]160344[/C][C]220586.277777778[/C][C]-60242.2777777778[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]34893.1428571429[/C][C]13294.8571428571[/C][/ROW]
[ROW][C]52[/C][C]161922[/C][C]158311.869565217[/C][C]3610.13043478262[/C][/ROW]
[ROW][C]53[/C][C]307432[/C][C]220586.277777778[/C][C]86845.7222222222[/C][/ROW]
[ROW][C]54[/C][C]235223[/C][C]158311.869565217[/C][C]76911.1304347826[/C][/ROW]
[ROW][C]55[/C][C]195583[/C][C]158311.869565217[/C][C]37271.1304347826[/C][/ROW]
[ROW][C]56[/C][C]146061[/C][C]158311.869565217[/C][C]-12250.8695652174[/C][/ROW]
[ROW][C]57[/C][C]208834[/C][C]158311.869565217[/C][C]50522.1304347826[/C][/ROW]
[ROW][C]58[/C][C]93764[/C][C]82260.2105263158[/C][C]11503.7894736842[/C][/ROW]
[ROW][C]59[/C][C]151985[/C][C]123977.375[/C][C]28007.625[/C][/ROW]
[ROW][C]60[/C][C]193222[/C][C]220586.277777778[/C][C]-27364.2777777778[/C][/ROW]
[ROW][C]61[/C][C]148922[/C][C]158311.869565217[/C][C]-9389.86956521738[/C][/ROW]
[ROW][C]62[/C][C]132856[/C][C]158311.869565217[/C][C]-25455.8695652174[/C][/ROW]
[ROW][C]63[/C][C]129561[/C][C]123977.375[/C][C]5583.625[/C][/ROW]
[ROW][C]64[/C][C]112718[/C][C]123977.375[/C][C]-11259.375[/C][/ROW]
[ROW][C]65[/C][C]160930[/C][C]123977.375[/C][C]36952.625[/C][/ROW]
[ROW][C]66[/C][C]99184[/C][C]123977.375[/C][C]-24793.375[/C][/ROW]
[ROW][C]67[/C][C]192535[/C][C]165656.5[/C][C]26878.5[/C][/ROW]
[ROW][C]68[/C][C]138708[/C][C]220586.277777778[/C][C]-81878.2777777778[/C][/ROW]
[ROW][C]69[/C][C]114408[/C][C]123977.375[/C][C]-9569.375[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]34893.1428571429[/C][C]-2923.14285714286[/C][/ROW]
[ROW][C]71[/C][C]225558[/C][C]289329[/C][C]-63771[/C][/ROW]
[ROW][C]72[/C][C]139220[/C][C]123977.375[/C][C]15242.625[/C][/ROW]
[ROW][C]73[/C][C]113612[/C][C]158311.869565217[/C][C]-44699.8695652174[/C][/ROW]
[ROW][C]74[/C][C]108641[/C][C]158311.869565217[/C][C]-49670.8695652174[/C][/ROW]
[ROW][C]75[/C][C]162203[/C][C]165656.5[/C][C]-3453.5[/C][/ROW]
[ROW][C]76[/C][C]100098[/C][C]158311.869565217[/C][C]-58213.8695652174[/C][/ROW]
[ROW][C]77[/C][C]174768[/C][C]165656.5[/C][C]9111.5[/C][/ROW]
[ROW][C]78[/C][C]158459[/C][C]220586.277777778[/C][C]-62127.2777777778[/C][/ROW]
[ROW][C]79[/C][C]80934[/C][C]82260.2105263158[/C][C]-1326.21052631579[/C][/ROW]
[ROW][C]80[/C][C]84971[/C][C]123977.375[/C][C]-39006.375[/C][/ROW]
[ROW][C]81[/C][C]80545[/C][C]82260.2105263158[/C][C]-1715.21052631579[/C][/ROW]
[ROW][C]82[/C][C]287191[/C][C]220586.277777778[/C][C]66604.7222222222[/C][/ROW]
[ROW][C]83[/C][C]62974[/C][C]82260.2105263158[/C][C]-19286.2105263158[/C][/ROW]
[ROW][C]84[/C][C]134091[/C][C]158311.869565217[/C][C]-24220.8695652174[/C][/ROW]
[ROW][C]85[/C][C]75555[/C][C]82260.2105263158[/C][C]-6705.21052631579[/C][/ROW]
[ROW][C]86[/C][C]162154[/C][C]158311.869565217[/C][C]3842.13043478262[/C][/ROW]
[ROW][C]87[/C][C]226638[/C][C]165656.5[/C][C]60981.5[/C][/ROW]
[ROW][C]88[/C][C]115367[/C][C]123977.375[/C][C]-8610.375[/C][/ROW]
[ROW][C]89[/C][C]108749[/C][C]123977.375[/C][C]-15228.375[/C][/ROW]
[ROW][C]90[/C][C]155537[/C][C]158311.869565217[/C][C]-2774.86956521738[/C][/ROW]
[ROW][C]91[/C][C]153133[/C][C]158311.869565217[/C][C]-5178.86956521738[/C][/ROW]
[ROW][C]92[/C][C]165618[/C][C]165656.5[/C][C]-38.5[/C][/ROW]
[ROW][C]93[/C][C]151517[/C][C]123977.375[/C][C]27539.625[/C][/ROW]
[ROW][C]94[/C][C]133686[/C][C]123977.375[/C][C]9708.625[/C][/ROW]
[ROW][C]95[/C][C]61342[/C][C]82260.2105263158[/C][C]-20918.2105263158[/C][/ROW]
[ROW][C]96[/C][C]245196[/C][C]289329[/C][C]-44133[/C][/ROW]
[ROW][C]97[/C][C]195576[/C][C]158311.869565217[/C][C]37264.1304347826[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]7038.38461538462[/C][C]12310.6153846154[/C][/ROW]
[ROW][C]99[/C][C]225371[/C][C]220586.277777778[/C][C]4784.72222222222[/C][/ROW]
[ROW][C]100[/C][C]153213[/C][C]158311.869565217[/C][C]-5098.86956521738[/C][/ROW]
[ROW][C]101[/C][C]59117[/C][C]34893.1428571429[/C][C]24223.8571428571[/C][/ROW]
[ROW][C]102[/C][C]91762[/C][C]82260.2105263158[/C][C]9501.78947368421[/C][/ROW]
[ROW][C]103[/C][C]136769[/C][C]123977.375[/C][C]12791.625[/C][/ROW]
[ROW][C]104[/C][C]114798[/C][C]123977.375[/C][C]-9179.375[/C][/ROW]
[ROW][C]105[/C][C]85338[/C][C]82260.2105263158[/C][C]3077.78947368421[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]34893.1428571429[/C][C]-7217.14285714286[/C][/ROW]
[ROW][C]107[/C][C]153535[/C][C]158311.869565217[/C][C]-4776.86956521738[/C][/ROW]
[ROW][C]108[/C][C]122417[/C][C]123977.375[/C][C]-1560.375[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]7038.38461538462[/C][C]-7038.38461538462[/C][/ROW]
[ROW][C]110[/C][C]91529[/C][C]82260.2105263158[/C][C]9268.78947368421[/C][/ROW]
[ROW][C]111[/C][C]107205[/C][C]123977.375[/C][C]-16772.375[/C][/ROW]
[ROW][C]112[/C][C]144664[/C][C]158311.869565217[/C][C]-13647.8695652174[/C][/ROW]
[ROW][C]113[/C][C]146445[/C][C]158311.869565217[/C][C]-11866.8695652174[/C][/ROW]
[ROW][C]114[/C][C]76656[/C][C]82260.2105263158[/C][C]-5604.21052631579[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]7038.38461538462[/C][C]-3422.38461538462[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]7038.38461538462[/C][C]-7038.38461538462[/C][/ROW]
[ROW][C]117[/C][C]183088[/C][C]123977.375[/C][C]59110.625[/C][/ROW]
[ROW][C]118[/C][C]144677[/C][C]158311.869565217[/C][C]-13634.8695652174[/C][/ROW]
[ROW][C]119[/C][C]159104[/C][C]158311.869565217[/C][C]792.130434782623[/C][/ROW]
[ROW][C]120[/C][C]113273[/C][C]82260.2105263158[/C][C]31012.7894736842[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]82260.2105263158[/C][C]-38850.2105263158[/C][/ROW]
[ROW][C]122[/C][C]175774[/C][C]158311.869565217[/C][C]17462.1304347826[/C][/ROW]
[ROW][C]123[/C][C]95401[/C][C]82260.2105263158[/C][C]13140.7894736842[/C][/ROW]
[ROW][C]124[/C][C]134837[/C][C]158311.869565217[/C][C]-23474.8695652174[/C][/ROW]
[ROW][C]125[/C][C]60493[/C][C]82260.2105263158[/C][C]-21767.2105263158[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]7038.38461538462[/C][C]12725.6153846154[/C][/ROW]
[ROW][C]127[/C][C]164062[/C][C]158311.869565217[/C][C]5750.13043478262[/C][/ROW]
[ROW][C]128[/C][C]132696[/C][C]123977.375[/C][C]8718.625[/C][/ROW]
[ROW][C]129[/C][C]155367[/C][C]158311.869565217[/C][C]-2944.86956521738[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]7038.38461538462[/C][C]4757.61538461538[/C][/ROW]
[ROW][C]131[/C][C]10674[/C][C]7038.38461538462[/C][C]3635.61538461538[/C][/ROW]
[ROW][C]132[/C][C]142261[/C][C]158311.869565217[/C][C]-16050.8695652174[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]7038.38461538462[/C][C]-202.384615384615[/C][/ROW]
[ROW][C]134[/C][C]162563[/C][C]158311.869565217[/C][C]4251.13043478262[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]7038.38461538462[/C][C]-1920.38461538462[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]34893.1428571429[/C][C]5354.85714285714[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]7038.38461538462[/C][C]-7038.38461538462[/C][/ROW]
[ROW][C]138[/C][C]122641[/C][C]82260.2105263158[/C][C]40380.7894736842[/C][/ROW]
[ROW][C]139[/C][C]88837[/C][C]123977.375[/C][C]-35140.375[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]7038.38461538462[/C][C]92.6153846153848[/C][/ROW]
[ROW][C]141[/C][C]9056[/C][C]34893.1428571429[/C][C]-25837.1428571429[/C][/ROW]
[ROW][C]142[/C][C]76611[/C][C]82260.2105263158[/C][C]-5649.21052631579[/C][/ROW]
[ROW][C]143[/C][C]132697[/C][C]123977.375[/C][C]8719.625[/C][/ROW]
[ROW][C]144[/C][C]100681[/C][C]123977.375[/C][C]-23296.375[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160309&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160309&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
1159261158311.869565217949.130434782623
2189672158311.86956521731360.1304347826
372157038.38461538462176.615384615385
4129098165656.5-36558.5
5230632289329-58697
6515038289329225709
7180745158311.86956521722433.1304347826
8185559158311.86956521727247.1304347826
9154581158311.869565217-3730.86956521738
10298001220586.27777777877414.7222222222
11121844158311.869565217-36467.8695652174
12184039165656.518382.5
13100324158311.869565217-57987.8695652174
14220269289329-69060
15168265158311.8695652179953.13043478262
16154647158311.869565217-3664.86956521738
17142018158311.869565217-16293.8695652174
1879030123977.375-44947.375
19167047220586.277777778-53539.2777777778
202799734893.1428571429-6896.14285714286
217301982260.2105263158-9241.21052631579
22241082220586.27777777820495.7222222222
23195820158311.86956521737508.1304347826
24142001165656.5-23655.5
25145433158311.869565217-12878.8695652174
26183744158311.86956521725432.1304347826
27202357158311.86956521744045.1304347826
28199532158311.86956521741220.1304347826
2935492428932965595
30192399220586.277777778-28187.2777777778
31182286158311.86956521723974.1304347826
32181590158311.86956521723278.1304347826
33133801165656.5-31855.5
34233686289329-55643
35219428220586.277777778-1158.27777777778
3607038.38461538462-7038.38461538462
37223044220586.2777777782457.72222222222
38100129158311.869565217-58182.8695652174
39145864165656.5-19792.5
40249965220586.27777777829378.7222222222
41242379220586.27777777821792.7222222222
42145794158311.869565217-12517.8695652174
439640482260.210526315814143.7894736842
44195891220586.277777778-24695.2777777778
45117156123977.375-6821.375
46157787123977.37533809.625
478129382260.2105263158-967.210526315786
48237435220586.27777777816848.7222222222
49233155220586.27777777812568.7222222222
50160344220586.277777778-60242.2777777778
514818834893.142857142913294.8571428571
52161922158311.8695652173610.13043478262
53307432220586.27777777886845.7222222222
54235223158311.86956521776911.1304347826
55195583158311.86956521737271.1304347826
56146061158311.869565217-12250.8695652174
57208834158311.86956521750522.1304347826
589376482260.210526315811503.7894736842
59151985123977.37528007.625
60193222220586.277777778-27364.2777777778
61148922158311.869565217-9389.86956521738
62132856158311.869565217-25455.8695652174
63129561123977.3755583.625
64112718123977.375-11259.375
65160930123977.37536952.625
6699184123977.375-24793.375
67192535165656.526878.5
68138708220586.277777778-81878.2777777778
69114408123977.375-9569.375
703197034893.1428571429-2923.14285714286
71225558289329-63771
72139220123977.37515242.625
73113612158311.869565217-44699.8695652174
74108641158311.869565217-49670.8695652174
75162203165656.5-3453.5
76100098158311.869565217-58213.8695652174
77174768165656.59111.5
78158459220586.277777778-62127.2777777778
798093482260.2105263158-1326.21052631579
8084971123977.375-39006.375
818054582260.2105263158-1715.21052631579
82287191220586.27777777866604.7222222222
836297482260.2105263158-19286.2105263158
84134091158311.869565217-24220.8695652174
857555582260.2105263158-6705.21052631579
86162154158311.8695652173842.13043478262
87226638165656.560981.5
88115367123977.375-8610.375
89108749123977.375-15228.375
90155537158311.869565217-2774.86956521738
91153133158311.869565217-5178.86956521738
92165618165656.5-38.5
93151517123977.37527539.625
94133686123977.3759708.625
956134282260.2105263158-20918.2105263158
96245196289329-44133
97195576158311.86956521737264.1304347826
98193497038.3846153846212310.6153846154
99225371220586.2777777784784.72222222222
100153213158311.869565217-5098.86956521738
1015911734893.142857142924223.8571428571
1029176282260.21052631589501.78947368421
103136769123977.37512791.625
104114798123977.375-9179.375
1058533882260.21052631583077.78947368421
1062767634893.1428571429-7217.14285714286
107153535158311.869565217-4776.86956521738
108122417123977.375-1560.375
10907038.38461538462-7038.38461538462
1109152982260.21052631589268.78947368421
111107205123977.375-16772.375
112144664158311.869565217-13647.8695652174
113146445158311.869565217-11866.8695652174
1147665682260.2105263158-5604.21052631579
11536167038.38461538462-3422.38461538462
11607038.38461538462-7038.38461538462
117183088123977.37559110.625
118144677158311.869565217-13634.8695652174
119159104158311.869565217792.130434782623
12011327382260.210526315831012.7894736842
1214341082260.2105263158-38850.2105263158
122175774158311.86956521717462.1304347826
1239540182260.210526315813140.7894736842
124134837158311.869565217-23474.8695652174
1256049382260.2105263158-21767.2105263158
126197647038.3846153846212725.6153846154
127164062158311.8695652175750.13043478262
128132696123977.3758718.625
129155367158311.869565217-2944.86956521738
130117967038.384615384624757.61538461538
131106747038.384615384623635.61538461538
132142261158311.869565217-16050.8695652174
13368367038.38461538462-202.384615384615
134162563158311.8695652174251.13043478262
13551187038.38461538462-1920.38461538462
1364024834893.14285714295354.85714285714
13707038.38461538462-7038.38461538462
13812264182260.210526315840380.7894736842
13988837123977.375-35140.375
14071317038.3846153846292.6153846153848
141905634893.1428571429-25837.1428571429
1427661182260.2105263158-5649.21052631579
143132697123977.3758719.625
144100681123977.375-23296.375



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