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 10:00:54 -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/t132447971914wq4gikxs5vwlo.htm/, Retrieved Tue, 07 May 2024 09:28:41 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158800, Retrieved Tue, 07 May 2024 09:28:41 +0000
QR Codes:

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

Post a new message
Dataseries X:
158258	48	18	63	20465	23975
186930	53	20	56	33629	85634
7215	0	0	0	1423	1929
128162	51	27	63	25629	36294
226974	76	31	116	54002	72255
500344	125	36	138	151036	189748
171007	59	23	71	33287	61834
179835	80	30	107	31172	68167
154581	55	30	50	28113	38462
278960	67	26	79	57803	101219
121844	50	24	58	49830	43270
183086	77	30	91	52143	76183
98796	44	22	41	21055	31476
209322	79	25	91	47007	62157
157125	51	18	61	28735	46261
154565	54	22	74	59147	50063
134198	75	33	131	78950	64483
69128	2	15	45	13497	2341
150680	73	34	110	46154	48149
27997	13	18	41	53249	12743
69919	19	15	37	10726	18743
233044	93	30	84	83700	97057
195820	38	25	67	40400	17675
127994	48	34	69	33797	33106
145433	50	21	58	36205	53311
170864	48	21	60	30165	42754
199655	60	25	88	58534	59056
188633	81	31	75	44663	101621
354266	60	31	98	92556	118120
192399	52	20	67	40078	79572
165753	50	28	84	34711	42744
173721	60	20	58	31076	65931
126739	53	17	35	74608	38575
224762	76	25	74	58092	28795
219428	63	24	89	42009	94440
0	0	0	0	0	0
217267	54	27	75	36022	38229
99706	44	14	39	23333	31972
136733	36	35	101	53349	40071
249965	83	34	135	92596	132480
232951	105	22	76	49598	62797
143755	37	34	118	44093	40429
95734	25	23	76	84205	45545
191416	63	24	65	63369	57568
114820	55	26	97	60132	39019
157625	41	22	67	37403	53866
81293	23	35	63	24460	38345
210040	63	24	96	46456	50210
223771	54	31	112	66616	80947
160344	68	26	75	41554	43461
48188	12	22	39	22346	14812
145235	84	21	63	30874	37819
287839	66	27	93	68701	102738
235223	56	30	76	35728	54509
195583	67	33	117	29010	62956
145942	40	11	30	23110	55411
207309	53	26	65	38844	50611
93764	26	26	78	27084	26692
151985	67	23	87	35139	60056
190545	36	38	85	57476	25155
146414	50	30	111	33277	42840
130794	48	19	60	31141	39358
124234	46	19	53	61281	47241
112718	53	26	67	25820	49611
160817	27	26	90	23284	41833
99070	38	33	100	35378	48930
178653	68	36	135	74990	110600
138708	93	25	71	29653	52235
114408	59	24	75	64622	53986
31970	5	21	42	4157	4105
224494	53	19	42	29245	59331
123328	36	12	8	50008	47796
113504	72	30	86	52338	38302
105932	49	21	41	13310	14063
162203	81	34	118	92901	54414
100098	27	32	91	10956	9903
174768	94	28	102	34241	53987
156752	71	28	89	75043	88937
77269	18	21	46	21152	21928
84971	34	31	60	42249	29487
80522	54	26	69	42005	35334
276525	44	29	95	41152	57596
62974	26	23	17	14399	29750
120296	44	25	61	28263	41029
75555	35	22	55	17215	12416
157988	32	26	55	48140	51158
223247	55	33	124	62897	79935
115019	58	24	73	22883	26552
99602	44	24	73	41622	25807
151804	39	21	67	40715	50620
146005	49	28	66	65897	61467
163444	72	27	75	76542	65292
151517	39	25	83	37477	55516
133686	28	15	55	53216	42006
58128	24	13	27	40911	26273
234325	49	36	115	57021	90248
195576	96	24	76	73116	61476
19349	13	1	0	3895	9604
213189	32	24	83	46609	45108
151672	41	31	90	29351	47232
59117	24	4	4	2325	3439
71931	52	20	56	31747	30553
126653	57	23	63	32665	24751
113552	28	23	52	19249	34458
85338	36	12	24	15292	24649
27676	2	16	17	5842	2342
138522	80	29	105	33994	52739
122417	29	26	20	13018	6245
0	0	0	0	0	0
87592	46	25	51	98177	35381
107205	25	21	76	37941	19595
144664	51	23	59	31032	50848
136540	59	21	70	32683	39443
71894	36	21	38	34545	27023
3616	0	0	0	0	0
0	0	0	0	0	0
175055	38	23	81	27525	61022
144618	68	33	78	66856	63528
152826	28	28	67	28549	34835
113245	36	23	89	38610	37172
43410	7	1	3	2781	13
175762	70	29	87	41211	62548
93634	30	17	48	22698	31334
117426	59	31	66	41194	20839
60493	3	12	32	32689	5084
19764	10	2	4	5752	9927
164062	46	21	70	26757	53229
128144	34	26	94	22527	29877
154959	54	29	91	44810	37310
11796	1	2	1	0	0
10674	0	0	0	0	0
138547	35	18	39	100674	50067
6836	0	1	0	0	0
154135	48	21	45	57786	47708
5118	5	0	0	0	0
40248	8	4	7	5444	6012
0	0	0	0	0	0
120460	36	25	75	28470	27749
88837	21	26	52	61849	47555
7131	0	0	0	0	0
9056	0	4	1	2179	1336
68916	15	17	49	8019	11017
132697	50	21	69	39644	55184
100681	17	22	56	23494	43485




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

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

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

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

As an alternative you can also use a QR Code:  

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

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







Goodness of Fit
Correlation0.7535
R-squared0.5678
RMSE16447.4413

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

