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 16:54:13 -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/t1323986069oi7xsa1drcp9zrx.htm/, Retrieved Wed, 08 May 2024 18:44:39 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=155727, Retrieved Wed, 08 May 2024 18:44:39 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact137
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [Recursive Partitioning (Regression Trees)] [rp] [2011-12-15 21:54:13] [685fae5a377cc1dc51f9f02306b751ce] [Current]
Feedback Forum

Post a new message
Dataseries X:
1407	118540	74	440	15	18158
1072	127145	44	306	16	30461
192	7215	18	72	0	1423
2032	112861	84	584	22	25629
3032	197581	120	1013	25	48758
5519	377410	209	1506	26	129230
1321	117604	49	442	19	27376
1034	120102	44	274	25	26706
1388	96175	36	382	25	26505
2552	253517	85	812	26	49801
1735	108994	65	546	20	46580
1788	156212	58	551	25	48352
1292	68810	84	477	15	13899
2362	149246	83	799	21	39342
1150	125503	42	330	12	27465
1374	125769	67	419	19	55211
1503	123467	49	364	28	74098
965	56088	45	277	12	13497
2164	108128	73	658	28	38338
633	22762	20	188	13	52505
837	48554	48	286	14	10663
1991	159102	78	575	23	74484
1450	139108	57	514	25	28895
1765	92058	43	525	30	32827
1612	126311	69	516	17	36188
1173	113807	21	426	17	28173
1602	133994	132	509	21	54926
1046	131810	71	248	24	38900
2176	279065	96	724	22	88530
1767	158146	35	733	16	35482
1167	107352	36	374	23	26730
1394	149827	37	471	18	29806
1733	90912	83	549	11	41799
2374	169510	96	721	20	54289
1852	162204	40	596	20	36805
1	0	1	0	0	0
1677	163310	53	778	24	33146
1505	92342	46	464	14	23333
1813	98357	40	417	29	47686
1648	178277	49	607	31	77783
1560	134927	53	495	15	36042
1301	104577	46	489	30	34541
784	81614	23	281	20	75620
1580	119111	60	603	20	60610
896	83923	39	278	18	55041
959	109885	71	246	19	32087
567	52851	24	162	28	16356
1519	153621	73	525	18	40161
1625	152572	74	506	26	55459
1817	114073	44	677	23	36679
658	48188	28	205	22	22346
1187	90994	52	306	19	27377
1863	215588	61	680	20	50273
1559	176489	64	533	25	32104
1340	138871	46	487	27	27016
1342	104416	44	418	10	19715
1505	156186	54	401	26	33629
669	60368	16	189	21	27084
814	95391	53	275	19	32352
2189	126048	65	738	32	51845
1291	96388	44	369	28	26591
1378	77353	58	490	16	29677
978	79872	41	298	16	54237
823	79772	27	259	20	20284
789	96945	22	268	20	22741
1134	88300	34	364	24	34178
1875	126203	59	426	31	69551
2289	110681	56	689	21	29653
817	81299	29	208	21	38071
340	31970	15	101	21	4157
2354	185321	101	809	15	28321
992	87611	51	293	9	40195
976	73021	50	327	21	48158
1357	82167	56	405	18	13310
1958	101152	42	508	27	78474
933	49164	29	248	24	6386
1600	105181	48	424	22	31588
1821	105922	71	628	21	61254
816	60138	23	253	21	21152
1121	73422	66	366	26	41272
800	67727	54	190	22	34165
1446	188098	45	515	22	37054
750	51185	23	221	20	12368
1171	84448	28	404	21	23168
662	41956	35	219	19	16380
1284	110827	40	377	19	41242
1980	167055	175	427	25	48259
879	63603	78	209	19	20790
869	64995	42	276	21	34585
1000	93424	36	382	18	35672
1240	97229	32	446	23	52168
1771	112819	60	521	18	53933
917	106460	49	295	19	34474
1042	102220	50	382	12	43753
629	38721	30	253	9	36456
1770	168764	85	569	26	51183
1454	151588	46	441	21	52742
222	19349	11	67	1	3895
1529	125440	77	504	24	37076
1303	101954	48	523	18	24079
552	43803	24	240	4	2325
708	47062	19	219	15	29354
998	104220	43	329	19	30341
872	85939	50	217	20	18992
584	58660	35	136	12	15292
596	27676	22	194	16	5842
926	93448	31	209	21	28918
576	43284	22	151	9	3738
0	0	0	0	0	0
868	64333	23	237	21	95352
736	57050	46	236	17	37478
998	96933	34	323	18	26839
915	70088	46	296	21	26783
782	65494	55	267	17	33392
78	3616	5	14	0	0
0	0	0	0	0	0
782	135104	33	261	19	25446
1159	95554	60	391	26	60038
1646	120307	77	469	25	28162
749	84336	32	243	20	33298
778	43410	19	292	1	2781
1335	131452	55	400	21	37121
806	79015	33	217	14	22698
1390	88043	40	392	24	27615
680	57578	36	160	12	32689
285	19764	12	75	2	5752
1335	105757	41	412	16	23164
840	96410	22	293	22	20304
1230	105056	30	401	28	34409
256	11796	9	79	2	0
80	7627	8	25	0	0
1162	117413	47	412	17	92538
41	6836	3	11	1	0
1540	131955	37	539	17	46037
42	5118	3	6	0	0
528	40248	16	183	4	5444
0	0	0	0	0	0
799	77813	38	281	21	23924
1086	67140	28	196	24	52230
81	7131	4	27	0	0
61	4194	11	14	0	0
849	60378	20	240	15	8019
970	96971	40	233	18	34542
964	83484	16	347	19	21157




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 4 seconds \tabularnewline
R Server & 'Gertrude Mary Cox' @ cox.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155727&T=0

