Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationFri, 16 Dec 2011 08:21:46 -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/16/t1324041754en9r2nk863tfvzw.htm/, Retrieved Sun, 05 May 2024 10:57:20 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=155902, Retrieved Sun, 05 May 2024 10:57:20 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact75
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)] [] [2011-12-16 13:10:07] [8845143a6d3c316a3d9f23c370a4d275]
-   PD      [Recursive Partitioning (Regression Trees)] [] [2011-12-16 13:21:46] [cd8b9934e81fda54a97eda68755efa21] [Current]
- R PD        [Recursive Partitioning (Regression Trees)] [] [2011-12-16 14:48:55] [8845143a6d3c316a3d9f23c370a4d275]
-   P         [Recursive Partitioning (Regression Trees)] [] [2011-12-16 14:51:38] [8845143a6d3c316a3d9f23c370a4d275]
Feedback Forum

Post a new message
Dataseries X:
1418	210907	79	94	112285	24188
869	120982	58	103	84786	18273
1530	176508	60	93	83123	14130
2172	179321	108	103	101193	32287
901	123185	49	51	38361	8654
463	52746	0	70	68504	9245
3201	385534	121	91	119182	33251
371	33170	1	22	22807	1271
1583	149061	43	93	116174	27101
1439	165446	69	60	57635	16373
1764	237213	78	123	66198	19716
1495	173326	86	148	71701	17753
1373	133131	44	90	57793	9028
2187	258873	104	124	80444	18653
1491	180083	63	70	53855	8828
4041	324799	158	168	97668	29498
1706	230964	102	115	133824	27563
2152	236785	77	71	101481	18293
1036	135473	82	66	99645	22530
1882	202925	115	134	114789	15977
1929	215147	101	117	99052	35082
2242	344297	80	108	67654	16116
1220	153935	50	84	65553	15849
1289	132943	83	156	97500	16026
2515	174724	123	120	69112	26569
2147	174415	73	114	82753	24785
2352	225548	81	94	85323	17569
1638	223632	105	120	72654	23825
1222	124817	47	81	30727	7869
1812	221698	105	110	77873	14975
1677	210767	94	133	117478	37791
1579	170266	44	122	74007	9605
1731	260561	114	158	90183	27295
807	84853	38	109	61542	2746
2452	294424	107	124	101494	34461
1940	215641	71	92	55813	4787
2662	325107	84	126	79215	24919
1499	167542	59	70	55461	16329
865	106408	33	37	31081	12558
2527	265769	96	120	83122	28522
2747	269651	106	93	70106	22265
1324	149112	56	95	60578	14459
1383	152871	59	90	79892	22240
1179	111665	39	80	49810	11802
2099	116408	34	31	71570	7623
4308	362301	76	110	100708	11912
918	78800	20	66	33032	7935
1831	183167	91	138	82875	18220
3373	277965	115	133	139077	19199
1713	150629	85	113	71595	19918
1438	168809	76	100	72260	21884
496	24188	8	7	5950	2694
2253	329267	79	140	115762	15808
744	65029	21	61	32551	3597
1161	101097	30	41	31701	5296
2352	218946	76	96	80670	25239
2144	244052	101	164	143558	29801
2694	233328	92	102	120733	34861
1973	256462	123	124	105195	35940
1769	206161	75	99	73107	16688
3148	311473	128	129	132068	24683
2474	235800	105	62	149193	46230
2084	177939	55	73	46821	10387
1954	207176	56	114	87011	21436
1226	196553	41	99	95260	30546
1389	174184	72	70	55183	19746
1496	143246	67	104	106671	15977
2269	187559	75	116	73511	22583
1833	187681	114	91	92945	17274
1268	119016	118	74	78664	16469
1943	182192	77	138	70054	14251
893	73566	22	67	22618	3007
1762	194979	66	151	74011	16851
1403	167488	69	72	83737	21113
1425	143756	105	120	69094	17401
1857	275541	116	115	93133	23958
1840	243199	88	105	95536	23567
1502	182999	73	104	225920	13065
1441	135649	99	108	62133	15358
1420	152299	62	98	61370	14587
1416	120221	53	69	43836	12770
2970	346485	118	111	106117	24021
1317	145790	30	99	38692	9648
1644	193339	100	71	84651	20537
870	80953	49	27	56622	7905
1654	122774	24	69	15986	4527
1054	130585	67	107	95364	30495
3004	286468	57	107	89691	17719
2008	241066	75	93	67267	27056
2547	148446	135	129	126846	33473
1885	204713	68	69	41140	9758
1626	182079	124	118	102860	21115
1468	140344	33	73	51715	7236
2445	220516	98	119	55801	13790
1964	243060	58	104	111813	32902
1381	162765	68	107	120293	25131
1369	182613	81	99	138599	30910
1659	232138	131	90	161647	35947
2888	265318	110	197	115929	29848
2845	310839	130	85	162901	42705
1982	225060	93	139	109825	31808
1904	232317	118	106	129838	26675
1391	144966	39	50	37510	8435
602	43287	13	64	43750	7409
1743	155754	74	31	40652	14993
1559	164709	81	63	87771	36867
2014	201940	109	92	85872	33835
2143	235454	151	106	89275	24164
874	99466	28	69	192565	22609
1281	100750	83	93	140867	6440
1401	224549	54	114	120662	21916
1944	243511	133	110	101338	20556
391	22938	12	0	1168	238
1605	152474	106	83	65567	22392
530	61857	23	30	25162	3913
1386	132487	71	98	40735	8388
2395	317394	116	82	91413	22120
387	21054	4	0	855	338
1742	209641	62	60	97068	11727
449	31414	18	9	14116	3988
2699	244749	98	115	76643	20923
1606	184510	64	140	110681	20237
1204	128423	32	120	92696	3769
1138	97839	25	66	94785	12252
568	38214	16	21	8773	1888
1459	151101	48	124	83209	14497
2158	272458	100	152	93815	28864
1111	172494	46	139	86687	21721
2833	328107	129	144	105547	33644
1955	250579	130	120	103487	15923
2922	351067	136	160	213688	42935
1002	158015	59	114	71220	18864
956	85439	32	78	56926	7785
2186	229242	63	119	91721	17939
3604	351619	95	141	115168	23436
1035	84207	14	101	111194	325
3261	324598	113	133	135777	34538
1587	131069	47	83	51513	12198
1424	204271	92	116	74163	26924
1701	165543	70	90	51633	12716
1249	141722	19	36	75345	8172
3352	299775	91	97	98952	14300
1641	195838	111	98	102372	25515
2035	173260	41	78	37238	2805
2312	254488	120	117	103772	29402
1369	104389	135	148	123969	16440
2201	199476	87	105	135400	28732
1900	224330	131	132	130115	28608
207	14688	4	0	6023	2065
1645	181633	47	73	64466	14817
2429	271856	109	86	54990	16714
151	7199	7	0	1644	556
474	46660	12	13	6179	2089
141	17547	0	4	3926	2658
872	95227	37	48	34777	1669
1318	152601	46	46	73224	16267




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155902&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.7918
R-squared0.6269
RMSE23.0468

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7918[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6269[/C][/ROW]
[ROW][C]RMSE[/C][C]23.0468[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155902&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155902&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.7918
R-squared0.6269
RMSE23.0468







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
194102.152173913043-8.15217391304348
2103102.1521739130430.847826086956516
393102.152173913043-9.15217391304348
4103117.984126984127-14.984126984127
55169-18
67061.958.05
791117.984126984127-26.984126984127
822715
993102.152173913043-9.15217391304348
106069-9
11123102.15217391304320.8478260869565
12148117.98412698412730.015873015873
1390102.152173913043-12.1521739130435
14124117.9841269841276.01587301587301
1570691
16168117.98412698412750.015873015873
17115117.984126984127-2.98412698412699
1871102.152173913043-31.1521739130435
1966102.152173913043-36.1521739130435
20134117.98412698412716.015873015873
21117117.984126984127-0.984126984126988
22108102.1521739130435.84782608695652
2384102.152173913043-18.1521739130435
24156117.98412698412738.015873015873
25120117.9841269841272.01587301587301
26114102.15217391304311.8478260869565
2794102.152173913043-8.15217391304348
28120117.9841269841272.01587301587301
29816912
30110117.984126984127-7.98412698412699
31133117.98412698412715.015873015873
32122102.15217391304319.8478260869565
33158117.98412698412740.015873015873
34109102.1521739130436.84782608695652
35124117.9841269841276.01587301587301
36926923
37126117.9841269841278.01587301587301
3870691
393761.95-24.95
40120117.9841269841272.01587301587301
4193117.984126984127-24.984126984127
4295102.152173913043-7.15217391304348
4390102.152173913043-12.1521739130435
44806911
453161.95-30.95
46110102.1521739130437.84782608695652
476661.954.05
48138117.98412698412720.015873015873
49133117.98412698412715.015873015873
50113117.984126984127-4.98412698412699
51100102.152173913043-2.15217391304348
52770
53140102.15217391304337.8478260869565
546161.95-0.950000000000003
554161.95-20.95
5696102.152173913043-6.15217391304348
57164117.98412698412746.015873015873
58102117.984126984127-15.984126984127
59124117.9841269841276.01587301587301
6099102.152173913043-3.15217391304348
61129117.98412698412711.015873015873
6262117.984126984127-55.984126984127
6373694
64114102.15217391304311.8478260869565
6599102.152173913043-3.15217391304348
6670691
67104102.1521739130431.84782608695652
68116102.15217391304313.8478260869565
6991117.984126984127-26.984126984127
7074117.984126984127-43.984126984127
71138102.15217391304335.8478260869565
726761.955.05
73151102.15217391304348.8478260869565
7472102.152173913043-30.1521739130435
75120117.9841269841272.01587301587301
76115117.984126984127-2.98412698412699
77105117.984126984127-12.984126984127
78104102.1521739130431.84782608695652
79108117.984126984127-9.98412698412699
8098102.152173913043-4.15217391304348
8169690
82111117.984126984127-6.98412698412699
839961.9537.05
8471117.984126984127-46.984126984127
852769-42
866961.957.05
87107102.1521739130434.84782608695652
88107102.1521739130434.84782608695652
8993102.152173913043-9.15217391304348
90129117.98412698412711.015873015873
9169690
92118117.9841269841270.0158730158730123
937361.9511.05
94119117.9841269841271.01587301587301
95104102.1521739130431.84782608695652
96107102.1521739130434.84782608695652
9799102.152173913043-3.15217391304348
9890117.984126984127-27.984126984127
99197117.98412698412779.015873015873
10085117.984126984127-32.984126984127
101139117.98412698412721.015873015873
102106117.984126984127-11.984126984127
1035069-19
1046461.952.05
1053169-38
10663102.152173913043-39.1521739130435
10792117.984126984127-25.984126984127
108106117.984126984127-11.984126984127
1096961.957.05
11093117.984126984127-24.984126984127
111114102.15217391304311.8478260869565
112110117.984126984127-7.98412698412699
11307-7
11483117.984126984127-34.984126984127
1153061.95-31.95
116986929
11782117.984126984127-35.984126984127
11807-7
11960102.152173913043-42.1521739130435
120972
121115117.984126984127-2.98412698412699
122140102.15217391304337.8478260869565
12312061.9558.05
1246661.954.05
12521714
126124102.15217391304321.8478260869565
127152117.98412698412734.015873015873
128139102.15217391304336.8478260869565
129144117.98412698412726.015873015873
130120117.9841269841272.01587301587301
131160117.98412698412742.015873015873
132114102.15217391304311.8478260869565
1337861.9516.05
134119102.15217391304316.8478260869565
135141117.98412698412723.015873015873
13610161.9539.05
137133117.98412698412715.015873015873
138836914
139116117.984126984127-1.98412698412699
140906921
1413661.95-25.95
14297117.984126984127-20.984126984127
14398117.984126984127-19.984126984127
14478699
145117117.984126984127-0.984126984126988
146148117.98412698412730.015873015873
147105117.984126984127-12.984126984127
148132117.98412698412714.015873015873
14907-7
15073102.152173913043-29.1521739130435
15186117.984126984127-31.984126984127
15207-7
1531361.95-48.95
15447-3
1554861.95-13.95
15646102.152173913043-56.1521739130435

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 94 & 102.152173913043 & -8.15217391304348 \tabularnewline
2 & 103 & 102.152173913043 & 0.847826086956516 \tabularnewline
3 & 93 & 102.152173913043 & -9.15217391304348 \tabularnewline
4 & 103 & 117.984126984127 & -14.984126984127 \tabularnewline
5 & 51 & 69 & -18 \tabularnewline
6 & 70 & 61.95 & 8.05 \tabularnewline
7 & 91 & 117.984126984127 & -26.984126984127 \tabularnewline
8 & 22 & 7 & 15 \tabularnewline
9 & 93 & 102.152173913043 & -9.15217391304348 \tabularnewline
10 & 60 & 69 & -9 \tabularnewline
11 & 123 & 102.152173913043 & 20.8478260869565 \tabularnewline
12 & 148 & 117.984126984127 & 30.015873015873 \tabularnewline
13 & 90 & 102.152173913043 & -12.1521739130435 \tabularnewline
14 & 124 & 117.984126984127 & 6.01587301587301 \tabularnewline
15 & 70 & 69 & 1 \tabularnewline
16 & 168 & 117.984126984127 & 50.015873015873 \tabularnewline
17 & 115 & 117.984126984127 & -2.98412698412699 \tabularnewline
18 & 71 & 102.152173913043 & -31.1521739130435 \tabularnewline
19 & 66 & 102.152173913043 & -36.1521739130435 \tabularnewline
20 & 134 & 117.984126984127 & 16.015873015873 \tabularnewline
21 & 117 & 117.984126984127 & -0.984126984126988 \tabularnewline
22 & 108 & 102.152173913043 & 5.84782608695652 \tabularnewline
23 & 84 & 102.152173913043 & -18.1521739130435 \tabularnewline
24 & 156 & 117.984126984127 & 38.015873015873 \tabularnewline
25 & 120 & 117.984126984127 & 2.01587301587301 \tabularnewline
26 & 114 & 102.152173913043 & 11.8478260869565 \tabularnewline
27 & 94 & 102.152173913043 & -8.15217391304348 \tabularnewline
28 & 120 & 117.984126984127 & 2.01587301587301 \tabularnewline
29 & 81 & 69 & 12 \tabularnewline
30 & 110 & 117.984126984127 & -7.98412698412699 \tabularnewline
31 & 133 & 117.984126984127 & 15.015873015873 \tabularnewline
32 & 122 & 102.152173913043 & 19.8478260869565 \tabularnewline
33 & 158 & 117.984126984127 & 40.015873015873 \tabularnewline
34 & 109 & 102.152173913043 & 6.84782608695652 \tabularnewline
35 & 124 & 117.984126984127 & 6.01587301587301 \tabularnewline
36 & 92 & 69 & 23 \tabularnewline
37 & 126 & 117.984126984127 & 8.01587301587301 \tabularnewline
38 & 70 & 69 & 1 \tabularnewline
39 & 37 & 61.95 & -24.95 \tabularnewline
40 & 120 & 117.984126984127 & 2.01587301587301 \tabularnewline
41 & 93 & 117.984126984127 & -24.984126984127 \tabularnewline
42 & 95 & 102.152173913043 & -7.15217391304348 \tabularnewline
43 & 90 & 102.152173913043 & -12.1521739130435 \tabularnewline
44 & 80 & 69 & 11 \tabularnewline
45 & 31 & 61.95 & -30.95 \tabularnewline
46 & 110 & 102.152173913043 & 7.84782608695652 \tabularnewline
47 & 66 & 61.95 & 4.05 \tabularnewline
48 & 138 & 117.984126984127 & 20.015873015873 \tabularnewline
49 & 133 & 117.984126984127 & 15.015873015873 \tabularnewline
50 & 113 & 117.984126984127 & -4.98412698412699 \tabularnewline
51 & 100 & 102.152173913043 & -2.15217391304348 \tabularnewline
52 & 7 & 7 & 0 \tabularnewline
53 & 140 & 102.152173913043 & 37.8478260869565 \tabularnewline
54 & 61 & 61.95 & -0.950000000000003 \tabularnewline
55 & 41 & 61.95 & -20.95 \tabularnewline
56 & 96 & 102.152173913043 & -6.15217391304348 \tabularnewline
57 & 164 & 117.984126984127 & 46.015873015873 \tabularnewline
58 & 102 & 117.984126984127 & -15.984126984127 \tabularnewline
59 & 124 & 117.984126984127 & 6.01587301587301 \tabularnewline
60 & 99 & 102.152173913043 & -3.15217391304348 \tabularnewline
61 & 129 & 117.984126984127 & 11.015873015873 \tabularnewline
62 & 62 & 117.984126984127 & -55.984126984127 \tabularnewline
63 & 73 & 69 & 4 \tabularnewline
64 & 114 & 102.152173913043 & 11.8478260869565 \tabularnewline
65 & 99 & 102.152173913043 & -3.15217391304348 \tabularnewline
66 & 70 & 69 & 1 \tabularnewline
67 & 104 & 102.152173913043 & 1.84782608695652 \tabularnewline
68 & 116 & 102.152173913043 & 13.8478260869565 \tabularnewline
69 & 91 & 117.984126984127 & -26.984126984127 \tabularnewline
70 & 74 & 117.984126984127 & -43.984126984127 \tabularnewline
71 & 138 & 102.152173913043 & 35.8478260869565 \tabularnewline
72 & 67 & 61.95 & 5.05 \tabularnewline
73 & 151 & 102.152173913043 & 48.8478260869565 \tabularnewline
74 & 72 & 102.152173913043 & -30.1521739130435 \tabularnewline
75 & 120 & 117.984126984127 & 2.01587301587301 \tabularnewline
76 & 115 & 117.984126984127 & -2.98412698412699 \tabularnewline
77 & 105 & 117.984126984127 & -12.984126984127 \tabularnewline
78 & 104 & 102.152173913043 & 1.84782608695652 \tabularnewline
79 & 108 & 117.984126984127 & -9.98412698412699 \tabularnewline
80 & 98 & 102.152173913043 & -4.15217391304348 \tabularnewline
81 & 69 & 69 & 0 \tabularnewline
82 & 111 & 117.984126984127 & -6.98412698412699 \tabularnewline
83 & 99 & 61.95 & 37.05 \tabularnewline
84 & 71 & 117.984126984127 & -46.984126984127 \tabularnewline
85 & 27 & 69 & -42 \tabularnewline
86 & 69 & 61.95 & 7.05 \tabularnewline
87 & 107 & 102.152173913043 & 4.84782608695652 \tabularnewline
88 & 107 & 102.152173913043 & 4.84782608695652 \tabularnewline
89 & 93 & 102.152173913043 & -9.15217391304348 \tabularnewline
90 & 129 & 117.984126984127 & 11.015873015873 \tabularnewline
91 & 69 & 69 & 0 \tabularnewline
92 & 118 & 117.984126984127 & 0.0158730158730123 \tabularnewline
93 & 73 & 61.95 & 11.05 \tabularnewline
94 & 119 & 117.984126984127 & 1.01587301587301 \tabularnewline
95 & 104 & 102.152173913043 & 1.84782608695652 \tabularnewline
96 & 107 & 102.152173913043 & 4.84782608695652 \tabularnewline
97 & 99 & 102.152173913043 & -3.15217391304348 \tabularnewline
98 & 90 & 117.984126984127 & -27.984126984127 \tabularnewline
99 & 197 & 117.984126984127 & 79.015873015873 \tabularnewline
100 & 85 & 117.984126984127 & -32.984126984127 \tabularnewline
101 & 139 & 117.984126984127 & 21.015873015873 \tabularnewline
102 & 106 & 117.984126984127 & -11.984126984127 \tabularnewline
103 & 50 & 69 & -19 \tabularnewline
104 & 64 & 61.95 & 2.05 \tabularnewline
105 & 31 & 69 & -38 \tabularnewline
106 & 63 & 102.152173913043 & -39.1521739130435 \tabularnewline
107 & 92 & 117.984126984127 & -25.984126984127 \tabularnewline
108 & 106 & 117.984126984127 & -11.984126984127 \tabularnewline
109 & 69 & 61.95 & 7.05 \tabularnewline
110 & 93 & 117.984126984127 & -24.984126984127 \tabularnewline
111 & 114 & 102.152173913043 & 11.8478260869565 \tabularnewline
112 & 110 & 117.984126984127 & -7.98412698412699 \tabularnewline
113 & 0 & 7 & -7 \tabularnewline
114 & 83 & 117.984126984127 & -34.984126984127 \tabularnewline
115 & 30 & 61.95 & -31.95 \tabularnewline
116 & 98 & 69 & 29 \tabularnewline
117 & 82 & 117.984126984127 & -35.984126984127 \tabularnewline
118 & 0 & 7 & -7 \tabularnewline
119 & 60 & 102.152173913043 & -42.1521739130435 \tabularnewline
120 & 9 & 7 & 2 \tabularnewline
121 & 115 & 117.984126984127 & -2.98412698412699 \tabularnewline
122 & 140 & 102.152173913043 & 37.8478260869565 \tabularnewline
123 & 120 & 61.95 & 58.05 \tabularnewline
124 & 66 & 61.95 & 4.05 \tabularnewline
125 & 21 & 7 & 14 \tabularnewline
126 & 124 & 102.152173913043 & 21.8478260869565 \tabularnewline
127 & 152 & 117.984126984127 & 34.015873015873 \tabularnewline
128 & 139 & 102.152173913043 & 36.8478260869565 \tabularnewline
129 & 144 & 117.984126984127 & 26.015873015873 \tabularnewline
130 & 120 & 117.984126984127 & 2.01587301587301 \tabularnewline
131 & 160 & 117.984126984127 & 42.015873015873 \tabularnewline
132 & 114 & 102.152173913043 & 11.8478260869565 \tabularnewline
133 & 78 & 61.95 & 16.05 \tabularnewline
134 & 119 & 102.152173913043 & 16.8478260869565 \tabularnewline
135 & 141 & 117.984126984127 & 23.015873015873 \tabularnewline
136 & 101 & 61.95 & 39.05 \tabularnewline
137 & 133 & 117.984126984127 & 15.015873015873 \tabularnewline
138 & 83 & 69 & 14 \tabularnewline
139 & 116 & 117.984126984127 & -1.98412698412699 \tabularnewline
140 & 90 & 69 & 21 \tabularnewline
141 & 36 & 61.95 & -25.95 \tabularnewline
142 & 97 & 117.984126984127 & -20.984126984127 \tabularnewline
143 & 98 & 117.984126984127 & -19.984126984127 \tabularnewline
144 & 78 & 69 & 9 \tabularnewline
145 & 117 & 117.984126984127 & -0.984126984126988 \tabularnewline
146 & 148 & 117.984126984127 & 30.015873015873 \tabularnewline
147 & 105 & 117.984126984127 & -12.984126984127 \tabularnewline
148 & 132 & 117.984126984127 & 14.015873015873 \tabularnewline
149 & 0 & 7 & -7 \tabularnewline
150 & 73 & 102.152173913043 & -29.1521739130435 \tabularnewline
151 & 86 & 117.984126984127 & -31.984126984127 \tabularnewline
152 & 0 & 7 & -7 \tabularnewline
153 & 13 & 61.95 & -48.95 \tabularnewline
154 & 4 & 7 & -3 \tabularnewline
155 & 48 & 61.95 & -13.95 \tabularnewline
156 & 46 & 102.152173913043 & -56.1521739130435 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155902&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]94[/C][C]102.152173913043[/C][C]-8.15217391304348[/C][/ROW]
[ROW][C]2[/C][C]103[/C][C]102.152173913043[/C][C]0.847826086956516[/C][/ROW]
[ROW][C]3[/C][C]93[/C][C]102.152173913043[/C][C]-9.15217391304348[/C][/ROW]
[ROW][C]4[/C][C]103[/C][C]117.984126984127[/C][C]-14.984126984127[/C][/ROW]
[ROW][C]5[/C][C]51[/C][C]69[/C][C]-18[/C][/ROW]
[ROW][C]6[/C][C]70[/C][C]61.95[/C][C]8.05[/C][/ROW]
[ROW][C]7[/C][C]91[/C][C]117.984126984127[/C][C]-26.984126984127[/C][/ROW]
[ROW][C]8[/C][C]22[/C][C]7[/C][C]15[/C][/ROW]
[ROW][C]9[/C][C]93[/C][C]102.152173913043[/C][C]-9.15217391304348[/C][/ROW]
[ROW][C]10[/C][C]60[/C][C]69[/C][C]-9[/C][/ROW]
[ROW][C]11[/C][C]123[/C][C]102.152173913043[/C][C]20.8478260869565[/C][/ROW]
[ROW][C]12[/C][C]148[/C][C]117.984126984127[/C][C]30.015873015873[/C][/ROW]
[ROW][C]13[/C][C]90[/C][C]102.152173913043[/C][C]-12.1521739130435[/C][/ROW]
[ROW][C]14[/C][C]124[/C][C]117.984126984127[/C][C]6.01587301587301[/C][/ROW]
[ROW][C]15[/C][C]70[/C][C]69[/C][C]1[/C][/ROW]
[ROW][C]16[/C][C]168[/C][C]117.984126984127[/C][C]50.015873015873[/C][/ROW]
[ROW][C]17[/C][C]115[/C][C]117.984126984127[/C][C]-2.98412698412699[/C][/ROW]
[ROW][C]18[/C][C]71[/C][C]102.152173913043[/C][C]-31.1521739130435[/C][/ROW]
[ROW][C]19[/C][C]66[/C][C]102.152173913043[/C][C]-36.1521739130435[/C][/ROW]
[ROW][C]20[/C][C]134[/C][C]117.984126984127[/C][C]16.015873015873[/C][/ROW]
[ROW][C]21[/C][C]117[/C][C]117.984126984127[/C][C]-0.984126984126988[/C][/ROW]
[ROW][C]22[/C][C]108[/C][C]102.152173913043[/C][C]5.84782608695652[/C][/ROW]
[ROW][C]23[/C][C]84[/C][C]102.152173913043[/C][C]-18.1521739130435[/C][/ROW]
[ROW][C]24[/C][C]156[/C][C]117.984126984127[/C][C]38.015873015873[/C][/ROW]
[ROW][C]25[/C][C]120[/C][C]117.984126984127[/C][C]2.01587301587301[/C][/ROW]
[ROW][C]26[/C][C]114[/C][C]102.152173913043[/C][C]11.8478260869565[/C][/ROW]
[ROW][C]27[/C][C]94[/C][C]102.152173913043[/C][C]-8.15217391304348[/C][/ROW]
[ROW][C]28[/C][C]120[/C][C]117.984126984127[/C][C]2.01587301587301[/C][/ROW]
[ROW][C]29[/C][C]81[/C][C]69[/C][C]12[/C][/ROW]
[ROW][C]30[/C][C]110[/C][C]117.984126984127[/C][C]-7.98412698412699[/C][/ROW]
[ROW][C]31[/C][C]133[/C][C]117.984126984127[/C][C]15.015873015873[/C][/ROW]
[ROW][C]32[/C][C]122[/C][C]102.152173913043[/C][C]19.8478260869565[/C][/ROW]
[ROW][C]33[/C][C]158[/C][C]117.984126984127[/C][C]40.015873015873[/C][/ROW]
[ROW][C]34[/C][C]109[/C][C]102.152173913043[/C][C]6.84782608695652[/C][/ROW]
[ROW][C]35[/C][C]124[/C][C]117.984126984127[/C][C]6.01587301587301[/C][/ROW]
[ROW][C]36[/C][C]92[/C][C]69[/C][C]23[/C][/ROW]
[ROW][C]37[/C][C]126[/C][C]117.984126984127[/C][C]8.01587301587301[/C][/ROW]
[ROW][C]38[/C][C]70[/C][C]69[/C][C]1[/C][/ROW]
[ROW][C]39[/C][C]37[/C][C]61.95[/C][C]-24.95[/C][/ROW]
[ROW][C]40[/C][C]120[/C][C]117.984126984127[/C][C]2.01587301587301[/C][/ROW]
[ROW][C]41[/C][C]93[/C][C]117.984126984127[/C][C]-24.984126984127[/C][/ROW]
[ROW][C]42[/C][C]95[/C][C]102.152173913043[/C][C]-7.15217391304348[/C][/ROW]
[ROW][C]43[/C][C]90[/C][C]102.152173913043[/C][C]-12.1521739130435[/C][/ROW]
[ROW][C]44[/C][C]80[/C][C]69[/C][C]11[/C][/ROW]
[ROW][C]45[/C][C]31[/C][C]61.95[/C][C]-30.95[/C][/ROW]
[ROW][C]46[/C][C]110[/C][C]102.152173913043[/C][C]7.84782608695652[/C][/ROW]
[ROW][C]47[/C][C]66[/C][C]61.95[/C][C]4.05[/C][/ROW]
[ROW][C]48[/C][C]138[/C][C]117.984126984127[/C][C]20.015873015873[/C][/ROW]
[ROW][C]49[/C][C]133[/C][C]117.984126984127[/C][C]15.015873015873[/C][/ROW]
[ROW][C]50[/C][C]113[/C][C]117.984126984127[/C][C]-4.98412698412699[/C][/ROW]
[ROW][C]51[/C][C]100[/C][C]102.152173913043[/C][C]-2.15217391304348[/C][/ROW]
[ROW][C]52[/C][C]7[/C][C]7[/C][C]0[/C][/ROW]
[ROW][C]53[/C][C]140[/C][C]102.152173913043[/C][C]37.8478260869565[/C][/ROW]
[ROW][C]54[/C][C]61[/C][C]61.95[/C][C]-0.950000000000003[/C][/ROW]
[ROW][C]55[/C][C]41[/C][C]61.95[/C][C]-20.95[/C][/ROW]
[ROW][C]56[/C][C]96[/C][C]102.152173913043[/C][C]-6.15217391304348[/C][/ROW]
[ROW][C]57[/C][C]164[/C][C]117.984126984127[/C][C]46.015873015873[/C][/ROW]
[ROW][C]58[/C][C]102[/C][C]117.984126984127[/C][C]-15.984126984127[/C][/ROW]
[ROW][C]59[/C][C]124[/C][C]117.984126984127[/C][C]6.01587301587301[/C][/ROW]
[ROW][C]60[/C][C]99[/C][C]102.152173913043[/C][C]-3.15217391304348[/C][/ROW]
[ROW][C]61[/C][C]129[/C][C]117.984126984127[/C][C]11.015873015873[/C][/ROW]
[ROW][C]62[/C][C]62[/C][C]117.984126984127[/C][C]-55.984126984127[/C][/ROW]
[ROW][C]63[/C][C]73[/C][C]69[/C][C]4[/C][/ROW]
[ROW][C]64[/C][C]114[/C][C]102.152173913043[/C][C]11.8478260869565[/C][/ROW]
[ROW][C]65[/C][C]99[/C][C]102.152173913043[/C][C]-3.15217391304348[/C][/ROW]
[ROW][C]66[/C][C]70[/C][C]69[/C][C]1[/C][/ROW]
[ROW][C]67[/C][C]104[/C][C]102.152173913043[/C][C]1.84782608695652[/C][/ROW]
[ROW][C]68[/C][C]116[/C][C]102.152173913043[/C][C]13.8478260869565[/C][/ROW]
[ROW][C]69[/C][C]91[/C][C]117.984126984127[/C][C]-26.984126984127[/C][/ROW]
[ROW][C]70[/C][C]74[/C][C]117.984126984127[/C][C]-43.984126984127[/C][/ROW]
[ROW][C]71[/C][C]138[/C][C]102.152173913043[/C][C]35.8478260869565[/C][/ROW]
[ROW][C]72[/C][C]67[/C][C]61.95[/C][C]5.05[/C][/ROW]
[ROW][C]73[/C][C]151[/C][C]102.152173913043[/C][C]48.8478260869565[/C][/ROW]
[ROW][C]74[/C][C]72[/C][C]102.152173913043[/C][C]-30.1521739130435[/C][/ROW]
[ROW][C]75[/C][C]120[/C][C]117.984126984127[/C][C]2.01587301587301[/C][/ROW]
[ROW][C]76[/C][C]115[/C][C]117.984126984127[/C][C]-2.98412698412699[/C][/ROW]
[ROW][C]77[/C][C]105[/C][C]117.984126984127[/C][C]-12.984126984127[/C][/ROW]
[ROW][C]78[/C][C]104[/C][C]102.152173913043[/C][C]1.84782608695652[/C][/ROW]
[ROW][C]79[/C][C]108[/C][C]117.984126984127[/C][C]-9.98412698412699[/C][/ROW]
[ROW][C]80[/C][C]98[/C][C]102.152173913043[/C][C]-4.15217391304348[/C][/ROW]
[ROW][C]81[/C][C]69[/C][C]69[/C][C]0[/C][/ROW]
[ROW][C]82[/C][C]111[/C][C]117.984126984127[/C][C]-6.98412698412699[/C][/ROW]
[ROW][C]83[/C][C]99[/C][C]61.95[/C][C]37.05[/C][/ROW]
[ROW][C]84[/C][C]71[/C][C]117.984126984127[/C][C]-46.984126984127[/C][/ROW]
[ROW][C]85[/C][C]27[/C][C]69[/C][C]-42[/C][/ROW]
[ROW][C]86[/C][C]69[/C][C]61.95[/C][C]7.05[/C][/ROW]
[ROW][C]87[/C][C]107[/C][C]102.152173913043[/C][C]4.84782608695652[/C][/ROW]
[ROW][C]88[/C][C]107[/C][C]102.152173913043[/C][C]4.84782608695652[/C][/ROW]
[ROW][C]89[/C][C]93[/C][C]102.152173913043[/C][C]-9.15217391304348[/C][/ROW]
[ROW][C]90[/C][C]129[/C][C]117.984126984127[/C][C]11.015873015873[/C][/ROW]
[ROW][C]91[/C][C]69[/C][C]69[/C][C]0[/C][/ROW]
[ROW][C]92[/C][C]118[/C][C]117.984126984127[/C][C]0.0158730158730123[/C][/ROW]
[ROW][C]93[/C][C]73[/C][C]61.95[/C][C]11.05[/C][/ROW]
[ROW][C]94[/C][C]119[/C][C]117.984126984127[/C][C]1.01587301587301[/C][/ROW]
[ROW][C]95[/C][C]104[/C][C]102.152173913043[/C][C]1.84782608695652[/C][/ROW]
[ROW][C]96[/C][C]107[/C][C]102.152173913043[/C][C]4.84782608695652[/C][/ROW]
[ROW][C]97[/C][C]99[/C][C]102.152173913043[/C][C]-3.15217391304348[/C][/ROW]
[ROW][C]98[/C][C]90[/C][C]117.984126984127[/C][C]-27.984126984127[/C][/ROW]
[ROW][C]99[/C][C]197[/C][C]117.984126984127[/C][C]79.015873015873[/C][/ROW]
[ROW][C]100[/C][C]85[/C][C]117.984126984127[/C][C]-32.984126984127[/C][/ROW]
[ROW][C]101[/C][C]139[/C][C]117.984126984127[/C][C]21.015873015873[/C][/ROW]
[ROW][C]102[/C][C]106[/C][C]117.984126984127[/C][C]-11.984126984127[/C][/ROW]
[ROW][C]103[/C][C]50[/C][C]69[/C][C]-19[/C][/ROW]
[ROW][C]104[/C][C]64[/C][C]61.95[/C][C]2.05[/C][/ROW]
[ROW][C]105[/C][C]31[/C][C]69[/C][C]-38[/C][/ROW]
[ROW][C]106[/C][C]63[/C][C]102.152173913043[/C][C]-39.1521739130435[/C][/ROW]
[ROW][C]107[/C][C]92[/C][C]117.984126984127[/C][C]-25.984126984127[/C][/ROW]
[ROW][C]108[/C][C]106[/C][C]117.984126984127[/C][C]-11.984126984127[/C][/ROW]
[ROW][C]109[/C][C]69[/C][C]61.95[/C][C]7.05[/C][/ROW]
[ROW][C]110[/C][C]93[/C][C]117.984126984127[/C][C]-24.984126984127[/C][/ROW]
[ROW][C]111[/C][C]114[/C][C]102.152173913043[/C][C]11.8478260869565[/C][/ROW]
[ROW][C]112[/C][C]110[/C][C]117.984126984127[/C][C]-7.98412698412699[/C][/ROW]
[ROW][C]113[/C][C]0[/C][C]7[/C][C]-7[/C][/ROW]
[ROW][C]114[/C][C]83[/C][C]117.984126984127[/C][C]-34.984126984127[/C][/ROW]
[ROW][C]115[/C][C]30[/C][C]61.95[/C][C]-31.95[/C][/ROW]
[ROW][C]116[/C][C]98[/C][C]69[/C][C]29[/C][/ROW]
[ROW][C]117[/C][C]82[/C][C]117.984126984127[/C][C]-35.984126984127[/C][/ROW]
[ROW][C]118[/C][C]0[/C][C]7[/C][C]-7[/C][/ROW]
[ROW][C]119[/C][C]60[/C][C]102.152173913043[/C][C]-42.1521739130435[/C][/ROW]
[ROW][C]120[/C][C]9[/C][C]7[/C][C]2[/C][/ROW]
[ROW][C]121[/C][C]115[/C][C]117.984126984127[/C][C]-2.98412698412699[/C][/ROW]
[ROW][C]122[/C][C]140[/C][C]102.152173913043[/C][C]37.8478260869565[/C][/ROW]
[ROW][C]123[/C][C]120[/C][C]61.95[/C][C]58.05[/C][/ROW]
[ROW][C]124[/C][C]66[/C][C]61.95[/C][C]4.05[/C][/ROW]
[ROW][C]125[/C][C]21[/C][C]7[/C][C]14[/C][/ROW]
[ROW][C]126[/C][C]124[/C][C]102.152173913043[/C][C]21.8478260869565[/C][/ROW]
[ROW][C]127[/C][C]152[/C][C]117.984126984127[/C][C]34.015873015873[/C][/ROW]
[ROW][C]128[/C][C]139[/C][C]102.152173913043[/C][C]36.8478260869565[/C][/ROW]
[ROW][C]129[/C][C]144[/C][C]117.984126984127[/C][C]26.015873015873[/C][/ROW]
[ROW][C]130[/C][C]120[/C][C]117.984126984127[/C][C]2.01587301587301[/C][/ROW]
[ROW][C]131[/C][C]160[/C][C]117.984126984127[/C][C]42.015873015873[/C][/ROW]
[ROW][C]132[/C][C]114[/C][C]102.152173913043[/C][C]11.8478260869565[/C][/ROW]
[ROW][C]133[/C][C]78[/C][C]61.95[/C][C]16.05[/C][/ROW]
[ROW][C]134[/C][C]119[/C][C]102.152173913043[/C][C]16.8478260869565[/C][/ROW]
[ROW][C]135[/C][C]141[/C][C]117.984126984127[/C][C]23.015873015873[/C][/ROW]
[ROW][C]136[/C][C]101[/C][C]61.95[/C][C]39.05[/C][/ROW]
[ROW][C]137[/C][C]133[/C][C]117.984126984127[/C][C]15.015873015873[/C][/ROW]
[ROW][C]138[/C][C]83[/C][C]69[/C][C]14[/C][/ROW]
[ROW][C]139[/C][C]116[/C][C]117.984126984127[/C][C]-1.98412698412699[/C][/ROW]
[ROW][C]140[/C][C]90[/C][C]69[/C][C]21[/C][/ROW]
[ROW][C]141[/C][C]36[/C][C]61.95[/C][C]-25.95[/C][/ROW]
[ROW][C]142[/C][C]97[/C][C]117.984126984127[/C][C]-20.984126984127[/C][/ROW]
[ROW][C]143[/C][C]98[/C][C]117.984126984127[/C][C]-19.984126984127[/C][/ROW]
[ROW][C]144[/C][C]78[/C][C]69[/C][C]9[/C][/ROW]
[ROW][C]145[/C][C]117[/C][C]117.984126984127[/C][C]-0.984126984126988[/C][/ROW]
[ROW][C]146[/C][C]148[/C][C]117.984126984127[/C][C]30.015873015873[/C][/ROW]
[ROW][C]147[/C][C]105[/C][C]117.984126984127[/C][C]-12.984126984127[/C][/ROW]
[ROW][C]148[/C][C]132[/C][C]117.984126984127[/C][C]14.015873015873[/C][/ROW]
[ROW][C]149[/C][C]0[/C][C]7[/C][C]-7[/C][/ROW]
[ROW][C]150[/C][C]73[/C][C]102.152173913043[/C][C]-29.1521739130435[/C][/ROW]
[ROW][C]151[/C][C]86[/C][C]117.984126984127[/C][C]-31.984126984127[/C][/ROW]
[ROW][C]152[/C][C]0[/C][C]7[/C][C]-7[/C][/ROW]
[ROW][C]153[/C][C]13[/C][C]61.95[/C][C]-48.95[/C][/ROW]
[ROW][C]154[/C][C]4[/C][C]7[/C][C]-3[/C][/ROW]
[ROW][C]155[/C][C]48[/C][C]61.95[/C][C]-13.95[/C][/ROW]
[ROW][C]156[/C][C]46[/C][C]102.152173913043[/C][C]-56.1521739130435[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155902&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155902&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
194102.152173913043-8.15217391304348
2103102.1521739130430.847826086956516
393102.152173913043-9.15217391304348
4103117.984126984127-14.984126984127
55169-18
67061.958.05
791117.984126984127-26.984126984127
822715
993102.152173913043-9.15217391304348
106069-9
11123102.15217391304320.8478260869565
12148117.98412698412730.015873015873
1390102.152173913043-12.1521739130435
14124117.9841269841276.01587301587301
1570691
16168117.98412698412750.015873015873
17115117.984126984127-2.98412698412699
1871102.152173913043-31.1521739130435
1966102.152173913043-36.1521739130435
20134117.98412698412716.015873015873
21117117.984126984127-0.984126984126988
22108102.1521739130435.84782608695652
2384102.152173913043-18.1521739130435
24156117.98412698412738.015873015873
25120117.9841269841272.01587301587301
26114102.15217391304311.8478260869565
2794102.152173913043-8.15217391304348
28120117.9841269841272.01587301587301
29816912
30110117.984126984127-7.98412698412699
31133117.98412698412715.015873015873
32122102.15217391304319.8478260869565
33158117.98412698412740.015873015873
34109102.1521739130436.84782608695652
35124117.9841269841276.01587301587301
36926923
37126117.9841269841278.01587301587301
3870691
393761.95-24.95
40120117.9841269841272.01587301587301
4193117.984126984127-24.984126984127
4295102.152173913043-7.15217391304348
4390102.152173913043-12.1521739130435
44806911
453161.95-30.95
46110102.1521739130437.84782608695652
476661.954.05
48138117.98412698412720.015873015873
49133117.98412698412715.015873015873
50113117.984126984127-4.98412698412699
51100102.152173913043-2.15217391304348
52770
53140102.15217391304337.8478260869565
546161.95-0.950000000000003
554161.95-20.95
5696102.152173913043-6.15217391304348
57164117.98412698412746.015873015873
58102117.984126984127-15.984126984127
59124117.9841269841276.01587301587301
6099102.152173913043-3.15217391304348
61129117.98412698412711.015873015873
6262117.984126984127-55.984126984127
6373694
64114102.15217391304311.8478260869565
6599102.152173913043-3.15217391304348
6670691
67104102.1521739130431.84782608695652
68116102.15217391304313.8478260869565
6991117.984126984127-26.984126984127
7074117.984126984127-43.984126984127
71138102.15217391304335.8478260869565
726761.955.05
73151102.15217391304348.8478260869565
7472102.152173913043-30.1521739130435
75120117.9841269841272.01587301587301
76115117.984126984127-2.98412698412699
77105117.984126984127-12.984126984127
78104102.1521739130431.84782608695652
79108117.984126984127-9.98412698412699
8098102.152173913043-4.15217391304348
8169690
82111117.984126984127-6.98412698412699
839961.9537.05
8471117.984126984127-46.984126984127
852769-42
866961.957.05
87107102.1521739130434.84782608695652
88107102.1521739130434.84782608695652
8993102.152173913043-9.15217391304348
90129117.98412698412711.015873015873
9169690
92118117.9841269841270.0158730158730123
937361.9511.05
94119117.9841269841271.01587301587301
95104102.1521739130431.84782608695652
96107102.1521739130434.84782608695652
9799102.152173913043-3.15217391304348
9890117.984126984127-27.984126984127
99197117.98412698412779.015873015873
10085117.984126984127-32.984126984127
101139117.98412698412721.015873015873
102106117.984126984127-11.984126984127
1035069-19
1046461.952.05
1053169-38
10663102.152173913043-39.1521739130435
10792117.984126984127-25.984126984127
108106117.984126984127-11.984126984127
1096961.957.05
11093117.984126984127-24.984126984127
111114102.15217391304311.8478260869565
112110117.984126984127-7.98412698412699
11307-7
11483117.984126984127-34.984126984127
1153061.95-31.95
116986929
11782117.984126984127-35.984126984127
11807-7
11960102.152173913043-42.1521739130435
120972
121115117.984126984127-2.98412698412699
122140102.15217391304337.8478260869565
12312061.9558.05
1246661.954.05
12521714
126124102.15217391304321.8478260869565
127152117.98412698412734.015873015873
128139102.15217391304336.8478260869565
129144117.98412698412726.015873015873
130120117.9841269841272.01587301587301
131160117.98412698412742.015873015873
132114102.15217391304311.8478260869565
1337861.9516.05
134119102.15217391304316.8478260869565
135141117.98412698412723.015873015873
13610161.9539.05
137133117.98412698412715.015873015873
138836914
139116117.984126984127-1.98412698412699
140906921
1413661.95-25.95
14297117.984126984127-20.984126984127
14398117.984126984127-19.984126984127
14478699
145117117.984126984127-0.984126984126988
146148117.98412698412730.015873015873
147105117.984126984127-12.984126984127
148132117.98412698412714.015873015873
14907-7
15073102.152173913043-29.1521739130435
15186117.984126984127-31.984126984127
15207-7
1531361.95-48.95
15447-3
1554861.95-13.95
15646102.152173913043-56.1521739130435



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