[TABLE]
[ROW][C]Goodness of Fit[/C][/ROW]
[ROW][C]Correlation[/C][C]0.7535[/C][/ROW]
[ROW][C]R-squared[/C][C]0.5678[/C][/ROW]
[ROW][C]RMSE[/C][C]16447.4413[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158800&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158800&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.7535
R-squared0.5678
RMSE16447.4413







Actuals, Predictions, and Residuals
#ActualsForecastsResiduals
12046530325.0344827586-9860.03448275862
23362946108.3048780488-12479.3048780488
314231748.5-325.5
42562946108.3048780488-20479.3048780488
55400246108.30487804887893.69512195122
615103683255.62567780.375
73328746108.3048780488-12821.3048780488
83117246108.3048780488-14936.3048780488
92811346108.3048780488-17995.3048780488
105780383255.625-25452.625
114983046108.30487804883721.69512195122
125214346108.30487804886034.69512195122
132105530325.0344827586-9270.03448275862
144700746108.3048780488898.695121951219
152873546108.3048780488-17373.3048780488
165914746108.304878048813038.6951219512
177895046108.304878048832841.6951219512
181349713959.8571428571-462.857142857143
194615446108.304878048845.6951219512193
205324930325.034482758622923.9655172414
211072630325.0344827586-19599.0344827586
228370083255.625444.375
234040030325.034482758610074.9655172414
243379730325.03448275863471.96551724138
253620546108.3048780488-9903.30487804878
263016546108.3048780488-15943.3048780488
275853446108.304878048812425.6951219512
284466383255.625-38592.625
299255683255.6259300.375
304007846108.3048780488-6030.30487804878
313471146108.3048780488-11397.3048780488
323107646108.3048780488-15032.3048780488
337460846108.304878048828499.6951219512
345809230325.034482758627766.9655172414
354200946108.3048780488-4099.30487804878
3601748.5-1748.5
373602246108.3048780488-10086.3048780488
382333330325.0344827586-6992.03448275862
395334946108.30487804887240.69512195122
409259683255.6259340.375
414959846108.30487804883489.69512195122
424409346108.3048780488-2015.30487804878
438420546108.304878048838096.6951219512
446336946108.304878048817260.6951219512
456013246108.304878048814023.6951219512
463740346108.3048780488-8705.30487804878
472446046108.3048780488-21648.3048780488
484645646108.3048780488347.695121951219
496661646108.304878048820507.6951219512
504155446108.3048780488-4554.30487804878
512234630325.0344827586-7979.03448275862
523087446108.3048780488-15234.3048780488
536870183255.625-14554.625
543572846108.3048780488-10380.3048780488
552901046108.3048780488-17098.3048780488
562311046108.3048780488-22998.3048780488
573884446108.3048780488-7264.30487804878
582708430325.0344827586-3241.03448275862
593513946108.3048780488-10969.3048780488
605747630325.034482758627150.9655172414
613327746108.3048780488-12831.3048780488
623114146108.3048780488-14967.3048780488
636128146108.304878048815172.6951219512
642582046108.3048780488-20288.3048780488
652328446108.3048780488-22824.3048780488
663537846108.3048780488-10730.3048780488
677499083255.625-8265.625
682965346108.3048780488-16455.3048780488
696462246108.304878048818513.6951219512
7041571748.52408.5
712924546108.3048780488-16863.3048780488
725000846108.30487804883899.69512195122
735233846108.30487804886229.69512195122
741331030325.0344827586-17015.0344827586
759290146108.304878048846792.6951219512
761095613959.8571428571-3003.85714285714
773424146108.3048780488-11867.3048780488
787504346108.304878048828934.6951219512
792115230325.0344827586-9173.03448275862
804224930325.034482758611923.9655172414
814200546108.3048780488-4103.30487804878
824115246108.3048780488-4956.30487804878
831439930325.0344827586-15926.0344827586
842826346108.3048780488-17845.3048780488
851721513959.85714285713255.14285714286
864814046108.30487804882031.69512195122
876289746108.304878048816788.6951219512
882288330325.0344827586-7442.03448275862
894162230325.034482758611296.9655172414
904071546108.3048780488-5393.30487804878
916589746108.304878048819788.6951219512
927654246108.304878048830433.6951219512
933747746108.3048780488-8631.30487804878
945321646108.30487804887107.69512195122
954091130325.034482758610585.9655172414
965702146108.304878048810912.6951219512
977311646108.304878048827007.6951219512
9838951748.52146.5
994660946108.3048780488500.695121951219
1002935146108.3048780488-16757.3048780488
101232513959.8571428571-11634.8571428571
1023174730325.03448275861421.96551724138
1033266530325.03448275862339.96551724138
1041924930325.0344827586-11076.0344827586
1051529230325.0344827586-15033.0344827586
10658421748.54093.5
1073399446108.3048780488-12114.3048780488
1081301813959.8571428571-941.857142857143
10901748.5-1748.5
1109817746108.304878048852068.6951219512
1113794130325.03448275867615.96551724138
1123103246108.3048780488-15076.3048780488
1133268346108.3048780488-13425.3048780488
1143454530325.03448275864219.96551724138
11501748.5-1748.5
11601748.5-1748.5
1172752546108.3048780488-18583.3048780488
1186685646108.304878048820747.6951219512
1192854930325.0344827586-1776.03448275862
1203861046108.3048780488-7498.30487804878
12127811748.51032.5
1224121146108.3048780488-4897.30487804878
1232269830325.0344827586-7627.03448275862
1244119430325.034482758610868.9655172414
1253268913959.857142857118729.1428571429
12657521748.54003.5
1272675746108.3048780488-19351.3048780488
1282252730325.0344827586-7798.03448275862
1294481046108.3048780488-1298.30487804878
13001748.5-1748.5
13101748.5-1748.5
13210067446108.304878048854565.6951219512
13301748.5-1748.5
1345778646108.304878048811677.6951219512
13501748.5-1748.5
13654441748.53695.5
13701748.5-1748.5
1382847030325.0344827586-1855.03448275862
1396184946108.304878048815740.6951219512
14001748.5-1748.5
14121791748.5430.5
142801913959.8571428571-5940.85714285714
1433964446108.3048780488-6464.30487804878
1442349446108.3048780488-22614.3048780488

\begin{tabular}{lllllllll}
\hline
Actuals, Predictions, and Residuals \tabularnewline
# & Actuals & Forecasts & Residuals \tabularnewline
1 & 20465 & 30325.0344827586 & -9860.03448275862 \tabularnewline
2 & 33629 & 46108.3048780488 & -12479.3048780488 \tabularnewline
3 & 1423 & 1748.5 & -325.5 \tabularnewline
4 & 25629 & 46108.3048780488 & -20479.3048780488 \tabularnewline
5 & 54002 & 46108.3048780488 & 7893.69512195122 \tabularnewline
6 & 151036 & 83255.625 & 67780.375 \tabularnewline
7 & 33287 & 46108.3048780488 & -12821.3048780488 \tabularnewline
8 & 31172 & 46108.3048780488 & -14936.3048780488 \tabularnewline
9 & 28113 & 46108.3048780488 & -17995.3048780488 \tabularnewline
10 & 57803 & 83255.625 & -25452.625 \tabularnewline
11 & 49830 & 46108.3048780488 & 3721.69512195122 \tabularnewline
12 & 52143 & 46108.3048780488 & 6034.69512195122 \tabularnewline
13 & 21055 & 30325.0344827586 & -9270.03448275862 \tabularnewline
14 & 47007 & 46108.3048780488 & 898.695121951219 \tabularnewline
15 & 28735 & 46108.3048780488 & -17373.3048780488 \tabularnewline
16 & 59147 & 46108.3048780488 & 13038.6951219512 \tabularnewline
17 & 78950 & 46108.3048780488 & 32841.6951219512 \tabularnewline
18 & 13497 & 13959.8571428571 & -462.857142857143 \tabularnewline
19 & 46154 & 46108.3048780488 & 45.6951219512193 \tabularnewline
20 & 53249 & 30325.0344827586 & 22923.9655172414 \tabularnewline
21 & 10726 & 30325.0344827586 & -19599.0344827586 \tabularnewline
22 & 83700 & 83255.625 & 444.375 \tabularnewline
23 & 40400 & 30325.0344827586 & 10074.9655172414 \tabularnewline
24 & 33797 & 30325.0344827586 & 3471.96551724138 \tabularnewline
25 & 36205 & 46108.3048780488 & -9903.30487804878 \tabularnewline
26 & 30165 & 46108.3048780488 & -15943.3048780488 \tabularnewline
27 & 58534 & 46108.3048780488 & 12425.6951219512 \tabularnewline
28 & 44663 & 83255.625 & -38592.625 \tabularnewline
29 & 92556 & 83255.625 & 9300.375 \tabularnewline
30 & 40078 & 46108.3048780488 & -6030.30487804878 \tabularnewline
31 & 34711 & 46108.3048780488 & -11397.3048780488 \tabularnewline
32 & 31076 & 46108.3048780488 & -15032.3048780488 \tabularnewline
33 & 74608 & 46108.3048780488 & 28499.6951219512 \tabularnewline
34 & 58092 & 30325.0344827586 & 27766.9655172414 \tabularnewline
35 & 42009 & 46108.3048780488 & -4099.30487804878 \tabularnewline
36 & 0 & 1748.5 & -1748.5 \tabularnewline
37 & 36022 & 46108.3048780488 & -10086.3048780488 \tabularnewline
38 & 23333 & 30325.0344827586 & -6992.03448275862 \tabularnewline
39 & 53349 & 46108.3048780488 & 7240.69512195122 \tabularnewline
40 & 92596 & 83255.625 & 9340.375 \tabularnewline
41 & 49598 & 46108.3048780488 & 3489.69512195122 \tabularnewline
42 & 44093 & 46108.3048780488 & -2015.30487804878 \tabularnewline
43 & 84205 & 46108.3048780488 & 38096.6951219512 \tabularnewline
44 & 63369 & 46108.3048780488 & 17260.6951219512 \tabularnewline
45 & 60132 & 46108.3048780488 & 14023.6951219512 \tabularnewline
46 & 37403 & 46108.3048780488 & -8705.30487804878 \tabularnewline
47 & 24460 & 46108.3048780488 & -21648.3048780488 \tabularnewline
48 & 46456 & 46108.3048780488 & 347.695121951219 \tabularnewline
49 & 66616 & 46108.3048780488 & 20507.6951219512 \tabularnewline
50 & 41554 & 46108.3048780488 & -4554.30487804878 \tabularnewline
51 & 22346 & 30325.0344827586 & -7979.03448275862 \tabularnewline
52 & 30874 & 46108.3048780488 & -15234.3048780488 \tabularnewline
53 & 68701 & 83255.625 & -14554.625 \tabularnewline
54 & 35728 & 46108.3048780488 & -10380.3048780488 \tabularnewline
55 & 29010 & 46108.3048780488 & -17098.3048780488 \tabularnewline
56 & 23110 & 46108.3048780488 & -22998.3048780488 \tabularnewline
57 & 38844 & 46108.3048780488 & -7264.30487804878 \tabularnewline
58 & 27084 & 30325.0344827586 & -3241.03448275862 \tabularnewline
59 & 35139 & 46108.3048780488 & -10969.3048780488 \tabularnewline
60 & 57476 & 30325.0344827586 & 27150.9655172414 \tabularnewline
61 & 33277 & 46108.3048780488 & -12831.3048780488 \tabularnewline
62 & 31141 & 46108.3048780488 & -14967.3048780488 \tabularnewline
63 & 61281 & 46108.3048780488 & 15172.6951219512 \tabularnewline
64 & 25820 & 46108.3048780488 & -20288.3048780488 \tabularnewline
65 & 23284 & 46108.3048780488 & -22824.3048780488 \tabularnewline
66 & 35378 & 46108.3048780488 & -10730.3048780488 \tabularnewline
67 & 74990 & 83255.625 & -8265.625 \tabularnewline
68 & 29653 & 46108.3048780488 & -16455.3048780488 \tabularnewline
69 & 64622 & 46108.3048780488 & 18513.6951219512 \tabularnewline
70 & 4157 & 1748.5 & 2408.5 \tabularnewline
71 & 29245 & 46108.3048780488 & -16863.3048780488 \tabularnewline
72 & 50008 & 46108.3048780488 & 3899.69512195122 \tabularnewline
73 & 52338 & 46108.3048780488 & 6229.69512195122 \tabularnewline
74 & 13310 & 30325.0344827586 & -17015.0344827586 \tabularnewline
75 & 92901 & 46108.3048780488 & 46792.6951219512 \tabularnewline
76 & 10956 & 13959.8571428571 & -3003.85714285714 \tabularnewline
77 & 34241 & 46108.3048780488 & -11867.3048780488 \tabularnewline
78 & 75043 & 46108.3048780488 & 28934.6951219512 \tabularnewline
79 & 21152 & 30325.0344827586 & -9173.03448275862 \tabularnewline
80 & 42249 & 30325.0344827586 & 11923.9655172414 \tabularnewline
81 & 42005 & 46108.3048780488 & -4103.30487804878 \tabularnewline
82 & 41152 & 46108.3048780488 & -4956.30487804878 \tabularnewline
83 & 14399 & 30325.0344827586 & -15926.0344827586 \tabularnewline
84 & 28263 & 46108.3048780488 & -17845.3048780488 \tabularnewline
85 & 17215 & 13959.8571428571 & 3255.14285714286 \tabularnewline
86 & 48140 & 46108.3048780488 & 2031.69512195122 \tabularnewline
87 & 62897 & 46108.3048780488 & 16788.6951219512 \tabularnewline
88 & 22883 & 30325.0344827586 & -7442.03448275862 \tabularnewline
89 & 41622 & 30325.0344827586 & 11296.9655172414 \tabularnewline
90 & 40715 & 46108.3048780488 & -5393.30487804878 \tabularnewline
91 & 65897 & 46108.3048780488 & 19788.6951219512 \tabularnewline
92 & 76542 & 46108.3048780488 & 30433.6951219512 \tabularnewline
93 & 37477 & 46108.3048780488 & -8631.30487804878 \tabularnewline
94 & 53216 & 46108.3048780488 & 7107.69512195122 \tabularnewline
95 & 40911 & 30325.0344827586 & 10585.9655172414 \tabularnewline
96 & 57021 & 46108.3048780488 & 10912.6951219512 \tabularnewline
97 & 73116 & 46108.3048780488 & 27007.6951219512 \tabularnewline
98 & 3895 & 1748.5 & 2146.5 \tabularnewline
99 & 46609 & 46108.3048780488 & 500.695121951219 \tabularnewline
100 & 29351 & 46108.3048780488 & -16757.3048780488 \tabularnewline
101 & 2325 & 13959.8571428571 & -11634.8571428571 \tabularnewline
102 & 31747 & 30325.0344827586 & 1421.96551724138 \tabularnewline
103 & 32665 & 30325.0344827586 & 2339.96551724138 \tabularnewline
104 & 19249 & 30325.0344827586 & -11076.0344827586 \tabularnewline
105 & 15292 & 30325.0344827586 & -15033.0344827586 \tabularnewline
106 & 5842 & 1748.5 & 4093.5 \tabularnewline
107 & 33994 & 46108.3048780488 & -12114.3048780488 \tabularnewline
108 & 13018 & 13959.8571428571 & -941.857142857143 \tabularnewline
109 & 0 & 1748.5 & -1748.5 \tabularnewline
110 & 98177 & 46108.3048780488 & 52068.6951219512 \tabularnewline
111 & 37941 & 30325.0344827586 & 7615.96551724138 \tabularnewline
112 & 31032 & 46108.3048780488 & -15076.3048780488 \tabularnewline
113 & 32683 & 46108.3048780488 & -13425.3048780488 \tabularnewline
114 & 34545 & 30325.0344827586 & 4219.96551724138 \tabularnewline
115 & 0 & 1748.5 & -1748.5 \tabularnewline
116 & 0 & 1748.5 & -1748.5 \tabularnewline
117 & 27525 & 46108.3048780488 & -18583.3048780488 \tabularnewline
118 & 66856 & 46108.3048780488 & 20747.6951219512 \tabularnewline
119 & 28549 & 30325.0344827586 & -1776.03448275862 \tabularnewline
120 & 38610 & 46108.3048780488 & -7498.30487804878 \tabularnewline
121 & 2781 & 1748.5 & 1032.5 \tabularnewline
122 & 41211 & 46108.3048780488 & -4897.30487804878 \tabularnewline
123 & 22698 & 30325.0344827586 & -7627.03448275862 \tabularnewline
124 & 41194 & 30325.0344827586 & 10868.9655172414 \tabularnewline
125 & 32689 & 13959.8571428571 & 18729.1428571429 \tabularnewline
126 & 5752 & 1748.5 & 4003.5 \tabularnewline
127 & 26757 & 46108.3048780488 & -19351.3048780488 \tabularnewline
128 & 22527 & 30325.0344827586 & -7798.03448275862 \tabularnewline
129 & 44810 & 46108.3048780488 & -1298.30487804878 \tabularnewline
130 & 0 & 1748.5 & -1748.5 \tabularnewline
131 & 0 & 1748.5 & -1748.5 \tabularnewline
132 & 100674 & 46108.3048780488 & 54565.6951219512 \tabularnewline
133 & 0 & 1748.5 & -1748.5 \tabularnewline
134 & 57786 & 46108.3048780488 & 11677.6951219512 \tabularnewline
135 & 0 & 1748.5 & -1748.5 \tabularnewline
136 & 5444 & 1748.5 & 3695.5 \tabularnewline
137 & 0 & 1748.5 & -1748.5 \tabularnewline
138 & 28470 & 30325.0344827586 & -1855.03448275862 \tabularnewline
139 & 61849 & 46108.3048780488 & 15740.6951219512 \tabularnewline
140 & 0 & 1748.5 & -1748.5 \tabularnewline
141 & 2179 & 1748.5 & 430.5 \tabularnewline
142 & 8019 & 13959.8571428571 & -5940.85714285714 \tabularnewline
143 & 39644 & 46108.3048780488 & -6464.30487804878 \tabularnewline
144 & 23494 & 46108.3048780488 & -22614.3048780488 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=158800&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]20465[/C][C]30325.0344827586[/C][C]-9860.03448275862[/C][/ROW]
[ROW][C]2[/C][C]33629[/C][C]46108.3048780488[/C][C]-12479.3048780488[/C][/ROW]
[ROW][C]3[/C][C]1423[/C][C]1748.5[/C][C]-325.5[/C][/ROW]
[ROW][C]4[/C][C]25629[/C][C]46108.3048780488[/C][C]-20479.3048780488[/C][/ROW]
[ROW][C]5[/C][C]54002[/C][C]46108.3048780488[/C][C]7893.69512195122[/C][/ROW]
[ROW][C]6[/C][C]151036[/C][C]83255.625[/C][C]67780.375[/C][/ROW]
[ROW][C]7[/C][C]33287[/C][C]46108.3048780488[/C][C]-12821.3048780488[/C][/ROW]
[ROW][C]8[/C][C]31172[/C][C]46108.3048780488[/C][C]-14936.3048780488[/C][/ROW]
[ROW][C]9[/C][C]28113[/C][C]46108.3048780488[/C][C]-17995.3048780488[/C][/ROW]
[ROW][C]10[/C][C]57803[/C][C]83255.625[/C][C]-25452.625[/C][/ROW]
[ROW][C]11[/C][C]49830[/C][C]46108.3048780488[/C][C]3721.69512195122[/C][/ROW]
[ROW][C]12[/C][C]52143[/C][C]46108.3048780488[/C][C]6034.69512195122[/C][/ROW]
[ROW][C]13[/C][C]21055[/C][C]30325.0344827586[/C][C]-9270.03448275862[/C][/ROW]
[ROW][C]14[/C][C]47007[/C][C]46108.3048780488[/C][C]898.695121951219[/C][/ROW]
[ROW][C]15[/C][C]28735[/C][C]46108.3048780488[/C][C]-17373.3048780488[/C][/ROW]
[ROW][C]16[/C][C]59147[/C][C]46108.3048780488[/C][C]13038.6951219512[/C][/ROW]
[ROW][C]17[/C][C]78950[/C][C]46108.3048780488[/C][C]32841.6951219512[/C][/ROW]
[ROW][C]18[/C][C]13497[/C][C]13959.8571428571[/C][C]-462.857142857143[/C][/ROW]
[ROW][C]19[/C][C]46154[/C][C]46108.3048780488[/C][C]45.6951219512193[/C][/ROW]
[ROW][C]20[/C][C]53249[/C][C]30325.0344827586[/C][C]22923.9655172414[/C][/ROW]
[ROW][C]21[/C][C]10726[/C][C]30325.0344827586[/C][C]-19599.0344827586[/C][/ROW]
[ROW][C]22[/C][C]83700[/C][C]83255.625[/C][C]444.375[/C][/ROW]
[ROW][C]23[/C][C]40400[/C][C]30325.0344827586[/C][C]10074.9655172414[/C][/ROW]
[ROW][C]24[/C][C]33797[/C][C]30325.0344827586[/C][C]3471.96551724138[/C][/ROW]
[ROW][C]25[/C][C]36205[/C][C]46108.3048780488[/C][C]-9903.30487804878[/C][/ROW]
[ROW][C]26[/C][C]30165[/C][C]46108.3048780488[/C][C]-15943.3048780488[/C][/ROW]
[ROW][C]27[/C][C]58534[/C][C]46108.3048780488[/C][C]12425.6951219512[/C][/ROW]
[ROW][C]28[/C][C]44663[/C][C]83255.625[/C][C]-38592.625[/C][/ROW]
[ROW][C]29[/C][C]92556[/C][C]83255.625[/C][C]9300.375[/C][/ROW]
[ROW][C]30[/C][C]40078[/C][C]46108.3048780488[/C][C]-6030.30487804878[/C][/ROW]
[ROW][C]31[/C][C]34711[/C][C]46108.3048780488[/C][C]-11397.3048780488[/C][/ROW]
[ROW][C]32[/C][C]31076[/C][C]46108.3048780488[/C][C]-15032.3048780488[/C][/ROW]
[ROW][C]33[/C][C]74608[/C][C]46108.3048780488[/C][C]28499.6951219512[/C][/ROW]
[ROW][C]34[/C][C]58092[/C][C]30325.0344827586[/C][C]27766.9655172414[/C][/ROW]
[ROW][C]35[/C][C]42009[/C][C]46108.3048780488[/C][C]-4099.30487804878[/C][/ROW]
[ROW][C]36[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]37[/C][C]36022[/C][C]46108.3048780488[/C][C]-10086.3048780488[/C][/ROW]
[ROW][C]38[/C][C]23333[/C][C]30325.0344827586[/C][C]-6992.03448275862[/C][/ROW]
[ROW][C]39[/C][C]53349[/C][C]46108.3048780488[/C][C]7240.69512195122[/C][/ROW]
[ROW][C]40[/C][C]92596[/C][C]83255.625[/C][C]9340.375[/C][/ROW]
[ROW][C]41[/C][C]49598[/C][C]46108.3048780488[/C][C]3489.69512195122[/C][/ROW]
[ROW][C]42[/C][C]44093[/C][C]46108.3048780488[/C][C]-2015.30487804878[/C][/ROW]
[ROW][C]43[/C][C]84205[/C][C]46108.3048780488[/C][C]38096.6951219512[/C][/ROW]
[ROW][C]44[/C][C]63369[/C][C]46108.3048780488[/C][C]17260.6951219512[/C][/ROW]
[ROW][C]45[/C][C]60132[/C][C]46108.3048780488[/C][C]14023.6951219512[/C][/ROW]
[ROW][C]46[/C][C]37403[/C][C]46108.3048780488[/C][C]-8705.30487804878[/C][/ROW]
[ROW][C]47[/C][C]24460[/C][C]46108.3048780488[/C][C]-21648.3048780488[/C][/ROW]
[ROW][C]48[/C][C]46456[/C][C]46108.3048780488[/C][C]347.695121951219[/C][/ROW]
[ROW][C]49[/C][C]66616[/C][C]46108.3048780488[/C][C]20507.6951219512[/C][/ROW]
[ROW][C]50[/C][C]41554[/C][C]46108.3048780488[/C][C]-4554.30487804878[/C][/ROW]
[ROW][C]51[/C][C]22346[/C][C]30325.0344827586[/C][C]-7979.03448275862[/C][/ROW]
[ROW][C]52[/C][C]30874[/C][C]46108.3048780488[/C][C]-15234.3048780488[/C][/ROW]
[ROW][C]53[/C][C]68701[/C][C]83255.625[/C][C]-14554.625[/C][/ROW]
[ROW][C]54[/C][C]35728[/C][C]46108.3048780488[/C][C]-10380.3048780488[/C][/ROW]
[ROW][C]55[/C][C]29010[/C][C]46108.3048780488[/C][C]-17098.3048780488[/C][/ROW]
[ROW][C]56[/C][C]23110[/C][C]46108.3048780488[/C][C]-22998.3048780488[/C][/ROW]
[ROW][C]57[/C][C]38844[/C][C]46108.3048780488[/C][C]-7264.30487804878[/C][/ROW]
[ROW][C]58[/C][C]27084[/C][C]30325.0344827586[/C][C]-3241.03448275862[/C][/ROW]
[ROW][C]59[/C][C]35139[/C][C]46108.3048780488[/C][C]-10969.3048780488[/C][/ROW]
[ROW][C]60[/C][C]57476[/C][C]30325.0344827586[/C][C]27150.9655172414[/C][/ROW]
[ROW][C]61[/C][C]33277[/C][C]46108.3048780488[/C][C]-12831.3048780488[/C][/ROW]
[ROW][C]62[/C][C]31141[/C][C]46108.3048780488[/C][C]-14967.3048780488[/C][/ROW]
[ROW][C]63[/C][C]61281[/C][C]46108.3048780488[/C][C]15172.6951219512[/C][/ROW]
[ROW][C]64[/C][C]25820[/C][C]46108.3048780488[/C][C]-20288.3048780488[/C][/ROW]
[ROW][C]65[/C][C]23284[/C][C]46108.3048780488[/C][C]-22824.3048780488[/C][/ROW]
[ROW][C]66[/C][C]35378[/C][C]46108.3048780488[/C][C]-10730.3048780488[/C][/ROW]
[ROW][C]67[/C][C]74990[/C][C]83255.625[/C][C]-8265.625[/C][/ROW]
[ROW][C]68[/C][C]29653[/C][C]46108.3048780488[/C][C]-16455.3048780488[/C][/ROW]
[ROW][C]69[/C][C]64622[/C][C]46108.3048780488[/C][C]18513.6951219512[/C][/ROW]
[ROW][C]70[/C][C]4157[/C][C]1748.5[/C][C]2408.5[/C][/ROW]
[ROW][C]71[/C][C]29245[/C][C]46108.3048780488[/C][C]-16863.3048780488[/C][/ROW]
[ROW][C]72[/C][C]50008[/C][C]46108.3048780488[/C][C]3899.69512195122[/C][/ROW]
[ROW][C]73[/C][C]52338[/C][C]46108.3048780488[/C][C]6229.69512195122[/C][/ROW]
[ROW][C]74[/C][C]13310[/C][C]30325.0344827586[/C][C]-17015.0344827586[/C][/ROW]
[ROW][C]75[/C][C]92901[/C][C]46108.3048780488[/C][C]46792.6951219512[/C][/ROW]
[ROW][C]76[/C][C]10956[/C][C]13959.8571428571[/C][C]-3003.85714285714[/C][/ROW]
[ROW][C]77[/C][C]34241[/C][C]46108.3048780488[/C][C]-11867.3048780488[/C][/ROW]
[ROW][C]78[/C][C]75043[/C][C]46108.3048780488[/C][C]28934.6951219512[/C][/ROW]
[ROW][C]79[/C][C]21152[/C][C]30325.0344827586[/C][C]-9173.03448275862[/C][/ROW]
[ROW][C]80[/C][C]42249[/C][C]30325.0344827586[/C][C]11923.9655172414[/C][/ROW]
[ROW][C]81[/C][C]42005[/C][C]46108.3048780488[/C][C]-4103.30487804878[/C][/ROW]
[ROW][C]82[/C][C]41152[/C][C]46108.3048780488[/C][C]-4956.30487804878[/C][/ROW]
[ROW][C]83[/C][C]14399[/C][C]30325.0344827586[/C][C]-15926.0344827586[/C][/ROW]
[ROW][C]84[/C][C]28263[/C][C]46108.3048780488[/C][C]-17845.3048780488[/C][/ROW]
[ROW][C]85[/C][C]17215[/C][C]13959.8571428571[/C][C]3255.14285714286[/C][/ROW]
[ROW][C]86[/C][C]48140[/C][C]46108.3048780488[/C][C]2031.69512195122[/C][/ROW]
[ROW][C]87[/C][C]62897[/C][C]46108.3048780488[/C][C]16788.6951219512[/C][/ROW]
[ROW][C]88[/C][C]22883[/C][C]30325.0344827586[/C][C]-7442.03448275862[/C][/ROW]
[ROW][C]89[/C][C]41622[/C][C]30325.0344827586[/C][C]11296.9655172414[/C][/ROW]
[ROW][C]90[/C][C]40715[/C][C]46108.3048780488[/C][C]-5393.30487804878[/C][/ROW]
[ROW][C]91[/C][C]65897[/C][C]46108.3048780488[/C][C]19788.6951219512[/C][/ROW]
[ROW][C]92[/C][C]76542[/C][C]46108.3048780488[/C][C]30433.6951219512[/C][/ROW]
[ROW][C]93[/C][C]37477[/C][C]46108.3048780488[/C][C]-8631.30487804878[/C][/ROW]
[ROW][C]94[/C][C]53216[/C][C]46108.3048780488[/C][C]7107.69512195122[/C][/ROW]
[ROW][C]95[/C][C]40911[/C][C]30325.0344827586[/C][C]10585.9655172414[/C][/ROW]
[ROW][C]96[/C][C]57021[/C][C]46108.3048780488[/C][C]10912.6951219512[/C][/ROW]
[ROW][C]97[/C][C]73116[/C][C]46108.3048780488[/C][C]27007.6951219512[/C][/ROW]
[ROW][C]98[/C][C]3895[/C][C]1748.5[/C][C]2146.5[/C][/ROW]
[ROW][C]99[/C][C]46609[/C][C]46108.3048780488[/C][C]500.695121951219[/C][/ROW]
[ROW][C]100[/C][C]29351[/C][C]46108.3048780488[/C][C]-16757.3048780488[/C][/ROW]
[ROW][C]101[/C][C]2325[/C][C]13959.8571428571[/C][C]-11634.8571428571[/C][/ROW]
[ROW][C]102[/C][C]31747[/C][C]30325.0344827586[/C][C]1421.96551724138[/C][/ROW]
[ROW][C]103[/C][C]32665[/C][C]30325.0344827586[/C][C]2339.96551724138[/C][/ROW]
[ROW][C]104[/C][C]19249[/C][C]30325.0344827586[/C][C]-11076.0344827586[/C][/ROW]
[ROW][C]105[/C][C]15292[/C][C]30325.0344827586[/C][C]-15033.0344827586[/C][/ROW]
[ROW][C]106[/C][C]5842[/C][C]1748.5[/C][C]4093.5[/C][/ROW]
[ROW][C]107[/C][C]33994[/C][C]46108.3048780488[/C][C]-12114.3048780488[/C][/ROW]
[ROW][C]108[/C][C]13018[/C][C]13959.8571428571[/C][C]-941.857142857143[/C][/ROW]
[ROW][C]109[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]110[/C][C]98177[/C][C]46108.3048780488[/C][C]52068.6951219512[/C][/ROW]
[ROW][C]111[/C][C]37941[/C][C]30325.0344827586[/C][C]7615.96551724138[/C][/ROW]
[ROW][C]112[/C][C]31032[/C][C]46108.3048780488[/C][C]-15076.3048780488[/C][/ROW]
[ROW][C]113[/C][C]32683[/C][C]46108.3048780488[/C][C]-13425.3048780488[/C][/ROW]
[ROW][C]114[/C][C]34545[/C][C]30325.0344827586[/C][C]4219.96551724138[/C][/ROW]
[ROW][C]115[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]116[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]117[/C][C]27525[/C][C]46108.3048780488[/C][C]-18583.3048780488[/C][/ROW]
[ROW][C]118[/C][C]66856[/C][C]46108.3048780488[/C][C]20747.6951219512[/C][/ROW]
[ROW][C]119[/C][C]28549[/C][C]30325.0344827586[/C][C]-1776.03448275862[/C][/ROW]
[ROW][C]120[/C][C]38610[/C][C]46108.3048780488[/C][C]-7498.30487804878[/C][/ROW]
[ROW][C]121[/C][C]2781[/C][C]1748.5[/C][C]1032.5[/C][/ROW]
[ROW][C]122[/C][C]41211[/C][C]46108.3048780488[/C][C]-4897.30487804878[/C][/ROW]
[ROW][C]123[/C][C]22698[/C][C]30325.0344827586[/C][C]-7627.03448275862[/C][/ROW]
[ROW][C]124[/C][C]41194[/C][C]30325.0344827586[/C][C]10868.9655172414[/C][/ROW]
[ROW][C]125[/C][C]32689[/C][C]13959.8571428571[/C][C]18729.1428571429[/C][/ROW]
[ROW][C]126[/C][C]5752[/C][C]1748.5[/C][C]4003.5[/C][/ROW]
[ROW][C]127[/C][C]26757[/C][C]46108.3048780488[/C][C]-19351.3048780488[/C][/ROW]
[ROW][C]128[/C][C]22527[/C][C]30325.0344827586[/C][C]-7798.03448275862[/C][/ROW]
[ROW][C]129[/C][C]44810[/C][C]46108.3048780488[/C][C]-1298.30487804878[/C][/ROW]
[ROW][C]130[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]131[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]132[/C][C]100674[/C][C]46108.3048780488[/C][C]54565.6951219512[/C][/ROW]
[ROW][C]133[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]134[/C][C]57786[/C][C]46108.3048780488[/C][C]11677.6951219512[/C][/ROW]
[ROW][C]135[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]136[/C][C]5444[/C][C]1748.5[/C][C]3695.5[/C][/ROW]
[ROW][C]137[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]138[/C][C]28470[/C][C]30325.0344827586[/C][C]-1855.03448275862[/C][/ROW]
[ROW][C]139[/C][C]61849[/C][C]46108.3048780488[/C][C]15740.6951219512[/C][/ROW]
[ROW][C]140[/C][C]0[/C][C]1748.5[/C][C]-1748.5[/C][/ROW]
[ROW][C]141[/C][C]2179[/C][C]1748.5[/C][C]430.5[/C][/ROW]
[ROW][C]142[/C][C]8019[/C][C]13959.8571428571[/C][C]-5940.85714285714[/C][/ROW]
[ROW][C]143[/C][C]39644[/C][C]46108.3048780488[/C][C]-6464.30487804878[/C][/ROW]
[ROW][C]144[/C][C]23494[/C][C]46108.3048780488[/C][C]-22614.3048780488[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=158800&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158800&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
12046530325.0344827586-9860.03448275862
23362946108.3048780488-12479.3048780488
314231748.5-325.5
42562946108.3048780488-20479.3048780488
55400246108.30487804887893.69512195122
615103683255.62567780.375
73328746108.3048780488-12821.3048780488
83117246108.3048780488-14936.3048780488
92811346108.3048780488-17995.3048780488
105780383255.625-25452.625
114983046108.30487804883721.69512195122
125214346108.30487804886034.69512195122
132105530325.0344827586-9270.03448275862
144700746108.3048780488898.695121951219
152873546108.3048780488-17373.3048780488
165914746108.304878048813038.6951219512
177895046108.304878048832841.6951219512
181349713959.8571428571-462.857142857143
194615446108.304878048845.6951219512193
205324930325.034482758622923.9655172414
211072630325.0344827586-19599.0344827586
228370083255.625444.375
234040030325.034482758610074.9655172414
243379730325.03448275863471.96551724138
253620546108.3048780488-9903.30487804878
263016546108.3048780488-15943.3048780488
275853446108.304878048812425.6951219512
284466383255.625-38592.625
299255683255.6259300.375
304007846108.3048780488-6030.30487804878
313471146108.3048780488-11397.3048780488
323107646108.3048780488-15032.3048780488
337460846108.304878048828499.6951219512
345809230325.034482758627766.9655172414
354200946108.3048780488-4099.30487804878
3601748.5-1748.5
373602246108.3048780488-10086.3048780488
382333330325.0344827586-6992.03448275862
395334946108.30487804887240.69512195122
409259683255.6259340.375
414959846108.30487804883489.69512195122
424409346108.3048780488-2015.30487804878
438420546108.304878048838096.6951219512
446336946108.304878048817260.6951219512
456013246108.304878048814023.6951219512
463740346108.3048780488-8705.30487804878
472446046108.3048780488-21648.3048780488
484645646108.3048780488347.695121951219
496661646108.304878048820507.6951219512
504155446108.3048780488-4554.30487804878
512234630325.0344827586-7979.03448275862
523087446108.3048780488-15234.3048780488
536870183255.625-14554.625
543572846108.3048780488-10380.3048780488
552901046108.3048780488-17098.3048780488
562311046108.3048780488-22998.3048780488
573884446108.3048780488-7264.30487804878
582708430325.0344827586-3241.03448275862
593513946108.3048780488-10969.3048780488
605747630325.034482758627150.9655172414
613327746108.3048780488-12831.3048780488
623114146108.3048780488-14967.3048780488
636128146108.304878048815172.6951219512
642582046108.3048780488-20288.3048780488
652328446108.3048780488-22824.3048780488
663537846108.3048780488-10730.3048780488
677499083255.625-8265.625
682965346108.3048780488-16455.3048780488
696462246108.304878048818513.6951219512
7041571748.52408.5
712924546108.3048780488-16863.3048780488
725000846108.30487804883899.69512195122
735233846108.30487804886229.69512195122
741331030325.0344827586-17015.0344827586
759290146108.304878048846792.6951219512
761095613959.8571428571-3003.85714285714
773424146108.3048780488-11867.3048780488
787504346108.304878048828934.6951219512
792115230325.0344827586-9173.03448275862
804224930325.034482758611923.9655172414
814200546108.3048780488-4103.30487804878
824115246108.3048780488-4956.30487804878
831439930325.0344827586-15926.0344827586
842826346108.3048780488-17845.3048780488
851721513959.85714285713255.14285714286
864814046108.30487804882031.69512195122
876289746108.304878048816788.6951219512
882288330325.0344827586-7442.03448275862
894162230325.034482758611296.9655172414
904071546108.3048780488-5393.30487804878
916589746108.304878048819788.6951219512
927654246108.304878048830433.6951219512
933747746108.3048780488-8631.30487804878
945321646108.30487804887107.69512195122
954091130325.034482758610585.9655172414
965702146108.304878048810912.6951219512
977311646108.304878048827007.6951219512
9838951748.52146.5
994660946108.3048780488500.695121951219
1002935146108.3048780488-16757.3048780488
101232513959.8571428571-11634.8571428571
1023174730325.03448275861421.96551724138
1033266530325.03448275862339.96551724138
1041924930325.0344827586-11076.0344827586
1051529230325.0344827586-15033.0344827586
10658421748.54093.5
1073399446108.3048780488-12114.3048780488
1081301813959.8571428571-941.857142857143
10901748.5-1748.5
1109817746108.304878048852068.6951219512
1113794130325.03448275867615.96551724138
1123103246108.3048780488-15076.3048780488
1133268346108.3048780488-13425.3048780488
1143454530325.03448275864219.96551724138
11501748.5-1748.5
11601748.5-1748.5
1172752546108.3048780488-18583.3048780488
1186685646108.304878048820747.6951219512
1192854930325.0344827586-1776.03448275862
1203861046108.3048780488-7498.30487804878
12127811748.51032.5
1224121146108.3048780488-4897.30487804878
1232269830325.0344827586-7627.03448275862
1244119430325.034482758610868.9655172414
1253268913959.857142857118729.1428571429
12657521748.54003.5
1272675746108.3048780488-19351.3048780488
1282252730325.0344827586-7798.03448275862
1294481046108.3048780488-1298.30487804878
13001748.5-1748.5
13101748.5-1748.5
13210067446108.304878048854565.6951219512
13301748.5-1748.5
1345778646108.304878048811677.6951219512
13501748.5-1748.5
13654441748.53695.5
13701748.5-1748.5
1382847030325.0344827586-1855.03448275862
1396184946108.304878048815740.6951219512
14001748.5-1748.5
14121791748.5430.5
142801913959.8571428571-5940.85714285714
1433964446108.3048780488-6464.30487804878
1442349446108.3048780488-22614.3048780488



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