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 computationWed, 21 Dec 2011 16:08:01 -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/21/t1324501769h4ld2jriv9413wl.htm/, Retrieved Tue, 07 May 2024 19:01:30 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=159040, Retrieved Tue, 07 May 2024 19:01:30 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact106
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Kendall tau Correlation Matrix] [Paper, Pearson Co...] [2011-12-18 12:42:54] [75512e061a94450f738c2449abbaac12]
-   P   [Kendall tau Correlation Matrix] [Paper, Kendall's ...] [2011-12-19 10:46:53] [75512e061a94450f738c2449abbaac12]
- RMP     [Multiple Regression] [Paper, 3.3 Meervo...] [2011-12-19 15:22:52] [75512e061a94450f738c2449abbaac12]
- RMP       [Recursive Partitioning (Regression Trees)] [paper, recursive ...] [2011-12-21 13:30:58] [75512e061a94450f738c2449abbaac12]
- R P           [Recursive Partitioning (Regression Trees)] [paper, RP (endoge...] [2011-12-21 21:08:01] [242bbde8f74d68805b56d9ecebfdbe63] [Current]
Feedback Forum

Post a new message
Dataseries X:
1683	150596	84	37	18	63	20465	23975	0
1323	154801	50	42	20	56	33629	85634	1
192	7215	18	0	0	0	1423	1929	0
2172	122139	91	49	26	60	25629	36294	0
3335	221399	129	76	30	112	54002	72255	0
6310	441870	237	118	34	130	151036	189748	1
1478	134379	52	42	23	71	33287	61834	1
1324	140428	53	57	30	107	31172	68167	0
1488	103255	40	45	30	50	28113	38462	0
2756	271630	91	67	26	79	57803	101219	1
1931	121593	71	50	24	58	49830	43270	2
1966	172071	63	71	30	91	52143	76183	0
1575	83707	94	41	19	36	21055	31476	0
2855	197412	98	66	25	91	47007	62157	4
1263	134398	48	42	17	58	28735	46261	4
1479	139224	73	54	19	65	59147	50063	3
1636	134153	52	75	33	131	78950	64483	0
1076	64149	52	0	15	45	13497	2341	5
2376	122294	82	54	34	110	46154	48149	0
678	24889	22	13	15	33	53249	12743	0
902	52197	52	16	15	37	10726	18743	0
2308	188915	89	77	27	78	83700	97057	0
1590	163147	66	34	25	67	40400	17675	0
1863	98575	48	38	34	69	33797	33106	1
1799	143546	80	50	21	58	36205	53311	1
1385	139780	25	39	21	60	30165	42754	0
1870	163784	146	54	25	88	58534	59056	0
1161	152479	75	67	28	71	44663	101621	0
2417	304108	109	55	26	85	92556	118120	0
1952	184024	40	52	20	67	40078	79572	0
1514	151621	41	50	28	84	34711	42744	0
1487	164516	41	54	20	58	31076	65931	2
2051	120179	94	53	17	35	74608	38575	4
2843	214701	116	76	25	74	58092	28795	0
2216	196865	48	52	24	89	42009	94440	1
1	0	1	0	0	0	0	0	0
1830	181527	57	46	27	75	36022	38229	0
1563	93107	49	44	14	39	23333	31972	3
2046	129352	45	35	32	93	53349	40071	9
2005	229143	58	82	31	123	92596	132480	0
1934	177063	67	70	21	73	49598	62797	2
1572	126602	53	31	34	118	44093	40429	0
950	93742	29	25	23	76	84205	45545	2
1877	152153	72	48	24	65	63369	57568	1
1036	95704	42	44	22	82	60132	39019	2
1097	139793	84	40	22	67	37403	53866	2
730	76348	30	23	35	63	24460	38345	1
1918	188980	86	63	21	84	46456	50210	0
1826	172100	79	43	31	112	66616	80947	1
2444	146552	54	62	26	75	41554	43461	7
658	48188	28	12	22	39	22346	14812	0
1425	109185	60	63	21	63	30874	37819	0
2246	263652	68	60	27	93	68701	102738	0
1899	215609	75	53	26	69	35728	54509	0
1630	174876	54	53	33	117	29010	62956	1
1496	115124	49	35	11	30	23110	55411	6
1681	179712	60	49	26	65	38844	50611	0
816	70369	20	25	26	78	27084	26692	0
902	109215	58	47	21	80	35139	60056	0
2606	166096	85	30	38	85	57476	25155	10
1557	130414	51	50	29	107	33277	42840	6
1780	102057	71	36	19	60	31141	39358	0
1265	115310	56	43	19	53	61281	47241	11
1117	101181	32	44	24	62	25820	49611	3
1069	135228	31	14	26	90	23284	41833	0
1229	94982	37	38	29	89	35378	48930	0
2155	166919	67	58	34	127	74990	110600	8
2500	118169	64	68	25	71	29653	52235	2
1003	102361	36	48	24	75	64622	53986	0
340	31970	15	5	21	42	4157	4105	0
2586	200413	107	53	19	42	29245	59331	3
1119	103381	58	36	12	8	50008	47796	1
1251	94940	61	62	28	82	52338	38302	2
1516	101560	65	46	21	41	13310	14063	1
2473	144176	60	67	34	118	92901	54414	0
1288	71921	37	2	32	91	10956	9903	2
1911	126905	54	64	27	96	34241	53987	1
2279	131184	87	59	26	81	75043	88937	0
816	60138	23	16	21	46	21152	21928	0
1234	84971	71	34	31	60	42249	29487	0
907	80420	64	54	26	69	42005	35334	0
1827	233569	57	39	26	85	41152	57596	0
841	56252	25	26	23	17	14399	29750	0
1309	97181	32	37	25	61	28263	41029	0
764	50800	41	17	22	55	17215	12416	0
1439	125941	45	32	26	55	48140	51158	0
2500	211032	210	55	33	124	62897	79935	0
974	71960	92	39	22	65	22883	26552	0
1152	90379	53	39	24	73	41622	25807	6
1261	125650	47	28	21	67	40715	50620	0
1508	115572	36	45	28	66	65897	61467	5
2005	136266	67	66	22	61	76542	65292	1
1191	146715	55	39	22	74	37477	55516	0
1265	124626	57	27	15	55	53216	42006	0
761	49176	33	22	13	27	40911	26273	0
2156	212926	102	43	36	115	57021	90248	0
1689	173884	55	88	24	76	73116	61476	0
223	19349	12	13	1	0	3895	9604	0
2074	181141	95	23	24	83	46609	45108	3
1879	145502	70	40	31	90	29351	47232	0
566	45448	26	8	4	4	2325	3439	0
802	58280	20	41	20	56	31747	30553	0
1131	115944	44	51	23	63	32665	24751	0
981	94341	52	24	23	52	19249	34458	1
591	59090	37	23	12	24	15292	24649	0
596	27676	22	2	16	17	5842	2342	0
1261	120586	41	78	28	101	33994	52739	0
861	88011	31	12	10	20	13018	6245	0
0	0	0	0	0	0	0	0	0
1030	85610	31	46	25	51	98177	35381	0
991	84193	58	22	21	76	37941	19595	0
1178	117769	39	49	21	55	31032	50848	0
1200	107653	56	52	21	70	32683	39443	0
849	71894	57	36	21	38	34545	27023	0
78	3616	5	0	0	0	0	0	0
0	0	0	0	0	0	0	0	0
924	154806	38	35	23	81	27525	61022	0
1480	136061	73	68	29	64	66856	63528	0
1870	141822	89	26	27	66	28549	34835	1
861	106515	37	32	23	89	38610	37172	0
778	43410	19	7	1	3	2781	13	0
1533	146920	64	67	25	76	41211	62548	1
889	88874	38	30	17	48	22698	31334	0
1705	111924	49	55	29	62	41194	20839	8
700	60373	39	3	12	32	32689	5084	3
285	19764	12	10	2	4	5752	9927	1
1490	121665	46	46	18	61	26757	53229	2
981	108685	26	23	25	90	22527	29877	0
1368	124493	37	43	29	91	44810	37310	0
256	11796	9	1	2	1	0	0	0
98	10674	9	0	0	0	0	0	0
1317	131263	52	33	18	39	100674	50067	0
41	6836	3	0	1	0	0	0	0
1768	153278	55	48	21	45	57786	47708	5
42	5118	3	5	0	0	0	0	0
528	40248	16	8	4	7	5444	6012	1
0	0	0	0	0	0	0	0	0
938	100728	42	25	25	75	28470	27749	0
1245	84267	36	21	26	52	61849	47555	0
81	7131	4	0	0	0	0	0	1
257	8812	13	0	4	1	2179	1336	0
891	63952	22	15	17	49	8019	11017	1
1114	120111	47	47	21	69	39644	55184	0
1079	94127	18	17	22	56	23494	43485	1




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

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







Goodness of Fit
Correlation0.898
R-squared0.8063
RMSE29109.3141

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.898[/C][/ROW]
[ROW][C]R-squared[/C][C]0.8063[/C][/ROW]
[ROW][C]RMSE[/C][C]29109.3141[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159040&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159040&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.898
R-squared0.8063
RMSE29109.3141







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
1150596161273.162790698-10677.1627906977
2154801144667.710133.3
372158818.73333333333-1603.73333333333
4122139161273.162790698-39134.1627906977
5221399161273.16279069860125.8372093023
6441870266605.285714286175264.714285714
7134379144667.7-10288.7
8140428144667.7-4239.70000000001
910325594324.258930.75
10271630266605.2857142865024.71428571426
11121593161273.162790698-39680.1627906977
12172071161273.16279069810797.8372093023
138370794324.25-10617.25
14197412161273.16279069836138.8372093023
15134398118704.88461538515693.1153846154
16139224118704.88461538520519.1153846154
17134153161273.162790698-27120.1627906977
186414994324.25-30175.25
19122294161273.162790698-38979.1627906977
202488950971.1428571429-26082.1428571429
215219750971.14285714291225.85714285714
22188915266605.285714286-77690.2857142857
23163147161273.1627906981873.83720930232
2498575161273.162790698-62698.1627906977
25143546161273.162790698-17727.1627906977
26139780118704.88461538521075.1153846154
27163784161273.1627906982510.83720930232
28152479144667.77811.29999999999
29304108266605.28571428637502.7142857143
30184024161273.16279069822750.8372093023
31151621118704.88461538532916.1153846154
32164516144667.719848.3
33120179161273.162790698-41094.1627906977
34214701161273.16279069853427.8372093023
35196865161273.16279069835591.8372093023
3608818.73333333333-8818.73333333333
37181527161273.16279069820253.8372093023
389310794324.25-1217.25
39129352161273.162790698-31921.1627906977
40229143266605.285714286-37462.2857142857
41177063161273.16279069815789.8372093023
42126602118704.8846153857897.11538461539
4393742118704.884615385-24962.8846153846
44152153161273.162790698-9120.16279069768
459570494324.251379.75
46139793118704.88461538521088.1153846154
477634879796.3333333333-3448.33333333333
48188980161273.16279069827706.8372093023
49172100161273.16279069810826.8372093023
50146552161273.162790698-14721.1627906977
514818850971.1428571429-2783.14285714286
5210918594324.2514860.75
53263652266605.285714286-2953.28571428574
54215609161273.16279069854335.8372093023
55174876161273.16279069813602.8372093023
56115124118704.884615385-3580.88461538461
57179712161273.16279069818438.8372093023
587036979796.3333333333-9427.33333333333
5910921579796.333333333329418.6666666667
60166096161273.1627906984822.83720930232
61130414118704.88461538511709.1153846154
62102057161273.162790698-59216.1627906977
63115310118704.884615385-3394.88461538461
64101181118704.884615385-17523.8846153846
65135228118704.88461538516523.1153846154
6694982118704.884615385-23722.8846153846
67166919266605.285714286-99686.2857142857
68118169161273.162790698-43104.1627906977
69102361118704.884615385-16343.8846153846
70319708818.7333333333323151.2666666667
71200413161273.16279069839139.8372093023
72103381118704.884615385-15323.8846153846
739494094324.25615.75
7410156094324.257235.75
75144176161273.162790698-17097.1627906977
767192194324.25-22403.25
77126905161273.162790698-34368.1627906977
78131184161273.162790698-30089.1627906977
796013850971.14285714299166.85714285714
808497194324.25-9353.25
818042079796.3333333333623.666666666672
82233569161273.16279069872295.8372093023
835625279796.3333333333-23544.3333333333
8497181118704.884615385-21523.8846153846
855080050971.1428571429-171.142857142855
86125941118704.8846153857236.11538461539
87211032161273.16279069849758.8372093023
887196094324.25-22364.25
899037994324.25-3945.25
90125650118704.8846153856945.11538461539
91115572144667.7-29095.7
92136266161273.162790698-25007.1627906977
93146715144667.72047.29999999999
94124626118704.8846153855921.11538461539
954917650971.1428571429-1795.14285714286
96212926161273.16279069851652.8372093023
97173884161273.16279069812610.8372093023
98193498818.7333333333310530.2666666667
99181141161273.16279069819867.8372093023
100145502161273.162790698-15771.1627906977
1014544850971.1428571429-5523.14285714286
1025828079796.3333333333-21516.3333333333
10311594494324.2521619.75
1049434194324.2516.75
1055909050971.14285714298118.85714285714
1062767650971.1428571429-23295.1428571429
107120586118704.8846153851881.11538461539
1088801150971.142857142937039.8571428571
10908818.73333333333-8818.73333333333
1108561094324.25-8714.25
1118419394324.25-10131.25
112117769118704.884615385-935.88461538461
11310765394324.2513328.75
1147189479796.3333333333-7902.33333333333
11536168818.73333333333-5202.73333333333
11608818.73333333333-8818.73333333333
117154806144667.710138.3
118136061144667.7-8606.70000000001
119141822161273.162790698-19451.1627906977
12010651579796.333333333326718.6666666667
1214341050971.1428571429-7561.14285714286
122146920144667.72252.29999999999
1238887479796.33333333339077.66666666667
124111924161273.162790698-49349.1627906977
1256037350971.14285714299401.85714285714
126197648818.7333333333310945.2666666667
127121665118704.8846153852960.11538461539
12810868594324.2514360.75
12912449394324.2530168.75
130117968818.733333333332977.26666666667
131106748818.733333333331855.26666666667
132131263118704.88461538512558.1153846154
13368368818.73333333333-1982.73333333333
134153278161273.162790698-7995.16279069768
13551188818.73333333333-3700.73333333333
1364024850971.1428571429-10723.1428571429
13708818.73333333333-8818.73333333333
13810072894324.256403.75
13984267118704.884615385-34437.8846153846
14071318818.73333333333-1687.73333333333
14188128818.73333333333-6.73333333333358
1426395250971.142857142912980.8571428571
143120111118704.8846153851406.11538461539
14494127118704.884615385-24577.8846153846

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 150596 & 161273.162790698 & -10677.1627906977 \tabularnewline
2 & 154801 & 144667.7 & 10133.3 \tabularnewline
3 & 7215 & 8818.73333333333 & -1603.73333333333 \tabularnewline
4 & 122139 & 161273.162790698 & -39134.1627906977 \tabularnewline
5 & 221399 & 161273.162790698 & 60125.8372093023 \tabularnewline
6 & 441870 & 266605.285714286 & 175264.714285714 \tabularnewline
7 & 134379 & 144667.7 & -10288.7 \tabularnewline
8 & 140428 & 144667.7 & -4239.70000000001 \tabularnewline
9 & 103255 & 94324.25 & 8930.75 \tabularnewline
10 & 271630 & 266605.285714286 & 5024.71428571426 \tabularnewline
11 & 121593 & 161273.162790698 & -39680.1627906977 \tabularnewline
12 & 172071 & 161273.162790698 & 10797.8372093023 \tabularnewline
13 & 83707 & 94324.25 & -10617.25 \tabularnewline
14 & 197412 & 161273.162790698 & 36138.8372093023 \tabularnewline
15 & 134398 & 118704.884615385 & 15693.1153846154 \tabularnewline
16 & 139224 & 118704.884615385 & 20519.1153846154 \tabularnewline
17 & 134153 & 161273.162790698 & -27120.1627906977 \tabularnewline
18 & 64149 & 94324.25 & -30175.25 \tabularnewline
19 & 122294 & 161273.162790698 & -38979.1627906977 \tabularnewline
20 & 24889 & 50971.1428571429 & -26082.1428571429 \tabularnewline
21 & 52197 & 50971.1428571429 & 1225.85714285714 \tabularnewline
22 & 188915 & 266605.285714286 & -77690.2857142857 \tabularnewline
23 & 163147 & 161273.162790698 & 1873.83720930232 \tabularnewline
24 & 98575 & 161273.162790698 & -62698.1627906977 \tabularnewline
25 & 143546 & 161273.162790698 & -17727.1627906977 \tabularnewline
26 & 139780 & 118704.884615385 & 21075.1153846154 \tabularnewline
27 & 163784 & 161273.162790698 & 2510.83720930232 \tabularnewline
28 & 152479 & 144667.7 & 7811.29999999999 \tabularnewline
29 & 304108 & 266605.285714286 & 37502.7142857143 \tabularnewline
30 & 184024 & 161273.162790698 & 22750.8372093023 \tabularnewline
31 & 151621 & 118704.884615385 & 32916.1153846154 \tabularnewline
32 & 164516 & 144667.7 & 19848.3 \tabularnewline
33 & 120179 & 161273.162790698 & -41094.1627906977 \tabularnewline
34 & 214701 & 161273.162790698 & 53427.8372093023 \tabularnewline
35 & 196865 & 161273.162790698 & 35591.8372093023 \tabularnewline
36 & 0 & 8818.73333333333 & -8818.73333333333 \tabularnewline
37 & 181527 & 161273.162790698 & 20253.8372093023 \tabularnewline
38 & 93107 & 94324.25 & -1217.25 \tabularnewline
39 & 129352 & 161273.162790698 & -31921.1627906977 \tabularnewline
40 & 229143 & 266605.285714286 & -37462.2857142857 \tabularnewline
41 & 177063 & 161273.162790698 & 15789.8372093023 \tabularnewline
42 & 126602 & 118704.884615385 & 7897.11538461539 \tabularnewline
43 & 93742 & 118704.884615385 & -24962.8846153846 \tabularnewline
44 & 152153 & 161273.162790698 & -9120.16279069768 \tabularnewline
45 & 95704 & 94324.25 & 1379.75 \tabularnewline
46 & 139793 & 118704.884615385 & 21088.1153846154 \tabularnewline
47 & 76348 & 79796.3333333333 & -3448.33333333333 \tabularnewline
48 & 188980 & 161273.162790698 & 27706.8372093023 \tabularnewline
49 & 172100 & 161273.162790698 & 10826.8372093023 \tabularnewline
50 & 146552 & 161273.162790698 & -14721.1627906977 \tabularnewline
51 & 48188 & 50971.1428571429 & -2783.14285714286 \tabularnewline
52 & 109185 & 94324.25 & 14860.75 \tabularnewline
53 & 263652 & 266605.285714286 & -2953.28571428574 \tabularnewline
54 & 215609 & 161273.162790698 & 54335.8372093023 \tabularnewline
55 & 174876 & 161273.162790698 & 13602.8372093023 \tabularnewline
56 & 115124 & 118704.884615385 & -3580.88461538461 \tabularnewline
57 & 179712 & 161273.162790698 & 18438.8372093023 \tabularnewline
58 & 70369 & 79796.3333333333 & -9427.33333333333 \tabularnewline
59 & 109215 & 79796.3333333333 & 29418.6666666667 \tabularnewline
60 & 166096 & 161273.162790698 & 4822.83720930232 \tabularnewline
61 & 130414 & 118704.884615385 & 11709.1153846154 \tabularnewline
62 & 102057 & 161273.162790698 & -59216.1627906977 \tabularnewline
63 & 115310 & 118704.884615385 & -3394.88461538461 \tabularnewline
64 & 101181 & 118704.884615385 & -17523.8846153846 \tabularnewline
65 & 135228 & 118704.884615385 & 16523.1153846154 \tabularnewline
66 & 94982 & 118704.884615385 & -23722.8846153846 \tabularnewline
67 & 166919 & 266605.285714286 & -99686.2857142857 \tabularnewline
68 & 118169 & 161273.162790698 & -43104.1627906977 \tabularnewline
69 & 102361 & 118704.884615385 & -16343.8846153846 \tabularnewline
70 & 31970 & 8818.73333333333 & 23151.2666666667 \tabularnewline
71 & 200413 & 161273.162790698 & 39139.8372093023 \tabularnewline
72 & 103381 & 118704.884615385 & -15323.8846153846 \tabularnewline
73 & 94940 & 94324.25 & 615.75 \tabularnewline
74 & 101560 & 94324.25 & 7235.75 \tabularnewline
75 & 144176 & 161273.162790698 & -17097.1627906977 \tabularnewline
76 & 71921 & 94324.25 & -22403.25 \tabularnewline
77 & 126905 & 161273.162790698 & -34368.1627906977 \tabularnewline
78 & 131184 & 161273.162790698 & -30089.1627906977 \tabularnewline
79 & 60138 & 50971.1428571429 & 9166.85714285714 \tabularnewline
80 & 84971 & 94324.25 & -9353.25 \tabularnewline
81 & 80420 & 79796.3333333333 & 623.666666666672 \tabularnewline
82 & 233569 & 161273.162790698 & 72295.8372093023 \tabularnewline
83 & 56252 & 79796.3333333333 & -23544.3333333333 \tabularnewline
84 & 97181 & 118704.884615385 & -21523.8846153846 \tabularnewline
85 & 50800 & 50971.1428571429 & -171.142857142855 \tabularnewline
86 & 125941 & 118704.884615385 & 7236.11538461539 \tabularnewline
87 & 211032 & 161273.162790698 & 49758.8372093023 \tabularnewline
88 & 71960 & 94324.25 & -22364.25 \tabularnewline
89 & 90379 & 94324.25 & -3945.25 \tabularnewline
90 & 125650 & 118704.884615385 & 6945.11538461539 \tabularnewline
91 & 115572 & 144667.7 & -29095.7 \tabularnewline
92 & 136266 & 161273.162790698 & -25007.1627906977 \tabularnewline
93 & 146715 & 144667.7 & 2047.29999999999 \tabularnewline
94 & 124626 & 118704.884615385 & 5921.11538461539 \tabularnewline
95 & 49176 & 50971.1428571429 & -1795.14285714286 \tabularnewline
96 & 212926 & 161273.162790698 & 51652.8372093023 \tabularnewline
97 & 173884 & 161273.162790698 & 12610.8372093023 \tabularnewline
98 & 19349 & 8818.73333333333 & 10530.2666666667 \tabularnewline
99 & 181141 & 161273.162790698 & 19867.8372093023 \tabularnewline
100 & 145502 & 161273.162790698 & -15771.1627906977 \tabularnewline
101 & 45448 & 50971.1428571429 & -5523.14285714286 \tabularnewline
102 & 58280 & 79796.3333333333 & -21516.3333333333 \tabularnewline
103 & 115944 & 94324.25 & 21619.75 \tabularnewline
104 & 94341 & 94324.25 & 16.75 \tabularnewline
105 & 59090 & 50971.1428571429 & 8118.85714285714 \tabularnewline
106 & 27676 & 50971.1428571429 & -23295.1428571429 \tabularnewline
107 & 120586 & 118704.884615385 & 1881.11538461539 \tabularnewline
108 & 88011 & 50971.1428571429 & 37039.8571428571 \tabularnewline
109 & 0 & 8818.73333333333 & -8818.73333333333 \tabularnewline
110 & 85610 & 94324.25 & -8714.25 \tabularnewline
111 & 84193 & 94324.25 & -10131.25 \tabularnewline
112 & 117769 & 118704.884615385 & -935.88461538461 \tabularnewline
113 & 107653 & 94324.25 & 13328.75 \tabularnewline
114 & 71894 & 79796.3333333333 & -7902.33333333333 \tabularnewline
115 & 3616 & 8818.73333333333 & -5202.73333333333 \tabularnewline
116 & 0 & 8818.73333333333 & -8818.73333333333 \tabularnewline
117 & 154806 & 144667.7 & 10138.3 \tabularnewline
118 & 136061 & 144667.7 & -8606.70000000001 \tabularnewline
119 & 141822 & 161273.162790698 & -19451.1627906977 \tabularnewline
120 & 106515 & 79796.3333333333 & 26718.6666666667 \tabularnewline
121 & 43410 & 50971.1428571429 & -7561.14285714286 \tabularnewline
122 & 146920 & 144667.7 & 2252.29999999999 \tabularnewline
123 & 88874 & 79796.3333333333 & 9077.66666666667 \tabularnewline
124 & 111924 & 161273.162790698 & -49349.1627906977 \tabularnewline
125 & 60373 & 50971.1428571429 & 9401.85714285714 \tabularnewline
126 & 19764 & 8818.73333333333 & 10945.2666666667 \tabularnewline
127 & 121665 & 118704.884615385 & 2960.11538461539 \tabularnewline
128 & 108685 & 94324.25 & 14360.75 \tabularnewline
129 & 124493 & 94324.25 & 30168.75 \tabularnewline
130 & 11796 & 8818.73333333333 & 2977.26666666667 \tabularnewline
131 & 10674 & 8818.73333333333 & 1855.26666666667 \tabularnewline
132 & 131263 & 118704.884615385 & 12558.1153846154 \tabularnewline
133 & 6836 & 8818.73333333333 & -1982.73333333333 \tabularnewline
134 & 153278 & 161273.162790698 & -7995.16279069768 \tabularnewline
135 & 5118 & 8818.73333333333 & -3700.73333333333 \tabularnewline
136 & 40248 & 50971.1428571429 & -10723.1428571429 \tabularnewline
137 & 0 & 8818.73333333333 & -8818.73333333333 \tabularnewline
138 & 100728 & 94324.25 & 6403.75 \tabularnewline
139 & 84267 & 118704.884615385 & -34437.8846153846 \tabularnewline
140 & 7131 & 8818.73333333333 & -1687.73333333333 \tabularnewline
141 & 8812 & 8818.73333333333 & -6.73333333333358 \tabularnewline
142 & 63952 & 50971.1428571429 & 12980.8571428571 \tabularnewline
143 & 120111 & 118704.884615385 & 1406.11538461539 \tabularnewline
144 & 94127 & 118704.884615385 & -24577.8846153846 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=159040&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]150596[/C][C]161273.162790698[/C][C]-10677.1627906977[/C][/ROW]
[ROW][C]2[/C][C]154801[/C][C]144667.7[/C][C]10133.3[/C][/ROW]
[ROW][C]3[/C][C]7215[/C][C]8818.73333333333[/C][C]-1603.73333333333[/C][/ROW]
[ROW][C]4[/C][C]122139[/C][C]161273.162790698[/C][C]-39134.1627906977[/C][/ROW]
[ROW][C]5[/C][C]221399[/C][C]161273.162790698[/C][C]60125.8372093023[/C][/ROW]
[ROW][C]6[/C][C]441870[/C][C]266605.285714286[/C][C]175264.714285714[/C][/ROW]
[ROW][C]7[/C][C]134379[/C][C]144667.7[/C][C]-10288.7[/C][/ROW]
[ROW][C]8[/C][C]140428[/C][C]144667.7[/C][C]-4239.70000000001[/C][/ROW]
[ROW][C]9[/C][C]103255[/C][C]94324.25[/C][C]8930.75[/C][/ROW]
[ROW][C]10[/C][C]271630[/C][C]266605.285714286[/C][C]5024.71428571426[/C][/ROW]
[ROW][C]11[/C][C]121593[/C][C]161273.162790698[/C][C]-39680.1627906977[/C][/ROW]
[ROW][C]12[/C][C]172071[/C][C]161273.162790698[/C][C]10797.8372093023[/C][/ROW]
[ROW][C]13[/C][C]83707[/C][C]94324.25[/C][C]-10617.25[/C][/ROW]
[ROW][C]14[/C][C]197412[/C][C]161273.162790698[/C][C]36138.8372093023[/C][/ROW]
[ROW][C]15[/C][C]134398[/C][C]118704.884615385[/C][C]15693.1153846154[/C][/ROW]
[ROW][C]16[/C][C]139224[/C][C]118704.884615385[/C][C]20519.1153846154[/C][/ROW]
[ROW][C]17[/C][C]134153[/C][C]161273.162790698[/C][C]-27120.1627906977[/C][/ROW]
[ROW][C]18[/C][C]64149[/C][C]94324.25[/C][C]-30175.25[/C][/ROW]
[ROW][C]19[/C][C]122294[/C][C]161273.162790698[/C][C]-38979.1627906977[/C][/ROW]
[ROW][C]20[/C][C]24889[/C][C]50971.1428571429[/C][C]-26082.1428571429[/C][/ROW]
[ROW][C]21[/C][C]52197[/C][C]50971.1428571429[/C][C]1225.85714285714[/C][/ROW]
[ROW][C]22[/C][C]188915[/C][C]266605.285714286[/C][C]-77690.2857142857[/C][/ROW]
[ROW][C]23[/C][C]163147[/C][C]161273.162790698[/C][C]1873.83720930232[/C][/ROW]
[ROW][C]24[/C][C]98575[/C][C]161273.162790698[/C][C]-62698.1627906977[/C][/ROW]
[ROW][C]25[/C][C]143546[/C][C]161273.162790698[/C][C]-17727.1627906977[/C][/ROW]
[ROW][C]26[/C][C]139780[/C][C]118704.884615385[/C][C]21075.1153846154[/C][/ROW]
[ROW][C]27[/C][C]163784[/C][C]161273.162790698[/C][C]2510.83720930232[/C][/ROW]
[ROW][C]28[/C][C]152479[/C][C]144667.7[/C][C]7811.29999999999[/C][/ROW]
[ROW][C]29[/C][C]304108[/C][C]266605.285714286[/C][C]37502.7142857143[/C][/ROW]
[ROW][C]30[/C][C]184024[/C][C]161273.162790698[/C][C]22750.8372093023[/C][/ROW]
[ROW][C]31[/C][C]151621[/C][C]118704.884615385[/C][C]32916.1153846154[/C][/ROW]
[ROW][C]32[/C][C]164516[/C][C]144667.7[/C][C]19848.3[/C][/ROW]
[ROW][C]33[/C][C]120179[/C][C]161273.162790698[/C][C]-41094.1627906977[/C][/ROW]
[ROW][C]34[/C][C]214701[/C][C]161273.162790698[/C][C]53427.8372093023[/C][/ROW]
[ROW][C]35[/C][C]196865[/C][C]161273.162790698[/C][C]35591.8372093023[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]8818.73333333333[/C][C]-8818.73333333333[/C][/ROW]
[ROW][C]37[/C][C]181527[/C][C]161273.162790698[/C][C]20253.8372093023[/C][/ROW]
[ROW][C]38[/C][C]93107[/C][C]94324.25[/C][C]-1217.25[/C][/ROW]
[ROW][C]39[/C][C]129352[/C][C]161273.162790698[/C][C]-31921.1627906977[/C][/ROW]
[ROW][C]40[/C][C]229143[/C][C]266605.285714286[/C][C]-37462.2857142857[/C][/ROW]
[ROW][C]41[/C][C]177063[/C][C]161273.162790698[/C][C]15789.8372093023[/C][/ROW]
[ROW][C]42[/C][C]126602[/C][C]118704.884615385[/C][C]7897.11538461539[/C][/ROW]
[ROW][C]43[/C][C]93742[/C][C]118704.884615385[/C][C]-24962.8846153846[/C][/ROW]
[ROW][C]44[/C][C]152153[/C][C]161273.162790698[/C][C]-9120.16279069768[/C][/ROW]
[ROW][C]45[/C][C]95704[/C][C]94324.25[/C][C]1379.75[/C][/ROW]
[ROW][C]46[/C][C]139793[/C][C]118704.884615385[/C][C]21088.1153846154[/C][/ROW]
[ROW][C]47[/C][C]76348[/C][C]79796.3333333333[/C][C]-3448.33333333333[/C][/ROW]
[ROW][C]48[/C][C]188980[/C][C]161273.162790698[/C][C]27706.8372093023[/C][/ROW]
[ROW][C]49[/C][C]172100[/C][C]161273.162790698[/C][C]10826.8372093023[/C][/ROW]
[ROW][C]50[/C][C]146552[/C][C]161273.162790698[/C][C]-14721.1627906977[/C][/ROW]
[ROW][C]51[/C][C]48188[/C][C]50971.1428571429[/C][C]-2783.14285714286[/C][/ROW]
[ROW][C]52[/C][C]109185[/C][C]94324.25[/C][C]14860.75[/C][/ROW]
[ROW][C]53[/C][C]263652[/C][C]266605.285714286[/C][C]-2953.28571428574[/C][/ROW]
[ROW][C]54[/C][C]215609[/C][C]161273.162790698[/C][C]54335.8372093023[/C][/ROW]
[ROW][C]55[/C][C]174876[/C][C]161273.162790698[/C][C]13602.8372093023[/C][/ROW]
[ROW][C]56[/C][C]115124[/C][C]118704.884615385[/C][C]-3580.88461538461[/C][/ROW]
[ROW][C]57[/C][C]179712[/C][C]161273.162790698[/C][C]18438.8372093023[/C][/ROW]
[ROW][C]58[/C][C]70369[/C][C]79796.3333333333[/C][C]-9427.33333333333[/C][/ROW]
[ROW][C]59[/C][C]109215[/C][C]79796.3333333333[/C][C]29418.6666666667[/C][/ROW]
[ROW][C]60[/C][C]166096[/C][C]161273.162790698[/C][C]4822.83720930232[/C][/ROW]
[ROW][C]61[/C][C]130414[/C][C]118704.884615385[/C][C]11709.1153846154[/C][/ROW]
[ROW][C]62[/C][C]102057[/C][C]161273.162790698[/C][C]-59216.1627906977[/C][/ROW]
[ROW][C]63[/C][C]115310[/C][C]118704.884615385[/C][C]-3394.88461538461[/C][/ROW]
[ROW][C]64[/C][C]101181[/C][C]118704.884615385[/C][C]-17523.8846153846[/C][/ROW]
[ROW][C]65[/C][C]135228[/C][C]118704.884615385[/C][C]16523.1153846154[/C][/ROW]
[ROW][C]66[/C][C]94982[/C][C]118704.884615385[/C][C]-23722.8846153846[/C][/ROW]
[ROW][C]67[/C][C]166919[/C][C]266605.285714286[/C][C]-99686.2857142857[/C][/ROW]
[ROW][C]68[/C][C]118169[/C][C]161273.162790698[/C][C]-43104.1627906977[/C][/ROW]
[ROW][C]69[/C][C]102361[/C][C]118704.884615385[/C][C]-16343.8846153846[/C][/ROW]
[ROW][C]70[/C][C]31970[/C][C]8818.73333333333[/C][C]23151.2666666667[/C][/ROW]
[ROW][C]71[/C][C]200413[/C][C]161273.162790698[/C][C]39139.8372093023[/C][/ROW]
[ROW][C]72[/C][C]103381[/C][C]118704.884615385[/C][C]-15323.8846153846[/C][/ROW]
[ROW][C]73[/C][C]94940[/C][C]94324.25[/C][C]615.75[/C][/ROW]
[ROW][C]74[/C][C]101560[/C][C]94324.25[/C][C]7235.75[/C][/ROW]
[ROW][C]75[/C][C]144176[/C][C]161273.162790698[/C][C]-17097.1627906977[/C][/ROW]
[ROW][C]76[/C][C]71921[/C][C]94324.25[/C][C]-22403.25[/C][/ROW]
[ROW][C]77[/C][C]126905[/C][C]161273.162790698[/C][C]-34368.1627906977[/C][/ROW]
[ROW][C]78[/C][C]131184[/C][C]161273.162790698[/C][C]-30089.1627906977[/C][/ROW]
[ROW][C]79[/C][C]60138[/C][C]50971.1428571429[/C][C]9166.85714285714[/C][/ROW]
[ROW][C]80[/C][C]84971[/C][C]94324.25[/C][C]-9353.25[/C][/ROW]
[ROW][C]81[/C][C]80420[/C][C]79796.3333333333[/C][C]623.666666666672[/C][/ROW]
[ROW][C]82[/C][C]233569[/C][C]161273.162790698[/C][C]72295.8372093023[/C][/ROW]
[ROW][C]83[/C][C]56252[/C][C]79796.3333333333[/C][C]-23544.3333333333[/C][/ROW]
[ROW][C]84[/C][C]97181[/C][C]118704.884615385[/C][C]-21523.8846153846[/C][/ROW]
[ROW][C]85[/C][C]50800[/C][C]50971.1428571429[/C][C]-171.142857142855[/C][/ROW]
[ROW][C]86[/C][C]125941[/C][C]118704.884615385[/C][C]7236.11538461539[/C][/ROW]
[ROW][C]87[/C][C]211032[/C][C]161273.162790698[/C][C]49758.8372093023[/C][/ROW]
[ROW][C]88[/C][C]71960[/C][C]94324.25[/C][C]-22364.25[/C][/ROW]
[ROW][C]89[/C][C]90379[/C][C]94324.25[/C][C]-3945.25[/C][/ROW]
[ROW][C]90[/C][C]125650[/C][C]118704.884615385[/C][C]6945.11538461539[/C][/ROW]
[ROW][C]91[/C][C]115572[/C][C]144667.7[/C][C]-29095.7[/C][/ROW]
[ROW][C]92[/C][C]136266[/C][C]161273.162790698[/C][C]-25007.1627906977[/C][/ROW]
[ROW][C]93[/C][C]146715[/C][C]144667.7[/C][C]2047.29999999999[/C][/ROW]
[ROW][C]94[/C][C]124626[/C][C]118704.884615385[/C][C]5921.11538461539[/C][/ROW]
[ROW][C]95[/C][C]49176[/C][C]50971.1428571429[/C][C]-1795.14285714286[/C][/ROW]
[ROW][C]96[/C][C]212926[/C][C]161273.162790698[/C][C]51652.8372093023[/C][/ROW]
[ROW][C]97[/C][C]173884[/C][C]161273.162790698[/C][C]12610.8372093023[/C][/ROW]
[ROW][C]98[/C][C]19349[/C][C]8818.73333333333[/C][C]10530.2666666667[/C][/ROW]
[ROW][C]99[/C][C]181141[/C][C]161273.162790698[/C][C]19867.8372093023[/C][/ROW]
[ROW][C]100[/C][C]145502[/C][C]161273.162790698[/C][C]-15771.1627906977[/C][/ROW]
[ROW][C]101[/C][C]45448[/C][C]50971.1428571429[/C][C]-5523.14285714286[/C][/ROW]
[ROW][C]102[/C][C]58280[/C][C]79796.3333333333[/C][C]-21516.3333333333[/C][/ROW]
[ROW][C]103[/C][C]115944[/C][C]94324.25[/C][C]21619.75[/C][/ROW]
[ROW][C]104[/C][C]94341[/C][C]94324.25[/C][C]16.75[/C][/ROW]
[ROW][C]105[/C][C]59090[/C][C]50971.1428571429[/C][C]8118.85714285714[/C][/ROW]
[ROW][C]106[/C][C]27676[/C][C]50971.1428571429[/C][C]-23295.1428571429[/C][/ROW]
[ROW][C]107[/C][C]120586[/C][C]118704.884615385[/C][C]1881.11538461539[/C][/ROW]
[ROW][C]108[/C][C]88011[/C][C]50971.1428571429[/C][C]37039.8571428571[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]8818.73333333333[/C][C]-8818.73333333333[/C][/ROW]
[ROW][C]110[/C][C]85610[/C][C]94324.25[/C][C]-8714.25[/C][/ROW]
[ROW][C]111[/C][C]84193[/C][C]94324.25[/C][C]-10131.25[/C][/ROW]
[ROW][C]112[/C][C]117769[/C][C]118704.884615385[/C][C]-935.88461538461[/C][/ROW]
[ROW][C]113[/C][C]107653[/C][C]94324.25[/C][C]13328.75[/C][/ROW]
[ROW][C]114[/C][C]71894[/C][C]79796.3333333333[/C][C]-7902.33333333333[/C][/ROW]
[ROW][C]115[/C][C]3616[/C][C]8818.73333333333[/C][C]-5202.73333333333[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]8818.73333333333[/C][C]-8818.73333333333[/C][/ROW]
[ROW][C]117[/C][C]154806[/C][C]144667.7[/C][C]10138.3[/C][/ROW]
[ROW][C]118[/C][C]136061[/C][C]144667.7[/C][C]-8606.70000000001[/C][/ROW]
[ROW][C]119[/C][C]141822[/C][C]161273.162790698[/C][C]-19451.1627906977[/C][/ROW]
[ROW][C]120[/C][C]106515[/C][C]79796.3333333333[/C][C]26718.6666666667[/C][/ROW]
[ROW][C]121[/C][C]43410[/C][C]50971.1428571429[/C][C]-7561.14285714286[/C][/ROW]
[ROW][C]122[/C][C]146920[/C][C]144667.7[/C][C]2252.29999999999[/C][/ROW]
[ROW][C]123[/C][C]88874[/C][C]79796.3333333333[/C][C]9077.66666666667[/C][/ROW]
[ROW][C]124[/C][C]111924[/C][C]161273.162790698[/C][C]-49349.1627906977[/C][/ROW]
[ROW][C]125[/C][C]60373[/C][C]50971.1428571429[/C][C]9401.85714285714[/C][/ROW]
[ROW][C]126[/C][C]19764[/C][C]8818.73333333333[/C][C]10945.2666666667[/C][/ROW]
[ROW][C]127[/C][C]121665[/C][C]118704.884615385[/C][C]2960.11538461539[/C][/ROW]
[ROW][C]128[/C][C]108685[/C][C]94324.25[/C][C]14360.75[/C][/ROW]
[ROW][C]129[/C][C]124493[/C][C]94324.25[/C][C]30168.75[/C][/ROW]
[ROW][C]130[/C][C]11796[/C][C]8818.73333333333[/C][C]2977.26666666667[/C][/ROW]
[ROW][C]131[/C][C]10674[/C][C]8818.73333333333[/C][C]1855.26666666667[/C][/ROW]
[ROW][C]132[/C][C]131263[/C][C]118704.884615385[/C][C]12558.1153846154[/C][/ROW]
[ROW][C]133[/C][C]6836[/C][C]8818.73333333333[/C][C]-1982.73333333333[/C][/ROW]
[ROW][C]134[/C][C]153278[/C][C]161273.162790698[/C][C]-7995.16279069768[/C][/ROW]
[ROW][C]135[/C][C]5118[/C][C]8818.73333333333[/C][C]-3700.73333333333[/C][/ROW]
[ROW][C]136[/C][C]40248[/C][C]50971.1428571429[/C][C]-10723.1428571429[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]8818.73333333333[/C][C]-8818.73333333333[/C][/ROW]
[ROW][C]138[/C][C]100728[/C][C]94324.25[/C][C]6403.75[/C][/ROW]
[ROW][C]139[/C][C]84267[/C][C]118704.884615385[/C][C]-34437.8846153846[/C][/ROW]
[ROW][C]140[/C][C]7131[/C][C]8818.73333333333[/C][C]-1687.73333333333[/C][/ROW]
[ROW][C]141[/C][C]8812[/C][C]8818.73333333333[/C][C]-6.73333333333358[/C][/ROW]
[ROW][C]142[/C][C]63952[/C][C]50971.1428571429[/C][C]12980.8571428571[/C][/ROW]
[ROW][C]143[/C][C]120111[/C][C]118704.884615385[/C][C]1406.11538461539[/C][/ROW]
[ROW][C]144[/C][C]94127[/C][C]118704.884615385[/C][C]-24577.8846153846[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=159040&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159040&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
1150596161273.162790698-10677.1627906977
2154801144667.710133.3
372158818.73333333333-1603.73333333333
4122139161273.162790698-39134.1627906977
5221399161273.16279069860125.8372093023
6441870266605.285714286175264.714285714
7134379144667.7-10288.7
8140428144667.7-4239.70000000001
910325594324.258930.75
10271630266605.2857142865024.71428571426
11121593161273.162790698-39680.1627906977
12172071161273.16279069810797.8372093023
138370794324.25-10617.25
14197412161273.16279069836138.8372093023
15134398118704.88461538515693.1153846154
16139224118704.88461538520519.1153846154
17134153161273.162790698-27120.1627906977
186414994324.25-30175.25
19122294161273.162790698-38979.1627906977
202488950971.1428571429-26082.1428571429
215219750971.14285714291225.85714285714
22188915266605.285714286-77690.2857142857
23163147161273.1627906981873.83720930232
2498575161273.162790698-62698.1627906977
25143546161273.162790698-17727.1627906977
26139780118704.88461538521075.1153846154
27163784161273.1627906982510.83720930232
28152479144667.77811.29999999999
29304108266605.28571428637502.7142857143
30184024161273.16279069822750.8372093023
31151621118704.88461538532916.1153846154
32164516144667.719848.3
33120179161273.162790698-41094.1627906977
34214701161273.16279069853427.8372093023
35196865161273.16279069835591.8372093023
3608818.73333333333-8818.73333333333
37181527161273.16279069820253.8372093023
389310794324.25-1217.25
39129352161273.162790698-31921.1627906977
40229143266605.285714286-37462.2857142857
41177063161273.16279069815789.8372093023
42126602118704.8846153857897.11538461539
4393742118704.884615385-24962.8846153846
44152153161273.162790698-9120.16279069768
459570494324.251379.75
46139793118704.88461538521088.1153846154
477634879796.3333333333-3448.33333333333
48188980161273.16279069827706.8372093023
49172100161273.16279069810826.8372093023
50146552161273.162790698-14721.1627906977
514818850971.1428571429-2783.14285714286
5210918594324.2514860.75
53263652266605.285714286-2953.28571428574
54215609161273.16279069854335.8372093023
55174876161273.16279069813602.8372093023
56115124118704.884615385-3580.88461538461
57179712161273.16279069818438.8372093023
587036979796.3333333333-9427.33333333333
5910921579796.333333333329418.6666666667
60166096161273.1627906984822.83720930232
61130414118704.88461538511709.1153846154
62102057161273.162790698-59216.1627906977
63115310118704.884615385-3394.88461538461
64101181118704.884615385-17523.8846153846
65135228118704.88461538516523.1153846154
6694982118704.884615385-23722.8846153846
67166919266605.285714286-99686.2857142857
68118169161273.162790698-43104.1627906977
69102361118704.884615385-16343.8846153846
70319708818.7333333333323151.2666666667
71200413161273.16279069839139.8372093023
72103381118704.884615385-15323.8846153846
739494094324.25615.75
7410156094324.257235.75
75144176161273.162790698-17097.1627906977
767192194324.25-22403.25
77126905161273.162790698-34368.1627906977
78131184161273.162790698-30089.1627906977
796013850971.14285714299166.85714285714
808497194324.25-9353.25
818042079796.3333333333623.666666666672
82233569161273.16279069872295.8372093023
835625279796.3333333333-23544.3333333333
8497181118704.884615385-21523.8846153846
855080050971.1428571429-171.142857142855
86125941118704.8846153857236.11538461539
87211032161273.16279069849758.8372093023
887196094324.25-22364.25
899037994324.25-3945.25
90125650118704.8846153856945.11538461539
91115572144667.7-29095.7
92136266161273.162790698-25007.1627906977
93146715144667.72047.29999999999
94124626118704.8846153855921.11538461539
954917650971.1428571429-1795.14285714286
96212926161273.16279069851652.8372093023
97173884161273.16279069812610.8372093023
98193498818.7333333333310530.2666666667
99181141161273.16279069819867.8372093023
100145502161273.162790698-15771.1627906977
1014544850971.1428571429-5523.14285714286
1025828079796.3333333333-21516.3333333333
10311594494324.2521619.75
1049434194324.2516.75
1055909050971.14285714298118.85714285714
1062767650971.1428571429-23295.1428571429
107120586118704.8846153851881.11538461539
1088801150971.142857142937039.8571428571
10908818.73333333333-8818.73333333333
1108561094324.25-8714.25
1118419394324.25-10131.25
112117769118704.884615385-935.88461538461
11310765394324.2513328.75
1147189479796.3333333333-7902.33333333333
11536168818.73333333333-5202.73333333333
11608818.73333333333-8818.73333333333
117154806144667.710138.3
118136061144667.7-8606.70000000001
119141822161273.162790698-19451.1627906977
12010651579796.333333333326718.6666666667
1214341050971.1428571429-7561.14285714286
122146920144667.72252.29999999999
1238887479796.33333333339077.66666666667
124111924161273.162790698-49349.1627906977
1256037350971.14285714299401.85714285714
126197648818.7333333333310945.2666666667
127121665118704.8846153852960.11538461539
12810868594324.2514360.75
12912449394324.2530168.75
130117968818.733333333332977.26666666667
131106748818.733333333331855.26666666667
132131263118704.88461538512558.1153846154
13368368818.73333333333-1982.73333333333
134153278161273.162790698-7995.16279069768
13551188818.73333333333-3700.73333333333
1364024850971.1428571429-10723.1428571429
13708818.73333333333-8818.73333333333
13810072894324.256403.75
13984267118704.884615385-34437.8846153846
14071318818.73333333333-1687.73333333333
14188128818.73333333333-6.73333333333358
1426395250971.142857142912980.8571428571
143120111118704.8846153851406.11538461539
14494127118704.884615385-24577.8846153846



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