Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_arimaforecasting.wasp
Title produced by softwareARIMA Forecasting
Date of computationWed, 31 Jan 2018 17:13:17 +0100
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2018/Jan/31/t1517415243p3hgdnpr71h62xn.htm/, Retrieved Mon, 06 May 2024 15:43:16 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=313052, Retrieved Mon, 06 May 2024 15:43:16 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact67
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [ARIMA Forecasting] [] [2018-01-31 16:13:17] [767bae2faba658f23149559b7968621e] [Current]
Feedback Forum

Post a new message
Dataseries X:
62.4
67.4
76.1
67.4
74.5
72.6
60.5
66.1
76.5
76.8
77
71
74.8
73.7
80.5
71.8
76.9
79.9
65.9
69.5
75.1
79.6
75.2
68
72.8
71.5
78.5
76.8
75.3
76.7
69.7
67.8
77.5
82.5
75.3
70.9
76
73.7
79.7
77.8
73.3
78.3
71.9
67
82
83.7
74.8
80
74.3
76.8
89
81.9
76.8
88.9
75.8
75.5
89.1
88
85.9
89.3
82.9
81.2
90.5
86.4
81.8
91.3
73.4
76.6
91
87
89.7
90.7
86.5
86.6
98.8
84.4
91.4
95.7
78.5
81.7
94.3
98.5
95.4
91.7
92.8
90.5
102.2
91.8
95
102
88.9
89.6
97.9
108.6
100.8
95.1
101
100.9
102.5
105.4
98.4
105.3
96.5
88.1
107.9
107
92.5
95.7
85.2
85.5
94.7
86.2
88.8
93.4
83.4
82.9
96.7
96.2
92.8
92.8
90
95.4
108.3
96.3
95
109
92
92.3
107
105.5
105.4
103.9
99.2
102.2
121.5
102.3
110
105.9
91.9
100
111.7
104.9
103.3
101.8
100.8
104.2
116.5
97.9
100.7
107
96.3
96
104.5
107.4
102.4
94.9
98.8
96.8
108.2
103.8
102.3
107.2
102
92.6
105.2
113
105.6
101.6
101.7
102.7
109
105.5
103.3
108.6
98.2
90
112.4
111.9
102.1
102.4
101.7
98.7
114
105.1
98.3
110
96.5
92.2
112
111.4
107.5
103.4
103.5
107.4
117.6
110.2
104.3
115.9
98.9
101.9
113.5
109.5
110
114.2
106.9
109.2
124.2
104.7
111.9
119
102.9
106.3




Summary of computational transaction
Raw Input view raw input (R code)
Raw Outputview raw output of R engine
Computing time2 seconds
R ServerBig Analytics Cloud Computing Center

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input view raw input (R code)  \tabularnewline
Raw Outputview raw output of R engine  \tabularnewline
Computing time2 seconds \tabularnewline
R ServerBig Analytics Cloud Computing Center \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=313052&T=0

[TABLE]
[ROW]
Summary of computational transaction[/C][/ROW] [ROW]Raw Input[/C] view raw input (R code) [/C][/ROW] [ROW]Raw Output[/C]view raw output of R engine [/C][/ROW] [ROW]Computing time[/C]2 seconds[/C][/ROW] [ROW]R Server[/C]Big Analytics Cloud Computing Center[/C][/ROW] [/TABLE] Source: https://freestatistics.org/blog/index.php?pk=313052&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=313052&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 Input view raw input (R code)
Raw Outputview raw output of R engine
Computing time2 seconds
R ServerBig Analytics Cloud Computing Center







