Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationFri, 23 Dec 2011 00:52:04 -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/23/t1324619554s6ytck2wtv8lif5.htm/, Retrieved Mon, 29 Apr 2024 20:04:13 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=160168, Retrieved Mon, 29 Apr 2024 20:04:13 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact111
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [Regression trees] [2011-12-23 05:52:04] [5c55e7d277583a4a66c326a86fdb470e] [Current]
Feedback Forum

Post a new message
Dataseries X:
1845	162687	95	595	115	0	48
1917	233285	67	580	79	1	75
192	7215	18	72	1	0	0
2665	164587	99	737	158	0	74
3709	283430	141	1255	127	0	92
7138	546996	275	2021	278	1	137
1888	192501	61	606	95	1	65
1909	213538	64	533	64	0	97
2140	182282	46	687	92	0	62
3168	336547	102	1074	130	1	72
1957	122275	77	637	158	2	50
2370	203938	72	743	120	0	88
1998	119300	110	701	87	0	68
3203	220796	122	1087	264	4	79
1505	174005	67	422	51	4	56
1574	156326	89	474	85	3	54
1965	164063	60	483	100	0	101
1314	90025	63	375	72	5	13
2921	179987	90	929	147	0	80
823	47066	29	262	49	0	19
1289	109572	64	437	40	0	33
2818	241285	103	850	99	0	99
1792	208339	77	652	127	1	38
2474	164166	59	754	166	1	68
1994	159763	89	619	41	1	54
1806	207078	34	657	160	0	63
2177	217028	169	695	92	0	66
1458	201536	96	366	59	0	90
3057	408960	124	1015	89	0	75
2487	250260	48	1029	104	0	68
1914	216527	46	576	81	0	69
1825	212949	51	656	116	2	80
2509	164248	110	812	105	4	59
3634	278911	136	1108	388	0	135
2608	238654	59	852	88	1	75
1	0	1	0	0	0	0
2157	233971	66	1009	63	0	54
1978	149649	55	658	138	3	62
2224	161703	52	547	270	9	46
2215	254893	70	826	64	0	83
2538	269492	73	838	96	2	106
1881	169526	62	704	62	0	51
1113	107893	35	404	35	2	27
2380	229714	83	848	66	1	78
1365	139667	51	419	56	2	71
1294	175983	102	349	46	2	44
756	81407	33	216	49	1	23
2465	251259	110	796	121	0	78
2327	239807	90	752	113	1	60
2787	172743	60	964	190	8	73
658	48188	28	205	37	0	12
2013	169355	71	506	52	0	104
2666	335398	78	841	89	0	95
2086	244729	81	699	73	0	57
2067	208286	62	746	61	1	68
1776	159913	58	547	77	8	44
2045	232137	72	561	63	0	62
1047	101694	26	329	75	1	26
1190	157258	68	427	32	0	67
2932	211586	101	993	59	10	36
1868	181076	66	564	71	6	56
2316	158024	86	858	92	0	55
1392	141491	64	376	87	11	54
1355	130108	40	471	48	3	61
1326	166420	39	432	63	0	27
1587	135509	45	500	41	0	64
2336	195043	72	504	86	8	76
2898	138708	66	887	152	2	93
1118	116552	40	271	49	0	59
340	31970	15	101	40	0	5
3224	291993	121	1203	148	3	62
1552	167825	82	506	86	1	47
1551	135926	69	528	62	2	88
1794	136647	77	501	96	1	57
2728	171518	71	698	95	0	81
1580	108980	46	426	83	2	35
2414	183471	61	709	112	1	102
2640	167426	101	847	77	0	73
1203	112510	49	367	78	0	32
1313	92421	77	413	114	0	34
1207	117169	84	272	55	0	80
2246	304603	65	830	60	0	49
1076	75101	30	334	49	1	30
1638	145043	41	524	132	0	57
1208	95827	48	393	49	0	54
1868	173931	60	574	71	0	38
2829	250424	252	695	102	0	63
1209	115367	116	284	74	0	58
1463	125839	66	462	49	7	49
1610	164078	54	653	74	0	46
1865	158931	42	684	59	5	51
2444	190382	85	714	91	1	90
1253	155226	59	420	68	0	45
1468	146159	61	551	81	0	28
979	62641	44	396	33	0	26
2365	258585	121	741	166	0	54
1890	199841	71	571	97	0	96
223	19349	12	67	15	0	13
2527	247280	109	877	105	3	43
2186	173152	88	885	61	0	46
778	72128	30	306	11	0	30
1194	104253	26	382	45	0	59
1424	151090	57	435	89	0	73
1386	147990	68	348	72	1	40
839	87448	42	227	27	1	36
596	27676	22	194	59	0	2
1684	170326	52	413	127	0	103
1168	132148	38	273	48	1	30
0	0	0	0	0	0	0
1315	133868	36	390	58	0	78
1149	109001	68	376	57	0	25
1485	158833	46	495	60	0	59
1529	150013	66	448	77	1	60
962	89887	63	313	71	0	36
78	3616	5	14	5	0	0
0	0	0	0	0	0	0
1295	216479	48	445	78	0	51
1751	177323	102	637	76	0	79
2142	177948	102	593	124	2	30
1070	140106	41	326	67	0	43
778	43410	19	292	63	0	7
1986	206059	76	573	92	1	92
1084	109873	45	315	58	0	32
2400	157084	61	683	65	10	84
731	60493	40	174	29	3	3
285	19764	12	75	19	1	10
1873	177559	57	572	64	3	47
1269	154169	36	414	79	0	44
1725	164249	54	562	104	0	54
256	11796	9	79	22	0	1
98	10674	9	33	7	0	0
1435	151322	59	487	37	0	46
41	6836	3	11	5	0	0
1931	174712	68	664	48	6	51
42	5118	3	6	1	0	5
528	40248	16	183	34	1	8
0	0	0	0	0	0	0
1122	127628	51	342	53	0	38
1305	88837	38	269	44	0	21
81	7131	4	27	0	1	0
262	9056	15	99	18	0	0
1165	97191	31	322	52	1	26
1405	157478	59	367	60	0	53
1409	125583	23	521	50	1	31




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 4 seconds \tabularnewline
R Server & 'Gwilym Jenkins' @ jenkins.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160168&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]4 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Gwilym Jenkins' @ jenkins.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160168&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160168&T=0

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net







