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 11:36:26 -0500
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2011/Dec/21/t1324485423zegrz24nfymvot0.htm/, Retrieved Tue, 07 May 2024 20:32:43 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158877, Retrieved Tue, 07 May 2024 20:32:43 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact56
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [PAPERDEEL3] [2011-12-21 16:36:26] [20d72825ced8e4e20cafbe8bf70803f4] [Current]
Feedback Forum

Post a new message
Dataseries X:
159261	1801	91	48	19	20465
189672	1717	59	53	20	33629
7215	192	18	0	0	1423
129098	2295	95	51	27	25629
230632	3450	136	76	31	54002
515038	6861	263	136	36	151036
180745	1795	56	62	23	33287
185559	1681	59	83	30	31172
154581	1897	44	55	30	28113
298001	2974	96	67	26	57803
121844	1946	75	50	24	49830
200907	2330	70	87	30	52143
101647	1839	100	46	22	21055
220269	3183	119	79	28	47007
170952	1486	61	56	18	28735
154647	1567	88	54	22	59147
142018	1756	57	81	33	78950
79030	1247	61	6	15	13497
167047	2779	87	74	34	46154
27997	726	24	13	18	53249
73019	1048	59	22	15	10726
241082	2805	100	99	30	83700
195820	1760	72	38	25	40400
142001	2266	54	59	34	33797
145433	1848	86	50	21	36205
183744	1665	32	50	21	30165
202357	2084	163	61	25	58534
201385	1448	94	90	31	44663
354924	2741	118	60	31	92556
192399	2112	44	52	20	40078
182286	1684	44	61	28	34711
181590	1616	45	60	22	31076
133801	2227	105	53	17	74608
233686	3088	123	76	25	58092
219428	2389	53	63	24	42009
0	1	1	0	0	0
223044	2099	63	54	28	36022
100129	1669	51	44	14	23333
145864	2137	49	42	35	53349
249965	2153	64	83	34	92596
242379	2390	71	105	22	49598
145794	1701	59	37	34	44093
103623	1049	33	25	23	84205
195891	2161	78	64	24	63369
117156	1276	50	55	26	60132
157787	1190	95	41	22	37403
81293	745	32	23	35	24460
243273	2374	103	77	24	46456
233155	2289	89	59	31	66616
160344	2639	59	68	26	41554
48188	658	28	12	22	22346
161922	1917	69	99	21	30874
307432	2557	74	78	27	68701
235223	2026	79	56	30	35728
195583	1911	59	67	33	29010
146061	1716	56	40	11	23110
208834	1852	67	53	26	38844
93764	981	24	26	26	27084
151985	1177	66	67	23	35139
195506	2849	97	36	38	57476
148922	1688	60	50	31	33277
142670	2162	81	51	20	31141
129561	1331	61	46	22	61281
122204	1307	38	57	26	25820
160930	1256	35	27	26	23284
99184	1294	41	38	33	35378
192811	2311	71	72	36	74990
138708	2897	65	93	25	29653
114408	1103	38	59	24	64622
31970	340	15	5	21	4157
225558	2791	112	53	19	29245
139220	1338	72	40	12	50008
113612	1441	68	72	30	52338
119537	1681	72	53	21	13310
162203	2650	67	81	34	92901
100098	1499	44	27	32	10956
174768	2302	60	94	28	34241
158459	2540	97	71	28	75043
80934	1000	30	20	21	21152
84971	1234	71	34	31	42249
80545	927	68	54	26	42005
287191	2176	64	49	29	41152
62974	957	28	26	23	14399
134091	1551	40	48	25	28263
75555	1014	46	35	22	17215
162154	1772	55	32	26	48140
227638	2630	229	55	33	62897
115367	1205	112	58	24	22883
115603	1392	63	44	24	41622
155537	1524	52	45	21	40715
153133	1829	41	49	28	65897
165618	2229	78	72	27	76542
151517	1233	57	39	25	37477
133686	1365	58	28	15	53216
61342	950	40	24	13	40911
245196	2319	117	52	36	57021
195576	1857	70	96	24	73116
19349	223	12	13	1	3895
225371	2390	105	38	24	46609
153213	1985	78	41	31	29351
59117	700	29	24	4	2325
91762	1062	24	54	21	31747
136769	1311	54	68	23	32665
114798	1157	61	28	23	19249
85338	823	40	36	12	15292
27676	596	22	2	16	5842
153535	1545	48	91	29	33994
122417	1130	37	29	26	13018
0	0	0	0	0	0
91529	1082	32	46	25	98177
107205	1135	67	25	21	37941
144664	1367	45	51	23	31032
146445	1506	63	60	21	32683
76656	870	60	36	21	34545
3616	78	5	0	0	0
0	0	0	0	0	0
183088	1130	44	40	23	27525
144677	1582	84	68	33	66856
159104	2034	98	28	30	28549
128944	970	39	41	23	38610
43410	778	19	7	1	2781
175774	1752	73	70	29	41211
95401	957	42	30	18	22698
134837	2098	55	69	33	41194
60493	731	40	3	12	32689
19764	285	12	10	2	5752
164062	1834	56	46	21	26757
132696	1148	33	34	28	22527
155367	1646	54	54	29	44810
11796	256	9	1	2	0
10674	98	9	0	0	0
142261	1404	57	39	18	100674
6836	41	3	0	1	0
162563	1824	63	48	21	57786
5118	42	3	5	0	0
40248	528	16	8	4	5444
0	0	0	0	0	0
122641	1073	47	38	25	28470
88837	1305	38	21	26	61849
7131	81	4	0	0	0
9056	261	14	0	4	2179
76611	934	24	15	17	8019
132697	1180	51	50	21	39644
100681	1148	20	17	22	23494




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158877&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.8583
R-squared0.7368
RMSE39561.5351

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8583[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7368[/C][/ROW]
[ROW][C]RMSE[/C][C]39561.5351[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158877&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158877&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.8583
R-squared0.7368
RMSE39561.5351







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1159261167392.642857143-8131.64285714287
2189672167392.64285714322279.3571428571
372156214.692307692311000.30769230769
4129098167392.642857143-38294.6428571429
5230632256404.636363636-25772.6363636364
6515038256404.636363636258633.363636364
7180745167392.64285714313352.3571428571
8185559167392.64285714318166.3571428571
9154581167392.642857143-12811.6428571429
10298001256404.63636363641596.3636363636
11121844167392.642857143-45548.6428571429
12200907217511.818181818-16604.8181818182
13101647167392.642857143-65745.6428571429
14220269256404.636363636-36135.6363636364
15170952167392.6428571433559.35714285713
16154647167392.642857143-12745.6428571429
17142018167392.642857143-25374.6428571429
1879030125642-46612
19167047256404.636363636-89357.6363636364
202799736422.8571428571-8425.85714285714
217301983464.9473684211-10445.9473684211
22241082256404.636363636-15322.6363636364
23195820167392.64285714328427.3571428571
24142001167392.642857143-25391.6428571429
25145433167392.642857143-21959.6428571429
26183744167392.64285714316351.3571428571
27202357167392.64285714334964.3571428571
28201385167392.64285714333992.3571428571
29354924256404.63636363698519.3636363636
30192399167392.64285714325006.3571428571
31182286167392.64285714314893.3571428571
32181590167392.64285714314197.3571428571
33133801167392.642857143-33591.6428571429
34233686256404.636363636-22718.6363636364
35219428217511.8181818181916.18181818182
3606214.69230769231-6214.69230769231
37223044167392.64285714355651.3571428571
38100129167392.642857143-67263.6428571429
39145864167392.642857143-21528.6428571429
40249965167392.64285714382572.3571428571
41242379217511.81818181824867.1818181818
42145794167392.642857143-21598.6428571429
4310362383464.947368421120158.0526315789
44195891167392.64285714328498.3571428571
45117156125642-8486
4615778712564232145
478129383464.9473684211-2171.94736842105
48243273217511.81818181825761.1818181818
49233155167392.64285714365762.3571428571
50160344217511.818181818-57167.8181818182
514818836422.857142857111765.1428571429
52161922167392.642857143-5470.64285714287
53307432217511.81818181889920.1818181818
54235223167392.64285714367830.3571428571
55195583167392.64285714328190.3571428571
56146061167392.642857143-21331.6428571429
57208834167392.64285714341441.3571428571
589376483464.947368421110299.0526315789
5915198512564226343
60195506256404.636363636-60898.6363636364
61148922167392.642857143-18470.6428571429
62142670167392.642857143-24722.6428571429
631295611256423919
64122204125642-3438
6516093012564235288
6699184125642-26458
67192811167392.64285714325418.3571428571
68138708256404.636363636-117696.636363636
69114408125642-11234
703197036422.8571428571-4452.85714285714
71225558256404.636363636-30846.6363636364
7213922012564213578
73113612125642-12030
74119537167392.642857143-47855.6428571429
75162203217511.818181818-55308.8181818182
76100098167392.642857143-67294.6428571429
77174768167392.6428571437375.35714285713
78158459217511.818181818-59052.8181818182
798093483464.9473684211-2530.94736842105
8084971125642-40671
818054583464.9473684211-2919.94736842105
82287191167392.642857143119798.357142857
836297483464.9473684211-20490.9473684211
84134091167392.642857143-33301.6428571429
857555583464.9473684211-7909.94736842105
86162154167392.642857143-5238.64285714287
87227638217511.81818181810126.1818181818
88115367125642-10275
89115603125642-10039
90155537167392.642857143-11855.6428571429
91153133167392.642857143-14259.6428571429
92165618167392.642857143-1774.64285714287
9315151712564225875
941336861256428044
956134283464.9473684211-22122.9473684211
96245196217511.81818181827684.1818181818
97195576167392.64285714328183.3571428571
98193496214.6923076923113134.3076923077
99225371217511.8181818187859.18181818182
100153213167392.642857143-14179.6428571429
1015911736422.857142857122694.1428571429
1029176283464.94736842118297.05263157895
10313676912564211127
104114798125642-10844
1058533883464.94736842111873.05263157895
1062767636422.8571428571-8746.85714285714
107153535167392.642857143-13857.6428571429
108122417125642-3225
10906214.69230769231-6214.69230769231
1109152983464.94736842118064.05263157895
111107205125642-18437
11214466412564219022
113146445167392.642857143-20947.6428571429
1147665683464.9473684211-6808.94736842105
11536166214.69230769231-2598.69230769231
11606214.69230769231-6214.69230769231
11718308812564257446
118144677167392.642857143-22715.6428571429
119159104167392.642857143-8288.64285714287
12012894483464.947368421145479.0526315789
1214341083464.9473684211-40054.9473684211
122175774167392.6428571438381.35714285713
1239540183464.947368421111936.0526315789
124134837167392.642857143-32555.6428571429
1256049383464.9473684211-22971.9473684211
1261976436422.8571428571-16658.8571428571
127164062167392.642857143-3330.64285714287
1281326961256427054
129155367167392.642857143-12025.6428571429
130117966214.692307692315581.30769230769
131106746214.692307692314459.30769230769
13214226112564216619
13368366214.69230769231621.307692307692
134162563167392.642857143-4829.64285714287
13551186214.69230769231-1096.69230769231
1364024836422.85714285713825.14285714286
13706214.69230769231-6214.69230769231
13812264183464.947368421139176.0526315789
13988837125642-36805
14071316214.69230769231916.307692307692
14190566214.692307692312841.30769230769
1427661183464.9473684211-6853.94736842105
1431326971256427055
144100681125642-24961

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 159261 & 167392.642857143 & -8131.64285714287 \tabularnewline
2 & 189672 & 167392.642857143 & 22279.3571428571 \tabularnewline
3 & 7215 & 6214.69230769231 & 1000.30769230769 \tabularnewline
4 & 129098 & 167392.642857143 & -38294.6428571429 \tabularnewline
5 & 230632 & 256404.636363636 & -25772.6363636364 \tabularnewline
6 & 515038 & 256404.636363636 & 258633.363636364 \tabularnewline
7 & 180745 & 167392.642857143 & 13352.3571428571 \tabularnewline
8 & 185559 & 167392.642857143 & 18166.3571428571 \tabularnewline
9 & 154581 & 167392.642857143 & -12811.6428571429 \tabularnewline
10 & 298001 & 256404.636363636 & 41596.3636363636 \tabularnewline
11 & 121844 & 167392.642857143 & -45548.6428571429 \tabularnewline
12 & 200907 & 217511.818181818 & -16604.8181818182 \tabularnewline
13 & 101647 & 167392.642857143 & -65745.6428571429 \tabularnewline
14 & 220269 & 256404.636363636 & -36135.6363636364 \tabularnewline
15 & 170952 & 167392.642857143 & 3559.35714285713 \tabularnewline
16 & 154647 & 167392.642857143 & -12745.6428571429 \tabularnewline
17 & 142018 & 167392.642857143 & -25374.6428571429 \tabularnewline
18 & 79030 & 125642 & -46612 \tabularnewline
19 & 167047 & 256404.636363636 & -89357.6363636364 \tabularnewline
20 & 27997 & 36422.8571428571 & -8425.85714285714 \tabularnewline
21 & 73019 & 83464.9473684211 & -10445.9473684211 \tabularnewline
22 & 241082 & 256404.636363636 & -15322.6363636364 \tabularnewline
23 & 195820 & 167392.642857143 & 28427.3571428571 \tabularnewline
24 & 142001 & 167392.642857143 & -25391.6428571429 \tabularnewline
25 & 145433 & 167392.642857143 & -21959.6428571429 \tabularnewline
26 & 183744 & 167392.642857143 & 16351.3571428571 \tabularnewline
27 & 202357 & 167392.642857143 & 34964.3571428571 \tabularnewline
28 & 201385 & 167392.642857143 & 33992.3571428571 \tabularnewline
29 & 354924 & 256404.636363636 & 98519.3636363636 \tabularnewline
30 & 192399 & 167392.642857143 & 25006.3571428571 \tabularnewline
31 & 182286 & 167392.642857143 & 14893.3571428571 \tabularnewline
32 & 181590 & 167392.642857143 & 14197.3571428571 \tabularnewline
33 & 133801 & 167392.642857143 & -33591.6428571429 \tabularnewline
34 & 233686 & 256404.636363636 & -22718.6363636364 \tabularnewline
35 & 219428 & 217511.818181818 & 1916.18181818182 \tabularnewline
36 & 0 & 6214.69230769231 & -6214.69230769231 \tabularnewline
37 & 223044 & 167392.642857143 & 55651.3571428571 \tabularnewline
38 & 100129 & 167392.642857143 & -67263.6428571429 \tabularnewline
39 & 145864 & 167392.642857143 & -21528.6428571429 \tabularnewline
40 & 249965 & 167392.642857143 & 82572.3571428571 \tabularnewline
41 & 242379 & 217511.818181818 & 24867.1818181818 \tabularnewline
42 & 145794 & 167392.642857143 & -21598.6428571429 \tabularnewline
43 & 103623 & 83464.9473684211 & 20158.0526315789 \tabularnewline
44 & 195891 & 167392.642857143 & 28498.3571428571 \tabularnewline
45 & 117156 & 125642 & -8486 \tabularnewline
46 & 157787 & 125642 & 32145 \tabularnewline
47 & 81293 & 83464.9473684211 & -2171.94736842105 \tabularnewline
48 & 243273 & 217511.818181818 & 25761.1818181818 \tabularnewline
49 & 233155 & 167392.642857143 & 65762.3571428571 \tabularnewline
50 & 160344 & 217511.818181818 & -57167.8181818182 \tabularnewline
51 & 48188 & 36422.8571428571 & 11765.1428571429 \tabularnewline
52 & 161922 & 167392.642857143 & -5470.64285714287 \tabularnewline
53 & 307432 & 217511.818181818 & 89920.1818181818 \tabularnewline
54 & 235223 & 167392.642857143 & 67830.3571428571 \tabularnewline
55 & 195583 & 167392.642857143 & 28190.3571428571 \tabularnewline
56 & 146061 & 167392.642857143 & -21331.6428571429 \tabularnewline
57 & 208834 & 167392.642857143 & 41441.3571428571 \tabularnewline
58 & 93764 & 83464.9473684211 & 10299.0526315789 \tabularnewline
59 & 151985 & 125642 & 26343 \tabularnewline
60 & 195506 & 256404.636363636 & -60898.6363636364 \tabularnewline
61 & 148922 & 167392.642857143 & -18470.6428571429 \tabularnewline
62 & 142670 & 167392.642857143 & -24722.6428571429 \tabularnewline
63 & 129561 & 125642 & 3919 \tabularnewline
64 & 122204 & 125642 & -3438 \tabularnewline
65 & 160930 & 125642 & 35288 \tabularnewline
66 & 99184 & 125642 & -26458 \tabularnewline
67 & 192811 & 167392.642857143 & 25418.3571428571 \tabularnewline
68 & 138708 & 256404.636363636 & -117696.636363636 \tabularnewline
69 & 114408 & 125642 & -11234 \tabularnewline
70 & 31970 & 36422.8571428571 & -4452.85714285714 \tabularnewline
71 & 225558 & 256404.636363636 & -30846.6363636364 \tabularnewline
72 & 139220 & 125642 & 13578 \tabularnewline
73 & 113612 & 125642 & -12030 \tabularnewline
74 & 119537 & 167392.642857143 & -47855.6428571429 \tabularnewline
75 & 162203 & 217511.818181818 & -55308.8181818182 \tabularnewline
76 & 100098 & 167392.642857143 & -67294.6428571429 \tabularnewline
77 & 174768 & 167392.642857143 & 7375.35714285713 \tabularnewline
78 & 158459 & 217511.818181818 & -59052.8181818182 \tabularnewline
79 & 80934 & 83464.9473684211 & -2530.94736842105 \tabularnewline
80 & 84971 & 125642 & -40671 \tabularnewline
81 & 80545 & 83464.9473684211 & -2919.94736842105 \tabularnewline
82 & 287191 & 167392.642857143 & 119798.357142857 \tabularnewline
83 & 62974 & 83464.9473684211 & -20490.9473684211 \tabularnewline
84 & 134091 & 167392.642857143 & -33301.6428571429 \tabularnewline
85 & 75555 & 83464.9473684211 & -7909.94736842105 \tabularnewline
86 & 162154 & 167392.642857143 & -5238.64285714287 \tabularnewline
87 & 227638 & 217511.818181818 & 10126.1818181818 \tabularnewline
88 & 115367 & 125642 & -10275 \tabularnewline
89 & 115603 & 125642 & -10039 \tabularnewline
90 & 155537 & 167392.642857143 & -11855.6428571429 \tabularnewline
91 & 153133 & 167392.642857143 & -14259.6428571429 \tabularnewline
92 & 165618 & 167392.642857143 & -1774.64285714287 \tabularnewline
93 & 151517 & 125642 & 25875 \tabularnewline
94 & 133686 & 125642 & 8044 \tabularnewline
95 & 61342 & 83464.9473684211 & -22122.9473684211 \tabularnewline
96 & 245196 & 217511.818181818 & 27684.1818181818 \tabularnewline
97 & 195576 & 167392.642857143 & 28183.3571428571 \tabularnewline
98 & 19349 & 6214.69230769231 & 13134.3076923077 \tabularnewline
99 & 225371 & 217511.818181818 & 7859.18181818182 \tabularnewline
100 & 153213 & 167392.642857143 & -14179.6428571429 \tabularnewline
101 & 59117 & 36422.8571428571 & 22694.1428571429 \tabularnewline
102 & 91762 & 83464.9473684211 & 8297.05263157895 \tabularnewline
103 & 136769 & 125642 & 11127 \tabularnewline
104 & 114798 & 125642 & -10844 \tabularnewline
105 & 85338 & 83464.9473684211 & 1873.05263157895 \tabularnewline
106 & 27676 & 36422.8571428571 & -8746.85714285714 \tabularnewline
107 & 153535 & 167392.642857143 & -13857.6428571429 \tabularnewline
108 & 122417 & 125642 & -3225 \tabularnewline
109 & 0 & 6214.69230769231 & -6214.69230769231 \tabularnewline
110 & 91529 & 83464.9473684211 & 8064.05263157895 \tabularnewline
111 & 107205 & 125642 & -18437 \tabularnewline
112 & 144664 & 125642 & 19022 \tabularnewline
113 & 146445 & 167392.642857143 & -20947.6428571429 \tabularnewline
114 & 76656 & 83464.9473684211 & -6808.94736842105 \tabularnewline
115 & 3616 & 6214.69230769231 & -2598.69230769231 \tabularnewline
116 & 0 & 6214.69230769231 & -6214.69230769231 \tabularnewline
117 & 183088 & 125642 & 57446 \tabularnewline
118 & 144677 & 167392.642857143 & -22715.6428571429 \tabularnewline
119 & 159104 & 167392.642857143 & -8288.64285714287 \tabularnewline
120 & 128944 & 83464.9473684211 & 45479.0526315789 \tabularnewline
121 & 43410 & 83464.9473684211 & -40054.9473684211 \tabularnewline
122 & 175774 & 167392.642857143 & 8381.35714285713 \tabularnewline
123 & 95401 & 83464.9473684211 & 11936.0526315789 \tabularnewline
124 & 134837 & 167392.642857143 & -32555.6428571429 \tabularnewline
125 & 60493 & 83464.9473684211 & -22971.9473684211 \tabularnewline
126 & 19764 & 36422.8571428571 & -16658.8571428571 \tabularnewline
127 & 164062 & 167392.642857143 & -3330.64285714287 \tabularnewline
128 & 132696 & 125642 & 7054 \tabularnewline
129 & 155367 & 167392.642857143 & -12025.6428571429 \tabularnewline
130 & 11796 & 6214.69230769231 & 5581.30769230769 \tabularnewline
131 & 10674 & 6214.69230769231 & 4459.30769230769 \tabularnewline
132 & 142261 & 125642 & 16619 \tabularnewline
133 & 6836 & 6214.69230769231 & 621.307692307692 \tabularnewline
134 & 162563 & 167392.642857143 & -4829.64285714287 \tabularnewline
135 & 5118 & 6214.69230769231 & -1096.69230769231 \tabularnewline
136 & 40248 & 36422.8571428571 & 3825.14285714286 \tabularnewline
137 & 0 & 6214.69230769231 & -6214.69230769231 \tabularnewline
138 & 122641 & 83464.9473684211 & 39176.0526315789 \tabularnewline
139 & 88837 & 125642 & -36805 \tabularnewline
140 & 7131 & 6214.69230769231 & 916.307692307692 \tabularnewline
141 & 9056 & 6214.69230769231 & 2841.30769230769 \tabularnewline
142 & 76611 & 83464.9473684211 & -6853.94736842105 \tabularnewline
143 & 132697 & 125642 & 7055 \tabularnewline
144 & 100681 & 125642 & -24961 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158877&T=2

[TABLE]
[ROW][C]Actuals, Predictions, and Residuals[/C][/ROW]
[ROW][C]#[/C][C]Actuals[/C][C]Forecasts[/C][C]Residuals[/C][/ROW]
[ROW][C]1[/C][C]159261[/C][C]167392.642857143[/C][C]-8131.64285714287[/C][/ROW]
[ROW][C]2[/C][C]189672[/C][C]167392.642857143[/C][C]22279.3571428571[/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]167392.642857143[/C][C]-38294.6428571429[/C][/ROW]
[ROW][C]5[/C][C]230632[/C][C]256404.636363636[/C][C]-25772.6363636364[/C][/ROW]
[ROW][C]6[/C][C]515038[/C][C]256404.636363636[/C][C]258633.363636364[/C][/ROW]
[ROW][C]7[/C][C]180745[/C][C]167392.642857143[/C][C]13352.3571428571[/C][/ROW]
[ROW][C]8[/C][C]185559[/C][C]167392.642857143[/C][C]18166.3571428571[/C][/ROW]
[ROW][C]9[/C][C]154581[/C][C]167392.642857143[/C][C]-12811.6428571429[/C][/ROW]
[ROW][C]10[/C][C]298001[/C][C]256404.636363636[/C][C]41596.3636363636[/C][/ROW]
[ROW][C]11[/C][C]121844[/C][C]167392.642857143[/C][C]-45548.6428571429[/C][/ROW]
[ROW][C]12[/C][C]200907[/C][C]217511.818181818[/C][C]-16604.8181818182[/C][/ROW]
[ROW][C]13[/C][C]101647[/C][C]167392.642857143[/C][C]-65745.6428571429[/C][/ROW]
[ROW][C]14[/C][C]220269[/C][C]256404.636363636[/C][C]-36135.6363636364[/C][/ROW]
[ROW][C]15[/C][C]170952[/C][C]167392.642857143[/C][C]3559.35714285713[/C][/ROW]
[ROW][C]16[/C][C]154647[/C][C]167392.642857143[/C][C]-12745.6428571429[/C][/ROW]
[ROW][C]17[/C][C]142018[/C][C]167392.642857143[/C][C]-25374.6428571429[/C][/ROW]
[ROW][C]18[/C][C]79030[/C][C]125642[/C][C]-46612[/C][/ROW]
[ROW][C]19[/C][C]167047[/C][C]256404.636363636[/C][C]-89357.6363636364[/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]83464.9473684211[/C][C]-10445.9473684211[/C][/ROW]
[ROW][C]22[/C][C]241082[/C][C]256404.636363636[/C][C]-15322.6363636364[/C][/ROW]
[ROW][C]23[/C][C]195820[/C][C]167392.642857143[/C][C]28427.3571428571[/C][/ROW]
[ROW][C]24[/C][C]142001[/C][C]167392.642857143[/C][C]-25391.6428571429[/C][/ROW]
[ROW][C]25[/C][C]145433[/C][C]167392.642857143[/C][C]-21959.6428571429[/C][/ROW]
[ROW][C]26[/C][C]183744[/C][C]167392.642857143[/C][C]16351.3571428571[/C][/ROW]
[ROW][C]27[/C][C]202357[/C][C]167392.642857143[/C][C]34964.3571428571[/C][/ROW]
[ROW][C]28[/C][C]201385[/C][C]167392.642857143[/C][C]33992.3571428571[/C][/ROW]
[ROW][C]29[/C][C]354924[/C][C]256404.636363636[/C][C]98519.3636363636[/C][/ROW]
[ROW][C]30[/C][C]192399[/C][C]167392.642857143[/C][C]25006.3571428571[/C][/ROW]
[ROW][C]31[/C][C]182286[/C][C]167392.642857143[/C][C]14893.3571428571[/C][/ROW]
[ROW][C]32[/C][C]181590[/C][C]167392.642857143[/C][C]14197.3571428571[/C][/ROW]
[ROW][C]33[/C][C]133801[/C][C]167392.642857143[/C][C]-33591.6428571429[/C][/ROW]
[ROW][C]34[/C][C]233686[/C][C]256404.636363636[/C][C]-22718.6363636364[/C][/ROW]
[ROW][C]35[/C][C]219428[/C][C]217511.818181818[/C][C]1916.18181818182[/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]167392.642857143[/C][C]55651.3571428571[/C][/ROW]
[ROW][C]38[/C][C]100129[/C][C]167392.642857143[/C][C]-67263.6428571429[/C][/ROW]
[ROW][C]39[/C][C]145864[/C][C]167392.642857143[/C][C]-21528.6428571429[/C][/ROW]
[ROW][C]40[/C][C]249965[/C][C]167392.642857143[/C][C]82572.3571428571[/C][/ROW]
[ROW][C]41[/C][C]242379[/C][C]217511.818181818[/C][C]24867.1818181818[/C][/ROW]
[ROW][C]42[/C][C]145794[/C][C]167392.642857143[/C][C]-21598.6428571429[/C][/ROW]
[ROW][C]43[/C][C]103623[/C][C]83464.9473684211[/C][C]20158.0526315789[/C][/ROW]
[ROW][C]44[/C][C]195891[/C][C]167392.642857143[/C][C]28498.3571428571[/C][/ROW]
[ROW][C]45[/C][C]117156[/C][C]125642[/C][C]-8486[/C][/ROW]
[ROW][C]46[/C][C]157787[/C][C]125642[/C][C]32145[/C][/ROW]
[ROW][C]47[/C][C]81293[/C][C]83464.9473684211[/C][C]-2171.94736842105[/C][/ROW]
[ROW][C]48[/C][C]243273[/C][C]217511.818181818[/C][C]25761.1818181818[/C][/ROW]
[ROW][C]49[/C][C]233155[/C][C]167392.642857143[/C][C]65762.3571428571[/C][/ROW]
[ROW][C]50[/C][C]160344[/C][C]217511.818181818[/C][C]-57167.8181818182[/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]167392.642857143[/C][C]-5470.64285714287[/C][/ROW]
[ROW][C]53[/C][C]307432[/C][C]217511.818181818[/C][C]89920.1818181818[/C][/ROW]
[ROW][C]54[/C][C]235223[/C][C]167392.642857143[/C][C]67830.3571428571[/C][/ROW]
[ROW][C]55[/C][C]195583[/C][C]167392.642857143[/C][C]28190.3571428571[/C][/ROW]
[ROW][C]56[/C][C]146061[/C][C]167392.642857143[/C][C]-21331.6428571429[/C][/ROW]
[ROW][C]57[/C][C]208834[/C][C]167392.642857143[/C][C]41441.3571428571[/C][/ROW]
[ROW][C]58[/C][C]93764[/C][C]83464.9473684211[/C][C]10299.0526315789[/C][/ROW]
[ROW][C]59[/C][C]151985[/C][C]125642[/C][C]26343[/C][/ROW]
[ROW][C]60[/C][C]195506[/C][C]256404.636363636[/C][C]-60898.6363636364[/C][/ROW]
[ROW][C]61[/C][C]148922[/C][C]167392.642857143[/C][C]-18470.6428571429[/C][/ROW]
[ROW][C]62[/C][C]142670[/C][C]167392.642857143[/C][C]-24722.6428571429[/C][/ROW]
[ROW][C]63[/C][C]129561[/C][C]125642[/C][C]3919[/C][/ROW]
[ROW][C]64[/C][C]122204[/C][C]125642[/C][C]-3438[/C][/ROW]
[ROW][C]65[/C][C]160930[/C][C]125642[/C][C]35288[/C][/ROW]
[ROW][C]66[/C][C]99184[/C][C]125642[/C][C]-26458[/C][/ROW]
[ROW][C]67[/C][C]192811[/C][C]167392.642857143[/C][C]25418.3571428571[/C][/ROW]
[ROW][C]68[/C][C]138708[/C][C]256404.636363636[/C][C]-117696.636363636[/C][/ROW]
[ROW][C]69[/C][C]114408[/C][C]125642[/C][C]-11234[/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]256404.636363636[/C][C]-30846.6363636364[/C][/ROW]
[ROW][C]72[/C][C]139220[/C][C]125642[/C][C]13578[/C][/ROW]
[ROW][C]73[/C][C]113612[/C][C]125642[/C][C]-12030[/C][/ROW]
[ROW][C]74[/C][C]119537[/C][C]167392.642857143[/C][C]-47855.6428571429[/C][/ROW]
[ROW][C]75[/C][C]162203[/C][C]217511.818181818[/C][C]-55308.8181818182[/C][/ROW]
[ROW][C]76[/C][C]100098[/C][C]167392.642857143[/C][C]-67294.6428571429[/C][/ROW]
[ROW][C]77[/C][C]174768[/C][C]167392.642857143[/C][C]7375.35714285713[/C][/ROW]
[ROW][C]78[/C][C]158459[/C][C]217511.818181818[/C][C]-59052.8181818182[/C][/ROW]
[ROW][C]79[/C][C]80934[/C][C]83464.9473684211[/C][C]-2530.94736842105[/C][/ROW]
[ROW][C]80[/C][C]84971[/C][C]125642[/C][C]-40671[/C][/ROW]
[ROW][C]81[/C][C]80545[/C][C]83464.9473684211[/C][C]-2919.94736842105[/C][/ROW]
[ROW][C]82[/C][C]287191[/C][C]167392.642857143[/C][C]119798.357142857[/C][/ROW]
[ROW][C]83[/C][C]62974[/C][C]83464.9473684211[/C][C]-20490.9473684211[/C][/ROW]
[ROW][C]84[/C][C]134091[/C][C]167392.642857143[/C][C]-33301.6428571429[/C][/ROW]
[ROW][C]85[/C][C]75555[/C][C]83464.9473684211[/C][C]-7909.94736842105[/C][/ROW]
[ROW][C]86[/C][C]162154[/C][C]167392.642857143[/C][C]-5238.64285714287[/C][/ROW]
[ROW][C]87[/C][C]227638[/C][C]217511.818181818[/C][C]10126.1818181818[/C][/ROW]
[ROW][C]88[/C][C]115367[/C][C]125642[/C][C]-10275[/C][/ROW]
[ROW][C]89[/C][C]115603[/C][C]125642[/C][C]-10039[/C][/ROW]
[ROW][C]90[/C][C]155537[/C][C]167392.642857143[/C][C]-11855.6428571429[/C][/ROW]
[ROW][C]91[/C][C]153133[/C][C]167392.642857143[/C][C]-14259.6428571429[/C][/ROW]
[ROW][C]92[/C][C]165618[/C][C]167392.642857143[/C][C]-1774.64285714287[/C][/ROW]
[ROW][C]93[/C][C]151517[/C][C]125642[/C][C]25875[/C][/ROW]
[ROW][C]94[/C][C]133686[/C][C]125642[/C][C]8044[/C][/ROW]
[ROW][C]95[/C][C]61342[/C][C]83464.9473684211[/C][C]-22122.9473684211[/C][/ROW]
[ROW][C]96[/C][C]245196[/C][C]217511.818181818[/C][C]27684.1818181818[/C][/ROW]
[ROW][C]97[/C][C]195576[/C][C]167392.642857143[/C][C]28183.3571428571[/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]217511.818181818[/C][C]7859.18181818182[/C][/ROW]
[ROW][C]100[/C][C]153213[/C][C]167392.642857143[/C][C]-14179.6428571429[/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]83464.9473684211[/C][C]8297.05263157895[/C][/ROW]
[ROW][C]103[/C][C]136769[/C][C]125642[/C][C]11127[/C][/ROW]
[ROW][C]104[/C][C]114798[/C][C]125642[/C][C]-10844[/C][/ROW]
[ROW][C]105[/C][C]85338[/C][C]83464.9473684211[/C][C]1873.05263157895[/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]167392.642857143[/C][C]-13857.6428571429[/C][/ROW]
[ROW][C]108[/C][C]122417[/C][C]125642[/C][C]-3225[/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]83464.9473684211[/C][C]8064.05263157895[/C][/ROW]
[ROW][C]111[/C][C]107205[/C][C]125642[/C][C]-18437[/C][/ROW]
[ROW][C]112[/C][C]144664[/C][C]125642[/C][C]19022[/C][/ROW]
[ROW][C]113[/C][C]146445[/C][C]167392.642857143[/C][C]-20947.6428571429[/C][/ROW]
[ROW][C]114[/C][C]76656[/C][C]83464.9473684211[/C][C]-6808.94736842105[/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]183088[/C][C]125642[/C][C]57446[/C][/ROW]
[ROW][C]118[/C][C]144677[/C][C]167392.642857143[/C][C]-22715.6428571429[/C][/ROW]
[ROW][C]119[/C][C]159104[/C][C]167392.642857143[/C][C]-8288.64285714287[/C][/ROW]
[ROW][C]120[/C][C]128944[/C][C]83464.9473684211[/C][C]45479.0526315789[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]83464.9473684211[/C][C]-40054.9473684211[/C][/ROW]
[ROW][C]122[/C][C]175774[/C][C]167392.642857143[/C][C]8381.35714285713[/C][/ROW]
[ROW][C]123[/C][C]95401[/C][C]83464.9473684211[/C][C]11936.0526315789[/C][/ROW]
[ROW][C]124[/C][C]134837[/C][C]167392.642857143[/C][C]-32555.6428571429[/C][/ROW]
[ROW][C]125[/C][C]60493[/C][C]83464.9473684211[/C][C]-22971.9473684211[/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]167392.642857143[/C][C]-3330.64285714287[/C][/ROW]
[ROW][C]128[/C][C]132696[/C][C]125642[/C][C]7054[/C][/ROW]
[ROW][C]129[/C][C]155367[/C][C]167392.642857143[/C][C]-12025.6428571429[/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]125642[/C][C]16619[/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]167392.642857143[/C][C]-4829.64285714287[/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]83464.9473684211[/C][C]39176.0526315789[/C][/ROW]
[ROW][C]139[/C][C]88837[/C][C]125642[/C][C]-36805[/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]83464.9473684211[/C][C]-6853.94736842105[/C][/ROW]
[ROW][C]143[/C][C]132697[/C][C]125642[/C][C]7055[/C][/ROW]
[ROW][C]144[/C][C]100681[/C][C]125642[/C][C]-24961[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158877&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158877&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
1159261167392.642857143-8131.64285714287
2189672167392.64285714322279.3571428571
372156214.692307692311000.30769230769
4129098167392.642857143-38294.6428571429
5230632256404.636363636-25772.6363636364
6515038256404.636363636258633.363636364
7180745167392.64285714313352.3571428571
8185559167392.64285714318166.3571428571
9154581167392.642857143-12811.6428571429
10298001256404.63636363641596.3636363636
11121844167392.642857143-45548.6428571429
12200907217511.818181818-16604.8181818182
13101647167392.642857143-65745.6428571429
14220269256404.636363636-36135.6363636364
15170952167392.6428571433559.35714285713
16154647167392.642857143-12745.6428571429
17142018167392.642857143-25374.6428571429
1879030125642-46612
19167047256404.636363636-89357.6363636364
202799736422.8571428571-8425.85714285714
217301983464.9473684211-10445.9473684211
22241082256404.636363636-15322.6363636364
23195820167392.64285714328427.3571428571
24142001167392.642857143-25391.6428571429
25145433167392.642857143-21959.6428571429
26183744167392.64285714316351.3571428571
27202357167392.64285714334964.3571428571
28201385167392.64285714333992.3571428571
29354924256404.63636363698519.3636363636
30192399167392.64285714325006.3571428571
31182286167392.64285714314893.3571428571
32181590167392.64285714314197.3571428571
33133801167392.642857143-33591.6428571429
34233686256404.636363636-22718.6363636364
35219428217511.8181818181916.18181818182
3606214.69230769231-6214.69230769231
37223044167392.64285714355651.3571428571
38100129167392.642857143-67263.6428571429
39145864167392.642857143-21528.6428571429
40249965167392.64285714382572.3571428571
41242379217511.81818181824867.1818181818
42145794167392.642857143-21598.6428571429
4310362383464.947368421120158.0526315789
44195891167392.64285714328498.3571428571
45117156125642-8486
4615778712564232145
478129383464.9473684211-2171.94736842105
48243273217511.81818181825761.1818181818
49233155167392.64285714365762.3571428571
50160344217511.818181818-57167.8181818182
514818836422.857142857111765.1428571429
52161922167392.642857143-5470.64285714287
53307432217511.81818181889920.1818181818
54235223167392.64285714367830.3571428571
55195583167392.64285714328190.3571428571
56146061167392.642857143-21331.6428571429
57208834167392.64285714341441.3571428571
589376483464.947368421110299.0526315789
5915198512564226343
60195506256404.636363636-60898.6363636364
61148922167392.642857143-18470.6428571429
62142670167392.642857143-24722.6428571429
631295611256423919
64122204125642-3438
6516093012564235288
6699184125642-26458
67192811167392.64285714325418.3571428571
68138708256404.636363636-117696.636363636
69114408125642-11234
703197036422.8571428571-4452.85714285714
71225558256404.636363636-30846.6363636364
7213922012564213578
73113612125642-12030
74119537167392.642857143-47855.6428571429
75162203217511.818181818-55308.8181818182
76100098167392.642857143-67294.6428571429
77174768167392.6428571437375.35714285713
78158459217511.818181818-59052.8181818182
798093483464.9473684211-2530.94736842105
8084971125642-40671
818054583464.9473684211-2919.94736842105
82287191167392.642857143119798.357142857
836297483464.9473684211-20490.9473684211
84134091167392.642857143-33301.6428571429
857555583464.9473684211-7909.94736842105
86162154167392.642857143-5238.64285714287
87227638217511.81818181810126.1818181818
88115367125642-10275
89115603125642-10039
90155537167392.642857143-11855.6428571429
91153133167392.642857143-14259.6428571429
92165618167392.642857143-1774.64285714287
9315151712564225875
941336861256428044
956134283464.9473684211-22122.9473684211
96245196217511.81818181827684.1818181818
97195576167392.64285714328183.3571428571
98193496214.6923076923113134.3076923077
99225371217511.8181818187859.18181818182
100153213167392.642857143-14179.6428571429
1015911736422.857142857122694.1428571429
1029176283464.94736842118297.05263157895
10313676912564211127
104114798125642-10844
1058533883464.94736842111873.05263157895
1062767636422.8571428571-8746.85714285714
107153535167392.642857143-13857.6428571429
108122417125642-3225
10906214.69230769231-6214.69230769231
1109152983464.94736842118064.05263157895
111107205125642-18437
11214466412564219022
113146445167392.642857143-20947.6428571429
1147665683464.9473684211-6808.94736842105
11536166214.69230769231-2598.69230769231
11606214.69230769231-6214.69230769231
11718308812564257446
118144677167392.642857143-22715.6428571429
119159104167392.642857143-8288.64285714287
12012894483464.947368421145479.0526315789
1214341083464.9473684211-40054.9473684211
122175774167392.6428571438381.35714285713
1239540183464.947368421111936.0526315789
124134837167392.642857143-32555.6428571429
1256049383464.9473684211-22971.9473684211
1261976436422.8571428571-16658.8571428571
127164062167392.642857143-3330.64285714287
1281326961256427054
129155367167392.642857143-12025.6428571429
130117966214.692307692315581.30769230769
131106746214.692307692314459.30769230769
13214226112564216619
13368366214.69230769231621.307692307692
134162563167392.642857143-4829.64285714287
13551186214.69230769231-1096.69230769231
1364024836422.85714285713825.14285714286
13706214.69230769231-6214.69230769231
13812264183464.947368421139176.0526315789
13988837125642-36805
14071316214.69230769231916.307692307692
14190566214.692307692312841.30769230769
1427661183464.9473684211-6853.94736842105
1431326971256427055
144100681125642-24961



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