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, 14 Dec 2011 08:48:52 -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/14/t1323870586xuokf2ip5457zqy.htm/, Retrieved Wed, 01 May 2024 20:51:39 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=154962, Retrieved Wed, 01 May 2024 20:51:39 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact66
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [tree] [2011-12-14 13:48:52] [685fae5a377cc1dc51f9f02306b751ce] [Current]
Feedback Forum

Post a new message
Dataseries X:
1407	118540	74	440	15	18158
1072	127145	44	306	16	30461
192	7215	18	72	0	1423
2032	112861	84	584	22	25629
3032	197581	120	1013	25	48758
5519	377410	209	1506	26	129230
1321	117604	49	442	19	27376
1034	120102	44	274	25	26706
1388	96175	36	382	25	26505
2552	253517	85	812	26	49801
1735	108994	65	546	20	46580
1788	156212	58	551	25	48352
1292	68810	84	477	15	13899
2362	149246	83	799	21	39342
1150	125503	42	330	12	27465
1374	125769	67	419	19	55211
1503	123467	49	364	28	74098
965	56088	45	277	12	13497
2164	108128	73	658	28	38338
633	22762	20	188	13	52505
837	48554	48	286	14	10663
1991	159102	78	575	23	74484
1450	139108	57	514	25	28895
1765	92058	43	525	30	32827
1612	126311	69	516	17	36188
1173	113807	21	426	17	28173
1602	133994	132	509	21	54926
1046	131810	71	248	24	38900
2176	279065	96	724	22	88530
1767	158146	35	733	16	35482
1167	107352	36	374	23	26730
1394	149827	37	471	18	29806
1733	90912	83	549	11	41799
2374	169510	96	721	20	54289
1852	162204	40	596	20	36805
1	0	1	0	0	0
1677	163310	53	778	24	33146
1505	92342	46	464	14	23333
1813	98357	40	417	29	47686
1648	178277	49	607	31	77783
1560	134927	53	495	15	36042
1301	104577	46	489	30	34541
784	81614	23	281	20	75620
1580	119111	60	603	20	60610
896	83923	39	278	18	55041
959	109885	71	246	19	32087
567	52851	24	162	28	16356
1519	153621	73	525	18	40161
1625	152572	74	506	26	55459
1817	114073	44	677	23	36679
658	48188	28	205	22	22346
1187	90994	52	306	19	27377
1863	215588	61	680	20	50273
1559	176489	64	533	25	32104
1340	138871	46	487	27	27016
1342	104416	44	418	10	19715
1505	156186	54	401	26	33629
669	60368	16	189	21	27084
814	95391	53	275	19	32352
2189	126048	65	738	32	51845
1291	96388	44	369	28	26591
1378	77353	58	490	16	29677
978	79872	41	298	16	54237
823	79772	27	259	20	20284
789	96945	22	268	20	22741
1134	88300	34	364	24	34178
1875	126203	59	426	31	69551
2289	110681	56	689	21	29653
817	81299	29	208	21	38071
340	31970	15	101	21	4157
2354	185321	101	809	15	28321
992	87611	51	293	9	40195
976	73021	50	327	21	48158
1357	82167	56	405	18	13310
1958	101152	42	508	27	78474
933	49164	29	248	24	6386
1600	105181	48	424	22	31588
1821	105922	71	628	21	61254
816	60138	23	253	21	21152
1121	73422	66	366	26	41272
800	67727	54	190	22	34165
1446	188098	45	515	22	37054
750	51185	23	221	20	12368
1171	84448	28	404	21	23168
662	41956	35	219	19	16380
1284	110827	40	377	19	41242
1980	167055	175	427	25	48259
879	63603	78	209	19	20790
869	64995	42	276	21	34585
1000	93424	36	382	18	35672
1240	97229	32	446	23	52168
1771	112819	60	521	18	53933
917	106460	49	295	19	34474
1042	102220	50	382	12	43753
629	38721	30	253	9	36456
1770	168764	85	569	26	51183
1454	151588	46	441	21	52742
222	19349	11	67	1	3895
1529	125440	77	504	24	37076
1303	101954	48	523	18	24079
552	43803	24	240	4	2325
708	47062	19	219	15	29354
998	104220	43	329	19	30341
872	85939	50	217	20	18992
584	58660	35	136	12	15292
596	27676	22	194	16	5842
926	93448	31	209	21	28918
576	43284	22	151	9	3738
0	0	0	0	0	0
868	64333	23	237	21	95352
736	57050	46	236	17	37478
998	96933	34	323	18	26839
915	70088	46	296	21	26783
782	65494	55	267	17	33392
78	3616	5	14	0	0
0	0	0	0	0	0
782	135104	33	261	19	25446
1159	95554	60	391	26	60038
1646	120307	77	469	25	28162
749	84336	32	243	20	33298
778	43410	19	292	1	2781
1335	131452	55	400	21	37121
806	79015	33	217	14	22698
1390	88043	40	392	24	27615
680	57578	36	160	12	32689
285	19764	12	75	2	5752
1335	105757	41	412	16	23164
840	96410	22	293	22	20304
1230	105056	30	401	28	34409
256	11796	9	79	2	0
80	7627	8	25	0	0
1162	117413	47	412	17	92538
41	6836	3	11	1	0
1540	131955	37	539	17	46037
42	5118	3	6	0	0
528	40248	16	183	4	5444
0	0	0	0	0	0
799	77813	38	281	21	23924
1086	67140	28	196	24	52230
81	7131	4	27	0	0
61	4194	11	14	0	0
849	60378	20	240	15	8019
970	96971	40	233	18	34542
964	83484	16	347	19	21157




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

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







