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:05:30 -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/t1324462034ao161i0g6ulr2bc.htm/, Retrieved Wed, 08 May 2024 02:16:21 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158420, Retrieved Wed, 08 May 2024 02:16:21 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact70
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [rfc RT] [2011-12-21 10:05:30] [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=158420&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=158420&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158420&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.8544
R-squared0.73
RMSE453.0978

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8544[/C][/ROW]
[ROW][C]R-squared[/C][C]0.73[/C][/ROW]
[ROW][C]RMSE[/C][C]453.0978[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158420&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158420&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.8544
R-squared0.73
RMSE453.0978







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
117721840.69047619048-68.6904761904761
217031840.69047619048-137.690476190476
3192208.222222222222-16.2222222222222
422941840.69047619048453.309523809524
534482582.15384615385865.846153846154
668133086.857142857143726.14285714286
717951840.69047619048-45.6904761904761
816801840.69047619048-160.690476190476
918961840.6904761904855.3095238095239
1029173086.85714285714-169.857142857143
1119461353.42857142857592.571428571429
1221481840.69047619048307.309523809524
1318321353.42857142857478.571428571429
1430592582.15384615385476.846153846154
1514691840.69047619048-371.690476190476
1615651840.69047619048-275.690476190476
1717551840.69047619048-85.6904761904761
1812341009.73333333333224.266666666667
1927792364.57142857143414.428571428572
20726208.222222222222517.777777777778
211048824.428571428571223.571428571429
2228042582.15384615385221.846153846154
2317601484276
2422612364.57142857143-103.571428571428
2518481840.690476190487.30952380952385
2616471840.69047619048-193.690476190476
2720811840.69047619048240.309523809524
2813921840.69047619048-448.690476190476
2927413086.85714285714-345.857142857143
3021111840.69047619048270.309523809524
3116841840.69047619048-156.690476190476
3216161840.69047619048-224.690476190476
3322271840.69047619048386.309523809524
3430882582.15384615385505.846153846154
3523882582.15384615385-194.153846153846
361208.222222222222-207.222222222222
3720992582.15384615385-483.153846153846
3816691353.42857142857315.571428571429
3920942364.57142857143-270.571428571428
4021533086.85714285714-933.857142857143
4123902582.15384615385-192.153846153846
4217012364.57142857143-663.571428571428
439831009.73333333333-26.7333333333333
4421611840.69047619048320.309523809524
4512761353.42857142857-77.4285714285713
4611891484-295
477441009.73333333333-265.733333333333
4822312582.15384615385-351.153846153846
4922422582.15384615385-340.153846153846
5026381840.69047619048797.309523809524
51658824.428571428571-166.428571428571
5218591840.6904761904818.3095238095239
5324893086.85714285714-597.857142857143
5420252582.15384615385-557.153846153846
5519111840.6904761904870.3095238095239
5617141484230
5718511840.6904761904810.3095238095239
589801009.73333333333-29.7333333333333
5911771840.69047619048-663.690476190476
6028092364.57142857143444.428571428572
6116881840.69047619048-152.690476190476
6220971840.69047619048256.309523809524
6313091353.42857142857-44.4285714285713
6412431353.42857142857-110.428571428571
6512551484-229
6612931353.42857142857-60.4285714285713
6722592364.57142857143-105.571428571428
6828971840.690476190481056.30952380952
6911031353.42857142857-250.428571428571
70340208.222222222222131.777777777778
7127912582.15384615385208.846153846154
7213331484-151
7314411353.4285714285787.5714285714287
7416221353.42857142857268.571428571429
7526492364.57142857143284.428571428572
7614991353.42857142857145.571428571429
7723021840.69047619048461.309523809524
7825401840.69047619048699.309523809524
7910001009.73333333333-9.73333333333335
8012341009.73333333333224.266666666667
819271009.73333333333-82.7333333333333
8221763086.85714285714-910.857142857143
83956824.428571428571131.571428571429
8415311840.69047619048-309.690476190476
8510131009.733333333333.26666666666665
8617711484287
8726132582.1538461538530.8461538461538
8812031353.42857142857-150.428571428571
8913031353.42857142857-50.4285714285713
901524148440
9118291840.69047619048-11.6904761904761
9222271840.69047619048386.309523809524
9312331484-251
9413651484-119
95901824.42857142857176.5714285714286
9623193086.85714285714-767.857142857143
9718561840.6904761904815.3095238095239
98223208.22222222222214.7777777777778
9923902582.15384615385-192.153846153846
10019731484489
101699824.428571428571-125.428571428571
10210621009.7333333333352.2666666666667
10312521353.42857142857-101.428571428571
10411541353.42857142857-199.428571428571
1058231009.73333333333-186.733333333333
106596208.222222222222387.777777777778
10714711840.69047619048-369.690476190476
10811301353.42857142857-223.428571428571
1090208.222222222222-208.222222222222
11010821009.7333333333372.2666666666667
11111341353.42857142857-219.428571428571
11213661840.69047619048-474.690476190476
11314521840.69047619048-388.690476190476
1148691009.73333333333-140.733333333333
11578208.222222222222-130.222222222222
1160208.222222222222-208.222222222222
11711271484-357
11815781840.69047619048-262.690476190476
11919821484498
1209191353.42857142857-434.428571428571
121778824.428571428571-46.4285714285714
12217511840.69047619048-89.6904761904761
1239561009.73333333333-53.7333333333333
12418751353.42857142857521.571428571429
125731824.428571428571-93.4285714285714
126285208.22222222222276.7777777777778
12718331840.69047619048-7.69047619047615
12811471484-337
12916461840.69047619048-194.690476190476
130256208.22222222222247.7777777777778
13198208.222222222222-110.222222222222
13214031484-81
13341208.222222222222-167.222222222222
13417861840.69047619048-54.6904761904761
13542208.222222222222-166.222222222222
136528208.222222222222319.777777777778
1370208.222222222222-208.222222222222
13810721353.42857142857-281.428571428571
13913051009.73333333333295.266666666667
14081208.222222222222-127.222222222222
141261208.22222222222252.7777777777778
1429341009.73333333333-75.7333333333333
14311791840.69047619048-661.690476190476
14411471353.42857142857-206.428571428571

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 1772 & 1840.69047619048 & -68.6904761904761 \tabularnewline
2 & 1703 & 1840.69047619048 & -137.690476190476 \tabularnewline
3 & 192 & 208.222222222222 & -16.2222222222222 \tabularnewline
4 & 2294 & 1840.69047619048 & 453.309523809524 \tabularnewline
5 & 3448 & 2582.15384615385 & 865.846153846154 \tabularnewline
6 & 6813 & 3086.85714285714 & 3726.14285714286 \tabularnewline
7 & 1795 & 1840.69047619048 & -45.6904761904761 \tabularnewline
8 & 1680 & 1840.69047619048 & -160.690476190476 \tabularnewline
9 & 1896 & 1840.69047619048 & 55.3095238095239 \tabularnewline
10 & 2917 & 3086.85714285714 & -169.857142857143 \tabularnewline
11 & 1946 & 1353.42857142857 & 592.571428571429 \tabularnewline
12 & 2148 & 1840.69047619048 & 307.309523809524 \tabularnewline
13 & 1832 & 1353.42857142857 & 478.571428571429 \tabularnewline
14 & 3059 & 2582.15384615385 & 476.846153846154 \tabularnewline
15 & 1469 & 1840.69047619048 & -371.690476190476 \tabularnewline
16 & 1565 & 1840.69047619048 & -275.690476190476 \tabularnewline
17 & 1755 & 1840.69047619048 & -85.6904761904761 \tabularnewline
18 & 1234 & 1009.73333333333 & 224.266666666667 \tabularnewline
19 & 2779 & 2364.57142857143 & 414.428571428572 \tabularnewline
20 & 726 & 208.222222222222 & 517.777777777778 \tabularnewline
21 & 1048 & 824.428571428571 & 223.571428571429 \tabularnewline
22 & 2804 & 2582.15384615385 & 221.846153846154 \tabularnewline
23 & 1760 & 1484 & 276 \tabularnewline
24 & 2261 & 2364.57142857143 & -103.571428571428 \tabularnewline
25 & 1848 & 1840.69047619048 & 7.30952380952385 \tabularnewline
26 & 1647 & 1840.69047619048 & -193.690476190476 \tabularnewline
27 & 2081 & 1840.69047619048 & 240.309523809524 \tabularnewline
28 & 1392 & 1840.69047619048 & -448.690476190476 \tabularnewline
29 & 2741 & 3086.85714285714 & -345.857142857143 \tabularnewline
30 & 2111 & 1840.69047619048 & 270.309523809524 \tabularnewline
31 & 1684 & 1840.69047619048 & -156.690476190476 \tabularnewline
32 & 1616 & 1840.69047619048 & -224.690476190476 \tabularnewline
33 & 2227 & 1840.69047619048 & 386.309523809524 \tabularnewline
34 & 3088 & 2582.15384615385 & 505.846153846154 \tabularnewline
35 & 2388 & 2582.15384615385 & -194.153846153846 \tabularnewline
36 & 1 & 208.222222222222 & -207.222222222222 \tabularnewline
37 & 2099 & 2582.15384615385 & -483.153846153846 \tabularnewline
38 & 1669 & 1353.42857142857 & 315.571428571429 \tabularnewline
39 & 2094 & 2364.57142857143 & -270.571428571428 \tabularnewline
40 & 2153 & 3086.85714285714 & -933.857142857143 \tabularnewline
41 & 2390 & 2582.15384615385 & -192.153846153846 \tabularnewline
42 & 1701 & 2364.57142857143 & -663.571428571428 \tabularnewline
43 & 983 & 1009.73333333333 & -26.7333333333333 \tabularnewline
44 & 2161 & 1840.69047619048 & 320.309523809524 \tabularnewline
45 & 1276 & 1353.42857142857 & -77.4285714285713 \tabularnewline
46 & 1189 & 1484 & -295 \tabularnewline
47 & 744 & 1009.73333333333 & -265.733333333333 \tabularnewline
48 & 2231 & 2582.15384615385 & -351.153846153846 \tabularnewline
49 & 2242 & 2582.15384615385 & -340.153846153846 \tabularnewline
50 & 2638 & 1840.69047619048 & 797.309523809524 \tabularnewline
51 & 658 & 824.428571428571 & -166.428571428571 \tabularnewline
52 & 1859 & 1840.69047619048 & 18.3095238095239 \tabularnewline
53 & 2489 & 3086.85714285714 & -597.857142857143 \tabularnewline
54 & 2025 & 2582.15384615385 & -557.153846153846 \tabularnewline
55 & 1911 & 1840.69047619048 & 70.3095238095239 \tabularnewline
56 & 1714 & 1484 & 230 \tabularnewline
57 & 1851 & 1840.69047619048 & 10.3095238095239 \tabularnewline
58 & 980 & 1009.73333333333 & -29.7333333333333 \tabularnewline
59 & 1177 & 1840.69047619048 & -663.690476190476 \tabularnewline
60 & 2809 & 2364.57142857143 & 444.428571428572 \tabularnewline
61 & 1688 & 1840.69047619048 & -152.690476190476 \tabularnewline
62 & 2097 & 1840.69047619048 & 256.309523809524 \tabularnewline
63 & 1309 & 1353.42857142857 & -44.4285714285713 \tabularnewline
64 & 1243 & 1353.42857142857 & -110.428571428571 \tabularnewline
65 & 1255 & 1484 & -229 \tabularnewline
66 & 1293 & 1353.42857142857 & -60.4285714285713 \tabularnewline
67 & 2259 & 2364.57142857143 & -105.571428571428 \tabularnewline
68 & 2897 & 1840.69047619048 & 1056.30952380952 \tabularnewline
69 & 1103 & 1353.42857142857 & -250.428571428571 \tabularnewline
70 & 340 & 208.222222222222 & 131.777777777778 \tabularnewline
71 & 2791 & 2582.15384615385 & 208.846153846154 \tabularnewline
72 & 1333 & 1484 & -151 \tabularnewline
73 & 1441 & 1353.42857142857 & 87.5714285714287 \tabularnewline
74 & 1622 & 1353.42857142857 & 268.571428571429 \tabularnewline
75 & 2649 & 2364.57142857143 & 284.428571428572 \tabularnewline
76 & 1499 & 1353.42857142857 & 145.571428571429 \tabularnewline
77 & 2302 & 1840.69047619048 & 461.309523809524 \tabularnewline
78 & 2540 & 1840.69047619048 & 699.309523809524 \tabularnewline
79 & 1000 & 1009.73333333333 & -9.73333333333335 \tabularnewline
80 & 1234 & 1009.73333333333 & 224.266666666667 \tabularnewline
81 & 927 & 1009.73333333333 & -82.7333333333333 \tabularnewline
82 & 2176 & 3086.85714285714 & -910.857142857143 \tabularnewline
83 & 956 & 824.428571428571 & 131.571428571429 \tabularnewline
84 & 1531 & 1840.69047619048 & -309.690476190476 \tabularnewline
85 & 1013 & 1009.73333333333 & 3.26666666666665 \tabularnewline
86 & 1771 & 1484 & 287 \tabularnewline
87 & 2613 & 2582.15384615385 & 30.8461538461538 \tabularnewline
88 & 1203 & 1353.42857142857 & -150.428571428571 \tabularnewline
89 & 1303 & 1353.42857142857 & -50.4285714285713 \tabularnewline
90 & 1524 & 1484 & 40 \tabularnewline
91 & 1829 & 1840.69047619048 & -11.6904761904761 \tabularnewline
92 & 2227 & 1840.69047619048 & 386.309523809524 \tabularnewline
93 & 1233 & 1484 & -251 \tabularnewline
94 & 1365 & 1484 & -119 \tabularnewline
95 & 901 & 824.428571428571 & 76.5714285714286 \tabularnewline
96 & 2319 & 3086.85714285714 & -767.857142857143 \tabularnewline
97 & 1856 & 1840.69047619048 & 15.3095238095239 \tabularnewline
98 & 223 & 208.222222222222 & 14.7777777777778 \tabularnewline
99 & 2390 & 2582.15384615385 & -192.153846153846 \tabularnewline
100 & 1973 & 1484 & 489 \tabularnewline
101 & 699 & 824.428571428571 & -125.428571428571 \tabularnewline
102 & 1062 & 1009.73333333333 & 52.2666666666667 \tabularnewline
103 & 1252 & 1353.42857142857 & -101.428571428571 \tabularnewline
104 & 1154 & 1353.42857142857 & -199.428571428571 \tabularnewline
105 & 823 & 1009.73333333333 & -186.733333333333 \tabularnewline
106 & 596 & 208.222222222222 & 387.777777777778 \tabularnewline
107 & 1471 & 1840.69047619048 & -369.690476190476 \tabularnewline
108 & 1130 & 1353.42857142857 & -223.428571428571 \tabularnewline
109 & 0 & 208.222222222222 & -208.222222222222 \tabularnewline
110 & 1082 & 1009.73333333333 & 72.2666666666667 \tabularnewline
111 & 1134 & 1353.42857142857 & -219.428571428571 \tabularnewline
112 & 1366 & 1840.69047619048 & -474.690476190476 \tabularnewline
113 & 1452 & 1840.69047619048 & -388.690476190476 \tabularnewline
114 & 869 & 1009.73333333333 & -140.733333333333 \tabularnewline
115 & 78 & 208.222222222222 & -130.222222222222 \tabularnewline
116 & 0 & 208.222222222222 & -208.222222222222 \tabularnewline
117 & 1127 & 1484 & -357 \tabularnewline
118 & 1578 & 1840.69047619048 & -262.690476190476 \tabularnewline
119 & 1982 & 1484 & 498 \tabularnewline
120 & 919 & 1353.42857142857 & -434.428571428571 \tabularnewline
121 & 778 & 824.428571428571 & -46.4285714285714 \tabularnewline
122 & 1751 & 1840.69047619048 & -89.6904761904761 \tabularnewline
123 & 956 & 1009.73333333333 & -53.7333333333333 \tabularnewline
124 & 1875 & 1353.42857142857 & 521.571428571429 \tabularnewline
125 & 731 & 824.428571428571 & -93.4285714285714 \tabularnewline
126 & 285 & 208.222222222222 & 76.7777777777778 \tabularnewline
127 & 1833 & 1840.69047619048 & -7.69047619047615 \tabularnewline
128 & 1147 & 1484 & -337 \tabularnewline
129 & 1646 & 1840.69047619048 & -194.690476190476 \tabularnewline
130 & 256 & 208.222222222222 & 47.7777777777778 \tabularnewline
131 & 98 & 208.222222222222 & -110.222222222222 \tabularnewline
132 & 1403 & 1484 & -81 \tabularnewline
133 & 41 & 208.222222222222 & -167.222222222222 \tabularnewline
134 & 1786 & 1840.69047619048 & -54.6904761904761 \tabularnewline
135 & 42 & 208.222222222222 & -166.222222222222 \tabularnewline
136 & 528 & 208.222222222222 & 319.777777777778 \tabularnewline
137 & 0 & 208.222222222222 & -208.222222222222 \tabularnewline
138 & 1072 & 1353.42857142857 & -281.428571428571 \tabularnewline
139 & 1305 & 1009.73333333333 & 295.266666666667 \tabularnewline
140 & 81 & 208.222222222222 & -127.222222222222 \tabularnewline
141 & 261 & 208.222222222222 & 52.7777777777778 \tabularnewline
142 & 934 & 1009.73333333333 & -75.7333333333333 \tabularnewline
143 & 1179 & 1840.69047619048 & -661.690476190476 \tabularnewline
144 & 1147 & 1353.42857142857 & -206.428571428571 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158420&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]1772[/C][C]1840.69047619048[/C][C]-68.6904761904761[/C][/ROW]
[ROW][C]2[/C][C]1703[/C][C]1840.69047619048[/C][C]-137.690476190476[/C][/ROW]
[ROW][C]3[/C][C]192[/C][C]208.222222222222[/C][C]-16.2222222222222[/C][/ROW]
[ROW][C]4[/C][C]2294[/C][C]1840.69047619048[/C][C]453.309523809524[/C][/ROW]
[ROW][C]5[/C][C]3448[/C][C]2582.15384615385[/C][C]865.846153846154[/C][/ROW]
[ROW][C]6[/C][C]6813[/C][C]3086.85714285714[/C][C]3726.14285714286[/C][/ROW]
[ROW][C]7[/C][C]1795[/C][C]1840.69047619048[/C][C]-45.6904761904761[/C][/ROW]
[ROW][C]8[/C][C]1680[/C][C]1840.69047619048[/C][C]-160.690476190476[/C][/ROW]
[ROW][C]9[/C][C]1896[/C][C]1840.69047619048[/C][C]55.3095238095239[/C][/ROW]
[ROW][C]10[/C][C]2917[/C][C]3086.85714285714[/C][C]-169.857142857143[/C][/ROW]
[ROW][C]11[/C][C]1946[/C][C]1353.42857142857[/C][C]592.571428571429[/C][/ROW]
[ROW][C]12[/C][C]2148[/C][C]1840.69047619048[/C][C]307.309523809524[/C][/ROW]
[ROW][C]13[/C][C]1832[/C][C]1353.42857142857[/C][C]478.571428571429[/C][/ROW]
[ROW][C]14[/C][C]3059[/C][C]2582.15384615385[/C][C]476.846153846154[/C][/ROW]
[ROW][C]15[/C][C]1469[/C][C]1840.69047619048[/C][C]-371.690476190476[/C][/ROW]
[ROW][C]16[/C][C]1565[/C][C]1840.69047619048[/C][C]-275.690476190476[/C][/ROW]
[ROW][C]17[/C][C]1755[/C][C]1840.69047619048[/C][C]-85.6904761904761[/C][/ROW]
[ROW][C]18[/C][C]1234[/C][C]1009.73333333333[/C][C]224.266666666667[/C][/ROW]
[ROW][C]19[/C][C]2779[/C][C]2364.57142857143[/C][C]414.428571428572[/C][/ROW]
[ROW][C]20[/C][C]726[/C][C]208.222222222222[/C][C]517.777777777778[/C][/ROW]
[ROW][C]21[/C][C]1048[/C][C]824.428571428571[/C][C]223.571428571429[/C][/ROW]
[ROW][C]22[/C][C]2804[/C][C]2582.15384615385[/C][C]221.846153846154[/C][/ROW]
[ROW][C]23[/C][C]1760[/C][C]1484[/C][C]276[/C][/ROW]
[ROW][C]24[/C][C]2261[/C][C]2364.57142857143[/C][C]-103.571428571428[/C][/ROW]
[ROW][C]25[/C][C]1848[/C][C]1840.69047619048[/C][C]7.30952380952385[/C][/ROW]
[ROW][C]26[/C][C]1647[/C][C]1840.69047619048[/C][C]-193.690476190476[/C][/ROW]
[ROW][C]27[/C][C]2081[/C][C]1840.69047619048[/C][C]240.309523809524[/C][/ROW]
[ROW][C]28[/C][C]1392[/C][C]1840.69047619048[/C][C]-448.690476190476[/C][/ROW]
[ROW][C]29[/C][C]2741[/C][C]3086.85714285714[/C][C]-345.857142857143[/C][/ROW]
[ROW][C]30[/C][C]2111[/C][C]1840.69047619048[/C][C]270.309523809524[/C][/ROW]
[ROW][C]31[/C][C]1684[/C][C]1840.69047619048[/C][C]-156.690476190476[/C][/ROW]
[ROW][C]32[/C][C]1616[/C][C]1840.69047619048[/C][C]-224.690476190476[/C][/ROW]
[ROW][C]33[/C][C]2227[/C][C]1840.69047619048[/C][C]386.309523809524[/C][/ROW]
[ROW][C]34[/C][C]3088[/C][C]2582.15384615385[/C][C]505.846153846154[/C][/ROW]
[ROW][C]35[/C][C]2388[/C][C]2582.15384615385[/C][C]-194.153846153846[/C][/ROW]
[ROW][C]36[/C][C]1[/C][C]208.222222222222[/C][C]-207.222222222222[/C][/ROW]
[ROW][C]37[/C][C]2099[/C][C]2582.15384615385[/C][C]-483.153846153846[/C][/ROW]
[ROW][C]38[/C][C]1669[/C][C]1353.42857142857[/C][C]315.571428571429[/C][/ROW]
[ROW][C]39[/C][C]2094[/C][C]2364.57142857143[/C][C]-270.571428571428[/C][/ROW]
[ROW][C]40[/C][C]2153[/C][C]3086.85714285714[/C][C]-933.857142857143[/C][/ROW]
[ROW][C]41[/C][C]2390[/C][C]2582.15384615385[/C][C]-192.153846153846[/C][/ROW]
[ROW][C]42[/C][C]1701[/C][C]2364.57142857143[/C][C]-663.571428571428[/C][/ROW]
[ROW][C]43[/C][C]983[/C][C]1009.73333333333[/C][C]-26.7333333333333[/C][/ROW]
[ROW][C]44[/C][C]2161[/C][C]1840.69047619048[/C][C]320.309523809524[/C][/ROW]
[ROW][C]45[/C][C]1276[/C][C]1353.42857142857[/C][C]-77.4285714285713[/C][/ROW]
[ROW][C]46[/C][C]1189[/C][C]1484[/C][C]-295[/C][/ROW]
[ROW][C]47[/C][C]744[/C][C]1009.73333333333[/C][C]-265.733333333333[/C][/ROW]
[ROW][C]48[/C][C]2231[/C][C]2582.15384615385[/C][C]-351.153846153846[/C][/ROW]
[ROW][C]49[/C][C]2242[/C][C]2582.15384615385[/C][C]-340.153846153846[/C][/ROW]
[ROW][C]50[/C][C]2638[/C][C]1840.69047619048[/C][C]797.309523809524[/C][/ROW]
[ROW][C]51[/C][C]658[/C][C]824.428571428571[/C][C]-166.428571428571[/C][/ROW]
[ROW][C]52[/C][C]1859[/C][C]1840.69047619048[/C][C]18.3095238095239[/C][/ROW]
[ROW][C]53[/C][C]2489[/C][C]3086.85714285714[/C][C]-597.857142857143[/C][/ROW]
[ROW][C]54[/C][C]2025[/C][C]2582.15384615385[/C][C]-557.153846153846[/C][/ROW]
[ROW][C]55[/C][C]1911[/C][C]1840.69047619048[/C][C]70.3095238095239[/C][/ROW]
[ROW][C]56[/C][C]1714[/C][C]1484[/C][C]230[/C][/ROW]
[ROW][C]57[/C][C]1851[/C][C]1840.69047619048[/C][C]10.3095238095239[/C][/ROW]
[ROW][C]58[/C][C]980[/C][C]1009.73333333333[/C][C]-29.7333333333333[/C][/ROW]
[ROW][C]59[/C][C]1177[/C][C]1840.69047619048[/C][C]-663.690476190476[/C][/ROW]
[ROW][C]60[/C][C]2809[/C][C]2364.57142857143[/C][C]444.428571428572[/C][/ROW]
[ROW][C]61[/C][C]1688[/C][C]1840.69047619048[/C][C]-152.690476190476[/C][/ROW]
[ROW][C]62[/C][C]2097[/C][C]1840.69047619048[/C][C]256.309523809524[/C][/ROW]
[ROW][C]63[/C][C]1309[/C][C]1353.42857142857[/C][C]-44.4285714285713[/C][/ROW]
[ROW][C]64[/C][C]1243[/C][C]1353.42857142857[/C][C]-110.428571428571[/C][/ROW]
[ROW][C]65[/C][C]1255[/C][C]1484[/C][C]-229[/C][/ROW]
[ROW][C]66[/C][C]1293[/C][C]1353.42857142857[/C][C]-60.4285714285713[/C][/ROW]
[ROW][C]67[/C][C]2259[/C][C]2364.57142857143[/C][C]-105.571428571428[/C][/ROW]
[ROW][C]68[/C][C]2897[/C][C]1840.69047619048[/C][C]1056.30952380952[/C][/ROW]
[ROW][C]69[/C][C]1103[/C][C]1353.42857142857[/C][C]-250.428571428571[/C][/ROW]
[ROW][C]70[/C][C]340[/C][C]208.222222222222[/C][C]131.777777777778[/C][/ROW]
[ROW][C]71[/C][C]2791[/C][C]2582.15384615385[/C][C]208.846153846154[/C][/ROW]
[ROW][C]72[/C][C]1333[/C][C]1484[/C][C]-151[/C][/ROW]
[ROW][C]73[/C][C]1441[/C][C]1353.42857142857[/C][C]87.5714285714287[/C][/ROW]
[ROW][C]74[/C][C]1622[/C][C]1353.42857142857[/C][C]268.571428571429[/C][/ROW]
[ROW][C]75[/C][C]2649[/C][C]2364.57142857143[/C][C]284.428571428572[/C][/ROW]
[ROW][C]76[/C][C]1499[/C][C]1353.42857142857[/C][C]145.571428571429[/C][/ROW]
[ROW][C]77[/C][C]2302[/C][C]1840.69047619048[/C][C]461.309523809524[/C][/ROW]
[ROW][C]78[/C][C]2540[/C][C]1840.69047619048[/C][C]699.309523809524[/C][/ROW]
[ROW][C]79[/C][C]1000[/C][C]1009.73333333333[/C][C]-9.73333333333335[/C][/ROW]
[ROW][C]80[/C][C]1234[/C][C]1009.73333333333[/C][C]224.266666666667[/C][/ROW]
[ROW][C]81[/C][C]927[/C][C]1009.73333333333[/C][C]-82.7333333333333[/C][/ROW]
[ROW][C]82[/C][C]2176[/C][C]3086.85714285714[/C][C]-910.857142857143[/C][/ROW]
[ROW][C]83[/C][C]956[/C][C]824.428571428571[/C][C]131.571428571429[/C][/ROW]
[ROW][C]84[/C][C]1531[/C][C]1840.69047619048[/C][C]-309.690476190476[/C][/ROW]
[ROW][C]85[/C][C]1013[/C][C]1009.73333333333[/C][C]3.26666666666665[/C][/ROW]
[ROW][C]86[/C][C]1771[/C][C]1484[/C][C]287[/C][/ROW]
[ROW][C]87[/C][C]2613[/C][C]2582.15384615385[/C][C]30.8461538461538[/C][/ROW]
[ROW][C]88[/C][C]1203[/C][C]1353.42857142857[/C][C]-150.428571428571[/C][/ROW]
[ROW][C]89[/C][C]1303[/C][C]1353.42857142857[/C][C]-50.4285714285713[/C][/ROW]
[ROW][C]90[/C][C]1524[/C][C]1484[/C][C]40[/C][/ROW]
[ROW][C]91[/C][C]1829[/C][C]1840.69047619048[/C][C]-11.6904761904761[/C][/ROW]
[ROW][C]92[/C][C]2227[/C][C]1840.69047619048[/C][C]386.309523809524[/C][/ROW]
[ROW][C]93[/C][C]1233[/C][C]1484[/C][C]-251[/C][/ROW]
[ROW][C]94[/C][C]1365[/C][C]1484[/C][C]-119[/C][/ROW]
[ROW][C]95[/C][C]901[/C][C]824.428571428571[/C][C]76.5714285714286[/C][/ROW]
[ROW][C]96[/C][C]2319[/C][C]3086.85714285714[/C][C]-767.857142857143[/C][/ROW]
[ROW][C]97[/C][C]1856[/C][C]1840.69047619048[/C][C]15.3095238095239[/C][/ROW]
[ROW][C]98[/C][C]223[/C][C]208.222222222222[/C][C]14.7777777777778[/C][/ROW]
[ROW][C]99[/C][C]2390[/C][C]2582.15384615385[/C][C]-192.153846153846[/C][/ROW]
[ROW][C]100[/C][C]1973[/C][C]1484[/C][C]489[/C][/ROW]
[ROW][C]101[/C][C]699[/C][C]824.428571428571[/C][C]-125.428571428571[/C][/ROW]
[ROW][C]102[/C][C]1062[/C][C]1009.73333333333[/C][C]52.2666666666667[/C][/ROW]
[ROW][C]103[/C][C]1252[/C][C]1353.42857142857[/C][C]-101.428571428571[/C][/ROW]
[ROW][C]104[/C][C]1154[/C][C]1353.42857142857[/C][C]-199.428571428571[/C][/ROW]
[ROW][C]105[/C][C]823[/C][C]1009.73333333333[/C][C]-186.733333333333[/C][/ROW]
[ROW][C]106[/C][C]596[/C][C]208.222222222222[/C][C]387.777777777778[/C][/ROW]
[ROW][C]107[/C][C]1471[/C][C]1840.69047619048[/C][C]-369.690476190476[/C][/ROW]
[ROW][C]108[/C][C]1130[/C][C]1353.42857142857[/C][C]-223.428571428571[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]208.222222222222[/C][C]-208.222222222222[/C][/ROW]
[ROW][C]110[/C][C]1082[/C][C]1009.73333333333[/C][C]72.2666666666667[/C][/ROW]
[ROW][C]111[/C][C]1134[/C][C]1353.42857142857[/C][C]-219.428571428571[/C][/ROW]
[ROW][C]112[/C][C]1366[/C][C]1840.69047619048[/C][C]-474.690476190476[/C][/ROW]
[ROW][C]113[/C][C]1452[/C][C]1840.69047619048[/C][C]-388.690476190476[/C][/ROW]
[ROW][C]114[/C][C]869[/C][C]1009.73333333333[/C][C]-140.733333333333[/C][/ROW]
[ROW][C]115[/C][C]78[/C][C]208.222222222222[/C][C]-130.222222222222[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]208.222222222222[/C][C]-208.222222222222[/C][/ROW]
[ROW][C]117[/C][C]1127[/C][C]1484[/C][C]-357[/C][/ROW]
[ROW][C]118[/C][C]1578[/C][C]1840.69047619048[/C][C]-262.690476190476[/C][/ROW]
[ROW][C]119[/C][C]1982[/C][C]1484[/C][C]498[/C][/ROW]
[ROW][C]120[/C][C]919[/C][C]1353.42857142857[/C][C]-434.428571428571[/C][/ROW]
[ROW][C]121[/C][C]778[/C][C]824.428571428571[/C][C]-46.4285714285714[/C][/ROW]
[ROW][C]122[/C][C]1751[/C][C]1840.69047619048[/C][C]-89.6904761904761[/C][/ROW]
[ROW][C]123[/C][C]956[/C][C]1009.73333333333[/C][C]-53.7333333333333[/C][/ROW]
[ROW][C]124[/C][C]1875[/C][C]1353.42857142857[/C][C]521.571428571429[/C][/ROW]
[ROW][C]125[/C][C]731[/C][C]824.428571428571[/C][C]-93.4285714285714[/C][/ROW]
[ROW][C]126[/C][C]285[/C][C]208.222222222222[/C][C]76.7777777777778[/C][/ROW]
[ROW][C]127[/C][C]1833[/C][C]1840.69047619048[/C][C]-7.69047619047615[/C][/ROW]
[ROW][C]128[/C][C]1147[/C][C]1484[/C][C]-337[/C][/ROW]
[ROW][C]129[/C][C]1646[/C][C]1840.69047619048[/C][C]-194.690476190476[/C][/ROW]
[ROW][C]130[/C][C]256[/C][C]208.222222222222[/C][C]47.7777777777778[/C][/ROW]
[ROW][C]131[/C][C]98[/C][C]208.222222222222[/C][C]-110.222222222222[/C][/ROW]
[ROW][C]132[/C][C]1403[/C][C]1484[/C][C]-81[/C][/ROW]
[ROW][C]133[/C][C]41[/C][C]208.222222222222[/C][C]-167.222222222222[/C][/ROW]
[ROW][C]134[/C][C]1786[/C][C]1840.69047619048[/C][C]-54.6904761904761[/C][/ROW]
[ROW][C]135[/C][C]42[/C][C]208.222222222222[/C][C]-166.222222222222[/C][/ROW]
[ROW][C]136[/C][C]528[/C][C]208.222222222222[/C][C]319.777777777778[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]208.222222222222[/C][C]-208.222222222222[/C][/ROW]
[ROW][C]138[/C][C]1072[/C][C]1353.42857142857[/C][C]-281.428571428571[/C][/ROW]
[ROW][C]139[/C][C]1305[/C][C]1009.73333333333[/C][C]295.266666666667[/C][/ROW]
[ROW][C]140[/C][C]81[/C][C]208.222222222222[/C][C]-127.222222222222[/C][/ROW]
[ROW][C]141[/C][C]261[/C][C]208.222222222222[/C][C]52.7777777777778[/C][/ROW]
[ROW][C]142[/C][C]934[/C][C]1009.73333333333[/C][C]-75.7333333333333[/C][/ROW]
[ROW][C]143[/C][C]1179[/C][C]1840.69047619048[/C][C]-661.690476190476[/C][/ROW]
[ROW][C]144[/C][C]1147[/C][C]1353.42857142857[/C][C]-206.428571428571[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158420&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158420&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
117721840.69047619048-68.6904761904761
217031840.69047619048-137.690476190476
3192208.222222222222-16.2222222222222
422941840.69047619048453.309523809524
534482582.15384615385865.846153846154
668133086.857142857143726.14285714286
717951840.69047619048-45.6904761904761
816801840.69047619048-160.690476190476
918961840.6904761904855.3095238095239
1029173086.85714285714-169.857142857143
1119461353.42857142857592.571428571429
1221481840.69047619048307.309523809524
1318321353.42857142857478.571428571429
1430592582.15384615385476.846153846154
1514691840.69047619048-371.690476190476
1615651840.69047619048-275.690476190476
1717551840.69047619048-85.6904761904761
1812341009.73333333333224.266666666667
1927792364.57142857143414.428571428572
20726208.222222222222517.777777777778
211048824.428571428571223.571428571429
2228042582.15384615385221.846153846154
2317601484276
2422612364.57142857143-103.571428571428
2518481840.690476190487.30952380952385
2616471840.69047619048-193.690476190476
2720811840.69047619048240.309523809524
2813921840.69047619048-448.690476190476
2927413086.85714285714-345.857142857143
3021111840.69047619048270.309523809524
3116841840.69047619048-156.690476190476
3216161840.69047619048-224.690476190476
3322271840.69047619048386.309523809524
3430882582.15384615385505.846153846154
3523882582.15384615385-194.153846153846
361208.222222222222-207.222222222222
3720992582.15384615385-483.153846153846
3816691353.42857142857315.571428571429
3920942364.57142857143-270.571428571428
4021533086.85714285714-933.857142857143
4123902582.15384615385-192.153846153846
4217012364.57142857143-663.571428571428
439831009.73333333333-26.7333333333333
4421611840.69047619048320.309523809524
4512761353.42857142857-77.4285714285713
4611891484-295
477441009.73333333333-265.733333333333
4822312582.15384615385-351.153846153846
4922422582.15384615385-340.153846153846
5026381840.69047619048797.309523809524
51658824.428571428571-166.428571428571
5218591840.6904761904818.3095238095239
5324893086.85714285714-597.857142857143
5420252582.15384615385-557.153846153846
5519111840.6904761904870.3095238095239
5617141484230
5718511840.6904761904810.3095238095239
589801009.73333333333-29.7333333333333
5911771840.69047619048-663.690476190476
6028092364.57142857143444.428571428572
6116881840.69047619048-152.690476190476
6220971840.69047619048256.309523809524
6313091353.42857142857-44.4285714285713
6412431353.42857142857-110.428571428571
6512551484-229
6612931353.42857142857-60.4285714285713
6722592364.57142857143-105.571428571428
6828971840.690476190481056.30952380952
6911031353.42857142857-250.428571428571
70340208.222222222222131.777777777778
7127912582.15384615385208.846153846154
7213331484-151
7314411353.4285714285787.5714285714287
7416221353.42857142857268.571428571429
7526492364.57142857143284.428571428572
7614991353.42857142857145.571428571429
7723021840.69047619048461.309523809524
7825401840.69047619048699.309523809524
7910001009.73333333333-9.73333333333335
8012341009.73333333333224.266666666667
819271009.73333333333-82.7333333333333
8221763086.85714285714-910.857142857143
83956824.428571428571131.571428571429
8415311840.69047619048-309.690476190476
8510131009.733333333333.26666666666665
8617711484287
8726132582.1538461538530.8461538461538
8812031353.42857142857-150.428571428571
8913031353.42857142857-50.4285714285713
901524148440
9118291840.69047619048-11.6904761904761
9222271840.69047619048386.309523809524
9312331484-251
9413651484-119
95901824.42857142857176.5714285714286
9623193086.85714285714-767.857142857143
9718561840.6904761904815.3095238095239
98223208.22222222222214.7777777777778
9923902582.15384615385-192.153846153846
10019731484489
101699824.428571428571-125.428571428571
10210621009.7333333333352.2666666666667
10312521353.42857142857-101.428571428571
10411541353.42857142857-199.428571428571
1058231009.73333333333-186.733333333333
106596208.222222222222387.777777777778
10714711840.69047619048-369.690476190476
10811301353.42857142857-223.428571428571
1090208.222222222222-208.222222222222
11010821009.7333333333372.2666666666667
11111341353.42857142857-219.428571428571
11213661840.69047619048-474.690476190476
11314521840.69047619048-388.690476190476
1148691009.73333333333-140.733333333333
11578208.222222222222-130.222222222222
1160208.222222222222-208.222222222222
11711271484-357
11815781840.69047619048-262.690476190476
11919821484498
1209191353.42857142857-434.428571428571
121778824.428571428571-46.4285714285714
12217511840.69047619048-89.6904761904761
1239561009.73333333333-53.7333333333333
12418751353.42857142857521.571428571429
125731824.428571428571-93.4285714285714
126285208.22222222222276.7777777777778
12718331840.69047619048-7.69047619047615
12811471484-337
12916461840.69047619048-194.690476190476
130256208.22222222222247.7777777777778
13198208.222222222222-110.222222222222
13214031484-81
13341208.222222222222-167.222222222222
13417861840.69047619048-54.6904761904761
13542208.222222222222-166.222222222222
136528208.222222222222319.777777777778
1370208.222222222222-208.222222222222
13810721353.42857142857-281.428571428571
13913051009.73333333333295.266666666667
14081208.222222222222-127.222222222222
141261208.22222222222252.7777777777778
1429341009.73333333333-75.7333333333333
14311791840.69047619048-661.690476190476
14411471353.42857142857-206.428571428571



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