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:52:50 -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/t13244792193ltgo0x8resp2ve.htm/, Retrieved Tue, 07 May 2024 11:29:02 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158784, Retrieved Tue, 07 May 2024 11:29:02 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact55
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [recursive paritio...] [2011-12-21 14:52:50] [2d8eb933f626a8d2aaa7a56374bb41d5] [Current]
Feedback Forum

Post a new message
Dataseries X:
159261	0	48	19	20465	23975
189672	1	53	20	33629	85634
7215	0	0	0	1423	1929
129098	0	51	27	25629	36294
230632	0	76	31	54002	72255
515038	1	136	36	151036	189748
180745	1	62	23	33287	61834
185559	0	83	30	31172	68167
154581	0	55	30	28113	38462
298001	1	67	26	57803	101219
121844	2	50	24	49830	43270
184039	0	77	30	52143	76183
100324	0	46	22	21055	31476
217742	4	79	28	47007	62157
168265	4	56	18	28735	46261
154647	3	54	22	59147	50063
142018	0	81	33	78950	64483
79030	5	6	15	13497	2341
167047	0	74	34	46154	48149
27997	0	13	18	53249	12743
73019	0	22	15	10726	18743
241082	0	99	30	83700	97057
195820	0	38	25	40400	17675
142001	1	59	34	33797	33106
145433	1	50	21	36205	53311
183744	0	50	21	30165	42754
202232	0	61	25	58534	59056
199532	0	87	31	44663	101621
354924	0	60	31	92556	118120
192399	0	52	20	40078	79572
182286	0	61	28	34711	42744
181590	2	60	22	31076	65931
133801	4	53	17	74608	38575
233686	0	76	25	58092	28795
219428	1	63	24	42009	94440
0	0	0	0	0	0
223044	0	54	28	36022	38229
100129	3	44	14	23333	31972
136733	9	36	35	53349	40071
249965	0	83	34	92596	132480
242379	2	105	22	49598	62797
145794	0	37	34	44093	40429
96404	2	25	23	84205	45545
195891	1	64	24	63369	57568
117156	2	55	26	60132	39019
157787	2	41	22	37403	53866
81293	1	23	35	24460	38345
237435	0	75	24	46456	50210
233155	1	59	31	66616	80947
160344	8	68	26	41554	43461
48188	0	12	22	22346	14812
161922	0	99	21	30874	37819
307432	0	78	27	68701	102738
235223	0	56	30	35728	54509
195583	1	67	33	29010	62956
146061	8	40	11	23110	55411
208834	0	53	26	38844	50611
93764	1	26	26	27084	26692
151985	0	67	23	35139	60056
190545	10	36	38	57476	25155
148922	6	50	31	33277	42840
132856	0	48	20	31141	39358
129561	11	46	22	61281	47241
112718	3	53	26	25820	49611
160930	0	27	26	23284	41833
99184	0	38	33	35378	48930
192535	8	71	36	74990	110600
138708	2	93	25	29653	52235
114408	0	59	24	64622	53986
31970	0	5	21	4157	4105
225558	3	53	19	29245	59331
137011	1	40	12	50008	47796
113612	2	72	30	52338	38302
108641	1	51	21	13310	14063
162203	0	81	34	92901	54414
100098	2	27	32	10956	9903
174768	1	94	28	34241	53987
158459	0	71	28	75043	88937
80934	0	20	21	21152	21928
84971	0	34	31	42249	29487
80545	0	54	26	42005	35334
287191	0	49	29	41152	57596
62974	1	26	23	14399	29750
134091	0	48	25	28263	41029
75555	0	35	22	17215	12416
162154	0	32	26	48140	51158
226638	0	55	33	62897	79935
115019	0	58	24	22883	26552
108749	7	44	24	41622	25807
155537	0	45	21	40715	50620
153133	5	49	28	65897	61467
165618	1	72	27	76542	65292
151517	0	39	25	37477	55516
133686	0	28	15	53216	42006
61342	0	24	13	40911	26273
245196	0	52	36	57021	90248
195576	0	96	24	73116	61476
19349	0	13	1	3895	9604
225371	3	38	24	46609	45108
152796	0	41	31	29351	47232
59117	0	24	4	2325	3439
91762	0	54	21	31747	30553
136769	0	68	23	32665	24751
114798	1	28	23	19249	34458
85338	1	36	12	15292	24649
27676	0	2	16	5842	2342
153535	0	91	29	33994	52739
122417	0	29	26	13018	6245
0	0	0	0	0	0
91529	0	46	25	98177	35381
107205	0	25	21	37941	19595
144664	0	51	23	31032	50848
136540	0	59	21	32683	39443
76656	0	36	21	34545	27023
3616	0	0	0	0	0
0	0	0	0	0	0
183065	0	40	23	27525	61022
144677	0	68	33	66856	63528
159104	2	28	30	28549	34835
113273	0	36	23	38610	37172
43410	0	7	1	2781	13
175774	1	70	29	41211	62548
95401	0	30	18	22698	31334
134837	8	69	33	41194	20839
60493	3	3	12	32689	5084
19764	1	10	2	5752	9927
164062	3	46	21	26757	53229
132696	0	34	28	22527	29877
155367	0	54	29	44810	37310
11796	0	1	2	0	0
10674	0	0	0	0	0
142261	0	39	18	100674	50067
6836	0	0	1	0	0
162563	6	48	21	57786	47708
5118	0	5	0	0	0
40248	1	8	4	5444	6012
0	0	0	0	0	0
122641	0	38	25	28470	27749
88837	0	21	26	61849	47555
7131	1	0	0	0	0
9056	0	0	4	2179	1336
76611	1	15	17	8019	11017
132697	0	50	21	39644	55184
100681	1	17	22	23494	43485




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158784&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.8609
R-squared0.7411
RMSE39179.9942

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8609[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7411[/C][/ROW]
[ROW][C]RMSE[/C][C]39179.9942[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158784&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158784&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.8609
R-squared0.7411
RMSE39179.9942







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1159261144628.94366197214632.0563380282
2189672198107.714285714-8435.71428571429
3721512105.4-4890.4
4129098144628.943661972-15530.9436619718
5230632198107.71428571432524.2857142857
6515038302489.571428571212548.428571429
7180745198107.714285714-17362.7142857143
8185559198107.714285714-12548.7142857143
9154581144628.9436619729952.05633802817
10298001302489.571428571-4488.57142857142
11121844144628.943661972-22784.9436619718
12184039198107.714285714-14068.7142857143
13100324144628.943661972-44304.9436619718
14217742198107.71428571419634.2857142857
15168265144628.94366197223636.0563380282
16154647144628.94366197210018.0563380282
17142018198107.714285714-56089.7142857143
187903063109.615384615415920.3846153846
19167047144628.94366197222418.0563380282
202799763109.6153846154-35112.6153846154
217301984645.3-11626.3
22241082198107.71428571442974.2857142857
23195820144628.94366197251191.0563380282
24142001144628.943661972-2627.94366197183
25145433144628.943661972804.056338028167
26183744144628.94366197239115.0563380282
27202232198107.7142857144124.28571428571
28199532302489.571428571-102957.571428571
29354924302489.57142857152434.4285714286
30192399198107.714285714-5708.71428571429
31182286144628.94366197237657.0563380282
32181590198107.714285714-16517.7142857143
33133801144628.943661972-10827.9436619718
34233686144628.94366197289057.0563380282
35219428198107.71428571421320.2857142857
36012105.4-12105.4
37223044144628.94366197278415.0563380282
38100129144628.943661972-44499.9436619718
39136733144628.943661972-7895.94366197183
40249965302489.571428571-52524.5714285714
41242379198107.71428571444271.2857142857
42145794144628.9436619721165.05633802817
439640484645.311758.7
44195891198107.714285714-2216.71428571429
45117156144628.943661972-27472.9436619718
46157787144628.94366197213158.0563380282
478129384645.3-3352.3
48237435144628.94366197292806.0563380282
49233155198107.71428571435047.2857142857
50160344144628.94366197215715.0563380282
514818863109.6153846154-14921.6153846154
52161922144628.94366197217293.0563380282
53307432302489.5714285714942.42857142858
54235223144628.94366197290594.0563380282
55195583198107.714285714-2524.71428571429
56146061144628.9436619721432.05633802817
57208834144628.94366197264205.0563380282
589376484645.39118.7
59151985198107.714285714-46122.7142857143
60190545144628.94366197245916.0563380282
61148922144628.9436619724293.05633802817
62132856144628.943661972-11772.9436619718
63129561144628.943661972-15067.9436619718
64112718144628.943661972-31910.9436619718
65160930144628.94366197216301.0563380282
6699184144628.943661972-45444.9436619718
67192535302489.571428571-109954.571428571
68138708144628.943661972-5920.94366197183
69114408144628.943661972-30220.9436619718
703197012105.419864.6
71225558198107.71428571427450.2857142857
72137011144628.943661972-7617.94366197183
73113612144628.943661972-31016.9436619718
7410864163109.615384615445531.3846153846
75162203144628.94366197217574.0563380282
7610009863109.615384615436988.3846153846
77174768144628.94366197230139.0563380282
78158459198107.714285714-39648.7142857143
798093484645.3-3711.3
8084971144628.943661972-59657.9436619718
8180545144628.943661972-64083.9436619718
82287191198107.71428571489083.2857142857
836297484645.3-21671.3
84134091144628.943661972-10537.9436619718
857555563109.615384615412445.3846153846
86162154144628.94366197217525.0563380282
87226638198107.71428571428530.2857142857
88115019144628.943661972-29609.9436619718
89108749144628.943661972-35879.9436619718
90155537144628.94366197210908.0563380282
91153133198107.714285714-44974.7142857143
92165618198107.714285714-32489.7142857143
93151517144628.9436619726888.05633802817
94133686144628.943661972-10942.9436619718
956134284645.3-23303.3
96245196198107.71428571447088.2857142857
97195576198107.714285714-2531.71428571429
981934963109.6153846154-43760.6153846154
99225371144628.94366197280742.0563380282
100152796144628.9436619728167.05633802817
1015911763109.6153846154-3992.61538461538
10291762144628.943661972-52866.9436619718
103136769144628.943661972-7859.94366197183
104114798144628.943661972-29830.9436619718
10585338144628.943661972-59290.9436619718
1062767612105.415570.6
107153535144628.9436619728906.05633802817
10812241763109.615384615459307.3846153846
109012105.4-12105.4
11091529144628.943661972-53099.9436619718
11110720584645.322559.7
112144664144628.94366197235.0563380281674
113136540144628.943661972-8088.94366197183
11476656144628.943661972-67972.9436619718
115361612105.4-8489.4
116012105.4-12105.4
117183065198107.714285714-15042.7142857143
118144677198107.714285714-53430.7142857143
119159104144628.94366197214475.0563380282
120113273144628.943661972-31355.9436619718
1214341063109.6153846154-19699.6153846154
122175774198107.714285714-22333.7142857143
12395401144628.943661972-49227.9436619718
124134837144628.943661972-9791.94366197183
1256049312105.448387.6
1261976463109.6153846154-43345.6153846154
127164062144628.94366197219433.0563380282
128132696144628.943661972-11932.9436619718
129155367144628.94366197210738.0563380282
1301179612105.4-309.4
1311067412105.4-1431.4
132142261144628.943661972-2367.94366197183
133683612105.4-5269.4
134162563144628.94366197217934.0563380282
135511812105.4-6987.4
1364024863109.6153846154-22861.6153846154
137012105.4-12105.4
138122641144628.943661972-21987.9436619718
1398883784645.34191.7
140713112105.4-4974.4
141905612105.4-3049.4
1427661163109.615384615413501.3846153846
143132697144628.943661972-11931.9436619718
14410068184645.316035.7

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 159261 & 144628.943661972 & 14632.0563380282 \tabularnewline
2 & 189672 & 198107.714285714 & -8435.71428571429 \tabularnewline
3 & 7215 & 12105.4 & -4890.4 \tabularnewline
4 & 129098 & 144628.943661972 & -15530.9436619718 \tabularnewline
5 & 230632 & 198107.714285714 & 32524.2857142857 \tabularnewline
6 & 515038 & 302489.571428571 & 212548.428571429 \tabularnewline
7 & 180745 & 198107.714285714 & -17362.7142857143 \tabularnewline
8 & 185559 & 198107.714285714 & -12548.7142857143 \tabularnewline
9 & 154581 & 144628.943661972 & 9952.05633802817 \tabularnewline
10 & 298001 & 302489.571428571 & -4488.57142857142 \tabularnewline
11 & 121844 & 144628.943661972 & -22784.9436619718 \tabularnewline
12 & 184039 & 198107.714285714 & -14068.7142857143 \tabularnewline
13 & 100324 & 144628.943661972 & -44304.9436619718 \tabularnewline
14 & 217742 & 198107.714285714 & 19634.2857142857 \tabularnewline
15 & 168265 & 144628.943661972 & 23636.0563380282 \tabularnewline
16 & 154647 & 144628.943661972 & 10018.0563380282 \tabularnewline
17 & 142018 & 198107.714285714 & -56089.7142857143 \tabularnewline
18 & 79030 & 63109.6153846154 & 15920.3846153846 \tabularnewline
19 & 167047 & 144628.943661972 & 22418.0563380282 \tabularnewline
20 & 27997 & 63109.6153846154 & -35112.6153846154 \tabularnewline
21 & 73019 & 84645.3 & -11626.3 \tabularnewline
22 & 241082 & 198107.714285714 & 42974.2857142857 \tabularnewline
23 & 195820 & 144628.943661972 & 51191.0563380282 \tabularnewline
24 & 142001 & 144628.943661972 & -2627.94366197183 \tabularnewline
25 & 145433 & 144628.943661972 & 804.056338028167 \tabularnewline
26 & 183744 & 144628.943661972 & 39115.0563380282 \tabularnewline
27 & 202232 & 198107.714285714 & 4124.28571428571 \tabularnewline
28 & 199532 & 302489.571428571 & -102957.571428571 \tabularnewline
29 & 354924 & 302489.571428571 & 52434.4285714286 \tabularnewline
30 & 192399 & 198107.714285714 & -5708.71428571429 \tabularnewline
31 & 182286 & 144628.943661972 & 37657.0563380282 \tabularnewline
32 & 181590 & 198107.714285714 & -16517.7142857143 \tabularnewline
33 & 133801 & 144628.943661972 & -10827.9436619718 \tabularnewline
34 & 233686 & 144628.943661972 & 89057.0563380282 \tabularnewline
35 & 219428 & 198107.714285714 & 21320.2857142857 \tabularnewline
36 & 0 & 12105.4 & -12105.4 \tabularnewline
37 & 223044 & 144628.943661972 & 78415.0563380282 \tabularnewline
38 & 100129 & 144628.943661972 & -44499.9436619718 \tabularnewline
39 & 136733 & 144628.943661972 & -7895.94366197183 \tabularnewline
40 & 249965 & 302489.571428571 & -52524.5714285714 \tabularnewline
41 & 242379 & 198107.714285714 & 44271.2857142857 \tabularnewline
42 & 145794 & 144628.943661972 & 1165.05633802817 \tabularnewline
43 & 96404 & 84645.3 & 11758.7 \tabularnewline
44 & 195891 & 198107.714285714 & -2216.71428571429 \tabularnewline
45 & 117156 & 144628.943661972 & -27472.9436619718 \tabularnewline
46 & 157787 & 144628.943661972 & 13158.0563380282 \tabularnewline
47 & 81293 & 84645.3 & -3352.3 \tabularnewline
48 & 237435 & 144628.943661972 & 92806.0563380282 \tabularnewline
49 & 233155 & 198107.714285714 & 35047.2857142857 \tabularnewline
50 & 160344 & 144628.943661972 & 15715.0563380282 \tabularnewline
51 & 48188 & 63109.6153846154 & -14921.6153846154 \tabularnewline
52 & 161922 & 144628.943661972 & 17293.0563380282 \tabularnewline
53 & 307432 & 302489.571428571 & 4942.42857142858 \tabularnewline
54 & 235223 & 144628.943661972 & 90594.0563380282 \tabularnewline
55 & 195583 & 198107.714285714 & -2524.71428571429 \tabularnewline
56 & 146061 & 144628.943661972 & 1432.05633802817 \tabularnewline
57 & 208834 & 144628.943661972 & 64205.0563380282 \tabularnewline
58 & 93764 & 84645.3 & 9118.7 \tabularnewline
59 & 151985 & 198107.714285714 & -46122.7142857143 \tabularnewline
60 & 190545 & 144628.943661972 & 45916.0563380282 \tabularnewline
61 & 148922 & 144628.943661972 & 4293.05633802817 \tabularnewline
62 & 132856 & 144628.943661972 & -11772.9436619718 \tabularnewline
63 & 129561 & 144628.943661972 & -15067.9436619718 \tabularnewline
64 & 112718 & 144628.943661972 & -31910.9436619718 \tabularnewline
65 & 160930 & 144628.943661972 & 16301.0563380282 \tabularnewline
66 & 99184 & 144628.943661972 & -45444.9436619718 \tabularnewline
67 & 192535 & 302489.571428571 & -109954.571428571 \tabularnewline
68 & 138708 & 144628.943661972 & -5920.94366197183 \tabularnewline
69 & 114408 & 144628.943661972 & -30220.9436619718 \tabularnewline
70 & 31970 & 12105.4 & 19864.6 \tabularnewline
71 & 225558 & 198107.714285714 & 27450.2857142857 \tabularnewline
72 & 137011 & 144628.943661972 & -7617.94366197183 \tabularnewline
73 & 113612 & 144628.943661972 & -31016.9436619718 \tabularnewline
74 & 108641 & 63109.6153846154 & 45531.3846153846 \tabularnewline
75 & 162203 & 144628.943661972 & 17574.0563380282 \tabularnewline
76 & 100098 & 63109.6153846154 & 36988.3846153846 \tabularnewline
77 & 174768 & 144628.943661972 & 30139.0563380282 \tabularnewline
78 & 158459 & 198107.714285714 & -39648.7142857143 \tabularnewline
79 & 80934 & 84645.3 & -3711.3 \tabularnewline
80 & 84971 & 144628.943661972 & -59657.9436619718 \tabularnewline
81 & 80545 & 144628.943661972 & -64083.9436619718 \tabularnewline
82 & 287191 & 198107.714285714 & 89083.2857142857 \tabularnewline
83 & 62974 & 84645.3 & -21671.3 \tabularnewline
84 & 134091 & 144628.943661972 & -10537.9436619718 \tabularnewline
85 & 75555 & 63109.6153846154 & 12445.3846153846 \tabularnewline
86 & 162154 & 144628.943661972 & 17525.0563380282 \tabularnewline
87 & 226638 & 198107.714285714 & 28530.2857142857 \tabularnewline
88 & 115019 & 144628.943661972 & -29609.9436619718 \tabularnewline
89 & 108749 & 144628.943661972 & -35879.9436619718 \tabularnewline
90 & 155537 & 144628.943661972 & 10908.0563380282 \tabularnewline
91 & 153133 & 198107.714285714 & -44974.7142857143 \tabularnewline
92 & 165618 & 198107.714285714 & -32489.7142857143 \tabularnewline
93 & 151517 & 144628.943661972 & 6888.05633802817 \tabularnewline
94 & 133686 & 144628.943661972 & -10942.9436619718 \tabularnewline
95 & 61342 & 84645.3 & -23303.3 \tabularnewline
96 & 245196 & 198107.714285714 & 47088.2857142857 \tabularnewline
97 & 195576 & 198107.714285714 & -2531.71428571429 \tabularnewline
98 & 19349 & 63109.6153846154 & -43760.6153846154 \tabularnewline
99 & 225371 & 144628.943661972 & 80742.0563380282 \tabularnewline
100 & 152796 & 144628.943661972 & 8167.05633802817 \tabularnewline
101 & 59117 & 63109.6153846154 & -3992.61538461538 \tabularnewline
102 & 91762 & 144628.943661972 & -52866.9436619718 \tabularnewline
103 & 136769 & 144628.943661972 & -7859.94366197183 \tabularnewline
104 & 114798 & 144628.943661972 & -29830.9436619718 \tabularnewline
105 & 85338 & 144628.943661972 & -59290.9436619718 \tabularnewline
106 & 27676 & 12105.4 & 15570.6 \tabularnewline
107 & 153535 & 144628.943661972 & 8906.05633802817 \tabularnewline
108 & 122417 & 63109.6153846154 & 59307.3846153846 \tabularnewline
109 & 0 & 12105.4 & -12105.4 \tabularnewline
110 & 91529 & 144628.943661972 & -53099.9436619718 \tabularnewline
111 & 107205 & 84645.3 & 22559.7 \tabularnewline
112 & 144664 & 144628.943661972 & 35.0563380281674 \tabularnewline
113 & 136540 & 144628.943661972 & -8088.94366197183 \tabularnewline
114 & 76656 & 144628.943661972 & -67972.9436619718 \tabularnewline
115 & 3616 & 12105.4 & -8489.4 \tabularnewline
116 & 0 & 12105.4 & -12105.4 \tabularnewline
117 & 183065 & 198107.714285714 & -15042.7142857143 \tabularnewline
118 & 144677 & 198107.714285714 & -53430.7142857143 \tabularnewline
119 & 159104 & 144628.943661972 & 14475.0563380282 \tabularnewline
120 & 113273 & 144628.943661972 & -31355.9436619718 \tabularnewline
121 & 43410 & 63109.6153846154 & -19699.6153846154 \tabularnewline
122 & 175774 & 198107.714285714 & -22333.7142857143 \tabularnewline
123 & 95401 & 144628.943661972 & -49227.9436619718 \tabularnewline
124 & 134837 & 144628.943661972 & -9791.94366197183 \tabularnewline
125 & 60493 & 12105.4 & 48387.6 \tabularnewline
126 & 19764 & 63109.6153846154 & -43345.6153846154 \tabularnewline
127 & 164062 & 144628.943661972 & 19433.0563380282 \tabularnewline
128 & 132696 & 144628.943661972 & -11932.9436619718 \tabularnewline
129 & 155367 & 144628.943661972 & 10738.0563380282 \tabularnewline
130 & 11796 & 12105.4 & -309.4 \tabularnewline
131 & 10674 & 12105.4 & -1431.4 \tabularnewline
132 & 142261 & 144628.943661972 & -2367.94366197183 \tabularnewline
133 & 6836 & 12105.4 & -5269.4 \tabularnewline
134 & 162563 & 144628.943661972 & 17934.0563380282 \tabularnewline
135 & 5118 & 12105.4 & -6987.4 \tabularnewline
136 & 40248 & 63109.6153846154 & -22861.6153846154 \tabularnewline
137 & 0 & 12105.4 & -12105.4 \tabularnewline
138 & 122641 & 144628.943661972 & -21987.9436619718 \tabularnewline
139 & 88837 & 84645.3 & 4191.7 \tabularnewline
140 & 7131 & 12105.4 & -4974.4 \tabularnewline
141 & 9056 & 12105.4 & -3049.4 \tabularnewline
142 & 76611 & 63109.6153846154 & 13501.3846153846 \tabularnewline
143 & 132697 & 144628.943661972 & -11931.9436619718 \tabularnewline
144 & 100681 & 84645.3 & 16035.7 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158784&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]144628.943661972[/C][C]14632.0563380282[/C][/ROW]
[ROW][C]2[/C][C]189672[/C][C]198107.714285714[/C][C]-8435.71428571429[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]12105.4[/C][C]-4890.4[/C][/ROW]
[ROW][C]4[/C][C]129098[/C][C]144628.943661972[/C][C]-15530.9436619718[/C][/ROW]
[ROW][C]5[/C][C]230632[/C][C]198107.714285714[/C][C]32524.2857142857[/C][/ROW]
[ROW][C]6[/C][C]515038[/C][C]302489.571428571[/C][C]212548.428571429[/C][/ROW]
[ROW][C]7[/C][C]180745[/C][C]198107.714285714[/C][C]-17362.7142857143[/C][/ROW]
[ROW][C]8[/C][C]185559[/C][C]198107.714285714[/C][C]-12548.7142857143[/C][/ROW]
[ROW][C]9[/C][C]154581[/C][C]144628.943661972[/C][C]9952.05633802817[/C][/ROW]
[ROW][C]10[/C][C]298001[/C][C]302489.571428571[/C][C]-4488.57142857142[/C][/ROW]
[ROW][C]11[/C][C]121844[/C][C]144628.943661972[/C][C]-22784.9436619718[/C][/ROW]
[ROW][C]12[/C][C]184039[/C][C]198107.714285714[/C][C]-14068.7142857143[/C][/ROW]
[ROW][C]13[/C][C]100324[/C][C]144628.943661972[/C][C]-44304.9436619718[/C][/ROW]
[ROW][C]14[/C][C]217742[/C][C]198107.714285714[/C][C]19634.2857142857[/C][/ROW]
[ROW][C]15[/C][C]168265[/C][C]144628.943661972[/C][C]23636.0563380282[/C][/ROW]
[ROW][C]16[/C][C]154647[/C][C]144628.943661972[/C][C]10018.0563380282[/C][/ROW]
[ROW][C]17[/C][C]142018[/C][C]198107.714285714[/C][C]-56089.7142857143[/C][/ROW]
[ROW][C]18[/C][C]79030[/C][C]63109.6153846154[/C][C]15920.3846153846[/C][/ROW]
[ROW][C]19[/C][C]167047[/C][C]144628.943661972[/C][C]22418.0563380282[/C][/ROW]
[ROW][C]20[/C][C]27997[/C][C]63109.6153846154[/C][C]-35112.6153846154[/C][/ROW]
[ROW][C]21[/C][C]73019[/C][C]84645.3[/C][C]-11626.3[/C][/ROW]
[ROW][C]22[/C][C]241082[/C][C]198107.714285714[/C][C]42974.2857142857[/C][/ROW]
[ROW][C]23[/C][C]195820[/C][C]144628.943661972[/C][C]51191.0563380282[/C][/ROW]
[ROW][C]24[/C][C]142001[/C][C]144628.943661972[/C][C]-2627.94366197183[/C][/ROW]
[ROW][C]25[/C][C]145433[/C][C]144628.943661972[/C][C]804.056338028167[/C][/ROW]
[ROW][C]26[/C][C]183744[/C][C]144628.943661972[/C][C]39115.0563380282[/C][/ROW]
[ROW][C]27[/C][C]202232[/C][C]198107.714285714[/C][C]4124.28571428571[/C][/ROW]
[ROW][C]28[/C][C]199532[/C][C]302489.571428571[/C][C]-102957.571428571[/C][/ROW]
[ROW][C]29[/C][C]354924[/C][C]302489.571428571[/C][C]52434.4285714286[/C][/ROW]
[ROW][C]30[/C][C]192399[/C][C]198107.714285714[/C][C]-5708.71428571429[/C][/ROW]
[ROW][C]31[/C][C]182286[/C][C]144628.943661972[/C][C]37657.0563380282[/C][/ROW]
[ROW][C]32[/C][C]181590[/C][C]198107.714285714[/C][C]-16517.7142857143[/C][/ROW]
[ROW][C]33[/C][C]133801[/C][C]144628.943661972[/C][C]-10827.9436619718[/C][/ROW]
[ROW][C]34[/C][C]233686[/C][C]144628.943661972[/C][C]89057.0563380282[/C][/ROW]
[ROW][C]35[/C][C]219428[/C][C]198107.714285714[/C][C]21320.2857142857[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]12105.4[/C][C]-12105.4[/C][/ROW]
[ROW][C]37[/C][C]223044[/C][C]144628.943661972[/C][C]78415.0563380282[/C][/ROW]
[ROW][C]38[/C][C]100129[/C][C]144628.943661972[/C][C]-44499.9436619718[/C][/ROW]
[ROW][C]39[/C][C]136733[/C][C]144628.943661972[/C][C]-7895.94366197183[/C][/ROW]
[ROW][C]40[/C][C]249965[/C][C]302489.571428571[/C][C]-52524.5714285714[/C][/ROW]
[ROW][C]41[/C][C]242379[/C][C]198107.714285714[/C][C]44271.2857142857[/C][/ROW]
[ROW][C]42[/C][C]145794[/C][C]144628.943661972[/C][C]1165.05633802817[/C][/ROW]
[ROW][C]43[/C][C]96404[/C][C]84645.3[/C][C]11758.7[/C][/ROW]
[ROW][C]44[/C][C]195891[/C][C]198107.714285714[/C][C]-2216.71428571429[/C][/ROW]
[ROW][C]45[/C][C]117156[/C][C]144628.943661972[/C][C]-27472.9436619718[/C][/ROW]
[ROW][C]46[/C][C]157787[/C][C]144628.943661972[/C][C]13158.0563380282[/C][/ROW]
[ROW][C]47[/C][C]81293[/C][C]84645.3[/C][C]-3352.3[/C][/ROW]
[ROW][C]48[/C][C]237435[/C][C]144628.943661972[/C][C]92806.0563380282[/C][/ROW]
[ROW][C]49[/C][C]233155[/C][C]198107.714285714[/C][C]35047.2857142857[/C][/ROW]
[ROW][C]50[/C][C]160344[/C][C]144628.943661972[/C][C]15715.0563380282[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]63109.6153846154[/C][C]-14921.6153846154[/C][/ROW]
[ROW][C]52[/C][C]161922[/C][C]144628.943661972[/C][C]17293.0563380282[/C][/ROW]
[ROW][C]53[/C][C]307432[/C][C]302489.571428571[/C][C]4942.42857142858[/C][/ROW]
[ROW][C]54[/C][C]235223[/C][C]144628.943661972[/C][C]90594.0563380282[/C][/ROW]
[ROW][C]55[/C][C]195583[/C][C]198107.714285714[/C][C]-2524.71428571429[/C][/ROW]
[ROW][C]56[/C][C]146061[/C][C]144628.943661972[/C][C]1432.05633802817[/C][/ROW]
[ROW][C]57[/C][C]208834[/C][C]144628.943661972[/C][C]64205.0563380282[/C][/ROW]
[ROW][C]58[/C][C]93764[/C][C]84645.3[/C][C]9118.7[/C][/ROW]
[ROW][C]59[/C][C]151985[/C][C]198107.714285714[/C][C]-46122.7142857143[/C][/ROW]
[ROW][C]60[/C][C]190545[/C][C]144628.943661972[/C][C]45916.0563380282[/C][/ROW]
[ROW][C]61[/C][C]148922[/C][C]144628.943661972[/C][C]4293.05633802817[/C][/ROW]
[ROW][C]62[/C][C]132856[/C][C]144628.943661972[/C][C]-11772.9436619718[/C][/ROW]
[ROW][C]63[/C][C]129561[/C][C]144628.943661972[/C][C]-15067.9436619718[/C][/ROW]
[ROW][C]64[/C][C]112718[/C][C]144628.943661972[/C][C]-31910.9436619718[/C][/ROW]
[ROW][C]65[/C][C]160930[/C][C]144628.943661972[/C][C]16301.0563380282[/C][/ROW]
[ROW][C]66[/C][C]99184[/C][C]144628.943661972[/C][C]-45444.9436619718[/C][/ROW]
[ROW][C]67[/C][C]192535[/C][C]302489.571428571[/C][C]-109954.571428571[/C][/ROW]
[ROW][C]68[/C][C]138708[/C][C]144628.943661972[/C][C]-5920.94366197183[/C][/ROW]
[ROW][C]69[/C][C]114408[/C][C]144628.943661972[/C][C]-30220.9436619718[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]12105.4[/C][C]19864.6[/C][/ROW]
[ROW][C]71[/C][C]225558[/C][C]198107.714285714[/C][C]27450.2857142857[/C][/ROW]
[ROW][C]72[/C][C]137011[/C][C]144628.943661972[/C][C]-7617.94366197183[/C][/ROW]
[ROW][C]73[/C][C]113612[/C][C]144628.943661972[/C][C]-31016.9436619718[/C][/ROW]
[ROW][C]74[/C][C]108641[/C][C]63109.6153846154[/C][C]45531.3846153846[/C][/ROW]
[ROW][C]75[/C][C]162203[/C][C]144628.943661972[/C][C]17574.0563380282[/C][/ROW]
[ROW][C]76[/C][C]100098[/C][C]63109.6153846154[/C][C]36988.3846153846[/C][/ROW]
[ROW][C]77[/C][C]174768[/C][C]144628.943661972[/C][C]30139.0563380282[/C][/ROW]
[ROW][C]78[/C][C]158459[/C][C]198107.714285714[/C][C]-39648.7142857143[/C][/ROW]
[ROW][C]79[/C][C]80934[/C][C]84645.3[/C][C]-3711.3[/C][/ROW]
[ROW][C]80[/C][C]84971[/C][C]144628.943661972[/C][C]-59657.9436619718[/C][/ROW]
[ROW][C]81[/C][C]80545[/C][C]144628.943661972[/C][C]-64083.9436619718[/C][/ROW]
[ROW][C]82[/C][C]287191[/C][C]198107.714285714[/C][C]89083.2857142857[/C][/ROW]
[ROW][C]83[/C][C]62974[/C][C]84645.3[/C][C]-21671.3[/C][/ROW]
[ROW][C]84[/C][C]134091[/C][C]144628.943661972[/C][C]-10537.9436619718[/C][/ROW]
[ROW][C]85[/C][C]75555[/C][C]63109.6153846154[/C][C]12445.3846153846[/C][/ROW]
[ROW][C]86[/C][C]162154[/C][C]144628.943661972[/C][C]17525.0563380282[/C][/ROW]
[ROW][C]87[/C][C]226638[/C][C]198107.714285714[/C][C]28530.2857142857[/C][/ROW]
[ROW][C]88[/C][C]115019[/C][C]144628.943661972[/C][C]-29609.9436619718[/C][/ROW]
[ROW][C]89[/C][C]108749[/C][C]144628.943661972[/C][C]-35879.9436619718[/C][/ROW]
[ROW][C]90[/C][C]155537[/C][C]144628.943661972[/C][C]10908.0563380282[/C][/ROW]
[ROW][C]91[/C][C]153133[/C][C]198107.714285714[/C][C]-44974.7142857143[/C][/ROW]
[ROW][C]92[/C][C]165618[/C][C]198107.714285714[/C][C]-32489.7142857143[/C][/ROW]
[ROW][C]93[/C][C]151517[/C][C]144628.943661972[/C][C]6888.05633802817[/C][/ROW]
[ROW][C]94[/C][C]133686[/C][C]144628.943661972[/C][C]-10942.9436619718[/C][/ROW]
[ROW][C]95[/C][C]61342[/C][C]84645.3[/C][C]-23303.3[/C][/ROW]
[ROW][C]96[/C][C]245196[/C][C]198107.714285714[/C][C]47088.2857142857[/C][/ROW]
[ROW][C]97[/C][C]195576[/C][C]198107.714285714[/C][C]-2531.71428571429[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]63109.6153846154[/C][C]-43760.6153846154[/C][/ROW]
[ROW][C]99[/C][C]225371[/C][C]144628.943661972[/C][C]80742.0563380282[/C][/ROW]
[ROW][C]100[/C][C]152796[/C][C]144628.943661972[/C][C]8167.05633802817[/C][/ROW]
[ROW][C]101[/C][C]59117[/C][C]63109.6153846154[/C][C]-3992.61538461538[/C][/ROW]
[ROW][C]102[/C][C]91762[/C][C]144628.943661972[/C][C]-52866.9436619718[/C][/ROW]
[ROW][C]103[/C][C]136769[/C][C]144628.943661972[/C][C]-7859.94366197183[/C][/ROW]
[ROW][C]104[/C][C]114798[/C][C]144628.943661972[/C][C]-29830.9436619718[/C][/ROW]
[ROW][C]105[/C][C]85338[/C][C]144628.943661972[/C][C]-59290.9436619718[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]12105.4[/C][C]15570.6[/C][/ROW]
[ROW][C]107[/C][C]153535[/C][C]144628.943661972[/C][C]8906.05633802817[/C][/ROW]
[ROW][C]108[/C][C]122417[/C][C]63109.6153846154[/C][C]59307.3846153846[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]12105.4[/C][C]-12105.4[/C][/ROW]
[ROW][C]110[/C][C]91529[/C][C]144628.943661972[/C][C]-53099.9436619718[/C][/ROW]
[ROW][C]111[/C][C]107205[/C][C]84645.3[/C][C]22559.7[/C][/ROW]
[ROW][C]112[/C][C]144664[/C][C]144628.943661972[/C][C]35.0563380281674[/C][/ROW]
[ROW][C]113[/C][C]136540[/C][C]144628.943661972[/C][C]-8088.94366197183[/C][/ROW]
[ROW][C]114[/C][C]76656[/C][C]144628.943661972[/C][C]-67972.9436619718[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]12105.4[/C][C]-8489.4[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]12105.4[/C][C]-12105.4[/C][/ROW]
[ROW][C]117[/C][C]183065[/C][C]198107.714285714[/C][C]-15042.7142857143[/C][/ROW]
[ROW][C]118[/C][C]144677[/C][C]198107.714285714[/C][C]-53430.7142857143[/C][/ROW]
[ROW][C]119[/C][C]159104[/C][C]144628.943661972[/C][C]14475.0563380282[/C][/ROW]
[ROW][C]120[/C][C]113273[/C][C]144628.943661972[/C][C]-31355.9436619718[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]63109.6153846154[/C][C]-19699.6153846154[/C][/ROW]
[ROW][C]122[/C][C]175774[/C][C]198107.714285714[/C][C]-22333.7142857143[/C][/ROW]
[ROW][C]123[/C][C]95401[/C][C]144628.943661972[/C][C]-49227.9436619718[/C][/ROW]
[ROW][C]124[/C][C]134837[/C][C]144628.943661972[/C][C]-9791.94366197183[/C][/ROW]
[ROW][C]125[/C][C]60493[/C][C]12105.4[/C][C]48387.6[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]63109.6153846154[/C][C]-43345.6153846154[/C][/ROW]
[ROW][C]127[/C][C]164062[/C][C]144628.943661972[/C][C]19433.0563380282[/C][/ROW]
[ROW][C]128[/C][C]132696[/C][C]144628.943661972[/C][C]-11932.9436619718[/C][/ROW]
[ROW][C]129[/C][C]155367[/C][C]144628.943661972[/C][C]10738.0563380282[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]12105.4[/C][C]-309.4[/C][/ROW]
[ROW][C]131[/C][C]10674[/C][C]12105.4[/C][C]-1431.4[/C][/ROW]
[ROW][C]132[/C][C]142261[/C][C]144628.943661972[/C][C]-2367.94366197183[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]12105.4[/C][C]-5269.4[/C][/ROW]
[ROW][C]134[/C][C]162563[/C][C]144628.943661972[/C][C]17934.0563380282[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]12105.4[/C][C]-6987.4[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]63109.6153846154[/C][C]-22861.6153846154[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]12105.4[/C][C]-12105.4[/C][/ROW]
[ROW][C]138[/C][C]122641[/C][C]144628.943661972[/C][C]-21987.9436619718[/C][/ROW]
[ROW][C]139[/C][C]88837[/C][C]84645.3[/C][C]4191.7[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]12105.4[/C][C]-4974.4[/C][/ROW]
[ROW][C]141[/C][C]9056[/C][C]12105.4[/C][C]-3049.4[/C][/ROW]
[ROW][C]142[/C][C]76611[/C][C]63109.6153846154[/C][C]13501.3846153846[/C][/ROW]
[ROW][C]143[/C][C]132697[/C][C]144628.943661972[/C][C]-11931.9436619718[/C][/ROW]
[ROW][C]144[/C][C]100681[/C][C]84645.3[/C][C]16035.7[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158784&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158784&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
1159261144628.94366197214632.0563380282
2189672198107.714285714-8435.71428571429
3721512105.4-4890.4
4129098144628.943661972-15530.9436619718
5230632198107.71428571432524.2857142857
6515038302489.571428571212548.428571429
7180745198107.714285714-17362.7142857143
8185559198107.714285714-12548.7142857143
9154581144628.9436619729952.05633802817
10298001302489.571428571-4488.57142857142
11121844144628.943661972-22784.9436619718
12184039198107.714285714-14068.7142857143
13100324144628.943661972-44304.9436619718
14217742198107.71428571419634.2857142857
15168265144628.94366197223636.0563380282
16154647144628.94366197210018.0563380282
17142018198107.714285714-56089.7142857143
187903063109.615384615415920.3846153846
19167047144628.94366197222418.0563380282
202799763109.6153846154-35112.6153846154
217301984645.3-11626.3
22241082198107.71428571442974.2857142857
23195820144628.94366197251191.0563380282
24142001144628.943661972-2627.94366197183
25145433144628.943661972804.056338028167
26183744144628.94366197239115.0563380282
27202232198107.7142857144124.28571428571
28199532302489.571428571-102957.571428571
29354924302489.57142857152434.4285714286
30192399198107.714285714-5708.71428571429
31182286144628.94366197237657.0563380282
32181590198107.714285714-16517.7142857143
33133801144628.943661972-10827.9436619718
34233686144628.94366197289057.0563380282
35219428198107.71428571421320.2857142857
36012105.4-12105.4
37223044144628.94366197278415.0563380282
38100129144628.943661972-44499.9436619718
39136733144628.943661972-7895.94366197183
40249965302489.571428571-52524.5714285714
41242379198107.71428571444271.2857142857
42145794144628.9436619721165.05633802817
439640484645.311758.7
44195891198107.714285714-2216.71428571429
45117156144628.943661972-27472.9436619718
46157787144628.94366197213158.0563380282
478129384645.3-3352.3
48237435144628.94366197292806.0563380282
49233155198107.71428571435047.2857142857
50160344144628.94366197215715.0563380282
514818863109.6153846154-14921.6153846154
52161922144628.94366197217293.0563380282
53307432302489.5714285714942.42857142858
54235223144628.94366197290594.0563380282
55195583198107.714285714-2524.71428571429
56146061144628.9436619721432.05633802817
57208834144628.94366197264205.0563380282
589376484645.39118.7
59151985198107.714285714-46122.7142857143
60190545144628.94366197245916.0563380282
61148922144628.9436619724293.05633802817
62132856144628.943661972-11772.9436619718
63129561144628.943661972-15067.9436619718
64112718144628.943661972-31910.9436619718
65160930144628.94366197216301.0563380282
6699184144628.943661972-45444.9436619718
67192535302489.571428571-109954.571428571
68138708144628.943661972-5920.94366197183
69114408144628.943661972-30220.9436619718
703197012105.419864.6
71225558198107.71428571427450.2857142857
72137011144628.943661972-7617.94366197183
73113612144628.943661972-31016.9436619718
7410864163109.615384615445531.3846153846
75162203144628.94366197217574.0563380282
7610009863109.615384615436988.3846153846
77174768144628.94366197230139.0563380282
78158459198107.714285714-39648.7142857143
798093484645.3-3711.3
8084971144628.943661972-59657.9436619718
8180545144628.943661972-64083.9436619718
82287191198107.71428571489083.2857142857
836297484645.3-21671.3
84134091144628.943661972-10537.9436619718
857555563109.615384615412445.3846153846
86162154144628.94366197217525.0563380282
87226638198107.71428571428530.2857142857
88115019144628.943661972-29609.9436619718
89108749144628.943661972-35879.9436619718
90155537144628.94366197210908.0563380282
91153133198107.714285714-44974.7142857143
92165618198107.714285714-32489.7142857143
93151517144628.9436619726888.05633802817
94133686144628.943661972-10942.9436619718
956134284645.3-23303.3
96245196198107.71428571447088.2857142857
97195576198107.714285714-2531.71428571429
981934963109.6153846154-43760.6153846154
99225371144628.94366197280742.0563380282
100152796144628.9436619728167.05633802817
1015911763109.6153846154-3992.61538461538
10291762144628.943661972-52866.9436619718
103136769144628.943661972-7859.94366197183
104114798144628.943661972-29830.9436619718
10585338144628.943661972-59290.9436619718
1062767612105.415570.6
107153535144628.9436619728906.05633802817
10812241763109.615384615459307.3846153846
109012105.4-12105.4
11091529144628.943661972-53099.9436619718
11110720584645.322559.7
112144664144628.94366197235.0563380281674
113136540144628.943661972-8088.94366197183
11476656144628.943661972-67972.9436619718
115361612105.4-8489.4
116012105.4-12105.4
117183065198107.714285714-15042.7142857143
118144677198107.714285714-53430.7142857143
119159104144628.94366197214475.0563380282
120113273144628.943661972-31355.9436619718
1214341063109.6153846154-19699.6153846154
122175774198107.714285714-22333.7142857143
12395401144628.943661972-49227.9436619718
124134837144628.943661972-9791.94366197183
1256049312105.448387.6
1261976463109.6153846154-43345.6153846154
127164062144628.94366197219433.0563380282
128132696144628.943661972-11932.9436619718
129155367144628.94366197210738.0563380282
1301179612105.4-309.4
1311067412105.4-1431.4
132142261144628.943661972-2367.94366197183
133683612105.4-5269.4
134162563144628.94366197217934.0563380282
135511812105.4-6987.4
1364024863109.6153846154-22861.6153846154
137012105.4-12105.4
138122641144628.943661972-21987.9436619718
1398883784645.34191.7
140713112105.4-4974.4
141905612105.4-3049.4
1427661163109.615384615413501.3846153846
143132697144628.943661972-11931.9436619718
14410068184645.316035.7



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')
}