Goodness of Fit
Correlation0.8511
R-squared0.7244
RMSE29351.1286

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8511[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7244[/C][/ROW]
[ROW][C]RMSE[/C][C]29351.1286[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154962&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154962&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.8511
R-squared0.7244
RMSE29351.1286







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1118540109075.7727272739464.22727272728
2127145109075.77272727318069.2272727273
372156617.57142857143597.428571428572
4112861137658.689655172-24797.6896551724
5197581205375.444444444-7794.44444444444
6377410205375.444444444172034.555555556
7117604109075.7727272738528.22727272728
8120102109075.77272727311026.2272727273
996175109075.772727273-12900.7727272727
10253517205375.44444444448141.5555555556
11108994137658.689655172-28664.6896551724
12156212137658.68965517218553.3103448276
1368810109075.772727273-40265.7727272727
14149246205375.444444444-56129.4444444444
15125503109075.77272727316427.2272727273
16125769109075.77272727316693.2272727273
17123467109075.77272727314391.2272727273
185608875554.8108108108-19466.8108108108
19108128137658.689655172-29530.6896551724
202276240919.9090909091-18157.9090909091
214855475554.8108108108-27000.8108108108
22159102137658.68965517221443.3103448276
23139108137658.6896551721449.31034482759
2492058137658.689655172-45600.6896551724
25126311137658.689655172-11347.6896551724
26113807109075.7727272734731.22727272728
27133994137658.689655172-3664.68965517241
28131810109075.77272727322734.2272727273
29279065205375.44444444473689.5555555556
30158146137658.68965517220487.3103448276
31107352109075.772727273-1723.77272727272
32149827109075.77272727340751.2272727273
3390912137658.689655172-46746.6896551724
34169510205375.444444444-35865.4444444444
35162204137658.68965517224545.3103448276
3606617.57142857143-6617.57142857143
37163310137658.68965517225651.3103448276
3892342109075.772727273-16733.7727272727
3998357109075.772727273-10718.7727272727
40178277137658.68965517240618.3103448276
41134927137658.689655172-2731.68965517241
42104577109075.772727273-4498.77272727272
438161475554.81081081086059.18918918919
44119111137658.689655172-18547.6896551724
458392375554.81081081088368.18918918919
4610988575554.810810810834330.1891891892
475285140919.909090909111931.0909090909
48153621137658.68965517215962.3103448276
49152572137658.68965517214913.3103448276
50114073137658.689655172-23585.6896551724
514818840919.90909090917268.09090909091
5290994109075.772727273-18081.7727272727
53215588137658.68965517277929.3103448276
54176489137658.68965517238830.3103448276
55138871109075.77272727329795.2272727273
56104416109075.772727273-4659.77272727272
57156186109075.77272727347110.2272727273
586036875554.8108108108-15186.8108108108
599539175554.810810810819836.1891891892
60126048205375.444444444-79327.4444444444
6196388109075.772727273-12687.7727272727
6277353109075.772727273-31722.7727272727
637987275554.81081081084317.18918918919
647977275554.81081081084217.18918918919
659694575554.810810810821390.1891891892
6688300109075.772727273-20775.7727272727
67126203109075.77272727317127.2272727273
68110681205375.444444444-94694.4444444444
698129975554.81081081085744.18918918919
703197040919.9090909091-8949.90909090909
71185321205375.444444444-20054.4444444444
728761175554.810810810812056.1891891892
737302175554.8108108108-2533.81081081081
7482167109075.772727273-26908.7727272727
75101152137658.689655172-36506.6896551724
764916475554.8108108108-26390.8108108108
77105181109075.772727273-3894.77272727272
78105922137658.689655172-31736.6896551724
796013875554.8108108108-15416.8108108108
8073422109075.772727273-35653.7727272727
816772775554.8108108108-7827.81081081081
82188098137658.68965517250439.3103448276
835118575554.8108108108-24369.8108108108
8484448109075.772727273-24627.7727272727
854195640919.90909090911036.09090909091
86110827109075.7727272731751.22727272728
87167055109075.77272727357979.2272727273
886360375554.8108108108-11951.8108108108
896499575554.8108108108-10559.8108108108
9093424109075.772727273-15651.7727272727
9197229109075.772727273-11846.7727272727
92112819137658.689655172-24839.6896551724
9310646075554.810810810830905.1891891892
94102220109075.772727273-6855.77272727272
953872140919.9090909091-2198.90909090909
96168764137658.68965517231105.3103448276
97151588109075.77272727342512.2272727273
98193496617.5714285714312731.4285714286
99125440137658.689655172-12218.6896551724
100101954137658.689655172-35704.6896551724
1014380340919.90909090912883.09090909091
1024706275554.8108108108-28492.8108108108
103104220109075.772727273-4855.77272727272
1048593975554.810810810810384.1891891892
1055866040919.909090909117740.0909090909
1062767640919.9090909091-13243.9090909091
1079344875554.810810810817893.1891891892
1084328440919.90909090912364.09090909091
10906617.57142857143-6617.57142857143
1106433375554.8108108108-11221.8108108108
1115705075554.8108108108-18504.8108108108
11296933109075.772727273-12142.7727272727
1137008875554.8108108108-5466.81081081081
1146549475554.8108108108-10060.8108108108
11536166617.57142857143-3001.57142857143
11606617.57142857143-6617.57142857143
11713510475554.810810810859549.1891891892
11895554109075.772727273-13521.7727272727
119120307109075.77272727311231.2272727273
1208433675554.81081081088781.18918918919
1214341075554.8108108108-32144.8108108108
122131452109075.77272727322376.2272727273
1237901575554.81081081083460.18918918919
12488043109075.772727273-21032.7727272727
1255757875554.8108108108-17976.8108108108
126197646617.5714285714313146.4285714286
127105757109075.772727273-3318.77272727272
1289641075554.810810810820855.1891891892
129105056109075.772727273-4019.77272727272
130117966617.571428571435178.42857142857
13176276617.571428571431009.42857142857
132117413109075.7727272738337.22727272728
13368366617.57142857143218.428571428572
134131955137658.689655172-5703.68965517241
13551186617.57142857143-1499.57142857143
1364024840919.9090909091-671.909090909088
13706617.57142857143-6617.57142857143
1387781375554.81081081082258.18918918919
13967140109075.772727273-41935.7727272727
14071316617.57142857143513.428571428572
14141946617.57142857143-2423.57142857143
1426037875554.8108108108-15176.8108108108
1439697175554.810810810821416.1891891892
1448348475554.81081081087929.18918918919

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 118540 & 109075.772727273 & 9464.22727272728 \tabularnewline
2 & 127145 & 109075.772727273 & 18069.2272727273 \tabularnewline
3 & 7215 & 6617.57142857143 & 597.428571428572 \tabularnewline
4 & 112861 & 137658.689655172 & -24797.6896551724 \tabularnewline
5 & 197581 & 205375.444444444 & -7794.44444444444 \tabularnewline
6 & 377410 & 205375.444444444 & 172034.555555556 \tabularnewline
7 & 117604 & 109075.772727273 & 8528.22727272728 \tabularnewline
8 & 120102 & 109075.772727273 & 11026.2272727273 \tabularnewline
9 & 96175 & 109075.772727273 & -12900.7727272727 \tabularnewline
10 & 253517 & 205375.444444444 & 48141.5555555556 \tabularnewline
11 & 108994 & 137658.689655172 & -28664.6896551724 \tabularnewline
12 & 156212 & 137658.689655172 & 18553.3103448276 \tabularnewline
13 & 68810 & 109075.772727273 & -40265.7727272727 \tabularnewline
14 & 149246 & 205375.444444444 & -56129.4444444444 \tabularnewline
15 & 125503 & 109075.772727273 & 16427.2272727273 \tabularnewline
16 & 125769 & 109075.772727273 & 16693.2272727273 \tabularnewline
17 & 123467 & 109075.772727273 & 14391.2272727273 \tabularnewline
18 & 56088 & 75554.8108108108 & -19466.8108108108 \tabularnewline
19 & 108128 & 137658.689655172 & -29530.6896551724 \tabularnewline
20 & 22762 & 40919.9090909091 & -18157.9090909091 \tabularnewline
21 & 48554 & 75554.8108108108 & -27000.8108108108 \tabularnewline
22 & 159102 & 137658.689655172 & 21443.3103448276 \tabularnewline
23 & 139108 & 137658.689655172 & 1449.31034482759 \tabularnewline
24 & 92058 & 137658.689655172 & -45600.6896551724 \tabularnewline
25 & 126311 & 137658.689655172 & -11347.6896551724 \tabularnewline
26 & 113807 & 109075.772727273 & 4731.22727272728 \tabularnewline
27 & 133994 & 137658.689655172 & -3664.68965517241 \tabularnewline
28 & 131810 & 109075.772727273 & 22734.2272727273 \tabularnewline
29 & 279065 & 205375.444444444 & 73689.5555555556 \tabularnewline
30 & 158146 & 137658.689655172 & 20487.3103448276 \tabularnewline
31 & 107352 & 109075.772727273 & -1723.77272727272 \tabularnewline
32 & 149827 & 109075.772727273 & 40751.2272727273 \tabularnewline
33 & 90912 & 137658.689655172 & -46746.6896551724 \tabularnewline
34 & 169510 & 205375.444444444 & -35865.4444444444 \tabularnewline
35 & 162204 & 137658.689655172 & 24545.3103448276 \tabularnewline
36 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
37 & 163310 & 137658.689655172 & 25651.3103448276 \tabularnewline
38 & 92342 & 109075.772727273 & -16733.7727272727 \tabularnewline
39 & 98357 & 109075.772727273 & -10718.7727272727 \tabularnewline
40 & 178277 & 137658.689655172 & 40618.3103448276 \tabularnewline
41 & 134927 & 137658.689655172 & -2731.68965517241 \tabularnewline
42 & 104577 & 109075.772727273 & -4498.77272727272 \tabularnewline
43 & 81614 & 75554.8108108108 & 6059.18918918919 \tabularnewline
44 & 119111 & 137658.689655172 & -18547.6896551724 \tabularnewline
45 & 83923 & 75554.8108108108 & 8368.18918918919 \tabularnewline
46 & 109885 & 75554.8108108108 & 34330.1891891892 \tabularnewline
47 & 52851 & 40919.9090909091 & 11931.0909090909 \tabularnewline
48 & 153621 & 137658.689655172 & 15962.3103448276 \tabularnewline
49 & 152572 & 137658.689655172 & 14913.3103448276 \tabularnewline
50 & 114073 & 137658.689655172 & -23585.6896551724 \tabularnewline
51 & 48188 & 40919.9090909091 & 7268.09090909091 \tabularnewline
52 & 90994 & 109075.772727273 & -18081.7727272727 \tabularnewline
53 & 215588 & 137658.689655172 & 77929.3103448276 \tabularnewline
54 & 176489 & 137658.689655172 & 38830.3103448276 \tabularnewline
55 & 138871 & 109075.772727273 & 29795.2272727273 \tabularnewline
56 & 104416 & 109075.772727273 & -4659.77272727272 \tabularnewline
57 & 156186 & 109075.772727273 & 47110.2272727273 \tabularnewline
58 & 60368 & 75554.8108108108 & -15186.8108108108 \tabularnewline
59 & 95391 & 75554.8108108108 & 19836.1891891892 \tabularnewline
60 & 126048 & 205375.444444444 & -79327.4444444444 \tabularnewline
61 & 96388 & 109075.772727273 & -12687.7727272727 \tabularnewline
62 & 77353 & 109075.772727273 & -31722.7727272727 \tabularnewline
63 & 79872 & 75554.8108108108 & 4317.18918918919 \tabularnewline
64 & 79772 & 75554.8108108108 & 4217.18918918919 \tabularnewline
65 & 96945 & 75554.8108108108 & 21390.1891891892 \tabularnewline
66 & 88300 & 109075.772727273 & -20775.7727272727 \tabularnewline
67 & 126203 & 109075.772727273 & 17127.2272727273 \tabularnewline
68 & 110681 & 205375.444444444 & -94694.4444444444 \tabularnewline
69 & 81299 & 75554.8108108108 & 5744.18918918919 \tabularnewline
70 & 31970 & 40919.9090909091 & -8949.90909090909 \tabularnewline
71 & 185321 & 205375.444444444 & -20054.4444444444 \tabularnewline
72 & 87611 & 75554.8108108108 & 12056.1891891892 \tabularnewline
73 & 73021 & 75554.8108108108 & -2533.81081081081 \tabularnewline
74 & 82167 & 109075.772727273 & -26908.7727272727 \tabularnewline
75 & 101152 & 137658.689655172 & -36506.6896551724 \tabularnewline
76 & 49164 & 75554.8108108108 & -26390.8108108108 \tabularnewline
77 & 105181 & 109075.772727273 & -3894.77272727272 \tabularnewline
78 & 105922 & 137658.689655172 & -31736.6896551724 \tabularnewline
79 & 60138 & 75554.8108108108 & -15416.8108108108 \tabularnewline
80 & 73422 & 109075.772727273 & -35653.7727272727 \tabularnewline
81 & 67727 & 75554.8108108108 & -7827.81081081081 \tabularnewline
82 & 188098 & 137658.689655172 & 50439.3103448276 \tabularnewline
83 & 51185 & 75554.8108108108 & -24369.8108108108 \tabularnewline
84 & 84448 & 109075.772727273 & -24627.7727272727 \tabularnewline
85 & 41956 & 40919.9090909091 & 1036.09090909091 \tabularnewline
86 & 110827 & 109075.772727273 & 1751.22727272728 \tabularnewline
87 & 167055 & 109075.772727273 & 57979.2272727273 \tabularnewline
88 & 63603 & 75554.8108108108 & -11951.8108108108 \tabularnewline
89 & 64995 & 75554.8108108108 & -10559.8108108108 \tabularnewline
90 & 93424 & 109075.772727273 & -15651.7727272727 \tabularnewline
91 & 97229 & 109075.772727273 & -11846.7727272727 \tabularnewline
92 & 112819 & 137658.689655172 & -24839.6896551724 \tabularnewline
93 & 106460 & 75554.8108108108 & 30905.1891891892 \tabularnewline
94 & 102220 & 109075.772727273 & -6855.77272727272 \tabularnewline
95 & 38721 & 40919.9090909091 & -2198.90909090909 \tabularnewline
96 & 168764 & 137658.689655172 & 31105.3103448276 \tabularnewline
97 & 151588 & 109075.772727273 & 42512.2272727273 \tabularnewline
98 & 19349 & 6617.57142857143 & 12731.4285714286 \tabularnewline
99 & 125440 & 137658.689655172 & -12218.6896551724 \tabularnewline
100 & 101954 & 137658.689655172 & -35704.6896551724 \tabularnewline
101 & 43803 & 40919.9090909091 & 2883.09090909091 \tabularnewline
102 & 47062 & 75554.8108108108 & -28492.8108108108 \tabularnewline
103 & 104220 & 109075.772727273 & -4855.77272727272 \tabularnewline
104 & 85939 & 75554.8108108108 & 10384.1891891892 \tabularnewline
105 & 58660 & 40919.9090909091 & 17740.0909090909 \tabularnewline
106 & 27676 & 40919.9090909091 & -13243.9090909091 \tabularnewline
107 & 93448 & 75554.8108108108 & 17893.1891891892 \tabularnewline
108 & 43284 & 40919.9090909091 & 2364.09090909091 \tabularnewline
109 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
110 & 64333 & 75554.8108108108 & -11221.8108108108 \tabularnewline
111 & 57050 & 75554.8108108108 & -18504.8108108108 \tabularnewline
112 & 96933 & 109075.772727273 & -12142.7727272727 \tabularnewline
113 & 70088 & 75554.8108108108 & -5466.81081081081 \tabularnewline
114 & 65494 & 75554.8108108108 & -10060.8108108108 \tabularnewline
115 & 3616 & 6617.57142857143 & -3001.57142857143 \tabularnewline
116 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
117 & 135104 & 75554.8108108108 & 59549.1891891892 \tabularnewline
118 & 95554 & 109075.772727273 & -13521.7727272727 \tabularnewline
119 & 120307 & 109075.772727273 & 11231.2272727273 \tabularnewline
120 & 84336 & 75554.8108108108 & 8781.18918918919 \tabularnewline
121 & 43410 & 75554.8108108108 & -32144.8108108108 \tabularnewline
122 & 131452 & 109075.772727273 & 22376.2272727273 \tabularnewline
123 & 79015 & 75554.8108108108 & 3460.18918918919 \tabularnewline
124 & 88043 & 109075.772727273 & -21032.7727272727 \tabularnewline
125 & 57578 & 75554.8108108108 & -17976.8108108108 \tabularnewline
126 & 19764 & 6617.57142857143 & 13146.4285714286 \tabularnewline
127 & 105757 & 109075.772727273 & -3318.77272727272 \tabularnewline
128 & 96410 & 75554.8108108108 & 20855.1891891892 \tabularnewline
129 & 105056 & 109075.772727273 & -4019.77272727272 \tabularnewline
130 & 11796 & 6617.57142857143 & 5178.42857142857 \tabularnewline
131 & 7627 & 6617.57142857143 & 1009.42857142857 \tabularnewline
132 & 117413 & 109075.772727273 & 8337.22727272728 \tabularnewline
133 & 6836 & 6617.57142857143 & 218.428571428572 \tabularnewline
134 & 131955 & 137658.689655172 & -5703.68965517241 \tabularnewline
135 & 5118 & 6617.57142857143 & -1499.57142857143 \tabularnewline
136 & 40248 & 40919.9090909091 & -671.909090909088 \tabularnewline
137 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
138 & 77813 & 75554.8108108108 & 2258.18918918919 \tabularnewline
139 & 67140 & 109075.772727273 & -41935.7727272727 \tabularnewline
140 & 7131 & 6617.57142857143 & 513.428571428572 \tabularnewline
141 & 4194 & 6617.57142857143 & -2423.57142857143 \tabularnewline
142 & 60378 & 75554.8108108108 & -15176.8108108108 \tabularnewline
143 & 96971 & 75554.8108108108 & 21416.1891891892 \tabularnewline
144 & 83484 & 75554.8108108108 & 7929.18918918919 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154962&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]118540[/C][C]109075.772727273[/C][C]9464.22727272728[/C][/ROW]
[ROW][C]2[/C][C]127145[/C][C]109075.772727273[/C][C]18069.2272727273[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]6617.57142857143[/C][C]597.428571428572[/C][/ROW]
[ROW][C]4[/C][C]112861[/C][C]137658.689655172[/C][C]-24797.6896551724[/C][/ROW]
[ROW][C]5[/C][C]197581[/C][C]205375.444444444[/C][C]-7794.44444444444[/C][/ROW]
[ROW][C]6[/C][C]377410[/C][C]205375.444444444[/C][C]172034.555555556[/C][/ROW]
[ROW][C]7[/C][C]117604[/C][C]109075.772727273[/C][C]8528.22727272728[/C][/ROW]
[ROW][C]8[/C][C]120102[/C][C]109075.772727273[/C][C]11026.2272727273[/C][/ROW]
[ROW][C]9[/C][C]96175[/C][C]109075.772727273[/C][C]-12900.7727272727[/C][/ROW]
[ROW][C]10[/C][C]253517[/C][C]205375.444444444[/C][C]48141.5555555556[/C][/ROW]
[ROW][C]11[/C][C]108994[/C][C]137658.689655172[/C][C]-28664.6896551724[/C][/ROW]
[ROW][C]12[/C][C]156212[/C][C]137658.689655172[/C][C]18553.3103448276[/C][/ROW]
[ROW][C]13[/C][C]68810[/C][C]109075.772727273[/C][C]-40265.7727272727[/C][/ROW]
[ROW][C]14[/C][C]149246[/C][C]205375.444444444[/C][C]-56129.4444444444[/C][/ROW]
[ROW][C]15[/C][C]125503[/C][C]109075.772727273[/C][C]16427.2272727273[/C][/ROW]
[ROW][C]16[/C][C]125769[/C][C]109075.772727273[/C][C]16693.2272727273[/C][/ROW]
[ROW][C]17[/C][C]123467[/C][C]109075.772727273[/C][C]14391.2272727273[/C][/ROW]
[ROW][C]18[/C][C]56088[/C][C]75554.8108108108[/C][C]-19466.8108108108[/C][/ROW]
[ROW][C]19[/C][C]108128[/C][C]137658.689655172[/C][C]-29530.6896551724[/C][/ROW]
[ROW][C]20[/C][C]22762[/C][C]40919.9090909091[/C][C]-18157.9090909091[/C][/ROW]
[ROW][C]21[/C][C]48554[/C][C]75554.8108108108[/C][C]-27000.8108108108[/C][/ROW]
[ROW][C]22[/C][C]159102[/C][C]137658.689655172[/C][C]21443.3103448276[/C][/ROW]
[ROW][C]23[/C][C]139108[/C][C]137658.689655172[/C][C]1449.31034482759[/C][/ROW]
[ROW][C]24[/C][C]92058[/C][C]137658.689655172[/C][C]-45600.6896551724[/C][/ROW]
[ROW][C]25[/C][C]126311[/C][C]137658.689655172[/C][C]-11347.6896551724[/C][/ROW]
[ROW][C]26[/C][C]113807[/C][C]109075.772727273[/C][C]4731.22727272728[/C][/ROW]
[ROW][C]27[/C][C]133994[/C][C]137658.689655172[/C][C]-3664.68965517241[/C][/ROW]
[ROW][C]28[/C][C]131810[/C][C]109075.772727273[/C][C]22734.2272727273[/C][/ROW]
[ROW][C]29[/C][C]279065[/C][C]205375.444444444[/C][C]73689.5555555556[/C][/ROW]
[ROW][C]30[/C][C]158146[/C][C]137658.689655172[/C][C]20487.3103448276[/C][/ROW]
[ROW][C]31[/C][C]107352[/C][C]109075.772727273[/C][C]-1723.77272727272[/C][/ROW]
[ROW][C]32[/C][C]149827[/C][C]109075.772727273[/C][C]40751.2272727273[/C][/ROW]
[ROW][C]33[/C][C]90912[/C][C]137658.689655172[/C][C]-46746.6896551724[/C][/ROW]
[ROW][C]34[/C][C]169510[/C][C]205375.444444444[/C][C]-35865.4444444444[/C][/ROW]
[ROW][C]35[/C][C]162204[/C][C]137658.689655172[/C][C]24545.3103448276[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]37[/C][C]163310[/C][C]137658.689655172[/C][C]25651.3103448276[/C][/ROW]
[ROW][C]38[/C][C]92342[/C][C]109075.772727273[/C][C]-16733.7727272727[/C][/ROW]
[ROW][C]39[/C][C]98357[/C][C]109075.772727273[/C][C]-10718.7727272727[/C][/ROW]
[ROW][C]40[/C][C]178277[/C][C]137658.689655172[/C][C]40618.3103448276[/C][/ROW]
[ROW][C]41[/C][C]134927[/C][C]137658.689655172[/C][C]-2731.68965517241[/C][/ROW]
[ROW][C]42[/C][C]104577[/C][C]109075.772727273[/C][C]-4498.77272727272[/C][/ROW]
[ROW][C]43[/C][C]81614[/C][C]75554.8108108108[/C][C]6059.18918918919[/C][/ROW]
[ROW][C]44[/C][C]119111[/C][C]137658.689655172[/C][C]-18547.6896551724[/C][/ROW]
[ROW][C]45[/C][C]83923[/C][C]75554.8108108108[/C][C]8368.18918918919[/C][/ROW]
[ROW][C]46[/C][C]109885[/C][C]75554.8108108108[/C][C]34330.1891891892[/C][/ROW]
[ROW][C]47[/C][C]52851[/C][C]40919.9090909091[/C][C]11931.0909090909[/C][/ROW]
[ROW][C]48[/C][C]153621[/C][C]137658.689655172[/C][C]15962.3103448276[/C][/ROW]
[ROW][C]49[/C][C]152572[/C][C]137658.689655172[/C][C]14913.3103448276[/C][/ROW]
[ROW][C]50[/C][C]114073[/C][C]137658.689655172[/C][C]-23585.6896551724[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]40919.9090909091[/C][C]7268.09090909091[/C][/ROW]
[ROW][C]52[/C][C]90994[/C][C]109075.772727273[/C][C]-18081.7727272727[/C][/ROW]
[ROW][C]53[/C][C]215588[/C][C]137658.689655172[/C][C]77929.3103448276[/C][/ROW]
[ROW][C]54[/C][C]176489[/C][C]137658.689655172[/C][C]38830.3103448276[/C][/ROW]
[ROW][C]55[/C][C]138871[/C][C]109075.772727273[/C][C]29795.2272727273[/C][/ROW]
[ROW][C]56[/C][C]104416[/C][C]109075.772727273[/C][C]-4659.77272727272[/C][/ROW]
[ROW][C]57[/C][C]156186[/C][C]109075.772727273[/C][C]47110.2272727273[/C][/ROW]
[ROW][C]58[/C][C]60368[/C][C]75554.8108108108[/C][C]-15186.8108108108[/C][/ROW]
[ROW][C]59[/C][C]95391[/C][C]75554.8108108108[/C][C]19836.1891891892[/C][/ROW]
[ROW][C]60[/C][C]126048[/C][C]205375.444444444[/C][C]-79327.4444444444[/C][/ROW]
[ROW][C]61[/C][C]96388[/C][C]109075.772727273[/C][C]-12687.7727272727[/C][/ROW]
[ROW][C]62[/C][C]77353[/C][C]109075.772727273[/C][C]-31722.7727272727[/C][/ROW]
[ROW][C]63[/C][C]79872[/C][C]75554.8108108108[/C][C]4317.18918918919[/C][/ROW]
[ROW][C]64[/C][C]79772[/C][C]75554.8108108108[/C][C]4217.18918918919[/C][/ROW]
[ROW][C]65[/C][C]96945[/C][C]75554.8108108108[/C][C]21390.1891891892[/C][/ROW]
[ROW][C]66[/C][C]88300[/C][C]109075.772727273[/C][C]-20775.7727272727[/C][/ROW]
[ROW][C]67[/C][C]126203[/C][C]109075.772727273[/C][C]17127.2272727273[/C][/ROW]
[ROW][C]68[/C][C]110681[/C][C]205375.444444444[/C][C]-94694.4444444444[/C][/ROW]
[ROW][C]69[/C][C]81299[/C][C]75554.8108108108[/C][C]5744.18918918919[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]40919.9090909091[/C][C]-8949.90909090909[/C][/ROW]
[ROW][C]71[/C][C]185321[/C][C]205375.444444444[/C][C]-20054.4444444444[/C][/ROW]
[ROW][C]72[/C][C]87611[/C][C]75554.8108108108[/C][C]12056.1891891892[/C][/ROW]
[ROW][C]73[/C][C]73021[/C][C]75554.8108108108[/C][C]-2533.81081081081[/C][/ROW]
[ROW][C]74[/C][C]82167[/C][C]109075.772727273[/C][C]-26908.7727272727[/C][/ROW]
[ROW][C]75[/C][C]101152[/C][C]137658.689655172[/C][C]-36506.6896551724[/C][/ROW]
[ROW][C]76[/C][C]49164[/C][C]75554.8108108108[/C][C]-26390.8108108108[/C][/ROW]
[ROW][C]77[/C][C]105181[/C][C]109075.772727273[/C][C]-3894.77272727272[/C][/ROW]
[ROW][C]78[/C][C]105922[/C][C]137658.689655172[/C][C]-31736.6896551724[/C][/ROW]
[ROW][C]79[/C][C]60138[/C][C]75554.8108108108[/C][C]-15416.8108108108[/C][/ROW]
[ROW][C]80[/C][C]73422[/C][C]109075.772727273[/C][C]-35653.7727272727[/C][/ROW]
[ROW][C]81[/C][C]67727[/C][C]75554.8108108108[/C][C]-7827.81081081081[/C][/ROW]
[ROW][C]82[/C][C]188098[/C][C]137658.689655172[/C][C]50439.3103448276[/C][/ROW]
[ROW][C]83[/C][C]51185[/C][C]75554.8108108108[/C][C]-24369.8108108108[/C][/ROW]
[ROW][C]84[/C][C]84448[/C][C]109075.772727273[/C][C]-24627.7727272727[/C][/ROW]
[ROW][C]85[/C][C]41956[/C][C]40919.9090909091[/C][C]1036.09090909091[/C][/ROW]
[ROW][C]86[/C][C]110827[/C][C]109075.772727273[/C][C]1751.22727272728[/C][/ROW]
[ROW][C]87[/C][C]167055[/C][C]109075.772727273[/C][C]57979.2272727273[/C][/ROW]
[ROW][C]88[/C][C]63603[/C][C]75554.8108108108[/C][C]-11951.8108108108[/C][/ROW]
[ROW][C]89[/C][C]64995[/C][C]75554.8108108108[/C][C]-10559.8108108108[/C][/ROW]
[ROW][C]90[/C][C]93424[/C][C]109075.772727273[/C][C]-15651.7727272727[/C][/ROW]
[ROW][C]91[/C][C]97229[/C][C]109075.772727273[/C][C]-11846.7727272727[/C][/ROW]
[ROW][C]92[/C][C]112819[/C][C]137658.689655172[/C][C]-24839.6896551724[/C][/ROW]
[ROW][C]93[/C][C]106460[/C][C]75554.8108108108[/C][C]30905.1891891892[/C][/ROW]
[ROW][C]94[/C][C]102220[/C][C]109075.772727273[/C][C]-6855.77272727272[/C][/ROW]
[ROW][C]95[/C][C]38721[/C][C]40919.9090909091[/C][C]-2198.90909090909[/C][/ROW]
[ROW][C]96[/C][C]168764[/C][C]137658.689655172[/C][C]31105.3103448276[/C][/ROW]
[ROW][C]97[/C][C]151588[/C][C]109075.772727273[/C][C]42512.2272727273[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]6617.57142857143[/C][C]12731.4285714286[/C][/ROW]
[ROW][C]99[/C][C]125440[/C][C]137658.689655172[/C][C]-12218.6896551724[/C][/ROW]
[ROW][C]100[/C][C]101954[/C][C]137658.689655172[/C][C]-35704.6896551724[/C][/ROW]
[ROW][C]101[/C][C]43803[/C][C]40919.9090909091[/C][C]2883.09090909091[/C][/ROW]
[ROW][C]102[/C][C]47062[/C][C]75554.8108108108[/C][C]-28492.8108108108[/C][/ROW]
[ROW][C]103[/C][C]104220[/C][C]109075.772727273[/C][C]-4855.77272727272[/C][/ROW]
[ROW][C]104[/C][C]85939[/C][C]75554.8108108108[/C][C]10384.1891891892[/C][/ROW]
[ROW][C]105[/C][C]58660[/C][C]40919.9090909091[/C][C]17740.0909090909[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]40919.9090909091[/C][C]-13243.9090909091[/C][/ROW]
[ROW][C]107[/C][C]93448[/C][C]75554.8108108108[/C][C]17893.1891891892[/C][/ROW]
[ROW][C]108[/C][C]43284[/C][C]40919.9090909091[/C][C]2364.09090909091[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]110[/C][C]64333[/C][C]75554.8108108108[/C][C]-11221.8108108108[/C][/ROW]
[ROW][C]111[/C][C]57050[/C][C]75554.8108108108[/C][C]-18504.8108108108[/C][/ROW]
[ROW][C]112[/C][C]96933[/C][C]109075.772727273[/C][C]-12142.7727272727[/C][/ROW]
[ROW][C]113[/C][C]70088[/C][C]75554.8108108108[/C][C]-5466.81081081081[/C][/ROW]
[ROW][C]114[/C][C]65494[/C][C]75554.8108108108[/C][C]-10060.8108108108[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]6617.57142857143[/C][C]-3001.57142857143[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]117[/C][C]135104[/C][C]75554.8108108108[/C][C]59549.1891891892[/C][/ROW]
[ROW][C]118[/C][C]95554[/C][C]109075.772727273[/C][C]-13521.7727272727[/C][/ROW]
[ROW][C]119[/C][C]120307[/C][C]109075.772727273[/C][C]11231.2272727273[/C][/ROW]
[ROW][C]120[/C][C]84336[/C][C]75554.8108108108[/C][C]8781.18918918919[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]75554.8108108108[/C][C]-32144.8108108108[/C][/ROW]
[ROW][C]122[/C][C]131452[/C][C]109075.772727273[/C][C]22376.2272727273[/C][/ROW]
[ROW][C]123[/C][C]79015[/C][C]75554.8108108108[/C][C]3460.18918918919[/C][/ROW]
[ROW][C]124[/C][C]88043[/C][C]109075.772727273[/C][C]-21032.7727272727[/C][/ROW]
[ROW][C]125[/C][C]57578[/C][C]75554.8108108108[/C][C]-17976.8108108108[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]6617.57142857143[/C][C]13146.4285714286[/C][/ROW]
[ROW][C]127[/C][C]105757[/C][C]109075.772727273[/C][C]-3318.77272727272[/C][/ROW]
[ROW][C]128[/C][C]96410[/C][C]75554.8108108108[/C][C]20855.1891891892[/C][/ROW]
[ROW][C]129[/C][C]105056[/C][C]109075.772727273[/C][C]-4019.77272727272[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]6617.57142857143[/C][C]5178.42857142857[/C][/ROW]
[ROW][C]131[/C][C]7627[/C][C]6617.57142857143[/C][C]1009.42857142857[/C][/ROW]
[ROW][C]132[/C][C]117413[/C][C]109075.772727273[/C][C]8337.22727272728[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]6617.57142857143[/C][C]218.428571428572[/C][/ROW]
[ROW][C]134[/C][C]131955[/C][C]137658.689655172[/C][C]-5703.68965517241[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]6617.57142857143[/C][C]-1499.57142857143[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]40919.9090909091[/C][C]-671.909090909088[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]138[/C][C]77813[/C][C]75554.8108108108[/C][C]2258.18918918919[/C][/ROW]
[ROW][C]139[/C][C]67140[/C][C]109075.772727273[/C][C]-41935.7727272727[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]6617.57142857143[/C][C]513.428571428572[/C][/ROW]
[ROW][C]141[/C][C]4194[/C][C]6617.57142857143[/C][C]-2423.57142857143[/C][/ROW]
[ROW][C]142[/C][C]60378[/C][C]75554.8108108108[/C][C]-15176.8108108108[/C][/ROW]
[ROW][C]143[/C][C]96971[/C][C]75554.8108108108[/C][C]21416.1891891892[/C][/ROW]
[ROW][C]144[/C][C]83484[/C][C]75554.8108108108[/C][C]7929.18918918919[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154962&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154962&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
1118540109075.7727272739464.22727272728
2127145109075.77272727318069.2272727273
372156617.57142857143597.428571428572
4112861137658.689655172-24797.6896551724
5197581205375.444444444-7794.44444444444
6377410205375.444444444172034.555555556
7117604109075.7727272738528.22727272728
8120102109075.77272727311026.2272727273
996175109075.772727273-12900.7727272727
10253517205375.44444444448141.5555555556
11108994137658.689655172-28664.6896551724
12156212137658.68965517218553.3103448276
1368810109075.772727273-40265.7727272727
14149246205375.444444444-56129.4444444444
15125503109075.77272727316427.2272727273
16125769109075.77272727316693.2272727273
17123467109075.77272727314391.2272727273
185608875554.8108108108-19466.8108108108
19108128137658.689655172-29530.6896551724
202276240919.9090909091-18157.9090909091
214855475554.8108108108-27000.8108108108
22159102137658.68965517221443.3103448276
23139108137658.6896551721449.31034482759
2492058137658.689655172-45600.6896551724
25126311137658.689655172-11347.6896551724
26113807109075.7727272734731.22727272728
27133994137658.689655172-3664.68965517241
28131810109075.77272727322734.2272727273
29279065205375.44444444473689.5555555556
30158146137658.68965517220487.3103448276
31107352109075.772727273-1723.77272727272
32149827109075.77272727340751.2272727273
3390912137658.689655172-46746.6896551724
34169510205375.444444444-35865.4444444444
35162204137658.68965517224545.3103448276
3606617.57142857143-6617.57142857143
37163310137658.68965517225651.3103448276
3892342109075.772727273-16733.7727272727
3998357109075.772727273-10718.7727272727
40178277137658.68965517240618.3103448276
41134927137658.689655172-2731.68965517241
42104577109075.772727273-4498.77272727272
438161475554.81081081086059.18918918919
44119111137658.689655172-18547.6896551724
458392375554.81081081088368.18918918919
4610988575554.810810810834330.1891891892
475285140919.909090909111931.0909090909
48153621137658.68965517215962.3103448276
49152572137658.68965517214913.3103448276
50114073137658.689655172-23585.6896551724
514818840919.90909090917268.09090909091
5290994109075.772727273-18081.7727272727
53215588137658.68965517277929.3103448276
54176489137658.68965517238830.3103448276
55138871109075.77272727329795.2272727273
56104416109075.772727273-4659.77272727272
57156186109075.77272727347110.2272727273
586036875554.8108108108-15186.8108108108
599539175554.810810810819836.1891891892
60126048205375.444444444-79327.4444444444
6196388109075.772727273-12687.7727272727
6277353109075.772727273-31722.7727272727
637987275554.81081081084317.18918918919
647977275554.81081081084217.18918918919
659694575554.810810810821390.1891891892
6688300109075.772727273-20775.7727272727
67126203109075.77272727317127.2272727273
68110681205375.444444444-94694.4444444444
698129975554.81081081085744.18918918919
703197040919.9090909091-8949.90909090909
71185321205375.444444444-20054.4444444444
728761175554.810810810812056.1891891892
737302175554.8108108108-2533.81081081081
7482167109075.772727273-26908.7727272727
75101152137658.689655172-36506.6896551724
764916475554.8108108108-26390.8108108108
77105181109075.772727273-3894.77272727272
78105922137658.689655172-31736.6896551724
796013875554.8108108108-15416.8108108108
8073422109075.772727273-35653.7727272727
816772775554.8108108108-7827.81081081081
82188098137658.68965517250439.3103448276
835118575554.8108108108-24369.8108108108
8484448109075.772727273-24627.7727272727
854195640919.90909090911036.09090909091
86110827109075.7727272731751.22727272728
87167055109075.77272727357979.2272727273
886360375554.8108108108-11951.8108108108
896499575554.8108108108-10559.8108108108
9093424109075.772727273-15651.7727272727
9197229109075.772727273-11846.7727272727
92112819137658.689655172-24839.6896551724
9310646075554.810810810830905.1891891892
94102220109075.772727273-6855.77272727272
953872140919.9090909091-2198.90909090909
96168764137658.68965517231105.3103448276
97151588109075.77272727342512.2272727273
98193496617.5714285714312731.4285714286
99125440137658.689655172-12218.6896551724
100101954137658.689655172-35704.6896551724
1014380340919.90909090912883.09090909091
1024706275554.8108108108-28492.8108108108
103104220109075.772727273-4855.77272727272
1048593975554.810810810810384.1891891892
1055866040919.909090909117740.0909090909
1062767640919.9090909091-13243.9090909091
1079344875554.810810810817893.1891891892
1084328440919.90909090912364.09090909091
10906617.57142857143-6617.57142857143
1106433375554.8108108108-11221.8108108108
1115705075554.8108108108-18504.8108108108
11296933109075.772727273-12142.7727272727
1137008875554.8108108108-5466.81081081081
1146549475554.8108108108-10060.8108108108
11536166617.57142857143-3001.57142857143
11606617.57142857143-6617.57142857143
11713510475554.810810810859549.1891891892
11895554109075.772727273-13521.7727272727
119120307109075.77272727311231.2272727273
1208433675554.81081081088781.18918918919
1214341075554.8108108108-32144.8108108108
122131452109075.77272727322376.2272727273
1237901575554.81081081083460.18918918919
12488043109075.772727273-21032.7727272727
1255757875554.8108108108-17976.8108108108
126197646617.5714285714313146.4285714286
127105757109075.772727273-3318.77272727272
1289641075554.810810810820855.1891891892
129105056109075.772727273-4019.77272727272
130117966617.571428571435178.42857142857
13176276617.571428571431009.42857142857
132117413109075.7727272738337.22727272728
13368366617.57142857143218.428571428572
134131955137658.689655172-5703.68965517241
13551186617.57142857143-1499.57142857143
1364024840919.9090909091-671.909090909088
13706617.57142857143-6617.57142857143
1387781375554.81081081082258.18918918919
13967140109075.772727273-41935.7727272727
14071316617.57142857143513.428571428572
14141946617.57142857143-2423.57142857143
1426037875554.8108108108-15176.8108108108
1439697175554.810810810821416.1891891892
1448348475554.81081081087929.18918918919



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