Free Statistics

of Irreproducible Research!

Author's title

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

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact97
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Kendall tau Correlation Matrix] [pearson correlati...] [2011-12-18 15:22:22] [9631d8669dd1906475401d4d7f07aac5]
- RMPD  [Multiple Regression] [Multiple Regression] [2011-12-21 13:40:30] [2c6fcdc40ef3b1a27716d75d6f478b32]
- RMP     [Recursive Partitioning (Regression Trees)] [Recursive Partiti...] [2011-12-21 14:30:18] [2c6fcdc40ef3b1a27716d75d6f478b32]
- RMP         [Recursive Partitioning (Regression Trees)] [] [2011-12-22 10:31:01] [8a4496bd93dae12a8bdfa51e6ea7daab] [Current]
Feedback Forum

Post a new message
Dataseries X:
158258	0	48	18	20465	23975
186930	1	53	20	33629	85634
7215	0	0	0	1423	1929
129098	0	51	27	25629	36294
230632	0	76	31	54002	72255
508313	1	128	36	151036	189748
180745	1	62	23	33287	61834
185559	0	83	30	31172	68167
154581	0	55	30	28113	38462
290658	1	67	26	57803	101219
121844	2	50	24	49830	43270
184039	0	77	30	52143	76183
100324	0	46	22	21055	31476
209427	4	79	25	47007	62157
168265	4	56	18	28735	46261
154593	3	54	22	59147	50063
142018	0	81	33	78950	64483
78604	5	6	15	13497	2341
167047	0	74	34	46154	48149
27997	0	13	18	53249	12743
73019	0	22	15	10726	18743
241082	0	99	30	83700	97057
195820	0	38	25	40400	17675
141899	1	59	34	33797	33106
145433	1	50	21	36205	53311
183744	0	50	21	30165	42754
202232	0	61	25	58534	59056
190230	0	81	31	44663	101621
354924	0	60	31	92556	118120
192399	0	52	20	40078	79572
182286	0	61	28	34711	42744
181590	2	60	22	31076	65931
133801	4	53	17	74608	38575
233686	0	76	25	58092	28795
219428	1	63	24	42009	94440
0	0	0	0	0	0
223044	0	54	28	36022	38229
100129	3	44	14	23333	31972
136733	9	36	35	53349	40071
249965	0	83	34	92596	132480
242379	2	105	22	49598	62797
145794	0	37	34	44093	40429
96404	2	25	23	84205	45545
195891	1	64	24	63369	57568
117156	2	55	26	60132	39019
157787	2	41	22	37403	53866
81293	1	23	35	24460	38345
224049	0	67	24	46456	50210
223789	1	54	31	66616	80947
160344	8	68	26	41554	43461
48188	0	12	22	22346	14812
152206	0	86	21	30874	37819
294283	0	74	27	68701	102738
235223	0	56	30	35728	54509
195583	1	67	33	29010	62956
145942	8	40	11	23110	55411
208834	0	53	26	38844	50611
93764	1	26	26	27084	26692
151985	0	67	23	35139	60056
190545	10	36	38	57476	25155
148922	6	50	31	33277	42840
132856	0	48	20	31141	39358
126107	11	46	19	61281	47241
112718	3	53	26	25820	49611
160930	0	27	26	23284	41833
99184	0	38	33	35378	48930
182022	8	69	36	74990	110600
138708	2	93	25	29653	52235
114408	0	59	24	64622	53986
31970	0	5	21	4157	4105
225558	3	53	19	29245	59331
137011	1	40	12	50008	47796
113612	2	72	30	52338	38302
108641	1	51	21	13310	14063
162203	0	81	34	92901	54414
100098	2	27	32	10956	9903
174768	1	94	28	34241	53987
158459	0	71	28	75043	88937
80934	0	20	21	21152	21928
84971	0	34	31	42249	29487
80545	0	54	26	42005	35334
287191	0	49	29	41152	57596
62974	1	26	23	14399	29750
130982	0	47	25	28263	41029
75555	0	35	22	17215	12416
162154	0	32	26	48140	51158
226638	0	55	33	62897	79935
115019	0	58	24	22883	26552
105038	7	44	24	41622	25807
155537	0	45	21	40715	50620
153133	5	49	28	65897	61467
165577	1	72	27	76542	65292
151517	0	39	25	37477	55516
133686	0	28	15	53216	42006
58128	0	24	13	40911	26273
245196	0	52	36	57021	90248
195576	0	96	24	73116	61476
19349	0	13	1	3895	9604
225371	3	38	24	46609	45108
152796	0	41	31	29351	47232
59117	0	24	4	2325	3439
91762	0	54	21	31747	30553
127987	0	59	23	32665	24751
113552	1	28	23	19249	34458
85338	1	36	12	15292	24649
27676	0	2	16	5842	2342
147984	0	83	29	33994	52739
122417	0	29	26	13018	6245
0	0	0	0	0	0
91529	0	46	25	98177	35381
107205	0	25	21	37941	19595
144664	0	51	23	31032	50848
136540	0	59	21	32683	39443
76656	0	36	21	34545	27023
3616	0	0	0	0	0
0	0	0	0	0	0
183065	0	40	23	27525	61022
144636	0	68	33	66856	63528
159104	2	28	30	28549	34835
113273	0	36	23	38610	37172
43410	0	7	1	2781	13
175774	1	70	29	41211	62548
95401	0	30	18	22698	31334
118893	8	59	32	41194	20839
60493	3	3	12	32689	5084
19764	1	10	2	5752	9927
164062	3	46	21	26757	53229
132696	0	34	28	22527	29877
155367	0	54	29	44810	37310
11796	0	1	2	0	0
10674	0	0	0	0	0
142261	0	39	18	100674	50067
6836	0	0	1	0	0
154206	6	48	21	57786	47708
5118	0	5	0	0	0
40248	1	8	4	5444	6012
0	0	0	0	0	0
122641	0	38	25	28470	27749
88837	0	21	26	61849	47555
7131	1	0	0	0	0
9056	0	0	4	2179	1336
76611	1	15	17	8019	11017
132697	0	50	21	39644	55184
100681	1	17	22	23494	43485




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time5 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net

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

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

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

As an alternative you can also use a QR Code:  

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

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time5 seconds
R Server'Gwilym Jenkins' @ jenkins.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=159272&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=159272&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=159272&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=159272&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=159272&T=2

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