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 09:20:08 -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/t1324479217ncgjm41mbbna360.htm/, Retrieved Tue, 07 May 2024 17:17:58 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158783, Retrieved Tue, 07 May 2024 17:17:58 +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)] [paper recursive ] [2011-12-21 14:20:08] [1c5701688738a71acfb394dd0fcb74f6] [Current]
Feedback Forum

Post a new message
Dataseries X:
1773	158258	90	48	6200	39
1704	186930	58	53	10265	46
192	7215	18	0	603	0
2295	129098	95	51	8874	54
3450	230632	136	76	20323	93
6813	508313	261	128	26258	198
1795	180745	56	62	10165	42
1681	185559	59	83	8247	59
1897	154581	44	55	8683	49
2917	290658	95	67	16957	83
1946	121844	75	50	8058	49
2148	184039	69	77	20488	83
1832	100324	98	46	7945	39
3138	215855	117	79	13448	93
1476	168265	58	56	5389	31
1567	154647	88	54	6185	29
1756	142018	57	81	24369	104
1247	79030	61	6	70	2
2779	167047	87	74	17327	46
726	27997	24	13	3878	27
1048	73019	59	22	3149	16
2805	241082	100	99	20517	108
1760	195820	72	38	2570	36
2261	141899	53	59	5162	33
1848	145433	86	50	5299	46
1665	183744	32	50	7233	65
2082	202232	161	61	15657	80
1440	199532	93	87	15329	81
2741	354924	118	60	14881	69
2112	192399	44	52	16318	69
1684	182286	44	61	9556	37
1616	181590	45	60	10462	45
2227	133801	105	53	7192	62
3088	233686	123	76	4362	33
2389	219428	53	63	14349	77
1	0	1	0	0	0
2099	223044	63	54	10881	34
1669	100129	51	44	8022	44
2095	136733	48	36	13073	43
2153	249965	64	83	26641	117
2390	242379	71	105	14426	125
1701	145794	59	37	15604	49
983	96404	32	25	9184	76
2161	195891	78	64	5989	81
1276	117156	50	55	11270	111
1189	157787	94	41	13958	61
745	81293	32	23	7162	56
2231	224049	100	67	13275	54
2242	223789	87	54	21224	47
2639	160344	59	68	10615	55
658	48188	28	12	2102	14
1917	161922	69	99	12396	44
2489	294283	73	74	18717	115
2026	235223	79	56	9724	57
1911	195583	59	67	9863	48
1716	146061	56	40	8374	40
1852	208834	67	53	8030	51
981	93764	24	26	7509	32
1177	151985	66	67	14146	36
2809	190545	95	36	7768	47
1688	148922	60	50	13823	51
2097	132856	80	48	7230	37
1309	126107	60	46	10170	52
1244	112718	37	53	7573	42
1256	160930	35	27	5753	11
1293	99184	40	38	9791	47
2303	192535	70	71	19365	59
2897	138708	65	93	9422	82
1103	114408	38	59	12310	49
340	31970	15	5	1283	6
2791	225558	112	53	6372	83
1333	137011	71	40	5413	56
1441	113612	68	72	10837	114
1623	108641	71	51	3394	46
2650	162203	67	81	12964	46
1499	100098	44	27	3495	2
2302	174768	60	94	11580	51
2540	158459	97	71	9970	96
1000	80934	30	20	4911	20
1234	84971	71	34	10138	57
927	80545	68	54	14697	49
2176	287191	64	49	8464	51
957	62974	28	26	4204	40
1551	134091	40	48	10226	40
1014	75555	46	35	3456	36
1771	162154	54	32	8895	64
2613	226638	227	55	22557	117
1203	115019	110	58	6900	40
1337	108749	62	44	8620	46
1524	155537	52	45	7820	61
1829	153133	41	49	12112	59
2229	165618	78	72	13178	94
1233	151517	57	39	7028	36
1365	133686	58	28	6616	51
950	61342	40	24	9570	39
2319	245196	117	52	14612	62
1857	195576	70	96	11219	79
223	19349	12	13	786	14
2390	225371	105	38	11252	45
1973	152796	76	41	9289	43
700	59117	29	24	593	8
1062	91762	24	54	6562	41
1311	136769	54	68	8208	25
1157	114798	61	28	7488	22
823	85338	40	36	4574	18
596	27676	22	2	522	3
1545	153535	48	91	12840	54
1130	122417	37	29	1350	6
0	0	0	0	0	0
1082	91529	32	46	10623	50
1135	107205	67	25	5322	33
1366	144664	44	51	7987	54
1452	136540	62	59	10566	63
870	76656	60	36	1900	56
78	3616	5	0	0	0
0	0	0	0	0	0
1127	183065	43	40	10698	49
1582	144677	84	68	14884	90
2034	159104	98	28	6852	51
919	113273	38	36	6873	29
778	43410	19	7	4	1
1752	175774	73	70	9188	68
957	95401	42	30	5141	29
1875	118893	54	59	4260	27
731	60493	40	3	443	4
285	19764	12	10	2416	10
1834	164062	56	46	9831	47
1147	132696	32	34	5953	44
1646	155367	54	54	9435	53
256	11796	9	1	0	0
98	10674	9	0	0	0
1404	142261	57	39	7642	40
41	6836	3	0	0	0
1824	162563	63	48	6837	57
42	5118	3	5	0	0
528	40248	16	8	775	6
0	0	0	0	0	0
1073	122641	47	38	8191	24
1305	88837	38	21	1661	34
81	7131	4	0	0	0
261	9056	14	0	548	10
934	76611	24	15	3080	16
1179	132697	50	50	13400	93
1147	100681	19	17	8181	28




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158783&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 time5 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net







