Free Statistics

of Irreproducible Research!

Author's title

Author*Unverified author*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationTue, 20 Dec 2011 03:46:25 -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/20/t13243708857pqexlziy3r19cv.htm/, Retrieved Mon, 06 May 2024 02:16:47 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=157800, Retrieved Mon, 06 May 2024 02:16:47 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact170
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [] [2010-12-05 18:59:57] [b98453cac15ba1066b407e146608df68]
- R PD  [Recursive Partitioning (Regression Trees)] [Recursive Partiti...] [2011-12-13 17:44:25] [570fce4db58fd7864ac807c4286d6e49]
-    D      [Recursive Partitioning (Regression Trees)] [Recursive Partiti...] [2011-12-20 08:46:25] [d41d8cd98f00b204e9800998ecf8427e] [Current]
Feedback Forum

Post a new message
Dataseries X:
140824	269998	116	165	90
110459	176565	127	132	63
105079	222373	106	121	59
112098	218443	133	145	135
43929	157206	64	71	48
76173	70849	89	47	46
187326	482608	122	177	109
22807	33186	22	5	46
144408	207822	117	124	75
66485	211698	82	92	72
79089	292874	136	149	78
81625	235891	184	93	61
68788	156623	106	70	58
103297	344166	162	148	114
69446	211787	86	100	45
114948	369753	199	142	127
167949	292100	139	194	58
125081	315018	92	113	90
125818	168686	85	162	41
136588	256016	174	186	59
112431	269240	148	147	99
103037	425544	144	137	101
82317	161962	84	71	62
118906	189897	208	123	65
83515	200545	144	134	150
104581	203723	139	115	72
103129	267198	127	138	91
83243	263212	136	125	60
37110	155915	99	66	53
113344	326805	135	137	140
139165	271661	165	152	49
86652	197192	139	159	81
112302	318563	178	159	53
69652	97717	137	31	40
119442	346931	148	185	72
69867	273950	127	78	87
101629	411809	141	117	72
70168	208192	89	109	67
31081	115469	46	41	36
103925	328339	143	149	45
92622	324178	122	123	42
79011	157897	103	103	70
93487	192883	108	87	82
64520	173450	126	71	85
93473	153778	45	51	82
114360	445562	122	70	792
33032	78800	66	21	57
96125	208051	180	155	80
151911	323152	165	172	116
89256	175523	146	133	68
95671	213050	137	125	48
5950	24188	7	7	20
149695	372225	157	158	81
32551	65029	61	21	21
31701	101097	41	35	70
100087	269593	120	133	124
169707	302218	208	169	80
150491	315889	127	256	206
120192	322546	147	190	62
95893	246873	127	100	77
151715	360665	161	171	65
176225	296186	73	267	146
59900	232336	94	80	71
104767	254550	142	126	59
114799	228595	125	132	58
72128	216027	87	121	58
143592	187959	128	156	54
89626	227699	148	133	89
131072	229698	116	199	78
126817	166791	89	98	62
81351	239277	154	109	63
22618	73566	67	25	39
88977	242498	171	113	58
92059	187167	90	126	94
81897	178281	133	137	61
108146	349060	137	121	92
126372	323126	133	178	48
249771	206059	125	63	50
71154	184970	134	109	58
71571	168990	110	101	67
55918	153613	89	61	41
160141	429481	138	157	114
38692	145919	99	38	45
102812	280343	92	159	57
56622	80953	27	58	31
15986	148106	77	27	175
123534	146777	127	108	63
108535	336054	137	83	278
93879	307486	122	88	91
144551	178495	143	164	68
56750	251466	85	96	58
127654	230961	131	192	71
65594	175244	90	94	86
59938	261494	135	107	89
146975	301883	132	144	134
143372	189252	139	123	64
168553	222504	127	170	72
183500	278170	104	210	61
165986	367723	221	193	123
184923	392346	106	297	73
140358	281033	161	125	80
149959	273642	130	204	85
57224	186856	59	70	116
43750	43287	64	49	43
48029	185302	36	82	85
104978	203088	88	205	72
100046	259692	125	111	110
101047	301456	124	135	55
197426	119969	83	59	44
160902	153028	127	70	79
147172	306952	143	108	58
109432	297807	115	141	70
1168	23623	0	11	9
83248	175532	94	130	49
25162	61857	30	28	25
45724	163766	119	101	107
110529	384053	102	216	63
855	21054	0	4	2
101382	252805	77	97	67
14116	31961	9	39	22
89506	294609	137	119	152
135356	235069	157	118	78
116066	174862	146	41	112
144244	152043	84	107	47
8773	38214	21	16	52
102153	189451	139	69	108
117440	344802	168	160	110
104128	190943	163	158	61
134238	396160	167	161	134
134047	314212	145	165	120
279488	396712	175	246	111
79756	187992	137	89	49
66089	102424	100	49	55
102070	283392	150	107	149
146760	401260	163	182	155
154771	135936	137	16	103
165933	373146	149	173	142
64593	157429	112	90	76
92280	236370	135	140	83
67150	258959	114	142	185
128692	214338	45	126	69
124089	363154	120	123	117
125386	232339	115	239	63
37238	173260	78	15	37
140015	317676	136	170	56
150047	168994	179	123	122
154451	233293	118	151	52
156349	301585	147	194	64
0	1	0	0	0
6023	14688	0	5	0
0	98	0	0	0
0	455	0	0	0
0	0	0	0	0
0	0	0	0	0
84601	216803	88	122	58
68946	365230	115	173	109
0	0	0	0	0
0	203	0	0	0
1644	7199	0	6	0
6179	46660	13	13	7
3926	17547	4	3	3
52789	116678	76	35	89
0	969	0	0	0
100350	195592	63	72	46




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=157800&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=157800&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=157800&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.827
R-squared0.684
RMSE29150.2276

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.827[/C][/ROW]
[ROW][C]R-squared[/C][C]0.684[/C][/ROW]
[ROW][C]RMSE[/C][C]29150.2276[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=157800&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=157800&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.827
R-squared0.684
RMSE29150.2276







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1140824136205.2222222224618.77777777778
2110459106229.0727272734229.92727272728
31050798339621683
4112098106229.0727272735868.92727272728
54392983396-39467
67617379811.5714285714-3638.57142857143
7187326136205.22222222251120.7777777778
82280731147.7-8340.7
9144408106229.07272727338178.9272727273
106648583396-16911
1179089106229.072727273-27140.0727272727
1281625106229.072727273-24604.0727272727
136878883396-14608
14103297106229.072727273-2932.07272727272
156944683396-13950
16114948106229.0727272738718.92727272728
17167949136205.22222222231743.7777777778
181250818339641685
19125818136205.222222222-10387.2222222222
20136588136205.222222222382.777777777781
21112431106229.0727272736201.92727272728
22103037106229.072727273-3192.07272727272
238231783396-1079
24118906106229.07272727312676.9272727273
2583515106229.072727273-22714.0727272727
26104581106229.072727273-1648.07272727272
27103129106229.072727273-3100.07272727272
2883243106229.072727273-22986.0727272727
293711083396-46286
30113344106229.0727272737114.92727272728
31139165136205.2222222222959.77777777778
3286652136205.222222222-49553.2222222222
33112302136205.222222222-23903.2222222222
346965279811.5714285714-10159.5714285714
35119442136205.222222222-16763.2222222222
3669867106229.072727273-36362.0727272727
37101629106229.072727273-4600.07272727272
387016883396-13228
393108131147.7-66.7000000000007
40103925106229.072727273-2304.07272727272
4192622106229.072727273-13607.0727272727
427901183396-4385
43934878339610091
4464520106229.072727273-41709.0727272727
45934738339610077
46114360106229.0727272738130.92727272728
473303231147.71884.3
4896125136205.222222222-40080.2222222222
49151911136205.22222222215705.7777777778
5089256106229.072727273-16973.0727272727
5195671106229.072727273-10558.0727272727
5259502860.823529411763089.17647058824
53149695136205.22222222213489.7777777778
543255131147.71403.3
553170131147.7553.299999999999
56100087106229.072727273-6142.07272727272
57169707136205.22222222233501.7777777778
58150491172934.571428571-22443.5714285714
59120192136205.222222222-16013.2222222222
6095893106229.072727273-10336.0727272727
61151715136205.22222222215509.7777777778
62176225172934.5714285713290.42857142858
635990083396-23496
64104767106229.072727273-1462.07272727272
65114799106229.0727272738569.92727272728
667212883396-11268
67143592136205.2222222227386.77777777778
6889626106229.072727273-16603.0727272727
69131072136205.222222222-5133.22222222222
701268178339643421
7181351106229.072727273-24878.0727272727
722261831147.7-8529.7
7388977106229.072727273-17252.0727272727
7492059833968663
7581897106229.072727273-24332.0727272727
76108146106229.0727272731916.92727272728
77126372136205.222222222-9833.22222222222
78249771106229.072727273143541.927272727
7971154106229.072727273-35075.0727272727
807157183396-11825
815591883396-27478
82160141136205.22222222223935.7777777778
833869279811.5714285714-41119.5714285714
84102812136205.222222222-33393.2222222222
855662283396-26774
861598631147.7-15161.7
87123534106229.07272727317304.9272727273
88108535106229.0727272732305.92727272728
8993879106229.072727273-12350.0727272727
90144551136205.2222222228345.77777777778
915675083396-26646
92127654136205.222222222-8551.22222222222
936559483396-17802
9459938106229.072727273-46291.0727272727
95146975106229.07272727340745.9272727273
96143372106229.07272727337142.9272727273
97168553136205.22222222232347.7777777778
98183500172934.57142857110565.4285714286
99165986136205.22222222229780.7777777778
100184923172934.57142857111988.4285714286
101140358106229.07272727334128.9272727273
102149959136205.22222222213753.7777777778
1035722483396-26172
1044375031147.712602.3
1054802983396-35367
106104978136205.222222222-31227.2222222222
107100046106229.072727273-6183.07272727272
108101047106229.072727273-5182.07272727272
10919742683396114030
110160902106229.07272727354672.9272727273
111147172106229.07272727340942.9272727273
112109432106229.0727272733202.92727272728
11311682860.82352941176-1692.82352941176
1148324883396-148
1152516231147.7-5985.7
11645724106229.072727273-60505.0727272727
117110529172934.571428571-62405.5714285714
1188552860.82352941176-2005.82352941176
1191013828339617986
120141162860.8235294117611255.1764705882
12189506106229.072727273-16723.0727272727
122135356106229.07272727329126.9272727273
12311606679811.571428571436254.4285714286
1241442448339660848
12587732860.823529411765912.17647058824
126102153106229.072727273-4076.07272727272
127117440136205.222222222-18765.2222222222
128104128136205.222222222-32077.2222222222
129134238136205.222222222-1967.22222222222
130134047136205.222222222-2158.22222222222
131279488172934.571428571106553.428571429
13279756106229.072727273-26473.0727272727
1336608979811.5714285714-13722.5714285714
134102070106229.072727273-4159.07272727272
135146760136205.22222222210554.7777777778
13615477179811.571428571474959.4285714286
137165933136205.22222222229727.7777777778
1386459383396-18803
13992280106229.072727273-13949.0727272727
1406715083396-16246
1411286928339645296
142124089106229.07272727317859.9272727273
143125386172934.571428571-47548.5714285714
1443723879811.5714285714-42573.5714285714
145140015136205.2222222223809.77777777778
146150047106229.07272727343817.9272727273
147154451136205.22222222218245.7777777778
148156349136205.22222222220143.7777777778
14902860.82352941176-2860.82352941176
15060232860.823529411763162.17647058824
15102860.82352941176-2860.82352941176
15202860.82352941176-2860.82352941176
15302860.82352941176-2860.82352941176
15402860.82352941176-2860.82352941176
15584601833961205
15668946136205.222222222-67259.2222222222
15702860.82352941176-2860.82352941176
15802860.82352941176-2860.82352941176
15916442860.82352941176-1216.82352941176
16061792860.823529411763318.17647058824
16139262860.823529411761065.17647058824
1625278931147.721641.3
16302860.82352941176-2860.82352941176
1641003508339616954

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 140824 & 136205.222222222 & 4618.77777777778 \tabularnewline
2 & 110459 & 106229.072727273 & 4229.92727272728 \tabularnewline
3 & 105079 & 83396 & 21683 \tabularnewline
4 & 112098 & 106229.072727273 & 5868.92727272728 \tabularnewline
5 & 43929 & 83396 & -39467 \tabularnewline
6 & 76173 & 79811.5714285714 & -3638.57142857143 \tabularnewline
7 & 187326 & 136205.222222222 & 51120.7777777778 \tabularnewline
8 & 22807 & 31147.7 & -8340.7 \tabularnewline
9 & 144408 & 106229.072727273 & 38178.9272727273 \tabularnewline
10 & 66485 & 83396 & -16911 \tabularnewline
11 & 79089 & 106229.072727273 & -27140.0727272727 \tabularnewline
12 & 81625 & 106229.072727273 & -24604.0727272727 \tabularnewline
13 & 68788 & 83396 & -14608 \tabularnewline
14 & 103297 & 106229.072727273 & -2932.07272727272 \tabularnewline
15 & 69446 & 83396 & -13950 \tabularnewline
16 & 114948 & 106229.072727273 & 8718.92727272728 \tabularnewline
17 & 167949 & 136205.222222222 & 31743.7777777778 \tabularnewline
18 & 125081 & 83396 & 41685 \tabularnewline
19 & 125818 & 136205.222222222 & -10387.2222222222 \tabularnewline
20 & 136588 & 136205.222222222 & 382.777777777781 \tabularnewline
21 & 112431 & 106229.072727273 & 6201.92727272728 \tabularnewline
22 & 103037 & 106229.072727273 & -3192.07272727272 \tabularnewline
23 & 82317 & 83396 & -1079 \tabularnewline
24 & 118906 & 106229.072727273 & 12676.9272727273 \tabularnewline
25 & 83515 & 106229.072727273 & -22714.0727272727 \tabularnewline
26 & 104581 & 106229.072727273 & -1648.07272727272 \tabularnewline
27 & 103129 & 106229.072727273 & -3100.07272727272 \tabularnewline
28 & 83243 & 106229.072727273 & -22986.0727272727 \tabularnewline
29 & 37110 & 83396 & -46286 \tabularnewline
30 & 113344 & 106229.072727273 & 7114.92727272728 \tabularnewline
31 & 139165 & 136205.222222222 & 2959.77777777778 \tabularnewline
32 & 86652 & 136205.222222222 & -49553.2222222222 \tabularnewline
33 & 112302 & 136205.222222222 & -23903.2222222222 \tabularnewline
34 & 69652 & 79811.5714285714 & -10159.5714285714 \tabularnewline
35 & 119442 & 136205.222222222 & -16763.2222222222 \tabularnewline
36 & 69867 & 106229.072727273 & -36362.0727272727 \tabularnewline
37 & 101629 & 106229.072727273 & -4600.07272727272 \tabularnewline
38 & 70168 & 83396 & -13228 \tabularnewline
39 & 31081 & 31147.7 & -66.7000000000007 \tabularnewline
40 & 103925 & 106229.072727273 & -2304.07272727272 \tabularnewline
41 & 92622 & 106229.072727273 & -13607.0727272727 \tabularnewline
42 & 79011 & 83396 & -4385 \tabularnewline
43 & 93487 & 83396 & 10091 \tabularnewline
44 & 64520 & 106229.072727273 & -41709.0727272727 \tabularnewline
45 & 93473 & 83396 & 10077 \tabularnewline
46 & 114360 & 106229.072727273 & 8130.92727272728 \tabularnewline
47 & 33032 & 31147.7 & 1884.3 \tabularnewline
48 & 96125 & 136205.222222222 & -40080.2222222222 \tabularnewline
49 & 151911 & 136205.222222222 & 15705.7777777778 \tabularnewline
50 & 89256 & 106229.072727273 & -16973.0727272727 \tabularnewline
51 & 95671 & 106229.072727273 & -10558.0727272727 \tabularnewline
52 & 5950 & 2860.82352941176 & 3089.17647058824 \tabularnewline
53 & 149695 & 136205.222222222 & 13489.7777777778 \tabularnewline
54 & 32551 & 31147.7 & 1403.3 \tabularnewline
55 & 31701 & 31147.7 & 553.299999999999 \tabularnewline
56 & 100087 & 106229.072727273 & -6142.07272727272 \tabularnewline
57 & 169707 & 136205.222222222 & 33501.7777777778 \tabularnewline
58 & 150491 & 172934.571428571 & -22443.5714285714 \tabularnewline
59 & 120192 & 136205.222222222 & -16013.2222222222 \tabularnewline
60 & 95893 & 106229.072727273 & -10336.0727272727 \tabularnewline
61 & 151715 & 136205.222222222 & 15509.7777777778 \tabularnewline
62 & 176225 & 172934.571428571 & 3290.42857142858 \tabularnewline
63 & 59900 & 83396 & -23496 \tabularnewline
64 & 104767 & 106229.072727273 & -1462.07272727272 \tabularnewline
65 & 114799 & 106229.072727273 & 8569.92727272728 \tabularnewline
66 & 72128 & 83396 & -11268 \tabularnewline
67 & 143592 & 136205.222222222 & 7386.77777777778 \tabularnewline
68 & 89626 & 106229.072727273 & -16603.0727272727 \tabularnewline
69 & 131072 & 136205.222222222 & -5133.22222222222 \tabularnewline
70 & 126817 & 83396 & 43421 \tabularnewline
71 & 81351 & 106229.072727273 & -24878.0727272727 \tabularnewline
72 & 22618 & 31147.7 & -8529.7 \tabularnewline
73 & 88977 & 106229.072727273 & -17252.0727272727 \tabularnewline
74 & 92059 & 83396 & 8663 \tabularnewline
75 & 81897 & 106229.072727273 & -24332.0727272727 \tabularnewline
76 & 108146 & 106229.072727273 & 1916.92727272728 \tabularnewline
77 & 126372 & 136205.222222222 & -9833.22222222222 \tabularnewline
78 & 249771 & 106229.072727273 & 143541.927272727 \tabularnewline
79 & 71154 & 106229.072727273 & -35075.0727272727 \tabularnewline
80 & 71571 & 83396 & -11825 \tabularnewline
81 & 55918 & 83396 & -27478 \tabularnewline
82 & 160141 & 136205.222222222 & 23935.7777777778 \tabularnewline
83 & 38692 & 79811.5714285714 & -41119.5714285714 \tabularnewline
84 & 102812 & 136205.222222222 & -33393.2222222222 \tabularnewline
85 & 56622 & 83396 & -26774 \tabularnewline
86 & 15986 & 31147.7 & -15161.7 \tabularnewline
87 & 123534 & 106229.072727273 & 17304.9272727273 \tabularnewline
88 & 108535 & 106229.072727273 & 2305.92727272728 \tabularnewline
89 & 93879 & 106229.072727273 & -12350.0727272727 \tabularnewline
90 & 144551 & 136205.222222222 & 8345.77777777778 \tabularnewline
91 & 56750 & 83396 & -26646 \tabularnewline
92 & 127654 & 136205.222222222 & -8551.22222222222 \tabularnewline
93 & 65594 & 83396 & -17802 \tabularnewline
94 & 59938 & 106229.072727273 & -46291.0727272727 \tabularnewline
95 & 146975 & 106229.072727273 & 40745.9272727273 \tabularnewline
96 & 143372 & 106229.072727273 & 37142.9272727273 \tabularnewline
97 & 168553 & 136205.222222222 & 32347.7777777778 \tabularnewline
98 & 183500 & 172934.571428571 & 10565.4285714286 \tabularnewline
99 & 165986 & 136205.222222222 & 29780.7777777778 \tabularnewline
100 & 184923 & 172934.571428571 & 11988.4285714286 \tabularnewline
101 & 140358 & 106229.072727273 & 34128.9272727273 \tabularnewline
102 & 149959 & 136205.222222222 & 13753.7777777778 \tabularnewline
103 & 57224 & 83396 & -26172 \tabularnewline
104 & 43750 & 31147.7 & 12602.3 \tabularnewline
105 & 48029 & 83396 & -35367 \tabularnewline
106 & 104978 & 136205.222222222 & -31227.2222222222 \tabularnewline
107 & 100046 & 106229.072727273 & -6183.07272727272 \tabularnewline
108 & 101047 & 106229.072727273 & -5182.07272727272 \tabularnewline
109 & 197426 & 83396 & 114030 \tabularnewline
110 & 160902 & 106229.072727273 & 54672.9272727273 \tabularnewline
111 & 147172 & 106229.072727273 & 40942.9272727273 \tabularnewline
112 & 109432 & 106229.072727273 & 3202.92727272728 \tabularnewline
113 & 1168 & 2860.82352941176 & -1692.82352941176 \tabularnewline
114 & 83248 & 83396 & -148 \tabularnewline
115 & 25162 & 31147.7 & -5985.7 \tabularnewline
116 & 45724 & 106229.072727273 & -60505.0727272727 \tabularnewline
117 & 110529 & 172934.571428571 & -62405.5714285714 \tabularnewline
118 & 855 & 2860.82352941176 & -2005.82352941176 \tabularnewline
119 & 101382 & 83396 & 17986 \tabularnewline
120 & 14116 & 2860.82352941176 & 11255.1764705882 \tabularnewline
121 & 89506 & 106229.072727273 & -16723.0727272727 \tabularnewline
122 & 135356 & 106229.072727273 & 29126.9272727273 \tabularnewline
123 & 116066 & 79811.5714285714 & 36254.4285714286 \tabularnewline
124 & 144244 & 83396 & 60848 \tabularnewline
125 & 8773 & 2860.82352941176 & 5912.17647058824 \tabularnewline
126 & 102153 & 106229.072727273 & -4076.07272727272 \tabularnewline
127 & 117440 & 136205.222222222 & -18765.2222222222 \tabularnewline
128 & 104128 & 136205.222222222 & -32077.2222222222 \tabularnewline
129 & 134238 & 136205.222222222 & -1967.22222222222 \tabularnewline
130 & 134047 & 136205.222222222 & -2158.22222222222 \tabularnewline
131 & 279488 & 172934.571428571 & 106553.428571429 \tabularnewline
132 & 79756 & 106229.072727273 & -26473.0727272727 \tabularnewline
133 & 66089 & 79811.5714285714 & -13722.5714285714 \tabularnewline
134 & 102070 & 106229.072727273 & -4159.07272727272 \tabularnewline
135 & 146760 & 136205.222222222 & 10554.7777777778 \tabularnewline
136 & 154771 & 79811.5714285714 & 74959.4285714286 \tabularnewline
137 & 165933 & 136205.222222222 & 29727.7777777778 \tabularnewline
138 & 64593 & 83396 & -18803 \tabularnewline
139 & 92280 & 106229.072727273 & -13949.0727272727 \tabularnewline
140 & 67150 & 83396 & -16246 \tabularnewline
141 & 128692 & 83396 & 45296 \tabularnewline
142 & 124089 & 106229.072727273 & 17859.9272727273 \tabularnewline
143 & 125386 & 172934.571428571 & -47548.5714285714 \tabularnewline
144 & 37238 & 79811.5714285714 & -42573.5714285714 \tabularnewline
145 & 140015 & 136205.222222222 & 3809.77777777778 \tabularnewline
146 & 150047 & 106229.072727273 & 43817.9272727273 \tabularnewline
147 & 154451 & 136205.222222222 & 18245.7777777778 \tabularnewline
148 & 156349 & 136205.222222222 & 20143.7777777778 \tabularnewline
149 & 0 & 2860.82352941176 & -2860.82352941176 \tabularnewline
150 & 6023 & 2860.82352941176 & 3162.17647058824 \tabularnewline
151 & 0 & 2860.82352941176 & -2860.82352941176 \tabularnewline
152 & 0 & 2860.82352941176 & -2860.82352941176 \tabularnewline
153 & 0 & 2860.82352941176 & -2860.82352941176 \tabularnewline
154 & 0 & 2860.82352941176 & -2860.82352941176 \tabularnewline
155 & 84601 & 83396 & 1205 \tabularnewline
156 & 68946 & 136205.222222222 & -67259.2222222222 \tabularnewline
157 & 0 & 2860.82352941176 & -2860.82352941176 \tabularnewline
158 & 0 & 2860.82352941176 & -2860.82352941176 \tabularnewline
159 & 1644 & 2860.82352941176 & -1216.82352941176 \tabularnewline
160 & 6179 & 2860.82352941176 & 3318.17647058824 \tabularnewline
161 & 3926 & 2860.82352941176 & 1065.17647058824 \tabularnewline
162 & 52789 & 31147.7 & 21641.3 \tabularnewline
163 & 0 & 2860.82352941176 & -2860.82352941176 \tabularnewline
164 & 100350 & 83396 & 16954 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=157800&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]136205.222222222[/C][C]4618.77777777778[/C][/ROW]
[ROW][C]2[/C][C]110459[/C][C]106229.072727273[/C][C]4229.92727272728[/C][/ROW]
[ROW][C]3[/C][C]105079[/C][C]83396[/C][C]21683[/C][/ROW]
[ROW][C]4[/C][C]112098[/C][C]106229.072727273[/C][C]5868.92727272728[/C][/ROW]
[ROW][C]5[/C][C]43929[/C][C]83396[/C][C]-39467[/C][/ROW]
[ROW][C]6[/C][C]76173[/C][C]79811.5714285714[/C][C]-3638.57142857143[/C][/ROW]
[ROW][C]7[/C][C]187326[/C][C]136205.222222222[/C][C]51120.7777777778[/C][/ROW]
[ROW][C]8[/C][C]22807[/C][C]31147.7[/C][C]-8340.7[/C][/ROW]
[ROW][C]9[/C][C]144408[/C][C]106229.072727273[/C][C]38178.9272727273[/C][/ROW]
[ROW][C]10[/C][C]66485[/C][C]83396[/C][C]-16911[/C][/ROW]
[ROW][C]11[/C][C]79089[/C][C]106229.072727273[/C][C]-27140.0727272727[/C][/ROW]
[ROW][C]12[/C][C]81625[/C][C]106229.072727273[/C][C]-24604.0727272727[/C][/ROW]
[ROW][C]13[/C][C]68788[/C][C]83396[/C][C]-14608[/C][/ROW]
[ROW][C]14[/C][C]103297[/C][C]106229.072727273[/C][C]-2932.07272727272[/C][/ROW]
[ROW][C]15[/C][C]69446[/C][C]83396[/C][C]-13950[/C][/ROW]
[ROW][C]16[/C][C]114948[/C][C]106229.072727273[/C][C]8718.92727272728[/C][/ROW]
[ROW][C]17[/C][C]167949[/C][C]136205.222222222[/C][C]31743.7777777778[/C][/ROW]
[ROW][C]18[/C][C]125081[/C][C]83396[/C][C]41685[/C][/ROW]
[ROW][C]19[/C][C]125818[/C][C]136205.222222222[/C][C]-10387.2222222222[/C][/ROW]
[ROW][C]20[/C][C]136588[/C][C]136205.222222222[/C][C]382.777777777781[/C][/ROW]
[ROW][C]21[/C][C]112431[/C][C]106229.072727273[/C][C]6201.92727272728[/C][/ROW]
[ROW][C]22[/C][C]103037[/C][C]106229.072727273[/C][C]-3192.07272727272[/C][/ROW]
[ROW][C]23[/C][C]82317[/C][C]83396[/C][C]-1079[/C][/ROW]
[ROW][C]24[/C][C]118906[/C][C]106229.072727273[/C][C]12676.9272727273[/C][/ROW]
[ROW][C]25[/C][C]83515[/C][C]106229.072727273[/C][C]-22714.0727272727[/C][/ROW]
[ROW][C]26[/C][C]104581[/C][C]106229.072727273[/C][C]-1648.07272727272[/C][/ROW]
[ROW][C]27[/C][C]103129[/C][C]106229.072727273[/C][C]-3100.07272727272[/C][/ROW]
[ROW][C]28[/C][C]83243[/C][C]106229.072727273[/C][C]-22986.0727272727[/C][/ROW]
[ROW][C]29[/C][C]37110[/C][C]83396[/C][C]-46286[/C][/ROW]
[ROW][C]30[/C][C]113344[/C][C]106229.072727273[/C][C]7114.92727272728[/C][/ROW]
[ROW][C]31[/C][C]139165[/C][C]136205.222222222[/C][C]2959.77777777778[/C][/ROW]
[ROW][C]32[/C][C]86652[/C][C]136205.222222222[/C][C]-49553.2222222222[/C][/ROW]
[ROW][C]33[/C][C]112302[/C][C]136205.222222222[/C][C]-23903.2222222222[/C][/ROW]
[ROW][C]34[/C][C]69652[/C][C]79811.5714285714[/C][C]-10159.5714285714[/C][/ROW]
[ROW][C]35[/C][C]119442[/C][C]136205.222222222[/C][C]-16763.2222222222[/C][/ROW]
[ROW][C]36[/C][C]69867[/C][C]106229.072727273[/C][C]-36362.0727272727[/C][/ROW]
[ROW][C]37[/C][C]101629[/C][C]106229.072727273[/C][C]-4600.07272727272[/C][/ROW]
[ROW][C]38[/C][C]70168[/C][C]83396[/C][C]-13228[/C][/ROW]
[ROW][C]39[/C][C]31081[/C][C]31147.7[/C][C]-66.7000000000007[/C][/ROW]
[ROW][C]40[/C][C]103925[/C][C]106229.072727273[/C][C]-2304.07272727272[/C][/ROW]
[ROW][C]41[/C][C]92622[/C][C]106229.072727273[/C][C]-13607.0727272727[/C][/ROW]
[ROW][C]42[/C][C]79011[/C][C]83396[/C][C]-4385[/C][/ROW]
[ROW][C]43[/C][C]93487[/C][C]83396[/C][C]10091[/C][/ROW]
[ROW][C]44[/C][C]64520[/C][C]106229.072727273[/C][C]-41709.0727272727[/C][/ROW]
[ROW][C]45[/C][C]93473[/C][C]83396[/C][C]10077[/C][/ROW]
[ROW][C]46[/C][C]114360[/C][C]106229.072727273[/C][C]8130.92727272728[/C][/ROW]
[ROW][C]47[/C][C]33032[/C][C]31147.7[/C][C]1884.3[/C][/ROW]
[ROW][C]48[/C][C]96125[/C][C]136205.222222222[/C][C]-40080.2222222222[/C][/ROW]
[ROW][C]49[/C][C]151911[/C][C]136205.222222222[/C][C]15705.7777777778[/C][/ROW]
[ROW][C]50[/C][C]89256[/C][C]106229.072727273[/C][C]-16973.0727272727[/C][/ROW]
[ROW][C]51[/C][C]95671[/C][C]106229.072727273[/C][C]-10558.0727272727[/C][/ROW]
[ROW][C]52[/C][C]5950[/C][C]2860.82352941176[/C][C]3089.17647058824[/C][/ROW]
[ROW][C]53[/C][C]149695[/C][C]136205.222222222[/C][C]13489.7777777778[/C][/ROW]
[ROW][C]54[/C][C]32551[/C][C]31147.7[/C][C]1403.3[/C][/ROW]
[ROW][C]55[/C][C]31701[/C][C]31147.7[/C][C]553.299999999999[/C][/ROW]
[ROW][C]56[/C][C]100087[/C][C]106229.072727273[/C][C]-6142.07272727272[/C][/ROW]
[ROW][C]57[/C][C]169707[/C][C]136205.222222222[/C][C]33501.7777777778[/C][/ROW]
[ROW][C]58[/C][C]150491[/C][C]172934.571428571[/C][C]-22443.5714285714[/C][/ROW]
[ROW][C]59[/C][C]120192[/C][C]136205.222222222[/C][C]-16013.2222222222[/C][/ROW]
[ROW][C]60[/C][C]95893[/C][C]106229.072727273[/C][C]-10336.0727272727[/C][/ROW]
[ROW][C]61[/C][C]151715[/C][C]136205.222222222[/C][C]15509.7777777778[/C][/ROW]
[ROW][C]62[/C][C]176225[/C][C]172934.571428571[/C][C]3290.42857142858[/C][/ROW]
[ROW][C]63[/C][C]59900[/C][C]83396[/C][C]-23496[/C][/ROW]
[ROW][C]64[/C][C]104767[/C][C]106229.072727273[/C][C]-1462.07272727272[/C][/ROW]
[ROW][C]65[/C][C]114799[/C][C]106229.072727273[/C][C]8569.92727272728[/C][/ROW]
[ROW][C]66[/C][C]72128[/C][C]83396[/C][C]-11268[/C][/ROW]
[ROW][C]67[/C][C]143592[/C][C]136205.222222222[/C][C]7386.77777777778[/C][/ROW]
[ROW][C]68[/C][C]89626[/C][C]106229.072727273[/C][C]-16603.0727272727[/C][/ROW]
[ROW][C]69[/C][C]131072[/C][C]136205.222222222[/C][C]-5133.22222222222[/C][/ROW]
[ROW][C]70[/C][C]126817[/C][C]83396[/C][C]43421[/C][/ROW]
[ROW][C]71[/C][C]81351[/C][C]106229.072727273[/C][C]-24878.0727272727[/C][/ROW]
[ROW][C]72[/C][C]22618[/C][C]31147.7[/C][C]-8529.7[/C][/ROW]
[ROW][C]73[/C][C]88977[/C][C]106229.072727273[/C][C]-17252.0727272727[/C][/ROW]
[ROW][C]74[/C][C]92059[/C][C]83396[/C][C]8663[/C][/ROW]
[ROW][C]75[/C][C]81897[/C][C]106229.072727273[/C][C]-24332.0727272727[/C][/ROW]
[ROW][C]76[/C][C]108146[/C][C]106229.072727273[/C][C]1916.92727272728[/C][/ROW]
[ROW][C]77[/C][C]126372[/C][C]136205.222222222[/C][C]-9833.22222222222[/C][/ROW]
[ROW][C]78[/C][C]249771[/C][C]106229.072727273[/C][C]143541.927272727[/C][/ROW]
[ROW][C]79[/C][C]71154[/C][C]106229.072727273[/C][C]-35075.0727272727[/C][/ROW]
[ROW][C]80[/C][C]71571[/C][C]83396[/C][C]-11825[/C][/ROW]
[ROW][C]81[/C][C]55918[/C][C]83396[/C][C]-27478[/C][/ROW]
[ROW][C]82[/C][C]160141[/C][C]136205.222222222[/C][C]23935.7777777778[/C][/ROW]
[ROW][C]83[/C][C]38692[/C][C]79811.5714285714[/C][C]-41119.5714285714[/C][/ROW]
[ROW][C]84[/C][C]102812[/C][C]136205.222222222[/C][C]-33393.2222222222[/C][/ROW]
[ROW][C]85[/C][C]56622[/C][C]83396[/C][C]-26774[/C][/ROW]
[ROW][C]86[/C][C]15986[/C][C]31147.7[/C][C]-15161.7[/C][/ROW]
[ROW][C]87[/C][C]123534[/C][C]106229.072727273[/C][C]17304.9272727273[/C][/ROW]
[ROW][C]88[/C][C]108535[/C][C]106229.072727273[/C][C]2305.92727272728[/C][/ROW]
[ROW][C]89[/C][C]93879[/C][C]106229.072727273[/C][C]-12350.0727272727[/C][/ROW]
[ROW][C]90[/C][C]144551[/C][C]136205.222222222[/C][C]8345.77777777778[/C][/ROW]
[ROW][C]91[/C][C]56750[/C][C]83396[/C][C]-26646[/C][/ROW]
[ROW][C]92[/C][C]127654[/C][C]136205.222222222[/C][C]-8551.22222222222[/C][/ROW]
[ROW][C]93[/C][C]65594[/C][C]83396[/C][C]-17802[/C][/ROW]
[ROW][C]94[/C][C]59938[/C][C]106229.072727273[/C][C]-46291.0727272727[/C][/ROW]
[ROW][C]95[/C][C]146975[/C][C]106229.072727273[/C][C]40745.9272727273[/C][/ROW]
[ROW][C]96[/C][C]143372[/C][C]106229.072727273[/C][C]37142.9272727273[/C][/ROW]
[ROW][C]97[/C][C]168553[/C][C]136205.222222222[/C][C]32347.7777777778[/C][/ROW]
[ROW][C]98[/C][C]183500[/C][C]172934.571428571[/C][C]10565.4285714286[/C][/ROW]
[ROW][C]99[/C][C]165986[/C][C]136205.222222222[/C][C]29780.7777777778[/C][/ROW]
[ROW][C]100[/C][C]184923[/C][C]172934.571428571[/C][C]11988.4285714286[/C][/ROW]
[ROW][C]101[/C][C]140358[/C][C]106229.072727273[/C][C]34128.9272727273[/C][/ROW]
[ROW][C]102[/C][C]149959[/C][C]136205.222222222[/C][C]13753.7777777778[/C][/ROW]
[ROW][C]103[/C][C]57224[/C][C]83396[/C][C]-26172[/C][/ROW]
[ROW][C]104[/C][C]43750[/C][C]31147.7[/C][C]12602.3[/C][/ROW]
[ROW][C]105[/C][C]48029[/C][C]83396[/C][C]-35367[/C][/ROW]
[ROW][C]106[/C][C]104978[/C][C]136205.222222222[/C][C]-31227.2222222222[/C][/ROW]
[ROW][C]107[/C][C]100046[/C][C]106229.072727273[/C][C]-6183.07272727272[/C][/ROW]
[ROW][C]108[/C][C]101047[/C][C]106229.072727273[/C][C]-5182.07272727272[/C][/ROW]
[ROW][C]109[/C][C]197426[/C][C]83396[/C][C]114030[/C][/ROW]
[ROW][C]110[/C][C]160902[/C][C]106229.072727273[/C][C]54672.9272727273[/C][/ROW]
[ROW][C]111[/C][C]147172[/C][C]106229.072727273[/C][C]40942.9272727273[/C][/ROW]
[ROW][C]112[/C][C]109432[/C][C]106229.072727273[/C][C]3202.92727272728[/C][/ROW]
[ROW][C]113[/C][C]1168[/C][C]2860.82352941176[/C][C]-1692.82352941176[/C][/ROW]
[ROW][C]114[/C][C]83248[/C][C]83396[/C][C]-148[/C][/ROW]
[ROW][C]115[/C][C]25162[/C][C]31147.7[/C][C]-5985.7[/C][/ROW]
[ROW][C]116[/C][C]45724[/C][C]106229.072727273[/C][C]-60505.0727272727[/C][/ROW]
[ROW][C]117[/C][C]110529[/C][C]172934.571428571[/C][C]-62405.5714285714[/C][/ROW]
[ROW][C]118[/C][C]855[/C][C]2860.82352941176[/C][C]-2005.82352941176[/C][/ROW]
[ROW][C]119[/C][C]101382[/C][C]83396[/C][C]17986[/C][/ROW]
[ROW][C]120[/C][C]14116[/C][C]2860.82352941176[/C][C]11255.1764705882[/C][/ROW]
[ROW][C]121[/C][C]89506[/C][C]106229.072727273[/C][C]-16723.0727272727[/C][/ROW]
[ROW][C]122[/C][C]135356[/C][C]106229.072727273[/C][C]29126.9272727273[/C][/ROW]
[ROW][C]123[/C][C]116066[/C][C]79811.5714285714[/C][C]36254.4285714286[/C][/ROW]
[ROW][C]124[/C][C]144244[/C][C]83396[/C][C]60848[/C][/ROW]
[ROW][C]125[/C][C]8773[/C][C]2860.82352941176[/C][C]5912.17647058824[/C][/ROW]
[ROW][C]126[/C][C]102153[/C][C]106229.072727273[/C][C]-4076.07272727272[/C][/ROW]
[ROW][C]127[/C][C]117440[/C][C]136205.222222222[/C][C]-18765.2222222222[/C][/ROW]
[ROW][C]128[/C][C]104128[/C][C]136205.222222222[/C][C]-32077.2222222222[/C][/ROW]
[ROW][C]129[/C][C]134238[/C][C]136205.222222222[/C][C]-1967.22222222222[/C][/ROW]
[ROW][C]130[/C][C]134047[/C][C]136205.222222222[/C][C]-2158.22222222222[/C][/ROW]
[ROW][C]131[/C][C]279488[/C][C]172934.571428571[/C][C]106553.428571429[/C][/ROW]
[ROW][C]132[/C][C]79756[/C][C]106229.072727273[/C][C]-26473.0727272727[/C][/ROW]
[ROW][C]133[/C][C]66089[/C][C]79811.5714285714[/C][C]-13722.5714285714[/C][/ROW]
[ROW][C]134[/C][C]102070[/C][C]106229.072727273[/C][C]-4159.07272727272[/C][/ROW]
[ROW][C]135[/C][C]146760[/C][C]136205.222222222[/C][C]10554.7777777778[/C][/ROW]
[ROW][C]136[/C][C]154771[/C][C]79811.5714285714[/C][C]74959.4285714286[/C][/ROW]
[ROW][C]137[/C][C]165933[/C][C]136205.222222222[/C][C]29727.7777777778[/C][/ROW]
[ROW][C]138[/C][C]64593[/C][C]83396[/C][C]-18803[/C][/ROW]
[ROW][C]139[/C][C]92280[/C][C]106229.072727273[/C][C]-13949.0727272727[/C][/ROW]
[ROW][C]140[/C][C]67150[/C][C]83396[/C][C]-16246[/C][/ROW]
[ROW][C]141[/C][C]128692[/C][C]83396[/C][C]45296[/C][/ROW]
[ROW][C]142[/C][C]124089[/C][C]106229.072727273[/C][C]17859.9272727273[/C][/ROW]
[ROW][C]143[/C][C]125386[/C][C]172934.571428571[/C][C]-47548.5714285714[/C][/ROW]
[ROW][C]144[/C][C]37238[/C][C]79811.5714285714[/C][C]-42573.5714285714[/C][/ROW]
[ROW][C]145[/C][C]140015[/C][C]136205.222222222[/C][C]3809.77777777778[/C][/ROW]
[ROW][C]146[/C][C]150047[/C][C]106229.072727273[/C][C]43817.9272727273[/C][/ROW]
[ROW][C]147[/C][C]154451[/C][C]136205.222222222[/C][C]18245.7777777778[/C][/ROW]
[ROW][C]148[/C][C]156349[/C][C]136205.222222222[/C][C]20143.7777777778[/C][/ROW]
[ROW][C]149[/C][C]0[/C][C]2860.82352941176[/C][C]-2860.82352941176[/C][/ROW]
[ROW][C]150[/C][C]6023[/C][C]2860.82352941176[/C][C]3162.17647058824[/C][/ROW]
[ROW][C]151[/C][C]0[/C][C]2860.82352941176[/C][C]-2860.82352941176[/C][/ROW]
[ROW][C]152[/C][C]0[/C][C]2860.82352941176[/C][C]-2860.82352941176[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]2860.82352941176[/C][C]-2860.82352941176[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]2860.82352941176[/C][C]-2860.82352941176[/C][/ROW]
[ROW][C]155[/C][C]84601[/C][C]83396[/C][C]1205[/C][/ROW]
[ROW][C]156[/C][C]68946[/C][C]136205.222222222[/C][C]-67259.2222222222[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]2860.82352941176[/C][C]-2860.82352941176[/C][/ROW]
[ROW][C]158[/C][C]0[/C][C]2860.82352941176[/C][C]-2860.82352941176[/C][/ROW]
[ROW][C]159[/C][C]1644[/C][C]2860.82352941176[/C][C]-1216.82352941176[/C][/ROW]
[ROW][C]160[/C][C]6179[/C][C]2860.82352941176[/C][C]3318.17647058824[/C][/ROW]
[ROW][C]161[/C][C]3926[/C][C]2860.82352941176[/C][C]1065.17647058824[/C][/ROW]
[ROW][C]162[/C][C]52789[/C][C]31147.7[/C][C]21641.3[/C][/ROW]
[ROW][C]163[/C][C]0[/C][C]2860.82352941176[/C][C]-2860.82352941176[/C][/ROW]
[ROW][C]164[/C][C]100350[/C][C]83396[/C][C]16954[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=157800&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=157800&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
1140824136205.2222222224618.77777777778
2110459106229.0727272734229.92727272728
31050798339621683
4112098106229.0727272735868.92727272728
54392983396-39467
67617379811.5714285714-3638.57142857143
7187326136205.22222222251120.7777777778
82280731147.7-8340.7
9144408106229.07272727338178.9272727273
106648583396-16911
1179089106229.072727273-27140.0727272727
1281625106229.072727273-24604.0727272727
136878883396-14608
14103297106229.072727273-2932.07272727272
156944683396-13950
16114948106229.0727272738718.92727272728
17167949136205.22222222231743.7777777778
181250818339641685
19125818136205.222222222-10387.2222222222
20136588136205.222222222382.777777777781
21112431106229.0727272736201.92727272728
22103037106229.072727273-3192.07272727272
238231783396-1079
24118906106229.07272727312676.9272727273
2583515106229.072727273-22714.0727272727
26104581106229.072727273-1648.07272727272
27103129106229.072727273-3100.07272727272
2883243106229.072727273-22986.0727272727
293711083396-46286
30113344106229.0727272737114.92727272728
31139165136205.2222222222959.77777777778
3286652136205.222222222-49553.2222222222
33112302136205.222222222-23903.2222222222
346965279811.5714285714-10159.5714285714
35119442136205.222222222-16763.2222222222
3669867106229.072727273-36362.0727272727
37101629106229.072727273-4600.07272727272
387016883396-13228
393108131147.7-66.7000000000007
40103925106229.072727273-2304.07272727272
4192622106229.072727273-13607.0727272727
427901183396-4385
43934878339610091
4464520106229.072727273-41709.0727272727
45934738339610077
46114360106229.0727272738130.92727272728
473303231147.71884.3
4896125136205.222222222-40080.2222222222
49151911136205.22222222215705.7777777778
5089256106229.072727273-16973.0727272727
5195671106229.072727273-10558.0727272727
5259502860.823529411763089.17647058824
53149695136205.22222222213489.7777777778
543255131147.71403.3
553170131147.7553.299999999999
56100087106229.072727273-6142.07272727272
57169707136205.22222222233501.7777777778
58150491172934.571428571-22443.5714285714
59120192136205.222222222-16013.2222222222
6095893106229.072727273-10336.0727272727
61151715136205.22222222215509.7777777778
62176225172934.5714285713290.42857142858
635990083396-23496
64104767106229.072727273-1462.07272727272
65114799106229.0727272738569.92727272728
667212883396-11268
67143592136205.2222222227386.77777777778
6889626106229.072727273-16603.0727272727
69131072136205.222222222-5133.22222222222
701268178339643421
7181351106229.072727273-24878.0727272727
722261831147.7-8529.7
7388977106229.072727273-17252.0727272727
7492059833968663
7581897106229.072727273-24332.0727272727
76108146106229.0727272731916.92727272728
77126372136205.222222222-9833.22222222222
78249771106229.072727273143541.927272727
7971154106229.072727273-35075.0727272727
807157183396-11825
815591883396-27478
82160141136205.22222222223935.7777777778
833869279811.5714285714-41119.5714285714
84102812136205.222222222-33393.2222222222
855662283396-26774
861598631147.7-15161.7
87123534106229.07272727317304.9272727273
88108535106229.0727272732305.92727272728
8993879106229.072727273-12350.0727272727
90144551136205.2222222228345.77777777778
915675083396-26646
92127654136205.222222222-8551.22222222222
936559483396-17802
9459938106229.072727273-46291.0727272727
95146975106229.07272727340745.9272727273
96143372106229.07272727337142.9272727273
97168553136205.22222222232347.7777777778
98183500172934.57142857110565.4285714286
99165986136205.22222222229780.7777777778
100184923172934.57142857111988.4285714286
101140358106229.07272727334128.9272727273
102149959136205.22222222213753.7777777778
1035722483396-26172
1044375031147.712602.3
1054802983396-35367
106104978136205.222222222-31227.2222222222
107100046106229.072727273-6183.07272727272
108101047106229.072727273-5182.07272727272
10919742683396114030
110160902106229.07272727354672.9272727273
111147172106229.07272727340942.9272727273
112109432106229.0727272733202.92727272728
11311682860.82352941176-1692.82352941176
1148324883396-148
1152516231147.7-5985.7
11645724106229.072727273-60505.0727272727
117110529172934.571428571-62405.5714285714
1188552860.82352941176-2005.82352941176
1191013828339617986
120141162860.8235294117611255.1764705882
12189506106229.072727273-16723.0727272727
122135356106229.07272727329126.9272727273
12311606679811.571428571436254.4285714286
1241442448339660848
12587732860.823529411765912.17647058824
126102153106229.072727273-4076.07272727272
127117440136205.222222222-18765.2222222222
128104128136205.222222222-32077.2222222222
129134238136205.222222222-1967.22222222222
130134047136205.222222222-2158.22222222222
131279488172934.571428571106553.428571429
13279756106229.072727273-26473.0727272727
1336608979811.5714285714-13722.5714285714
134102070106229.072727273-4159.07272727272
135146760136205.22222222210554.7777777778
13615477179811.571428571474959.4285714286
137165933136205.22222222229727.7777777778
1386459383396-18803
13992280106229.072727273-13949.0727272727
1406715083396-16246
1411286928339645296
142124089106229.07272727317859.9272727273
143125386172934.571428571-47548.5714285714
1443723879811.5714285714-42573.5714285714
145140015136205.2222222223809.77777777778
146150047106229.07272727343817.9272727273
147154451136205.22222222218245.7777777778
148156349136205.22222222220143.7777777778
14902860.82352941176-2860.82352941176
15060232860.823529411763162.17647058824
15102860.82352941176-2860.82352941176
15202860.82352941176-2860.82352941176
15302860.82352941176-2860.82352941176
15402860.82352941176-2860.82352941176
15584601833961205
15668946136205.222222222-67259.2222222222
15702860.82352941176-2860.82352941176
15802860.82352941176-2860.82352941176
15916442860.82352941176-1216.82352941176
16061792860.823529411763318.17647058824
16139262860.823529411761065.17647058824
1625278931147.721641.3
16302860.82352941176-2860.82352941176
1641003508339616954



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')
}