Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationWed, 21 Dec 2011 05:18:48 -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/21/t1324462793g24cc6ac66v1fx6.htm/, Retrieved Tue, 07 May 2024 11:12:34 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158439, Retrieved Tue, 07 May 2024 11:12:34 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact61
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [rfc RT quantiles] [2011-12-21 10:13:19] [26f9350dcf28f408b6e37deed68b781e]
-         [Recursive Partitioning (Regression Trees)] [rfc RT compcharacter] [2011-12-21 10:18:48] [0956ee981dded61b2e7128dae94e5715] [Current]
Feedback Forum

Post a new message
Dataseries X:
1772	158258	48	18	63	20465
1703	186930	53	20	56	33629
192	7215	0	0	0	1423
2294	129098	51	27	63	25629
3448	230587	76	31	116	54002
6813	508313	128	36	138	151036
1795	180745	62	23	71	33287
1680	185559	83	30	107	31172
1896	154581	55	30	50	28113
2917	290658	67	26	79	57803
1946	121844	50	24	58	49830
2148	184039	77	30	91	52143
1832	100324	46	22	41	21055
3059	209427	79	25	91	47007
1469	167592	55	18	61	28735
1565	154593	54	22	74	59147
1755	142018	81	33	131	78950
1234	77855	5	15	45	13497
2779	167047	74	34	110	46154
726	27997	13	18	41	53249
1048	73019	22	15	37	10726
2804	241082	99	30	84	83700
1760	195820	38	25	67	40400
2261	141899	59	34	69	33797
1848	145433	50	21	58	36205
1647	180241	50	21	60	30165
2081	202232	61	25	88	58534
1392	190230	81	31	75	44663
2741	354924	60	31	98	92556
2111	192399	52	20	67	40078
1684	182286	61	28	84	34711
1616	181590	60	22	62	31076
2227	133801	53	17	35	74608
3088	233686	76	25	74	58092
2388	219428	63	24	89	42009
1	0	0	0	0	0
2099	223044	54	28	79	36022
1669	100129	44	14	39	23333
2094	136733	36	35	101	53349
2153	249965	83	34	135	92596
2390	242379	105	22	76	49598
1701	145794	37	34	118	44093
983	96404	25	23	76	84205
2161	195891	64	24	65	63369
1276	117156	55	26	97	60132
1189	157787	41	22	67	37403
744	81293	23	35	63	24460
2231	224049	67	24	96	46456
2242	223789	54	31	112	66616
2638	160344	68	26	75	41554
658	48188	12	22	39	22346
1859	152206	86	21	63	30874
2489	294283	74	27	93	68701
2025	235223	56	30	76	35728
1911	195583	67	33	117	29010
1714	145942	40	11	30	23110
1851	208834	53	26	65	38844
980	93764	26	26	78	27084
1177	151985	67	23	87	35139
2809	190545	36	38	85	57476
1688	148922	50	31	115	33277
2097	132856	48	20	62	31141
1309	126107	46	19	53	61281
1243	112718	53	26	67	25820
1255	160930	27	26	90	23284
1293	99184	38	33	100	35378
2259	182022	69	36	135	74990
2897	138708	93	25	71	29653
1103	114408	59	24	75	64622
340	31970	5	21	42	4157
2791	225558	53	19	42	29245
1333	137011	40	12	8	50008
1441	113612	72	30	86	52338
1622	108641	51	21	41	13310
2649	162203	81	34	118	92901
1499	100098	27	32	91	10956
2302	174768	94	28	102	34241
2540	158459	71	28	89	75043
1000	80934	20	21	46	21152
1234	84971	34	31	60	42249
927	80545	54	26	69	42005
2176	287191	49	29	95	41152
956	62974	26	23	17	14399
1531	130982	47	25	61	28263
1013	75555	35	22	55	17215
1771	162154	32	26	55	48140
2613	226638	55	33	124	62897
1203	115019	58	24	73	22883
1303	105038	44	24	73	41622
1524	155537	45	21	67	40715
1829	153133	49	28	66	65897
2227	165577	72	27	75	76542
1233	151517	39	25	83	37477
1365	133686	28	15	55	53216
901	58128	24	13	27	40911
2319	245196	52	36	115	57021
1856	195576	96	24	76	73116
223	19349	13	1	0	3895
2390	225371	38	24	83	46609
1973	152796	41	31	90	29351
699	59117	24	4	4	2325
1062	91762	54	21	60	31747
1252	127987	59	23	63	32665
1154	113552	28	23	52	19249
823	85338	36	12	24	15292
596	27676	2	16	17	5842
1471	147984	83	29	105	33994
1130	122417	29	26	20	13018
0	0	0	0	0	0
1082	91529	46	25	51	98177
1134	107205	25	21	76	37941
1366	144664	51	23	59	31032
1452	136540	59	21	70	32683
869	76656	36	21	38	34545
78	3616	0	0	0	0
0	0	0	0	0	0
1127	183065	40	23	81	27525
1578	144636	68	33	78	66856
1982	152826	28	28	67	28549
919	113273	36	23	89	38610
778	43410	7	1	3	2781
1751	175774	70	29	87	41211
956	95401	30	18	51	22698
1875	118893	59	32	69	41194
731	60493	3	12	32	32689
285	19764	10	2	4	5752
1833	164062	46	21	70	26757
1147	132696	34	28	102	22527
1646	155367	54	29	91	44810
256	11796	1	2	1	0
98	10674	0	0	0	0
1403	142261	39	18	39	100674
41	6836	0	1	0	0
1786	154206	48	21	45	57786
42	5118	5	0	0	0
528	40248	8	4	7	5444
0	0	0	0	0	0
1072	122641	38	25	75	28470
1305	88837	21	26	52	61849
81	7131	0	0	0	0
261	9056	0	4	1	2179
934	76611	15	17	49	8019
1179	132697	50	21	69	39644
1147	100681	17	22	56	23494




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

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







