Free Statistics

of Irreproducible Research!

Author's title

Author*Unverified author*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationMon, 10 Dec 2012 13:30:31 -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/2012/Dec/10/t1355164249upgdo5jqqj212xq.htm/, Retrieved Fri, 26 Apr 2024 11:20:52 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=198276, Retrieved Fri, 26 Apr 2024 11:20:52 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact74
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)] [WS 10: Recursive ...] [2011-12-10 19:57:04] [a9a952c1cbc7081c25fad93a34aab827]
-           [Recursive Partitioning (Regression Trees)] [] [2012-12-10 18:30:31] [d41d8cd98f00b204e9800998ecf8427e] [Current]
Feedback Forum

Post a new message
Dataseries X:
0	255202	64	92	34
0	135248	59	58	30
0	207223	64	62	42
1	189326	95	108	34
1	141365	46	55	25
0	65295	27	8	31
0	439387	103	134	29
0	33186	19	1	18
0	183696	51	64	30
0	186657	38	77	29
1	276696	99	86	42
1	194414	98	96	50
0	141409	59	44	33
1	306730	68	108	46
1	192691	74	63	38
1	333497	164	160	52
0	261835	59	109	32
1	263451	130	86	35
1	157448	49	93	25
1	232190	73	126	42
0	245725	64	110	40
0	388603	92	86	35
0	156540	34	50	25
0	156189	47	92	46
0	189726	106	123	39
0	192167	106	81	35
1	249893	122	93	38
1	236812	76	113	35
1	143160	47	52	28
0	259667	54	113	37
0	243020	68	113	40
0	176062	67	44	42
0	286683	79	123	44
1	87485	33	38	33
0	329737	88	111	38
1	247082	51	77	37
0	378463	108	102	41
1	191653	75	74	32
0	114673	31	33	17
0	301596	167	107	39
0	284195	73	108	33
1	155568	60	66	35
1	177306	67	69	32
1	144595	51	62	35
0	140319	73	50	45
1	405267	135	91	38
1	78800	42	20	26
1	201970	69	101	45
1	302705	101	129	44
1	164733	50	93	40
1	194221	68	89	33
0	24188	24	8	4
0	346142	288	80	41
0	65029	17	21	18
0	101097	64	30	14
1	253745	51	86	36
0	273513	77	116	49
1	282220	160	106	32
1	280928	120	132	37
1	214872	74	75	32
0	342048	127	139	43
0	273924	108	121	25
1	195726	92	57	42
1	231162	80	67	37
0	209798	61	45	33
1	201345	60	88	28
0	180231	118	79	31
1	204441	129	75	40
0	197813	67	114	32
1	136421	60	127	25
1	216092	59	86	42
1	73566	32	22	23
0	213998	70	67	42
1	181728	50	77	38
0	148758	51	105	34
0	308343	71	121	39
1	251437	78	88	32
0	202388	102	78	37
0	173286	56	122	34
0	155529	58	66	33
0	132672	41	58	25
1	390163	102	134	45
0	145905	66	30	26
0	228012	88	103	40
1	80953	25	49	8
0	130805	47	26	27
1	135163	49	67	32
1	333790	168	59	37
1	271806	95	95	50
1	164235	99	156	41
1	234092	80	74	37
0	207158	69	137	38
0	156583	57	37	28
0	242395	68	111	36
1	261601	70	58	32
1	178489	35	78	32
0	204221	44	88	33
1	268066	69	152	35
1	327622	133	130	58
1	361799	101	145	27
0	247131	107	108	45
1	265849	58	138	37
0	162336	162	62	32
1	43287	14	13	19
0	172244	68	89	22
0	189021	121	86	35
0	227681	43	116	36
0	269329	81	157	36
0	106503	56	28	23
1	117891	77	83	40
1	287201	59	72	40
0	266805	78	134	42
0	23623	11	12	1
1	174954	69	120	36
0	61857	25	23	11
1	144889	43	83	40
1	347988	103	126	34
0	21054	16	4	0
1	224051	46	71	27
1	31414	19	18	8
1	278660	107	98	35
0	209481	58	68	44
0	156870	75	44	40
1	112933	46	29	28
0	38214	34	16	8
0	166011	35	61	36
1	316044	73	117	47
1	181578	56	46	48
1	358903	72	129	45
1	275578	91	139	48
1	368796	106	136	49
1	172464	31	66	35
1	94381	35	42	32
1	250563	290	75	36
1	382499	154	97	42
1	118010	42	49	35
1	365575	122	127	42
1	147989	72	55	34
1	231681	46	101	41
0	193119	77	80	36
0	189020	108	29	32
0	341958	106	95	33
1	222060	79	120	35
0	173260	63	41	21
0	274787	91	128	42
1	130908	52	142	49
0	204009	75	88	33
0	262412	94	170	39
0	1	0	0	0
0	14688	10	4	0
0	98	1	0	0
0	455	2	0	0
1	0	0	0	0
0	0	0	0	0
1	195765	75	56	33
0	334258	129	121	47
0	0	0	0	0
0	203	4	0	0
0	7199	5	7	0
1	46660	20	12	5
1	17547	5	0	1
0	107465	38	37	38
1	969	2	0	0
1	179994	58	47	28




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time7 seconds
R Server'Sir Ronald Aylmer Fisher' @ fisher.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 7 seconds \tabularnewline
R Server & 'Sir Ronald Aylmer Fisher' @ fisher.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=198276&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]7 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Sir Ronald Aylmer Fisher' @ fisher.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=198276&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=198276&T=0

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time7 seconds
R Server'Sir Ronald Aylmer Fisher' @ fisher.wessa.net







