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 09:20:41 -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/t1324477295w0s227wsert3mvn.htm/, Retrieved Tue, 07 May 2024 10:19:18 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158723, Retrieved Tue, 07 May 2024 10:19:18 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact75
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Kendall tau Correlation Matrix] [KCM] [2011-12-21 13:22:03] [bab4e1d4a779bb46523d87231e2a2e96]
- RMP     [Recursive Partitioning (Regression Trees)] [RP] [2011-12-21 14:20:41] [b625935f05df8270d3a5abfea0142dde] [Current]
Feedback Forum

Post a new message
Dataseries X:
1773	158258	90	48	20465	6200
1704	186930	58	53	33629	10265
192	7215	18	0	1423	603
2295	129098	95	51	25629	8874
3450	230632	136	76	54002	20323
6813	508313	261	128	151036	26258
1795	180745	56	62	33287	10165
1681	185559	59	83	31172	8247
1897	154581	44	55	28113	8683
2917	290658	95	67	57803	16957
1946	121844	75	50	49830	8058
2148	184039	69	77	52143	20488
1832	100324	98	46	21055	7945
3138	215855	117	79	47007	13448
1476	168265	58	56	28735	5389
1567	154647	88	54	59147	6185
1756	142018	57	81	78950	24369
1247	79030	61	6	13497	70
2779	167047	87	74	46154	17327
726	27997	24	13	53249	3878
1048	73019	59	22	10726	3149
2805	241082	100	99	83700	20517
1760	195820	72	38	40400	2570
2261	141899	53	59	33797	5162
1848	145433	86	50	36205	5299
1665	183744	32	50	30165	7233
2082	202232	161	61	58534	15657
1440	199532	93	87	44663	15329
2741	354924	118	60	92556	14881
2112	192399	44	52	40078	16318
1684	182286	44	61	34711	9556
1616	181590	45	60	31076	10462
2227	133801	105	53	74608	7192
3088	233686	123	76	58092	4362
2389	219428	53	63	42009	14349
1	0	1	0	0	0
2099	223044	63	54	36022	10881
1669	100129	51	44	23333	8022
2095	136733	48	36	53349	13073
2153	249965	64	83	92596	26641
2390	242379	71	105	49598	14426
1701	145794	59	37	44093	15604
983	96404	32	25	84205	9184
2161	195891	78	64	63369	5989
1276	117156	50	55	60132	11270
1189	157787	94	41	37403	13958
745	81293	32	23	24460	7162
2231	224049	100	67	46456	13275
2242	223789	87	54	66616	21224
2639	160344	59	68	41554	10615
658	48188	28	12	22346	2102
1917	161922	69	99	30874	12396
2489	294283	73	74	68701	18717
2026	235223	79	56	35728	9724
1911	195583	59	67	29010	9863
1716	146061	56	40	23110	8374
1852	208834	67	53	38844	8030
981	93764	24	26	27084	7509
1177	151985	66	67	35139	14146
2809	190545	95	36	57476	7768
1688	148922	60	50	33277	13823
2097	132856	80	48	31141	7230
1309	126107	60	46	61281	10170
1244	112718	37	53	25820	7573
1256	160930	35	27	23284	5753
1293	99184	40	38	35378	9791
2303	192535	70	71	74990	19365
2897	138708	65	93	29653	9422
1103	114408	38	59	64622	12310
340	31970	15	5	4157	1283
2791	225558	112	53	29245	6372
1333	137011	71	40	50008	5413
1441	113612	68	72	52338	10837
1623	108641	71	51	13310	3394
2650	162203	67	81	92901	12964
1499	100098	44	27	10956	3495
2302	174768	60	94	34241	11580
2540	158459	97	71	75043	9970
1000	80934	30	20	21152	4911
1234	84971	71	34	42249	10138
927	80545	68	54	42005	14697
2176	287191	64	49	41152	8464
957	62974	28	26	14399	4204
1551	134091	40	48	28263	10226
1014	75555	46	35	17215	3456
1771	162154	54	32	48140	8895
2613	226638	227	55	62897	22557
1203	115019	110	58	22883	6900
1337	108749	62	44	41622	8620
1524	155537	52	45	40715	7820
1829	153133	41	49	65897	12112
2229	165618	78	72	76542	13178
1233	151517	57	39	37477	7028
1365	133686	58	28	53216	6616
950	61342	40	24	40911	9570
2319	245196	117	52	57021	14612
1857	195576	70	96	73116	11219
223	19349	12	13	3895	786
2390	225371	105	38	46609	11252
1973	152796	76	41	29351	9289
700	59117	29	24	2325	593
1062	91762	24	54	31747	6562
1311	136769	54	68	32665	8208
1157	114798	61	28	19249	7488
823	85338	40	36	15292	4574
596	27676	22	2	5842	522
1545	153535	48	91	33994	12840
1130	122417	37	29	13018	1350
0	0	0	0	0	0
1082	91529	32	46	98177	10623
1135	107205	67	25	37941	5322
1366	144664	44	51	31032	7987
1452	136540	62	59	32683	10566
870	76656	60	36	34545	1900
78	3616	5	0	0	0
0	0	0	0	0	0
1127	183065	43	40	27525	10698
1582	144677	84	68	66856	14884
2034	159104	98	28	28549	6852
919	113273	38	36	38610	6873
778	43410	19	7	2781	4
1752	175774	73	70	41211	9188
957	95401	42	30	22698	5141
1875	118893	54	59	41194	4260
731	60493	40	3	32689	443
285	19764	12	10	5752	2416
1834	164062	56	46	26757	9831
1147	132696	32	34	22527	5953
1646	155367	54	54	44810	9435
256	11796	9	1	0	0
98	10674	9	0	0	0
1404	142261	57	39	100674	7642
41	6836	3	0	0	0
1824	162563	63	48	57786	6837
42	5118	3	5	0	0
528	40248	16	8	5444	775
0	0	0	0	0	0
1073	122641	47	38	28470	8191
1305	88837	38	21	61849	1661
81	7131	4	0	0	0
261	9056	14	0	2179	548
934	76611	24	15	8019	3080
1179	132697	50	50	39644	13400
1147	100681	19	17	23494	8181




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158723&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.8623
R-squared0.7435
RMSE38628.0736

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8623[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7435[/C][/ROW]
[ROW][C]RMSE[/C][C]38628.0736[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158723&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158723&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.8623
R-squared0.7435
RMSE38628.0736







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1158258157211.5531914891046.44680851063
2186930157211.55319148929718.4468085106
372156214.692307692311000.30769230769
4129098202277.695652174-73179.6956521739
5230632254273.454545455-23641.4545454546
6508313254273.454545455254039.545454545
7180745157211.55319148923533.4468085106
8185559157211.55319148928347.4468085106
9154581157211.553191489-2630.55319148937
10290658254273.45454545536384.5454545454
11121844157211.553191489-35367.5531914894
12184039202277.695652174-18238.6956521739
13100324157211.553191489-56887.5531914894
14215855254273.454545455-38418.4545454546
15168265157211.55319148911053.4468085106
16154647157211.553191489-2564.55319148937
17142018157211.553191489-15193.5531914894
1879030123725.958333333-44695.9583333333
19167047254273.454545455-87226.4545454546
202799736422.8571428571-8425.85714285714
217301982260.2105263158-9241.21052631579
22241082254273.454545455-13191.4545454546
23195820157211.55319148938608.4468085106
24141899202277.695652174-60378.6956521739
25145433157211.553191489-11778.5531914894
26183744157211.55319148926532.4468085106
27202232157211.55319148945020.4468085106
28199532157211.55319148942320.4468085106
29354924254273.454545455100650.545454545
30192399202277.695652174-9878.69565217392
31182286157211.55319148925074.4468085106
32181590157211.55319148924378.4468085106
33133801202277.695652174-68476.6956521739
34233686254273.454545455-20587.4545454546
35219428202277.69565217417150.3043478261
3606214.69230769231-6214.69230769231
37223044202277.69565217420766.3043478261
38100129157211.553191489-57082.5531914894
39136733157211.553191489-20478.5531914894
40249965202277.69565217447687.3043478261
41242379202277.69565217440101.3043478261
42145794157211.553191489-11417.5531914894
439640482260.210526315814143.7894736842
44195891202277.695652174-6386.69565217392
45117156123725.958333333-6569.95833333333
46157787123725.95833333334061.0416666667
478129382260.2105263158-967.210526315786
48224049202277.69565217421771.3043478261
49223789202277.69565217421511.3043478261
50160344202277.695652174-41933.6956521739
514818836422.857142857111765.1428571429
52161922157211.5531914894710.44680851063
53294283202277.69565217492005.3043478261
54235223157211.55319148978011.4468085106
55195583157211.55319148938371.4468085106
56146061157211.553191489-11150.5531914894
57208834157211.55319148951622.4468085106
589376482260.210526315811503.7894736842
59151985123725.95833333328259.0416666667
60190545254273.454545455-63728.4545454546
61148922157211.553191489-8289.55319148937
62132856157211.553191489-24355.5531914894
63126107123725.9583333332381.04166666667
64112718123725.958333333-11007.9583333333
65160930123725.95833333337204.0416666667
6699184123725.958333333-24541.9583333333
67192535202277.695652174-9742.69565217392
68138708254273.454545455-115565.454545455
69114408123725.958333333-9317.95833333333
703197036422.8571428571-4452.85714285714
71225558254273.454545455-28715.4545454546
72137011123725.95833333313285.0416666667
73113612157211.553191489-43599.5531914894
74108641157211.553191489-48570.5531914894
75162203202277.695652174-40074.6956521739
76100098157211.553191489-57113.5531914894
77174768202277.695652174-27509.6956521739
78158459202277.695652174-43818.6956521739
798093482260.2105263158-1326.21052631579
8084971123725.958333333-38754.9583333333
818054582260.2105263158-1715.21052631579
82287191202277.69565217484913.3043478261
836297482260.2105263158-19286.2105263158
84134091157211.553191489-23120.5531914894
857555582260.2105263158-6705.21052631579
86162154157211.5531914894942.44680851063
87226638202277.69565217424360.3043478261
88115019123725.958333333-8706.95833333333
89108749123725.958333333-14976.9583333333
90155537157211.553191489-1674.55319148937
91153133157211.553191489-4078.55319148937
92165618202277.695652174-36659.6956521739
93151517123725.95833333327791.0416666667
94133686123725.9583333339960.04166666667
956134282260.2105263158-20918.2105263158
96245196202277.69565217442918.3043478261
97195576157211.55319148938364.4468085106
98193496214.6923076923113134.3076923077
99225371202277.69565217423093.3043478261
100152796157211.553191489-4415.55319148937
1015911736422.857142857122694.1428571429
1029176282260.21052631589501.78947368421
103136769123725.95833333313043.0416666667
104114798123725.958333333-8927.95833333333
1058533882260.21052631583077.78947368421
1062767636422.8571428571-8746.85714285714
107153535157211.553191489-3676.55319148937
108122417123725.958333333-1308.95833333333
10906214.69230769231-6214.69230769231
1109152982260.21052631589268.78947368421
111107205123725.958333333-16520.9583333333
112144664157211.553191489-12547.5531914894
113136540157211.553191489-20671.5531914894
1147665682260.2105263158-5604.21052631579
11536166214.69230769231-2598.69230769231
11606214.69230769231-6214.69230769231
117183065123725.95833333359339.0416666667
118144677157211.553191489-12534.5531914894
119159104157211.5531914891892.44680851063
12011327382260.210526315831012.7894736842
1214341082260.2105263158-38850.2105263158
122175774157211.55319148918562.4468085106
1239540182260.210526315813140.7894736842
124118893157211.553191489-38318.5531914894
1256049382260.2105263158-21767.2105263158
1261976436422.8571428571-16658.8571428571
127164062157211.5531914896850.44680851063
128132696123725.9583333338970.04166666667
129155367157211.553191489-1844.55319148937
130117966214.692307692315581.30769230769
131106746214.692307692314459.30769230769
132142261157211.553191489-14950.5531914894
13368366214.69230769231621.307692307692
134162563157211.5531914895351.44680851063
13551186214.69230769231-1096.69230769231
1364024836422.85714285713825.14285714286
13706214.69230769231-6214.69230769231
13812264182260.210526315840380.7894736842
13988837123725.958333333-34888.9583333333
14071316214.69230769231916.307692307692
14190566214.692307692312841.30769230769
1427661182260.2105263158-5649.21052631579
143132697123725.9583333338971.04166666667
144100681123725.958333333-23044.9583333333

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 158258 & 157211.553191489 & 1046.44680851063 \tabularnewline
2 & 186930 & 157211.553191489 & 29718.4468085106 \tabularnewline
3 & 7215 & 6214.69230769231 & 1000.30769230769 \tabularnewline
4 & 129098 & 202277.695652174 & -73179.6956521739 \tabularnewline
5 & 230632 & 254273.454545455 & -23641.4545454546 \tabularnewline
6 & 508313 & 254273.454545455 & 254039.545454545 \tabularnewline
7 & 180745 & 157211.553191489 & 23533.4468085106 \tabularnewline
8 & 185559 & 157211.553191489 & 28347.4468085106 \tabularnewline
9 & 154581 & 157211.553191489 & -2630.55319148937 \tabularnewline
10 & 290658 & 254273.454545455 & 36384.5454545454 \tabularnewline
11 & 121844 & 157211.553191489 & -35367.5531914894 \tabularnewline
12 & 184039 & 202277.695652174 & -18238.6956521739 \tabularnewline
13 & 100324 & 157211.553191489 & -56887.5531914894 \tabularnewline
14 & 215855 & 254273.454545455 & -38418.4545454546 \tabularnewline
15 & 168265 & 157211.553191489 & 11053.4468085106 \tabularnewline
16 & 154647 & 157211.553191489 & -2564.55319148937 \tabularnewline
17 & 142018 & 157211.553191489 & -15193.5531914894 \tabularnewline
18 & 79030 & 123725.958333333 & -44695.9583333333 \tabularnewline
19 & 167047 & 254273.454545455 & -87226.4545454546 \tabularnewline
20 & 27997 & 36422.8571428571 & -8425.85714285714 \tabularnewline
21 & 73019 & 82260.2105263158 & -9241.21052631579 \tabularnewline
22 & 241082 & 254273.454545455 & -13191.4545454546 \tabularnewline
23 & 195820 & 157211.553191489 & 38608.4468085106 \tabularnewline
24 & 141899 & 202277.695652174 & -60378.6956521739 \tabularnewline
25 & 145433 & 157211.553191489 & -11778.5531914894 \tabularnewline
26 & 183744 & 157211.553191489 & 26532.4468085106 \tabularnewline
27 & 202232 & 157211.553191489 & 45020.4468085106 \tabularnewline
28 & 199532 & 157211.553191489 & 42320.4468085106 \tabularnewline
29 & 354924 & 254273.454545455 & 100650.545454545 \tabularnewline
30 & 192399 & 202277.695652174 & -9878.69565217392 \tabularnewline
31 & 182286 & 157211.553191489 & 25074.4468085106 \tabularnewline
32 & 181590 & 157211.553191489 & 24378.4468085106 \tabularnewline
33 & 133801 & 202277.695652174 & -68476.6956521739 \tabularnewline
34 & 233686 & 254273.454545455 & -20587.4545454546 \tabularnewline
35 & 219428 & 202277.695652174 & 17150.3043478261 \tabularnewline
36 & 0 & 6214.69230769231 & -6214.69230769231 \tabularnewline
37 & 223044 & 202277.695652174 & 20766.3043478261 \tabularnewline
38 & 100129 & 157211.553191489 & -57082.5531914894 \tabularnewline
39 & 136733 & 157211.553191489 & -20478.5531914894 \tabularnewline
40 & 249965 & 202277.695652174 & 47687.3043478261 \tabularnewline
41 & 242379 & 202277.695652174 & 40101.3043478261 \tabularnewline
42 & 145794 & 157211.553191489 & -11417.5531914894 \tabularnewline
43 & 96404 & 82260.2105263158 & 14143.7894736842 \tabularnewline
44 & 195891 & 202277.695652174 & -6386.69565217392 \tabularnewline
45 & 117156 & 123725.958333333 & -6569.95833333333 \tabularnewline
46 & 157787 & 123725.958333333 & 34061.0416666667 \tabularnewline
47 & 81293 & 82260.2105263158 & -967.210526315786 \tabularnewline
48 & 224049 & 202277.695652174 & 21771.3043478261 \tabularnewline
49 & 223789 & 202277.695652174 & 21511.3043478261 \tabularnewline
50 & 160344 & 202277.695652174 & -41933.6956521739 \tabularnewline
51 & 48188 & 36422.8571428571 & 11765.1428571429 \tabularnewline
52 & 161922 & 157211.553191489 & 4710.44680851063 \tabularnewline
53 & 294283 & 202277.695652174 & 92005.3043478261 \tabularnewline
54 & 235223 & 157211.553191489 & 78011.4468085106 \tabularnewline
55 & 195583 & 157211.553191489 & 38371.4468085106 \tabularnewline
56 & 146061 & 157211.553191489 & -11150.5531914894 \tabularnewline
57 & 208834 & 157211.553191489 & 51622.4468085106 \tabularnewline
58 & 93764 & 82260.2105263158 & 11503.7894736842 \tabularnewline
59 & 151985 & 123725.958333333 & 28259.0416666667 \tabularnewline
60 & 190545 & 254273.454545455 & -63728.4545454546 \tabularnewline
61 & 148922 & 157211.553191489 & -8289.55319148937 \tabularnewline
62 & 132856 & 157211.553191489 & -24355.5531914894 \tabularnewline
63 & 126107 & 123725.958333333 & 2381.04166666667 \tabularnewline
64 & 112718 & 123725.958333333 & -11007.9583333333 \tabularnewline
65 & 160930 & 123725.958333333 & 37204.0416666667 \tabularnewline
66 & 99184 & 123725.958333333 & -24541.9583333333 \tabularnewline
67 & 192535 & 202277.695652174 & -9742.69565217392 \tabularnewline
68 & 138708 & 254273.454545455 & -115565.454545455 \tabularnewline
69 & 114408 & 123725.958333333 & -9317.95833333333 \tabularnewline
70 & 31970 & 36422.8571428571 & -4452.85714285714 \tabularnewline
71 & 225558 & 254273.454545455 & -28715.4545454546 \tabularnewline
72 & 137011 & 123725.958333333 & 13285.0416666667 \tabularnewline
73 & 113612 & 157211.553191489 & -43599.5531914894 \tabularnewline
74 & 108641 & 157211.553191489 & -48570.5531914894 \tabularnewline
75 & 162203 & 202277.695652174 & -40074.6956521739 \tabularnewline
76 & 100098 & 157211.553191489 & -57113.5531914894 \tabularnewline
77 & 174768 & 202277.695652174 & -27509.6956521739 \tabularnewline
78 & 158459 & 202277.695652174 & -43818.6956521739 \tabularnewline
79 & 80934 & 82260.2105263158 & -1326.21052631579 \tabularnewline
80 & 84971 & 123725.958333333 & -38754.9583333333 \tabularnewline
81 & 80545 & 82260.2105263158 & -1715.21052631579 \tabularnewline
82 & 287191 & 202277.695652174 & 84913.3043478261 \tabularnewline
83 & 62974 & 82260.2105263158 & -19286.2105263158 \tabularnewline
84 & 134091 & 157211.553191489 & -23120.5531914894 \tabularnewline
85 & 75555 & 82260.2105263158 & -6705.21052631579 \tabularnewline
86 & 162154 & 157211.553191489 & 4942.44680851063 \tabularnewline
87 & 226638 & 202277.695652174 & 24360.3043478261 \tabularnewline
88 & 115019 & 123725.958333333 & -8706.95833333333 \tabularnewline
89 & 108749 & 123725.958333333 & -14976.9583333333 \tabularnewline
90 & 155537 & 157211.553191489 & -1674.55319148937 \tabularnewline
91 & 153133 & 157211.553191489 & -4078.55319148937 \tabularnewline
92 & 165618 & 202277.695652174 & -36659.6956521739 \tabularnewline
93 & 151517 & 123725.958333333 & 27791.0416666667 \tabularnewline
94 & 133686 & 123725.958333333 & 9960.04166666667 \tabularnewline
95 & 61342 & 82260.2105263158 & -20918.2105263158 \tabularnewline
96 & 245196 & 202277.695652174 & 42918.3043478261 \tabularnewline
97 & 195576 & 157211.553191489 & 38364.4468085106 \tabularnewline
98 & 19349 & 6214.69230769231 & 13134.3076923077 \tabularnewline
99 & 225371 & 202277.695652174 & 23093.3043478261 \tabularnewline
100 & 152796 & 157211.553191489 & -4415.55319148937 \tabularnewline
101 & 59117 & 36422.8571428571 & 22694.1428571429 \tabularnewline
102 & 91762 & 82260.2105263158 & 9501.78947368421 \tabularnewline
103 & 136769 & 123725.958333333 & 13043.0416666667 \tabularnewline
104 & 114798 & 123725.958333333 & -8927.95833333333 \tabularnewline
105 & 85338 & 82260.2105263158 & 3077.78947368421 \tabularnewline
106 & 27676 & 36422.8571428571 & -8746.85714285714 \tabularnewline
107 & 153535 & 157211.553191489 & -3676.55319148937 \tabularnewline
108 & 122417 & 123725.958333333 & -1308.95833333333 \tabularnewline
109 & 0 & 6214.69230769231 & -6214.69230769231 \tabularnewline
110 & 91529 & 82260.2105263158 & 9268.78947368421 \tabularnewline
111 & 107205 & 123725.958333333 & -16520.9583333333 \tabularnewline
112 & 144664 & 157211.553191489 & -12547.5531914894 \tabularnewline
113 & 136540 & 157211.553191489 & -20671.5531914894 \tabularnewline
114 & 76656 & 82260.2105263158 & -5604.21052631579 \tabularnewline
115 & 3616 & 6214.69230769231 & -2598.69230769231 \tabularnewline
116 & 0 & 6214.69230769231 & -6214.69230769231 \tabularnewline
117 & 183065 & 123725.958333333 & 59339.0416666667 \tabularnewline
118 & 144677 & 157211.553191489 & -12534.5531914894 \tabularnewline
119 & 159104 & 157211.553191489 & 1892.44680851063 \tabularnewline
120 & 113273 & 82260.2105263158 & 31012.7894736842 \tabularnewline
121 & 43410 & 82260.2105263158 & -38850.2105263158 \tabularnewline
122 & 175774 & 157211.553191489 & 18562.4468085106 \tabularnewline
123 & 95401 & 82260.2105263158 & 13140.7894736842 \tabularnewline
124 & 118893 & 157211.553191489 & -38318.5531914894 \tabularnewline
125 & 60493 & 82260.2105263158 & -21767.2105263158 \tabularnewline
126 & 19764 & 36422.8571428571 & -16658.8571428571 \tabularnewline
127 & 164062 & 157211.553191489 & 6850.44680851063 \tabularnewline
128 & 132696 & 123725.958333333 & 8970.04166666667 \tabularnewline
129 & 155367 & 157211.553191489 & -1844.55319148937 \tabularnewline
130 & 11796 & 6214.69230769231 & 5581.30769230769 \tabularnewline
131 & 10674 & 6214.69230769231 & 4459.30769230769 \tabularnewline
132 & 142261 & 157211.553191489 & -14950.5531914894 \tabularnewline
133 & 6836 & 6214.69230769231 & 621.307692307692 \tabularnewline
134 & 162563 & 157211.553191489 & 5351.44680851063 \tabularnewline
135 & 5118 & 6214.69230769231 & -1096.69230769231 \tabularnewline
136 & 40248 & 36422.8571428571 & 3825.14285714286 \tabularnewline
137 & 0 & 6214.69230769231 & -6214.69230769231 \tabularnewline
138 & 122641 & 82260.2105263158 & 40380.7894736842 \tabularnewline
139 & 88837 & 123725.958333333 & -34888.9583333333 \tabularnewline
140 & 7131 & 6214.69230769231 & 916.307692307692 \tabularnewline
141 & 9056 & 6214.69230769231 & 2841.30769230769 \tabularnewline
142 & 76611 & 82260.2105263158 & -5649.21052631579 \tabularnewline
143 & 132697 & 123725.958333333 & 8971.04166666667 \tabularnewline
144 & 100681 & 123725.958333333 & -23044.9583333333 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158723&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]158258[/C][C]157211.553191489[/C][C]1046.44680851063[/C][/ROW]
[ROW][C]2[/C][C]186930[/C][C]157211.553191489[/C][C]29718.4468085106[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]6214.69230769231[/C][C]1000.30769230769[/C][/ROW]
[ROW][C]4[/C][C]129098[/C][C]202277.695652174[/C][C]-73179.6956521739[/C][/ROW]
[ROW][C]5[/C][C]230632[/C][C]254273.454545455[/C][C]-23641.4545454546[/C][/ROW]
[ROW][C]6[/C][C]508313[/C][C]254273.454545455[/C][C]254039.545454545[/C][/ROW]
[ROW][C]7[/C][C]180745[/C][C]157211.553191489[/C][C]23533.4468085106[/C][/ROW]
[ROW][C]8[/C][C]185559[/C][C]157211.553191489[/C][C]28347.4468085106[/C][/ROW]
[ROW][C]9[/C][C]154581[/C][C]157211.553191489[/C][C]-2630.55319148937[/C][/ROW]
[ROW][C]10[/C][C]290658[/C][C]254273.454545455[/C][C]36384.5454545454[/C][/ROW]
[ROW][C]11[/C][C]121844[/C][C]157211.553191489[/C][C]-35367.5531914894[/C][/ROW]
[ROW][C]12[/C][C]184039[/C][C]202277.695652174[/C][C]-18238.6956521739[/C][/ROW]
[ROW][C]13[/C][C]100324[/C][C]157211.553191489[/C][C]-56887.5531914894[/C][/ROW]
[ROW][C]14[/C][C]215855[/C][C]254273.454545455[/C][C]-38418.4545454546[/C][/ROW]
[ROW][C]15[/C][C]168265[/C][C]157211.553191489[/C][C]11053.4468085106[/C][/ROW]
[ROW][C]16[/C][C]154647[/C][C]157211.553191489[/C][C]-2564.55319148937[/C][/ROW]
[ROW][C]17[/C][C]142018[/C][C]157211.553191489[/C][C]-15193.5531914894[/C][/ROW]
[ROW][C]18[/C][C]79030[/C][C]123725.958333333[/C][C]-44695.9583333333[/C][/ROW]
[ROW][C]19[/C][C]167047[/C][C]254273.454545455[/C][C]-87226.4545454546[/C][/ROW]
[ROW][C]20[/C][C]27997[/C][C]36422.8571428571[/C][C]-8425.85714285714[/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]254273.454545455[/C][C]-13191.4545454546[/C][/ROW]
[ROW][C]23[/C][C]195820[/C][C]157211.553191489[/C][C]38608.4468085106[/C][/ROW]
[ROW][C]24[/C][C]141899[/C][C]202277.695652174[/C][C]-60378.6956521739[/C][/ROW]
[ROW][C]25[/C][C]145433[/C][C]157211.553191489[/C][C]-11778.5531914894[/C][/ROW]
[ROW][C]26[/C][C]183744[/C][C]157211.553191489[/C][C]26532.4468085106[/C][/ROW]
[ROW][C]27[/C][C]202232[/C][C]157211.553191489[/C][C]45020.4468085106[/C][/ROW]
[ROW][C]28[/C][C]199532[/C][C]157211.553191489[/C][C]42320.4468085106[/C][/ROW]
[ROW][C]29[/C][C]354924[/C][C]254273.454545455[/C][C]100650.545454545[/C][/ROW]
[ROW][C]30[/C][C]192399[/C][C]202277.695652174[/C][C]-9878.69565217392[/C][/ROW]
[ROW][C]31[/C][C]182286[/C][C]157211.553191489[/C][C]25074.4468085106[/C][/ROW]
[ROW][C]32[/C][C]181590[/C][C]157211.553191489[/C][C]24378.4468085106[/C][/ROW]
[ROW][C]33[/C][C]133801[/C][C]202277.695652174[/C][C]-68476.6956521739[/C][/ROW]
[ROW][C]34[/C][C]233686[/C][C]254273.454545455[/C][C]-20587.4545454546[/C][/ROW]
[ROW][C]35[/C][C]219428[/C][C]202277.695652174[/C][C]17150.3043478261[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]6214.69230769231[/C][C]-6214.69230769231[/C][/ROW]
[ROW][C]37[/C][C]223044[/C][C]202277.695652174[/C][C]20766.3043478261[/C][/ROW]
[ROW][C]38[/C][C]100129[/C][C]157211.553191489[/C][C]-57082.5531914894[/C][/ROW]
[ROW][C]39[/C][C]136733[/C][C]157211.553191489[/C][C]-20478.5531914894[/C][/ROW]
[ROW][C]40[/C][C]249965[/C][C]202277.695652174[/C][C]47687.3043478261[/C][/ROW]
[ROW][C]41[/C][C]242379[/C][C]202277.695652174[/C][C]40101.3043478261[/C][/ROW]
[ROW][C]42[/C][C]145794[/C][C]157211.553191489[/C][C]-11417.5531914894[/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]202277.695652174[/C][C]-6386.69565217392[/C][/ROW]
[ROW][C]45[/C][C]117156[/C][C]123725.958333333[/C][C]-6569.95833333333[/C][/ROW]
[ROW][C]46[/C][C]157787[/C][C]123725.958333333[/C][C]34061.0416666667[/C][/ROW]
[ROW][C]47[/C][C]81293[/C][C]82260.2105263158[/C][C]-967.210526315786[/C][/ROW]
[ROW][C]48[/C][C]224049[/C][C]202277.695652174[/C][C]21771.3043478261[/C][/ROW]
[ROW][C]49[/C][C]223789[/C][C]202277.695652174[/C][C]21511.3043478261[/C][/ROW]
[ROW][C]50[/C][C]160344[/C][C]202277.695652174[/C][C]-41933.6956521739[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]36422.8571428571[/C][C]11765.1428571429[/C][/ROW]
[ROW][C]52[/C][C]161922[/C][C]157211.553191489[/C][C]4710.44680851063[/C][/ROW]
[ROW][C]53[/C][C]294283[/C][C]202277.695652174[/C][C]92005.3043478261[/C][/ROW]
[ROW][C]54[/C][C]235223[/C][C]157211.553191489[/C][C]78011.4468085106[/C][/ROW]
[ROW][C]55[/C][C]195583[/C][C]157211.553191489[/C][C]38371.4468085106[/C][/ROW]
[ROW][C]56[/C][C]146061[/C][C]157211.553191489[/C][C]-11150.5531914894[/C][/ROW]
[ROW][C]57[/C][C]208834[/C][C]157211.553191489[/C][C]51622.4468085106[/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]123725.958333333[/C][C]28259.0416666667[/C][/ROW]
[ROW][C]60[/C][C]190545[/C][C]254273.454545455[/C][C]-63728.4545454546[/C][/ROW]
[ROW][C]61[/C][C]148922[/C][C]157211.553191489[/C][C]-8289.55319148937[/C][/ROW]
[ROW][C]62[/C][C]132856[/C][C]157211.553191489[/C][C]-24355.5531914894[/C][/ROW]
[ROW][C]63[/C][C]126107[/C][C]123725.958333333[/C][C]2381.04166666667[/C][/ROW]
[ROW][C]64[/C][C]112718[/C][C]123725.958333333[/C][C]-11007.9583333333[/C][/ROW]
[ROW][C]65[/C][C]160930[/C][C]123725.958333333[/C][C]37204.0416666667[/C][/ROW]
[ROW][C]66[/C][C]99184[/C][C]123725.958333333[/C][C]-24541.9583333333[/C][/ROW]
[ROW][C]67[/C][C]192535[/C][C]202277.695652174[/C][C]-9742.69565217392[/C][/ROW]
[ROW][C]68[/C][C]138708[/C][C]254273.454545455[/C][C]-115565.454545455[/C][/ROW]
[ROW][C]69[/C][C]114408[/C][C]123725.958333333[/C][C]-9317.95833333333[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]36422.8571428571[/C][C]-4452.85714285714[/C][/ROW]
[ROW][C]71[/C][C]225558[/C][C]254273.454545455[/C][C]-28715.4545454546[/C][/ROW]
[ROW][C]72[/C][C]137011[/C][C]123725.958333333[/C][C]13285.0416666667[/C][/ROW]
[ROW][C]73[/C][C]113612[/C][C]157211.553191489[/C][C]-43599.5531914894[/C][/ROW]
[ROW][C]74[/C][C]108641[/C][C]157211.553191489[/C][C]-48570.5531914894[/C][/ROW]
[ROW][C]75[/C][C]162203[/C][C]202277.695652174[/C][C]-40074.6956521739[/C][/ROW]
[ROW][C]76[/C][C]100098[/C][C]157211.553191489[/C][C]-57113.5531914894[/C][/ROW]
[ROW][C]77[/C][C]174768[/C][C]202277.695652174[/C][C]-27509.6956521739[/C][/ROW]
[ROW][C]78[/C][C]158459[/C][C]202277.695652174[/C][C]-43818.6956521739[/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]123725.958333333[/C][C]-38754.9583333333[/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]202277.695652174[/C][C]84913.3043478261[/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]157211.553191489[/C][C]-23120.5531914894[/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]157211.553191489[/C][C]4942.44680851063[/C][/ROW]
[ROW][C]87[/C][C]226638[/C][C]202277.695652174[/C][C]24360.3043478261[/C][/ROW]
[ROW][C]88[/C][C]115019[/C][C]123725.958333333[/C][C]-8706.95833333333[/C][/ROW]
[ROW][C]89[/C][C]108749[/C][C]123725.958333333[/C][C]-14976.9583333333[/C][/ROW]
[ROW][C]90[/C][C]155537[/C][C]157211.553191489[/C][C]-1674.55319148937[/C][/ROW]
[ROW][C]91[/C][C]153133[/C][C]157211.553191489[/C][C]-4078.55319148937[/C][/ROW]
[ROW][C]92[/C][C]165618[/C][C]202277.695652174[/C][C]-36659.6956521739[/C][/ROW]
[ROW][C]93[/C][C]151517[/C][C]123725.958333333[/C][C]27791.0416666667[/C][/ROW]
[ROW][C]94[/C][C]133686[/C][C]123725.958333333[/C][C]9960.04166666667[/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]202277.695652174[/C][C]42918.3043478261[/C][/ROW]
[ROW][C]97[/C][C]195576[/C][C]157211.553191489[/C][C]38364.4468085106[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]6214.69230769231[/C][C]13134.3076923077[/C][/ROW]
[ROW][C]99[/C][C]225371[/C][C]202277.695652174[/C][C]23093.3043478261[/C][/ROW]
[ROW][C]100[/C][C]152796[/C][C]157211.553191489[/C][C]-4415.55319148937[/C][/ROW]
[ROW][C]101[/C][C]59117[/C][C]36422.8571428571[/C][C]22694.1428571429[/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]123725.958333333[/C][C]13043.0416666667[/C][/ROW]
[ROW][C]104[/C][C]114798[/C][C]123725.958333333[/C][C]-8927.95833333333[/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]36422.8571428571[/C][C]-8746.85714285714[/C][/ROW]
[ROW][C]107[/C][C]153535[/C][C]157211.553191489[/C][C]-3676.55319148937[/C][/ROW]
[ROW][C]108[/C][C]122417[/C][C]123725.958333333[/C][C]-1308.95833333333[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]6214.69230769231[/C][C]-6214.69230769231[/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]123725.958333333[/C][C]-16520.9583333333[/C][/ROW]
[ROW][C]112[/C][C]144664[/C][C]157211.553191489[/C][C]-12547.5531914894[/C][/ROW]
[ROW][C]113[/C][C]136540[/C][C]157211.553191489[/C][C]-20671.5531914894[/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]6214.69230769231[/C][C]-2598.69230769231[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]6214.69230769231[/C][C]-6214.69230769231[/C][/ROW]
[ROW][C]117[/C][C]183065[/C][C]123725.958333333[/C][C]59339.0416666667[/C][/ROW]
[ROW][C]118[/C][C]144677[/C][C]157211.553191489[/C][C]-12534.5531914894[/C][/ROW]
[ROW][C]119[/C][C]159104[/C][C]157211.553191489[/C][C]1892.44680851063[/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]157211.553191489[/C][C]18562.4468085106[/C][/ROW]
[ROW][C]123[/C][C]95401[/C][C]82260.2105263158[/C][C]13140.7894736842[/C][/ROW]
[ROW][C]124[/C][C]118893[/C][C]157211.553191489[/C][C]-38318.5531914894[/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]36422.8571428571[/C][C]-16658.8571428571[/C][/ROW]
[ROW][C]127[/C][C]164062[/C][C]157211.553191489[/C][C]6850.44680851063[/C][/ROW]
[ROW][C]128[/C][C]132696[/C][C]123725.958333333[/C][C]8970.04166666667[/C][/ROW]
[ROW][C]129[/C][C]155367[/C][C]157211.553191489[/C][C]-1844.55319148937[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]6214.69230769231[/C][C]5581.30769230769[/C][/ROW]
[ROW][C]131[/C][C]10674[/C][C]6214.69230769231[/C][C]4459.30769230769[/C][/ROW]
[ROW][C]132[/C][C]142261[/C][C]157211.553191489[/C][C]-14950.5531914894[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]6214.69230769231[/C][C]621.307692307692[/C][/ROW]
[ROW][C]134[/C][C]162563[/C][C]157211.553191489[/C][C]5351.44680851063[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]6214.69230769231[/C][C]-1096.69230769231[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]36422.8571428571[/C][C]3825.14285714286[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]6214.69230769231[/C][C]-6214.69230769231[/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]123725.958333333[/C][C]-34888.9583333333[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]6214.69230769231[/C][C]916.307692307692[/C][/ROW]
[ROW][C]141[/C][C]9056[/C][C]6214.69230769231[/C][C]2841.30769230769[/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]123725.958333333[/C][C]8971.04166666667[/C][/ROW]
[ROW][C]144[/C][C]100681[/C][C]123725.958333333[/C][C]-23044.9583333333[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158723&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158723&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
1158258157211.5531914891046.44680851063
2186930157211.55319148929718.4468085106
372156214.692307692311000.30769230769
4129098202277.695652174-73179.6956521739
5230632254273.454545455-23641.4545454546
6508313254273.454545455254039.545454545
7180745157211.55319148923533.4468085106
8185559157211.55319148928347.4468085106
9154581157211.553191489-2630.55319148937
10290658254273.45454545536384.5454545454
11121844157211.553191489-35367.5531914894
12184039202277.695652174-18238.6956521739
13100324157211.553191489-56887.5531914894
14215855254273.454545455-38418.4545454546
15168265157211.55319148911053.4468085106
16154647157211.553191489-2564.55319148937
17142018157211.553191489-15193.5531914894
1879030123725.958333333-44695.9583333333
19167047254273.454545455-87226.4545454546
202799736422.8571428571-8425.85714285714
217301982260.2105263158-9241.21052631579
22241082254273.454545455-13191.4545454546
23195820157211.55319148938608.4468085106
24141899202277.695652174-60378.6956521739
25145433157211.553191489-11778.5531914894
26183744157211.55319148926532.4468085106
27202232157211.55319148945020.4468085106
28199532157211.55319148942320.4468085106
29354924254273.454545455100650.545454545
30192399202277.695652174-9878.69565217392
31182286157211.55319148925074.4468085106
32181590157211.55319148924378.4468085106
33133801202277.695652174-68476.6956521739
34233686254273.454545455-20587.4545454546
35219428202277.69565217417150.3043478261
3606214.69230769231-6214.69230769231
37223044202277.69565217420766.3043478261
38100129157211.553191489-57082.5531914894
39136733157211.553191489-20478.5531914894
40249965202277.69565217447687.3043478261
41242379202277.69565217440101.3043478261
42145794157211.553191489-11417.5531914894
439640482260.210526315814143.7894736842
44195891202277.695652174-6386.69565217392
45117156123725.958333333-6569.95833333333
46157787123725.95833333334061.0416666667
478129382260.2105263158-967.210526315786
48224049202277.69565217421771.3043478261
49223789202277.69565217421511.3043478261
50160344202277.695652174-41933.6956521739
514818836422.857142857111765.1428571429
52161922157211.5531914894710.44680851063
53294283202277.69565217492005.3043478261
54235223157211.55319148978011.4468085106
55195583157211.55319148938371.4468085106
56146061157211.553191489-11150.5531914894
57208834157211.55319148951622.4468085106
589376482260.210526315811503.7894736842
59151985123725.95833333328259.0416666667
60190545254273.454545455-63728.4545454546
61148922157211.553191489-8289.55319148937
62132856157211.553191489-24355.5531914894
63126107123725.9583333332381.04166666667
64112718123725.958333333-11007.9583333333
65160930123725.95833333337204.0416666667
6699184123725.958333333-24541.9583333333
67192535202277.695652174-9742.69565217392
68138708254273.454545455-115565.454545455
69114408123725.958333333-9317.95833333333
703197036422.8571428571-4452.85714285714
71225558254273.454545455-28715.4545454546
72137011123725.95833333313285.0416666667
73113612157211.553191489-43599.5531914894
74108641157211.553191489-48570.5531914894
75162203202277.695652174-40074.6956521739
76100098157211.553191489-57113.5531914894
77174768202277.695652174-27509.6956521739
78158459202277.695652174-43818.6956521739
798093482260.2105263158-1326.21052631579
8084971123725.958333333-38754.9583333333
818054582260.2105263158-1715.21052631579
82287191202277.69565217484913.3043478261
836297482260.2105263158-19286.2105263158
84134091157211.553191489-23120.5531914894
857555582260.2105263158-6705.21052631579
86162154157211.5531914894942.44680851063
87226638202277.69565217424360.3043478261
88115019123725.958333333-8706.95833333333
89108749123725.958333333-14976.9583333333
90155537157211.553191489-1674.55319148937
91153133157211.553191489-4078.55319148937
92165618202277.695652174-36659.6956521739
93151517123725.95833333327791.0416666667
94133686123725.9583333339960.04166666667
956134282260.2105263158-20918.2105263158
96245196202277.69565217442918.3043478261
97195576157211.55319148938364.4468085106
98193496214.6923076923113134.3076923077
99225371202277.69565217423093.3043478261
100152796157211.553191489-4415.55319148937
1015911736422.857142857122694.1428571429
1029176282260.21052631589501.78947368421
103136769123725.95833333313043.0416666667
104114798123725.958333333-8927.95833333333
1058533882260.21052631583077.78947368421
1062767636422.8571428571-8746.85714285714
107153535157211.553191489-3676.55319148937
108122417123725.958333333-1308.95833333333
10906214.69230769231-6214.69230769231
1109152982260.21052631589268.78947368421
111107205123725.958333333-16520.9583333333
112144664157211.553191489-12547.5531914894
113136540157211.553191489-20671.5531914894
1147665682260.2105263158-5604.21052631579
11536166214.69230769231-2598.69230769231
11606214.69230769231-6214.69230769231
117183065123725.95833333359339.0416666667
118144677157211.553191489-12534.5531914894
119159104157211.5531914891892.44680851063
12011327382260.210526315831012.7894736842
1214341082260.2105263158-38850.2105263158
122175774157211.55319148918562.4468085106
1239540182260.210526315813140.7894736842
124118893157211.553191489-38318.5531914894
1256049382260.2105263158-21767.2105263158
1261976436422.8571428571-16658.8571428571
127164062157211.5531914896850.44680851063
128132696123725.9583333338970.04166666667
129155367157211.553191489-1844.55319148937
130117966214.692307692315581.30769230769
131106746214.692307692314459.30769230769
132142261157211.553191489-14950.5531914894
13368366214.69230769231621.307692307692
134162563157211.5531914895351.44680851063
13551186214.69230769231-1096.69230769231
1364024836422.85714285713825.14285714286
13706214.69230769231-6214.69230769231
13812264182260.210526315840380.7894736842
13988837123725.958333333-34888.9583333333
14071316214.69230769231916.307692307692
14190566214.692307692312841.30769230769
1427661182260.2105263158-5649.21052631579
143132697123725.9583333338971.04166666667
144100681123725.958333333-23044.9583333333



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