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 computationFri, 23 Dec 2011 07:20:11 -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/23/t1324642830fnw0jtt7b2axriz.htm/, Retrieved Mon, 29 Apr 2024 17:55:03 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=160344, Retrieved Mon, 29 Apr 2024 17:55:03 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact80
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Kendall tau Correlation Matrix] [] [2010-12-05 17:44:33] [b98453cac15ba1066b407e146608df68]
- RMPD  [Kendall tau Correlation Matrix] [Paper stat: Stude...] [2011-12-23 11:37:02] [09e53a95f5780167f20e6b4304200573]
- RMP       [Recursive Partitioning (Regression Trees)] [Paper stat: Regre...] [2011-12-23 12:20:11] [9431a512beb885c6943db1a049152d0e] [Current]
- R           [Recursive Partitioning (Regression Trees)] [paper Stat: Tree ...] [2011-12-23 14:27:04] [09e53a95f5780167f20e6b4304200573]
Feedback Forum

Post a new message
Dataseries X:
140824	186099	32033	165	165	130	279055
110459	113854	20654	135	132	143	212408
105079	99776	16346	121	121	118	233939
112098	106194	35926	148	145	146	222117
43929	100792	10621	73	71	73	179751
76173	47552	10024	49	47	89	70849
187326	250931	43068	185	177	146	599777
22807	6853	1271	5	5	22	33186
144408	115466	34416	125	124	132	227332
66485	110896	20318	93	92	92	258874
79089	169351	24409	154	149	147	359064
81625	94853	20648	98	93	203	264989
68788	72591	12347	70	70	113	209202
103297	101345	21857	148	148	171	368577
69446	113713	11034	100	100	87	269455
114948	165354	33433	150	142	208	397286
167949	164263	35902	197	194	153	335567
125081	135213	22355	114	113	97	428322
125818	111669	31219	169	162	95	182016
136588	134163	21983	200	186	197	267365
112431	140303	40085	148	147	160	279428
103037	150773	18507	140	137	148	508849
82317	111848	16278	74	71	84	206722
118906	102509	24662	128	123	227	200004
83515	96785	31452	140	134	154	257139
104581	116136	32580	116	115	151	270941
103129	158376	22883	147	138	142	296850
83243	153990	27652	132	125	148	329962
37110	64057	9845	70	66	110	187155
113344	230054	20190	144	137	149	393860
139165	184531	46201	155	152	179	327660
86652	114198	10971	165	159	149	269239
112302	198299	34811	161	159	187	386982
69652	33750	3029	31	31	153	130446
119442	189723	38941	199	185	163	430118
69867	100826	4958	78	78	127	273950
101629	188355	32344	121	117	151	428077
70168	104470	19433	112	109	100	254312
31081	58391	12558	41	41	46	120351
103925	164808	36524	158	149	156	395643
92622	134097	26041	123	123	128	345875
79011	80238	16637	104	103	111	212715
93487	133252	28395	94	87	119	224524
64520	54518	16747	73	71	148	182485
93473	121850	9105	52	51	65	157164
114360	79367	11941	71	70	134	459455
33032	56968	7935	21	21	66	78800
96125	106314	19499	155	155	201	217932
151911	191889	22938	174	172	177	368086
89256	104864	25314	136	133	156	228688
95676	160792	28527	128	125	158	244765
5950	15049	2694	7	7	7	24188
149695	191179	20867	165	158	175	400109
32551	25109	3597	21	21	61	65029
31701	45824	5296	35	35	41	101097
100087	129711	32982	137	133	133	305666
169707	210012	38975	174	169	228	369627
150491	194679	42721	257	256	140	367127
120192	197680	41455	207	190	155	377704
95893	81180	23923	103	100	141	280106
151715	197765	26719	171	171	181	400971
176225	214738	53405	279	267	75	315924
59900	96252	12526	83	80	97	291391
104767	124527	26584	130	126	142	295075
114799	153242	37062	131	132	136	280018
72128	145707	25696	126	121	87	267432
143592	113963	24634	158	156	140	217181
89626	134904	27269	138	133	169	258166
131072	114268	25270	200	199	129	260919
126817	94333	24634	104	98	92	182961
81351	102204	17828	111	109	160	256967
22618	23824	3007	26	25	67	73566
88977	111563	20065	115	113	179	272362
92059	91313	24648	127	126	90	229056
81897	89770	21588	140	137	144	229851
108146	100125	25217	121	121	144	371391
126372	165278	30927	183	178	144	398210
249771	181712	18487	68	63	134	220419
71154	80906	18050	112	109	146	231884
71571	75881	17696	103	101	121	217714
55918	83963	17326	63	61	112	200046
160141	175721	39361	166	157	145	483074
38692	68580	9648	38	38	99	145943
102812	136323	26759	163	159	96	295224
56622	55792	7905	59	58	27	80953
15986	25157	4527	27	27	77	217384
123534	100922	41517	108	108	137	179344
108535	118845	21261	88	83	151	415550
93879	170492	36099	92	88	126	389059
144551	81716	39039	170	164	159	180679
56750	115750	13841	98	96	101	299505
127654	105590	23841	205	192	144	292260
65594	92795	8589	96	94	102	199481
59938	82390	15049	107	107	135	282361
146975	135599	39038	150	144	147	329281
165904	127667	36774	138	136	155	234577
169265	163073	40076	177	171	138	297995
183500	211381	43840	213	210	113	329583
165986	189944	43146	208	193	248	416463
184923	226168	50099	307	297	116	415683
140358	117495	40312	125	125	176	297080
149959	195894	32616	208	204	140	318283
57224	80684	11338	73	70	59	224033
43750	19630	7409	49	49	64	43287
48029	88634	18213	82	82	40	238089
104978	139292	45873	206	205	98	263322
100046	128602	39844	112	111	139	299566
101047	135848	28317	139	135	135	321797
197426	178377	24797	60	59	97	193926
160902	106330	7471	70	70	142	170491
147172	178303	27259	112	108	155	354041
109432	116938	23201	142	141	115	303273
1168	5841	238	11	11	0	23668
83248	106020	28830	130	130	103	196743
25162	24610	3913	31	28	30	61857
45724	74151	9935	132	101	130	217543
110529	232241	27738	219	216	102	440711
855	6622	338	4	4	0	21054
101382	127097	13326	102	97	77	252805
14116	13155	3988	39	39	9	31961
89506	160501	24347	125	119	150	360436
135356	91502	27111	121	118	163	251948
116066	24469	3938	42	41	148	187003
144244	88229	17416	111	107	94	180842
8773	13983	1888	16	16	21	38214
102153	80716	18700	70	69	151	278173
117440	157384	36809	162	160	187	358276
104128	122975	24959	173	158	171	211775
134238	191469	37343	171	161	170	445926
134047	231257	21849	172	165	145	348017
279488	258287	49809	254	246	198	441946
79756	122531	21654	90	89	152	215177
66089	61394	8728	50	49	112	126320
102070	86480	20920	113	107	173	316128
146760	195791	27195	187	182	177	466139
154771	18284	1037	16	16	153	162279
165933	147581	42570	175	173	161	416643
64593	72558	17672	90	90	115	178322
92280	147341	34245	140	140	147	292443
67150	114651	16786	145	142	124	283913
128692	100187	20954	141	126	57	244802
124089	130332	16378	125	123	144	387072
125386	134218	31852	241	239	126	246963
37238	10901	2805	16	15	78	173260
140015	145758	38086	175	170	153	346748
150047	75767	21166	132	123	196	176654
154451	134969	34672	154	151	130	267742
156349	169216	36171	198	194	159	314070




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160344&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 time5 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net







