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 computationSun, 18 Dec 2011 11:11:40 -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/18/t132422473384yq54wus2rj3us.htm/, Retrieved Sun, 05 May 2024 17:35:05 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=157035, Retrieved Sun, 05 May 2024 17:35:05 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact79
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [] [2010-12-05 18:59:57] [b98453cac15ba1066b407e146608df68]
- R PD    [Recursive Partitioning (Regression Trees)] [Regression Trees HoF] [2011-12-18 16:11:40] [4352eab26b4a512b718de67a19830b91] [Current]
Feedback Forum

Post a new message
Dataseries X:
1738	157382	86	563	109	0	48	18	20465
1446	168465	52	426	74	1	45	20	33629
192	7215	18	72	1	0	0	0	1423
2181	122259	91	618	154	0	49	26	25629
3335	221399	129	1118	124	0	76	30	54002
6406	454489	242	1788	278	1	118	36	151036
1479	134379	53	498	89	1	42	23	33287
1410	150416	54	384	54	0	62	30	31172
1591	121391	41	468	87	0	48	30	28113
2811	275326	91	919	129	1	67	26	57803
1932	121593	72	629	158	2	50	24	49830
1967	172071	64	611	113	0	71	30	52143
1621	86249	94	574	83	0	41	21	21055
2933	201902	100	987	255	4	77	25	47007
1332	144113	50	384	50	4	45	17	28735
1502	144677	77	452	81	3	54	19	59147
1636	134153	52	391	92	0	75	33	78950
1076	64149	52	305	72	5	0	15	13497
2376	122294	82	721	142	0	54	34	46154
710	27918	24	215	49	0	13	18	53249
902	52197	52	310	40	0	16	15	10726
2332	191463	90	697	94	0	78	27	83700
1647	176034	68	597	127	0	35	25	40400
1876	98629	49	560	164	1	38	34	33797
1800	143546	81	569	41	1	50	21	36205
1385	139780	25	513	160	0	39	21	30165
1913	174181	149	616	90	0	58	25	58534
1243	163773	79	311	55	0	70	28	44663
2483	312831	111	810	84	0	55	28	92556
1953	184024	41	815	90	0	52	20	40078
1514	151621	41	427	76	0	50	28	34711
1488	164516	42	496	111	2	54	20	31076
2073	120414	95	661	87	4	53	17	74608
2874	214975	117	861	302	0	76	25	58092
2248	200609	48	742	84	1	54	24	42009
1	0	1	0	0	0	0	0	0
1888	191923	58	890	58	0	46	27	36022
1563	93107	49	483	137	3	44	14	23333
2054	129419	45	495	267	9	35	32	53349
2053	233497	61	760	60	0	82	31	92596
1950	178228	67	628	94	2	73	21	49598
1572	126602	53	597	62	0	31	34	44093
957	94332	29	350	35	2	25	23	84205
1974	164183	75	742	59	1	57	24	63369
1036	95704	42	322	46	2	44	22	60132
1105	139901	85	282	40	2	40	22	37403
744	81293	31	212	49	1	23	35	24460
1926	189007	87	651	114	0	63	21	46456
1853	173779	80	588	113	1	43	31	66616
2445	146552	55	875	171	7	62	26	41554
658	48188	28	205	37	0	12	22	22346
1489	113870	61	381	51	0	67	21	30874
2276	266451	68	769	89	0	60	27	68701
1955	229437	77	664	67	0	55	26	35728
1630	174876	54	584	49	1	53	33	29010
1506	119070	50	465	74	6	35	11	23110
1720	186704	60	456	58	0	50	26	38844
852	72559	22	251	72	0	25	26	27084
917	111940	59	315	32	0	47	23	35139
2614	166226	86	880	59	10	30	38	57476
1558	130414	52	454	65	6	50	29	33277
1792	102141	71	673	81	0	36	19	31141
1271	115753	58	348	84	11	43	19	61281
1135	102194	33	384	46	3	44	24	25820
1169	148531	32	395	56	0	25	26	23284
1229	94982	37	391	36	0	38	29	35378
2226	178613	67	483	86	8	68	36	74990
2752	128907	65	843	152	2	83	25	29653
1007	102378	36	248	48	0	48	24	64622
340	31970	15	101	40	0	5	21	4157
2606	204812	108	910	135	3	53	19	29245
1159	104972	61	352	80	1	36	12	50008
1264	95276	62	410	60	2	62	28	52338
1516	101560	65	442	89	1	46	21	13310
2474	144193	60	627	89	0	67	34	92901
1288	71921	37	345	79	2	2	32	10956
1911	126905	54	538	111	1	64	27	34241
2337	140303	89	756	69	0	59	28	75043
816	60138	23	253	76	0	16	21	21152
1234	84971	71	395	105	0	34	31	42249
907	80420	64	211	49	0	54	26	42005
1912	244190	58	712	60	0	39	29	41152
842	56252	26	244	49	0	26	23	14399
1309	97181	32	438	132	0	37	25	28263
770	50913	42	256	49	0	17	22	17215
1567	143910	46	496	71	0	32	26	48140
2543	218900	217	624	100	0	55	33	62897
1095	90772	96	263	71	0	50	22	22883
1154	90385	54	360	49	6	39	24	41622
1324	136220	48	518	72	0	30	21	40715
1509	115572	37	535	59	5	45	28	65897
2014	139075	69	587	87	1	66	23	76542
1216	148950	56	407	68	0	39	25	37477
1265	124626	57	466	81	0	27	15	53216
762	49176	34	291	30	0	22	13	40911
2178	215480	104	694	166	0	45	36	57021
1752	182328	61	526	94	0	95	24	73116
223	19349	12	67	15	0	13	1	3895
2117	183873	95	726	104	3	26	24	46609
1888	146020	71	771	61	0	40	31	29351
619	51201	27	263	11	0	13	4	2325
802	58280	20	240	44	0	41	20	31747
1131	115944	44	360	84	0	51	23	32665
982	94341	53	249	66	1	24	23	19249
709	72904	37	190	27	0	30	12	15292
596	27676	22	194	59	0	2	16	5842
1302	125728	42	298	127	0	78	29	33994
868	89920	31	229	32	0	12	10	13018
0	0	0	0	0	0	0	0	0
1030	85610	31	306	58	0	46	25	98177
1116	106742	65	366	57	0	25	21	37941
1237	126825	42	412	59	0	49	23	31032
1214	109807	56	372	65	0	52	21	32683
849	71894	57	287	71	0	36	21	34545
78	3616	5	14	5	0	0	0	0
0	0	0	0	0	0	0	0	0
924	154806	38	301	70	0	35	23	27525
1495	136333	75	539	72	0	68	29	66856
1898	147766	92	535	119	1	26	28	28549
912	113245	37	287	56	0	36	23	38610
778	43410	19	292	63	0	7	1	2781
1567	152455	65	474	88	1	67	25	41211
890	88874	39	241	46	0	30	17	22698
1705	111924	49	497	60	8	55	29	41194
700	60373	39	165	29	3	3	12	32689
285	19764	12	75	19	1	10	2	5752
1528	125760	49	471	61	2	46	20	26757
982	108685	27	341	66	0	23	25	22527
1496	141868	38	497	97	0	48	29	44810
256	11796	9	79	22	0	1	2	0
98	10674	9	33	7	0	0	0	0
1317	131263	52	449	37	0	33	18	100674
41	6836	3	11	5	0	0	1	0
1769	153278	56	606	48	5	48	21	57786
42	5118	3	6	1	0	5	0	0
528	40248	16	183	34	1	8	4	5444
0	0	0	0	0	0	0	0	0
946	100798	43	312	49	0	25	25	28470
1252	84315	36	248	44	0	21	26	61849
81	7131	4	27	0	1	0	0	0
257	8812	13	97	18	0	0	4	2179
892	63952	23	247	48	1	15	17	8019
1114	120111	47	273	54	0	47	21	39644
1079	94127	18	386	50	1	17	22	23494




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=157035&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.8662
R-squared0.7504
RMSE33926.7564

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8662[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7504[/C][/ROW]
[ROW][C]RMSE[/C][C]33926.7564[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=157035&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=157035&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.8662
R-squared0.7504
RMSE33926.7564







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1157382139524.97517857.025
2168465139524.97528940.025
3721511776.7647058824-4561.76470588235
4122259170465.952380952-48206.9523809524
5221399231645.461538462-10246.4615384615
6454489231645.461538462222843.538461538
7134379139524.975-5145.97500000001
8150416139524.97510891.025
9121391139524.975-18133.975
10275326231645.46153846243680.5384615385
11121593170465.952380952-48872.9523809524
12172071170465.9523809521605.04761904763
1386249139524.975-53275.975
14201902231645.461538462-29743.4615384615
15144113139524.9754588.02499999999
16144677139524.9755152.02499999999
17134153139524.975-5371.97500000001
1864149108346.323529412-44197.3235294118
19122294170465.952380952-48171.9523809524
202791862098-34180
215219762098-9901
22191463170465.95238095220997.0476190476
23176034139524.97536509.025
2498629139524.975-40895.975
25143546139524.9754021.02499999999
26139780139524.975255.024999999994
27174181170465.9523809523715.04761904763
28163773108346.32352941255426.6764705882
29312831231645.46153846281185.5384615385
30184024231645.461538462-47621.4615384615
31151621139524.97512096.025
32164516139524.97524991.025
33120414170465.952380952-50051.9523809524
34214975231645.461538462-16670.4615384615
35200609170465.95238095230143.0476190476
36011776.7647058824-11776.7647058824
37191923139524.97552398.025
3893107139524.975-46417.975
39129419170465.952380952-41046.9523809524
40233497231645.4615384621851.53846153847
41178228170465.9523809527762.04761904763
42126602139524.975-12922.975
4394332108346.323529412-14014.3235294118
44164183170465.952380952-6282.95238095237
4595704108346.323529412-12642.3235294118
46139901108346.32352941231554.6764705882
47812936209819195
48189007170465.95238095218541.0476190476
49173779139524.97534254.025
50146552231645.461538462-85093.4615384615
514818862098-13910
52113870139524.975-25654.975
53266451231645.46153846234805.5384615385
54229437170465.95238095258971.0476190476
55174876139524.97535351.025
56119070139524.975-20454.975
57186704139524.97547179.025
58725596209810461
59111940108346.3235294123593.67647058824
60166226231645.461538462-65419.4615384615
61130414139524.975-9110.97500000001
62102141139524.975-37383.975
63115753108346.3235294127406.67647058824
64102194108346.323529412-6152.32352941176
65148531108346.32352941240184.6764705882
6694982108346.323529412-13364.3235294118
67178613170465.9523809528147.04761904763
68128907231645.461538462-102738.461538462
69102378108346.323529412-5968.32352941176
703197011776.764705882420193.2352941176
71204812231645.461538462-26833.4615384615
72104972108346.323529412-3374.32352941176
7395276108346.323529412-13070.3235294118
74101560139524.975-37964.975
75144193170465.952380952-26272.9523809524
7671921108346.323529412-36425.3235294118
77126905139524.975-12619.975
78140303170465.952380952-30162.9523809524
796013862098-1960
8084971108346.323529412-23375.3235294118
81804206209818322
82244190170465.95238095273724.0476190476
835625262098-5846
8497181108346.323529412-11165.3235294118
855091362098-11185
86143910139524.9754385.02499999999
87218900170465.95238095248434.0476190476
8890772108346.323529412-17574.3235294118
8990385108346.323529412-17961.3235294118
90136220139524.975-3304.97500000001
91115572139524.975-23952.975
92139075170465.952380952-31390.9523809524
93148950108346.32352941240603.6764705882
94124626108346.32352941216279.6764705882
954917662098-12922
96215480170465.95238095245014.0476190476
97182328139524.97542803.025
981934911776.76470588247572.23529411765
99183873170465.95238095213407.0476190476
100146020139524.9756495.02499999999
1015120162098-10897
1025828062098-3818
103115944108346.3235294127597.67647058824
10494341108346.323529412-14005.3235294118
105729046209810806
1062767611776.764705882415899.2352941176
107125728108346.32352941217381.6764705882
108899206209827822
109011776.7647058824-11776.7647058824
11085610108346.323529412-22736.3235294118
111106742108346.323529412-1604.32352941176
112126825108346.32352941218478.6764705882
113109807108346.3235294121460.67647058824
11471894620989796
115361611776.7647058824-8160.76470588235
116011776.7647058824-11776.7647058824
117154806108346.32352941246459.6764705882
118136333139524.975-3191.97500000001
119147766139524.9758241.02499999999
120113245108346.3235294124898.67647058824
1214341062098-18688
122152455139524.97512930.025
123888746209826776
124111924139524.975-27600.975
1256037362098-1725
1261976411776.76470588247987.23529411765
127125760139524.975-13764.975
128108685108346.323529412338.676470588238
129141868139524.9752343.02499999999
1301179611776.764705882419.2352941176468
1311067411776.7647058824-1102.76470588235
132131263139524.975-8261.97500000001
133683611776.7647058824-4940.76470588235
134153278139524.97513753.025
135511811776.7647058824-6658.76470588235
1364024811776.764705882428471.2352941176
137011776.7647058824-11776.7647058824
138100798108346.323529412-7548.32352941176
13984315108346.323529412-24031.3235294118
140713111776.7647058824-4645.76470588235
141881211776.7647058824-2964.76470588235
14263952620981854
143120111108346.32352941211764.6764705882
14494127108346.323529412-14219.3235294118

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 157382 & 139524.975 & 17857.025 \tabularnewline
2 & 168465 & 139524.975 & 28940.025 \tabularnewline
3 & 7215 & 11776.7647058824 & -4561.76470588235 \tabularnewline
4 & 122259 & 170465.952380952 & -48206.9523809524 \tabularnewline
5 & 221399 & 231645.461538462 & -10246.4615384615 \tabularnewline
6 & 454489 & 231645.461538462 & 222843.538461538 \tabularnewline
7 & 134379 & 139524.975 & -5145.97500000001 \tabularnewline
8 & 150416 & 139524.975 & 10891.025 \tabularnewline
9 & 121391 & 139524.975 & -18133.975 \tabularnewline
10 & 275326 & 231645.461538462 & 43680.5384615385 \tabularnewline
11 & 121593 & 170465.952380952 & -48872.9523809524 \tabularnewline
12 & 172071 & 170465.952380952 & 1605.04761904763 \tabularnewline
13 & 86249 & 139524.975 & -53275.975 \tabularnewline
14 & 201902 & 231645.461538462 & -29743.4615384615 \tabularnewline
15 & 144113 & 139524.975 & 4588.02499999999 \tabularnewline
16 & 144677 & 139524.975 & 5152.02499999999 \tabularnewline
17 & 134153 & 139524.975 & -5371.97500000001 \tabularnewline
18 & 64149 & 108346.323529412 & -44197.3235294118 \tabularnewline
19 & 122294 & 170465.952380952 & -48171.9523809524 \tabularnewline
20 & 27918 & 62098 & -34180 \tabularnewline
21 & 52197 & 62098 & -9901 \tabularnewline
22 & 191463 & 170465.952380952 & 20997.0476190476 \tabularnewline
23 & 176034 & 139524.975 & 36509.025 \tabularnewline
24 & 98629 & 139524.975 & -40895.975 \tabularnewline
25 & 143546 & 139524.975 & 4021.02499999999 \tabularnewline
26 & 139780 & 139524.975 & 255.024999999994 \tabularnewline
27 & 174181 & 170465.952380952 & 3715.04761904763 \tabularnewline
28 & 163773 & 108346.323529412 & 55426.6764705882 \tabularnewline
29 & 312831 & 231645.461538462 & 81185.5384615385 \tabularnewline
30 & 184024 & 231645.461538462 & -47621.4615384615 \tabularnewline
31 & 151621 & 139524.975 & 12096.025 \tabularnewline
32 & 164516 & 139524.975 & 24991.025 \tabularnewline
33 & 120414 & 170465.952380952 & -50051.9523809524 \tabularnewline
34 & 214975 & 231645.461538462 & -16670.4615384615 \tabularnewline
35 & 200609 & 170465.952380952 & 30143.0476190476 \tabularnewline
36 & 0 & 11776.7647058824 & -11776.7647058824 \tabularnewline
37 & 191923 & 139524.975 & 52398.025 \tabularnewline
38 & 93107 & 139524.975 & -46417.975 \tabularnewline
39 & 129419 & 170465.952380952 & -41046.9523809524 \tabularnewline
40 & 233497 & 231645.461538462 & 1851.53846153847 \tabularnewline
41 & 178228 & 170465.952380952 & 7762.04761904763 \tabularnewline
42 & 126602 & 139524.975 & -12922.975 \tabularnewline
43 & 94332 & 108346.323529412 & -14014.3235294118 \tabularnewline
44 & 164183 & 170465.952380952 & -6282.95238095237 \tabularnewline
45 & 95704 & 108346.323529412 & -12642.3235294118 \tabularnewline
46 & 139901 & 108346.323529412 & 31554.6764705882 \tabularnewline
47 & 81293 & 62098 & 19195 \tabularnewline
48 & 189007 & 170465.952380952 & 18541.0476190476 \tabularnewline
49 & 173779 & 139524.975 & 34254.025 \tabularnewline
50 & 146552 & 231645.461538462 & -85093.4615384615 \tabularnewline
51 & 48188 & 62098 & -13910 \tabularnewline
52 & 113870 & 139524.975 & -25654.975 \tabularnewline
53 & 266451 & 231645.461538462 & 34805.5384615385 \tabularnewline
54 & 229437 & 170465.952380952 & 58971.0476190476 \tabularnewline
55 & 174876 & 139524.975 & 35351.025 \tabularnewline
56 & 119070 & 139524.975 & -20454.975 \tabularnewline
57 & 186704 & 139524.975 & 47179.025 \tabularnewline
58 & 72559 & 62098 & 10461 \tabularnewline
59 & 111940 & 108346.323529412 & 3593.67647058824 \tabularnewline
60 & 166226 & 231645.461538462 & -65419.4615384615 \tabularnewline
61 & 130414 & 139524.975 & -9110.97500000001 \tabularnewline
62 & 102141 & 139524.975 & -37383.975 \tabularnewline
63 & 115753 & 108346.323529412 & 7406.67647058824 \tabularnewline
64 & 102194 & 108346.323529412 & -6152.32352941176 \tabularnewline
65 & 148531 & 108346.323529412 & 40184.6764705882 \tabularnewline
66 & 94982 & 108346.323529412 & -13364.3235294118 \tabularnewline
67 & 178613 & 170465.952380952 & 8147.04761904763 \tabularnewline
68 & 128907 & 231645.461538462 & -102738.461538462 \tabularnewline
69 & 102378 & 108346.323529412 & -5968.32352941176 \tabularnewline
70 & 31970 & 11776.7647058824 & 20193.2352941176 \tabularnewline
71 & 204812 & 231645.461538462 & -26833.4615384615 \tabularnewline
72 & 104972 & 108346.323529412 & -3374.32352941176 \tabularnewline
73 & 95276 & 108346.323529412 & -13070.3235294118 \tabularnewline
74 & 101560 & 139524.975 & -37964.975 \tabularnewline
75 & 144193 & 170465.952380952 & -26272.9523809524 \tabularnewline
76 & 71921 & 108346.323529412 & -36425.3235294118 \tabularnewline
77 & 126905 & 139524.975 & -12619.975 \tabularnewline
78 & 140303 & 170465.952380952 & -30162.9523809524 \tabularnewline
79 & 60138 & 62098 & -1960 \tabularnewline
80 & 84971 & 108346.323529412 & -23375.3235294118 \tabularnewline
81 & 80420 & 62098 & 18322 \tabularnewline
82 & 244190 & 170465.952380952 & 73724.0476190476 \tabularnewline
83 & 56252 & 62098 & -5846 \tabularnewline
84 & 97181 & 108346.323529412 & -11165.3235294118 \tabularnewline
85 & 50913 & 62098 & -11185 \tabularnewline
86 & 143910 & 139524.975 & 4385.02499999999 \tabularnewline
87 & 218900 & 170465.952380952 & 48434.0476190476 \tabularnewline
88 & 90772 & 108346.323529412 & -17574.3235294118 \tabularnewline
89 & 90385 & 108346.323529412 & -17961.3235294118 \tabularnewline
90 & 136220 & 139524.975 & -3304.97500000001 \tabularnewline
91 & 115572 & 139524.975 & -23952.975 \tabularnewline
92 & 139075 & 170465.952380952 & -31390.9523809524 \tabularnewline
93 & 148950 & 108346.323529412 & 40603.6764705882 \tabularnewline
94 & 124626 & 108346.323529412 & 16279.6764705882 \tabularnewline
95 & 49176 & 62098 & -12922 \tabularnewline
96 & 215480 & 170465.952380952 & 45014.0476190476 \tabularnewline
97 & 182328 & 139524.975 & 42803.025 \tabularnewline
98 & 19349 & 11776.7647058824 & 7572.23529411765 \tabularnewline
99 & 183873 & 170465.952380952 & 13407.0476190476 \tabularnewline
100 & 146020 & 139524.975 & 6495.02499999999 \tabularnewline
101 & 51201 & 62098 & -10897 \tabularnewline
102 & 58280 & 62098 & -3818 \tabularnewline
103 & 115944 & 108346.323529412 & 7597.67647058824 \tabularnewline
104 & 94341 & 108346.323529412 & -14005.3235294118 \tabularnewline
105 & 72904 & 62098 & 10806 \tabularnewline
106 & 27676 & 11776.7647058824 & 15899.2352941176 \tabularnewline
107 & 125728 & 108346.323529412 & 17381.6764705882 \tabularnewline
108 & 89920 & 62098 & 27822 \tabularnewline
109 & 0 & 11776.7647058824 & -11776.7647058824 \tabularnewline
110 & 85610 & 108346.323529412 & -22736.3235294118 \tabularnewline
111 & 106742 & 108346.323529412 & -1604.32352941176 \tabularnewline
112 & 126825 & 108346.323529412 & 18478.6764705882 \tabularnewline
113 & 109807 & 108346.323529412 & 1460.67647058824 \tabularnewline
114 & 71894 & 62098 & 9796 \tabularnewline
115 & 3616 & 11776.7647058824 & -8160.76470588235 \tabularnewline
116 & 0 & 11776.7647058824 & -11776.7647058824 \tabularnewline
117 & 154806 & 108346.323529412 & 46459.6764705882 \tabularnewline
118 & 136333 & 139524.975 & -3191.97500000001 \tabularnewline
119 & 147766 & 139524.975 & 8241.02499999999 \tabularnewline
120 & 113245 & 108346.323529412 & 4898.67647058824 \tabularnewline
121 & 43410 & 62098 & -18688 \tabularnewline
122 & 152455 & 139524.975 & 12930.025 \tabularnewline
123 & 88874 & 62098 & 26776 \tabularnewline
124 & 111924 & 139524.975 & -27600.975 \tabularnewline
125 & 60373 & 62098 & -1725 \tabularnewline
126 & 19764 & 11776.7647058824 & 7987.23529411765 \tabularnewline
127 & 125760 & 139524.975 & -13764.975 \tabularnewline
128 & 108685 & 108346.323529412 & 338.676470588238 \tabularnewline
129 & 141868 & 139524.975 & 2343.02499999999 \tabularnewline
130 & 11796 & 11776.7647058824 & 19.2352941176468 \tabularnewline
131 & 10674 & 11776.7647058824 & -1102.76470588235 \tabularnewline
132 & 131263 & 139524.975 & -8261.97500000001 \tabularnewline
133 & 6836 & 11776.7647058824 & -4940.76470588235 \tabularnewline
134 & 153278 & 139524.975 & 13753.025 \tabularnewline
135 & 5118 & 11776.7647058824 & -6658.76470588235 \tabularnewline
136 & 40248 & 11776.7647058824 & 28471.2352941176 \tabularnewline
137 & 0 & 11776.7647058824 & -11776.7647058824 \tabularnewline
138 & 100798 & 108346.323529412 & -7548.32352941176 \tabularnewline
139 & 84315 & 108346.323529412 & -24031.3235294118 \tabularnewline
140 & 7131 & 11776.7647058824 & -4645.76470588235 \tabularnewline
141 & 8812 & 11776.7647058824 & -2964.76470588235 \tabularnewline
142 & 63952 & 62098 & 1854 \tabularnewline
143 & 120111 & 108346.323529412 & 11764.6764705882 \tabularnewline
144 & 94127 & 108346.323529412 & -14219.3235294118 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=157035&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]157382[/C][C]139524.975[/C][C]17857.025[/C][/ROW]
[ROW][C]2[/C][C]168465[/C][C]139524.975[/C][C]28940.025[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]11776.7647058824[/C][C]-4561.76470588235[/C][/ROW]
[ROW][C]4[/C][C]122259[/C][C]170465.952380952[/C][C]-48206.9523809524[/C][/ROW]
[ROW][C]5[/C][C]221399[/C][C]231645.461538462[/C][C]-10246.4615384615[/C][/ROW]
[ROW][C]6[/C][C]454489[/C][C]231645.461538462[/C][C]222843.538461538[/C][/ROW]
[ROW][C]7[/C][C]134379[/C][C]139524.975[/C][C]-5145.97500000001[/C][/ROW]
[ROW][C]8[/C][C]150416[/C][C]139524.975[/C][C]10891.025[/C][/ROW]
[ROW][C]9[/C][C]121391[/C][C]139524.975[/C][C]-18133.975[/C][/ROW]
[ROW][C]10[/C][C]275326[/C][C]231645.461538462[/C][C]43680.5384615385[/C][/ROW]
[ROW][C]11[/C][C]121593[/C][C]170465.952380952[/C][C]-48872.9523809524[/C][/ROW]
[ROW][C]12[/C][C]172071[/C][C]170465.952380952[/C][C]1605.04761904763[/C][/ROW]
[ROW][C]13[/C][C]86249[/C][C]139524.975[/C][C]-53275.975[/C][/ROW]
[ROW][C]14[/C][C]201902[/C][C]231645.461538462[/C][C]-29743.4615384615[/C][/ROW]
[ROW][C]15[/C][C]144113[/C][C]139524.975[/C][C]4588.02499999999[/C][/ROW]
[ROW][C]16[/C][C]144677[/C][C]139524.975[/C][C]5152.02499999999[/C][/ROW]
[ROW][C]17[/C][C]134153[/C][C]139524.975[/C][C]-5371.97500000001[/C][/ROW]
[ROW][C]18[/C][C]64149[/C][C]108346.323529412[/C][C]-44197.3235294118[/C][/ROW]
[ROW][C]19[/C][C]122294[/C][C]170465.952380952[/C][C]-48171.9523809524[/C][/ROW]
[ROW][C]20[/C][C]27918[/C][C]62098[/C][C]-34180[/C][/ROW]
[ROW][C]21[/C][C]52197[/C][C]62098[/C][C]-9901[/C][/ROW]
[ROW][C]22[/C][C]191463[/C][C]170465.952380952[/C][C]20997.0476190476[/C][/ROW]
[ROW][C]23[/C][C]176034[/C][C]139524.975[/C][C]36509.025[/C][/ROW]
[ROW][C]24[/C][C]98629[/C][C]139524.975[/C][C]-40895.975[/C][/ROW]
[ROW][C]25[/C][C]143546[/C][C]139524.975[/C][C]4021.02499999999[/C][/ROW]
[ROW][C]26[/C][C]139780[/C][C]139524.975[/C][C]255.024999999994[/C][/ROW]
[ROW][C]27[/C][C]174181[/C][C]170465.952380952[/C][C]3715.04761904763[/C][/ROW]
[ROW][C]28[/C][C]163773[/C][C]108346.323529412[/C][C]55426.6764705882[/C][/ROW]
[ROW][C]29[/C][C]312831[/C][C]231645.461538462[/C][C]81185.5384615385[/C][/ROW]
[ROW][C]30[/C][C]184024[/C][C]231645.461538462[/C][C]-47621.4615384615[/C][/ROW]
[ROW][C]31[/C][C]151621[/C][C]139524.975[/C][C]12096.025[/C][/ROW]
[ROW][C]32[/C][C]164516[/C][C]139524.975[/C][C]24991.025[/C][/ROW]
[ROW][C]33[/C][C]120414[/C][C]170465.952380952[/C][C]-50051.9523809524[/C][/ROW]
[ROW][C]34[/C][C]214975[/C][C]231645.461538462[/C][C]-16670.4615384615[/C][/ROW]
[ROW][C]35[/C][C]200609[/C][C]170465.952380952[/C][C]30143.0476190476[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]11776.7647058824[/C][C]-11776.7647058824[/C][/ROW]
[ROW][C]37[/C][C]191923[/C][C]139524.975[/C][C]52398.025[/C][/ROW]
[ROW][C]38[/C][C]93107[/C][C]139524.975[/C][C]-46417.975[/C][/ROW]
[ROW][C]39[/C][C]129419[/C][C]170465.952380952[/C][C]-41046.9523809524[/C][/ROW]
[ROW][C]40[/C][C]233497[/C][C]231645.461538462[/C][C]1851.53846153847[/C][/ROW]
[ROW][C]41[/C][C]178228[/C][C]170465.952380952[/C][C]7762.04761904763[/C][/ROW]
[ROW][C]42[/C][C]126602[/C][C]139524.975[/C][C]-12922.975[/C][/ROW]
[ROW][C]43[/C][C]94332[/C][C]108346.323529412[/C][C]-14014.3235294118[/C][/ROW]
[ROW][C]44[/C][C]164183[/C][C]170465.952380952[/C][C]-6282.95238095237[/C][/ROW]
[ROW][C]45[/C][C]95704[/C][C]108346.323529412[/C][C]-12642.3235294118[/C][/ROW]
[ROW][C]46[/C][C]139901[/C][C]108346.323529412[/C][C]31554.6764705882[/C][/ROW]
[ROW][C]47[/C][C]81293[/C][C]62098[/C][C]19195[/C][/ROW]
[ROW][C]48[/C][C]189007[/C][C]170465.952380952[/C][C]18541.0476190476[/C][/ROW]
[ROW][C]49[/C][C]173779[/C][C]139524.975[/C][C]34254.025[/C][/ROW]
[ROW][C]50[/C][C]146552[/C][C]231645.461538462[/C][C]-85093.4615384615[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]62098[/C][C]-13910[/C][/ROW]
[ROW][C]52[/C][C]113870[/C][C]139524.975[/C][C]-25654.975[/C][/ROW]
[ROW][C]53[/C][C]266451[/C][C]231645.461538462[/C][C]34805.5384615385[/C][/ROW]
[ROW][C]54[/C][C]229437[/C][C]170465.952380952[/C][C]58971.0476190476[/C][/ROW]
[ROW][C]55[/C][C]174876[/C][C]139524.975[/C][C]35351.025[/C][/ROW]
[ROW][C]56[/C][C]119070[/C][C]139524.975[/C][C]-20454.975[/C][/ROW]
[ROW][C]57[/C][C]186704[/C][C]139524.975[/C][C]47179.025[/C][/ROW]
[ROW][C]58[/C][C]72559[/C][C]62098[/C][C]10461[/C][/ROW]
[ROW][C]59[/C][C]111940[/C][C]108346.323529412[/C][C]3593.67647058824[/C][/ROW]
[ROW][C]60[/C][C]166226[/C][C]231645.461538462[/C][C]-65419.4615384615[/C][/ROW]
[ROW][C]61[/C][C]130414[/C][C]139524.975[/C][C]-9110.97500000001[/C][/ROW]
[ROW][C]62[/C][C]102141[/C][C]139524.975[/C][C]-37383.975[/C][/ROW]
[ROW][C]63[/C][C]115753[/C][C]108346.323529412[/C][C]7406.67647058824[/C][/ROW]
[ROW][C]64[/C][C]102194[/C][C]108346.323529412[/C][C]-6152.32352941176[/C][/ROW]
[ROW][C]65[/C][C]148531[/C][C]108346.323529412[/C][C]40184.6764705882[/C][/ROW]
[ROW][C]66[/C][C]94982[/C][C]108346.323529412[/C][C]-13364.3235294118[/C][/ROW]
[ROW][C]67[/C][C]178613[/C][C]170465.952380952[/C][C]8147.04761904763[/C][/ROW]
[ROW][C]68[/C][C]128907[/C][C]231645.461538462[/C][C]-102738.461538462[/C][/ROW]
[ROW][C]69[/C][C]102378[/C][C]108346.323529412[/C][C]-5968.32352941176[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]11776.7647058824[/C][C]20193.2352941176[/C][/ROW]
[ROW][C]71[/C][C]204812[/C][C]231645.461538462[/C][C]-26833.4615384615[/C][/ROW]
[ROW][C]72[/C][C]104972[/C][C]108346.323529412[/C][C]-3374.32352941176[/C][/ROW]
[ROW][C]73[/C][C]95276[/C][C]108346.323529412[/C][C]-13070.3235294118[/C][/ROW]
[ROW][C]74[/C][C]101560[/C][C]139524.975[/C][C]-37964.975[/C][/ROW]
[ROW][C]75[/C][C]144193[/C][C]170465.952380952[/C][C]-26272.9523809524[/C][/ROW]
[ROW][C]76[/C][C]71921[/C][C]108346.323529412[/C][C]-36425.3235294118[/C][/ROW]
[ROW][C]77[/C][C]126905[/C][C]139524.975[/C][C]-12619.975[/C][/ROW]
[ROW][C]78[/C][C]140303[/C][C]170465.952380952[/C][C]-30162.9523809524[/C][/ROW]
[ROW][C]79[/C][C]60138[/C][C]62098[/C][C]-1960[/C][/ROW]
[ROW][C]80[/C][C]84971[/C][C]108346.323529412[/C][C]-23375.3235294118[/C][/ROW]
[ROW][C]81[/C][C]80420[/C][C]62098[/C][C]18322[/C][/ROW]
[ROW][C]82[/C][C]244190[/C][C]170465.952380952[/C][C]73724.0476190476[/C][/ROW]
[ROW][C]83[/C][C]56252[/C][C]62098[/C][C]-5846[/C][/ROW]
[ROW][C]84[/C][C]97181[/C][C]108346.323529412[/C][C]-11165.3235294118[/C][/ROW]
[ROW][C]85[/C][C]50913[/C][C]62098[/C][C]-11185[/C][/ROW]
[ROW][C]86[/C][C]143910[/C][C]139524.975[/C][C]4385.02499999999[/C][/ROW]
[ROW][C]87[/C][C]218900[/C][C]170465.952380952[/C][C]48434.0476190476[/C][/ROW]
[ROW][C]88[/C][C]90772[/C][C]108346.323529412[/C][C]-17574.3235294118[/C][/ROW]
[ROW][C]89[/C][C]90385[/C][C]108346.323529412[/C][C]-17961.3235294118[/C][/ROW]
[ROW][C]90[/C][C]136220[/C][C]139524.975[/C][C]-3304.97500000001[/C][/ROW]
[ROW][C]91[/C][C]115572[/C][C]139524.975[/C][C]-23952.975[/C][/ROW]
[ROW][C]92[/C][C]139075[/C][C]170465.952380952[/C][C]-31390.9523809524[/C][/ROW]
[ROW][C]93[/C][C]148950[/C][C]108346.323529412[/C][C]40603.6764705882[/C][/ROW]
[ROW][C]94[/C][C]124626[/C][C]108346.323529412[/C][C]16279.6764705882[/C][/ROW]
[ROW][C]95[/C][C]49176[/C][C]62098[/C][C]-12922[/C][/ROW]
[ROW][C]96[/C][C]215480[/C][C]170465.952380952[/C][C]45014.0476190476[/C][/ROW]
[ROW][C]97[/C][C]182328[/C][C]139524.975[/C][C]42803.025[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]11776.7647058824[/C][C]7572.23529411765[/C][/ROW]
[ROW][C]99[/C][C]183873[/C][C]170465.952380952[/C][C]13407.0476190476[/C][/ROW]
[ROW][C]100[/C][C]146020[/C][C]139524.975[/C][C]6495.02499999999[/C][/ROW]
[ROW][C]101[/C][C]51201[/C][C]62098[/C][C]-10897[/C][/ROW]
[ROW][C]102[/C][C]58280[/C][C]62098[/C][C]-3818[/C][/ROW]
[ROW][C]103[/C][C]115944[/C][C]108346.323529412[/C][C]7597.67647058824[/C][/ROW]
[ROW][C]104[/C][C]94341[/C][C]108346.323529412[/C][C]-14005.3235294118[/C][/ROW]
[ROW][C]105[/C][C]72904[/C][C]62098[/C][C]10806[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]11776.7647058824[/C][C]15899.2352941176[/C][/ROW]
[ROW][C]107[/C][C]125728[/C][C]108346.323529412[/C][C]17381.6764705882[/C][/ROW]
[ROW][C]108[/C][C]89920[/C][C]62098[/C][C]27822[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]11776.7647058824[/C][C]-11776.7647058824[/C][/ROW]
[ROW][C]110[/C][C]85610[/C][C]108346.323529412[/C][C]-22736.3235294118[/C][/ROW]
[ROW][C]111[/C][C]106742[/C][C]108346.323529412[/C][C]-1604.32352941176[/C][/ROW]
[ROW][C]112[/C][C]126825[/C][C]108346.323529412[/C][C]18478.6764705882[/C][/ROW]
[ROW][C]113[/C][C]109807[/C][C]108346.323529412[/C][C]1460.67647058824[/C][/ROW]
[ROW][C]114[/C][C]71894[/C][C]62098[/C][C]9796[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]11776.7647058824[/C][C]-8160.76470588235[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]11776.7647058824[/C][C]-11776.7647058824[/C][/ROW]
[ROW][C]117[/C][C]154806[/C][C]108346.323529412[/C][C]46459.6764705882[/C][/ROW]
[ROW][C]118[/C][C]136333[/C][C]139524.975[/C][C]-3191.97500000001[/C][/ROW]
[ROW][C]119[/C][C]147766[/C][C]139524.975[/C][C]8241.02499999999[/C][/ROW]
[ROW][C]120[/C][C]113245[/C][C]108346.323529412[/C][C]4898.67647058824[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]62098[/C][C]-18688[/C][/ROW]
[ROW][C]122[/C][C]152455[/C][C]139524.975[/C][C]12930.025[/C][/ROW]
[ROW][C]123[/C][C]88874[/C][C]62098[/C][C]26776[/C][/ROW]
[ROW][C]124[/C][C]111924[/C][C]139524.975[/C][C]-27600.975[/C][/ROW]
[ROW][C]125[/C][C]60373[/C][C]62098[/C][C]-1725[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]11776.7647058824[/C][C]7987.23529411765[/C][/ROW]
[ROW][C]127[/C][C]125760[/C][C]139524.975[/C][C]-13764.975[/C][/ROW]
[ROW][C]128[/C][C]108685[/C][C]108346.323529412[/C][C]338.676470588238[/C][/ROW]
[ROW][C]129[/C][C]141868[/C][C]139524.975[/C][C]2343.02499999999[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]11776.7647058824[/C][C]19.2352941176468[/C][/ROW]
[ROW][C]131[/C][C]10674[/C][C]11776.7647058824[/C][C]-1102.76470588235[/C][/ROW]
[ROW][C]132[/C][C]131263[/C][C]139524.975[/C][C]-8261.97500000001[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]11776.7647058824[/C][C]-4940.76470588235[/C][/ROW]
[ROW][C]134[/C][C]153278[/C][C]139524.975[/C][C]13753.025[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]11776.7647058824[/C][C]-6658.76470588235[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]11776.7647058824[/C][C]28471.2352941176[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]11776.7647058824[/C][C]-11776.7647058824[/C][/ROW]
[ROW][C]138[/C][C]100798[/C][C]108346.323529412[/C][C]-7548.32352941176[/C][/ROW]
[ROW][C]139[/C][C]84315[/C][C]108346.323529412[/C][C]-24031.3235294118[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]11776.7647058824[/C][C]-4645.76470588235[/C][/ROW]
[ROW][C]141[/C][C]8812[/C][C]11776.7647058824[/C][C]-2964.76470588235[/C][/ROW]
[ROW][C]142[/C][C]63952[/C][C]62098[/C][C]1854[/C][/ROW]
[ROW][C]143[/C][C]120111[/C][C]108346.323529412[/C][C]11764.6764705882[/C][/ROW]
[ROW][C]144[/C][C]94127[/C][C]108346.323529412[/C][C]-14219.3235294118[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=157035&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=157035&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
1157382139524.97517857.025
2168465139524.97528940.025
3721511776.7647058824-4561.76470588235
4122259170465.952380952-48206.9523809524
5221399231645.461538462-10246.4615384615
6454489231645.461538462222843.538461538
7134379139524.975-5145.97500000001
8150416139524.97510891.025
9121391139524.975-18133.975
10275326231645.46153846243680.5384615385
11121593170465.952380952-48872.9523809524
12172071170465.9523809521605.04761904763
1386249139524.975-53275.975
14201902231645.461538462-29743.4615384615
15144113139524.9754588.02499999999
16144677139524.9755152.02499999999
17134153139524.975-5371.97500000001
1864149108346.323529412-44197.3235294118
19122294170465.952380952-48171.9523809524
202791862098-34180
215219762098-9901
22191463170465.95238095220997.0476190476
23176034139524.97536509.025
2498629139524.975-40895.975
25143546139524.9754021.02499999999
26139780139524.975255.024999999994
27174181170465.9523809523715.04761904763
28163773108346.32352941255426.6764705882
29312831231645.46153846281185.5384615385
30184024231645.461538462-47621.4615384615
31151621139524.97512096.025
32164516139524.97524991.025
33120414170465.952380952-50051.9523809524
34214975231645.461538462-16670.4615384615
35200609170465.95238095230143.0476190476
36011776.7647058824-11776.7647058824
37191923139524.97552398.025
3893107139524.975-46417.975
39129419170465.952380952-41046.9523809524
40233497231645.4615384621851.53846153847
41178228170465.9523809527762.04761904763
42126602139524.975-12922.975
4394332108346.323529412-14014.3235294118
44164183170465.952380952-6282.95238095237
4595704108346.323529412-12642.3235294118
46139901108346.32352941231554.6764705882
47812936209819195
48189007170465.95238095218541.0476190476
49173779139524.97534254.025
50146552231645.461538462-85093.4615384615
514818862098-13910
52113870139524.975-25654.975
53266451231645.46153846234805.5384615385
54229437170465.95238095258971.0476190476
55174876139524.97535351.025
56119070139524.975-20454.975
57186704139524.97547179.025
58725596209810461
59111940108346.3235294123593.67647058824
60166226231645.461538462-65419.4615384615
61130414139524.975-9110.97500000001
62102141139524.975-37383.975
63115753108346.3235294127406.67647058824
64102194108346.323529412-6152.32352941176
65148531108346.32352941240184.6764705882
6694982108346.323529412-13364.3235294118
67178613170465.9523809528147.04761904763
68128907231645.461538462-102738.461538462
69102378108346.323529412-5968.32352941176
703197011776.764705882420193.2352941176
71204812231645.461538462-26833.4615384615
72104972108346.323529412-3374.32352941176
7395276108346.323529412-13070.3235294118
74101560139524.975-37964.975
75144193170465.952380952-26272.9523809524
7671921108346.323529412-36425.3235294118
77126905139524.975-12619.975
78140303170465.952380952-30162.9523809524
796013862098-1960
8084971108346.323529412-23375.3235294118
81804206209818322
82244190170465.95238095273724.0476190476
835625262098-5846
8497181108346.323529412-11165.3235294118
855091362098-11185
86143910139524.9754385.02499999999
87218900170465.95238095248434.0476190476
8890772108346.323529412-17574.3235294118
8990385108346.323529412-17961.3235294118
90136220139524.975-3304.97500000001
91115572139524.975-23952.975
92139075170465.952380952-31390.9523809524
93148950108346.32352941240603.6764705882
94124626108346.32352941216279.6764705882
954917662098-12922
96215480170465.95238095245014.0476190476
97182328139524.97542803.025
981934911776.76470588247572.23529411765
99183873170465.95238095213407.0476190476
100146020139524.9756495.02499999999
1015120162098-10897
1025828062098-3818
103115944108346.3235294127597.67647058824
10494341108346.323529412-14005.3235294118
105729046209810806
1062767611776.764705882415899.2352941176
107125728108346.32352941217381.6764705882
108899206209827822
109011776.7647058824-11776.7647058824
11085610108346.323529412-22736.3235294118
111106742108346.323529412-1604.32352941176
112126825108346.32352941218478.6764705882
113109807108346.3235294121460.67647058824
11471894620989796
115361611776.7647058824-8160.76470588235
116011776.7647058824-11776.7647058824
117154806108346.32352941246459.6764705882
118136333139524.975-3191.97500000001
119147766139524.9758241.02499999999
120113245108346.3235294124898.67647058824
1214341062098-18688
122152455139524.97512930.025
123888746209826776
124111924139524.975-27600.975
1256037362098-1725
1261976411776.76470588247987.23529411765
127125760139524.975-13764.975
128108685108346.323529412338.676470588238
129141868139524.9752343.02499999999
1301179611776.764705882419.2352941176468
1311067411776.7647058824-1102.76470588235
132131263139524.975-8261.97500000001
133683611776.7647058824-4940.76470588235
134153278139524.97513753.025
135511811776.7647058824-6658.76470588235
1364024811776.764705882428471.2352941176
137011776.7647058824-11776.7647058824
138100798108346.323529412-7548.32352941176
13984315108346.323529412-24031.3235294118
140713111776.7647058824-4645.76470588235
141881211776.7647058824-2964.76470588235
14263952620981854
143120111108346.32352941211764.6764705882
14494127108346.323529412-14219.3235294118



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