Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Module--
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationTue, 21 Aug 2012 18:59:12 -0400
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2012/Aug/21/t1345590007s0v5vyqga5v3eqp.htm/, Retrieved Thu, 02 May 2024 23:03:00 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=169477, Retrieved Thu, 02 May 2024 23:03:00 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact168
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Multiple Regression] [] [2010-12-05 18:56:24] [b98453cac15ba1066b407e146608df68]
- RMPD  [Recursive Partitioning (Regression Trees)] [RP(geen categorie...] [2011-12-22 15:40:18] [729e3e98c2c68b03161978d53cee5b12]
- RMP       [Recursive Partitioning (Regression Trees)] [] [2012-08-21 22:59:12] [6ca9362bade14820cda7467b7288bbb3] [Current]
Feedback Forum

Post a new message
Dataseries X:
162687	1845	95	595	21	20465
201906	1796	62	545	20	33629
7215	192	18	72	0	1423
146367	2444	97	679	27	25629
257045	3567	139	1201	31	54002
524450	6917	265	1967	36	151036
188294	1840	58	595	23	33287
195674	1740	60	496	30	31172
177020	2078	44	670	30	28113
330194	3118	99	1047	27	57803
121844	1946	75	634	24	49830
203938	2370	72	743	30	52143
113213	1944	106	686	22	21055
220751	3198	120	1086	28	47007
172905	1491	63	419	18	28735
156326	1573	88	474	22	59147
145178	1807	58	442	37	78950
89171	1309	61	373	15	13497
172624	2820	88	899	34	46154
39790	776	27	242	18	53249
87927	1162	62	399	15	10726
241285	2818	103	850	30	83700
195820	1761	73	642	25	40400
146946	2315	56	717	34	33797
159763	1994	89	619	21	36205
207078	1806	34	657	21	30165
212394	2152	166	691	25	58534
201536	1457	95	366	31	44663
394662	3000	121	994	31	92556
217892	2236	46	929	20	40078
182286	1685	45	490	28	34711
181740	1626	47	553	22	31076
137978	2257	107	738	17	74608
255929	3373	130	1028	25	58092
236489	2571	55	844	25	42009
0	1	1	0	0	0
230761	2142	64	1000	31	36022
132807	1878	54	629	14	23333
157118	2190	49	532	35	53349
253254	2186	68	811	34	92596
269329	2533	72	837	22	49598
161273	1823	61	682	34	44093
107181	1095	33	400	23	84205
195891	2162	79	804	24	63369
139667	1365	51	419	26	60132
171101	1245	99	334	23	37403
81407	756	33	216	35	24460
247563	2417	104	786	24	46456
239807	2327	90	752	31	66616
172743	2786	59	964	30	41554
48188	658	28	205	22	22346
169355	2012	70	506	23	30874
325322	2616	77	830	27	68701
241518	2071	79	694	30	35728
195583	1911	59	691	33	29010
159913	1775	57	547	12	23110
220241	1919	70	538	26	38844
101694	1047	26	329	26	27084
157258	1190	68	427	23	35139
202536	2890	99	972	38	57476
173505	1836	64	541	32	33277
150518	2254	83	836	21	31141
141491	1392	64	376	22	61281
125612	1325	38	467	26	25820
166049	1317	36	430	28	23284
124197	1525	42	483	33	35378
195043	2335	71	504	36	74990
138708	2897	65	887	25	29653
116552	1118	40	271	25	64622
31970	340	15	101	21	4157
258158	2977	115	1097	19	29245
151194	1452	79	470	12	50008
135926	1550	68	528	30	52338
119629	1685	73	475	21	13310
171518	2728	71	698	39	92901
108949	1574	45	425	32	10956
183471	2413	60	709	28	34241
159966	2563	98	824	29	75043
93786	1079	34	336	21	21152
84971	1235	72	395	31	42249
88882	980	76	234	26	42005
304603	2246	65	830	29	41152
75101	1076	30	334	23	14399
145043	1637	40	524	25	28263
95827	1208	48	393	22	17215
173924	1865	58	574	26	48140
241957	2726	237	672	33	62897
115367	1208	115	284	24	22883
118408	1419	64	450	24	41622
164078	1609	53	653	21	40715
158931	1864	41	684	28	65897
184139	2412	82	706	28	76542
152856	1238	58	417	25	37477
144014	1462	59	549	15	53216
62535	973	42	394	13	40911
245196	2319	117	730	36	57021
199841	1890	71	571	27	73116
19349	223	12	67	1	3895
247280	2526	108	877	24	46609
159408	2072	83	856	31	29351
72128	778	30	306	4	2325
104253	1194	26	382	21	31747
151090	1424	57	435	27	32665
137382	1328	66	336	23	19249
87448	839	42	227	12	15292
27676	596	22	194	16	5842
165507	1671	50	410	29	33994
132148	1167	37	273	26	13018
0	0	0	0	0	0
95778	1106	34	343	25	98177
109001	1148	67	376	21	37941
158833	1485	46	495	24	31032
147690	1526	63	448	21	32683
89887	962	63	313	21	34545
3616	78	5	14	0	0
0	0	0	0	0	0
199005	1184	45	410	23	27525
160930	1671	92	606	33	66856
177948	2142	102	593	32	28549
136061	1015	39	312	23	38610
43410	778	19	292	1	2781
184277	1856	74	547	29	41211
108858	1056	43	302	20	22698
151030	2297	59	660	33	41194
60493	731	40	174	12	32689
19764	285	12	75	2	5752
177559	1872	56	572	21	26757
140281	1181	35	389	28	22527
164249	1725	54	562	35	44810
11796	256	9	79	2	0
10674	98	9	33	0	0
151322	1435	59	487	18	100674
6836	41	3	11	1	0
174712	1930	67	664	21	57786
5118	42	3	6	0	0
40248	528	16	183	4	5444
0	0	0	0	0	0
127628	1121	50	342	29	28470
88837	1305	38	269	26	61849
7131	81	4	27	0	0
9056	262	15	99	4	2179
87957	1099	26	305	19	8019
144470	1290	53	327	22	39644
111408	1248	20	459	22	23494




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time7 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 & 7 seconds \tabularnewline
R Server & 'Herman Ole Andreas Wold' @ wold.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=169477&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]7 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=169477&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=169477&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 time7 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net







