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 computationTue, 20 Dec 2011 11:35:07 -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/20/t13243989482v65f3ujpjmamlv.htm/, Retrieved Thu, 30 May 2024 02:02:05 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158042, Retrieved Thu, 30 May 2024 02:02:05 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact87
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [Regression Trees ...] [2011-12-20 16:35:07] [4352eab26b4a512b718de67a19830b91] [Current]
Feedback Forum

Post a new message
Dataseries X:
1347	117788	72	416	101	0	20	15	18158
1042	121102	43	294	63	1	38	16	30461
192	7215	18	72	1	0	0	0	1423
2029	112854	83	583	146	0	49	22	25629
3032	197581	120	1013	114	0	70	25	48758
5488	377043	204	1496	260	1	104	26	129230
1321	117604	49	442	83	1	37	19	27376
1034	120102	44	274	48	0	46	25	26706
1388	96175	36	382	77	0	42	25	26505
2430	245851	84	781	115	1	62	22	49801
1735	108994	65	546	146	1	50	20	46580
1788	156212	58	551	94	0	65	25	48352
1292	68810	84	477	57	0	28	15	13899
2347	146004	83	791	235	4	48	21	39342
1089	117564	40	318	40	4	37	12	27465
1253	111160	59	395	74	3	38	16	55211
1503	123467	49	364	85	0	71	28	74098
965	56088	45	277	61	5	0	12	13497
2136	107912	72	648	125	0	50	28	38338
620	22648	19	184	44	0	12	13	52505
837	48554	48	286	37	0	16	14	10663
1972	156405	75	573	86	0	73	23	74484
1395	133000	55	497	127	0	18	25	28895
1751	91746	42	523	159	1	38	30	32827
1594	126119	69	510	35	1	50	17	36188
1173	113807	21	426	153	0	33	17	28173
1549	130568	130	494	80	0	43	19	54926
1046	131810	71	248	51	0	59	24	38900
2155	278309	95	715	69	0	47	22	88530
1727	156532	34	717	78	0	40	16	35482
1167	107352	36	374	71	0	33	23	26730
1373	147314	37	463	102	2	50	17	29806
1707	90772	82	540	70	4	41	11	41799
2134	127346	86	664	167	0	73	20	54289
1852	162204	40	596	61	1	43	20	36805
1	0	1	0	0	0	0	0	0
1281	122675	50	581	55	0	23	24	33146
1505	92342	46	464	131	3	44	14	23333
1621	79698	37	350	256	9	21	28	47686
1482	159364	46	543	51	0	65	26	77783
1547	133888	52	489	79	2	61	15	36042
1294	104129	46	488	57	0	27	29	34541
784	81614	23	281	32	2	21	20	75620
1561	118909	59	598	49	1	42	20	60610
896	83923	39	278	39	1	40	18	55041
904	96795	69	230	32	2	32	19	32087
567	52851	24	162	40	1	15	28	16356
1519	153621	73	525	94	0	46	18	40161
1422	130383	74	438	98	1	34	21	55459
1780	112331	43	662	137	4	37	23	36679
658	48188	28	205	37	0	12	22	22346
1187	90994	52	306	49	0	42	19	27377
1863	215588	61	680	79	0	56	20	50273
1391	154943	61	474	58	0	38	22	32104
1339	138871	45	487	39	1	46	27	27016
1342	104416	44	418	68	5	30	10	19715
1449	148763	51	390	50	0	44	21	33629
669	60368	16	189	59	0	25	21	27084
814	95391	53	275	28	0	42	19	32352
1944	101193	57	644	49	10	24	30	51845
1172	83172	42	319	61	6	25	27	26591
1364	77279	57	486	75	0	32	16	29677
963	78798	39	295	81	11	20	16	54237
809	79599	25	258	42	3	30	20	20284
789	96945	22	268	43	0	13	20	22741
1134	88300	34	364	30	0	35	24	34178
1765	118903	57	409	71	8	39	26	69551
2289	110681	56	689	137	2	68	21	29653
797	78270	29	199	45	0	32	21	38071
340	31970	15	101	40	0	5	21	4157
2100	161669	96	688	126	3	53	15	28321
977	87545	49	289	74	1	33	9	40195
968	72940	50	327	48	1	44	21	48158
1299	71183	53	382	82	1	36	18	13310
1902	97814	40	483	68	0	46	27	78464
933	49164	29	248	60	2	0	24	6386
1600	105181	48	424	92	1	49	22	31588
1803	105233	70	622	62	0	29	21	61254
816	60138	23	253	76	0	16	21	21152
1121	73422	66	366	92	0	33	26	41272
795	67706	53	189	45	0	48	22	34165
1446	188098	45	515	46	0	33	22	37054
750	51185	23	221	44	0	24	20	12368
1171	84448	28	404	109	0	33	21	23168
662	41956	35	219	43	0	16	19	16380
1240	108493	38	359	64	0	32	19	41242
1963	166900	171	424	82	0	41	25	48259
874	63603	73	209	68	0	36	19	20790
862	64494	42	275	43	4	22	20	34585
1000	93424	36	382	63	0	26	18	35672
1240	97229	32	446	54	3	37	23	52168
1771	112819	60	521	82	1	57	18	53933
891	105737	47	287	52	0	20	18	34474
1042	102220	50	382	74	0	24	12	43753
617	38583	28	249	18	0	18	9	36456
1770	168764	85	569	131	0	37	26	51183
1355	142096	44	405	81	0	67	21	52742
222	19349	11	67	15	0	13	1	3895
1434	119212	74	477	98	1	18	21	37076
1297	101941	48	520	44	0	32	18	24079
552	43803	24	240	11	0	8	4	2325
702	47054	19	218	36	0	38	15	29354
998	104220	43	329	70	0	41	19	30341
860	83354	48	213	62	1	24	20	18992
580	58585	35	135	27	0	23	12	15292
596	27676	22	194	59	0	2	16	5842
926	93448	31	209	103	0	52	21	28918
576	43284	22	151	24	0	5	9	3738
0	0	0	0	0	0	0	0	0
868	64333	23	237	53	0	43	21	95352
736	57050	46	236	42	0	18	17	37478
998	96933	34	323	45	0	41	18	26839
915	70088	46	296	55	0	45	21	26783
782	65494	55	267	66	0	29	17	33392
38	3058	4	1	0	0	0	0	0
0	0	0	0	0	0	0	0	0
760	133793	32	255	53	0	32	19	25446
1157	95530	60	390	67	0	41	26	60038
1641	119970	77	468	112	1	17	25	28162
749	84336	32	243	51	0	24	20	33298
778	43410	19	292	63	0	7	1	2781
1335	131452	55	400	81	1	62	21	37121
806	79015	33	217	35	0	30	14	22698
1357	87570	39	384	55	8	49	24	27615
679	57578	35	160	29	3	3	12	32689
285	19764	12	75	19	1	10	2	5752
1296	100160	40	402	48	2	41	16	23164
840	96410	22	293	51	0	18	22	20304
1145	98010	28	377	89	0	38	24	34409
256	11796	9	79	22	0	1	2	0
80	7627	8	25	7	0	0	0	0
1096	110721	47	387	34	0	27	17	92538
41	6836	3	11	5	0	0	1	0
1540	131955	37	539	43	4	45	17	46037
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
768	77065	35	271	45	0	16	21	23924
1086	67140	28	196	42	0	16	24	52230
81	7131	4	27	0	1	0	0	0
61	4194	11	14	4	0	0	0	0
849	60378	20	240	40	1	15	15	8019
887	81731	39	210	49	0	38	18	34542
964	83484	16	347	47	0	17	19	21157




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158042&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.8464
R-squared0.7164
RMSE28799.1643

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8464[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7164[/C][/ROW]
[ROW][C]RMSE[/C][C]28799.1643[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158042&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158042&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.8464
R-squared0.7164
RMSE28799.1643







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1117788113284.754503.25
2121102113284.757817.25
372156577.71428571429637.285714285715
4112854133924.137931034-21070.1379310345
5197581209054.428571429-11473.4285714286
6377043209054.428571429167988.571428571
7117604113284.754319.25
8120102113284.756817.25
99617598033.5-1858.5
10245851209054.42857142936796.5714285714
11108994133924.137931034-24930.1379310345
12156212133924.13793103422287.8620689655
1368810113284.75-44474.75
14146004209054.428571429-63050.4285714286
1511756498033.519530.5
16111160113284.75-2124.75
17123467113284.7510182.25
185608874510.2162162162-18422.2162162162
19107912209054.428571429-101142.428571429
202264840890.1818181818-18242.1818181818
214855474510.2162162162-25956.2162162162
22156405133924.13793103422480.8620689655
23133000133924.137931034-924.137931034493
2491746133924.137931034-42178.1379310345
25126119133924.137931034-7805.13793103449
2611380798033.515773.5
27130568133924.137931034-3356.13793103449
28131810113284.7518525.25
29278309209054.42857142969254.5714285714
30156532133924.13793103422607.8620689655
3110735298033.59318.5
3214731498033.549280.5
3390772133924.137931034-43152.1379310345
34127346133924.137931034-6578.13793103449
35162204133924.13793103428279.8620689655
3606577.71428571429-6577.71428571429
37122675133924.137931034-11249.1379310345
3892342113284.75-20942.75
397969898033.5-18335.5
40159364133924.13793103425439.8620689655
41133888133924.137931034-36.1379310344928
42104129133924.137931034-29795.1379310345
438161474510.21621621627103.78378378379
44118909133924.137931034-15015.1379310345
458392374510.21621621629412.78378378379
469679574510.216216216222284.7837837838
475285140890.181818181811960.8181818182
48153621133924.13793103419696.8620689655
49130383113284.7517098.25
50112331133924.137931034-21593.1379310345
514818840890.18181818187297.81818181818
5290994113284.75-22290.75
53215588133924.13793103481663.8620689655
54154943113284.7541658.25
55138871133924.1379310344946.86206896551
56104416113284.75-8868.75
57148763113284.7535478.25
586036874510.2162162162-14142.2162162162
599539174510.216216216220880.7837837838
60101193133924.137931034-32731.1379310345
618317298033.5-14861.5
6277279113284.75-36005.75
637879874510.21621621624287.78378378379
647959974510.21621621625088.78378378379
659694574510.216216216222434.7837837838
668830098033.5-9733.5
67118903113284.755618.25
68110681209054.428571429-98373.4285714286
697827074510.21621621623759.78378378379
703197040890.1818181818-8920.18181818182
71161669133924.13793103427744.8620689655
728754574510.216216216213034.7837837838
737294074510.2162162162-1570.21621621621
7471183113284.75-42101.75
759781498033.5-219.5
764916474510.2162162162-25346.2162162162
77105181113284.75-8103.75
78105233133924.137931034-28691.1379310345
796013874510.2162162162-14372.2162162162
8073422113284.75-39862.75
816770674510.2162162162-6804.21621621621
82188098133924.13793103454173.8620689655
835118574510.2162162162-23325.2162162162
848444898033.5-13585.5
854195640890.18181818181065.81818181818
8610849398033.510459.5
87166900113284.7553615.25
886360374510.2162162162-10907.2162162162
896449474510.2162162162-10016.2162162162
909342498033.5-4609.5
919722998033.5-804.5
92112819133924.137931034-21105.1379310345
9310573774510.216216216231226.7837837838
94102220113284.75-11064.75
953858340890.1818181818-2307.18181818182
96168764133924.13793103434839.8620689655
97142096113284.7528811.25
98193496577.7142857142912771.2857142857
99119212113284.755927.25
100101941133924.137931034-31983.1379310345
1014380340890.18181818182912.81818181818
1024705474510.2162162162-27456.2162162162
103104220113284.75-9064.75
1048335474510.21621621628843.78378378379
1055858540890.181818181817694.8181818182
1062767640890.1818181818-13214.1818181818
1079344874510.216216216218937.7837837838
1084328440890.18181818182393.81818181818
10906577.71428571429-6577.71428571429
1106433374510.2162162162-10177.2162162162
1115705074510.2162162162-17460.2162162162
1129693398033.5-1100.5
1137008874510.2162162162-4422.21621621621
1146549474510.2162162162-9016.21621621621
11530586577.71428571429-3519.71428571429
11606577.71428571429-6577.71428571429
11713379374510.216216216259282.7837837838
11895530113284.75-17754.75
119119970113284.756685.25
1208433674510.21621621629825.78378378379
1214341074510.2162162162-31100.2162162162
122131452113284.7518167.25
1237901574510.21621621624504.78378378379
1248757098033.5-10463.5
1255757874510.2162162162-16932.2162162162
126197646577.7142857142913186.2857142857
12710016098033.52126.5
1289641074510.216216216221899.7837837838
1299801098033.5-23.5
130117966577.714285714295218.28571428571
13176276577.714285714291049.28571428571
132110721113284.75-2563.75
13368366577.71428571429258.285714285715
134131955133924.137931034-1969.13793103449
13551186577.71428571429-1459.71428571429
1364024840890.1818181818-642.181818181816
13706577.71428571429-6577.71428571429
1387706574510.21621621622554.78378378379
1396714098033.5-30893.5
14071316577.71428571429553.285714285715
14141946577.71428571429-2383.71428571429
1426037874510.2162162162-14132.2162162162
1438173174510.21621621627220.78378378379
1448348474510.21621621628973.78378378379

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 117788 & 113284.75 & 4503.25 \tabularnewline
2 & 121102 & 113284.75 & 7817.25 \tabularnewline
3 & 7215 & 6577.71428571429 & 637.285714285715 \tabularnewline
4 & 112854 & 133924.137931034 & -21070.1379310345 \tabularnewline
5 & 197581 & 209054.428571429 & -11473.4285714286 \tabularnewline
6 & 377043 & 209054.428571429 & 167988.571428571 \tabularnewline
7 & 117604 & 113284.75 & 4319.25 \tabularnewline
8 & 120102 & 113284.75 & 6817.25 \tabularnewline
9 & 96175 & 98033.5 & -1858.5 \tabularnewline
10 & 245851 & 209054.428571429 & 36796.5714285714 \tabularnewline
11 & 108994 & 133924.137931034 & -24930.1379310345 \tabularnewline
12 & 156212 & 133924.137931034 & 22287.8620689655 \tabularnewline
13 & 68810 & 113284.75 & -44474.75 \tabularnewline
14 & 146004 & 209054.428571429 & -63050.4285714286 \tabularnewline
15 & 117564 & 98033.5 & 19530.5 \tabularnewline
16 & 111160 & 113284.75 & -2124.75 \tabularnewline
17 & 123467 & 113284.75 & 10182.25 \tabularnewline
18 & 56088 & 74510.2162162162 & -18422.2162162162 \tabularnewline
19 & 107912 & 209054.428571429 & -101142.428571429 \tabularnewline
20 & 22648 & 40890.1818181818 & -18242.1818181818 \tabularnewline
21 & 48554 & 74510.2162162162 & -25956.2162162162 \tabularnewline
22 & 156405 & 133924.137931034 & 22480.8620689655 \tabularnewline
23 & 133000 & 133924.137931034 & -924.137931034493 \tabularnewline
24 & 91746 & 133924.137931034 & -42178.1379310345 \tabularnewline
25 & 126119 & 133924.137931034 & -7805.13793103449 \tabularnewline
26 & 113807 & 98033.5 & 15773.5 \tabularnewline
27 & 130568 & 133924.137931034 & -3356.13793103449 \tabularnewline
28 & 131810 & 113284.75 & 18525.25 \tabularnewline
29 & 278309 & 209054.428571429 & 69254.5714285714 \tabularnewline
30 & 156532 & 133924.137931034 & 22607.8620689655 \tabularnewline
31 & 107352 & 98033.5 & 9318.5 \tabularnewline
32 & 147314 & 98033.5 & 49280.5 \tabularnewline
33 & 90772 & 133924.137931034 & -43152.1379310345 \tabularnewline
34 & 127346 & 133924.137931034 & -6578.13793103449 \tabularnewline
35 & 162204 & 133924.137931034 & 28279.8620689655 \tabularnewline
36 & 0 & 6577.71428571429 & -6577.71428571429 \tabularnewline
37 & 122675 & 133924.137931034 & -11249.1379310345 \tabularnewline
38 & 92342 & 113284.75 & -20942.75 \tabularnewline
39 & 79698 & 98033.5 & -18335.5 \tabularnewline
40 & 159364 & 133924.137931034 & 25439.8620689655 \tabularnewline
41 & 133888 & 133924.137931034 & -36.1379310344928 \tabularnewline
42 & 104129 & 133924.137931034 & -29795.1379310345 \tabularnewline
43 & 81614 & 74510.2162162162 & 7103.78378378379 \tabularnewline
44 & 118909 & 133924.137931034 & -15015.1379310345 \tabularnewline
45 & 83923 & 74510.2162162162 & 9412.78378378379 \tabularnewline
46 & 96795 & 74510.2162162162 & 22284.7837837838 \tabularnewline
47 & 52851 & 40890.1818181818 & 11960.8181818182 \tabularnewline
48 & 153621 & 133924.137931034 & 19696.8620689655 \tabularnewline
49 & 130383 & 113284.75 & 17098.25 \tabularnewline
50 & 112331 & 133924.137931034 & -21593.1379310345 \tabularnewline
51 & 48188 & 40890.1818181818 & 7297.81818181818 \tabularnewline
52 & 90994 & 113284.75 & -22290.75 \tabularnewline
53 & 215588 & 133924.137931034 & 81663.8620689655 \tabularnewline
54 & 154943 & 113284.75 & 41658.25 \tabularnewline
55 & 138871 & 133924.137931034 & 4946.86206896551 \tabularnewline
56 & 104416 & 113284.75 & -8868.75 \tabularnewline
57 & 148763 & 113284.75 & 35478.25 \tabularnewline
58 & 60368 & 74510.2162162162 & -14142.2162162162 \tabularnewline
59 & 95391 & 74510.2162162162 & 20880.7837837838 \tabularnewline
60 & 101193 & 133924.137931034 & -32731.1379310345 \tabularnewline
61 & 83172 & 98033.5 & -14861.5 \tabularnewline
62 & 77279 & 113284.75 & -36005.75 \tabularnewline
63 & 78798 & 74510.2162162162 & 4287.78378378379 \tabularnewline
64 & 79599 & 74510.2162162162 & 5088.78378378379 \tabularnewline
65 & 96945 & 74510.2162162162 & 22434.7837837838 \tabularnewline
66 & 88300 & 98033.5 & -9733.5 \tabularnewline
67 & 118903 & 113284.75 & 5618.25 \tabularnewline
68 & 110681 & 209054.428571429 & -98373.4285714286 \tabularnewline
69 & 78270 & 74510.2162162162 & 3759.78378378379 \tabularnewline
70 & 31970 & 40890.1818181818 & -8920.18181818182 \tabularnewline
71 & 161669 & 133924.137931034 & 27744.8620689655 \tabularnewline
72 & 87545 & 74510.2162162162 & 13034.7837837838 \tabularnewline
73 & 72940 & 74510.2162162162 & -1570.21621621621 \tabularnewline
74 & 71183 & 113284.75 & -42101.75 \tabularnewline
75 & 97814 & 98033.5 & -219.5 \tabularnewline
76 & 49164 & 74510.2162162162 & -25346.2162162162 \tabularnewline
77 & 105181 & 113284.75 & -8103.75 \tabularnewline
78 & 105233 & 133924.137931034 & -28691.1379310345 \tabularnewline
79 & 60138 & 74510.2162162162 & -14372.2162162162 \tabularnewline
80 & 73422 & 113284.75 & -39862.75 \tabularnewline
81 & 67706 & 74510.2162162162 & -6804.21621621621 \tabularnewline
82 & 188098 & 133924.137931034 & 54173.8620689655 \tabularnewline
83 & 51185 & 74510.2162162162 & -23325.2162162162 \tabularnewline
84 & 84448 & 98033.5 & -13585.5 \tabularnewline
85 & 41956 & 40890.1818181818 & 1065.81818181818 \tabularnewline
86 & 108493 & 98033.5 & 10459.5 \tabularnewline
87 & 166900 & 113284.75 & 53615.25 \tabularnewline
88 & 63603 & 74510.2162162162 & -10907.2162162162 \tabularnewline
89 & 64494 & 74510.2162162162 & -10016.2162162162 \tabularnewline
90 & 93424 & 98033.5 & -4609.5 \tabularnewline
91 & 97229 & 98033.5 & -804.5 \tabularnewline
92 & 112819 & 133924.137931034 & -21105.1379310345 \tabularnewline
93 & 105737 & 74510.2162162162 & 31226.7837837838 \tabularnewline
94 & 102220 & 113284.75 & -11064.75 \tabularnewline
95 & 38583 & 40890.1818181818 & -2307.18181818182 \tabularnewline
96 & 168764 & 133924.137931034 & 34839.8620689655 \tabularnewline
97 & 142096 & 113284.75 & 28811.25 \tabularnewline
98 & 19349 & 6577.71428571429 & 12771.2857142857 \tabularnewline
99 & 119212 & 113284.75 & 5927.25 \tabularnewline
100 & 101941 & 133924.137931034 & -31983.1379310345 \tabularnewline
101 & 43803 & 40890.1818181818 & 2912.81818181818 \tabularnewline
102 & 47054 & 74510.2162162162 & -27456.2162162162 \tabularnewline
103 & 104220 & 113284.75 & -9064.75 \tabularnewline
104 & 83354 & 74510.2162162162 & 8843.78378378379 \tabularnewline
105 & 58585 & 40890.1818181818 & 17694.8181818182 \tabularnewline
106 & 27676 & 40890.1818181818 & -13214.1818181818 \tabularnewline
107 & 93448 & 74510.2162162162 & 18937.7837837838 \tabularnewline
108 & 43284 & 40890.1818181818 & 2393.81818181818 \tabularnewline
109 & 0 & 6577.71428571429 & -6577.71428571429 \tabularnewline
110 & 64333 & 74510.2162162162 & -10177.2162162162 \tabularnewline
111 & 57050 & 74510.2162162162 & -17460.2162162162 \tabularnewline
112 & 96933 & 98033.5 & -1100.5 \tabularnewline
113 & 70088 & 74510.2162162162 & -4422.21621621621 \tabularnewline
114 & 65494 & 74510.2162162162 & -9016.21621621621 \tabularnewline
115 & 3058 & 6577.71428571429 & -3519.71428571429 \tabularnewline
116 & 0 & 6577.71428571429 & -6577.71428571429 \tabularnewline
117 & 133793 & 74510.2162162162 & 59282.7837837838 \tabularnewline
118 & 95530 & 113284.75 & -17754.75 \tabularnewline
119 & 119970 & 113284.75 & 6685.25 \tabularnewline
120 & 84336 & 74510.2162162162 & 9825.78378378379 \tabularnewline
121 & 43410 & 74510.2162162162 & -31100.2162162162 \tabularnewline
122 & 131452 & 113284.75 & 18167.25 \tabularnewline
123 & 79015 & 74510.2162162162 & 4504.78378378379 \tabularnewline
124 & 87570 & 98033.5 & -10463.5 \tabularnewline
125 & 57578 & 74510.2162162162 & -16932.2162162162 \tabularnewline
126 & 19764 & 6577.71428571429 & 13186.2857142857 \tabularnewline
127 & 100160 & 98033.5 & 2126.5 \tabularnewline
128 & 96410 & 74510.2162162162 & 21899.7837837838 \tabularnewline
129 & 98010 & 98033.5 & -23.5 \tabularnewline
130 & 11796 & 6577.71428571429 & 5218.28571428571 \tabularnewline
131 & 7627 & 6577.71428571429 & 1049.28571428571 \tabularnewline
132 & 110721 & 113284.75 & -2563.75 \tabularnewline
133 & 6836 & 6577.71428571429 & 258.285714285715 \tabularnewline
134 & 131955 & 133924.137931034 & -1969.13793103449 \tabularnewline
135 & 5118 & 6577.71428571429 & -1459.71428571429 \tabularnewline
136 & 40248 & 40890.1818181818 & -642.181818181816 \tabularnewline
137 & 0 & 6577.71428571429 & -6577.71428571429 \tabularnewline
138 & 77065 & 74510.2162162162 & 2554.78378378379 \tabularnewline
139 & 67140 & 98033.5 & -30893.5 \tabularnewline
140 & 7131 & 6577.71428571429 & 553.285714285715 \tabularnewline
141 & 4194 & 6577.71428571429 & -2383.71428571429 \tabularnewline
142 & 60378 & 74510.2162162162 & -14132.2162162162 \tabularnewline
143 & 81731 & 74510.2162162162 & 7220.78378378379 \tabularnewline
144 & 83484 & 74510.2162162162 & 8973.78378378379 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158042&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]117788[/C][C]113284.75[/C][C]4503.25[/C][/ROW]
[ROW][C]2[/C][C]121102[/C][C]113284.75[/C][C]7817.25[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]6577.71428571429[/C][C]637.285714285715[/C][/ROW]
[ROW][C]4[/C][C]112854[/C][C]133924.137931034[/C][C]-21070.1379310345[/C][/ROW]
[ROW][C]5[/C][C]197581[/C][C]209054.428571429[/C][C]-11473.4285714286[/C][/ROW]
[ROW][C]6[/C][C]377043[/C][C]209054.428571429[/C][C]167988.571428571[/C][/ROW]
[ROW][C]7[/C][C]117604[/C][C]113284.75[/C][C]4319.25[/C][/ROW]
[ROW][C]8[/C][C]120102[/C][C]113284.75[/C][C]6817.25[/C][/ROW]
[ROW][C]9[/C][C]96175[/C][C]98033.5[/C][C]-1858.5[/C][/ROW]
[ROW][C]10[/C][C]245851[/C][C]209054.428571429[/C][C]36796.5714285714[/C][/ROW]
[ROW][C]11[/C][C]108994[/C][C]133924.137931034[/C][C]-24930.1379310345[/C][/ROW]
[ROW][C]12[/C][C]156212[/C][C]133924.137931034[/C][C]22287.8620689655[/C][/ROW]
[ROW][C]13[/C][C]68810[/C][C]113284.75[/C][C]-44474.75[/C][/ROW]
[ROW][C]14[/C][C]146004[/C][C]209054.428571429[/C][C]-63050.4285714286[/C][/ROW]
[ROW][C]15[/C][C]117564[/C][C]98033.5[/C][C]19530.5[/C][/ROW]
[ROW][C]16[/C][C]111160[/C][C]113284.75[/C][C]-2124.75[/C][/ROW]
[ROW][C]17[/C][C]123467[/C][C]113284.75[/C][C]10182.25[/C][/ROW]
[ROW][C]18[/C][C]56088[/C][C]74510.2162162162[/C][C]-18422.2162162162[/C][/ROW]
[ROW][C]19[/C][C]107912[/C][C]209054.428571429[/C][C]-101142.428571429[/C][/ROW]
[ROW][C]20[/C][C]22648[/C][C]40890.1818181818[/C][C]-18242.1818181818[/C][/ROW]
[ROW][C]21[/C][C]48554[/C][C]74510.2162162162[/C][C]-25956.2162162162[/C][/ROW]
[ROW][C]22[/C][C]156405[/C][C]133924.137931034[/C][C]22480.8620689655[/C][/ROW]
[ROW][C]23[/C][C]133000[/C][C]133924.137931034[/C][C]-924.137931034493[/C][/ROW]
[ROW][C]24[/C][C]91746[/C][C]133924.137931034[/C][C]-42178.1379310345[/C][/ROW]
[ROW][C]25[/C][C]126119[/C][C]133924.137931034[/C][C]-7805.13793103449[/C][/ROW]
[ROW][C]26[/C][C]113807[/C][C]98033.5[/C][C]15773.5[/C][/ROW]
[ROW][C]27[/C][C]130568[/C][C]133924.137931034[/C][C]-3356.13793103449[/C][/ROW]
[ROW][C]28[/C][C]131810[/C][C]113284.75[/C][C]18525.25[/C][/ROW]
[ROW][C]29[/C][C]278309[/C][C]209054.428571429[/C][C]69254.5714285714[/C][/ROW]
[ROW][C]30[/C][C]156532[/C][C]133924.137931034[/C][C]22607.8620689655[/C][/ROW]
[ROW][C]31[/C][C]107352[/C][C]98033.5[/C][C]9318.5[/C][/ROW]
[ROW][C]32[/C][C]147314[/C][C]98033.5[/C][C]49280.5[/C][/ROW]
[ROW][C]33[/C][C]90772[/C][C]133924.137931034[/C][C]-43152.1379310345[/C][/ROW]
[ROW][C]34[/C][C]127346[/C][C]133924.137931034[/C][C]-6578.13793103449[/C][/ROW]
[ROW][C]35[/C][C]162204[/C][C]133924.137931034[/C][C]28279.8620689655[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]6577.71428571429[/C][C]-6577.71428571429[/C][/ROW]
[ROW][C]37[/C][C]122675[/C][C]133924.137931034[/C][C]-11249.1379310345[/C][/ROW]
[ROW][C]38[/C][C]92342[/C][C]113284.75[/C][C]-20942.75[/C][/ROW]
[ROW][C]39[/C][C]79698[/C][C]98033.5[/C][C]-18335.5[/C][/ROW]
[ROW][C]40[/C][C]159364[/C][C]133924.137931034[/C][C]25439.8620689655[/C][/ROW]
[ROW][C]41[/C][C]133888[/C][C]133924.137931034[/C][C]-36.1379310344928[/C][/ROW]
[ROW][C]42[/C][C]104129[/C][C]133924.137931034[/C][C]-29795.1379310345[/C][/ROW]
[ROW][C]43[/C][C]81614[/C][C]74510.2162162162[/C][C]7103.78378378379[/C][/ROW]
[ROW][C]44[/C][C]118909[/C][C]133924.137931034[/C][C]-15015.1379310345[/C][/ROW]
[ROW][C]45[/C][C]83923[/C][C]74510.2162162162[/C][C]9412.78378378379[/C][/ROW]
[ROW][C]46[/C][C]96795[/C][C]74510.2162162162[/C][C]22284.7837837838[/C][/ROW]
[ROW][C]47[/C][C]52851[/C][C]40890.1818181818[/C][C]11960.8181818182[/C][/ROW]
[ROW][C]48[/C][C]153621[/C][C]133924.137931034[/C][C]19696.8620689655[/C][/ROW]
[ROW][C]49[/C][C]130383[/C][C]113284.75[/C][C]17098.25[/C][/ROW]
[ROW][C]50[/C][C]112331[/C][C]133924.137931034[/C][C]-21593.1379310345[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]40890.1818181818[/C][C]7297.81818181818[/C][/ROW]
[ROW][C]52[/C][C]90994[/C][C]113284.75[/C][C]-22290.75[/C][/ROW]
[ROW][C]53[/C][C]215588[/C][C]133924.137931034[/C][C]81663.8620689655[/C][/ROW]
[ROW][C]54[/C][C]154943[/C][C]113284.75[/C][C]41658.25[/C][/ROW]
[ROW][C]55[/C][C]138871[/C][C]133924.137931034[/C][C]4946.86206896551[/C][/ROW]
[ROW][C]56[/C][C]104416[/C][C]113284.75[/C][C]-8868.75[/C][/ROW]
[ROW][C]57[/C][C]148763[/C][C]113284.75[/C][C]35478.25[/C][/ROW]
[ROW][C]58[/C][C]60368[/C][C]74510.2162162162[/C][C]-14142.2162162162[/C][/ROW]
[ROW][C]59[/C][C]95391[/C][C]74510.2162162162[/C][C]20880.7837837838[/C][/ROW]
[ROW][C]60[/C][C]101193[/C][C]133924.137931034[/C][C]-32731.1379310345[/C][/ROW]
[ROW][C]61[/C][C]83172[/C][C]98033.5[/C][C]-14861.5[/C][/ROW]
[ROW][C]62[/C][C]77279[/C][C]113284.75[/C][C]-36005.75[/C][/ROW]
[ROW][C]63[/C][C]78798[/C][C]74510.2162162162[/C][C]4287.78378378379[/C][/ROW]
[ROW][C]64[/C][C]79599[/C][C]74510.2162162162[/C][C]5088.78378378379[/C][/ROW]
[ROW][C]65[/C][C]96945[/C][C]74510.2162162162[/C][C]22434.7837837838[/C][/ROW]
[ROW][C]66[/C][C]88300[/C][C]98033.5[/C][C]-9733.5[/C][/ROW]
[ROW][C]67[/C][C]118903[/C][C]113284.75[/C][C]5618.25[/C][/ROW]
[ROW][C]68[/C][C]110681[/C][C]209054.428571429[/C][C]-98373.4285714286[/C][/ROW]
[ROW][C]69[/C][C]78270[/C][C]74510.2162162162[/C][C]3759.78378378379[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]40890.1818181818[/C][C]-8920.18181818182[/C][/ROW]
[ROW][C]71[/C][C]161669[/C][C]133924.137931034[/C][C]27744.8620689655[/C][/ROW]
[ROW][C]72[/C][C]87545[/C][C]74510.2162162162[/C][C]13034.7837837838[/C][/ROW]
[ROW][C]73[/C][C]72940[/C][C]74510.2162162162[/C][C]-1570.21621621621[/C][/ROW]
[ROW][C]74[/C][C]71183[/C][C]113284.75[/C][C]-42101.75[/C][/ROW]
[ROW][C]75[/C][C]97814[/C][C]98033.5[/C][C]-219.5[/C][/ROW]
[ROW][C]76[/C][C]49164[/C][C]74510.2162162162[/C][C]-25346.2162162162[/C][/ROW]
[ROW][C]77[/C][C]105181[/C][C]113284.75[/C][C]-8103.75[/C][/ROW]
[ROW][C]78[/C][C]105233[/C][C]133924.137931034[/C][C]-28691.1379310345[/C][/ROW]
[ROW][C]79[/C][C]60138[/C][C]74510.2162162162[/C][C]-14372.2162162162[/C][/ROW]
[ROW][C]80[/C][C]73422[/C][C]113284.75[/C][C]-39862.75[/C][/ROW]
[ROW][C]81[/C][C]67706[/C][C]74510.2162162162[/C][C]-6804.21621621621[/C][/ROW]
[ROW][C]82[/C][C]188098[/C][C]133924.137931034[/C][C]54173.8620689655[/C][/ROW]
[ROW][C]83[/C][C]51185[/C][C]74510.2162162162[/C][C]-23325.2162162162[/C][/ROW]
[ROW][C]84[/C][C]84448[/C][C]98033.5[/C][C]-13585.5[/C][/ROW]
[ROW][C]85[/C][C]41956[/C][C]40890.1818181818[/C][C]1065.81818181818[/C][/ROW]
[ROW][C]86[/C][C]108493[/C][C]98033.5[/C][C]10459.5[/C][/ROW]
[ROW][C]87[/C][C]166900[/C][C]113284.75[/C][C]53615.25[/C][/ROW]
[ROW][C]88[/C][C]63603[/C][C]74510.2162162162[/C][C]-10907.2162162162[/C][/ROW]
[ROW][C]89[/C][C]64494[/C][C]74510.2162162162[/C][C]-10016.2162162162[/C][/ROW]
[ROW][C]90[/C][C]93424[/C][C]98033.5[/C][C]-4609.5[/C][/ROW]
[ROW][C]91[/C][C]97229[/C][C]98033.5[/C][C]-804.5[/C][/ROW]
[ROW][C]92[/C][C]112819[/C][C]133924.137931034[/C][C]-21105.1379310345[/C][/ROW]
[ROW][C]93[/C][C]105737[/C][C]74510.2162162162[/C][C]31226.7837837838[/C][/ROW]
[ROW][C]94[/C][C]102220[/C][C]113284.75[/C][C]-11064.75[/C][/ROW]
[ROW][C]95[/C][C]38583[/C][C]40890.1818181818[/C][C]-2307.18181818182[/C][/ROW]
[ROW][C]96[/C][C]168764[/C][C]133924.137931034[/C][C]34839.8620689655[/C][/ROW]
[ROW][C]97[/C][C]142096[/C][C]113284.75[/C][C]28811.25[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]6577.71428571429[/C][C]12771.2857142857[/C][/ROW]
[ROW][C]99[/C][C]119212[/C][C]113284.75[/C][C]5927.25[/C][/ROW]
[ROW][C]100[/C][C]101941[/C][C]133924.137931034[/C][C]-31983.1379310345[/C][/ROW]
[ROW][C]101[/C][C]43803[/C][C]40890.1818181818[/C][C]2912.81818181818[/C][/ROW]
[ROW][C]102[/C][C]47054[/C][C]74510.2162162162[/C][C]-27456.2162162162[/C][/ROW]
[ROW][C]103[/C][C]104220[/C][C]113284.75[/C][C]-9064.75[/C][/ROW]
[ROW][C]104[/C][C]83354[/C][C]74510.2162162162[/C][C]8843.78378378379[/C][/ROW]
[ROW][C]105[/C][C]58585[/C][C]40890.1818181818[/C][C]17694.8181818182[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]40890.1818181818[/C][C]-13214.1818181818[/C][/ROW]
[ROW][C]107[/C][C]93448[/C][C]74510.2162162162[/C][C]18937.7837837838[/C][/ROW]
[ROW][C]108[/C][C]43284[/C][C]40890.1818181818[/C][C]2393.81818181818[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]6577.71428571429[/C][C]-6577.71428571429[/C][/ROW]
[ROW][C]110[/C][C]64333[/C][C]74510.2162162162[/C][C]-10177.2162162162[/C][/ROW]
[ROW][C]111[/C][C]57050[/C][C]74510.2162162162[/C][C]-17460.2162162162[/C][/ROW]
[ROW][C]112[/C][C]96933[/C][C]98033.5[/C][C]-1100.5[/C][/ROW]
[ROW][C]113[/C][C]70088[/C][C]74510.2162162162[/C][C]-4422.21621621621[/C][/ROW]
[ROW][C]114[/C][C]65494[/C][C]74510.2162162162[/C][C]-9016.21621621621[/C][/ROW]
[ROW][C]115[/C][C]3058[/C][C]6577.71428571429[/C][C]-3519.71428571429[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]6577.71428571429[/C][C]-6577.71428571429[/C][/ROW]
[ROW][C]117[/C][C]133793[/C][C]74510.2162162162[/C][C]59282.7837837838[/C][/ROW]
[ROW][C]118[/C][C]95530[/C][C]113284.75[/C][C]-17754.75[/C][/ROW]
[ROW][C]119[/C][C]119970[/C][C]113284.75[/C][C]6685.25[/C][/ROW]
[ROW][C]120[/C][C]84336[/C][C]74510.2162162162[/C][C]9825.78378378379[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]74510.2162162162[/C][C]-31100.2162162162[/C][/ROW]
[ROW][C]122[/C][C]131452[/C][C]113284.75[/C][C]18167.25[/C][/ROW]
[ROW][C]123[/C][C]79015[/C][C]74510.2162162162[/C][C]4504.78378378379[/C][/ROW]
[ROW][C]124[/C][C]87570[/C][C]98033.5[/C][C]-10463.5[/C][/ROW]
[ROW][C]125[/C][C]57578[/C][C]74510.2162162162[/C][C]-16932.2162162162[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]6577.71428571429[/C][C]13186.2857142857[/C][/ROW]
[ROW][C]127[/C][C]100160[/C][C]98033.5[/C][C]2126.5[/C][/ROW]
[ROW][C]128[/C][C]96410[/C][C]74510.2162162162[/C][C]21899.7837837838[/C][/ROW]
[ROW][C]129[/C][C]98010[/C][C]98033.5[/C][C]-23.5[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]6577.71428571429[/C][C]5218.28571428571[/C][/ROW]
[ROW][C]131[/C][C]7627[/C][C]6577.71428571429[/C][C]1049.28571428571[/C][/ROW]
[ROW][C]132[/C][C]110721[/C][C]113284.75[/C][C]-2563.75[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]6577.71428571429[/C][C]258.285714285715[/C][/ROW]
[ROW][C]134[/C][C]131955[/C][C]133924.137931034[/C][C]-1969.13793103449[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]6577.71428571429[/C][C]-1459.71428571429[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]40890.1818181818[/C][C]-642.181818181816[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]6577.71428571429[/C][C]-6577.71428571429[/C][/ROW]
[ROW][C]138[/C][C]77065[/C][C]74510.2162162162[/C][C]2554.78378378379[/C][/ROW]
[ROW][C]139[/C][C]67140[/C][C]98033.5[/C][C]-30893.5[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]6577.71428571429[/C][C]553.285714285715[/C][/ROW]
[ROW][C]141[/C][C]4194[/C][C]6577.71428571429[/C][C]-2383.71428571429[/C][/ROW]
[ROW][C]142[/C][C]60378[/C][C]74510.2162162162[/C][C]-14132.2162162162[/C][/ROW]
[ROW][C]143[/C][C]81731[/C][C]74510.2162162162[/C][C]7220.78378378379[/C][/ROW]
[ROW][C]144[/C][C]83484[/C][C]74510.2162162162[/C][C]8973.78378378379[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158042&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158042&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
1117788113284.754503.25
2121102113284.757817.25
372156577.71428571429637.285714285715
4112854133924.137931034-21070.1379310345
5197581209054.428571429-11473.4285714286
6377043209054.428571429167988.571428571
7117604113284.754319.25
8120102113284.756817.25
99617598033.5-1858.5
10245851209054.42857142936796.5714285714
11108994133924.137931034-24930.1379310345
12156212133924.13793103422287.8620689655
1368810113284.75-44474.75
14146004209054.428571429-63050.4285714286
1511756498033.519530.5
16111160113284.75-2124.75
17123467113284.7510182.25
185608874510.2162162162-18422.2162162162
19107912209054.428571429-101142.428571429
202264840890.1818181818-18242.1818181818
214855474510.2162162162-25956.2162162162
22156405133924.13793103422480.8620689655
23133000133924.137931034-924.137931034493
2491746133924.137931034-42178.1379310345
25126119133924.137931034-7805.13793103449
2611380798033.515773.5
27130568133924.137931034-3356.13793103449
28131810113284.7518525.25
29278309209054.42857142969254.5714285714
30156532133924.13793103422607.8620689655
3110735298033.59318.5
3214731498033.549280.5
3390772133924.137931034-43152.1379310345
34127346133924.137931034-6578.13793103449
35162204133924.13793103428279.8620689655
3606577.71428571429-6577.71428571429
37122675133924.137931034-11249.1379310345
3892342113284.75-20942.75
397969898033.5-18335.5
40159364133924.13793103425439.8620689655
41133888133924.137931034-36.1379310344928
42104129133924.137931034-29795.1379310345
438161474510.21621621627103.78378378379
44118909133924.137931034-15015.1379310345
458392374510.21621621629412.78378378379
469679574510.216216216222284.7837837838
475285140890.181818181811960.8181818182
48153621133924.13793103419696.8620689655
49130383113284.7517098.25
50112331133924.137931034-21593.1379310345
514818840890.18181818187297.81818181818
5290994113284.75-22290.75
53215588133924.13793103481663.8620689655
54154943113284.7541658.25
55138871133924.1379310344946.86206896551
56104416113284.75-8868.75
57148763113284.7535478.25
586036874510.2162162162-14142.2162162162
599539174510.216216216220880.7837837838
60101193133924.137931034-32731.1379310345
618317298033.5-14861.5
6277279113284.75-36005.75
637879874510.21621621624287.78378378379
647959974510.21621621625088.78378378379
659694574510.216216216222434.7837837838
668830098033.5-9733.5
67118903113284.755618.25
68110681209054.428571429-98373.4285714286
697827074510.21621621623759.78378378379
703197040890.1818181818-8920.18181818182
71161669133924.13793103427744.8620689655
728754574510.216216216213034.7837837838
737294074510.2162162162-1570.21621621621
7471183113284.75-42101.75
759781498033.5-219.5
764916474510.2162162162-25346.2162162162
77105181113284.75-8103.75
78105233133924.137931034-28691.1379310345
796013874510.2162162162-14372.2162162162
8073422113284.75-39862.75
816770674510.2162162162-6804.21621621621
82188098133924.13793103454173.8620689655
835118574510.2162162162-23325.2162162162
848444898033.5-13585.5
854195640890.18181818181065.81818181818
8610849398033.510459.5
87166900113284.7553615.25
886360374510.2162162162-10907.2162162162
896449474510.2162162162-10016.2162162162
909342498033.5-4609.5
919722998033.5-804.5
92112819133924.137931034-21105.1379310345
9310573774510.216216216231226.7837837838
94102220113284.75-11064.75
953858340890.1818181818-2307.18181818182
96168764133924.13793103434839.8620689655
97142096113284.7528811.25
98193496577.7142857142912771.2857142857
99119212113284.755927.25
100101941133924.137931034-31983.1379310345
1014380340890.18181818182912.81818181818
1024705474510.2162162162-27456.2162162162
103104220113284.75-9064.75
1048335474510.21621621628843.78378378379
1055858540890.181818181817694.8181818182
1062767640890.1818181818-13214.1818181818
1079344874510.216216216218937.7837837838
1084328440890.18181818182393.81818181818
10906577.71428571429-6577.71428571429
1106433374510.2162162162-10177.2162162162
1115705074510.2162162162-17460.2162162162
1129693398033.5-1100.5
1137008874510.2162162162-4422.21621621621
1146549474510.2162162162-9016.21621621621
11530586577.71428571429-3519.71428571429
11606577.71428571429-6577.71428571429
11713379374510.216216216259282.7837837838
11895530113284.75-17754.75
119119970113284.756685.25
1208433674510.21621621629825.78378378379
1214341074510.2162162162-31100.2162162162
122131452113284.7518167.25
1237901574510.21621621624504.78378378379
1248757098033.5-10463.5
1255757874510.2162162162-16932.2162162162
126197646577.7142857142913186.2857142857
12710016098033.52126.5
1289641074510.216216216221899.7837837838
1299801098033.5-23.5
130117966577.714285714295218.28571428571
13176276577.714285714291049.28571428571
132110721113284.75-2563.75
13368366577.71428571429258.285714285715
134131955133924.137931034-1969.13793103449
13551186577.71428571429-1459.71428571429
1364024840890.1818181818-642.181818181816
13706577.71428571429-6577.71428571429
1387706574510.21621621622554.78378378379
1396714098033.5-30893.5
14071316577.71428571429553.285714285715
14141946577.71428571429-2383.71428571429
1426037874510.2162162162-14132.2162162162
1438173174510.21621621627220.78378378379
1448348474510.21621621628973.78378378379



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