Goodness of Fit
Correlation0.8179
R-squared0.6689
RMSE27032.3407

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8179[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6689[/C][/ROW]
[ROW][C]RMSE[/C][C]27032.3407[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160344&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160344&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.8179
R-squared0.6689
RMSE27032.3407







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1140824156589.185185185-15765.1851851852
2110459105304.9111111115154.08888888889
3105079105304.911111111-225.911111111112
4112098133964.4-21866.4
54392983147.5517241379-39218.5517241379
67617328178.157894736847994.8421052632
7187326156589.18518518530736.8148148148
82280728178.1578947368-5371.15789473684
9144408133964.410443.6
106648583147.5517241379-16662.5517241379
1179089105304.911111111-26215.9111111111
128162583147.5517241379-1522.55172413793
136878881275.375-12487.375
14103297105304.911111111-2007.91111111111
156944683147.5517241379-13701.5517241379
16114948105304.9111111119643.08888888889
17167949133964.433984.6
18125081105304.91111111119776.0888888889
19125818105304.91111111120513.0888888889
20136588105304.91111111131283.0888888889
21112431133964.4-21533.4
22103037105304.911111111-2267.91111111111
238231783147.5517241379-830.551724137928
24118906105304.91111111113601.0888888889
2583515105304.911111111-21789.9111111111
26104581105304.911111111-723.911111111112
27103129105304.911111111-2175.91111111111
2883243105304.911111111-22061.9111111111
293711028178.15789473688931.84210526316
30113344156589.185185185-43245.1851851852
31139165156589.185185185-17424.1851851852
3286652105304.911111111-18652.9111111111
33112302156589.185185185-44287.1851851852
346965281275.375-11623.375
35119442156589.185185185-37147.1851851852
366986783147.5517241379-13280.5517241379
37101629156589.185185185-54960.1851851852
387016883147.5517241379-12979.5517241379
393108128178.15789473682902.84210526316
40103925133964.4-30039.4
4192622105304.911111111-12682.9111111111
427901183147.5517241379-4136.55172413793
439348783147.551724137910339.4482758621
446452081275.375-16755.375
459347383147.551724137910325.4482758621
4611436083147.551724137931212.4482758621
473303228178.15789473684853.84210526316
4896125105304.911111111-9179.91111111111
49151911156589.185185185-4678.1851851852
5089256105304.911111111-16048.9111111111
5195676105304.911111111-9628.91111111111
52595028178.1578947368-22228.1578947368
53149695156589.185185185-6894.1851851852
543255128178.15789473684372.84210526316
553170128178.15789473683522.84210526316
56100087105304.911111111-5217.91111111111
57169707156589.18518518513117.8148148148
58150491156589.185185185-6098.1851851852
59120192156589.185185185-36397.1851851852
609589383147.551724137912745.4482758621
61151715156589.185185185-4874.1851851852
62176225156589.18518518519635.8148148148
635990083147.5517241379-23247.5517241379
64104767105304.911111111-537.911111111112
65114799133964.4-19165.4
6672128105304.911111111-33176.9111111111
67143592105304.91111111138287.0888888889
6889626105304.911111111-15678.9111111111
69131072105304.91111111125767.0888888889
7012681783147.551724137943669.4482758621
718135183147.5517241379-1796.55172413793
722261828178.1578947368-5560.15789473684
7388977105304.911111111-16327.9111111111
7492059105304.911111111-13245.9111111111
7581897105304.911111111-23407.9111111111
76108146105304.9111111112841.08888888889
77126372105304.91111111121067.0888888889
78249771156589.18518518593181.8148148148
797115483147.5517241379-11993.5517241379
807157183147.5517241379-11576.5517241379
815591883147.5517241379-27229.5517241379
82160141156589.1851851853551.8148148148
833869228178.157894736810513.8421052632
84102812105304.911111111-2492.91111111111
855662228178.157894736828443.8421052632
861598628178.1578947368-12192.1578947368
87123534133964.4-10430.4
8810853583147.551724137925387.4482758621
8993879133964.4-40085.4
90144551133964.410586.6
915675083147.5517241379-26397.5517241379
92127654105304.91111111122349.0888888889
936559483147.5517241379-17553.5517241379
945993883147.5517241379-23209.5517241379
95146975133964.413010.6
96165904133964.431939.6
97169265133964.435300.6
98183500156589.18518518526910.8148148148
99165986156589.1851851859396.8148148148
100184923156589.18518518528333.8148148148
101140358133964.46393.60000000001
102149959156589.185185185-6630.1851851852
1035722483147.5517241379-25923.5517241379
1044375028178.157894736815571.8421052632
1054802983147.5517241379-35118.5517241379
106104978133964.4-28986.4
107100046133964.4-33918.4
108101047105304.911111111-4257.91111111111
109197426156589.18518518540836.8148148148
11016090283147.551724137977754.4482758621
111147172156589.185185185-9417.1851851852
112109432105304.9111111114127.08888888889
113116828178.1578947368-27010.1578947368
11483248105304.911111111-22056.9111111111
1152516228178.1578947368-3016.15789473684
1164572481275.375-35551.375
117110529156589.185185185-46060.1851851852
11885528178.1578947368-27323.1578947368
11910138283147.551724137918234.4482758621
1201411628178.1578947368-14062.1578947368
12189506105304.911111111-15798.9111111111
122135356105304.91111111130051.0888888889
12311606681275.37534790.625
12414424483147.551724137961096.4482758621
125877328178.1578947368-19405.1578947368
12610215383147.551724137919005.4482758621
127117440133964.4-16524.4
128104128105304.911111111-1176.91111111111
129134238156589.185185185-22351.1851851852
130134047156589.185185185-22542.1851851852
131279488156589.185185185122898.814814815
1327975683147.5517241379-3391.55172413793
1336608981275.375-15186.375
134102070105304.911111111-3234.91111111111
135146760156589.185185185-9829.1851851852
13615477181275.37573495.625
137165933133964.431968.6
1386459381275.375-16682.375
13992280105304.911111111-13024.9111111111
14067150105304.911111111-38154.9111111111
141128692105304.91111111123387.0888888889
142124089105304.91111111118784.0888888889
143125386105304.91111111120081.0888888889
1443723828178.15789473689059.84210526316
145140015133964.46050.60000000001
146150047105304.91111111144742.0888888889
147154451133964.420486.6
148156349133964.422384.6

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 140824 & 156589.185185185 & -15765.1851851852 \tabularnewline
2 & 110459 & 105304.911111111 & 5154.08888888889 \tabularnewline
3 & 105079 & 105304.911111111 & -225.911111111112 \tabularnewline
4 & 112098 & 133964.4 & -21866.4 \tabularnewline
5 & 43929 & 83147.5517241379 & -39218.5517241379 \tabularnewline
6 & 76173 & 28178.1578947368 & 47994.8421052632 \tabularnewline
7 & 187326 & 156589.185185185 & 30736.8148148148 \tabularnewline
8 & 22807 & 28178.1578947368 & -5371.15789473684 \tabularnewline
9 & 144408 & 133964.4 & 10443.6 \tabularnewline
10 & 66485 & 83147.5517241379 & -16662.5517241379 \tabularnewline
11 & 79089 & 105304.911111111 & -26215.9111111111 \tabularnewline
12 & 81625 & 83147.5517241379 & -1522.55172413793 \tabularnewline
13 & 68788 & 81275.375 & -12487.375 \tabularnewline
14 & 103297 & 105304.911111111 & -2007.91111111111 \tabularnewline
15 & 69446 & 83147.5517241379 & -13701.5517241379 \tabularnewline
16 & 114948 & 105304.911111111 & 9643.08888888889 \tabularnewline
17 & 167949 & 133964.4 & 33984.6 \tabularnewline
18 & 125081 & 105304.911111111 & 19776.0888888889 \tabularnewline
19 & 125818 & 105304.911111111 & 20513.0888888889 \tabularnewline
20 & 136588 & 105304.911111111 & 31283.0888888889 \tabularnewline
21 & 112431 & 133964.4 & -21533.4 \tabularnewline
22 & 103037 & 105304.911111111 & -2267.91111111111 \tabularnewline
23 & 82317 & 83147.5517241379 & -830.551724137928 \tabularnewline
24 & 118906 & 105304.911111111 & 13601.0888888889 \tabularnewline
25 & 83515 & 105304.911111111 & -21789.9111111111 \tabularnewline
26 & 104581 & 105304.911111111 & -723.911111111112 \tabularnewline
27 & 103129 & 105304.911111111 & -2175.91111111111 \tabularnewline
28 & 83243 & 105304.911111111 & -22061.9111111111 \tabularnewline
29 & 37110 & 28178.1578947368 & 8931.84210526316 \tabularnewline
30 & 113344 & 156589.185185185 & -43245.1851851852 \tabularnewline
31 & 139165 & 156589.185185185 & -17424.1851851852 \tabularnewline
32 & 86652 & 105304.911111111 & -18652.9111111111 \tabularnewline
33 & 112302 & 156589.185185185 & -44287.1851851852 \tabularnewline
34 & 69652 & 81275.375 & -11623.375 \tabularnewline
35 & 119442 & 156589.185185185 & -37147.1851851852 \tabularnewline
36 & 69867 & 83147.5517241379 & -13280.5517241379 \tabularnewline
37 & 101629 & 156589.185185185 & -54960.1851851852 \tabularnewline
38 & 70168 & 83147.5517241379 & -12979.5517241379 \tabularnewline
39 & 31081 & 28178.1578947368 & 2902.84210526316 \tabularnewline
40 & 103925 & 133964.4 & -30039.4 \tabularnewline
41 & 92622 & 105304.911111111 & -12682.9111111111 \tabularnewline
42 & 79011 & 83147.5517241379 & -4136.55172413793 \tabularnewline
43 & 93487 & 83147.5517241379 & 10339.4482758621 \tabularnewline
44 & 64520 & 81275.375 & -16755.375 \tabularnewline
45 & 93473 & 83147.5517241379 & 10325.4482758621 \tabularnewline
46 & 114360 & 83147.5517241379 & 31212.4482758621 \tabularnewline
47 & 33032 & 28178.1578947368 & 4853.84210526316 \tabularnewline
48 & 96125 & 105304.911111111 & -9179.91111111111 \tabularnewline
49 & 151911 & 156589.185185185 & -4678.1851851852 \tabularnewline
50 & 89256 & 105304.911111111 & -16048.9111111111 \tabularnewline
51 & 95676 & 105304.911111111 & -9628.91111111111 \tabularnewline
52 & 5950 & 28178.1578947368 & -22228.1578947368 \tabularnewline
53 & 149695 & 156589.185185185 & -6894.1851851852 \tabularnewline
54 & 32551 & 28178.1578947368 & 4372.84210526316 \tabularnewline
55 & 31701 & 28178.1578947368 & 3522.84210526316 \tabularnewline
56 & 100087 & 105304.911111111 & -5217.91111111111 \tabularnewline
57 & 169707 & 156589.185185185 & 13117.8148148148 \tabularnewline
58 & 150491 & 156589.185185185 & -6098.1851851852 \tabularnewline
59 & 120192 & 156589.185185185 & -36397.1851851852 \tabularnewline
60 & 95893 & 83147.5517241379 & 12745.4482758621 \tabularnewline
61 & 151715 & 156589.185185185 & -4874.1851851852 \tabularnewline
62 & 176225 & 156589.185185185 & 19635.8148148148 \tabularnewline
63 & 59900 & 83147.5517241379 & -23247.5517241379 \tabularnewline
64 & 104767 & 105304.911111111 & -537.911111111112 \tabularnewline
65 & 114799 & 133964.4 & -19165.4 \tabularnewline
66 & 72128 & 105304.911111111 & -33176.9111111111 \tabularnewline
67 & 143592 & 105304.911111111 & 38287.0888888889 \tabularnewline
68 & 89626 & 105304.911111111 & -15678.9111111111 \tabularnewline
69 & 131072 & 105304.911111111 & 25767.0888888889 \tabularnewline
70 & 126817 & 83147.5517241379 & 43669.4482758621 \tabularnewline
71 & 81351 & 83147.5517241379 & -1796.55172413793 \tabularnewline
72 & 22618 & 28178.1578947368 & -5560.15789473684 \tabularnewline
73 & 88977 & 105304.911111111 & -16327.9111111111 \tabularnewline
74 & 92059 & 105304.911111111 & -13245.9111111111 \tabularnewline
75 & 81897 & 105304.911111111 & -23407.9111111111 \tabularnewline
76 & 108146 & 105304.911111111 & 2841.08888888889 \tabularnewline
77 & 126372 & 105304.911111111 & 21067.0888888889 \tabularnewline
78 & 249771 & 156589.185185185 & 93181.8148148148 \tabularnewline
79 & 71154 & 83147.5517241379 & -11993.5517241379 \tabularnewline
80 & 71571 & 83147.5517241379 & -11576.5517241379 \tabularnewline
81 & 55918 & 83147.5517241379 & -27229.5517241379 \tabularnewline
82 & 160141 & 156589.185185185 & 3551.8148148148 \tabularnewline
83 & 38692 & 28178.1578947368 & 10513.8421052632 \tabularnewline
84 & 102812 & 105304.911111111 & -2492.91111111111 \tabularnewline
85 & 56622 & 28178.1578947368 & 28443.8421052632 \tabularnewline
86 & 15986 & 28178.1578947368 & -12192.1578947368 \tabularnewline
87 & 123534 & 133964.4 & -10430.4 \tabularnewline
88 & 108535 & 83147.5517241379 & 25387.4482758621 \tabularnewline
89 & 93879 & 133964.4 & -40085.4 \tabularnewline
90 & 144551 & 133964.4 & 10586.6 \tabularnewline
91 & 56750 & 83147.5517241379 & -26397.5517241379 \tabularnewline
92 & 127654 & 105304.911111111 & 22349.0888888889 \tabularnewline
93 & 65594 & 83147.5517241379 & -17553.5517241379 \tabularnewline
94 & 59938 & 83147.5517241379 & -23209.5517241379 \tabularnewline
95 & 146975 & 133964.4 & 13010.6 \tabularnewline
96 & 165904 & 133964.4 & 31939.6 \tabularnewline
97 & 169265 & 133964.4 & 35300.6 \tabularnewline
98 & 183500 & 156589.185185185 & 26910.8148148148 \tabularnewline
99 & 165986 & 156589.185185185 & 9396.8148148148 \tabularnewline
100 & 184923 & 156589.185185185 & 28333.8148148148 \tabularnewline
101 & 140358 & 133964.4 & 6393.60000000001 \tabularnewline
102 & 149959 & 156589.185185185 & -6630.1851851852 \tabularnewline
103 & 57224 & 83147.5517241379 & -25923.5517241379 \tabularnewline
104 & 43750 & 28178.1578947368 & 15571.8421052632 \tabularnewline
105 & 48029 & 83147.5517241379 & -35118.5517241379 \tabularnewline
106 & 104978 & 133964.4 & -28986.4 \tabularnewline
107 & 100046 & 133964.4 & -33918.4 \tabularnewline
108 & 101047 & 105304.911111111 & -4257.91111111111 \tabularnewline
109 & 197426 & 156589.185185185 & 40836.8148148148 \tabularnewline
110 & 160902 & 83147.5517241379 & 77754.4482758621 \tabularnewline
111 & 147172 & 156589.185185185 & -9417.1851851852 \tabularnewline
112 & 109432 & 105304.911111111 & 4127.08888888889 \tabularnewline
113 & 1168 & 28178.1578947368 & -27010.1578947368 \tabularnewline
114 & 83248 & 105304.911111111 & -22056.9111111111 \tabularnewline
115 & 25162 & 28178.1578947368 & -3016.15789473684 \tabularnewline
116 & 45724 & 81275.375 & -35551.375 \tabularnewline
117 & 110529 & 156589.185185185 & -46060.1851851852 \tabularnewline
118 & 855 & 28178.1578947368 & -27323.1578947368 \tabularnewline
119 & 101382 & 83147.5517241379 & 18234.4482758621 \tabularnewline
120 & 14116 & 28178.1578947368 & -14062.1578947368 \tabularnewline
121 & 89506 & 105304.911111111 & -15798.9111111111 \tabularnewline
122 & 135356 & 105304.911111111 & 30051.0888888889 \tabularnewline
123 & 116066 & 81275.375 & 34790.625 \tabularnewline
124 & 144244 & 83147.5517241379 & 61096.4482758621 \tabularnewline
125 & 8773 & 28178.1578947368 & -19405.1578947368 \tabularnewline
126 & 102153 & 83147.5517241379 & 19005.4482758621 \tabularnewline
127 & 117440 & 133964.4 & -16524.4 \tabularnewline
128 & 104128 & 105304.911111111 & -1176.91111111111 \tabularnewline
129 & 134238 & 156589.185185185 & -22351.1851851852 \tabularnewline
130 & 134047 & 156589.185185185 & -22542.1851851852 \tabularnewline
131 & 279488 & 156589.185185185 & 122898.814814815 \tabularnewline
132 & 79756 & 83147.5517241379 & -3391.55172413793 \tabularnewline
133 & 66089 & 81275.375 & -15186.375 \tabularnewline
134 & 102070 & 105304.911111111 & -3234.91111111111 \tabularnewline
135 & 146760 & 156589.185185185 & -9829.1851851852 \tabularnewline
136 & 154771 & 81275.375 & 73495.625 \tabularnewline
137 & 165933 & 133964.4 & 31968.6 \tabularnewline
138 & 64593 & 81275.375 & -16682.375 \tabularnewline
139 & 92280 & 105304.911111111 & -13024.9111111111 \tabularnewline
140 & 67150 & 105304.911111111 & -38154.9111111111 \tabularnewline
141 & 128692 & 105304.911111111 & 23387.0888888889 \tabularnewline
142 & 124089 & 105304.911111111 & 18784.0888888889 \tabularnewline
143 & 125386 & 105304.911111111 & 20081.0888888889 \tabularnewline
144 & 37238 & 28178.1578947368 & 9059.84210526316 \tabularnewline
145 & 140015 & 133964.4 & 6050.60000000001 \tabularnewline
146 & 150047 & 105304.911111111 & 44742.0888888889 \tabularnewline
147 & 154451 & 133964.4 & 20486.6 \tabularnewline
148 & 156349 & 133964.4 & 22384.6 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160344&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]140824[/C][C]156589.185185185[/C][C]-15765.1851851852[/C][/ROW]
[ROW][C]2[/C][C]110459[/C][C]105304.911111111[/C][C]5154.08888888889[/C][/ROW]
[ROW][C]3[/C][C]105079[/C][C]105304.911111111[/C][C]-225.911111111112[/C][/ROW]
[ROW][C]4[/C][C]112098[/C][C]133964.4[/C][C]-21866.4[/C][/ROW]
[ROW][C]5[/C][C]43929[/C][C]83147.5517241379[/C][C]-39218.5517241379[/C][/ROW]
[ROW][C]6[/C][C]76173[/C][C]28178.1578947368[/C][C]47994.8421052632[/C][/ROW]
[ROW][C]7[/C][C]187326[/C][C]156589.185185185[/C][C]30736.8148148148[/C][/ROW]
[ROW][C]8[/C][C]22807[/C][C]28178.1578947368[/C][C]-5371.15789473684[/C][/ROW]
[ROW][C]9[/C][C]144408[/C][C]133964.4[/C][C]10443.6[/C][/ROW]
[ROW][C]10[/C][C]66485[/C][C]83147.5517241379[/C][C]-16662.5517241379[/C][/ROW]
[ROW][C]11[/C][C]79089[/C][C]105304.911111111[/C][C]-26215.9111111111[/C][/ROW]
[ROW][C]12[/C][C]81625[/C][C]83147.5517241379[/C][C]-1522.55172413793[/C][/ROW]
[ROW][C]13[/C][C]68788[/C][C]81275.375[/C][C]-12487.375[/C][/ROW]
[ROW][C]14[/C][C]103297[/C][C]105304.911111111[/C][C]-2007.91111111111[/C][/ROW]
[ROW][C]15[/C][C]69446[/C][C]83147.5517241379[/C][C]-13701.5517241379[/C][/ROW]
[ROW][C]16[/C][C]114948[/C][C]105304.911111111[/C][C]9643.08888888889[/C][/ROW]
[ROW][C]17[/C][C]167949[/C][C]133964.4[/C][C]33984.6[/C][/ROW]
[ROW][C]18[/C][C]125081[/C][C]105304.911111111[/C][C]19776.0888888889[/C][/ROW]
[ROW][C]19[/C][C]125818[/C][C]105304.911111111[/C][C]20513.0888888889[/C][/ROW]
[ROW][C]20[/C][C]136588[/C][C]105304.911111111[/C][C]31283.0888888889[/C][/ROW]
[ROW][C]21[/C][C]112431[/C][C]133964.4[/C][C]-21533.4[/C][/ROW]
[ROW][C]22[/C][C]103037[/C][C]105304.911111111[/C][C]-2267.91111111111[/C][/ROW]
[ROW][C]23[/C][C]82317[/C][C]83147.5517241379[/C][C]-830.551724137928[/C][/ROW]
[ROW][C]24[/C][C]118906[/C][C]105304.911111111[/C][C]13601.0888888889[/C][/ROW]
[ROW][C]25[/C][C]83515[/C][C]105304.911111111[/C][C]-21789.9111111111[/C][/ROW]
[ROW][C]26[/C][C]104581[/C][C]105304.911111111[/C][C]-723.911111111112[/C][/ROW]
[ROW][C]27[/C][C]103129[/C][C]105304.911111111[/C][C]-2175.91111111111[/C][/ROW]
[ROW][C]28[/C][C]83243[/C][C]105304.911111111[/C][C]-22061.9111111111[/C][/ROW]
[ROW][C]29[/C][C]37110[/C][C]28178.1578947368[/C][C]8931.84210526316[/C][/ROW]
[ROW][C]30[/C][C]113344[/C][C]156589.185185185[/C][C]-43245.1851851852[/C][/ROW]
[ROW][C]31[/C][C]139165[/C][C]156589.185185185[/C][C]-17424.1851851852[/C][/ROW]
[ROW][C]32[/C][C]86652[/C][C]105304.911111111[/C][C]-18652.9111111111[/C][/ROW]
[ROW][C]33[/C][C]112302[/C][C]156589.185185185[/C][C]-44287.1851851852[/C][/ROW]
[ROW][C]34[/C][C]69652[/C][C]81275.375[/C][C]-11623.375[/C][/ROW]
[ROW][C]35[/C][C]119442[/C][C]156589.185185185[/C][C]-37147.1851851852[/C][/ROW]
[ROW][C]36[/C][C]69867[/C][C]83147.5517241379[/C][C]-13280.5517241379[/C][/ROW]
[ROW][C]37[/C][C]101629[/C][C]156589.185185185[/C][C]-54960.1851851852[/C][/ROW]
[ROW][C]38[/C][C]70168[/C][C]83147.5517241379[/C][C]-12979.5517241379[/C][/ROW]
[ROW][C]39[/C][C]31081[/C][C]28178.1578947368[/C][C]2902.84210526316[/C][/ROW]
[ROW][C]40[/C][C]103925[/C][C]133964.4[/C][C]-30039.4[/C][/ROW]
[ROW][C]41[/C][C]92622[/C][C]105304.911111111[/C][C]-12682.9111111111[/C][/ROW]
[ROW][C]42[/C][C]79011[/C][C]83147.5517241379[/C][C]-4136.55172413793[/C][/ROW]
[ROW][C]43[/C][C]93487[/C][C]83147.5517241379[/C][C]10339.4482758621[/C][/ROW]
[ROW][C]44[/C][C]64520[/C][C]81275.375[/C][C]-16755.375[/C][/ROW]
[ROW][C]45[/C][C]93473[/C][C]83147.5517241379[/C][C]10325.4482758621[/C][/ROW]
[ROW][C]46[/C][C]114360[/C][C]83147.5517241379[/C][C]31212.4482758621[/C][/ROW]
[ROW][C]47[/C][C]33032[/C][C]28178.1578947368[/C][C]4853.84210526316[/C][/ROW]
[ROW][C]48[/C][C]96125[/C][C]105304.911111111[/C][C]-9179.91111111111[/C][/ROW]
[ROW][C]49[/C][C]151911[/C][C]156589.185185185[/C][C]-4678.1851851852[/C][/ROW]
[ROW][C]50[/C][C]89256[/C][C]105304.911111111[/C][C]-16048.9111111111[/C][/ROW]
[ROW][C]51[/C][C]95676[/C][C]105304.911111111[/C][C]-9628.91111111111[/C][/ROW]
[ROW][C]52[/C][C]5950[/C][C]28178.1578947368[/C][C]-22228.1578947368[/C][/ROW]
[ROW][C]53[/C][C]149695[/C][C]156589.185185185[/C][C]-6894.1851851852[/C][/ROW]
[ROW][C]54[/C][C]32551[/C][C]28178.1578947368[/C][C]4372.84210526316[/C][/ROW]
[ROW][C]55[/C][C]31701[/C][C]28178.1578947368[/C][C]3522.84210526316[/C][/ROW]
[ROW][C]56[/C][C]100087[/C][C]105304.911111111[/C][C]-5217.91111111111[/C][/ROW]
[ROW][C]57[/C][C]169707[/C][C]156589.185185185[/C][C]13117.8148148148[/C][/ROW]
[ROW][C]58[/C][C]150491[/C][C]156589.185185185[/C][C]-6098.1851851852[/C][/ROW]
[ROW][C]59[/C][C]120192[/C][C]156589.185185185[/C][C]-36397.1851851852[/C][/ROW]
[ROW][C]60[/C][C]95893[/C][C]83147.5517241379[/C][C]12745.4482758621[/C][/ROW]
[ROW][C]61[/C][C]151715[/C][C]156589.185185185[/C][C]-4874.1851851852[/C][/ROW]
[ROW][C]62[/C][C]176225[/C][C]156589.185185185[/C][C]19635.8148148148[/C][/ROW]
[ROW][C]63[/C][C]59900[/C][C]83147.5517241379[/C][C]-23247.5517241379[/C][/ROW]
[ROW][C]64[/C][C]104767[/C][C]105304.911111111[/C][C]-537.911111111112[/C][/ROW]
[ROW][C]65[/C][C]114799[/C][C]133964.4[/C][C]-19165.4[/C][/ROW]
[ROW][C]66[/C][C]72128[/C][C]105304.911111111[/C][C]-33176.9111111111[/C][/ROW]
[ROW][C]67[/C][C]143592[/C][C]105304.911111111[/C][C]38287.0888888889[/C][/ROW]
[ROW][C]68[/C][C]89626[/C][C]105304.911111111[/C][C]-15678.9111111111[/C][/ROW]
[ROW][C]69[/C][C]131072[/C][C]105304.911111111[/C][C]25767.0888888889[/C][/ROW]
[ROW][C]70[/C][C]126817[/C][C]83147.5517241379[/C][C]43669.4482758621[/C][/ROW]
[ROW][C]71[/C][C]81351[/C][C]83147.5517241379[/C][C]-1796.55172413793[/C][/ROW]
[ROW][C]72[/C][C]22618[/C][C]28178.1578947368[/C][C]-5560.15789473684[/C][/ROW]
[ROW][C]73[/C][C]88977[/C][C]105304.911111111[/C][C]-16327.9111111111[/C][/ROW]
[ROW][C]74[/C][C]92059[/C][C]105304.911111111[/C][C]-13245.9111111111[/C][/ROW]
[ROW][C]75[/C][C]81897[/C][C]105304.911111111[/C][C]-23407.9111111111[/C][/ROW]
[ROW][C]76[/C][C]108146[/C][C]105304.911111111[/C][C]2841.08888888889[/C][/ROW]
[ROW][C]77[/C][C]126372[/C][C]105304.911111111[/C][C]21067.0888888889[/C][/ROW]
[ROW][C]78[/C][C]249771[/C][C]156589.185185185[/C][C]93181.8148148148[/C][/ROW]
[ROW][C]79[/C][C]71154[/C][C]83147.5517241379[/C][C]-11993.5517241379[/C][/ROW]
[ROW][C]80[/C][C]71571[/C][C]83147.5517241379[/C][C]-11576.5517241379[/C][/ROW]
[ROW][C]81[/C][C]55918[/C][C]83147.5517241379[/C][C]-27229.5517241379[/C][/ROW]
[ROW][C]82[/C][C]160141[/C][C]156589.185185185[/C][C]3551.8148148148[/C][/ROW]
[ROW][C]83[/C][C]38692[/C][C]28178.1578947368[/C][C]10513.8421052632[/C][/ROW]
[ROW][C]84[/C][C]102812[/C][C]105304.911111111[/C][C]-2492.91111111111[/C][/ROW]
[ROW][C]85[/C][C]56622[/C][C]28178.1578947368[/C][C]28443.8421052632[/C][/ROW]
[ROW][C]86[/C][C]15986[/C][C]28178.1578947368[/C][C]-12192.1578947368[/C][/ROW]
[ROW][C]87[/C][C]123534[/C][C]133964.4[/C][C]-10430.4[/C][/ROW]
[ROW][C]88[/C][C]108535[/C][C]83147.5517241379[/C][C]25387.4482758621[/C][/ROW]
[ROW][C]89[/C][C]93879[/C][C]133964.4[/C][C]-40085.4[/C][/ROW]
[ROW][C]90[/C][C]144551[/C][C]133964.4[/C][C]10586.6[/C][/ROW]
[ROW][C]91[/C][C]56750[/C][C]83147.5517241379[/C][C]-26397.5517241379[/C][/ROW]
[ROW][C]92[/C][C]127654[/C][C]105304.911111111[/C][C]22349.0888888889[/C][/ROW]
[ROW][C]93[/C][C]65594[/C][C]83147.5517241379[/C][C]-17553.5517241379[/C][/ROW]
[ROW][C]94[/C][C]59938[/C][C]83147.5517241379[/C][C]-23209.5517241379[/C][/ROW]
[ROW][C]95[/C][C]146975[/C][C]133964.4[/C][C]13010.6[/C][/ROW]
[ROW][C]96[/C][C]165904[/C][C]133964.4[/C][C]31939.6[/C][/ROW]
[ROW][C]97[/C][C]169265[/C][C]133964.4[/C][C]35300.6[/C][/ROW]
[ROW][C]98[/C][C]183500[/C][C]156589.185185185[/C][C]26910.8148148148[/C][/ROW]
[ROW][C]99[/C][C]165986[/C][C]156589.185185185[/C][C]9396.8148148148[/C][/ROW]
[ROW][C]100[/C][C]184923[/C][C]156589.185185185[/C][C]28333.8148148148[/C][/ROW]
[ROW][C]101[/C][C]140358[/C][C]133964.4[/C][C]6393.60000000001[/C][/ROW]
[ROW][C]102[/C][C]149959[/C][C]156589.185185185[/C][C]-6630.1851851852[/C][/ROW]
[ROW][C]103[/C][C]57224[/C][C]83147.5517241379[/C][C]-25923.5517241379[/C][/ROW]
[ROW][C]104[/C][C]43750[/C][C]28178.1578947368[/C][C]15571.8421052632[/C][/ROW]
[ROW][C]105[/C][C]48029[/C][C]83147.5517241379[/C][C]-35118.5517241379[/C][/ROW]
[ROW][C]106[/C][C]104978[/C][C]133964.4[/C][C]-28986.4[/C][/ROW]
[ROW][C]107[/C][C]100046[/C][C]133964.4[/C][C]-33918.4[/C][/ROW]
[ROW][C]108[/C][C]101047[/C][C]105304.911111111[/C][C]-4257.91111111111[/C][/ROW]
[ROW][C]109[/C][C]197426[/C][C]156589.185185185[/C][C]40836.8148148148[/C][/ROW]
[ROW][C]110[/C][C]160902[/C][C]83147.5517241379[/C][C]77754.4482758621[/C][/ROW]
[ROW][C]111[/C][C]147172[/C][C]156589.185185185[/C][C]-9417.1851851852[/C][/ROW]
[ROW][C]112[/C][C]109432[/C][C]105304.911111111[/C][C]4127.08888888889[/C][/ROW]
[ROW][C]113[/C][C]1168[/C][C]28178.1578947368[/C][C]-27010.1578947368[/C][/ROW]
[ROW][C]114[/C][C]83248[/C][C]105304.911111111[/C][C]-22056.9111111111[/C][/ROW]
[ROW][C]115[/C][C]25162[/C][C]28178.1578947368[/C][C]-3016.15789473684[/C][/ROW]
[ROW][C]116[/C][C]45724[/C][C]81275.375[/C][C]-35551.375[/C][/ROW]
[ROW][C]117[/C][C]110529[/C][C]156589.185185185[/C][C]-46060.1851851852[/C][/ROW]
[ROW][C]118[/C][C]855[/C][C]28178.1578947368[/C][C]-27323.1578947368[/C][/ROW]
[ROW][C]119[/C][C]101382[/C][C]83147.5517241379[/C][C]18234.4482758621[/C][/ROW]
[ROW][C]120[/C][C]14116[/C][C]28178.1578947368[/C][C]-14062.1578947368[/C][/ROW]
[ROW][C]121[/C][C]89506[/C][C]105304.911111111[/C][C]-15798.9111111111[/C][/ROW]
[ROW][C]122[/C][C]135356[/C][C]105304.911111111[/C][C]30051.0888888889[/C][/ROW]
[ROW][C]123[/C][C]116066[/C][C]81275.375[/C][C]34790.625[/C][/ROW]
[ROW][C]124[/C][C]144244[/C][C]83147.5517241379[/C][C]61096.4482758621[/C][/ROW]
[ROW][C]125[/C][C]8773[/C][C]28178.1578947368[/C][C]-19405.1578947368[/C][/ROW]
[ROW][C]126[/C][C]102153[/C][C]83147.5517241379[/C][C]19005.4482758621[/C][/ROW]
[ROW][C]127[/C][C]117440[/C][C]133964.4[/C][C]-16524.4[/C][/ROW]
[ROW][C]128[/C][C]104128[/C][C]105304.911111111[/C][C]-1176.91111111111[/C][/ROW]
[ROW][C]129[/C][C]134238[/C][C]156589.185185185[/C][C]-22351.1851851852[/C][/ROW]
[ROW][C]130[/C][C]134047[/C][C]156589.185185185[/C][C]-22542.1851851852[/C][/ROW]
[ROW][C]131[/C][C]279488[/C][C]156589.185185185[/C][C]122898.814814815[/C][/ROW]
[ROW][C]132[/C][C]79756[/C][C]83147.5517241379[/C][C]-3391.55172413793[/C][/ROW]
[ROW][C]133[/C][C]66089[/C][C]81275.375[/C][C]-15186.375[/C][/ROW]
[ROW][C]134[/C][C]102070[/C][C]105304.911111111[/C][C]-3234.91111111111[/C][/ROW]
[ROW][C]135[/C][C]146760[/C][C]156589.185185185[/C][C]-9829.1851851852[/C][/ROW]
[ROW][C]136[/C][C]154771[/C][C]81275.375[/C][C]73495.625[/C][/ROW]
[ROW][C]137[/C][C]165933[/C][C]133964.4[/C][C]31968.6[/C][/ROW]
[ROW][C]138[/C][C]64593[/C][C]81275.375[/C][C]-16682.375[/C][/ROW]
[ROW][C]139[/C][C]92280[/C][C]105304.911111111[/C][C]-13024.9111111111[/C][/ROW]
[ROW][C]140[/C][C]67150[/C][C]105304.911111111[/C][C]-38154.9111111111[/C][/ROW]
[ROW][C]141[/C][C]128692[/C][C]105304.911111111[/C][C]23387.0888888889[/C][/ROW]
[ROW][C]142[/C][C]124089[/C][C]105304.911111111[/C][C]18784.0888888889[/C][/ROW]
[ROW][C]143[/C][C]125386[/C][C]105304.911111111[/C][C]20081.0888888889[/C][/ROW]
[ROW][C]144[/C][C]37238[/C][C]28178.1578947368[/C][C]9059.84210526316[/C][/ROW]
[ROW][C]145[/C][C]140015[/C][C]133964.4[/C][C]6050.60000000001[/C][/ROW]
[ROW][C]146[/C][C]150047[/C][C]105304.911111111[/C][C]44742.0888888889[/C][/ROW]
[ROW][C]147[/C][C]154451[/C][C]133964.4[/C][C]20486.6[/C][/ROW]
[ROW][C]148[/C][C]156349[/C][C]133964.4[/C][C]22384.6[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160344&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160344&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
1140824156589.185185185-15765.1851851852
2110459105304.9111111115154.08888888889
3105079105304.911111111-225.911111111112
4112098133964.4-21866.4
54392983147.5517241379-39218.5517241379
67617328178.157894736847994.8421052632
7187326156589.18518518530736.8148148148
82280728178.1578947368-5371.15789473684
9144408133964.410443.6
106648583147.5517241379-16662.5517241379
1179089105304.911111111-26215.9111111111
128162583147.5517241379-1522.55172413793
136878881275.375-12487.375
14103297105304.911111111-2007.91111111111
156944683147.5517241379-13701.5517241379
16114948105304.9111111119643.08888888889
17167949133964.433984.6
18125081105304.91111111119776.0888888889
19125818105304.91111111120513.0888888889
20136588105304.91111111131283.0888888889
21112431133964.4-21533.4
22103037105304.911111111-2267.91111111111
238231783147.5517241379-830.551724137928
24118906105304.91111111113601.0888888889
2583515105304.911111111-21789.9111111111
26104581105304.911111111-723.911111111112
27103129105304.911111111-2175.91111111111
2883243105304.911111111-22061.9111111111
293711028178.15789473688931.84210526316
30113344156589.185185185-43245.1851851852
31139165156589.185185185-17424.1851851852
3286652105304.911111111-18652.9111111111
33112302156589.185185185-44287.1851851852
346965281275.375-11623.375
35119442156589.185185185-37147.1851851852
366986783147.5517241379-13280.5517241379
37101629156589.185185185-54960.1851851852
387016883147.5517241379-12979.5517241379
393108128178.15789473682902.84210526316
40103925133964.4-30039.4
4192622105304.911111111-12682.9111111111
427901183147.5517241379-4136.55172413793
439348783147.551724137910339.4482758621
446452081275.375-16755.375
459347383147.551724137910325.4482758621
4611436083147.551724137931212.4482758621
473303228178.15789473684853.84210526316
4896125105304.911111111-9179.91111111111
49151911156589.185185185-4678.1851851852
5089256105304.911111111-16048.9111111111
5195676105304.911111111-9628.91111111111
52595028178.1578947368-22228.1578947368
53149695156589.185185185-6894.1851851852
543255128178.15789473684372.84210526316
553170128178.15789473683522.84210526316
56100087105304.911111111-5217.91111111111
57169707156589.18518518513117.8148148148
58150491156589.185185185-6098.1851851852
59120192156589.185185185-36397.1851851852
609589383147.551724137912745.4482758621
61151715156589.185185185-4874.1851851852
62176225156589.18518518519635.8148148148
635990083147.5517241379-23247.5517241379
64104767105304.911111111-537.911111111112
65114799133964.4-19165.4
6672128105304.911111111-33176.9111111111
67143592105304.91111111138287.0888888889
6889626105304.911111111-15678.9111111111
69131072105304.91111111125767.0888888889
7012681783147.551724137943669.4482758621
718135183147.5517241379-1796.55172413793
722261828178.1578947368-5560.15789473684
7388977105304.911111111-16327.9111111111
7492059105304.911111111-13245.9111111111
7581897105304.911111111-23407.9111111111
76108146105304.9111111112841.08888888889
77126372105304.91111111121067.0888888889
78249771156589.18518518593181.8148148148
797115483147.5517241379-11993.5517241379
807157183147.5517241379-11576.5517241379
815591883147.5517241379-27229.5517241379
82160141156589.1851851853551.8148148148
833869228178.157894736810513.8421052632
84102812105304.911111111-2492.91111111111
855662228178.157894736828443.8421052632
861598628178.1578947368-12192.1578947368
87123534133964.4-10430.4
8810853583147.551724137925387.4482758621
8993879133964.4-40085.4
90144551133964.410586.6
915675083147.5517241379-26397.5517241379
92127654105304.91111111122349.0888888889
936559483147.5517241379-17553.5517241379
945993883147.5517241379-23209.5517241379
95146975133964.413010.6
96165904133964.431939.6
97169265133964.435300.6
98183500156589.18518518526910.8148148148
99165986156589.1851851859396.8148148148
100184923156589.18518518528333.8148148148
101140358133964.46393.60000000001
102149959156589.185185185-6630.1851851852
1035722483147.5517241379-25923.5517241379
1044375028178.157894736815571.8421052632
1054802983147.5517241379-35118.5517241379
106104978133964.4-28986.4
107100046133964.4-33918.4
108101047105304.911111111-4257.91111111111
109197426156589.18518518540836.8148148148
11016090283147.551724137977754.4482758621
111147172156589.185185185-9417.1851851852
112109432105304.9111111114127.08888888889
113116828178.1578947368-27010.1578947368
11483248105304.911111111-22056.9111111111
1152516228178.1578947368-3016.15789473684
1164572481275.375-35551.375
117110529156589.185185185-46060.1851851852
11885528178.1578947368-27323.1578947368
11910138283147.551724137918234.4482758621
1201411628178.1578947368-14062.1578947368
12189506105304.911111111-15798.9111111111
122135356105304.91111111130051.0888888889
12311606681275.37534790.625
12414424483147.551724137961096.4482758621
125877328178.1578947368-19405.1578947368
12610215383147.551724137919005.4482758621
127117440133964.4-16524.4
128104128105304.911111111-1176.91111111111
129134238156589.185185185-22351.1851851852
130134047156589.185185185-22542.1851851852
131279488156589.185185185122898.814814815
1327975683147.5517241379-3391.55172413793
1336608981275.375-15186.375
134102070105304.911111111-3234.91111111111
135146760156589.185185185-9829.1851851852
13615477181275.37573495.625
137165933133964.431968.6
1386459381275.375-16682.375
13992280105304.911111111-13024.9111111111
14067150105304.911111111-38154.9111111111
141128692105304.91111111123387.0888888889
142124089105304.91111111118784.0888888889
143125386105304.91111111120081.0888888889
1443723828178.15789473689059.84210526316
145140015133964.46050.60000000001
146150047105304.91111111144742.0888888889
147154451133964.420486.6
148156349133964.422384.6



Parameters (Session):
par1 = 1 ; par2 = none ; par3 = 3 ; par4 = no ;
Parameters (R input):
par1 = 1 ; par2 = none ; par3 = 3 ; par4 = no ;
R code (references can be found in the software module):
library(party)
library(Hmisc)
par1 <- as.numeric(par1)
par3 <- as.numeric(par3)
x <- data.frame(t(y))
is.data.frame(x)
x <- x[!is.na(x[,par1]),]
k <- length(x[1,])
n <- length(x[,1])
colnames(x)[par1]
x[,par1]
if (par2 == 'kmeans') {
cl <- kmeans(x[,par1], par3)
print(cl)
clm <- matrix(cbind(cl$centers,1:par3),ncol=2)
clm <- clm[sort.list(clm[,1]),]
for (i in 1:par3) {
cl$cluster[cl$cluster==clm[i,2]] <- paste('C',i,sep='')
}
cl$cluster <- as.factor(cl$cluster)
print(cl$cluster)
x[,par1] <- cl$cluster
}
if (par2 == 'quantiles') {
x[,par1] <- cut2(x[,par1],g=par3)
}
if (par2 == 'hclust') {
hc <- hclust(dist(x[,par1])^2, 'cen')
print(hc)
memb <- cutree(hc, k = par3)
dum <- c(mean(x[memb==1,par1]))
for (i in 2:par3) {
dum <- c(dum, mean(x[memb==i,par1]))
}
hcm <- matrix(cbind(dum,1:par3),ncol=2)
hcm <- hcm[sort.list(hcm[,1]),]
for (i in 1:par3) {
memb[memb==hcm[i,2]] <- paste('C',i,sep='')
}
memb <- as.factor(memb)
print(memb)
x[,par1] <- memb
}
if (par2=='equal') {
ed <- cut(as.numeric(x[,par1]),par3,labels=paste('C',1:par3,sep=''))
x[,par1] <- as.factor(ed)
}
table(x[,par1])
colnames(x)
colnames(x)[par1]
x[,par1]
if (par2 == 'none') {
m <- ctree(as.formula(paste(colnames(x)[par1],' ~ .',sep='')),data = x)
}
load(file='createtable')
if (par2 != 'none') {
m <- ctree(as.formula(paste('as.factor(',colnames(x)[par1],') ~ .',sep='')),data = x)
if (par4=='yes') {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'10-Fold Cross Validation',3+2*par3,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'',1,TRUE)
a<-table.element(a,'Prediction (training)',par3+1,TRUE)
a<-table.element(a,'Prediction (testing)',par3+1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Actual',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,paste('C',jjj,sep=''),1,TRUE)
a<-table.element(a,'CV',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,paste('C',jjj,sep=''),1,TRUE)
a<-table.element(a,'CV',1,TRUE)
a<-table.row.end(a)
for (i in 1:10) {
ind <- sample(2, nrow(x), replace=T, prob=c(0.9,0.1))
m.ct <- ctree(as.formula(paste('as.factor(',colnames(x)[par1],') ~ .',sep='')),data =x[ind==1,])
if (i==1) {
m.ct.i.pred <- predict(m.ct, newdata=x[ind==1,])
m.ct.i.actu <- x[ind==1,par1]
m.ct.x.pred <- predict(m.ct, newdata=x[ind==2,])
m.ct.x.actu <- x[ind==2,par1]
} else {
m.ct.i.pred <- c(m.ct.i.pred,predict(m.ct, newdata=x[ind==1,]))
m.ct.i.actu <- c(m.ct.i.actu,x[ind==1,par1])
m.ct.x.pred <- c(m.ct.x.pred,predict(m.ct, newdata=x[ind==2,]))
m.ct.x.actu <- c(m.ct.x.actu,x[ind==2,par1])
}
}
print(m.ct.i.tab <- table(m.ct.i.actu,m.ct.i.pred))
numer <- 0
for (i in 1:par3) {
print(m.ct.i.tab[i,i] / sum(m.ct.i.tab[i,]))
numer <- numer + m.ct.i.tab[i,i]
}
print(m.ct.i.cp <- numer / sum(m.ct.i.tab))
print(m.ct.x.tab <- table(m.ct.x.actu,m.ct.x.pred))
numer <- 0
for (i in 1:par3) {
print(m.ct.x.tab[i,i] / sum(m.ct.x.tab[i,]))
numer <- numer + m.ct.x.tab[i,i]
}
print(m.ct.x.cp <- numer / sum(m.ct.x.tab))
for (i in 1:par3) {
a<-table.row.start(a)
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
for (jjj in 1:par3) a<-table.element(a,m.ct.i.tab[i,jjj])
a<-table.element(a,round(m.ct.i.tab[i,i]/sum(m.ct.i.tab[i,]),4))
for (jjj in 1:par3) a<-table.element(a,m.ct.x.tab[i,jjj])
a<-table.element(a,round(m.ct.x.tab[i,i]/sum(m.ct.x.tab[i,]),4))
a<-table.row.end(a)
}
a<-table.row.start(a)
a<-table.element(a,'Overall',1,TRUE)
for (jjj in 1:par3) a<-table.element(a,'-')
a<-table.element(a,round(m.ct.i.cp,4))
for (jjj in 1:par3) a<-table.element(a,'-')
a<-table.element(a,round(m.ct.x.cp,4))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable3.tab')
}
}
m
bitmap(file='test1.png')
plot(m)
dev.off()
bitmap(file='test1a.png')
plot(x[,par1] ~ as.factor(where(m)),main='Response by Terminal Node',xlab='Terminal Node',ylab='Response')
dev.off()
if (par2 == 'none') {
forec <- predict(m)
result <- as.data.frame(cbind(x[,par1],forec,x[,par1]-forec))
colnames(result) <- c('Actuals','Forecasts','Residuals')
print(result)
}
if (par2 != 'none') {
print(cbind(as.factor(x[,par1]),predict(m)))
myt <- table(as.factor(x[,par1]),predict(m))
print(myt)
}
bitmap(file='test2.png')
if(par2=='none') {
op <- par(mfrow=c(2,2))
plot(density(result$Actuals),main='Kernel Density Plot of Actuals')
plot(density(result$Residuals),main='Kernel Density Plot of Residuals')
plot(result$Forecasts,result$Actuals,main='Actuals versus Predictions',xlab='Predictions',ylab='Actuals')
plot(density(result$Forecasts),main='Kernel Density Plot of Predictions')
par(op)
}
if(par2!='none') {
plot(myt,main='Confusion Matrix',xlab='Actual',ylab='Predicted')
}
dev.off()
if (par2 == 'none') {
detcoef <- cor(result$Forecasts,result$Actuals)
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Goodness of Fit',2,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'Correlation',1,TRUE)
a<-table.element(a,round(detcoef,4))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'R-squared',1,TRUE)
a<-table.element(a,round(detcoef*detcoef,4))
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'RMSE',1,TRUE)
a<-table.element(a,round(sqrt(mean((result$Residuals)^2)),4))
a<-table.row.end(a)
a<-table.end(a)
table.save(a,file='mytable1.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Actuals, Predictions, and Residuals',4,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'#',header=TRUE)
a<-table.element(a,'Actuals',header=TRUE)
a<-table.element(a,'Forecasts',header=TRUE)
a<-table.element(a,'Residuals',header=TRUE)
a<-table.row.end(a)
for (i in 1:length(result$Actuals)) {
a<-table.row.start(a)
a<-table.element(a,i,header=TRUE)
a<-table.element(a,result$Actuals[i])
a<-table.element(a,result$Forecasts[i])
a<-table.element(a,result$Residuals[i])
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable.tab')
}
if (par2 != 'none') {
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Confusion Matrix (predicted in columns / actuals in rows)',par3+1,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'',1,TRUE)
for (i in 1:par3) {
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
}
a<-table.row.end(a)
for (i in 1:par3) {
a<-table.row.start(a)
a<-table.element(a,paste('C',i,sep=''),1,TRUE)
for (j in 1:par3) {
a<-table.element(a,myt[i,j])
}
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable2.tab')
}