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 computationWed, 21 Dec 2011 10:39:02 -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/21/t1324481998b3odimqi9efv3ln.htm/, Retrieved Tue, 07 May 2024 08:02:09 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158838, Retrieved Tue, 07 May 2024 08:02:09 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact65
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Multiple Regression] [Multiple regression] [2011-12-21 15:21:41] [1ed874da5cc4aa1cd1ced057f766d90b]
- RMP     [Recursive Partitioning (Regression Trees)] [Regression Tree] [2011-12-21 15:39:02] [452d9c400285ceb08a690c4b81b76477] [Current]
-   P       [Recursive Partitioning (Regression Trees)] [regression tree] [2011-12-23 11:46:03] [1ed874da5cc4aa1cd1ced057f766d90b]
- RMPD      [Multiple Regression] [MR belangrijkste ...] [2011-12-23 12:21:00] [1ed874da5cc4aa1cd1ced057f766d90b]
Feedback Forum

Post a new message
Dataseries X:
1801	159261	91	586	111	0	74
1717	189672	59	520	76	1	80
192	7215	18	72	1	0	0
2295	129098	95	645	155	0	84
3450	230632	136	1163	125	0	124
6861	515038	263	1945	278	1	140
1795	180745	56	585	89	1	88
1681	185559	59	470	59	0	115
1897	154581	44	612	87	0	109
2974	298001	96	992	129	1	104
1946	121844	75	634	158	2	63
2148	184039	69	677	120	0	118
1832	100324	98	665	87	0	71
3183	220269	119	1079	264	4	112
1476	168265	58	413	51	4	63
1567	154647	88	469	85	3	86
1756	142018	57	431	96	0	132
1247	79030	61	361	72	5	54
2779	167047	87	877	147	0	134
726	27997	24	221	49	0	57
1048	73019	59	366	40	0	59
2805	241082	100	846	99	0	113
1760	195820	72	642	127	0	96
2266	142001	54	689	164	1	96
1848	145433	86	576	41	1	78
1665	183744	32	610	160	0	80
2084	202357	163	673	92	0	93
1440	199532	93	361	59	0	109
2741	354924	118	907	89	0	115
2112	192399	44	882	90	0	79
1684	182286	44	490	76	0	103
1616	181590	45	548	116	2	71
2227	133801	105	723	92	4	66
3088	233686	123	918	344	0	100
2389	219428	53	787	84	1	96
1	0	1	0	0	0	0
2099	223044	63	983	61	0	109
1669	100129	51	539	138	3	51
2137	145864	49	515	270	9	119
2153	249965	64	795	64	0	136
2390	242379	71	753	96	2	84
1701	145794	59	635	62	0	136
983	96404	32	361	35	2	84
2161	195891	78	804	59	1	92
1276	117156	50	394	56	2	103
1190	157787	95	320	40	2	82
745	81293	32	212	49	1	106
2330	237435	101	772	121	0	96
2289	233155	89	740	113	1	124
2639	160344	59	938	172	8	97
658	48188	28	205	37	0	82
1917	161922	69	492	51	0	79
2557	307432	74	818	89	0	97
2026	235223	79	680	73	0	107
1911	195583	59	691	49	1	126
1716	146061	56	534	74	8	40
1852	208834	67	487	58	0	96
981	93764	24	301	72	1	100
1177	151985	66	421	32	0	91
2833	193222	96	947	59	10	136
1688	148922	60	492	70	6	124
2097	132856	80	790	85	0	79
1331	129561	61	362	87	11	74
1244	112718	37	430	48	3	96
1256	160930	35	416	56	0	97
1294	99184	41	409	41	0	122
2303	192535	70	498	86	8	144
2897	138708	65	887	152	2	90
1103	114408	38	267	48	0	93
340	31970	15	101	40	0	78
2791	225558	112	1000	135	3	72
1338	139220	72	416	83	1	45
1441	113612	68	480	62	2	120
1623	108641	71	454	91	1	59
2650	162203	67	671	91	0	133
1499	100098	44	413	82	2	117
2302	174768	60	677	112	1	123
2540	158459	97	820	69	0	110
1000	80934	30	316	78	0	75
1234	84971	71	395	105	0	114
927	80545	68	217	49	0	94
2176	287191	64	818	60	0	116
957	62974	28	292	49	1	86
1551	134091	40	513	132	0	90
1014	75555	46	345	49	0	87
1771	162154	54	557	71	0	99
2613	226638	227	645	100	0	132
1205	115367	112	284	74	0	96
1337	108749	62	424	49	7	91
1524	155537	52	614	72	0	77
1829	153133	41	672	59	5	104
2229	165618	78	649	90	1	97
1233	151517	57	415	68	0	94
1365	133686	58	505	81	0	60
950	61342	40	387	33	0	46
2319	245196	117	730	166	0	135
1857	195576	70	563	94	0	90
223	19349	12	67	15	0	2
2390	225371	105	812	104	3	96
1985	153213	78	811	61	0	109
700	59117	29	281	11	0	15
1062	91762	24	338	45	0	68
1311	136769	54	413	84	0	88
1157	114798	61	298	66	1	84
823	85338	40	223	27	1	46
596	27676	22	194	59	0	59
1545	153535	48	371	127	0	116
1130	122417	37	268	48	0	29
0	0	0	0	0	0	0
1082	91529	32	332	58	0	91
1135	107205	67	371	57	0	76
1367	144664	45	465	59	0	83
1506	146445	63	447	76	1	84
870	76656	60	295	71	0	65
78	3616	5	14	5	0	0
0	0	0	0	0	0	0
1130	183088	44	388	70	0	84
1582	144677	84	564	76	0	114
2034	159104	98	562	122	2	124
919	113273	38	288	56	0	92
778	43410	19	292	63	0	3
1752	175774	73	530	92	1	109
957	95401	42	256	54	0	74
2098	134837	55	602	64	8	121
731	60493	40	174	29	3	48
285	19764	12	75	19	1	8
1834	164062	56	565	64	3	80
1148	132696	33	377	79	0	107
1646	155367	54	544	97	0	116
256	11796	9	79	22	0	8
98	10674	9	33	7	0	0
1404	142261	57	479	37	0	56
41	6836	3	11	5	0	4
1824	162563	63	626	48	6	70
42	5118	3	6	1	0	0
528	40248	16	183	34	1	14
0	0	0	0	0	0	0
1073	122641	47	334	49	0	91
1305	88837	38	269	44	0	89
81	7131	4	27	0	1	0
261	9056	14	99	18	0	12
934	76611	24	260	48	1	60
1180	132697	51	290	54	0	80
1147	100681	19	414	50	1	88




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time7 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 & 7 seconds \tabularnewline
R Server & 'Gwilym Jenkins' @ jenkins.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158838&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]7 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=158838&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158838&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 time7 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net







