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 09:46:40 -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/t13244788223aaburhzy5epapi.htm/, Retrieved Wed, 08 May 2024 03:21:21 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=158773, Retrieved Wed, 08 May 2024 03:21:21 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact66
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Kendall tau Correlation Matrix] [] [2011-12-14 11:18:16] [518aa67394b1ff91cc885d6a199d84d8]
- RMPD    [Recursive Partitioning (Regression Trees)] [] [2011-12-21 14:46:40] [bd7a66e2f212a6bc9afe853e3942ee45] [Current]
Feedback Forum

Post a new message
Dataseries X:
20465	159261	91	19	67	23975
33629	189672	59	20	56	85634
1423	7215	18	0	0	1929
25629	129098	95	27	63	36294
54002	230632	136	31	116	72255
151036	515038	263	36	138	189748
33287	180745	56	23	71	61834
31172	185559	59	30	107	68167
28113	154581	44	30	50	38462
57803	298001	96	26	79	101219
49830	121844	75	24	58	43270
52143	184039	69	30	91	76183
21055	100324	98	22	41	31476
47007	220269	119	28	100	62157
28735	170952	61	18	61	46261
59147	154647	88	22	74	50063
78950	142018	57	33	131	64483
13497	79030	61	15	45	2341
46154	167047	87	34	110	48149
53249	27997	24	18	41	12743
10726	73019	59	15	37	18743
83700	241082	100	30	84	97057
40400	195820	72	25	67	17675
33797	142001	54	34	69	33106
36205	145433	86	21	58	53311
30165	183744	32	21	60	42754
58534	202357	163	25	88	59056
44663	199532	93	31	75	101621
92556	354924	118	31	98	118120
40078	192399	44	20	67	79572
34711	182286	44	28	84	42744
31076	181590	45	22	62	65931
74608	133801	105	17	35	38575
58092	233686	123	25	74	28795
42009	219428	53	24	89	94440
0	0	1	0	0	0
36022	223044	63	28	79	38229
23333	100129	51	14	39	31972
53349	145864	49	35	101	40071
92596	249965	64	34	135	132480
49598	242379	71	22	76	62797
44093	145794	59	34	118	40429
84205	103623	33	23	76	45545
63369	195891	78	24	65	57568
60132	117156	50	26	97	39019
37403	157787	95	22	67	53866
24460	81293	32	35	63	38345
46456	237435	101	24	96	50210
66616	233155	89	31	112	80947
41554	160344	59	26	75	43461
22346	48188	28	22	39	14812
30874	161922	69	21	63	37819
68701	307432	74	27	93	102738
35728	235223	79	30	76	54509
29010	195583	59	33	117	62956
23110	146061	56	11	30	55411
38844	208834	67	26	65	50611
27084	93764	24	26	78	26692
35139	151985	66	23	87	60056
57476	193222	96	38	85	25155
33277	148922	60	31	115	42840
31141	132856	80	20	62	39358
61281	129561	61	22	60	47241
25820	112718	37	26	67	49611
23284	160930	35	26	90	41833
35378	99184	41	33	100	48930
74990	192535	70	36	135	110600
29653	138708	65	25	71	52235
64622	114408	38	24	75	53986
4157	31970	15	21	42	4105
29245	225558	112	19	42	59331
50008	139220	72	12	8	47796
52338	113612	68	30	86	38302
13310	108641	71	21	41	14063
92901	162203	67	34	118	54414
10956	100098	44	32	91	9903
34241	174768	60	28	102	53987
75043	158459	97	28	89	88937
21152	80934	30	21	46	21928
42249	84971	71	31	60	29487
42005	80545	68	26	69	35334
41152	287191	64	29	95	57596
14399	62974	28	23	17	29750
28263	134091	40	25	61	41029
17215	75555	46	22	55	12416
48140	162154	55	26	55	51158
62897	227638	229	33	124	79935
22883	115367	112	24	73	26552
41622	108749	62	24	73	25807
40715	155537	52	21	67	50620
65897	153133	41	28	66	61467
76542	165618	78	27	75	65292
37477	151517	57	25	83	55516
53216	133686	58	15	55	42006
40911	61342	40	13	27	26273
57021	245196	117	36	115	90248
73116	195576	70	24	76	61476
3895	19349	12	1	0	9604
46609	225371	105	24	83	45108
29351	153213	78	31	90	47232
2325	59117	29	4	4	3439
31747	91762	24	21	60	30553
32665	136769	54	23	63	24751
19249	114798	61	23	52	34458
15292	85338	40	12	24	24649
5842	27676	22	16	17	2342
33994	153535	48	29	105	52739
13018	122417	37	26	20	6245
0	0	0	0	0	0
98177	91529	32	25	51	35381
37941	107205	67	21	76	19595
31032	144664	45	23	59	50848
32683	146445	63	21	70	39443
34545	76656	60	21	38	27023
0	3616	5	0	0	0
0	0	0	0	0	0
27525	183088	44	23	81	61022
66856	144677	84	33	78	63528
28549	159104	98	30	73	34835
38610	113273	38	23	89	37172
2781	43410	19	1	3	13
41211	175774	73	29	87	62548
22698	95401	42	18	51	31334
41194	134837	55	33	73	20839
32689	60493	40	12	32	5084
5752	19764	12	2	4	9927
26757	164062	56	21	70	53229
22527	132696	33	28	102	29877
44810	155367	54	29	91	37310
0	11796	9	2	1	0
0	10674	9	0	0	0
100674	142261	57	18	39	50067
0	6836	3	1	0	0
57786	162563	63	21	45	47708
0	5118	3	0	0	0
5444	40248	16	4	7	6012
0	0	0	0	0	0
28470	122641	47	25	75	27749
61849	88837	38	26	52	47555
0	7131	4	0	0	0
2179	9056	14	4	1	1336
8019	76611	24	17	49	11017
39644	132697	51	21	69	55184
23494	100681	19	22	56	43485




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time4 seconds
R Server'Gertrude Mary Cox' @ cox.wessa.net
R Framework error message
The field 'Names of X columns' contains a hard return which cannot be interpreted.
Please, resubmit your request without hard returns in the 'Names of X columns'.

\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 & 'Gertrude Mary Cox' @ cox.wessa.net \tabularnewline
R Framework error message & 
The field 'Names of X columns' contains a hard return which cannot be interpreted.
Please, resubmit your request without hard returns in the 'Names of X columns'.
\tabularnewline \hline \end{tabular} %Source: https://freestatistics.org/blog/index.php?pk=158773&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]'Gertrude Mary Cox' @ cox.wessa.net[/C][/ROW]
[ROW][C]R Framework error message[/C][C]
The field 'Names of X columns' contains a hard return which cannot be interpreted.
Please, resubmit your request without hard returns in the 'Names of X columns'.
[/C][/ROW] [/TABLE] Source: https://freestatistics.org/blog/index.php?pk=158773&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158773&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'Gertrude Mary Cox' @ cox.wessa.net
R Framework error message
The field 'Names of X columns' contains a hard return which cannot be interpreted.
Please, resubmit your request without hard returns in the 'Names of X columns'.







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=158773&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=158773&T=1

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

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=158773&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 = 1 ; par2 = none ; par3 = 3 ; par4 = no ;
Parameters (R input):
par1 = 1 ; 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')
}