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:40:51 -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/t1324395701sm82afubbvdcqy0.htm/, Retrieved Mon, 06 May 2024 01:36:24 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158006, Retrieved Mon, 06 May 2024 01:36:24 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact136
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [rt peer] [2011-12-20 15:40:51] [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=158006&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=158006&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158006&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.9177
R-squared0.8421
RMSE11.7561

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.9177[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8421[/C][/ROW]
[ROW][C]RMSE[/C][C]11.7561[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158006&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158006&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.9177
R-squared0.8421
RMSE11.7561







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
16348.272727272727314.7272727272727
25048.27272727272731.72727272727273
300.230769230769231-0.230769230769231
45165.3571428571429-14.3571428571429
511282.318181818181829.6818181818182
6118103.87514.125
75965.3571428571429-6.35714285714286
89070.777777777777819.2222222222222
95070.7777777777778-20.7777777777778
107982.3181818181818-3.31818181818181
114965.3571428571429-16.3571428571429
129182.31818181818188.68181818181819
133235.0625-3.0625
148265.357142857142916.6428571428571
155848.27272727272739.72727272727273
166565.3571428571429-0.357142857142861
17111103.8757.125
183635.06250.9375
198982.31818181818186.68181818181819
202835.0625-7.0625
213535.0625-0.0625
2278103.875-25.875
236770.7777777777778-3.77777777777777
246182.3181818181818-21.3181818181818
255865.3571428571429-7.35714285714286
264948.27272727272730.727272727272727
277765.357142857142911.6428571428571
287170.77777777777780.222222222222229
2985103.875-18.875
305648.27272727272737.72727272727273
317165.35714285714295.64285714285714
325865.3571428571429-7.35714285714286
333435.0625-1.0625
345965.3571428571429-6.35714285714286
357765.357142857142911.6428571428571
3600.230769230769231-0.230769230769231
377582.3181818181818-7.31818181818181
383935.06253.9375
398382.31818181818180.681818181818187
40123103.87519.125
416765.35714285714291.64285714285714
4210570.777777777777834.2222222222222
437665.357142857142910.6428571428571
445765.3571428571429-8.35714285714286
458265.357142857142916.6428571428571
466465.3571428571429-1.35714285714286
475770.7777777777778-13.7777777777778
488065.357142857142914.6428571428571
4994103.875-9.875
507282.3181818181818-10.3181818181818
513944.8571428571429-5.85714285714285
526065.3571428571429-5.35714285714286
538482.31818181818181.68181818181819
546982.3181818181818-13.3181818181818
5510282.318181818181819.6818181818182
562835.0625-7.0625
576582.3181818181818-17.3181818181818
586744.857142857142922.1428571428571
598065.357142857142914.6428571428571
607982.3181818181818-3.31818181818181
6110782.318181818181824.6818181818182
626065.3571428571429-5.35714285714286
635365.3571428571429-12.3571428571429
645965.3571428571429-6.35714285714286
658065.357142857142914.6428571428571
668970.777777777777818.2222222222222
67115103.87511.125
685965.3571428571429-6.35714285714286
696665.35714285714290.642857142857139
704244.8571428571429-2.85714285714285
713535.0625-0.0625
7238.14285714285714-5.14285714285714
737265.35714285714296.64285714285714
743848.2727272727273-10.2727272727273
75107103.8753.125
767370.77777777777782.22222222222223
778082.3181818181818-2.31818181818181
786965.35714285714293.64285714285714
794644.85714285714291.14285714285715
805270.7777777777778-18.7777777777778
815844.857142857142913.1428571428571
828582.31818181818182.68181818181819
831344.8571428571429-31.8571428571429
846170.7777777777778-9.77777777777777
854944.85714285714294.14285714285715
864765.3571428571429-18.3571428571429
879382.318181818181810.6818181818182
886565.3571428571429-0.357142857142861
896465.3571428571429-1.35714285714286
906465.3571428571429-1.35714285714286
915765.3571428571429-8.35714285714286
926165.3571428571429-4.35714285714286
937165.35714285714295.64285714285714
944335.06257.9375
95188.142857142857149.85714285714286
9610382.318181818181820.6818181818182
977682.3181818181818-6.31818181818181
9800.230769230769231-0.230769230769231
998382.31818181818180.681818181818187
1007370.77777777777782.22222222222223
10148.14285714285714-4.14285714285714
1024135.06255.9375
1035765.3571428571429-8.35714285714286
1045265.3571428571429-13.3571428571429
1052435.0625-11.0625
1061735.0625-18.0625
1078970.777777777777818.2222222222222
108208.1428571428571411.8571428571429
10900.230769230769231-0.230769230769231
1105170.7777777777778-19.7777777777778
1116348.272727272727314.7272727272727
1124848.2727272727273-0.272727272727273
1137065.35714285714294.64285714285714
1143248.2727272727273-16.2727272727273
11500.230769230769231-0.230769230769231
11600.230769230769231-0.230769230769231
1177265.35714285714296.64285714285714
1185670.7777777777778-14.7777777777778
1196682.3181818181818-16.3181818181818
1207765.357142857142911.6428571428571
12130.2307692307692312.76923076923077
1227370.77777777777782.22222222222223
1233735.06251.9375
1245782.3181818181818-25.3181818181818
1253235.0625-3.0625
12648.14285714285714-4.14285714285714
1275535.062519.9375
1288465.357142857142918.6428571428571
1299070.777777777777819.2222222222222
13018.14285714285714-7.14285714285714
13100.230769230769231-0.230769230769231
1323848.2727272727273-10.2727272727273
13300.230769230769231-0.230769230769231
1343648.2727272727273-12.2727272727273
13500.230769230769231-0.230769230769231
13678.14285714285714-1.14285714285714
13700.230769230769231-0.230769230769231
1387570.77777777777784.22222222222223
1395270.7777777777778-18.7777777777778
14000.230769230769231-0.230769230769231
14100.230769230769231-0.230769230769231
1424535.06259.9375
1436665.35714285714290.642857142857139
1444865.3571428571429-17.3571428571429

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 63 & 48.2727272727273 & 14.7272727272727 \tabularnewline
2 & 50 & 48.2727272727273 & 1.72727272727273 \tabularnewline
3 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
4 & 51 & 65.3571428571429 & -14.3571428571429 \tabularnewline
5 & 112 & 82.3181818181818 & 29.6818181818182 \tabularnewline
6 & 118 & 103.875 & 14.125 \tabularnewline
7 & 59 & 65.3571428571429 & -6.35714285714286 \tabularnewline
8 & 90 & 70.7777777777778 & 19.2222222222222 \tabularnewline
9 & 50 & 70.7777777777778 & -20.7777777777778 \tabularnewline
10 & 79 & 82.3181818181818 & -3.31818181818181 \tabularnewline
11 & 49 & 65.3571428571429 & -16.3571428571429 \tabularnewline
12 & 91 & 82.3181818181818 & 8.68181818181819 \tabularnewline
13 & 32 & 35.0625 & -3.0625 \tabularnewline
14 & 82 & 65.3571428571429 & 16.6428571428571 \tabularnewline
15 & 58 & 48.2727272727273 & 9.72727272727273 \tabularnewline
16 & 65 & 65.3571428571429 & -0.357142857142861 \tabularnewline
17 & 111 & 103.875 & 7.125 \tabularnewline
18 & 36 & 35.0625 & 0.9375 \tabularnewline
19 & 89 & 82.3181818181818 & 6.68181818181819 \tabularnewline
20 & 28 & 35.0625 & -7.0625 \tabularnewline
21 & 35 & 35.0625 & -0.0625 \tabularnewline
22 & 78 & 103.875 & -25.875 \tabularnewline
23 & 67 & 70.7777777777778 & -3.77777777777777 \tabularnewline
24 & 61 & 82.3181818181818 & -21.3181818181818 \tabularnewline
25 & 58 & 65.3571428571429 & -7.35714285714286 \tabularnewline
26 & 49 & 48.2727272727273 & 0.727272727272727 \tabularnewline
27 & 77 & 65.3571428571429 & 11.6428571428571 \tabularnewline
28 & 71 & 70.7777777777778 & 0.222222222222229 \tabularnewline
29 & 85 & 103.875 & -18.875 \tabularnewline
30 & 56 & 48.2727272727273 & 7.72727272727273 \tabularnewline
31 & 71 & 65.3571428571429 & 5.64285714285714 \tabularnewline
32 & 58 & 65.3571428571429 & -7.35714285714286 \tabularnewline
33 & 34 & 35.0625 & -1.0625 \tabularnewline
34 & 59 & 65.3571428571429 & -6.35714285714286 \tabularnewline
35 & 77 & 65.3571428571429 & 11.6428571428571 \tabularnewline
36 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
37 & 75 & 82.3181818181818 & -7.31818181818181 \tabularnewline
38 & 39 & 35.0625 & 3.9375 \tabularnewline
39 & 83 & 82.3181818181818 & 0.681818181818187 \tabularnewline
40 & 123 & 103.875 & 19.125 \tabularnewline
41 & 67 & 65.3571428571429 & 1.64285714285714 \tabularnewline
42 & 105 & 70.7777777777778 & 34.2222222222222 \tabularnewline
43 & 76 & 65.3571428571429 & 10.6428571428571 \tabularnewline
44 & 57 & 65.3571428571429 & -8.35714285714286 \tabularnewline
45 & 82 & 65.3571428571429 & 16.6428571428571 \tabularnewline
46 & 64 & 65.3571428571429 & -1.35714285714286 \tabularnewline
47 & 57 & 70.7777777777778 & -13.7777777777778 \tabularnewline
48 & 80 & 65.3571428571429 & 14.6428571428571 \tabularnewline
49 & 94 & 103.875 & -9.875 \tabularnewline
50 & 72 & 82.3181818181818 & -10.3181818181818 \tabularnewline
51 & 39 & 44.8571428571429 & -5.85714285714285 \tabularnewline
52 & 60 & 65.3571428571429 & -5.35714285714286 \tabularnewline
53 & 84 & 82.3181818181818 & 1.68181818181819 \tabularnewline
54 & 69 & 82.3181818181818 & -13.3181818181818 \tabularnewline
55 & 102 & 82.3181818181818 & 19.6818181818182 \tabularnewline
56 & 28 & 35.0625 & -7.0625 \tabularnewline
57 & 65 & 82.3181818181818 & -17.3181818181818 \tabularnewline
58 & 67 & 44.8571428571429 & 22.1428571428571 \tabularnewline
59 & 80 & 65.3571428571429 & 14.6428571428571 \tabularnewline
60 & 79 & 82.3181818181818 & -3.31818181818181 \tabularnewline
61 & 107 & 82.3181818181818 & 24.6818181818182 \tabularnewline
62 & 60 & 65.3571428571429 & -5.35714285714286 \tabularnewline
63 & 53 & 65.3571428571429 & -12.3571428571429 \tabularnewline
64 & 59 & 65.3571428571429 & -6.35714285714286 \tabularnewline
65 & 80 & 65.3571428571429 & 14.6428571428571 \tabularnewline
66 & 89 & 70.7777777777778 & 18.2222222222222 \tabularnewline
67 & 115 & 103.875 & 11.125 \tabularnewline
68 & 59 & 65.3571428571429 & -6.35714285714286 \tabularnewline
69 & 66 & 65.3571428571429 & 0.642857142857139 \tabularnewline
70 & 42 & 44.8571428571429 & -2.85714285714285 \tabularnewline
71 & 35 & 35.0625 & -0.0625 \tabularnewline
72 & 3 & 8.14285714285714 & -5.14285714285714 \tabularnewline
73 & 72 & 65.3571428571429 & 6.64285714285714 \tabularnewline
74 & 38 & 48.2727272727273 & -10.2727272727273 \tabularnewline
75 & 107 & 103.875 & 3.125 \tabularnewline
76 & 73 & 70.7777777777778 & 2.22222222222223 \tabularnewline
77 & 80 & 82.3181818181818 & -2.31818181818181 \tabularnewline
78 & 69 & 65.3571428571429 & 3.64285714285714 \tabularnewline
79 & 46 & 44.8571428571429 & 1.14285714285715 \tabularnewline
80 & 52 & 70.7777777777778 & -18.7777777777778 \tabularnewline
81 & 58 & 44.8571428571429 & 13.1428571428571 \tabularnewline
82 & 85 & 82.3181818181818 & 2.68181818181819 \tabularnewline
83 & 13 & 44.8571428571429 & -31.8571428571429 \tabularnewline
84 & 61 & 70.7777777777778 & -9.77777777777777 \tabularnewline
85 & 49 & 44.8571428571429 & 4.14285714285715 \tabularnewline
86 & 47 & 65.3571428571429 & -18.3571428571429 \tabularnewline
87 & 93 & 82.3181818181818 & 10.6818181818182 \tabularnewline
88 & 65 & 65.3571428571429 & -0.357142857142861 \tabularnewline
89 & 64 & 65.3571428571429 & -1.35714285714286 \tabularnewline
90 & 64 & 65.3571428571429 & -1.35714285714286 \tabularnewline
91 & 57 & 65.3571428571429 & -8.35714285714286 \tabularnewline
92 & 61 & 65.3571428571429 & -4.35714285714286 \tabularnewline
93 & 71 & 65.3571428571429 & 5.64285714285714 \tabularnewline
94 & 43 & 35.0625 & 7.9375 \tabularnewline
95 & 18 & 8.14285714285714 & 9.85714285714286 \tabularnewline
96 & 103 & 82.3181818181818 & 20.6818181818182 \tabularnewline
97 & 76 & 82.3181818181818 & -6.31818181818181 \tabularnewline
98 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
99 & 83 & 82.3181818181818 & 0.681818181818187 \tabularnewline
100 & 73 & 70.7777777777778 & 2.22222222222223 \tabularnewline
101 & 4 & 8.14285714285714 & -4.14285714285714 \tabularnewline
102 & 41 & 35.0625 & 5.9375 \tabularnewline
103 & 57 & 65.3571428571429 & -8.35714285714286 \tabularnewline
104 & 52 & 65.3571428571429 & -13.3571428571429 \tabularnewline
105 & 24 & 35.0625 & -11.0625 \tabularnewline
106 & 17 & 35.0625 & -18.0625 \tabularnewline
107 & 89 & 70.7777777777778 & 18.2222222222222 \tabularnewline
108 & 20 & 8.14285714285714 & 11.8571428571429 \tabularnewline
109 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
110 & 51 & 70.7777777777778 & -19.7777777777778 \tabularnewline
111 & 63 & 48.2727272727273 & 14.7272727272727 \tabularnewline
112 & 48 & 48.2727272727273 & -0.272727272727273 \tabularnewline
113 & 70 & 65.3571428571429 & 4.64285714285714 \tabularnewline
114 & 32 & 48.2727272727273 & -16.2727272727273 \tabularnewline
115 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
116 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
117 & 72 & 65.3571428571429 & 6.64285714285714 \tabularnewline
118 & 56 & 70.7777777777778 & -14.7777777777778 \tabularnewline
119 & 66 & 82.3181818181818 & -16.3181818181818 \tabularnewline
120 & 77 & 65.3571428571429 & 11.6428571428571 \tabularnewline
121 & 3 & 0.230769230769231 & 2.76923076923077 \tabularnewline
122 & 73 & 70.7777777777778 & 2.22222222222223 \tabularnewline
123 & 37 & 35.0625 & 1.9375 \tabularnewline
124 & 57 & 82.3181818181818 & -25.3181818181818 \tabularnewline
125 & 32 & 35.0625 & -3.0625 \tabularnewline
126 & 4 & 8.14285714285714 & -4.14285714285714 \tabularnewline
127 & 55 & 35.0625 & 19.9375 \tabularnewline
128 & 84 & 65.3571428571429 & 18.6428571428571 \tabularnewline
129 & 90 & 70.7777777777778 & 19.2222222222222 \tabularnewline
130 & 1 & 8.14285714285714 & -7.14285714285714 \tabularnewline
131 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
132 & 38 & 48.2727272727273 & -10.2727272727273 \tabularnewline
133 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
134 & 36 & 48.2727272727273 & -12.2727272727273 \tabularnewline
135 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
136 & 7 & 8.14285714285714 & -1.14285714285714 \tabularnewline
137 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
138 & 75 & 70.7777777777778 & 4.22222222222223 \tabularnewline
139 & 52 & 70.7777777777778 & -18.7777777777778 \tabularnewline
140 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
141 & 0 & 0.230769230769231 & -0.230769230769231 \tabularnewline
142 & 45 & 35.0625 & 9.9375 \tabularnewline
143 & 66 & 65.3571428571429 & 0.642857142857139 \tabularnewline
144 & 48 & 65.3571428571429 & -17.3571428571429 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158006&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]63[/C][C]48.2727272727273[/C][C]14.7272727272727[/C][/ROW]
[ROW][C]2[/C][C]50[/C][C]48.2727272727273[/C][C]1.72727272727273[/C][/ROW]
[ROW][C]3[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]4[/C][C]51[/C][C]65.3571428571429[/C][C]-14.3571428571429[/C][/ROW]
[ROW][C]5[/C][C]112[/C][C]82.3181818181818[/C][C]29.6818181818182[/C][/ROW]
[ROW][C]6[/C][C]118[/C][C]103.875[/C][C]14.125[/C][/ROW]
[ROW][C]7[/C][C]59[/C][C]65.3571428571429[/C][C]-6.35714285714286[/C][/ROW]
[ROW][C]8[/C][C]90[/C][C]70.7777777777778[/C][C]19.2222222222222[/C][/ROW]
[ROW][C]9[/C][C]50[/C][C]70.7777777777778[/C][C]-20.7777777777778[/C][/ROW]
[ROW][C]10[/C][C]79[/C][C]82.3181818181818[/C][C]-3.31818181818181[/C][/ROW]
[ROW][C]11[/C][C]49[/C][C]65.3571428571429[/C][C]-16.3571428571429[/C][/ROW]
[ROW][C]12[/C][C]91[/C][C]82.3181818181818[/C][C]8.68181818181819[/C][/ROW]
[ROW][C]13[/C][C]32[/C][C]35.0625[/C][C]-3.0625[/C][/ROW]
[ROW][C]14[/C][C]82[/C][C]65.3571428571429[/C][C]16.6428571428571[/C][/ROW]
[ROW][C]15[/C][C]58[/C][C]48.2727272727273[/C][C]9.72727272727273[/C][/ROW]
[ROW][C]16[/C][C]65[/C][C]65.3571428571429[/C][C]-0.357142857142861[/C][/ROW]
[ROW][C]17[/C][C]111[/C][C]103.875[/C][C]7.125[/C][/ROW]
[ROW][C]18[/C][C]36[/C][C]35.0625[/C][C]0.9375[/C][/ROW]
[ROW][C]19[/C][C]89[/C][C]82.3181818181818[/C][C]6.68181818181819[/C][/ROW]
[ROW][C]20[/C][C]28[/C][C]35.0625[/C][C]-7.0625[/C][/ROW]
[ROW][C]21[/C][C]35[/C][C]35.0625[/C][C]-0.0625[/C][/ROW]
[ROW][C]22[/C][C]78[/C][C]103.875[/C][C]-25.875[/C][/ROW]
[ROW][C]23[/C][C]67[/C][C]70.7777777777778[/C][C]-3.77777777777777[/C][/ROW]
[ROW][C]24[/C][C]61[/C][C]82.3181818181818[/C][C]-21.3181818181818[/C][/ROW]
[ROW][C]25[/C][C]58[/C][C]65.3571428571429[/C][C]-7.35714285714286[/C][/ROW]
[ROW][C]26[/C][C]49[/C][C]48.2727272727273[/C][C]0.727272727272727[/C][/ROW]
[ROW][C]27[/C][C]77[/C][C]65.3571428571429[/C][C]11.6428571428571[/C][/ROW]
[ROW][C]28[/C][C]71[/C][C]70.7777777777778[/C][C]0.222222222222229[/C][/ROW]
[ROW][C]29[/C][C]85[/C][C]103.875[/C][C]-18.875[/C][/ROW]
[ROW][C]30[/C][C]56[/C][C]48.2727272727273[/C][C]7.72727272727273[/C][/ROW]
[ROW][C]31[/C][C]71[/C][C]65.3571428571429[/C][C]5.64285714285714[/C][/ROW]
[ROW][C]32[/C][C]58[/C][C]65.3571428571429[/C][C]-7.35714285714286[/C][/ROW]
[ROW][C]33[/C][C]34[/C][C]35.0625[/C][C]-1.0625[/C][/ROW]
[ROW][C]34[/C][C]59[/C][C]65.3571428571429[/C][C]-6.35714285714286[/C][/ROW]
[ROW][C]35[/C][C]77[/C][C]65.3571428571429[/C][C]11.6428571428571[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]37[/C][C]75[/C][C]82.3181818181818[/C][C]-7.31818181818181[/C][/ROW]
[ROW][C]38[/C][C]39[/C][C]35.0625[/C][C]3.9375[/C][/ROW]
[ROW][C]39[/C][C]83[/C][C]82.3181818181818[/C][C]0.681818181818187[/C][/ROW]
[ROW][C]40[/C][C]123[/C][C]103.875[/C][C]19.125[/C][/ROW]
[ROW][C]41[/C][C]67[/C][C]65.3571428571429[/C][C]1.64285714285714[/C][/ROW]
[ROW][C]42[/C][C]105[/C][C]70.7777777777778[/C][C]34.2222222222222[/C][/ROW]
[ROW][C]43[/C][C]76[/C][C]65.3571428571429[/C][C]10.6428571428571[/C][/ROW]
[ROW][C]44[/C][C]57[/C][C]65.3571428571429[/C][C]-8.35714285714286[/C][/ROW]
[ROW][C]45[/C][C]82[/C][C]65.3571428571429[/C][C]16.6428571428571[/C][/ROW]
[ROW][C]46[/C][C]64[/C][C]65.3571428571429[/C][C]-1.35714285714286[/C][/ROW]
[ROW][C]47[/C][C]57[/C][C]70.7777777777778[/C][C]-13.7777777777778[/C][/ROW]
[ROW][C]48[/C][C]80[/C][C]65.3571428571429[/C][C]14.6428571428571[/C][/ROW]
[ROW][C]49[/C][C]94[/C][C]103.875[/C][C]-9.875[/C][/ROW]
[ROW][C]50[/C][C]72[/C][C]82.3181818181818[/C][C]-10.3181818181818[/C][/ROW]
[ROW][C]51[/C][C]39[/C][C]44.8571428571429[/C][C]-5.85714285714285[/C][/ROW]
[ROW][C]52[/C][C]60[/C][C]65.3571428571429[/C][C]-5.35714285714286[/C][/ROW]
[ROW][C]53[/C][C]84[/C][C]82.3181818181818[/C][C]1.68181818181819[/C][/ROW]
[ROW][C]54[/C][C]69[/C][C]82.3181818181818[/C][C]-13.3181818181818[/C][/ROW]
[ROW][C]55[/C][C]102[/C][C]82.3181818181818[/C][C]19.6818181818182[/C][/ROW]
[ROW][C]56[/C][C]28[/C][C]35.0625[/C][C]-7.0625[/C][/ROW]
[ROW][C]57[/C][C]65[/C][C]82.3181818181818[/C][C]-17.3181818181818[/C][/ROW]
[ROW][C]58[/C][C]67[/C][C]44.8571428571429[/C][C]22.1428571428571[/C][/ROW]
[ROW][C]59[/C][C]80[/C][C]65.3571428571429[/C][C]14.6428571428571[/C][/ROW]
[ROW][C]60[/C][C]79[/C][C]82.3181818181818[/C][C]-3.31818181818181[/C][/ROW]
[ROW][C]61[/C][C]107[/C][C]82.3181818181818[/C][C]24.6818181818182[/C][/ROW]
[ROW][C]62[/C][C]60[/C][C]65.3571428571429[/C][C]-5.35714285714286[/C][/ROW]
[ROW][C]63[/C][C]53[/C][C]65.3571428571429[/C][C]-12.3571428571429[/C][/ROW]
[ROW][C]64[/C][C]59[/C][C]65.3571428571429[/C][C]-6.35714285714286[/C][/ROW]
[ROW][C]65[/C][C]80[/C][C]65.3571428571429[/C][C]14.6428571428571[/C][/ROW]
[ROW][C]66[/C][C]89[/C][C]70.7777777777778[/C][C]18.2222222222222[/C][/ROW]
[ROW][C]67[/C][C]115[/C][C]103.875[/C][C]11.125[/C][/ROW]
[ROW][C]68[/C][C]59[/C][C]65.3571428571429[/C][C]-6.35714285714286[/C][/ROW]
[ROW][C]69[/C][C]66[/C][C]65.3571428571429[/C][C]0.642857142857139[/C][/ROW]
[ROW][C]70[/C][C]42[/C][C]44.8571428571429[/C][C]-2.85714285714285[/C][/ROW]
[ROW][C]71[/C][C]35[/C][C]35.0625[/C][C]-0.0625[/C][/ROW]
[ROW][C]72[/C][C]3[/C][C]8.14285714285714[/C][C]-5.14285714285714[/C][/ROW]
[ROW][C]73[/C][C]72[/C][C]65.3571428571429[/C][C]6.64285714285714[/C][/ROW]
[ROW][C]74[/C][C]38[/C][C]48.2727272727273[/C][C]-10.2727272727273[/C][/ROW]
[ROW][C]75[/C][C]107[/C][C]103.875[/C][C]3.125[/C][/ROW]
[ROW][C]76[/C][C]73[/C][C]70.7777777777778[/C][C]2.22222222222223[/C][/ROW]
[ROW][C]77[/C][C]80[/C][C]82.3181818181818[/C][C]-2.31818181818181[/C][/ROW]
[ROW][C]78[/C][C]69[/C][C]65.3571428571429[/C][C]3.64285714285714[/C][/ROW]
[ROW][C]79[/C][C]46[/C][C]44.8571428571429[/C][C]1.14285714285715[/C][/ROW]
[ROW][C]80[/C][C]52[/C][C]70.7777777777778[/C][C]-18.7777777777778[/C][/ROW]
[ROW][C]81[/C][C]58[/C][C]44.8571428571429[/C][C]13.1428571428571[/C][/ROW]
[ROW][C]82[/C][C]85[/C][C]82.3181818181818[/C][C]2.68181818181819[/C][/ROW]
[ROW][C]83[/C][C]13[/C][C]44.8571428571429[/C][C]-31.8571428571429[/C][/ROW]
[ROW][C]84[/C][C]61[/C][C]70.7777777777778[/C][C]-9.77777777777777[/C][/ROW]
[ROW][C]85[/C][C]49[/C][C]44.8571428571429[/C][C]4.14285714285715[/C][/ROW]
[ROW][C]86[/C][C]47[/C][C]65.3571428571429[/C][C]-18.3571428571429[/C][/ROW]
[ROW][C]87[/C][C]93[/C][C]82.3181818181818[/C][C]10.6818181818182[/C][/ROW]
[ROW][C]88[/C][C]65[/C][C]65.3571428571429[/C][C]-0.357142857142861[/C][/ROW]
[ROW][C]89[/C][C]64[/C][C]65.3571428571429[/C][C]-1.35714285714286[/C][/ROW]
[ROW][C]90[/C][C]64[/C][C]65.3571428571429[/C][C]-1.35714285714286[/C][/ROW]
[ROW][C]91[/C][C]57[/C][C]65.3571428571429[/C][C]-8.35714285714286[/C][/ROW]
[ROW][C]92[/C][C]61[/C][C]65.3571428571429[/C][C]-4.35714285714286[/C][/ROW]
[ROW][C]93[/C][C]71[/C][C]65.3571428571429[/C][C]5.64285714285714[/C][/ROW]
[ROW][C]94[/C][C]43[/C][C]35.0625[/C][C]7.9375[/C][/ROW]
[ROW][C]95[/C][C]18[/C][C]8.14285714285714[/C][C]9.85714285714286[/C][/ROW]
[ROW][C]96[/C][C]103[/C][C]82.3181818181818[/C][C]20.6818181818182[/C][/ROW]
[ROW][C]97[/C][C]76[/C][C]82.3181818181818[/C][C]-6.31818181818181[/C][/ROW]
[ROW][C]98[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]99[/C][C]83[/C][C]82.3181818181818[/C][C]0.681818181818187[/C][/ROW]
[ROW][C]100[/C][C]73[/C][C]70.7777777777778[/C][C]2.22222222222223[/C][/ROW]
[ROW][C]101[/C][C]4[/C][C]8.14285714285714[/C][C]-4.14285714285714[/C][/ROW]
[ROW][C]102[/C][C]41[/C][C]35.0625[/C][C]5.9375[/C][/ROW]
[ROW][C]103[/C][C]57[/C][C]65.3571428571429[/C][C]-8.35714285714286[/C][/ROW]
[ROW][C]104[/C][C]52[/C][C]65.3571428571429[/C][C]-13.3571428571429[/C][/ROW]
[ROW][C]105[/C][C]24[/C][C]35.0625[/C][C]-11.0625[/C][/ROW]
[ROW][C]106[/C][C]17[/C][C]35.0625[/C][C]-18.0625[/C][/ROW]
[ROW][C]107[/C][C]89[/C][C]70.7777777777778[/C][C]18.2222222222222[/C][/ROW]
[ROW][C]108[/C][C]20[/C][C]8.14285714285714[/C][C]11.8571428571429[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]110[/C][C]51[/C][C]70.7777777777778[/C][C]-19.7777777777778[/C][/ROW]
[ROW][C]111[/C][C]63[/C][C]48.2727272727273[/C][C]14.7272727272727[/C][/ROW]
[ROW][C]112[/C][C]48[/C][C]48.2727272727273[/C][C]-0.272727272727273[/C][/ROW]
[ROW][C]113[/C][C]70[/C][C]65.3571428571429[/C][C]4.64285714285714[/C][/ROW]
[ROW][C]114[/C][C]32[/C][C]48.2727272727273[/C][C]-16.2727272727273[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]117[/C][C]72[/C][C]65.3571428571429[/C][C]6.64285714285714[/C][/ROW]
[ROW][C]118[/C][C]56[/C][C]70.7777777777778[/C][C]-14.7777777777778[/C][/ROW]
[ROW][C]119[/C][C]66[/C][C]82.3181818181818[/C][C]-16.3181818181818[/C][/ROW]
[ROW][C]120[/C][C]77[/C][C]65.3571428571429[/C][C]11.6428571428571[/C][/ROW]
[ROW][C]121[/C][C]3[/C][C]0.230769230769231[/C][C]2.76923076923077[/C][/ROW]
[ROW][C]122[/C][C]73[/C][C]70.7777777777778[/C][C]2.22222222222223[/C][/ROW]
[ROW][C]123[/C][C]37[/C][C]35.0625[/C][C]1.9375[/C][/ROW]
[ROW][C]124[/C][C]57[/C][C]82.3181818181818[/C][C]-25.3181818181818[/C][/ROW]
[ROW][C]125[/C][C]32[/C][C]35.0625[/C][C]-3.0625[/C][/ROW]
[ROW][C]126[/C][C]4[/C][C]8.14285714285714[/C][C]-4.14285714285714[/C][/ROW]
[ROW][C]127[/C][C]55[/C][C]35.0625[/C][C]19.9375[/C][/ROW]
[ROW][C]128[/C][C]84[/C][C]65.3571428571429[/C][C]18.6428571428571[/C][/ROW]
[ROW][C]129[/C][C]90[/C][C]70.7777777777778[/C][C]19.2222222222222[/C][/ROW]
[ROW][C]130[/C][C]1[/C][C]8.14285714285714[/C][C]-7.14285714285714[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]132[/C][C]38[/C][C]48.2727272727273[/C][C]-10.2727272727273[/C][/ROW]
[ROW][C]133[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]134[/C][C]36[/C][C]48.2727272727273[/C][C]-12.2727272727273[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]136[/C][C]7[/C][C]8.14285714285714[/C][C]-1.14285714285714[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]138[/C][C]75[/C][C]70.7777777777778[/C][C]4.22222222222223[/C][/ROW]
[ROW][C]139[/C][C]52[/C][C]70.7777777777778[/C][C]-18.7777777777778[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]141[/C][C]0[/C][C]0.230769230769231[/C][C]-0.230769230769231[/C][/ROW]
[ROW][C]142[/C][C]45[/C][C]35.0625[/C][C]9.9375[/C][/ROW]
[ROW][C]143[/C][C]66[/C][C]65.3571428571429[/C][C]0.642857142857139[/C][/ROW]
[ROW][C]144[/C][C]48[/C][C]65.3571428571429[/C][C]-17.3571428571429[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158006&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158006&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
16348.272727272727314.7272727272727
25048.27272727272731.72727272727273
300.230769230769231-0.230769230769231
45165.3571428571429-14.3571428571429
511282.318181818181829.6818181818182
6118103.87514.125
75965.3571428571429-6.35714285714286
89070.777777777777819.2222222222222
95070.7777777777778-20.7777777777778
107982.3181818181818-3.31818181818181
114965.3571428571429-16.3571428571429
129182.31818181818188.68181818181819
133235.0625-3.0625
148265.357142857142916.6428571428571
155848.27272727272739.72727272727273
166565.3571428571429-0.357142857142861
17111103.8757.125
183635.06250.9375
198982.31818181818186.68181818181819
202835.0625-7.0625
213535.0625-0.0625
2278103.875-25.875
236770.7777777777778-3.77777777777777
246182.3181818181818-21.3181818181818
255865.3571428571429-7.35714285714286
264948.27272727272730.727272727272727
277765.357142857142911.6428571428571
287170.77777777777780.222222222222229
2985103.875-18.875
305648.27272727272737.72727272727273
317165.35714285714295.64285714285714
325865.3571428571429-7.35714285714286
333435.0625-1.0625
345965.3571428571429-6.35714285714286
357765.357142857142911.6428571428571
3600.230769230769231-0.230769230769231
377582.3181818181818-7.31818181818181
383935.06253.9375
398382.31818181818180.681818181818187
40123103.87519.125
416765.35714285714291.64285714285714
4210570.777777777777834.2222222222222
437665.357142857142910.6428571428571
445765.3571428571429-8.35714285714286
458265.357142857142916.6428571428571
466465.3571428571429-1.35714285714286
475770.7777777777778-13.7777777777778
488065.357142857142914.6428571428571
4994103.875-9.875
507282.3181818181818-10.3181818181818
513944.8571428571429-5.85714285714285
526065.3571428571429-5.35714285714286
538482.31818181818181.68181818181819
546982.3181818181818-13.3181818181818
5510282.318181818181819.6818181818182
562835.0625-7.0625
576582.3181818181818-17.3181818181818
586744.857142857142922.1428571428571
598065.357142857142914.6428571428571
607982.3181818181818-3.31818181818181
6110782.318181818181824.6818181818182
626065.3571428571429-5.35714285714286
635365.3571428571429-12.3571428571429
645965.3571428571429-6.35714285714286
658065.357142857142914.6428571428571
668970.777777777777818.2222222222222
67115103.87511.125
685965.3571428571429-6.35714285714286
696665.35714285714290.642857142857139
704244.8571428571429-2.85714285714285
713535.0625-0.0625
7238.14285714285714-5.14285714285714
737265.35714285714296.64285714285714
743848.2727272727273-10.2727272727273
75107103.8753.125
767370.77777777777782.22222222222223
778082.3181818181818-2.31818181818181
786965.35714285714293.64285714285714
794644.85714285714291.14285714285715
805270.7777777777778-18.7777777777778
815844.857142857142913.1428571428571
828582.31818181818182.68181818181819
831344.8571428571429-31.8571428571429
846170.7777777777778-9.77777777777777
854944.85714285714294.14285714285715
864765.3571428571429-18.3571428571429
879382.318181818181810.6818181818182
886565.3571428571429-0.357142857142861
896465.3571428571429-1.35714285714286
906465.3571428571429-1.35714285714286
915765.3571428571429-8.35714285714286
926165.3571428571429-4.35714285714286
937165.35714285714295.64285714285714
944335.06257.9375
95188.142857142857149.85714285714286
9610382.318181818181820.6818181818182
977682.3181818181818-6.31818181818181
9800.230769230769231-0.230769230769231
998382.31818181818180.681818181818187
1007370.77777777777782.22222222222223
10148.14285714285714-4.14285714285714
1024135.06255.9375
1035765.3571428571429-8.35714285714286
1045265.3571428571429-13.3571428571429
1052435.0625-11.0625
1061735.0625-18.0625
1078970.777777777777818.2222222222222
108208.1428571428571411.8571428571429
10900.230769230769231-0.230769230769231
1105170.7777777777778-19.7777777777778
1116348.272727272727314.7272727272727
1124848.2727272727273-0.272727272727273
1137065.35714285714294.64285714285714
1143248.2727272727273-16.2727272727273
11500.230769230769231-0.230769230769231
11600.230769230769231-0.230769230769231
1177265.35714285714296.64285714285714
1185670.7777777777778-14.7777777777778
1196682.3181818181818-16.3181818181818
1207765.357142857142911.6428571428571
12130.2307692307692312.76923076923077
1227370.77777777777782.22222222222223
1233735.06251.9375
1245782.3181818181818-25.3181818181818
1253235.0625-3.0625
12648.14285714285714-4.14285714285714
1275535.062519.9375
1288465.357142857142918.6428571428571
1299070.777777777777819.2222222222222
13018.14285714285714-7.14285714285714
13100.230769230769231-0.230769230769231
1323848.2727272727273-10.2727272727273
13300.230769230769231-0.230769230769231
1343648.2727272727273-12.2727272727273
13500.230769230769231-0.230769230769231
13678.14285714285714-1.14285714285714
13700.230769230769231-0.230769230769231
1387570.77777777777784.22222222222223
1395270.7777777777778-18.7777777777778
14000.230769230769231-0.230769230769231
14100.230769230769231-0.230769230769231
1424535.06259.9375
1436665.35714285714290.642857142857139
1444865.3571428571429-17.3571428571429



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