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 09:51:57 -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/t13239608018e2i19jcyvhb0o6.htm/, Retrieved Wed, 08 May 2024 13:22:35 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=155457, Retrieved Wed, 08 May 2024 13:22:35 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact81
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-15 14:51:57] [8a4496bd93dae12a8bdfa51e6ea7daab] [Current]
Feedback Forum

Post a new message
Dataseries X:
1575	129988	81	20	18	70	18158	5636	22622	30	28
1134	130358	46	38	17	68	30461	9079	73570	42	39
192	7215	18	0	0	0	1423	603	1929	0	0
2044	112976	87	49	22	68	25629	8874	36294	54	54
3283	219904	126	76	30	120	48758	17988	62378	86	80
5877	402036	218	104	31	120	129230	21325	167760	157	144
1322	117604	50	37	19	72	27376	8325	52443	36	36
1225	131822	50	57	25	96	26706	7117	57283	48	48
1463	99729	38	42	30	109	26505	7996	36614	45	42
2671	269088	87	67	26	104	49801	14218	93268	77	71
1810	113066	69	50	20	54	46580	6321	35439	49	49
1915	165392	62	66	30	118	48352	19690	72405	77	74
1452	78240	90	38	15	49	13899	5659	24044	28	27
2415	152673	84	48	22	88	39342	11370	55909	84	83
1254	134368	47	42	17	60	27465	4778	44689	31	31
1375	125769	68	47	19	74	55211	5954	49319	28	28
1504	123467	50	71	28	112	74098	22924	62075	99	98
1016	57396	49	0	12	45	13497	70	2341	2	2
2222	108458	79	50	28	110	38338	14369	40551	41	43
634	22762	21	12	13	39	52505	3706	11621	25	24
849	48633	50	16	14	55	10663	3147	18741	16	16
2189	182081	83	77	27	102	74484	16801	84202	96	95
1520	149502	61	32	25	96	28895	2162	15334	23	22
1791	93773	46	38	30	86	32827	4721	28024	33	33
1751	133428	79	50	21	78	36188	5290	53306	46	45
1180	113933	23	33	17	64	28173	6446	37918	59	59
1750	153851	140	49	22	82	54926	14711	54819	72	66
1101	140711	75	59	28	100	38900	13311	89058	72	70
2398	303863	106	55	26	99	88530	13577	103354	62	56
1826	163810	38	42	17	67	35482	14634	70239	55	55
1410	134521	41	47	23	87	26730	6931	33045	27	27
1433	157640	39	51	20	65	29806	9992	63852	41	37
1893	103274	90	45	16	63	41799	6185	30905	51	48
2525	193500	105	73	20	80	54289	3445	24242	26	26
2033	178768	43	51	21	84	36805	12327	78907	65	64
1	0	1	0	0	0	0	0	0	0	0
1817	181412	55	46	27	105	33146	9898	36005	28	21
1506	92342	47	44	14	51	23333	8022	31972	44	44
1924	115762	42	33	31	104	47686	10765	35853	36	36
1649	178277	50	71	31	124	77783	22717	115301	100	89
1672	145067	58	61	19	75	36042	10090	47689	104	101
1433	114146	50	28	30	120	34541	12385	34223	35	31
866	86039	26	21	23	84	75620	8513	43431	69	65
1683	125481	66	42	21	82	60610	5508	52220	73	71
1024	95535	42	44	22	87	55041	9628	33863	106	102
1029	129221	78	40	21	78	32087	11872	46879	53	53
629	61554	26	15	32	97	16356	4186	23228	43	41
1693	170811	83	46	21	84	40161	10877	42827	49	46
1715	159121	75	43	26	104	55459	17066	65765	38	37
2248	137317	52	57	25	93	36679	9175	38167	51	51
658	48188	28	12	22	82	22346	2102	14812	14	14
1234	95461	56	46	19	73	27377	10807	32615	40	40
2157	249356	65	60	24	87	50273	13662	82188	79	77
1725	191094	68	47	26	95	32104	9224	51763	52	51
1504	161082	51	50	27	105	27016	9001	59325	44	43
1454	111388	47	35	10	37	19715	7204	48976	34	33
1620	172614	58	45	26	96	33629	6572	43384	47	47
733	63205	18	25	23	88	27084	7509	26692	32	31
894	109102	56	47	21	83	32352	12920	53279	31	31
2355	137519	75	28	34	124	51845	5438	20652	40	40
1514	125777	51	48	29	116	26591	11489	38338	42	42
1636	88650	66	32	19	76	29677	6661	36735	34	35
1123	95845	50	28	19	65	54237	7941	42764	40	40
897	83419	29	31	23	86	20284	6173	44331	35	30
855	101723	25	13	22	85	22741	5562	41354	11	11
1229	94982	37	38	29	107	34178	9492	47879	43	41
2012	145568	62	49	31	124	69551	17456	103793	53	53
2393	113325	63	68	21	78	29653	9422	52235	82	82
878	87133	33	36	24	93	38071	10913	49825	41	41
340	31970	15	5	21	78	4157	1283	4105	6	6
2480	194516	103	53	15	59	28321	6198	58687	82	81
1071	98324	56	36	9	33	40195	4501	40745	47	47
1091	80820	56	54	23	92	48158	9560	33187	108	100
1425	89141	60	37	18	52	13310	3394	14063	46	46
2227	118147	55	52	34	133	78474	9871	37407	38	38
1082	56544	32	0	25	92	6386	2419	7190	0	0
1790	118838	52	52	25	103	31588	10630	49562	45	45
2072	118781	80	51	22	86	61254	8536	76324	57	56
816	60138	23	16	21	75	21152	4911	21928	20	18
1121	73422	66	33	26	96	41272	9775	27860	56	54
834	70248	60	48	22	81	34165	11227	28078	38	37
1766	225857	54	35	26	104	37054	6916	49577	42	40
751	51185	24	24	20	76	12368	3424	28145	37	37
1309	97181	32	37	25	90	23168	8637	36241	36	36
732	45100	39	17	19	75	16380	3189	10824	34	34
1327	115801	43	32	22	86	41242	8178	46892	53	49
2246	186310	190	55	25	100	48450	16739	61264	85	82
968	71960	86	39	22	88	20790	6094	22933	36	36
1015	80105	48	31	21	80	34585	7237	20787	33	33
1149	110416	43	26	21	77	35672	7355	43978	57	55
1301	98707	34	37	23	88	52168	9734	51305	50	50
1982	136234	67	66	22	79	53933	11225	55593	71	71
1092	136781	53	35	21	81	34474	6213	51648	32	31
1162	116132	54	24	12	48	43753	4875	30552	45	42
759	49164	33	22	13	46	36456	8159	23470	33	31
1980	189493	93	42	32	120	51183	11893	77530	53	51
1608	169406	50	86	24	90	52742	10754	57299	64	64
223	19349	12	13	1	2	3895	786	9604	14	14
1810	160902	88	21	24	96	37076	9706	34684	38	37
1466	109510	53	32	25	86	24079	7796	41094	39	37
553	43803	25	8	4	15	2325	593	3439	8	8
708	47062	19	38	15	48	29354	5600	25171	38	38
1079	110845	44	45	21	81	30341	7245	23437	24	23
957	92517	52	24	23	84	18992	7360	34086	22	22
585	58660	36	23	12	46	15292	4574	24649	18	18
596	27676	22	2	16	59	5842	522	2342	3	1
981	98550	33	52	24	96	28918	10905	45571	49	48
585	43646	24	5	9	29	3738	999	3255	5	5
0	0	0	0	0	0	0	0	0	0	0
975	75566	28	43	25	91	95352	9016	30002	47	46
751	57359	49	18	17	63	37478	5134	19360	33	33
1071	104330	36	44	18	68	26839	6608	43320	44	41
931	70369	47	45	21	84	26783	8577	35513	56	57
783	65494	56	29	17	54	33392	1543	23536	49	49
78	3616	5	0	0	0	0	0	0	0	0
0	0	0	0	0	0	0	0	0	0	0
874	143931	37	32	20	75	25446	9803	54438	45	45
1327	117946	66	65	26	87	59847	12140	56812	78	78
1843	138702	86	26	27	108	28162	6678	33838	51	46
750	84336	33	24	20	80	33298	6420	32366	25	25
778	43410	19	7	1	3	2781	4	13	1	1
1442	139695	61	62	25	96	37121	7979	55082	62	59
807	79015	34	30	14	55	22698	5141	31334	29	29
1613	106116	47	54	27	99	27615	1311	16612	26	26
685	57586	38	3	12	48	32689	443	5084	4	4
285	19764	12	10	2	8	5752	2416	9927	10	10
1418	112195	43	46	16	60	23164	8396	47413	43	43
954	103651	25	23	23	88	20304	5462	27389	36	36
1283	113402	35	40	28	112	34409	7271	30425	43	41
256	11796	9	1	2	8	0	0	0	0	0
81	7627	9	0	0	0	0	0	0	0	0
1215	121085	50	29	17	52	92538	4423	33510	33	32
41	6836	3	0	1	4	0	0	0	0	0
1634	139563	46	46	17	57	46037	5331	40389	53	53
42	5118	3	5	0	0	0	0	0	0	0
528	40248	16	8	4	14	5444	775	6012	6	6
0	0	0	0	0	0	0	0	0	0	0
890	95079	42	21	25	91	23924	6676	22205	19	18
1203	80763	32	21	26	89	52230	1489	17231	26	26
81	7131	4	0	0	0	0	0	0	0	0
61	4194	11	0	0	0	0	0	0	0	0
849	60378	20	15	15	54	8019	3080	11017	16	16
1035	109173	44	47	20	77	34542	11409	46741	84	84
964	83484	16	17	19	76	21157	6769	39869	28	22




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

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

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

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