Goodness of Fit
Correlation0.7092
R-squared0.503
RMSE17637.4145

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7092[/C][/ROW]
[ROW][C]R-squared[/C][C]0.503[/C][/ROW]
[ROW][C]RMSE[/C][C]17637.4145[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158439&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158439&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.7092
R-squared0.503
RMSE17637.4145







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
12046540588.4776119403-20123.4776119403
23362940588.4776119403-6959.4776119403
314232808.57894736842-1385.57894736842
42562953523.1739130435-27894.1739130435
55400253523.1739130435478.82608695652
615103677129.222222222273906.7777777778
73328740588.4776119403-7301.4776119403
83117240588.4776119403-9416.4776119403
92811340588.4776119403-12475.4776119403
105780377129.2222222222-19326.2222222222
114983040588.47761194039241.5223880597
125214353523.1739130435-1380.17391304348
132105540588.4776119403-19533.4776119403
144700753523.1739130435-6516.17391304348
152873540588.4776119403-11853.4776119403
165914740588.477611940318558.5223880597
177895040588.477611940338361.5223880597
181349729136.8076923077-15639.8076923077
194615453523.1739130435-7369.17391304348
205324929136.807692307724112.1923076923
211072629136.8076923077-18410.8076923077
228370077129.22222222226570.77777777778
234040040588.4776119403-188.477611940296
243379753523.1739130435-19726.1739130435
253620540588.4776119403-4383.4776119403
263016540588.4776119403-10423.4776119403
275853440588.477611940317945.5223880597
284466340588.47761194034074.5223880597
299255677129.222222222215426.7777777778
304007840588.4776119403-510.477611940296
313471140588.4776119403-5877.4776119403
323107640588.4776119403-9512.4776119403
337460853523.173913043521084.8260869565
345809253523.17391304354568.82608695652
354200953523.1739130435-11514.1739130435
3602808.57894736842-2808.57894736842
373602240588.4776119403-4566.4776119403
382333340588.4776119403-17255.4776119403
395334940588.477611940312760.5223880597
409259677129.222222222215466.7777777778
414959877129.2222222222-27531.2222222222
424409340588.47761194033504.5223880597
438420529136.807692307755068.1923076923
446336953523.17391304359845.82608695652
456013240588.477611940319543.5223880597
463740340588.4776119403-3185.4776119403
472446029136.8076923077-4676.80769230769
484645653523.1739130435-7067.17391304348
496661653523.173913043513092.8260869565
504155453523.1739130435-11969.1739130435
51223462808.5789473684219537.4210526316
523087440588.4776119403-9714.4776119403
536870177129.2222222222-8428.22222222222
543572840588.4776119403-4860.4776119403
552901040588.4776119403-11578.4776119403
562311040588.4776119403-17478.4776119403
573884440588.4776119403-1744.4776119403
582708429136.8076923077-2052.80769230769
593513940588.4776119403-5449.4776119403
605747653523.17391304353952.82608695652
613327740588.4776119403-7311.4776119403
623114140588.4776119403-9447.4776119403
636128140588.477611940320692.5223880597
642582040588.4776119403-14768.4776119403
652328429136.8076923077-5852.80769230769
663537840588.4776119403-5210.4776119403
677499053523.173913043521466.8260869565
682965353523.1739130435-23870.1739130435
696462240588.477611940324033.5223880597
7041572808.578947368421348.42105263158
712924553523.1739130435-24278.1739130435
725000840588.47761194039419.5223880597
735233840588.477611940311749.5223880597
741331040588.4776119403-27278.4776119403
759290153523.173913043539377.8260869565
761095629136.8076923077-18180.8076923077
773424153523.1739130435-19282.1739130435
787504353523.173913043521519.8260869565
792115229136.8076923077-7984.80769230769
804224929136.807692307713112.1923076923
814200540588.47761194031416.5223880597
824115277129.2222222222-35977.2222222222
831439929136.8076923077-14737.8076923077
842826340588.4776119403-12325.4776119403
851721529136.8076923077-11921.8076923077
864814029136.807692307719003.1923076923
876289753523.17391304359373.82608695652
882288340588.4776119403-17705.4776119403
894162240588.47761194031033.5223880597
904071540588.4776119403126.522388059704
916589740588.477611940325308.5223880597
927654253523.173913043523018.8260869565
933747740588.4776119403-3111.4776119403
945321629136.807692307724079.1923076923
954091129136.807692307711774.1923076923
965702177129.2222222222-20108.2222222222
977311640588.477611940332527.5223880597
9838952808.578947368421086.42105263158
994660953523.1739130435-6914.17391304348
1002935140588.4776119403-11237.4776119403
10123252808.57894736842-483.578947368421
1023174740588.4776119403-8841.4776119403
1033266540588.4776119403-7923.4776119403
1041924929136.8076923077-9887.80769230769
1051529240588.4776119403-25296.4776119403
10658422808.578947368423033.42105263158
1073399440588.4776119403-6594.4776119403
1081301829136.8076923077-16118.8076923077
10902808.57894736842-2808.57894736842
1109817740588.477611940357588.5223880597
1113794129136.80769230778804.1923076923
1123103240588.4776119403-9556.4776119403
1133268340588.4776119403-7905.4776119403
1143454540588.4776119403-6043.4776119403
11502808.57894736842-2808.57894736842
11602808.57894736842-2808.57894736842
1172752540588.4776119403-13063.4776119403
1186685640588.477611940326267.5223880597
1192854929136.8076923077-587.807692307691
1203861040588.4776119403-1978.4776119403
121278129136.8076923077-26355.8076923077
1224121140588.4776119403622.522388059704
1232269829136.8076923077-6438.80769230769
1244119440588.4776119403605.522388059704
1253268929136.80769230773552.19230769231
12657522808.578947368422943.42105263158
1272675740588.4776119403-13831.4776119403
1282252729136.8076923077-6609.80769230769
1294481040588.47761194034221.5223880597
13002808.57894736842-2808.57894736842
13102808.57894736842-2808.57894736842
13210067440588.477611940360085.5223880597
13302808.57894736842-2808.57894736842
1345778640588.477611940317197.5223880597
13502808.57894736842-2808.57894736842
13654442808.578947368422635.42105263158
13702808.57894736842-2808.57894736842
1382847040588.4776119403-12118.4776119403
1396184929136.807692307732712.1923076923
14002808.57894736842-2808.57894736842
14121792808.57894736842-629.578947368421
142801929136.8076923077-21117.8076923077
1433964440588.4776119403-944.477611940296
1442349429136.8076923077-5642.80769230769

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 20465 & 40588.4776119403 & -20123.4776119403 \tabularnewline
2 & 33629 & 40588.4776119403 & -6959.4776119403 \tabularnewline
3 & 1423 & 2808.57894736842 & -1385.57894736842 \tabularnewline
4 & 25629 & 53523.1739130435 & -27894.1739130435 \tabularnewline
5 & 54002 & 53523.1739130435 & 478.82608695652 \tabularnewline
6 & 151036 & 77129.2222222222 & 73906.7777777778 \tabularnewline
7 & 33287 & 40588.4776119403 & -7301.4776119403 \tabularnewline
8 & 31172 & 40588.4776119403 & -9416.4776119403 \tabularnewline
9 & 28113 & 40588.4776119403 & -12475.4776119403 \tabularnewline
10 & 57803 & 77129.2222222222 & -19326.2222222222 \tabularnewline
11 & 49830 & 40588.4776119403 & 9241.5223880597 \tabularnewline
12 & 52143 & 53523.1739130435 & -1380.17391304348 \tabularnewline
13 & 21055 & 40588.4776119403 & -19533.4776119403 \tabularnewline
14 & 47007 & 53523.1739130435 & -6516.17391304348 \tabularnewline
15 & 28735 & 40588.4776119403 & -11853.4776119403 \tabularnewline
16 & 59147 & 40588.4776119403 & 18558.5223880597 \tabularnewline
17 & 78950 & 40588.4776119403 & 38361.5223880597 \tabularnewline
18 & 13497 & 29136.8076923077 & -15639.8076923077 \tabularnewline
19 & 46154 & 53523.1739130435 & -7369.17391304348 \tabularnewline
20 & 53249 & 29136.8076923077 & 24112.1923076923 \tabularnewline
21 & 10726 & 29136.8076923077 & -18410.8076923077 \tabularnewline
22 & 83700 & 77129.2222222222 & 6570.77777777778 \tabularnewline
23 & 40400 & 40588.4776119403 & -188.477611940296 \tabularnewline
24 & 33797 & 53523.1739130435 & -19726.1739130435 \tabularnewline
25 & 36205 & 40588.4776119403 & -4383.4776119403 \tabularnewline
26 & 30165 & 40588.4776119403 & -10423.4776119403 \tabularnewline
27 & 58534 & 40588.4776119403 & 17945.5223880597 \tabularnewline
28 & 44663 & 40588.4776119403 & 4074.5223880597 \tabularnewline
29 & 92556 & 77129.2222222222 & 15426.7777777778 \tabularnewline
30 & 40078 & 40588.4776119403 & -510.477611940296 \tabularnewline
31 & 34711 & 40588.4776119403 & -5877.4776119403 \tabularnewline
32 & 31076 & 40588.4776119403 & -9512.4776119403 \tabularnewline
33 & 74608 & 53523.1739130435 & 21084.8260869565 \tabularnewline
34 & 58092 & 53523.1739130435 & 4568.82608695652 \tabularnewline
35 & 42009 & 53523.1739130435 & -11514.1739130435 \tabularnewline
36 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
37 & 36022 & 40588.4776119403 & -4566.4776119403 \tabularnewline
38 & 23333 & 40588.4776119403 & -17255.4776119403 \tabularnewline
39 & 53349 & 40588.4776119403 & 12760.5223880597 \tabularnewline
40 & 92596 & 77129.2222222222 & 15466.7777777778 \tabularnewline
41 & 49598 & 77129.2222222222 & -27531.2222222222 \tabularnewline
42 & 44093 & 40588.4776119403 & 3504.5223880597 \tabularnewline
43 & 84205 & 29136.8076923077 & 55068.1923076923 \tabularnewline
44 & 63369 & 53523.1739130435 & 9845.82608695652 \tabularnewline
45 & 60132 & 40588.4776119403 & 19543.5223880597 \tabularnewline
46 & 37403 & 40588.4776119403 & -3185.4776119403 \tabularnewline
47 & 24460 & 29136.8076923077 & -4676.80769230769 \tabularnewline
48 & 46456 & 53523.1739130435 & -7067.17391304348 \tabularnewline
49 & 66616 & 53523.1739130435 & 13092.8260869565 \tabularnewline
50 & 41554 & 53523.1739130435 & -11969.1739130435 \tabularnewline
51 & 22346 & 2808.57894736842 & 19537.4210526316 \tabularnewline
52 & 30874 & 40588.4776119403 & -9714.4776119403 \tabularnewline
53 & 68701 & 77129.2222222222 & -8428.22222222222 \tabularnewline
54 & 35728 & 40588.4776119403 & -4860.4776119403 \tabularnewline
55 & 29010 & 40588.4776119403 & -11578.4776119403 \tabularnewline
56 & 23110 & 40588.4776119403 & -17478.4776119403 \tabularnewline
57 & 38844 & 40588.4776119403 & -1744.4776119403 \tabularnewline
58 & 27084 & 29136.8076923077 & -2052.80769230769 \tabularnewline
59 & 35139 & 40588.4776119403 & -5449.4776119403 \tabularnewline
60 & 57476 & 53523.1739130435 & 3952.82608695652 \tabularnewline
61 & 33277 & 40588.4776119403 & -7311.4776119403 \tabularnewline
62 & 31141 & 40588.4776119403 & -9447.4776119403 \tabularnewline
63 & 61281 & 40588.4776119403 & 20692.5223880597 \tabularnewline
64 & 25820 & 40588.4776119403 & -14768.4776119403 \tabularnewline
65 & 23284 & 29136.8076923077 & -5852.80769230769 \tabularnewline
66 & 35378 & 40588.4776119403 & -5210.4776119403 \tabularnewline
67 & 74990 & 53523.1739130435 & 21466.8260869565 \tabularnewline
68 & 29653 & 53523.1739130435 & -23870.1739130435 \tabularnewline
69 & 64622 & 40588.4776119403 & 24033.5223880597 \tabularnewline
70 & 4157 & 2808.57894736842 & 1348.42105263158 \tabularnewline
71 & 29245 & 53523.1739130435 & -24278.1739130435 \tabularnewline
72 & 50008 & 40588.4776119403 & 9419.5223880597 \tabularnewline
73 & 52338 & 40588.4776119403 & 11749.5223880597 \tabularnewline
74 & 13310 & 40588.4776119403 & -27278.4776119403 \tabularnewline
75 & 92901 & 53523.1739130435 & 39377.8260869565 \tabularnewline
76 & 10956 & 29136.8076923077 & -18180.8076923077 \tabularnewline
77 & 34241 & 53523.1739130435 & -19282.1739130435 \tabularnewline
78 & 75043 & 53523.1739130435 & 21519.8260869565 \tabularnewline
79 & 21152 & 29136.8076923077 & -7984.80769230769 \tabularnewline
80 & 42249 & 29136.8076923077 & 13112.1923076923 \tabularnewline
81 & 42005 & 40588.4776119403 & 1416.5223880597 \tabularnewline
82 & 41152 & 77129.2222222222 & -35977.2222222222 \tabularnewline
83 & 14399 & 29136.8076923077 & -14737.8076923077 \tabularnewline
84 & 28263 & 40588.4776119403 & -12325.4776119403 \tabularnewline
85 & 17215 & 29136.8076923077 & -11921.8076923077 \tabularnewline
86 & 48140 & 29136.8076923077 & 19003.1923076923 \tabularnewline
87 & 62897 & 53523.1739130435 & 9373.82608695652 \tabularnewline
88 & 22883 & 40588.4776119403 & -17705.4776119403 \tabularnewline
89 & 41622 & 40588.4776119403 & 1033.5223880597 \tabularnewline
90 & 40715 & 40588.4776119403 & 126.522388059704 \tabularnewline
91 & 65897 & 40588.4776119403 & 25308.5223880597 \tabularnewline
92 & 76542 & 53523.1739130435 & 23018.8260869565 \tabularnewline
93 & 37477 & 40588.4776119403 & -3111.4776119403 \tabularnewline
94 & 53216 & 29136.8076923077 & 24079.1923076923 \tabularnewline
95 & 40911 & 29136.8076923077 & 11774.1923076923 \tabularnewline
96 & 57021 & 77129.2222222222 & -20108.2222222222 \tabularnewline
97 & 73116 & 40588.4776119403 & 32527.5223880597 \tabularnewline
98 & 3895 & 2808.57894736842 & 1086.42105263158 \tabularnewline
99 & 46609 & 53523.1739130435 & -6914.17391304348 \tabularnewline
100 & 29351 & 40588.4776119403 & -11237.4776119403 \tabularnewline
101 & 2325 & 2808.57894736842 & -483.578947368421 \tabularnewline
102 & 31747 & 40588.4776119403 & -8841.4776119403 \tabularnewline
103 & 32665 & 40588.4776119403 & -7923.4776119403 \tabularnewline
104 & 19249 & 29136.8076923077 & -9887.80769230769 \tabularnewline
105 & 15292 & 40588.4776119403 & -25296.4776119403 \tabularnewline
106 & 5842 & 2808.57894736842 & 3033.42105263158 \tabularnewline
107 & 33994 & 40588.4776119403 & -6594.4776119403 \tabularnewline
108 & 13018 & 29136.8076923077 & -16118.8076923077 \tabularnewline
109 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
110 & 98177 & 40588.4776119403 & 57588.5223880597 \tabularnewline
111 & 37941 & 29136.8076923077 & 8804.1923076923 \tabularnewline
112 & 31032 & 40588.4776119403 & -9556.4776119403 \tabularnewline
113 & 32683 & 40588.4776119403 & -7905.4776119403 \tabularnewline
114 & 34545 & 40588.4776119403 & -6043.4776119403 \tabularnewline
115 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
116 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
117 & 27525 & 40588.4776119403 & -13063.4776119403 \tabularnewline
118 & 66856 & 40588.4776119403 & 26267.5223880597 \tabularnewline
119 & 28549 & 29136.8076923077 & -587.807692307691 \tabularnewline
120 & 38610 & 40588.4776119403 & -1978.4776119403 \tabularnewline
121 & 2781 & 29136.8076923077 & -26355.8076923077 \tabularnewline
122 & 41211 & 40588.4776119403 & 622.522388059704 \tabularnewline
123 & 22698 & 29136.8076923077 & -6438.80769230769 \tabularnewline
124 & 41194 & 40588.4776119403 & 605.522388059704 \tabularnewline
125 & 32689 & 29136.8076923077 & 3552.19230769231 \tabularnewline
126 & 5752 & 2808.57894736842 & 2943.42105263158 \tabularnewline
127 & 26757 & 40588.4776119403 & -13831.4776119403 \tabularnewline
128 & 22527 & 29136.8076923077 & -6609.80769230769 \tabularnewline
129 & 44810 & 40588.4776119403 & 4221.5223880597 \tabularnewline
130 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
131 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
132 & 100674 & 40588.4776119403 & 60085.5223880597 \tabularnewline
133 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
134 & 57786 & 40588.4776119403 & 17197.5223880597 \tabularnewline
135 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
136 & 5444 & 2808.57894736842 & 2635.42105263158 \tabularnewline
137 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
138 & 28470 & 40588.4776119403 & -12118.4776119403 \tabularnewline
139 & 61849 & 29136.8076923077 & 32712.1923076923 \tabularnewline
140 & 0 & 2808.57894736842 & -2808.57894736842 \tabularnewline
141 & 2179 & 2808.57894736842 & -629.578947368421 \tabularnewline
142 & 8019 & 29136.8076923077 & -21117.8076923077 \tabularnewline
143 & 39644 & 40588.4776119403 & -944.477611940296 \tabularnewline
144 & 23494 & 29136.8076923077 & -5642.80769230769 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158439&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]20465[/C][C]40588.4776119403[/C][C]-20123.4776119403[/C][/ROW]
[ROW][C]2[/C][C]33629[/C][C]40588.4776119403[/C][C]-6959.4776119403[/C][/ROW]
[ROW][C]3[/C][C]1423[/C][C]2808.57894736842[/C][C]-1385.57894736842[/C][/ROW]
[ROW][C]4[/C][C]25629[/C][C]53523.1739130435[/C][C]-27894.1739130435[/C][/ROW]
[ROW][C]5[/C][C]54002[/C][C]53523.1739130435[/C][C]478.82608695652[/C][/ROW]
[ROW][C]6[/C][C]151036[/C][C]77129.2222222222[/C][C]73906.7777777778[/C][/ROW]
[ROW][C]7[/C][C]33287[/C][C]40588.4776119403[/C][C]-7301.4776119403[/C][/ROW]
[ROW][C]8[/C][C]31172[/C][C]40588.4776119403[/C][C]-9416.4776119403[/C][/ROW]
[ROW][C]9[/C][C]28113[/C][C]40588.4776119403[/C][C]-12475.4776119403[/C][/ROW]
[ROW][C]10[/C][C]57803[/C][C]77129.2222222222[/C][C]-19326.2222222222[/C][/ROW]
[ROW][C]11[/C][C]49830[/C][C]40588.4776119403[/C][C]9241.5223880597[/C][/ROW]
[ROW][C]12[/C][C]52143[/C][C]53523.1739130435[/C][C]-1380.17391304348[/C][/ROW]
[ROW][C]13[/C][C]21055[/C][C]40588.4776119403[/C][C]-19533.4776119403[/C][/ROW]
[ROW][C]14[/C][C]47007[/C][C]53523.1739130435[/C][C]-6516.17391304348[/C][/ROW]
[ROW][C]15[/C][C]28735[/C][C]40588.4776119403[/C][C]-11853.4776119403[/C][/ROW]
[ROW][C]16[/C][C]59147[/C][C]40588.4776119403[/C][C]18558.5223880597[/C][/ROW]
[ROW][C]17[/C][C]78950[/C][C]40588.4776119403[/C][C]38361.5223880597[/C][/ROW]
[ROW][C]18[/C][C]13497[/C][C]29136.8076923077[/C][C]-15639.8076923077[/C][/ROW]
[ROW][C]19[/C][C]46154[/C][C]53523.1739130435[/C][C]-7369.17391304348[/C][/ROW]
[ROW][C]20[/C][C]53249[/C][C]29136.8076923077[/C][C]24112.1923076923[/C][/ROW]
[ROW][C]21[/C][C]10726[/C][C]29136.8076923077[/C][C]-18410.8076923077[/C][/ROW]
[ROW][C]22[/C][C]83700[/C][C]77129.2222222222[/C][C]6570.77777777778[/C][/ROW]
[ROW][C]23[/C][C]40400[/C][C]40588.4776119403[/C][C]-188.477611940296[/C][/ROW]
[ROW][C]24[/C][C]33797[/C][C]53523.1739130435[/C][C]-19726.1739130435[/C][/ROW]
[ROW][C]25[/C][C]36205[/C][C]40588.4776119403[/C][C]-4383.4776119403[/C][/ROW]
[ROW][C]26[/C][C]30165[/C][C]40588.4776119403[/C][C]-10423.4776119403[/C][/ROW]
[ROW][C]27[/C][C]58534[/C][C]40588.4776119403[/C][C]17945.5223880597[/C][/ROW]
[ROW][C]28[/C][C]44663[/C][C]40588.4776119403[/C][C]4074.5223880597[/C][/ROW]
[ROW][C]29[/C][C]92556[/C][C]77129.2222222222[/C][C]15426.7777777778[/C][/ROW]
[ROW][C]30[/C][C]40078[/C][C]40588.4776119403[/C][C]-510.477611940296[/C][/ROW]
[ROW][C]31[/C][C]34711[/C][C]40588.4776119403[/C][C]-5877.4776119403[/C][/ROW]
[ROW][C]32[/C][C]31076[/C][C]40588.4776119403[/C][C]-9512.4776119403[/C][/ROW]
[ROW][C]33[/C][C]74608[/C][C]53523.1739130435[/C][C]21084.8260869565[/C][/ROW]
[ROW][C]34[/C][C]58092[/C][C]53523.1739130435[/C][C]4568.82608695652[/C][/ROW]
[ROW][C]35[/C][C]42009[/C][C]53523.1739130435[/C][C]-11514.1739130435[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]37[/C][C]36022[/C][C]40588.4776119403[/C][C]-4566.4776119403[/C][/ROW]
[ROW][C]38[/C][C]23333[/C][C]40588.4776119403[/C][C]-17255.4776119403[/C][/ROW]
[ROW][C]39[/C][C]53349[/C][C]40588.4776119403[/C][C]12760.5223880597[/C][/ROW]
[ROW][C]40[/C][C]92596[/C][C]77129.2222222222[/C][C]15466.7777777778[/C][/ROW]
[ROW][C]41[/C][C]49598[/C][C]77129.2222222222[/C][C]-27531.2222222222[/C][/ROW]
[ROW][C]42[/C][C]44093[/C][C]40588.4776119403[/C][C]3504.5223880597[/C][/ROW]
[ROW][C]43[/C][C]84205[/C][C]29136.8076923077[/C][C]55068.1923076923[/C][/ROW]
[ROW][C]44[/C][C]63369[/C][C]53523.1739130435[/C][C]9845.82608695652[/C][/ROW]
[ROW][C]45[/C][C]60132[/C][C]40588.4776119403[/C][C]19543.5223880597[/C][/ROW]
[ROW][C]46[/C][C]37403[/C][C]40588.4776119403[/C][C]-3185.4776119403[/C][/ROW]
[ROW][C]47[/C][C]24460[/C][C]29136.8076923077[/C][C]-4676.80769230769[/C][/ROW]
[ROW][C]48[/C][C]46456[/C][C]53523.1739130435[/C][C]-7067.17391304348[/C][/ROW]
[ROW][C]49[/C][C]66616[/C][C]53523.1739130435[/C][C]13092.8260869565[/C][/ROW]
[ROW][C]50[/C][C]41554[/C][C]53523.1739130435[/C][C]-11969.1739130435[/C][/ROW]
[ROW][C]51[/C][C]22346[/C][C]2808.57894736842[/C][C]19537.4210526316[/C][/ROW]
[ROW][C]52[/C][C]30874[/C][C]40588.4776119403[/C][C]-9714.4776119403[/C][/ROW]
[ROW][C]53[/C][C]68701[/C][C]77129.2222222222[/C][C]-8428.22222222222[/C][/ROW]
[ROW][C]54[/C][C]35728[/C][C]40588.4776119403[/C][C]-4860.4776119403[/C][/ROW]
[ROW][C]55[/C][C]29010[/C][C]40588.4776119403[/C][C]-11578.4776119403[/C][/ROW]
[ROW][C]56[/C][C]23110[/C][C]40588.4776119403[/C][C]-17478.4776119403[/C][/ROW]
[ROW][C]57[/C][C]38844[/C][C]40588.4776119403[/C][C]-1744.4776119403[/C][/ROW]
[ROW][C]58[/C][C]27084[/C][C]29136.8076923077[/C][C]-2052.80769230769[/C][/ROW]
[ROW][C]59[/C][C]35139[/C][C]40588.4776119403[/C][C]-5449.4776119403[/C][/ROW]
[ROW][C]60[/C][C]57476[/C][C]53523.1739130435[/C][C]3952.82608695652[/C][/ROW]
[ROW][C]61[/C][C]33277[/C][C]40588.4776119403[/C][C]-7311.4776119403[/C][/ROW]
[ROW][C]62[/C][C]31141[/C][C]40588.4776119403[/C][C]-9447.4776119403[/C][/ROW]
[ROW][C]63[/C][C]61281[/C][C]40588.4776119403[/C][C]20692.5223880597[/C][/ROW]
[ROW][C]64[/C][C]25820[/C][C]40588.4776119403[/C][C]-14768.4776119403[/C][/ROW]
[ROW][C]65[/C][C]23284[/C][C]29136.8076923077[/C][C]-5852.80769230769[/C][/ROW]
[ROW][C]66[/C][C]35378[/C][C]40588.4776119403[/C][C]-5210.4776119403[/C][/ROW]
[ROW][C]67[/C][C]74990[/C][C]53523.1739130435[/C][C]21466.8260869565[/C][/ROW]
[ROW][C]68[/C][C]29653[/C][C]53523.1739130435[/C][C]-23870.1739130435[/C][/ROW]
[ROW][C]69[/C][C]64622[/C][C]40588.4776119403[/C][C]24033.5223880597[/C][/ROW]
[ROW][C]70[/C][C]4157[/C][C]2808.57894736842[/C][C]1348.42105263158[/C][/ROW]
[ROW][C]71[/C][C]29245[/C][C]53523.1739130435[/C][C]-24278.1739130435[/C][/ROW]
[ROW][C]72[/C][C]50008[/C][C]40588.4776119403[/C][C]9419.5223880597[/C][/ROW]
[ROW][C]73[/C][C]52338[/C][C]40588.4776119403[/C][C]11749.5223880597[/C][/ROW]
[ROW][C]74[/C][C]13310[/C][C]40588.4776119403[/C][C]-27278.4776119403[/C][/ROW]
[ROW][C]75[/C][C]92901[/C][C]53523.1739130435[/C][C]39377.8260869565[/C][/ROW]
[ROW][C]76[/C][C]10956[/C][C]29136.8076923077[/C][C]-18180.8076923077[/C][/ROW]
[ROW][C]77[/C][C]34241[/C][C]53523.1739130435[/C][C]-19282.1739130435[/C][/ROW]
[ROW][C]78[/C][C]75043[/C][C]53523.1739130435[/C][C]21519.8260869565[/C][/ROW]
[ROW][C]79[/C][C]21152[/C][C]29136.8076923077[/C][C]-7984.80769230769[/C][/ROW]
[ROW][C]80[/C][C]42249[/C][C]29136.8076923077[/C][C]13112.1923076923[/C][/ROW]
[ROW][C]81[/C][C]42005[/C][C]40588.4776119403[/C][C]1416.5223880597[/C][/ROW]
[ROW][C]82[/C][C]41152[/C][C]77129.2222222222[/C][C]-35977.2222222222[/C][/ROW]
[ROW][C]83[/C][C]14399[/C][C]29136.8076923077[/C][C]-14737.8076923077[/C][/ROW]
[ROW][C]84[/C][C]28263[/C][C]40588.4776119403[/C][C]-12325.4776119403[/C][/ROW]
[ROW][C]85[/C][C]17215[/C][C]29136.8076923077[/C][C]-11921.8076923077[/C][/ROW]
[ROW][C]86[/C][C]48140[/C][C]29136.8076923077[/C][C]19003.1923076923[/C][/ROW]
[ROW][C]87[/C][C]62897[/C][C]53523.1739130435[/C][C]9373.82608695652[/C][/ROW]
[ROW][C]88[/C][C]22883[/C][C]40588.4776119403[/C][C]-17705.4776119403[/C][/ROW]
[ROW][C]89[/C][C]41622[/C][C]40588.4776119403[/C][C]1033.5223880597[/C][/ROW]
[ROW][C]90[/C][C]40715[/C][C]40588.4776119403[/C][C]126.522388059704[/C][/ROW]
[ROW][C]91[/C][C]65897[/C][C]40588.4776119403[/C][C]25308.5223880597[/C][/ROW]
[ROW][C]92[/C][C]76542[/C][C]53523.1739130435[/C][C]23018.8260869565[/C][/ROW]
[ROW][C]93[/C][C]37477[/C][C]40588.4776119403[/C][C]-3111.4776119403[/C][/ROW]
[ROW][C]94[/C][C]53216[/C][C]29136.8076923077[/C][C]24079.1923076923[/C][/ROW]
[ROW][C]95[/C][C]40911[/C][C]29136.8076923077[/C][C]11774.1923076923[/C][/ROW]
[ROW][C]96[/C][C]57021[/C][C]77129.2222222222[/C][C]-20108.2222222222[/C][/ROW]
[ROW][C]97[/C][C]73116[/C][C]40588.4776119403[/C][C]32527.5223880597[/C][/ROW]
[ROW][C]98[/C][C]3895[/C][C]2808.57894736842[/C][C]1086.42105263158[/C][/ROW]
[ROW][C]99[/C][C]46609[/C][C]53523.1739130435[/C][C]-6914.17391304348[/C][/ROW]
[ROW][C]100[/C][C]29351[/C][C]40588.4776119403[/C][C]-11237.4776119403[/C][/ROW]
[ROW][C]101[/C][C]2325[/C][C]2808.57894736842[/C][C]-483.578947368421[/C][/ROW]
[ROW][C]102[/C][C]31747[/C][C]40588.4776119403[/C][C]-8841.4776119403[/C][/ROW]
[ROW][C]103[/C][C]32665[/C][C]40588.4776119403[/C][C]-7923.4776119403[/C][/ROW]
[ROW][C]104[/C][C]19249[/C][C]29136.8076923077[/C][C]-9887.80769230769[/C][/ROW]
[ROW][C]105[/C][C]15292[/C][C]40588.4776119403[/C][C]-25296.4776119403[/C][/ROW]
[ROW][C]106[/C][C]5842[/C][C]2808.57894736842[/C][C]3033.42105263158[/C][/ROW]
[ROW][C]107[/C][C]33994[/C][C]40588.4776119403[/C][C]-6594.4776119403[/C][/ROW]
[ROW][C]108[/C][C]13018[/C][C]29136.8076923077[/C][C]-16118.8076923077[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]110[/C][C]98177[/C][C]40588.4776119403[/C][C]57588.5223880597[/C][/ROW]
[ROW][C]111[/C][C]37941[/C][C]29136.8076923077[/C][C]8804.1923076923[/C][/ROW]
[ROW][C]112[/C][C]31032[/C][C]40588.4776119403[/C][C]-9556.4776119403[/C][/ROW]
[ROW][C]113[/C][C]32683[/C][C]40588.4776119403[/C][C]-7905.4776119403[/C][/ROW]
[ROW][C]114[/C][C]34545[/C][C]40588.4776119403[/C][C]-6043.4776119403[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]117[/C][C]27525[/C][C]40588.4776119403[/C][C]-13063.4776119403[/C][/ROW]
[ROW][C]118[/C][C]66856[/C][C]40588.4776119403[/C][C]26267.5223880597[/C][/ROW]
[ROW][C]119[/C][C]28549[/C][C]29136.8076923077[/C][C]-587.807692307691[/C][/ROW]
[ROW][C]120[/C][C]38610[/C][C]40588.4776119403[/C][C]-1978.4776119403[/C][/ROW]
[ROW][C]121[/C][C]2781[/C][C]29136.8076923077[/C][C]-26355.8076923077[/C][/ROW]
[ROW][C]122[/C][C]41211[/C][C]40588.4776119403[/C][C]622.522388059704[/C][/ROW]
[ROW][C]123[/C][C]22698[/C][C]29136.8076923077[/C][C]-6438.80769230769[/C][/ROW]
[ROW][C]124[/C][C]41194[/C][C]40588.4776119403[/C][C]605.522388059704[/C][/ROW]
[ROW][C]125[/C][C]32689[/C][C]29136.8076923077[/C][C]3552.19230769231[/C][/ROW]
[ROW][C]126[/C][C]5752[/C][C]2808.57894736842[/C][C]2943.42105263158[/C][/ROW]
[ROW][C]127[/C][C]26757[/C][C]40588.4776119403[/C][C]-13831.4776119403[/C][/ROW]
[ROW][C]128[/C][C]22527[/C][C]29136.8076923077[/C][C]-6609.80769230769[/C][/ROW]
[ROW][C]129[/C][C]44810[/C][C]40588.4776119403[/C][C]4221.5223880597[/C][/ROW]
[ROW][C]130[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]132[/C][C]100674[/C][C]40588.4776119403[/C][C]60085.5223880597[/C][/ROW]
[ROW][C]133[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]134[/C][C]57786[/C][C]40588.4776119403[/C][C]17197.5223880597[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]136[/C][C]5444[/C][C]2808.57894736842[/C][C]2635.42105263158[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]138[/C][C]28470[/C][C]40588.4776119403[/C][C]-12118.4776119403[/C][/ROW]
[ROW][C]139[/C][C]61849[/C][C]29136.8076923077[/C][C]32712.1923076923[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]2808.57894736842[/C][C]-2808.57894736842[/C][/ROW]
[ROW][C]141[/C][C]2179[/C][C]2808.57894736842[/C][C]-629.578947368421[/C][/ROW]
[ROW][C]142[/C][C]8019[/C][C]29136.8076923077[/C][C]-21117.8076923077[/C][/ROW]
[ROW][C]143[/C][C]39644[/C][C]40588.4776119403[/C][C]-944.477611940296[/C][/ROW]
[ROW][C]144[/C][C]23494[/C][C]29136.8076923077[/C][C]-5642.80769230769[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158439&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158439&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
12046540588.4776119403-20123.4776119403
23362940588.4776119403-6959.4776119403
314232808.57894736842-1385.57894736842
42562953523.1739130435-27894.1739130435
55400253523.1739130435478.82608695652
615103677129.222222222273906.7777777778
73328740588.4776119403-7301.4776119403
83117240588.4776119403-9416.4776119403
92811340588.4776119403-12475.4776119403
105780377129.2222222222-19326.2222222222
114983040588.47761194039241.5223880597
125214353523.1739130435-1380.17391304348
132105540588.4776119403-19533.4776119403
144700753523.1739130435-6516.17391304348
152873540588.4776119403-11853.4776119403
165914740588.477611940318558.5223880597
177895040588.477611940338361.5223880597
181349729136.8076923077-15639.8076923077
194615453523.1739130435-7369.17391304348
205324929136.807692307724112.1923076923
211072629136.8076923077-18410.8076923077
228370077129.22222222226570.77777777778
234040040588.4776119403-188.477611940296
243379753523.1739130435-19726.1739130435
253620540588.4776119403-4383.4776119403
263016540588.4776119403-10423.4776119403
275853440588.477611940317945.5223880597
284466340588.47761194034074.5223880597
299255677129.222222222215426.7777777778
304007840588.4776119403-510.477611940296
313471140588.4776119403-5877.4776119403
323107640588.4776119403-9512.4776119403
337460853523.173913043521084.8260869565
345809253523.17391304354568.82608695652
354200953523.1739130435-11514.1739130435
3602808.57894736842-2808.57894736842
373602240588.4776119403-4566.4776119403
382333340588.4776119403-17255.4776119403
395334940588.477611940312760.5223880597
409259677129.222222222215466.7777777778
414959877129.2222222222-27531.2222222222
424409340588.47761194033504.5223880597
438420529136.807692307755068.1923076923
446336953523.17391304359845.82608695652
456013240588.477611940319543.5223880597
463740340588.4776119403-3185.4776119403
472446029136.8076923077-4676.80769230769
484645653523.1739130435-7067.17391304348
496661653523.173913043513092.8260869565
504155453523.1739130435-11969.1739130435
51223462808.5789473684219537.4210526316
523087440588.4776119403-9714.4776119403
536870177129.2222222222-8428.22222222222
543572840588.4776119403-4860.4776119403
552901040588.4776119403-11578.4776119403
562311040588.4776119403-17478.4776119403
573884440588.4776119403-1744.4776119403
582708429136.8076923077-2052.80769230769
593513940588.4776119403-5449.4776119403
605747653523.17391304353952.82608695652
613327740588.4776119403-7311.4776119403
623114140588.4776119403-9447.4776119403
636128140588.477611940320692.5223880597
642582040588.4776119403-14768.4776119403
652328429136.8076923077-5852.80769230769
663537840588.4776119403-5210.4776119403
677499053523.173913043521466.8260869565
682965353523.1739130435-23870.1739130435
696462240588.477611940324033.5223880597
7041572808.578947368421348.42105263158
712924553523.1739130435-24278.1739130435
725000840588.47761194039419.5223880597
735233840588.477611940311749.5223880597
741331040588.4776119403-27278.4776119403
759290153523.173913043539377.8260869565
761095629136.8076923077-18180.8076923077
773424153523.1739130435-19282.1739130435
787504353523.173913043521519.8260869565
792115229136.8076923077-7984.80769230769
804224929136.807692307713112.1923076923
814200540588.47761194031416.5223880597
824115277129.2222222222-35977.2222222222
831439929136.8076923077-14737.8076923077
842826340588.4776119403-12325.4776119403
851721529136.8076923077-11921.8076923077
864814029136.807692307719003.1923076923
876289753523.17391304359373.82608695652
882288340588.4776119403-17705.4776119403
894162240588.47761194031033.5223880597
904071540588.4776119403126.522388059704
916589740588.477611940325308.5223880597
927654253523.173913043523018.8260869565
933747740588.4776119403-3111.4776119403
945321629136.807692307724079.1923076923
954091129136.807692307711774.1923076923
965702177129.2222222222-20108.2222222222
977311640588.477611940332527.5223880597
9838952808.578947368421086.42105263158
994660953523.1739130435-6914.17391304348
1002935140588.4776119403-11237.4776119403
10123252808.57894736842-483.578947368421
1023174740588.4776119403-8841.4776119403
1033266540588.4776119403-7923.4776119403
1041924929136.8076923077-9887.80769230769
1051529240588.4776119403-25296.4776119403
10658422808.578947368423033.42105263158
1073399440588.4776119403-6594.4776119403
1081301829136.8076923077-16118.8076923077
10902808.57894736842-2808.57894736842
1109817740588.477611940357588.5223880597
1113794129136.80769230778804.1923076923
1123103240588.4776119403-9556.4776119403
1133268340588.4776119403-7905.4776119403
1143454540588.4776119403-6043.4776119403
11502808.57894736842-2808.57894736842
11602808.57894736842-2808.57894736842
1172752540588.4776119403-13063.4776119403
1186685640588.477611940326267.5223880597
1192854929136.8076923077-587.807692307691
1203861040588.4776119403-1978.4776119403
121278129136.8076923077-26355.8076923077
1224121140588.4776119403622.522388059704
1232269829136.8076923077-6438.80769230769
1244119440588.4776119403605.522388059704
1253268929136.80769230773552.19230769231
12657522808.578947368422943.42105263158
1272675740588.4776119403-13831.4776119403
1282252729136.8076923077-6609.80769230769
1294481040588.47761194034221.5223880597
13002808.57894736842-2808.57894736842
13102808.57894736842-2808.57894736842
13210067440588.477611940360085.5223880597
13302808.57894736842-2808.57894736842
1345778640588.477611940317197.5223880597
13502808.57894736842-2808.57894736842
13654442808.578947368422635.42105263158
13702808.57894736842-2808.57894736842
1382847040588.4776119403-12118.4776119403
1396184929136.807692307732712.1923076923
14002808.57894736842-2808.57894736842
14121792808.57894736842-629.578947368421
142801929136.8076923077-21117.8076923077
1433964440588.4776119403-944.477611940296
1442349429136.8076923077-5642.80769230769



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