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 computationThu, 15 Dec 2011 10:59:08 -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/15/t1323964771xm1x6335doj3yb0.htm/, Retrieved Wed, 08 May 2024 21:46:29 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=155528, Retrieved Wed, 08 May 2024 21:46:29 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact89
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Kendall tau Correlation Matrix] [] [2010-12-05 17:44:33] [b98453cac15ba1066b407e146608df68]
- RMPD  [Kendall tau Correlation Matrix] [Pearson Correlati...] [2011-12-13 17:28:26] [570fce4db58fd7864ac807c4286d6e49]
- RMPD      [Recursive Partitioning (Regression Trees)] [] [2011-12-15 15:59:08] [c7041fab4904771a5085f5eb0f28763f] [Current]
Feedback Forum

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




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

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







Goodness of Fit
Correlation0.8657
R-squared0.7494
RMSE30490.9993

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8657[/C][/ROW]
[ROW][C]R-squared[/C][C]0.7494[/C][/ROW]
[ROW][C]RMSE[/C][C]30490.9993[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155528&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155528&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.8657
R-squared0.7494
RMSE30490.9993







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1129988145042.790697674-15054.7906976744
2130358107454.57446808522903.4255319149
372156617.57142857143597.428571428572
4112976145042.790697674-32066.7906976744
5219904229232.5-9328.5
6402036229232.5172803.5
7117604107454.57446808510149.4255319149
8131822107454.57446808524367.4255319149
999729107454.574468085-7725.5744680851
10256310229232.527077.5
11113066145042.790697674-31976.7906976744
12165392145042.79069767420349.2093023256
1378240107454.574468085-29214.5744680851
14152673229232.5-76559.5
15134368107454.57446808526913.4255319149
16125769107454.57446808518314.4255319149
17123467145042.790697674-21575.7906976744
185623279980.5714285714-23748.5714285714
19108458145042.790697674-36584.7906976744
202276242283.7777777778-19521.7777777778
214863359959.6875-11326.6875
22182081145042.79069767437038.2093023256
23140857145042.790697674-4185.79069767441
2493773145042.790697674-51269.7906976744
25133428145042.790697674-11614.7906976744
26113933107454.5744680856478.4255319149
27153851145042.7906976748808.20930232559
28140711107454.57446808533256.4255319149
29303844229232.574611.5
30163810145042.79069767418767.2093023256
31123344107454.57446808515889.4255319149
32157640107454.57446808550185.4255319149
33103274145042.790697674-41768.7906976744
34193500229232.5-35732.5
35178768145042.79069767433725.2093023256
3606617.57142857143-6617.57142857143
37181412145042.79069767436369.2093023256
3892342145042.790697674-52700.7906976744
39100023145042.790697674-45019.7906976744
40178277145042.79069767433234.2093023256
41145067145042.79069767424.2093023255875
42114146107454.5744680856691.4255319149
438603979980.57142857146058.42857142857
44125481145042.790697674-19561.7906976744
4595535107454.574468085-11919.5744680851
46129221107454.57446808521766.4255319149
476155459959.68751594.3125
48168048145042.79069767423005.2093023256
49159121145042.79069767414078.2093023256
50129362145042.790697674-15680.7906976744
514818859959.6875-11771.6875
5295461107454.574468085-11993.5744680851
53229864145042.79069767484821.2093023256
54191094145042.79069767446051.2093023256
55161082145042.79069767416039.2093023256
56111388107454.5744680853933.42553191489
57172614145042.79069767427571.2093023256
586320559959.68753245.3125
59109102107454.5744680851647.42553191489
60137303145042.790697674-7739.79069767441
61125304145042.790697674-19738.7906976744
6288620145042.790697674-56422.7906976744
6395808107454.574468085-11646.5744680851
6483419107454.574468085-24035.5744680851
6510172379980.571428571421742.4285714286
6694982107454.574468085-12472.5744680851
67143566145042.790697674-1476.79069767441
68113325229232.5-115907.5
698151859959.687521558.3125
703197059959.6875-27989.6875
71192268229232.5-36964.5
7291261107454.574468085-16193.5744680851
7380820107454.574468085-26634.5744680851
7489141107454.574468085-18313.5744680851
75116322145042.790697674-28720.7906976744
765654479980.5714285714-23436.5714285714
77118838145042.790697674-26204.7906976744
78118781145042.790697674-26261.7906976744
796013859959.6875178.3125
8073422107454.574468085-34032.5744680851
816781959959.68757859.3125
82225857145042.79069767480814.2093023256
835118542283.77777777788901.22222222222
8497181107454.574468085-10273.5744680851
854510059959.6875-14859.6875
86115801107454.5744680858346.4255319149
87186310145042.79069767441267.2093023256
8871960107454.574468085-35494.5744680851
8980105107454.574468085-27349.5744680851
90110416107454.5744680852961.42553191489
9198707107454.574468085-8747.5744680851
92136234145042.790697674-8808.79069767441
93136781107454.57446808529326.4255319149
94105863107454.574468085-1591.57446808511
954916442283.77777777786880.22222222222
96189493145042.79069767444450.2093023256
97169406145042.79069767424363.2093023256
98193496617.5714285714312731.4285714286
99160819145042.79069767415776.2093023256
100109510107454.5744680852055.42553191489
1014380342283.77777777781519.22222222222
1024706259959.6875-12897.6875
103110845107454.5744680853390.42553191489
10492517107454.574468085-14937.5744680851
1055866042283.777777777816376.2222222222
1062767642283.7777777778-14607.7777777778
10798550107454.574468085-8904.5744680851
1084364642283.77777777781362.22222222222
10906617.57142857143-6617.57142857143
11075566107454.574468085-31888.5744680851
1115735959959.6875-2600.6875
112104330107454.574468085-3124.57446808511
11370369107454.574468085-37085.5744680851
1146549459959.68755534.3125
11536166617.57142857143-3001.57142857143
11606617.57142857143-6617.57142857143
117143931107454.57446808536476.4255319149
118117946107454.57446808510491.4255319149
119137332145042.790697674-7710.79069767441
1208433659959.687524376.3125
1214341042283.77777777781126.22222222222
122139695107454.57446808532240.4255319149
1237901559959.687519055.3125
124106116145042.790697674-38926.7906976744
1255758659959.6875-2373.6875
126197646617.5714285714313146.4285714286
127105757107454.574468085-1697.57446808511
128103651107454.574468085-3803.57446808511
129113402107454.5744680855947.4255319149
130117966617.571428571435178.42857142857
13176276617.571428571431009.42857142857
132121085107454.57446808513630.4255319149
13368366617.57142857143218.428571428572
134139563145042.790697674-5479.79069767441
13551186617.57142857143-1499.57142857143
1364024842283.7777777778-2035.77777777778
13706617.57142857143-6617.57142857143
1389507979980.571428571415098.4285714286
1398076379980.5714285714782.428571428565
14071316617.57142857143513.428571428572
14141946617.57142857143-2423.57142857143
1426037859959.6875418.3125
143109173107454.5744680851718.42553191489
1448348479980.57142857143503.42857142857

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 129988 & 145042.790697674 & -15054.7906976744 \tabularnewline
2 & 130358 & 107454.574468085 & 22903.4255319149 \tabularnewline
3 & 7215 & 6617.57142857143 & 597.428571428572 \tabularnewline
4 & 112976 & 145042.790697674 & -32066.7906976744 \tabularnewline
5 & 219904 & 229232.5 & -9328.5 \tabularnewline
6 & 402036 & 229232.5 & 172803.5 \tabularnewline
7 & 117604 & 107454.574468085 & 10149.4255319149 \tabularnewline
8 & 131822 & 107454.574468085 & 24367.4255319149 \tabularnewline
9 & 99729 & 107454.574468085 & -7725.5744680851 \tabularnewline
10 & 256310 & 229232.5 & 27077.5 \tabularnewline
11 & 113066 & 145042.790697674 & -31976.7906976744 \tabularnewline
12 & 165392 & 145042.790697674 & 20349.2093023256 \tabularnewline
13 & 78240 & 107454.574468085 & -29214.5744680851 \tabularnewline
14 & 152673 & 229232.5 & -76559.5 \tabularnewline
15 & 134368 & 107454.574468085 & 26913.4255319149 \tabularnewline
16 & 125769 & 107454.574468085 & 18314.4255319149 \tabularnewline
17 & 123467 & 145042.790697674 & -21575.7906976744 \tabularnewline
18 & 56232 & 79980.5714285714 & -23748.5714285714 \tabularnewline
19 & 108458 & 145042.790697674 & -36584.7906976744 \tabularnewline
20 & 22762 & 42283.7777777778 & -19521.7777777778 \tabularnewline
21 & 48633 & 59959.6875 & -11326.6875 \tabularnewline
22 & 182081 & 145042.790697674 & 37038.2093023256 \tabularnewline
23 & 140857 & 145042.790697674 & -4185.79069767441 \tabularnewline
24 & 93773 & 145042.790697674 & -51269.7906976744 \tabularnewline
25 & 133428 & 145042.790697674 & -11614.7906976744 \tabularnewline
26 & 113933 & 107454.574468085 & 6478.4255319149 \tabularnewline
27 & 153851 & 145042.790697674 & 8808.20930232559 \tabularnewline
28 & 140711 & 107454.574468085 & 33256.4255319149 \tabularnewline
29 & 303844 & 229232.5 & 74611.5 \tabularnewline
30 & 163810 & 145042.790697674 & 18767.2093023256 \tabularnewline
31 & 123344 & 107454.574468085 & 15889.4255319149 \tabularnewline
32 & 157640 & 107454.574468085 & 50185.4255319149 \tabularnewline
33 & 103274 & 145042.790697674 & -41768.7906976744 \tabularnewline
34 & 193500 & 229232.5 & -35732.5 \tabularnewline
35 & 178768 & 145042.790697674 & 33725.2093023256 \tabularnewline
36 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
37 & 181412 & 145042.790697674 & 36369.2093023256 \tabularnewline
38 & 92342 & 145042.790697674 & -52700.7906976744 \tabularnewline
39 & 100023 & 145042.790697674 & -45019.7906976744 \tabularnewline
40 & 178277 & 145042.790697674 & 33234.2093023256 \tabularnewline
41 & 145067 & 145042.790697674 & 24.2093023255875 \tabularnewline
42 & 114146 & 107454.574468085 & 6691.4255319149 \tabularnewline
43 & 86039 & 79980.5714285714 & 6058.42857142857 \tabularnewline
44 & 125481 & 145042.790697674 & -19561.7906976744 \tabularnewline
45 & 95535 & 107454.574468085 & -11919.5744680851 \tabularnewline
46 & 129221 & 107454.574468085 & 21766.4255319149 \tabularnewline
47 & 61554 & 59959.6875 & 1594.3125 \tabularnewline
48 & 168048 & 145042.790697674 & 23005.2093023256 \tabularnewline
49 & 159121 & 145042.790697674 & 14078.2093023256 \tabularnewline
50 & 129362 & 145042.790697674 & -15680.7906976744 \tabularnewline
51 & 48188 & 59959.6875 & -11771.6875 \tabularnewline
52 & 95461 & 107454.574468085 & -11993.5744680851 \tabularnewline
53 & 229864 & 145042.790697674 & 84821.2093023256 \tabularnewline
54 & 191094 & 145042.790697674 & 46051.2093023256 \tabularnewline
55 & 161082 & 145042.790697674 & 16039.2093023256 \tabularnewline
56 & 111388 & 107454.574468085 & 3933.42553191489 \tabularnewline
57 & 172614 & 145042.790697674 & 27571.2093023256 \tabularnewline
58 & 63205 & 59959.6875 & 3245.3125 \tabularnewline
59 & 109102 & 107454.574468085 & 1647.42553191489 \tabularnewline
60 & 137303 & 145042.790697674 & -7739.79069767441 \tabularnewline
61 & 125304 & 145042.790697674 & -19738.7906976744 \tabularnewline
62 & 88620 & 145042.790697674 & -56422.7906976744 \tabularnewline
63 & 95808 & 107454.574468085 & -11646.5744680851 \tabularnewline
64 & 83419 & 107454.574468085 & -24035.5744680851 \tabularnewline
65 & 101723 & 79980.5714285714 & 21742.4285714286 \tabularnewline
66 & 94982 & 107454.574468085 & -12472.5744680851 \tabularnewline
67 & 143566 & 145042.790697674 & -1476.79069767441 \tabularnewline
68 & 113325 & 229232.5 & -115907.5 \tabularnewline
69 & 81518 & 59959.6875 & 21558.3125 \tabularnewline
70 & 31970 & 59959.6875 & -27989.6875 \tabularnewline
71 & 192268 & 229232.5 & -36964.5 \tabularnewline
72 & 91261 & 107454.574468085 & -16193.5744680851 \tabularnewline
73 & 80820 & 107454.574468085 & -26634.5744680851 \tabularnewline
74 & 89141 & 107454.574468085 & -18313.5744680851 \tabularnewline
75 & 116322 & 145042.790697674 & -28720.7906976744 \tabularnewline
76 & 56544 & 79980.5714285714 & -23436.5714285714 \tabularnewline
77 & 118838 & 145042.790697674 & -26204.7906976744 \tabularnewline
78 & 118781 & 145042.790697674 & -26261.7906976744 \tabularnewline
79 & 60138 & 59959.6875 & 178.3125 \tabularnewline
80 & 73422 & 107454.574468085 & -34032.5744680851 \tabularnewline
81 & 67819 & 59959.6875 & 7859.3125 \tabularnewline
82 & 225857 & 145042.790697674 & 80814.2093023256 \tabularnewline
83 & 51185 & 42283.7777777778 & 8901.22222222222 \tabularnewline
84 & 97181 & 107454.574468085 & -10273.5744680851 \tabularnewline
85 & 45100 & 59959.6875 & -14859.6875 \tabularnewline
86 & 115801 & 107454.574468085 & 8346.4255319149 \tabularnewline
87 & 186310 & 145042.790697674 & 41267.2093023256 \tabularnewline
88 & 71960 & 107454.574468085 & -35494.5744680851 \tabularnewline
89 & 80105 & 107454.574468085 & -27349.5744680851 \tabularnewline
90 & 110416 & 107454.574468085 & 2961.42553191489 \tabularnewline
91 & 98707 & 107454.574468085 & -8747.5744680851 \tabularnewline
92 & 136234 & 145042.790697674 & -8808.79069767441 \tabularnewline
93 & 136781 & 107454.574468085 & 29326.4255319149 \tabularnewline
94 & 105863 & 107454.574468085 & -1591.57446808511 \tabularnewline
95 & 49164 & 42283.7777777778 & 6880.22222222222 \tabularnewline
96 & 189493 & 145042.790697674 & 44450.2093023256 \tabularnewline
97 & 169406 & 145042.790697674 & 24363.2093023256 \tabularnewline
98 & 19349 & 6617.57142857143 & 12731.4285714286 \tabularnewline
99 & 160819 & 145042.790697674 & 15776.2093023256 \tabularnewline
100 & 109510 & 107454.574468085 & 2055.42553191489 \tabularnewline
101 & 43803 & 42283.7777777778 & 1519.22222222222 \tabularnewline
102 & 47062 & 59959.6875 & -12897.6875 \tabularnewline
103 & 110845 & 107454.574468085 & 3390.42553191489 \tabularnewline
104 & 92517 & 107454.574468085 & -14937.5744680851 \tabularnewline
105 & 58660 & 42283.7777777778 & 16376.2222222222 \tabularnewline
106 & 27676 & 42283.7777777778 & -14607.7777777778 \tabularnewline
107 & 98550 & 107454.574468085 & -8904.5744680851 \tabularnewline
108 & 43646 & 42283.7777777778 & 1362.22222222222 \tabularnewline
109 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
110 & 75566 & 107454.574468085 & -31888.5744680851 \tabularnewline
111 & 57359 & 59959.6875 & -2600.6875 \tabularnewline
112 & 104330 & 107454.574468085 & -3124.57446808511 \tabularnewline
113 & 70369 & 107454.574468085 & -37085.5744680851 \tabularnewline
114 & 65494 & 59959.6875 & 5534.3125 \tabularnewline
115 & 3616 & 6617.57142857143 & -3001.57142857143 \tabularnewline
116 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
117 & 143931 & 107454.574468085 & 36476.4255319149 \tabularnewline
118 & 117946 & 107454.574468085 & 10491.4255319149 \tabularnewline
119 & 137332 & 145042.790697674 & -7710.79069767441 \tabularnewline
120 & 84336 & 59959.6875 & 24376.3125 \tabularnewline
121 & 43410 & 42283.7777777778 & 1126.22222222222 \tabularnewline
122 & 139695 & 107454.574468085 & 32240.4255319149 \tabularnewline
123 & 79015 & 59959.6875 & 19055.3125 \tabularnewline
124 & 106116 & 145042.790697674 & -38926.7906976744 \tabularnewline
125 & 57586 & 59959.6875 & -2373.6875 \tabularnewline
126 & 19764 & 6617.57142857143 & 13146.4285714286 \tabularnewline
127 & 105757 & 107454.574468085 & -1697.57446808511 \tabularnewline
128 & 103651 & 107454.574468085 & -3803.57446808511 \tabularnewline
129 & 113402 & 107454.574468085 & 5947.4255319149 \tabularnewline
130 & 11796 & 6617.57142857143 & 5178.42857142857 \tabularnewline
131 & 7627 & 6617.57142857143 & 1009.42857142857 \tabularnewline
132 & 121085 & 107454.574468085 & 13630.4255319149 \tabularnewline
133 & 6836 & 6617.57142857143 & 218.428571428572 \tabularnewline
134 & 139563 & 145042.790697674 & -5479.79069767441 \tabularnewline
135 & 5118 & 6617.57142857143 & -1499.57142857143 \tabularnewline
136 & 40248 & 42283.7777777778 & -2035.77777777778 \tabularnewline
137 & 0 & 6617.57142857143 & -6617.57142857143 \tabularnewline
138 & 95079 & 79980.5714285714 & 15098.4285714286 \tabularnewline
139 & 80763 & 79980.5714285714 & 782.428571428565 \tabularnewline
140 & 7131 & 6617.57142857143 & 513.428571428572 \tabularnewline
141 & 4194 & 6617.57142857143 & -2423.57142857143 \tabularnewline
142 & 60378 & 59959.6875 & 418.3125 \tabularnewline
143 & 109173 & 107454.574468085 & 1718.42553191489 \tabularnewline
144 & 83484 & 79980.5714285714 & 3503.42857142857 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155528&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]129988[/C][C]145042.790697674[/C][C]-15054.7906976744[/C][/ROW]
[ROW][C]2[/C][C]130358[/C][C]107454.574468085[/C][C]22903.4255319149[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]6617.57142857143[/C][C]597.428571428572[/C][/ROW]
[ROW][C]4[/C][C]112976[/C][C]145042.790697674[/C][C]-32066.7906976744[/C][/ROW]
[ROW][C]5[/C][C]219904[/C][C]229232.5[/C][C]-9328.5[/C][/ROW]
[ROW][C]6[/C][C]402036[/C][C]229232.5[/C][C]172803.5[/C][/ROW]
[ROW][C]7[/C][C]117604[/C][C]107454.574468085[/C][C]10149.4255319149[/C][/ROW]
[ROW][C]8[/C][C]131822[/C][C]107454.574468085[/C][C]24367.4255319149[/C][/ROW]
[ROW][C]9[/C][C]99729[/C][C]107454.574468085[/C][C]-7725.5744680851[/C][/ROW]
[ROW][C]10[/C][C]256310[/C][C]229232.5[/C][C]27077.5[/C][/ROW]
[ROW][C]11[/C][C]113066[/C][C]145042.790697674[/C][C]-31976.7906976744[/C][/ROW]
[ROW][C]12[/C][C]165392[/C][C]145042.790697674[/C][C]20349.2093023256[/C][/ROW]
[ROW][C]13[/C][C]78240[/C][C]107454.574468085[/C][C]-29214.5744680851[/C][/ROW]
[ROW][C]14[/C][C]152673[/C][C]229232.5[/C][C]-76559.5[/C][/ROW]
[ROW][C]15[/C][C]134368[/C][C]107454.574468085[/C][C]26913.4255319149[/C][/ROW]
[ROW][C]16[/C][C]125769[/C][C]107454.574468085[/C][C]18314.4255319149[/C][/ROW]
[ROW][C]17[/C][C]123467[/C][C]145042.790697674[/C][C]-21575.7906976744[/C][/ROW]
[ROW][C]18[/C][C]56232[/C][C]79980.5714285714[/C][C]-23748.5714285714[/C][/ROW]
[ROW][C]19[/C][C]108458[/C][C]145042.790697674[/C][C]-36584.7906976744[/C][/ROW]
[ROW][C]20[/C][C]22762[/C][C]42283.7777777778[/C][C]-19521.7777777778[/C][/ROW]
[ROW][C]21[/C][C]48633[/C][C]59959.6875[/C][C]-11326.6875[/C][/ROW]
[ROW][C]22[/C][C]182081[/C][C]145042.790697674[/C][C]37038.2093023256[/C][/ROW]
[ROW][C]23[/C][C]140857[/C][C]145042.790697674[/C][C]-4185.79069767441[/C][/ROW]
[ROW][C]24[/C][C]93773[/C][C]145042.790697674[/C][C]-51269.7906976744[/C][/ROW]
[ROW][C]25[/C][C]133428[/C][C]145042.790697674[/C][C]-11614.7906976744[/C][/ROW]
[ROW][C]26[/C][C]113933[/C][C]107454.574468085[/C][C]6478.4255319149[/C][/ROW]
[ROW][C]27[/C][C]153851[/C][C]145042.790697674[/C][C]8808.20930232559[/C][/ROW]
[ROW][C]28[/C][C]140711[/C][C]107454.574468085[/C][C]33256.4255319149[/C][/ROW]
[ROW][C]29[/C][C]303844[/C][C]229232.5[/C][C]74611.5[/C][/ROW]
[ROW][C]30[/C][C]163810[/C][C]145042.790697674[/C][C]18767.2093023256[/C][/ROW]
[ROW][C]31[/C][C]123344[/C][C]107454.574468085[/C][C]15889.4255319149[/C][/ROW]
[ROW][C]32[/C][C]157640[/C][C]107454.574468085[/C][C]50185.4255319149[/C][/ROW]
[ROW][C]33[/C][C]103274[/C][C]145042.790697674[/C][C]-41768.7906976744[/C][/ROW]
[ROW][C]34[/C][C]193500[/C][C]229232.5[/C][C]-35732.5[/C][/ROW]
[ROW][C]35[/C][C]178768[/C][C]145042.790697674[/C][C]33725.2093023256[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]37[/C][C]181412[/C][C]145042.790697674[/C][C]36369.2093023256[/C][/ROW]
[ROW][C]38[/C][C]92342[/C][C]145042.790697674[/C][C]-52700.7906976744[/C][/ROW]
[ROW][C]39[/C][C]100023[/C][C]145042.790697674[/C][C]-45019.7906976744[/C][/ROW]
[ROW][C]40[/C][C]178277[/C][C]145042.790697674[/C][C]33234.2093023256[/C][/ROW]
[ROW][C]41[/C][C]145067[/C][C]145042.790697674[/C][C]24.2093023255875[/C][/ROW]
[ROW][C]42[/C][C]114146[/C][C]107454.574468085[/C][C]6691.4255319149[/C][/ROW]
[ROW][C]43[/C][C]86039[/C][C]79980.5714285714[/C][C]6058.42857142857[/C][/ROW]
[ROW][C]44[/C][C]125481[/C][C]145042.790697674[/C][C]-19561.7906976744[/C][/ROW]
[ROW][C]45[/C][C]95535[/C][C]107454.574468085[/C][C]-11919.5744680851[/C][/ROW]
[ROW][C]46[/C][C]129221[/C][C]107454.574468085[/C][C]21766.4255319149[/C][/ROW]
[ROW][C]47[/C][C]61554[/C][C]59959.6875[/C][C]1594.3125[/C][/ROW]
[ROW][C]48[/C][C]168048[/C][C]145042.790697674[/C][C]23005.2093023256[/C][/ROW]
[ROW][C]49[/C][C]159121[/C][C]145042.790697674[/C][C]14078.2093023256[/C][/ROW]
[ROW][C]50[/C][C]129362[/C][C]145042.790697674[/C][C]-15680.7906976744[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]59959.6875[/C][C]-11771.6875[/C][/ROW]
[ROW][C]52[/C][C]95461[/C][C]107454.574468085[/C][C]-11993.5744680851[/C][/ROW]
[ROW][C]53[/C][C]229864[/C][C]145042.790697674[/C][C]84821.2093023256[/C][/ROW]
[ROW][C]54[/C][C]191094[/C][C]145042.790697674[/C][C]46051.2093023256[/C][/ROW]
[ROW][C]55[/C][C]161082[/C][C]145042.790697674[/C][C]16039.2093023256[/C][/ROW]
[ROW][C]56[/C][C]111388[/C][C]107454.574468085[/C][C]3933.42553191489[/C][/ROW]
[ROW][C]57[/C][C]172614[/C][C]145042.790697674[/C][C]27571.2093023256[/C][/ROW]
[ROW][C]58[/C][C]63205[/C][C]59959.6875[/C][C]3245.3125[/C][/ROW]
[ROW][C]59[/C][C]109102[/C][C]107454.574468085[/C][C]1647.42553191489[/C][/ROW]
[ROW][C]60[/C][C]137303[/C][C]145042.790697674[/C][C]-7739.79069767441[/C][/ROW]
[ROW][C]61[/C][C]125304[/C][C]145042.790697674[/C][C]-19738.7906976744[/C][/ROW]
[ROW][C]62[/C][C]88620[/C][C]145042.790697674[/C][C]-56422.7906976744[/C][/ROW]
[ROW][C]63[/C][C]95808[/C][C]107454.574468085[/C][C]-11646.5744680851[/C][/ROW]
[ROW][C]64[/C][C]83419[/C][C]107454.574468085[/C][C]-24035.5744680851[/C][/ROW]
[ROW][C]65[/C][C]101723[/C][C]79980.5714285714[/C][C]21742.4285714286[/C][/ROW]
[ROW][C]66[/C][C]94982[/C][C]107454.574468085[/C][C]-12472.5744680851[/C][/ROW]
[ROW][C]67[/C][C]143566[/C][C]145042.790697674[/C][C]-1476.79069767441[/C][/ROW]
[ROW][C]68[/C][C]113325[/C][C]229232.5[/C][C]-115907.5[/C][/ROW]
[ROW][C]69[/C][C]81518[/C][C]59959.6875[/C][C]21558.3125[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]59959.6875[/C][C]-27989.6875[/C][/ROW]
[ROW][C]71[/C][C]192268[/C][C]229232.5[/C][C]-36964.5[/C][/ROW]
[ROW][C]72[/C][C]91261[/C][C]107454.574468085[/C][C]-16193.5744680851[/C][/ROW]
[ROW][C]73[/C][C]80820[/C][C]107454.574468085[/C][C]-26634.5744680851[/C][/ROW]
[ROW][C]74[/C][C]89141[/C][C]107454.574468085[/C][C]-18313.5744680851[/C][/ROW]
[ROW][C]75[/C][C]116322[/C][C]145042.790697674[/C][C]-28720.7906976744[/C][/ROW]
[ROW][C]76[/C][C]56544[/C][C]79980.5714285714[/C][C]-23436.5714285714[/C][/ROW]
[ROW][C]77[/C][C]118838[/C][C]145042.790697674[/C][C]-26204.7906976744[/C][/ROW]
[ROW][C]78[/C][C]118781[/C][C]145042.790697674[/C][C]-26261.7906976744[/C][/ROW]
[ROW][C]79[/C][C]60138[/C][C]59959.6875[/C][C]178.3125[/C][/ROW]
[ROW][C]80[/C][C]73422[/C][C]107454.574468085[/C][C]-34032.5744680851[/C][/ROW]
[ROW][C]81[/C][C]67819[/C][C]59959.6875[/C][C]7859.3125[/C][/ROW]
[ROW][C]82[/C][C]225857[/C][C]145042.790697674[/C][C]80814.2093023256[/C][/ROW]
[ROW][C]83[/C][C]51185[/C][C]42283.7777777778[/C][C]8901.22222222222[/C][/ROW]
[ROW][C]84[/C][C]97181[/C][C]107454.574468085[/C][C]-10273.5744680851[/C][/ROW]
[ROW][C]85[/C][C]45100[/C][C]59959.6875[/C][C]-14859.6875[/C][/ROW]
[ROW][C]86[/C][C]115801[/C][C]107454.574468085[/C][C]8346.4255319149[/C][/ROW]
[ROW][C]87[/C][C]186310[/C][C]145042.790697674[/C][C]41267.2093023256[/C][/ROW]
[ROW][C]88[/C][C]71960[/C][C]107454.574468085[/C][C]-35494.5744680851[/C][/ROW]
[ROW][C]89[/C][C]80105[/C][C]107454.574468085[/C][C]-27349.5744680851[/C][/ROW]
[ROW][C]90[/C][C]110416[/C][C]107454.574468085[/C][C]2961.42553191489[/C][/ROW]
[ROW][C]91[/C][C]98707[/C][C]107454.574468085[/C][C]-8747.5744680851[/C][/ROW]
[ROW][C]92[/C][C]136234[/C][C]145042.790697674[/C][C]-8808.79069767441[/C][/ROW]
[ROW][C]93[/C][C]136781[/C][C]107454.574468085[/C][C]29326.4255319149[/C][/ROW]
[ROW][C]94[/C][C]105863[/C][C]107454.574468085[/C][C]-1591.57446808511[/C][/ROW]
[ROW][C]95[/C][C]49164[/C][C]42283.7777777778[/C][C]6880.22222222222[/C][/ROW]
[ROW][C]96[/C][C]189493[/C][C]145042.790697674[/C][C]44450.2093023256[/C][/ROW]
[ROW][C]97[/C][C]169406[/C][C]145042.790697674[/C][C]24363.2093023256[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]6617.57142857143[/C][C]12731.4285714286[/C][/ROW]
[ROW][C]99[/C][C]160819[/C][C]145042.790697674[/C][C]15776.2093023256[/C][/ROW]
[ROW][C]100[/C][C]109510[/C][C]107454.574468085[/C][C]2055.42553191489[/C][/ROW]
[ROW][C]101[/C][C]43803[/C][C]42283.7777777778[/C][C]1519.22222222222[/C][/ROW]
[ROW][C]102[/C][C]47062[/C][C]59959.6875[/C][C]-12897.6875[/C][/ROW]
[ROW][C]103[/C][C]110845[/C][C]107454.574468085[/C][C]3390.42553191489[/C][/ROW]
[ROW][C]104[/C][C]92517[/C][C]107454.574468085[/C][C]-14937.5744680851[/C][/ROW]
[ROW][C]105[/C][C]58660[/C][C]42283.7777777778[/C][C]16376.2222222222[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]42283.7777777778[/C][C]-14607.7777777778[/C][/ROW]
[ROW][C]107[/C][C]98550[/C][C]107454.574468085[/C][C]-8904.5744680851[/C][/ROW]
[ROW][C]108[/C][C]43646[/C][C]42283.7777777778[/C][C]1362.22222222222[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]110[/C][C]75566[/C][C]107454.574468085[/C][C]-31888.5744680851[/C][/ROW]
[ROW][C]111[/C][C]57359[/C][C]59959.6875[/C][C]-2600.6875[/C][/ROW]
[ROW][C]112[/C][C]104330[/C][C]107454.574468085[/C][C]-3124.57446808511[/C][/ROW]
[ROW][C]113[/C][C]70369[/C][C]107454.574468085[/C][C]-37085.5744680851[/C][/ROW]
[ROW][C]114[/C][C]65494[/C][C]59959.6875[/C][C]5534.3125[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]6617.57142857143[/C][C]-3001.57142857143[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]117[/C][C]143931[/C][C]107454.574468085[/C][C]36476.4255319149[/C][/ROW]
[ROW][C]118[/C][C]117946[/C][C]107454.574468085[/C][C]10491.4255319149[/C][/ROW]
[ROW][C]119[/C][C]137332[/C][C]145042.790697674[/C][C]-7710.79069767441[/C][/ROW]
[ROW][C]120[/C][C]84336[/C][C]59959.6875[/C][C]24376.3125[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]42283.7777777778[/C][C]1126.22222222222[/C][/ROW]
[ROW][C]122[/C][C]139695[/C][C]107454.574468085[/C][C]32240.4255319149[/C][/ROW]
[ROW][C]123[/C][C]79015[/C][C]59959.6875[/C][C]19055.3125[/C][/ROW]
[ROW][C]124[/C][C]106116[/C][C]145042.790697674[/C][C]-38926.7906976744[/C][/ROW]
[ROW][C]125[/C][C]57586[/C][C]59959.6875[/C][C]-2373.6875[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]6617.57142857143[/C][C]13146.4285714286[/C][/ROW]
[ROW][C]127[/C][C]105757[/C][C]107454.574468085[/C][C]-1697.57446808511[/C][/ROW]
[ROW][C]128[/C][C]103651[/C][C]107454.574468085[/C][C]-3803.57446808511[/C][/ROW]
[ROW][C]129[/C][C]113402[/C][C]107454.574468085[/C][C]5947.4255319149[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]6617.57142857143[/C][C]5178.42857142857[/C][/ROW]
[ROW][C]131[/C][C]7627[/C][C]6617.57142857143[/C][C]1009.42857142857[/C][/ROW]
[ROW][C]132[/C][C]121085[/C][C]107454.574468085[/C][C]13630.4255319149[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]6617.57142857143[/C][C]218.428571428572[/C][/ROW]
[ROW][C]134[/C][C]139563[/C][C]145042.790697674[/C][C]-5479.79069767441[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]6617.57142857143[/C][C]-1499.57142857143[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]42283.7777777778[/C][C]-2035.77777777778[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]6617.57142857143[/C][C]-6617.57142857143[/C][/ROW]
[ROW][C]138[/C][C]95079[/C][C]79980.5714285714[/C][C]15098.4285714286[/C][/ROW]
[ROW][C]139[/C][C]80763[/C][C]79980.5714285714[/C][C]782.428571428565[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]6617.57142857143[/C][C]513.428571428572[/C][/ROW]
[ROW][C]141[/C][C]4194[/C][C]6617.57142857143[/C][C]-2423.57142857143[/C][/ROW]
[ROW][C]142[/C][C]60378[/C][C]59959.6875[/C][C]418.3125[/C][/ROW]
[ROW][C]143[/C][C]109173[/C][C]107454.574468085[/C][C]1718.42553191489[/C][/ROW]
[ROW][C]144[/C][C]83484[/C][C]79980.5714285714[/C][C]3503.42857142857[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155528&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155528&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
1129988145042.790697674-15054.7906976744
2130358107454.57446808522903.4255319149
372156617.57142857143597.428571428572
4112976145042.790697674-32066.7906976744
5219904229232.5-9328.5
6402036229232.5172803.5
7117604107454.57446808510149.4255319149
8131822107454.57446808524367.4255319149
999729107454.574468085-7725.5744680851
10256310229232.527077.5
11113066145042.790697674-31976.7906976744
12165392145042.79069767420349.2093023256
1378240107454.574468085-29214.5744680851
14152673229232.5-76559.5
15134368107454.57446808526913.4255319149
16125769107454.57446808518314.4255319149
17123467145042.790697674-21575.7906976744
185623279980.5714285714-23748.5714285714
19108458145042.790697674-36584.7906976744
202276242283.7777777778-19521.7777777778
214863359959.6875-11326.6875
22182081145042.79069767437038.2093023256
23140857145042.790697674-4185.79069767441
2493773145042.790697674-51269.7906976744
25133428145042.790697674-11614.7906976744
26113933107454.5744680856478.4255319149
27153851145042.7906976748808.20930232559
28140711107454.57446808533256.4255319149
29303844229232.574611.5
30163810145042.79069767418767.2093023256
31123344107454.57446808515889.4255319149
32157640107454.57446808550185.4255319149
33103274145042.790697674-41768.7906976744
34193500229232.5-35732.5
35178768145042.79069767433725.2093023256
3606617.57142857143-6617.57142857143
37181412145042.79069767436369.2093023256
3892342145042.790697674-52700.7906976744
39100023145042.790697674-45019.7906976744
40178277145042.79069767433234.2093023256
41145067145042.79069767424.2093023255875
42114146107454.5744680856691.4255319149
438603979980.57142857146058.42857142857
44125481145042.790697674-19561.7906976744
4595535107454.574468085-11919.5744680851
46129221107454.57446808521766.4255319149
476155459959.68751594.3125
48168048145042.79069767423005.2093023256
49159121145042.79069767414078.2093023256
50129362145042.790697674-15680.7906976744
514818859959.6875-11771.6875
5295461107454.574468085-11993.5744680851
53229864145042.79069767484821.2093023256
54191094145042.79069767446051.2093023256
55161082145042.79069767416039.2093023256
56111388107454.5744680853933.42553191489
57172614145042.79069767427571.2093023256
586320559959.68753245.3125
59109102107454.5744680851647.42553191489
60137303145042.790697674-7739.79069767441
61125304145042.790697674-19738.7906976744
6288620145042.790697674-56422.7906976744
6395808107454.574468085-11646.5744680851
6483419107454.574468085-24035.5744680851
6510172379980.571428571421742.4285714286
6694982107454.574468085-12472.5744680851
67143566145042.790697674-1476.79069767441
68113325229232.5-115907.5
698151859959.687521558.3125
703197059959.6875-27989.6875
71192268229232.5-36964.5
7291261107454.574468085-16193.5744680851
7380820107454.574468085-26634.5744680851
7489141107454.574468085-18313.5744680851
75116322145042.790697674-28720.7906976744
765654479980.5714285714-23436.5714285714
77118838145042.790697674-26204.7906976744
78118781145042.790697674-26261.7906976744
796013859959.6875178.3125
8073422107454.574468085-34032.5744680851
816781959959.68757859.3125
82225857145042.79069767480814.2093023256
835118542283.77777777788901.22222222222
8497181107454.574468085-10273.5744680851
854510059959.6875-14859.6875
86115801107454.5744680858346.4255319149
87186310145042.79069767441267.2093023256
8871960107454.574468085-35494.5744680851
8980105107454.574468085-27349.5744680851
90110416107454.5744680852961.42553191489
9198707107454.574468085-8747.5744680851
92136234145042.790697674-8808.79069767441
93136781107454.57446808529326.4255319149
94105863107454.574468085-1591.57446808511
954916442283.77777777786880.22222222222
96189493145042.79069767444450.2093023256
97169406145042.79069767424363.2093023256
98193496617.5714285714312731.4285714286
99160819145042.79069767415776.2093023256
100109510107454.5744680852055.42553191489
1014380342283.77777777781519.22222222222
1024706259959.6875-12897.6875
103110845107454.5744680853390.42553191489
10492517107454.574468085-14937.5744680851
1055866042283.777777777816376.2222222222
1062767642283.7777777778-14607.7777777778
10798550107454.574468085-8904.5744680851
1084364642283.77777777781362.22222222222
10906617.57142857143-6617.57142857143
11075566107454.574468085-31888.5744680851
1115735959959.6875-2600.6875
112104330107454.574468085-3124.57446808511
11370369107454.574468085-37085.5744680851
1146549459959.68755534.3125
11536166617.57142857143-3001.57142857143
11606617.57142857143-6617.57142857143
117143931107454.57446808536476.4255319149
118117946107454.57446808510491.4255319149
119137332145042.790697674-7710.79069767441
1208433659959.687524376.3125
1214341042283.77777777781126.22222222222
122139695107454.57446808532240.4255319149
1237901559959.687519055.3125
124106116145042.790697674-38926.7906976744
1255758659959.6875-2373.6875
126197646617.5714285714313146.4285714286
127105757107454.574468085-1697.57446808511
128103651107454.574468085-3803.57446808511
129113402107454.5744680855947.4255319149
130117966617.571428571435178.42857142857
13176276617.571428571431009.42857142857
132121085107454.57446808513630.4255319149
13368366617.57142857143218.428571428572
134139563145042.790697674-5479.79069767441
13551186617.57142857143-1499.57142857143
1364024842283.7777777778-2035.77777777778
13706617.57142857143-6617.57142857143
1389507979980.571428571415098.4285714286
1398076379980.5714285714782.428571428565
14071316617.57142857143513.428571428572
14141946617.57142857143-2423.57142857143
1426037859959.6875418.3125
143109173107454.5744680851718.42553191489
1448348479980.57142857143503.42857142857



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