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 computationTue, 15 Dec 2009 08:15:28 -0700
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2009/Dec/15/t12608902114ytum8b7f9762vs.htm/, Retrieved Thu, 09 May 2024 01:01:57 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=67966, Retrieved Thu, 09 May 2024 01:01:57 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywordsForecasting
Estimated Impact112
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [ARIMA Forecasting] [] [2009-12-07 09:54:52] [b98453cac15ba1066b407e146608df68]
-   PD  [ARIMA Forecasting] [Forecasting] [2009-12-13 21:15:11] [9717cb857c153ca3061376906953b329]
- R P       [ARIMA Forecasting] [Forecasting] [2009-12-15 15:15:28] [52b85b290d6f50b0921ad6729b8a5af2] [Current]
Feedback Forum

Post a new message
Dataseries X:
220206
220115
218444
214912
210705
209673
237041
242081
241878
242621
238545
240337
244752
244576
241572
240541
236089
236997
264579
270349
269645
267037
258113
262813
267413
267366
264777
258863
254844
254868
277267
285351
286602
283042
276687
277915
277128
277103
275037
270150
267140
264993
287259
291186
292300
288186
281477
282656
280190
280408
276836
275216
274352
271311
289802
290726
292300
278506
269826
265861
269034
264176
255198
253353
246057
235372
258556
260993
254663
250643
243422
247105
248541
245039
237080
237085
225554
226839
247934
248333
246969
245098
246263
255765
264319
268347
273046
273963
267430
271993
292710
295881
293299
288576




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135

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

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

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

As an alternative you can also use a QR Code:  

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

Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time3 seconds
R Server'Gwilym Jenkins' @ 72.249.127.135







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[76])
64253353-------
65246057-------
66235372-------
67258556-------
68260993-------
69254663-------
70250643-------
71243422-------
72247105-------
73248541-------
74245039-------
75237080-------
76237085-------
77225554231571.8062225531.3643237612.24820.02540.036800.0368
78226839225516.8611216878.2877234155.43440.38210.49660.01270.0043
79247934249094.5813238048.833260140.32970.418410.04660.9835
80248333252302.4046238334.2427266270.56650.28880.73010.11130.9836
81246969249791.9399233332.6513266251.22840.36840.5690.28090.9349
82245098244895.5173226090.174263700.86070.49160.41450.27460.7922
83246263237678.1574216576.7056258779.60920.21260.24540.29680.522
84255765239568.8021216357.1837262780.42050.08570.28590.26230.5831
85264319241126.9174215918.3886266335.44630.03570.12750.28220.6233
86268347238756.9201211651.1687265862.67150.01620.03230.32480.5481
87273046232679.3293203783.8832261574.77540.00310.00780.38270.3825
88273963231123.1032200522.1849261724.02150.0030.00360.35130.3513
89267430226323.1413193116.8417259529.44090.00760.00250.51810.2626
90271993221336.5716185684.8016256988.34170.00270.00560.38110.1933
91292710244524.7949206464.6149282584.97480.00650.07860.43030.6492
92295881247995.4519207406.3427288584.5610.01040.01540.49350.7009
93293299246177.6325203182.07289173.1950.01590.01170.48560.6607
94288576241016.9295195683.8816286349.97730.01990.01190.430.5675

