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 16:02:44 -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/t1324501379fdepezfdaniukiq.htm/, Retrieved Tue, 07 May 2024 23:41:51 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=159033, Retrieved Tue, 07 May 2024 23:41:51 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact61
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [] [2010-12-05 18:59:57] [b98453cac15ba1066b407e146608df68]
- R PD    [Recursive Partitioning (Regression Trees)] [] [2011-12-21 21:02:44] [3f0da162950979c43b1152c5680f6843] [Current]
Feedback Forum

Post a new message
Dataseries X:
158258	89	48	18	20465
186930	57	53	20	33629
7215	18	0	0	1423
129098	94	51	27	25629
230587	134	76	31	54002
508313	260	128	36	151036
180745	56	62	23	33287
185559	58	83	30	31172
154581	43	55	30	28113
290658	95	67	26	57803
121844	75	50	24	49830
184039	68	77	30	52143
100324	98	46	22	21055
209427	114	79	25	47007
167592	57	55	18	28735
154593	86	54	22	59147
142018	56	81	33	78950
77855	59	5	15	13497
167047	86	74	34	46154
27997	24	13	18	53249
70824	58	19	15	10726
241082	99	99	30	83700
195820	72	38	25	40400
141899	53	59	34	33797
145433	85	50	21	36205
180241	30	50	21	30165
202232	160	61	25	58534
190230	90	81	31	44663
354924	117	60	31	92556
192399	43	52	20	40078
182286	44	61	28	34711
181590	45	60	22	31076
133801	105	53	17	74608
233686	123	76	25	58092
219428	52	63	24	42009
0	1	0	0	0
223044	63	54	28	36022
100129	51	44	14	23333
136733	47	36	35	53349
249965	64	83	34	92596
242379	71	105	22	49598
145794	59	37	34	44093
96404	31	25	23	84205
195891	78	64	24	63369
115335	49	55	26	60132
157787	94	41	22	37403
81293	31	23	35	24460
224049	100	67	24	46456
223789	86	54	31	66616
160344	58	68	26	41554
48188	28	12	22	22346
152206	68	86	21	30874
294283	72	74	27	68701
235223	78	56	30	35728
195583	59	67	33	29010
145942	54	40	11	23110
208834	66	53	26	38844
93764	23	26	26	27084
151985	66	67	23	35139
190545	94	36	38	57476
148922	59	50	31	33277
132856	80	48	20	31141
124234	59	46	19	61281
112718	36	53	26	25820
160930	34	27	26	23284
99184	40	38	33	35378
182022	69	69	36	74990
138708	65	93	25	29653
114408	38	59	24	64622
31970	15	5	21	4157
225558	112	53	19	29245
137011	71	40	12	50008
113612	68	72	30	52338
108641	70	51	21	13310
162203	66	81	34	92901
100098	44	27	32	10956
174768	60	94	28	34241
158459	97	71	28	75043
80934	30	20	21	21152
84971	71	34	31	42249
80545	68	54	26	42005
287191	64	49	29	41152
62974	27	26	23	14399
130982	38	47	25	28263
75555	45	35	22	17215
162154	54	32	26	48140
224670	225	55	33	62897
115019	110	58	24	22883
105038	60	44	24	41622
155537	52	45	21	40715
153133	41	49	28	65897
165577	76	72	27	76542
151517	57	39	25	37477
133686	58	28	15	53216
58128	38	24	13	40911
245196	117	52	36	57021
195576	69	96	24	73116
19349	12	13	1	3895
225371	105	38	24	46609
152796	76	41	31	29351
59117	28	24	4	2325
91762	23	54	21	31747
127987	52	59	23	32665
113552	58	28	23	19249
85338	40	36	12	15292
27676	22	2	16	5842
147984	47	83	29	33994
122417	36	29	26	13018
0	0	0	0	0
91529	32	46	25	98177
107205	66	25	21	37941
144664	44	51	23	31032
136540	61	59	21	32683
76656	59	36	21	34545
3616	5	0	0	0
0	0	0	0	0
183065	42	40	23	27525
144636	83	68	33	66856
152826	96	28	28	28549
113273	38	36	23	38610
43410	19	7	1	2781
175774	72	70	29	41211
95401	41	30	18	22698
118893	54	59	32	41194
60493	40	3	12	32689
19764	12	10	2	5752
164062	55	46	21	26757
132696	32	34	28	22527
155088	47	54	29	44810
11796	9	1	2	0
10674	9	0	0	0
142261	56	39	18	100674
6836	3	0	1	0
154206	61	48	21	57786
5118	3	5	0	0
40248	16	8	4	5444
0	0	0	0	0
122641	46	38	25	28470
88837	38	21	26	61849
7131	4	0	0	0
9056	14	0	4	2179
76611	24	15	17	8019
132697	50	50	21	39644
100681	19	17	22	23494




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

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