Goodness of Fit
Correlation0.8446
R-squared0.7133
RMSE467.4989

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8446[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7133[/C][/ROW]
[ROW][C]RMSE[/C][C]467.4989[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158783&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158783&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.8446
R-squared0.7133
RMSE467.4989







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
117731966.42105263158-193.421052631579
217041578.8064516129125.193548387097
3192208.222222222222-16.2222222222222
422951966.42105263158328.578947368421
534502588.61538461538861.384615384615
668133086.857142857143726.14285714286
717951578.8064516129216.193548387097
816811966.42105263158-285.421052631579
918971578.8064516129318.193548387097
1029173086.85714285714-169.857142857143
1119461966.42105263158-20.421052631579
1221481966.42105263158181.578947368421
1318321325.2506.8
1431382588.61538461538549.384615384615
1514761578.8064516129-102.806451612903
1615671966.42105263158-399.421052631579
1717561578.8064516129177.193548387097
1812471010.93333333333236.066666666667
1927791966.42105263158812.578947368421
20726208.222222222222517.777777777778
211048831.714285714286216.285714285714
2228052588.61538461538216.384615384615
2317601966.42105263158-206.421052631579
2422611578.8064516129682.193548387097
2518481966.42105263158-118.421052631579
2616651578.806451612986.1935483870968
2720821966.42105263158115.578947368421
2814401966.42105263158-526.421052631579
2927413086.85714285714-345.857142857143
3021121578.8064516129533.193548387097
3116841578.8064516129105.193548387097
3216161578.806451612937.1935483870968
3322271966.42105263158260.578947368421
3430882588.61538461538499.384615384615
3523892588.61538461538-199.615384615385
361208.222222222222-207.222222222222
3720992588.61538461538-489.615384615385
3816691325.2343.8
3920951578.8064516129516.193548387097
4021533086.85714285714-933.857142857143
4123902588.61538461538-198.615384615385
4217011966.42105263158-265.421052631579
439831010.93333333333-27.9333333333333
4421611966.42105263158194.578947368421
4512761325.2-49.2
4611891966.42105263158-777.421052631579
477451010.93333333333-265.933333333333
4822312588.61538461538-357.615384615385
4922422588.61538461538-346.615384615385
5026391966.42105263158672.578947368421
51658831.714285714286-173.714285714286
5219171966.42105263158-49.421052631579
5324893086.85714285714-597.857142857143
5420262588.61538461538-562.615384615385
5519111966.42105263158-55.421052631579
5617161578.8064516129137.193548387097
5718521966.42105263158-114.421052631579
589811010.93333333333-29.9333333333333
5911771966.42105263158-789.421052631579
6028091966.42105263158842.578947368421
6116881966.42105263158-278.421052631579
6220971966.42105263158130.578947368421
6313091966.42105263158-657.421052631579
6412441325.2-81.2
6512561578.8064516129-322.806451612903
6612931325.2-32.2
6723031966.42105263158336.578947368421
6828971966.42105263158930.578947368421
6911031325.2-222.2
70340208.222222222222131.777777777778
7127912588.61538461538202.384615384615
7213331966.42105263158-633.421052631579
7314411325.2115.8
7416231325.2297.8
7526501966.42105263158683.578947368421
7614991325.2173.8
7723021966.42105263158335.578947368421
7825401966.42105263158573.578947368421
7910001010.93333333333-10.9333333333333
8012341010.93333333333223.066666666667
819271010.93333333333-83.9333333333333
8221763086.85714285714-910.857142857143
83957831.714285714286125.285714285714
8415511578.8064516129-27.8064516129032
8510141010.933333333333.06666666666672
8617711578.8064516129192.193548387097
8726132588.6153846153824.3846153846152
8812031325.2-122.2
8913371325.211.8
9015241578.8064516129-54.8064516129032
9118291578.8064516129250.193548387097
9222291966.42105263158262.578947368421
9312331578.8064516129-345.806451612903
9413651578.8064516129-213.806451612903
95950831.714285714286118.285714285714
9623193086.85714285714-767.857142857143
9718571966.42105263158-109.421052631579
98223208.22222222222214.7777777777778
9923902588.61538461538-198.615384615385
10019731966.421052631586.57894736842104
101700831.714285714286-131.714285714286
10210621010.9333333333351.0666666666667
10313111578.8064516129-267.806451612903
10411571325.2-168.2
1058231010.93333333333-187.933333333333
106596208.222222222222387.777777777778
10715451578.8064516129-33.8064516129032
10811301578.8064516129-448.806451612903
1090208.222222222222-208.222222222222
11010821010.9333333333371.0666666666667
11111351325.2-190.2
11213661578.8064516129-212.806451612903
11314521966.42105263158-514.421052631579
1148701010.93333333333-140.933333333333
11578208.222222222222-130.222222222222
1160208.222222222222-208.222222222222
11711271578.8064516129-451.806451612903
11815821966.42105263158-384.421052631579
11920341966.4210526315867.578947368421
1209191325.2-406.2
121778831.714285714286-53.7142857142857
12217521966.42105263158-214.421052631579
1239571010.93333333333-53.9333333333333
12418751578.8064516129296.193548387097
125731831.714285714286-100.714285714286
126285208.22222222222276.7777777777778
12718341578.8064516129255.193548387097
12811471578.8064516129-431.806451612903
12916461578.806451612967.1935483870968
130256208.22222222222247.7777777777778
13198208.222222222222-110.222222222222
13214041578.8064516129-174.806451612903
13341208.222222222222-167.222222222222
13418241966.42105263158-142.421052631579
13542208.222222222222-166.222222222222
136528208.222222222222319.777777777778
1370208.222222222222-208.222222222222
13810731578.8064516129-505.806451612903
13913051010.93333333333294.066666666667
14081208.222222222222-127.222222222222
141261208.22222222222252.7777777777778
1429341010.93333333333-76.9333333333333
14311791578.8064516129-399.806451612903
14411471325.2-178.2

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 1773 & 1966.42105263158 & -193.421052631579 \tabularnewline
2 & 1704 & 1578.8064516129 & 125.193548387097 \tabularnewline
3 & 192 & 208.222222222222 & -16.2222222222222 \tabularnewline
4 & 2295 & 1966.42105263158 & 328.578947368421 \tabularnewline
5 & 3450 & 2588.61538461538 & 861.384615384615 \tabularnewline
6 & 6813 & 3086.85714285714 & 3726.14285714286 \tabularnewline
7 & 1795 & 1578.8064516129 & 216.193548387097 \tabularnewline
8 & 1681 & 1966.42105263158 & -285.421052631579 \tabularnewline
9 & 1897 & 1578.8064516129 & 318.193548387097 \tabularnewline
10 & 2917 & 3086.85714285714 & -169.857142857143 \tabularnewline
11 & 1946 & 1966.42105263158 & -20.421052631579 \tabularnewline
12 & 2148 & 1966.42105263158 & 181.578947368421 \tabularnewline
13 & 1832 & 1325.2 & 506.8 \tabularnewline
14 & 3138 & 2588.61538461538 & 549.384615384615 \tabularnewline
15 & 1476 & 1578.8064516129 & -102.806451612903 \tabularnewline
16 & 1567 & 1966.42105263158 & -399.421052631579 \tabularnewline
17 & 1756 & 1578.8064516129 & 177.193548387097 \tabularnewline
18 & 1247 & 1010.93333333333 & 236.066666666667 \tabularnewline
19 & 2779 & 1966.42105263158 & 812.578947368421 \tabularnewline
20 & 726 & 208.222222222222 & 517.777777777778 \tabularnewline
21 & 1048 & 831.714285714286 & 216.285714285714 \tabularnewline
22 & 2805 & 2588.61538461538 & 216.384615384615 \tabularnewline
23 & 1760 & 1966.42105263158 & -206.421052631579 \tabularnewline
24 & 2261 & 1578.8064516129 & 682.193548387097 \tabularnewline
25 & 1848 & 1966.42105263158 & -118.421052631579 \tabularnewline
26 & 1665 & 1578.8064516129 & 86.1935483870968 \tabularnewline
27 & 2082 & 1966.42105263158 & 115.578947368421 \tabularnewline
28 & 1440 & 1966.42105263158 & -526.421052631579 \tabularnewline
29 & 2741 & 3086.85714285714 & -345.857142857143 \tabularnewline
30 & 2112 & 1578.8064516129 & 533.193548387097 \tabularnewline
31 & 1684 & 1578.8064516129 & 105.193548387097 \tabularnewline
32 & 1616 & 1578.8064516129 & 37.1935483870968 \tabularnewline
33 & 2227 & 1966.42105263158 & 260.578947368421 \tabularnewline
34 & 3088 & 2588.61538461538 & 499.384615384615 \tabularnewline
35 & 2389 & 2588.61538461538 & -199.615384615385 \tabularnewline
36 & 1 & 208.222222222222 & -207.222222222222 \tabularnewline
37 & 2099 & 2588.61538461538 & -489.615384615385 \tabularnewline
38 & 1669 & 1325.2 & 343.8 \tabularnewline
39 & 2095 & 1578.8064516129 & 516.193548387097 \tabularnewline
40 & 2153 & 3086.85714285714 & -933.857142857143 \tabularnewline
41 & 2390 & 2588.61538461538 & -198.615384615385 \tabularnewline
42 & 1701 & 1966.42105263158 & -265.421052631579 \tabularnewline
43 & 983 & 1010.93333333333 & -27.9333333333333 \tabularnewline
44 & 2161 & 1966.42105263158 & 194.578947368421 \tabularnewline
45 & 1276 & 1325.2 & -49.2 \tabularnewline
46 & 1189 & 1966.42105263158 & -777.421052631579 \tabularnewline
47 & 745 & 1010.93333333333 & -265.933333333333 \tabularnewline
48 & 2231 & 2588.61538461538 & -357.615384615385 \tabularnewline
49 & 2242 & 2588.61538461538 & -346.615384615385 \tabularnewline
50 & 2639 & 1966.42105263158 & 672.578947368421 \tabularnewline
51 & 658 & 831.714285714286 & -173.714285714286 \tabularnewline
52 & 1917 & 1966.42105263158 & -49.421052631579 \tabularnewline
53 & 2489 & 3086.85714285714 & -597.857142857143 \tabularnewline
54 & 2026 & 2588.61538461538 & -562.615384615385 \tabularnewline
55 & 1911 & 1966.42105263158 & -55.421052631579 \tabularnewline
56 & 1716 & 1578.8064516129 & 137.193548387097 \tabularnewline
57 & 1852 & 1966.42105263158 & -114.421052631579 \tabularnewline
58 & 981 & 1010.93333333333 & -29.9333333333333 \tabularnewline
59 & 1177 & 1966.42105263158 & -789.421052631579 \tabularnewline
60 & 2809 & 1966.42105263158 & 842.578947368421 \tabularnewline
61 & 1688 & 1966.42105263158 & -278.421052631579 \tabularnewline
62 & 2097 & 1966.42105263158 & 130.578947368421 \tabularnewline
63 & 1309 & 1966.42105263158 & -657.421052631579 \tabularnewline
64 & 1244 & 1325.2 & -81.2 \tabularnewline
65 & 1256 & 1578.8064516129 & -322.806451612903 \tabularnewline
66 & 1293 & 1325.2 & -32.2 \tabularnewline
67 & 2303 & 1966.42105263158 & 336.578947368421 \tabularnewline
68 & 2897 & 1966.42105263158 & 930.578947368421 \tabularnewline
69 & 1103 & 1325.2 & -222.2 \tabularnewline
70 & 340 & 208.222222222222 & 131.777777777778 \tabularnewline
71 & 2791 & 2588.61538461538 & 202.384615384615 \tabularnewline
72 & 1333 & 1966.42105263158 & -633.421052631579 \tabularnewline
73 & 1441 & 1325.2 & 115.8 \tabularnewline
74 & 1623 & 1325.2 & 297.8 \tabularnewline
75 & 2650 & 1966.42105263158 & 683.578947368421 \tabularnewline
76 & 1499 & 1325.2 & 173.8 \tabularnewline
77 & 2302 & 1966.42105263158 & 335.578947368421 \tabularnewline
78 & 2540 & 1966.42105263158 & 573.578947368421 \tabularnewline
79 & 1000 & 1010.93333333333 & -10.9333333333333 \tabularnewline
80 & 1234 & 1010.93333333333 & 223.066666666667 \tabularnewline
81 & 927 & 1010.93333333333 & -83.9333333333333 \tabularnewline
82 & 2176 & 3086.85714285714 & -910.857142857143 \tabularnewline
83 & 957 & 831.714285714286 & 125.285714285714 \tabularnewline
84 & 1551 & 1578.8064516129 & -27.8064516129032 \tabularnewline
85 & 1014 & 1010.93333333333 & 3.06666666666672 \tabularnewline
86 & 1771 & 1578.8064516129 & 192.193548387097 \tabularnewline
87 & 2613 & 2588.61538461538 & 24.3846153846152 \tabularnewline
88 & 1203 & 1325.2 & -122.2 \tabularnewline
89 & 1337 & 1325.2 & 11.8 \tabularnewline
90 & 1524 & 1578.8064516129 & -54.8064516129032 \tabularnewline
91 & 1829 & 1578.8064516129 & 250.193548387097 \tabularnewline
92 & 2229 & 1966.42105263158 & 262.578947368421 \tabularnewline
93 & 1233 & 1578.8064516129 & -345.806451612903 \tabularnewline
94 & 1365 & 1578.8064516129 & -213.806451612903 \tabularnewline
95 & 950 & 831.714285714286 & 118.285714285714 \tabularnewline
96 & 2319 & 3086.85714285714 & -767.857142857143 \tabularnewline
97 & 1857 & 1966.42105263158 & -109.421052631579 \tabularnewline
98 & 223 & 208.222222222222 & 14.7777777777778 \tabularnewline
99 & 2390 & 2588.61538461538 & -198.615384615385 \tabularnewline
100 & 1973 & 1966.42105263158 & 6.57894736842104 \tabularnewline
101 & 700 & 831.714285714286 & -131.714285714286 \tabularnewline
102 & 1062 & 1010.93333333333 & 51.0666666666667 \tabularnewline
103 & 1311 & 1578.8064516129 & -267.806451612903 \tabularnewline
104 & 1157 & 1325.2 & -168.2 \tabularnewline
105 & 823 & 1010.93333333333 & -187.933333333333 \tabularnewline
106 & 596 & 208.222222222222 & 387.777777777778 \tabularnewline
107 & 1545 & 1578.8064516129 & -33.8064516129032 \tabularnewline
108 & 1130 & 1578.8064516129 & -448.806451612903 \tabularnewline
109 & 0 & 208.222222222222 & -208.222222222222 \tabularnewline
110 & 1082 & 1010.93333333333 & 71.0666666666667 \tabularnewline
111 & 1135 & 1325.2 & -190.2 \tabularnewline
112 & 1366 & 1578.8064516129 & -212.806451612903 \tabularnewline
113 & 1452 & 1966.42105263158 & -514.421052631579 \tabularnewline
114 & 870 & 1010.93333333333 & -140.933333333333 \tabularnewline
115 & 78 & 208.222222222222 & -130.222222222222 \tabularnewline
116 & 0 & 208.222222222222 & -208.222222222222 \tabularnewline
117 & 1127 & 1578.8064516129 & -451.806451612903 \tabularnewline
118 & 1582 & 1966.42105263158 & -384.421052631579 \tabularnewline
119 & 2034 & 1966.42105263158 & 67.578947368421 \tabularnewline
120 & 919 & 1325.2 & -406.2 \tabularnewline
121 & 778 & 831.714285714286 & -53.7142857142857 \tabularnewline
122 & 1752 & 1966.42105263158 & -214.421052631579 \tabularnewline
123 & 957 & 1010.93333333333 & -53.9333333333333 \tabularnewline
124 & 1875 & 1578.8064516129 & 296.193548387097 \tabularnewline
125 & 731 & 831.714285714286 & -100.714285714286 \tabularnewline
126 & 285 & 208.222222222222 & 76.7777777777778 \tabularnewline
127 & 1834 & 1578.8064516129 & 255.193548387097 \tabularnewline
128 & 1147 & 1578.8064516129 & -431.806451612903 \tabularnewline
129 & 1646 & 1578.8064516129 & 67.1935483870968 \tabularnewline
130 & 256 & 208.222222222222 & 47.7777777777778 \tabularnewline
131 & 98 & 208.222222222222 & -110.222222222222 \tabularnewline
132 & 1404 & 1578.8064516129 & -174.806451612903 \tabularnewline
133 & 41 & 208.222222222222 & -167.222222222222 \tabularnewline
134 & 1824 & 1966.42105263158 & -142.421052631579 \tabularnewline
135 & 42 & 208.222222222222 & -166.222222222222 \tabularnewline
136 & 528 & 208.222222222222 & 319.777777777778 \tabularnewline
137 & 0 & 208.222222222222 & -208.222222222222 \tabularnewline
138 & 1073 & 1578.8064516129 & -505.806451612903 \tabularnewline
139 & 1305 & 1010.93333333333 & 294.066666666667 \tabularnewline
140 & 81 & 208.222222222222 & -127.222222222222 \tabularnewline
141 & 261 & 208.222222222222 & 52.7777777777778 \tabularnewline
142 & 934 & 1010.93333333333 & -76.9333333333333 \tabularnewline
143 & 1179 & 1578.8064516129 & -399.806451612903 \tabularnewline
144 & 1147 & 1325.2 & -178.2 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158783&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]1773[/C][C]1966.42105263158[/C][C]-193.421052631579[/C][/ROW]
[ROW][C]2[/C][C]1704[/C][C]1578.8064516129[/C][C]125.193548387097[/C][/ROW]
[ROW][C]3[/C][C]192[/C][C]208.222222222222[/C][C]-16.2222222222222[/C][/ROW]
[ROW][C]4[/C][C]2295[/C][C]1966.42105263158[/C][C]328.578947368421[/C][/ROW]
[ROW][C]5[/C][C]3450[/C][C]2588.61538461538[/C][C]861.384615384615[/C][/ROW]
[ROW][C]6[/C][C]6813[/C][C]3086.85714285714[/C][C]3726.14285714286[/C][/ROW]
[ROW][C]7[/C][C]1795[/C][C]1578.8064516129[/C][C]216.193548387097[/C][/ROW]
[ROW][C]8[/C][C]1681[/C][C]1966.42105263158[/C][C]-285.421052631579[/C][/ROW]
[ROW][C]9[/C][C]1897[/C][C]1578.8064516129[/C][C]318.193548387097[/C][/ROW]
[ROW][C]10[/C][C]2917[/C][C]3086.85714285714[/C][C]-169.857142857143[/C][/ROW]
[ROW][C]11[/C][C]1946[/C][C]1966.42105263158[/C][C]-20.421052631579[/C][/ROW]
[ROW][C]12[/C][C]2148[/C][C]1966.42105263158[/C][C]181.578947368421[/C][/ROW]
[ROW][C]13[/C][C]1832[/C][C]1325.2[/C][C]506.8[/C][/ROW]
[ROW][C]14[/C][C]3138[/C][C]2588.61538461538[/C][C]549.384615384615[/C][/ROW]
[ROW][C]15[/C][C]1476[/C][C]1578.8064516129[/C][C]-102.806451612903[/C][/ROW]
[ROW][C]16[/C][C]1567[/C][C]1966.42105263158[/C][C]-399.421052631579[/C][/ROW]
[ROW][C]17[/C][C]1756[/C][C]1578.8064516129[/C][C]177.193548387097[/C][/ROW]
[ROW][C]18[/C][C]1247[/C][C]1010.93333333333[/C][C]236.066666666667[/C][/ROW]
[ROW][C]19[/C][C]2779[/C][C]1966.42105263158[/C][C]812.578947368421[/C][/ROW]
[ROW][C]20[/C][C]726[/C][C]208.222222222222[/C][C]517.777777777778[/C][/ROW]
[ROW][C]21[/C][C]1048[/C][C]831.714285714286[/C][C]216.285714285714[/C][/ROW]
[ROW][C]22[/C][C]2805[/C][C]2588.61538461538[/C][C]216.384615384615[/C][/ROW]
[ROW][C]23[/C][C]1760[/C][C]1966.42105263158[/C][C]-206.421052631579[/C][/ROW]
[ROW][C]24[/C][C]2261[/C][C]1578.8064516129[/C][C]682.193548387097[/C][/ROW]
[ROW][C]25[/C][C]1848[/C][C]1966.42105263158[/C][C]-118.421052631579[/C][/ROW]
[ROW][C]26[/C][C]1665[/C][C]1578.8064516129[/C][C]86.1935483870968[/C][/ROW]
[ROW][C]27[/C][C]2082[/C][C]1966.42105263158[/C][C]115.578947368421[/C][/ROW]
[ROW][C]28[/C][C]1440[/C][C]1966.42105263158[/C][C]-526.421052631579[/C][/ROW]
[ROW][C]29[/C][C]2741[/C][C]3086.85714285714[/C][C]-345.857142857143[/C][/ROW]
[ROW][C]30[/C][C]2112[/C][C]1578.8064516129[/C][C]533.193548387097[/C][/ROW]
[ROW][C]31[/C][C]1684[/C][C]1578.8064516129[/C][C]105.193548387097[/C][/ROW]
[ROW][C]32[/C][C]1616[/C][C]1578.8064516129[/C][C]37.1935483870968[/C][/ROW]
[ROW][C]33[/C][C]2227[/C][C]1966.42105263158[/C][C]260.578947368421[/C][/ROW]
[ROW][C]34[/C][C]3088[/C][C]2588.61538461538[/C][C]499.384615384615[/C][/ROW]
[ROW][C]35[/C][C]2389[/C][C]2588.61538461538[/C][C]-199.615384615385[/C][/ROW]
[ROW][C]36[/C][C]1[/C][C]208.222222222222[/C][C]-207.222222222222[/C][/ROW]
[ROW][C]37[/C][C]2099[/C][C]2588.61538461538[/C][C]-489.615384615385[/C][/ROW]
[ROW][C]38[/C][C]1669[/C][C]1325.2[/C][C]343.8[/C][/ROW]
[ROW][C]39[/C][C]2095[/C][C]1578.8064516129[/C][C]516.193548387097[/C][/ROW]
[ROW][C]40[/C][C]2153[/C][C]3086.85714285714[/C][C]-933.857142857143[/C][/ROW]
[ROW][C]41[/C][C]2390[/C][C]2588.61538461538[/C][C]-198.615384615385[/C][/ROW]
[ROW][C]42[/C][C]1701[/C][C]1966.42105263158[/C][C]-265.421052631579[/C][/ROW]
[ROW][C]43[/C][C]983[/C][C]1010.93333333333[/C][C]-27.9333333333333[/C][/ROW]
[ROW][C]44[/C][C]2161[/C][C]1966.42105263158[/C][C]194.578947368421[/C][/ROW]
[ROW][C]45[/C][C]1276[/C][C]1325.2[/C][C]-49.2[/C][/ROW]
[ROW][C]46[/C][C]1189[/C][C]1966.42105263158[/C][C]-777.421052631579[/C][/ROW]
[ROW][C]47[/C][C]745[/C][C]1010.93333333333[/C][C]-265.933333333333[/C][/ROW]
[ROW][C]48[/C][C]2231[/C][C]2588.61538461538[/C][C]-357.615384615385[/C][/ROW]
[ROW][C]49[/C][C]2242[/C][C]2588.61538461538[/C][C]-346.615384615385[/C][/ROW]
[ROW][C]50[/C][C]2639[/C][C]1966.42105263158[/C][C]672.578947368421[/C][/ROW]
[ROW][C]51[/C][C]658[/C][C]831.714285714286[/C][C]-173.714285714286[/C][/ROW]
[ROW][C]52[/C][C]1917[/C][C]1966.42105263158[/C][C]-49.421052631579[/C][/ROW]
[ROW][C]53[/C][C]2489[/C][C]3086.85714285714[/C][C]-597.857142857143[/C][/ROW]
[ROW][C]54[/C][C]2026[/C][C]2588.61538461538[/C][C]-562.615384615385[/C][/ROW]
[ROW][C]55[/C][C]1911[/C][C]1966.42105263158[/C][C]-55.421052631579[/C][/ROW]
[ROW][C]56[/C][C]1716[/C][C]1578.8064516129[/C][C]137.193548387097[/C][/ROW]
[ROW][C]57[/C][C]1852[/C][C]1966.42105263158[/C][C]-114.421052631579[/C][/ROW]
[ROW][C]58[/C][C]981[/C][C]1010.93333333333[/C][C]-29.9333333333333[/C][/ROW]
[ROW][C]59[/C][C]1177[/C][C]1966.42105263158[/C][C]-789.421052631579[/C][/ROW]
[ROW][C]60[/C][C]2809[/C][C]1966.42105263158[/C][C]842.578947368421[/C][/ROW]
[ROW][C]61[/C][C]1688[/C][C]1966.42105263158[/C][C]-278.421052631579[/C][/ROW]
[ROW][C]62[/C][C]2097[/C][C]1966.42105263158[/C][C]130.578947368421[/C][/ROW]
[ROW][C]63[/C][C]1309[/C][C]1966.42105263158[/C][C]-657.421052631579[/C][/ROW]
[ROW][C]64[/C][C]1244[/C][C]1325.2[/C][C]-81.2[/C][/ROW]
[ROW][C]65[/C][C]1256[/C][C]1578.8064516129[/C][C]-322.806451612903[/C][/ROW]
[ROW][C]66[/C][C]1293[/C][C]1325.2[/C][C]-32.2[/C][/ROW]
[ROW][C]67[/C][C]2303[/C][C]1966.42105263158[/C][C]336.578947368421[/C][/ROW]
[ROW][C]68[/C][C]2897[/C][C]1966.42105263158[/C][C]930.578947368421[/C][/ROW]
[ROW][C]69[/C][C]1103[/C][C]1325.2[/C][C]-222.2[/C][/ROW]
[ROW][C]70[/C][C]340[/C][C]208.222222222222[/C][C]131.777777777778[/C][/ROW]
[ROW][C]71[/C][C]2791[/C][C]2588.61538461538[/C][C]202.384615384615[/C][/ROW]
[ROW][C]72[/C][C]1333[/C][C]1966.42105263158[/C][C]-633.421052631579[/C][/ROW]
[ROW][C]73[/C][C]1441[/C][C]1325.2[/C][C]115.8[/C][/ROW]
[ROW][C]74[/C][C]1623[/C][C]1325.2[/C][C]297.8[/C][/ROW]
[ROW][C]75[/C][C]2650[/C][C]1966.42105263158[/C][C]683.578947368421[/C][/ROW]
[ROW][C]76[/C][C]1499[/C][C]1325.2[/C][C]173.8[/C][/ROW]
[ROW][C]77[/C][C]2302[/C][C]1966.42105263158[/C][C]335.578947368421[/C][/ROW]
[ROW][C]78[/C][C]2540[/C][C]1966.42105263158[/C][C]573.578947368421[/C][/ROW]
[ROW][C]79[/C][C]1000[/C][C]1010.93333333333[/C][C]-10.9333333333333[/C][/ROW]
[ROW][C]80[/C][C]1234[/C][C]1010.93333333333[/C][C]223.066666666667[/C][/ROW]
[ROW][C]81[/C][C]927[/C][C]1010.93333333333[/C][C]-83.9333333333333[/C][/ROW]
[ROW][C]82[/C][C]2176[/C][C]3086.85714285714[/C][C]-910.857142857143[/C][/ROW]
[ROW][C]83[/C][C]957[/C][C]831.714285714286[/C][C]125.285714285714[/C][/ROW]
[ROW][C]84[/C][C]1551[/C][C]1578.8064516129[/C][C]-27.8064516129032[/C][/ROW]
[ROW][C]85[/C][C]1014[/C][C]1010.93333333333[/C][C]3.06666666666672[/C][/ROW]
[ROW][C]86[/C][C]1771[/C][C]1578.8064516129[/C][C]192.193548387097[/C][/ROW]
[ROW][C]87[/C][C]2613[/C][C]2588.61538461538[/C][C]24.3846153846152[/C][/ROW]
[ROW][C]88[/C][C]1203[/C][C]1325.2[/C][C]-122.2[/C][/ROW]
[ROW][C]89[/C][C]1337[/C][C]1325.2[/C][C]11.8[/C][/ROW]
[ROW][C]90[/C][C]1524[/C][C]1578.8064516129[/C][C]-54.8064516129032[/C][/ROW]
[ROW][C]91[/C][C]1829[/C][C]1578.8064516129[/C][C]250.193548387097[/C][/ROW]
[ROW][C]92[/C][C]2229[/C][C]1966.42105263158[/C][C]262.578947368421[/C][/ROW]
[ROW][C]93[/C][C]1233[/C][C]1578.8064516129[/C][C]-345.806451612903[/C][/ROW]
[ROW][C]94[/C][C]1365[/C][C]1578.8064516129[/C][C]-213.806451612903[/C][/ROW]
[ROW][C]95[/C][C]950[/C][C]831.714285714286[/C][C]118.285714285714[/C][/ROW]
[ROW][C]96[/C][C]2319[/C][C]3086.85714285714[/C][C]-767.857142857143[/C][/ROW]
[ROW][C]97[/C][C]1857[/C][C]1966.42105263158[/C][C]-109.421052631579[/C][/ROW]
[ROW][C]98[/C][C]223[/C][C]208.222222222222[/C][C]14.7777777777778[/C][/ROW]
[ROW][C]99[/C][C]2390[/C][C]2588.61538461538[/C][C]-198.615384615385[/C][/ROW]
[ROW][C]100[/C][C]1973[/C][C]1966.42105263158[/C][C]6.57894736842104[/C][/ROW]
[ROW][C]101[/C][C]700[/C][C]831.714285714286[/C][C]-131.714285714286[/C][/ROW]
[ROW][C]102[/C][C]1062[/C][C]1010.93333333333[/C][C]51.0666666666667[/C][/ROW]
[ROW][C]103[/C][C]1311[/C][C]1578.8064516129[/C][C]-267.806451612903[/C][/ROW]
[ROW][C]104[/C][C]1157[/C][C]1325.2[/C][C]-168.2[/C][/ROW]
[ROW][C]105[/C][C]823[/C][C]1010.93333333333[/C][C]-187.933333333333[/C][/ROW]
[ROW][C]106[/C][C]596[/C][C]208.222222222222[/C][C]387.777777777778[/C][/ROW]
[ROW][C]107[/C][C]1545[/C][C]1578.8064516129[/C][C]-33.8064516129032[/C][/ROW]
[ROW][C]108[/C][C]1130[/C][C]1578.8064516129[/C][C]-448.806451612903[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]208.222222222222[/C][C]-208.222222222222[/C][/ROW]
[ROW][C]110[/C][C]1082[/C][C]1010.93333333333[/C][C]71.0666666666667[/C][/ROW]
[ROW][C]111[/C][C]1135[/C][C]1325.2[/C][C]-190.2[/C][/ROW]
[ROW][C]112[/C][C]1366[/C][C]1578.8064516129[/C][C]-212.806451612903[/C][/ROW]
[ROW][C]113[/C][C]1452[/C][C]1966.42105263158[/C][C]-514.421052631579[/C][/ROW]
[ROW][C]114[/C][C]870[/C][C]1010.93333333333[/C][C]-140.933333333333[/C][/ROW]
[ROW][C]115[/C][C]78[/C][C]208.222222222222[/C][C]-130.222222222222[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]208.222222222222[/C][C]-208.222222222222[/C][/ROW]
[ROW][C]117[/C][C]1127[/C][C]1578.8064516129[/C][C]-451.806451612903[/C][/ROW]
[ROW][C]118[/C][C]1582[/C][C]1966.42105263158[/C][C]-384.421052631579[/C][/ROW]
[ROW][C]119[/C][C]2034[/C][C]1966.42105263158[/C][C]67.578947368421[/C][/ROW]
[ROW][C]120[/C][C]919[/C][C]1325.2[/C][C]-406.2[/C][/ROW]
[ROW][C]121[/C][C]778[/C][C]831.714285714286[/C][C]-53.7142857142857[/C][/ROW]
[ROW][C]122[/C][C]1752[/C][C]1966.42105263158[/C][C]-214.421052631579[/C][/ROW]
[ROW][C]123[/C][C]957[/C][C]1010.93333333333[/C][C]-53.9333333333333[/C][/ROW]
[ROW][C]124[/C][C]1875[/C][C]1578.8064516129[/C][C]296.193548387097[/C][/ROW]
[ROW][C]125[/C][C]731[/C][C]831.714285714286[/C][C]-100.714285714286[/C][/ROW]
[ROW][C]126[/C][C]285[/C][C]208.222222222222[/C][C]76.7777777777778[/C][/ROW]
[ROW][C]127[/C][C]1834[/C][C]1578.8064516129[/C][C]255.193548387097[/C][/ROW]
[ROW][C]128[/C][C]1147[/C][C]1578.8064516129[/C][C]-431.806451612903[/C][/ROW]
[ROW][C]129[/C][C]1646[/C][C]1578.8064516129[/C][C]67.1935483870968[/C][/ROW]
[ROW][C]130[/C][C]256[/C][C]208.222222222222[/C][C]47.7777777777778[/C][/ROW]
[ROW][C]131[/C][C]98[/C][C]208.222222222222[/C][C]-110.222222222222[/C][/ROW]
[ROW][C]132[/C][C]1404[/C][C]1578.8064516129[/C][C]-174.806451612903[/C][/ROW]
[ROW][C]133[/C][C]41[/C][C]208.222222222222[/C][C]-167.222222222222[/C][/ROW]
[ROW][C]134[/C][C]1824[/C][C]1966.42105263158[/C][C]-142.421052631579[/C][/ROW]
[ROW][C]135[/C][C]42[/C][C]208.222222222222[/C][C]-166.222222222222[/C][/ROW]
[ROW][C]136[/C][C]528[/C][C]208.222222222222[/C][C]319.777777777778[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]208.222222222222[/C][C]-208.222222222222[/C][/ROW]
[ROW][C]138[/C][C]1073[/C][C]1578.8064516129[/C][C]-505.806451612903[/C][/ROW]
[ROW][C]139[/C][C]1305[/C][C]1010.93333333333[/C][C]294.066666666667[/C][/ROW]
[ROW][C]140[/C][C]81[/C][C]208.222222222222[/C][C]-127.222222222222[/C][/ROW]
[ROW][C]141[/C][C]261[/C][C]208.222222222222[/C][C]52.7777777777778[/C][/ROW]
[ROW][C]142[/C][C]934[/C][C]1010.93333333333[/C][C]-76.9333333333333[/C][/ROW]
[ROW][C]143[/C][C]1179[/C][C]1578.8064516129[/C][C]-399.806451612903[/C][/ROW]
[ROW][C]144[/C][C]1147[/C][C]1325.2[/C][C]-178.2[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158783&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158783&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
117731966.42105263158-193.421052631579
217041578.8064516129125.193548387097
3192208.222222222222-16.2222222222222
422951966.42105263158328.578947368421
534502588.61538461538861.384615384615
668133086.857142857143726.14285714286
717951578.8064516129216.193548387097
816811966.42105263158-285.421052631579
918971578.8064516129318.193548387097
1029173086.85714285714-169.857142857143
1119461966.42105263158-20.421052631579
1221481966.42105263158181.578947368421
1318321325.2506.8
1431382588.61538461538549.384615384615
1514761578.8064516129-102.806451612903
1615671966.42105263158-399.421052631579
1717561578.8064516129177.193548387097
1812471010.93333333333236.066666666667
1927791966.42105263158812.578947368421
20726208.222222222222517.777777777778
211048831.714285714286216.285714285714
2228052588.61538461538216.384615384615
2317601966.42105263158-206.421052631579
2422611578.8064516129682.193548387097
2518481966.42105263158-118.421052631579
2616651578.806451612986.1935483870968
2720821966.42105263158115.578947368421
2814401966.42105263158-526.421052631579
2927413086.85714285714-345.857142857143
3021121578.8064516129533.193548387097
3116841578.8064516129105.193548387097
3216161578.806451612937.1935483870968
3322271966.42105263158260.578947368421
3430882588.61538461538499.384615384615
3523892588.61538461538-199.615384615385
361208.222222222222-207.222222222222
3720992588.61538461538-489.615384615385
3816691325.2343.8
3920951578.8064516129516.193548387097
4021533086.85714285714-933.857142857143
4123902588.61538461538-198.615384615385
4217011966.42105263158-265.421052631579
439831010.93333333333-27.9333333333333
4421611966.42105263158194.578947368421
4512761325.2-49.2
4611891966.42105263158-777.421052631579
477451010.93333333333-265.933333333333
4822312588.61538461538-357.615384615385
4922422588.61538461538-346.615384615385
5026391966.42105263158672.578947368421
51658831.714285714286-173.714285714286
5219171966.42105263158-49.421052631579
5324893086.85714285714-597.857142857143
5420262588.61538461538-562.615384615385
5519111966.42105263158-55.421052631579
5617161578.8064516129137.193548387097
5718521966.42105263158-114.421052631579
589811010.93333333333-29.9333333333333
5911771966.42105263158-789.421052631579
6028091966.42105263158842.578947368421
6116881966.42105263158-278.421052631579
6220971966.42105263158130.578947368421
6313091966.42105263158-657.421052631579
6412441325.2-81.2
6512561578.8064516129-322.806451612903
6612931325.2-32.2
6723031966.42105263158336.578947368421
6828971966.42105263158930.578947368421
6911031325.2-222.2
70340208.222222222222131.777777777778
7127912588.61538461538202.384615384615
7213331966.42105263158-633.421052631579
7314411325.2115.8
7416231325.2297.8
7526501966.42105263158683.578947368421
7614991325.2173.8
7723021966.42105263158335.578947368421
7825401966.42105263158573.578947368421
7910001010.93333333333-10.9333333333333
8012341010.93333333333223.066666666667
819271010.93333333333-83.9333333333333
8221763086.85714285714-910.857142857143
83957831.714285714286125.285714285714
8415511578.8064516129-27.8064516129032
8510141010.933333333333.06666666666672
8617711578.8064516129192.193548387097
8726132588.6153846153824.3846153846152
8812031325.2-122.2
8913371325.211.8
9015241578.8064516129-54.8064516129032
9118291578.8064516129250.193548387097
9222291966.42105263158262.578947368421
9312331578.8064516129-345.806451612903
9413651578.8064516129-213.806451612903
95950831.714285714286118.285714285714
9623193086.85714285714-767.857142857143
9718571966.42105263158-109.421052631579
98223208.22222222222214.7777777777778
9923902588.61538461538-198.615384615385
10019731966.421052631586.57894736842104
101700831.714285714286-131.714285714286
10210621010.9333333333351.0666666666667
10313111578.8064516129-267.806451612903
10411571325.2-168.2
1058231010.93333333333-187.933333333333
106596208.222222222222387.777777777778
10715451578.8064516129-33.8064516129032
10811301578.8064516129-448.806451612903
1090208.222222222222-208.222222222222
11010821010.9333333333371.0666666666667
11111351325.2-190.2
11213661578.8064516129-212.806451612903
11314521966.42105263158-514.421052631579
1148701010.93333333333-140.933333333333
11578208.222222222222-130.222222222222
1160208.222222222222-208.222222222222
11711271578.8064516129-451.806451612903
11815821966.42105263158-384.421052631579
11920341966.4210526315867.578947368421
1209191325.2-406.2
121778831.714285714286-53.7142857142857
12217521966.42105263158-214.421052631579
1239571010.93333333333-53.9333333333333
12418751578.8064516129296.193548387097
125731831.714285714286-100.714285714286
126285208.22222222222276.7777777777778
12718341578.8064516129255.193548387097
12811471578.8064516129-431.806451612903
12916461578.806451612967.1935483870968
130256208.22222222222247.7777777777778
13198208.222222222222-110.222222222222
13214041578.8064516129-174.806451612903
13341208.222222222222-167.222222222222
13418241966.42105263158-142.421052631579
13542208.222222222222-166.222222222222
136528208.222222222222319.777777777778
1370208.222222222222-208.222222222222
13810731578.8064516129-505.806451612903
13913051010.93333333333294.066666666667
14081208.222222222222-127.222222222222
141261208.22222222222252.7777777777778
1429341010.93333333333-76.9333333333333
14311791578.8064516129-399.806451612903
14411471325.2-178.2



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