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 computationSun, 18 Dec 2011 08:08:04 -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/18/t1324213727bhs9oxtr0mbykjq.htm/, Retrieved Sun, 05 May 2024 18:24:57 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=156820, Retrieved Sun, 05 May 2024 18:24:57 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact78
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]
- R PD    [Recursive Partitioning (Regression Trees)] [Recursive Partiti...] [2011-12-18 13:08:04] [e1aba6efa0fba8dc2a9839c208d0186e] [Current]
-   P       [Recursive Partitioning (Regression Trees)] [Recursive Partiti...] [2011-12-18 13:16:44] [c26e829f03d42da3805b9c4b60f90f25]
Feedback Forum

Post a new message
Dataseries X:
140824	165	186099	38
110459	135	113854	34
105079	121	99776	42
112098	148	106194	38
43929	73	100792	27
76173	49	47552	35
187326	185	250931	33
22807	5	6853	18
144408	125	115466	34
66485	93	110896	33
79089	154	169351	46
81625	98	94853	55
68788	70	72591	37
103297	148	101345	55
69446	100	113713	44
114948	150	165354	59
167949	197	164263	36
125081	114	135213	39
125818	169	111669	29
136588	200	134163	51
112431	148	140303	49
103037	140	150773	39
82317	74	111848	25
118906	128	102509	52
83515	140	96785	45
104581	116	116136	38
103129	147	158376	41
83243	132	153990	43
37110	70	64057	32
113344	144	230054	41
139165	155	184531	47
86652	165	114198	50
112302	161	198299	48
69652	31	33750	37
119442	199	189723	43
69867	78	100826	42
101629	121	188355	44
70168	112	104470	36
31081	41	58391	17
103925	158	164808	42
92622	123	134097	39
79011	104	80238	41
93487	94	133252	36
64520	73	54518	47
93473	52	121850	45
114360	71	79367	41
33032	21	56968	26
96125	155	106314	52
151911	174	191889	47
89256	136	104864	45
95671	128	160791	40
5950	7	15049	4
149695	165	191179	44
32551	21	25109	18
31701	35	45824	14
100087	137	129711	37
169707	174	210012	61
150491	257	194679	39
120192	207	197680	42
95893	103	81180	36
151715	171	197765	49
176225	279	214738	28
59900	83	96252	43
104767	130	124527	42
114799	131	153242	37
72128	126	145707	30
143592	158	113963	35
89626	138	134904	44
131072	200	114268	36
126817	104	94333	28
81351	111	102204	45
22618	26	23824	23
88977	115	111563	45
92059	127	91313	38
81897	140	89770	38
108146	121	100125	46
126372	183	165278	36
249771	68	181712	41
71154	112	80906	38
71571	103	75881	37
55918	63	83963	28
160141	166	175721	45
38692	38	68580	26
102812	163	136323	44
56622	59	55792	8
15986	27	25157	27
123534	108	100922	38
108535	88	118845	37
93879	92	170492	57
144551	170	81716	45
56750	98	115750	37
127654	205	105590	40
65594	96	92795	31
59938	107	82390	36
146975	150	135599	40
143372	123	111542	36
168553	176	162519	35
183500	213	211381	39
165986	208	189944	65
184923	307	226168	30
140358	125	117495	51
149959	208	195894	41
57224	73	80684	36
43750	49	19630	19
48029	82	88634	23
104978	206	139292	44
100046	112	128602	40
101047	139	135848	40
197426	60	178377	30
160902	70	106330	41
147172	112	178303	40
109432	142	116938	45
1168	11	5841	1
83248	130	106020	40
25162	31	24610	11
45724	132	74151	45
110529	219	232241	38
855	4	6622	0
101382	102	127097	30
14116	39	13155	8
89506	125	160501	39
135356	121	91502	48
116066	42	24469	48
144244	111	88229	29
8773	16	13983	8
102153	70	80716	43
117440	162	157384	52
104128	173	122975	53
134238	171	191469	48
134047	172	231257	48
279488	254	258287	50
79756	90	122531	40
66089	50	61394	36
102070	113	86480	40
146760	187	195791	46
154771	16	18284	42
165933	175	147581	46
64593	90	72558	39
92280	140	147341	41
67150	145	114651	46
128692	141	100187	32
124089	125	130332	39
125386	241	134218	39
37238	16	10901	21
140015	175	145758	45
150047	132	75767	50
154451	154	134969	36
156349	198	169216	44
0	0	0	0
6023	5	7953	0
0	0	0	0
0	0	0	0
0	0	0	0
0	0	0	0
84601	125	105406	37
68946	174	174586	52
0	0	0	0
0	0	0	0
1644	6	4245	0
6179	13	21509	5
3926	3	7670	1
52789	35	15673	43
0	0	0	0
100350	80	75882	34




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net

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

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]4 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Gwilym Jenkins' @ jenkins.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=156820&T=0

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

As an alternative you can also use a QR Code:  

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

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net