[TABLE]
[ROW][C]Summary of computational transaction[/C][/ROW]
[ROW][C]Raw Input[/C][C]view raw input (R code) [/C][/ROW]
[ROW][C]Raw Output[/C][C]view raw output of R engine [/C][/ROW]
[ROW][C]Computing time[/C][C]4 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Gertrude Mary Cox' @ cox.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155727&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155727&T=0

As an alternative you can also use a QR Code:  

The GUIDs for individual cells are displayed in the table below:

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net







Goodness of Fit
Correlation0.8954
R-squared0.8017
RMSE307.6131

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.8954[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8017[/C][/ROW]
[ROW][C]RMSE[/C][C]307.6131[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155727&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155727&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.8954
R-squared0.8017
RMSE307.6131







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
114071410.92857142857-3.92857142857133
21072913.885714285714158.114285714286
3192111.93333333333380.0666666666667
420321830.30769230769201.692307692308
530322571.90909090909460.090909090909
655192571.909090909092947.09090909091
713211410.92857142857-89.9285714285713
81034913.885714285714120.114285714286
913881187.875200.125
1025522571.90909090909-19.909090909091
1117351830.30769230769-95.3076923076924
1217881830.30769230769-42.3076923076924
1312921410.92857142857-118.928571428571
1423622571.90909090909-209.909090909091
151150913.885714285714236.114285714286
1613741410.92857142857-36.9285714285713
1715031410.9285714285792.0714285714287
18965777.333333333333187.666666666667
1921641830.30769230769333.692307692308
20633623.7272727272739.27272727272725
21837777.33333333333359.6666666666666
2219911830.30769230769160.692307692308
2314501588.5-138.5
2417651588.5176.5
2516121588.523.5
2611731187.875-14.875
2716021588.513.5
281046913.885714285714132.114285714286
2921762571.90909090909-395.909090909091
3017672571.90909090909-804.909090909091
3111671187.875-20.875
3213941410.92857142857-16.9285714285713
3317331830.30769230769-97.3076923076924
3423742571.90909090909-197.909090909091
3518521830.3076923076921.6923076923076
361111.933333333333-110.933333333333
3716772571.90909090909-894.909090909091
3815051410.9285714285794.0714285714287
3918131410.92857142857402.071428571429
4016481830.30769230769-182.307692307692
4115601588.5-28.5
4213011410.92857142857-109.928571428571
43784913.885714285714-129.885714285714
4415801830.30769230769-250.307692307692
45896913.885714285714-17.8857142857142
46959913.88571428571445.1142857142858
47567623.727272727273-56.7272727272727
4815191588.5-69.5
4916251588.536.5
5018171830.30769230769-13.3076923076924
51658623.72727272727334.2727272727273
521187913.885714285714273.114285714286
5318631830.3076923076932.6923076923076
5415591588.5-29.5
5513401410.92857142857-70.9285714285713
5613421410.92857142857-68.9285714285713
5715051410.9285714285794.0714285714287
58669623.72727272727345.2727272727273
59814913.885714285714-99.8857142857142
6021892571.90909090909-382.909090909091
6112911410.92857142857-119.928571428571
6213781410.92857142857-32.9285714285713
63978913.88571428571464.1142857142858
64823913.885714285714-90.8857142857142
65789913.885714285714-124.885714285714
6611341187.875-53.875
6718751410.92857142857464.071428571429
6822892571.90909090909-282.909090909091
69817913.885714285714-96.8857142857142
70340111.933333333333228.066666666667
7123542571.90909090909-217.909090909091
72992913.88571428571478.1142857142858
73976913.88571428571462.1142857142858
7413571410.92857142857-53.9285714285713
7519581588.5369.5
76933777.333333333333155.666666666667
7716001410.92857142857189.071428571429
7818211830.30769230769-9.30769230769238
79816777.33333333333338.6666666666666
8011211410.92857142857-289.928571428571
81800913.885714285714-113.885714285714
8214461588.5-142.5
83750777.333333333333-27.3333333333334
8411711187.875-16.875
85662623.72727272727338.2727272727273
8612841410.92857142857-126.928571428571
8719801410.92857142857569.071428571429
88879913.885714285714-34.8857142857142
89869913.885714285714-44.8857142857142
9010001187.875-187.875
9112401187.87552.125
9217711588.5182.5
93917913.8857142857143.11428571428576
9410421410.92857142857-368.928571428571
95629777.333333333333-148.333333333333
9617701830.30769230769-60.3076923076924
9714541410.9285714285743.0714285714287
98222111.933333333333110.066666666667
9915291588.5-59.5
10013031588.5-285.5
101552777.333333333333-225.333333333333
102708623.72727272727384.2727272727273
103998913.88571428571484.1142857142858
104872913.885714285714-41.8857142857142
105584623.727272727273-39.7272727272727
106596623.727272727273-27.7272727272727
107926913.88571428571412.1142857142858
108576623.727272727273-47.7272727272727
1090111.933333333333-111.933333333333
110868913.885714285714-45.8857142857142
111736777.333333333333-41.3333333333334
112998913.88571428571484.1142857142858
113915913.8857142857141.11428571428576
114782913.885714285714-131.885714285714
11578111.933333333333-33.9333333333333
1160111.933333333333-111.933333333333
117782913.885714285714-131.885714285714
11811591410.92857142857-251.928571428571
11916461410.92857142857235.071428571429
120749913.885714285714-164.885714285714
121778777.3333333333330.666666666666629
12213351410.92857142857-75.9285714285713
123806913.885714285714-107.885714285714
12413901410.92857142857-20.9285714285713
125680623.72727272727356.2727272727273
126285111.933333333333173.066666666667
12713351410.92857142857-75.9285714285713
128840913.885714285714-73.8857142857142
12912301187.87542.125
130256111.933333333333144.066666666667
13180111.933333333333-31.9333333333333
13211621410.92857142857-248.928571428571
13341111.933333333333-70.9333333333333
13415401588.5-48.5
13542111.933333333333-69.9333333333333
136528623.727272727273-95.7272727272727
1370111.933333333333-111.933333333333
138799913.885714285714-114.885714285714
1391086913.885714285714172.114285714286
14081111.933333333333-30.9333333333333
14161111.933333333333-50.9333333333333
142849913.885714285714-64.8857142857142
143970913.88571428571456.1142857142858
144964913.88571428571450.1142857142858

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 1407 & 1410.92857142857 & -3.92857142857133 \tabularnewline
2 & 1072 & 913.885714285714 & 158.114285714286 \tabularnewline
3 & 192 & 111.933333333333 & 80.0666666666667 \tabularnewline
4 & 2032 & 1830.30769230769 & 201.692307692308 \tabularnewline
5 & 3032 & 2571.90909090909 & 460.090909090909 \tabularnewline
6 & 5519 & 2571.90909090909 & 2947.09090909091 \tabularnewline
7 & 1321 & 1410.92857142857 & -89.9285714285713 \tabularnewline
8 & 1034 & 913.885714285714 & 120.114285714286 \tabularnewline
9 & 1388 & 1187.875 & 200.125 \tabularnewline
10 & 2552 & 2571.90909090909 & -19.909090909091 \tabularnewline
11 & 1735 & 1830.30769230769 & -95.3076923076924 \tabularnewline
12 & 1788 & 1830.30769230769 & -42.3076923076924 \tabularnewline
13 & 1292 & 1410.92857142857 & -118.928571428571 \tabularnewline
14 & 2362 & 2571.90909090909 & -209.909090909091 \tabularnewline
15 & 1150 & 913.885714285714 & 236.114285714286 \tabularnewline
16 & 1374 & 1410.92857142857 & -36.9285714285713 \tabularnewline
17 & 1503 & 1410.92857142857 & 92.0714285714287 \tabularnewline
18 & 965 & 777.333333333333 & 187.666666666667 \tabularnewline
19 & 2164 & 1830.30769230769 & 333.692307692308 \tabularnewline
20 & 633 & 623.727272727273 & 9.27272727272725 \tabularnewline
21 & 837 & 777.333333333333 & 59.6666666666666 \tabularnewline
22 & 1991 & 1830.30769230769 & 160.692307692308 \tabularnewline
23 & 1450 & 1588.5 & -138.5 \tabularnewline
24 & 1765 & 1588.5 & 176.5 \tabularnewline
25 & 1612 & 1588.5 & 23.5 \tabularnewline
26 & 1173 & 1187.875 & -14.875 \tabularnewline
27 & 1602 & 1588.5 & 13.5 \tabularnewline
28 & 1046 & 913.885714285714 & 132.114285714286 \tabularnewline
29 & 2176 & 2571.90909090909 & -395.909090909091 \tabularnewline
30 & 1767 & 2571.90909090909 & -804.909090909091 \tabularnewline
31 & 1167 & 1187.875 & -20.875 \tabularnewline
32 & 1394 & 1410.92857142857 & -16.9285714285713 \tabularnewline
33 & 1733 & 1830.30769230769 & -97.3076923076924 \tabularnewline
34 & 2374 & 2571.90909090909 & -197.909090909091 \tabularnewline
35 & 1852 & 1830.30769230769 & 21.6923076923076 \tabularnewline
36 & 1 & 111.933333333333 & -110.933333333333 \tabularnewline
37 & 1677 & 2571.90909090909 & -894.909090909091 \tabularnewline
38 & 1505 & 1410.92857142857 & 94.0714285714287 \tabularnewline
39 & 1813 & 1410.92857142857 & 402.071428571429 \tabularnewline
40 & 1648 & 1830.30769230769 & -182.307692307692 \tabularnewline
41 & 1560 & 1588.5 & -28.5 \tabularnewline
42 & 1301 & 1410.92857142857 & -109.928571428571 \tabularnewline
43 & 784 & 913.885714285714 & -129.885714285714 \tabularnewline
44 & 1580 & 1830.30769230769 & -250.307692307692 \tabularnewline
45 & 896 & 913.885714285714 & -17.8857142857142 \tabularnewline
46 & 959 & 913.885714285714 & 45.1142857142858 \tabularnewline
47 & 567 & 623.727272727273 & -56.7272727272727 \tabularnewline
48 & 1519 & 1588.5 & -69.5 \tabularnewline
49 & 1625 & 1588.5 & 36.5 \tabularnewline
50 & 1817 & 1830.30769230769 & -13.3076923076924 \tabularnewline
51 & 658 & 623.727272727273 & 34.2727272727273 \tabularnewline
52 & 1187 & 913.885714285714 & 273.114285714286 \tabularnewline
53 & 1863 & 1830.30769230769 & 32.6923076923076 \tabularnewline
54 & 1559 & 1588.5 & -29.5 \tabularnewline
55 & 1340 & 1410.92857142857 & -70.9285714285713 \tabularnewline
56 & 1342 & 1410.92857142857 & -68.9285714285713 \tabularnewline
57 & 1505 & 1410.92857142857 & 94.0714285714287 \tabularnewline
58 & 669 & 623.727272727273 & 45.2727272727273 \tabularnewline
59 & 814 & 913.885714285714 & -99.8857142857142 \tabularnewline
60 & 2189 & 2571.90909090909 & -382.909090909091 \tabularnewline
61 & 1291 & 1410.92857142857 & -119.928571428571 \tabularnewline
62 & 1378 & 1410.92857142857 & -32.9285714285713 \tabularnewline
63 & 978 & 913.885714285714 & 64.1142857142858 \tabularnewline
64 & 823 & 913.885714285714 & -90.8857142857142 \tabularnewline
65 & 789 & 913.885714285714 & -124.885714285714 \tabularnewline
66 & 1134 & 1187.875 & -53.875 \tabularnewline
67 & 1875 & 1410.92857142857 & 464.071428571429 \tabularnewline
68 & 2289 & 2571.90909090909 & -282.909090909091 \tabularnewline
69 & 817 & 913.885714285714 & -96.8857142857142 \tabularnewline
70 & 340 & 111.933333333333 & 228.066666666667 \tabularnewline
71 & 2354 & 2571.90909090909 & -217.909090909091 \tabularnewline
72 & 992 & 913.885714285714 & 78.1142857142858 \tabularnewline
73 & 976 & 913.885714285714 & 62.1142857142858 \tabularnewline
74 & 1357 & 1410.92857142857 & -53.9285714285713 \tabularnewline
75 & 1958 & 1588.5 & 369.5 \tabularnewline
76 & 933 & 777.333333333333 & 155.666666666667 \tabularnewline
77 & 1600 & 1410.92857142857 & 189.071428571429 \tabularnewline
78 & 1821 & 1830.30769230769 & -9.30769230769238 \tabularnewline
79 & 816 & 777.333333333333 & 38.6666666666666 \tabularnewline
80 & 1121 & 1410.92857142857 & -289.928571428571 \tabularnewline
81 & 800 & 913.885714285714 & -113.885714285714 \tabularnewline
82 & 1446 & 1588.5 & -142.5 \tabularnewline
83 & 750 & 777.333333333333 & -27.3333333333334 \tabularnewline
84 & 1171 & 1187.875 & -16.875 \tabularnewline
85 & 662 & 623.727272727273 & 38.2727272727273 \tabularnewline
86 & 1284 & 1410.92857142857 & -126.928571428571 \tabularnewline
87 & 1980 & 1410.92857142857 & 569.071428571429 \tabularnewline
88 & 879 & 913.885714285714 & -34.8857142857142 \tabularnewline
89 & 869 & 913.885714285714 & -44.8857142857142 \tabularnewline
90 & 1000 & 1187.875 & -187.875 \tabularnewline
91 & 1240 & 1187.875 & 52.125 \tabularnewline
92 & 1771 & 1588.5 & 182.5 \tabularnewline
93 & 917 & 913.885714285714 & 3.11428571428576 \tabularnewline
94 & 1042 & 1410.92857142857 & -368.928571428571 \tabularnewline
95 & 629 & 777.333333333333 & -148.333333333333 \tabularnewline
96 & 1770 & 1830.30769230769 & -60.3076923076924 \tabularnewline
97 & 1454 & 1410.92857142857 & 43.0714285714287 \tabularnewline
98 & 222 & 111.933333333333 & 110.066666666667 \tabularnewline
99 & 1529 & 1588.5 & -59.5 \tabularnewline
100 & 1303 & 1588.5 & -285.5 \tabularnewline
101 & 552 & 777.333333333333 & -225.333333333333 \tabularnewline
102 & 708 & 623.727272727273 & 84.2727272727273 \tabularnewline
103 & 998 & 913.885714285714 & 84.1142857142858 \tabularnewline
104 & 872 & 913.885714285714 & -41.8857142857142 \tabularnewline
105 & 584 & 623.727272727273 & -39.7272727272727 \tabularnewline
106 & 596 & 623.727272727273 & -27.7272727272727 \tabularnewline
107 & 926 & 913.885714285714 & 12.1142857142858 \tabularnewline
108 & 576 & 623.727272727273 & -47.7272727272727 \tabularnewline
109 & 0 & 111.933333333333 & -111.933333333333 \tabularnewline
110 & 868 & 913.885714285714 & -45.8857142857142 \tabularnewline
111 & 736 & 777.333333333333 & -41.3333333333334 \tabularnewline
112 & 998 & 913.885714285714 & 84.1142857142858 \tabularnewline
113 & 915 & 913.885714285714 & 1.11428571428576 \tabularnewline
114 & 782 & 913.885714285714 & -131.885714285714 \tabularnewline
115 & 78 & 111.933333333333 & -33.9333333333333 \tabularnewline
116 & 0 & 111.933333333333 & -111.933333333333 \tabularnewline
117 & 782 & 913.885714285714 & -131.885714285714 \tabularnewline
118 & 1159 & 1410.92857142857 & -251.928571428571 \tabularnewline
119 & 1646 & 1410.92857142857 & 235.071428571429 \tabularnewline
120 & 749 & 913.885714285714 & -164.885714285714 \tabularnewline
121 & 778 & 777.333333333333 & 0.666666666666629 \tabularnewline
122 & 1335 & 1410.92857142857 & -75.9285714285713 \tabularnewline
123 & 806 & 913.885714285714 & -107.885714285714 \tabularnewline
124 & 1390 & 1410.92857142857 & -20.9285714285713 \tabularnewline
125 & 680 & 623.727272727273 & 56.2727272727273 \tabularnewline
126 & 285 & 111.933333333333 & 173.066666666667 \tabularnewline
127 & 1335 & 1410.92857142857 & -75.9285714285713 \tabularnewline
128 & 840 & 913.885714285714 & -73.8857142857142 \tabularnewline
129 & 1230 & 1187.875 & 42.125 \tabularnewline
130 & 256 & 111.933333333333 & 144.066666666667 \tabularnewline
131 & 80 & 111.933333333333 & -31.9333333333333 \tabularnewline
132 & 1162 & 1410.92857142857 & -248.928571428571 \tabularnewline
133 & 41 & 111.933333333333 & -70.9333333333333 \tabularnewline
134 & 1540 & 1588.5 & -48.5 \tabularnewline
135 & 42 & 111.933333333333 & -69.9333333333333 \tabularnewline
136 & 528 & 623.727272727273 & -95.7272727272727 \tabularnewline
137 & 0 & 111.933333333333 & -111.933333333333 \tabularnewline
138 & 799 & 913.885714285714 & -114.885714285714 \tabularnewline
139 & 1086 & 913.885714285714 & 172.114285714286 \tabularnewline
140 & 81 & 111.933333333333 & -30.9333333333333 \tabularnewline
141 & 61 & 111.933333333333 & -50.9333333333333 \tabularnewline
142 & 849 & 913.885714285714 & -64.8857142857142 \tabularnewline
143 & 970 & 913.885714285714 & 56.1142857142858 \tabularnewline
144 & 964 & 913.885714285714 & 50.1142857142858 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155727&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]1407[/C][C]1410.92857142857[/C][C]-3.92857142857133[/C][/ROW]
[ROW][C]2[/C][C]1072[/C][C]913.885714285714[/C][C]158.114285714286[/C][/ROW]
[ROW][C]3[/C][C]192[/C][C]111.933333333333[/C][C]80.0666666666667[/C][/ROW]
[ROW][C]4[/C][C]2032[/C][C]1830.30769230769[/C][C]201.692307692308[/C][/ROW]
[ROW][C]5[/C][C]3032[/C][C]2571.90909090909[/C][C]460.090909090909[/C][/ROW]
[ROW][C]6[/C][C]5519[/C][C]2571.90909090909[/C][C]2947.09090909091[/C][/ROW]
[ROW][C]7[/C][C]1321[/C][C]1410.92857142857[/C][C]-89.9285714285713[/C][/ROW]
[ROW][C]8[/C][C]1034[/C][C]913.885714285714[/C][C]120.114285714286[/C][/ROW]
[ROW][C]9[/C][C]1388[/C][C]1187.875[/C][C]200.125[/C][/ROW]
[ROW][C]10[/C][C]2552[/C][C]2571.90909090909[/C][C]-19.909090909091[/C][/ROW]
[ROW][C]11[/C][C]1735[/C][C]1830.30769230769[/C][C]-95.3076923076924[/C][/ROW]
[ROW][C]12[/C][C]1788[/C][C]1830.30769230769[/C][C]-42.3076923076924[/C][/ROW]
[ROW][C]13[/C][C]1292[/C][C]1410.92857142857[/C][C]-118.928571428571[/C][/ROW]
[ROW][C]14[/C][C]2362[/C][C]2571.90909090909[/C][C]-209.909090909091[/C][/ROW]
[ROW][C]15[/C][C]1150[/C][C]913.885714285714[/C][C]236.114285714286[/C][/ROW]
[ROW][C]16[/C][C]1374[/C][C]1410.92857142857[/C][C]-36.9285714285713[/C][/ROW]
[ROW][C]17[/C][C]1503[/C][C]1410.92857142857[/C][C]92.0714285714287[/C][/ROW]
[ROW][C]18[/C][C]965[/C][C]777.333333333333[/C][C]187.666666666667[/C][/ROW]
[ROW][C]19[/C][C]2164[/C][C]1830.30769230769[/C][C]333.692307692308[/C][/ROW]
[ROW][C]20[/C][C]633[/C][C]623.727272727273[/C][C]9.27272727272725[/C][/ROW]
[ROW][C]21[/C][C]837[/C][C]777.333333333333[/C][C]59.6666666666666[/C][/ROW]
[ROW][C]22[/C][C]1991[/C][C]1830.30769230769[/C][C]160.692307692308[/C][/ROW]
[ROW][C]23[/C][C]1450[/C][C]1588.5[/C][C]-138.5[/C][/ROW]
[ROW][C]24[/C][C]1765[/C][C]1588.5[/C][C]176.5[/C][/ROW]
[ROW][C]25[/C][C]1612[/C][C]1588.5[/C][C]23.5[/C][/ROW]
[ROW][C]26[/C][C]1173[/C][C]1187.875[/C][C]-14.875[/C][/ROW]
[ROW][C]27[/C][C]1602[/C][C]1588.5[/C][C]13.5[/C][/ROW]
[ROW][C]28[/C][C]1046[/C][C]913.885714285714[/C][C]132.114285714286[/C][/ROW]
[ROW][C]29[/C][C]2176[/C][C]2571.90909090909[/C][C]-395.909090909091[/C][/ROW]
[ROW][C]30[/C][C]1767[/C][C]2571.90909090909[/C][C]-804.909090909091[/C][/ROW]
[ROW][C]31[/C][C]1167[/C][C]1187.875[/C][C]-20.875[/C][/ROW]
[ROW][C]32[/C][C]1394[/C][C]1410.92857142857[/C][C]-16.9285714285713[/C][/ROW]
[ROW][C]33[/C][C]1733[/C][C]1830.30769230769[/C][C]-97.3076923076924[/C][/ROW]
[ROW][C]34[/C][C]2374[/C][C]2571.90909090909[/C][C]-197.909090909091[/C][/ROW]
[ROW][C]35[/C][C]1852[/C][C]1830.30769230769[/C][C]21.6923076923076[/C][/ROW]
[ROW][C]36[/C][C]1[/C][C]111.933333333333[/C][C]-110.933333333333[/C][/ROW]
[ROW][C]37[/C][C]1677[/C][C]2571.90909090909[/C][C]-894.909090909091[/C][/ROW]
[ROW][C]38[/C][C]1505[/C][C]1410.92857142857[/C][C]94.0714285714287[/C][/ROW]
[ROW][C]39[/C][C]1813[/C][C]1410.92857142857[/C][C]402.071428571429[/C][/ROW]
[ROW][C]40[/C][C]1648[/C][C]1830.30769230769[/C][C]-182.307692307692[/C][/ROW]
[ROW][C]41[/C][C]1560[/C][C]1588.5[/C][C]-28.5[/C][/ROW]
[ROW][C]42[/C][C]1301[/C][C]1410.92857142857[/C][C]-109.928571428571[/C][/ROW]
[ROW][C]43[/C][C]784[/C][C]913.885714285714[/C][C]-129.885714285714[/C][/ROW]
[ROW][C]44[/C][C]1580[/C][C]1830.30769230769[/C][C]-250.307692307692[/C][/ROW]
[ROW][C]45[/C][C]896[/C][C]913.885714285714[/C][C]-17.8857142857142[/C][/ROW]
[ROW][C]46[/C][C]959[/C][C]913.885714285714[/C][C]45.1142857142858[/C][/ROW]
[ROW][C]47[/C][C]567[/C][C]623.727272727273[/C][C]-56.7272727272727[/C][/ROW]
[ROW][C]48[/C][C]1519[/C][C]1588.5[/C][C]-69.5[/C][/ROW]
[ROW][C]49[/C][C]1625[/C][C]1588.5[/C][C]36.5[/C][/ROW]
[ROW][C]50[/C][C]1817[/C][C]1830.30769230769[/C][C]-13.3076923076924[/C][/ROW]
[ROW][C]51[/C][C]658[/C][C]623.727272727273[/C][C]34.2727272727273[/C][/ROW]
[ROW][C]52[/C][C]1187[/C][C]913.885714285714[/C][C]273.114285714286[/C][/ROW]
[ROW][C]53[/C][C]1863[/C][C]1830.30769230769[/C][C]32.6923076923076[/C][/ROW]
[ROW][C]54[/C][C]1559[/C][C]1588.5[/C][C]-29.5[/C][/ROW]
[ROW][C]55[/C][C]1340[/C][C]1410.92857142857[/C][C]-70.9285714285713[/C][/ROW]
[ROW][C]56[/C][C]1342[/C][C]1410.92857142857[/C][C]-68.9285714285713[/C][/ROW]
[ROW][C]57[/C][C]1505[/C][C]1410.92857142857[/C][C]94.0714285714287[/C][/ROW]
[ROW][C]58[/C][C]669[/C][C]623.727272727273[/C][C]45.2727272727273[/C][/ROW]
[ROW][C]59[/C][C]814[/C][C]913.885714285714[/C][C]-99.8857142857142[/C][/ROW]
[ROW][C]60[/C][C]2189[/C][C]2571.90909090909[/C][C]-382.909090909091[/C][/ROW]
[ROW][C]61[/C][C]1291[/C][C]1410.92857142857[/C][C]-119.928571428571[/C][/ROW]
[ROW][C]62[/C][C]1378[/C][C]1410.92857142857[/C][C]-32.9285714285713[/C][/ROW]
[ROW][C]63[/C][C]978[/C][C]913.885714285714[/C][C]64.1142857142858[/C][/ROW]
[ROW][C]64[/C][C]823[/C][C]913.885714285714[/C][C]-90.8857142857142[/C][/ROW]
[ROW][C]65[/C][C]789[/C][C]913.885714285714[/C][C]-124.885714285714[/C][/ROW]
[ROW][C]66[/C][C]1134[/C][C]1187.875[/C][C]-53.875[/C][/ROW]
[ROW][C]67[/C][C]1875[/C][C]1410.92857142857[/C][C]464.071428571429[/C][/ROW]
[ROW][C]68[/C][C]2289[/C][C]2571.90909090909[/C][C]-282.909090909091[/C][/ROW]
[ROW][C]69[/C][C]817[/C][C]913.885714285714[/C][C]-96.8857142857142[/C][/ROW]
[ROW][C]70[/C][C]340[/C][C]111.933333333333[/C][C]228.066666666667[/C][/ROW]
[ROW][C]71[/C][C]2354[/C][C]2571.90909090909[/C][C]-217.909090909091[/C][/ROW]
[ROW][C]72[/C][C]992[/C][C]913.885714285714[/C][C]78.1142857142858[/C][/ROW]
[ROW][C]73[/C][C]976[/C][C]913.885714285714[/C][C]62.1142857142858[/C][/ROW]
[ROW][C]74[/C][C]1357[/C][C]1410.92857142857[/C][C]-53.9285714285713[/C][/ROW]
[ROW][C]75[/C][C]1958[/C][C]1588.5[/C][C]369.5[/C][/ROW]
[ROW][C]76[/C][C]933[/C][C]777.333333333333[/C][C]155.666666666667[/C][/ROW]
[ROW][C]77[/C][C]1600[/C][C]1410.92857142857[/C][C]189.071428571429[/C][/ROW]
[ROW][C]78[/C][C]1821[/C][C]1830.30769230769[/C][C]-9.30769230769238[/C][/ROW]
[ROW][C]79[/C][C]816[/C][C]777.333333333333[/C][C]38.6666666666666[/C][/ROW]
[ROW][C]80[/C][C]1121[/C][C]1410.92857142857[/C][C]-289.928571428571[/C][/ROW]
[ROW][C]81[/C][C]800[/C][C]913.885714285714[/C][C]-113.885714285714[/C][/ROW]
[ROW][C]82[/C][C]1446[/C][C]1588.5[/C][C]-142.5[/C][/ROW]
[ROW][C]83[/C][C]750[/C][C]777.333333333333[/C][C]-27.3333333333334[/C][/ROW]
[ROW][C]84[/C][C]1171[/C][C]1187.875[/C][C]-16.875[/C][/ROW]
[ROW][C]85[/C][C]662[/C][C]623.727272727273[/C][C]38.2727272727273[/C][/ROW]
[ROW][C]86[/C][C]1284[/C][C]1410.92857142857[/C][C]-126.928571428571[/C][/ROW]
[ROW][C]87[/C][C]1980[/C][C]1410.92857142857[/C][C]569.071428571429[/C][/ROW]
[ROW][C]88[/C][C]879[/C][C]913.885714285714[/C][C]-34.8857142857142[/C][/ROW]
[ROW][C]89[/C][C]869[/C][C]913.885714285714[/C][C]-44.8857142857142[/C][/ROW]
[ROW][C]90[/C][C]1000[/C][C]1187.875[/C][C]-187.875[/C][/ROW]
[ROW][C]91[/C][C]1240[/C][C]1187.875[/C][C]52.125[/C][/ROW]
[ROW][C]92[/C][C]1771[/C][C]1588.5[/C][C]182.5[/C][/ROW]
[ROW][C]93[/C][C]917[/C][C]913.885714285714[/C][C]3.11428571428576[/C][/ROW]
[ROW][C]94[/C][C]1042[/C][C]1410.92857142857[/C][C]-368.928571428571[/C][/ROW]
[ROW][C]95[/C][C]629[/C][C]777.333333333333[/C][C]-148.333333333333[/C][/ROW]
[ROW][C]96[/C][C]1770[/C][C]1830.30769230769[/C][C]-60.3076923076924[/C][/ROW]
[ROW][C]97[/C][C]1454[/C][C]1410.92857142857[/C][C]43.0714285714287[/C][/ROW]
[ROW][C]98[/C][C]222[/C][C]111.933333333333[/C][C]110.066666666667[/C][/ROW]
[ROW][C]99[/C][C]1529[/C][C]1588.5[/C][C]-59.5[/C][/ROW]
[ROW][C]100[/C][C]1303[/C][C]1588.5[/C][C]-285.5[/C][/ROW]
[ROW][C]101[/C][C]552[/C][C]777.333333333333[/C][C]-225.333333333333[/C][/ROW]
[ROW][C]102[/C][C]708[/C][C]623.727272727273[/C][C]84.2727272727273[/C][/ROW]
[ROW][C]103[/C][C]998[/C][C]913.885714285714[/C][C]84.1142857142858[/C][/ROW]
[ROW][C]104[/C][C]872[/C][C]913.885714285714[/C][C]-41.8857142857142[/C][/ROW]
[ROW][C]105[/C][C]584[/C][C]623.727272727273[/C][C]-39.7272727272727[/C][/ROW]
[ROW][C]106[/C][C]596[/C][C]623.727272727273[/C][C]-27.7272727272727[/C][/ROW]
[ROW][C]107[/C][C]926[/C][C]913.885714285714[/C][C]12.1142857142858[/C][/ROW]
[ROW][C]108[/C][C]576[/C][C]623.727272727273[/C][C]-47.7272727272727[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]111.933333333333[/C][C]-111.933333333333[/C][/ROW]
[ROW][C]110[/C][C]868[/C][C]913.885714285714[/C][C]-45.8857142857142[/C][/ROW]
[ROW][C]111[/C][C]736[/C][C]777.333333333333[/C][C]-41.3333333333334[/C][/ROW]
[ROW][C]112[/C][C]998[/C][C]913.885714285714[/C][C]84.1142857142858[/C][/ROW]
[ROW][C]113[/C][C]915[/C][C]913.885714285714[/C][C]1.11428571428576[/C][/ROW]
[ROW][C]114[/C][C]782[/C][C]913.885714285714[/C][C]-131.885714285714[/C][/ROW]
[ROW][C]115[/C][C]78[/C][C]111.933333333333[/C][C]-33.9333333333333[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]111.933333333333[/C][C]-111.933333333333[/C][/ROW]
[ROW][C]117[/C][C]782[/C][C]913.885714285714[/C][C]-131.885714285714[/C][/ROW]
[ROW][C]118[/C][C]1159[/C][C]1410.92857142857[/C][C]-251.928571428571[/C][/ROW]
[ROW][C]119[/C][C]1646[/C][C]1410.92857142857[/C][C]235.071428571429[/C][/ROW]
[ROW][C]120[/C][C]749[/C][C]913.885714285714[/C][C]-164.885714285714[/C][/ROW]
[ROW][C]121[/C][C]778[/C][C]777.333333333333[/C][C]0.666666666666629[/C][/ROW]
[ROW][C]122[/C][C]1335[/C][C]1410.92857142857[/C][C]-75.9285714285713[/C][/ROW]
[ROW][C]123[/C][C]806[/C][C]913.885714285714[/C][C]-107.885714285714[/C][/ROW]
[ROW][C]124[/C][C]1390[/C][C]1410.92857142857[/C][C]-20.9285714285713[/C][/ROW]
[ROW][C]125[/C][C]680[/C][C]623.727272727273[/C][C]56.2727272727273[/C][/ROW]
[ROW][C]126[/C][C]285[/C][C]111.933333333333[/C][C]173.066666666667[/C][/ROW]
[ROW][C]127[/C][C]1335[/C][C]1410.92857142857[/C][C]-75.9285714285713[/C][/ROW]
[ROW][C]128[/C][C]840[/C][C]913.885714285714[/C][C]-73.8857142857142[/C][/ROW]
[ROW][C]129[/C][C]1230[/C][C]1187.875[/C][C]42.125[/C][/ROW]
[ROW][C]130[/C][C]256[/C][C]111.933333333333[/C][C]144.066666666667[/C][/ROW]
[ROW][C]131[/C][C]80[/C][C]111.933333333333[/C][C]-31.9333333333333[/C][/ROW]
[ROW][C]132[/C][C]1162[/C][C]1410.92857142857[/C][C]-248.928571428571[/C][/ROW]
[ROW][C]133[/C][C]41[/C][C]111.933333333333[/C][C]-70.9333333333333[/C][/ROW]
[ROW][C]134[/C][C]1540[/C][C]1588.5[/C][C]-48.5[/C][/ROW]
[ROW][C]135[/C][C]42[/C][C]111.933333333333[/C][C]-69.9333333333333[/C][/ROW]
[ROW][C]136[/C][C]528[/C][C]623.727272727273[/C][C]-95.7272727272727[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]111.933333333333[/C][C]-111.933333333333[/C][/ROW]
[ROW][C]138[/C][C]799[/C][C]913.885714285714[/C][C]-114.885714285714[/C][/ROW]
[ROW][C]139[/C][C]1086[/C][C]913.885714285714[/C][C]172.114285714286[/C][/ROW]
[ROW][C]140[/C][C]81[/C][C]111.933333333333[/C][C]-30.9333333333333[/C][/ROW]
[ROW][C]141[/C][C]61[/C][C]111.933333333333[/C][C]-50.9333333333333[/C][/ROW]
[ROW][C]142[/C][C]849[/C][C]913.885714285714[/C][C]-64.8857142857142[/C][/ROW]
[ROW][C]143[/C][C]970[/C][C]913.885714285714[/C][C]56.1142857142858[/C][/ROW]
[ROW][C]144[/C][C]964[/C][C]913.885714285714[/C][C]50.1142857142858[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155727&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155727&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
114071410.92857142857-3.92857142857133
21072913.885714285714158.114285714286
3192111.93333333333380.0666666666667
420321830.30769230769201.692307692308
530322571.90909090909460.090909090909
655192571.909090909092947.09090909091
713211410.92857142857-89.9285714285713
81034913.885714285714120.114285714286
913881187.875200.125
1025522571.90909090909-19.909090909091
1117351830.30769230769-95.3076923076924
1217881830.30769230769-42.3076923076924
1312921410.92857142857-118.928571428571
1423622571.90909090909-209.909090909091
151150913.885714285714236.114285714286
1613741410.92857142857-36.9285714285713
1715031410.9285714285792.0714285714287
18965777.333333333333187.666666666667
1921641830.30769230769333.692307692308
20633623.7272727272739.27272727272725
21837777.33333333333359.6666666666666
2219911830.30769230769160.692307692308
2314501588.5-138.5
2417651588.5176.5
2516121588.523.5
2611731187.875-14.875
2716021588.513.5
281046913.885714285714132.114285714286
2921762571.90909090909-395.909090909091
3017672571.90909090909-804.909090909091
3111671187.875-20.875
3213941410.92857142857-16.9285714285713
3317331830.30769230769-97.3076923076924
3423742571.90909090909-197.909090909091
3518521830.3076923076921.6923076923076
361111.933333333333-110.933333333333
3716772571.90909090909-894.909090909091
3815051410.9285714285794.0714285714287
3918131410.92857142857402.071428571429
4016481830.30769230769-182.307692307692
4115601588.5-28.5
4213011410.92857142857-109.928571428571
43784913.885714285714-129.885714285714
4415801830.30769230769-250.307692307692
45896913.885714285714-17.8857142857142
46959913.88571428571445.1142857142858
47567623.727272727273-56.7272727272727
4815191588.5-69.5
4916251588.536.5
5018171830.30769230769-13.3076923076924
51658623.72727272727334.2727272727273
521187913.885714285714273.114285714286
5318631830.3076923076932.6923076923076
5415591588.5-29.5
5513401410.92857142857-70.9285714285713
5613421410.92857142857-68.9285714285713
5715051410.9285714285794.0714285714287
58669623.72727272727345.2727272727273
59814913.885714285714-99.8857142857142
6021892571.90909090909-382.909090909091
6112911410.92857142857-119.928571428571
6213781410.92857142857-32.9285714285713
63978913.88571428571464.1142857142858
64823913.885714285714-90.8857142857142
65789913.885714285714-124.885714285714
6611341187.875-53.875
6718751410.92857142857464.071428571429
6822892571.90909090909-282.909090909091
69817913.885714285714-96.8857142857142
70340111.933333333333228.066666666667
7123542571.90909090909-217.909090909091
72992913.88571428571478.1142857142858
73976913.88571428571462.1142857142858
7413571410.92857142857-53.9285714285713
7519581588.5369.5
76933777.333333333333155.666666666667
7716001410.92857142857189.071428571429
7818211830.30769230769-9.30769230769238
79816777.33333333333338.6666666666666
8011211410.92857142857-289.928571428571
81800913.885714285714-113.885714285714
8214461588.5-142.5
83750777.333333333333-27.3333333333334
8411711187.875-16.875
85662623.72727272727338.2727272727273
8612841410.92857142857-126.928571428571
8719801410.92857142857569.071428571429
88879913.885714285714-34.8857142857142
89869913.885714285714-44.8857142857142
9010001187.875-187.875
9112401187.87552.125
9217711588.5182.5
93917913.8857142857143.11428571428576
9410421410.92857142857-368.928571428571
95629777.333333333333-148.333333333333
9617701830.30769230769-60.3076923076924
9714541410.9285714285743.0714285714287
98222111.933333333333110.066666666667
9915291588.5-59.5
10013031588.5-285.5
101552777.333333333333-225.333333333333
102708623.72727272727384.2727272727273
103998913.88571428571484.1142857142858
104872913.885714285714-41.8857142857142
105584623.727272727273-39.7272727272727
106596623.727272727273-27.7272727272727
107926913.88571428571412.1142857142858
108576623.727272727273-47.7272727272727
1090111.933333333333-111.933333333333
110868913.885714285714-45.8857142857142
111736777.333333333333-41.3333333333334
112998913.88571428571484.1142857142858
113915913.8857142857141.11428571428576
114782913.885714285714-131.885714285714
11578111.933333333333-33.9333333333333
1160111.933333333333-111.933333333333
117782913.885714285714-131.885714285714
11811591410.92857142857-251.928571428571
11916461410.92857142857235.071428571429
120749913.885714285714-164.885714285714
121778777.3333333333330.666666666666629
12213351410.92857142857-75.9285714285713
123806913.885714285714-107.885714285714
12413901410.92857142857-20.9285714285713
125680623.72727272727356.2727272727273
126285111.933333333333173.066666666667
12713351410.92857142857-75.9285714285713
128840913.885714285714-73.8857142857142
12912301187.87542.125
130256111.933333333333144.066666666667
13180111.933333333333-31.9333333333333
13211621410.92857142857-248.928571428571
13341111.933333333333-70.9333333333333
13415401588.5-48.5
13542111.933333333333-69.9333333333333
136528623.727272727273-95.7272727272727
1370111.933333333333-111.933333333333
138799913.885714285714-114.885714285714
1391086913.885714285714172.114285714286
14081111.933333333333-30.9333333333333
14161111.933333333333-50.9333333333333
142849913.885714285714-64.8857142857142
143970913.88571428571456.1142857142858
144964913.88571428571450.1142857142858



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