Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Module--
Title produced by softwareRecursive Partitioning (Regression Trees)
Date of computationThu, 22 Dec 2011 14:53:19 -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/22/t13245836088yrvqhz2ig4xqmq.htm/, Retrieved Fri, 03 May 2024 06:56:03 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=159921, Retrieved Fri, 03 May 2024 06:56:03 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact101
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Multiple Regression] [] [2010-12-05 18:56:24] [b98453cac15ba1066b407e146608df68]
-   PD  [Multiple Regression] [] [2011-12-22 19:20:56] [5a05da414fd67612c3b80d44effe0727]
- RM      [Recursive Partitioning (Regression Trees)] [] [2011-12-22 19:51:48] [5a05da414fd67612c3b80d44effe0727]
- RM          [Recursive Partitioning (Regression Trees)] [] [2011-12-22 19:53:19] [95610e892c4b5c84ff80f4c898567a9d] [Current]
Feedback Forum

Post a new message
Dataseries X:
1845	162687	595	115	48	21	82	6200	37
1796	201906	545	76	58	20	80	10265	43
192	7215	72	1	0	0	0	603	0
2444	146367	679	155	67	27	84	8874	54
3567	257045	1201	125	83	31	124	20323	86
6917	524450	1967	278	136	36	140	26258	181
1840	188294	595	89	65	23	88	10165	42
1740	195674	496	59	86	30	115	8247	59
2078	177020	670	87	62	30	109	8683	46
3097	325899	1039	130	71	27	108	16957	77
1946	121844	634	158	50	24	63	8058	49
2370	203938	743	120	88	30	118	20488	79
1883	107394	681	87	50	22	71	7945	37
3198	220751	1086	264	79	28	112	13448	92
1490	172905	419	51	56	18	63	5389	31
1573	156326	474	85	54	22	86	6185	28
1807	145178	442	100	81	37	148	24369	103
1309	89171	373	72	13	15	54	70	2
2820	172624	899	147	74	34	134	17327	48
776	39790	242	49	18	18	57	3878	25
1162	87927	399	40	31	15	59	3149	16
2818	241285	850	99	99	30	113	20517	106
1760	195820	642	127	38	25	96	2570	35
2315	146946	717	164	59	34	96	5162	33
1994	159763	619	41	54	21	78	5299	45
1806	207078	657	160	63	21	80	7233	64
2152	212394	691	92	66	25	93	15657	73
1457	201536	366	59	90	31	109	15329	78
3000	394662	994	89	72	31	115	14881	63
2236	217892	929	90	61	20	79	16318	69
1685	182286	490	76	61	28	103	9556	36
1626	181740	553	116	61	22	71	10462	41
2257	137978	738	92	53	17	66	7192	59
3373	255929	1028	361	118	25	100	4362	33
2571	236489	844	85	73	25	100	14349	76
1	0	0	0	0	0	0	0	0
2142	230761	1000	63	54	31	121	10881	27
1878	132807	629	138	54	14	51	8022	44
2190	157118	532	270	46	35	119	13073	43
2186	253254	811	64	83	34	136	26641	104
2532	269329	837	96	106	22	84	14426	120
1823	161273	682	62	44	34	136	15604	44
1095	107181	400	35	27	23	84	9184	71
2162	195891	804	59	64	24	92	5989	78
1365	139667	419	56	71	26	103	11270	106
1244	171101	334	41	44	23	85	13958	61
756	81407	216	49	23	35	106	7162	53
2417	247563	786	121	78	24	96	13275	51
2327	239807	752	113	60	31	124	21224	46
2786	172743	964	190	73	30	106	10615	55
658	48188	205	37	12	22	82	2102	14
2012	169355	506	52	104	23	87	12396	44
2602	315622	830	89	83	27	97	18717	113
2071	241518	694	73	57	30	107	9724	55
1911	195583	691	49	67	33	126	9863	46
1775	159913	547	77	44	12	43	8374	39
1918	220241	538	58	53	26	96	8030	51
1046	101694	329	75	26	26	100	7509	31
1190	157258	427	32	67	23	91	14146	36
2890	202536	972	59	36	38	136	7768	47
1836	173505	541	71	56	32	128	13823	53
2254	150518	836	91	52	21	83	7230	38
1392	141491	376	87	54	22	74	10170	52
1325	125612	467	48	57	26	96	7573	37
1317	166049	430	63	27	28	102	5753	11
1525	124197	483	41	58	33	122	9791	45
2335	195043	504	86	76	36	144	19365	59
2897	138708	887	152	93	25	90	9422	82
1118	116552	271	49	59	25	97	12310	49
340	31970	101	40	5	21	78	1283	6
2977	258158	1097	135	57	19	72	6372	81
1449	151184	469	83	42	12	45	5413	56
1550	135926	528	62	88	30	120	10837	105
1684	119629	475	91	53	21	59	3394	46
2728	171518	698	95	81	39	150	12964	46
1574	108949	425	82	35	32	117	3495	2
2413	183471	709	112	102	28	123	11580	51
2563	159966	824	70	71	29	114	9970	95
1079	93786	336	78	28	21	75	4911	18
1235	84971	395	105	34	31	114	10138	55
980	88882	234	49	54	26	94	14697	48
2246	304603	830	60	49	29	116	8464	48
1076	75101	334	49	30	23	86	4204	39
1637	145043	524	132	57	25	90	10226	40
1208	95827	393	49	54	22	87	3456	36
1865	173924	574	71	38	26	99	8895	60
2726	241957	672	102	63	33	132	22557	114
1208	115367	284	74	58	24	96	6900	39
1419	118408	450	49	46	24	91	8620	45
1609	164078	653	74	46	21	77	7820	59
1864	158931	684	59	51	28	104	12112	59
2412	184139	706	91	87	28	100	13178	93
1238	152856	417	68	39	25	94	7028	35
1462	144014	549	81	28	15	60	6616	47
973	62535	394	33	26	13	46	9570	36
2319	245196	730	166	52	36	135	14612	59
1890	199841	571	97	96	27	99	11219	79
223	19349	67	15	13	1	2	786	14
2526	247280	877	105	43	24	96	11252	42
2072	159408	856	61	42	31	109	9289	41
778	72128	306	11	30	4	15	593	8
1194	104253	382	45	59	21	68	6562	41
1424	151090	435	89	73	27	102	8208	24
1328	137382	336	67	39	23	84	7488	22
839	87448	227	27	36	12	46	4574	18
596	27676	194	59	2	16	59	522	1
1671	165507	410	127	102	29	116	12840	53
1167	132148	273	48	30	26	29	1350	6
0	0	0	0	0	0	0	0	0
1106	95778	343	58	46	25	91	10623	49
1148	109001	376	57	25	21	76	5322	33
1485	158833	495	60	59	24	86	7987	50
1526	147690	448	77	60	21	84	10566	64
962	89887	313	71	36	21	65	1900	53
78	3616	14	5	0	0	0	0	0
0	0	0	0	0	0	0	0	0
1184	199005	410	70	45	23	84	10698	48
1671	160930	606	76	79	33	114	14884	90
2142	177948	593	124	30	32	132	6852	46
1015	136061	312	56	43	23	92	6873	29
778	43410	292	63	7	1	3	4	1
1856	184277	547	92	80	29	109	9188	64
1056	108858	302	58	32	20	81	5141	29
2234	141744	632	64	81	33	121	4260	27
731	60493	174	29	3	12	48	443	4
285	19764	75	19	10	2	8	2416	10
1872	177559	572	64	47	21	80	9831	47
1181	140281	389	79	35	28	107	5953	44
1725	164249	562	104	54	35	140	9435	51
256	11796	79	22	1	2	8	0	0
98	10674	33	7	0	0	0	0	0
1435	151322	487	37	46	18	56	7642	38
41	6836	11	5	0	1	4	0	0
1930	174712	664	48	51	21	70	6837	57
42	5118	6	1	5	0	0	0	0
528	40248	183	34	8	4	14	775	6
0	0	0	0	0	0	0	0	0
1121	127628	342	53	38	29	104	8191	22
1305	88837	269	44	21	26	89	1661	34
81	7131	27	0	0	0	0	0	0
262	9056	99	18	0	4	12	548	10
1099	87957	305	52	18	19	60	3080	16
1290	144470	327	56	53	22	84	13400	93
1248	111408	459	50	17	22	88	8181	22




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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159921&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 time5 seconds
R Server'Herman Ole Andreas Wold' @ wold.wessa.net