\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[76]) \tabularnewline
64 & 253353 & - & - & - & - & - & - & - \tabularnewline
65 & 246057 & - & - & - & - & - & - & - \tabularnewline
66 & 235372 & - & - & - & - & - & - & - \tabularnewline
67 & 258556 & - & - & - & - & - & - & - \tabularnewline
68 & 260993 & - & - & - & - & - & - & - \tabularnewline
69 & 254663 & - & - & - & - & - & - & - \tabularnewline
70 & 250643 & - & - & - & - & - & - & - \tabularnewline
71 & 243422 & - & - & - & - & - & - & - \tabularnewline
72 & 247105 & - & - & - & - & - & - & - \tabularnewline
73 & 248541 & - & - & - & - & - & - & - \tabularnewline
74 & 245039 & - & - & - & - & - & - & - \tabularnewline
75 & 237080 & - & - & - & - & - & - & - \tabularnewline
76 & 237085 & - & - & - & - & - & - & - \tabularnewline
77 & 225554 & 231571.8062 & 225531.3643 & 237612.2482 & 0.0254 & 0.0368 & 0 & 0.0368 \tabularnewline
78 & 226839 & 225516.8611 & 216878.2877 & 234155.4344 & 0.3821 & 0.4966 & 0.0127 & 0.0043 \tabularnewline
79 & 247934 & 249094.5813 & 238048.833 & 260140.3297 & 0.4184 & 1 & 0.0466 & 0.9835 \tabularnewline
80 & 248333 & 252302.4046 & 238334.2427 & 266270.5665 & 0.2888 & 0.7301 & 0.1113 & 0.9836 \tabularnewline
81 & 246969 & 249791.9399 & 233332.6513 & 266251.2284 & 0.3684 & 0.569 & 0.2809 & 0.9349 \tabularnewline
82 & 245098 & 244895.5173 & 226090.174 & 263700.8607 & 0.4916 & 0.4145 & 0.2746 & 0.7922 \tabularnewline
83 & 246263 & 237678.1574 & 216576.7056 & 258779.6092 & 0.2126 & 0.2454 & 0.2968 & 0.522 \tabularnewline
84 & 255765 & 239568.8021 & 216357.1837 & 262780.4205 & 0.0857 & 0.2859 & 0.2623 & 0.5831 \tabularnewline
85 & 264319 & 241126.9174 & 215918.3886 & 266335.4463 & 0.0357 & 0.1275 & 0.2822 & 0.6233 \tabularnewline
86 & 268347 & 238756.9201 & 211651.1687 & 265862.6715 & 0.0162 & 0.0323 & 0.3248 & 0.5481 \tabularnewline
87 & 273046 & 232679.3293 & 203783.8832 & 261574.7754 & 0.0031 & 0.0078 & 0.3827 & 0.3825 \tabularnewline
88 & 273963 & 231123.1032 & 200522.1849 & 261724.0215 & 0.003 & 0.0036 & 0.3513 & 0.3513 \tabularnewline
89 & 267430 & 226323.1413 & 193116.8417 & 259529.4409 & 0.0076 & 0.0025 & 0.5181 & 0.2626 \tabularnewline
90 & 271993 & 221336.5716 & 185684.8016 & 256988.3417 & 0.0027 & 0.0056 & 0.3811 & 0.1933 \tabularnewline
91 & 292710 & 244524.7949 & 206464.6149 & 282584.9748 & 0.0065 & 0.0786 & 0.4303 & 0.6492 \tabularnewline
92 & 295881 & 247995.4519 & 207406.3427 & 288584.561 & 0.0104 & 0.0154 & 0.4935 & 0.7009 \tabularnewline
93 & 293299 & 246177.6325 & 203182.07 & 289173.195 & 0.0159 & 0.0117 & 0.4856 & 0.6607 \tabularnewline
94 & 288576 & 241016.9295 & 195683.8816 & 286349.9773 & 0.0199 & 0.0119 & 0.43 & 0.5675 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=67966&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[76])[/C][/ROW]
[ROW][C]64[/C][C]253353[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]65[/C][C]246057[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]66[/C][C]235372[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]67[/C][C]258556[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]68[/C][C]260993[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]69[/C][C]254663[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]70[/C][C]250643[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]71[/C][C]243422[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]72[/C][C]247105[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]73[/C][C]248541[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]74[/C][C]245039[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]75[/C][C]237080[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]76[/C][C]237085[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]77[/C][C]225554[/C][C]231571.8062[/C][C]225531.3643[/C][C]237612.2482[/C][C]0.0254[/C][C]0.0368[/C][C]0[/C][C]0.0368[/C][/ROW]
[ROW][C]78[/C][C]226839[/C][C]225516.8611[/C][C]216878.2877[/C][C]234155.4344[/C][C]0.3821[/C][C]0.4966[/C][C]0.0127[/C][C]0.0043[/C][/ROW]
[ROW][C]79[/C][C]247934[/C][C]249094.5813[/C][C]238048.833[/C][C]260140.3297[/C][C]0.4184[/C][C]1[/C][C]0.0466[/C][C]0.9835[/C][/ROW]
[ROW][C]80[/C][C]248333[/C][C]252302.4046[/C][C]238334.2427[/C][C]266270.5665[/C][C]0.2888[/C][C]0.7301[/C][C]0.1113[/C][C]0.9836[/C][/ROW]
[ROW][C]81[/C][C]246969[/C][C]249791.9399[/C][C]233332.6513[/C][C]266251.2284[/C][C]0.3684[/C][C]0.569[/C][C]0.2809[/C][C]0.9349[/C][/ROW]
[ROW][C]82[/C][C]245098[/C][C]244895.5173[/C][C]226090.174[/C][C]263700.8607[/C][C]0.4916[/C][C]0.4145[/C][C]0.2746[/C][C]0.7922[/C][/ROW]
[ROW][C]83[/C][C]246263[/C][C]237678.1574[/C][C]216576.7056[/C][C]258779.6092[/C][C]0.2126[/C][C]0.2454[/C][C]0.2968[/C][C]0.522[/C][/ROW]
[ROW][C]84[/C][C]255765[/C][C]239568.8021[/C][C]216357.1837[/C][C]262780.4205[/C][C]0.0857[/C][C]0.2859[/C][C]0.2623[/C][C]0.5831[/C][/ROW]
[ROW][C]85[/C][C]264319[/C][C]241126.9174[/C][C]215918.3886[/C][C]266335.4463[/C][C]0.0357[/C][C]0.1275[/C][C]0.2822[/C][C]0.6233[/C][/ROW]
[ROW][C]86[/C][C]268347[/C][C]238756.9201[/C][C]211651.1687[/C][C]265862.6715[/C][C]0.0162[/C][C]0.0323[/C][C]0.3248[/C][C]0.5481[/C][/ROW]
[ROW][C]87[/C][C]273046[/C][C]232679.3293[/C][C]203783.8832[/C][C]261574.7754[/C][C]0.0031[/C][C]0.0078[/C][C]0.3827[/C][C]0.3825[/C][/ROW]
[ROW][C]88[/C][C]273963[/C][C]231123.1032[/C][C]200522.1849[/C][C]261724.0215[/C][C]0.003[/C][C]0.0036[/C][C]0.3513[/C][C]0.3513[/C][/ROW]
[ROW][C]89[/C][C]267430[/C][C]226323.1413[/C][C]193116.8417[/C][C]259529.4409[/C][C]0.0076[/C][C]0.0025[/C][C]0.5181[/C][C]0.2626[/C][/ROW]
[ROW][C]90[/C][C]271993[/C][C]221336.5716[/C][C]185684.8016[/C][C]256988.3417[/C][C]0.0027[/C][C]0.0056[/C][C]0.3811[/C][C]0.1933[/C][/ROW]
[ROW][C]91[/C][C]292710[/C][C]244524.7949[/C][C]206464.6149[/C][C]282584.9748[/C][C]0.0065[/C][C]0.0786[/C][C]0.4303[/C][C]0.6492[/C][/ROW]
[ROW][C]92[/C][C]295881[/C][C]247995.4519[/C][C]207406.3427[/C][C]288584.561[/C][C]0.0104[/C][C]0.0154[/C][C]0.4935[/C][C]0.7009[/C][/ROW]
[ROW][C]93[/C][C]293299[/C][C]246177.6325[/C][C]203182.07[/C][C]289173.195[/C][C]0.0159[/C][C]0.0117[/C][C]0.4856[/C][C]0.6607[/C][/ROW]
[ROW][C]94[/C][C]288576[/C][C]241016.9295[/C][C]195683.8816[/C][C]286349.9773[/C][C]0.0199[/C][C]0.0119[/C][C]0.43[/C][C]0.5675[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=67966&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=67966&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[76])
64253353-------
65246057-------
66235372-------
67258556-------
68260993-------
69254663-------
70250643-------
71243422-------
72247105-------
73248541-------
74245039-------
75237080-------
76237085-------
77225554231571.8062225531.3643237612.24820.02540.036800.0368
78226839225516.8611216878.2877234155.43440.38210.49660.01270.0043
79247934249094.5813238048.833260140.32970.418410.04660.9835
80248333252302.4046238334.2427266270.56650.28880.73010.11130.9836
81246969249791.9399233332.6513266251.22840.36840.5690.28090.9349
82245098244895.5173226090.174263700.86070.49160.41450.27460.7922
83246263237678.1574216576.7056258779.60920.21260.24540.29680.522
84255765239568.8021216357.1837262780.42050.08570.28590.26230.5831
85264319241126.9174215918.3886266335.44630.03570.12750.28220.6233
86268347238756.9201211651.1687265862.67150.01620.03230.32480.5481
87273046232679.3293203783.8832261574.77540.00310.00780.38270.3825
88273963231123.1032200522.1849261724.02150.0030.00360.35130.3513
89267430226323.1413193116.8417259529.44090.00760.00250.51810.2626
90271993221336.5716185684.8016256988.34170.00270.00560.38110.1933
91292710244524.7949206464.6149282584.97480.00650.07860.43030.6492
92295881247995.4519207406.3427288584.5610.01040.01540.49350.7009
93293299246177.6325203182.07289173.1950.01590.01170.48560.6607
94288576241016.9295195683.8816286349.97730.01990.01190.430.5675







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
770.0133-0.026036213991.889900
780.01950.00590.01591748051.371918981021.63094356.7214
790.0226-0.00470.01221346949.013613102997.42513619.8063
800.0282-0.01570.013115756172.816713766291.2733710.2953
810.0336-0.01130.01277968989.492112606830.91683550.6099
820.03928e-040.010740999.236210512525.63673242.3025
830.04530.03610.014473699522.227619539239.43544420.3212
840.04940.06760.021262316825.83849886437.73587063.0332
850.05330.09620.0294537872693.1954104107132.786810203.2903
860.05790.12390.0388875572828.462181253702.354313463.0495
870.06340.17350.05111629468103.0078312909556.959217689.2498
880.06760.18540.06231835256758.1635439771823.726220970.7373
890.07490.18160.07141689773832.8947535925824.431523150.0718
900.08220.22890.08272566073734.0961680936389.407526094.7579
910.07940.19710.09032321813991.5679790328229.551628112.777
920.08350.19310.09672293025717.9167884246822.574429736.288
930.08910.19140.10232220423275.1236962845437.430231029.7508
940.0960.19730.10762261865190.77261035013201.504832171.6211

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
77 & 0.0133 & -0.026 & 0 & 36213991.8899 & 0 & 0 \tabularnewline
78 & 0.0195 & 0.0059 & 0.0159 & 1748051.3719 & 18981021.6309 & 4356.7214 \tabularnewline
79 & 0.0226 & -0.0047 & 0.0122 & 1346949.0136 & 13102997.4251 & 3619.8063 \tabularnewline
80 & 0.0282 & -0.0157 & 0.0131 & 15756172.8167 & 13766291.273 & 3710.2953 \tabularnewline
81 & 0.0336 & -0.0113 & 0.0127 & 7968989.4921 & 12606830.9168 & 3550.6099 \tabularnewline
82 & 0.0392 & 8e-04 & 0.0107 & 40999.2362 & 10512525.6367 & 3242.3025 \tabularnewline
83 & 0.0453 & 0.0361 & 0.0144 & 73699522.2276 & 19539239.4354 & 4420.3212 \tabularnewline
84 & 0.0494 & 0.0676 & 0.021 & 262316825.838 & 49886437.7358 & 7063.0332 \tabularnewline
85 & 0.0533 & 0.0962 & 0.0294 & 537872693.1954 & 104107132.7868 & 10203.2903 \tabularnewline
86 & 0.0579 & 0.1239 & 0.0388 & 875572828.462 & 181253702.3543 & 13463.0495 \tabularnewline
87 & 0.0634 & 0.1735 & 0.0511 & 1629468103.0078 & 312909556.9592 & 17689.2498 \tabularnewline
88 & 0.0676 & 0.1854 & 0.0623 & 1835256758.1635 & 439771823.7262 & 20970.7373 \tabularnewline
89 & 0.0749 & 0.1816 & 0.0714 & 1689773832.8947 & 535925824.4315 & 23150.0718 \tabularnewline
90 & 0.0822 & 0.2289 & 0.0827 & 2566073734.0961 & 680936389.4075 & 26094.7579 \tabularnewline
91 & 0.0794 & 0.1971 & 0.0903 & 2321813991.5679 & 790328229.5516 & 28112.777 \tabularnewline
92 & 0.0835 & 0.1931 & 0.0967 & 2293025717.9167 & 884246822.5744 & 29736.288 \tabularnewline
93 & 0.0891 & 0.1914 & 0.1023 & 2220423275.1236 & 962845437.4302 & 31029.7508 \tabularnewline
94 & 0.096 & 0.1973 & 0.1076 & 2261865190.7726 & 1035013201.5048 & 32171.6211 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=67966&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]Sq.E[/C][C]MSE[/C][C]RMSE[/C][/ROW]
[ROW][C]77[/C][C]0.0133[/C][C]-0.026[/C][C]0[/C][C]36213991.8899[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]78[/C][C]0.0195[/C][C]0.0059[/C][C]0.0159[/C][C]1748051.3719[/C][C]18981021.6309[/C][C]4356.7214[/C][/ROW]
[ROW][C]79[/C][C]0.0226[/C][C]-0.0047[/C][C]0.0122[/C][C]1346949.0136[/C][C]13102997.4251[/C][C]3619.8063[/C][/ROW]
[ROW][C]80[/C][C]0.0282[/C][C]-0.0157[/C][C]0.0131[/C][C]15756172.8167[/C][C]13766291.273[/C][C]3710.2953[/C][/ROW]
[ROW][C]81[/C][C]0.0336[/C][C]-0.0113[/C][C]0.0127[/C][C]7968989.4921[/C][C]12606830.9168[/C][C]3550.6099[/C][/ROW]
[ROW][C]82[/C][C]0.0392[/C][C]8e-04[/C][C]0.0107[/C][C]40999.2362[/C][C]10512525.6367[/C][C]3242.3025[/C][/ROW]
[ROW][C]83[/C][C]0.0453[/C][C]0.0361[/C][C]0.0144[/C][C]73699522.2276[/C][C]19539239.4354[/C][C]4420.3212[/C][/ROW]
[ROW][C]84[/C][C]0.0494[/C][C]0.0676[/C][C]0.021[/C][C]262316825.838[/C][C]49886437.7358[/C][C]7063.0332[/C][/ROW]
[ROW][C]85[/C][C]0.0533[/C][C]0.0962[/C][C]0.0294[/C][C]537872693.1954[/C][C]104107132.7868[/C][C]10203.2903[/C][/ROW]
[ROW][C]86[/C][C]0.0579[/C][C]0.1239[/C][C]0.0388[/C][C]875572828.462[/C][C]181253702.3543[/C][C]13463.0495[/C][/ROW]
[ROW][C]87[/C][C]0.0634[/C][C]0.1735[/C][C]0.0511[/C][C]1629468103.0078[/C][C]312909556.9592[/C][C]17689.2498[/C][/ROW]
[ROW][C]88[/C][C]0.0676[/C][C]0.1854[/C][C]0.0623[/C][C]1835256758.1635[/C][C]439771823.7262[/C][C]20970.7373[/C][/ROW]
[ROW][C]89[/C][C]0.0749[/C][C]0.1816[/C][C]0.0714[/C][C]1689773832.8947[/C][C]535925824.4315[/C][C]23150.0718[/C][/ROW]
[ROW][C]90[/C][C]0.0822[/C][C]0.2289[/C][C]0.0827[/C][C]2566073734.0961[/C][C]680936389.4075[/C][C]26094.7579[/C][/ROW]
[ROW][C]91[/C][C]0.0794[/C][C]0.1971[/C][C]0.0903[/C][C]2321813991.5679[/C][C]790328229.5516[/C][C]28112.777[/C][/ROW]
[ROW][C]92[/C][C]0.0835[/C][C]0.1931[/C][C]0.0967[/C][C]2293025717.9167[/C][C]884246822.5744[/C][C]29736.288[/C][/ROW]
[ROW][C]93[/C][C]0.0891[/C][C]0.1914[/C][C]0.1023[/C][C]2220423275.1236[/C][C]962845437.4302[/C][C]31029.7508[/C][/ROW]
[ROW][C]94[/C][C]0.096[/C][C]0.1973[/C][C]0.1076[/C][C]2261865190.7726[/C][C]1035013201.5048[/C][C]32171.6211[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=67966&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=67966&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.PEMAPESq.EMSERMSE
770.0133-0.026036213991.889900
780.01950.00590.01591748051.371918981021.63094356.7214
790.0226-0.00470.01221346949.013613102997.42513619.8063
800.0282-0.01570.013115756172.816713766291.2733710.2953
810.0336-0.01130.01277968989.492112606830.91683550.6099
820.03928e-040.010740999.236210512525.63673242.3025
830.04530.03610.014473699522.227619539239.43544420.3212
840.04940.06760.021262316825.83849886437.73587063.0332
850.05330.09620.0294537872693.1954104107132.786810203.2903
860.05790.12390.0388875572828.462181253702.354313463.0495
870.06340.17350.05111629468103.0078312909556.959217689.2498
880.06760.18540.06231835256758.1635439771823.726220970.7373
890.07490.18160.07141689773832.8947535925824.431523150.0718
900.08220.22890.08272566073734.0961680936389.407526094.7579
910.07940.19710.09032321813991.5679790328229.551628112.777
920.08350.19310.09672293025717.9167884246822.574429736.288
930.08910.19140.10232220423275.1236962845437.430231029.7508
940.0960.19730.10762261865190.77261035013201.504832171.6211



Parameters (Session):
par1 = 18 ; par2 = 1 ; par3 = 1 ; par4 = 1 ; par5 = 12 ; par6 = 3 ; par7 = 0 ; par8 = 1 ; par9 = 1 ; par10 = FALSE ;
Parameters (R input):
par1 = 18 ; par2 = 1 ; par3 = 1 ; par4 = 1 ; par5 = 12 ; par6 = 3 ; par7 = 0 ; par8 = 1 ; 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
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,par1))
(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.mape <- array(0, dim=fx)
perf.mape1 <- 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)
for (i in 1:fx) {
locSD <- (ub[i] - forecast$pred[i]) / 1.96
perf.pe[i] = (x[nx+i] - forecast$pred[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.mse[1] = abs(perf.se[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.mse[i] = perf.mse[i-1] + perf.se[i]
perf.mse1[i] = perf.mse[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',7,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,'Sq.E',1,header=TRUE)
a<-table.element(a,'MSE',1,header=TRUE)
a<-table.element(a,'RMSE',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.se[i],4))
a<-table.element(a,round(perf.mse1[i],4))
a<-table.element(a,round(perf.rmse[i],4))
a<-table.row.end(a)
}
a<-table.end(a)
table.save(a,file='mytable1.tab')