Univariate ARIMA Extrapolation Forecast
timeY[t]F[t]95% LB95% UBp-value(H0: Y[t] = F[t])P(F[t]>Y[t-1])P(F[t]>Y[t-s])P(F[t]>Y[188])
17690-------
177112.4-------
178111.9-------
179102.1-------
180102.4-------
181101.7-------
18298.7-------
183114-------
184105.1-------
18598.3-------
186110-------
18796.5-------
18892.2-------
189112109.7378102.6092117.20610.276410.24241
190111.4110.6282103.3541118.25320.42140.36220.37191
191107.5103.994196.755111.60410.18330.02820.68720.9988
192103.4103.480995.0129112.46350.4930.19030.59320.9931
193103.5101.940293.3482111.0710.36890.3770.52060.9817
194107.4101.937692.9714111.49210.13120.37430.74670.9771
195117.6113.8182103.4509124.89180.25160.8720.48720.9999
196110.2104.627994.5779115.40260.15540.00910.46580.9881
197104.3104.632194.2052115.84120.47680.16510.86590.9851
198115.9111.138699.8023123.34690.22230.86390.57250.9988
19998.997.545186.9254109.04140.40879e-040.57070.8189
200101.996.816285.9267108.63690.19960.36490.7780.778
201113.5111.577399.0513125.17220.39080.91850.47570.9974
202109.5112.963199.9963127.06340.31510.47030.5860.9981
203110107.669994.7946121.72190.37260.39930.50950.9845
204114.2105.696392.6238120.00850.12210.27780.62340.9677
205106.9104.514391.2409119.08380.37410.09630.55430.9512
206109.2105.002691.3707119.99810.29160.40210.3770.9529
207124.2116.4575101.4391132.96710.1790.80550.44610.998
208104.7107.357192.8924123.32910.37220.01940.36360.9686
209111.9107.519192.7416123.87090.29980.63230.65020.9668
210119113.872398.1708131.25240.28150.5880.40960.9927
211102.9100.165685.5754116.41380.37080.01150.56070.8317
212106.399.462784.6837115.95890.20830.34150.38610.8059

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast \tabularnewline
time & Y[t] & F[t] & 95% LB & 95% UB & p-value(H0: Y[t] = F[t]) & P(F[t]>Y[t-1]) & P(F[t]>Y[t-s]) & P(F[t]>Y[188]) \tabularnewline
176 & 90 & - & - & - & - & - & - & - \tabularnewline
177 & 112.4 & - & - & - & - & - & - & - \tabularnewline
178 & 111.9 & - & - & - & - & - & - & - \tabularnewline
179 & 102.1 & - & - & - & - & - & - & - \tabularnewline
180 & 102.4 & - & - & - & - & - & - & - \tabularnewline
181 & 101.7 & - & - & - & - & - & - & - \tabularnewline
182 & 98.7 & - & - & - & - & - & - & - \tabularnewline
183 & 114 & - & - & - & - & - & - & - \tabularnewline
184 & 105.1 & - & - & - & - & - & - & - \tabularnewline
185 & 98.3 & - & - & - & - & - & - & - \tabularnewline
186 & 110 & - & - & - & - & - & - & - \tabularnewline
187 & 96.5 & - & - & - & - & - & - & - \tabularnewline
188 & 92.2 & - & - & - & - & - & - & - \tabularnewline
189 & 112 & 109.7378 & 102.6092 & 117.2061 & 0.2764 & 1 & 0.2424 & 1 \tabularnewline
190 & 111.4 & 110.6282 & 103.3541 & 118.2532 & 0.4214 & 0.3622 & 0.3719 & 1 \tabularnewline
191 & 107.5 & 103.9941 & 96.755 & 111.6041 & 0.1833 & 0.0282 & 0.6872 & 0.9988 \tabularnewline
192 & 103.4 & 103.4809 & 95.0129 & 112.4635 & 0.493 & 0.1903 & 0.5932 & 0.9931 \tabularnewline
193 & 103.5 & 101.9402 & 93.3482 & 111.071 & 0.3689 & 0.377 & 0.5206 & 0.9817 \tabularnewline
194 & 107.4 & 101.9376 & 92.9714 & 111.4921 & 0.1312 & 0.3743 & 0.7467 & 0.9771 \tabularnewline
195 & 117.6 & 113.8182 & 103.4509 & 124.8918 & 0.2516 & 0.872 & 0.4872 & 0.9999 \tabularnewline
196 & 110.2 & 104.6279 & 94.5779 & 115.4026 & 0.1554 & 0.0091 & 0.4658 & 0.9881 \tabularnewline
197 & 104.3 & 104.6321 & 94.2052 & 115.8412 & 0.4768 & 0.1651 & 0.8659 & 0.9851 \tabularnewline
198 & 115.9 & 111.1386 & 99.8023 & 123.3469 & 0.2223 & 0.8639 & 0.5725 & 0.9988 \tabularnewline
199 & 98.9 & 97.5451 & 86.9254 & 109.0414 & 0.4087 & 9e-04 & 0.5707 & 0.8189 \tabularnewline
200 & 101.9 & 96.8162 & 85.9267 & 108.6369 & 0.1996 & 0.3649 & 0.778 & 0.778 \tabularnewline
201 & 113.5 & 111.5773 & 99.0513 & 125.1722 & 0.3908 & 0.9185 & 0.4757 & 0.9974 \tabularnewline
202 & 109.5 & 112.9631 & 99.9963 & 127.0634 & 0.3151 & 0.4703 & 0.586 & 0.9981 \tabularnewline
203 & 110 & 107.6699 & 94.7946 & 121.7219 & 0.3726 & 0.3993 & 0.5095 & 0.9845 \tabularnewline
204 & 114.2 & 105.6963 & 92.6238 & 120.0085 & 0.1221 & 0.2778 & 0.6234 & 0.9677 \tabularnewline
205 & 106.9 & 104.5143 & 91.2409 & 119.0838 & 0.3741 & 0.0963 & 0.5543 & 0.9512 \tabularnewline
206 & 109.2 & 105.0026 & 91.3707 & 119.9981 & 0.2916 & 0.4021 & 0.377 & 0.9529 \tabularnewline
207 & 124.2 & 116.4575 & 101.4391 & 132.9671 & 0.179 & 0.8055 & 0.4461 & 0.998 \tabularnewline
208 & 104.7 & 107.3571 & 92.8924 & 123.3291 & 0.3722 & 0.0194 & 0.3636 & 0.9686 \tabularnewline
209 & 111.9 & 107.5191 & 92.7416 & 123.8709 & 0.2998 & 0.6323 & 0.6502 & 0.9668 \tabularnewline
210 & 119 & 113.8723 & 98.1708 & 131.2524 & 0.2815 & 0.588 & 0.4096 & 0.9927 \tabularnewline
211 & 102.9 & 100.1656 & 85.5754 & 116.4138 & 0.3708 & 0.0115 & 0.5607 & 0.8317 \tabularnewline
212 & 106.3 & 99.4627 & 84.6837 & 115.9589 & 0.2083 & 0.3415 & 0.3861 & 0.8059 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=313052&T=1

