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 computationThu, 22 Dec 2011 09:34:01 -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/22/t132456452466yaqvntcvbmhb8.htm/, Retrieved Fri, 03 May 2024 13:08:59 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=159508, Retrieved Fri, 03 May 2024 13:08:59 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact117
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [recursive] [2011-12-22 14:34:01] [5363b79245edacd2d961915f77b3b63a] [Current]
Feedback Forum

Post a new message
Dataseries X:
1826	161442	592	48	93
1728	189695	524	53	60
192	7215	72	0	18
2295	129098	645	51	95
3509	245678	1185	79	137
6861	515038	1945	136	263
1801	183078	585	62	57
1681	185559	470	83	59
1897	154581	612	55	44
2974	298001	992	67	96
1946	121844	634	50	75
2363	203796	741	88	71
1850	104738	674	47	101
3189	220490	1081	79	120
1486	170952	419	56	61
1567	154647	469	54	88
1759	142025	432	81	58
1247	79030	361	6	61
2779	167047	877	74	87
727	27997	221	13	25
1117	84588	377	31	61
2809	241227	847	99	101
1760	195820	642	38	72
2279	142530	693	59	56
1937	157178	611	54	87
1800	204256	654	63	33
2146	212298	690	66	166
1453	201403	365	90	95
2741	354924	907	60	118
2112	192399	882	52	44
1684	182286	490	61	44
1617	181590	548	60	46
2233	134868	726	53	106
3122	235002	935	76	125
2511	228872	824	70	54
1	0	0	0	1
2137	230360	997	54	64
1669	100129	539	44	51
2137	145864	515	42	49
2176	252386	806	83	67
2390	242379	753	105	71
1783	156399	665	42	60
1049	103623	387	25	33
2161	195891	804	64	78
1364	139654	419	71	51
1228	167934	330	44	96
745	81293	212	23	32
2410	246211	783	78	104
2289	233155	740	59	89
2639	160344	938	68	59
658	48188	205	12	28
1917	161922	492	99	69
2583	311044	824	80	75
2026	235223	680	56	79
1911	195583	691	67	59
1751	155574	540	44	57
1852	208834	487	53	67
1044	101687	328	26	25
1177	151985	421	67	66
2878	201027	965	36	99
1830	172600	538	56	63
2191	144556	811	51	82
1331	129561	362	46	61
1307	122204	460	57	38
1256	160930	416	27	35
1378	109798	437	45	42
2311	192811	499	72	71
2897	138708	887	93	65
1103	114408	267	59	38
340	31970	101	5	15
2900	245432	1058	56	113
1367	142907	426	40	74
1441	113612	480	72	68
1681	119537	474	53	72
2655	162215	673	81	68
1499	100098	413	27	44
2302	174768	677	94	60
2540	158459	820	71	97
1053	90743	330	25	33
1234	84971	395	34	71
927	80545	217	54	68
2176	287191	818	49	64
984	67006	301	26	29
1551	134091	513	48	40
1204	95803	392	54	47
1858	173833	572	38	58
2716	241469	669	63	237
1207	115367	284	58	114
1392	115603	443	44	63
1525	155537	614	45	53
1829	153133	672	49	41
2383	179228	701	75	82
1233	151517	415	39	57
1366	133686	505	28	59
953	61350	388	24	41
2319	245196	730	52	117
1857	195576	563	96	70
223	19349	67	13	12
2505	245422	869	43	108
2055	157961	849	42	83
747	66802	292	28	30
1062	91762	338	54	24
1422	151077	435	73	57
1319	136847	334	39	64
823	85338	223	36	40
596	27676	194	2	22
1644	162934	407	96	49
1130	122417	268	29	37
0	0	0	0	0
1082	91529	332	46	32
1135	107205	371	25	67
1367	144664	465	51	45
1506	146445	447	60	63
910	84940	301	36	61
78	3616	14	0	5
0	0	0	0	0
1130	183088	388	40	44
1635	153780	589	74	90
2122	176586	591	30	101
970	128944	299	41	39
778	43410	292	7	19
1752	175774	530	70	73
1050	108656	297	32	43
2180	140243	614	81	56
731	60493	174	3	40
285	19764	75	10	12
1834	164062	565	46	56
1167	138469	382	35	34
1646	155367	544	54	54
256	11796	79	1	9
98	10674	33	0	9
1409	144927	480	39	58
41	6836	11	0	3
1824	162563	626	48	63
42	5118	6	5	3
528	40248	183	8	16
0	0	0	0	0
1114	127476	342	38	50
1305	88837	269	21	38
81	7131	27	0	4
261	9056	99	0	14
1062	87305	291	18	26
1279	142829	324	53	53
1148	100681	414	17	20




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159508&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'Herman Ole Andreas Wold' @ wold.wessa.net







