Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_regression_trees1.wasp
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationTue, 13 Dec 2011 14:02:37 -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/13/t1323802977zsh1gf54am048oq.htm/, Retrieved Fri, 03 May 2024 00:58:41 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=154642, Retrieved Fri, 03 May 2024 00:58:41 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact72
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Recursive Partitioning (Regression Trees)] [] [2010-12-05 18:59:57] [b98453cac15ba1066b407e146608df68]
- R PD    [Recursive Partitioning (Regression Trees)] [] [2011-12-13 19:02:37] [44862125718ce971d51d71f1796e585f] [Current]
Feedback Forum

Post a new message
Dataseries X:
1666	264724	66	34	124252
966	137550	61	30	98956
1783	213265	66	42	98073
2563	208980	100	38	106816
1070	147176	49	27	41449
578	65295	28	31	76173
4059	452801	108	29	177551
381	33186	19	18	22807
1900	200501	55	31	126938
1694	199716	43	33	61680
2001	292387	101	42	72117
1953	219225	106	54	79738
1600	156623	65	35	57793
2664	327332	73	51	91677
1739	202440	78	42	64631
4680	367911	172	59	106385
2029	285842	66	36	161961
2688	292903	144	39	112669
1321	159678	52	26	114029
2198	251859	79	45	124550
2446	269240	68	45	105416
2641	412303	100	39	72875
1299	161189	38	25	81964
1648	178722	52	52	104880
2975	200181	109	41	76302
2487	203572	111	38	96740
2657	249899	124	38	93071
1842	254114	82	37	78912
1474	151167	50	32	35224
2478	310339	58	38	90694
2122	253478	72	45	125369
1733	191614	71	46	80849
2031	311019	83	48	104434
867	87995	35	33	65702
2804	343613	88	39	108179
2695	266925	54	39	63583
3425	395062	115	41	95066
1679	192734	78	32	62486
917	114673	31	17	31081
2995	310306	176	39	94584
3134	311966	76	37	87408
1489	157897	62	38	68966
1636	185249	71	36	88766
1610	160770	54	42	57139
2402	142302	76	45	90586
4941	414427	138	38	109249
918	78800	42	26	33032
2133	202416	72	46	96056
3802	314815	111	47	146648
2000	169182	54	45	80613
1668	200370	72	35	87026
496	24188	24	4	5950
2452	361758	297	44	131106
744	65029	17	18	32551
1161	101097	64	14	31701
2730	255165	53	37	91072
2393	296166	81	55	159803
3417	312624	169	36	143950
2294	296511	129	39	112368
2044	234948	78	36	82124
3814	357369	134	46	144068
3050	288449	113	28	162627
2346	205791	97	42	55062
2327	247065	85	38	95329
1349	218745	64	36	105612
1587	208308	64	28	62853
1818	186550	123	34	125976
2500	215974	134	40	79146
2153	219705	74	35	118645
1491	141993	63	25	99971
2402	227667	65	45	77826
893	73566	32	23	22618
2088	229355	76	45	84892
1593	181728	50	38	92059
1638	161629	57	38	77993
2143	328393	74	41	104155
2264	288008	86	36	109840
1735	202410	103	37	238712
2110	184970	60	38	67486
1601	168990	60	37	68007
1609	146441	44	25	48194
3458	404418	106	45	134796
1358	145916	67	26	38692
2192	266992	97	44	93587
870	80953	25	8	56622
1737	135658	51	27	15986
1181	145468	53	35	113402
3409	334352	174	37	97967
2339	279518	102	57	74844
3016	175232	101	41	136051
2204	237176	86	37	50548
1924	215300	71	38	112215
1651	167587	60	31	59591
2916	256299	71	36	59938
2263	278086	74	36	137639
1522	178489	36	32	143372
1562	215379	49	35	138599
1954	271106	73	35	174110
3726	363714	140	58	135062
3409	375100	105	30	175681
2341	256086	111	45	130307
2148	268556	62	37	139141
1962	182910	171	36	44244
602	43287	14	19	43750
2099	184069	76	23	48029
1866	193549	127	39	95216
2535	259498	46	40	92288
2586	295230	86	40	94588
974	106655	57	23	197426
3026	151612	82	41	151244
1846	304890	65	40	139206
2205	283225	81	43	106271
398	23623	11	1	1168
1821	174970	69	36	71764
530	61857	25	11	25162
1571	154990	48	44	45635
2747	358662	105	34	101817
387	21054	16	0	855
1976	239794	48	28	100174
450	31414	20	8	14116
3214	294582	109	39	85008
1878	217893	59	44	124254
1490	165013	80	43	105793
1562	142934	51	28	117129
568	38214	34	8	8773
1794	185597	39	39	94747
2617	339082	78	47	107549
1224	186273	57	48	97392
3385	385366	77	46	126893
2236	282568	95	48	118850
3192	381104	116	50	234853
1245	187978	35	40	74783
1079	98495	41	32	66089
2734	276677	305	38	95684
3941	390304	159	46	139537
1520	118152	46	35	144253
3907	371020	127	42	153824
1795	152198	75	38	63995
1627	236370	46	41	84891
2094	207837	83	42	61263
1638	193297	110	32	106221
3716	353301	111	36	113587
2023	224936	81	35	113864
2035	173260	63	21	37238
2743	306150	96	45	119906
1623	131872	54	49	135096
2305	209639	77	36	151611
2341	269828	98	43	144645
2	1	0	0	0
207	14688	10	0	6023
5	98	1	0	0
8	455	2	0	0
0	0	0	0	0
0	0	0	0	0
1853	206943	81	37	77457
2964	347930	135	47	62464
0	0	0	0	0
4	203	4	0	0
151	7199	5	0	1644
474	46660	20	5	6179
141	17547	5	1	3926
990	108513	40	38	42087
29	969	2	0	0
1581	182311	61	28	87656




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

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