[TABLE]
[ROW][C]Univariate ARIMA Extrapolation Forecast[/C][/ROW]
[ROW][C]time[/C][C]Y[t][/C][C]F[t][/C][C]95% LB[/C][C]95% UB[/C][C]p-value(H0: Y[t] = F[t])[/C][C]P(F[t]>Y[t-1])[/C][C]P(F[t]>Y[t-s])[/C][C]P(F[t]>Y[188])[/C][/ROW]
[ROW][C]176[/C][C]90[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]177[/C][C]112.4[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]178[/C][C]111.9[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]179[/C][C]102.1[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]180[/C][C]102.4[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]181[/C][C]101.7[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]182[/C][C]98.7[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]183[/C][C]114[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]184[/C][C]105.1[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]185[/C][C]98.3[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]186[/C][C]110[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]187[/C][C]96.5[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]188[/C][C]92.2[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]189[/C][C]112[/C][C]109.7378[/C][C]102.6092[/C][C]117.2061[/C][C]0.2764[/C][C]1[/C][C]0.2424[/C][C]1[/C][/ROW]
[ROW][C]190[/C][C]111.4[/C][C]110.6282[/C][C]103.3541[/C][C]118.2532[/C][C]0.4214[/C][C]0.3622[/C][C]0.3719[/C][C]1[/C][/ROW]
[ROW][C]191[/C][C]107.5[/C][C]103.9941[/C][C]96.755[/C][C]111.6041[/C][C]0.1833[/C][C]0.0282[/C][C]0.6872[/C][C]0.9988[/C][/ROW]
[ROW][C]192[/C][C]103.4[/C][C]103.4809[/C][C]95.0129[/C][C]112.4635[/C][C]0.493[/C][C]0.1903[/C][C]0.5932[/C][C]0.9931[/C][/ROW]
[ROW][C]193[/C][C]103.5[/C][C]101.9402[/C][C]93.3482[/C][C]111.071[/C][C]0.3689[/C][C]0.377[/C][C]0.5206[/C][C]0.9817[/C][/ROW]
[ROW][C]194[/C][C]107.4[/C][C]101.9376[/C][C]92.9714[/C][C]111.4921[/C][C]0.1312[/C][C]0.3743[/C][C]0.7467[/C][C]0.9771[/C][/ROW]
[ROW][C]195[/C][C]117.6[/C][C]113.8182[/C][C]103.4509[/C][C]124.8918[/C][C]0.2516[/C][C]0.872[/C][C]0.4872[/C][C]0.9999[/C][/ROW]
[ROW][C]196[/C][C]110.2[/C][C]104.6279[/C][C]94.5779[/C][C]115.4026[/C][C]0.1554[/C][C]0.0091[/C][C]0.4658[/C][C]0.9881[/C][/ROW]
[ROW][C]197[/C][C]104.3[/C][C]104.6321[/C][C]94.2052[/C][C]115.8412[/C][C]0.4768[/C][C]0.1651[/C][C]0.8659[/C][C]0.9851[/C][/ROW]
[ROW][C]198[/C][C]115.9[/C][C]111.1386[/C][C]99.8023[/C][C]123.3469[/C][C]0.2223[/C][C]0.8639[/C][C]0.5725[/C][C]0.9988[/C][/ROW]
[ROW][C]199[/C][C]98.9[/C][C]97.5451[/C][C]86.9254[/C][C]109.0414[/C][C]0.4087[/C][C]9e-04[/C][C]0.5707[/C][C]0.8189[/C][/ROW]
[ROW][C]200[/C][C]101.9[/C][C]96.8162[/C][C]85.9267[/C][C]108.6369[/C][C]0.1996[/C][C]0.3649[/C][C]0.778[/C][C]0.778[/C][/ROW]
[ROW][C]201[/C][C]113.5[/C][C]111.5773[/C][C]99.0513[/C][C]125.1722[/C][C]0.3908[/C][C]0.9185[/C][C]0.4757[/C][C]0.9974[/C][/ROW]
[ROW][C]202[/C][C]109.5[/C][C]112.9631[/C][C]99.9963[/C][C]127.0634[/C][C]0.3151[/C][C]0.4703[/C][C]0.586[/C][C]0.9981[/C][/ROW]
[ROW][C]203[/C][C]110[/C][C]107.6699[/C][C]94.7946[/C][C]121.7219[/C][C]0.3726[/C][C]0.3993[/C][C]0.5095[/C][C]0.9845[/C][/ROW]
[ROW][C]204[/C][C]114.2[/C][C]105.6963[/C][C]92.6238[/C][C]120.0085[/C][C]0.1221[/C][C]0.2778[/C][C]0.6234[/C][C]0.9677[/C][/ROW]
[ROW][C]205[/C][C]106.9[/C][C]104.5143[/C][C]91.2409[/C][C]119.0838[/C][C]0.3741[/C][C]0.0963[/C][C]0.5543[/C][C]0.9512[/C][/ROW]
[ROW][C]206[/C][C]109.2[/C][C]105.0026[/C][C]91.3707[/C][C]119.9981[/C][C]0.2916[/C][C]0.4021[/C][C]0.377[/C][C]0.9529[/C][/ROW]
[ROW][C]207[/C][C]124.2[/C][C]116.4575[/C][C]101.4391[/C][C]132.9671[/C][C]0.179[/C][C]0.8055[/C][C]0.4461[/C][C]0.998[/C][/ROW]
[ROW][C]208[/C][C]104.7[/C][C]107.3571[/C][C]92.8924[/C][C]123.3291[/C][C]0.3722[/C][C]0.0194[/C][C]0.3636[/C][C]0.9686[/C][/ROW]
[ROW][C]209[/C][C]111.9[/C][C]107.5191[/C][C]92.7416[/C][C]123.8709[/C][C]0.2998[/C][C]0.6323[/C][C]0.6502[/C][C]0.9668[/C][/ROW]
[ROW][C]210[/C][C]119[/C][C]113.8723[/C][C]98.1708[/C][C]131.2524[/C][C]0.2815[/C][C]0.588[/C][C]0.4096[/C][C]0.9927[/C][/ROW]
[ROW][C]211[/C][C]102.9[/C][C]100.1656[/C][C]85.5754[/C][C]116.4138[/C][C]0.3708[/C][C]0.0115[/C][C]0.5607[/C][C]0.8317[/C][/ROW]
[ROW][C]212[/C][C]106.3[/C][C]99.4627[/C][C]84.6837[/C][C]115.9589[/C][C]0.2083[/C][C]0.3415[/C][C]0.3861[/C][C]0.8059[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=313052&T=1

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

As an alternative you can also use a QR Code:  

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

Univariate ARIMA Extrapolation Forecast
timeY[t]F[t]95% LB95% UBp-value(H0: Y[t] = F[t])P(F[t]>Y[t-1])P(F[t]>Y[t-s])P(F[t]>Y[188])
17690-------
177112.4-------
178111.9-------
179102.1-------
180102.4-------
181101.7-------
18298.7-------
183114-------
184105.1-------
18598.3-------
186110-------
18796.5-------
18892.2-------
189112109.7378102.6092117.20610.276410.24241
190111.4110.6282103.3541118.25320.42140.36220.37191
191107.5103.994196.755111.60410.18330.02820.68720.9988
192103.4103.480995.0129112.46350.4930.19030.59320.9931
193103.5101.940293.3482111.0710.36890.3770.52060.9817
194107.4101.937692.9714111.49210.13120.37430.74670.9771
195117.6113.8182103.4509124.89180.25160.8720.48720.9999
196110.2104.627994.5779115.40260.15540.00910.46580.9881
197104.3104.632194.2052115.84120.47680.16510.86590.9851
198115.9111.138699.8023123.34690.22230.86390.57250.9988
19998.997.545186.9254109.04140.40879e-040.57070.8189
200101.996.816285.9267108.63690.19960.36490.7780.778
201113.5111.577399.0513125.17220.39080.91850.47570.9974
202109.5112.963199.9963127.06340.31510.47030.5860.9981
203110107.669994.7946121.72190.37260.39930.50950.9845
204114.2105.696392.6238120.00850.12210.27780.62340.9677
205106.9104.514391.2409119.08380.37410.09630.55430.9512
206109.2105.002691.3707119.99810.29160.40210.3770.9529
207124.2116.4575101.4391132.96710.1790.80550.44610.998
208104.7107.357192.8924123.32910.37220.01940.36360.9686
209111.9107.519192.7416123.87090.29980.63230.65020.9668
210119113.872398.1708131.25240.28150.5880.40960.9927
211102.9100.165685.5754116.41380.37080.01150.56070.8317
212106.399.462784.6837115.95890.20830.34150.38610.8059







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPEsMAPESq.EMSERMSEScaledEMASE
1890.03470.02020.02020.02045.1174000.31360.3136
1900.03520.00690.01360.01370.59572.85661.69010.1070.2103
1910.03730.03260.01990.020212.29146.00152.44980.48610.3022
1920.0443-8e-040.01510.01530.00654.50282.122-0.01120.2295
1930.04570.01510.01510.01532.43314.08882.02210.21630.2268
1940.04780.05090.02110.021429.83838.38042.89490.75730.3152
1950.04960.03220.02270.02314.30189.22633.03750.52430.3451
1960.05250.05060.02610.026731.048511.95413.45750.77250.3985
1970.0547-0.00320.02360.0240.110310.63813.2616-0.0460.3594
1980.0560.04110.02530.025822.670911.84143.44110.66010.3894
1990.06010.01370.02430.02471.835710.93183.30630.18780.3711
2000.06230.04990.02640.026925.844512.17453.48920.70480.3989
2010.06220.01690.02570.02623.696811.52243.39450.26660.3887
2020.0637-0.03160.02610.026511.992911.5563.3994-0.48010.3953
2030.06660.02120.02580.02625.429611.14763.33880.3230.3905
2040.06910.07450.02880.029472.312914.97043.86921.17890.4397
2050.07110.02230.02840.0295.691314.42463.7980.33070.4333
2060.07290.03840.0290.029617.617914.6023.82130.58190.4416
2070.07230.06230.03080.031459.946816.98854.12171.07340.4748
2080.0759-0.02540.03050.03117.060116.49214.061-0.36840.4695
2090.07760.03920.03090.031519.192216.62074.07680.60740.4761
2100.07790.04310.03150.032126.293717.06044.13040.71090.4867
2110.08280.02660.03120.03187.47716.64374.07970.37910.4821
2120.08460.06430.03260.033346.748417.89814.23060.94790.5015

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & sMAPE & Sq.E & MSE & RMSE & ScaledE & MASE \tabularnewline
189 & 0.0347 & 0.0202 & 0.0202 & 0.0204 & 5.1174 & 0 & 0 & 0.3136 & 0.3136 \tabularnewline
190 & 0.0352 & 0.0069 & 0.0136 & 0.0137 & 0.5957 & 2.8566 & 1.6901 & 0.107 & 0.2103 \tabularnewline
191 & 0.0373 & 0.0326 & 0.0199 & 0.0202 & 12.2914 & 6.0015 & 2.4498 & 0.4861 & 0.3022 \tabularnewline
192 & 0.0443 & -8e-04 & 0.0151 & 0.0153 & 0.0065 & 4.5028 & 2.122 & -0.0112 & 0.2295 \tabularnewline
193 & 0.0457 & 0.0151 & 0.0151 & 0.0153 & 2.4331 & 4.0888 & 2.0221 & 0.2163 & 0.2268 \tabularnewline
194 & 0.0478 & 0.0509 & 0.0211 & 0.0214 & 29.8383 & 8.3804 & 2.8949 & 0.7573 & 0.3152 \tabularnewline
195 & 0.0496 & 0.0322 & 0.0227 & 0.023 & 14.3018 & 9.2263 & 3.0375 & 0.5243 & 0.3451 \tabularnewline
196 & 0.0525 & 0.0506 & 0.0261 & 0.0267 & 31.0485 & 11.9541 & 3.4575 & 0.7725 & 0.3985 \tabularnewline
197 & 0.0547 & -0.0032 & 0.0236 & 0.024 & 0.1103 & 10.6381 & 3.2616 & -0.046 & 0.3594 \tabularnewline
198 & 0.056 & 0.0411 & 0.0253 & 0.0258 & 22.6709 & 11.8414 & 3.4411 & 0.6601 & 0.3894 \tabularnewline
199 & 0.0601 & 0.0137 & 0.0243 & 0.0247 & 1.8357 & 10.9318 & 3.3063 & 0.1878 & 0.3711 \tabularnewline
200 & 0.0623 & 0.0499 & 0.0264 & 0.0269 & 25.8445 & 12.1745 & 3.4892 & 0.7048 & 0.3989 \tabularnewline
201 & 0.0622 & 0.0169 & 0.0257 & 0.0262 & 3.6968 & 11.5224 & 3.3945 & 0.2666 & 0.3887 \tabularnewline
202 & 0.0637 & -0.0316 & 0.0261 & 0.0265 & 11.9929 & 11.556 & 3.3994 & -0.4801 & 0.3953 \tabularnewline
203 & 0.0666 & 0.0212 & 0.0258 & 0.0262 & 5.4296 & 11.1476 & 3.3388 & 0.323 & 0.3905 \tabularnewline
204 & 0.0691 & 0.0745 & 0.0288 & 0.0294 & 72.3129 & 14.9704 & 3.8692 & 1.1789 & 0.4397 \tabularnewline
205 & 0.0711 & 0.0223 & 0.0284 & 0.029 & 5.6913 & 14.4246 & 3.798 & 0.3307 & 0.4333 \tabularnewline
206 & 0.0729 & 0.0384 & 0.029 & 0.0296 & 17.6179 & 14.602 & 3.8213 & 0.5819 & 0.4416 \tabularnewline
207 & 0.0723 & 0.0623 & 0.0308 & 0.0314 & 59.9468 & 16.9885 & 4.1217 & 1.0734 & 0.4748 \tabularnewline
208 & 0.0759 & -0.0254 & 0.0305 & 0.0311 & 7.0601 & 16.4921 & 4.061 & -0.3684 & 0.4695 \tabularnewline
209 & 0.0776 & 0.0392 & 0.0309 & 0.0315 & 19.1922 & 16.6207 & 4.0768 & 0.6074 & 0.4761 \tabularnewline
210 & 0.0779 & 0.0431 & 0.0315 & 0.0321 & 26.2937 & 17.0604 & 4.1304 & 0.7109 & 0.4867 \tabularnewline
211 & 0.0828 & 0.0266 & 0.0312 & 0.0318 & 7.477 & 16.6437 & 4.0797 & 0.3791 & 0.4821 \tabularnewline
212 & 0.0846 & 0.0643 & 0.0326 & 0.0333 & 46.7484 & 17.8981 & 4.2306 & 0.9479 & 0.5015 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=313052&T=2

[TABLE]
[ROW][C]Univariate ARIMA Extrapolation Forecast Performance[/C][/ROW]
[ROW][C]time[/C][C]% S.E.[/C][C]PE[/C][C]MAPE[/C][C]sMAPE[/C][C]Sq.E[/C][C]MSE[/C][C]RMSE[/C][C]ScaledE[/C][C]MASE[/C][/ROW]
[ROW][C]189[/C][C]0.0347[/C][C]0.0202[/C][C]0.0202[/C][C]0.0204[/C][C]5.1174[/C][C]0[/C][C]0[/C][C]0.3136[/C][C]0.3136[/C][/ROW]
[ROW][C]190[/C][C]0.0352[/C][C]0.0069[/C][C]0.0136[/C][C]0.0137[/C][C]0.5957[/C][C]2.8566[/C][C]1.6901[/C][C]0.107[/C][C]0.2103[/C][/ROW]
[ROW][C]191[/C][C]0.0373[/C][C]0.0326[/C][C]0.0199[/C][C]0.0202[/C][C]12.2914[/C][C]6.0015[/C][C]2.4498[/C][C]0.4861[/C][C]0.3022[/C][/ROW]
[ROW][C]192[/C][C]0.0443[/C][C]-8e-04[/C][C]0.0151[/C][C]0.0153[/C][C]0.0065[/C][C]4.5028[/C][C]2.122[/C][C]-0.0112[/C][C]0.2295[/C][/ROW]
[ROW][C]193[/C][C]0.0457[/C][C]0.0151[/C][C]0.0151[/C][C]0.0153[/C][C]2.4331[/C][C]4.0888[/C][C]2.0221[/C][C]0.2163[/C][C]0.2268[/C][/ROW]
[ROW][C]194[/C][C]0.0478[/C][C]0.0509[/C][C]0.0211[/C][C]0.0214[/C][C]29.8383[/C][C]8.3804[/C][C]2.8949[/C][C]0.7573[/C][C]0.3152[/C][/ROW]
[ROW][C]195[/C][C]0.0496[/C][C]0.0322[/C][C]0.0227[/C][C]0.023[/C][C]14.3018[/C][C]9.2263[/C][C]3.0375[/C][C]0.5243[/C][C]0.3451[/C][/ROW]
[ROW][C]196[/C][C]0.0525[/C][C]0.0506[/C][C]0.0261[/C][C]0.0267[/C][C]31.0485[/C][C]11.9541[/C][C]3.4575[/C][C]0.7725[/C][C]0.3985[/C][/ROW]
[ROW][C]197[/C][C]0.0547[/C][C]-0.0032[/C][C]0.0236[/C][C]0.024[/C][C]0.1103[/C][C]10.6381[/C][C]3.2616[/C][C]-0.046[/C][C]0.3594[/C][/ROW]
[ROW][C]198[/C][C]0.056[/C][C]0.0411[/C][C]0.0253[/C][C]0.0258[/C][C]22.6709[/C][C]11.8414[/C][C]3.4411[/C][C]0.6601[/C][C]0.3894[/C][/ROW]
[ROW][C]199[/C][C]0.0601[/C][C]0.0137[/C][C]0.0243[/C][C]0.0247[/C][C]1.8357[/C][C]10.9318[/C][C]3.3063[/C][C]0.1878[/C][C]0.3711[/C][/ROW]
[ROW][C]200[/C][C]0.0623[/C][C]0.0499[/C][C]0.0264[/C][C]0.0269[/C][C]25.8445[/C][C]12.1745[/C][C]3.4892[/C][C]0.7048[/C][C]0.3989[/C][/ROW]
[ROW][C]201[/C][C]0.0622[/C][C]0.0169[/C][C]0.0257[/C][C]0.0262[/C][C]3.6968[/C][C]11.5224[/C][C]3.3945[/C][C]0.2666[/C][C]0.3887[/C][/ROW]
[ROW][C]202[/C][C]0.0637[/C][C]-0.0316[/C][C]0.0261[/C][C]0.0265[/C][C]11.9929[/C][C]11.556[/C][C]3.3994[/C][C]-0.4801[/C][C]0.3953[/C][/ROW]
[ROW][C]203[/C][C]0.0666[/C][C]0.0212[/C][C]0.0258[/C][C]0.0262[/C][C]5.4296[/C][C]11.1476[/C][C]3.3388[/C][C]0.323[/C][C]0.3905[/C][/ROW]
[ROW][C]204[/C][C]0.0691[/C][C]0.0745[/C][C]0.0288[/C][C]0.0294[/C][C]72.3129[/C][C]14.9704[/C][C]3.8692[/C][C]1.1789[/C][C]0.4397[/C][/ROW]
[ROW][C]205[/C][C]0.0711[/C][C]0.0223[/C][C]0.0284[/C][C]0.029[/C][C]5.6913[/C][C]14.4246[/C][C]3.798[/C][C]0.3307[/C][C]0.4333[/C][/ROW]
[ROW][C]206[/C][C]0.0729[/C][C]0.0384[/C][C]0.029[/C][C]0.0296[/C][C]17.6179[/C][C]14.602[/C][C]3.8213[/C][C]0.5819[/C][C]0.4416[/C][/ROW]
[ROW][C]207[/C][C]0.0723[/C][C]0.0623[/C][C]0.0308[/C][C]0.0314[/C][C]59.9468[/C][C]16.9885[/C][C]4.1217[/C][C]1.0734[/C][C]0.4748[/C][/ROW]
[ROW][C]208[/C][C]0.0759[/C][C]-0.0254[/C][C]0.0305[/C][C]0.0311[/C][C]7.0601[/C][C]16.4921[/C][C]4.061[/C][C]-0.3684[/C][C]0.4695[/C][/ROW]
[ROW][C]209[/C][C]0.0776[/C][C]0.0392[/C][C]0.0309[/C][C]0.0315[/C][C]19.1922[/C][C]16.6207[/C][C]4.0768[/C][C]0.6074[/C][C]0.4761[/C][/ROW]
[ROW][C]210[/C][C]0.0779[/C][C]0.0431[/C][C]0.0315[/C][C]0.0321[/C][C]26.2937[/C][C]17.0604[/C][C]4.1304[/C][C]0.7109[/C][C]0.4867[/C][/ROW]
[ROW][C]211[/C][C]0.0828[/C][C]0.0266[/C][C]0.0312[/C][C]0.0318[/C][C]7.477[/C][C]16.6437[/C][C]4.0797[/C][C]0.3791[/C][C]0.4821[/C][/ROW]
[ROW][C]212[/C][C]0.0846[/C][C]0.0643[/C][C]0.0326[/C][C]0.0333[/C][C]46.7484[/C][C]17.8981[/C][C]4.2306[/C][C]0.9479[/C][C]0.5015[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=313052&T=2

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

As an alternative you can also use a QR Code:  

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

Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPEsMAPESq.EMSERMSEScaledEMASE
1890.03470.02020.02020.02045.1174000.31360.3136
1900.03520.00690.01360.01370.59572.85661.69010.1070.2103
1910.03730.03260.01990.020212.29146.00152.44980.48610.3022
1920.0443-8e-040.01510.01530.00654.50282.122-0.01120.2295
1930.04570.01510.01510.01532.43314.08882.02210.21630.2268
1940.04780.05090.02110.021429.83838.38042.89490.75730.3152
1950.04960.03220.02270.02314.30189.22633.03750.52430.3451
1960.05250.05060.02610.026731.048511.95413.45750.77250.3985
1970.0547-0.00320.02360.0240.110310.63813.2616-0.0460.3594
1980.0560.04110.02530.025822.670911.84143.44110.66010.3894
1990.06010.01370.02430.02471.835710.93183.30630.18780.3711
2000.06230.04990.02640.026925.844512.17453.48920.70480.3989
2010.06220.01690.02570.02623.696811.52243.39450.26660.3887
2020.0637-0.03160.02610.026511.992911.5563.3994-0.48010.3953
2030.06660.02120.02580.02625.429611.14763.33880.3230.3905
2040.06910.07450.02880.029472.312914.97043.86921.17890.4397
2050.07110.02230.02840.0295.691314.42463.7980.33070.4333
2060.07290.03840.0290.029617.617914.6023.82130.58190.4416
2070.07230.06230.03080.031459.946816.98854.12171.07340.4748
2080.0759-0.02540.03050.03117.060116.49214.061-0.36840.4695
2090.07760.03920.03090.031519.192216.62074.07680.60740.4761
2100.07790.04310.03150.032126.293717.06044.13040.71090.4867
2110.08280.02660.03120.03187.47716.64374.07970.37910.4821
2120.08460.06430.03260.033346.748417.89814.23060.94790.5015



Parameters (Session):
par1 = 1 ; par2 = 2 ; par3 = 3 ; par4 = TRUE ;
Parameters (R input):
par1 = 24 ; par2 = 0.3 ; par3 = 1 ; par4 = 1 ; par5 = 12 ; par6 = 2 ; par7 = 0 ; par8 = 0 ; par9 = 1 ; par10 = FALSE ;
R code (references can be found in the software module):
par1 <- as.numeric(par1) #cut off periods
par2 <- as.numeric(par2) #lambda
par3 <- as.numeric(par3) #degree of non-seasonal differencing
par4 <- as.numeric(par4) #degree of seasonal differencing
par5 <- as.numeric(par5) #seasonal period
par6 <- as.numeric(par6) #p
par7 <- as.numeric(par7) #q
par8 <- as.numeric(par8) #P
par9 <- as.numeric(par9) #Q
if (par10 == 'TRUE') par10 <- TRUE
if (par10 == 'FALSE') par10 <- FALSE
if (par2 == 0) x <- log(x)
if (par2 != 0) x <- x^par2
lx <- length(x)
first <- lx - 2*par1
nx <- lx - par1
nx1 <- nx + 1
fx <- lx - nx
if (fx < 1) {
fx <- par5*2
nx1 <- lx + fx - 1
first <- lx - 2*fx
}
first <- 1
if (fx < 3) fx <- round(lx/10,0)
(arima.out <- arima(x[1:nx], order=c(par6,par3,par7), seasonal=list(order=c(par8,par4,par9), period=par5), include.mean=par10, method='ML'))
(forecast <- predict(arima.out,fx))
(lb <- forecast$pred - 1.96 * forecast$se)
(ub <- forecast$pred + 1.96 * forecast$se)
if (par2 == 0) {
x <- exp(x)
forecast$pred <- exp(forecast$pred)
lb <- exp(lb)
ub <- exp(ub)
}
if (par2 != 0) {
x <- x^(1/par2)
forecast$pred <- forecast$pred^(1/par2)
lb <- lb^(1/par2)
ub <- ub^(1/par2)
}
if (par2 < 0) {
olb <- lb
lb <- ub
ub <- olb
}
(actandfor <- c(x[1:nx], forecast$pred))
(perc.se <- (ub-forecast$pred)/1.96/forecast$pred)
bitmap(file='test1.png')
opar <- par(mar=c(4,4,2,2),las=1)
ylim <- c( min(x[first:nx],lb), max(x[first:nx],ub))
plot(x,ylim=ylim,type='n',xlim=c(first,lx))
usr <- par('usr')
rect(usr[1],usr[3],nx+1,usr[4],border=NA,col='lemonchiffon')
rect(nx1,usr[3],usr[2],usr[4],border=NA,col='lavender')
abline(h= (-3:3)*2 , col ='gray', lty =3)
polygon( c(nx1:lx,lx:nx1), c(lb,rev(ub)), col = 'orange', lty=2,border=NA)
lines(nx1:lx, lb , lty=2)
lines(nx1:lx, ub , lty=2)
lines(x, lwd=2)
lines(nx1:lx, forecast$pred , lwd=2 , col ='white')
box()
par(opar)
dev.off()
prob.dec <- array(NA, dim=fx)
prob.sdec <- array(NA, dim=fx)
prob.ldec <- array(NA, dim=fx)
prob.pval <- array(NA, dim=fx)
perf.pe <- array(0, dim=fx)
perf.spe <- array(0, dim=fx)
perf.scalederr <- array(0, dim=fx)
perf.mase <- array(0, dim=fx)
perf.mase1 <- array(0, dim=fx)
perf.mape <- array(0, dim=fx)
perf.smape <- array(0, dim=fx)
perf.mape1 <- array(0, dim=fx)
perf.smape1 <- array(0,dim=fx)
perf.se <- array(0, dim=fx)
perf.mse <- array(0, dim=fx)
perf.mse1 <- array(0, dim=fx)
perf.rmse <- array(0, dim=fx)
perf.scaleddenom <- 0
for (i in 2:fx) {
perf.scaleddenom = perf.scaleddenom + abs(x[nx+i] - x[nx+i-1])
}
perf.scaleddenom = perf.scaleddenom / (fx-1)
for (i in 1:fx) {
locSD <- (ub[i] - forecast$pred[i]) / 1.96
perf.scalederr[i] = (x[nx+i] - forecast$pred[i]) / perf.scaleddenom
perf.pe[i] = (x[nx+i] - forecast$pred[i]) / x[nx+i]
perf.spe[i] = 2*(x[nx+i] - forecast$pred[i]) / (x[nx+i] + forecast$pred[i])
perf.se[i] = (x[nx+i] - forecast$pred[i])^2
prob.dec[i] = pnorm((x[nx+i-1] - forecast$pred[i]) / locSD)
prob.sdec[i] = pnorm((x[nx+i-par5] - forecast$pred[i]) / locSD)
prob.ldec[i] = pnorm((x[nx] - forecast$pred[i]) / locSD)
prob.pval[i] = pnorm(abs(x[nx+i] - forecast$pred[i]) / locSD)
}
perf.mape[1] = abs(perf.pe[1])
perf.smape[1] = abs(perf.spe[1])
perf.mape1[1] = perf.mape[1]
perf.smape1[1] = perf.smape[1]
perf.mse[1] = perf.se[1]
perf.mase[1] = abs(perf.scalederr[1])
perf.mase1[1] = perf.mase[1]
for (i in 2:fx) {
perf.mape[i] = perf.mape[i-1] + abs(perf.pe[i])
perf.mape1[i] = perf.mape[i] / i
perf.smape[i] = perf.smape[i-1] + abs(perf.spe[i])
perf.smape1[i] = perf.smape[i] / i
perf.mse[i] = perf.mse[i-1] + perf.se[i]
perf.mse1[i] = perf.mse[i] / i
perf.mase[i] = perf.mase[i-1] + abs(perf.scalederr[i])
perf.mase1[i] = perf.mase[i] / i
}
perf.rmse = sqrt(perf.mse1)
bitmap(file='test2.png')
plot(forecast$pred, pch=19, type='b',main='ARIMA Extrapolation Forecast', ylab='Forecast and 95% CI', xlab='time',ylim=c(min(lb),max(ub)))
dum <- forecast$pred
dum[1:par1] <- x[(nx+1):lx]
lines(dum, lty=1)
lines(ub,lty=3)
lines(lb,lty=3)
dev.off()
load(file='createtable')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Univariate ARIMA Extrapolation Forecast',9,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'time',1,header=TRUE)
a<-table.element(a,'Y[t]',1,header=TRUE)
a<-table.element(a,'F[t]',1,header=TRUE)
a<-table.element(a,'95% LB',1,header=TRUE)
a<-table.element(a,'95% UB',1,header=TRUE)
a<-table.element(a,'p-value
(H0: Y[t] = F[t])',1,header=TRUE)
a<-table.element(a,'P(F[t]>Y[t-1])',1,header=TRUE)
a<-table.element(a,'P(F[t]>Y[t-s])',1,header=TRUE)
mylab <- paste('P(F[t]>Y[',nx,sep='')
mylab <- paste(mylab,'])',sep='')
a<-table.element(a,mylab,1,header=TRUE)
a<-table.row.end(a)
for (i in (nx-par5):nx) {
a<-table.row.start(a)
a<-table.element(a,i,header=TRUE)
a<-table.element(a,x[i])
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.element(a,'-')
a<-table.row.end(a)
}
for (i in 1:fx) {
a<-table.row.start(a)
a<-table.element(a,nx+i,header=TRUE)
a<-table.element(a,round(x[nx+i],4))
a<-table.element(a,round(forecast$pred[i],4))
a<-table.element(a,round(lb[i],4))
a<-table.element(a,round(ub[i],4))
a<-table.element(a,round((1-prob.pval[i]),4))
a<-table.element(a,round((1-prob.dec[i]),4))
a<-table.element(a,round((1-prob.sdec[i]),4))
a<-table.element(a,round((1-prob.ldec[i]),4))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable.tab')
a<-table.start()
a<-table.row.start(a)
a<-table.element(a,'Univariate ARIMA Extrapolation Forecast Performance',10,TRUE)
a<-table.row.end(a)
a<-table.row.start(a)
a<-table.element(a,'time',1,header=TRUE)
a<-table.element(a,'% S.E.',1,header=TRUE)
a<-table.element(a,'PE',1,header=TRUE)
a<-table.element(a,'MAPE',1,header=TRUE)
a<-table.element(a,'sMAPE',1,header=TRUE)
a<-table.element(a,'Sq.E',1,header=TRUE)
a<-table.element(a,'MSE',1,header=TRUE)
a<-table.element(a,'RMSE',1,header=TRUE)
a<-table.element(a,'ScaledE',1,header=TRUE)
a<-table.element(a,'MASE',1,header=TRUE)
a<-table.row.end(a)
for (i in 1:fx) {
a<-table.row.start(a)
a<-table.element(a,nx+i,header=TRUE)
a<-table.element(a,round(perc.se[i],4))
a<-table.element(a,round(perf.pe[i],4))
a<-table.element(a,round(perf.mape1[i],4))
a<-table.element(a,round(perf.smape1[i],4))
a<-table.element(a,round(perf.se[i],4))
a<-table.element(a,round(perf.mse1[i],4))
a<-table.element(a,round(perf.rmse[i],4))
a<-table.element(a,round(perf.scalederr[i],4))
a<-table.element(a,round(perf.mase1[i],4))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable1.tab')