Goodness of Fit
Correlation0.7098
R-squared0.5038
RMSE17624.1765

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7098[/C][/ROW]
[ROW][C]R-squared[/C][C]0.5038[/C][/ROW]
[ROW][C]RMSE[/C][C]17624.1765[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159033&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159033&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.7098
R-squared0.5038
RMSE17624.1765







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
12046539346.9529411765-18881.9529411765
23362939346.9529411765-5717.95294117647
314231399.9411764705923.0588235294117
42562939346.9529411765-13717.9529411765
55400254071.2380952381-69.2380952380918
615103677129.222222222273906.7777777778
73328739346.9529411765-6059.95294117647
83117254071.2380952381-22899.2380952381
92811339346.9529411765-11233.9529411765
105780377129.2222222222-19326.2222222222
114983039346.952941176510483.0470588235
125214354071.2380952381-1928.23809523809
132105539346.9529411765-18291.9529411765
144700754071.2380952381-7064.23809523809
152873539346.9529411765-10611.9529411765
165914739346.952941176519800.0470588235
177895054071.238095238124878.7619047619
181349721466.25-7969.25
194615454071.2380952381-7917.23809523809
205324921466.2531782.75
211072621466.25-10740.25
228370077129.22222222226570.77777777778
234040039346.95294117651053.04705882353
243379739346.9529411765-5549.95294117647
253620539346.9529411765-3141.95294117647
263016539346.9529411765-9181.95294117647
275853439346.952941176519187.0470588235
284466354071.2380952381-9408.23809523809
299255677129.222222222215426.7777777778
304007839346.9529411765731.047058823533
313471139346.9529411765-4635.95294117647
323107639346.9529411765-8270.95294117647
337460839346.952941176535261.0470588235
345809254071.23809523814020.76190476191
354200939346.95294117652662.04705882353
3601399.94117647059-1399.94117647059
373602239346.9529411765-3324.95294117647
382333339346.9529411765-16013.9529411765
395334939346.952941176514002.0470588235
409259677129.222222222215466.7777777778
414959877129.2222222222-27531.2222222222
424409339346.95294117654746.04705882353
438420539346.952941176544858.0470588235
446336939346.952941176524022.0470588235
456013239346.952941176520785.0470588235
463740339346.9529411765-1943.95294117647
472446039346.9529411765-14886.9529411765
484645639346.95294117657109.04705882353
496661639346.952941176527269.0470588235
504155454071.2380952381-12517.2380952381
512234621466.25879.75
523087454071.2380952381-23197.2380952381
536870177129.2222222222-8428.22222222222
543572839346.9529411765-3618.95294117647
552901039346.9529411765-10336.9529411765
562311039346.9529411765-16236.9529411765
573884439346.9529411765-502.952941176467
582708439346.9529411765-12262.9529411765
593513939346.9529411765-4207.95294117647
605747639346.952941176518129.0470588235
613327739346.9529411765-6069.95294117647
623114139346.9529411765-8205.95294117647
636128139346.952941176521934.0470588235
642582039346.9529411765-13526.9529411765
652328439346.9529411765-16062.9529411765
663537839346.9529411765-3968.95294117647
677499054071.238095238120918.7619047619
682965354071.2380952381-24418.2380952381
696462239346.952941176525275.0470588235
70415721466.25-17309.25
712924539346.9529411765-10101.9529411765
725000839346.952941176510661.0470588235
735233854071.2380952381-1733.23809523809
741331039346.9529411765-26036.9529411765
759290154071.238095238138829.7619047619
761095639346.9529411765-28390.9529411765
773424154071.2380952381-19830.2380952381
787504354071.238095238120971.7619047619
792115239346.9529411765-18194.9529411765
804224939346.95294117652902.04705882353
814200539346.95294117652658.04705882353
824115277129.2222222222-35977.2222222222
831439921466.25-7067.25
842826339346.9529411765-11083.9529411765
851721521466.25-4251.25
864814039346.95294117658793.04705882353
876289739346.952941176523550.0470588235
882288339346.9529411765-16463.9529411765
894162239346.95294117652275.04705882353
904071539346.95294117651368.04705882353
916589739346.952941176526550.0470588235
927654254071.238095238122470.7619047619
933747739346.9529411765-1869.95294117647
945321639346.952941176513869.0470588235
954091121466.2519444.75
965702177129.2222222222-20108.2222222222
977311654071.238095238119044.7619047619
9838951399.941176470592495.05882352941
994660939346.95294117657262.04705882353
1002935139346.9529411765-9995.95294117647
10123251399.94117647059925.058823529412
1023174739346.9529411765-7599.95294117647
1033266539346.9529411765-6681.95294117647
1041924939346.9529411765-20097.9529411765
1051529239346.9529411765-24054.9529411765
106584221466.25-15624.25
1073399454071.2380952381-20077.2380952381
1081301839346.9529411765-26328.9529411765
10901399.94117647059-1399.94117647059
1109817739346.952941176558830.0470588235
1113794139346.9529411765-1405.95294117647
1123103239346.9529411765-8314.95294117647
1133268339346.9529411765-6663.95294117647
1143454521466.2513078.75
11501399.94117647059-1399.94117647059
11601399.94117647059-1399.94117647059
1172752539346.9529411765-11821.9529411765
1186685654071.238095238112784.7619047619
1192854939346.9529411765-10797.9529411765
1203861039346.9529411765-736.952941176467
12127811399.941176470591381.05882352941
1224121154071.2380952381-12860.2380952381
1232269839346.9529411765-16648.9529411765
1244119439346.95294117651847.04705882353
1253268921466.2511222.75
12657521399.941176470594352.05882352941
1272675739346.9529411765-12589.9529411765
1282252739346.9529411765-16819.9529411765
1294481039346.95294117655463.04705882353
13001399.94117647059-1399.94117647059
13101399.94117647059-1399.94117647059
13210067439346.952941176561327.0470588235
13301399.94117647059-1399.94117647059
1345778639346.952941176518439.0470588235
13501399.94117647059-1399.94117647059
13654441399.941176470594044.05882352941
13701399.94117647059-1399.94117647059
1382847039346.9529411765-10876.9529411765
1396184939346.952941176522502.0470588235
14001399.94117647059-1399.94117647059
14121791399.94117647059779.058823529412
142801921466.25-13447.25
1433964439346.9529411765297.047058823533
1442349439346.9529411765-15852.9529411765

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 20465 & 39346.9529411765 & -18881.9529411765 \tabularnewline
2 & 33629 & 39346.9529411765 & -5717.95294117647 \tabularnewline
3 & 1423 & 1399.94117647059 & 23.0588235294117 \tabularnewline
4 & 25629 & 39346.9529411765 & -13717.9529411765 \tabularnewline
5 & 54002 & 54071.2380952381 & -69.2380952380918 \tabularnewline
6 & 151036 & 77129.2222222222 & 73906.7777777778 \tabularnewline
7 & 33287 & 39346.9529411765 & -6059.95294117647 \tabularnewline
8 & 31172 & 54071.2380952381 & -22899.2380952381 \tabularnewline
9 & 28113 & 39346.9529411765 & -11233.9529411765 \tabularnewline
10 & 57803 & 77129.2222222222 & -19326.2222222222 \tabularnewline
11 & 49830 & 39346.9529411765 & 10483.0470588235 \tabularnewline
12 & 52143 & 54071.2380952381 & -1928.23809523809 \tabularnewline
13 & 21055 & 39346.9529411765 & -18291.9529411765 \tabularnewline
14 & 47007 & 54071.2380952381 & -7064.23809523809 \tabularnewline
15 & 28735 & 39346.9529411765 & -10611.9529411765 \tabularnewline
16 & 59147 & 39346.9529411765 & 19800.0470588235 \tabularnewline
17 & 78950 & 54071.2380952381 & 24878.7619047619 \tabularnewline
18 & 13497 & 21466.25 & -7969.25 \tabularnewline
19 & 46154 & 54071.2380952381 & -7917.23809523809 \tabularnewline
20 & 53249 & 21466.25 & 31782.75 \tabularnewline
21 & 10726 & 21466.25 & -10740.25 \tabularnewline
22 & 83700 & 77129.2222222222 & 6570.77777777778 \tabularnewline
23 & 40400 & 39346.9529411765 & 1053.04705882353 \tabularnewline
24 & 33797 & 39346.9529411765 & -5549.95294117647 \tabularnewline
25 & 36205 & 39346.9529411765 & -3141.95294117647 \tabularnewline
26 & 30165 & 39346.9529411765 & -9181.95294117647 \tabularnewline
27 & 58534 & 39346.9529411765 & 19187.0470588235 \tabularnewline
28 & 44663 & 54071.2380952381 & -9408.23809523809 \tabularnewline
29 & 92556 & 77129.2222222222 & 15426.7777777778 \tabularnewline
30 & 40078 & 39346.9529411765 & 731.047058823533 \tabularnewline
31 & 34711 & 39346.9529411765 & -4635.95294117647 \tabularnewline
32 & 31076 & 39346.9529411765 & -8270.95294117647 \tabularnewline
33 & 74608 & 39346.9529411765 & 35261.0470588235 \tabularnewline
34 & 58092 & 54071.2380952381 & 4020.76190476191 \tabularnewline
35 & 42009 & 39346.9529411765 & 2662.04705882353 \tabularnewline
36 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
37 & 36022 & 39346.9529411765 & -3324.95294117647 \tabularnewline
38 & 23333 & 39346.9529411765 & -16013.9529411765 \tabularnewline
39 & 53349 & 39346.9529411765 & 14002.0470588235 \tabularnewline
40 & 92596 & 77129.2222222222 & 15466.7777777778 \tabularnewline
41 & 49598 & 77129.2222222222 & -27531.2222222222 \tabularnewline
42 & 44093 & 39346.9529411765 & 4746.04705882353 \tabularnewline
43 & 84205 & 39346.9529411765 & 44858.0470588235 \tabularnewline
44 & 63369 & 39346.9529411765 & 24022.0470588235 \tabularnewline
45 & 60132 & 39346.9529411765 & 20785.0470588235 \tabularnewline
46 & 37403 & 39346.9529411765 & -1943.95294117647 \tabularnewline
47 & 24460 & 39346.9529411765 & -14886.9529411765 \tabularnewline
48 & 46456 & 39346.9529411765 & 7109.04705882353 \tabularnewline
49 & 66616 & 39346.9529411765 & 27269.0470588235 \tabularnewline
50 & 41554 & 54071.2380952381 & -12517.2380952381 \tabularnewline
51 & 22346 & 21466.25 & 879.75 \tabularnewline
52 & 30874 & 54071.2380952381 & -23197.2380952381 \tabularnewline
53 & 68701 & 77129.2222222222 & -8428.22222222222 \tabularnewline
54 & 35728 & 39346.9529411765 & -3618.95294117647 \tabularnewline
55 & 29010 & 39346.9529411765 & -10336.9529411765 \tabularnewline
56 & 23110 & 39346.9529411765 & -16236.9529411765 \tabularnewline
57 & 38844 & 39346.9529411765 & -502.952941176467 \tabularnewline
58 & 27084 & 39346.9529411765 & -12262.9529411765 \tabularnewline
59 & 35139 & 39346.9529411765 & -4207.95294117647 \tabularnewline
60 & 57476 & 39346.9529411765 & 18129.0470588235 \tabularnewline
61 & 33277 & 39346.9529411765 & -6069.95294117647 \tabularnewline
62 & 31141 & 39346.9529411765 & -8205.95294117647 \tabularnewline
63 & 61281 & 39346.9529411765 & 21934.0470588235 \tabularnewline
64 & 25820 & 39346.9529411765 & -13526.9529411765 \tabularnewline
65 & 23284 & 39346.9529411765 & -16062.9529411765 \tabularnewline
66 & 35378 & 39346.9529411765 & -3968.95294117647 \tabularnewline
67 & 74990 & 54071.2380952381 & 20918.7619047619 \tabularnewline
68 & 29653 & 54071.2380952381 & -24418.2380952381 \tabularnewline
69 & 64622 & 39346.9529411765 & 25275.0470588235 \tabularnewline
70 & 4157 & 21466.25 & -17309.25 \tabularnewline
71 & 29245 & 39346.9529411765 & -10101.9529411765 \tabularnewline
72 & 50008 & 39346.9529411765 & 10661.0470588235 \tabularnewline
73 & 52338 & 54071.2380952381 & -1733.23809523809 \tabularnewline
74 & 13310 & 39346.9529411765 & -26036.9529411765 \tabularnewline
75 & 92901 & 54071.2380952381 & 38829.7619047619 \tabularnewline
76 & 10956 & 39346.9529411765 & -28390.9529411765 \tabularnewline
77 & 34241 & 54071.2380952381 & -19830.2380952381 \tabularnewline
78 & 75043 & 54071.2380952381 & 20971.7619047619 \tabularnewline
79 & 21152 & 39346.9529411765 & -18194.9529411765 \tabularnewline
80 & 42249 & 39346.9529411765 & 2902.04705882353 \tabularnewline
81 & 42005 & 39346.9529411765 & 2658.04705882353 \tabularnewline
82 & 41152 & 77129.2222222222 & -35977.2222222222 \tabularnewline
83 & 14399 & 21466.25 & -7067.25 \tabularnewline
84 & 28263 & 39346.9529411765 & -11083.9529411765 \tabularnewline
85 & 17215 & 21466.25 & -4251.25 \tabularnewline
86 & 48140 & 39346.9529411765 & 8793.04705882353 \tabularnewline
87 & 62897 & 39346.9529411765 & 23550.0470588235 \tabularnewline
88 & 22883 & 39346.9529411765 & -16463.9529411765 \tabularnewline
89 & 41622 & 39346.9529411765 & 2275.04705882353 \tabularnewline
90 & 40715 & 39346.9529411765 & 1368.04705882353 \tabularnewline
91 & 65897 & 39346.9529411765 & 26550.0470588235 \tabularnewline
92 & 76542 & 54071.2380952381 & 22470.7619047619 \tabularnewline
93 & 37477 & 39346.9529411765 & -1869.95294117647 \tabularnewline
94 & 53216 & 39346.9529411765 & 13869.0470588235 \tabularnewline
95 & 40911 & 21466.25 & 19444.75 \tabularnewline
96 & 57021 & 77129.2222222222 & -20108.2222222222 \tabularnewline
97 & 73116 & 54071.2380952381 & 19044.7619047619 \tabularnewline
98 & 3895 & 1399.94117647059 & 2495.05882352941 \tabularnewline
99 & 46609 & 39346.9529411765 & 7262.04705882353 \tabularnewline
100 & 29351 & 39346.9529411765 & -9995.95294117647 \tabularnewline
101 & 2325 & 1399.94117647059 & 925.058823529412 \tabularnewline
102 & 31747 & 39346.9529411765 & -7599.95294117647 \tabularnewline
103 & 32665 & 39346.9529411765 & -6681.95294117647 \tabularnewline
104 & 19249 & 39346.9529411765 & -20097.9529411765 \tabularnewline
105 & 15292 & 39346.9529411765 & -24054.9529411765 \tabularnewline
106 & 5842 & 21466.25 & -15624.25 \tabularnewline
107 & 33994 & 54071.2380952381 & -20077.2380952381 \tabularnewline
108 & 13018 & 39346.9529411765 & -26328.9529411765 \tabularnewline
109 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
110 & 98177 & 39346.9529411765 & 58830.0470588235 \tabularnewline
111 & 37941 & 39346.9529411765 & -1405.95294117647 \tabularnewline
112 & 31032 & 39346.9529411765 & -8314.95294117647 \tabularnewline
113 & 32683 & 39346.9529411765 & -6663.95294117647 \tabularnewline
114 & 34545 & 21466.25 & 13078.75 \tabularnewline
115 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
116 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
117 & 27525 & 39346.9529411765 & -11821.9529411765 \tabularnewline
118 & 66856 & 54071.2380952381 & 12784.7619047619 \tabularnewline
119 & 28549 & 39346.9529411765 & -10797.9529411765 \tabularnewline
120 & 38610 & 39346.9529411765 & -736.952941176467 \tabularnewline
121 & 2781 & 1399.94117647059 & 1381.05882352941 \tabularnewline
122 & 41211 & 54071.2380952381 & -12860.2380952381 \tabularnewline
123 & 22698 & 39346.9529411765 & -16648.9529411765 \tabularnewline
124 & 41194 & 39346.9529411765 & 1847.04705882353 \tabularnewline
125 & 32689 & 21466.25 & 11222.75 \tabularnewline
126 & 5752 & 1399.94117647059 & 4352.05882352941 \tabularnewline
127 & 26757 & 39346.9529411765 & -12589.9529411765 \tabularnewline
128 & 22527 & 39346.9529411765 & -16819.9529411765 \tabularnewline
129 & 44810 & 39346.9529411765 & 5463.04705882353 \tabularnewline
130 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
131 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
132 & 100674 & 39346.9529411765 & 61327.0470588235 \tabularnewline
133 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
134 & 57786 & 39346.9529411765 & 18439.0470588235 \tabularnewline
135 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
136 & 5444 & 1399.94117647059 & 4044.05882352941 \tabularnewline
137 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
138 & 28470 & 39346.9529411765 & -10876.9529411765 \tabularnewline
139 & 61849 & 39346.9529411765 & 22502.0470588235 \tabularnewline
140 & 0 & 1399.94117647059 & -1399.94117647059 \tabularnewline
141 & 2179 & 1399.94117647059 & 779.058823529412 \tabularnewline
142 & 8019 & 21466.25 & -13447.25 \tabularnewline
143 & 39644 & 39346.9529411765 & 297.047058823533 \tabularnewline
144 & 23494 & 39346.9529411765 & -15852.9529411765 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=159033&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]20465[/C][C]39346.9529411765[/C][C]-18881.9529411765[/C][/ROW]
[ROW][C]2[/C][C]33629[/C][C]39346.9529411765[/C][C]-5717.95294117647[/C][/ROW]
[ROW][C]3[/C][C]1423[/C][C]1399.94117647059[/C][C]23.0588235294117[/C][/ROW]
[ROW][C]4[/C][C]25629[/C][C]39346.9529411765[/C][C]-13717.9529411765[/C][/ROW]
[ROW][C]5[/C][C]54002[/C][C]54071.2380952381[/C][C]-69.2380952380918[/C][/ROW]
[ROW][C]6[/C][C]151036[/C][C]77129.2222222222[/C][C]73906.7777777778[/C][/ROW]
[ROW][C]7[/C][C]33287[/C][C]39346.9529411765[/C][C]-6059.95294117647[/C][/ROW]
[ROW][C]8[/C][C]31172[/C][C]54071.2380952381[/C][C]-22899.2380952381[/C][/ROW]
[ROW][C]9[/C][C]28113[/C][C]39346.9529411765[/C][C]-11233.9529411765[/C][/ROW]
[ROW][C]10[/C][C]57803[/C][C]77129.2222222222[/C][C]-19326.2222222222[/C][/ROW]
[ROW][C]11[/C][C]49830[/C][C]39346.9529411765[/C][C]10483.0470588235[/C][/ROW]
[ROW][C]12[/C][C]52143[/C][C]54071.2380952381[/C][C]-1928.23809523809[/C][/ROW]
[ROW][C]13[/C][C]21055[/C][C]39346.9529411765[/C][C]-18291.9529411765[/C][/ROW]
[ROW][C]14[/C][C]47007[/C][C]54071.2380952381[/C][C]-7064.23809523809[/C][/ROW]
[ROW][C]15[/C][C]28735[/C][C]39346.9529411765[/C][C]-10611.9529411765[/C][/ROW]
[ROW][C]16[/C][C]59147[/C][C]39346.9529411765[/C][C]19800.0470588235[/C][/ROW]
[ROW][C]17[/C][C]78950[/C][C]54071.2380952381[/C][C]24878.7619047619[/C][/ROW]
[ROW][C]18[/C][C]13497[/C][C]21466.25[/C][C]-7969.25[/C][/ROW]
[ROW][C]19[/C][C]46154[/C][C]54071.2380952381[/C][C]-7917.23809523809[/C][/ROW]
[ROW][C]20[/C][C]53249[/C][C]21466.25[/C][C]31782.75[/C][/ROW]
[ROW][C]21[/C][C]10726[/C][C]21466.25[/C][C]-10740.25[/C][/ROW]
[ROW][C]22[/C][C]83700[/C][C]77129.2222222222[/C][C]6570.77777777778[/C][/ROW]
[ROW][C]23[/C][C]40400[/C][C]39346.9529411765[/C][C]1053.04705882353[/C][/ROW]
[ROW][C]24[/C][C]33797[/C][C]39346.9529411765[/C][C]-5549.95294117647[/C][/ROW]
[ROW][C]25[/C][C]36205[/C][C]39346.9529411765[/C][C]-3141.95294117647[/C][/ROW]
[ROW][C]26[/C][C]30165[/C][C]39346.9529411765[/C][C]-9181.95294117647[/C][/ROW]
[ROW][C]27[/C][C]58534[/C][C]39346.9529411765[/C][C]19187.0470588235[/C][/ROW]
[ROW][C]28[/C][C]44663[/C][C]54071.2380952381[/C][C]-9408.23809523809[/C][/ROW]
[ROW][C]29[/C][C]92556[/C][C]77129.2222222222[/C][C]15426.7777777778[/C][/ROW]
[ROW][C]30[/C][C]40078[/C][C]39346.9529411765[/C][C]731.047058823533[/C][/ROW]
[ROW][C]31[/C][C]34711[/C][C]39346.9529411765[/C][C]-4635.95294117647[/C][/ROW]
[ROW][C]32[/C][C]31076[/C][C]39346.9529411765[/C][C]-8270.95294117647[/C][/ROW]
[ROW][C]33[/C][C]74608[/C][C]39346.9529411765[/C][C]35261.0470588235[/C][/ROW]
[ROW][C]34[/C][C]58092[/C][C]54071.2380952381[/C][C]4020.76190476191[/C][/ROW]
[ROW][C]35[/C][C]42009[/C][C]39346.9529411765[/C][C]2662.04705882353[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]37[/C][C]36022[/C][C]39346.9529411765[/C][C]-3324.95294117647[/C][/ROW]
[ROW][C]38[/C][C]23333[/C][C]39346.9529411765[/C][C]-16013.9529411765[/C][/ROW]
[ROW][C]39[/C][C]53349[/C][C]39346.9529411765[/C][C]14002.0470588235[/C][/ROW]
[ROW][C]40[/C][C]92596[/C][C]77129.2222222222[/C][C]15466.7777777778[/C][/ROW]
[ROW][C]41[/C][C]49598[/C][C]77129.2222222222[/C][C]-27531.2222222222[/C][/ROW]
[ROW][C]42[/C][C]44093[/C][C]39346.9529411765[/C][C]4746.04705882353[/C][/ROW]
[ROW][C]43[/C][C]84205[/C][C]39346.9529411765[/C][C]44858.0470588235[/C][/ROW]
[ROW][C]44[/C][C]63369[/C][C]39346.9529411765[/C][C]24022.0470588235[/C][/ROW]
[ROW][C]45[/C][C]60132[/C][C]39346.9529411765[/C][C]20785.0470588235[/C][/ROW]
[ROW][C]46[/C][C]37403[/C][C]39346.9529411765[/C][C]-1943.95294117647[/C][/ROW]
[ROW][C]47[/C][C]24460[/C][C]39346.9529411765[/C][C]-14886.9529411765[/C][/ROW]
[ROW][C]48[/C][C]46456[/C][C]39346.9529411765[/C][C]7109.04705882353[/C][/ROW]
[ROW][C]49[/C][C]66616[/C][C]39346.9529411765[/C][C]27269.0470588235[/C][/ROW]
[ROW][C]50[/C][C]41554[/C][C]54071.2380952381[/C][C]-12517.2380952381[/C][/ROW]
[ROW][C]51[/C][C]22346[/C][C]21466.25[/C][C]879.75[/C][/ROW]
[ROW][C]52[/C][C]30874[/C][C]54071.2380952381[/C][C]-23197.2380952381[/C][/ROW]
[ROW][C]53[/C][C]68701[/C][C]77129.2222222222[/C][C]-8428.22222222222[/C][/ROW]
[ROW][C]54[/C][C]35728[/C][C]39346.9529411765[/C][C]-3618.95294117647[/C][/ROW]
[ROW][C]55[/C][C]29010[/C][C]39346.9529411765[/C][C]-10336.9529411765[/C][/ROW]
[ROW][C]56[/C][C]23110[/C][C]39346.9529411765[/C][C]-16236.9529411765[/C][/ROW]
[ROW][C]57[/C][C]38844[/C][C]39346.9529411765[/C][C]-502.952941176467[/C][/ROW]
[ROW][C]58[/C][C]27084[/C][C]39346.9529411765[/C][C]-12262.9529411765[/C][/ROW]
[ROW][C]59[/C][C]35139[/C][C]39346.9529411765[/C][C]-4207.95294117647[/C][/ROW]
[ROW][C]60[/C][C]57476[/C][C]39346.9529411765[/C][C]18129.0470588235[/C][/ROW]
[ROW][C]61[/C][C]33277[/C][C]39346.9529411765[/C][C]-6069.95294117647[/C][/ROW]
[ROW][C]62[/C][C]31141[/C][C]39346.9529411765[/C][C]-8205.95294117647[/C][/ROW]
[ROW][C]63[/C][C]61281[/C][C]39346.9529411765[/C][C]21934.0470588235[/C][/ROW]
[ROW][C]64[/C][C]25820[/C][C]39346.9529411765[/C][C]-13526.9529411765[/C][/ROW]
[ROW][C]65[/C][C]23284[/C][C]39346.9529411765[/C][C]-16062.9529411765[/C][/ROW]
[ROW][C]66[/C][C]35378[/C][C]39346.9529411765[/C][C]-3968.95294117647[/C][/ROW]
[ROW][C]67[/C][C]74990[/C][C]54071.2380952381[/C][C]20918.7619047619[/C][/ROW]
[ROW][C]68[/C][C]29653[/C][C]54071.2380952381[/C][C]-24418.2380952381[/C][/ROW]
[ROW][C]69[/C][C]64622[/C][C]39346.9529411765[/C][C]25275.0470588235[/C][/ROW]
[ROW][C]70[/C][C]4157[/C][C]21466.25[/C][C]-17309.25[/C][/ROW]
[ROW][C]71[/C][C]29245[/C][C]39346.9529411765[/C][C]-10101.9529411765[/C][/ROW]
[ROW][C]72[/C][C]50008[/C][C]39346.9529411765[/C][C]10661.0470588235[/C][/ROW]
[ROW][C]73[/C][C]52338[/C][C]54071.2380952381[/C][C]-1733.23809523809[/C][/ROW]
[ROW][C]74[/C][C]13310[/C][C]39346.9529411765[/C][C]-26036.9529411765[/C][/ROW]
[ROW][C]75[/C][C]92901[/C][C]54071.2380952381[/C][C]38829.7619047619[/C][/ROW]
[ROW][C]76[/C][C]10956[/C][C]39346.9529411765[/C][C]-28390.9529411765[/C][/ROW]
[ROW][C]77[/C][C]34241[/C][C]54071.2380952381[/C][C]-19830.2380952381[/C][/ROW]
[ROW][C]78[/C][C]75043[/C][C]54071.2380952381[/C][C]20971.7619047619[/C][/ROW]
[ROW][C]79[/C][C]21152[/C][C]39346.9529411765[/C][C]-18194.9529411765[/C][/ROW]
[ROW][C]80[/C][C]42249[/C][C]39346.9529411765[/C][C]2902.04705882353[/C][/ROW]
[ROW][C]81[/C][C]42005[/C][C]39346.9529411765[/C][C]2658.04705882353[/C][/ROW]
[ROW][C]82[/C][C]41152[/C][C]77129.2222222222[/C][C]-35977.2222222222[/C][/ROW]
[ROW][C]83[/C][C]14399[/C][C]21466.25[/C][C]-7067.25[/C][/ROW]
[ROW][C]84[/C][C]28263[/C][C]39346.9529411765[/C][C]-11083.9529411765[/C][/ROW]
[ROW][C]85[/C][C]17215[/C][C]21466.25[/C][C]-4251.25[/C][/ROW]
[ROW][C]86[/C][C]48140[/C][C]39346.9529411765[/C][C]8793.04705882353[/C][/ROW]
[ROW][C]87[/C][C]62897[/C][C]39346.9529411765[/C][C]23550.0470588235[/C][/ROW]
[ROW][C]88[/C][C]22883[/C][C]39346.9529411765[/C][C]-16463.9529411765[/C][/ROW]
[ROW][C]89[/C][C]41622[/C][C]39346.9529411765[/C][C]2275.04705882353[/C][/ROW]
[ROW][C]90[/C][C]40715[/C][C]39346.9529411765[/C][C]1368.04705882353[/C][/ROW]
[ROW][C]91[/C][C]65897[/C][C]39346.9529411765[/C][C]26550.0470588235[/C][/ROW]
[ROW][C]92[/C][C]76542[/C][C]54071.2380952381[/C][C]22470.7619047619[/C][/ROW]
[ROW][C]93[/C][C]37477[/C][C]39346.9529411765[/C][C]-1869.95294117647[/C][/ROW]
[ROW][C]94[/C][C]53216[/C][C]39346.9529411765[/C][C]13869.0470588235[/C][/ROW]
[ROW][C]95[/C][C]40911[/C][C]21466.25[/C][C]19444.75[/C][/ROW]
[ROW][C]96[/C][C]57021[/C][C]77129.2222222222[/C][C]-20108.2222222222[/C][/ROW]
[ROW][C]97[/C][C]73116[/C][C]54071.2380952381[/C][C]19044.7619047619[/C][/ROW]
[ROW][C]98[/C][C]3895[/C][C]1399.94117647059[/C][C]2495.05882352941[/C][/ROW]
[ROW][C]99[/C][C]46609[/C][C]39346.9529411765[/C][C]7262.04705882353[/C][/ROW]
[ROW][C]100[/C][C]29351[/C][C]39346.9529411765[/C][C]-9995.95294117647[/C][/ROW]
[ROW][C]101[/C][C]2325[/C][C]1399.94117647059[/C][C]925.058823529412[/C][/ROW]
[ROW][C]102[/C][C]31747[/C][C]39346.9529411765[/C][C]-7599.95294117647[/C][/ROW]
[ROW][C]103[/C][C]32665[/C][C]39346.9529411765[/C][C]-6681.95294117647[/C][/ROW]
[ROW][C]104[/C][C]19249[/C][C]39346.9529411765[/C][C]-20097.9529411765[/C][/ROW]
[ROW][C]105[/C][C]15292[/C][C]39346.9529411765[/C][C]-24054.9529411765[/C][/ROW]
[ROW][C]106[/C][C]5842[/C][C]21466.25[/C][C]-15624.25[/C][/ROW]
[ROW][C]107[/C][C]33994[/C][C]54071.2380952381[/C][C]-20077.2380952381[/C][/ROW]
[ROW][C]108[/C][C]13018[/C][C]39346.9529411765[/C][C]-26328.9529411765[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]110[/C][C]98177[/C][C]39346.9529411765[/C][C]58830.0470588235[/C][/ROW]
[ROW][C]111[/C][C]37941[/C][C]39346.9529411765[/C][C]-1405.95294117647[/C][/ROW]
[ROW][C]112[/C][C]31032[/C][C]39346.9529411765[/C][C]-8314.95294117647[/C][/ROW]
[ROW][C]113[/C][C]32683[/C][C]39346.9529411765[/C][C]-6663.95294117647[/C][/ROW]
[ROW][C]114[/C][C]34545[/C][C]21466.25[/C][C]13078.75[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]117[/C][C]27525[/C][C]39346.9529411765[/C][C]-11821.9529411765[/C][/ROW]
[ROW][C]118[/C][C]66856[/C][C]54071.2380952381[/C][C]12784.7619047619[/C][/ROW]
[ROW][C]119[/C][C]28549[/C][C]39346.9529411765[/C][C]-10797.9529411765[/C][/ROW]
[ROW][C]120[/C][C]38610[/C][C]39346.9529411765[/C][C]-736.952941176467[/C][/ROW]
[ROW][C]121[/C][C]2781[/C][C]1399.94117647059[/C][C]1381.05882352941[/C][/ROW]
[ROW][C]122[/C][C]41211[/C][C]54071.2380952381[/C][C]-12860.2380952381[/C][/ROW]
[ROW][C]123[/C][C]22698[/C][C]39346.9529411765[/C][C]-16648.9529411765[/C][/ROW]
[ROW][C]124[/C][C]41194[/C][C]39346.9529411765[/C][C]1847.04705882353[/C][/ROW]
[ROW][C]125[/C][C]32689[/C][C]21466.25[/C][C]11222.75[/C][/ROW]
[ROW][C]126[/C][C]5752[/C][C]1399.94117647059[/C][C]4352.05882352941[/C][/ROW]
[ROW][C]127[/C][C]26757[/C][C]39346.9529411765[/C][C]-12589.9529411765[/C][/ROW]
[ROW][C]128[/C][C]22527[/C][C]39346.9529411765[/C][C]-16819.9529411765[/C][/ROW]
[ROW][C]129[/C][C]44810[/C][C]39346.9529411765[/C][C]5463.04705882353[/C][/ROW]
[ROW][C]130[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]132[/C][C]100674[/C][C]39346.9529411765[/C][C]61327.0470588235[/C][/ROW]
[ROW][C]133[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]134[/C][C]57786[/C][C]39346.9529411765[/C][C]18439.0470588235[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]136[/C][C]5444[/C][C]1399.94117647059[/C][C]4044.05882352941[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]138[/C][C]28470[/C][C]39346.9529411765[/C][C]-10876.9529411765[/C][/ROW]
[ROW][C]139[/C][C]61849[/C][C]39346.9529411765[/C][C]22502.0470588235[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]1399.94117647059[/C][C]-1399.94117647059[/C][/ROW]
[ROW][C]141[/C][C]2179[/C][C]1399.94117647059[/C][C]779.058823529412[/C][/ROW]
[ROW][C]142[/C][C]8019[/C][C]21466.25[/C][C]-13447.25[/C][/ROW]
[ROW][C]143[/C][C]39644[/C][C]39346.9529411765[/C][C]297.047058823533[/C][/ROW]
[ROW][C]144[/C][C]23494[/C][C]39346.9529411765[/C][C]-15852.9529411765[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159033&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159033&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
12046539346.9529411765-18881.9529411765
23362939346.9529411765-5717.95294117647
314231399.9411764705923.0588235294117
42562939346.9529411765-13717.9529411765
55400254071.2380952381-69.2380952380918
615103677129.222222222273906.7777777778
73328739346.9529411765-6059.95294117647
83117254071.2380952381-22899.2380952381
92811339346.9529411765-11233.9529411765
105780377129.2222222222-19326.2222222222
114983039346.952941176510483.0470588235
125214354071.2380952381-1928.23809523809
132105539346.9529411765-18291.9529411765
144700754071.2380952381-7064.23809523809
152873539346.9529411765-10611.9529411765
165914739346.952941176519800.0470588235
177895054071.238095238124878.7619047619
181349721466.25-7969.25
194615454071.2380952381-7917.23809523809
205324921466.2531782.75
211072621466.25-10740.25
228370077129.22222222226570.77777777778
234040039346.95294117651053.04705882353
243379739346.9529411765-5549.95294117647
253620539346.9529411765-3141.95294117647
263016539346.9529411765-9181.95294117647
275853439346.952941176519187.0470588235
284466354071.2380952381-9408.23809523809
299255677129.222222222215426.7777777778
304007839346.9529411765731.047058823533
313471139346.9529411765-4635.95294117647
323107639346.9529411765-8270.95294117647
337460839346.952941176535261.0470588235
345809254071.23809523814020.76190476191
354200939346.95294117652662.04705882353
3601399.94117647059-1399.94117647059
373602239346.9529411765-3324.95294117647
382333339346.9529411765-16013.9529411765
395334939346.952941176514002.0470588235
409259677129.222222222215466.7777777778
414959877129.2222222222-27531.2222222222
424409339346.95294117654746.04705882353
438420539346.952941176544858.0470588235
446336939346.952941176524022.0470588235
456013239346.952941176520785.0470588235
463740339346.9529411765-1943.95294117647
472446039346.9529411765-14886.9529411765
484645639346.95294117657109.04705882353
496661639346.952941176527269.0470588235
504155454071.2380952381-12517.2380952381
512234621466.25879.75
523087454071.2380952381-23197.2380952381
536870177129.2222222222-8428.22222222222
543572839346.9529411765-3618.95294117647
552901039346.9529411765-10336.9529411765
562311039346.9529411765-16236.9529411765
573884439346.9529411765-502.952941176467
582708439346.9529411765-12262.9529411765
593513939346.9529411765-4207.95294117647
605747639346.952941176518129.0470588235
613327739346.9529411765-6069.95294117647
623114139346.9529411765-8205.95294117647
636128139346.952941176521934.0470588235
642582039346.9529411765-13526.9529411765
652328439346.9529411765-16062.9529411765
663537839346.9529411765-3968.95294117647
677499054071.238095238120918.7619047619
682965354071.2380952381-24418.2380952381
696462239346.952941176525275.0470588235
70415721466.25-17309.25
712924539346.9529411765-10101.9529411765
725000839346.952941176510661.0470588235
735233854071.2380952381-1733.23809523809
741331039346.9529411765-26036.9529411765
759290154071.238095238138829.7619047619
761095639346.9529411765-28390.9529411765
773424154071.2380952381-19830.2380952381
787504354071.238095238120971.7619047619
792115239346.9529411765-18194.9529411765
804224939346.95294117652902.04705882353
814200539346.95294117652658.04705882353
824115277129.2222222222-35977.2222222222
831439921466.25-7067.25
842826339346.9529411765-11083.9529411765
851721521466.25-4251.25
864814039346.95294117658793.04705882353
876289739346.952941176523550.0470588235
882288339346.9529411765-16463.9529411765
894162239346.95294117652275.04705882353
904071539346.95294117651368.04705882353
916589739346.952941176526550.0470588235
927654254071.238095238122470.7619047619
933747739346.9529411765-1869.95294117647
945321639346.952941176513869.0470588235
954091121466.2519444.75
965702177129.2222222222-20108.2222222222
977311654071.238095238119044.7619047619
9838951399.941176470592495.05882352941
994660939346.95294117657262.04705882353
1002935139346.9529411765-9995.95294117647
10123251399.94117647059925.058823529412
1023174739346.9529411765-7599.95294117647
1033266539346.9529411765-6681.95294117647
1041924939346.9529411765-20097.9529411765
1051529239346.9529411765-24054.9529411765
106584221466.25-15624.25
1073399454071.2380952381-20077.2380952381
1081301839346.9529411765-26328.9529411765
10901399.94117647059-1399.94117647059
1109817739346.952941176558830.0470588235
1113794139346.9529411765-1405.95294117647
1123103239346.9529411765-8314.95294117647
1133268339346.9529411765-6663.95294117647
1143454521466.2513078.75
11501399.94117647059-1399.94117647059
11601399.94117647059-1399.94117647059
1172752539346.9529411765-11821.9529411765
1186685654071.238095238112784.7619047619
1192854939346.9529411765-10797.9529411765
1203861039346.9529411765-736.952941176467
12127811399.941176470591381.05882352941
1224121154071.2380952381-12860.2380952381
1232269839346.9529411765-16648.9529411765
1244119439346.95294117651847.04705882353
1253268921466.2511222.75
12657521399.941176470594352.05882352941
1272675739346.9529411765-12589.9529411765
1282252739346.9529411765-16819.9529411765
1294481039346.95294117655463.04705882353
13001399.94117647059-1399.94117647059
13101399.94117647059-1399.94117647059
13210067439346.952941176561327.0470588235
13301399.94117647059-1399.94117647059
1345778639346.952941176518439.0470588235
13501399.94117647059-1399.94117647059
13654441399.941176470594044.05882352941
13701399.94117647059-1399.94117647059
1382847039346.9529411765-10876.9529411765
1396184939346.952941176522502.0470588235
14001399.94117647059-1399.94117647059
14121791399.94117647059779.058823529412
142801921466.25-13447.25
1433964439346.9529411765297.047058823533
1442349439346.9529411765-15852.9529411765



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