Goodness of Fit
Correlation0.9653
R-squared0.9318
RMSE9.7837

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.9653[/C][/ROW]
[ROW][C]R-squared[/C][C]0.9318[/C][/ROW]
[ROW][C]RMSE[/C][C]9.7837[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159921&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159921&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.9653
R-squared0.9318
RMSE9.7837







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
18276.92857142857145.07142857142857
28076.92857142857143.07142857142857
303.88235294117647-3.88235294117647
48490.7368421052632-6.73684210526316
5124112.07692307692311.9230769230769
6140129.14285714285710.8571428571429
78890.7368421052632-2.73684210526316
8115112.0769230769232.92307692307692
9109112.076923076923-3.07692307692308
1010890.736842105263217.2631578947368
116390.7368421052632-27.7368421052632
12118112.0769230769235.92307692307692
137176.9285714285714-5.92857142857143
14112112.076923076923-0.0769230769230802
156353.78571428571439.21428571428572
168676.92857142857149.07142857142857
17148129.14285714285718.8571428571429
185453.78571428571430.214285714285715
19134129.1428571428574.85714285714286
205753.78571428571433.21428571428572
215953.78571428571435.21428571428572
22113112.0769230769230.92307692307692
239690.73684210526325.26315789473684
2496129.142857142857-33.1428571428571
257876.92857142857141.07142857142857
268076.92857142857143.07142857142857
279390.73684210526322.26315789473684
28109112.076923076923-3.07692307692308
29115112.0769230769232.92307692307692
307976.92857142857142.07142857142857
31103112.076923076923-9.07692307692308
327176.9285714285714-5.92857142857143
336653.785714285714312.2142857142857
3410090.73684210526329.26315789473684
3510090.73684210526329.26315789473684
3603.88235294117647-3.88235294117647
37121112.0769230769238.92307692307692
385153.7857142857143-2.78571428571428
39119129.142857142857-10.1428571428571
40136129.1428571428576.85714285714286
418476.92857142857147.07142857142857
42136129.1428571428576.85714285714286
438490.7368421052632-6.73684210526316
449290.73684210526321.26315789473684
4510390.736842105263212.2631578947368
468590.7368421052632-5.73684210526316
47106129.142857142857-23.1428571428571
489690.73684210526325.26315789473684
49124112.07692307692311.9230769230769
50106112.076923076923-6.07692307692308
518276.92857142857145.07142857142857
528790.7368421052632-3.73684210526316
539790.73684210526326.26315789473684
54107112.076923076923-5.07692307692308
55126129.142857142857-3.14285714285714
564353.7857142857143-10.7857142857143
579690.73684210526325.26315789473684
5810090.73684210526329.26315789473684
599190.73684210526320.263157894736835
60136129.1428571428576.85714285714286
61128129.142857142857-1.14285714285714
628376.92857142857146.07142857142857
637476.9285714285714-2.92857142857143
649690.73684210526325.26315789473684
65102112.076923076923-10.0769230769231
66122129.142857142857-7.14285714285714
67144129.14285714285714.8571428571429
689090.7368421052632-0.736842105263165
699790.73684210526326.26315789473684
707876.92857142857141.07142857142857
717276.9285714285714-4.92857142857143
724553.7857142857143-8.78571428571428
73120112.0769230769237.92307692307692
745976.9285714285714-17.9285714285714
75150129.14285714285720.8571428571429
76117129.142857142857-12.1428571428571
77123112.07692307692310.9230769230769
78114112.0769230769231.92307692307692
797576.9285714285714-1.92857142857143
80114112.0769230769231.92307692307692
819490.73684210526323.26315789473684
82116112.0769230769233.92307692307692
838690.7368421052632-4.73684210526316
849090.7368421052632-0.736842105263165
858776.928571428571410.0714285714286
869990.73684210526328.26315789473684
87132129.1428571428572.85714285714286
889690.73684210526325.26315789473684
899190.73684210526320.263157894736835
907776.92857142857140.0714285714285694
91104112.076923076923-8.07692307692308
92100112.076923076923-12.0769230769231
939490.73684210526323.26315789473684
946053.78571428571436.21428571428572
954653.7857142857143-7.78571428571428
96135129.1428571428575.85714285714286
979990.73684210526328.26315789473684
9823.88235294117647-1.88235294117647
999690.73684210526325.26315789473684
100109112.076923076923-3.07692307692308
101153.8823529411764711.1176470588235
1026876.9285714285714-8.92857142857143
10310290.736842105263211.2631578947368
1048490.7368421052632-6.73684210526316
1054653.7857142857143-7.78571428571428
1065953.78571428571435.21428571428572
107116112.0769230769233.92307692307692
1082990.7368421052632-61.7368421052632
10903.88235294117647-3.88235294117647
1109190.73684210526320.263157894736835
1117676.9285714285714-0.928571428571431
1128690.7368421052632-4.73684210526316
1138476.92857142857147.07142857142857
1146576.9285714285714-11.9285714285714
11503.88235294117647-3.88235294117647
11603.88235294117647-3.88235294117647
1178490.7368421052632-6.73684210526316
118114129.142857142857-15.1428571428571
119132129.1428571428572.85714285714286
1209290.73684210526321.26315789473684
12133.88235294117647-0.882352941176471
122109112.076923076923-3.07692307692308
1238176.92857142857144.07142857142857
124121129.142857142857-8.14285714285714
1254853.7857142857143-5.78571428571428
12683.882352941176474.11764705882353
1278076.92857142857143.07142857142857
128107112.076923076923-5.07692307692308
129140129.14285714285710.8571428571429
13083.882352941176474.11764705882353
13103.88235294117647-3.88235294117647
1325653.78571428571432.21428571428572
13343.882352941176470.117647058823529
1347076.9285714285714-6.92857142857143
13503.88235294117647-3.88235294117647
136143.8823529411764710.1176470588235
13703.88235294117647-3.88235294117647
138104112.076923076923-8.07692307692308
1398990.7368421052632-1.73684210526316
14003.88235294117647-3.88235294117647
141123.882352941176478.11764705882353
1426076.9285714285714-16.9285714285714
1438476.92857142857147.07142857142857
1448876.928571428571411.0714285714286

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 82 & 76.9285714285714 & 5.07142857142857 \tabularnewline
2 & 80 & 76.9285714285714 & 3.07142857142857 \tabularnewline
3 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
4 & 84 & 90.7368421052632 & -6.73684210526316 \tabularnewline
5 & 124 & 112.076923076923 & 11.9230769230769 \tabularnewline
6 & 140 & 129.142857142857 & 10.8571428571429 \tabularnewline
7 & 88 & 90.7368421052632 & -2.73684210526316 \tabularnewline
8 & 115 & 112.076923076923 & 2.92307692307692 \tabularnewline
9 & 109 & 112.076923076923 & -3.07692307692308 \tabularnewline
10 & 108 & 90.7368421052632 & 17.2631578947368 \tabularnewline
11 & 63 & 90.7368421052632 & -27.7368421052632 \tabularnewline
12 & 118 & 112.076923076923 & 5.92307692307692 \tabularnewline
13 & 71 & 76.9285714285714 & -5.92857142857143 \tabularnewline
14 & 112 & 112.076923076923 & -0.0769230769230802 \tabularnewline
15 & 63 & 53.7857142857143 & 9.21428571428572 \tabularnewline
16 & 86 & 76.9285714285714 & 9.07142857142857 \tabularnewline
17 & 148 & 129.142857142857 & 18.8571428571429 \tabularnewline
18 & 54 & 53.7857142857143 & 0.214285714285715 \tabularnewline
19 & 134 & 129.142857142857 & 4.85714285714286 \tabularnewline
20 & 57 & 53.7857142857143 & 3.21428571428572 \tabularnewline
21 & 59 & 53.7857142857143 & 5.21428571428572 \tabularnewline
22 & 113 & 112.076923076923 & 0.92307692307692 \tabularnewline
23 & 96 & 90.7368421052632 & 5.26315789473684 \tabularnewline
24 & 96 & 129.142857142857 & -33.1428571428571 \tabularnewline
25 & 78 & 76.9285714285714 & 1.07142857142857 \tabularnewline
26 & 80 & 76.9285714285714 & 3.07142857142857 \tabularnewline
27 & 93 & 90.7368421052632 & 2.26315789473684 \tabularnewline
28 & 109 & 112.076923076923 & -3.07692307692308 \tabularnewline
29 & 115 & 112.076923076923 & 2.92307692307692 \tabularnewline
30 & 79 & 76.9285714285714 & 2.07142857142857 \tabularnewline
31 & 103 & 112.076923076923 & -9.07692307692308 \tabularnewline
32 & 71 & 76.9285714285714 & -5.92857142857143 \tabularnewline
33 & 66 & 53.7857142857143 & 12.2142857142857 \tabularnewline
34 & 100 & 90.7368421052632 & 9.26315789473684 \tabularnewline
35 & 100 & 90.7368421052632 & 9.26315789473684 \tabularnewline
36 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
37 & 121 & 112.076923076923 & 8.92307692307692 \tabularnewline
38 & 51 & 53.7857142857143 & -2.78571428571428 \tabularnewline
39 & 119 & 129.142857142857 & -10.1428571428571 \tabularnewline
40 & 136 & 129.142857142857 & 6.85714285714286 \tabularnewline
41 & 84 & 76.9285714285714 & 7.07142857142857 \tabularnewline
42 & 136 & 129.142857142857 & 6.85714285714286 \tabularnewline
43 & 84 & 90.7368421052632 & -6.73684210526316 \tabularnewline
44 & 92 & 90.7368421052632 & 1.26315789473684 \tabularnewline
45 & 103 & 90.7368421052632 & 12.2631578947368 \tabularnewline
46 & 85 & 90.7368421052632 & -5.73684210526316 \tabularnewline
47 & 106 & 129.142857142857 & -23.1428571428571 \tabularnewline
48 & 96 & 90.7368421052632 & 5.26315789473684 \tabularnewline
49 & 124 & 112.076923076923 & 11.9230769230769 \tabularnewline
50 & 106 & 112.076923076923 & -6.07692307692308 \tabularnewline
51 & 82 & 76.9285714285714 & 5.07142857142857 \tabularnewline
52 & 87 & 90.7368421052632 & -3.73684210526316 \tabularnewline
53 & 97 & 90.7368421052632 & 6.26315789473684 \tabularnewline
54 & 107 & 112.076923076923 & -5.07692307692308 \tabularnewline
55 & 126 & 129.142857142857 & -3.14285714285714 \tabularnewline
56 & 43 & 53.7857142857143 & -10.7857142857143 \tabularnewline
57 & 96 & 90.7368421052632 & 5.26315789473684 \tabularnewline
58 & 100 & 90.7368421052632 & 9.26315789473684 \tabularnewline
59 & 91 & 90.7368421052632 & 0.263157894736835 \tabularnewline
60 & 136 & 129.142857142857 & 6.85714285714286 \tabularnewline
61 & 128 & 129.142857142857 & -1.14285714285714 \tabularnewline
62 & 83 & 76.9285714285714 & 6.07142857142857 \tabularnewline
63 & 74 & 76.9285714285714 & -2.92857142857143 \tabularnewline
64 & 96 & 90.7368421052632 & 5.26315789473684 \tabularnewline
65 & 102 & 112.076923076923 & -10.0769230769231 \tabularnewline
66 & 122 & 129.142857142857 & -7.14285714285714 \tabularnewline
67 & 144 & 129.142857142857 & 14.8571428571429 \tabularnewline
68 & 90 & 90.7368421052632 & -0.736842105263165 \tabularnewline
69 & 97 & 90.7368421052632 & 6.26315789473684 \tabularnewline
70 & 78 & 76.9285714285714 & 1.07142857142857 \tabularnewline
71 & 72 & 76.9285714285714 & -4.92857142857143 \tabularnewline
72 & 45 & 53.7857142857143 & -8.78571428571428 \tabularnewline
73 & 120 & 112.076923076923 & 7.92307692307692 \tabularnewline
74 & 59 & 76.9285714285714 & -17.9285714285714 \tabularnewline
75 & 150 & 129.142857142857 & 20.8571428571429 \tabularnewline
76 & 117 & 129.142857142857 & -12.1428571428571 \tabularnewline
77 & 123 & 112.076923076923 & 10.9230769230769 \tabularnewline
78 & 114 & 112.076923076923 & 1.92307692307692 \tabularnewline
79 & 75 & 76.9285714285714 & -1.92857142857143 \tabularnewline
80 & 114 & 112.076923076923 & 1.92307692307692 \tabularnewline
81 & 94 & 90.7368421052632 & 3.26315789473684 \tabularnewline
82 & 116 & 112.076923076923 & 3.92307692307692 \tabularnewline
83 & 86 & 90.7368421052632 & -4.73684210526316 \tabularnewline
84 & 90 & 90.7368421052632 & -0.736842105263165 \tabularnewline
85 & 87 & 76.9285714285714 & 10.0714285714286 \tabularnewline
86 & 99 & 90.7368421052632 & 8.26315789473684 \tabularnewline
87 & 132 & 129.142857142857 & 2.85714285714286 \tabularnewline
88 & 96 & 90.7368421052632 & 5.26315789473684 \tabularnewline
89 & 91 & 90.7368421052632 & 0.263157894736835 \tabularnewline
90 & 77 & 76.9285714285714 & 0.0714285714285694 \tabularnewline
91 & 104 & 112.076923076923 & -8.07692307692308 \tabularnewline
92 & 100 & 112.076923076923 & -12.0769230769231 \tabularnewline
93 & 94 & 90.7368421052632 & 3.26315789473684 \tabularnewline
94 & 60 & 53.7857142857143 & 6.21428571428572 \tabularnewline
95 & 46 & 53.7857142857143 & -7.78571428571428 \tabularnewline
96 & 135 & 129.142857142857 & 5.85714285714286 \tabularnewline
97 & 99 & 90.7368421052632 & 8.26315789473684 \tabularnewline
98 & 2 & 3.88235294117647 & -1.88235294117647 \tabularnewline
99 & 96 & 90.7368421052632 & 5.26315789473684 \tabularnewline
100 & 109 & 112.076923076923 & -3.07692307692308 \tabularnewline
101 & 15 & 3.88235294117647 & 11.1176470588235 \tabularnewline
102 & 68 & 76.9285714285714 & -8.92857142857143 \tabularnewline
103 & 102 & 90.7368421052632 & 11.2631578947368 \tabularnewline
104 & 84 & 90.7368421052632 & -6.73684210526316 \tabularnewline
105 & 46 & 53.7857142857143 & -7.78571428571428 \tabularnewline
106 & 59 & 53.7857142857143 & 5.21428571428572 \tabularnewline
107 & 116 & 112.076923076923 & 3.92307692307692 \tabularnewline
108 & 29 & 90.7368421052632 & -61.7368421052632 \tabularnewline
109 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
110 & 91 & 90.7368421052632 & 0.263157894736835 \tabularnewline
111 & 76 & 76.9285714285714 & -0.928571428571431 \tabularnewline
112 & 86 & 90.7368421052632 & -4.73684210526316 \tabularnewline
113 & 84 & 76.9285714285714 & 7.07142857142857 \tabularnewline
114 & 65 & 76.9285714285714 & -11.9285714285714 \tabularnewline
115 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
116 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
117 & 84 & 90.7368421052632 & -6.73684210526316 \tabularnewline
118 & 114 & 129.142857142857 & -15.1428571428571 \tabularnewline
119 & 132 & 129.142857142857 & 2.85714285714286 \tabularnewline
120 & 92 & 90.7368421052632 & 1.26315789473684 \tabularnewline
121 & 3 & 3.88235294117647 & -0.882352941176471 \tabularnewline
122 & 109 & 112.076923076923 & -3.07692307692308 \tabularnewline
123 & 81 & 76.9285714285714 & 4.07142857142857 \tabularnewline
124 & 121 & 129.142857142857 & -8.14285714285714 \tabularnewline
125 & 48 & 53.7857142857143 & -5.78571428571428 \tabularnewline
126 & 8 & 3.88235294117647 & 4.11764705882353 \tabularnewline
127 & 80 & 76.9285714285714 & 3.07142857142857 \tabularnewline
128 & 107 & 112.076923076923 & -5.07692307692308 \tabularnewline
129 & 140 & 129.142857142857 & 10.8571428571429 \tabularnewline
130 & 8 & 3.88235294117647 & 4.11764705882353 \tabularnewline
131 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
132 & 56 & 53.7857142857143 & 2.21428571428572 \tabularnewline
133 & 4 & 3.88235294117647 & 0.117647058823529 \tabularnewline
134 & 70 & 76.9285714285714 & -6.92857142857143 \tabularnewline
135 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
136 & 14 & 3.88235294117647 & 10.1176470588235 \tabularnewline
137 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
138 & 104 & 112.076923076923 & -8.07692307692308 \tabularnewline
139 & 89 & 90.7368421052632 & -1.73684210526316 \tabularnewline
140 & 0 & 3.88235294117647 & -3.88235294117647 \tabularnewline
141 & 12 & 3.88235294117647 & 8.11764705882353 \tabularnewline
142 & 60 & 76.9285714285714 & -16.9285714285714 \tabularnewline
143 & 84 & 76.9285714285714 & 7.07142857142857 \tabularnewline
144 & 88 & 76.9285714285714 & 11.0714285714286 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=159921&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]82[/C][C]76.9285714285714[/C][C]5.07142857142857[/C][/ROW]
[ROW][C]2[/C][C]80[/C][C]76.9285714285714[/C][C]3.07142857142857[/C][/ROW]
[ROW][C]3[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]4[/C][C]84[/C][C]90.7368421052632[/C][C]-6.73684210526316[/C][/ROW]
[ROW][C]5[/C][C]124[/C][C]112.076923076923[/C][C]11.9230769230769[/C][/ROW]
[ROW][C]6[/C][C]140[/C][C]129.142857142857[/C][C]10.8571428571429[/C][/ROW]
[ROW][C]7[/C][C]88[/C][C]90.7368421052632[/C][C]-2.73684210526316[/C][/ROW]
[ROW][C]8[/C][C]115[/C][C]112.076923076923[/C][C]2.92307692307692[/C][/ROW]
[ROW][C]9[/C][C]109[/C][C]112.076923076923[/C][C]-3.07692307692308[/C][/ROW]
[ROW][C]10[/C][C]108[/C][C]90.7368421052632[/C][C]17.2631578947368[/C][/ROW]
[ROW][C]11[/C][C]63[/C][C]90.7368421052632[/C][C]-27.7368421052632[/C][/ROW]
[ROW][C]12[/C][C]118[/C][C]112.076923076923[/C][C]5.92307692307692[/C][/ROW]
[ROW][C]13[/C][C]71[/C][C]76.9285714285714[/C][C]-5.92857142857143[/C][/ROW]
[ROW][C]14[/C][C]112[/C][C]112.076923076923[/C][C]-0.0769230769230802[/C][/ROW]
[ROW][C]15[/C][C]63[/C][C]53.7857142857143[/C][C]9.21428571428572[/C][/ROW]
[ROW][C]16[/C][C]86[/C][C]76.9285714285714[/C][C]9.07142857142857[/C][/ROW]
[ROW][C]17[/C][C]148[/C][C]129.142857142857[/C][C]18.8571428571429[/C][/ROW]
[ROW][C]18[/C][C]54[/C][C]53.7857142857143[/C][C]0.214285714285715[/C][/ROW]
[ROW][C]19[/C][C]134[/C][C]129.142857142857[/C][C]4.85714285714286[/C][/ROW]
[ROW][C]20[/C][C]57[/C][C]53.7857142857143[/C][C]3.21428571428572[/C][/ROW]
[ROW][C]21[/C][C]59[/C][C]53.7857142857143[/C][C]5.21428571428572[/C][/ROW]
[ROW][C]22[/C][C]113[/C][C]112.076923076923[/C][C]0.92307692307692[/C][/ROW]
[ROW][C]23[/C][C]96[/C][C]90.7368421052632[/C][C]5.26315789473684[/C][/ROW]
[ROW][C]24[/C][C]96[/C][C]129.142857142857[/C][C]-33.1428571428571[/C][/ROW]
[ROW][C]25[/C][C]78[/C][C]76.9285714285714[/C][C]1.07142857142857[/C][/ROW]
[ROW][C]26[/C][C]80[/C][C]76.9285714285714[/C][C]3.07142857142857[/C][/ROW]
[ROW][C]27[/C][C]93[/C][C]90.7368421052632[/C][C]2.26315789473684[/C][/ROW]
[ROW][C]28[/C][C]109[/C][C]112.076923076923[/C][C]-3.07692307692308[/C][/ROW]
[ROW][C]29[/C][C]115[/C][C]112.076923076923[/C][C]2.92307692307692[/C][/ROW]
[ROW][C]30[/C][C]79[/C][C]76.9285714285714[/C][C]2.07142857142857[/C][/ROW]
[ROW][C]31[/C][C]103[/C][C]112.076923076923[/C][C]-9.07692307692308[/C][/ROW]
[ROW][C]32[/C][C]71[/C][C]76.9285714285714[/C][C]-5.92857142857143[/C][/ROW]
[ROW][C]33[/C][C]66[/C][C]53.7857142857143[/C][C]12.2142857142857[/C][/ROW]
[ROW][C]34[/C][C]100[/C][C]90.7368421052632[/C][C]9.26315789473684[/C][/ROW]
[ROW][C]35[/C][C]100[/C][C]90.7368421052632[/C][C]9.26315789473684[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]37[/C][C]121[/C][C]112.076923076923[/C][C]8.92307692307692[/C][/ROW]
[ROW][C]38[/C][C]51[/C][C]53.7857142857143[/C][C]-2.78571428571428[/C][/ROW]
[ROW][C]39[/C][C]119[/C][C]129.142857142857[/C][C]-10.1428571428571[/C][/ROW]
[ROW][C]40[/C][C]136[/C][C]129.142857142857[/C][C]6.85714285714286[/C][/ROW]
[ROW][C]41[/C][C]84[/C][C]76.9285714285714[/C][C]7.07142857142857[/C][/ROW]
[ROW][C]42[/C][C]136[/C][C]129.142857142857[/C][C]6.85714285714286[/C][/ROW]
[ROW][C]43[/C][C]84[/C][C]90.7368421052632[/C][C]-6.73684210526316[/C][/ROW]
[ROW][C]44[/C][C]92[/C][C]90.7368421052632[/C][C]1.26315789473684[/C][/ROW]
[ROW][C]45[/C][C]103[/C][C]90.7368421052632[/C][C]12.2631578947368[/C][/ROW]
[ROW][C]46[/C][C]85[/C][C]90.7368421052632[/C][C]-5.73684210526316[/C][/ROW]
[ROW][C]47[/C][C]106[/C][C]129.142857142857[/C][C]-23.1428571428571[/C][/ROW]
[ROW][C]48[/C][C]96[/C][C]90.7368421052632[/C][C]5.26315789473684[/C][/ROW]
[ROW][C]49[/C][C]124[/C][C]112.076923076923[/C][C]11.9230769230769[/C][/ROW]
[ROW][C]50[/C][C]106[/C][C]112.076923076923[/C][C]-6.07692307692308[/C][/ROW]
[ROW][C]51[/C][C]82[/C][C]76.9285714285714[/C][C]5.07142857142857[/C][/ROW]
[ROW][C]52[/C][C]87[/C][C]90.7368421052632[/C][C]-3.73684210526316[/C][/ROW]
[ROW][C]53[/C][C]97[/C][C]90.7368421052632[/C][C]6.26315789473684[/C][/ROW]
[ROW][C]54[/C][C]107[/C][C]112.076923076923[/C][C]-5.07692307692308[/C][/ROW]
[ROW][C]55[/C][C]126[/C][C]129.142857142857[/C][C]-3.14285714285714[/C][/ROW]
[ROW][C]56[/C][C]43[/C][C]53.7857142857143[/C][C]-10.7857142857143[/C][/ROW]
[ROW][C]57[/C][C]96[/C][C]90.7368421052632[/C][C]5.26315789473684[/C][/ROW]
[ROW][C]58[/C][C]100[/C][C]90.7368421052632[/C][C]9.26315789473684[/C][/ROW]
[ROW][C]59[/C][C]91[/C][C]90.7368421052632[/C][C]0.263157894736835[/C][/ROW]
[ROW][C]60[/C][C]136[/C][C]129.142857142857[/C][C]6.85714285714286[/C][/ROW]
[ROW][C]61[/C][C]128[/C][C]129.142857142857[/C][C]-1.14285714285714[/C][/ROW]
[ROW][C]62[/C][C]83[/C][C]76.9285714285714[/C][C]6.07142857142857[/C][/ROW]
[ROW][C]63[/C][C]74[/C][C]76.9285714285714[/C][C]-2.92857142857143[/C][/ROW]
[ROW][C]64[/C][C]96[/C][C]90.7368421052632[/C][C]5.26315789473684[/C][/ROW]
[ROW][C]65[/C][C]102[/C][C]112.076923076923[/C][C]-10.0769230769231[/C][/ROW]
[ROW][C]66[/C][C]122[/C][C]129.142857142857[/C][C]-7.14285714285714[/C][/ROW]
[ROW][C]67[/C][C]144[/C][C]129.142857142857[/C][C]14.8571428571429[/C][/ROW]
[ROW][C]68[/C][C]90[/C][C]90.7368421052632[/C][C]-0.736842105263165[/C][/ROW]
[ROW][C]69[/C][C]97[/C][C]90.7368421052632[/C][C]6.26315789473684[/C][/ROW]
[ROW][C]70[/C][C]78[/C][C]76.9285714285714[/C][C]1.07142857142857[/C][/ROW]
[ROW][C]71[/C][C]72[/C][C]76.9285714285714[/C][C]-4.92857142857143[/C][/ROW]
[ROW][C]72[/C][C]45[/C][C]53.7857142857143[/C][C]-8.78571428571428[/C][/ROW]
[ROW][C]73[/C][C]120[/C][C]112.076923076923[/C][C]7.92307692307692[/C][/ROW]
[ROW][C]74[/C][C]59[/C][C]76.9285714285714[/C][C]-17.9285714285714[/C][/ROW]
[ROW][C]75[/C][C]150[/C][C]129.142857142857[/C][C]20.8571428571429[/C][/ROW]
[ROW][C]76[/C][C]117[/C][C]129.142857142857[/C][C]-12.1428571428571[/C][/ROW]
[ROW][C]77[/C][C]123[/C][C]112.076923076923[/C][C]10.9230769230769[/C][/ROW]
[ROW][C]78[/C][C]114[/C][C]112.076923076923[/C][C]1.92307692307692[/C][/ROW]
[ROW][C]79[/C][C]75[/C][C]76.9285714285714[/C][C]-1.92857142857143[/C][/ROW]
[ROW][C]80[/C][C]114[/C][C]112.076923076923[/C][C]1.92307692307692[/C][/ROW]
[ROW][C]81[/C][C]94[/C][C]90.7368421052632[/C][C]3.26315789473684[/C][/ROW]
[ROW][C]82[/C][C]116[/C][C]112.076923076923[/C][C]3.92307692307692[/C][/ROW]
[ROW][C]83[/C][C]86[/C][C]90.7368421052632[/C][C]-4.73684210526316[/C][/ROW]
[ROW][C]84[/C][C]90[/C][C]90.7368421052632[/C][C]-0.736842105263165[/C][/ROW]
[ROW][C]85[/C][C]87[/C][C]76.9285714285714[/C][C]10.0714285714286[/C][/ROW]
[ROW][C]86[/C][C]99[/C][C]90.7368421052632[/C][C]8.26315789473684[/C][/ROW]
[ROW][C]87[/C][C]132[/C][C]129.142857142857[/C][C]2.85714285714286[/C][/ROW]
[ROW][C]88[/C][C]96[/C][C]90.7368421052632[/C][C]5.26315789473684[/C][/ROW]
[ROW][C]89[/C][C]91[/C][C]90.7368421052632[/C][C]0.263157894736835[/C][/ROW]
[ROW][C]90[/C][C]77[/C][C]76.9285714285714[/C][C]0.0714285714285694[/C][/ROW]
[ROW][C]91[/C][C]104[/C][C]112.076923076923[/C][C]-8.07692307692308[/C][/ROW]
[ROW][C]92[/C][C]100[/C][C]112.076923076923[/C][C]-12.0769230769231[/C][/ROW]
[ROW][C]93[/C][C]94[/C][C]90.7368421052632[/C][C]3.26315789473684[/C][/ROW]
[ROW][C]94[/C][C]60[/C][C]53.7857142857143[/C][C]6.21428571428572[/C][/ROW]
[ROW][C]95[/C][C]46[/C][C]53.7857142857143[/C][C]-7.78571428571428[/C][/ROW]
[ROW][C]96[/C][C]135[/C][C]129.142857142857[/C][C]5.85714285714286[/C][/ROW]
[ROW][C]97[/C][C]99[/C][C]90.7368421052632[/C][C]8.26315789473684[/C][/ROW]
[ROW][C]98[/C][C]2[/C][C]3.88235294117647[/C][C]-1.88235294117647[/C][/ROW]
[ROW][C]99[/C][C]96[/C][C]90.7368421052632[/C][C]5.26315789473684[/C][/ROW]
[ROW][C]100[/C][C]109[/C][C]112.076923076923[/C][C]-3.07692307692308[/C][/ROW]
[ROW][C]101[/C][C]15[/C][C]3.88235294117647[/C][C]11.1176470588235[/C][/ROW]
[ROW][C]102[/C][C]68[/C][C]76.9285714285714[/C][C]-8.92857142857143[/C][/ROW]
[ROW][C]103[/C][C]102[/C][C]90.7368421052632[/C][C]11.2631578947368[/C][/ROW]
[ROW][C]104[/C][C]84[/C][C]90.7368421052632[/C][C]-6.73684210526316[/C][/ROW]
[ROW][C]105[/C][C]46[/C][C]53.7857142857143[/C][C]-7.78571428571428[/C][/ROW]
[ROW][C]106[/C][C]59[/C][C]53.7857142857143[/C][C]5.21428571428572[/C][/ROW]
[ROW][C]107[/C][C]116[/C][C]112.076923076923[/C][C]3.92307692307692[/C][/ROW]
[ROW][C]108[/C][C]29[/C][C]90.7368421052632[/C][C]-61.7368421052632[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]110[/C][C]91[/C][C]90.7368421052632[/C][C]0.263157894736835[/C][/ROW]
[ROW][C]111[/C][C]76[/C][C]76.9285714285714[/C][C]-0.928571428571431[/C][/ROW]
[ROW][C]112[/C][C]86[/C][C]90.7368421052632[/C][C]-4.73684210526316[/C][/ROW]
[ROW][C]113[/C][C]84[/C][C]76.9285714285714[/C][C]7.07142857142857[/C][/ROW]
[ROW][C]114[/C][C]65[/C][C]76.9285714285714[/C][C]-11.9285714285714[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]117[/C][C]84[/C][C]90.7368421052632[/C][C]-6.73684210526316[/C][/ROW]
[ROW][C]118[/C][C]114[/C][C]129.142857142857[/C][C]-15.1428571428571[/C][/ROW]
[ROW][C]119[/C][C]132[/C][C]129.142857142857[/C][C]2.85714285714286[/C][/ROW]
[ROW][C]120[/C][C]92[/C][C]90.7368421052632[/C][C]1.26315789473684[/C][/ROW]
[ROW][C]121[/C][C]3[/C][C]3.88235294117647[/C][C]-0.882352941176471[/C][/ROW]
[ROW][C]122[/C][C]109[/C][C]112.076923076923[/C][C]-3.07692307692308[/C][/ROW]
[ROW][C]123[/C][C]81[/C][C]76.9285714285714[/C][C]4.07142857142857[/C][/ROW]
[ROW][C]124[/C][C]121[/C][C]129.142857142857[/C][C]-8.14285714285714[/C][/ROW]
[ROW][C]125[/C][C]48[/C][C]53.7857142857143[/C][C]-5.78571428571428[/C][/ROW]
[ROW][C]126[/C][C]8[/C][C]3.88235294117647[/C][C]4.11764705882353[/C][/ROW]
[ROW][C]127[/C][C]80[/C][C]76.9285714285714[/C][C]3.07142857142857[/C][/ROW]
[ROW][C]128[/C][C]107[/C][C]112.076923076923[/C][C]-5.07692307692308[/C][/ROW]
[ROW][C]129[/C][C]140[/C][C]129.142857142857[/C][C]10.8571428571429[/C][/ROW]
[ROW][C]130[/C][C]8[/C][C]3.88235294117647[/C][C]4.11764705882353[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]132[/C][C]56[/C][C]53.7857142857143[/C][C]2.21428571428572[/C][/ROW]
[ROW][C]133[/C][C]4[/C][C]3.88235294117647[/C][C]0.117647058823529[/C][/ROW]
[ROW][C]134[/C][C]70[/C][C]76.9285714285714[/C][C]-6.92857142857143[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]136[/C][C]14[/C][C]3.88235294117647[/C][C]10.1176470588235[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]138[/C][C]104[/C][C]112.076923076923[/C][C]-8.07692307692308[/C][/ROW]
[ROW][C]139[/C][C]89[/C][C]90.7368421052632[/C][C]-1.73684210526316[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]3.88235294117647[/C][C]-3.88235294117647[/C][/ROW]
[ROW][C]141[/C][C]12[/C][C]3.88235294117647[/C][C]8.11764705882353[/C][/ROW]
[ROW][C]142[/C][C]60[/C][C]76.9285714285714[/C][C]-16.9285714285714[/C][/ROW]
[ROW][C]143[/C][C]84[/C][C]76.9285714285714[/C][C]7.07142857142857[/C][/ROW]
[ROW][C]144[/C][C]88[/C][C]76.9285714285714[/C][C]11.0714285714286[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159921&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159921&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
18276.92857142857145.07142857142857
28076.92857142857143.07142857142857
303.88235294117647-3.88235294117647
48490.7368421052632-6.73684210526316
5124112.07692307692311.9230769230769
6140129.14285714285710.8571428571429
78890.7368421052632-2.73684210526316
8115112.0769230769232.92307692307692
9109112.076923076923-3.07692307692308
1010890.736842105263217.2631578947368
116390.7368421052632-27.7368421052632
12118112.0769230769235.92307692307692
137176.9285714285714-5.92857142857143
14112112.076923076923-0.0769230769230802
156353.78571428571439.21428571428572
168676.92857142857149.07142857142857
17148129.14285714285718.8571428571429
185453.78571428571430.214285714285715
19134129.1428571428574.85714285714286
205753.78571428571433.21428571428572
215953.78571428571435.21428571428572
22113112.0769230769230.92307692307692
239690.73684210526325.26315789473684
2496129.142857142857-33.1428571428571
257876.92857142857141.07142857142857
268076.92857142857143.07142857142857
279390.73684210526322.26315789473684
28109112.076923076923-3.07692307692308
29115112.0769230769232.92307692307692
307976.92857142857142.07142857142857
31103112.076923076923-9.07692307692308
327176.9285714285714-5.92857142857143
336653.785714285714312.2142857142857
3410090.73684210526329.26315789473684
3510090.73684210526329.26315789473684
3603.88235294117647-3.88235294117647
37121112.0769230769238.92307692307692
385153.7857142857143-2.78571428571428
39119129.142857142857-10.1428571428571
40136129.1428571428576.85714285714286
418476.92857142857147.07142857142857
42136129.1428571428576.85714285714286
438490.7368421052632-6.73684210526316
449290.73684210526321.26315789473684
4510390.736842105263212.2631578947368
468590.7368421052632-5.73684210526316
47106129.142857142857-23.1428571428571
489690.73684210526325.26315789473684
49124112.07692307692311.9230769230769
50106112.076923076923-6.07692307692308
518276.92857142857145.07142857142857
528790.7368421052632-3.73684210526316
539790.73684210526326.26315789473684
54107112.076923076923-5.07692307692308
55126129.142857142857-3.14285714285714
564353.7857142857143-10.7857142857143
579690.73684210526325.26315789473684
5810090.73684210526329.26315789473684
599190.73684210526320.263157894736835
60136129.1428571428576.85714285714286
61128129.142857142857-1.14285714285714
628376.92857142857146.07142857142857
637476.9285714285714-2.92857142857143
649690.73684210526325.26315789473684
65102112.076923076923-10.0769230769231
66122129.142857142857-7.14285714285714
67144129.14285714285714.8571428571429
689090.7368421052632-0.736842105263165
699790.73684210526326.26315789473684
707876.92857142857141.07142857142857
717276.9285714285714-4.92857142857143
724553.7857142857143-8.78571428571428
73120112.0769230769237.92307692307692
745976.9285714285714-17.9285714285714
75150129.14285714285720.8571428571429
76117129.142857142857-12.1428571428571
77123112.07692307692310.9230769230769
78114112.0769230769231.92307692307692
797576.9285714285714-1.92857142857143
80114112.0769230769231.92307692307692
819490.73684210526323.26315789473684
82116112.0769230769233.92307692307692
838690.7368421052632-4.73684210526316
849090.7368421052632-0.736842105263165
858776.928571428571410.0714285714286
869990.73684210526328.26315789473684
87132129.1428571428572.85714285714286
889690.73684210526325.26315789473684
899190.73684210526320.263157894736835
907776.92857142857140.0714285714285694
91104112.076923076923-8.07692307692308
92100112.076923076923-12.0769230769231
939490.73684210526323.26315789473684
946053.78571428571436.21428571428572
954653.7857142857143-7.78571428571428
96135129.1428571428575.85714285714286
979990.73684210526328.26315789473684
9823.88235294117647-1.88235294117647
999690.73684210526325.26315789473684
100109112.076923076923-3.07692307692308
101153.8823529411764711.1176470588235
1026876.9285714285714-8.92857142857143
10310290.736842105263211.2631578947368
1048490.7368421052632-6.73684210526316
1054653.7857142857143-7.78571428571428
1065953.78571428571435.21428571428572
107116112.0769230769233.92307692307692
1082990.7368421052632-61.7368421052632
10903.88235294117647-3.88235294117647
1109190.73684210526320.263157894736835
1117676.9285714285714-0.928571428571431
1128690.7368421052632-4.73684210526316
1138476.92857142857147.07142857142857
1146576.9285714285714-11.9285714285714
11503.88235294117647-3.88235294117647
11603.88235294117647-3.88235294117647
1178490.7368421052632-6.73684210526316
118114129.142857142857-15.1428571428571
119132129.1428571428572.85714285714286
1209290.73684210526321.26315789473684
12133.88235294117647-0.882352941176471
122109112.076923076923-3.07692307692308
1238176.92857142857144.07142857142857
124121129.142857142857-8.14285714285714
1254853.7857142857143-5.78571428571428
12683.882352941176474.11764705882353
1278076.92857142857143.07142857142857
128107112.076923076923-5.07692307692308
129140129.14285714285710.8571428571429
13083.882352941176474.11764705882353
13103.88235294117647-3.88235294117647
1325653.78571428571432.21428571428572
13343.882352941176470.117647058823529
1347076.9285714285714-6.92857142857143
13503.88235294117647-3.88235294117647
136143.8823529411764710.1176470588235
13703.88235294117647-3.88235294117647
138104112.076923076923-8.07692307692308
1398990.7368421052632-1.73684210526316
14003.88235294117647-3.88235294117647
141123.882352941176478.11764705882353
1426076.9285714285714-16.9285714285714
1438476.92857142857147.07142857142857
1448876.928571428571411.0714285714286



Parameters (Session):
par1 = 1 ; par2 = Do not include Seasonal Dummies ; par3 = No Linear Trend ;
Parameters (R input):
par1 = 7 ; par2 = none ; par3 = 3 ; par4 = no ; par5 = ; par6 = ; par7 = ; par8 = ; par9 = ; par10 = ; par11 = ; par12 = ; par13 = ; par14 = ; par15 = ; par16 = ; par17 = ; par18 = ; par19 = ; par20 = ;
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')
}