Goodness of Fit
Correlation0.8895
R-squared0.7911
RMSE36921.0697

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8895[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7911[/C][/ROW]
[ROW][C]RMSE[/C][C]36921.0697[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=169477&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=169477&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.8895
R-squared0.7911
RMSE36921.0697







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1162687170479.459459459-7792.45945945947
2201906170479.45945945931426.5405405405
3721513813.1666666667-6598.16666666667
4146367170479.459459459-24112.4594594595
5257045320169.857142857-63124.8571428572
6524450320169.857142857204280.142857143
7188294170479.45945945917814.5405405405
8195674170479.45945945925194.5405405405
9177020170479.4594594596540.54054054053
10330194320169.85714285710024.1428571428
11121844170479.459459459-48635.4594594595
12203938209953.793103448-6015.79310344829
13113213170479.459459459-57266.4594594595
14220751320169.857142857-99418.8571428572
15172905138110.7534794.25
16156326138110.7518215.25
17145178170479.459459459-25301.4594594595
1889171138110.75-48939.75
19172624209953.793103448-37329.7931034483
203979067137.25-27347.25
2187927102800.461538462-14873.4615384615
22241285209953.79310344831331.2068965517
23195820170479.45945945925340.5405405405
24146946209953.793103448-63007.7931034483
25159763170479.459459459-10716.4594594595
26207078170479.45945945936598.5405405405
27212394209953.7931034482440.20689655171
28201536138110.7563425.25
29394662320169.85714285774492.1428571428
30217892209953.7931034487938.20689655171
31182286170479.45945945911806.5405405405
32181740170479.45945945911260.5405405405
33137978209953.793103448-71975.7931034483
34255929320169.857142857-64240.8571428572
35236489209953.79310344826535.2068965517
36013813.1666666667-13813.1666666667
37230761209953.79310344820807.2068965517
38132807170479.459459459-37672.4594594595
39157118170479.459459459-13361.4594594595
40253254209953.79310344843300.2068965517
41269329209953.79310344859375.2068965517
42161273170479.459459459-9206.45945945947
43107181102800.4615384624380.53846153847
44195891209953.793103448-14062.7931034483
45139667138110.751556.25
46171101138110.7532990.25
478140767137.2514269.75
48247563209953.79310344837609.2068965517
49239807209953.79310344829853.2068965517
50172743209953.793103448-37210.7931034483
514818813813.166666666734374.8333333333
52169355170479.459459459-1124.45945945947
53325322209953.793103448115368.206896552
54241518209953.79310344831564.2068965517
55195583209953.793103448-14370.7931034483
56159913170479.459459459-10566.4594594595
57220241170479.45945945949761.5405405405
58101694102800.461538462-1106.46153846153
59157258138110.7519147.25
60202536209953.793103448-7417.79310344829
61173505170479.4594594593025.54054054053
62150518209953.793103448-59435.7931034483
63141491138110.753380.25
64125612138110.75-12498.75
65166049138110.7527938.25
66124197138110.75-13913.75
67195043170479.45945945924563.5405405405
68138708209953.793103448-71245.7931034483
69116552102800.46153846213751.5384615385
703197013813.166666666718156.8333333333
71258158320169.857142857-62011.8571428572
72151194138110.7513083.25
73135926138110.75-2184.75
74119629170479.459459459-50850.4594594595
75171518209953.793103448-38435.7931034483
76108949138110.75-29161.75
77183471209953.793103448-26482.7931034483
78159966209953.793103448-49987.7931034483
7993786102800.461538462-9014.46153846153
8084971138110.75-53139.75
8188882102800.461538462-13918.4615384615
82304603209953.79310344894649.2068965517
8375101102800.461538462-27699.4615384615
84145043170479.459459459-25436.4594594595
8595827138110.75-42283.75
86173924170479.4594594593444.54054054053
87241957170479.45945945971477.5405405405
88115367138110.75-22743.75
89118408138110.75-19702.75
90164078170479.459459459-6401.45945945947
91158931170479.459459459-11548.4594594595
92184139209953.793103448-25814.7931034483
93152856138110.7514745.25
94144014138110.755903.25
956253567137.25-4602.25
96245196209953.79310344835242.2068965517
97199841170479.45945945929361.5405405405
981934913813.16666666675535.83333333333
99247280209953.79310344837326.2068965517
100159408209953.793103448-50545.7931034483
1017212867137.254990.75
102104253138110.75-33857.75
103151090138110.7512979.25
104137382138110.75-728.75
1058744867137.2520310.75
1062767613813.166666666713862.8333333333
107165507170479.459459459-4972.45945945947
108132148138110.75-5962.75
109013813.1666666667-13813.1666666667
11095778102800.461538462-7022.46153846153
111109001102800.4615384626200.53846153847
112158833138110.7520722.25
113147690138110.759579.25
1148988767137.2522749.75
115361613813.1666666667-10197.1666666667
116013813.1666666667-13813.1666666667
117199005138110.7560894.25
118160930170479.459459459-9549.45945945947
119177948170479.4594594597468.54054054053
120136061102800.46153846233260.5384615385
1214341067137.25-23727.25
122184277170479.45945945913797.5405405405
123108858102800.4615384626057.53846153847
124151030170479.459459459-19449.4594594595
1256049367137.25-6644.25
1261976413813.16666666675950.83333333333
127177559170479.4594594597079.54054054053
128140281138110.752170.25
129164249170479.459459459-6230.45945945947
1301179613813.1666666667-2017.16666666667
1311067413813.1666666667-3139.16666666667
132151322138110.7513211.25
133683613813.1666666667-6977.16666666667
134174712170479.4594594594232.54054054053
135511813813.1666666667-8695.16666666667
1364024813813.166666666726434.8333333333
137013813.1666666667-13813.1666666667
138127628102800.46153846224827.5384615385
13988837138110.75-49273.75
140713113813.1666666667-6682.16666666667
141905613813.1666666667-4757.16666666667
14287957102800.461538462-14843.4615384615
143144470138110.756359.25
144111408138110.75-26702.75

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 162687 & 170479.459459459 & -7792.45945945947 \tabularnewline
2 & 201906 & 170479.459459459 & 31426.5405405405 \tabularnewline
3 & 7215 & 13813.1666666667 & -6598.16666666667 \tabularnewline
4 & 146367 & 170479.459459459 & -24112.4594594595 \tabularnewline
5 & 257045 & 320169.857142857 & -63124.8571428572 \tabularnewline
6 & 524450 & 320169.857142857 & 204280.142857143 \tabularnewline
7 & 188294 & 170479.459459459 & 17814.5405405405 \tabularnewline
8 & 195674 & 170479.459459459 & 25194.5405405405 \tabularnewline
9 & 177020 & 170479.459459459 & 6540.54054054053 \tabularnewline
10 & 330194 & 320169.857142857 & 10024.1428571428 \tabularnewline
11 & 121844 & 170479.459459459 & -48635.4594594595 \tabularnewline
12 & 203938 & 209953.793103448 & -6015.79310344829 \tabularnewline
13 & 113213 & 170479.459459459 & -57266.4594594595 \tabularnewline
14 & 220751 & 320169.857142857 & -99418.8571428572 \tabularnewline
15 & 172905 & 138110.75 & 34794.25 \tabularnewline
16 & 156326 & 138110.75 & 18215.25 \tabularnewline
17 & 145178 & 170479.459459459 & -25301.4594594595 \tabularnewline
18 & 89171 & 138110.75 & -48939.75 \tabularnewline
19 & 172624 & 209953.793103448 & -37329.7931034483 \tabularnewline
20 & 39790 & 67137.25 & -27347.25 \tabularnewline
21 & 87927 & 102800.461538462 & -14873.4615384615 \tabularnewline
22 & 241285 & 209953.793103448 & 31331.2068965517 \tabularnewline
23 & 195820 & 170479.459459459 & 25340.5405405405 \tabularnewline
24 & 146946 & 209953.793103448 & -63007.7931034483 \tabularnewline
25 & 159763 & 170479.459459459 & -10716.4594594595 \tabularnewline
26 & 207078 & 170479.459459459 & 36598.5405405405 \tabularnewline
27 & 212394 & 209953.793103448 & 2440.20689655171 \tabularnewline
28 & 201536 & 138110.75 & 63425.25 \tabularnewline
29 & 394662 & 320169.857142857 & 74492.1428571428 \tabularnewline
30 & 217892 & 209953.793103448 & 7938.20689655171 \tabularnewline
31 & 182286 & 170479.459459459 & 11806.5405405405 \tabularnewline
32 & 181740 & 170479.459459459 & 11260.5405405405 \tabularnewline
33 & 137978 & 209953.793103448 & -71975.7931034483 \tabularnewline
34 & 255929 & 320169.857142857 & -64240.8571428572 \tabularnewline
35 & 236489 & 209953.793103448 & 26535.2068965517 \tabularnewline
36 & 0 & 13813.1666666667 & -13813.1666666667 \tabularnewline
37 & 230761 & 209953.793103448 & 20807.2068965517 \tabularnewline
38 & 132807 & 170479.459459459 & -37672.4594594595 \tabularnewline
39 & 157118 & 170479.459459459 & -13361.4594594595 \tabularnewline
40 & 253254 & 209953.793103448 & 43300.2068965517 \tabularnewline
41 & 269329 & 209953.793103448 & 59375.2068965517 \tabularnewline
42 & 161273 & 170479.459459459 & -9206.45945945947 \tabularnewline
43 & 107181 & 102800.461538462 & 4380.53846153847 \tabularnewline
44 & 195891 & 209953.793103448 & -14062.7931034483 \tabularnewline
45 & 139667 & 138110.75 & 1556.25 \tabularnewline
46 & 171101 & 138110.75 & 32990.25 \tabularnewline
47 & 81407 & 67137.25 & 14269.75 \tabularnewline
48 & 247563 & 209953.793103448 & 37609.2068965517 \tabularnewline
49 & 239807 & 209953.793103448 & 29853.2068965517 \tabularnewline
50 & 172743 & 209953.793103448 & -37210.7931034483 \tabularnewline
51 & 48188 & 13813.1666666667 & 34374.8333333333 \tabularnewline
52 & 169355 & 170479.459459459 & -1124.45945945947 \tabularnewline
53 & 325322 & 209953.793103448 & 115368.206896552 \tabularnewline
54 & 241518 & 209953.793103448 & 31564.2068965517 \tabularnewline
55 & 195583 & 209953.793103448 & -14370.7931034483 \tabularnewline
56 & 159913 & 170479.459459459 & -10566.4594594595 \tabularnewline
57 & 220241 & 170479.459459459 & 49761.5405405405 \tabularnewline
58 & 101694 & 102800.461538462 & -1106.46153846153 \tabularnewline
59 & 157258 & 138110.75 & 19147.25 \tabularnewline
60 & 202536 & 209953.793103448 & -7417.79310344829 \tabularnewline
61 & 173505 & 170479.459459459 & 3025.54054054053 \tabularnewline
62 & 150518 & 209953.793103448 & -59435.7931034483 \tabularnewline
63 & 141491 & 138110.75 & 3380.25 \tabularnewline
64 & 125612 & 138110.75 & -12498.75 \tabularnewline
65 & 166049 & 138110.75 & 27938.25 \tabularnewline
66 & 124197 & 138110.75 & -13913.75 \tabularnewline
67 & 195043 & 170479.459459459 & 24563.5405405405 \tabularnewline
68 & 138708 & 209953.793103448 & -71245.7931034483 \tabularnewline
69 & 116552 & 102800.461538462 & 13751.5384615385 \tabularnewline
70 & 31970 & 13813.1666666667 & 18156.8333333333 \tabularnewline
71 & 258158 & 320169.857142857 & -62011.8571428572 \tabularnewline
72 & 151194 & 138110.75 & 13083.25 \tabularnewline
73 & 135926 & 138110.75 & -2184.75 \tabularnewline
74 & 119629 & 170479.459459459 & -50850.4594594595 \tabularnewline
75 & 171518 & 209953.793103448 & -38435.7931034483 \tabularnewline
76 & 108949 & 138110.75 & -29161.75 \tabularnewline
77 & 183471 & 209953.793103448 & -26482.7931034483 \tabularnewline
78 & 159966 & 209953.793103448 & -49987.7931034483 \tabularnewline
79 & 93786 & 102800.461538462 & -9014.46153846153 \tabularnewline
80 & 84971 & 138110.75 & -53139.75 \tabularnewline
81 & 88882 & 102800.461538462 & -13918.4615384615 \tabularnewline
82 & 304603 & 209953.793103448 & 94649.2068965517 \tabularnewline
83 & 75101 & 102800.461538462 & -27699.4615384615 \tabularnewline
84 & 145043 & 170479.459459459 & -25436.4594594595 \tabularnewline
85 & 95827 & 138110.75 & -42283.75 \tabularnewline
86 & 173924 & 170479.459459459 & 3444.54054054053 \tabularnewline
87 & 241957 & 170479.459459459 & 71477.5405405405 \tabularnewline
88 & 115367 & 138110.75 & -22743.75 \tabularnewline
89 & 118408 & 138110.75 & -19702.75 \tabularnewline
90 & 164078 & 170479.459459459 & -6401.45945945947 \tabularnewline
91 & 158931 & 170479.459459459 & -11548.4594594595 \tabularnewline
92 & 184139 & 209953.793103448 & -25814.7931034483 \tabularnewline
93 & 152856 & 138110.75 & 14745.25 \tabularnewline
94 & 144014 & 138110.75 & 5903.25 \tabularnewline
95 & 62535 & 67137.25 & -4602.25 \tabularnewline
96 & 245196 & 209953.793103448 & 35242.2068965517 \tabularnewline
97 & 199841 & 170479.459459459 & 29361.5405405405 \tabularnewline
98 & 19349 & 13813.1666666667 & 5535.83333333333 \tabularnewline
99 & 247280 & 209953.793103448 & 37326.2068965517 \tabularnewline
100 & 159408 & 209953.793103448 & -50545.7931034483 \tabularnewline
101 & 72128 & 67137.25 & 4990.75 \tabularnewline
102 & 104253 & 138110.75 & -33857.75 \tabularnewline
103 & 151090 & 138110.75 & 12979.25 \tabularnewline
104 & 137382 & 138110.75 & -728.75 \tabularnewline
105 & 87448 & 67137.25 & 20310.75 \tabularnewline
106 & 27676 & 13813.1666666667 & 13862.8333333333 \tabularnewline
107 & 165507 & 170479.459459459 & -4972.45945945947 \tabularnewline
108 & 132148 & 138110.75 & -5962.75 \tabularnewline
109 & 0 & 13813.1666666667 & -13813.1666666667 \tabularnewline
110 & 95778 & 102800.461538462 & -7022.46153846153 \tabularnewline
111 & 109001 & 102800.461538462 & 6200.53846153847 \tabularnewline
112 & 158833 & 138110.75 & 20722.25 \tabularnewline
113 & 147690 & 138110.75 & 9579.25 \tabularnewline
114 & 89887 & 67137.25 & 22749.75 \tabularnewline
115 & 3616 & 13813.1666666667 & -10197.1666666667 \tabularnewline
116 & 0 & 13813.1666666667 & -13813.1666666667 \tabularnewline
117 & 199005 & 138110.75 & 60894.25 \tabularnewline
118 & 160930 & 170479.459459459 & -9549.45945945947 \tabularnewline
119 & 177948 & 170479.459459459 & 7468.54054054053 \tabularnewline
120 & 136061 & 102800.461538462 & 33260.5384615385 \tabularnewline
121 & 43410 & 67137.25 & -23727.25 \tabularnewline
122 & 184277 & 170479.459459459 & 13797.5405405405 \tabularnewline
123 & 108858 & 102800.461538462 & 6057.53846153847 \tabularnewline
124 & 151030 & 170479.459459459 & -19449.4594594595 \tabularnewline
125 & 60493 & 67137.25 & -6644.25 \tabularnewline
126 & 19764 & 13813.1666666667 & 5950.83333333333 \tabularnewline
127 & 177559 & 170479.459459459 & 7079.54054054053 \tabularnewline
128 & 140281 & 138110.75 & 2170.25 \tabularnewline
129 & 164249 & 170479.459459459 & -6230.45945945947 \tabularnewline
130 & 11796 & 13813.1666666667 & -2017.16666666667 \tabularnewline
131 & 10674 & 13813.1666666667 & -3139.16666666667 \tabularnewline
132 & 151322 & 138110.75 & 13211.25 \tabularnewline
133 & 6836 & 13813.1666666667 & -6977.16666666667 \tabularnewline
134 & 174712 & 170479.459459459 & 4232.54054054053 \tabularnewline
135 & 5118 & 13813.1666666667 & -8695.16666666667 \tabularnewline
136 & 40248 & 13813.1666666667 & 26434.8333333333 \tabularnewline
137 & 0 & 13813.1666666667 & -13813.1666666667 \tabularnewline
138 & 127628 & 102800.461538462 & 24827.5384615385 \tabularnewline
139 & 88837 & 138110.75 & -49273.75 \tabularnewline
140 & 7131 & 13813.1666666667 & -6682.16666666667 \tabularnewline
141 & 9056 & 13813.1666666667 & -4757.16666666667 \tabularnewline
142 & 87957 & 102800.461538462 & -14843.4615384615 \tabularnewline
143 & 144470 & 138110.75 & 6359.25 \tabularnewline
144 & 111408 & 138110.75 & -26702.75 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=169477&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]162687[/C][C]170479.459459459[/C][C]-7792.45945945947[/C][/ROW]
[ROW][C]2[/C][C]201906[/C][C]170479.459459459[/C][C]31426.5405405405[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]13813.1666666667[/C][C]-6598.16666666667[/C][/ROW]
[ROW][C]4[/C][C]146367[/C][C]170479.459459459[/C][C]-24112.4594594595[/C][/ROW]
[ROW][C]5[/C][C]257045[/C][C]320169.857142857[/C][C]-63124.8571428572[/C][/ROW]
[ROW][C]6[/C][C]524450[/C][C]320169.857142857[/C][C]204280.142857143[/C][/ROW]
[ROW][C]7[/C][C]188294[/C][C]170479.459459459[/C][C]17814.5405405405[/C][/ROW]
[ROW][C]8[/C][C]195674[/C][C]170479.459459459[/C][C]25194.5405405405[/C][/ROW]
[ROW][C]9[/C][C]177020[/C][C]170479.459459459[/C][C]6540.54054054053[/C][/ROW]
[ROW][C]10[/C][C]330194[/C][C]320169.857142857[/C][C]10024.1428571428[/C][/ROW]
[ROW][C]11[/C][C]121844[/C][C]170479.459459459[/C][C]-48635.4594594595[/C][/ROW]
[ROW][C]12[/C][C]203938[/C][C]209953.793103448[/C][C]-6015.79310344829[/C][/ROW]
[ROW][C]13[/C][C]113213[/C][C]170479.459459459[/C][C]-57266.4594594595[/C][/ROW]
[ROW][C]14[/C][C]220751[/C][C]320169.857142857[/C][C]-99418.8571428572[/C][/ROW]
[ROW][C]15[/C][C]172905[/C][C]138110.75[/C][C]34794.25[/C][/ROW]
[ROW][C]16[/C][C]156326[/C][C]138110.75[/C][C]18215.25[/C][/ROW]
[ROW][C]17[/C][C]145178[/C][C]170479.459459459[/C][C]-25301.4594594595[/C][/ROW]
[ROW][C]18[/C][C]89171[/C][C]138110.75[/C][C]-48939.75[/C][/ROW]
[ROW][C]19[/C][C]172624[/C][C]209953.793103448[/C][C]-37329.7931034483[/C][/ROW]
[ROW][C]20[/C][C]39790[/C][C]67137.25[/C][C]-27347.25[/C][/ROW]
[ROW][C]21[/C][C]87927[/C][C]102800.461538462[/C][C]-14873.4615384615[/C][/ROW]
[ROW][C]22[/C][C]241285[/C][C]209953.793103448[/C][C]31331.2068965517[/C][/ROW]
[ROW][C]23[/C][C]195820[/C][C]170479.459459459[/C][C]25340.5405405405[/C][/ROW]
[ROW][C]24[/C][C]146946[/C][C]209953.793103448[/C][C]-63007.7931034483[/C][/ROW]
[ROW][C]25[/C][C]159763[/C][C]170479.459459459[/C][C]-10716.4594594595[/C][/ROW]
[ROW][C]26[/C][C]207078[/C][C]170479.459459459[/C][C]36598.5405405405[/C][/ROW]
[ROW][C]27[/C][C]212394[/C][C]209953.793103448[/C][C]2440.20689655171[/C][/ROW]
[ROW][C]28[/C][C]201536[/C][C]138110.75[/C][C]63425.25[/C][/ROW]
[ROW][C]29[/C][C]394662[/C][C]320169.857142857[/C][C]74492.1428571428[/C][/ROW]
[ROW][C]30[/C][C]217892[/C][C]209953.793103448[/C][C]7938.20689655171[/C][/ROW]
[ROW][C]31[/C][C]182286[/C][C]170479.459459459[/C][C]11806.5405405405[/C][/ROW]
[ROW][C]32[/C][C]181740[/C][C]170479.459459459[/C][C]11260.5405405405[/C][/ROW]
[ROW][C]33[/C][C]137978[/C][C]209953.793103448[/C][C]-71975.7931034483[/C][/ROW]
[ROW][C]34[/C][C]255929[/C][C]320169.857142857[/C][C]-64240.8571428572[/C][/ROW]
[ROW][C]35[/C][C]236489[/C][C]209953.793103448[/C][C]26535.2068965517[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]13813.1666666667[/C][C]-13813.1666666667[/C][/ROW]
[ROW][C]37[/C][C]230761[/C][C]209953.793103448[/C][C]20807.2068965517[/C][/ROW]
[ROW][C]38[/C][C]132807[/C][C]170479.459459459[/C][C]-37672.4594594595[/C][/ROW]
[ROW][C]39[/C][C]157118[/C][C]170479.459459459[/C][C]-13361.4594594595[/C][/ROW]
[ROW][C]40[/C][C]253254[/C][C]209953.793103448[/C][C]43300.2068965517[/C][/ROW]
[ROW][C]41[/C][C]269329[/C][C]209953.793103448[/C][C]59375.2068965517[/C][/ROW]
[ROW][C]42[/C][C]161273[/C][C]170479.459459459[/C][C]-9206.45945945947[/C][/ROW]
[ROW][C]43[/C][C]107181[/C][C]102800.461538462[/C][C]4380.53846153847[/C][/ROW]
[ROW][C]44[/C][C]195891[/C][C]209953.793103448[/C][C]-14062.7931034483[/C][/ROW]
[ROW][C]45[/C][C]139667[/C][C]138110.75[/C][C]1556.25[/C][/ROW]
[ROW][C]46[/C][C]171101[/C][C]138110.75[/C][C]32990.25[/C][/ROW]
[ROW][C]47[/C][C]81407[/C][C]67137.25[/C][C]14269.75[/C][/ROW]
[ROW][C]48[/C][C]247563[/C][C]209953.793103448[/C][C]37609.2068965517[/C][/ROW]
[ROW][C]49[/C][C]239807[/C][C]209953.793103448[/C][C]29853.2068965517[/C][/ROW]
[ROW][C]50[/C][C]172743[/C][C]209953.793103448[/C][C]-37210.7931034483[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]13813.1666666667[/C][C]34374.8333333333[/C][/ROW]
[ROW][C]52[/C][C]169355[/C][C]170479.459459459[/C][C]-1124.45945945947[/C][/ROW]
[ROW][C]53[/C][C]325322[/C][C]209953.793103448[/C][C]115368.206896552[/C][/ROW]
[ROW][C]54[/C][C]241518[/C][C]209953.793103448[/C][C]31564.2068965517[/C][/ROW]
[ROW][C]55[/C][C]195583[/C][C]209953.793103448[/C][C]-14370.7931034483[/C][/ROW]
[ROW][C]56[/C][C]159913[/C][C]170479.459459459[/C][C]-10566.4594594595[/C][/ROW]
[ROW][C]57[/C][C]220241[/C][C]170479.459459459[/C][C]49761.5405405405[/C][/ROW]
[ROW][C]58[/C][C]101694[/C][C]102800.461538462[/C][C]-1106.46153846153[/C][/ROW]
[ROW][C]59[/C][C]157258[/C][C]138110.75[/C][C]19147.25[/C][/ROW]
[ROW][C]60[/C][C]202536[/C][C]209953.793103448[/C][C]-7417.79310344829[/C][/ROW]
[ROW][C]61[/C][C]173505[/C][C]170479.459459459[/C][C]3025.54054054053[/C][/ROW]
[ROW][C]62[/C][C]150518[/C][C]209953.793103448[/C][C]-59435.7931034483[/C][/ROW]
[ROW][C]63[/C][C]141491[/C][C]138110.75[/C][C]3380.25[/C][/ROW]
[ROW][C]64[/C][C]125612[/C][C]138110.75[/C][C]-12498.75[/C][/ROW]
[ROW][C]65[/C][C]166049[/C][C]138110.75[/C][C]27938.25[/C][/ROW]
[ROW][C]66[/C][C]124197[/C][C]138110.75[/C][C]-13913.75[/C][/ROW]
[ROW][C]67[/C][C]195043[/C][C]170479.459459459[/C][C]24563.5405405405[/C][/ROW]
[ROW][C]68[/C][C]138708[/C][C]209953.793103448[/C][C]-71245.7931034483[/C][/ROW]
[ROW][C]69[/C][C]116552[/C][C]102800.461538462[/C][C]13751.5384615385[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]13813.1666666667[/C][C]18156.8333333333[/C][/ROW]
[ROW][C]71[/C][C]258158[/C][C]320169.857142857[/C][C]-62011.8571428572[/C][/ROW]
[ROW][C]72[/C][C]151194[/C][C]138110.75[/C][C]13083.25[/C][/ROW]
[ROW][C]73[/C][C]135926[/C][C]138110.75[/C][C]-2184.75[/C][/ROW]
[ROW][C]74[/C][C]119629[/C][C]170479.459459459[/C][C]-50850.4594594595[/C][/ROW]
[ROW][C]75[/C][C]171518[/C][C]209953.793103448[/C][C]-38435.7931034483[/C][/ROW]
[ROW][C]76[/C][C]108949[/C][C]138110.75[/C][C]-29161.75[/C][/ROW]
[ROW][C]77[/C][C]183471[/C][C]209953.793103448[/C][C]-26482.7931034483[/C][/ROW]
[ROW][C]78[/C][C]159966[/C][C]209953.793103448[/C][C]-49987.7931034483[/C][/ROW]
[ROW][C]79[/C][C]93786[/C][C]102800.461538462[/C][C]-9014.46153846153[/C][/ROW]
[ROW][C]80[/C][C]84971[/C][C]138110.75[/C][C]-53139.75[/C][/ROW]
[ROW][C]81[/C][C]88882[/C][C]102800.461538462[/C][C]-13918.4615384615[/C][/ROW]
[ROW][C]82[/C][C]304603[/C][C]209953.793103448[/C][C]94649.2068965517[/C][/ROW]
[ROW][C]83[/C][C]75101[/C][C]102800.461538462[/C][C]-27699.4615384615[/C][/ROW]
[ROW][C]84[/C][C]145043[/C][C]170479.459459459[/C][C]-25436.4594594595[/C][/ROW]
[ROW][C]85[/C][C]95827[/C][C]138110.75[/C][C]-42283.75[/C][/ROW]
[ROW][C]86[/C][C]173924[/C][C]170479.459459459[/C][C]3444.54054054053[/C][/ROW]
[ROW][C]87[/C][C]241957[/C][C]170479.459459459[/C][C]71477.5405405405[/C][/ROW]
[ROW][C]88[/C][C]115367[/C][C]138110.75[/C][C]-22743.75[/C][/ROW]
[ROW][C]89[/C][C]118408[/C][C]138110.75[/C][C]-19702.75[/C][/ROW]
[ROW][C]90[/C][C]164078[/C][C]170479.459459459[/C][C]-6401.45945945947[/C][/ROW]
[ROW][C]91[/C][C]158931[/C][C]170479.459459459[/C][C]-11548.4594594595[/C][/ROW]
[ROW][C]92[/C][C]184139[/C][C]209953.793103448[/C][C]-25814.7931034483[/C][/ROW]
[ROW][C]93[/C][C]152856[/C][C]138110.75[/C][C]14745.25[/C][/ROW]
[ROW][C]94[/C][C]144014[/C][C]138110.75[/C][C]5903.25[/C][/ROW]
[ROW][C]95[/C][C]62535[/C][C]67137.25[/C][C]-4602.25[/C][/ROW]
[ROW][C]96[/C][C]245196[/C][C]209953.793103448[/C][C]35242.2068965517[/C][/ROW]
[ROW][C]97[/C][C]199841[/C][C]170479.459459459[/C][C]29361.5405405405[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]13813.1666666667[/C][C]5535.83333333333[/C][/ROW]
[ROW][C]99[/C][C]247280[/C][C]209953.793103448[/C][C]37326.2068965517[/C][/ROW]
[ROW][C]100[/C][C]159408[/C][C]209953.793103448[/C][C]-50545.7931034483[/C][/ROW]
[ROW][C]101[/C][C]72128[/C][C]67137.25[/C][C]4990.75[/C][/ROW]
[ROW][C]102[/C][C]104253[/C][C]138110.75[/C][C]-33857.75[/C][/ROW]
[ROW][C]103[/C][C]151090[/C][C]138110.75[/C][C]12979.25[/C][/ROW]
[ROW][C]104[/C][C]137382[/C][C]138110.75[/C][C]-728.75[/C][/ROW]
[ROW][C]105[/C][C]87448[/C][C]67137.25[/C][C]20310.75[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]13813.1666666667[/C][C]13862.8333333333[/C][/ROW]
[ROW][C]107[/C][C]165507[/C][C]170479.459459459[/C][C]-4972.45945945947[/C][/ROW]
[ROW][C]108[/C][C]132148[/C][C]138110.75[/C][C]-5962.75[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]13813.1666666667[/C][C]-13813.1666666667[/C][/ROW]
[ROW][C]110[/C][C]95778[/C][C]102800.461538462[/C][C]-7022.46153846153[/C][/ROW]
[ROW][C]111[/C][C]109001[/C][C]102800.461538462[/C][C]6200.53846153847[/C][/ROW]
[ROW][C]112[/C][C]158833[/C][C]138110.75[/C][C]20722.25[/C][/ROW]
[ROW][C]113[/C][C]147690[/C][C]138110.75[/C][C]9579.25[/C][/ROW]
[ROW][C]114[/C][C]89887[/C][C]67137.25[/C][C]22749.75[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]13813.1666666667[/C][C]-10197.1666666667[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]13813.1666666667[/C][C]-13813.1666666667[/C][/ROW]
[ROW][C]117[/C][C]199005[/C][C]138110.75[/C][C]60894.25[/C][/ROW]
[ROW][C]118[/C][C]160930[/C][C]170479.459459459[/C][C]-9549.45945945947[/C][/ROW]
[ROW][C]119[/C][C]177948[/C][C]170479.459459459[/C][C]7468.54054054053[/C][/ROW]
[ROW][C]120[/C][C]136061[/C][C]102800.461538462[/C][C]33260.5384615385[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]67137.25[/C][C]-23727.25[/C][/ROW]
[ROW][C]122[/C][C]184277[/C][C]170479.459459459[/C][C]13797.5405405405[/C][/ROW]
[ROW][C]123[/C][C]108858[/C][C]102800.461538462[/C][C]6057.53846153847[/C][/ROW]
[ROW][C]124[/C][C]151030[/C][C]170479.459459459[/C][C]-19449.4594594595[/C][/ROW]
[ROW][C]125[/C][C]60493[/C][C]67137.25[/C][C]-6644.25[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]13813.1666666667[/C][C]5950.83333333333[/C][/ROW]
[ROW][C]127[/C][C]177559[/C][C]170479.459459459[/C][C]7079.54054054053[/C][/ROW]
[ROW][C]128[/C][C]140281[/C][C]138110.75[/C][C]2170.25[/C][/ROW]
[ROW][C]129[/C][C]164249[/C][C]170479.459459459[/C][C]-6230.45945945947[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]13813.1666666667[/C][C]-2017.16666666667[/C][/ROW]
[ROW][C]131[/C][C]10674[/C][C]13813.1666666667[/C][C]-3139.16666666667[/C][/ROW]
[ROW][C]132[/C][C]151322[/C][C]138110.75[/C][C]13211.25[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]13813.1666666667[/C][C]-6977.16666666667[/C][/ROW]
[ROW][C]134[/C][C]174712[/C][C]170479.459459459[/C][C]4232.54054054053[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]13813.1666666667[/C][C]-8695.16666666667[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]13813.1666666667[/C][C]26434.8333333333[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]13813.1666666667[/C][C]-13813.1666666667[/C][/ROW]
[ROW][C]138[/C][C]127628[/C][C]102800.461538462[/C][C]24827.5384615385[/C][/ROW]
[ROW][C]139[/C][C]88837[/C][C]138110.75[/C][C]-49273.75[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]13813.1666666667[/C][C]-6682.16666666667[/C][/ROW]
[ROW][C]141[/C][C]9056[/C][C]13813.1666666667[/C][C]-4757.16666666667[/C][/ROW]
[ROW][C]142[/C][C]87957[/C][C]102800.461538462[/C][C]-14843.4615384615[/C][/ROW]
[ROW][C]143[/C][C]144470[/C][C]138110.75[/C][C]6359.25[/C][/ROW]
[ROW][C]144[/C][C]111408[/C][C]138110.75[/C][C]-26702.75[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=169477&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=169477&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
1162687170479.459459459-7792.45945945947
2201906170479.45945945931426.5405405405
3721513813.1666666667-6598.16666666667
4146367170479.459459459-24112.4594594595
5257045320169.857142857-63124.8571428572
6524450320169.857142857204280.142857143
7188294170479.45945945917814.5405405405
8195674170479.45945945925194.5405405405
9177020170479.4594594596540.54054054053
10330194320169.85714285710024.1428571428
11121844170479.459459459-48635.4594594595
12203938209953.793103448-6015.79310344829
13113213170479.459459459-57266.4594594595
14220751320169.857142857-99418.8571428572
15172905138110.7534794.25
16156326138110.7518215.25
17145178170479.459459459-25301.4594594595
1889171138110.75-48939.75
19172624209953.793103448-37329.7931034483
203979067137.25-27347.25
2187927102800.461538462-14873.4615384615
22241285209953.79310344831331.2068965517
23195820170479.45945945925340.5405405405
24146946209953.793103448-63007.7931034483
25159763170479.459459459-10716.4594594595
26207078170479.45945945936598.5405405405
27212394209953.7931034482440.20689655171
28201536138110.7563425.25
29394662320169.85714285774492.1428571428
30217892209953.7931034487938.20689655171
31182286170479.45945945911806.5405405405
32181740170479.45945945911260.5405405405
33137978209953.793103448-71975.7931034483
34255929320169.857142857-64240.8571428572
35236489209953.79310344826535.2068965517
36013813.1666666667-13813.1666666667
37230761209953.79310344820807.2068965517
38132807170479.459459459-37672.4594594595
39157118170479.459459459-13361.4594594595
40253254209953.79310344843300.2068965517
41269329209953.79310344859375.2068965517
42161273170479.459459459-9206.45945945947
43107181102800.4615384624380.53846153847
44195891209953.793103448-14062.7931034483
45139667138110.751556.25
46171101138110.7532990.25
478140767137.2514269.75
48247563209953.79310344837609.2068965517
49239807209953.79310344829853.2068965517
50172743209953.793103448-37210.7931034483
514818813813.166666666734374.8333333333
52169355170479.459459459-1124.45945945947
53325322209953.793103448115368.206896552
54241518209953.79310344831564.2068965517
55195583209953.793103448-14370.7931034483
56159913170479.459459459-10566.4594594595
57220241170479.45945945949761.5405405405
58101694102800.461538462-1106.46153846153
59157258138110.7519147.25
60202536209953.793103448-7417.79310344829
61173505170479.4594594593025.54054054053
62150518209953.793103448-59435.7931034483
63141491138110.753380.25
64125612138110.75-12498.75
65166049138110.7527938.25
66124197138110.75-13913.75
67195043170479.45945945924563.5405405405
68138708209953.793103448-71245.7931034483
69116552102800.46153846213751.5384615385
703197013813.166666666718156.8333333333
71258158320169.857142857-62011.8571428572
72151194138110.7513083.25
73135926138110.75-2184.75
74119629170479.459459459-50850.4594594595
75171518209953.793103448-38435.7931034483
76108949138110.75-29161.75
77183471209953.793103448-26482.7931034483
78159966209953.793103448-49987.7931034483
7993786102800.461538462-9014.46153846153
8084971138110.75-53139.75
8188882102800.461538462-13918.4615384615
82304603209953.79310344894649.2068965517
8375101102800.461538462-27699.4615384615
84145043170479.459459459-25436.4594594595
8595827138110.75-42283.75
86173924170479.4594594593444.54054054053
87241957170479.45945945971477.5405405405
88115367138110.75-22743.75
89118408138110.75-19702.75
90164078170479.459459459-6401.45945945947
91158931170479.459459459-11548.4594594595
92184139209953.793103448-25814.7931034483
93152856138110.7514745.25
94144014138110.755903.25
956253567137.25-4602.25
96245196209953.79310344835242.2068965517
97199841170479.45945945929361.5405405405
981934913813.16666666675535.83333333333
99247280209953.79310344837326.2068965517
100159408209953.793103448-50545.7931034483
1017212867137.254990.75
102104253138110.75-33857.75
103151090138110.7512979.25
104137382138110.75-728.75
1058744867137.2520310.75
1062767613813.166666666713862.8333333333
107165507170479.459459459-4972.45945945947
108132148138110.75-5962.75
109013813.1666666667-13813.1666666667
11095778102800.461538462-7022.46153846153
111109001102800.4615384626200.53846153847
112158833138110.7520722.25
113147690138110.759579.25
1148988767137.2522749.75
115361613813.1666666667-10197.1666666667
116013813.1666666667-13813.1666666667
117199005138110.7560894.25
118160930170479.459459459-9549.45945945947
119177948170479.4594594597468.54054054053
120136061102800.46153846233260.5384615385
1214341067137.25-23727.25
122184277170479.45945945913797.5405405405
123108858102800.4615384626057.53846153847
124151030170479.459459459-19449.4594594595
1256049367137.25-6644.25
1261976413813.16666666675950.83333333333
127177559170479.4594594597079.54054054053
128140281138110.752170.25
129164249170479.459459459-6230.45945945947
1301179613813.1666666667-2017.16666666667
1311067413813.1666666667-3139.16666666667
132151322138110.7513211.25
133683613813.1666666667-6977.16666666667
134174712170479.4594594594232.54054054053
135511813813.1666666667-8695.16666666667
1364024813813.166666666726434.8333333333
137013813.1666666667-13813.1666666667
138127628102800.46153846224827.5384615385
13988837138110.75-49273.75
140713113813.1666666667-6682.16666666667
141905613813.1666666667-4757.16666666667
14287957102800.461538462-14843.4615384615
143144470138110.756359.25
144111408138110.75-26702.75



Parameters (Session):
par1 = 1 ; par2 = none ; par3 = 3 ; par4 = no ;
Parameters (R input):
par1 = 1 ; par2 = none ; par3 = 3 ; par4 = no ; par5 = ; par6 = ; par7 = ; par8 = ; par9 = ; par10 = ; par11 = ; par12 = ; par13 = ; par14 = ; par15 = ; par16 = ; par17 = ; par18 = ; par19 = ; par20 = ;
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')
}