Free Statistics

of Irreproducible Research!

Author's title

Author*Unverified author*
R Software Modulerwasp_arimaforecasting.wasp
Title produced by softwareARIMA Forecasting
Date of computationMon, 05 Dec 2011 11:50:19 -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/05/t132310386165wijp1vxdiwdgv.htm/, Retrieved Fri, 03 May 2024 10:59:07 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=151071, Retrieved Fri, 03 May 2024 10:59:07 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact114
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [Univariate Data Series] [] [2008-12-08 19:22:39] [d2d412c7f4d35ffbf5ee5ee89db327d4]
- RMPD  [ARIMA Backward Selection] [WS9 Wine Sales Au...] [2011-12-02 15:00:34] [9d4f280afcb4ecc352d7c6f913a0a151]
- RM      [ARIMA Forecasting] [WS9 Wine Sales Au...] [2011-12-02 15:13:11] [9d4f280afcb4ecc352d7c6f913a0a151]
- R P         [ARIMA Forecasting] [WS9 Wine Sales Au...] [2011-12-05 16:50:19] [d41d8cd98f00b204e9800998ecf8427e] [Current]
Feedback Forum

Post a new message
Dataseries X:
2564
2820
3508
3088
3299
2939
3320
3418
3604
3495
4163
4882
2211
3260
2992
2425
2707
3244
3965
3315
3333
3583
4021
4904
2252
2952
3573
3048
3059
2731
3563
3092
3478
3478
4308
5029
2075
3264
3308
3688
3136
2824
3644
4694
2914
3686
4358
5587
2265
3685
3754
3708
3210
3517
3905
3670
4221
4404
5086
5725




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

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

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

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

As an alternative you can also use a QR Code:  

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

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







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[36])
244904-------
252252-------
262952-------
273573-------
283048-------
293059-------
302731-------
313563-------
323092-------
333478-------
343478-------
354308-------
365029-------
3720752351.47572004.04692759.13610.091900.68380
3832642943.67262498.45683468.22420.11570.99940.48760
3933083367.30482853.66443973.3970.4240.63080.2530
4036882821.86072373.65593354.69767e-040.03690.20280
4131363042.0182558.25123617.26540.37440.01390.47690
4228242939.41122471.65613495.68780.34210.24430.76860
4336443637.12173056.27994328.35180.49220.98940.58320
4446943254.24512733.63153874.008400.10890.69610
4529143490.57192932.20664155.2640.04462e-040.51480
4636863461.81262909.17714119.42810.2520.94870.48080
4743584182.89223514.83924977.91960.3330.88970.37890.0185
4855874972.3234178.96975916.28990.10090.89890.45320.4532
4922652347.89441971.66772795.91140.358400.88370
5036852981.20142503.28673550.3570.00770.99320.16510
5137543363.54622824.31634005.72820.11670.16330.56730
5237082823.24862369.16513364.36367e-044e-049e-040
5332103026.56622539.62963606.86580.26780.01070.35580
5435172947.24382473.13863512.23590.0240.1810.66550
5539053633.02153048.48784329.63680.22210.6280.48770
5636703261.91532736.96053887.55770.10050.02200
5742213483.52032922.95224151.5950.01520.29220.95260
5844043466.04442909.65634128.82570.00280.01280.25770
5950864177.20513506.84975.77340.01290.28890.32860.0183
6057254978.94234180.67965929.62590.0620.41270.1050.4589