Goodness of Fit
Correlation0.9135
R-squared0.8346
RMSE378.5624

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.9135[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8346[/C][/ROW]
[ROW][C]RMSE[/C][C]378.5624[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160168&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160168&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.9135
R-squared0.8346
RMSE378.5624







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
118451831.4285714285713.5714285714287
219171831.4285714285785.5714285714287
3192232.210526315789-40.2105263157895
426652457.3125207.6875
537093702.56.5
671383702.53435.5
718881831.4285714285756.5714285714287
819091831.4285714285777.5714285714287
921401831.42857142857308.571428571429
1031683702.5-534.5
1119571831.42857142857125.571428571429
1223702457.3125-87.3125
1319982457.3125-459.3125
1432033702.5-499.5
1515051420.1153846153884.8846153846155
1615741420.11538461538153.884615384615
1719651420.11538461538544.884615384615
1813141196.14285714286117.857142857143
1929212457.3125463.6875
208231029.82352941176-206.823529411765
2112891196.1428571428692.8571428571429
2228182457.3125360.6875
2317921831.42857142857-39.4285714285713
2424742457.312516.6875
2519941831.42857142857162.571428571429
2618061831.42857142857-25.4285714285713
2721772457.3125-280.3125
2814581420.1153846153837.8846153846155
2930573702.5-645.5
3024873702.5-1215.5
3119141831.4285714285782.5714285714287
3218251831.42857142857-6.42857142857133
3325092457.312551.6875
3436343702.5-68.5
3526082457.3125150.6875
361232.210526315789-231.210526315789
3721572457.3125-300.3125
3819781831.42857142857146.571428571429
3922242057.14285714286166.857142857143
4022152457.3125-242.3125
4125382457.312580.6875
4218812457.3125-576.3125
4311131196.14285714286-83.1428571428571
4423802457.3125-77.3125
4513651420.11538461538-55.1153846153845
4612941420.11538461538-126.115384615385
477561029.82352941176-273.823529411765
4824652457.31257.6875
4923272457.3125-130.3125
5027872457.3125329.6875
51658232.210526315789425.789473684211
5220131831.42857142857181.571428571429
5326662457.3125208.6875
5420862457.3125-371.3125
5520672457.3125-390.3125
5617762057.14285714286-281.142857142857
5720451831.42857142857213.571428571429
5810471029.8235294117617.1764705882354
5911901420.11538461538-230.115384615385
6029322457.3125474.6875
6118682057.14285714286-189.142857142857
6223162457.3125-141.3125
6313921420.11538461538-28.1153846153845
6413551420.11538461538-65.1153846153845
6513261196.14285714286129.857142857143
6615871420.11538461538166.884615384615
6723362057.14285714286278.857142857143
6828982457.3125440.6875
6911181029.8235294117688.1764705882354
70340232.210526315789107.789473684211
7132243702.5-478.5
7215521831.42857142857-279.428571428571
7315511831.42857142857-280.428571428571
7417941831.42857142857-37.4285714285713
7527282457.3125270.6875
7615801420.11538461538159.884615384615
7724142457.3125-43.3125
7826402457.3125182.6875
7912031196.142857142866.85714285714289
8013131420.11538461538-107.115384615385
8112071029.82352941176177.176470588235
8222462457.3125-211.3125
8310761029.8235294117646.1764705882354
8416381831.42857142857-193.428571428571
8512081420.11538461538-212.115384615385
8618681831.4285714285736.5714285714287
8728292457.3125371.6875
8812091029.82352941176179.176470588235
8914631420.1153846153842.8846153846155
9016101831.42857142857-221.428571428571
9118652057.14285714286-192.142857142857
9224442457.3125-13.3125
9312531420.11538461538-167.115384615385
9414681831.42857142857-363.428571428571
959791196.14285714286-217.142857142857
9623652457.3125-92.3125
9718901831.4285714285758.5714285714287
98223232.210526315789-9.21052631578948
9925272457.312569.6875
10021862457.3125-271.3125
1017781029.82352941176-251.823529411765
10211941420.11538461538-226.115384615385
10314241420.115384615383.88461538461547
10413861420.11538461538-34.1153846153845
1058391029.82352941176-190.823529411765
106596232.210526315789363.789473684211
10716841420.11538461538263.884615384615
10811681029.82352941176138.176470588235
1090232.210526315789-232.210526315789
11013151420.11538461538-105.115384615385
11111491196.14285714286-47.1428571428571
11214851420.1153846153864.8846153846155
11315291420.11538461538108.884615384615
1149621029.82352941176-67.8235294117646
11578232.210526315789-154.210526315789
1160232.210526315789-232.210526315789
11712951420.11538461538-125.115384615385
11817511831.42857142857-80.4285714285713
11921421831.42857142857310.571428571429
12010701029.8235294117640.1764705882354
1217781029.82352941176-251.823529411765
12219861831.42857142857154.571428571429
12310841029.8235294117654.1764705882354
12424002057.14285714286342.857142857143
125731232.210526315789498.789473684211
126285232.21052631578952.7894736842105
12718731831.4285714285741.5714285714287
12812691420.11538461538-151.115384615385
12917251831.42857142857-106.428571428571
130256232.21052631578923.7894736842105
13198232.210526315789-134.210526315789
13214351420.1153846153814.8846153846155
13341232.210526315789-191.210526315789
13419312057.14285714286-126.142857142857
13542232.210526315789-190.210526315789
136528232.210526315789295.789473684211
1370232.210526315789-232.210526315789
13811221029.8235294117692.1764705882354
13913051029.82352941176275.176470588235
14081232.210526315789-151.210526315789
141262232.21052631578929.7894736842105
14211651029.82352941176135.176470588235
14314051420.11538461538-15.1153846153845
14414091831.42857142857-422.428571428571

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 1845 & 1831.42857142857 & 13.5714285714287 \tabularnewline
2 & 1917 & 1831.42857142857 & 85.5714285714287 \tabularnewline
3 & 192 & 232.210526315789 & -40.2105263157895 \tabularnewline
4 & 2665 & 2457.3125 & 207.6875 \tabularnewline
5 & 3709 & 3702.5 & 6.5 \tabularnewline
6 & 7138 & 3702.5 & 3435.5 \tabularnewline
7 & 1888 & 1831.42857142857 & 56.5714285714287 \tabularnewline
8 & 1909 & 1831.42857142857 & 77.5714285714287 \tabularnewline
9 & 2140 & 1831.42857142857 & 308.571428571429 \tabularnewline
10 & 3168 & 3702.5 & -534.5 \tabularnewline
11 & 1957 & 1831.42857142857 & 125.571428571429 \tabularnewline
12 & 2370 & 2457.3125 & -87.3125 \tabularnewline
13 & 1998 & 2457.3125 & -459.3125 \tabularnewline
14 & 3203 & 3702.5 & -499.5 \tabularnewline
15 & 1505 & 1420.11538461538 & 84.8846153846155 \tabularnewline
16 & 1574 & 1420.11538461538 & 153.884615384615 \tabularnewline
17 & 1965 & 1420.11538461538 & 544.884615384615 \tabularnewline
18 & 1314 & 1196.14285714286 & 117.857142857143 \tabularnewline
19 & 2921 & 2457.3125 & 463.6875 \tabularnewline
20 & 823 & 1029.82352941176 & -206.823529411765 \tabularnewline
21 & 1289 & 1196.14285714286 & 92.8571428571429 \tabularnewline
22 & 2818 & 2457.3125 & 360.6875 \tabularnewline
23 & 1792 & 1831.42857142857 & -39.4285714285713 \tabularnewline
24 & 2474 & 2457.3125 & 16.6875 \tabularnewline
25 & 1994 & 1831.42857142857 & 162.571428571429 \tabularnewline
26 & 1806 & 1831.42857142857 & -25.4285714285713 \tabularnewline
27 & 2177 & 2457.3125 & -280.3125 \tabularnewline
28 & 1458 & 1420.11538461538 & 37.8846153846155 \tabularnewline
29 & 3057 & 3702.5 & -645.5 \tabularnewline
30 & 2487 & 3702.5 & -1215.5 \tabularnewline
31 & 1914 & 1831.42857142857 & 82.5714285714287 \tabularnewline
32 & 1825 & 1831.42857142857 & -6.42857142857133 \tabularnewline
33 & 2509 & 2457.3125 & 51.6875 \tabularnewline
34 & 3634 & 3702.5 & -68.5 \tabularnewline
35 & 2608 & 2457.3125 & 150.6875 \tabularnewline
36 & 1 & 232.210526315789 & -231.210526315789 \tabularnewline
37 & 2157 & 2457.3125 & -300.3125 \tabularnewline
38 & 1978 & 1831.42857142857 & 146.571428571429 \tabularnewline
39 & 2224 & 2057.14285714286 & 166.857142857143 \tabularnewline
40 & 2215 & 2457.3125 & -242.3125 \tabularnewline
41 & 2538 & 2457.3125 & 80.6875 \tabularnewline
42 & 1881 & 2457.3125 & -576.3125 \tabularnewline
43 & 1113 & 1196.14285714286 & -83.1428571428571 \tabularnewline
44 & 2380 & 2457.3125 & -77.3125 \tabularnewline
45 & 1365 & 1420.11538461538 & -55.1153846153845 \tabularnewline
46 & 1294 & 1420.11538461538 & -126.115384615385 \tabularnewline
47 & 756 & 1029.82352941176 & -273.823529411765 \tabularnewline
48 & 2465 & 2457.3125 & 7.6875 \tabularnewline
49 & 2327 & 2457.3125 & -130.3125 \tabularnewline
50 & 2787 & 2457.3125 & 329.6875 \tabularnewline
51 & 658 & 232.210526315789 & 425.789473684211 \tabularnewline
52 & 2013 & 1831.42857142857 & 181.571428571429 \tabularnewline
53 & 2666 & 2457.3125 & 208.6875 \tabularnewline
54 & 2086 & 2457.3125 & -371.3125 \tabularnewline
55 & 2067 & 2457.3125 & -390.3125 \tabularnewline
56 & 1776 & 2057.14285714286 & -281.142857142857 \tabularnewline
57 & 2045 & 1831.42857142857 & 213.571428571429 \tabularnewline
58 & 1047 & 1029.82352941176 & 17.1764705882354 \tabularnewline
59 & 1190 & 1420.11538461538 & -230.115384615385 \tabularnewline
60 & 2932 & 2457.3125 & 474.6875 \tabularnewline
61 & 1868 & 2057.14285714286 & -189.142857142857 \tabularnewline
62 & 2316 & 2457.3125 & -141.3125 \tabularnewline
63 & 1392 & 1420.11538461538 & -28.1153846153845 \tabularnewline
64 & 1355 & 1420.11538461538 & -65.1153846153845 \tabularnewline
65 & 1326 & 1196.14285714286 & 129.857142857143 \tabularnewline
66 & 1587 & 1420.11538461538 & 166.884615384615 \tabularnewline
67 & 2336 & 2057.14285714286 & 278.857142857143 \tabularnewline
68 & 2898 & 2457.3125 & 440.6875 \tabularnewline
69 & 1118 & 1029.82352941176 & 88.1764705882354 \tabularnewline
70 & 340 & 232.210526315789 & 107.789473684211 \tabularnewline
71 & 3224 & 3702.5 & -478.5 \tabularnewline
72 & 1552 & 1831.42857142857 & -279.428571428571 \tabularnewline
73 & 1551 & 1831.42857142857 & -280.428571428571 \tabularnewline
74 & 1794 & 1831.42857142857 & -37.4285714285713 \tabularnewline
75 & 2728 & 2457.3125 & 270.6875 \tabularnewline
76 & 1580 & 1420.11538461538 & 159.884615384615 \tabularnewline
77 & 2414 & 2457.3125 & -43.3125 \tabularnewline
78 & 2640 & 2457.3125 & 182.6875 \tabularnewline
79 & 1203 & 1196.14285714286 & 6.85714285714289 \tabularnewline
80 & 1313 & 1420.11538461538 & -107.115384615385 \tabularnewline
81 & 1207 & 1029.82352941176 & 177.176470588235 \tabularnewline
82 & 2246 & 2457.3125 & -211.3125 \tabularnewline
83 & 1076 & 1029.82352941176 & 46.1764705882354 \tabularnewline
84 & 1638 & 1831.42857142857 & -193.428571428571 \tabularnewline
85 & 1208 & 1420.11538461538 & -212.115384615385 \tabularnewline
86 & 1868 & 1831.42857142857 & 36.5714285714287 \tabularnewline
87 & 2829 & 2457.3125 & 371.6875 \tabularnewline
88 & 1209 & 1029.82352941176 & 179.176470588235 \tabularnewline
89 & 1463 & 1420.11538461538 & 42.8846153846155 \tabularnewline
90 & 1610 & 1831.42857142857 & -221.428571428571 \tabularnewline
91 & 1865 & 2057.14285714286 & -192.142857142857 \tabularnewline
92 & 2444 & 2457.3125 & -13.3125 \tabularnewline
93 & 1253 & 1420.11538461538 & -167.115384615385 \tabularnewline
94 & 1468 & 1831.42857142857 & -363.428571428571 \tabularnewline
95 & 979 & 1196.14285714286 & -217.142857142857 \tabularnewline
96 & 2365 & 2457.3125 & -92.3125 \tabularnewline
97 & 1890 & 1831.42857142857 & 58.5714285714287 \tabularnewline
98 & 223 & 232.210526315789 & -9.21052631578948 \tabularnewline
99 & 2527 & 2457.3125 & 69.6875 \tabularnewline
100 & 2186 & 2457.3125 & -271.3125 \tabularnewline
101 & 778 & 1029.82352941176 & -251.823529411765 \tabularnewline
102 & 1194 & 1420.11538461538 & -226.115384615385 \tabularnewline
103 & 1424 & 1420.11538461538 & 3.88461538461547 \tabularnewline
104 & 1386 & 1420.11538461538 & -34.1153846153845 \tabularnewline
105 & 839 & 1029.82352941176 & -190.823529411765 \tabularnewline
106 & 596 & 232.210526315789 & 363.789473684211 \tabularnewline
107 & 1684 & 1420.11538461538 & 263.884615384615 \tabularnewline
108 & 1168 & 1029.82352941176 & 138.176470588235 \tabularnewline
109 & 0 & 232.210526315789 & -232.210526315789 \tabularnewline
110 & 1315 & 1420.11538461538 & -105.115384615385 \tabularnewline
111 & 1149 & 1196.14285714286 & -47.1428571428571 \tabularnewline
112 & 1485 & 1420.11538461538 & 64.8846153846155 \tabularnewline
113 & 1529 & 1420.11538461538 & 108.884615384615 \tabularnewline
114 & 962 & 1029.82352941176 & -67.8235294117646 \tabularnewline
115 & 78 & 232.210526315789 & -154.210526315789 \tabularnewline
116 & 0 & 232.210526315789 & -232.210526315789 \tabularnewline
117 & 1295 & 1420.11538461538 & -125.115384615385 \tabularnewline
118 & 1751 & 1831.42857142857 & -80.4285714285713 \tabularnewline
119 & 2142 & 1831.42857142857 & 310.571428571429 \tabularnewline
120 & 1070 & 1029.82352941176 & 40.1764705882354 \tabularnewline
121 & 778 & 1029.82352941176 & -251.823529411765 \tabularnewline
122 & 1986 & 1831.42857142857 & 154.571428571429 \tabularnewline
123 & 1084 & 1029.82352941176 & 54.1764705882354 \tabularnewline
124 & 2400 & 2057.14285714286 & 342.857142857143 \tabularnewline
125 & 731 & 232.210526315789 & 498.789473684211 \tabularnewline
126 & 285 & 232.210526315789 & 52.7894736842105 \tabularnewline
127 & 1873 & 1831.42857142857 & 41.5714285714287 \tabularnewline
128 & 1269 & 1420.11538461538 & -151.115384615385 \tabularnewline
129 & 1725 & 1831.42857142857 & -106.428571428571 \tabularnewline
130 & 256 & 232.210526315789 & 23.7894736842105 \tabularnewline
131 & 98 & 232.210526315789 & -134.210526315789 \tabularnewline
132 & 1435 & 1420.11538461538 & 14.8846153846155 \tabularnewline
133 & 41 & 232.210526315789 & -191.210526315789 \tabularnewline
134 & 1931 & 2057.14285714286 & -126.142857142857 \tabularnewline
135 & 42 & 232.210526315789 & -190.210526315789 \tabularnewline
136 & 528 & 232.210526315789 & 295.789473684211 \tabularnewline
137 & 0 & 232.210526315789 & -232.210526315789 \tabularnewline
138 & 1122 & 1029.82352941176 & 92.1764705882354 \tabularnewline
139 & 1305 & 1029.82352941176 & 275.176470588235 \tabularnewline
140 & 81 & 232.210526315789 & -151.210526315789 \tabularnewline
141 & 262 & 232.210526315789 & 29.7894736842105 \tabularnewline
142 & 1165 & 1029.82352941176 & 135.176470588235 \tabularnewline
143 & 1405 & 1420.11538461538 & -15.1153846153845 \tabularnewline
144 & 1409 & 1831.42857142857 & -422.428571428571 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=160168&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]1845[/C][C]1831.42857142857[/C][C]13.5714285714287[/C][/ROW]
[ROW][C]2[/C][C]1917[/C][C]1831.42857142857[/C][C]85.5714285714287[/C][/ROW]
[ROW][C]3[/C][C]192[/C][C]232.210526315789[/C][C]-40.2105263157895[/C][/ROW]
[ROW][C]4[/C][C]2665[/C][C]2457.3125[/C][C]207.6875[/C][/ROW]
[ROW][C]5[/C][C]3709[/C][C]3702.5[/C][C]6.5[/C][/ROW]
[ROW][C]6[/C][C]7138[/C][C]3702.5[/C][C]3435.5[/C][/ROW]
[ROW][C]7[/C][C]1888[/C][C]1831.42857142857[/C][C]56.5714285714287[/C][/ROW]
[ROW][C]8[/C][C]1909[/C][C]1831.42857142857[/C][C]77.5714285714287[/C][/ROW]
[ROW][C]9[/C][C]2140[/C][C]1831.42857142857[/C][C]308.571428571429[/C][/ROW]
[ROW][C]10[/C][C]3168[/C][C]3702.5[/C][C]-534.5[/C][/ROW]
[ROW][C]11[/C][C]1957[/C][C]1831.42857142857[/C][C]125.571428571429[/C][/ROW]
[ROW][C]12[/C][C]2370[/C][C]2457.3125[/C][C]-87.3125[/C][/ROW]
[ROW][C]13[/C][C]1998[/C][C]2457.3125[/C][C]-459.3125[/C][/ROW]
[ROW][C]14[/C][C]3203[/C][C]3702.5[/C][C]-499.5[/C][/ROW]
[ROW][C]15[/C][C]1505[/C][C]1420.11538461538[/C][C]84.8846153846155[/C][/ROW]
[ROW][C]16[/C][C]1574[/C][C]1420.11538461538[/C][C]153.884615384615[/C][/ROW]
[ROW][C]17[/C][C]1965[/C][C]1420.11538461538[/C][C]544.884615384615[/C][/ROW]
[ROW][C]18[/C][C]1314[/C][C]1196.14285714286[/C][C]117.857142857143[/C][/ROW]
[ROW][C]19[/C][C]2921[/C][C]2457.3125[/C][C]463.6875[/C][/ROW]
[ROW][C]20[/C][C]823[/C][C]1029.82352941176[/C][C]-206.823529411765[/C][/ROW]
[ROW][C]21[/C][C]1289[/C][C]1196.14285714286[/C][C]92.8571428571429[/C][/ROW]
[ROW][C]22[/C][C]2818[/C][C]2457.3125[/C][C]360.6875[/C][/ROW]
[ROW][C]23[/C][C]1792[/C][C]1831.42857142857[/C][C]-39.4285714285713[/C][/ROW]
[ROW][C]24[/C][C]2474[/C][C]2457.3125[/C][C]16.6875[/C][/ROW]
[ROW][C]25[/C][C]1994[/C][C]1831.42857142857[/C][C]162.571428571429[/C][/ROW]
[ROW][C]26[/C][C]1806[/C][C]1831.42857142857[/C][C]-25.4285714285713[/C][/ROW]
[ROW][C]27[/C][C]2177[/C][C]2457.3125[/C][C]-280.3125[/C][/ROW]
[ROW][C]28[/C][C]1458[/C][C]1420.11538461538[/C][C]37.8846153846155[/C][/ROW]
[ROW][C]29[/C][C]3057[/C][C]3702.5[/C][C]-645.5[/C][/ROW]
[ROW][C]30[/C][C]2487[/C][C]3702.5[/C][C]-1215.5[/C][/ROW]
[ROW][C]31[/C][C]1914[/C][C]1831.42857142857[/C][C]82.5714285714287[/C][/ROW]
[ROW][C]32[/C][C]1825[/C][C]1831.42857142857[/C][C]-6.42857142857133[/C][/ROW]
[ROW][C]33[/C][C]2509[/C][C]2457.3125[/C][C]51.6875[/C][/ROW]
[ROW][C]34[/C][C]3634[/C][C]3702.5[/C][C]-68.5[/C][/ROW]
[ROW][C]35[/C][C]2608[/C][C]2457.3125[/C][C]150.6875[/C][/ROW]
[ROW][C]36[/C][C]1[/C][C]232.210526315789[/C][C]-231.210526315789[/C][/ROW]
[ROW][C]37[/C][C]2157[/C][C]2457.3125[/C][C]-300.3125[/C][/ROW]
[ROW][C]38[/C][C]1978[/C][C]1831.42857142857[/C][C]146.571428571429[/C][/ROW]
[ROW][C]39[/C][C]2224[/C][C]2057.14285714286[/C][C]166.857142857143[/C][/ROW]
[ROW][C]40[/C][C]2215[/C][C]2457.3125[/C][C]-242.3125[/C][/ROW]
[ROW][C]41[/C][C]2538[/C][C]2457.3125[/C][C]80.6875[/C][/ROW]
[ROW][C]42[/C][C]1881[/C][C]2457.3125[/C][C]-576.3125[/C][/ROW]
[ROW][C]43[/C][C]1113[/C][C]1196.14285714286[/C][C]-83.1428571428571[/C][/ROW]
[ROW][C]44[/C][C]2380[/C][C]2457.3125[/C][C]-77.3125[/C][/ROW]
[ROW][C]45[/C][C]1365[/C][C]1420.11538461538[/C][C]-55.1153846153845[/C][/ROW]
[ROW][C]46[/C][C]1294[/C][C]1420.11538461538[/C][C]-126.115384615385[/C][/ROW]
[ROW][C]47[/C][C]756[/C][C]1029.82352941176[/C][C]-273.823529411765[/C][/ROW]
[ROW][C]48[/C][C]2465[/C][C]2457.3125[/C][C]7.6875[/C][/ROW]
[ROW][C]49[/C][C]2327[/C][C]2457.3125[/C][C]-130.3125[/C][/ROW]
[ROW][C]50[/C][C]2787[/C][C]2457.3125[/C][C]329.6875[/C][/ROW]
[ROW][C]51[/C][C]658[/C][C]232.210526315789[/C][C]425.789473684211[/C][/ROW]
[ROW][C]52[/C][C]2013[/C][C]1831.42857142857[/C][C]181.571428571429[/C][/ROW]
[ROW][C]53[/C][C]2666[/C][C]2457.3125[/C][C]208.6875[/C][/ROW]
[ROW][C]54[/C][C]2086[/C][C]2457.3125[/C][C]-371.3125[/C][/ROW]
[ROW][C]55[/C][C]2067[/C][C]2457.3125[/C][C]-390.3125[/C][/ROW]
[ROW][C]56[/C][C]1776[/C][C]2057.14285714286[/C][C]-281.142857142857[/C][/ROW]
[ROW][C]57[/C][C]2045[/C][C]1831.42857142857[/C][C]213.571428571429[/C][/ROW]
[ROW][C]58[/C][C]1047[/C][C]1029.82352941176[/C][C]17.1764705882354[/C][/ROW]
[ROW][C]59[/C][C]1190[/C][C]1420.11538461538[/C][C]-230.115384615385[/C][/ROW]
[ROW][C]60[/C][C]2932[/C][C]2457.3125[/C][C]474.6875[/C][/ROW]
[ROW][C]61[/C][C]1868[/C][C]2057.14285714286[/C][C]-189.142857142857[/C][/ROW]
[ROW][C]62[/C][C]2316[/C][C]2457.3125[/C][C]-141.3125[/C][/ROW]
[ROW][C]63[/C][C]1392[/C][C]1420.11538461538[/C][C]-28.1153846153845[/C][/ROW]
[ROW][C]64[/C][C]1355[/C][C]1420.11538461538[/C][C]-65.1153846153845[/C][/ROW]
[ROW][C]65[/C][C]1326[/C][C]1196.14285714286[/C][C]129.857142857143[/C][/ROW]
[ROW][C]66[/C][C]1587[/C][C]1420.11538461538[/C][C]166.884615384615[/C][/ROW]
[ROW][C]67[/C][C]2336[/C][C]2057.14285714286[/C][C]278.857142857143[/C][/ROW]
[ROW][C]68[/C][C]2898[/C][C]2457.3125[/C][C]440.6875[/C][/ROW]
[ROW][C]69[/C][C]1118[/C][C]1029.82352941176[/C][C]88.1764705882354[/C][/ROW]
[ROW][C]70[/C][C]340[/C][C]232.210526315789[/C][C]107.789473684211[/C][/ROW]
[ROW][C]71[/C][C]3224[/C][C]3702.5[/C][C]-478.5[/C][/ROW]
[ROW][C]72[/C][C]1552[/C][C]1831.42857142857[/C][C]-279.428571428571[/C][/ROW]
[ROW][C]73[/C][C]1551[/C][C]1831.42857142857[/C][C]-280.428571428571[/C][/ROW]
[ROW][C]74[/C][C]1794[/C][C]1831.42857142857[/C][C]-37.4285714285713[/C][/ROW]
[ROW][C]75[/C][C]2728[/C][C]2457.3125[/C][C]270.6875[/C][/ROW]
[ROW][C]76[/C][C]1580[/C][C]1420.11538461538[/C][C]159.884615384615[/C][/ROW]
[ROW][C]77[/C][C]2414[/C][C]2457.3125[/C][C]-43.3125[/C][/ROW]
[ROW][C]78[/C][C]2640[/C][C]2457.3125[/C][C]182.6875[/C][/ROW]
[ROW][C]79[/C][C]1203[/C][C]1196.14285714286[/C][C]6.85714285714289[/C][/ROW]
[ROW][C]80[/C][C]1313[/C][C]1420.11538461538[/C][C]-107.115384615385[/C][/ROW]
[ROW][C]81[/C][C]1207[/C][C]1029.82352941176[/C][C]177.176470588235[/C][/ROW]
[ROW][C]82[/C][C]2246[/C][C]2457.3125[/C][C]-211.3125[/C][/ROW]
[ROW][C]83[/C][C]1076[/C][C]1029.82352941176[/C][C]46.1764705882354[/C][/ROW]
[ROW][C]84[/C][C]1638[/C][C]1831.42857142857[/C][C]-193.428571428571[/C][/ROW]
[ROW][C]85[/C][C]1208[/C][C]1420.11538461538[/C][C]-212.115384615385[/C][/ROW]
[ROW][C]86[/C][C]1868[/C][C]1831.42857142857[/C][C]36.5714285714287[/C][/ROW]
[ROW][C]87[/C][C]2829[/C][C]2457.3125[/C][C]371.6875[/C][/ROW]
[ROW][C]88[/C][C]1209[/C][C]1029.82352941176[/C][C]179.176470588235[/C][/ROW]
[ROW][C]89[/C][C]1463[/C][C]1420.11538461538[/C][C]42.8846153846155[/C][/ROW]
[ROW][C]90[/C][C]1610[/C][C]1831.42857142857[/C][C]-221.428571428571[/C][/ROW]
[ROW][C]91[/C][C]1865[/C][C]2057.14285714286[/C][C]-192.142857142857[/C][/ROW]
[ROW][C]92[/C][C]2444[/C][C]2457.3125[/C][C]-13.3125[/C][/ROW]
[ROW][C]93[/C][C]1253[/C][C]1420.11538461538[/C][C]-167.115384615385[/C][/ROW]
[ROW][C]94[/C][C]1468[/C][C]1831.42857142857[/C][C]-363.428571428571[/C][/ROW]
[ROW][C]95[/C][C]979[/C][C]1196.14285714286[/C][C]-217.142857142857[/C][/ROW]
[ROW][C]96[/C][C]2365[/C][C]2457.3125[/C][C]-92.3125[/C][/ROW]
[ROW][C]97[/C][C]1890[/C][C]1831.42857142857[/C][C]58.5714285714287[/C][/ROW]
[ROW][C]98[/C][C]223[/C][C]232.210526315789[/C][C]-9.21052631578948[/C][/ROW]
[ROW][C]99[/C][C]2527[/C][C]2457.3125[/C][C]69.6875[/C][/ROW]
[ROW][C]100[/C][C]2186[/C][C]2457.3125[/C][C]-271.3125[/C][/ROW]
[ROW][C]101[/C][C]778[/C][C]1029.82352941176[/C][C]-251.823529411765[/C][/ROW]
[ROW][C]102[/C][C]1194[/C][C]1420.11538461538[/C][C]-226.115384615385[/C][/ROW]
[ROW][C]103[/C][C]1424[/C][C]1420.11538461538[/C][C]3.88461538461547[/C][/ROW]
[ROW][C]104[/C][C]1386[/C][C]1420.11538461538[/C][C]-34.1153846153845[/C][/ROW]
[ROW][C]105[/C][C]839[/C][C]1029.82352941176[/C][C]-190.823529411765[/C][/ROW]
[ROW][C]106[/C][C]596[/C][C]232.210526315789[/C][C]363.789473684211[/C][/ROW]
[ROW][C]107[/C][C]1684[/C][C]1420.11538461538[/C][C]263.884615384615[/C][/ROW]
[ROW][C]108[/C][C]1168[/C][C]1029.82352941176[/C][C]138.176470588235[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]232.210526315789[/C][C]-232.210526315789[/C][/ROW]
[ROW][C]110[/C][C]1315[/C][C]1420.11538461538[/C][C]-105.115384615385[/C][/ROW]
[ROW][C]111[/C][C]1149[/C][C]1196.14285714286[/C][C]-47.1428571428571[/C][/ROW]
[ROW][C]112[/C][C]1485[/C][C]1420.11538461538[/C][C]64.8846153846155[/C][/ROW]
[ROW][C]113[/C][C]1529[/C][C]1420.11538461538[/C][C]108.884615384615[/C][/ROW]
[ROW][C]114[/C][C]962[/C][C]1029.82352941176[/C][C]-67.8235294117646[/C][/ROW]
[ROW][C]115[/C][C]78[/C][C]232.210526315789[/C][C]-154.210526315789[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]232.210526315789[/C][C]-232.210526315789[/C][/ROW]
[ROW][C]117[/C][C]1295[/C][C]1420.11538461538[/C][C]-125.115384615385[/C][/ROW]
[ROW][C]118[/C][C]1751[/C][C]1831.42857142857[/C][C]-80.4285714285713[/C][/ROW]
[ROW][C]119[/C][C]2142[/C][C]1831.42857142857[/C][C]310.571428571429[/C][/ROW]
[ROW][C]120[/C][C]1070[/C][C]1029.82352941176[/C][C]40.1764705882354[/C][/ROW]
[ROW][C]121[/C][C]778[/C][C]1029.82352941176[/C][C]-251.823529411765[/C][/ROW]
[ROW][C]122[/C][C]1986[/C][C]1831.42857142857[/C][C]154.571428571429[/C][/ROW]
[ROW][C]123[/C][C]1084[/C][C]1029.82352941176[/C][C]54.1764705882354[/C][/ROW]
[ROW][C]124[/C][C]2400[/C][C]2057.14285714286[/C][C]342.857142857143[/C][/ROW]
[ROW][C]125[/C][C]731[/C][C]232.210526315789[/C][C]498.789473684211[/C][/ROW]
[ROW][C]126[/C][C]285[/C][C]232.210526315789[/C][C]52.7894736842105[/C][/ROW]
[ROW][C]127[/C][C]1873[/C][C]1831.42857142857[/C][C]41.5714285714287[/C][/ROW]
[ROW][C]128[/C][C]1269[/C][C]1420.11538461538[/C][C]-151.115384615385[/C][/ROW]
[ROW][C]129[/C][C]1725[/C][C]1831.42857142857[/C][C]-106.428571428571[/C][/ROW]
[ROW][C]130[/C][C]256[/C][C]232.210526315789[/C][C]23.7894736842105[/C][/ROW]
[ROW][C]131[/C][C]98[/C][C]232.210526315789[/C][C]-134.210526315789[/C][/ROW]
[ROW][C]132[/C][C]1435[/C][C]1420.11538461538[/C][C]14.8846153846155[/C][/ROW]
[ROW][C]133[/C][C]41[/C][C]232.210526315789[/C][C]-191.210526315789[/C][/ROW]
[ROW][C]134[/C][C]1931[/C][C]2057.14285714286[/C][C]-126.142857142857[/C][/ROW]
[ROW][C]135[/C][C]42[/C][C]232.210526315789[/C][C]-190.210526315789[/C][/ROW]
[ROW][C]136[/C][C]528[/C][C]232.210526315789[/C][C]295.789473684211[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]232.210526315789[/C][C]-232.210526315789[/C][/ROW]
[ROW][C]138[/C][C]1122[/C][C]1029.82352941176[/C][C]92.1764705882354[/C][/ROW]
[ROW][C]139[/C][C]1305[/C][C]1029.82352941176[/C][C]275.176470588235[/C][/ROW]
[ROW][C]140[/C][C]81[/C][C]232.210526315789[/C][C]-151.210526315789[/C][/ROW]
[ROW][C]141[/C][C]262[/C][C]232.210526315789[/C][C]29.7894736842105[/C][/ROW]
[ROW][C]142[/C][C]1165[/C][C]1029.82352941176[/C][C]135.176470588235[/C][/ROW]
[ROW][C]143[/C][C]1405[/C][C]1420.11538461538[/C][C]-15.1153846153845[/C][/ROW]
[ROW][C]144[/C][C]1409[/C][C]1831.42857142857[/C][C]-422.428571428571[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=160168&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=160168&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
118451831.4285714285713.5714285714287
219171831.4285714285785.5714285714287
3192232.210526315789-40.2105263157895
426652457.3125207.6875
537093702.56.5
671383702.53435.5
718881831.4285714285756.5714285714287
819091831.4285714285777.5714285714287
921401831.42857142857308.571428571429
1031683702.5-534.5
1119571831.42857142857125.571428571429
1223702457.3125-87.3125
1319982457.3125-459.3125
1432033702.5-499.5
1515051420.1153846153884.8846153846155
1615741420.11538461538153.884615384615
1719651420.11538461538544.884615384615
1813141196.14285714286117.857142857143
1929212457.3125463.6875
208231029.82352941176-206.823529411765
2112891196.1428571428692.8571428571429
2228182457.3125360.6875
2317921831.42857142857-39.4285714285713
2424742457.312516.6875
2519941831.42857142857162.571428571429
2618061831.42857142857-25.4285714285713
2721772457.3125-280.3125
2814581420.1153846153837.8846153846155
2930573702.5-645.5
3024873702.5-1215.5
3119141831.4285714285782.5714285714287
3218251831.42857142857-6.42857142857133
3325092457.312551.6875
3436343702.5-68.5
3526082457.3125150.6875
361232.210526315789-231.210526315789
3721572457.3125-300.3125
3819781831.42857142857146.571428571429
3922242057.14285714286166.857142857143
4022152457.3125-242.3125
4125382457.312580.6875
4218812457.3125-576.3125
4311131196.14285714286-83.1428571428571
4423802457.3125-77.3125
4513651420.11538461538-55.1153846153845
4612941420.11538461538-126.115384615385
477561029.82352941176-273.823529411765
4824652457.31257.6875
4923272457.3125-130.3125
5027872457.3125329.6875
51658232.210526315789425.789473684211
5220131831.42857142857181.571428571429
5326662457.3125208.6875
5420862457.3125-371.3125
5520672457.3125-390.3125
5617762057.14285714286-281.142857142857
5720451831.42857142857213.571428571429
5810471029.8235294117617.1764705882354
5911901420.11538461538-230.115384615385
6029322457.3125474.6875
6118682057.14285714286-189.142857142857
6223162457.3125-141.3125
6313921420.11538461538-28.1153846153845
6413551420.11538461538-65.1153846153845
6513261196.14285714286129.857142857143
6615871420.11538461538166.884615384615
6723362057.14285714286278.857142857143
6828982457.3125440.6875
6911181029.8235294117688.1764705882354
70340232.210526315789107.789473684211
7132243702.5-478.5
7215521831.42857142857-279.428571428571
7315511831.42857142857-280.428571428571
7417941831.42857142857-37.4285714285713
7527282457.3125270.6875
7615801420.11538461538159.884615384615
7724142457.3125-43.3125
7826402457.3125182.6875
7912031196.142857142866.85714285714289
8013131420.11538461538-107.115384615385
8112071029.82352941176177.176470588235
8222462457.3125-211.3125
8310761029.8235294117646.1764705882354
8416381831.42857142857-193.428571428571
8512081420.11538461538-212.115384615385
8618681831.4285714285736.5714285714287
8728292457.3125371.6875
8812091029.82352941176179.176470588235
8914631420.1153846153842.8846153846155
9016101831.42857142857-221.428571428571
9118652057.14285714286-192.142857142857
9224442457.3125-13.3125
9312531420.11538461538-167.115384615385
9414681831.42857142857-363.428571428571
959791196.14285714286-217.142857142857
9623652457.3125-92.3125
9718901831.4285714285758.5714285714287
98223232.210526315789-9.21052631578948
9925272457.312569.6875
10021862457.3125-271.3125
1017781029.82352941176-251.823529411765
10211941420.11538461538-226.115384615385
10314241420.115384615383.88461538461547
10413861420.11538461538-34.1153846153845
1058391029.82352941176-190.823529411765
106596232.210526315789363.789473684211
10716841420.11538461538263.884615384615
10811681029.82352941176138.176470588235
1090232.210526315789-232.210526315789
11013151420.11538461538-105.115384615385
11111491196.14285714286-47.1428571428571
11214851420.1153846153864.8846153846155
11315291420.11538461538108.884615384615
1149621029.82352941176-67.8235294117646
11578232.210526315789-154.210526315789
1160232.210526315789-232.210526315789
11712951420.11538461538-125.115384615385
11817511831.42857142857-80.4285714285713
11921421831.42857142857310.571428571429
12010701029.8235294117640.1764705882354
1217781029.82352941176-251.823529411765
12219861831.42857142857154.571428571429
12310841029.8235294117654.1764705882354
12424002057.14285714286342.857142857143
125731232.210526315789498.789473684211
126285232.21052631578952.7894736842105
12718731831.4285714285741.5714285714287
12812691420.11538461538-151.115384615385
12917251831.42857142857-106.428571428571
130256232.21052631578923.7894736842105
13198232.210526315789-134.210526315789
13214351420.1153846153814.8846153846155
13341232.210526315789-191.210526315789
13419312057.14285714286-126.142857142857
13542232.210526315789-190.210526315789
136528232.210526315789295.789473684211
1370232.210526315789-232.210526315789
13811221029.8235294117692.1764705882354
13913051029.82352941176275.176470588235
14081232.210526315789-151.210526315789
141262232.21052631578929.7894736842105
14211651029.82352941176135.176470588235
14314051420.11538461538-15.1153846153845
14414091831.42857142857-422.428571428571



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