Goodness of Fit
Correlation0.8661
R-squared0.7502
RMSE49695.4918

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8661[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7502[/C][/ROW]
[ROW][C]RMSE[/C][C]49695.4918[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=198276&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=198276&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.8661
R-squared0.7502
RMSE49695.4918







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1255202189475.63414634165726.3658536585
2135248189475.634146341-54227.6341463415
3207223189475.63414634117747.3658536585
4189326281991.019230769-92665.0192307692
5141365151925-10560
66529547292.318002.7
7439387281991.019230769157395.980769231
83318647292.3-14106.3
9183696189475.634146341-5779.63414634147
10186657189475.634146341-2818.63414634147
11276696281991.019230769-5295.01923076925
12194414281991.019230769-87577.0192307692
13141409151925-10516
14306730243250.36363636463479.6363636364
15192691189475.6341463413215.36585365853
16333497281991.01923076951505.9807692308
17261835243250.36363636418584.6363636364
18263451281991.019230769-18540.0192307692
19157448189475.634146341-32027.6341463415
20232190243250.363636364-11060.3636363636
21245725243250.3636363642474.63636363635
22388603281991.019230769106611.980769231
2315654096570.444444444459969.5555555556
24156189189475.634146341-33286.6341463415
25189726281991.019230769-92265.0192307692
26192167281991.019230769-89824.0192307692
27249893281991.019230769-32098.0192307692
28236812243250.363636364-6438.36363636365
29143160151925-8765
30259667243250.36363636416416.6363636364
31243020243250.363636364-230.363636363647
3217606215192524137
33286683281991.0192307694691.98076923075
348748596570.4444444444-9085.44444444444
35329737281991.01923076947745.9807692308
36247082189475.63414634157606.3658536585
37378463281991.01923076996471.9807692308
38191653189475.6341463412177.36585365853
3911467396570.444444444418102.5555555556
40301596281991.01923076919604.9807692308
41284195243250.36363636440944.6363636364
42155568189475.634146341-33907.6341463415
43177306189475.634146341-12169.6341463415
44144595189475.634146341-44880.6341463415
45140319151925-11606
46405267281991.019230769123275.980769231
477880096570.4444444444-17770.4444444444
48201970189475.63414634112494.3658536585
49302705281991.01923076920713.9807692308
50164733189475.634146341-24742.6341463415
51194221189475.6341463414745.36585365853
522418847292.3-23104.3
53346142281991.01923076964150.9807692308
546502947292.317736.7
55101097151925-50828
56253745189475.63414634164269.3658536585
57273513243250.36363636430262.6363636364
58282220281991.019230769228.980769230751
59280928281991.019230769-1063.01923076925
60214872189475.63414634125396.3658536585
61342048281991.01923076960056.9807692308
62273924281991.019230769-8067.01923076925
63195726281991.019230769-86265.0192307692
64231162281991.019230769-50829.0192307692
6520979815192557873
66201345189475.63414634111869.3658536585
67180231281991.019230769-101760.019230769
68204441281991.019230769-77550.0192307692
69197813243250.363636364-45437.3636363636
70136421243250.363636364-106829.363636364
71216092189475.63414634126616.3658536585
727356696570.4444444444-23004.4444444444
73213998189475.63414634124522.3658536585
74181728189475.634146341-7747.63414634147
75148758189475.634146341-40717.6341463415
76308343243250.36363636465092.6363636364
77251437281991.019230769-30554.0192307692
78202388281991.019230769-79603.0192307692
79173286243250.363636364-69964.3636363636
80155529189475.634146341-33946.6341463415
81132672189475.634146341-56803.6341463415
82390163281991.019230769108171.980769231
83145905151925-6020
84228012281991.019230769-53979.0192307692
858095347292.333660.7
86130805151925-21120
87135163189475.634146341-54312.6341463415
88333790281991.01923076951798.9807692308
89271806281991.019230769-10185.0192307692
90164235281991.019230769-117756.019230769
91234092281991.019230769-47899.0192307692
92207158243250.363636364-36092.3636363636
931565831519254658
94242395243250.363636364-855.363636363647
95261601189475.63414634172125.3658536585
96178489189475.634146341-10986.6341463415
97204221189475.63414634114745.3658536585
98268066243250.36363636424815.6363636364
99327622281991.01923076945630.9807692308
100361799281991.01923076979807.9807692308
101247131281991.019230769-34860.0192307692
102265849243250.36363636422598.6363636364
103162336281991.019230769-119655.019230769
1044328747292.3-4005.3
105172244189475.634146341-17231.6341463415
106189021281991.019230769-92970.0192307692
107227681243250.363636364-15569.3636363636
108269329281991.019230769-12662.0192307692
109106503151925-45422
110117891189475.634146341-71584.6341463415
111287201189475.63414634197725.3658536585
112266805281991.019230769-15186.0192307692
113236235398.5833333333318224.4166666667
114174954243250.363636364-68296.3636363636
1156185747292.314564.7
116144889189475.634146341-44586.6341463415
117347988281991.01923076965996.9807692308
1182105447292.3-26238.3
119224051189475.63414634134575.3658536585
1203141447292.3-15878.3
121278660281991.019230769-3331.01923076925
122209481189475.63414634120005.3658536585
1231568701519254945
124112933151925-38992
1253821496570.4444444444-58356.4444444444
126166011189475.634146341-23464.6341463415
127316044243250.36363636472793.6363636364
12818157815192529653
129358903243250.363636364115652.636363636
130275578281991.019230769-6413.01923076925
131368796281991.01923076986804.9807692308
132172464189475.634146341-17011.6341463415
1339438196570.4444444444-2189.44444444444
134250563281991.019230769-31428.0192307692
135382499281991.019230769100507.980769231
13611801096570.444444444421439.5555555556
137365575281991.01923076983583.9807692308
138147989151925-3936
139231681189475.63414634142205.3658536585
140193119189475.6341463413643.36585365853
14118902015192537095
142341958281991.01923076959966.9807692308
143222060281991.019230769-59931.0192307692
14417326015192521335
145274787281991.019230769-7204.01923076925
146130908243250.363636364-112342.363636364
147204009189475.63414634114533.3658536585
148262412281991.019230769-19579.0192307692
14915398.58333333333-5397.58333333333
150146885398.583333333339289.41666666667
151985398.58333333333-5300.58333333333
1524555398.58333333333-4943.58333333333
15305398.58333333333-5398.58333333333
15405398.58333333333-5398.58333333333
155195765189475.6341463416289.36585365853
156334258281991.01923076952266.9807692308
15705398.58333333333-5398.58333333333
1582035398.58333333333-5195.58333333333
15971995398.583333333331800.41666666667
1604666047292.3-632.300000000003
161175475398.5833333333312148.4166666667
16210746596570.444444444410894.5555555556
1639695398.58333333333-4429.58333333333
16417999415192528069

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 255202 & 189475.634146341 & 65726.3658536585 \tabularnewline
2 & 135248 & 189475.634146341 & -54227.6341463415 \tabularnewline
3 & 207223 & 189475.634146341 & 17747.3658536585 \tabularnewline
4 & 189326 & 281991.019230769 & -92665.0192307692 \tabularnewline
5 & 141365 & 151925 & -10560 \tabularnewline
6 & 65295 & 47292.3 & 18002.7 \tabularnewline
7 & 439387 & 281991.019230769 & 157395.980769231 \tabularnewline
8 & 33186 & 47292.3 & -14106.3 \tabularnewline
9 & 183696 & 189475.634146341 & -5779.63414634147 \tabularnewline
10 & 186657 & 189475.634146341 & -2818.63414634147 \tabularnewline
11 & 276696 & 281991.019230769 & -5295.01923076925 \tabularnewline
12 & 194414 & 281991.019230769 & -87577.0192307692 \tabularnewline
13 & 141409 & 151925 & -10516 \tabularnewline
14 & 306730 & 243250.363636364 & 63479.6363636364 \tabularnewline
15 & 192691 & 189475.634146341 & 3215.36585365853 \tabularnewline
16 & 333497 & 281991.019230769 & 51505.9807692308 \tabularnewline
17 & 261835 & 243250.363636364 & 18584.6363636364 \tabularnewline
18 & 263451 & 281991.019230769 & -18540.0192307692 \tabularnewline
19 & 157448 & 189475.634146341 & -32027.6341463415 \tabularnewline
20 & 232190 & 243250.363636364 & -11060.3636363636 \tabularnewline
21 & 245725 & 243250.363636364 & 2474.63636363635 \tabularnewline
22 & 388603 & 281991.019230769 & 106611.980769231 \tabularnewline
23 & 156540 & 96570.4444444444 & 59969.5555555556 \tabularnewline
24 & 156189 & 189475.634146341 & -33286.6341463415 \tabularnewline
25 & 189726 & 281991.019230769 & -92265.0192307692 \tabularnewline
26 & 192167 & 281991.019230769 & -89824.0192307692 \tabularnewline
27 & 249893 & 281991.019230769 & -32098.0192307692 \tabularnewline
28 & 236812 & 243250.363636364 & -6438.36363636365 \tabularnewline
29 & 143160 & 151925 & -8765 \tabularnewline
30 & 259667 & 243250.363636364 & 16416.6363636364 \tabularnewline
31 & 243020 & 243250.363636364 & -230.363636363647 \tabularnewline
32 & 176062 & 151925 & 24137 \tabularnewline
33 & 286683 & 281991.019230769 & 4691.98076923075 \tabularnewline
34 & 87485 & 96570.4444444444 & -9085.44444444444 \tabularnewline
35 & 329737 & 281991.019230769 & 47745.9807692308 \tabularnewline
36 & 247082 & 189475.634146341 & 57606.3658536585 \tabularnewline
37 & 378463 & 281991.019230769 & 96471.9807692308 \tabularnewline
38 & 191653 & 189475.634146341 & 2177.36585365853 \tabularnewline
39 & 114673 & 96570.4444444444 & 18102.5555555556 \tabularnewline
40 & 301596 & 281991.019230769 & 19604.9807692308 \tabularnewline
41 & 284195 & 243250.363636364 & 40944.6363636364 \tabularnewline
42 & 155568 & 189475.634146341 & -33907.6341463415 \tabularnewline
43 & 177306 & 189475.634146341 & -12169.6341463415 \tabularnewline
44 & 144595 & 189475.634146341 & -44880.6341463415 \tabularnewline
45 & 140319 & 151925 & -11606 \tabularnewline
46 & 405267 & 281991.019230769 & 123275.980769231 \tabularnewline
47 & 78800 & 96570.4444444444 & -17770.4444444444 \tabularnewline
48 & 201970 & 189475.634146341 & 12494.3658536585 \tabularnewline
49 & 302705 & 281991.019230769 & 20713.9807692308 \tabularnewline
50 & 164733 & 189475.634146341 & -24742.6341463415 \tabularnewline
51 & 194221 & 189475.634146341 & 4745.36585365853 \tabularnewline
52 & 24188 & 47292.3 & -23104.3 \tabularnewline
53 & 346142 & 281991.019230769 & 64150.9807692308 \tabularnewline
54 & 65029 & 47292.3 & 17736.7 \tabularnewline
55 & 101097 & 151925 & -50828 \tabularnewline
56 & 253745 & 189475.634146341 & 64269.3658536585 \tabularnewline
57 & 273513 & 243250.363636364 & 30262.6363636364 \tabularnewline
58 & 282220 & 281991.019230769 & 228.980769230751 \tabularnewline
59 & 280928 & 281991.019230769 & -1063.01923076925 \tabularnewline
60 & 214872 & 189475.634146341 & 25396.3658536585 \tabularnewline
61 & 342048 & 281991.019230769 & 60056.9807692308 \tabularnewline
62 & 273924 & 281991.019230769 & -8067.01923076925 \tabularnewline
63 & 195726 & 281991.019230769 & -86265.0192307692 \tabularnewline
64 & 231162 & 281991.019230769 & -50829.0192307692 \tabularnewline
65 & 209798 & 151925 & 57873 \tabularnewline
66 & 201345 & 189475.634146341 & 11869.3658536585 \tabularnewline
67 & 180231 & 281991.019230769 & -101760.019230769 \tabularnewline
68 & 204441 & 281991.019230769 & -77550.0192307692 \tabularnewline
69 & 197813 & 243250.363636364 & -45437.3636363636 \tabularnewline
70 & 136421 & 243250.363636364 & -106829.363636364 \tabularnewline
71 & 216092 & 189475.634146341 & 26616.3658536585 \tabularnewline
72 & 73566 & 96570.4444444444 & -23004.4444444444 \tabularnewline
73 & 213998 & 189475.634146341 & 24522.3658536585 \tabularnewline
74 & 181728 & 189475.634146341 & -7747.63414634147 \tabularnewline
75 & 148758 & 189475.634146341 & -40717.6341463415 \tabularnewline
76 & 308343 & 243250.363636364 & 65092.6363636364 \tabularnewline
77 & 251437 & 281991.019230769 & -30554.0192307692 \tabularnewline
78 & 202388 & 281991.019230769 & -79603.0192307692 \tabularnewline
79 & 173286 & 243250.363636364 & -69964.3636363636 \tabularnewline
80 & 155529 & 189475.634146341 & -33946.6341463415 \tabularnewline
81 & 132672 & 189475.634146341 & -56803.6341463415 \tabularnewline
82 & 390163 & 281991.019230769 & 108171.980769231 \tabularnewline
83 & 145905 & 151925 & -6020 \tabularnewline
84 & 228012 & 281991.019230769 & -53979.0192307692 \tabularnewline
85 & 80953 & 47292.3 & 33660.7 \tabularnewline
86 & 130805 & 151925 & -21120 \tabularnewline
87 & 135163 & 189475.634146341 & -54312.6341463415 \tabularnewline
88 & 333790 & 281991.019230769 & 51798.9807692308 \tabularnewline
89 & 271806 & 281991.019230769 & -10185.0192307692 \tabularnewline
90 & 164235 & 281991.019230769 & -117756.019230769 \tabularnewline
91 & 234092 & 281991.019230769 & -47899.0192307692 \tabularnewline
92 & 207158 & 243250.363636364 & -36092.3636363636 \tabularnewline
93 & 156583 & 151925 & 4658 \tabularnewline
94 & 242395 & 243250.363636364 & -855.363636363647 \tabularnewline
95 & 261601 & 189475.634146341 & 72125.3658536585 \tabularnewline
96 & 178489 & 189475.634146341 & -10986.6341463415 \tabularnewline
97 & 204221 & 189475.634146341 & 14745.3658536585 \tabularnewline
98 & 268066 & 243250.363636364 & 24815.6363636364 \tabularnewline
99 & 327622 & 281991.019230769 & 45630.9807692308 \tabularnewline
100 & 361799 & 281991.019230769 & 79807.9807692308 \tabularnewline
101 & 247131 & 281991.019230769 & -34860.0192307692 \tabularnewline
102 & 265849 & 243250.363636364 & 22598.6363636364 \tabularnewline
103 & 162336 & 281991.019230769 & -119655.019230769 \tabularnewline
104 & 43287 & 47292.3 & -4005.3 \tabularnewline
105 & 172244 & 189475.634146341 & -17231.6341463415 \tabularnewline
106 & 189021 & 281991.019230769 & -92970.0192307692 \tabularnewline
107 & 227681 & 243250.363636364 & -15569.3636363636 \tabularnewline
108 & 269329 & 281991.019230769 & -12662.0192307692 \tabularnewline
109 & 106503 & 151925 & -45422 \tabularnewline
110 & 117891 & 189475.634146341 & -71584.6341463415 \tabularnewline
111 & 287201 & 189475.634146341 & 97725.3658536585 \tabularnewline
112 & 266805 & 281991.019230769 & -15186.0192307692 \tabularnewline
113 & 23623 & 5398.58333333333 & 18224.4166666667 \tabularnewline
114 & 174954 & 243250.363636364 & -68296.3636363636 \tabularnewline
115 & 61857 & 47292.3 & 14564.7 \tabularnewline
116 & 144889 & 189475.634146341 & -44586.6341463415 \tabularnewline
117 & 347988 & 281991.019230769 & 65996.9807692308 \tabularnewline
118 & 21054 & 47292.3 & -26238.3 \tabularnewline
119 & 224051 & 189475.634146341 & 34575.3658536585 \tabularnewline
120 & 31414 & 47292.3 & -15878.3 \tabularnewline
121 & 278660 & 281991.019230769 & -3331.01923076925 \tabularnewline
122 & 209481 & 189475.634146341 & 20005.3658536585 \tabularnewline
123 & 156870 & 151925 & 4945 \tabularnewline
124 & 112933 & 151925 & -38992 \tabularnewline
125 & 38214 & 96570.4444444444 & -58356.4444444444 \tabularnewline
126 & 166011 & 189475.634146341 & -23464.6341463415 \tabularnewline
127 & 316044 & 243250.363636364 & 72793.6363636364 \tabularnewline
128 & 181578 & 151925 & 29653 \tabularnewline
129 & 358903 & 243250.363636364 & 115652.636363636 \tabularnewline
130 & 275578 & 281991.019230769 & -6413.01923076925 \tabularnewline
131 & 368796 & 281991.019230769 & 86804.9807692308 \tabularnewline
132 & 172464 & 189475.634146341 & -17011.6341463415 \tabularnewline
133 & 94381 & 96570.4444444444 & -2189.44444444444 \tabularnewline
134 & 250563 & 281991.019230769 & -31428.0192307692 \tabularnewline
135 & 382499 & 281991.019230769 & 100507.980769231 \tabularnewline
136 & 118010 & 96570.4444444444 & 21439.5555555556 \tabularnewline
137 & 365575 & 281991.019230769 & 83583.9807692308 \tabularnewline
138 & 147989 & 151925 & -3936 \tabularnewline
139 & 231681 & 189475.634146341 & 42205.3658536585 \tabularnewline
140 & 193119 & 189475.634146341 & 3643.36585365853 \tabularnewline
141 & 189020 & 151925 & 37095 \tabularnewline
142 & 341958 & 281991.019230769 & 59966.9807692308 \tabularnewline
143 & 222060 & 281991.019230769 & -59931.0192307692 \tabularnewline
144 & 173260 & 151925 & 21335 \tabularnewline
145 & 274787 & 281991.019230769 & -7204.01923076925 \tabularnewline
146 & 130908 & 243250.363636364 & -112342.363636364 \tabularnewline
147 & 204009 & 189475.634146341 & 14533.3658536585 \tabularnewline
148 & 262412 & 281991.019230769 & -19579.0192307692 \tabularnewline
149 & 1 & 5398.58333333333 & -5397.58333333333 \tabularnewline
150 & 14688 & 5398.58333333333 & 9289.41666666667 \tabularnewline
151 & 98 & 5398.58333333333 & -5300.58333333333 \tabularnewline
152 & 455 & 5398.58333333333 & -4943.58333333333 \tabularnewline
153 & 0 & 5398.58333333333 & -5398.58333333333 \tabularnewline
154 & 0 & 5398.58333333333 & -5398.58333333333 \tabularnewline
155 & 195765 & 189475.634146341 & 6289.36585365853 \tabularnewline
156 & 334258 & 281991.019230769 & 52266.9807692308 \tabularnewline
157 & 0 & 5398.58333333333 & -5398.58333333333 \tabularnewline
158 & 203 & 5398.58333333333 & -5195.58333333333 \tabularnewline
159 & 7199 & 5398.58333333333 & 1800.41666666667 \tabularnewline
160 & 46660 & 47292.3 & -632.300000000003 \tabularnewline
161 & 17547 & 5398.58333333333 & 12148.4166666667 \tabularnewline
162 & 107465 & 96570.4444444444 & 10894.5555555556 \tabularnewline
163 & 969 & 5398.58333333333 & -4429.58333333333 \tabularnewline
164 & 179994 & 151925 & 28069 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=198276&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]255202[/C][C]189475.634146341[/C][C]65726.3658536585[/C][/ROW]
[ROW][C]2[/C][C]135248[/C][C]189475.634146341[/C][C]-54227.6341463415[/C][/ROW]
[ROW][C]3[/C][C]207223[/C][C]189475.634146341[/C][C]17747.3658536585[/C][/ROW]
[ROW][C]4[/C][C]189326[/C][C]281991.019230769[/C][C]-92665.0192307692[/C][/ROW]
[ROW][C]5[/C][C]141365[/C][C]151925[/C][C]-10560[/C][/ROW]
[ROW][C]6[/C][C]65295[/C][C]47292.3[/C][C]18002.7[/C][/ROW]
[ROW][C]7[/C][C]439387[/C][C]281991.019230769[/C][C]157395.980769231[/C][/ROW]
[ROW][C]8[/C][C]33186[/C][C]47292.3[/C][C]-14106.3[/C][/ROW]
[ROW][C]9[/C][C]183696[/C][C]189475.634146341[/C][C]-5779.63414634147[/C][/ROW]
[ROW][C]10[/C][C]186657[/C][C]189475.634146341[/C][C]-2818.63414634147[/C][/ROW]
[ROW][C]11[/C][C]276696[/C][C]281991.019230769[/C][C]-5295.01923076925[/C][/ROW]
[ROW][C]12[/C][C]194414[/C][C]281991.019230769[/C][C]-87577.0192307692[/C][/ROW]
[ROW][C]13[/C][C]141409[/C][C]151925[/C][C]-10516[/C][/ROW]
[ROW][C]14[/C][C]306730[/C][C]243250.363636364[/C][C]63479.6363636364[/C][/ROW]
[ROW][C]15[/C][C]192691[/C][C]189475.634146341[/C][C]3215.36585365853[/C][/ROW]
[ROW][C]16[/C][C]333497[/C][C]281991.019230769[/C][C]51505.9807692308[/C][/ROW]
[ROW][C]17[/C][C]261835[/C][C]243250.363636364[/C][C]18584.6363636364[/C][/ROW]
[ROW][C]18[/C][C]263451[/C][C]281991.019230769[/C][C]-18540.0192307692[/C][/ROW]
[ROW][C]19[/C][C]157448[/C][C]189475.634146341[/C][C]-32027.6341463415[/C][/ROW]
[ROW][C]20[/C][C]232190[/C][C]243250.363636364[/C][C]-11060.3636363636[/C][/ROW]
[ROW][C]21[/C][C]245725[/C][C]243250.363636364[/C][C]2474.63636363635[/C][/ROW]
[ROW][C]22[/C][C]388603[/C][C]281991.019230769[/C][C]106611.980769231[/C][/ROW]
[ROW][C]23[/C][C]156540[/C][C]96570.4444444444[/C][C]59969.5555555556[/C][/ROW]
[ROW][C]24[/C][C]156189[/C][C]189475.634146341[/C][C]-33286.6341463415[/C][/ROW]
[ROW][C]25[/C][C]189726[/C][C]281991.019230769[/C][C]-92265.0192307692[/C][/ROW]
[ROW][C]26[/C][C]192167[/C][C]281991.019230769[/C][C]-89824.0192307692[/C][/ROW]
[ROW][C]27[/C][C]249893[/C][C]281991.019230769[/C][C]-32098.0192307692[/C][/ROW]
[ROW][C]28[/C][C]236812[/C][C]243250.363636364[/C][C]-6438.36363636365[/C][/ROW]
[ROW][C]29[/C][C]143160[/C][C]151925[/C][C]-8765[/C][/ROW]
[ROW][C]30[/C][C]259667[/C][C]243250.363636364[/C][C]16416.6363636364[/C][/ROW]
[ROW][C]31[/C][C]243020[/C][C]243250.363636364[/C][C]-230.363636363647[/C][/ROW]
[ROW][C]32[/C][C]176062[/C][C]151925[/C][C]24137[/C][/ROW]
[ROW][C]33[/C][C]286683[/C][C]281991.019230769[/C][C]4691.98076923075[/C][/ROW]
[ROW][C]34[/C][C]87485[/C][C]96570.4444444444[/C][C]-9085.44444444444[/C][/ROW]
[ROW][C]35[/C][C]329737[/C][C]281991.019230769[/C][C]47745.9807692308[/C][/ROW]
[ROW][C]36[/C][C]247082[/C][C]189475.634146341[/C][C]57606.3658536585[/C][/ROW]
[ROW][C]37[/C][C]378463[/C][C]281991.019230769[/C][C]96471.9807692308[/C][/ROW]
[ROW][C]38[/C][C]191653[/C][C]189475.634146341[/C][C]2177.36585365853[/C][/ROW]
[ROW][C]39[/C][C]114673[/C][C]96570.4444444444[/C][C]18102.5555555556[/C][/ROW]
[ROW][C]40[/C][C]301596[/C][C]281991.019230769[/C][C]19604.9807692308[/C][/ROW]
[ROW][C]41[/C][C]284195[/C][C]243250.363636364[/C][C]40944.6363636364[/C][/ROW]
[ROW][C]42[/C][C]155568[/C][C]189475.634146341[/C][C]-33907.6341463415[/C][/ROW]
[ROW][C]43[/C][C]177306[/C][C]189475.634146341[/C][C]-12169.6341463415[/C][/ROW]
[ROW][C]44[/C][C]144595[/C][C]189475.634146341[/C][C]-44880.6341463415[/C][/ROW]
[ROW][C]45[/C][C]140319[/C][C]151925[/C][C]-11606[/C][/ROW]
[ROW][C]46[/C][C]405267[/C][C]281991.019230769[/C][C]123275.980769231[/C][/ROW]
[ROW][C]47[/C][C]78800[/C][C]96570.4444444444[/C][C]-17770.4444444444[/C][/ROW]
[ROW][C]48[/C][C]201970[/C][C]189475.634146341[/C][C]12494.3658536585[/C][/ROW]
[ROW][C]49[/C][C]302705[/C][C]281991.019230769[/C][C]20713.9807692308[/C][/ROW]
[ROW][C]50[/C][C]164733[/C][C]189475.634146341[/C][C]-24742.6341463415[/C][/ROW]
[ROW][C]51[/C][C]194221[/C][C]189475.634146341[/C][C]4745.36585365853[/C][/ROW]
[ROW][C]52[/C][C]24188[/C][C]47292.3[/C][C]-23104.3[/C][/ROW]
[ROW][C]53[/C][C]346142[/C][C]281991.019230769[/C][C]64150.9807692308[/C][/ROW]
[ROW][C]54[/C][C]65029[/C][C]47292.3[/C][C]17736.7[/C][/ROW]
[ROW][C]55[/C][C]101097[/C][C]151925[/C][C]-50828[/C][/ROW]
[ROW][C]56[/C][C]253745[/C][C]189475.634146341[/C][C]64269.3658536585[/C][/ROW]
[ROW][C]57[/C][C]273513[/C][C]243250.363636364[/C][C]30262.6363636364[/C][/ROW]
[ROW][C]58[/C][C]282220[/C][C]281991.019230769[/C][C]228.980769230751[/C][/ROW]
[ROW][C]59[/C][C]280928[/C][C]281991.019230769[/C][C]-1063.01923076925[/C][/ROW]
[ROW][C]60[/C][C]214872[/C][C]189475.634146341[/C][C]25396.3658536585[/C][/ROW]
[ROW][C]61[/C][C]342048[/C][C]281991.019230769[/C][C]60056.9807692308[/C][/ROW]
[ROW][C]62[/C][C]273924[/C][C]281991.019230769[/C][C]-8067.01923076925[/C][/ROW]
[ROW][C]63[/C][C]195726[/C][C]281991.019230769[/C][C]-86265.0192307692[/C][/ROW]
[ROW][C]64[/C][C]231162[/C][C]281991.019230769[/C][C]-50829.0192307692[/C][/ROW]
[ROW][C]65[/C][C]209798[/C][C]151925[/C][C]57873[/C][/ROW]
[ROW][C]66[/C][C]201345[/C][C]189475.634146341[/C][C]11869.3658536585[/C][/ROW]
[ROW][C]67[/C][C]180231[/C][C]281991.019230769[/C][C]-101760.019230769[/C][/ROW]
[ROW][C]68[/C][C]204441[/C][C]281991.019230769[/C][C]-77550.0192307692[/C][/ROW]
[ROW][C]69[/C][C]197813[/C][C]243250.363636364[/C][C]-45437.3636363636[/C][/ROW]
[ROW][C]70[/C][C]136421[/C][C]243250.363636364[/C][C]-106829.363636364[/C][/ROW]
[ROW][C]71[/C][C]216092[/C][C]189475.634146341[/C][C]26616.3658536585[/C][/ROW]
[ROW][C]72[/C][C]73566[/C][C]96570.4444444444[/C][C]-23004.4444444444[/C][/ROW]
[ROW][C]73[/C][C]213998[/C][C]189475.634146341[/C][C]24522.3658536585[/C][/ROW]
[ROW][C]74[/C][C]181728[/C][C]189475.634146341[/C][C]-7747.63414634147[/C][/ROW]
[ROW][C]75[/C][C]148758[/C][C]189475.634146341[/C][C]-40717.6341463415[/C][/ROW]
[ROW][C]76[/C][C]308343[/C][C]243250.363636364[/C][C]65092.6363636364[/C][/ROW]
[ROW][C]77[/C][C]251437[/C][C]281991.019230769[/C][C]-30554.0192307692[/C][/ROW]
[ROW][C]78[/C][C]202388[/C][C]281991.019230769[/C][C]-79603.0192307692[/C][/ROW]
[ROW][C]79[/C][C]173286[/C][C]243250.363636364[/C][C]-69964.3636363636[/C][/ROW]
[ROW][C]80[/C][C]155529[/C][C]189475.634146341[/C][C]-33946.6341463415[/C][/ROW]
[ROW][C]81[/C][C]132672[/C][C]189475.634146341[/C][C]-56803.6341463415[/C][/ROW]
[ROW][C]82[/C][C]390163[/C][C]281991.019230769[/C][C]108171.980769231[/C][/ROW]
[ROW][C]83[/C][C]145905[/C][C]151925[/C][C]-6020[/C][/ROW]
[ROW][C]84[/C][C]228012[/C][C]281991.019230769[/C][C]-53979.0192307692[/C][/ROW]
[ROW][C]85[/C][C]80953[/C][C]47292.3[/C][C]33660.7[/C][/ROW]
[ROW][C]86[/C][C]130805[/C][C]151925[/C][C]-21120[/C][/ROW]
[ROW][C]87[/C][C]135163[/C][C]189475.634146341[/C][C]-54312.6341463415[/C][/ROW]
[ROW][C]88[/C][C]333790[/C][C]281991.019230769[/C][C]51798.9807692308[/C][/ROW]
[ROW][C]89[/C][C]271806[/C][C]281991.019230769[/C][C]-10185.0192307692[/C][/ROW]
[ROW][C]90[/C][C]164235[/C][C]281991.019230769[/C][C]-117756.019230769[/C][/ROW]
[ROW][C]91[/C][C]234092[/C][C]281991.019230769[/C][C]-47899.0192307692[/C][/ROW]
[ROW][C]92[/C][C]207158[/C][C]243250.363636364[/C][C]-36092.3636363636[/C][/ROW]
[ROW][C]93[/C][C]156583[/C][C]151925[/C][C]4658[/C][/ROW]
[ROW][C]94[/C][C]242395[/C][C]243250.363636364[/C][C]-855.363636363647[/C][/ROW]
[ROW][C]95[/C][C]261601[/C][C]189475.634146341[/C][C]72125.3658536585[/C][/ROW]
[ROW][C]96[/C][C]178489[/C][C]189475.634146341[/C][C]-10986.6341463415[/C][/ROW]
[ROW][C]97[/C][C]204221[/C][C]189475.634146341[/C][C]14745.3658536585[/C][/ROW]
[ROW][C]98[/C][C]268066[/C][C]243250.363636364[/C][C]24815.6363636364[/C][/ROW]
[ROW][C]99[/C][C]327622[/C][C]281991.019230769[/C][C]45630.9807692308[/C][/ROW]
[ROW][C]100[/C][C]361799[/C][C]281991.019230769[/C][C]79807.9807692308[/C][/ROW]
[ROW][C]101[/C][C]247131[/C][C]281991.019230769[/C][C]-34860.0192307692[/C][/ROW]
[ROW][C]102[/C][C]265849[/C][C]243250.363636364[/C][C]22598.6363636364[/C][/ROW]
[ROW][C]103[/C][C]162336[/C][C]281991.019230769[/C][C]-119655.019230769[/C][/ROW]
[ROW][C]104[/C][C]43287[/C][C]47292.3[/C][C]-4005.3[/C][/ROW]
[ROW][C]105[/C][C]172244[/C][C]189475.634146341[/C][C]-17231.6341463415[/C][/ROW]
[ROW][C]106[/C][C]189021[/C][C]281991.019230769[/C][C]-92970.0192307692[/C][/ROW]
[ROW][C]107[/C][C]227681[/C][C]243250.363636364[/C][C]-15569.3636363636[/C][/ROW]
[ROW][C]108[/C][C]269329[/C][C]281991.019230769[/C][C]-12662.0192307692[/C][/ROW]
[ROW][C]109[/C][C]106503[/C][C]151925[/C][C]-45422[/C][/ROW]
[ROW][C]110[/C][C]117891[/C][C]189475.634146341[/C][C]-71584.6341463415[/C][/ROW]
[ROW][C]111[/C][C]287201[/C][C]189475.634146341[/C][C]97725.3658536585[/C][/ROW]
[ROW][C]112[/C][C]266805[/C][C]281991.019230769[/C][C]-15186.0192307692[/C][/ROW]
[ROW][C]113[/C][C]23623[/C][C]5398.58333333333[/C][C]18224.4166666667[/C][/ROW]
[ROW][C]114[/C][C]174954[/C][C]243250.363636364[/C][C]-68296.3636363636[/C][/ROW]
[ROW][C]115[/C][C]61857[/C][C]47292.3[/C][C]14564.7[/C][/ROW]
[ROW][C]116[/C][C]144889[/C][C]189475.634146341[/C][C]-44586.6341463415[/C][/ROW]
[ROW][C]117[/C][C]347988[/C][C]281991.019230769[/C][C]65996.9807692308[/C][/ROW]
[ROW][C]118[/C][C]21054[/C][C]47292.3[/C][C]-26238.3[/C][/ROW]
[ROW][C]119[/C][C]224051[/C][C]189475.634146341[/C][C]34575.3658536585[/C][/ROW]
[ROW][C]120[/C][C]31414[/C][C]47292.3[/C][C]-15878.3[/C][/ROW]
[ROW][C]121[/C][C]278660[/C][C]281991.019230769[/C][C]-3331.01923076925[/C][/ROW]
[ROW][C]122[/C][C]209481[/C][C]189475.634146341[/C][C]20005.3658536585[/C][/ROW]
[ROW][C]123[/C][C]156870[/C][C]151925[/C][C]4945[/C][/ROW]
[ROW][C]124[/C][C]112933[/C][C]151925[/C][C]-38992[/C][/ROW]
[ROW][C]125[/C][C]38214[/C][C]96570.4444444444[/C][C]-58356.4444444444[/C][/ROW]
[ROW][C]126[/C][C]166011[/C][C]189475.634146341[/C][C]-23464.6341463415[/C][/ROW]
[ROW][C]127[/C][C]316044[/C][C]243250.363636364[/C][C]72793.6363636364[/C][/ROW]
[ROW][C]128[/C][C]181578[/C][C]151925[/C][C]29653[/C][/ROW]
[ROW][C]129[/C][C]358903[/C][C]243250.363636364[/C][C]115652.636363636[/C][/ROW]
[ROW][C]130[/C][C]275578[/C][C]281991.019230769[/C][C]-6413.01923076925[/C][/ROW]
[ROW][C]131[/C][C]368796[/C][C]281991.019230769[/C][C]86804.9807692308[/C][/ROW]
[ROW][C]132[/C][C]172464[/C][C]189475.634146341[/C][C]-17011.6341463415[/C][/ROW]
[ROW][C]133[/C][C]94381[/C][C]96570.4444444444[/C][C]-2189.44444444444[/C][/ROW]
[ROW][C]134[/C][C]250563[/C][C]281991.019230769[/C][C]-31428.0192307692[/C][/ROW]
[ROW][C]135[/C][C]382499[/C][C]281991.019230769[/C][C]100507.980769231[/C][/ROW]
[ROW][C]136[/C][C]118010[/C][C]96570.4444444444[/C][C]21439.5555555556[/C][/ROW]
[ROW][C]137[/C][C]365575[/C][C]281991.019230769[/C][C]83583.9807692308[/C][/ROW]
[ROW][C]138[/C][C]147989[/C][C]151925[/C][C]-3936[/C][/ROW]
[ROW][C]139[/C][C]231681[/C][C]189475.634146341[/C][C]42205.3658536585[/C][/ROW]
[ROW][C]140[/C][C]193119[/C][C]189475.634146341[/C][C]3643.36585365853[/C][/ROW]
[ROW][C]141[/C][C]189020[/C][C]151925[/C][C]37095[/C][/ROW]
[ROW][C]142[/C][C]341958[/C][C]281991.019230769[/C][C]59966.9807692308[/C][/ROW]
[ROW][C]143[/C][C]222060[/C][C]281991.019230769[/C][C]-59931.0192307692[/C][/ROW]
[ROW][C]144[/C][C]173260[/C][C]151925[/C][C]21335[/C][/ROW]
[ROW][C]145[/C][C]274787[/C][C]281991.019230769[/C][C]-7204.01923076925[/C][/ROW]
[ROW][C]146[/C][C]130908[/C][C]243250.363636364[/C][C]-112342.363636364[/C][/ROW]
[ROW][C]147[/C][C]204009[/C][C]189475.634146341[/C][C]14533.3658536585[/C][/ROW]
[ROW][C]148[/C][C]262412[/C][C]281991.019230769[/C][C]-19579.0192307692[/C][/ROW]
[ROW][C]149[/C][C]1[/C][C]5398.58333333333[/C][C]-5397.58333333333[/C][/ROW]
[ROW][C]150[/C][C]14688[/C][C]5398.58333333333[/C][C]9289.41666666667[/C][/ROW]
[ROW][C]151[/C][C]98[/C][C]5398.58333333333[/C][C]-5300.58333333333[/C][/ROW]
[ROW][C]152[/C][C]455[/C][C]5398.58333333333[/C][C]-4943.58333333333[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]5398.58333333333[/C][C]-5398.58333333333[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]5398.58333333333[/C][C]-5398.58333333333[/C][/ROW]
[ROW][C]155[/C][C]195765[/C][C]189475.634146341[/C][C]6289.36585365853[/C][/ROW]
[ROW][C]156[/C][C]334258[/C][C]281991.019230769[/C][C]52266.9807692308[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]5398.58333333333[/C][C]-5398.58333333333[/C][/ROW]
[ROW][C]158[/C][C]203[/C][C]5398.58333333333[/C][C]-5195.58333333333[/C][/ROW]
[ROW][C]159[/C][C]7199[/C][C]5398.58333333333[/C][C]1800.41666666667[/C][/ROW]
[ROW][C]160[/C][C]46660[/C][C]47292.3[/C][C]-632.300000000003[/C][/ROW]
[ROW][C]161[/C][C]17547[/C][C]5398.58333333333[/C][C]12148.4166666667[/C][/ROW]
[ROW][C]162[/C][C]107465[/C][C]96570.4444444444[/C][C]10894.5555555556[/C][/ROW]
[ROW][C]163[/C][C]969[/C][C]5398.58333333333[/C][C]-4429.58333333333[/C][/ROW]
[ROW][C]164[/C][C]179994[/C][C]151925[/C][C]28069[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=198276&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=198276&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
1255202189475.63414634165726.3658536585
2135248189475.634146341-54227.6341463415
3207223189475.63414634117747.3658536585
4189326281991.019230769-92665.0192307692
5141365151925-10560
66529547292.318002.7
7439387281991.019230769157395.980769231
83318647292.3-14106.3
9183696189475.634146341-5779.63414634147
10186657189475.634146341-2818.63414634147
11276696281991.019230769-5295.01923076925
12194414281991.019230769-87577.0192307692
13141409151925-10516
14306730243250.36363636463479.6363636364
15192691189475.6341463413215.36585365853
16333497281991.01923076951505.9807692308
17261835243250.36363636418584.6363636364
18263451281991.019230769-18540.0192307692
19157448189475.634146341-32027.6341463415
20232190243250.363636364-11060.3636363636
21245725243250.3636363642474.63636363635
22388603281991.019230769106611.980769231
2315654096570.444444444459969.5555555556
24156189189475.634146341-33286.6341463415
25189726281991.019230769-92265.0192307692
26192167281991.019230769-89824.0192307692
27249893281991.019230769-32098.0192307692
28236812243250.363636364-6438.36363636365
29143160151925-8765
30259667243250.36363636416416.6363636364
31243020243250.363636364-230.363636363647
3217606215192524137
33286683281991.0192307694691.98076923075
348748596570.4444444444-9085.44444444444
35329737281991.01923076947745.9807692308
36247082189475.63414634157606.3658536585
37378463281991.01923076996471.9807692308
38191653189475.6341463412177.36585365853
3911467396570.444444444418102.5555555556
40301596281991.01923076919604.9807692308
41284195243250.36363636440944.6363636364
42155568189475.634146341-33907.6341463415
43177306189475.634146341-12169.6341463415
44144595189475.634146341-44880.6341463415
45140319151925-11606
46405267281991.019230769123275.980769231
477880096570.4444444444-17770.4444444444
48201970189475.63414634112494.3658536585
49302705281991.01923076920713.9807692308
50164733189475.634146341-24742.6341463415
51194221189475.6341463414745.36585365853
522418847292.3-23104.3
53346142281991.01923076964150.9807692308
546502947292.317736.7
55101097151925-50828
56253745189475.63414634164269.3658536585
57273513243250.36363636430262.6363636364
58282220281991.019230769228.980769230751
59280928281991.019230769-1063.01923076925
60214872189475.63414634125396.3658536585
61342048281991.01923076960056.9807692308
62273924281991.019230769-8067.01923076925
63195726281991.019230769-86265.0192307692
64231162281991.019230769-50829.0192307692
6520979815192557873
66201345189475.63414634111869.3658536585
67180231281991.019230769-101760.019230769
68204441281991.019230769-77550.0192307692
69197813243250.363636364-45437.3636363636
70136421243250.363636364-106829.363636364
71216092189475.63414634126616.3658536585
727356696570.4444444444-23004.4444444444
73213998189475.63414634124522.3658536585
74181728189475.634146341-7747.63414634147
75148758189475.634146341-40717.6341463415
76308343243250.36363636465092.6363636364
77251437281991.019230769-30554.0192307692
78202388281991.019230769-79603.0192307692
79173286243250.363636364-69964.3636363636
80155529189475.634146341-33946.6341463415
81132672189475.634146341-56803.6341463415
82390163281991.019230769108171.980769231
83145905151925-6020
84228012281991.019230769-53979.0192307692
858095347292.333660.7
86130805151925-21120
87135163189475.634146341-54312.6341463415
88333790281991.01923076951798.9807692308
89271806281991.019230769-10185.0192307692
90164235281991.019230769-117756.019230769
91234092281991.019230769-47899.0192307692
92207158243250.363636364-36092.3636363636
931565831519254658
94242395243250.363636364-855.363636363647
95261601189475.63414634172125.3658536585
96178489189475.634146341-10986.6341463415
97204221189475.63414634114745.3658536585
98268066243250.36363636424815.6363636364
99327622281991.01923076945630.9807692308
100361799281991.01923076979807.9807692308
101247131281991.019230769-34860.0192307692
102265849243250.36363636422598.6363636364
103162336281991.019230769-119655.019230769
1044328747292.3-4005.3
105172244189475.634146341-17231.6341463415
106189021281991.019230769-92970.0192307692
107227681243250.363636364-15569.3636363636
108269329281991.019230769-12662.0192307692
109106503151925-45422
110117891189475.634146341-71584.6341463415
111287201189475.63414634197725.3658536585
112266805281991.019230769-15186.0192307692
113236235398.5833333333318224.4166666667
114174954243250.363636364-68296.3636363636
1156185747292.314564.7
116144889189475.634146341-44586.6341463415
117347988281991.01923076965996.9807692308
1182105447292.3-26238.3
119224051189475.63414634134575.3658536585
1203141447292.3-15878.3
121278660281991.019230769-3331.01923076925
122209481189475.63414634120005.3658536585
1231568701519254945
124112933151925-38992
1253821496570.4444444444-58356.4444444444
126166011189475.634146341-23464.6341463415
127316044243250.36363636472793.6363636364
12818157815192529653
129358903243250.363636364115652.636363636
130275578281991.019230769-6413.01923076925
131368796281991.01923076986804.9807692308
132172464189475.634146341-17011.6341463415
1339438196570.4444444444-2189.44444444444
134250563281991.019230769-31428.0192307692
135382499281991.019230769100507.980769231
13611801096570.444444444421439.5555555556
137365575281991.01923076983583.9807692308
138147989151925-3936
139231681189475.63414634142205.3658536585
140193119189475.6341463413643.36585365853
14118902015192537095
142341958281991.01923076959966.9807692308
143222060281991.019230769-59931.0192307692
14417326015192521335
145274787281991.019230769-7204.01923076925
146130908243250.363636364-112342.363636364
147204009189475.63414634114533.3658536585
148262412281991.019230769-19579.0192307692
14915398.58333333333-5397.58333333333
150146885398.583333333339289.41666666667
151985398.58333333333-5300.58333333333
1524555398.58333333333-4943.58333333333
15305398.58333333333-5398.58333333333
15405398.58333333333-5398.58333333333
155195765189475.6341463416289.36585365853
156334258281991.01923076952266.9807692308
15705398.58333333333-5398.58333333333
1582035398.58333333333-5195.58333333333
15971995398.583333333331800.41666666667
1604666047292.3-632.300000000003
161175475398.5833333333312148.4166666667
16210746596570.444444444410894.5555555556
1639695398.58333333333-4429.58333333333
16417999415192528069



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