Goodness of Fit
Correlation0.8696
R-squared0.7562
RMSE25604.7044

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8696[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7562[/C][/ROW]
[ROW][C]RMSE[/C][C]25604.7044[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=156820&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=156820&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.8696
R-squared0.7562
RMSE25604.7044







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1140824156589.185185185-15765.1851851852
2110459106279.5932203394179.40677966102
3105079106279.593220339-1200.59322033898
4112098106279.5932203395818.40677966102
54392982910.7777777778-38981.7777777778
67617377916.5-1743.5
7187326156589.18518518530736.8148148148
8228073034.519772.5
9144408106279.59322033938128.406779661
106648582910.7777777778-16425.7777777778
1179089106279.593220339-27190.593220339
128162582910.7777777778-1285.77777777778
136878877916.5-9128.5
14103297106279.593220339-2982.59322033898
156944682910.7777777778-13464.7777777778
16114948106279.5932203398668.40677966102
17167949140986.27272727326962.7272727273
18125081106279.59322033918801.406779661
19125818106279.59322033919538.406779661
20136588140986.272727273-4398.27272727274
21112431106279.5932203396151.40677966102
22103037106279.593220339-3242.59322033898
238231782910.7777777778-593.777777777781
24118906106279.59322033912626.406779661
2583515106279.593220339-22764.593220339
26104581106279.593220339-1698.59322033898
27103129106279.593220339-3150.59322033898
2883243106279.593220339-23036.593220339
293711030602.28571428576507.71428571429
30113344156589.185185185-43245.1851851852
31139165156589.185185185-17424.1851851852
3286652106279.593220339-19627.593220339
33112302156589.185185185-44287.1851851852
346965277916.5-8264.5
35119442156589.185185185-37147.1851851852
366986782910.7777777778-13043.7777777778
37101629156589.185185185-54960.1851851852
3870168106279.593220339-36111.593220339
393108130602.2857142857478.714285714286
40103925106279.593220339-2354.59322033898
4192622106279.593220339-13657.593220339
427901182910.7777777778-3899.77777777778
439348782910.777777777810576.2222222222
446452077916.5-13396.5
459347382910.777777777810562.2222222222
4611436082910.777777777831449.2222222222
473303230602.28571428572429.71428571429
4896125106279.593220339-10154.593220339
49151911156589.185185185-4678.1851851852
5089256106279.593220339-17023.593220339
5195671106279.593220339-10608.593220339
5259503034.52915.5
53149695156589.185185185-6894.1851851852
543255130602.28571428571948.71428571429
553170130602.28571428571098.71428571429
56100087106279.593220339-6192.59322033898
57169707156589.18518518513117.8148148148
58150491156589.185185185-6098.1851851852
59120192156589.185185185-36397.1851851852
609589382910.777777777812982.2222222222
61151715156589.185185185-4874.1851851852
62176225156589.18518518519635.8148148148
635990082910.7777777778-23010.7777777778
64104767106279.593220339-1512.59322033898
65114799106279.5932203398519.40677966102
6672128106279.593220339-34151.593220339
67143592106279.59322033937312.406779661
6889626106279.593220339-16653.593220339
69131072140986.272727273-9914.27272727274
7012681782910.777777777843906.2222222222
7181351106279.593220339-24928.593220339
722261830602.2857142857-7984.28571428571
7388977106279.593220339-17302.593220339
7492059106279.593220339-14220.593220339
7581897106279.593220339-24382.593220339
76108146106279.5932203391866.40677966102
77126372140986.272727273-14614.2727272727
78249771156589.18518518593181.8148148148
7971154106279.593220339-35125.593220339
807157182910.7777777778-11339.7777777778
815591882910.7777777778-26992.7777777778
82160141156589.1851851853551.8148148148
833869230602.28571428578089.71428571429
84102812106279.593220339-3467.59322033898
855662230602.285714285726019.7142857143
861598630602.2857142857-14616.2857142857
87123534106279.59322033917254.406779661
8810853582910.777777777825624.2222222222
899387982910.777777777810968.2222222222
90144551106279.59322033938271.406779661
915675082910.7777777778-26160.7777777778
92127654140986.272727273-13332.2727272727
936559482910.7777777778-17316.7777777778
945993882910.7777777778-22972.7777777778
95146975106279.59322033940695.406779661
96143372106279.59322033937092.406779661
97168553140986.27272727327566.7272727273
98183500156589.18518518526910.8148148148
99165986156589.1851851859396.8148148148
100184923156589.18518518528333.8148148148
101140358106279.59322033934078.406779661
102149959156589.185185185-6630.1851851852
1035722482910.7777777778-25686.7777777778
1044375030602.285714285713147.7142857143
1054802982910.7777777778-34881.7777777778
106104978140986.272727273-36008.2727272727
107100046106279.593220339-6233.59322033898
108101047106279.593220339-5232.59322033898
109197426156589.18518518540836.8148148148
11016090282910.777777777877991.2222222222
111147172156589.185185185-9417.1851851852
112109432106279.5932203393152.40677966102
11311683034.5-1866.5
11483248106279.593220339-23031.593220339
1152516230602.2857142857-5440.28571428571
1164572477916.5-32192.5
117110529156589.185185185-46060.1851851852
1188553034.5-2179.5
11910138282910.777777777818471.2222222222
1201411630602.2857142857-16486.2857142857
12189506106279.593220339-16773.593220339
122135356106279.59322033929076.406779661
12311606677916.538149.5
124144244106279.59322033937964.406779661
125877330602.2857142857-21829.2857142857
12610215382910.777777777819242.2222222222
127117440106279.59322033911160.406779661
128104128106279.593220339-2151.59322033898
129134238156589.185185185-22351.1851851852
130134047156589.185185185-22542.1851851852
131279488156589.185185185122898.814814815
1327975682910.7777777778-3154.77777777778
1336608977916.5-11827.5
134102070106279.593220339-4209.59322033898
135146760156589.185185185-9829.1851851852
13615477177916.576854.5
137165933140986.27272727324946.7272727273
1386459377916.5-13323.5
13992280106279.593220339-13999.593220339
14067150106279.593220339-39129.593220339
141128692106279.59322033922412.406779661
142124089106279.59322033917809.406779661
143125386140986.272727273-15600.2727272727
1443723830602.28571428576635.71428571429
145140015140986.272727273-971.272727272735
146150047106279.59322033943767.406779661
147154451106279.59322033948171.406779661
148156349140986.27272727315362.7272727273
14903034.5-3034.5
15060233034.52988.5
15103034.5-3034.5
15203034.5-3034.5
15303034.5-3034.5
15403034.5-3034.5
15584601106279.593220339-21678.593220339
15668946106279.593220339-37333.593220339
15703034.5-3034.5
15803034.5-3034.5
15916443034.5-1390.5
16061793034.53144.5
16139263034.5891.5
1625278977916.5-25127.5
16303034.5-3034.5
16410035082910.777777777817439.2222222222

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 140824 & 156589.185185185 & -15765.1851851852 \tabularnewline
2 & 110459 & 106279.593220339 & 4179.40677966102 \tabularnewline
3 & 105079 & 106279.593220339 & -1200.59322033898 \tabularnewline
4 & 112098 & 106279.593220339 & 5818.40677966102 \tabularnewline
5 & 43929 & 82910.7777777778 & -38981.7777777778 \tabularnewline
6 & 76173 & 77916.5 & -1743.5 \tabularnewline
7 & 187326 & 156589.185185185 & 30736.8148148148 \tabularnewline
8 & 22807 & 3034.5 & 19772.5 \tabularnewline
9 & 144408 & 106279.593220339 & 38128.406779661 \tabularnewline
10 & 66485 & 82910.7777777778 & -16425.7777777778 \tabularnewline
11 & 79089 & 106279.593220339 & -27190.593220339 \tabularnewline
12 & 81625 & 82910.7777777778 & -1285.77777777778 \tabularnewline
13 & 68788 & 77916.5 & -9128.5 \tabularnewline
14 & 103297 & 106279.593220339 & -2982.59322033898 \tabularnewline
15 & 69446 & 82910.7777777778 & -13464.7777777778 \tabularnewline
16 & 114948 & 106279.593220339 & 8668.40677966102 \tabularnewline
17 & 167949 & 140986.272727273 & 26962.7272727273 \tabularnewline
18 & 125081 & 106279.593220339 & 18801.406779661 \tabularnewline
19 & 125818 & 106279.593220339 & 19538.406779661 \tabularnewline
20 & 136588 & 140986.272727273 & -4398.27272727274 \tabularnewline
21 & 112431 & 106279.593220339 & 6151.40677966102 \tabularnewline
22 & 103037 & 106279.593220339 & -3242.59322033898 \tabularnewline
23 & 82317 & 82910.7777777778 & -593.777777777781 \tabularnewline
24 & 118906 & 106279.593220339 & 12626.406779661 \tabularnewline
25 & 83515 & 106279.593220339 & -22764.593220339 \tabularnewline
26 & 104581 & 106279.593220339 & -1698.59322033898 \tabularnewline
27 & 103129 & 106279.593220339 & -3150.59322033898 \tabularnewline
28 & 83243 & 106279.593220339 & -23036.593220339 \tabularnewline
29 & 37110 & 30602.2857142857 & 6507.71428571429 \tabularnewline
30 & 113344 & 156589.185185185 & -43245.1851851852 \tabularnewline
31 & 139165 & 156589.185185185 & -17424.1851851852 \tabularnewline
32 & 86652 & 106279.593220339 & -19627.593220339 \tabularnewline
33 & 112302 & 156589.185185185 & -44287.1851851852 \tabularnewline
34 & 69652 & 77916.5 & -8264.5 \tabularnewline
35 & 119442 & 156589.185185185 & -37147.1851851852 \tabularnewline
36 & 69867 & 82910.7777777778 & -13043.7777777778 \tabularnewline
37 & 101629 & 156589.185185185 & -54960.1851851852 \tabularnewline
38 & 70168 & 106279.593220339 & -36111.593220339 \tabularnewline
39 & 31081 & 30602.2857142857 & 478.714285714286 \tabularnewline
40 & 103925 & 106279.593220339 & -2354.59322033898 \tabularnewline
41 & 92622 & 106279.593220339 & -13657.593220339 \tabularnewline
42 & 79011 & 82910.7777777778 & -3899.77777777778 \tabularnewline
43 & 93487 & 82910.7777777778 & 10576.2222222222 \tabularnewline
44 & 64520 & 77916.5 & -13396.5 \tabularnewline
45 & 93473 & 82910.7777777778 & 10562.2222222222 \tabularnewline
46 & 114360 & 82910.7777777778 & 31449.2222222222 \tabularnewline
47 & 33032 & 30602.2857142857 & 2429.71428571429 \tabularnewline
48 & 96125 & 106279.593220339 & -10154.593220339 \tabularnewline
49 & 151911 & 156589.185185185 & -4678.1851851852 \tabularnewline
50 & 89256 & 106279.593220339 & -17023.593220339 \tabularnewline
51 & 95671 & 106279.593220339 & -10608.593220339 \tabularnewline
52 & 5950 & 3034.5 & 2915.5 \tabularnewline
53 & 149695 & 156589.185185185 & -6894.1851851852 \tabularnewline
54 & 32551 & 30602.2857142857 & 1948.71428571429 \tabularnewline
55 & 31701 & 30602.2857142857 & 1098.71428571429 \tabularnewline
56 & 100087 & 106279.593220339 & -6192.59322033898 \tabularnewline
57 & 169707 & 156589.185185185 & 13117.8148148148 \tabularnewline
58 & 150491 & 156589.185185185 & -6098.1851851852 \tabularnewline
59 & 120192 & 156589.185185185 & -36397.1851851852 \tabularnewline
60 & 95893 & 82910.7777777778 & 12982.2222222222 \tabularnewline
61 & 151715 & 156589.185185185 & -4874.1851851852 \tabularnewline
62 & 176225 & 156589.185185185 & 19635.8148148148 \tabularnewline
63 & 59900 & 82910.7777777778 & -23010.7777777778 \tabularnewline
64 & 104767 & 106279.593220339 & -1512.59322033898 \tabularnewline
65 & 114799 & 106279.593220339 & 8519.40677966102 \tabularnewline
66 & 72128 & 106279.593220339 & -34151.593220339 \tabularnewline
67 & 143592 & 106279.593220339 & 37312.406779661 \tabularnewline
68 & 89626 & 106279.593220339 & -16653.593220339 \tabularnewline
69 & 131072 & 140986.272727273 & -9914.27272727274 \tabularnewline
70 & 126817 & 82910.7777777778 & 43906.2222222222 \tabularnewline
71 & 81351 & 106279.593220339 & -24928.593220339 \tabularnewline
72 & 22618 & 30602.2857142857 & -7984.28571428571 \tabularnewline
73 & 88977 & 106279.593220339 & -17302.593220339 \tabularnewline
74 & 92059 & 106279.593220339 & -14220.593220339 \tabularnewline
75 & 81897 & 106279.593220339 & -24382.593220339 \tabularnewline
76 & 108146 & 106279.593220339 & 1866.40677966102 \tabularnewline
77 & 126372 & 140986.272727273 & -14614.2727272727 \tabularnewline
78 & 249771 & 156589.185185185 & 93181.8148148148 \tabularnewline
79 & 71154 & 106279.593220339 & -35125.593220339 \tabularnewline
80 & 71571 & 82910.7777777778 & -11339.7777777778 \tabularnewline
81 & 55918 & 82910.7777777778 & -26992.7777777778 \tabularnewline
82 & 160141 & 156589.185185185 & 3551.8148148148 \tabularnewline
83 & 38692 & 30602.2857142857 & 8089.71428571429 \tabularnewline
84 & 102812 & 106279.593220339 & -3467.59322033898 \tabularnewline
85 & 56622 & 30602.2857142857 & 26019.7142857143 \tabularnewline
86 & 15986 & 30602.2857142857 & -14616.2857142857 \tabularnewline
87 & 123534 & 106279.593220339 & 17254.406779661 \tabularnewline
88 & 108535 & 82910.7777777778 & 25624.2222222222 \tabularnewline
89 & 93879 & 82910.7777777778 & 10968.2222222222 \tabularnewline
90 & 144551 & 106279.593220339 & 38271.406779661 \tabularnewline
91 & 56750 & 82910.7777777778 & -26160.7777777778 \tabularnewline
92 & 127654 & 140986.272727273 & -13332.2727272727 \tabularnewline
93 & 65594 & 82910.7777777778 & -17316.7777777778 \tabularnewline
94 & 59938 & 82910.7777777778 & -22972.7777777778 \tabularnewline
95 & 146975 & 106279.593220339 & 40695.406779661 \tabularnewline
96 & 143372 & 106279.593220339 & 37092.406779661 \tabularnewline
97 & 168553 & 140986.272727273 & 27566.7272727273 \tabularnewline
98 & 183500 & 156589.185185185 & 26910.8148148148 \tabularnewline
99 & 165986 & 156589.185185185 & 9396.8148148148 \tabularnewline
100 & 184923 & 156589.185185185 & 28333.8148148148 \tabularnewline
101 & 140358 & 106279.593220339 & 34078.406779661 \tabularnewline
102 & 149959 & 156589.185185185 & -6630.1851851852 \tabularnewline
103 & 57224 & 82910.7777777778 & -25686.7777777778 \tabularnewline
104 & 43750 & 30602.2857142857 & 13147.7142857143 \tabularnewline
105 & 48029 & 82910.7777777778 & -34881.7777777778 \tabularnewline
106 & 104978 & 140986.272727273 & -36008.2727272727 \tabularnewline
107 & 100046 & 106279.593220339 & -6233.59322033898 \tabularnewline
108 & 101047 & 106279.593220339 & -5232.59322033898 \tabularnewline
109 & 197426 & 156589.185185185 & 40836.8148148148 \tabularnewline
110 & 160902 & 82910.7777777778 & 77991.2222222222 \tabularnewline
111 & 147172 & 156589.185185185 & -9417.1851851852 \tabularnewline
112 & 109432 & 106279.593220339 & 3152.40677966102 \tabularnewline
113 & 1168 & 3034.5 & -1866.5 \tabularnewline
114 & 83248 & 106279.593220339 & -23031.593220339 \tabularnewline
115 & 25162 & 30602.2857142857 & -5440.28571428571 \tabularnewline
116 & 45724 & 77916.5 & -32192.5 \tabularnewline
117 & 110529 & 156589.185185185 & -46060.1851851852 \tabularnewline
118 & 855 & 3034.5 & -2179.5 \tabularnewline
119 & 101382 & 82910.7777777778 & 18471.2222222222 \tabularnewline
120 & 14116 & 30602.2857142857 & -16486.2857142857 \tabularnewline
121 & 89506 & 106279.593220339 & -16773.593220339 \tabularnewline
122 & 135356 & 106279.593220339 & 29076.406779661 \tabularnewline
123 & 116066 & 77916.5 & 38149.5 \tabularnewline
124 & 144244 & 106279.593220339 & 37964.406779661 \tabularnewline
125 & 8773 & 30602.2857142857 & -21829.2857142857 \tabularnewline
126 & 102153 & 82910.7777777778 & 19242.2222222222 \tabularnewline
127 & 117440 & 106279.593220339 & 11160.406779661 \tabularnewline
128 & 104128 & 106279.593220339 & -2151.59322033898 \tabularnewline
129 & 134238 & 156589.185185185 & -22351.1851851852 \tabularnewline
130 & 134047 & 156589.185185185 & -22542.1851851852 \tabularnewline
131 & 279488 & 156589.185185185 & 122898.814814815 \tabularnewline
132 & 79756 & 82910.7777777778 & -3154.77777777778 \tabularnewline
133 & 66089 & 77916.5 & -11827.5 \tabularnewline
134 & 102070 & 106279.593220339 & -4209.59322033898 \tabularnewline
135 & 146760 & 156589.185185185 & -9829.1851851852 \tabularnewline
136 & 154771 & 77916.5 & 76854.5 \tabularnewline
137 & 165933 & 140986.272727273 & 24946.7272727273 \tabularnewline
138 & 64593 & 77916.5 & -13323.5 \tabularnewline
139 & 92280 & 106279.593220339 & -13999.593220339 \tabularnewline
140 & 67150 & 106279.593220339 & -39129.593220339 \tabularnewline
141 & 128692 & 106279.593220339 & 22412.406779661 \tabularnewline
142 & 124089 & 106279.593220339 & 17809.406779661 \tabularnewline
143 & 125386 & 140986.272727273 & -15600.2727272727 \tabularnewline
144 & 37238 & 30602.2857142857 & 6635.71428571429 \tabularnewline
145 & 140015 & 140986.272727273 & -971.272727272735 \tabularnewline
146 & 150047 & 106279.593220339 & 43767.406779661 \tabularnewline
147 & 154451 & 106279.593220339 & 48171.406779661 \tabularnewline
148 & 156349 & 140986.272727273 & 15362.7272727273 \tabularnewline
149 & 0 & 3034.5 & -3034.5 \tabularnewline
150 & 6023 & 3034.5 & 2988.5 \tabularnewline
151 & 0 & 3034.5 & -3034.5 \tabularnewline
152 & 0 & 3034.5 & -3034.5 \tabularnewline
153 & 0 & 3034.5 & -3034.5 \tabularnewline
154 & 0 & 3034.5 & -3034.5 \tabularnewline
155 & 84601 & 106279.593220339 & -21678.593220339 \tabularnewline
156 & 68946 & 106279.593220339 & -37333.593220339 \tabularnewline
157 & 0 & 3034.5 & -3034.5 \tabularnewline
158 & 0 & 3034.5 & -3034.5 \tabularnewline
159 & 1644 & 3034.5 & -1390.5 \tabularnewline
160 & 6179 & 3034.5 & 3144.5 \tabularnewline
161 & 3926 & 3034.5 & 891.5 \tabularnewline
162 & 52789 & 77916.5 & -25127.5 \tabularnewline
163 & 0 & 3034.5 & -3034.5 \tabularnewline
164 & 100350 & 82910.7777777778 & 17439.2222222222 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=156820&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]106279.593220339[/C][C]4179.40677966102[/C][/ROW]
[ROW][C]3[/C][C]105079[/C][C]106279.593220339[/C][C]-1200.59322033898[/C][/ROW]
[ROW][C]4[/C][C]112098[/C][C]106279.593220339[/C][C]5818.40677966102[/C][/ROW]
[ROW][C]5[/C][C]43929[/C][C]82910.7777777778[/C][C]-38981.7777777778[/C][/ROW]
[ROW][C]6[/C][C]76173[/C][C]77916.5[/C][C]-1743.5[/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]3034.5[/C][C]19772.5[/C][/ROW]
[ROW][C]9[/C][C]144408[/C][C]106279.593220339[/C][C]38128.406779661[/C][/ROW]
[ROW][C]10[/C][C]66485[/C][C]82910.7777777778[/C][C]-16425.7777777778[/C][/ROW]
[ROW][C]11[/C][C]79089[/C][C]106279.593220339[/C][C]-27190.593220339[/C][/ROW]
[ROW][C]12[/C][C]81625[/C][C]82910.7777777778[/C][C]-1285.77777777778[/C][/ROW]
[ROW][C]13[/C][C]68788[/C][C]77916.5[/C][C]-9128.5[/C][/ROW]
[ROW][C]14[/C][C]103297[/C][C]106279.593220339[/C][C]-2982.59322033898[/C][/ROW]
[ROW][C]15[/C][C]69446[/C][C]82910.7777777778[/C][C]-13464.7777777778[/C][/ROW]
[ROW][C]16[/C][C]114948[/C][C]106279.593220339[/C][C]8668.40677966102[/C][/ROW]
[ROW][C]17[/C][C]167949[/C][C]140986.272727273[/C][C]26962.7272727273[/C][/ROW]
[ROW][C]18[/C][C]125081[/C][C]106279.593220339[/C][C]18801.406779661[/C][/ROW]
[ROW][C]19[/C][C]125818[/C][C]106279.593220339[/C][C]19538.406779661[/C][/ROW]
[ROW][C]20[/C][C]136588[/C][C]140986.272727273[/C][C]-4398.27272727274[/C][/ROW]
[ROW][C]21[/C][C]112431[/C][C]106279.593220339[/C][C]6151.40677966102[/C][/ROW]
[ROW][C]22[/C][C]103037[/C][C]106279.593220339[/C][C]-3242.59322033898[/C][/ROW]
[ROW][C]23[/C][C]82317[/C][C]82910.7777777778[/C][C]-593.777777777781[/C][/ROW]
[ROW][C]24[/C][C]118906[/C][C]106279.593220339[/C][C]12626.406779661[/C][/ROW]
[ROW][C]25[/C][C]83515[/C][C]106279.593220339[/C][C]-22764.593220339[/C][/ROW]
[ROW][C]26[/C][C]104581[/C][C]106279.593220339[/C][C]-1698.59322033898[/C][/ROW]
[ROW][C]27[/C][C]103129[/C][C]106279.593220339[/C][C]-3150.59322033898[/C][/ROW]
[ROW][C]28[/C][C]83243[/C][C]106279.593220339[/C][C]-23036.593220339[/C][/ROW]
[ROW][C]29[/C][C]37110[/C][C]30602.2857142857[/C][C]6507.71428571429[/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]106279.593220339[/C][C]-19627.593220339[/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]77916.5[/C][C]-8264.5[/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]82910.7777777778[/C][C]-13043.7777777778[/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]106279.593220339[/C][C]-36111.593220339[/C][/ROW]
[ROW][C]39[/C][C]31081[/C][C]30602.2857142857[/C][C]478.714285714286[/C][/ROW]
[ROW][C]40[/C][C]103925[/C][C]106279.593220339[/C][C]-2354.59322033898[/C][/ROW]
[ROW][C]41[/C][C]92622[/C][C]106279.593220339[/C][C]-13657.593220339[/C][/ROW]
[ROW][C]42[/C][C]79011[/C][C]82910.7777777778[/C][C]-3899.77777777778[/C][/ROW]
[ROW][C]43[/C][C]93487[/C][C]82910.7777777778[/C][C]10576.2222222222[/C][/ROW]
[ROW][C]44[/C][C]64520[/C][C]77916.5[/C][C]-13396.5[/C][/ROW]
[ROW][C]45[/C][C]93473[/C][C]82910.7777777778[/C][C]10562.2222222222[/C][/ROW]
[ROW][C]46[/C][C]114360[/C][C]82910.7777777778[/C][C]31449.2222222222[/C][/ROW]
[ROW][C]47[/C][C]33032[/C][C]30602.2857142857[/C][C]2429.71428571429[/C][/ROW]
[ROW][C]48[/C][C]96125[/C][C]106279.593220339[/C][C]-10154.593220339[/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]106279.593220339[/C][C]-17023.593220339[/C][/ROW]
[ROW][C]51[/C][C]95671[/C][C]106279.593220339[/C][C]-10608.593220339[/C][/ROW]
[ROW][C]52[/C][C]5950[/C][C]3034.5[/C][C]2915.5[/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]30602.2857142857[/C][C]1948.71428571429[/C][/ROW]
[ROW][C]55[/C][C]31701[/C][C]30602.2857142857[/C][C]1098.71428571429[/C][/ROW]
[ROW][C]56[/C][C]100087[/C][C]106279.593220339[/C][C]-6192.59322033898[/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]82910.7777777778[/C][C]12982.2222222222[/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]82910.7777777778[/C][C]-23010.7777777778[/C][/ROW]
[ROW][C]64[/C][C]104767[/C][C]106279.593220339[/C][C]-1512.59322033898[/C][/ROW]
[ROW][C]65[/C][C]114799[/C][C]106279.593220339[/C][C]8519.40677966102[/C][/ROW]
[ROW][C]66[/C][C]72128[/C][C]106279.593220339[/C][C]-34151.593220339[/C][/ROW]
[ROW][C]67[/C][C]143592[/C][C]106279.593220339[/C][C]37312.406779661[/C][/ROW]
[ROW][C]68[/C][C]89626[/C][C]106279.593220339[/C][C]-16653.593220339[/C][/ROW]
[ROW][C]69[/C][C]131072[/C][C]140986.272727273[/C][C]-9914.27272727274[/C][/ROW]
[ROW][C]70[/C][C]126817[/C][C]82910.7777777778[/C][C]43906.2222222222[/C][/ROW]
[ROW][C]71[/C][C]81351[/C][C]106279.593220339[/C][C]-24928.593220339[/C][/ROW]
[ROW][C]72[/C][C]22618[/C][C]30602.2857142857[/C][C]-7984.28571428571[/C][/ROW]
[ROW][C]73[/C][C]88977[/C][C]106279.593220339[/C][C]-17302.593220339[/C][/ROW]
[ROW][C]74[/C][C]92059[/C][C]106279.593220339[/C][C]-14220.593220339[/C][/ROW]
[ROW][C]75[/C][C]81897[/C][C]106279.593220339[/C][C]-24382.593220339[/C][/ROW]
[ROW][C]76[/C][C]108146[/C][C]106279.593220339[/C][C]1866.40677966102[/C][/ROW]
[ROW][C]77[/C][C]126372[/C][C]140986.272727273[/C][C]-14614.2727272727[/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]106279.593220339[/C][C]-35125.593220339[/C][/ROW]
[ROW][C]80[/C][C]71571[/C][C]82910.7777777778[/C][C]-11339.7777777778[/C][/ROW]
[ROW][C]81[/C][C]55918[/C][C]82910.7777777778[/C][C]-26992.7777777778[/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]30602.2857142857[/C][C]8089.71428571429[/C][/ROW]
[ROW][C]84[/C][C]102812[/C][C]106279.593220339[/C][C]-3467.59322033898[/C][/ROW]
[ROW][C]85[/C][C]56622[/C][C]30602.2857142857[/C][C]26019.7142857143[/C][/ROW]
[ROW][C]86[/C][C]15986[/C][C]30602.2857142857[/C][C]-14616.2857142857[/C][/ROW]
[ROW][C]87[/C][C]123534[/C][C]106279.593220339[/C][C]17254.406779661[/C][/ROW]
[ROW][C]88[/C][C]108535[/C][C]82910.7777777778[/C][C]25624.2222222222[/C][/ROW]
[ROW][C]89[/C][C]93879[/C][C]82910.7777777778[/C][C]10968.2222222222[/C][/ROW]
[ROW][C]90[/C][C]144551[/C][C]106279.593220339[/C][C]38271.406779661[/C][/ROW]
[ROW][C]91[/C][C]56750[/C][C]82910.7777777778[/C][C]-26160.7777777778[/C][/ROW]
[ROW][C]92[/C][C]127654[/C][C]140986.272727273[/C][C]-13332.2727272727[/C][/ROW]
[ROW][C]93[/C][C]65594[/C][C]82910.7777777778[/C][C]-17316.7777777778[/C][/ROW]
[ROW][C]94[/C][C]59938[/C][C]82910.7777777778[/C][C]-22972.7777777778[/C][/ROW]
[ROW][C]95[/C][C]146975[/C][C]106279.593220339[/C][C]40695.406779661[/C][/ROW]
[ROW][C]96[/C][C]143372[/C][C]106279.593220339[/C][C]37092.406779661[/C][/ROW]
[ROW][C]97[/C][C]168553[/C][C]140986.272727273[/C][C]27566.7272727273[/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]106279.593220339[/C][C]34078.406779661[/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]82910.7777777778[/C][C]-25686.7777777778[/C][/ROW]
[ROW][C]104[/C][C]43750[/C][C]30602.2857142857[/C][C]13147.7142857143[/C][/ROW]
[ROW][C]105[/C][C]48029[/C][C]82910.7777777778[/C][C]-34881.7777777778[/C][/ROW]
[ROW][C]106[/C][C]104978[/C][C]140986.272727273[/C][C]-36008.2727272727[/C][/ROW]
[ROW][C]107[/C][C]100046[/C][C]106279.593220339[/C][C]-6233.59322033898[/C][/ROW]
[ROW][C]108[/C][C]101047[/C][C]106279.593220339[/C][C]-5232.59322033898[/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]82910.7777777778[/C][C]77991.2222222222[/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]106279.593220339[/C][C]3152.40677966102[/C][/ROW]
[ROW][C]113[/C][C]1168[/C][C]3034.5[/C][C]-1866.5[/C][/ROW]
[ROW][C]114[/C][C]83248[/C][C]106279.593220339[/C][C]-23031.593220339[/C][/ROW]
[ROW][C]115[/C][C]25162[/C][C]30602.2857142857[/C][C]-5440.28571428571[/C][/ROW]
[ROW][C]116[/C][C]45724[/C][C]77916.5[/C][C]-32192.5[/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]3034.5[/C][C]-2179.5[/C][/ROW]
[ROW][C]119[/C][C]101382[/C][C]82910.7777777778[/C][C]18471.2222222222[/C][/ROW]
[ROW][C]120[/C][C]14116[/C][C]30602.2857142857[/C][C]-16486.2857142857[/C][/ROW]
[ROW][C]121[/C][C]89506[/C][C]106279.593220339[/C][C]-16773.593220339[/C][/ROW]
[ROW][C]122[/C][C]135356[/C][C]106279.593220339[/C][C]29076.406779661[/C][/ROW]
[ROW][C]123[/C][C]116066[/C][C]77916.5[/C][C]38149.5[/C][/ROW]
[ROW][C]124[/C][C]144244[/C][C]106279.593220339[/C][C]37964.406779661[/C][/ROW]
[ROW][C]125[/C][C]8773[/C][C]30602.2857142857[/C][C]-21829.2857142857[/C][/ROW]
[ROW][C]126[/C][C]102153[/C][C]82910.7777777778[/C][C]19242.2222222222[/C][/ROW]
[ROW][C]127[/C][C]117440[/C][C]106279.593220339[/C][C]11160.406779661[/C][/ROW]
[ROW][C]128[/C][C]104128[/C][C]106279.593220339[/C][C]-2151.59322033898[/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]82910.7777777778[/C][C]-3154.77777777778[/C][/ROW]
[ROW][C]133[/C][C]66089[/C][C]77916.5[/C][C]-11827.5[/C][/ROW]
[ROW][C]134[/C][C]102070[/C][C]106279.593220339[/C][C]-4209.59322033898[/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]77916.5[/C][C]76854.5[/C][/ROW]
[ROW][C]137[/C][C]165933[/C][C]140986.272727273[/C][C]24946.7272727273[/C][/ROW]
[ROW][C]138[/C][C]64593[/C][C]77916.5[/C][C]-13323.5[/C][/ROW]
[ROW][C]139[/C][C]92280[/C][C]106279.593220339[/C][C]-13999.593220339[/C][/ROW]
[ROW][C]140[/C][C]67150[/C][C]106279.593220339[/C][C]-39129.593220339[/C][/ROW]
[ROW][C]141[/C][C]128692[/C][C]106279.593220339[/C][C]22412.406779661[/C][/ROW]
[ROW][C]142[/C][C]124089[/C][C]106279.593220339[/C][C]17809.406779661[/C][/ROW]
[ROW][C]143[/C][C]125386[/C][C]140986.272727273[/C][C]-15600.2727272727[/C][/ROW]
[ROW][C]144[/C][C]37238[/C][C]30602.2857142857[/C][C]6635.71428571429[/C][/ROW]
[ROW][C]145[/C][C]140015[/C][C]140986.272727273[/C][C]-971.272727272735[/C][/ROW]
[ROW][C]146[/C][C]150047[/C][C]106279.593220339[/C][C]43767.406779661[/C][/ROW]
[ROW][C]147[/C][C]154451[/C][C]106279.593220339[/C][C]48171.406779661[/C][/ROW]
[ROW][C]148[/C][C]156349[/C][C]140986.272727273[/C][C]15362.7272727273[/C][/ROW]
[ROW][C]149[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]150[/C][C]6023[/C][C]3034.5[/C][C]2988.5[/C][/ROW]
[ROW][C]151[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]152[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]155[/C][C]84601[/C][C]106279.593220339[/C][C]-21678.593220339[/C][/ROW]
[ROW][C]156[/C][C]68946[/C][C]106279.593220339[/C][C]-37333.593220339[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]158[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]159[/C][C]1644[/C][C]3034.5[/C][C]-1390.5[/C][/ROW]
[ROW][C]160[/C][C]6179[/C][C]3034.5[/C][C]3144.5[/C][/ROW]
[ROW][C]161[/C][C]3926[/C][C]3034.5[/C][C]891.5[/C][/ROW]
[ROW][C]162[/C][C]52789[/C][C]77916.5[/C][C]-25127.5[/C][/ROW]
[ROW][C]163[/C][C]0[/C][C]3034.5[/C][C]-3034.5[/C][/ROW]
[ROW][C]164[/C][C]100350[/C][C]82910.7777777778[/C][C]17439.2222222222[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=156820&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=156820&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
2110459106279.5932203394179.40677966102
3105079106279.593220339-1200.59322033898
4112098106279.5932203395818.40677966102
54392982910.7777777778-38981.7777777778
67617377916.5-1743.5
7187326156589.18518518530736.8148148148
8228073034.519772.5
9144408106279.59322033938128.406779661
106648582910.7777777778-16425.7777777778
1179089106279.593220339-27190.593220339
128162582910.7777777778-1285.77777777778
136878877916.5-9128.5
14103297106279.593220339-2982.59322033898
156944682910.7777777778-13464.7777777778
16114948106279.5932203398668.40677966102
17167949140986.27272727326962.7272727273
18125081106279.59322033918801.406779661
19125818106279.59322033919538.406779661
20136588140986.272727273-4398.27272727274
21112431106279.5932203396151.40677966102
22103037106279.593220339-3242.59322033898
238231782910.7777777778-593.777777777781
24118906106279.59322033912626.406779661
2583515106279.593220339-22764.593220339
26104581106279.593220339-1698.59322033898
27103129106279.593220339-3150.59322033898
2883243106279.593220339-23036.593220339
293711030602.28571428576507.71428571429
30113344156589.185185185-43245.1851851852
31139165156589.185185185-17424.1851851852
3286652106279.593220339-19627.593220339
33112302156589.185185185-44287.1851851852
346965277916.5-8264.5
35119442156589.185185185-37147.1851851852
366986782910.7777777778-13043.7777777778
37101629156589.185185185-54960.1851851852
3870168106279.593220339-36111.593220339
393108130602.2857142857478.714285714286
40103925106279.593220339-2354.59322033898
4192622106279.593220339-13657.593220339
427901182910.7777777778-3899.77777777778
439348782910.777777777810576.2222222222
446452077916.5-13396.5
459347382910.777777777810562.2222222222
4611436082910.777777777831449.2222222222
473303230602.28571428572429.71428571429
4896125106279.593220339-10154.593220339
49151911156589.185185185-4678.1851851852
5089256106279.593220339-17023.593220339
5195671106279.593220339-10608.593220339
5259503034.52915.5
53149695156589.185185185-6894.1851851852
543255130602.28571428571948.71428571429
553170130602.28571428571098.71428571429
56100087106279.593220339-6192.59322033898
57169707156589.18518518513117.8148148148
58150491156589.185185185-6098.1851851852
59120192156589.185185185-36397.1851851852
609589382910.777777777812982.2222222222
61151715156589.185185185-4874.1851851852
62176225156589.18518518519635.8148148148
635990082910.7777777778-23010.7777777778
64104767106279.593220339-1512.59322033898
65114799106279.5932203398519.40677966102
6672128106279.593220339-34151.593220339
67143592106279.59322033937312.406779661
6889626106279.593220339-16653.593220339
69131072140986.272727273-9914.27272727274
7012681782910.777777777843906.2222222222
7181351106279.593220339-24928.593220339
722261830602.2857142857-7984.28571428571
7388977106279.593220339-17302.593220339
7492059106279.593220339-14220.593220339
7581897106279.593220339-24382.593220339
76108146106279.5932203391866.40677966102
77126372140986.272727273-14614.2727272727
78249771156589.18518518593181.8148148148
7971154106279.593220339-35125.593220339
807157182910.7777777778-11339.7777777778
815591882910.7777777778-26992.7777777778
82160141156589.1851851853551.8148148148
833869230602.28571428578089.71428571429
84102812106279.593220339-3467.59322033898
855662230602.285714285726019.7142857143
861598630602.2857142857-14616.2857142857
87123534106279.59322033917254.406779661
8810853582910.777777777825624.2222222222
899387982910.777777777810968.2222222222
90144551106279.59322033938271.406779661
915675082910.7777777778-26160.7777777778
92127654140986.272727273-13332.2727272727
936559482910.7777777778-17316.7777777778
945993882910.7777777778-22972.7777777778
95146975106279.59322033940695.406779661
96143372106279.59322033937092.406779661
97168553140986.27272727327566.7272727273
98183500156589.18518518526910.8148148148
99165986156589.1851851859396.8148148148
100184923156589.18518518528333.8148148148
101140358106279.59322033934078.406779661
102149959156589.185185185-6630.1851851852
1035722482910.7777777778-25686.7777777778
1044375030602.285714285713147.7142857143
1054802982910.7777777778-34881.7777777778
106104978140986.272727273-36008.2727272727
107100046106279.593220339-6233.59322033898
108101047106279.593220339-5232.59322033898
109197426156589.18518518540836.8148148148
11016090282910.777777777877991.2222222222
111147172156589.185185185-9417.1851851852
112109432106279.5932203393152.40677966102
11311683034.5-1866.5
11483248106279.593220339-23031.593220339
1152516230602.2857142857-5440.28571428571
1164572477916.5-32192.5
117110529156589.185185185-46060.1851851852
1188553034.5-2179.5
11910138282910.777777777818471.2222222222
1201411630602.2857142857-16486.2857142857
12189506106279.593220339-16773.593220339
122135356106279.59322033929076.406779661
12311606677916.538149.5
124144244106279.59322033937964.406779661
125877330602.2857142857-21829.2857142857
12610215382910.777777777819242.2222222222
127117440106279.59322033911160.406779661
128104128106279.593220339-2151.59322033898
129134238156589.185185185-22351.1851851852
130134047156589.185185185-22542.1851851852
131279488156589.185185185122898.814814815
1327975682910.7777777778-3154.77777777778
1336608977916.5-11827.5
134102070106279.593220339-4209.59322033898
135146760156589.185185185-9829.1851851852
13615477177916.576854.5
137165933140986.27272727324946.7272727273
1386459377916.5-13323.5
13992280106279.593220339-13999.593220339
14067150106279.593220339-39129.593220339
141128692106279.59322033922412.406779661
142124089106279.59322033917809.406779661
143125386140986.272727273-15600.2727272727
1443723830602.28571428576635.71428571429
145140015140986.272727273-971.272727272735
146150047106279.59322033943767.406779661
147154451106279.59322033948171.406779661
148156349140986.27272727315362.7272727273
14903034.5-3034.5
15060233034.52988.5
15103034.5-3034.5
15203034.5-3034.5
15303034.5-3034.5
15403034.5-3034.5
15584601106279.593220339-21678.593220339
15668946106279.593220339-37333.593220339
15703034.5-3034.5
15803034.5-3034.5
15916443034.5-1390.5
16061793034.53144.5
16139263034.5891.5
1625278977916.5-25127.5
16303034.5-3034.5
16410035082910.777777777817439.2222222222



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