Goodness of Fit
Correlation0.8675
R-squared0.7525
RMSE38726.8188

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8675[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7525[/C][/ROW]
[ROW][C]RMSE[/C][C]38726.8188[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159508&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159508&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.8675
R-squared0.7525
RMSE38726.8188







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1161442153535.2758620697906.72413793104
2189695153535.27586206936159.724137931
3721514559.6842105263-7344.68421052631
4129098153535.275862069-24437.275862069
5245678271192.714285714-25514.7142857143
6515038271192.714285714243845.285714286
7183078153535.27586206929542.724137931
8185559153535.27586206932023.724137931
9154581153535.2758620691045.72413793104
10298001271192.71428571426808.2857142857
11121844153535.275862069-31691.275862069
12203796224303.75-20507.75
13104738153535.275862069-48797.275862069
14220490271192.714285714-50702.7142857143
15170952153535.27586206917416.724137931
16154647153535.2758620691111.72413793104
17142025153535.275862069-11510.275862069
1879030115444.1-36414.1
19167047224303.75-57256.75
202799714559.684210526313437.3157894737
218458899810.5833333333-15222.5833333333
22241227224303.7516923.25
23195820153535.27586206942284.724137931
24142530199226.357142857-56696.3571428571
25157178153535.2758620693642.72413793104
26204256153535.27586206950720.724137931
27212298199226.35714285713071.6428571429
28201403153535.27586206947867.724137931
29354924224303.75130620.25
30192399199226.357142857-6827.35714285713
31182286153535.27586206928750.724137931
32181590153535.27586206928054.724137931
33134868199226.357142857-64358.3571428571
34235002271192.714285714-36190.7142857143
35228872224303.754568.25
36014559.6842105263-14559.6842105263
37230360199226.35714285731133.6428571429
38100129153535.275862069-53406.275862069
39145864153535.275862069-7671.27586206896
40252386199226.35714285753159.6428571429
41242379224303.7518075.25
42156399153535.2758620692863.72413793104
4310362399810.58333333333812.41666666667
44195891199226.357142857-3335.35714285713
45139654153535.275862069-13881.275862069
46167934153535.27586206914398.724137931
478129370521.37510771.625
48246211224303.7521907.25
49233155199226.35714285733928.6428571429
50160344224303.75-63959.75
514818814559.684210526333628.3157894737
52161922153535.2758620698386.72413793104
53311044224303.7586740.25
54235223199226.35714285735996.6428571429
55195583199226.357142857-3643.35714285713
56155574153535.2758620692038.72413793104
57208834153535.27586206955298.724137931
5810168799810.58333333331876.41666666667
59151985153535.275862069-1550.27586206896
60201027224303.75-23276.75
61172600153535.27586206919064.724137931
62144556199226.357142857-54670.3571428571
63129561153535.275862069-23974.275862069
64122204153535.275862069-31331.275862069
65160930115444.145485.9
66109798153535.275862069-43737.275862069
67192811153535.27586206939275.724137931
68138708271192.714285714-132484.714285714
6911440899810.583333333314597.4166666667
703197014559.684210526317410.3157894737
71245432271192.714285714-25760.7142857143
72142907153535.275862069-10628.275862069
73113612153535.275862069-39923.275862069
74119537153535.275862069-33998.275862069
75162215224303.75-62088.75
76100098115444.1-15346.1
77174768199226.357142857-24458.3571428571
78158459224303.75-65844.75
799074399810.5833333333-9067.58333333333
8084971115444.1-30473.1
818054570521.37510023.625
82287191199226.35714285787964.6428571429
836700699810.5833333333-32804.5833333333
84134091153535.275862069-19444.275862069
8595803153535.275862069-57732.275862069
86173833153535.27586206920297.724137931
87241469224303.7517165.25
88115367153535.275862069-38168.275862069
89115603153535.275862069-37932.275862069
90155537153535.2758620692001.72413793104
91153133153535.275862069-402.275862068956
92179228224303.75-45075.75
93151517153535.275862069-2018.27586206896
94133686115444.118241.9
956135070521.375-9171.375
96245196224303.7520892.25
97195576153535.27586206942040.724137931
981934914559.68421052634789.31578947369
99245422224303.7521118.25
100157961199226.357142857-41265.3571428571
1016680270521.375-3719.375
1029176299810.5833333333-8048.58333333333
103151077153535.275862069-2458.27586206896
104136847153535.275862069-16688.275862069
1058533870521.37514816.625
1062767614559.684210526313116.3157894737
107162934153535.2758620699398.72413793104
108122417115444.16972.89999999999
109014559.6842105263-14559.6842105263
1109152999810.5833333333-8281.58333333333
111107205115444.1-8239.10000000001
112144664153535.275862069-8871.27586206896
113146445153535.275862069-7090.27586206896
1148494070521.37514418.625
115361614559.6842105263-10943.6842105263
116014559.6842105263-14559.6842105263
117183088153535.27586206929552.724137931
118153780153535.275862069244.724137931044
119176586115444.161141.9
12012894499810.583333333329133.4166666667
1214341070521.375-27111.375
122175774153535.27586206922238.724137931
12310865699810.58333333338845.41666666667
124140243153535.275862069-13292.275862069
1256049370521.375-10028.375
1261976414559.68421052635204.31578947369
127164062153535.27586206910526.724137931
128138469153535.275862069-15066.275862069
129155367153535.2758620691831.72413793104
1301179614559.6842105263-2763.68421052631
1311067414559.6842105263-3885.68421052631
132144927153535.275862069-8608.27586206896
133683614559.6842105263-7723.68421052631
134162563153535.2758620699027.72413793104
135511814559.6842105263-9441.68421052631
1364024814559.684210526325688.3157894737
137014559.6842105263-14559.6842105263
13812747699810.583333333327665.4166666667
13988837115444.1-26607.1
140713114559.6842105263-7428.68421052631
141905614559.6842105263-5503.68421052631
1428730599810.5833333333-12505.5833333333
143142829153535.275862069-10706.275862069
144100681115444.1-14763.1

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 161442 & 153535.275862069 & 7906.72413793104 \tabularnewline
2 & 189695 & 153535.275862069 & 36159.724137931 \tabularnewline
3 & 7215 & 14559.6842105263 & -7344.68421052631 \tabularnewline
4 & 129098 & 153535.275862069 & -24437.275862069 \tabularnewline
5 & 245678 & 271192.714285714 & -25514.7142857143 \tabularnewline
6 & 515038 & 271192.714285714 & 243845.285714286 \tabularnewline
7 & 183078 & 153535.275862069 & 29542.724137931 \tabularnewline
8 & 185559 & 153535.275862069 & 32023.724137931 \tabularnewline
9 & 154581 & 153535.275862069 & 1045.72413793104 \tabularnewline
10 & 298001 & 271192.714285714 & 26808.2857142857 \tabularnewline
11 & 121844 & 153535.275862069 & -31691.275862069 \tabularnewline
12 & 203796 & 224303.75 & -20507.75 \tabularnewline
13 & 104738 & 153535.275862069 & -48797.275862069 \tabularnewline
14 & 220490 & 271192.714285714 & -50702.7142857143 \tabularnewline
15 & 170952 & 153535.275862069 & 17416.724137931 \tabularnewline
16 & 154647 & 153535.275862069 & 1111.72413793104 \tabularnewline
17 & 142025 & 153535.275862069 & -11510.275862069 \tabularnewline
18 & 79030 & 115444.1 & -36414.1 \tabularnewline
19 & 167047 & 224303.75 & -57256.75 \tabularnewline
20 & 27997 & 14559.6842105263 & 13437.3157894737 \tabularnewline
21 & 84588 & 99810.5833333333 & -15222.5833333333 \tabularnewline
22 & 241227 & 224303.75 & 16923.25 \tabularnewline
23 & 195820 & 153535.275862069 & 42284.724137931 \tabularnewline
24 & 142530 & 199226.357142857 & -56696.3571428571 \tabularnewline
25 & 157178 & 153535.275862069 & 3642.72413793104 \tabularnewline
26 & 204256 & 153535.275862069 & 50720.724137931 \tabularnewline
27 & 212298 & 199226.357142857 & 13071.6428571429 \tabularnewline
28 & 201403 & 153535.275862069 & 47867.724137931 \tabularnewline
29 & 354924 & 224303.75 & 130620.25 \tabularnewline
30 & 192399 & 199226.357142857 & -6827.35714285713 \tabularnewline
31 & 182286 & 153535.275862069 & 28750.724137931 \tabularnewline
32 & 181590 & 153535.275862069 & 28054.724137931 \tabularnewline
33 & 134868 & 199226.357142857 & -64358.3571428571 \tabularnewline
34 & 235002 & 271192.714285714 & -36190.7142857143 \tabularnewline
35 & 228872 & 224303.75 & 4568.25 \tabularnewline
36 & 0 & 14559.6842105263 & -14559.6842105263 \tabularnewline
37 & 230360 & 199226.357142857 & 31133.6428571429 \tabularnewline
38 & 100129 & 153535.275862069 & -53406.275862069 \tabularnewline
39 & 145864 & 153535.275862069 & -7671.27586206896 \tabularnewline
40 & 252386 & 199226.357142857 & 53159.6428571429 \tabularnewline
41 & 242379 & 224303.75 & 18075.25 \tabularnewline
42 & 156399 & 153535.275862069 & 2863.72413793104 \tabularnewline
43 & 103623 & 99810.5833333333 & 3812.41666666667 \tabularnewline
44 & 195891 & 199226.357142857 & -3335.35714285713 \tabularnewline
45 & 139654 & 153535.275862069 & -13881.275862069 \tabularnewline
46 & 167934 & 153535.275862069 & 14398.724137931 \tabularnewline
47 & 81293 & 70521.375 & 10771.625 \tabularnewline
48 & 246211 & 224303.75 & 21907.25 \tabularnewline
49 & 233155 & 199226.357142857 & 33928.6428571429 \tabularnewline
50 & 160344 & 224303.75 & -63959.75 \tabularnewline
51 & 48188 & 14559.6842105263 & 33628.3157894737 \tabularnewline
52 & 161922 & 153535.275862069 & 8386.72413793104 \tabularnewline
53 & 311044 & 224303.75 & 86740.25 \tabularnewline
54 & 235223 & 199226.357142857 & 35996.6428571429 \tabularnewline
55 & 195583 & 199226.357142857 & -3643.35714285713 \tabularnewline
56 & 155574 & 153535.275862069 & 2038.72413793104 \tabularnewline
57 & 208834 & 153535.275862069 & 55298.724137931 \tabularnewline
58 & 101687 & 99810.5833333333 & 1876.41666666667 \tabularnewline
59 & 151985 & 153535.275862069 & -1550.27586206896 \tabularnewline
60 & 201027 & 224303.75 & -23276.75 \tabularnewline
61 & 172600 & 153535.275862069 & 19064.724137931 \tabularnewline
62 & 144556 & 199226.357142857 & -54670.3571428571 \tabularnewline
63 & 129561 & 153535.275862069 & -23974.275862069 \tabularnewline
64 & 122204 & 153535.275862069 & -31331.275862069 \tabularnewline
65 & 160930 & 115444.1 & 45485.9 \tabularnewline
66 & 109798 & 153535.275862069 & -43737.275862069 \tabularnewline
67 & 192811 & 153535.275862069 & 39275.724137931 \tabularnewline
68 & 138708 & 271192.714285714 & -132484.714285714 \tabularnewline
69 & 114408 & 99810.5833333333 & 14597.4166666667 \tabularnewline
70 & 31970 & 14559.6842105263 & 17410.3157894737 \tabularnewline
71 & 245432 & 271192.714285714 & -25760.7142857143 \tabularnewline
72 & 142907 & 153535.275862069 & -10628.275862069 \tabularnewline
73 & 113612 & 153535.275862069 & -39923.275862069 \tabularnewline
74 & 119537 & 153535.275862069 & -33998.275862069 \tabularnewline
75 & 162215 & 224303.75 & -62088.75 \tabularnewline
76 & 100098 & 115444.1 & -15346.1 \tabularnewline
77 & 174768 & 199226.357142857 & -24458.3571428571 \tabularnewline
78 & 158459 & 224303.75 & -65844.75 \tabularnewline
79 & 90743 & 99810.5833333333 & -9067.58333333333 \tabularnewline
80 & 84971 & 115444.1 & -30473.1 \tabularnewline
81 & 80545 & 70521.375 & 10023.625 \tabularnewline
82 & 287191 & 199226.357142857 & 87964.6428571429 \tabularnewline
83 & 67006 & 99810.5833333333 & -32804.5833333333 \tabularnewline
84 & 134091 & 153535.275862069 & -19444.275862069 \tabularnewline
85 & 95803 & 153535.275862069 & -57732.275862069 \tabularnewline
86 & 173833 & 153535.275862069 & 20297.724137931 \tabularnewline
87 & 241469 & 224303.75 & 17165.25 \tabularnewline
88 & 115367 & 153535.275862069 & -38168.275862069 \tabularnewline
89 & 115603 & 153535.275862069 & -37932.275862069 \tabularnewline
90 & 155537 & 153535.275862069 & 2001.72413793104 \tabularnewline
91 & 153133 & 153535.275862069 & -402.275862068956 \tabularnewline
92 & 179228 & 224303.75 & -45075.75 \tabularnewline
93 & 151517 & 153535.275862069 & -2018.27586206896 \tabularnewline
94 & 133686 & 115444.1 & 18241.9 \tabularnewline
95 & 61350 & 70521.375 & -9171.375 \tabularnewline
96 & 245196 & 224303.75 & 20892.25 \tabularnewline
97 & 195576 & 153535.275862069 & 42040.724137931 \tabularnewline
98 & 19349 & 14559.6842105263 & 4789.31578947369 \tabularnewline
99 & 245422 & 224303.75 & 21118.25 \tabularnewline
100 & 157961 & 199226.357142857 & -41265.3571428571 \tabularnewline
101 & 66802 & 70521.375 & -3719.375 \tabularnewline
102 & 91762 & 99810.5833333333 & -8048.58333333333 \tabularnewline
103 & 151077 & 153535.275862069 & -2458.27586206896 \tabularnewline
104 & 136847 & 153535.275862069 & -16688.275862069 \tabularnewline
105 & 85338 & 70521.375 & 14816.625 \tabularnewline
106 & 27676 & 14559.6842105263 & 13116.3157894737 \tabularnewline
107 & 162934 & 153535.275862069 & 9398.72413793104 \tabularnewline
108 & 122417 & 115444.1 & 6972.89999999999 \tabularnewline
109 & 0 & 14559.6842105263 & -14559.6842105263 \tabularnewline
110 & 91529 & 99810.5833333333 & -8281.58333333333 \tabularnewline
111 & 107205 & 115444.1 & -8239.10000000001 \tabularnewline
112 & 144664 & 153535.275862069 & -8871.27586206896 \tabularnewline
113 & 146445 & 153535.275862069 & -7090.27586206896 \tabularnewline
114 & 84940 & 70521.375 & 14418.625 \tabularnewline
115 & 3616 & 14559.6842105263 & -10943.6842105263 \tabularnewline
116 & 0 & 14559.6842105263 & -14559.6842105263 \tabularnewline
117 & 183088 & 153535.275862069 & 29552.724137931 \tabularnewline
118 & 153780 & 153535.275862069 & 244.724137931044 \tabularnewline
119 & 176586 & 115444.1 & 61141.9 \tabularnewline
120 & 128944 & 99810.5833333333 & 29133.4166666667 \tabularnewline
121 & 43410 & 70521.375 & -27111.375 \tabularnewline
122 & 175774 & 153535.275862069 & 22238.724137931 \tabularnewline
123 & 108656 & 99810.5833333333 & 8845.41666666667 \tabularnewline
124 & 140243 & 153535.275862069 & -13292.275862069 \tabularnewline
125 & 60493 & 70521.375 & -10028.375 \tabularnewline
126 & 19764 & 14559.6842105263 & 5204.31578947369 \tabularnewline
127 & 164062 & 153535.275862069 & 10526.724137931 \tabularnewline
128 & 138469 & 153535.275862069 & -15066.275862069 \tabularnewline
129 & 155367 & 153535.275862069 & 1831.72413793104 \tabularnewline
130 & 11796 & 14559.6842105263 & -2763.68421052631 \tabularnewline
131 & 10674 & 14559.6842105263 & -3885.68421052631 \tabularnewline
132 & 144927 & 153535.275862069 & -8608.27586206896 \tabularnewline
133 & 6836 & 14559.6842105263 & -7723.68421052631 \tabularnewline
134 & 162563 & 153535.275862069 & 9027.72413793104 \tabularnewline
135 & 5118 & 14559.6842105263 & -9441.68421052631 \tabularnewline
136 & 40248 & 14559.6842105263 & 25688.3157894737 \tabularnewline
137 & 0 & 14559.6842105263 & -14559.6842105263 \tabularnewline
138 & 127476 & 99810.5833333333 & 27665.4166666667 \tabularnewline
139 & 88837 & 115444.1 & -26607.1 \tabularnewline
140 & 7131 & 14559.6842105263 & -7428.68421052631 \tabularnewline
141 & 9056 & 14559.6842105263 & -5503.68421052631 \tabularnewline
142 & 87305 & 99810.5833333333 & -12505.5833333333 \tabularnewline
143 & 142829 & 153535.275862069 & -10706.275862069 \tabularnewline
144 & 100681 & 115444.1 & -14763.1 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=159508&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]161442[/C][C]153535.275862069[/C][C]7906.72413793104[/C][/ROW]
[ROW][C]2[/C][C]189695[/C][C]153535.275862069[/C][C]36159.724137931[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]14559.6842105263[/C][C]-7344.68421052631[/C][/ROW]
[ROW][C]4[/C][C]129098[/C][C]153535.275862069[/C][C]-24437.275862069[/C][/ROW]
[ROW][C]5[/C][C]245678[/C][C]271192.714285714[/C][C]-25514.7142857143[/C][/ROW]
[ROW][C]6[/C][C]515038[/C][C]271192.714285714[/C][C]243845.285714286[/C][/ROW]
[ROW][C]7[/C][C]183078[/C][C]153535.275862069[/C][C]29542.724137931[/C][/ROW]
[ROW][C]8[/C][C]185559[/C][C]153535.275862069[/C][C]32023.724137931[/C][/ROW]
[ROW][C]9[/C][C]154581[/C][C]153535.275862069[/C][C]1045.72413793104[/C][/ROW]
[ROW][C]10[/C][C]298001[/C][C]271192.714285714[/C][C]26808.2857142857[/C][/ROW]
[ROW][C]11[/C][C]121844[/C][C]153535.275862069[/C][C]-31691.275862069[/C][/ROW]
[ROW][C]12[/C][C]203796[/C][C]224303.75[/C][C]-20507.75[/C][/ROW]
[ROW][C]13[/C][C]104738[/C][C]153535.275862069[/C][C]-48797.275862069[/C][/ROW]
[ROW][C]14[/C][C]220490[/C][C]271192.714285714[/C][C]-50702.7142857143[/C][/ROW]
[ROW][C]15[/C][C]170952[/C][C]153535.275862069[/C][C]17416.724137931[/C][/ROW]
[ROW][C]16[/C][C]154647[/C][C]153535.275862069[/C][C]1111.72413793104[/C][/ROW]
[ROW][C]17[/C][C]142025[/C][C]153535.275862069[/C][C]-11510.275862069[/C][/ROW]
[ROW][C]18[/C][C]79030[/C][C]115444.1[/C][C]-36414.1[/C][/ROW]
[ROW][C]19[/C][C]167047[/C][C]224303.75[/C][C]-57256.75[/C][/ROW]
[ROW][C]20[/C][C]27997[/C][C]14559.6842105263[/C][C]13437.3157894737[/C][/ROW]
[ROW][C]21[/C][C]84588[/C][C]99810.5833333333[/C][C]-15222.5833333333[/C][/ROW]
[ROW][C]22[/C][C]241227[/C][C]224303.75[/C][C]16923.25[/C][/ROW]
[ROW][C]23[/C][C]195820[/C][C]153535.275862069[/C][C]42284.724137931[/C][/ROW]
[ROW][C]24[/C][C]142530[/C][C]199226.357142857[/C][C]-56696.3571428571[/C][/ROW]
[ROW][C]25[/C][C]157178[/C][C]153535.275862069[/C][C]3642.72413793104[/C][/ROW]
[ROW][C]26[/C][C]204256[/C][C]153535.275862069[/C][C]50720.724137931[/C][/ROW]
[ROW][C]27[/C][C]212298[/C][C]199226.357142857[/C][C]13071.6428571429[/C][/ROW]
[ROW][C]28[/C][C]201403[/C][C]153535.275862069[/C][C]47867.724137931[/C][/ROW]
[ROW][C]29[/C][C]354924[/C][C]224303.75[/C][C]130620.25[/C][/ROW]
[ROW][C]30[/C][C]192399[/C][C]199226.357142857[/C][C]-6827.35714285713[/C][/ROW]
[ROW][C]31[/C][C]182286[/C][C]153535.275862069[/C][C]28750.724137931[/C][/ROW]
[ROW][C]32[/C][C]181590[/C][C]153535.275862069[/C][C]28054.724137931[/C][/ROW]
[ROW][C]33[/C][C]134868[/C][C]199226.357142857[/C][C]-64358.3571428571[/C][/ROW]
[ROW][C]34[/C][C]235002[/C][C]271192.714285714[/C][C]-36190.7142857143[/C][/ROW]
[ROW][C]35[/C][C]228872[/C][C]224303.75[/C][C]4568.25[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]14559.6842105263[/C][C]-14559.6842105263[/C][/ROW]
[ROW][C]37[/C][C]230360[/C][C]199226.357142857[/C][C]31133.6428571429[/C][/ROW]
[ROW][C]38[/C][C]100129[/C][C]153535.275862069[/C][C]-53406.275862069[/C][/ROW]
[ROW][C]39[/C][C]145864[/C][C]153535.275862069[/C][C]-7671.27586206896[/C][/ROW]
[ROW][C]40[/C][C]252386[/C][C]199226.357142857[/C][C]53159.6428571429[/C][/ROW]
[ROW][C]41[/C][C]242379[/C][C]224303.75[/C][C]18075.25[/C][/ROW]
[ROW][C]42[/C][C]156399[/C][C]153535.275862069[/C][C]2863.72413793104[/C][/ROW]
[ROW][C]43[/C][C]103623[/C][C]99810.5833333333[/C][C]3812.41666666667[/C][/ROW]
[ROW][C]44[/C][C]195891[/C][C]199226.357142857[/C][C]-3335.35714285713[/C][/ROW]
[ROW][C]45[/C][C]139654[/C][C]153535.275862069[/C][C]-13881.275862069[/C][/ROW]
[ROW][C]46[/C][C]167934[/C][C]153535.275862069[/C][C]14398.724137931[/C][/ROW]
[ROW][C]47[/C][C]81293[/C][C]70521.375[/C][C]10771.625[/C][/ROW]
[ROW][C]48[/C][C]246211[/C][C]224303.75[/C][C]21907.25[/C][/ROW]
[ROW][C]49[/C][C]233155[/C][C]199226.357142857[/C][C]33928.6428571429[/C][/ROW]
[ROW][C]50[/C][C]160344[/C][C]224303.75[/C][C]-63959.75[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]14559.6842105263[/C][C]33628.3157894737[/C][/ROW]
[ROW][C]52[/C][C]161922[/C][C]153535.275862069[/C][C]8386.72413793104[/C][/ROW]
[ROW][C]53[/C][C]311044[/C][C]224303.75[/C][C]86740.25[/C][/ROW]
[ROW][C]54[/C][C]235223[/C][C]199226.357142857[/C][C]35996.6428571429[/C][/ROW]
[ROW][C]55[/C][C]195583[/C][C]199226.357142857[/C][C]-3643.35714285713[/C][/ROW]
[ROW][C]56[/C][C]155574[/C][C]153535.275862069[/C][C]2038.72413793104[/C][/ROW]
[ROW][C]57[/C][C]208834[/C][C]153535.275862069[/C][C]55298.724137931[/C][/ROW]
[ROW][C]58[/C][C]101687[/C][C]99810.5833333333[/C][C]1876.41666666667[/C][/ROW]
[ROW][C]59[/C][C]151985[/C][C]153535.275862069[/C][C]-1550.27586206896[/C][/ROW]
[ROW][C]60[/C][C]201027[/C][C]224303.75[/C][C]-23276.75[/C][/ROW]
[ROW][C]61[/C][C]172600[/C][C]153535.275862069[/C][C]19064.724137931[/C][/ROW]
[ROW][C]62[/C][C]144556[/C][C]199226.357142857[/C][C]-54670.3571428571[/C][/ROW]
[ROW][C]63[/C][C]129561[/C][C]153535.275862069[/C][C]-23974.275862069[/C][/ROW]
[ROW][C]64[/C][C]122204[/C][C]153535.275862069[/C][C]-31331.275862069[/C][/ROW]
[ROW][C]65[/C][C]160930[/C][C]115444.1[/C][C]45485.9[/C][/ROW]
[ROW][C]66[/C][C]109798[/C][C]153535.275862069[/C][C]-43737.275862069[/C][/ROW]
[ROW][C]67[/C][C]192811[/C][C]153535.275862069[/C][C]39275.724137931[/C][/ROW]
[ROW][C]68[/C][C]138708[/C][C]271192.714285714[/C][C]-132484.714285714[/C][/ROW]
[ROW][C]69[/C][C]114408[/C][C]99810.5833333333[/C][C]14597.4166666667[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]14559.6842105263[/C][C]17410.3157894737[/C][/ROW]
[ROW][C]71[/C][C]245432[/C][C]271192.714285714[/C][C]-25760.7142857143[/C][/ROW]
[ROW][C]72[/C][C]142907[/C][C]153535.275862069[/C][C]-10628.275862069[/C][/ROW]
[ROW][C]73[/C][C]113612[/C][C]153535.275862069[/C][C]-39923.275862069[/C][/ROW]
[ROW][C]74[/C][C]119537[/C][C]153535.275862069[/C][C]-33998.275862069[/C][/ROW]
[ROW][C]75[/C][C]162215[/C][C]224303.75[/C][C]-62088.75[/C][/ROW]
[ROW][C]76[/C][C]100098[/C][C]115444.1[/C][C]-15346.1[/C][/ROW]
[ROW][C]77[/C][C]174768[/C][C]199226.357142857[/C][C]-24458.3571428571[/C][/ROW]
[ROW][C]78[/C][C]158459[/C][C]224303.75[/C][C]-65844.75[/C][/ROW]
[ROW][C]79[/C][C]90743[/C][C]99810.5833333333[/C][C]-9067.58333333333[/C][/ROW]
[ROW][C]80[/C][C]84971[/C][C]115444.1[/C][C]-30473.1[/C][/ROW]
[ROW][C]81[/C][C]80545[/C][C]70521.375[/C][C]10023.625[/C][/ROW]
[ROW][C]82[/C][C]287191[/C][C]199226.357142857[/C][C]87964.6428571429[/C][/ROW]
[ROW][C]83[/C][C]67006[/C][C]99810.5833333333[/C][C]-32804.5833333333[/C][/ROW]
[ROW][C]84[/C][C]134091[/C][C]153535.275862069[/C][C]-19444.275862069[/C][/ROW]
[ROW][C]85[/C][C]95803[/C][C]153535.275862069[/C][C]-57732.275862069[/C][/ROW]
[ROW][C]86[/C][C]173833[/C][C]153535.275862069[/C][C]20297.724137931[/C][/ROW]
[ROW][C]87[/C][C]241469[/C][C]224303.75[/C][C]17165.25[/C][/ROW]
[ROW][C]88[/C][C]115367[/C][C]153535.275862069[/C][C]-38168.275862069[/C][/ROW]
[ROW][C]89[/C][C]115603[/C][C]153535.275862069[/C][C]-37932.275862069[/C][/ROW]
[ROW][C]90[/C][C]155537[/C][C]153535.275862069[/C][C]2001.72413793104[/C][/ROW]
[ROW][C]91[/C][C]153133[/C][C]153535.275862069[/C][C]-402.275862068956[/C][/ROW]
[ROW][C]92[/C][C]179228[/C][C]224303.75[/C][C]-45075.75[/C][/ROW]
[ROW][C]93[/C][C]151517[/C][C]153535.275862069[/C][C]-2018.27586206896[/C][/ROW]
[ROW][C]94[/C][C]133686[/C][C]115444.1[/C][C]18241.9[/C][/ROW]
[ROW][C]95[/C][C]61350[/C][C]70521.375[/C][C]-9171.375[/C][/ROW]
[ROW][C]96[/C][C]245196[/C][C]224303.75[/C][C]20892.25[/C][/ROW]
[ROW][C]97[/C][C]195576[/C][C]153535.275862069[/C][C]42040.724137931[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]14559.6842105263[/C][C]4789.31578947369[/C][/ROW]
[ROW][C]99[/C][C]245422[/C][C]224303.75[/C][C]21118.25[/C][/ROW]
[ROW][C]100[/C][C]157961[/C][C]199226.357142857[/C][C]-41265.3571428571[/C][/ROW]
[ROW][C]101[/C][C]66802[/C][C]70521.375[/C][C]-3719.375[/C][/ROW]
[ROW][C]102[/C][C]91762[/C][C]99810.5833333333[/C][C]-8048.58333333333[/C][/ROW]
[ROW][C]103[/C][C]151077[/C][C]153535.275862069[/C][C]-2458.27586206896[/C][/ROW]
[ROW][C]104[/C][C]136847[/C][C]153535.275862069[/C][C]-16688.275862069[/C][/ROW]
[ROW][C]105[/C][C]85338[/C][C]70521.375[/C][C]14816.625[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]14559.6842105263[/C][C]13116.3157894737[/C][/ROW]
[ROW][C]107[/C][C]162934[/C][C]153535.275862069[/C][C]9398.72413793104[/C][/ROW]
[ROW][C]108[/C][C]122417[/C][C]115444.1[/C][C]6972.89999999999[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]14559.6842105263[/C][C]-14559.6842105263[/C][/ROW]
[ROW][C]110[/C][C]91529[/C][C]99810.5833333333[/C][C]-8281.58333333333[/C][/ROW]
[ROW][C]111[/C][C]107205[/C][C]115444.1[/C][C]-8239.10000000001[/C][/ROW]
[ROW][C]112[/C][C]144664[/C][C]153535.275862069[/C][C]-8871.27586206896[/C][/ROW]
[ROW][C]113[/C][C]146445[/C][C]153535.275862069[/C][C]-7090.27586206896[/C][/ROW]
[ROW][C]114[/C][C]84940[/C][C]70521.375[/C][C]14418.625[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]14559.6842105263[/C][C]-10943.6842105263[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]14559.6842105263[/C][C]-14559.6842105263[/C][/ROW]
[ROW][C]117[/C][C]183088[/C][C]153535.275862069[/C][C]29552.724137931[/C][/ROW]
[ROW][C]118[/C][C]153780[/C][C]153535.275862069[/C][C]244.724137931044[/C][/ROW]
[ROW][C]119[/C][C]176586[/C][C]115444.1[/C][C]61141.9[/C][/ROW]
[ROW][C]120[/C][C]128944[/C][C]99810.5833333333[/C][C]29133.4166666667[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]70521.375[/C][C]-27111.375[/C][/ROW]
[ROW][C]122[/C][C]175774[/C][C]153535.275862069[/C][C]22238.724137931[/C][/ROW]
[ROW][C]123[/C][C]108656[/C][C]99810.5833333333[/C][C]8845.41666666667[/C][/ROW]
[ROW][C]124[/C][C]140243[/C][C]153535.275862069[/C][C]-13292.275862069[/C][/ROW]
[ROW][C]125[/C][C]60493[/C][C]70521.375[/C][C]-10028.375[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]14559.6842105263[/C][C]5204.31578947369[/C][/ROW]
[ROW][C]127[/C][C]164062[/C][C]153535.275862069[/C][C]10526.724137931[/C][/ROW]
[ROW][C]128[/C][C]138469[/C][C]153535.275862069[/C][C]-15066.275862069[/C][/ROW]
[ROW][C]129[/C][C]155367[/C][C]153535.275862069[/C][C]1831.72413793104[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]14559.6842105263[/C][C]-2763.68421052631[/C][/ROW]
[ROW][C]131[/C][C]10674[/C][C]14559.6842105263[/C][C]-3885.68421052631[/C][/ROW]
[ROW][C]132[/C][C]144927[/C][C]153535.275862069[/C][C]-8608.27586206896[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]14559.6842105263[/C][C]-7723.68421052631[/C][/ROW]
[ROW][C]134[/C][C]162563[/C][C]153535.275862069[/C][C]9027.72413793104[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]14559.6842105263[/C][C]-9441.68421052631[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]14559.6842105263[/C][C]25688.3157894737[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]14559.6842105263[/C][C]-14559.6842105263[/C][/ROW]
[ROW][C]138[/C][C]127476[/C][C]99810.5833333333[/C][C]27665.4166666667[/C][/ROW]
[ROW][C]139[/C][C]88837[/C][C]115444.1[/C][C]-26607.1[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]14559.6842105263[/C][C]-7428.68421052631[/C][/ROW]
[ROW][C]141[/C][C]9056[/C][C]14559.6842105263[/C][C]-5503.68421052631[/C][/ROW]
[ROW][C]142[/C][C]87305[/C][C]99810.5833333333[/C][C]-12505.5833333333[/C][/ROW]
[ROW][C]143[/C][C]142829[/C][C]153535.275862069[/C][C]-10706.275862069[/C][/ROW]
[ROW][C]144[/C][C]100681[/C][C]115444.1[/C][C]-14763.1[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159508&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159508&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
1161442153535.2758620697906.72413793104
2189695153535.27586206936159.724137931
3721514559.6842105263-7344.68421052631
4129098153535.275862069-24437.275862069
5245678271192.714285714-25514.7142857143
6515038271192.714285714243845.285714286
7183078153535.27586206929542.724137931
8185559153535.27586206932023.724137931
9154581153535.2758620691045.72413793104
10298001271192.71428571426808.2857142857
11121844153535.275862069-31691.275862069
12203796224303.75-20507.75
13104738153535.275862069-48797.275862069
14220490271192.714285714-50702.7142857143
15170952153535.27586206917416.724137931
16154647153535.2758620691111.72413793104
17142025153535.275862069-11510.275862069
1879030115444.1-36414.1
19167047224303.75-57256.75
202799714559.684210526313437.3157894737
218458899810.5833333333-15222.5833333333
22241227224303.7516923.25
23195820153535.27586206942284.724137931
24142530199226.357142857-56696.3571428571
25157178153535.2758620693642.72413793104
26204256153535.27586206950720.724137931
27212298199226.35714285713071.6428571429
28201403153535.27586206947867.724137931
29354924224303.75130620.25
30192399199226.357142857-6827.35714285713
31182286153535.27586206928750.724137931
32181590153535.27586206928054.724137931
33134868199226.357142857-64358.3571428571
34235002271192.714285714-36190.7142857143
35228872224303.754568.25
36014559.6842105263-14559.6842105263
37230360199226.35714285731133.6428571429
38100129153535.275862069-53406.275862069
39145864153535.275862069-7671.27586206896
40252386199226.35714285753159.6428571429
41242379224303.7518075.25
42156399153535.2758620692863.72413793104
4310362399810.58333333333812.41666666667
44195891199226.357142857-3335.35714285713
45139654153535.275862069-13881.275862069
46167934153535.27586206914398.724137931
478129370521.37510771.625
48246211224303.7521907.25
49233155199226.35714285733928.6428571429
50160344224303.75-63959.75
514818814559.684210526333628.3157894737
52161922153535.2758620698386.72413793104
53311044224303.7586740.25
54235223199226.35714285735996.6428571429
55195583199226.357142857-3643.35714285713
56155574153535.2758620692038.72413793104
57208834153535.27586206955298.724137931
5810168799810.58333333331876.41666666667
59151985153535.275862069-1550.27586206896
60201027224303.75-23276.75
61172600153535.27586206919064.724137931
62144556199226.357142857-54670.3571428571
63129561153535.275862069-23974.275862069
64122204153535.275862069-31331.275862069
65160930115444.145485.9
66109798153535.275862069-43737.275862069
67192811153535.27586206939275.724137931
68138708271192.714285714-132484.714285714
6911440899810.583333333314597.4166666667
703197014559.684210526317410.3157894737
71245432271192.714285714-25760.7142857143
72142907153535.275862069-10628.275862069
73113612153535.275862069-39923.275862069
74119537153535.275862069-33998.275862069
75162215224303.75-62088.75
76100098115444.1-15346.1
77174768199226.357142857-24458.3571428571
78158459224303.75-65844.75
799074399810.5833333333-9067.58333333333
8084971115444.1-30473.1
818054570521.37510023.625
82287191199226.35714285787964.6428571429
836700699810.5833333333-32804.5833333333
84134091153535.275862069-19444.275862069
8595803153535.275862069-57732.275862069
86173833153535.27586206920297.724137931
87241469224303.7517165.25
88115367153535.275862069-38168.275862069
89115603153535.275862069-37932.275862069
90155537153535.2758620692001.72413793104
91153133153535.275862069-402.275862068956
92179228224303.75-45075.75
93151517153535.275862069-2018.27586206896
94133686115444.118241.9
956135070521.375-9171.375
96245196224303.7520892.25
97195576153535.27586206942040.724137931
981934914559.68421052634789.31578947369
99245422224303.7521118.25
100157961199226.357142857-41265.3571428571
1016680270521.375-3719.375
1029176299810.5833333333-8048.58333333333
103151077153535.275862069-2458.27586206896
104136847153535.275862069-16688.275862069
1058533870521.37514816.625
1062767614559.684210526313116.3157894737
107162934153535.2758620699398.72413793104
108122417115444.16972.89999999999
109014559.6842105263-14559.6842105263
1109152999810.5833333333-8281.58333333333
111107205115444.1-8239.10000000001
112144664153535.275862069-8871.27586206896
113146445153535.275862069-7090.27586206896
1148494070521.37514418.625
115361614559.6842105263-10943.6842105263
116014559.6842105263-14559.6842105263
117183088153535.27586206929552.724137931
118153780153535.275862069244.724137931044
119176586115444.161141.9
12012894499810.583333333329133.4166666667
1214341070521.375-27111.375
122175774153535.27586206922238.724137931
12310865699810.58333333338845.41666666667
124140243153535.275862069-13292.275862069
1256049370521.375-10028.375
1261976414559.68421052635204.31578947369
127164062153535.27586206910526.724137931
128138469153535.275862069-15066.275862069
129155367153535.2758620691831.72413793104
1301179614559.6842105263-2763.68421052631
1311067414559.6842105263-3885.68421052631
132144927153535.275862069-8608.27586206896
133683614559.6842105263-7723.68421052631
134162563153535.2758620699027.72413793104
135511814559.6842105263-9441.68421052631
1364024814559.684210526325688.3157894737
137014559.6842105263-14559.6842105263
13812747699810.583333333327665.4166666667
13988837115444.1-26607.1
140713114559.6842105263-7428.68421052631
141905614559.6842105263-5503.68421052631
1428730599810.5833333333-12505.5833333333
143142829153535.275862069-10706.275862069
144100681115444.1-14763.1



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