Goodness of Fit
Correlation0.8964
R-squared0.8036
RMSE389.5212

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8964[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8036[/C][/ROW]
[ROW][C]RMSE[/C][C]389.5212[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158838&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158838&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.8964
R-squared0.8036
RMSE389.5212







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
118011691.68965517241109.310344827586
217171691.6896551724125.3103448275863
3192232.157894736842-40.1578947368421
422952225.9269.0799999999999
534503052.8397.2
668613052.83808.2
717951691.68965517241103.310344827586
816811691.68965517241-10.6896551724137
918971691.68965517241205.310344827586
1029743052.8-78.8000000000002
1119461691.68965517241254.310344827586
1221482225.92-77.9200000000001
1318322225.92-393.92
1431833052.8130.2
1514761241.30769230769234.692307692308
1615671870.66666666667-303.666666666667
1717561691.6896551724164.3103448275863
181247967.761904761905279.238095238095
1927793052.8-273.8
20726967.761904761905-241.761904761905
211048967.76190476190580.2380952380952
2228053052.8-247.8
2317601691.6896551724168.3103448275863
2422662225.9240.0799999999999
2518481691.68965517241156.310344827586
2616651691.68965517241-26.6896551724137
2720842225.92-141.92
2814401241.30769230769198.692307692308
2927413052.8-311.8
3021123052.8-940.8
3116841691.68965517241-7.68965517241372
3216161691.68965517241-75.6896551724137
3322272225.921.07999999999993
3430883052.835.1999999999998
3523892225.92163.08
361232.157894736842-231.157894736842
3720993052.8-953.8
3816691870.66666666667-201.666666666667
3921371870.66666666667266.333333333333
4021532225.92-72.9200000000001
4123902225.92164.08
4217011691.689655172419.31034482758628
43983967.76190476190515.2380952380952
4421612225.92-64.9200000000001
4512761241.3076923076934.6923076923076
4611901241.30769230769-51.3076923076924
47745967.761904761905-222.761904761905
4823302225.92104.08
4922892225.9263.0799999999999
5026393052.8-413.8
51658232.157894736842425.842105263158
5219171691.68965517241225.310344827586
5325572225.92331.08
5420262225.92-199.92
5519112225.92-314.92
5617161870.66666666667-154.666666666667
5718521691.68965517241160.310344827586
58981967.76190476190513.2380952380952
5911771241.30769230769-64.3076923076924
6028333052.8-219.8
6116881870.66666666667-182.666666666667
6220972225.92-128.92
6313311241.3076923076989.6923076923076
6412441241.307692307692.69230769230762
6512561241.3076923076914.6923076923076
6612941241.3076923076952.6923076923076
6723031870.66666666667432.333333333333
6828973052.8-155.8
6911031241.30769230769-138.307692307692
70340232.157894736842107.842105263158
7127913052.8-261.8
7213381241.3076923076996.6923076923076
7314411691.68965517241-250.689655172414
7416231691.68965517241-68.6896551724137
7526502225.92424.08
7614991241.30769230769257.692307692308
7723022225.9276.0799999999999
7825403052.8-512.8
791000967.76190476190532.2380952380952
801234967.761904761905266.238095238095
81927967.761904761905-40.7619047619048
8221762225.92-49.9200000000001
83957967.761904761905-10.7619047619048
8415511691.68965517241-140.689655172414
851014967.76190476190546.2380952380952
8617711691.6896551724179.3103448275863
8726132225.92387.08
8812051241.30769230769-36.3076923076924
8913371241.3076923076995.6923076923076
9015241691.68965517241-167.689655172414
9118292225.92-396.92
9222292225.923.07999999999993
9312331241.30769230769-8.30769230769238
9413651691.68965517241-326.689655172414
95950967.761904761905-17.7619047619048
9623192225.9293.0799999999999
9718571691.68965517241165.310344827586
98223232.157894736842-9.15789473684211
9923902225.92164.08
10019852225.92-240.92
101700967.761904761905-267.761904761905
1021062967.76190476190594.2380952380952
10313111241.3076923076969.6923076923076
10411571241.30769230769-84.3076923076924
105823967.761904761905-144.761904761905
106596232.157894736842363.842105263158
10715451241.30769230769303.692307692308
10811301241.30769230769-111.307692307692
1090232.157894736842-232.157894736842
1101082967.761904761905114.238095238095
11111351241.30769230769-106.307692307692
11213671691.68965517241-324.689655172414
11315061691.68965517241-185.689655172414
114870967.761904761905-97.7619047619048
11578232.157894736842-154.157894736842
1160232.157894736842-232.157894736842
11711301241.30769230769-111.307692307692
11815821691.68965517241-109.689655172414
11920341691.68965517241342.310344827586
1209191241.30769230769-322.307692307692
121778967.761904761905-189.761904761905
12217521691.6896551724160.3103448275863
123957967.761904761905-10.7619047619048
12420981870.66666666667227.333333333333
125731232.157894736842498.842105263158
126285232.15789473684252.8421052631579
12718341870.66666666667-36.6666666666667
12811481241.30769230769-93.3076923076924
12916461691.68965517241-45.6896551724137
130256232.15789473684223.8421052631579
13198232.157894736842-134.157894736842
13214041691.68965517241-287.689655172414
13341232.157894736842-191.157894736842
13418241870.66666666667-46.6666666666667
13542232.157894736842-190.157894736842
136528232.157894736842295.842105263158
1370232.157894736842-232.157894736842
13810731241.30769230769-168.307692307692
1391305967.761904761905337.238095238095
14081232.157894736842-151.157894736842
141261232.15789473684228.8421052631579
142934967.761904761905-33.7619047619048
14311801241.30769230769-61.3076923076924
14411471241.30769230769-94.3076923076924

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 1801 & 1691.68965517241 & 109.310344827586 \tabularnewline
2 & 1717 & 1691.68965517241 & 25.3103448275863 \tabularnewline
3 & 192 & 232.157894736842 & -40.1578947368421 \tabularnewline
4 & 2295 & 2225.92 & 69.0799999999999 \tabularnewline
5 & 3450 & 3052.8 & 397.2 \tabularnewline
6 & 6861 & 3052.8 & 3808.2 \tabularnewline
7 & 1795 & 1691.68965517241 & 103.310344827586 \tabularnewline
8 & 1681 & 1691.68965517241 & -10.6896551724137 \tabularnewline
9 & 1897 & 1691.68965517241 & 205.310344827586 \tabularnewline
10 & 2974 & 3052.8 & -78.8000000000002 \tabularnewline
11 & 1946 & 1691.68965517241 & 254.310344827586 \tabularnewline
12 & 2148 & 2225.92 & -77.9200000000001 \tabularnewline
13 & 1832 & 2225.92 & -393.92 \tabularnewline
14 & 3183 & 3052.8 & 130.2 \tabularnewline
15 & 1476 & 1241.30769230769 & 234.692307692308 \tabularnewline
16 & 1567 & 1870.66666666667 & -303.666666666667 \tabularnewline
17 & 1756 & 1691.68965517241 & 64.3103448275863 \tabularnewline
18 & 1247 & 967.761904761905 & 279.238095238095 \tabularnewline
19 & 2779 & 3052.8 & -273.8 \tabularnewline
20 & 726 & 967.761904761905 & -241.761904761905 \tabularnewline
21 & 1048 & 967.761904761905 & 80.2380952380952 \tabularnewline
22 & 2805 & 3052.8 & -247.8 \tabularnewline
23 & 1760 & 1691.68965517241 & 68.3103448275863 \tabularnewline
24 & 2266 & 2225.92 & 40.0799999999999 \tabularnewline
25 & 1848 & 1691.68965517241 & 156.310344827586 \tabularnewline
26 & 1665 & 1691.68965517241 & -26.6896551724137 \tabularnewline
27 & 2084 & 2225.92 & -141.92 \tabularnewline
28 & 1440 & 1241.30769230769 & 198.692307692308 \tabularnewline
29 & 2741 & 3052.8 & -311.8 \tabularnewline
30 & 2112 & 3052.8 & -940.8 \tabularnewline
31 & 1684 & 1691.68965517241 & -7.68965517241372 \tabularnewline
32 & 1616 & 1691.68965517241 & -75.6896551724137 \tabularnewline
33 & 2227 & 2225.92 & 1.07999999999993 \tabularnewline
34 & 3088 & 3052.8 & 35.1999999999998 \tabularnewline
35 & 2389 & 2225.92 & 163.08 \tabularnewline
36 & 1 & 232.157894736842 & -231.157894736842 \tabularnewline
37 & 2099 & 3052.8 & -953.8 \tabularnewline
38 & 1669 & 1870.66666666667 & -201.666666666667 \tabularnewline
39 & 2137 & 1870.66666666667 & 266.333333333333 \tabularnewline
40 & 2153 & 2225.92 & -72.9200000000001 \tabularnewline
41 & 2390 & 2225.92 & 164.08 \tabularnewline
42 & 1701 & 1691.68965517241 & 9.31034482758628 \tabularnewline
43 & 983 & 967.761904761905 & 15.2380952380952 \tabularnewline
44 & 2161 & 2225.92 & -64.9200000000001 \tabularnewline
45 & 1276 & 1241.30769230769 & 34.6923076923076 \tabularnewline
46 & 1190 & 1241.30769230769 & -51.3076923076924 \tabularnewline
47 & 745 & 967.761904761905 & -222.761904761905 \tabularnewline
48 & 2330 & 2225.92 & 104.08 \tabularnewline
49 & 2289 & 2225.92 & 63.0799999999999 \tabularnewline
50 & 2639 & 3052.8 & -413.8 \tabularnewline
51 & 658 & 232.157894736842 & 425.842105263158 \tabularnewline
52 & 1917 & 1691.68965517241 & 225.310344827586 \tabularnewline
53 & 2557 & 2225.92 & 331.08 \tabularnewline
54 & 2026 & 2225.92 & -199.92 \tabularnewline
55 & 1911 & 2225.92 & -314.92 \tabularnewline
56 & 1716 & 1870.66666666667 & -154.666666666667 \tabularnewline
57 & 1852 & 1691.68965517241 & 160.310344827586 \tabularnewline
58 & 981 & 967.761904761905 & 13.2380952380952 \tabularnewline
59 & 1177 & 1241.30769230769 & -64.3076923076924 \tabularnewline
60 & 2833 & 3052.8 & -219.8 \tabularnewline
61 & 1688 & 1870.66666666667 & -182.666666666667 \tabularnewline
62 & 2097 & 2225.92 & -128.92 \tabularnewline
63 & 1331 & 1241.30769230769 & 89.6923076923076 \tabularnewline
64 & 1244 & 1241.30769230769 & 2.69230769230762 \tabularnewline
65 & 1256 & 1241.30769230769 & 14.6923076923076 \tabularnewline
66 & 1294 & 1241.30769230769 & 52.6923076923076 \tabularnewline
67 & 2303 & 1870.66666666667 & 432.333333333333 \tabularnewline
68 & 2897 & 3052.8 & -155.8 \tabularnewline
69 & 1103 & 1241.30769230769 & -138.307692307692 \tabularnewline
70 & 340 & 232.157894736842 & 107.842105263158 \tabularnewline
71 & 2791 & 3052.8 & -261.8 \tabularnewline
72 & 1338 & 1241.30769230769 & 96.6923076923076 \tabularnewline
73 & 1441 & 1691.68965517241 & -250.689655172414 \tabularnewline
74 & 1623 & 1691.68965517241 & -68.6896551724137 \tabularnewline
75 & 2650 & 2225.92 & 424.08 \tabularnewline
76 & 1499 & 1241.30769230769 & 257.692307692308 \tabularnewline
77 & 2302 & 2225.92 & 76.0799999999999 \tabularnewline
78 & 2540 & 3052.8 & -512.8 \tabularnewline
79 & 1000 & 967.761904761905 & 32.2380952380952 \tabularnewline
80 & 1234 & 967.761904761905 & 266.238095238095 \tabularnewline
81 & 927 & 967.761904761905 & -40.7619047619048 \tabularnewline
82 & 2176 & 2225.92 & -49.9200000000001 \tabularnewline
83 & 957 & 967.761904761905 & -10.7619047619048 \tabularnewline
84 & 1551 & 1691.68965517241 & -140.689655172414 \tabularnewline
85 & 1014 & 967.761904761905 & 46.2380952380952 \tabularnewline
86 & 1771 & 1691.68965517241 & 79.3103448275863 \tabularnewline
87 & 2613 & 2225.92 & 387.08 \tabularnewline
88 & 1205 & 1241.30769230769 & -36.3076923076924 \tabularnewline
89 & 1337 & 1241.30769230769 & 95.6923076923076 \tabularnewline
90 & 1524 & 1691.68965517241 & -167.689655172414 \tabularnewline
91 & 1829 & 2225.92 & -396.92 \tabularnewline
92 & 2229 & 2225.92 & 3.07999999999993 \tabularnewline
93 & 1233 & 1241.30769230769 & -8.30769230769238 \tabularnewline
94 & 1365 & 1691.68965517241 & -326.689655172414 \tabularnewline
95 & 950 & 967.761904761905 & -17.7619047619048 \tabularnewline
96 & 2319 & 2225.92 & 93.0799999999999 \tabularnewline
97 & 1857 & 1691.68965517241 & 165.310344827586 \tabularnewline
98 & 223 & 232.157894736842 & -9.15789473684211 \tabularnewline
99 & 2390 & 2225.92 & 164.08 \tabularnewline
100 & 1985 & 2225.92 & -240.92 \tabularnewline
101 & 700 & 967.761904761905 & -267.761904761905 \tabularnewline
102 & 1062 & 967.761904761905 & 94.2380952380952 \tabularnewline
103 & 1311 & 1241.30769230769 & 69.6923076923076 \tabularnewline
104 & 1157 & 1241.30769230769 & -84.3076923076924 \tabularnewline
105 & 823 & 967.761904761905 & -144.761904761905 \tabularnewline
106 & 596 & 232.157894736842 & 363.842105263158 \tabularnewline
107 & 1545 & 1241.30769230769 & 303.692307692308 \tabularnewline
108 & 1130 & 1241.30769230769 & -111.307692307692 \tabularnewline
109 & 0 & 232.157894736842 & -232.157894736842 \tabularnewline
110 & 1082 & 967.761904761905 & 114.238095238095 \tabularnewline
111 & 1135 & 1241.30769230769 & -106.307692307692 \tabularnewline
112 & 1367 & 1691.68965517241 & -324.689655172414 \tabularnewline
113 & 1506 & 1691.68965517241 & -185.689655172414 \tabularnewline
114 & 870 & 967.761904761905 & -97.7619047619048 \tabularnewline
115 & 78 & 232.157894736842 & -154.157894736842 \tabularnewline
116 & 0 & 232.157894736842 & -232.157894736842 \tabularnewline
117 & 1130 & 1241.30769230769 & -111.307692307692 \tabularnewline
118 & 1582 & 1691.68965517241 & -109.689655172414 \tabularnewline
119 & 2034 & 1691.68965517241 & 342.310344827586 \tabularnewline
120 & 919 & 1241.30769230769 & -322.307692307692 \tabularnewline
121 & 778 & 967.761904761905 & -189.761904761905 \tabularnewline
122 & 1752 & 1691.68965517241 & 60.3103448275863 \tabularnewline
123 & 957 & 967.761904761905 & -10.7619047619048 \tabularnewline
124 & 2098 & 1870.66666666667 & 227.333333333333 \tabularnewline
125 & 731 & 232.157894736842 & 498.842105263158 \tabularnewline
126 & 285 & 232.157894736842 & 52.8421052631579 \tabularnewline
127 & 1834 & 1870.66666666667 & -36.6666666666667 \tabularnewline
128 & 1148 & 1241.30769230769 & -93.3076923076924 \tabularnewline
129 & 1646 & 1691.68965517241 & -45.6896551724137 \tabularnewline
130 & 256 & 232.157894736842 & 23.8421052631579 \tabularnewline
131 & 98 & 232.157894736842 & -134.157894736842 \tabularnewline
132 & 1404 & 1691.68965517241 & -287.689655172414 \tabularnewline
133 & 41 & 232.157894736842 & -191.157894736842 \tabularnewline
134 & 1824 & 1870.66666666667 & -46.6666666666667 \tabularnewline
135 & 42 & 232.157894736842 & -190.157894736842 \tabularnewline
136 & 528 & 232.157894736842 & 295.842105263158 \tabularnewline
137 & 0 & 232.157894736842 & -232.157894736842 \tabularnewline
138 & 1073 & 1241.30769230769 & -168.307692307692 \tabularnewline
139 & 1305 & 967.761904761905 & 337.238095238095 \tabularnewline
140 & 81 & 232.157894736842 & -151.157894736842 \tabularnewline
141 & 261 & 232.157894736842 & 28.8421052631579 \tabularnewline
142 & 934 & 967.761904761905 & -33.7619047619048 \tabularnewline
143 & 1180 & 1241.30769230769 & -61.3076923076924 \tabularnewline
144 & 1147 & 1241.30769230769 & -94.3076923076924 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158838&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]1801[/C][C]1691.68965517241[/C][C]109.310344827586[/C][/ROW]
[ROW][C]2[/C][C]1717[/C][C]1691.68965517241[/C][C]25.3103448275863[/C][/ROW]
[ROW][C]3[/C][C]192[/C][C]232.157894736842[/C][C]-40.1578947368421[/C][/ROW]
[ROW][C]4[/C][C]2295[/C][C]2225.92[/C][C]69.0799999999999[/C][/ROW]
[ROW][C]5[/C][C]3450[/C][C]3052.8[/C][C]397.2[/C][/ROW]
[ROW][C]6[/C][C]6861[/C][C]3052.8[/C][C]3808.2[/C][/ROW]
[ROW][C]7[/C][C]1795[/C][C]1691.68965517241[/C][C]103.310344827586[/C][/ROW]
[ROW][C]8[/C][C]1681[/C][C]1691.68965517241[/C][C]-10.6896551724137[/C][/ROW]
[ROW][C]9[/C][C]1897[/C][C]1691.68965517241[/C][C]205.310344827586[/C][/ROW]
[ROW][C]10[/C][C]2974[/C][C]3052.8[/C][C]-78.8000000000002[/C][/ROW]
[ROW][C]11[/C][C]1946[/C][C]1691.68965517241[/C][C]254.310344827586[/C][/ROW]
[ROW][C]12[/C][C]2148[/C][C]2225.92[/C][C]-77.9200000000001[/C][/ROW]
[ROW][C]13[/C][C]1832[/C][C]2225.92[/C][C]-393.92[/C][/ROW]
[ROW][C]14[/C][C]3183[/C][C]3052.8[/C][C]130.2[/C][/ROW]
[ROW][C]15[/C][C]1476[/C][C]1241.30769230769[/C][C]234.692307692308[/C][/ROW]
[ROW][C]16[/C][C]1567[/C][C]1870.66666666667[/C][C]-303.666666666667[/C][/ROW]
[ROW][C]17[/C][C]1756[/C][C]1691.68965517241[/C][C]64.3103448275863[/C][/ROW]
[ROW][C]18[/C][C]1247[/C][C]967.761904761905[/C][C]279.238095238095[/C][/ROW]
[ROW][C]19[/C][C]2779[/C][C]3052.8[/C][C]-273.8[/C][/ROW]
[ROW][C]20[/C][C]726[/C][C]967.761904761905[/C][C]-241.761904761905[/C][/ROW]
[ROW][C]21[/C][C]1048[/C][C]967.761904761905[/C][C]80.2380952380952[/C][/ROW]
[ROW][C]22[/C][C]2805[/C][C]3052.8[/C][C]-247.8[/C][/ROW]
[ROW][C]23[/C][C]1760[/C][C]1691.68965517241[/C][C]68.3103448275863[/C][/ROW]
[ROW][C]24[/C][C]2266[/C][C]2225.92[/C][C]40.0799999999999[/C][/ROW]
[ROW][C]25[/C][C]1848[/C][C]1691.68965517241[/C][C]156.310344827586[/C][/ROW]
[ROW][C]26[/C][C]1665[/C][C]1691.68965517241[/C][C]-26.6896551724137[/C][/ROW]
[ROW][C]27[/C][C]2084[/C][C]2225.92[/C][C]-141.92[/C][/ROW]
[ROW][C]28[/C][C]1440[/C][C]1241.30769230769[/C][C]198.692307692308[/C][/ROW]
[ROW][C]29[/C][C]2741[/C][C]3052.8[/C][C]-311.8[/C][/ROW]
[ROW][C]30[/C][C]2112[/C][C]3052.8[/C][C]-940.8[/C][/ROW]
[ROW][C]31[/C][C]1684[/C][C]1691.68965517241[/C][C]-7.68965517241372[/C][/ROW]
[ROW][C]32[/C][C]1616[/C][C]1691.68965517241[/C][C]-75.6896551724137[/C][/ROW]
[ROW][C]33[/C][C]2227[/C][C]2225.92[/C][C]1.07999999999993[/C][/ROW]
[ROW][C]34[/C][C]3088[/C][C]3052.8[/C][C]35.1999999999998[/C][/ROW]
[ROW][C]35[/C][C]2389[/C][C]2225.92[/C][C]163.08[/C][/ROW]
[ROW][C]36[/C][C]1[/C][C]232.157894736842[/C][C]-231.157894736842[/C][/ROW]
[ROW][C]37[/C][C]2099[/C][C]3052.8[/C][C]-953.8[/C][/ROW]
[ROW][C]38[/C][C]1669[/C][C]1870.66666666667[/C][C]-201.666666666667[/C][/ROW]
[ROW][C]39[/C][C]2137[/C][C]1870.66666666667[/C][C]266.333333333333[/C][/ROW]
[ROW][C]40[/C][C]2153[/C][C]2225.92[/C][C]-72.9200000000001[/C][/ROW]
[ROW][C]41[/C][C]2390[/C][C]2225.92[/C][C]164.08[/C][/ROW]
[ROW][C]42[/C][C]1701[/C][C]1691.68965517241[/C][C]9.31034482758628[/C][/ROW]
[ROW][C]43[/C][C]983[/C][C]967.761904761905[/C][C]15.2380952380952[/C][/ROW]
[ROW][C]44[/C][C]2161[/C][C]2225.92[/C][C]-64.9200000000001[/C][/ROW]
[ROW][C]45[/C][C]1276[/C][C]1241.30769230769[/C][C]34.6923076923076[/C][/ROW]
[ROW][C]46[/C][C]1190[/C][C]1241.30769230769[/C][C]-51.3076923076924[/C][/ROW]
[ROW][C]47[/C][C]745[/C][C]967.761904761905[/C][C]-222.761904761905[/C][/ROW]
[ROW][C]48[/C][C]2330[/C][C]2225.92[/C][C]104.08[/C][/ROW]
[ROW][C]49[/C][C]2289[/C][C]2225.92[/C][C]63.0799999999999[/C][/ROW]
[ROW][C]50[/C][C]2639[/C][C]3052.8[/C][C]-413.8[/C][/ROW]
[ROW][C]51[/C][C]658[/C][C]232.157894736842[/C][C]425.842105263158[/C][/ROW]
[ROW][C]52[/C][C]1917[/C][C]1691.68965517241[/C][C]225.310344827586[/C][/ROW]
[ROW][C]53[/C][C]2557[/C][C]2225.92[/C][C]331.08[/C][/ROW]
[ROW][C]54[/C][C]2026[/C][C]2225.92[/C][C]-199.92[/C][/ROW]
[ROW][C]55[/C][C]1911[/C][C]2225.92[/C][C]-314.92[/C][/ROW]
[ROW][C]56[/C][C]1716[/C][C]1870.66666666667[/C][C]-154.666666666667[/C][/ROW]
[ROW][C]57[/C][C]1852[/C][C]1691.68965517241[/C][C]160.310344827586[/C][/ROW]
[ROW][C]58[/C][C]981[/C][C]967.761904761905[/C][C]13.2380952380952[/C][/ROW]
[ROW][C]59[/C][C]1177[/C][C]1241.30769230769[/C][C]-64.3076923076924[/C][/ROW]
[ROW][C]60[/C][C]2833[/C][C]3052.8[/C][C]-219.8[/C][/ROW]
[ROW][C]61[/C][C]1688[/C][C]1870.66666666667[/C][C]-182.666666666667[/C][/ROW]
[ROW][C]62[/C][C]2097[/C][C]2225.92[/C][C]-128.92[/C][/ROW]
[ROW][C]63[/C][C]1331[/C][C]1241.30769230769[/C][C]89.6923076923076[/C][/ROW]
[ROW][C]64[/C][C]1244[/C][C]1241.30769230769[/C][C]2.69230769230762[/C][/ROW]
[ROW][C]65[/C][C]1256[/C][C]1241.30769230769[/C][C]14.6923076923076[/C][/ROW]
[ROW][C]66[/C][C]1294[/C][C]1241.30769230769[/C][C]52.6923076923076[/C][/ROW]
[ROW][C]67[/C][C]2303[/C][C]1870.66666666667[/C][C]432.333333333333[/C][/ROW]
[ROW][C]68[/C][C]2897[/C][C]3052.8[/C][C]-155.8[/C][/ROW]
[ROW][C]69[/C][C]1103[/C][C]1241.30769230769[/C][C]-138.307692307692[/C][/ROW]
[ROW][C]70[/C][C]340[/C][C]232.157894736842[/C][C]107.842105263158[/C][/ROW]
[ROW][C]71[/C][C]2791[/C][C]3052.8[/C][C]-261.8[/C][/ROW]
[ROW][C]72[/C][C]1338[/C][C]1241.30769230769[/C][C]96.6923076923076[/C][/ROW]
[ROW][C]73[/C][C]1441[/C][C]1691.68965517241[/C][C]-250.689655172414[/C][/ROW]
[ROW][C]74[/C][C]1623[/C][C]1691.68965517241[/C][C]-68.6896551724137[/C][/ROW]
[ROW][C]75[/C][C]2650[/C][C]2225.92[/C][C]424.08[/C][/ROW]
[ROW][C]76[/C][C]1499[/C][C]1241.30769230769[/C][C]257.692307692308[/C][/ROW]
[ROW][C]77[/C][C]2302[/C][C]2225.92[/C][C]76.0799999999999[/C][/ROW]
[ROW][C]78[/C][C]2540[/C][C]3052.8[/C][C]-512.8[/C][/ROW]
[ROW][C]79[/C][C]1000[/C][C]967.761904761905[/C][C]32.2380952380952[/C][/ROW]
[ROW][C]80[/C][C]1234[/C][C]967.761904761905[/C][C]266.238095238095[/C][/ROW]
[ROW][C]81[/C][C]927[/C][C]967.761904761905[/C][C]-40.7619047619048[/C][/ROW]
[ROW][C]82[/C][C]2176[/C][C]2225.92[/C][C]-49.9200000000001[/C][/ROW]
[ROW][C]83[/C][C]957[/C][C]967.761904761905[/C][C]-10.7619047619048[/C][/ROW]
[ROW][C]84[/C][C]1551[/C][C]1691.68965517241[/C][C]-140.689655172414[/C][/ROW]
[ROW][C]85[/C][C]1014[/C][C]967.761904761905[/C][C]46.2380952380952[/C][/ROW]
[ROW][C]86[/C][C]1771[/C][C]1691.68965517241[/C][C]79.3103448275863[/C][/ROW]
[ROW][C]87[/C][C]2613[/C][C]2225.92[/C][C]387.08[/C][/ROW]
[ROW][C]88[/C][C]1205[/C][C]1241.30769230769[/C][C]-36.3076923076924[/C][/ROW]
[ROW][C]89[/C][C]1337[/C][C]1241.30769230769[/C][C]95.6923076923076[/C][/ROW]
[ROW][C]90[/C][C]1524[/C][C]1691.68965517241[/C][C]-167.689655172414[/C][/ROW]
[ROW][C]91[/C][C]1829[/C][C]2225.92[/C][C]-396.92[/C][/ROW]
[ROW][C]92[/C][C]2229[/C][C]2225.92[/C][C]3.07999999999993[/C][/ROW]
[ROW][C]93[/C][C]1233[/C][C]1241.30769230769[/C][C]-8.30769230769238[/C][/ROW]
[ROW][C]94[/C][C]1365[/C][C]1691.68965517241[/C][C]-326.689655172414[/C][/ROW]
[ROW][C]95[/C][C]950[/C][C]967.761904761905[/C][C]-17.7619047619048[/C][/ROW]
[ROW][C]96[/C][C]2319[/C][C]2225.92[/C][C]93.0799999999999[/C][/ROW]
[ROW][C]97[/C][C]1857[/C][C]1691.68965517241[/C][C]165.310344827586[/C][/ROW]
[ROW][C]98[/C][C]223[/C][C]232.157894736842[/C][C]-9.15789473684211[/C][/ROW]
[ROW][C]99[/C][C]2390[/C][C]2225.92[/C][C]164.08[/C][/ROW]
[ROW][C]100[/C][C]1985[/C][C]2225.92[/C][C]-240.92[/C][/ROW]
[ROW][C]101[/C][C]700[/C][C]967.761904761905[/C][C]-267.761904761905[/C][/ROW]
[ROW][C]102[/C][C]1062[/C][C]967.761904761905[/C][C]94.2380952380952[/C][/ROW]
[ROW][C]103[/C][C]1311[/C][C]1241.30769230769[/C][C]69.6923076923076[/C][/ROW]
[ROW][C]104[/C][C]1157[/C][C]1241.30769230769[/C][C]-84.3076923076924[/C][/ROW]
[ROW][C]105[/C][C]823[/C][C]967.761904761905[/C][C]-144.761904761905[/C][/ROW]
[ROW][C]106[/C][C]596[/C][C]232.157894736842[/C][C]363.842105263158[/C][/ROW]
[ROW][C]107[/C][C]1545[/C][C]1241.30769230769[/C][C]303.692307692308[/C][/ROW]
[ROW][C]108[/C][C]1130[/C][C]1241.30769230769[/C][C]-111.307692307692[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]232.157894736842[/C][C]-232.157894736842[/C][/ROW]
[ROW][C]110[/C][C]1082[/C][C]967.761904761905[/C][C]114.238095238095[/C][/ROW]
[ROW][C]111[/C][C]1135[/C][C]1241.30769230769[/C][C]-106.307692307692[/C][/ROW]
[ROW][C]112[/C][C]1367[/C][C]1691.68965517241[/C][C]-324.689655172414[/C][/ROW]
[ROW][C]113[/C][C]1506[/C][C]1691.68965517241[/C][C]-185.689655172414[/C][/ROW]
[ROW][C]114[/C][C]870[/C][C]967.761904761905[/C][C]-97.7619047619048[/C][/ROW]
[ROW][C]115[/C][C]78[/C][C]232.157894736842[/C][C]-154.157894736842[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]232.157894736842[/C][C]-232.157894736842[/C][/ROW]
[ROW][C]117[/C][C]1130[/C][C]1241.30769230769[/C][C]-111.307692307692[/C][/ROW]
[ROW][C]118[/C][C]1582[/C][C]1691.68965517241[/C][C]-109.689655172414[/C][/ROW]
[ROW][C]119[/C][C]2034[/C][C]1691.68965517241[/C][C]342.310344827586[/C][/ROW]
[ROW][C]120[/C][C]919[/C][C]1241.30769230769[/C][C]-322.307692307692[/C][/ROW]
[ROW][C]121[/C][C]778[/C][C]967.761904761905[/C][C]-189.761904761905[/C][/ROW]
[ROW][C]122[/C][C]1752[/C][C]1691.68965517241[/C][C]60.3103448275863[/C][/ROW]
[ROW][C]123[/C][C]957[/C][C]967.761904761905[/C][C]-10.7619047619048[/C][/ROW]
[ROW][C]124[/C][C]2098[/C][C]1870.66666666667[/C][C]227.333333333333[/C][/ROW]
[ROW][C]125[/C][C]731[/C][C]232.157894736842[/C][C]498.842105263158[/C][/ROW]
[ROW][C]126[/C][C]285[/C][C]232.157894736842[/C][C]52.8421052631579[/C][/ROW]
[ROW][C]127[/C][C]1834[/C][C]1870.66666666667[/C][C]-36.6666666666667[/C][/ROW]
[ROW][C]128[/C][C]1148[/C][C]1241.30769230769[/C][C]-93.3076923076924[/C][/ROW]
[ROW][C]129[/C][C]1646[/C][C]1691.68965517241[/C][C]-45.6896551724137[/C][/ROW]
[ROW][C]130[/C][C]256[/C][C]232.157894736842[/C][C]23.8421052631579[/C][/ROW]
[ROW][C]131[/C][C]98[/C][C]232.157894736842[/C][C]-134.157894736842[/C][/ROW]
[ROW][C]132[/C][C]1404[/C][C]1691.68965517241[/C][C]-287.689655172414[/C][/ROW]
[ROW][C]133[/C][C]41[/C][C]232.157894736842[/C][C]-191.157894736842[/C][/ROW]
[ROW][C]134[/C][C]1824[/C][C]1870.66666666667[/C][C]-46.6666666666667[/C][/ROW]
[ROW][C]135[/C][C]42[/C][C]232.157894736842[/C][C]-190.157894736842[/C][/ROW]
[ROW][C]136[/C][C]528[/C][C]232.157894736842[/C][C]295.842105263158[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]232.157894736842[/C][C]-232.157894736842[/C][/ROW]
[ROW][C]138[/C][C]1073[/C][C]1241.30769230769[/C][C]-168.307692307692[/C][/ROW]
[ROW][C]139[/C][C]1305[/C][C]967.761904761905[/C][C]337.238095238095[/C][/ROW]
[ROW][C]140[/C][C]81[/C][C]232.157894736842[/C][C]-151.157894736842[/C][/ROW]
[ROW][C]141[/C][C]261[/C][C]232.157894736842[/C][C]28.8421052631579[/C][/ROW]
[ROW][C]142[/C][C]934[/C][C]967.761904761905[/C][C]-33.7619047619048[/C][/ROW]
[ROW][C]143[/C][C]1180[/C][C]1241.30769230769[/C][C]-61.3076923076924[/C][/ROW]
[ROW][C]144[/C][C]1147[/C][C]1241.30769230769[/C][C]-94.3076923076924[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158838&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158838&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
118011691.68965517241109.310344827586
217171691.6896551724125.3103448275863
3192232.157894736842-40.1578947368421
422952225.9269.0799999999999
534503052.8397.2
668613052.83808.2
717951691.68965517241103.310344827586
816811691.68965517241-10.6896551724137
918971691.68965517241205.310344827586
1029743052.8-78.8000000000002
1119461691.68965517241254.310344827586
1221482225.92-77.9200000000001
1318322225.92-393.92
1431833052.8130.2
1514761241.30769230769234.692307692308
1615671870.66666666667-303.666666666667
1717561691.6896551724164.3103448275863
181247967.761904761905279.238095238095
1927793052.8-273.8
20726967.761904761905-241.761904761905
211048967.76190476190580.2380952380952
2228053052.8-247.8
2317601691.6896551724168.3103448275863
2422662225.9240.0799999999999
2518481691.68965517241156.310344827586
2616651691.68965517241-26.6896551724137
2720842225.92-141.92
2814401241.30769230769198.692307692308
2927413052.8-311.8
3021123052.8-940.8
3116841691.68965517241-7.68965517241372
3216161691.68965517241-75.6896551724137
3322272225.921.07999999999993
3430883052.835.1999999999998
3523892225.92163.08
361232.157894736842-231.157894736842
3720993052.8-953.8
3816691870.66666666667-201.666666666667
3921371870.66666666667266.333333333333
4021532225.92-72.9200000000001
4123902225.92164.08
4217011691.689655172419.31034482758628
43983967.76190476190515.2380952380952
4421612225.92-64.9200000000001
4512761241.3076923076934.6923076923076
4611901241.30769230769-51.3076923076924
47745967.761904761905-222.761904761905
4823302225.92104.08
4922892225.9263.0799999999999
5026393052.8-413.8
51658232.157894736842425.842105263158
5219171691.68965517241225.310344827586
5325572225.92331.08
5420262225.92-199.92
5519112225.92-314.92
5617161870.66666666667-154.666666666667
5718521691.68965517241160.310344827586
58981967.76190476190513.2380952380952
5911771241.30769230769-64.3076923076924
6028333052.8-219.8
6116881870.66666666667-182.666666666667
6220972225.92-128.92
6313311241.3076923076989.6923076923076
6412441241.307692307692.69230769230762
6512561241.3076923076914.6923076923076
6612941241.3076923076952.6923076923076
6723031870.66666666667432.333333333333
6828973052.8-155.8
6911031241.30769230769-138.307692307692
70340232.157894736842107.842105263158
7127913052.8-261.8
7213381241.3076923076996.6923076923076
7314411691.68965517241-250.689655172414
7416231691.68965517241-68.6896551724137
7526502225.92424.08
7614991241.30769230769257.692307692308
7723022225.9276.0799999999999
7825403052.8-512.8
791000967.76190476190532.2380952380952
801234967.761904761905266.238095238095
81927967.761904761905-40.7619047619048
8221762225.92-49.9200000000001
83957967.761904761905-10.7619047619048
8415511691.68965517241-140.689655172414
851014967.76190476190546.2380952380952
8617711691.6896551724179.3103448275863
8726132225.92387.08
8812051241.30769230769-36.3076923076924
8913371241.3076923076995.6923076923076
9015241691.68965517241-167.689655172414
9118292225.92-396.92
9222292225.923.07999999999993
9312331241.30769230769-8.30769230769238
9413651691.68965517241-326.689655172414
95950967.761904761905-17.7619047619048
9623192225.9293.0799999999999
9718571691.68965517241165.310344827586
98223232.157894736842-9.15789473684211
9923902225.92164.08
10019852225.92-240.92
101700967.761904761905-267.761904761905
1021062967.76190476190594.2380952380952
10313111241.3076923076969.6923076923076
10411571241.30769230769-84.3076923076924
105823967.761904761905-144.761904761905
106596232.157894736842363.842105263158
10715451241.30769230769303.692307692308
10811301241.30769230769-111.307692307692
1090232.157894736842-232.157894736842
1101082967.761904761905114.238095238095
11111351241.30769230769-106.307692307692
11213671691.68965517241-324.689655172414
11315061691.68965517241-185.689655172414
114870967.761904761905-97.7619047619048
11578232.157894736842-154.157894736842
1160232.157894736842-232.157894736842
11711301241.30769230769-111.307692307692
11815821691.68965517241-109.689655172414
11920341691.68965517241342.310344827586
1209191241.30769230769-322.307692307692
121778967.761904761905-189.761904761905
12217521691.6896551724160.3103448275863
123957967.761904761905-10.7619047619048
12420981870.66666666667227.333333333333
125731232.157894736842498.842105263158
126285232.15789473684252.8421052631579
12718341870.66666666667-36.6666666666667
12811481241.30769230769-93.3076923076924
12916461691.68965517241-45.6896551724137
130256232.15789473684223.8421052631579
13198232.157894736842-134.157894736842
13214041691.68965517241-287.689655172414
13341232.157894736842-191.157894736842
13418241870.66666666667-46.6666666666667
13542232.157894736842-190.157894736842
136528232.157894736842295.842105263158
1370232.157894736842-232.157894736842
13810731241.30769230769-168.307692307692
1391305967.761904761905337.238095238095
14081232.157894736842-151.157894736842
141261232.15789473684228.8421052631579
142934967.761904761905-33.7619047619048
14311801241.30769230769-61.3076923076924
14411471241.30769230769-94.3076923076924



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