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 13:21:48 -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/t1324491803lu22bnm8fkok3cw.htm/, Retrieved Tue, 07 May 2024 09:55:49 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158931, Retrieved Tue, 07 May 2024 09:55:49 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact62
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 19:35:21] [b98453cac15ba1066b407e146608df68]
-   PD    [Recursive Partitioning (Regression Trees)] [] [2011-12-21 18:21:48] [ff205c8f94ca61ac7cf7eb30cad83105] [Current]
Feedback Forum

Post a new message
Dataseries X:
144244	152043	44	29	84	88229	107
197426	121726	28	30	83	178377	59
86652	204039	44	49	146	114198	159
65594	185890	48	31	90	92795	94
101382	252805	81	30	77	127097	97
76173	70849	8	35	89	47552	47
124089	366774	95	39	120	130332	123
66089	102424	42	36	100	61394	49
22618	73566	22	23	67	23824	25
149695	372238	85	44	157	191179	158
56622	80953	49	8	27	55792	58
150047	168994	147	50	179	75767	123
151911	334657	142	47	165	191889	172
25162	61857	23	11	30	24610	28
105079	222373	70	42	106	99776	121
69446	220700	71	43	87	113713	100
136588	263411	135	49	185	134163	186
128692	217478	38	32	45	100187	126
134047	316105	154	48	145	231257	165
31701	101097	30	14	41	45824	35
43750	43287	13	19	64	19630	49
143592	187965	79	35	128	113963	156
100350	199726	48	32	66	75882	72
151715	370483	154	46	161	197765	171
113344	327474	125	41	135	230054	137
279488	396725	137	50	175	258287	246
125081	322896	98	39	92	135213	113
68788	164107	50	37	113	72591	70
103037	425544	86	39	144	150773	137
102153	198094	66	43	151	80716	69
147172	306952	76	40	143	178303	108
146760	401260	103	46	163	195791	182
127654	254506	160	38	131	105590	192
110459	179444	71	34	127	113854	132
131072	232765	135	36	116	114268	199
126817	175699	143	28	89	94333	98
108535	361186	69	37	137	118845	83
82317	179306	66	25	84	111848	71
57224	186856	73	36	59	80684	70
135356	240153	76	48	163	91502	118
96125	208051	101	52	180	106314	155
1168	23623	12	1	0	5841	11
102070	283950	84	40	150	86480	107
118906	189897	103	52	208	102509	123
59900	233632	77	43	97	96252	80
79011	166266	67	41	111	80238	103
103297	358752	139	52	162	101345	148
143372	189252	83	36	139	111542	123
109432	297982	147	45	115	116938	141
167949	305704	113	36	139	164263	194
8773	38214	16	8	21	13983	16
45724	163766	83	45	119	74151	101
149959	285330	145	41	130	195894	204
81351	239314	99	45	154	102204	109
103129	267198	99	41	127	158376	138
154451	246745	116	36	118	134969	151
88977	242585	78	45	171	111563	113
140824	270018	96	38	116	186099	165
84601	233143	65	37	88	105406	122
169707	302218	122	56	208	210012	169
187326	498732	149	33	122	250931	177
156349	301703	185	44	147	169216	194
108146	359644	140	45	143	100125	121
168553	222504	94	35	127	162519	170
144408	207822	74	34	117	115466	124
183500	285198	158	39	104	211381	210
104128	196269	50	53	171	122975	158
33032	78800	20	26	66	56968	21
43929	162874	61	27	64	100792	71
56750	251466	76	37	85	115750	96
126372	341637	130	36	133	165278	178
160141	447353	147	45	138	175721	157
71571	182231	83	37	110	75881	101
125818	176082	103	29	85	111669	162
38692	145943	30	26	99	68580	38
95893	252529	89	36	127	81180	100
67150	282399	110	46	124	114651	142
110529	384053	135	38	102	232241	216
59938	261494	128	36	135	82390	107
81625	237633	117	55	184	94853	93
71154	201783	133	38	134	80906	109
104767	264889	92	42	142	124527	126
125386	236660	121	39	126	134218	239
165933	383703	127	46	161	147581	173
64520	173510	68	42	126	54518	71
165986	367807	151	58	221	189944	193
102812	280343	117	44	92	136323	159
81897	191030	127	38	133	89770	137
37110	155915	57	32	99	64057	66
146975	314255	73	36	132	135599	144
92059	187167	79	38	90	91313	126
144551	179797	165	45	159	81716	164
184923	397681	165	30	106	226168	297
79756	187992	71	40	137	122531	89
140015	323545	145	45	136	145758	170
89506	311281	106	39	137	160501	119
64593	157429	55	39	112	72558	90
70168	215710	79	36	89	104470	109
134238	403932	137	48	167	191469	161
101047	301614	169	40	124	135848	135
92622	324178	123	39	122	134097	123
14116	31961	18	8	9	13155	39
15986	150216	52	27	77	25157	27
89256	175523	99	45	146	104864	133
150491	323485	115	39	137	194679	256
140358	287015	117	51	176	117495	125
114948	369889	168	59	199	165354	142
95671	213060	94	40	137	160791	125
176225	303406	139	28	73	214738	267
93487	195153	75	36	108	133252	87
89626	237323	85	44	148	134904	133
66485	213274	82	33	82	110896	92
79089	296074	92	43	139	169351	149
55918	153613	62	28	89	83963	61
112302	318563	133	48	178	198299	159
104581	207280	86	38	139	116136	115
117440	353021	137	52	187	157384	160
101629	422946	112	43	148	188355	117
112098	218443	134	38	133	106194	145
68946	366745	130	47	115	174586	173
114799	228595	52	37	125	153242	132
119442	369331	132	39	148	189723	185
100087	279012	97	37	120	129711	133
139165	278019	123	45	165	184531	152
83243	270750	117	43	148	153990	125
123534	156923	71	36	130	100922	108
6179	46660	12	5	13	21509	13
1644	7199	7	0	0	4245	6
6023	14688	4	0	0	7953	5
120192	338543	146	42	150	197680	190
83248	195817	146	40	103	106020	130
103925	336047	124	39	143	164808	149
72128	216027	96	30	87	145707	121
112431	271965	123	45	148	140303	147
92280	236370	104	41	135	147341	140
83515	219420	138	41	144	96785	134
48029	185468	89	23	36	88634	82
93879	318651	130	57	122	170492	88
855	21054	4	0	0	6622	4
100046	259692	128	40	125	128602	111
31081	115469	33	17	46	58391	41
104978	219475	92	40	88	139292	205
5950	24188	8	4	7	15049	7
3926	17547	0	1	4	7670	3




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158931&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'AstonUniversity' @ aston.wessa.net