\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[36]) \tabularnewline
24 & 4904 & - & - & - & - & - & - & - \tabularnewline
25 & 2252 & - & - & - & - & - & - & - \tabularnewline
26 & 2952 & - & - & - & - & - & - & - \tabularnewline
27 & 3573 & - & - & - & - & - & - & - \tabularnewline
28 & 3048 & - & - & - & - & - & - & - \tabularnewline
29 & 3059 & - & - & - & - & - & - & - \tabularnewline
30 & 2731 & - & - & - & - & - & - & - \tabularnewline
31 & 3563 & - & - & - & - & - & - & - \tabularnewline
32 & 3092 & - & - & - & - & - & - & - \tabularnewline
33 & 3478 & - & - & - & - & - & - & - \tabularnewline
34 & 3478 & - & - & - & - & - & - & - \tabularnewline
35 & 4308 & - & - & - & - & - & - & - \tabularnewline
36 & 5029 & - & - & - & - & - & - & - \tabularnewline
37 & 2075 & 2351.4757 & 2004.0469 & 2759.1361 & 0.0919 & 0 & 0.6838 & 0 \tabularnewline
38 & 3264 & 2943.6726 & 2498.4568 & 3468.2242 & 0.1157 & 0.9994 & 0.4876 & 0 \tabularnewline
39 & 3308 & 3367.3048 & 2853.6644 & 3973.397 & 0.424 & 0.6308 & 0.253 & 0 \tabularnewline
40 & 3688 & 2821.8607 & 2373.6559 & 3354.6976 & 7e-04 & 0.0369 & 0.2028 & 0 \tabularnewline
41 & 3136 & 3042.018 & 2558.2512 & 3617.2654 & 0.3744 & 0.0139 & 0.4769 & 0 \tabularnewline
42 & 2824 & 2939.4112 & 2471.6561 & 3495.6878 & 0.3421 & 0.2443 & 0.7686 & 0 \tabularnewline
43 & 3644 & 3637.1217 & 3056.2799 & 4328.3518 & 0.4922 & 0.9894 & 0.5832 & 0 \tabularnewline
44 & 4694 & 3254.2451 & 2733.6315 & 3874.0084 & 0 & 0.1089 & 0.6961 & 0 \tabularnewline
45 & 2914 & 3490.5719 & 2932.2066 & 4155.264 & 0.0446 & 2e-04 & 0.5148 & 0 \tabularnewline
46 & 3686 & 3461.8126 & 2909.1771 & 4119.4281 & 0.252 & 0.9487 & 0.4808 & 0 \tabularnewline
47 & 4358 & 4182.8922 & 3514.8392 & 4977.9196 & 0.333 & 0.8897 & 0.3789 & 0.0185 \tabularnewline
48 & 5587 & 4972.323 & 4178.9697 & 5916.2899 & 0.1009 & 0.8989 & 0.4532 & 0.4532 \tabularnewline
49 & 2265 & 2347.8944 & 1971.6677 & 2795.9114 & 0.3584 & 0 & 0.8837 & 0 \tabularnewline
50 & 3685 & 2981.2014 & 2503.2867 & 3550.357 & 0.0077 & 0.9932 & 0.1651 & 0 \tabularnewline
51 & 3754 & 3363.5462 & 2824.3163 & 4005.7282 & 0.1167 & 0.1633 & 0.5673 & 0 \tabularnewline
52 & 3708 & 2823.2486 & 2369.1651 & 3364.3636 & 7e-04 & 4e-04 & 9e-04 & 0 \tabularnewline
53 & 3210 & 3026.5662 & 2539.6296 & 3606.8658 & 0.2678 & 0.0107 & 0.3558 & 0 \tabularnewline
54 & 3517 & 2947.2438 & 2473.1386 & 3512.2359 & 0.024 & 0.181 & 0.6655 & 0 \tabularnewline
55 & 3905 & 3633.0215 & 3048.4878 & 4329.6368 & 0.2221 & 0.628 & 0.4877 & 0 \tabularnewline
56 & 3670 & 3261.9153 & 2736.9605 & 3887.5577 & 0.1005 & 0.022 & 0 & 0 \tabularnewline
57 & 4221 & 3483.5203 & 2922.9522 & 4151.595 & 0.0152 & 0.2922 & 0.9526 & 0 \tabularnewline
58 & 4404 & 3466.0444 & 2909.6563 & 4128.8257 & 0.0028 & 0.0128 & 0.2577 & 0 \tabularnewline
59 & 5086 & 4177.2051 & 3506.8 & 4975.7734 & 0.0129 & 0.2889 & 0.3286 & 0.0183 \tabularnewline
60 & 5725 & 4978.9423 & 4180.6796 & 5929.6259 & 0.062 & 0.4127 & 0.105 & 0.4589 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=151071&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[36])[/C][/ROW]
[ROW][C]24[/C][C]4904[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]25[/C][C]2252[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]26[/C][C]2952[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]27[/C][C]3573[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]28[/C][C]3048[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]29[/C][C]3059[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]30[/C][C]2731[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]31[/C][C]3563[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]32[/C][C]3092[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]33[/C][C]3478[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]34[/C][C]3478[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]35[/C][C]4308[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]36[/C][C]5029[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]37[/C][C]2075[/C][C]2351.4757[/C][C]2004.0469[/C][C]2759.1361[/C][C]0.0919[/C][C]0[/C][C]0.6838[/C][C]0[/C][/ROW]
[ROW][C]38[/C][C]3264[/C][C]2943.6726[/C][C]2498.4568[/C][C]3468.2242[/C][C]0.1157[/C][C]0.9994[/C][C]0.4876[/C][C]0[/C][/ROW]
[ROW][C]39[/C][C]3308[/C][C]3367.3048[/C][C]2853.6644[/C][C]3973.397[/C][C]0.424[/C][C]0.6308[/C][C]0.253[/C][C]0[/C][/ROW]
[ROW][C]40[/C][C]3688[/C][C]2821.8607[/C][C]2373.6559[/C][C]3354.6976[/C][C]7e-04[/C][C]0.0369[/C][C]0.2028[/C][C]0[/C][/ROW]
[ROW][C]41[/C][C]3136[/C][C]3042.018[/C][C]2558.2512[/C][C]3617.2654[/C][C]0.3744[/C][C]0.0139[/C][C]0.4769[/C][C]0[/C][/ROW]
[ROW][C]42[/C][C]2824[/C][C]2939.4112[/C][C]2471.6561[/C][C]3495.6878[/C][C]0.3421[/C][C]0.2443[/C][C]0.7686[/C][C]0[/C][/ROW]
[ROW][C]43[/C][C]3644[/C][C]3637.1217[/C][C]3056.2799[/C][C]4328.3518[/C][C]0.4922[/C][C]0.9894[/C][C]0.5832[/C][C]0[/C][/ROW]
[ROW][C]44[/C][C]4694[/C][C]3254.2451[/C][C]2733.6315[/C][C]3874.0084[/C][C]0[/C][C]0.1089[/C][C]0.6961[/C][C]0[/C][/ROW]
[ROW][C]45[/C][C]2914[/C][C]3490.5719[/C][C]2932.2066[/C][C]4155.264[/C][C]0.0446[/C][C]2e-04[/C][C]0.5148[/C][C]0[/C][/ROW]
[ROW][C]46[/C][C]3686[/C][C]3461.8126[/C][C]2909.1771[/C][C]4119.4281[/C][C]0.252[/C][C]0.9487[/C][C]0.4808[/C][C]0[/C][/ROW]
[ROW][C]47[/C][C]4358[/C][C]4182.8922[/C][C]3514.8392[/C][C]4977.9196[/C][C]0.333[/C][C]0.8897[/C][C]0.3789[/C][C]0.0185[/C][/ROW]
[ROW][C]48[/C][C]5587[/C][C]4972.323[/C][C]4178.9697[/C][C]5916.2899[/C][C]0.1009[/C][C]0.8989[/C][C]0.4532[/C][C]0.4532[/C][/ROW]
[ROW][C]49[/C][C]2265[/C][C]2347.8944[/C][C]1971.6677[/C][C]2795.9114[/C][C]0.3584[/C][C]0[/C][C]0.8837[/C][C]0[/C][/ROW]
[ROW][C]50[/C][C]3685[/C][C]2981.2014[/C][C]2503.2867[/C][C]3550.357[/C][C]0.0077[/C][C]0.9932[/C][C]0.1651[/C][C]0[/C][/ROW]
[ROW][C]51[/C][C]3754[/C][C]3363.5462[/C][C]2824.3163[/C][C]4005.7282[/C][C]0.1167[/C][C]0.1633[/C][C]0.5673[/C][C]0[/C][/ROW]
[ROW][C]52[/C][C]3708[/C][C]2823.2486[/C][C]2369.1651[/C][C]3364.3636[/C][C]7e-04[/C][C]4e-04[/C][C]9e-04[/C][C]0[/C][/ROW]
[ROW][C]53[/C][C]3210[/C][C]3026.5662[/C][C]2539.6296[/C][C]3606.8658[/C][C]0.2678[/C][C]0.0107[/C][C]0.3558[/C][C]0[/C][/ROW]
[ROW][C]54[/C][C]3517[/C][C]2947.2438[/C][C]2473.1386[/C][C]3512.2359[/C][C]0.024[/C][C]0.181[/C][C]0.6655[/C][C]0[/C][/ROW]
[ROW][C]55[/C][C]3905[/C][C]3633.0215[/C][C]3048.4878[/C][C]4329.6368[/C][C]0.2221[/C][C]0.628[/C][C]0.4877[/C][C]0[/C][/ROW]
[ROW][C]56[/C][C]3670[/C][C]3261.9153[/C][C]2736.9605[/C][C]3887.5577[/C][C]0.1005[/C][C]0.022[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]57[/C][C]4221[/C][C]3483.5203[/C][C]2922.9522[/C][C]4151.595[/C][C]0.0152[/C][C]0.2922[/C][C]0.9526[/C][C]0[/C][/ROW]
[ROW][C]58[/C][C]4404[/C][C]3466.0444[/C][C]2909.6563[/C][C]4128.8257[/C][C]0.0028[/C][C]0.0128[/C][C]0.2577[/C][C]0[/C][/ROW]
[ROW][C]59[/C][C]5086[/C][C]4177.2051[/C][C]3506.8[/C][C]4975.7734[/C][C]0.0129[/C][C]0.2889[/C][C]0.3286[/C][C]0.0183[/C][/ROW]
[ROW][C]60[/C][C]5725[/C][C]4978.9423[/C][C]4180.6796[/C][C]5929.6259[/C][C]0.062[/C][C]0.4127[/C][C]0.105[/C][C]0.4589[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=151071&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=151071&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[36])
244904-------
252252-------
262952-------
273573-------
283048-------
293059-------
302731-------
313563-------
323092-------
333478-------
343478-------
354308-------
365029-------
3720752351.47572004.04692759.13610.091900.68380
3832642943.67262498.45683468.22420.11570.99940.48760
3933083367.30482853.66443973.3970.4240.63080.2530
4036882821.86072373.65593354.69767e-040.03690.20280
4131363042.0182558.25123617.26540.37440.01390.47690
4228242939.41122471.65613495.68780.34210.24430.76860
4336443637.12173056.27994328.35180.49220.98940.58320
4446943254.24512733.63153874.008400.10890.69610
4529143490.57192932.20664155.2640.04462e-040.51480
4636863461.81262909.17714119.42810.2520.94870.48080
4743584182.89223514.83924977.91960.3330.88970.37890.0185
4855874972.3234178.96975916.28990.10090.89890.45320.4532
4922652347.89441971.66772795.91140.358400.88370
5036852981.20142503.28673550.3570.00770.99320.16510
5137543363.54622824.31634005.72820.11670.16330.56730
5237082823.24862369.16513364.36367e-044e-049e-040
5332103026.56622539.62963606.86580.26780.01070.35580
5435172947.24382473.13863512.23590.0240.1810.66550
5539053633.02153048.48784329.63680.22210.6280.48770
5636703261.91532736.96053887.55770.10050.02200
5742213483.52032922.95224151.5950.01520.29220.95260
5844043466.04442909.65634128.82570.00280.01280.25770
5950864177.20513506.84975.77340.01290.28890.32860.0183
6057254978.94234180.67965929.62590.0620.41270.1050.4589







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
370.0885-0.1176076438.823700
380.09090.10880.1132102609.656589524.2401299.206
390.0918-0.01760.08133517.058260855.1795246.6884
400.09630.30690.1377750197.3542233190.7232482.8983
410.09650.03090.11648832.6202188319.1026433.9575
420.0966-0.03930.103513319.7501159152.5438398.9393
430.0970.00190.08947.3107136423.2248369.3551
440.09720.44240.13322072894.0771378482.0813615.209
450.0972-0.16520.1367332435.2046373365.7617611.0366
460.09690.06480.129550260.0065341055.1862583.9993
470.0970.04190.121630662.749312837.6919559.319
480.09690.12360.1217377827.7782318253.5324564.1396
490.0974-0.03530.11516871.4838294301.0671542.4952
500.09740.23610.1237495332.525308660.457555.5722
510.09740.11610.1232152454.1435298246.7027546.1197
520.09780.31340.1351782785.0053328530.3467573.1757
530.09780.06060.130733647.9538311184.3235557.839
540.09780.19330.1342324622.1164311930.8676558.5077
550.09780.07490.131173972.3265299406.7339547.1807
560.09790.12510.1308166533.0894292763.0516541.0758
570.09780.21170.1346543876.3071304720.8257552.0152
580.09760.27060.1408879760.7302330859.0032575.2034
590.09750.21760.1442825908.259352382.8839593.6185
600.09740.14980.1444556602.1306360892.0192600.7429

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
37 & 0.0885 & -0.1176 & 0 & 76438.8237 & 0 & 0 \tabularnewline
38 & 0.0909 & 0.1088 & 0.1132 & 102609.6565 & 89524.2401 & 299.206 \tabularnewline
39 & 0.0918 & -0.0176 & 0.0813 & 3517.0582 & 60855.1795 & 246.6884 \tabularnewline
40 & 0.0963 & 0.3069 & 0.1377 & 750197.3542 & 233190.7232 & 482.8983 \tabularnewline
41 & 0.0965 & 0.0309 & 0.1164 & 8832.6202 & 188319.1026 & 433.9575 \tabularnewline
42 & 0.0966 & -0.0393 & 0.1035 & 13319.7501 & 159152.5438 & 398.9393 \tabularnewline
43 & 0.097 & 0.0019 & 0.089 & 47.3107 & 136423.2248 & 369.3551 \tabularnewline
44 & 0.0972 & 0.4424 & 0.1332 & 2072894.0771 & 378482.0813 & 615.209 \tabularnewline
45 & 0.0972 & -0.1652 & 0.1367 & 332435.2046 & 373365.7617 & 611.0366 \tabularnewline
46 & 0.0969 & 0.0648 & 0.1295 & 50260.0065 & 341055.1862 & 583.9993 \tabularnewline
47 & 0.097 & 0.0419 & 0.1216 & 30662.749 & 312837.6919 & 559.319 \tabularnewline
48 & 0.0969 & 0.1236 & 0.1217 & 377827.7782 & 318253.5324 & 564.1396 \tabularnewline
49 & 0.0974 & -0.0353 & 0.1151 & 6871.4838 & 294301.0671 & 542.4952 \tabularnewline
50 & 0.0974 & 0.2361 & 0.1237 & 495332.525 & 308660.457 & 555.5722 \tabularnewline
51 & 0.0974 & 0.1161 & 0.1232 & 152454.1435 & 298246.7027 & 546.1197 \tabularnewline
52 & 0.0978 & 0.3134 & 0.1351 & 782785.0053 & 328530.3467 & 573.1757 \tabularnewline
53 & 0.0978 & 0.0606 & 0.1307 & 33647.9538 & 311184.3235 & 557.839 \tabularnewline
54 & 0.0978 & 0.1933 & 0.1342 & 324622.1164 & 311930.8676 & 558.5077 \tabularnewline
55 & 0.0978 & 0.0749 & 0.1311 & 73972.3265 & 299406.7339 & 547.1807 \tabularnewline
56 & 0.0979 & 0.1251 & 0.1308 & 166533.0894 & 292763.0516 & 541.0758 \tabularnewline
57 & 0.0978 & 0.2117 & 0.1346 & 543876.3071 & 304720.8257 & 552.0152 \tabularnewline
58 & 0.0976 & 0.2706 & 0.1408 & 879760.7302 & 330859.0032 & 575.2034 \tabularnewline
59 & 0.0975 & 0.2176 & 0.1442 & 825908.259 & 352382.8839 & 593.6185 \tabularnewline
60 & 0.0974 & 0.1498 & 0.1444 & 556602.1306 & 360892.0192 & 600.7429 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=151071&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]37[/C][C]0.0885[/C][C]-0.1176[/C][C]0[/C][C]76438.8237[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]38[/C][C]0.0909[/C][C]0.1088[/C][C]0.1132[/C][C]102609.6565[/C][C]89524.2401[/C][C]299.206[/C][/ROW]
[ROW][C]39[/C][C]0.0918[/C][C]-0.0176[/C][C]0.0813[/C][C]3517.0582[/C][C]60855.1795[/C][C]246.6884[/C][/ROW]
[ROW][C]40[/C][C]0.0963[/C][C]0.3069[/C][C]0.1377[/C][C]750197.3542[/C][C]233190.7232[/C][C]482.8983[/C][/ROW]
[ROW][C]41[/C][C]0.0965[/C][C]0.0309[/C][C]0.1164[/C][C]8832.6202[/C][C]188319.1026[/C][C]433.9575[/C][/ROW]
[ROW][C]42[/C][C]0.0966[/C][C]-0.0393[/C][C]0.1035[/C][C]13319.7501[/C][C]159152.5438[/C][C]398.9393[/C][/ROW]
[ROW][C]43[/C][C]0.097[/C][C]0.0019[/C][C]0.089[/C][C]47.3107[/C][C]136423.2248[/C][C]369.3551[/C][/ROW]
[ROW][C]44[/C][C]0.0972[/C][C]0.4424[/C][C]0.1332[/C][C]2072894.0771[/C][C]378482.0813[/C][C]615.209[/C][/ROW]
[ROW][C]45[/C][C]0.0972[/C][C]-0.1652[/C][C]0.1367[/C][C]332435.2046[/C][C]373365.7617[/C][C]611.0366[/C][/ROW]
[ROW][C]46[/C][C]0.0969[/C][C]0.0648[/C][C]0.1295[/C][C]50260.0065[/C][C]341055.1862[/C][C]583.9993[/C][/ROW]
[ROW][C]47[/C][C]0.097[/C][C]0.0419[/C][C]0.1216[/C][C]30662.749[/C][C]312837.6919[/C][C]559.319[/C][/ROW]
[ROW][C]48[/C][C]0.0969[/C][C]0.1236[/C][C]0.1217[/C][C]377827.7782[/C][C]318253.5324[/C][C]564.1396[/C][/ROW]
[ROW][C]49[/C][C]0.0974[/C][C]-0.0353[/C][C]0.1151[/C][C]6871.4838[/C][C]294301.0671[/C][C]542.4952[/C][/ROW]
[ROW][C]50[/C][C]0.0974[/C][C]0.2361[/C][C]0.1237[/C][C]495332.525[/C][C]308660.457[/C][C]555.5722[/C][/ROW]
[ROW][C]51[/C][C]0.0974[/C][C]0.1161[/C][C]0.1232[/C][C]152454.1435[/C][C]298246.7027[/C][C]546.1197[/C][/ROW]
[ROW][C]52[/C][C]0.0978[/C][C]0.3134[/C][C]0.1351[/C][C]782785.0053[/C][C]328530.3467[/C][C]573.1757[/C][/ROW]
[ROW][C]53[/C][C]0.0978[/C][C]0.0606[/C][C]0.1307[/C][C]33647.9538[/C][C]311184.3235[/C][C]557.839[/C][/ROW]
[ROW][C]54[/C][C]0.0978[/C][C]0.1933[/C][C]0.1342[/C][C]324622.1164[/C][C]311930.8676[/C][C]558.5077[/C][/ROW]
[ROW][C]55[/C][C]0.0978[/C][C]0.0749[/C][C]0.1311[/C][C]73972.3265[/C][C]299406.7339[/C][C]547.1807[/C][/ROW]
[ROW][C]56[/C][C]0.0979[/C][C]0.1251[/C][C]0.1308[/C][C]166533.0894[/C][C]292763.0516[/C][C]541.0758[/C][/ROW]
[ROW][C]57[/C][C]0.0978[/C][C]0.2117[/C][C]0.1346[/C][C]543876.3071[/C][C]304720.8257[/C][C]552.0152[/C][/ROW]
[ROW][C]58[/C][C]0.0976[/C][C]0.2706[/C][C]0.1408[/C][C]879760.7302[/C][C]330859.0032[/C][C]575.2034[/C][/ROW]
[ROW][C]59[/C][C]0.0975[/C][C]0.2176[/C][C]0.1442[/C][C]825908.259[/C][C]352382.8839[/C][C]593.6185[/C][/ROW]
[ROW][C]60[/C][C]0.0974[/C][C]0.1498[/C][C]0.1444[/C][C]556602.1306[/C][C]360892.0192[/C][C]600.7429[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=151071&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=151071&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
370.0885-0.1176076438.823700
380.09090.10880.1132102609.656589524.2401299.206
390.0918-0.01760.08133517.058260855.1795246.6884
400.09630.30690.1377750197.3542233190.7232482.8983
410.09650.03090.11648832.6202188319.1026433.9575
420.0966-0.03930.103513319.7501159152.5438398.9393
430.0970.00190.08947.3107136423.2248369.3551
440.09720.44240.13322072894.0771378482.0813615.209
450.0972-0.16520.1367332435.2046373365.7617611.0366
460.09690.06480.129550260.0065341055.1862583.9993
470.0970.04190.121630662.749312837.6919559.319
480.09690.12360.1217377827.7782318253.5324564.1396
490.0974-0.03530.11516871.4838294301.0671542.4952
500.09740.23610.1237495332.525308660.457555.5722
510.09740.11610.1232152454.1435298246.7027546.1197
520.09780.31340.1351782785.0053328530.3467573.1757
530.09780.06060.130733647.9538311184.3235557.839
540.09780.19330.1342324622.1164311930.8676558.5077
550.09780.07490.131173972.3265299406.7339547.1807
560.09790.12510.1308166533.0894292763.0516541.0758
570.09780.21170.1346543876.3071304720.8257552.0152
580.09760.27060.1408879760.7302330859.0032575.2034
590.09750.21760.1442825908.259352382.8839593.6185
600.09740.14980.1444556602.1306360892.0192600.7429



Parameters (Session):
par1 = 24 ; par2 = 0.0 ; par3 = 0 ; par4 = 1 ; par5 = 12 ; par6 = 3 ; par7 = 1 ; par8 = 0 ; par9 = 1 ; par10 = FALSE ;
Parameters (R input):
par1 = 24 ; par2 = 0.0 ; par3 = 0 ; par4 = 1 ; par5 = 12 ; par6 = 3 ; par7 = 1 ; 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
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')