Goodness of Fit
Correlation0.7318
R-squared0.5355
RMSE32269.2594

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7318[/C][/ROW]
[ROW][C]R-squared[/C][C]0.5355[/C][/ROW]
[ROW][C]RMSE[/C][C]32269.2594[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154642&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154642&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.7318
R-squared0.5355
RMSE32269.2594







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
112425290085.397727272734166.6022727273
29895690085.39772727278870.60227272728
39807390085.39772727277987.60227272728
410681690085.397727272716730.6022727273
54144990085.3977272727-48636.3977272727
6761733839237781
717755112122456327
82280738392-15585
912693890085.397727272736852.6022727273
106168090085.3977272727-28405.3977272727
1172117121224-49107
127973890085.3977272727-10347.3977272727
135779390085.3977272727-32292.3977272727
1491677121224-29547
156463190085.3977272727-25454.3977272727
16106385121224-14839
1716196112122440737
18112669121224-8555
1911402990085.397727272723943.6022727273
2012455090085.397727272734464.6022727273
21105416121224-15808
2272875121224-48349
238196490085.3977272727-8121.39772727272
2410488090085.397727272714794.6022727273
257630290085.3977272727-13783.3977272727
269674090085.39772727276654.60227272728
279307190085.39772727272985.60227272728
287891290085.3977272727-11173.3977272727
293522490085.3977272727-54861.3977272727
3090694121224-30530
3112536990085.397727272735283.6022727273
328084990085.3977272727-9236.39772727272
33104434121224-16790
34657023839227310
35108179121224-13045
366358390085.3977272727-26502.3977272727
3795066121224-26158
386248690085.3977272727-27599.3977272727
393108190085.3977272727-59004.3977272727
4094584121224-26640
4187408121224-33816
426896690085.3977272727-21119.3977272727
438876690085.3977272727-1319.39772727272
445713990085.3977272727-32946.3977272727
459058690085.3977272727500.602272727279
46109249121224-11975
473303238392-5360
489605690085.39772727275970.60227272728
4914664812122425424
508061390085.3977272727-9472.39772727272
518702690085.3977272727-3059.39772727272
5259501716.333333333334233.66666666667
531311061212249882
543255138392-5841
553170138392-6691
569107290085.3977272727986.60227272728
5715980312122438579
5814395012122422726
59112368121224-8856
608212490085.3977272727-7961.39772727272
6114406812122422844
6216262712122441403
635506290085.3977272727-35023.3977272727
649532990085.39772727275243.60227272728
6510561290085.397727272715526.6022727273
666285390085.3977272727-27232.3977272727
6712597690085.397727272735890.6022727273
687914690085.3977272727-10939.3977272727
6911864590085.397727272728559.6022727273
709997190085.39772727279885.60227272728
717782690085.3977272727-12259.3977272727
722261838392-15774
738489290085.3977272727-5193.39772727272
749205990085.39772727271973.60227272728
757799390085.3977272727-12092.3977272727
76104155121224-17069
77109840121224-11384
7823871290085.3977272727148626.602272727
796748690085.3977272727-22599.3977272727
806800790085.3977272727-22078.3977272727
814819490085.3977272727-41891.3977272727
8213479612122413572
833869290085.3977272727-51393.3977272727
849358790085.39772727273501.60227272728
85566223839218230
861598690085.3977272727-74099.3977272727
8711340290085.397727272723316.6022727273
8897967121224-23257
8974844121224-46380
9013605190085.397727272745965.6022727273
915054890085.3977272727-39537.3977272727
9211221590085.397727272722129.6022727273
935959190085.3977272727-30494.3977272727
945993890085.3977272727-30147.3977272727
9513763912122416415
9614337290085.397727272753286.6022727273
9713859990085.397727272748513.6022727273
9817411012122452886
9913506212122413838
10017568112122454457
10113030790085.397727272740221.6022727273
10213914112122417917
1034424490085.3977272727-45841.3977272727
10443750383925358
1054802990085.3977272727-42056.3977272727
1069521690085.39772727275130.60227272728
1079228890085.39772727272202.60227272728
10894588121224-26636
10919742690085.3977272727107340.602272727
11015124490085.397727272761158.6022727273
11113920612122417982
112106271121224-14953
11311681716.33333333333-548.333333333333
1147176490085.3977272727-18321.3977272727
1152516238392-13230
1164563590085.3977272727-44450.3977272727
117101817121224-19407
1188551716.33333333333-861.333333333333
11910017490085.397727272710088.6022727273
1201411638392-24276
12185008121224-36216
12212425490085.397727272734168.6022727273
12310579390085.397727272715707.6022727273
12411712990085.397727272727043.6022727273
125877338392-29619
1269474790085.39772727274661.60227272728
127107549121224-13675
1289739290085.39772727277306.60227272728
1291268931212245669
130118850121224-2374
131234853121224113629
1327478390085.3977272727-15302.3977272727
133660893839227697
13495684121224-25540
13513953712122418313
13614425390085.397727272754167.6022727273
13715382412122432600
1386399590085.3977272727-26090.3977272727
1398489190085.3977272727-5194.39772727272
1406126390085.3977272727-28822.3977272727
14110622190085.397727272716135.6022727273
142113587121224-7637
14311386490085.397727272723778.6022727273
1443723890085.3977272727-52847.3977272727
145119906121224-1318
14613509690085.397727272745010.6022727273
14715161190085.397727272761525.6022727273
14814464512122423421
14901716.33333333333-1716.33333333333
15060231716.333333333334306.66666666667
15101716.33333333333-1716.33333333333
15201716.33333333333-1716.33333333333
15301716.33333333333-1716.33333333333
15401716.33333333333-1716.33333333333
1557745790085.3977272727-12628.3977272727
15662464121224-58760
15701716.33333333333-1716.33333333333
15801716.33333333333-1716.33333333333
15916441716.33333333333-72.3333333333333
16061791716.333333333334462.66666666667
16139261716.333333333332209.66666666667
1624208790085.3977272727-47998.3977272727
16301716.33333333333-1716.33333333333
1648765690085.3977272727-2429.39772727272

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 124252 & 90085.3977272727 & 34166.6022727273 \tabularnewline
2 & 98956 & 90085.3977272727 & 8870.60227272728 \tabularnewline
3 & 98073 & 90085.3977272727 & 7987.60227272728 \tabularnewline
4 & 106816 & 90085.3977272727 & 16730.6022727273 \tabularnewline
5 & 41449 & 90085.3977272727 & -48636.3977272727 \tabularnewline
6 & 76173 & 38392 & 37781 \tabularnewline
7 & 177551 & 121224 & 56327 \tabularnewline
8 & 22807 & 38392 & -15585 \tabularnewline
9 & 126938 & 90085.3977272727 & 36852.6022727273 \tabularnewline
10 & 61680 & 90085.3977272727 & -28405.3977272727 \tabularnewline
11 & 72117 & 121224 & -49107 \tabularnewline
12 & 79738 & 90085.3977272727 & -10347.3977272727 \tabularnewline
13 & 57793 & 90085.3977272727 & -32292.3977272727 \tabularnewline
14 & 91677 & 121224 & -29547 \tabularnewline
15 & 64631 & 90085.3977272727 & -25454.3977272727 \tabularnewline
16 & 106385 & 121224 & -14839 \tabularnewline
17 & 161961 & 121224 & 40737 \tabularnewline
18 & 112669 & 121224 & -8555 \tabularnewline
19 & 114029 & 90085.3977272727 & 23943.6022727273 \tabularnewline
20 & 124550 & 90085.3977272727 & 34464.6022727273 \tabularnewline
21 & 105416 & 121224 & -15808 \tabularnewline
22 & 72875 & 121224 & -48349 \tabularnewline
23 & 81964 & 90085.3977272727 & -8121.39772727272 \tabularnewline
24 & 104880 & 90085.3977272727 & 14794.6022727273 \tabularnewline
25 & 76302 & 90085.3977272727 & -13783.3977272727 \tabularnewline
26 & 96740 & 90085.3977272727 & 6654.60227272728 \tabularnewline
27 & 93071 & 90085.3977272727 & 2985.60227272728 \tabularnewline
28 & 78912 & 90085.3977272727 & -11173.3977272727 \tabularnewline
29 & 35224 & 90085.3977272727 & -54861.3977272727 \tabularnewline
30 & 90694 & 121224 & -30530 \tabularnewline
31 & 125369 & 90085.3977272727 & 35283.6022727273 \tabularnewline
32 & 80849 & 90085.3977272727 & -9236.39772727272 \tabularnewline
33 & 104434 & 121224 & -16790 \tabularnewline
34 & 65702 & 38392 & 27310 \tabularnewline
35 & 108179 & 121224 & -13045 \tabularnewline
36 & 63583 & 90085.3977272727 & -26502.3977272727 \tabularnewline
37 & 95066 & 121224 & -26158 \tabularnewline
38 & 62486 & 90085.3977272727 & -27599.3977272727 \tabularnewline
39 & 31081 & 90085.3977272727 & -59004.3977272727 \tabularnewline
40 & 94584 & 121224 & -26640 \tabularnewline
41 & 87408 & 121224 & -33816 \tabularnewline
42 & 68966 & 90085.3977272727 & -21119.3977272727 \tabularnewline
43 & 88766 & 90085.3977272727 & -1319.39772727272 \tabularnewline
44 & 57139 & 90085.3977272727 & -32946.3977272727 \tabularnewline
45 & 90586 & 90085.3977272727 & 500.602272727279 \tabularnewline
46 & 109249 & 121224 & -11975 \tabularnewline
47 & 33032 & 38392 & -5360 \tabularnewline
48 & 96056 & 90085.3977272727 & 5970.60227272728 \tabularnewline
49 & 146648 & 121224 & 25424 \tabularnewline
50 & 80613 & 90085.3977272727 & -9472.39772727272 \tabularnewline
51 & 87026 & 90085.3977272727 & -3059.39772727272 \tabularnewline
52 & 5950 & 1716.33333333333 & 4233.66666666667 \tabularnewline
53 & 131106 & 121224 & 9882 \tabularnewline
54 & 32551 & 38392 & -5841 \tabularnewline
55 & 31701 & 38392 & -6691 \tabularnewline
56 & 91072 & 90085.3977272727 & 986.60227272728 \tabularnewline
57 & 159803 & 121224 & 38579 \tabularnewline
58 & 143950 & 121224 & 22726 \tabularnewline
59 & 112368 & 121224 & -8856 \tabularnewline
60 & 82124 & 90085.3977272727 & -7961.39772727272 \tabularnewline
61 & 144068 & 121224 & 22844 \tabularnewline
62 & 162627 & 121224 & 41403 \tabularnewline
63 & 55062 & 90085.3977272727 & -35023.3977272727 \tabularnewline
64 & 95329 & 90085.3977272727 & 5243.60227272728 \tabularnewline
65 & 105612 & 90085.3977272727 & 15526.6022727273 \tabularnewline
66 & 62853 & 90085.3977272727 & -27232.3977272727 \tabularnewline
67 & 125976 & 90085.3977272727 & 35890.6022727273 \tabularnewline
68 & 79146 & 90085.3977272727 & -10939.3977272727 \tabularnewline
69 & 118645 & 90085.3977272727 & 28559.6022727273 \tabularnewline
70 & 99971 & 90085.3977272727 & 9885.60227272728 \tabularnewline
71 & 77826 & 90085.3977272727 & -12259.3977272727 \tabularnewline
72 & 22618 & 38392 & -15774 \tabularnewline
73 & 84892 & 90085.3977272727 & -5193.39772727272 \tabularnewline
74 & 92059 & 90085.3977272727 & 1973.60227272728 \tabularnewline
75 & 77993 & 90085.3977272727 & -12092.3977272727 \tabularnewline
76 & 104155 & 121224 & -17069 \tabularnewline
77 & 109840 & 121224 & -11384 \tabularnewline
78 & 238712 & 90085.3977272727 & 148626.602272727 \tabularnewline
79 & 67486 & 90085.3977272727 & -22599.3977272727 \tabularnewline
80 & 68007 & 90085.3977272727 & -22078.3977272727 \tabularnewline
81 & 48194 & 90085.3977272727 & -41891.3977272727 \tabularnewline
82 & 134796 & 121224 & 13572 \tabularnewline
83 & 38692 & 90085.3977272727 & -51393.3977272727 \tabularnewline
84 & 93587 & 90085.3977272727 & 3501.60227272728 \tabularnewline
85 & 56622 & 38392 & 18230 \tabularnewline
86 & 15986 & 90085.3977272727 & -74099.3977272727 \tabularnewline
87 & 113402 & 90085.3977272727 & 23316.6022727273 \tabularnewline
88 & 97967 & 121224 & -23257 \tabularnewline
89 & 74844 & 121224 & -46380 \tabularnewline
90 & 136051 & 90085.3977272727 & 45965.6022727273 \tabularnewline
91 & 50548 & 90085.3977272727 & -39537.3977272727 \tabularnewline
92 & 112215 & 90085.3977272727 & 22129.6022727273 \tabularnewline
93 & 59591 & 90085.3977272727 & -30494.3977272727 \tabularnewline
94 & 59938 & 90085.3977272727 & -30147.3977272727 \tabularnewline
95 & 137639 & 121224 & 16415 \tabularnewline
96 & 143372 & 90085.3977272727 & 53286.6022727273 \tabularnewline
97 & 138599 & 90085.3977272727 & 48513.6022727273 \tabularnewline
98 & 174110 & 121224 & 52886 \tabularnewline
99 & 135062 & 121224 & 13838 \tabularnewline
100 & 175681 & 121224 & 54457 \tabularnewline
101 & 130307 & 90085.3977272727 & 40221.6022727273 \tabularnewline
102 & 139141 & 121224 & 17917 \tabularnewline
103 & 44244 & 90085.3977272727 & -45841.3977272727 \tabularnewline
104 & 43750 & 38392 & 5358 \tabularnewline
105 & 48029 & 90085.3977272727 & -42056.3977272727 \tabularnewline
106 & 95216 & 90085.3977272727 & 5130.60227272728 \tabularnewline
107 & 92288 & 90085.3977272727 & 2202.60227272728 \tabularnewline
108 & 94588 & 121224 & -26636 \tabularnewline
109 & 197426 & 90085.3977272727 & 107340.602272727 \tabularnewline
110 & 151244 & 90085.3977272727 & 61158.6022727273 \tabularnewline
111 & 139206 & 121224 & 17982 \tabularnewline
112 & 106271 & 121224 & -14953 \tabularnewline
113 & 1168 & 1716.33333333333 & -548.333333333333 \tabularnewline
114 & 71764 & 90085.3977272727 & -18321.3977272727 \tabularnewline
115 & 25162 & 38392 & -13230 \tabularnewline
116 & 45635 & 90085.3977272727 & -44450.3977272727 \tabularnewline
117 & 101817 & 121224 & -19407 \tabularnewline
118 & 855 & 1716.33333333333 & -861.333333333333 \tabularnewline
119 & 100174 & 90085.3977272727 & 10088.6022727273 \tabularnewline
120 & 14116 & 38392 & -24276 \tabularnewline
121 & 85008 & 121224 & -36216 \tabularnewline
122 & 124254 & 90085.3977272727 & 34168.6022727273 \tabularnewline
123 & 105793 & 90085.3977272727 & 15707.6022727273 \tabularnewline
124 & 117129 & 90085.3977272727 & 27043.6022727273 \tabularnewline
125 & 8773 & 38392 & -29619 \tabularnewline
126 & 94747 & 90085.3977272727 & 4661.60227272728 \tabularnewline
127 & 107549 & 121224 & -13675 \tabularnewline
128 & 97392 & 90085.3977272727 & 7306.60227272728 \tabularnewline
129 & 126893 & 121224 & 5669 \tabularnewline
130 & 118850 & 121224 & -2374 \tabularnewline
131 & 234853 & 121224 & 113629 \tabularnewline
132 & 74783 & 90085.3977272727 & -15302.3977272727 \tabularnewline
133 & 66089 & 38392 & 27697 \tabularnewline
134 & 95684 & 121224 & -25540 \tabularnewline
135 & 139537 & 121224 & 18313 \tabularnewline
136 & 144253 & 90085.3977272727 & 54167.6022727273 \tabularnewline
137 & 153824 & 121224 & 32600 \tabularnewline
138 & 63995 & 90085.3977272727 & -26090.3977272727 \tabularnewline
139 & 84891 & 90085.3977272727 & -5194.39772727272 \tabularnewline
140 & 61263 & 90085.3977272727 & -28822.3977272727 \tabularnewline
141 & 106221 & 90085.3977272727 & 16135.6022727273 \tabularnewline
142 & 113587 & 121224 & -7637 \tabularnewline
143 & 113864 & 90085.3977272727 & 23778.6022727273 \tabularnewline
144 & 37238 & 90085.3977272727 & -52847.3977272727 \tabularnewline
145 & 119906 & 121224 & -1318 \tabularnewline
146 & 135096 & 90085.3977272727 & 45010.6022727273 \tabularnewline
147 & 151611 & 90085.3977272727 & 61525.6022727273 \tabularnewline
148 & 144645 & 121224 & 23421 \tabularnewline
149 & 0 & 1716.33333333333 & -1716.33333333333 \tabularnewline
150 & 6023 & 1716.33333333333 & 4306.66666666667 \tabularnewline
151 & 0 & 1716.33333333333 & -1716.33333333333 \tabularnewline
152 & 0 & 1716.33333333333 & -1716.33333333333 \tabularnewline
153 & 0 & 1716.33333333333 & -1716.33333333333 \tabularnewline
154 & 0 & 1716.33333333333 & -1716.33333333333 \tabularnewline
155 & 77457 & 90085.3977272727 & -12628.3977272727 \tabularnewline
156 & 62464 & 121224 & -58760 \tabularnewline
157 & 0 & 1716.33333333333 & -1716.33333333333 \tabularnewline
158 & 0 & 1716.33333333333 & -1716.33333333333 \tabularnewline
159 & 1644 & 1716.33333333333 & -72.3333333333333 \tabularnewline
160 & 6179 & 1716.33333333333 & 4462.66666666667 \tabularnewline
161 & 3926 & 1716.33333333333 & 2209.66666666667 \tabularnewline
162 & 42087 & 90085.3977272727 & -47998.3977272727 \tabularnewline
163 & 0 & 1716.33333333333 & -1716.33333333333 \tabularnewline
164 & 87656 & 90085.3977272727 & -2429.39772727272 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=154642&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]124252[/C][C]90085.3977272727[/C][C]34166.6022727273[/C][/ROW]
[ROW][C]2[/C][C]98956[/C][C]90085.3977272727[/C][C]8870.60227272728[/C][/ROW]
[ROW][C]3[/C][C]98073[/C][C]90085.3977272727[/C][C]7987.60227272728[/C][/ROW]
[ROW][C]4[/C][C]106816[/C][C]90085.3977272727[/C][C]16730.6022727273[/C][/ROW]
[ROW][C]5[/C][C]41449[/C][C]90085.3977272727[/C][C]-48636.3977272727[/C][/ROW]
[ROW][C]6[/C][C]76173[/C][C]38392[/C][C]37781[/C][/ROW]
[ROW][C]7[/C][C]177551[/C][C]121224[/C][C]56327[/C][/ROW]
[ROW][C]8[/C][C]22807[/C][C]38392[/C][C]-15585[/C][/ROW]
[ROW][C]9[/C][C]126938[/C][C]90085.3977272727[/C][C]36852.6022727273[/C][/ROW]
[ROW][C]10[/C][C]61680[/C][C]90085.3977272727[/C][C]-28405.3977272727[/C][/ROW]
[ROW][C]11[/C][C]72117[/C][C]121224[/C][C]-49107[/C][/ROW]
[ROW][C]12[/C][C]79738[/C][C]90085.3977272727[/C][C]-10347.3977272727[/C][/ROW]
[ROW][C]13[/C][C]57793[/C][C]90085.3977272727[/C][C]-32292.3977272727[/C][/ROW]
[ROW][C]14[/C][C]91677[/C][C]121224[/C][C]-29547[/C][/ROW]
[ROW][C]15[/C][C]64631[/C][C]90085.3977272727[/C][C]-25454.3977272727[/C][/ROW]
[ROW][C]16[/C][C]106385[/C][C]121224[/C][C]-14839[/C][/ROW]
[ROW][C]17[/C][C]161961[/C][C]121224[/C][C]40737[/C][/ROW]
[ROW][C]18[/C][C]112669[/C][C]121224[/C][C]-8555[/C][/ROW]
[ROW][C]19[/C][C]114029[/C][C]90085.3977272727[/C][C]23943.6022727273[/C][/ROW]
[ROW][C]20[/C][C]124550[/C][C]90085.3977272727[/C][C]34464.6022727273[/C][/ROW]
[ROW][C]21[/C][C]105416[/C][C]121224[/C][C]-15808[/C][/ROW]
[ROW][C]22[/C][C]72875[/C][C]121224[/C][C]-48349[/C][/ROW]
[ROW][C]23[/C][C]81964[/C][C]90085.3977272727[/C][C]-8121.39772727272[/C][/ROW]
[ROW][C]24[/C][C]104880[/C][C]90085.3977272727[/C][C]14794.6022727273[/C][/ROW]
[ROW][C]25[/C][C]76302[/C][C]90085.3977272727[/C][C]-13783.3977272727[/C][/ROW]
[ROW][C]26[/C][C]96740[/C][C]90085.3977272727[/C][C]6654.60227272728[/C][/ROW]
[ROW][C]27[/C][C]93071[/C][C]90085.3977272727[/C][C]2985.60227272728[/C][/ROW]
[ROW][C]28[/C][C]78912[/C][C]90085.3977272727[/C][C]-11173.3977272727[/C][/ROW]
[ROW][C]29[/C][C]35224[/C][C]90085.3977272727[/C][C]-54861.3977272727[/C][/ROW]
[ROW][C]30[/C][C]90694[/C][C]121224[/C][C]-30530[/C][/ROW]
[ROW][C]31[/C][C]125369[/C][C]90085.3977272727[/C][C]35283.6022727273[/C][/ROW]
[ROW][C]32[/C][C]80849[/C][C]90085.3977272727[/C][C]-9236.39772727272[/C][/ROW]
[ROW][C]33[/C][C]104434[/C][C]121224[/C][C]-16790[/C][/ROW]
[ROW][C]34[/C][C]65702[/C][C]38392[/C][C]27310[/C][/ROW]
[ROW][C]35[/C][C]108179[/C][C]121224[/C][C]-13045[/C][/ROW]
[ROW][C]36[/C][C]63583[/C][C]90085.3977272727[/C][C]-26502.3977272727[/C][/ROW]
[ROW][C]37[/C][C]95066[/C][C]121224[/C][C]-26158[/C][/ROW]
[ROW][C]38[/C][C]62486[/C][C]90085.3977272727[/C][C]-27599.3977272727[/C][/ROW]
[ROW][C]39[/C][C]31081[/C][C]90085.3977272727[/C][C]-59004.3977272727[/C][/ROW]
[ROW][C]40[/C][C]94584[/C][C]121224[/C][C]-26640[/C][/ROW]
[ROW][C]41[/C][C]87408[/C][C]121224[/C][C]-33816[/C][/ROW]
[ROW][C]42[/C][C]68966[/C][C]90085.3977272727[/C][C]-21119.3977272727[/C][/ROW]
[ROW][C]43[/C][C]88766[/C][C]90085.3977272727[/C][C]-1319.39772727272[/C][/ROW]
[ROW][C]44[/C][C]57139[/C][C]90085.3977272727[/C][C]-32946.3977272727[/C][/ROW]
[ROW][C]45[/C][C]90586[/C][C]90085.3977272727[/C][C]500.602272727279[/C][/ROW]
[ROW][C]46[/C][C]109249[/C][C]121224[/C][C]-11975[/C][/ROW]
[ROW][C]47[/C][C]33032[/C][C]38392[/C][C]-5360[/C][/ROW]
[ROW][C]48[/C][C]96056[/C][C]90085.3977272727[/C][C]5970.60227272728[/C][/ROW]
[ROW][C]49[/C][C]146648[/C][C]121224[/C][C]25424[/C][/ROW]
[ROW][C]50[/C][C]80613[/C][C]90085.3977272727[/C][C]-9472.39772727272[/C][/ROW]
[ROW][C]51[/C][C]87026[/C][C]90085.3977272727[/C][C]-3059.39772727272[/C][/ROW]
[ROW][C]52[/C][C]5950[/C][C]1716.33333333333[/C][C]4233.66666666667[/C][/ROW]
[ROW][C]53[/C][C]131106[/C][C]121224[/C][C]9882[/C][/ROW]
[ROW][C]54[/C][C]32551[/C][C]38392[/C][C]-5841[/C][/ROW]
[ROW][C]55[/C][C]31701[/C][C]38392[/C][C]-6691[/C][/ROW]
[ROW][C]56[/C][C]91072[/C][C]90085.3977272727[/C][C]986.60227272728[/C][/ROW]
[ROW][C]57[/C][C]159803[/C][C]121224[/C][C]38579[/C][/ROW]
[ROW][C]58[/C][C]143950[/C][C]121224[/C][C]22726[/C][/ROW]
[ROW][C]59[/C][C]112368[/C][C]121224[/C][C]-8856[/C][/ROW]
[ROW][C]60[/C][C]82124[/C][C]90085.3977272727[/C][C]-7961.39772727272[/C][/ROW]
[ROW][C]61[/C][C]144068[/C][C]121224[/C][C]22844[/C][/ROW]
[ROW][C]62[/C][C]162627[/C][C]121224[/C][C]41403[/C][/ROW]
[ROW][C]63[/C][C]55062[/C][C]90085.3977272727[/C][C]-35023.3977272727[/C][/ROW]
[ROW][C]64[/C][C]95329[/C][C]90085.3977272727[/C][C]5243.60227272728[/C][/ROW]
[ROW][C]65[/C][C]105612[/C][C]90085.3977272727[/C][C]15526.6022727273[/C][/ROW]
[ROW][C]66[/C][C]62853[/C][C]90085.3977272727[/C][C]-27232.3977272727[/C][/ROW]
[ROW][C]67[/C][C]125976[/C][C]90085.3977272727[/C][C]35890.6022727273[/C][/ROW]
[ROW][C]68[/C][C]79146[/C][C]90085.3977272727[/C][C]-10939.3977272727[/C][/ROW]
[ROW][C]69[/C][C]118645[/C][C]90085.3977272727[/C][C]28559.6022727273[/C][/ROW]
[ROW][C]70[/C][C]99971[/C][C]90085.3977272727[/C][C]9885.60227272728[/C][/ROW]
[ROW][C]71[/C][C]77826[/C][C]90085.3977272727[/C][C]-12259.3977272727[/C][/ROW]
[ROW][C]72[/C][C]22618[/C][C]38392[/C][C]-15774[/C][/ROW]
[ROW][C]73[/C][C]84892[/C][C]90085.3977272727[/C][C]-5193.39772727272[/C][/ROW]
[ROW][C]74[/C][C]92059[/C][C]90085.3977272727[/C][C]1973.60227272728[/C][/ROW]
[ROW][C]75[/C][C]77993[/C][C]90085.3977272727[/C][C]-12092.3977272727[/C][/ROW]
[ROW][C]76[/C][C]104155[/C][C]121224[/C][C]-17069[/C][/ROW]
[ROW][C]77[/C][C]109840[/C][C]121224[/C][C]-11384[/C][/ROW]
[ROW][C]78[/C][C]238712[/C][C]90085.3977272727[/C][C]148626.602272727[/C][/ROW]
[ROW][C]79[/C][C]67486[/C][C]90085.3977272727[/C][C]-22599.3977272727[/C][/ROW]
[ROW][C]80[/C][C]68007[/C][C]90085.3977272727[/C][C]-22078.3977272727[/C][/ROW]
[ROW][C]81[/C][C]48194[/C][C]90085.3977272727[/C][C]-41891.3977272727[/C][/ROW]
[ROW][C]82[/C][C]134796[/C][C]121224[/C][C]13572[/C][/ROW]
[ROW][C]83[/C][C]38692[/C][C]90085.3977272727[/C][C]-51393.3977272727[/C][/ROW]
[ROW][C]84[/C][C]93587[/C][C]90085.3977272727[/C][C]3501.60227272728[/C][/ROW]
[ROW][C]85[/C][C]56622[/C][C]38392[/C][C]18230[/C][/ROW]
[ROW][C]86[/C][C]15986[/C][C]90085.3977272727[/C][C]-74099.3977272727[/C][/ROW]
[ROW][C]87[/C][C]113402[/C][C]90085.3977272727[/C][C]23316.6022727273[/C][/ROW]
[ROW][C]88[/C][C]97967[/C][C]121224[/C][C]-23257[/C][/ROW]
[ROW][C]89[/C][C]74844[/C][C]121224[/C][C]-46380[/C][/ROW]
[ROW][C]90[/C][C]136051[/C][C]90085.3977272727[/C][C]45965.6022727273[/C][/ROW]
[ROW][C]91[/C][C]50548[/C][C]90085.3977272727[/C][C]-39537.3977272727[/C][/ROW]
[ROW][C]92[/C][C]112215[/C][C]90085.3977272727[/C][C]22129.6022727273[/C][/ROW]
[ROW][C]93[/C][C]59591[/C][C]90085.3977272727[/C][C]-30494.3977272727[/C][/ROW]
[ROW][C]94[/C][C]59938[/C][C]90085.3977272727[/C][C]-30147.3977272727[/C][/ROW]
[ROW][C]95[/C][C]137639[/C][C]121224[/C][C]16415[/C][/ROW]
[ROW][C]96[/C][C]143372[/C][C]90085.3977272727[/C][C]53286.6022727273[/C][/ROW]
[ROW][C]97[/C][C]138599[/C][C]90085.3977272727[/C][C]48513.6022727273[/C][/ROW]
[ROW][C]98[/C][C]174110[/C][C]121224[/C][C]52886[/C][/ROW]
[ROW][C]99[/C][C]135062[/C][C]121224[/C][C]13838[/C][/ROW]
[ROW][C]100[/C][C]175681[/C][C]121224[/C][C]54457[/C][/ROW]
[ROW][C]101[/C][C]130307[/C][C]90085.3977272727[/C][C]40221.6022727273[/C][/ROW]
[ROW][C]102[/C][C]139141[/C][C]121224[/C][C]17917[/C][/ROW]
[ROW][C]103[/C][C]44244[/C][C]90085.3977272727[/C][C]-45841.3977272727[/C][/ROW]
[ROW][C]104[/C][C]43750[/C][C]38392[/C][C]5358[/C][/ROW]
[ROW][C]105[/C][C]48029[/C][C]90085.3977272727[/C][C]-42056.3977272727[/C][/ROW]
[ROW][C]106[/C][C]95216[/C][C]90085.3977272727[/C][C]5130.60227272728[/C][/ROW]
[ROW][C]107[/C][C]92288[/C][C]90085.3977272727[/C][C]2202.60227272728[/C][/ROW]
[ROW][C]108[/C][C]94588[/C][C]121224[/C][C]-26636[/C][/ROW]
[ROW][C]109[/C][C]197426[/C][C]90085.3977272727[/C][C]107340.602272727[/C][/ROW]
[ROW][C]110[/C][C]151244[/C][C]90085.3977272727[/C][C]61158.6022727273[/C][/ROW]
[ROW][C]111[/C][C]139206[/C][C]121224[/C][C]17982[/C][/ROW]
[ROW][C]112[/C][C]106271[/C][C]121224[/C][C]-14953[/C][/ROW]
[ROW][C]113[/C][C]1168[/C][C]1716.33333333333[/C][C]-548.333333333333[/C][/ROW]
[ROW][C]114[/C][C]71764[/C][C]90085.3977272727[/C][C]-18321.3977272727[/C][/ROW]
[ROW][C]115[/C][C]25162[/C][C]38392[/C][C]-13230[/C][/ROW]
[ROW][C]116[/C][C]45635[/C][C]90085.3977272727[/C][C]-44450.3977272727[/C][/ROW]
[ROW][C]117[/C][C]101817[/C][C]121224[/C][C]-19407[/C][/ROW]
[ROW][C]118[/C][C]855[/C][C]1716.33333333333[/C][C]-861.333333333333[/C][/ROW]
[ROW][C]119[/C][C]100174[/C][C]90085.3977272727[/C][C]10088.6022727273[/C][/ROW]
[ROW][C]120[/C][C]14116[/C][C]38392[/C][C]-24276[/C][/ROW]
[ROW][C]121[/C][C]85008[/C][C]121224[/C][C]-36216[/C][/ROW]
[ROW][C]122[/C][C]124254[/C][C]90085.3977272727[/C][C]34168.6022727273[/C][/ROW]
[ROW][C]123[/C][C]105793[/C][C]90085.3977272727[/C][C]15707.6022727273[/C][/ROW]
[ROW][C]124[/C][C]117129[/C][C]90085.3977272727[/C][C]27043.6022727273[/C][/ROW]
[ROW][C]125[/C][C]8773[/C][C]38392[/C][C]-29619[/C][/ROW]
[ROW][C]126[/C][C]94747[/C][C]90085.3977272727[/C][C]4661.60227272728[/C][/ROW]
[ROW][C]127[/C][C]107549[/C][C]121224[/C][C]-13675[/C][/ROW]
[ROW][C]128[/C][C]97392[/C][C]90085.3977272727[/C][C]7306.60227272728[/C][/ROW]
[ROW][C]129[/C][C]126893[/C][C]121224[/C][C]5669[/C][/ROW]
[ROW][C]130[/C][C]118850[/C][C]121224[/C][C]-2374[/C][/ROW]
[ROW][C]131[/C][C]234853[/C][C]121224[/C][C]113629[/C][/ROW]
[ROW][C]132[/C][C]74783[/C][C]90085.3977272727[/C][C]-15302.3977272727[/C][/ROW]
[ROW][C]133[/C][C]66089[/C][C]38392[/C][C]27697[/C][/ROW]
[ROW][C]134[/C][C]95684[/C][C]121224[/C][C]-25540[/C][/ROW]
[ROW][C]135[/C][C]139537[/C][C]121224[/C][C]18313[/C][/ROW]
[ROW][C]136[/C][C]144253[/C][C]90085.3977272727[/C][C]54167.6022727273[/C][/ROW]
[ROW][C]137[/C][C]153824[/C][C]121224[/C][C]32600[/C][/ROW]
[ROW][C]138[/C][C]63995[/C][C]90085.3977272727[/C][C]-26090.3977272727[/C][/ROW]
[ROW][C]139[/C][C]84891[/C][C]90085.3977272727[/C][C]-5194.39772727272[/C][/ROW]
[ROW][C]140[/C][C]61263[/C][C]90085.3977272727[/C][C]-28822.3977272727[/C][/ROW]
[ROW][C]141[/C][C]106221[/C][C]90085.3977272727[/C][C]16135.6022727273[/C][/ROW]
[ROW][C]142[/C][C]113587[/C][C]121224[/C][C]-7637[/C][/ROW]
[ROW][C]143[/C][C]113864[/C][C]90085.3977272727[/C][C]23778.6022727273[/C][/ROW]
[ROW][C]144[/C][C]37238[/C][C]90085.3977272727[/C][C]-52847.3977272727[/C][/ROW]
[ROW][C]145[/C][C]119906[/C][C]121224[/C][C]-1318[/C][/ROW]
[ROW][C]146[/C][C]135096[/C][C]90085.3977272727[/C][C]45010.6022727273[/C][/ROW]
[ROW][C]147[/C][C]151611[/C][C]90085.3977272727[/C][C]61525.6022727273[/C][/ROW]
[ROW][C]148[/C][C]144645[/C][C]121224[/C][C]23421[/C][/ROW]
[ROW][C]149[/C][C]0[/C][C]1716.33333333333[/C][C]-1716.33333333333[/C][/ROW]
[ROW][C]150[/C][C]6023[/C][C]1716.33333333333[/C][C]4306.66666666667[/C][/ROW]
[ROW][C]151[/C][C]0[/C][C]1716.33333333333[/C][C]-1716.33333333333[/C][/ROW]
[ROW][C]152[/C][C]0[/C][C]1716.33333333333[/C][C]-1716.33333333333[/C][/ROW]
[ROW][C]153[/C][C]0[/C][C]1716.33333333333[/C][C]-1716.33333333333[/C][/ROW]
[ROW][C]154[/C][C]0[/C][C]1716.33333333333[/C][C]-1716.33333333333[/C][/ROW]
[ROW][C]155[/C][C]77457[/C][C]90085.3977272727[/C][C]-12628.3977272727[/C][/ROW]
[ROW][C]156[/C][C]62464[/C][C]121224[/C][C]-58760[/C][/ROW]
[ROW][C]157[/C][C]0[/C][C]1716.33333333333[/C][C]-1716.33333333333[/C][/ROW]
[ROW][C]158[/C][C]0[/C][C]1716.33333333333[/C][C]-1716.33333333333[/C][/ROW]
[ROW][C]159[/C][C]1644[/C][C]1716.33333333333[/C][C]-72.3333333333333[/C][/ROW]
[ROW][C]160[/C][C]6179[/C][C]1716.33333333333[/C][C]4462.66666666667[/C][/ROW]
[ROW][C]161[/C][C]3926[/C][C]1716.33333333333[/C][C]2209.66666666667[/C][/ROW]
[ROW][C]162[/C][C]42087[/C][C]90085.3977272727[/C][C]-47998.3977272727[/C][/ROW]
[ROW][C]163[/C][C]0[/C][C]1716.33333333333[/C][C]-1716.33333333333[/C][/ROW]
[ROW][C]164[/C][C]87656[/C][C]90085.3977272727[/C][C]-2429.39772727272[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=154642&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=154642&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
112425290085.397727272734166.6022727273
29895690085.39772727278870.60227272728
39807390085.39772727277987.60227272728
410681690085.397727272716730.6022727273
54144990085.3977272727-48636.3977272727
6761733839237781
717755112122456327
82280738392-15585
912693890085.397727272736852.6022727273
106168090085.3977272727-28405.3977272727
1172117121224-49107
127973890085.3977272727-10347.3977272727
135779390085.3977272727-32292.3977272727
1491677121224-29547
156463190085.3977272727-25454.3977272727
16106385121224-14839
1716196112122440737
18112669121224-8555
1911402990085.397727272723943.6022727273
2012455090085.397727272734464.6022727273
21105416121224-15808
2272875121224-48349
238196490085.3977272727-8121.39772727272
2410488090085.397727272714794.6022727273
257630290085.3977272727-13783.3977272727
269674090085.39772727276654.60227272728
279307190085.39772727272985.60227272728
287891290085.3977272727-11173.3977272727
293522490085.3977272727-54861.3977272727
3090694121224-30530
3112536990085.397727272735283.6022727273
328084990085.3977272727-9236.39772727272
33104434121224-16790
34657023839227310
35108179121224-13045
366358390085.3977272727-26502.3977272727
3795066121224-26158
386248690085.3977272727-27599.3977272727
393108190085.3977272727-59004.3977272727
4094584121224-26640
4187408121224-33816
426896690085.3977272727-21119.3977272727
438876690085.3977272727-1319.39772727272
445713990085.3977272727-32946.3977272727
459058690085.3977272727500.602272727279
46109249121224-11975
473303238392-5360
489605690085.39772727275970.60227272728
4914664812122425424
508061390085.3977272727-9472.39772727272
518702690085.3977272727-3059.39772727272
5259501716.333333333334233.66666666667
531311061212249882
543255138392-5841
553170138392-6691
569107290085.3977272727986.60227272728
5715980312122438579
5814395012122422726
59112368121224-8856
608212490085.3977272727-7961.39772727272
6114406812122422844
6216262712122441403
635506290085.3977272727-35023.3977272727
649532990085.39772727275243.60227272728
6510561290085.397727272715526.6022727273
666285390085.3977272727-27232.3977272727
6712597690085.397727272735890.6022727273
687914690085.3977272727-10939.3977272727
6911864590085.397727272728559.6022727273
709997190085.39772727279885.60227272728
717782690085.3977272727-12259.3977272727
722261838392-15774
738489290085.3977272727-5193.39772727272
749205990085.39772727271973.60227272728
757799390085.3977272727-12092.3977272727
76104155121224-17069
77109840121224-11384
7823871290085.3977272727148626.602272727
796748690085.3977272727-22599.3977272727
806800790085.3977272727-22078.3977272727
814819490085.3977272727-41891.3977272727
8213479612122413572
833869290085.3977272727-51393.3977272727
849358790085.39772727273501.60227272728
85566223839218230
861598690085.3977272727-74099.3977272727
8711340290085.397727272723316.6022727273
8897967121224-23257
8974844121224-46380
9013605190085.397727272745965.6022727273
915054890085.3977272727-39537.3977272727
9211221590085.397727272722129.6022727273
935959190085.3977272727-30494.3977272727
945993890085.3977272727-30147.3977272727
9513763912122416415
9614337290085.397727272753286.6022727273
9713859990085.397727272748513.6022727273
9817411012122452886
9913506212122413838
10017568112122454457
10113030790085.397727272740221.6022727273
10213914112122417917
1034424490085.3977272727-45841.3977272727
10443750383925358
1054802990085.3977272727-42056.3977272727
1069521690085.39772727275130.60227272728
1079228890085.39772727272202.60227272728
10894588121224-26636
10919742690085.3977272727107340.602272727
11015124490085.397727272761158.6022727273
11113920612122417982
112106271121224-14953
11311681716.33333333333-548.333333333333
1147176490085.3977272727-18321.3977272727
1152516238392-13230
1164563590085.3977272727-44450.3977272727
117101817121224-19407
1188551716.33333333333-861.333333333333
11910017490085.397727272710088.6022727273
1201411638392-24276
12185008121224-36216
12212425490085.397727272734168.6022727273
12310579390085.397727272715707.6022727273
12411712990085.397727272727043.6022727273
125877338392-29619
1269474790085.39772727274661.60227272728
127107549121224-13675
1289739290085.39772727277306.60227272728
1291268931212245669
130118850121224-2374
131234853121224113629
1327478390085.3977272727-15302.3977272727
133660893839227697
13495684121224-25540
13513953712122418313
13614425390085.397727272754167.6022727273
13715382412122432600
1386399590085.3977272727-26090.3977272727
1398489190085.3977272727-5194.39772727272
1406126390085.3977272727-28822.3977272727
14110622190085.397727272716135.6022727273
142113587121224-7637
14311386490085.397727272723778.6022727273
1443723890085.3977272727-52847.3977272727
145119906121224-1318
14613509690085.397727272745010.6022727273
14715161190085.397727272761525.6022727273
14814464512122423421
14901716.33333333333-1716.33333333333
15060231716.333333333334306.66666666667
15101716.33333333333-1716.33333333333
15201716.33333333333-1716.33333333333
15301716.33333333333-1716.33333333333
15401716.33333333333-1716.33333333333
1557745790085.3977272727-12628.3977272727
15662464121224-58760
15701716.33333333333-1716.33333333333
15801716.33333333333-1716.33333333333
15916441716.33333333333-72.3333333333333
16061791716.333333333334462.66666666667
16139261716.333333333332209.66666666667
1624208790085.3977272727-47998.3977272727
16301716.33333333333-1716.33333333333
1648765690085.3977272727-2429.39772727272



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