Goodness of Fit
Correlation0.8229
R-squared0.6771
RMSE26672.2867

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8229[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6771[/C][/ROW]
[ROW][C]RMSE[/C][C]26672.2867[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158931&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158931&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.8229
R-squared0.6771
RMSE26672.2867







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1144244108040.10937536203.890625
2197426104459.28571428692966.7142857143
386652108040.109375-21388.109375
46559466247.6296296296-653.629629629635
5101382104459.285714286-3077.28571428571
67617366247.62962962969925.37037037036
7124089108040.10937516048.890625
86608966247.6296296296-158.629629629635
92261813417.92857142869200.07142857143
10149695108040.10937541654.890625
115662266247.6296296296-9625.62962962964
12150047108040.10937542006.890625
13151911148357.093753553.90625
142516213417.928571428611744.0714285714
15105079108040.109375-2961.109375
166944666247.62962962963198.37037037036
17136588148357.09375-11769.09375
18128692108040.10937520651.890625
19134047148357.09375-14310.09375
203170113417.928571428618283.0714285714
214375013417.928571428630332.0714285714
22143592108040.10937535551.890625
2310035066247.629629629634102.3703703704
24151715148357.093753357.90625
25113344108040.1093755303.890625
26279488148357.09375131130.90625
27125081108040.10937517040.890625
286878866247.62962962962540.37037037036
29103037108040.109375-5003.109375
3010215366247.629629629635905.3703703704
31147172108040.10937539131.890625
32146760148357.09375-1597.09375
33127654148357.09375-20703.09375
34110459108040.1093752418.890625
35131072148357.09375-17285.09375
3612681766247.629629629660569.3703703704
37108535104459.2857142864075.71428571429
388231766247.629629629616069.3703703704
395722466247.6296296296-9023.62962962964
40135356108040.10937527315.890625
4196125108040.109375-11915.109375
42116813417.9285714286-12249.9285714286
43102070108040.109375-5970.109375
44118906108040.10937510865.890625
455990066247.6296296296-6347.62962962964
467901166247.629629629612763.3703703704
47103297108040.109375-4743.109375
48143372108040.10937535331.890625
49109432108040.1093751391.890625
50167949148357.0937519591.90625
51877313417.9285714286-4644.92857142857
524572466247.6296296296-20523.6296296296
53149959148357.093751601.90625
5481351108040.109375-26689.109375
55103129108040.109375-4911.109375
56154451108040.10937546410.890625
5788977108040.109375-19063.109375
58140824148357.09375-7533.09375
5984601108040.109375-23439.109375
60169707148357.0937521349.90625
61187326148357.0937538968.90625
62156349148357.093757991.90625
63108146108040.109375105.890625
64168553148357.0937520195.90625
65144408108040.10937536367.890625
66183500148357.0937535142.90625
67104128108040.109375-3912.109375
683303266247.6296296296-33215.6296296296
694392966247.6296296296-22318.6296296296
7056750104459.285714286-47709.2857142857
71126372148357.09375-21985.09375
72160141108040.10937552100.890625
737157166247.62962962965323.37037037036
74125818148357.09375-22539.09375
753869266247.6296296296-27555.6296296296
769589366247.629629629629645.3703703704
7767150108040.109375-40890.109375
78110529148357.09375-37828.09375
7959938108040.109375-48102.109375
808162566247.629629629615377.3703703704
8171154108040.109375-36886.109375
82104767108040.109375-3273.109375
83125386148357.09375-22971.09375
84165933148357.0937517575.90625
856452066247.6296296296-1727.62962962964
86165986148357.0937517628.90625
87102812108040.109375-5228.109375
8881897108040.109375-26143.109375
893711066247.6296296296-29137.6296296296
90146975108040.10937538934.890625
9192059108040.109375-15981.109375
92144551148357.09375-3806.09375
93184923148357.0937536565.90625
9479756104459.285714286-24703.2857142857
95140015148357.09375-8342.09375
9689506108040.109375-18534.109375
976459366247.6296296296-1654.62962962964
9870168108040.109375-37872.109375
99134238148357.09375-14119.09375
100101047108040.109375-6993.109375
10192622108040.109375-15418.109375
1021411613417.9285714286698.071428571429
1031598613417.92857142862568.07142857143
10489256108040.109375-18784.109375
105150491148357.093752133.90625
106140358108040.10937532317.890625
107114948108040.1093756907.890625
10895671108040.109375-12369.109375
109176225148357.0937527867.90625
11093487104459.285714286-10972.2857142857
11189626108040.109375-18414.109375
1126648566247.6296296296237.370370370365
11379089108040.109375-28951.109375
1145591866247.6296296296-10329.6296296296
115112302108040.1093754261.890625
116104581108040.109375-3459.109375
117117440108040.1093759399.890625
118101629108040.109375-6411.109375
119112098108040.1093754057.890625
12068946148357.09375-79411.09375
121114799108040.1093756758.890625
122119442148357.09375-28915.09375
123100087108040.109375-7953.109375
124139165108040.10937531124.890625
12583243108040.109375-24797.109375
126123534108040.10937515493.890625
127617913417.9285714286-7238.92857142857
128164413417.9285714286-11773.9285714286
129602313417.9285714286-7394.92857142857
130120192148357.09375-28165.09375
13183248108040.109375-24792.109375
132103925108040.109375-4115.109375
13372128108040.109375-35912.109375
134112431108040.1093754390.890625
13592280108040.109375-15760.109375
13683515108040.109375-24525.109375
1374802966247.6296296296-18218.6296296296
13893879104459.285714286-10580.2857142857
13985513417.9285714286-12562.9285714286
140100046108040.109375-7994.109375
1413108166247.6296296296-35166.6296296296
142104978148357.09375-43379.09375
143595013417.9285714286-7467.92857142857
144392613417.9285714286-9491.92857142857

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 144244 & 108040.109375 & 36203.890625 \tabularnewline
2 & 197426 & 104459.285714286 & 92966.7142857143 \tabularnewline
3 & 86652 & 108040.109375 & -21388.109375 \tabularnewline
4 & 65594 & 66247.6296296296 & -653.629629629635 \tabularnewline
5 & 101382 & 104459.285714286 & -3077.28571428571 \tabularnewline
6 & 76173 & 66247.6296296296 & 9925.37037037036 \tabularnewline
7 & 124089 & 108040.109375 & 16048.890625 \tabularnewline
8 & 66089 & 66247.6296296296 & -158.629629629635 \tabularnewline
9 & 22618 & 13417.9285714286 & 9200.07142857143 \tabularnewline
10 & 149695 & 108040.109375 & 41654.890625 \tabularnewline
11 & 56622 & 66247.6296296296 & -9625.62962962964 \tabularnewline
12 & 150047 & 108040.109375 & 42006.890625 \tabularnewline
13 & 151911 & 148357.09375 & 3553.90625 \tabularnewline
14 & 25162 & 13417.9285714286 & 11744.0714285714 \tabularnewline
15 & 105079 & 108040.109375 & -2961.109375 \tabularnewline
16 & 69446 & 66247.6296296296 & 3198.37037037036 \tabularnewline
17 & 136588 & 148357.09375 & -11769.09375 \tabularnewline
18 & 128692 & 108040.109375 & 20651.890625 \tabularnewline
19 & 134047 & 148357.09375 & -14310.09375 \tabularnewline
20 & 31701 & 13417.9285714286 & 18283.0714285714 \tabularnewline
21 & 43750 & 13417.9285714286 & 30332.0714285714 \tabularnewline
22 & 143592 & 108040.109375 & 35551.890625 \tabularnewline
23 & 100350 & 66247.6296296296 & 34102.3703703704 \tabularnewline
24 & 151715 & 148357.09375 & 3357.90625 \tabularnewline
25 & 113344 & 108040.109375 & 5303.890625 \tabularnewline
26 & 279488 & 148357.09375 & 131130.90625 \tabularnewline
27 & 125081 & 108040.109375 & 17040.890625 \tabularnewline
28 & 68788 & 66247.6296296296 & 2540.37037037036 \tabularnewline
29 & 103037 & 108040.109375 & -5003.109375 \tabularnewline
30 & 102153 & 66247.6296296296 & 35905.3703703704 \tabularnewline
31 & 147172 & 108040.109375 & 39131.890625 \tabularnewline
32 & 146760 & 148357.09375 & -1597.09375 \tabularnewline
33 & 127654 & 148357.09375 & -20703.09375 \tabularnewline
34 & 110459 & 108040.109375 & 2418.890625 \tabularnewline
35 & 131072 & 148357.09375 & -17285.09375 \tabularnewline
36 & 126817 & 66247.6296296296 & 60569.3703703704 \tabularnewline
37 & 108535 & 104459.285714286 & 4075.71428571429 \tabularnewline
38 & 82317 & 66247.6296296296 & 16069.3703703704 \tabularnewline
39 & 57224 & 66247.6296296296 & -9023.62962962964 \tabularnewline
40 & 135356 & 108040.109375 & 27315.890625 \tabularnewline
41 & 96125 & 108040.109375 & -11915.109375 \tabularnewline
42 & 1168 & 13417.9285714286 & -12249.9285714286 \tabularnewline
43 & 102070 & 108040.109375 & -5970.109375 \tabularnewline
44 & 118906 & 108040.109375 & 10865.890625 \tabularnewline
45 & 59900 & 66247.6296296296 & -6347.62962962964 \tabularnewline
46 & 79011 & 66247.6296296296 & 12763.3703703704 \tabularnewline
47 & 103297 & 108040.109375 & -4743.109375 \tabularnewline
48 & 143372 & 108040.109375 & 35331.890625 \tabularnewline
49 & 109432 & 108040.109375 & 1391.890625 \tabularnewline
50 & 167949 & 148357.09375 & 19591.90625 \tabularnewline
51 & 8773 & 13417.9285714286 & -4644.92857142857 \tabularnewline
52 & 45724 & 66247.6296296296 & -20523.6296296296 \tabularnewline
53 & 149959 & 148357.09375 & 1601.90625 \tabularnewline
54 & 81351 & 108040.109375 & -26689.109375 \tabularnewline
55 & 103129 & 108040.109375 & -4911.109375 \tabularnewline
56 & 154451 & 108040.109375 & 46410.890625 \tabularnewline
57 & 88977 & 108040.109375 & -19063.109375 \tabularnewline
58 & 140824 & 148357.09375 & -7533.09375 \tabularnewline
59 & 84601 & 108040.109375 & -23439.109375 \tabularnewline
60 & 169707 & 148357.09375 & 21349.90625 \tabularnewline
61 & 187326 & 148357.09375 & 38968.90625 \tabularnewline
62 & 156349 & 148357.09375 & 7991.90625 \tabularnewline
63 & 108146 & 108040.109375 & 105.890625 \tabularnewline
64 & 168553 & 148357.09375 & 20195.90625 \tabularnewline
65 & 144408 & 108040.109375 & 36367.890625 \tabularnewline
66 & 183500 & 148357.09375 & 35142.90625 \tabularnewline
67 & 104128 & 108040.109375 & -3912.109375 \tabularnewline
68 & 33032 & 66247.6296296296 & -33215.6296296296 \tabularnewline
69 & 43929 & 66247.6296296296 & -22318.6296296296 \tabularnewline
70 & 56750 & 104459.285714286 & -47709.2857142857 \tabularnewline
71 & 126372 & 148357.09375 & -21985.09375 \tabularnewline
72 & 160141 & 108040.109375 & 52100.890625 \tabularnewline
73 & 71571 & 66247.6296296296 & 5323.37037037036 \tabularnewline
74 & 125818 & 148357.09375 & -22539.09375 \tabularnewline
75 & 38692 & 66247.6296296296 & -27555.6296296296 \tabularnewline
76 & 95893 & 66247.6296296296 & 29645.3703703704 \tabularnewline
77 & 67150 & 108040.109375 & -40890.109375 \tabularnewline
78 & 110529 & 148357.09375 & -37828.09375 \tabularnewline
79 & 59938 & 108040.109375 & -48102.109375 \tabularnewline
80 & 81625 & 66247.6296296296 & 15377.3703703704 \tabularnewline
81 & 71154 & 108040.109375 & -36886.109375 \tabularnewline
82 & 104767 & 108040.109375 & -3273.109375 \tabularnewline
83 & 125386 & 148357.09375 & -22971.09375 \tabularnewline
84 & 165933 & 148357.09375 & 17575.90625 \tabularnewline
85 & 64520 & 66247.6296296296 & -1727.62962962964 \tabularnewline
86 & 165986 & 148357.09375 & 17628.90625 \tabularnewline
87 & 102812 & 108040.109375 & -5228.109375 \tabularnewline
88 & 81897 & 108040.109375 & -26143.109375 \tabularnewline
89 & 37110 & 66247.6296296296 & -29137.6296296296 \tabularnewline
90 & 146975 & 108040.109375 & 38934.890625 \tabularnewline
91 & 92059 & 108040.109375 & -15981.109375 \tabularnewline
92 & 144551 & 148357.09375 & -3806.09375 \tabularnewline
93 & 184923 & 148357.09375 & 36565.90625 \tabularnewline
94 & 79756 & 104459.285714286 & -24703.2857142857 \tabularnewline
95 & 140015 & 148357.09375 & -8342.09375 \tabularnewline
96 & 89506 & 108040.109375 & -18534.109375 \tabularnewline
97 & 64593 & 66247.6296296296 & -1654.62962962964 \tabularnewline
98 & 70168 & 108040.109375 & -37872.109375 \tabularnewline
99 & 134238 & 148357.09375 & -14119.09375 \tabularnewline
100 & 101047 & 108040.109375 & -6993.109375 \tabularnewline
101 & 92622 & 108040.109375 & -15418.109375 \tabularnewline
102 & 14116 & 13417.9285714286 & 698.071428571429 \tabularnewline
103 & 15986 & 13417.9285714286 & 2568.07142857143 \tabularnewline
104 & 89256 & 108040.109375 & -18784.109375 \tabularnewline
105 & 150491 & 148357.09375 & 2133.90625 \tabularnewline
106 & 140358 & 108040.109375 & 32317.890625 \tabularnewline
107 & 114948 & 108040.109375 & 6907.890625 \tabularnewline
108 & 95671 & 108040.109375 & -12369.109375 \tabularnewline
109 & 176225 & 148357.09375 & 27867.90625 \tabularnewline
110 & 93487 & 104459.285714286 & -10972.2857142857 \tabularnewline
111 & 89626 & 108040.109375 & -18414.109375 \tabularnewline
112 & 66485 & 66247.6296296296 & 237.370370370365 \tabularnewline
113 & 79089 & 108040.109375 & -28951.109375 \tabularnewline
114 & 55918 & 66247.6296296296 & -10329.6296296296 \tabularnewline
115 & 112302 & 108040.109375 & 4261.890625 \tabularnewline
116 & 104581 & 108040.109375 & -3459.109375 \tabularnewline
117 & 117440 & 108040.109375 & 9399.890625 \tabularnewline
118 & 101629 & 108040.109375 & -6411.109375 \tabularnewline
119 & 112098 & 108040.109375 & 4057.890625 \tabularnewline
120 & 68946 & 148357.09375 & -79411.09375 \tabularnewline
121 & 114799 & 108040.109375 & 6758.890625 \tabularnewline
122 & 119442 & 148357.09375 & -28915.09375 \tabularnewline
123 & 100087 & 108040.109375 & -7953.109375 \tabularnewline
124 & 139165 & 108040.109375 & 31124.890625 \tabularnewline
125 & 83243 & 108040.109375 & -24797.109375 \tabularnewline
126 & 123534 & 108040.109375 & 15493.890625 \tabularnewline
127 & 6179 & 13417.9285714286 & -7238.92857142857 \tabularnewline
128 & 1644 & 13417.9285714286 & -11773.9285714286 \tabularnewline
129 & 6023 & 13417.9285714286 & -7394.92857142857 \tabularnewline
130 & 120192 & 148357.09375 & -28165.09375 \tabularnewline
131 & 83248 & 108040.109375 & -24792.109375 \tabularnewline
132 & 103925 & 108040.109375 & -4115.109375 \tabularnewline
133 & 72128 & 108040.109375 & -35912.109375 \tabularnewline
134 & 112431 & 108040.109375 & 4390.890625 \tabularnewline
135 & 92280 & 108040.109375 & -15760.109375 \tabularnewline
136 & 83515 & 108040.109375 & -24525.109375 \tabularnewline
137 & 48029 & 66247.6296296296 & -18218.6296296296 \tabularnewline
138 & 93879 & 104459.285714286 & -10580.2857142857 \tabularnewline
139 & 855 & 13417.9285714286 & -12562.9285714286 \tabularnewline
140 & 100046 & 108040.109375 & -7994.109375 \tabularnewline
141 & 31081 & 66247.6296296296 & -35166.6296296296 \tabularnewline
142 & 104978 & 148357.09375 & -43379.09375 \tabularnewline
143 & 5950 & 13417.9285714286 & -7467.92857142857 \tabularnewline
144 & 3926 & 13417.9285714286 & -9491.92857142857 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158931&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]144244[/C][C]108040.109375[/C][C]36203.890625[/C][/ROW]
[ROW][C]2[/C][C]197426[/C][C]104459.285714286[/C][C]92966.7142857143[/C][/ROW]
[ROW][C]3[/C][C]86652[/C][C]108040.109375[/C][C]-21388.109375[/C][/ROW]
[ROW][C]4[/C][C]65594[/C][C]66247.6296296296[/C][C]-653.629629629635[/C][/ROW]
[ROW][C]5[/C][C]101382[/C][C]104459.285714286[/C][C]-3077.28571428571[/C][/ROW]
[ROW][C]6[/C][C]76173[/C][C]66247.6296296296[/C][C]9925.37037037036[/C][/ROW]
[ROW][C]7[/C][C]124089[/C][C]108040.109375[/C][C]16048.890625[/C][/ROW]
[ROW][C]8[/C][C]66089[/C][C]66247.6296296296[/C][C]-158.629629629635[/C][/ROW]
[ROW][C]9[/C][C]22618[/C][C]13417.9285714286[/C][C]9200.07142857143[/C][/ROW]
[ROW][C]10[/C][C]149695[/C][C]108040.109375[/C][C]41654.890625[/C][/ROW]
[ROW][C]11[/C][C]56622[/C][C]66247.6296296296[/C][C]-9625.62962962964[/C][/ROW]
[ROW][C]12[/C][C]150047[/C][C]108040.109375[/C][C]42006.890625[/C][/ROW]
[ROW][C]13[/C][C]151911[/C][C]148357.09375[/C][C]3553.90625[/C][/ROW]
[ROW][C]14[/C][C]25162[/C][C]13417.9285714286[/C][C]11744.0714285714[/C][/ROW]
[ROW][C]15[/C][C]105079[/C][C]108040.109375[/C][C]-2961.109375[/C][/ROW]
[ROW][C]16[/C][C]69446[/C][C]66247.6296296296[/C][C]3198.37037037036[/C][/ROW]
[ROW][C]17[/C][C]136588[/C][C]148357.09375[/C][C]-11769.09375[/C][/ROW]
[ROW][C]18[/C][C]128692[/C][C]108040.109375[/C][C]20651.890625[/C][/ROW]
[ROW][C]19[/C][C]134047[/C][C]148357.09375[/C][C]-14310.09375[/C][/ROW]
[ROW][C]20[/C][C]31701[/C][C]13417.9285714286[/C][C]18283.0714285714[/C][/ROW]
[ROW][C]21[/C][C]43750[/C][C]13417.9285714286[/C][C]30332.0714285714[/C][/ROW]
[ROW][C]22[/C][C]143592[/C][C]108040.109375[/C][C]35551.890625[/C][/ROW]
[ROW][C]23[/C][C]100350[/C][C]66247.6296296296[/C][C]34102.3703703704[/C][/ROW]
[ROW][C]24[/C][C]151715[/C][C]148357.09375[/C][C]3357.90625[/C][/ROW]
[ROW][C]25[/C][C]113344[/C][C]108040.109375[/C][C]5303.890625[/C][/ROW]
[ROW][C]26[/C][C]279488[/C][C]148357.09375[/C][C]131130.90625[/C][/ROW]
[ROW][C]27[/C][C]125081[/C][C]108040.109375[/C][C]17040.890625[/C][/ROW]
[ROW][C]28[/C][C]68788[/C][C]66247.6296296296[/C][C]2540.37037037036[/C][/ROW]
[ROW][C]29[/C][C]103037[/C][C]108040.109375[/C][C]-5003.109375[/C][/ROW]
[ROW][C]30[/C][C]102153[/C][C]66247.6296296296[/C][C]35905.3703703704[/C][/ROW]
[ROW][C]31[/C][C]147172[/C][C]108040.109375[/C][C]39131.890625[/C][/ROW]
[ROW][C]32[/C][C]146760[/C][C]148357.09375[/C][C]-1597.09375[/C][/ROW]
[ROW][C]33[/C][C]127654[/C][C]148357.09375[/C][C]-20703.09375[/C][/ROW]
[ROW][C]34[/C][C]110459[/C][C]108040.109375[/C][C]2418.890625[/C][/ROW]
[ROW][C]35[/C][C]131072[/C][C]148357.09375[/C][C]-17285.09375[/C][/ROW]
[ROW][C]36[/C][C]126817[/C][C]66247.6296296296[/C][C]60569.3703703704[/C][/ROW]
[ROW][C]37[/C][C]108535[/C][C]104459.285714286[/C][C]4075.71428571429[/C][/ROW]
[ROW][C]38[/C][C]82317[/C][C]66247.6296296296[/C][C]16069.3703703704[/C][/ROW]
[ROW][C]39[/C][C]57224[/C][C]66247.6296296296[/C][C]-9023.62962962964[/C][/ROW]
[ROW][C]40[/C][C]135356[/C][C]108040.109375[/C][C]27315.890625[/C][/ROW]
[ROW][C]41[/C][C]96125[/C][C]108040.109375[/C][C]-11915.109375[/C][/ROW]
[ROW][C]42[/C][C]1168[/C][C]13417.9285714286[/C][C]-12249.9285714286[/C][/ROW]
[ROW][C]43[/C][C]102070[/C][C]108040.109375[/C][C]-5970.109375[/C][/ROW]
[ROW][C]44[/C][C]118906[/C][C]108040.109375[/C][C]10865.890625[/C][/ROW]
[ROW][C]45[/C][C]59900[/C][C]66247.6296296296[/C][C]-6347.62962962964[/C][/ROW]
[ROW][C]46[/C][C]79011[/C][C]66247.6296296296[/C][C]12763.3703703704[/C][/ROW]
[ROW][C]47[/C][C]103297[/C][C]108040.109375[/C][C]-4743.109375[/C][/ROW]
[ROW][C]48[/C][C]143372[/C][C]108040.109375[/C][C]35331.890625[/C][/ROW]
[ROW][C]49[/C][C]109432[/C][C]108040.109375[/C][C]1391.890625[/C][/ROW]
[ROW][C]50[/C][C]167949[/C][C]148357.09375[/C][C]19591.90625[/C][/ROW]
[ROW][C]51[/C][C]8773[/C][C]13417.9285714286[/C][C]-4644.92857142857[/C][/ROW]
[ROW][C]52[/C][C]45724[/C][C]66247.6296296296[/C][C]-20523.6296296296[/C][/ROW]
[ROW][C]53[/C][C]149959[/C][C]148357.09375[/C][C]1601.90625[/C][/ROW]
[ROW][C]54[/C][C]81351[/C][C]108040.109375[/C][C]-26689.109375[/C][/ROW]
[ROW][C]55[/C][C]103129[/C][C]108040.109375[/C][C]-4911.109375[/C][/ROW]
[ROW][C]56[/C][C]154451[/C][C]108040.109375[/C][C]46410.890625[/C][/ROW]
[ROW][C]57[/C][C]88977[/C][C]108040.109375[/C][C]-19063.109375[/C][/ROW]
[ROW][C]58[/C][C]140824[/C][C]148357.09375[/C][C]-7533.09375[/C][/ROW]
[ROW][C]59[/C][C]84601[/C][C]108040.109375[/C][C]-23439.109375[/C][/ROW]
[ROW][C]60[/C][C]169707[/C][C]148357.09375[/C][C]21349.90625[/C][/ROW]
[ROW][C]61[/C][C]187326[/C][C]148357.09375[/C][C]38968.90625[/C][/ROW]
[ROW][C]62[/C][C]156349[/C][C]148357.09375[/C][C]7991.90625[/C][/ROW]
[ROW][C]63[/C][C]108146[/C][C]108040.109375[/C][C]105.890625[/C][/ROW]
[ROW][C]64[/C][C]168553[/C][C]148357.09375[/C][C]20195.90625[/C][/ROW]
[ROW][C]65[/C][C]144408[/C][C]108040.109375[/C][C]36367.890625[/C][/ROW]
[ROW][C]66[/C][C]183500[/C][C]148357.09375[/C][C]35142.90625[/C][/ROW]
[ROW][C]67[/C][C]104128[/C][C]108040.109375[/C][C]-3912.109375[/C][/ROW]
[ROW][C]68[/C][C]33032[/C][C]66247.6296296296[/C][C]-33215.6296296296[/C][/ROW]
[ROW][C]69[/C][C]43929[/C][C]66247.6296296296[/C][C]-22318.6296296296[/C][/ROW]
[ROW][C]70[/C][C]56750[/C][C]104459.285714286[/C][C]-47709.2857142857[/C][/ROW]
[ROW][C]71[/C][C]126372[/C][C]148357.09375[/C][C]-21985.09375[/C][/ROW]
[ROW][C]72[/C][C]160141[/C][C]108040.109375[/C][C]52100.890625[/C][/ROW]
[ROW][C]73[/C][C]71571[/C][C]66247.6296296296[/C][C]5323.37037037036[/C][/ROW]
[ROW][C]74[/C][C]125818[/C][C]148357.09375[/C][C]-22539.09375[/C][/ROW]
[ROW][C]75[/C][C]38692[/C][C]66247.6296296296[/C][C]-27555.6296296296[/C][/ROW]
[ROW][C]76[/C][C]95893[/C][C]66247.6296296296[/C][C]29645.3703703704[/C][/ROW]
[ROW][C]77[/C][C]67150[/C][C]108040.109375[/C][C]-40890.109375[/C][/ROW]
[ROW][C]78[/C][C]110529[/C][C]148357.09375[/C][C]-37828.09375[/C][/ROW]
[ROW][C]79[/C][C]59938[/C][C]108040.109375[/C][C]-48102.109375[/C][/ROW]
[ROW][C]80[/C][C]81625[/C][C]66247.6296296296[/C][C]15377.3703703704[/C][/ROW]
[ROW][C]81[/C][C]71154[/C][C]108040.109375[/C][C]-36886.109375[/C][/ROW]
[ROW][C]82[/C][C]104767[/C][C]108040.109375[/C][C]-3273.109375[/C][/ROW]
[ROW][C]83[/C][C]125386[/C][C]148357.09375[/C][C]-22971.09375[/C][/ROW]
[ROW][C]84[/C][C]165933[/C][C]148357.09375[/C][C]17575.90625[/C][/ROW]
[ROW][C]85[/C][C]64520[/C][C]66247.6296296296[/C][C]-1727.62962962964[/C][/ROW]
[ROW][C]86[/C][C]165986[/C][C]148357.09375[/C][C]17628.90625[/C][/ROW]
[ROW][C]87[/C][C]102812[/C][C]108040.109375[/C][C]-5228.109375[/C][/ROW]
[ROW][C]88[/C][C]81897[/C][C]108040.109375[/C][C]-26143.109375[/C][/ROW]
[ROW][C]89[/C][C]37110[/C][C]66247.6296296296[/C][C]-29137.6296296296[/C][/ROW]
[ROW][C]90[/C][C]146975[/C][C]108040.109375[/C][C]38934.890625[/C][/ROW]
[ROW][C]91[/C][C]92059[/C][C]108040.109375[/C][C]-15981.109375[/C][/ROW]
[ROW][C]92[/C][C]144551[/C][C]148357.09375[/C][C]-3806.09375[/C][/ROW]
[ROW][C]93[/C][C]184923[/C][C]148357.09375[/C][C]36565.90625[/C][/ROW]
[ROW][C]94[/C][C]79756[/C][C]104459.285714286[/C][C]-24703.2857142857[/C][/ROW]
[ROW][C]95[/C][C]140015[/C][C]148357.09375[/C][C]-8342.09375[/C][/ROW]
[ROW][C]96[/C][C]89506[/C][C]108040.109375[/C][C]-18534.109375[/C][/ROW]
[ROW][C]97[/C][C]64593[/C][C]66247.6296296296[/C][C]-1654.62962962964[/C][/ROW]
[ROW][C]98[/C][C]70168[/C][C]108040.109375[/C][C]-37872.109375[/C][/ROW]
[ROW][C]99[/C][C]134238[/C][C]148357.09375[/C][C]-14119.09375[/C][/ROW]
[ROW][C]100[/C][C]101047[/C][C]108040.109375[/C][C]-6993.109375[/C][/ROW]
[ROW][C]101[/C][C]92622[/C][C]108040.109375[/C][C]-15418.109375[/C][/ROW]
[ROW][C]102[/C][C]14116[/C][C]13417.9285714286[/C][C]698.071428571429[/C][/ROW]
[ROW][C]103[/C][C]15986[/C][C]13417.9285714286[/C][C]2568.07142857143[/C][/ROW]
[ROW][C]104[/C][C]89256[/C][C]108040.109375[/C][C]-18784.109375[/C][/ROW]
[ROW][C]105[/C][C]150491[/C][C]148357.09375[/C][C]2133.90625[/C][/ROW]
[ROW][C]106[/C][C]140358[/C][C]108040.109375[/C][C]32317.890625[/C][/ROW]
[ROW][C]107[/C][C]114948[/C][C]108040.109375[/C][C]6907.890625[/C][/ROW]
[ROW][C]108[/C][C]95671[/C][C]108040.109375[/C][C]-12369.109375[/C][/ROW]
[ROW][C]109[/C][C]176225[/C][C]148357.09375[/C][C]27867.90625[/C][/ROW]
[ROW][C]110[/C][C]93487[/C][C]104459.285714286[/C][C]-10972.2857142857[/C][/ROW]
[ROW][C]111[/C][C]89626[/C][C]108040.109375[/C][C]-18414.109375[/C][/ROW]
[ROW][C]112[/C][C]66485[/C][C]66247.6296296296[/C][C]237.370370370365[/C][/ROW]
[ROW][C]113[/C][C]79089[/C][C]108040.109375[/C][C]-28951.109375[/C][/ROW]
[ROW][C]114[/C][C]55918[/C][C]66247.6296296296[/C][C]-10329.6296296296[/C][/ROW]
[ROW][C]115[/C][C]112302[/C][C]108040.109375[/C][C]4261.890625[/C][/ROW]
[ROW][C]116[/C][C]104581[/C][C]108040.109375[/C][C]-3459.109375[/C][/ROW]
[ROW][C]117[/C][C]117440[/C][C]108040.109375[/C][C]9399.890625[/C][/ROW]
[ROW][C]118[/C][C]101629[/C][C]108040.109375[/C][C]-6411.109375[/C][/ROW]
[ROW][C]119[/C][C]112098[/C][C]108040.109375[/C][C]4057.890625[/C][/ROW]
[ROW][C]120[/C][C]68946[/C][C]148357.09375[/C][C]-79411.09375[/C][/ROW]
[ROW][C]121[/C][C]114799[/C][C]108040.109375[/C][C]6758.890625[/C][/ROW]
[ROW][C]122[/C][C]119442[/C][C]148357.09375[/C][C]-28915.09375[/C][/ROW]
[ROW][C]123[/C][C]100087[/C][C]108040.109375[/C][C]-7953.109375[/C][/ROW]
[ROW][C]124[/C][C]139165[/C][C]108040.109375[/C][C]31124.890625[/C][/ROW]
[ROW][C]125[/C][C]83243[/C][C]108040.109375[/C][C]-24797.109375[/C][/ROW]
[ROW][C]126[/C][C]123534[/C][C]108040.109375[/C][C]15493.890625[/C][/ROW]
[ROW][C]127[/C][C]6179[/C][C]13417.9285714286[/C][C]-7238.92857142857[/C][/ROW]
[ROW][C]128[/C][C]1644[/C][C]13417.9285714286[/C][C]-11773.9285714286[/C][/ROW]
[ROW][C]129[/C][C]6023[/C][C]13417.9285714286[/C][C]-7394.92857142857[/C][/ROW]
[ROW][C]130[/C][C]120192[/C][C]148357.09375[/C][C]-28165.09375[/C][/ROW]
[ROW][C]131[/C][C]83248[/C][C]108040.109375[/C][C]-24792.109375[/C][/ROW]
[ROW][C]132[/C][C]103925[/C][C]108040.109375[/C][C]-4115.109375[/C][/ROW]
[ROW][C]133[/C][C]72128[/C][C]108040.109375[/C][C]-35912.109375[/C][/ROW]
[ROW][C]134[/C][C]112431[/C][C]108040.109375[/C][C]4390.890625[/C][/ROW]
[ROW][C]135[/C][C]92280[/C][C]108040.109375[/C][C]-15760.109375[/C][/ROW]
[ROW][C]136[/C][C]83515[/C][C]108040.109375[/C][C]-24525.109375[/C][/ROW]
[ROW][C]137[/C][C]48029[/C][C]66247.6296296296[/C][C]-18218.6296296296[/C][/ROW]
[ROW][C]138[/C][C]93879[/C][C]104459.285714286[/C][C]-10580.2857142857[/C][/ROW]
[ROW][C]139[/C][C]855[/C][C]13417.9285714286[/C][C]-12562.9285714286[/C][/ROW]
[ROW][C]140[/C][C]100046[/C][C]108040.109375[/C][C]-7994.109375[/C][/ROW]
[ROW][C]141[/C][C]31081[/C][C]66247.6296296296[/C][C]-35166.6296296296[/C][/ROW]
[ROW][C]142[/C][C]104978[/C][C]148357.09375[/C][C]-43379.09375[/C][/ROW]
[ROW][C]143[/C][C]5950[/C][C]13417.9285714286[/C][C]-7467.92857142857[/C][/ROW]
[ROW][C]144[/C][C]3926[/C][C]13417.9285714286[/C][C]-9491.92857142857[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158931&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158931&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
1144244108040.10937536203.890625
2197426104459.28571428692966.7142857143
386652108040.109375-21388.109375
46559466247.6296296296-653.629629629635
5101382104459.285714286-3077.28571428571
67617366247.62962962969925.37037037036
7124089108040.10937516048.890625
86608966247.6296296296-158.629629629635
92261813417.92857142869200.07142857143
10149695108040.10937541654.890625
115662266247.6296296296-9625.62962962964
12150047108040.10937542006.890625
13151911148357.093753553.90625
142516213417.928571428611744.0714285714
15105079108040.109375-2961.109375
166944666247.62962962963198.37037037036
17136588148357.09375-11769.09375
18128692108040.10937520651.890625
19134047148357.09375-14310.09375
203170113417.928571428618283.0714285714
214375013417.928571428630332.0714285714
22143592108040.10937535551.890625
2310035066247.629629629634102.3703703704
24151715148357.093753357.90625
25113344108040.1093755303.890625
26279488148357.09375131130.90625
27125081108040.10937517040.890625
286878866247.62962962962540.37037037036
29103037108040.109375-5003.109375
3010215366247.629629629635905.3703703704
31147172108040.10937539131.890625
32146760148357.09375-1597.09375
33127654148357.09375-20703.09375
34110459108040.1093752418.890625
35131072148357.09375-17285.09375
3612681766247.629629629660569.3703703704
37108535104459.2857142864075.71428571429
388231766247.629629629616069.3703703704
395722466247.6296296296-9023.62962962964
40135356108040.10937527315.890625
4196125108040.109375-11915.109375
42116813417.9285714286-12249.9285714286
43102070108040.109375-5970.109375
44118906108040.10937510865.890625
455990066247.6296296296-6347.62962962964
467901166247.629629629612763.3703703704
47103297108040.109375-4743.109375
48143372108040.10937535331.890625
49109432108040.1093751391.890625
50167949148357.0937519591.90625
51877313417.9285714286-4644.92857142857
524572466247.6296296296-20523.6296296296
53149959148357.093751601.90625
5481351108040.109375-26689.109375
55103129108040.109375-4911.109375
56154451108040.10937546410.890625
5788977108040.109375-19063.109375
58140824148357.09375-7533.09375
5984601108040.109375-23439.109375
60169707148357.0937521349.90625
61187326148357.0937538968.90625
62156349148357.093757991.90625
63108146108040.109375105.890625
64168553148357.0937520195.90625
65144408108040.10937536367.890625
66183500148357.0937535142.90625
67104128108040.109375-3912.109375
683303266247.6296296296-33215.6296296296
694392966247.6296296296-22318.6296296296
7056750104459.285714286-47709.2857142857
71126372148357.09375-21985.09375
72160141108040.10937552100.890625
737157166247.62962962965323.37037037036
74125818148357.09375-22539.09375
753869266247.6296296296-27555.6296296296
769589366247.629629629629645.3703703704
7767150108040.109375-40890.109375
78110529148357.09375-37828.09375
7959938108040.109375-48102.109375
808162566247.629629629615377.3703703704
8171154108040.109375-36886.109375
82104767108040.109375-3273.109375
83125386148357.09375-22971.09375
84165933148357.0937517575.90625
856452066247.6296296296-1727.62962962964
86165986148357.0937517628.90625
87102812108040.109375-5228.109375
8881897108040.109375-26143.109375
893711066247.6296296296-29137.6296296296
90146975108040.10937538934.890625
9192059108040.109375-15981.109375
92144551148357.09375-3806.09375
93184923148357.0937536565.90625
9479756104459.285714286-24703.2857142857
95140015148357.09375-8342.09375
9689506108040.109375-18534.109375
976459366247.6296296296-1654.62962962964
9870168108040.109375-37872.109375
99134238148357.09375-14119.09375
100101047108040.109375-6993.109375
10192622108040.109375-15418.109375
1021411613417.9285714286698.071428571429
1031598613417.92857142862568.07142857143
10489256108040.109375-18784.109375
105150491148357.093752133.90625
106140358108040.10937532317.890625
107114948108040.1093756907.890625
10895671108040.109375-12369.109375
109176225148357.0937527867.90625
11093487104459.285714286-10972.2857142857
11189626108040.109375-18414.109375
1126648566247.6296296296237.370370370365
11379089108040.109375-28951.109375
1145591866247.6296296296-10329.6296296296
115112302108040.1093754261.890625
116104581108040.109375-3459.109375
117117440108040.1093759399.890625
118101629108040.109375-6411.109375
119112098108040.1093754057.890625
12068946148357.09375-79411.09375
121114799108040.1093756758.890625
122119442148357.09375-28915.09375
123100087108040.109375-7953.109375
124139165108040.10937531124.890625
12583243108040.109375-24797.109375
126123534108040.10937515493.890625
127617913417.9285714286-7238.92857142857
128164413417.9285714286-11773.9285714286
129602313417.9285714286-7394.92857142857
130120192148357.09375-28165.09375
13183248108040.109375-24792.109375
132103925108040.109375-4115.109375
13372128108040.109375-35912.109375
134112431108040.1093754390.890625
13592280108040.109375-15760.109375
13683515108040.109375-24525.109375
1374802966247.6296296296-18218.6296296296
13893879104459.285714286-10580.2857142857
13985513417.9285714286-12562.9285714286
140100046108040.109375-7994.109375
1413108166247.6296296296-35166.6296296296
142104978148357.09375-43379.09375
143595013417.9285714286-7467.92857142857
144392613417.9285714286-9491.92857142857



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