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 10:37:45 -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/t1324395509gsjkhy0s4bfo1o5.htm/, Retrieved Mon, 06 May 2024 01:21:30 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158003, Retrieved Mon, 06 May 2024 01:21:30 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact93
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [rt pages] [2011-12-20 15:37:45] [0956ee981dded61b2e7128dae94e5715] [Current]
Feedback Forum

Post a new message
Dataseries X:
1565	129404	20	18	63	18158
1134	130358	38	17	50	30461
192	7215	0	0	0	1423
2033	112861	49	22	51	25629
3283	219904	76	30	112	48758
5877	402036	104	31	118	129230
1322	117604	37	19	59	27376
1225	131822	57	25	90	26706
1463	99729	42	30	50	26505
2568	256310	62	26	79	49801
1810	113066	50	20	49	46580
1915	165392	66	30	91	48352
1452	78240	38	15	32	13899
2415	152673	48	22	82	39342
1254	134368	42	17	58	27465
1374	125769	47	19	65	55211
1504	123467	71	28	111	74098
999	56232	0	12	36	13497
2222	108458	50	28	89	38338
634	22762	12	13	28	52505
849	48633	16	14	35	10663
2189	182081	77	27	78	74484
1469	140857	29	25	67	28895
1791	93773	38	30	61	32827
1743	133398	50	21	58	36188
1180	113933	33	17	49	28173
1749	153851	49	22	77	54926
1101	140711	59	28	71	38900
2391	303844	55	26	85	88530
1826	163810	42	17	56	35482
1301	123344	40	23	71	26730
1433	157640	51	20	58	29806
1893	103274	45	16	34	41799
2525	193500	73	20	59	54289
2033	178768	51	21	77	36805
1	0	0	0	0	0
1817	181412	46	27	75	33146
1506	92342	44	14	39	23333
1820	100023	31	29	83	47686
1649	178277	71	31	123	77783
1672	145067	61	19	67	36042
1433	114146	28	30	105	34541
864	86039	21	23	76	75620
1683	125481	42	21	57	60610
1024	95535	44	22	82	55041
1029	129221	40	21	64	32087
629	61554	15	32	57	16356
1679	168048	46	20	80	40161
1715	159121	43	26	94	55459
2093	129362	47	25	72	36679
658	48188	12	22	39	22346
1234	95461	46	19	60	27377
2059	229864	56	24	84	50273
1725	191094	47	26	69	32104
1504	161082	50	27	102	27016
1454	111388	35	10	28	19715
1620	172614	45	26	65	33629
733	63205	25	23	67	27084
894	109102	47	21	80	32352
2343	137303	28	34	79	51845
1503	125304	48	29	107	26591
1627	88620	32	19	60	29677
1119	95808	28	19	53	54237
897	83419	31	23	59	20284
855	101723	13	22	80	22741
1229	94982	38	29	89	34178
1991	143566	48	31	115	69551
2393	113325	68	21	59	29653
820	81518	32	21	66	38071
340	31970	5	21	42	4157
2443	192268	53	15	35	28321
1030	91261	33	9	3	40195
1091	80820	54	23	72	48158
1414	85829	37	18	38	13310
2192	116322	52	31	107	78474
1082	56544	0	25	73	6386
1764	116173	52	24	80	31588
2072	118781	51	22	69	61254
816	60138	16	21	46	21152
1121	73422	33	26	52	41272
810	67751	48	22	58	34165
1699	214002	33	26	85	37054
751	51185	24	20	13	12368
1309	97181	37	25	61	23168
732	45100	17	19	49	16380
1327	115801	32	22	47	41242
2246	186310	55	25	93	48450
968	71960	39	22	65	20790
1015	80105	31	21	64	34585
1100	103613	26	20	64	35672
1300	98707	37	23	57	52168
1982	136234	66	22	61	53933
1091	136781	35	21	71	34474
1107	105863	24	12	43	43753
666	42228	22	9	18	36456
1903	179997	37	32	103	51183
1608	169406	86	24	76	52742
223	19349	13	1	0	3895
1807	160819	21	24	83	37076
1466	109510	32	25	73	24079
552	43803	8	4	4	2325
708	47062	38	15	41	29354
1079	110845	45	21	57	30341
957	92517	24	23	52	18992
585	58660	23	12	24	15292
596	27676	2	16	17	5842
980	98550	52	24	89	28918
585	43646	5	9	20	3738
0	0	0	0	0	0
975	75566	43	25	51	95352
750	57359	18	17	63	37478
1071	104330	44	18	48	26839
931	70369	45	21	70	26783
783	65494	29	17	32	33392
78	3616	0	0	0	0
0	0	0	0	0	0
874	143931	32	20	72	25446
1327	117946	65	26	56	59847
1831	137332	26	27	66	28162
750	84336	24	20	77	33298
778	43410	7	1	3	2781
1373	136250	62	24	73	37121
807	79015	30	14	37	22698
1562	101354	49	27	57	27615
685	57586	3	12	32	32689
285	19764	10	2	4	5752
1336	105757	42	16	55	23164
954	103651	23	23	84	20304
1283	113402	40	28	90	34409
256	11796	1	2	1	0
81	7627	0	0	0	0
1214	121085	29	17	38	92538
41	6836	0	1	0	0
1634	139563	46	17	36	46037
42	5118	5	0	0	0
528	40248	8	4	7	5444
0	0	0	0	0	0
890	95079	21	25	75	23924
1203	80763	21	26	52	52230
81	7131	0	0	0	0
61	4194	0	0	0	0
849	60378	15	15	45	8019
1035	109173	47	20	66	34542
964	83484	17	19	48	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=158003&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=158003&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158003&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.8686
R-squared0.7544
RMSE30081.9522

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8686[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7544[/C][/ROW]
[ROW][C]RMSE[/C][C]30081.9522[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158003&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158003&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.8686
R-squared0.7544
RMSE30081.9522







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1129404147646.675675676-18242.6756756757
2130358100480.10869565229877.8913043478
372156617.57142857143597.428571428572
4112861147646.675675676-34785.6756756757
5219904229232.5-9328.5
6402036229232.5172803.5
7117604100480.10869565217123.8913043478
81318221227859037
999729100480.108695652-751.108695652176
10256310229232.527077.5
11113066147646.675675676-34580.6756756757
12165392147646.67567567617745.3243243243
1378240100480.108695652-22240.1086956522
14152673229232.5-76559.5
15134368100480.10869565233887.8913043478
161257691227852984
17123467122785682
1856232100480.108695652-44248.1086956522
19108458147646.675675676-39188.6756756757
202276241513.1111111111-18751.1111111111
214863359955.4375-11322.4375
22182081147646.67567567634434.3243243243
23140857100480.10869565240376.8913043478
2493773147646.675675676-53873.6756756757
25133398147646.675675676-14248.6756756757
26113933100480.10869565213452.8913043478
27153851147646.6756756766204.32432432432
2814071112278517926
29303844229232.574611.5
30163810147646.67567567616163.3243243243
31123344100480.10869565222863.8913043478
3215764012278534855
33103274147646.675675676-44372.6756756757
34193500229232.5-35732.5
35178768147646.67567567631121.3243243243
3606617.57142857143-6617.57142857143
37181412147646.67567567633765.3243243243
3892342100480.108695652-8138.10869565218
39100023147646.675675676-47623.6756756757
40178277147646.67567567630630.3243243243
41145067147646.675675676-2579.67567567568
42114146100480.10869565213665.8913043478
4386039100480.108695652-14441.1086956522
44125481147646.675675676-22165.6756756757
4595535100480.108695652-4945.10869565218
46129221100480.10869565228740.8913043478
476155459955.43751598.5625
48168048147646.67567567620401.3243243243
49159121147646.67567567611474.3243243243
50129362147646.675675676-18284.6756756757
514818859955.4375-11767.4375
5295461100480.108695652-5019.10869565218
53229864147646.67567567682217.3243243243
54191094147646.67567567643447.3243243243
5516108212278538297
56111388100480.10869565210907.8913043478
57172614147646.67567567624967.3243243243
586320559955.43753249.5625
59109102122785-13683
60137303147646.675675676-10343.6756756757
611253041227852519
6288620147646.675675676-59026.6756756757
6395808100480.108695652-4672.10869565218
6483419100480.108695652-17061.1086956522
65101723100480.1086956521242.89130434782
6694982100480.108695652-5498.10869565218
67143566147646.675675676-4080.67567567568
68113325229232.5-115907.5
698151859955.437521562.5625
703197059955.4375-27985.4375
71192268229232.5-36964.5
7291261100480.108695652-9219.10869565218
7380820122785-41965
7485829100480.108695652-14651.1086956522
75116322147646.675675676-31324.6756756757
7656544100480.108695652-43936.1086956522
77116173147646.675675676-31473.6756756757
78118781147646.675675676-28865.6756756757
796013859955.4375182.5625
8073422100480.108695652-27058.1086956522
816775159955.43757795.5625
82214002147646.67567567666355.3243243243
835118541513.11111111119671.88888888889
8497181100480.108695652-3299.10869565218
854510059955.4375-14855.4375
86115801100480.10869565215320.8913043478
87186310147646.67567567638663.3243243243
8871960100480.108695652-28520.1086956522
8980105100480.108695652-20375.1086956522
90103613100480.1086956523132.89130434782
9198707100480.108695652-1773.10869565218
92136234147646.675675676-11412.6756756757
93136781100480.10869565236300.8913043478
94105863100480.1086956525382.89130434782
954222841513.1111111111714.888888888891
96179997147646.67567567632350.3243243243
97169406147646.67567567621759.3243243243
98193496617.5714285714312731.4285714286
99160819147646.67567567613172.3243243243
100109510100480.1086956529029.89130434782
1014380341513.11111111112289.88888888889
1024706259955.4375-12893.4375
103110845100480.10869565210364.8913043478
10492517100480.108695652-7963.10869565218
1055866041513.111111111117146.8888888889
1062767641513.1111111111-13837.1111111111
10798550122785-24235
1084364641513.11111111112132.88888888889
10906617.57142857143-6617.57142857143
11075566100480.108695652-24914.1086956522
1115735959955.4375-2596.4375
112104330100480.1086956523849.89130434782
11370369100480.108695652-30111.1086956522
1146549459955.43755538.5625
11536166617.57142857143-3001.57142857143
11606617.57142857143-6617.57142857143
117143931100480.10869565243450.8913043478
118117946122785-4839
119137332147646.675675676-10314.6756756757
1208433659955.437524380.5625
1214341041513.11111111111896.88888888889
12213625012278513465
1237901559955.437519059.5625
124101354122785-21431
1255758659955.4375-2369.4375
126197646617.5714285714313146.4285714286
127105757100480.1086956525276.89130434782
128103651100480.1086956523170.89130434782
129113402100480.10869565212921.8913043478
130117966617.571428571435178.42857142857
13176276617.571428571431009.42857142857
132121085100480.10869565220604.8913043478
13368366617.57142857143218.428571428572
134139563147646.675675676-8083.67567567568
13551186617.57142857143-1499.57142857143
1364024841513.1111111111-1265.11111111111
13706617.57142857143-6617.57142857143
13895079100480.108695652-5401.10869565218
13980763100480.108695652-19717.1086956522
14071316617.57142857143513.428571428572
14141946617.57142857143-2423.57142857143
1426037859955.4375422.5625
143109173122785-13612
14483484100480.108695652-16996.1086956522

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 129404 & 147646.675675676 & -18242.6756756757 \tabularnewline
2 & 130358 & 100480.108695652 & 29877.8913043478 \tabularnewline
3 & 7215 & 6617.57142857143 & 597.428571428572 \tabularnewline
4 & 112861 & 147646.675675676 & -34785.6756756757 \tabularnewline
5 & 219904 & 229232.5 & -9328.5 \tabularnewline
6 & 402036 & 229232.5 & 172803.5 \tabularnewline
7 & 117604 & 100480.108695652 & 17123.8913043478 \tabularnewline
8 & 131822 & 122785 & 9037 \tabularnewline
9 & 99729 & 100480.108695652 & -751.108695652176 \tabularnewline
10 & 256310 & 229232.5 & 27077.5 \tabularnewline
11 & 113066 & 147646.675675676 & -34580.6756756757 \tabularnewline
12 & 165392 & 147646.675675676 & 17745.3243243243 \tabularnewline
13 & 78240 & 100480.108695652 & -22240.1086956522 \tabularnewline
14 & 152673 & 229232.5 & -76559.5 \tabularnewline
15 & 134368 & 100480.108695652 & 33887.8913043478 \tabularnewline
16 & 125769 & 122785 & 2984 \tabularnewline
17 & 123467 & 122785 & 682 \tabularnewline
18 & 56232 & 100480.108695652 & -44248.1086956522 \tabularnewline
19 & 108458 & 147646.675675676 & -39188.6756756757 \tabularnewline
20 & 22762 & 41513.1111111111 & -18751.1111111111 \tabularnewline
21 & 48633 & 59955.4375 & -11322.4375 \tabularnewline
22 & 182081 & 147646.675675676 & 34434.3243243243 \tabularnewline
23 & 140857 & 100480.108695652 & 40376.8913043478 \tabularnewline
24 & 93773 & 147646.675675676 & -53873.6756756757 \tabularnewline
25 & 133398 & 147646.675675676 & -14248.6756756757 \tabularnewline
26 & 113933 & 100480.108695652 & 13452.8913043478 \tabularnewline
27 & 153851 & 147646.675675676 & 6204.32432432432 \tabularnewline
28 & 140711 & 122785 & 17926 \tabularnewline
29 & 303844 & 229232.5 & 74611.5 \tabularnewline
30 & 163810 & 147646.675675676 & 16163.3243243243 \tabularnewline
31 & 123344 & 100480.108695652 & 22863.8913043478 \tabularnewline
32 & 157640 & 122785 & 34855 \tabularnewline
33 & 103274 & 147646.675675676 & -44372.6756756757 \tabularnewline
34 & 193500 & 229232.5 & -35732.5 \tabularnewline
35 & 178768 & 147646.675675676 & 31121.3243243243 \tabularnewline
36 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
37 & 181412 & 147646.675675676 & 33765.3243243243 \tabularnewline
38 & 92342 & 100480.108695652 & -8138.10869565218 \tabularnewline
39 & 100023 & 147646.675675676 & -47623.6756756757 \tabularnewline
40 & 178277 & 147646.675675676 & 30630.3243243243 \tabularnewline
41 & 145067 & 147646.675675676 & -2579.67567567568 \tabularnewline
42 & 114146 & 100480.108695652 & 13665.8913043478 \tabularnewline
43 & 86039 & 100480.108695652 & -14441.1086956522 \tabularnewline
44 & 125481 & 147646.675675676 & -22165.6756756757 \tabularnewline
45 & 95535 & 100480.108695652 & -4945.10869565218 \tabularnewline
46 & 129221 & 100480.108695652 & 28740.8913043478 \tabularnewline
47 & 61554 & 59955.4375 & 1598.5625 \tabularnewline
48 & 168048 & 147646.675675676 & 20401.3243243243 \tabularnewline
49 & 159121 & 147646.675675676 & 11474.3243243243 \tabularnewline
50 & 129362 & 147646.675675676 & -18284.6756756757 \tabularnewline
51 & 48188 & 59955.4375 & -11767.4375 \tabularnewline
52 & 95461 & 100480.108695652 & -5019.10869565218 \tabularnewline
53 & 229864 & 147646.675675676 & 82217.3243243243 \tabularnewline
54 & 191094 & 147646.675675676 & 43447.3243243243 \tabularnewline
55 & 161082 & 122785 & 38297 \tabularnewline
56 & 111388 & 100480.108695652 & 10907.8913043478 \tabularnewline
57 & 172614 & 147646.675675676 & 24967.3243243243 \tabularnewline
58 & 63205 & 59955.4375 & 3249.5625 \tabularnewline
59 & 109102 & 122785 & -13683 \tabularnewline
60 & 137303 & 147646.675675676 & -10343.6756756757 \tabularnewline
61 & 125304 & 122785 & 2519 \tabularnewline
62 & 88620 & 147646.675675676 & -59026.6756756757 \tabularnewline
63 & 95808 & 100480.108695652 & -4672.10869565218 \tabularnewline
64 & 83419 & 100480.108695652 & -17061.1086956522 \tabularnewline
65 & 101723 & 100480.108695652 & 1242.89130434782 \tabularnewline
66 & 94982 & 100480.108695652 & -5498.10869565218 \tabularnewline
67 & 143566 & 147646.675675676 & -4080.67567567568 \tabularnewline
68 & 113325 & 229232.5 & -115907.5 \tabularnewline
69 & 81518 & 59955.4375 & 21562.5625 \tabularnewline
70 & 31970 & 59955.4375 & -27985.4375 \tabularnewline
71 & 192268 & 229232.5 & -36964.5 \tabularnewline
72 & 91261 & 100480.108695652 & -9219.10869565218 \tabularnewline
73 & 80820 & 122785 & -41965 \tabularnewline
74 & 85829 & 100480.108695652 & -14651.1086956522 \tabularnewline
75 & 116322 & 147646.675675676 & -31324.6756756757 \tabularnewline
76 & 56544 & 100480.108695652 & -43936.1086956522 \tabularnewline
77 & 116173 & 147646.675675676 & -31473.6756756757 \tabularnewline
78 & 118781 & 147646.675675676 & -28865.6756756757 \tabularnewline
79 & 60138 & 59955.4375 & 182.5625 \tabularnewline
80 & 73422 & 100480.108695652 & -27058.1086956522 \tabularnewline
81 & 67751 & 59955.4375 & 7795.5625 \tabularnewline
82 & 214002 & 147646.675675676 & 66355.3243243243 \tabularnewline
83 & 51185 & 41513.1111111111 & 9671.88888888889 \tabularnewline
84 & 97181 & 100480.108695652 & -3299.10869565218 \tabularnewline
85 & 45100 & 59955.4375 & -14855.4375 \tabularnewline
86 & 115801 & 100480.108695652 & 15320.8913043478 \tabularnewline
87 & 186310 & 147646.675675676 & 38663.3243243243 \tabularnewline
88 & 71960 & 100480.108695652 & -28520.1086956522 \tabularnewline
89 & 80105 & 100480.108695652 & -20375.1086956522 \tabularnewline
90 & 103613 & 100480.108695652 & 3132.89130434782 \tabularnewline
91 & 98707 & 100480.108695652 & -1773.10869565218 \tabularnewline
92 & 136234 & 147646.675675676 & -11412.6756756757 \tabularnewline
93 & 136781 & 100480.108695652 & 36300.8913043478 \tabularnewline
94 & 105863 & 100480.108695652 & 5382.89130434782 \tabularnewline
95 & 42228 & 41513.1111111111 & 714.888888888891 \tabularnewline
96 & 179997 & 147646.675675676 & 32350.3243243243 \tabularnewline
97 & 169406 & 147646.675675676 & 21759.3243243243 \tabularnewline
98 & 19349 & 6617.57142857143 & 12731.4285714286 \tabularnewline
99 & 160819 & 147646.675675676 & 13172.3243243243 \tabularnewline
100 & 109510 & 100480.108695652 & 9029.89130434782 \tabularnewline
101 & 43803 & 41513.1111111111 & 2289.88888888889 \tabularnewline
102 & 47062 & 59955.4375 & -12893.4375 \tabularnewline
103 & 110845 & 100480.108695652 & 10364.8913043478 \tabularnewline
104 & 92517 & 100480.108695652 & -7963.10869565218 \tabularnewline
105 & 58660 & 41513.1111111111 & 17146.8888888889 \tabularnewline
106 & 27676 & 41513.1111111111 & -13837.1111111111 \tabularnewline
107 & 98550 & 122785 & -24235 \tabularnewline
108 & 43646 & 41513.1111111111 & 2132.88888888889 \tabularnewline
109 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
110 & 75566 & 100480.108695652 & -24914.1086956522 \tabularnewline
111 & 57359 & 59955.4375 & -2596.4375 \tabularnewline
112 & 104330 & 100480.108695652 & 3849.89130434782 \tabularnewline
113 & 70369 & 100480.108695652 & -30111.1086956522 \tabularnewline
114 & 65494 & 59955.4375 & 5538.5625 \tabularnewline
115 & 3616 & 6617.57142857143 & -3001.57142857143 \tabularnewline
116 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
117 & 143931 & 100480.108695652 & 43450.8913043478 \tabularnewline
118 & 117946 & 122785 & -4839 \tabularnewline
119 & 137332 & 147646.675675676 & -10314.6756756757 \tabularnewline
120 & 84336 & 59955.4375 & 24380.5625 \tabularnewline
121 & 43410 & 41513.1111111111 & 1896.88888888889 \tabularnewline
122 & 136250 & 122785 & 13465 \tabularnewline
123 & 79015 & 59955.4375 & 19059.5625 \tabularnewline
124 & 101354 & 122785 & -21431 \tabularnewline
125 & 57586 & 59955.4375 & -2369.4375 \tabularnewline
126 & 19764 & 6617.57142857143 & 13146.4285714286 \tabularnewline
127 & 105757 & 100480.108695652 & 5276.89130434782 \tabularnewline
128 & 103651 & 100480.108695652 & 3170.89130434782 \tabularnewline
129 & 113402 & 100480.108695652 & 12921.8913043478 \tabularnewline
130 & 11796 & 6617.57142857143 & 5178.42857142857 \tabularnewline
131 & 7627 & 6617.57142857143 & 1009.42857142857 \tabularnewline
132 & 121085 & 100480.108695652 & 20604.8913043478 \tabularnewline
133 & 6836 & 6617.57142857143 & 218.428571428572 \tabularnewline
134 & 139563 & 147646.675675676 & -8083.67567567568 \tabularnewline
135 & 5118 & 6617.57142857143 & -1499.57142857143 \tabularnewline
136 & 40248 & 41513.1111111111 & -1265.11111111111 \tabularnewline
137 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
138 & 95079 & 100480.108695652 & -5401.10869565218 \tabularnewline
139 & 80763 & 100480.108695652 & -19717.1086956522 \tabularnewline
140 & 7131 & 6617.57142857143 & 513.428571428572 \tabularnewline
141 & 4194 & 6617.57142857143 & -2423.57142857143 \tabularnewline
142 & 60378 & 59955.4375 & 422.5625 \tabularnewline
143 & 109173 & 122785 & -13612 \tabularnewline
144 & 83484 & 100480.108695652 & -16996.1086956522 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158003&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]129404[/C][C]147646.675675676[/C][C]-18242.6756756757[/C][/ROW]
[ROW][C]2[/C][C]130358[/C][C]100480.108695652[/C][C]29877.8913043478[/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]147646.675675676[/C][C]-34785.6756756757[/C][/ROW]
[ROW][C]5[/C][C]219904[/C][C]229232.5[/C][C]-9328.5[/C][/ROW]
[ROW][C]6[/C][C]402036[/C][C]229232.5[/C][C]172803.5[/C][/ROW]
[ROW][C]7[/C][C]117604[/C][C]100480.108695652[/C][C]17123.8913043478[/C][/ROW]
[ROW][C]8[/C][C]131822[/C][C]122785[/C][C]9037[/C][/ROW]
[ROW][C]9[/C][C]99729[/C][C]100480.108695652[/C][C]-751.108695652176[/C][/ROW]
[ROW][C]10[/C][C]256310[/C][C]229232.5[/C][C]27077.5[/C][/ROW]
[ROW][C]11[/C][C]113066[/C][C]147646.675675676[/C][C]-34580.6756756757[/C][/ROW]
[ROW][C]12[/C][C]165392[/C][C]147646.675675676[/C][C]17745.3243243243[/C][/ROW]
[ROW][C]13[/C][C]78240[/C][C]100480.108695652[/C][C]-22240.1086956522[/C][/ROW]
[ROW][C]14[/C][C]152673[/C][C]229232.5[/C][C]-76559.5[/C][/ROW]
[ROW][C]15[/C][C]134368[/C][C]100480.108695652[/C][C]33887.8913043478[/C][/ROW]
[ROW][C]16[/C][C]125769[/C][C]122785[/C][C]2984[/C][/ROW]
[ROW][C]17[/C][C]123467[/C][C]122785[/C][C]682[/C][/ROW]
[ROW][C]18[/C][C]56232[/C][C]100480.108695652[/C][C]-44248.1086956522[/C][/ROW]
[ROW][C]19[/C][C]108458[/C][C]147646.675675676[/C][C]-39188.6756756757[/C][/ROW]
[ROW][C]20[/C][C]22762[/C][C]41513.1111111111[/C][C]-18751.1111111111[/C][/ROW]
[ROW][C]21[/C][C]48633[/C][C]59955.4375[/C][C]-11322.4375[/C][/ROW]
[ROW][C]22[/C][C]182081[/C][C]147646.675675676[/C][C]34434.3243243243[/C][/ROW]
[ROW][C]23[/C][C]140857[/C][C]100480.108695652[/C][C]40376.8913043478[/C][/ROW]
[ROW][C]24[/C][C]93773[/C][C]147646.675675676[/C][C]-53873.6756756757[/C][/ROW]
[ROW][C]25[/C][C]133398[/C][C]147646.675675676[/C][C]-14248.6756756757[/C][/ROW]
[ROW][C]26[/C][C]113933[/C][C]100480.108695652[/C][C]13452.8913043478[/C][/ROW]
[ROW][C]27[/C][C]153851[/C][C]147646.675675676[/C][C]6204.32432432432[/C][/ROW]
[ROW][C]28[/C][C]140711[/C][C]122785[/C][C]17926[/C][/ROW]
[ROW][C]29[/C][C]303844[/C][C]229232.5[/C][C]74611.5[/C][/ROW]
[ROW][C]30[/C][C]163810[/C][C]147646.675675676[/C][C]16163.3243243243[/C][/ROW]
[ROW][C]31[/C][C]123344[/C][C]100480.108695652[/C][C]22863.8913043478[/C][/ROW]
[ROW][C]32[/C][C]157640[/C][C]122785[/C][C]34855[/C][/ROW]
[ROW][C]33[/C][C]103274[/C][C]147646.675675676[/C][C]-44372.6756756757[/C][/ROW]
[ROW][C]34[/C][C]193500[/C][C]229232.5[/C][C]-35732.5[/C][/ROW]
[ROW][C]35[/C][C]178768[/C][C]147646.675675676[/C][C]31121.3243243243[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]37[/C][C]181412[/C][C]147646.675675676[/C][C]33765.3243243243[/C][/ROW]
[ROW][C]38[/C][C]92342[/C][C]100480.108695652[/C][C]-8138.10869565218[/C][/ROW]
[ROW][C]39[/C][C]100023[/C][C]147646.675675676[/C][C]-47623.6756756757[/C][/ROW]
[ROW][C]40[/C][C]178277[/C][C]147646.675675676[/C][C]30630.3243243243[/C][/ROW]
[ROW][C]41[/C][C]145067[/C][C]147646.675675676[/C][C]-2579.67567567568[/C][/ROW]
[ROW][C]42[/C][C]114146[/C][C]100480.108695652[/C][C]13665.8913043478[/C][/ROW]
[ROW][C]43[/C][C]86039[/C][C]100480.108695652[/C][C]-14441.1086956522[/C][/ROW]
[ROW][C]44[/C][C]125481[/C][C]147646.675675676[/C][C]-22165.6756756757[/C][/ROW]
[ROW][C]45[/C][C]95535[/C][C]100480.108695652[/C][C]-4945.10869565218[/C][/ROW]
[ROW][C]46[/C][C]129221[/C][C]100480.108695652[/C][C]28740.8913043478[/C][/ROW]
[ROW][C]47[/C][C]61554[/C][C]59955.4375[/C][C]1598.5625[/C][/ROW]
[ROW][C]48[/C][C]168048[/C][C]147646.675675676[/C][C]20401.3243243243[/C][/ROW]
[ROW][C]49[/C][C]159121[/C][C]147646.675675676[/C][C]11474.3243243243[/C][/ROW]
[ROW][C]50[/C][C]129362[/C][C]147646.675675676[/C][C]-18284.6756756757[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]59955.4375[/C][C]-11767.4375[/C][/ROW]
[ROW][C]52[/C][C]95461[/C][C]100480.108695652[/C][C]-5019.10869565218[/C][/ROW]
[ROW][C]53[/C][C]229864[/C][C]147646.675675676[/C][C]82217.3243243243[/C][/ROW]
[ROW][C]54[/C][C]191094[/C][C]147646.675675676[/C][C]43447.3243243243[/C][/ROW]
[ROW][C]55[/C][C]161082[/C][C]122785[/C][C]38297[/C][/ROW]
[ROW][C]56[/C][C]111388[/C][C]100480.108695652[/C][C]10907.8913043478[/C][/ROW]
[ROW][C]57[/C][C]172614[/C][C]147646.675675676[/C][C]24967.3243243243[/C][/ROW]
[ROW][C]58[/C][C]63205[/C][C]59955.4375[/C][C]3249.5625[/C][/ROW]
[ROW][C]59[/C][C]109102[/C][C]122785[/C][C]-13683[/C][/ROW]
[ROW][C]60[/C][C]137303[/C][C]147646.675675676[/C][C]-10343.6756756757[/C][/ROW]
[ROW][C]61[/C][C]125304[/C][C]122785[/C][C]2519[/C][/ROW]
[ROW][C]62[/C][C]88620[/C][C]147646.675675676[/C][C]-59026.6756756757[/C][/ROW]
[ROW][C]63[/C][C]95808[/C][C]100480.108695652[/C][C]-4672.10869565218[/C][/ROW]
[ROW][C]64[/C][C]83419[/C][C]100480.108695652[/C][C]-17061.1086956522[/C][/ROW]
[ROW][C]65[/C][C]101723[/C][C]100480.108695652[/C][C]1242.89130434782[/C][/ROW]
[ROW][C]66[/C][C]94982[/C][C]100480.108695652[/C][C]-5498.10869565218[/C][/ROW]
[ROW][C]67[/C][C]143566[/C][C]147646.675675676[/C][C]-4080.67567567568[/C][/ROW]
[ROW][C]68[/C][C]113325[/C][C]229232.5[/C][C]-115907.5[/C][/ROW]
[ROW][C]69[/C][C]81518[/C][C]59955.4375[/C][C]21562.5625[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]59955.4375[/C][C]-27985.4375[/C][/ROW]
[ROW][C]71[/C][C]192268[/C][C]229232.5[/C][C]-36964.5[/C][/ROW]
[ROW][C]72[/C][C]91261[/C][C]100480.108695652[/C][C]-9219.10869565218[/C][/ROW]
[ROW][C]73[/C][C]80820[/C][C]122785[/C][C]-41965[/C][/ROW]
[ROW][C]74[/C][C]85829[/C][C]100480.108695652[/C][C]-14651.1086956522[/C][/ROW]
[ROW][C]75[/C][C]116322[/C][C]147646.675675676[/C][C]-31324.6756756757[/C][/ROW]
[ROW][C]76[/C][C]56544[/C][C]100480.108695652[/C][C]-43936.1086956522[/C][/ROW]
[ROW][C]77[/C][C]116173[/C][C]147646.675675676[/C][C]-31473.6756756757[/C][/ROW]
[ROW][C]78[/C][C]118781[/C][C]147646.675675676[/C][C]-28865.6756756757[/C][/ROW]
[ROW][C]79[/C][C]60138[/C][C]59955.4375[/C][C]182.5625[/C][/ROW]
[ROW][C]80[/C][C]73422[/C][C]100480.108695652[/C][C]-27058.1086956522[/C][/ROW]
[ROW][C]81[/C][C]67751[/C][C]59955.4375[/C][C]7795.5625[/C][/ROW]
[ROW][C]82[/C][C]214002[/C][C]147646.675675676[/C][C]66355.3243243243[/C][/ROW]
[ROW][C]83[/C][C]51185[/C][C]41513.1111111111[/C][C]9671.88888888889[/C][/ROW]
[ROW][C]84[/C][C]97181[/C][C]100480.108695652[/C][C]-3299.10869565218[/C][/ROW]
[ROW][C]85[/C][C]45100[/C][C]59955.4375[/C][C]-14855.4375[/C][/ROW]
[ROW][C]86[/C][C]115801[/C][C]100480.108695652[/C][C]15320.8913043478[/C][/ROW]
[ROW][C]87[/C][C]186310[/C][C]147646.675675676[/C][C]38663.3243243243[/C][/ROW]
[ROW][C]88[/C][C]71960[/C][C]100480.108695652[/C][C]-28520.1086956522[/C][/ROW]
[ROW][C]89[/C][C]80105[/C][C]100480.108695652[/C][C]-20375.1086956522[/C][/ROW]
[ROW][C]90[/C][C]103613[/C][C]100480.108695652[/C][C]3132.89130434782[/C][/ROW]
[ROW][C]91[/C][C]98707[/C][C]100480.108695652[/C][C]-1773.10869565218[/C][/ROW]
[ROW][C]92[/C][C]136234[/C][C]147646.675675676[/C][C]-11412.6756756757[/C][/ROW]
[ROW][C]93[/C][C]136781[/C][C]100480.108695652[/C][C]36300.8913043478[/C][/ROW]
[ROW][C]94[/C][C]105863[/C][C]100480.108695652[/C][C]5382.89130434782[/C][/ROW]
[ROW][C]95[/C][C]42228[/C][C]41513.1111111111[/C][C]714.888888888891[/C][/ROW]
[ROW][C]96[/C][C]179997[/C][C]147646.675675676[/C][C]32350.3243243243[/C][/ROW]
[ROW][C]97[/C][C]169406[/C][C]147646.675675676[/C][C]21759.3243243243[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]6617.57142857143[/C][C]12731.4285714286[/C][/ROW]
[ROW][C]99[/C][C]160819[/C][C]147646.675675676[/C][C]13172.3243243243[/C][/ROW]
[ROW][C]100[/C][C]109510[/C][C]100480.108695652[/C][C]9029.89130434782[/C][/ROW]
[ROW][C]101[/C][C]43803[/C][C]41513.1111111111[/C][C]2289.88888888889[/C][/ROW]
[ROW][C]102[/C][C]47062[/C][C]59955.4375[/C][C]-12893.4375[/C][/ROW]
[ROW][C]103[/C][C]110845[/C][C]100480.108695652[/C][C]10364.8913043478[/C][/ROW]
[ROW][C]104[/C][C]92517[/C][C]100480.108695652[/C][C]-7963.10869565218[/C][/ROW]
[ROW][C]105[/C][C]58660[/C][C]41513.1111111111[/C][C]17146.8888888889[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]41513.1111111111[/C][C]-13837.1111111111[/C][/ROW]
[ROW][C]107[/C][C]98550[/C][C]122785[/C][C]-24235[/C][/ROW]
[ROW][C]108[/C][C]43646[/C][C]41513.1111111111[/C][C]2132.88888888889[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]110[/C][C]75566[/C][C]100480.108695652[/C][C]-24914.1086956522[/C][/ROW]
[ROW][C]111[/C][C]57359[/C][C]59955.4375[/C][C]-2596.4375[/C][/ROW]
[ROW][C]112[/C][C]104330[/C][C]100480.108695652[/C][C]3849.89130434782[/C][/ROW]
[ROW][C]113[/C][C]70369[/C][C]100480.108695652[/C][C]-30111.1086956522[/C][/ROW]
[ROW][C]114[/C][C]65494[/C][C]59955.4375[/C][C]5538.5625[/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]143931[/C][C]100480.108695652[/C][C]43450.8913043478[/C][/ROW]
[ROW][C]118[/C][C]117946[/C][C]122785[/C][C]-4839[/C][/ROW]
[ROW][C]119[/C][C]137332[/C][C]147646.675675676[/C][C]-10314.6756756757[/C][/ROW]
[ROW][C]120[/C][C]84336[/C][C]59955.4375[/C][C]24380.5625[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]41513.1111111111[/C][C]1896.88888888889[/C][/ROW]
[ROW][C]122[/C][C]136250[/C][C]122785[/C][C]13465[/C][/ROW]
[ROW][C]123[/C][C]79015[/C][C]59955.4375[/C][C]19059.5625[/C][/ROW]
[ROW][C]124[/C][C]101354[/C][C]122785[/C][C]-21431[/C][/ROW]
[ROW][C]125[/C][C]57586[/C][C]59955.4375[/C][C]-2369.4375[/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]100480.108695652[/C][C]5276.89130434782[/C][/ROW]
[ROW][C]128[/C][C]103651[/C][C]100480.108695652[/C][C]3170.89130434782[/C][/ROW]
[ROW][C]129[/C][C]113402[/C][C]100480.108695652[/C][C]12921.8913043478[/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]121085[/C][C]100480.108695652[/C][C]20604.8913043478[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]6617.57142857143[/C][C]218.428571428572[/C][/ROW]
[ROW][C]134[/C][C]139563[/C][C]147646.675675676[/C][C]-8083.67567567568[/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]41513.1111111111[/C][C]-1265.11111111111[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]138[/C][C]95079[/C][C]100480.108695652[/C][C]-5401.10869565218[/C][/ROW]
[ROW][C]139[/C][C]80763[/C][C]100480.108695652[/C][C]-19717.1086956522[/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]59955.4375[/C][C]422.5625[/C][/ROW]
[ROW][C]143[/C][C]109173[/C][C]122785[/C][C]-13612[/C][/ROW]
[ROW][C]144[/C][C]83484[/C][C]100480.108695652[/C][C]-16996.1086956522[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158003&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158003&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
1129404147646.675675676-18242.6756756757
2130358100480.10869565229877.8913043478
372156617.57142857143597.428571428572
4112861147646.675675676-34785.6756756757
5219904229232.5-9328.5
6402036229232.5172803.5
7117604100480.10869565217123.8913043478
81318221227859037
999729100480.108695652-751.108695652176
10256310229232.527077.5
11113066147646.675675676-34580.6756756757
12165392147646.67567567617745.3243243243
1378240100480.108695652-22240.1086956522
14152673229232.5-76559.5
15134368100480.10869565233887.8913043478
161257691227852984
17123467122785682
1856232100480.108695652-44248.1086956522
19108458147646.675675676-39188.6756756757
202276241513.1111111111-18751.1111111111
214863359955.4375-11322.4375
22182081147646.67567567634434.3243243243
23140857100480.10869565240376.8913043478
2493773147646.675675676-53873.6756756757
25133398147646.675675676-14248.6756756757
26113933100480.10869565213452.8913043478
27153851147646.6756756766204.32432432432
2814071112278517926
29303844229232.574611.5
30163810147646.67567567616163.3243243243
31123344100480.10869565222863.8913043478
3215764012278534855
33103274147646.675675676-44372.6756756757
34193500229232.5-35732.5
35178768147646.67567567631121.3243243243
3606617.57142857143-6617.57142857143
37181412147646.67567567633765.3243243243
3892342100480.108695652-8138.10869565218
39100023147646.675675676-47623.6756756757
40178277147646.67567567630630.3243243243
41145067147646.675675676-2579.67567567568
42114146100480.10869565213665.8913043478
4386039100480.108695652-14441.1086956522
44125481147646.675675676-22165.6756756757
4595535100480.108695652-4945.10869565218
46129221100480.10869565228740.8913043478
476155459955.43751598.5625
48168048147646.67567567620401.3243243243
49159121147646.67567567611474.3243243243
50129362147646.675675676-18284.6756756757
514818859955.4375-11767.4375
5295461100480.108695652-5019.10869565218
53229864147646.67567567682217.3243243243
54191094147646.67567567643447.3243243243
5516108212278538297
56111388100480.10869565210907.8913043478
57172614147646.67567567624967.3243243243
586320559955.43753249.5625
59109102122785-13683
60137303147646.675675676-10343.6756756757
611253041227852519
6288620147646.675675676-59026.6756756757
6395808100480.108695652-4672.10869565218
6483419100480.108695652-17061.1086956522
65101723100480.1086956521242.89130434782
6694982100480.108695652-5498.10869565218
67143566147646.675675676-4080.67567567568
68113325229232.5-115907.5
698151859955.437521562.5625
703197059955.4375-27985.4375
71192268229232.5-36964.5
7291261100480.108695652-9219.10869565218
7380820122785-41965
7485829100480.108695652-14651.1086956522
75116322147646.675675676-31324.6756756757
7656544100480.108695652-43936.1086956522
77116173147646.675675676-31473.6756756757
78118781147646.675675676-28865.6756756757
796013859955.4375182.5625
8073422100480.108695652-27058.1086956522
816775159955.43757795.5625
82214002147646.67567567666355.3243243243
835118541513.11111111119671.88888888889
8497181100480.108695652-3299.10869565218
854510059955.4375-14855.4375
86115801100480.10869565215320.8913043478
87186310147646.67567567638663.3243243243
8871960100480.108695652-28520.1086956522
8980105100480.108695652-20375.1086956522
90103613100480.1086956523132.89130434782
9198707100480.108695652-1773.10869565218
92136234147646.675675676-11412.6756756757
93136781100480.10869565236300.8913043478
94105863100480.1086956525382.89130434782
954222841513.1111111111714.888888888891
96179997147646.67567567632350.3243243243
97169406147646.67567567621759.3243243243
98193496617.5714285714312731.4285714286
99160819147646.67567567613172.3243243243
100109510100480.1086956529029.89130434782
1014380341513.11111111112289.88888888889
1024706259955.4375-12893.4375
103110845100480.10869565210364.8913043478
10492517100480.108695652-7963.10869565218
1055866041513.111111111117146.8888888889
1062767641513.1111111111-13837.1111111111
10798550122785-24235
1084364641513.11111111112132.88888888889
10906617.57142857143-6617.57142857143
11075566100480.108695652-24914.1086956522
1115735959955.4375-2596.4375
112104330100480.1086956523849.89130434782
11370369100480.108695652-30111.1086956522
1146549459955.43755538.5625
11536166617.57142857143-3001.57142857143
11606617.57142857143-6617.57142857143
117143931100480.10869565243450.8913043478
118117946122785-4839
119137332147646.675675676-10314.6756756757
1208433659955.437524380.5625
1214341041513.11111111111896.88888888889
12213625012278513465
1237901559955.437519059.5625
124101354122785-21431
1255758659955.4375-2369.4375
126197646617.5714285714313146.4285714286
127105757100480.1086956525276.89130434782
128103651100480.1086956523170.89130434782
129113402100480.10869565212921.8913043478
130117966617.571428571435178.42857142857
13176276617.571428571431009.42857142857
132121085100480.10869565220604.8913043478
13368366617.57142857143218.428571428572
134139563147646.675675676-8083.67567567568
13551186617.57142857143-1499.57142857143
1364024841513.1111111111-1265.11111111111
13706617.57142857143-6617.57142857143
13895079100480.108695652-5401.10869565218
13980763100480.108695652-19717.1086956522
14071316617.57142857143513.428571428572
14141946617.57142857143-2423.57142857143
1426037859955.4375422.5625
143109173122785-13612
14483484100480.108695652-16996.1086956522



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