As an alternative you can also use a QR Code:  

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

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







Goodness of Fit
Correlation0.7791
R-squared0.6071
RMSE13592.2227

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7791[/C][/ROW]
[ROW][C]R-squared[/C][C]0.6071[/C][/ROW]
[ROW][C]RMSE[/C][C]13592.2227[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155457&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155457&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.7791
R-squared0.6071
RMSE13592.2227







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
11815829231.2857142857-11073.2857142857
23046129231.28571428571229.71428571429
314231379.5294117647143.4705882352941
42562943938.4772727273-18309.4772727273
54875843938.47727272734819.52272727273
612923075468.428571428653761.5714285714
72737629231.2857142857-1855.28571428571
82670643938.4772727273-17232.4772727273
92650529231.2857142857-2726.28571428571
104980175468.4285714286-25667.4285714286
114658043938.47727272732641.52272727273
124835243938.47727272734413.52272727273
131389929231.2857142857-15332.2857142857
143934243938.4772727273-4596.47727272727
152746529231.2857142857-1766.28571428571
165521129231.285714285725979.7142857143
177409843938.477272727330159.5227272727
181349711109.52387.5
193833844497.5-6159.5
205250529231.285714285723273.7142857143
211066329231.2857142857-18568.2857142857
227448475468.4285714286-984.428571428565
232889529231.2857142857-336.285714285714
243282744497.5-11670.5
253618844497.5-8309.5
262817343938.4772727273-15765.4772727273
275492643938.477272727310987.5227272727
283890075468.4285714286-36568.4285714286
298853075468.428571428613061.5714285714
303548243938.4772727273-8456.47727272727
312673029231.2857142857-2501.28571428571
322980629231.2857142857574.714285714286
334179943938.4772727273-2139.47727272727
345428944497.59791.5
353680543938.4772727273-7133.47727272727
3601379.52941176471-1379.52941176471
373314644497.5-11351.5
382333329231.2857142857-5898.28571428571
394768644497.53188.5
407778375468.42857142862314.57142857143
413604243938.4772727273-7896.47727272727
423454129231.28571428575309.71428571429
437562043938.477272727331681.5227272727
446061043938.477272727316671.5227272727
455504143938.477272727311102.5227272727
463208743938.4772727273-11851.4772727273
471635629231.2857142857-12875.2857142857
484016143938.4772727273-3777.47727272727
495545944497.510961.5
503667943938.4772727273-7259.47727272727
512234629231.2857142857-6885.28571428571
522737729231.2857142857-1854.28571428571
535027343938.47727272736334.52272727273
543210443938.4772727273-11834.4772727273
552701629231.2857142857-2215.28571428571
561971529231.2857142857-9516.28571428571
573362943938.4772727273-10309.4772727273
582708429231.2857142857-2147.28571428571
593235229231.28571428573120.71428571429
605184544497.57347.5
612659129231.2857142857-2640.28571428571
622967729231.2857142857445.714285714286
635423729231.285714285725005.7142857143
642028429231.2857142857-8947.28571428571
652274129231.2857142857-6490.28571428571
663417829231.28571428574946.71428571429
676955175468.4285714286-5917.42857142857
682965343938.4772727273-14285.4772727273
693807129231.28571428578839.71428571429
7041571379.529411764712777.47058823529
712832143938.4772727273-15617.4772727273
724019543938.4772727273-3743.47727272727
734815843938.47727272734219.52272727273
741331029231.2857142857-15921.2857142857
757847444497.533976.5
76638611109.5-4723.5
773158844497.5-12909.5
786125443938.477272727317315.5227272727
792115229231.2857142857-8079.28571428571
804127243938.4772727273-2666.47727272727
813416529231.28571428574933.71428571429
823705444497.5-7443.5
831236829231.2857142857-16863.2857142857
842316829231.2857142857-6063.28571428571
851638011109.55270.5
864124243938.4772727273-2696.47727272727
874845043938.47727272734511.52272727273
882079029231.2857142857-8441.28571428571
893458529231.28571428575353.71428571429
903567243938.4772727273-8266.47727272727
915216843938.47727272738229.52272727273
925393343938.47727272739994.52272727273
933447429231.28571428575242.71428571429
944375329231.285714285714521.7142857143
953645629231.28571428577224.71428571429
965118343938.47727272737244.52272727273
975274243938.47727272738803.52272727273
9838951379.529411764712515.47058823529
993707644497.5-7421.5
1002407929231.2857142857-5152.28571428571
101232511109.5-8784.5
1022935429231.2857142857122.714285714286
1033034129231.28571428571109.71428571429
1041899229231.2857142857-10239.2857142857
1051529229231.2857142857-13939.2857142857
106584211109.5-5267.5
1072891843938.4772727273-15020.4772727273
108373811109.5-7371.5
10901379.52941176471-1379.52941176471
1109535243938.477272727351413.5227272727
1113747829231.28571428578246.7142857143
1122683929231.2857142857-2392.28571428571
1132678343938.4772727273-17155.4772727273
1143339243938.4772727273-10546.4772727273
11501379.52941176471-1379.52941176471
11601379.52941176471-1379.52941176471
1172544629231.2857142857-3785.28571428571
1185984743938.477272727315908.5227272727
1192816243938.4772727273-15776.4772727273
1203329829231.28571428574066.71428571429
12127811379.529411764711401.47058823529
1223712143938.4772727273-6817.47727272727
1232269829231.2857142857-6533.28571428571
1242761529231.2857142857-1616.28571428571
1253268911109.521579.5
12657521379.529411764714372.47058823529
1272316429231.2857142857-6067.28571428571
1282030429231.2857142857-8927.28571428571
1293440929231.28571428575177.71428571429
13001379.52941176471-1379.52941176471
13101379.52941176471-1379.52941176471
1329253829231.285714285763306.7142857143
13301379.52941176471-1379.52941176471
1344603743938.47727272732098.52272727273
13501379.52941176471-1379.52941176471
13654441379.529411764714064.47058823529
13701379.52941176471-1379.52941176471
1382392429231.2857142857-5307.28571428571
1395223029231.285714285722998.7142857143
14001379.52941176471-1379.52941176471
14101379.52941176471-1379.52941176471
142801911109.5-3090.5
1433454243938.4772727273-9396.47727272727
1442115729231.2857142857-8074.28571428571

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 18158 & 29231.2857142857 & -11073.2857142857 \tabularnewline
2 & 30461 & 29231.2857142857 & 1229.71428571429 \tabularnewline
3 & 1423 & 1379.52941176471 & 43.4705882352941 \tabularnewline
4 & 25629 & 43938.4772727273 & -18309.4772727273 \tabularnewline
5 & 48758 & 43938.4772727273 & 4819.52272727273 \tabularnewline
6 & 129230 & 75468.4285714286 & 53761.5714285714 \tabularnewline
7 & 27376 & 29231.2857142857 & -1855.28571428571 \tabularnewline
8 & 26706 & 43938.4772727273 & -17232.4772727273 \tabularnewline
9 & 26505 & 29231.2857142857 & -2726.28571428571 \tabularnewline
10 & 49801 & 75468.4285714286 & -25667.4285714286 \tabularnewline
11 & 46580 & 43938.4772727273 & 2641.52272727273 \tabularnewline
12 & 48352 & 43938.4772727273 & 4413.52272727273 \tabularnewline
13 & 13899 & 29231.2857142857 & -15332.2857142857 \tabularnewline
14 & 39342 & 43938.4772727273 & -4596.47727272727 \tabularnewline
15 & 27465 & 29231.2857142857 & -1766.28571428571 \tabularnewline
16 & 55211 & 29231.2857142857 & 25979.7142857143 \tabularnewline
17 & 74098 & 43938.4772727273 & 30159.5227272727 \tabularnewline
18 & 13497 & 11109.5 & 2387.5 \tabularnewline
19 & 38338 & 44497.5 & -6159.5 \tabularnewline
20 & 52505 & 29231.2857142857 & 23273.7142857143 \tabularnewline
21 & 10663 & 29231.2857142857 & -18568.2857142857 \tabularnewline
22 & 74484 & 75468.4285714286 & -984.428571428565 \tabularnewline
23 & 28895 & 29231.2857142857 & -336.285714285714 \tabularnewline
24 & 32827 & 44497.5 & -11670.5 \tabularnewline
25 & 36188 & 44497.5 & -8309.5 \tabularnewline
26 & 28173 & 43938.4772727273 & -15765.4772727273 \tabularnewline
27 & 54926 & 43938.4772727273 & 10987.5227272727 \tabularnewline
28 & 38900 & 75468.4285714286 & -36568.4285714286 \tabularnewline
29 & 88530 & 75468.4285714286 & 13061.5714285714 \tabularnewline
30 & 35482 & 43938.4772727273 & -8456.47727272727 \tabularnewline
31 & 26730 & 29231.2857142857 & -2501.28571428571 \tabularnewline
32 & 29806 & 29231.2857142857 & 574.714285714286 \tabularnewline
33 & 41799 & 43938.4772727273 & -2139.47727272727 \tabularnewline
34 & 54289 & 44497.5 & 9791.5 \tabularnewline
35 & 36805 & 43938.4772727273 & -7133.47727272727 \tabularnewline
36 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
37 & 33146 & 44497.5 & -11351.5 \tabularnewline
38 & 23333 & 29231.2857142857 & -5898.28571428571 \tabularnewline
39 & 47686 & 44497.5 & 3188.5 \tabularnewline
40 & 77783 & 75468.4285714286 & 2314.57142857143 \tabularnewline
41 & 36042 & 43938.4772727273 & -7896.47727272727 \tabularnewline
42 & 34541 & 29231.2857142857 & 5309.71428571429 \tabularnewline
43 & 75620 & 43938.4772727273 & 31681.5227272727 \tabularnewline
44 & 60610 & 43938.4772727273 & 16671.5227272727 \tabularnewline
45 & 55041 & 43938.4772727273 & 11102.5227272727 \tabularnewline
46 & 32087 & 43938.4772727273 & -11851.4772727273 \tabularnewline
47 & 16356 & 29231.2857142857 & -12875.2857142857 \tabularnewline
48 & 40161 & 43938.4772727273 & -3777.47727272727 \tabularnewline
49 & 55459 & 44497.5 & 10961.5 \tabularnewline
50 & 36679 & 43938.4772727273 & -7259.47727272727 \tabularnewline
51 & 22346 & 29231.2857142857 & -6885.28571428571 \tabularnewline
52 & 27377 & 29231.2857142857 & -1854.28571428571 \tabularnewline
53 & 50273 & 43938.4772727273 & 6334.52272727273 \tabularnewline
54 & 32104 & 43938.4772727273 & -11834.4772727273 \tabularnewline
55 & 27016 & 29231.2857142857 & -2215.28571428571 \tabularnewline
56 & 19715 & 29231.2857142857 & -9516.28571428571 \tabularnewline
57 & 33629 & 43938.4772727273 & -10309.4772727273 \tabularnewline
58 & 27084 & 29231.2857142857 & -2147.28571428571 \tabularnewline
59 & 32352 & 29231.2857142857 & 3120.71428571429 \tabularnewline
60 & 51845 & 44497.5 & 7347.5 \tabularnewline
61 & 26591 & 29231.2857142857 & -2640.28571428571 \tabularnewline
62 & 29677 & 29231.2857142857 & 445.714285714286 \tabularnewline
63 & 54237 & 29231.2857142857 & 25005.7142857143 \tabularnewline
64 & 20284 & 29231.2857142857 & -8947.28571428571 \tabularnewline
65 & 22741 & 29231.2857142857 & -6490.28571428571 \tabularnewline
66 & 34178 & 29231.2857142857 & 4946.71428571429 \tabularnewline
67 & 69551 & 75468.4285714286 & -5917.42857142857 \tabularnewline
68 & 29653 & 43938.4772727273 & -14285.4772727273 \tabularnewline
69 & 38071 & 29231.2857142857 & 8839.71428571429 \tabularnewline
70 & 4157 & 1379.52941176471 & 2777.47058823529 \tabularnewline
71 & 28321 & 43938.4772727273 & -15617.4772727273 \tabularnewline
72 & 40195 & 43938.4772727273 & -3743.47727272727 \tabularnewline
73 & 48158 & 43938.4772727273 & 4219.52272727273 \tabularnewline
74 & 13310 & 29231.2857142857 & -15921.2857142857 \tabularnewline
75 & 78474 & 44497.5 & 33976.5 \tabularnewline
76 & 6386 & 11109.5 & -4723.5 \tabularnewline
77 & 31588 & 44497.5 & -12909.5 \tabularnewline
78 & 61254 & 43938.4772727273 & 17315.5227272727 \tabularnewline
79 & 21152 & 29231.2857142857 & -8079.28571428571 \tabularnewline
80 & 41272 & 43938.4772727273 & -2666.47727272727 \tabularnewline
81 & 34165 & 29231.2857142857 & 4933.71428571429 \tabularnewline
82 & 37054 & 44497.5 & -7443.5 \tabularnewline
83 & 12368 & 29231.2857142857 & -16863.2857142857 \tabularnewline
84 & 23168 & 29231.2857142857 & -6063.28571428571 \tabularnewline
85 & 16380 & 11109.5 & 5270.5 \tabularnewline
86 & 41242 & 43938.4772727273 & -2696.47727272727 \tabularnewline
87 & 48450 & 43938.4772727273 & 4511.52272727273 \tabularnewline
88 & 20790 & 29231.2857142857 & -8441.28571428571 \tabularnewline
89 & 34585 & 29231.2857142857 & 5353.71428571429 \tabularnewline
90 & 35672 & 43938.4772727273 & -8266.47727272727 \tabularnewline
91 & 52168 & 43938.4772727273 & 8229.52272727273 \tabularnewline
92 & 53933 & 43938.4772727273 & 9994.52272727273 \tabularnewline
93 & 34474 & 29231.2857142857 & 5242.71428571429 \tabularnewline
94 & 43753 & 29231.2857142857 & 14521.7142857143 \tabularnewline
95 & 36456 & 29231.2857142857 & 7224.71428571429 \tabularnewline
96 & 51183 & 43938.4772727273 & 7244.52272727273 \tabularnewline
97 & 52742 & 43938.4772727273 & 8803.52272727273 \tabularnewline
98 & 3895 & 1379.52941176471 & 2515.47058823529 \tabularnewline
99 & 37076 & 44497.5 & -7421.5 \tabularnewline
100 & 24079 & 29231.2857142857 & -5152.28571428571 \tabularnewline
101 & 2325 & 11109.5 & -8784.5 \tabularnewline
102 & 29354 & 29231.2857142857 & 122.714285714286 \tabularnewline
103 & 30341 & 29231.2857142857 & 1109.71428571429 \tabularnewline
104 & 18992 & 29231.2857142857 & -10239.2857142857 \tabularnewline
105 & 15292 & 29231.2857142857 & -13939.2857142857 \tabularnewline
106 & 5842 & 11109.5 & -5267.5 \tabularnewline
107 & 28918 & 43938.4772727273 & -15020.4772727273 \tabularnewline
108 & 3738 & 11109.5 & -7371.5 \tabularnewline
109 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
110 & 95352 & 43938.4772727273 & 51413.5227272727 \tabularnewline
111 & 37478 & 29231.2857142857 & 8246.7142857143 \tabularnewline
112 & 26839 & 29231.2857142857 & -2392.28571428571 \tabularnewline
113 & 26783 & 43938.4772727273 & -17155.4772727273 \tabularnewline
114 & 33392 & 43938.4772727273 & -10546.4772727273 \tabularnewline
115 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
116 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
117 & 25446 & 29231.2857142857 & -3785.28571428571 \tabularnewline
118 & 59847 & 43938.4772727273 & 15908.5227272727 \tabularnewline
119 & 28162 & 43938.4772727273 & -15776.4772727273 \tabularnewline
120 & 33298 & 29231.2857142857 & 4066.71428571429 \tabularnewline
121 & 2781 & 1379.52941176471 & 1401.47058823529 \tabularnewline
122 & 37121 & 43938.4772727273 & -6817.47727272727 \tabularnewline
123 & 22698 & 29231.2857142857 & -6533.28571428571 \tabularnewline
124 & 27615 & 29231.2857142857 & -1616.28571428571 \tabularnewline
125 & 32689 & 11109.5 & 21579.5 \tabularnewline
126 & 5752 & 1379.52941176471 & 4372.47058823529 \tabularnewline
127 & 23164 & 29231.2857142857 & -6067.28571428571 \tabularnewline
128 & 20304 & 29231.2857142857 & -8927.28571428571 \tabularnewline
129 & 34409 & 29231.2857142857 & 5177.71428571429 \tabularnewline
130 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
131 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
132 & 92538 & 29231.2857142857 & 63306.7142857143 \tabularnewline
133 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
134 & 46037 & 43938.4772727273 & 2098.52272727273 \tabularnewline
135 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
136 & 5444 & 1379.52941176471 & 4064.47058823529 \tabularnewline
137 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
138 & 23924 & 29231.2857142857 & -5307.28571428571 \tabularnewline
139 & 52230 & 29231.2857142857 & 22998.7142857143 \tabularnewline
140 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
141 & 0 & 1379.52941176471 & -1379.52941176471 \tabularnewline
142 & 8019 & 11109.5 & -3090.5 \tabularnewline
143 & 34542 & 43938.4772727273 & -9396.47727272727 \tabularnewline
144 & 21157 & 29231.2857142857 & -8074.28571428571 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=155457&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]18158[/C][C]29231.2857142857[/C][C]-11073.2857142857[/C][/ROW]
[ROW][C]2[/C][C]30461[/C][C]29231.2857142857[/C][C]1229.71428571429[/C][/ROW]
[ROW][C]3[/C][C]1423[/C][C]1379.52941176471[/C][C]43.4705882352941[/C][/ROW]
[ROW][C]4[/C][C]25629[/C][C]43938.4772727273[/C][C]-18309.4772727273[/C][/ROW]
[ROW][C]5[/C][C]48758[/C][C]43938.4772727273[/C][C]4819.52272727273[/C][/ROW]
[ROW][C]6[/C][C]129230[/C][C]75468.4285714286[/C][C]53761.5714285714[/C][/ROW]
[ROW][C]7[/C][C]27376[/C][C]29231.2857142857[/C][C]-1855.28571428571[/C][/ROW]
[ROW][C]8[/C][C]26706[/C][C]43938.4772727273[/C][C]-17232.4772727273[/C][/ROW]
[ROW][C]9[/C][C]26505[/C][C]29231.2857142857[/C][C]-2726.28571428571[/C][/ROW]
[ROW][C]10[/C][C]49801[/C][C]75468.4285714286[/C][C]-25667.4285714286[/C][/ROW]
[ROW][C]11[/C][C]46580[/C][C]43938.4772727273[/C][C]2641.52272727273[/C][/ROW]
[ROW][C]12[/C][C]48352[/C][C]43938.4772727273[/C][C]4413.52272727273[/C][/ROW]
[ROW][C]13[/C][C]13899[/C][C]29231.2857142857[/C][C]-15332.2857142857[/C][/ROW]
[ROW][C]14[/C][C]39342[/C][C]43938.4772727273[/C][C]-4596.47727272727[/C][/ROW]
[ROW][C]15[/C][C]27465[/C][C]29231.2857142857[/C][C]-1766.28571428571[/C][/ROW]
[ROW][C]16[/C][C]55211[/C][C]29231.2857142857[/C][C]25979.7142857143[/C][/ROW]
[ROW][C]17[/C][C]74098[/C][C]43938.4772727273[/C][C]30159.5227272727[/C][/ROW]
[ROW][C]18[/C][C]13497[/C][C]11109.5[/C][C]2387.5[/C][/ROW]
[ROW][C]19[/C][C]38338[/C][C]44497.5[/C][C]-6159.5[/C][/ROW]
[ROW][C]20[/C][C]52505[/C][C]29231.2857142857[/C][C]23273.7142857143[/C][/ROW]
[ROW][C]21[/C][C]10663[/C][C]29231.2857142857[/C][C]-18568.2857142857[/C][/ROW]
[ROW][C]22[/C][C]74484[/C][C]75468.4285714286[/C][C]-984.428571428565[/C][/ROW]
[ROW][C]23[/C][C]28895[/C][C]29231.2857142857[/C][C]-336.285714285714[/C][/ROW]
[ROW][C]24[/C][C]32827[/C][C]44497.5[/C][C]-11670.5[/C][/ROW]
[ROW][C]25[/C][C]36188[/C][C]44497.5[/C][C]-8309.5[/C][/ROW]
[ROW][C]26[/C][C]28173[/C][C]43938.4772727273[/C][C]-15765.4772727273[/C][/ROW]
[ROW][C]27[/C][C]54926[/C][C]43938.4772727273[/C][C]10987.5227272727[/C][/ROW]
[ROW][C]28[/C][C]38900[/C][C]75468.4285714286[/C][C]-36568.4285714286[/C][/ROW]
[ROW][C]29[/C][C]88530[/C][C]75468.4285714286[/C][C]13061.5714285714[/C][/ROW]
[ROW][C]30[/C][C]35482[/C][C]43938.4772727273[/C][C]-8456.47727272727[/C][/ROW]
[ROW][C]31[/C][C]26730[/C][C]29231.2857142857[/C][C]-2501.28571428571[/C][/ROW]
[ROW][C]32[/C][C]29806[/C][C]29231.2857142857[/C][C]574.714285714286[/C][/ROW]
[ROW][C]33[/C][C]41799[/C][C]43938.4772727273[/C][C]-2139.47727272727[/C][/ROW]
[ROW][C]34[/C][C]54289[/C][C]44497.5[/C][C]9791.5[/C][/ROW]
[ROW][C]35[/C][C]36805[/C][C]43938.4772727273[/C][C]-7133.47727272727[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]37[/C][C]33146[/C][C]44497.5[/C][C]-11351.5[/C][/ROW]
[ROW][C]38[/C][C]23333[/C][C]29231.2857142857[/C][C]-5898.28571428571[/C][/ROW]
[ROW][C]39[/C][C]47686[/C][C]44497.5[/C][C]3188.5[/C][/ROW]
[ROW][C]40[/C][C]77783[/C][C]75468.4285714286[/C][C]2314.57142857143[/C][/ROW]
[ROW][C]41[/C][C]36042[/C][C]43938.4772727273[/C][C]-7896.47727272727[/C][/ROW]
[ROW][C]42[/C][C]34541[/C][C]29231.2857142857[/C][C]5309.71428571429[/C][/ROW]
[ROW][C]43[/C][C]75620[/C][C]43938.4772727273[/C][C]31681.5227272727[/C][/ROW]
[ROW][C]44[/C][C]60610[/C][C]43938.4772727273[/C][C]16671.5227272727[/C][/ROW]
[ROW][C]45[/C][C]55041[/C][C]43938.4772727273[/C][C]11102.5227272727[/C][/ROW]
[ROW][C]46[/C][C]32087[/C][C]43938.4772727273[/C][C]-11851.4772727273[/C][/ROW]
[ROW][C]47[/C][C]16356[/C][C]29231.2857142857[/C][C]-12875.2857142857[/C][/ROW]
[ROW][C]48[/C][C]40161[/C][C]43938.4772727273[/C][C]-3777.47727272727[/C][/ROW]
[ROW][C]49[/C][C]55459[/C][C]44497.5[/C][C]10961.5[/C][/ROW]
[ROW][C]50[/C][C]36679[/C][C]43938.4772727273[/C][C]-7259.47727272727[/C][/ROW]
[ROW][C]51[/C][C]22346[/C][C]29231.2857142857[/C][C]-6885.28571428571[/C][/ROW]
[ROW][C]52[/C][C]27377[/C][C]29231.2857142857[/C][C]-1854.28571428571[/C][/ROW]
[ROW][C]53[/C][C]50273[/C][C]43938.4772727273[/C][C]6334.52272727273[/C][/ROW]
[ROW][C]54[/C][C]32104[/C][C]43938.4772727273[/C][C]-11834.4772727273[/C][/ROW]
[ROW][C]55[/C][C]27016[/C][C]29231.2857142857[/C][C]-2215.28571428571[/C][/ROW]
[ROW][C]56[/C][C]19715[/C][C]29231.2857142857[/C][C]-9516.28571428571[/C][/ROW]
[ROW][C]57[/C][C]33629[/C][C]43938.4772727273[/C][C]-10309.4772727273[/C][/ROW]
[ROW][C]58[/C][C]27084[/C][C]29231.2857142857[/C][C]-2147.28571428571[/C][/ROW]
[ROW][C]59[/C][C]32352[/C][C]29231.2857142857[/C][C]3120.71428571429[/C][/ROW]
[ROW][C]60[/C][C]51845[/C][C]44497.5[/C][C]7347.5[/C][/ROW]
[ROW][C]61[/C][C]26591[/C][C]29231.2857142857[/C][C]-2640.28571428571[/C][/ROW]
[ROW][C]62[/C][C]29677[/C][C]29231.2857142857[/C][C]445.714285714286[/C][/ROW]
[ROW][C]63[/C][C]54237[/C][C]29231.2857142857[/C][C]25005.7142857143[/C][/ROW]
[ROW][C]64[/C][C]20284[/C][C]29231.2857142857[/C][C]-8947.28571428571[/C][/ROW]
[ROW][C]65[/C][C]22741[/C][C]29231.2857142857[/C][C]-6490.28571428571[/C][/ROW]
[ROW][C]66[/C][C]34178[/C][C]29231.2857142857[/C][C]4946.71428571429[/C][/ROW]
[ROW][C]67[/C][C]69551[/C][C]75468.4285714286[/C][C]-5917.42857142857[/C][/ROW]
[ROW][C]68[/C][C]29653[/C][C]43938.4772727273[/C][C]-14285.4772727273[/C][/ROW]
[ROW][C]69[/C][C]38071[/C][C]29231.2857142857[/C][C]8839.71428571429[/C][/ROW]
[ROW][C]70[/C][C]4157[/C][C]1379.52941176471[/C][C]2777.47058823529[/C][/ROW]
[ROW][C]71[/C][C]28321[/C][C]43938.4772727273[/C][C]-15617.4772727273[/C][/ROW]
[ROW][C]72[/C][C]40195[/C][C]43938.4772727273[/C][C]-3743.47727272727[/C][/ROW]
[ROW][C]73[/C][C]48158[/C][C]43938.4772727273[/C][C]4219.52272727273[/C][/ROW]
[ROW][C]74[/C][C]13310[/C][C]29231.2857142857[/C][C]-15921.2857142857[/C][/ROW]
[ROW][C]75[/C][C]78474[/C][C]44497.5[/C][C]33976.5[/C][/ROW]
[ROW][C]76[/C][C]6386[/C][C]11109.5[/C][C]-4723.5[/C][/ROW]
[ROW][C]77[/C][C]31588[/C][C]44497.5[/C][C]-12909.5[/C][/ROW]
[ROW][C]78[/C][C]61254[/C][C]43938.4772727273[/C][C]17315.5227272727[/C][/ROW]
[ROW][C]79[/C][C]21152[/C][C]29231.2857142857[/C][C]-8079.28571428571[/C][/ROW]
[ROW][C]80[/C][C]41272[/C][C]43938.4772727273[/C][C]-2666.47727272727[/C][/ROW]
[ROW][C]81[/C][C]34165[/C][C]29231.2857142857[/C][C]4933.71428571429[/C][/ROW]
[ROW][C]82[/C][C]37054[/C][C]44497.5[/C][C]-7443.5[/C][/ROW]
[ROW][C]83[/C][C]12368[/C][C]29231.2857142857[/C][C]-16863.2857142857[/C][/ROW]
[ROW][C]84[/C][C]23168[/C][C]29231.2857142857[/C][C]-6063.28571428571[/C][/ROW]
[ROW][C]85[/C][C]16380[/C][C]11109.5[/C][C]5270.5[/C][/ROW]
[ROW][C]86[/C][C]41242[/C][C]43938.4772727273[/C][C]-2696.47727272727[/C][/ROW]
[ROW][C]87[/C][C]48450[/C][C]43938.4772727273[/C][C]4511.52272727273[/C][/ROW]
[ROW][C]88[/C][C]20790[/C][C]29231.2857142857[/C][C]-8441.28571428571[/C][/ROW]
[ROW][C]89[/C][C]34585[/C][C]29231.2857142857[/C][C]5353.71428571429[/C][/ROW]
[ROW][C]90[/C][C]35672[/C][C]43938.4772727273[/C][C]-8266.47727272727[/C][/ROW]
[ROW][C]91[/C][C]52168[/C][C]43938.4772727273[/C][C]8229.52272727273[/C][/ROW]
[ROW][C]92[/C][C]53933[/C][C]43938.4772727273[/C][C]9994.52272727273[/C][/ROW]
[ROW][C]93[/C][C]34474[/C][C]29231.2857142857[/C][C]5242.71428571429[/C][/ROW]
[ROW][C]94[/C][C]43753[/C][C]29231.2857142857[/C][C]14521.7142857143[/C][/ROW]
[ROW][C]95[/C][C]36456[/C][C]29231.2857142857[/C][C]7224.71428571429[/C][/ROW]
[ROW][C]96[/C][C]51183[/C][C]43938.4772727273[/C][C]7244.52272727273[/C][/ROW]
[ROW][C]97[/C][C]52742[/C][C]43938.4772727273[/C][C]8803.52272727273[/C][/ROW]
[ROW][C]98[/C][C]3895[/C][C]1379.52941176471[/C][C]2515.47058823529[/C][/ROW]
[ROW][C]99[/C][C]37076[/C][C]44497.5[/C][C]-7421.5[/C][/ROW]
[ROW][C]100[/C][C]24079[/C][C]29231.2857142857[/C][C]-5152.28571428571[/C][/ROW]
[ROW][C]101[/C][C]2325[/C][C]11109.5[/C][C]-8784.5[/C][/ROW]
[ROW][C]102[/C][C]29354[/C][C]29231.2857142857[/C][C]122.714285714286[/C][/ROW]
[ROW][C]103[/C][C]30341[/C][C]29231.2857142857[/C][C]1109.71428571429[/C][/ROW]
[ROW][C]104[/C][C]18992[/C][C]29231.2857142857[/C][C]-10239.2857142857[/C][/ROW]
[ROW][C]105[/C][C]15292[/C][C]29231.2857142857[/C][C]-13939.2857142857[/C][/ROW]
[ROW][C]106[/C][C]5842[/C][C]11109.5[/C][C]-5267.5[/C][/ROW]
[ROW][C]107[/C][C]28918[/C][C]43938.4772727273[/C][C]-15020.4772727273[/C][/ROW]
[ROW][C]108[/C][C]3738[/C][C]11109.5[/C][C]-7371.5[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]110[/C][C]95352[/C][C]43938.4772727273[/C][C]51413.5227272727[/C][/ROW]
[ROW][C]111[/C][C]37478[/C][C]29231.2857142857[/C][C]8246.7142857143[/C][/ROW]
[ROW][C]112[/C][C]26839[/C][C]29231.2857142857[/C][C]-2392.28571428571[/C][/ROW]
[ROW][C]113[/C][C]26783[/C][C]43938.4772727273[/C][C]-17155.4772727273[/C][/ROW]
[ROW][C]114[/C][C]33392[/C][C]43938.4772727273[/C][C]-10546.4772727273[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]117[/C][C]25446[/C][C]29231.2857142857[/C][C]-3785.28571428571[/C][/ROW]
[ROW][C]118[/C][C]59847[/C][C]43938.4772727273[/C][C]15908.5227272727[/C][/ROW]
[ROW][C]119[/C][C]28162[/C][C]43938.4772727273[/C][C]-15776.4772727273[/C][/ROW]
[ROW][C]120[/C][C]33298[/C][C]29231.2857142857[/C][C]4066.71428571429[/C][/ROW]
[ROW][C]121[/C][C]2781[/C][C]1379.52941176471[/C][C]1401.47058823529[/C][/ROW]
[ROW][C]122[/C][C]37121[/C][C]43938.4772727273[/C][C]-6817.47727272727[/C][/ROW]
[ROW][C]123[/C][C]22698[/C][C]29231.2857142857[/C][C]-6533.28571428571[/C][/ROW]
[ROW][C]124[/C][C]27615[/C][C]29231.2857142857[/C][C]-1616.28571428571[/C][/ROW]
[ROW][C]125[/C][C]32689[/C][C]11109.5[/C][C]21579.5[/C][/ROW]
[ROW][C]126[/C][C]5752[/C][C]1379.52941176471[/C][C]4372.47058823529[/C][/ROW]
[ROW][C]127[/C][C]23164[/C][C]29231.2857142857[/C][C]-6067.28571428571[/C][/ROW]
[ROW][C]128[/C][C]20304[/C][C]29231.2857142857[/C][C]-8927.28571428571[/C][/ROW]
[ROW][C]129[/C][C]34409[/C][C]29231.2857142857[/C][C]5177.71428571429[/C][/ROW]
[ROW][C]130[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]132[/C][C]92538[/C][C]29231.2857142857[/C][C]63306.7142857143[/C][/ROW]
[ROW][C]133[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]134[/C][C]46037[/C][C]43938.4772727273[/C][C]2098.52272727273[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]136[/C][C]5444[/C][C]1379.52941176471[/C][C]4064.47058823529[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]138[/C][C]23924[/C][C]29231.2857142857[/C][C]-5307.28571428571[/C][/ROW]
[ROW][C]139[/C][C]52230[/C][C]29231.2857142857[/C][C]22998.7142857143[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]141[/C][C]0[/C][C]1379.52941176471[/C][C]-1379.52941176471[/C][/ROW]
[ROW][C]142[/C][C]8019[/C][C]11109.5[/C][C]-3090.5[/C][/ROW]
[ROW][C]143[/C][C]34542[/C][C]43938.4772727273[/C][C]-9396.47727272727[/C][/ROW]
[ROW][C]144[/C][C]21157[/C][C]29231.2857142857[/C][C]-8074.28571428571[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=155457&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=155457&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
11815829231.2857142857-11073.2857142857
23046129231.28571428571229.71428571429
314231379.5294117647143.4705882352941
42562943938.4772727273-18309.4772727273
54875843938.47727272734819.52272727273
612923075468.428571428653761.5714285714
72737629231.2857142857-1855.28571428571
82670643938.4772727273-17232.4772727273
92650529231.2857142857-2726.28571428571
104980175468.4285714286-25667.4285714286
114658043938.47727272732641.52272727273
124835243938.47727272734413.52272727273
131389929231.2857142857-15332.2857142857
143934243938.4772727273-4596.47727272727
152746529231.2857142857-1766.28571428571
165521129231.285714285725979.7142857143
177409843938.477272727330159.5227272727
181349711109.52387.5
193833844497.5-6159.5
205250529231.285714285723273.7142857143
211066329231.2857142857-18568.2857142857
227448475468.4285714286-984.428571428565
232889529231.2857142857-336.285714285714
243282744497.5-11670.5
253618844497.5-8309.5
262817343938.4772727273-15765.4772727273
275492643938.477272727310987.5227272727
283890075468.4285714286-36568.4285714286
298853075468.428571428613061.5714285714
303548243938.4772727273-8456.47727272727
312673029231.2857142857-2501.28571428571
322980629231.2857142857574.714285714286
334179943938.4772727273-2139.47727272727
345428944497.59791.5
353680543938.4772727273-7133.47727272727
3601379.52941176471-1379.52941176471
373314644497.5-11351.5
382333329231.2857142857-5898.28571428571
394768644497.53188.5
407778375468.42857142862314.57142857143
413604243938.4772727273-7896.47727272727
423454129231.28571428575309.71428571429
437562043938.477272727331681.5227272727
446061043938.477272727316671.5227272727
455504143938.477272727311102.5227272727
463208743938.4772727273-11851.4772727273
471635629231.2857142857-12875.2857142857
484016143938.4772727273-3777.47727272727
495545944497.510961.5
503667943938.4772727273-7259.47727272727
512234629231.2857142857-6885.28571428571
522737729231.2857142857-1854.28571428571
535027343938.47727272736334.52272727273
543210443938.4772727273-11834.4772727273
552701629231.2857142857-2215.28571428571
561971529231.2857142857-9516.28571428571
573362943938.4772727273-10309.4772727273
582708429231.2857142857-2147.28571428571
593235229231.28571428573120.71428571429
605184544497.57347.5
612659129231.2857142857-2640.28571428571
622967729231.2857142857445.714285714286
635423729231.285714285725005.7142857143
642028429231.2857142857-8947.28571428571
652274129231.2857142857-6490.28571428571
663417829231.28571428574946.71428571429
676955175468.4285714286-5917.42857142857
682965343938.4772727273-14285.4772727273
693807129231.28571428578839.71428571429
7041571379.529411764712777.47058823529
712832143938.4772727273-15617.4772727273
724019543938.4772727273-3743.47727272727
734815843938.47727272734219.52272727273
741331029231.2857142857-15921.2857142857
757847444497.533976.5
76638611109.5-4723.5
773158844497.5-12909.5
786125443938.477272727317315.5227272727
792115229231.2857142857-8079.28571428571
804127243938.4772727273-2666.47727272727
813416529231.28571428574933.71428571429
823705444497.5-7443.5
831236829231.2857142857-16863.2857142857
842316829231.2857142857-6063.28571428571
851638011109.55270.5
864124243938.4772727273-2696.47727272727
874845043938.47727272734511.52272727273
882079029231.2857142857-8441.28571428571
893458529231.28571428575353.71428571429
903567243938.4772727273-8266.47727272727
915216843938.47727272738229.52272727273
925393343938.47727272739994.52272727273
933447429231.28571428575242.71428571429
944375329231.285714285714521.7142857143
953645629231.28571428577224.71428571429
965118343938.47727272737244.52272727273
975274243938.47727272738803.52272727273
9838951379.529411764712515.47058823529
993707644497.5-7421.5
1002407929231.2857142857-5152.28571428571
101232511109.5-8784.5
1022935429231.2857142857122.714285714286
1033034129231.28571428571109.71428571429
1041899229231.2857142857-10239.2857142857
1051529229231.2857142857-13939.2857142857
106584211109.5-5267.5
1072891843938.4772727273-15020.4772727273
108373811109.5-7371.5
10901379.52941176471-1379.52941176471
1109535243938.477272727351413.5227272727
1113747829231.28571428578246.7142857143
1122683929231.2857142857-2392.28571428571
1132678343938.4772727273-17155.4772727273
1143339243938.4772727273-10546.4772727273
11501379.52941176471-1379.52941176471
11601379.52941176471-1379.52941176471
1172544629231.2857142857-3785.28571428571
1185984743938.477272727315908.5227272727
1192816243938.4772727273-15776.4772727273
1203329829231.28571428574066.71428571429
12127811379.529411764711401.47058823529
1223712143938.4772727273-6817.47727272727
1232269829231.2857142857-6533.28571428571
1242761529231.2857142857-1616.28571428571
1253268911109.521579.5
12657521379.529411764714372.47058823529
1272316429231.2857142857-6067.28571428571
1282030429231.2857142857-8927.28571428571
1293440929231.28571428575177.71428571429
13001379.52941176471-1379.52941176471
13101379.52941176471-1379.52941176471
1329253829231.285714285763306.7142857143
13301379.52941176471-1379.52941176471
1344603743938.47727272732098.52272727273
13501379.52941176471-1379.52941176471
13654441379.529411764714064.47058823529
13701379.52941176471-1379.52941176471
1382392429231.2857142857-5307.28571428571
1395223029231.285714285722998.7142857143
14001379.52941176471-1379.52941176471
14101379.52941176471-1379.52941176471
142801911109.5-3090.5
1433454243938.4772727273-9396.47727272727
1442115729231.2857142857-8074.28571428571



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