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 computationFri, 02 Dec 2011 10:13:11 -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/02/t13228389458o93478vt5c2o10.htm/, Retrieved Mon, 29 Apr 2024 00:32:37 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=150289, Retrieved Mon, 29 Apr 2024 00:32:37 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact113
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] [2a6d487209befbc7c5ce02a41ecac161] [Current]
- R P         [ARIMA Forecasting] [WS9 Wine Sales Au...] [2011-12-05 16:50:19] [74be16979710d4c4e7c6647856088456]
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 time1 seconds
R Server'Gwilym Jenkins' @ jenkins.wessa.net

\begin{tabular}{lllllllll}
\hline
Summary of computational transaction \tabularnewline
Raw Input & view raw input (R code)  \tabularnewline
Raw Output & view raw output of R engine  \tabularnewline
Computing time & 1 seconds \tabularnewline
R Server & 'Gwilym Jenkins' @ jenkins.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=150289&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]1 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'Gwilym Jenkins' @ jenkins.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=150289&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=150289&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 time1 seconds
R Server'Gwilym Jenkins' @ jenkins.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-------
3720752309.87831962.44932718.81550.130100.60930
3832642975.09722517.92583515.27560.14730.99950.53340
3933083342.81762818.29953964.95460.45630.59810.23420
4036882844.13242390.45753383.90840.00110.04610.22960
4131363016.82422535.43723589.60910.34170.01080.44260
4228242964.91072491.2083528.68790.31210.2760.79190
4336443609.13153032.12794295.93670.46040.98750.55240
4446943275.82932752.1563899.145800.12350.71840
4529143463.82882910.0684122.96550.0511e-040.48320
4636863494.48462936.37134158.67780.2860.95660.51940
4743584139.15343478.89614924.72040.29250.87090.33680.0132
4855874990.92714195.74295936.81590.10840.90520.46860.4686
4922652330.34621958.93292772.17950.38600.87130
5036852997.7522519.39883566.92920.0090.99420.17960
5137543346.06472811.45953982.32630.10440.14820.54670
5237082837.85322383.98513378.12978e-044e-040.0010
5332103012.1122530.36693585.57430.24940.00870.3360
5435172964.73812490.53093529.23610.02760.19720.68750
5539053611.05653033.47124298.61650.2010.60570.46260
5636703276.85652752.76833900.72360.10840.024200
5742213463.75662909.78474123.1950.01220.26990.94890
5844043494.04852935.79374158.45810.00360.0160.28560
5950864138.90133478.43074924.77940.00910.25430.29240.0132
6057254990.98564195.49485937.30610.06420.4220.10850.4686

\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 & 2309.8783 & 1962.4493 & 2718.8155 & 0.1301 & 0 & 0.6093 & 0 \tabularnewline
38 & 3264 & 2975.0972 & 2517.9258 & 3515.2756 & 0.1473 & 0.9995 & 0.5334 & 0 \tabularnewline
39 & 3308 & 3342.8176 & 2818.2995 & 3964.9546 & 0.4563 & 0.5981 & 0.2342 & 0 \tabularnewline
40 & 3688 & 2844.1324 & 2390.4575 & 3383.9084 & 0.0011 & 0.0461 & 0.2296 & 0 \tabularnewline
41 & 3136 & 3016.8242 & 2535.4372 & 3589.6091 & 0.3417 & 0.0108 & 0.4426 & 0 \tabularnewline
42 & 2824 & 2964.9107 & 2491.208 & 3528.6879 & 0.3121 & 0.276 & 0.7919 & 0 \tabularnewline
43 & 3644 & 3609.1315 & 3032.1279 & 4295.9367 & 0.4604 & 0.9875 & 0.5524 & 0 \tabularnewline
44 & 4694 & 3275.8293 & 2752.156 & 3899.1458 & 0 & 0.1235 & 0.7184 & 0 \tabularnewline
45 & 2914 & 3463.8288 & 2910.068 & 4122.9655 & 0.051 & 1e-04 & 0.4832 & 0 \tabularnewline
46 & 3686 & 3494.4846 & 2936.3713 & 4158.6778 & 0.286 & 0.9566 & 0.5194 & 0 \tabularnewline
47 & 4358 & 4139.1534 & 3478.8961 & 4924.7204 & 0.2925 & 0.8709 & 0.3368 & 0.0132 \tabularnewline
48 & 5587 & 4990.9271 & 4195.7429 & 5936.8159 & 0.1084 & 0.9052 & 0.4686 & 0.4686 \tabularnewline
49 & 2265 & 2330.3462 & 1958.9329 & 2772.1795 & 0.386 & 0 & 0.8713 & 0 \tabularnewline
50 & 3685 & 2997.752 & 2519.3988 & 3566.9292 & 0.009 & 0.9942 & 0.1796 & 0 \tabularnewline
51 & 3754 & 3346.0647 & 2811.4595 & 3982.3263 & 0.1044 & 0.1482 & 0.5467 & 0 \tabularnewline
52 & 3708 & 2837.8532 & 2383.9851 & 3378.1297 & 8e-04 & 4e-04 & 0.001 & 0 \tabularnewline
53 & 3210 & 3012.112 & 2530.3669 & 3585.5743 & 0.2494 & 0.0087 & 0.336 & 0 \tabularnewline
54 & 3517 & 2964.7381 & 2490.5309 & 3529.2361 & 0.0276 & 0.1972 & 0.6875 & 0 \tabularnewline
55 & 3905 & 3611.0565 & 3033.4712 & 4298.6165 & 0.201 & 0.6057 & 0.4626 & 0 \tabularnewline
56 & 3670 & 3276.8565 & 2752.7683 & 3900.7236 & 0.1084 & 0.0242 & 0 & 0 \tabularnewline
57 & 4221 & 3463.7566 & 2909.7847 & 4123.195 & 0.0122 & 0.2699 & 0.9489 & 0 \tabularnewline
58 & 4404 & 3494.0485 & 2935.7937 & 4158.4581 & 0.0036 & 0.016 & 0.2856 & 0 \tabularnewline
59 & 5086 & 4138.9013 & 3478.4307 & 4924.7794 & 0.0091 & 0.2543 & 0.2924 & 0.0132 \tabularnewline
60 & 5725 & 4990.9856 & 4195.4948 & 5937.3061 & 0.0642 & 0.422 & 0.1085 & 0.4686 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=150289&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]2309.8783[/C][C]1962.4493[/C][C]2718.8155[/C][C]0.1301[/C][C]0[/C][C]0.6093[/C][C]0[/C][/ROW]
[ROW][C]38[/C][C]3264[/C][C]2975.0972[/C][C]2517.9258[/C][C]3515.2756[/C][C]0.1473[/C][C]0.9995[/C][C]0.5334[/C][C]0[/C][/ROW]
[ROW][C]39[/C][C]3308[/C][C]3342.8176[/C][C]2818.2995[/C][C]3964.9546[/C][C]0.4563[/C][C]0.5981[/C][C]0.2342[/C][C]0[/C][/ROW]
[ROW][C]40[/C][C]3688[/C][C]2844.1324[/C][C]2390.4575[/C][C]3383.9084[/C][C]0.0011[/C][C]0.0461[/C][C]0.2296[/C][C]0[/C][/ROW]
[ROW][C]41[/C][C]3136[/C][C]3016.8242[/C][C]2535.4372[/C][C]3589.6091[/C][C]0.3417[/C][C]0.0108[/C][C]0.4426[/C][C]0[/C][/ROW]
[ROW][C]42[/C][C]2824[/C][C]2964.9107[/C][C]2491.208[/C][C]3528.6879[/C][C]0.3121[/C][C]0.276[/C][C]0.7919[/C][C]0[/C][/ROW]
[ROW][C]43[/C][C]3644[/C][C]3609.1315[/C][C]3032.1279[/C][C]4295.9367[/C][C]0.4604[/C][C]0.9875[/C][C]0.5524[/C][C]0[/C][/ROW]
[ROW][C]44[/C][C]4694[/C][C]3275.8293[/C][C]2752.156[/C][C]3899.1458[/C][C]0[/C][C]0.1235[/C][C]0.7184[/C][C]0[/C][/ROW]
[ROW][C]45[/C][C]2914[/C][C]3463.8288[/C][C]2910.068[/C][C]4122.9655[/C][C]0.051[/C][C]1e-04[/C][C]0.4832[/C][C]0[/C][/ROW]
[ROW][C]46[/C][C]3686[/C][C]3494.4846[/C][C]2936.3713[/C][C]4158.6778[/C][C]0.286[/C][C]0.9566[/C][C]0.5194[/C][C]0[/C][/ROW]
[ROW][C]47[/C][C]4358[/C][C]4139.1534[/C][C]3478.8961[/C][C]4924.7204[/C][C]0.2925[/C][C]0.8709[/C][C]0.3368[/C][C]0.0132[/C][/ROW]
[ROW][C]48[/C][C]5587[/C][C]4990.9271[/C][C]4195.7429[/C][C]5936.8159[/C][C]0.1084[/C][C]0.9052[/C][C]0.4686[/C][C]0.4686[/C][/ROW]
[ROW][C]49[/C][C]2265[/C][C]2330.3462[/C][C]1958.9329[/C][C]2772.1795[/C][C]0.386[/C][C]0[/C][C]0.8713[/C][C]0[/C][/ROW]
[ROW][C]50[/C][C]3685[/C][C]2997.752[/C][C]2519.3988[/C][C]3566.9292[/C][C]0.009[/C][C]0.9942[/C][C]0.1796[/C][C]0[/C][/ROW]
[ROW][C]51[/C][C]3754[/C][C]3346.0647[/C][C]2811.4595[/C][C]3982.3263[/C][C]0.1044[/C][C]0.1482[/C][C]0.5467[/C][C]0[/C][/ROW]
[ROW][C]52[/C][C]3708[/C][C]2837.8532[/C][C]2383.9851[/C][C]3378.1297[/C][C]8e-04[/C][C]4e-04[/C][C]0.001[/C][C]0[/C][/ROW]
[ROW][C]53[/C][C]3210[/C][C]3012.112[/C][C]2530.3669[/C][C]3585.5743[/C][C]0.2494[/C][C]0.0087[/C][C]0.336[/C][C]0[/C][/ROW]
[ROW][C]54[/C][C]3517[/C][C]2964.7381[/C][C]2490.5309[/C][C]3529.2361[/C][C]0.0276[/C][C]0.1972[/C][C]0.6875[/C][C]0[/C][/ROW]
[ROW][C]55[/C][C]3905[/C][C]3611.0565[/C][C]3033.4712[/C][C]4298.6165[/C][C]0.201[/C][C]0.6057[/C][C]0.4626[/C][C]0[/C][/ROW]
[ROW][C]56[/C][C]3670[/C][C]3276.8565[/C][C]2752.7683[/C][C]3900.7236[/C][C]0.1084[/C][C]0.0242[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]57[/C][C]4221[/C][C]3463.7566[/C][C]2909.7847[/C][C]4123.195[/C][C]0.0122[/C][C]0.2699[/C][C]0.9489[/C][C]0[/C][/ROW]
[ROW][C]58[/C][C]4404[/C][C]3494.0485[/C][C]2935.7937[/C][C]4158.4581[/C][C]0.0036[/C][C]0.016[/C][C]0.2856[/C][C]0[/C][/ROW]
[ROW][C]59[/C][C]5086[/C][C]4138.9013[/C][C]3478.4307[/C][C]4924.7794[/C][C]0.0091[/C][C]0.2543[/C][C]0.2924[/C][C]0.0132[/C][/ROW]
[ROW][C]60[/C][C]5725[/C][C]4990.9856[/C][C]4195.4948[/C][C]5937.3061[/C][C]0.0642[/C][C]0.422[/C][C]0.1085[/C][C]0.4686[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=150289&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=150289&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-------
3720752309.87831962.44932718.81550.130100.60930
3832642975.09722517.92583515.27560.14730.99950.53340
3933083342.81762818.29953964.95460.45630.59810.23420
4036882844.13242390.45753383.90840.00110.04610.22960
4131363016.82422535.43723589.60910.34170.01080.44260
4228242964.91072491.2083528.68790.31210.2760.79190
4336443609.13153032.12794295.93670.46040.98750.55240
4446943275.82932752.1563899.145800.12350.71840
4529143463.82882910.0684122.96550.0511e-040.48320
4636863494.48462936.37134158.67780.2860.95660.51940
4743584139.15343478.89614924.72040.29250.87090.33680.0132
4855874990.92714195.74295936.81590.10840.90520.46860.4686
4922652330.34621958.93292772.17950.38600.87130
5036852997.7522519.39883566.92920.0090.99420.17960
5137543346.06472811.45953982.32630.10440.14820.54670
5237082837.85322383.98513378.12978e-044e-040.0010
5332103012.1122530.36693585.57430.24940.00870.3360
5435172964.73812490.53093529.23610.02760.19720.68750
5539053611.05653033.47124298.61650.2010.60570.46260
5636703276.85652752.76833900.72360.10840.024200
5742213463.75662909.78474123.1950.01220.26990.94890
5844043494.04852935.79374158.45810.00360.0160.28560
5950864138.90133478.43074924.77940.00910.25430.29240.0132
6057254990.98564195.49485937.30610.06420.4220.10850.4686







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
370.0903-0.1017055167.818500
380.09260.09710.099483464.847669316.333263.28
390.095-0.01040.06971212.264646614.9769215.905
400.09680.29670.1265712112.4692212989.35461.5077
410.09690.03950.109114202.8621173232.0524416.2115
420.097-0.04750.098819855.8282147669.3484384.2777
430.09710.00970.08611215.8156126747.4151356.016
440.09710.43290.12942011208.1733362305.0099601.9178
450.0971-0.15870.1327302311.7024355639.0868596.3548
460.0970.05480.124936678.1628323742.9944568.9842
470.09680.05290.118447893.8473298665.7992546.5032
480.09670.11940.1184355302.9095303385.5584550.8045
490.0967-0.0280.11154270.1298280376.6793529.5061
500.09690.22930.1199472309.7624294086.1852542.2971
510.0970.12190.12166411.2015285574.5197534.3917
520.09710.30660.1317757155.477315048.3295561.2917
530.09710.06570.127839159.6766298819.5852546.6439
540.09710.18630.1311304993.2476299162.5665546.9576
550.09710.08140.128586402.7687287964.6824536.6234
560.09710.120.128154561.848281294.5406530.3721
570.09710.21860.1323573417.6169295205.1633543.3279
580.0970.26040.1382828011.6831319423.6415565.1758
590.09690.22880.1421896995.9353344535.4804586.9714
600.09670.14710.1423538777.1832352628.8846593.8256

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
37 & 0.0903 & -0.1017 & 0 & 55167.8185 & 0 & 0 \tabularnewline
38 & 0.0926 & 0.0971 & 0.0994 & 83464.8476 & 69316.333 & 263.28 \tabularnewline
39 & 0.095 & -0.0104 & 0.0697 & 1212.2646 & 46614.9769 & 215.905 \tabularnewline
40 & 0.0968 & 0.2967 & 0.1265 & 712112.4692 & 212989.35 & 461.5077 \tabularnewline
41 & 0.0969 & 0.0395 & 0.1091 & 14202.8621 & 173232.0524 & 416.2115 \tabularnewline
42 & 0.097 & -0.0475 & 0.0988 & 19855.8282 & 147669.3484 & 384.2777 \tabularnewline
43 & 0.0971 & 0.0097 & 0.0861 & 1215.8156 & 126747.4151 & 356.016 \tabularnewline
44 & 0.0971 & 0.4329 & 0.1294 & 2011208.1733 & 362305.0099 & 601.9178 \tabularnewline
45 & 0.0971 & -0.1587 & 0.1327 & 302311.7024 & 355639.0868 & 596.3548 \tabularnewline
46 & 0.097 & 0.0548 & 0.1249 & 36678.1628 & 323742.9944 & 568.9842 \tabularnewline
47 & 0.0968 & 0.0529 & 0.1184 & 47893.8473 & 298665.7992 & 546.5032 \tabularnewline
48 & 0.0967 & 0.1194 & 0.1184 & 355302.9095 & 303385.5584 & 550.8045 \tabularnewline
49 & 0.0967 & -0.028 & 0.1115 & 4270.1298 & 280376.6793 & 529.5061 \tabularnewline
50 & 0.0969 & 0.2293 & 0.1199 & 472309.7624 & 294086.1852 & 542.2971 \tabularnewline
51 & 0.097 & 0.1219 & 0.12 & 166411.2015 & 285574.5197 & 534.3917 \tabularnewline
52 & 0.0971 & 0.3066 & 0.1317 & 757155.477 & 315048.3295 & 561.2917 \tabularnewline
53 & 0.0971 & 0.0657 & 0.1278 & 39159.6766 & 298819.5852 & 546.6439 \tabularnewline
54 & 0.0971 & 0.1863 & 0.1311 & 304993.2476 & 299162.5665 & 546.9576 \tabularnewline
55 & 0.0971 & 0.0814 & 0.1285 & 86402.7687 & 287964.6824 & 536.6234 \tabularnewline
56 & 0.0971 & 0.12 & 0.128 & 154561.848 & 281294.5406 & 530.3721 \tabularnewline
57 & 0.0971 & 0.2186 & 0.1323 & 573417.6169 & 295205.1633 & 543.3279 \tabularnewline
58 & 0.097 & 0.2604 & 0.1382 & 828011.6831 & 319423.6415 & 565.1758 \tabularnewline
59 & 0.0969 & 0.2288 & 0.1421 & 896995.9353 & 344535.4804 & 586.9714 \tabularnewline
60 & 0.0967 & 0.1471 & 0.1423 & 538777.1832 & 352628.8846 & 593.8256 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=150289&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.0903[/C][C]-0.1017[/C][C]0[/C][C]55167.8185[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]38[/C][C]0.0926[/C][C]0.0971[/C][C]0.0994[/C][C]83464.8476[/C][C]69316.333[/C][C]263.28[/C][/ROW]
[ROW][C]39[/C][C]0.095[/C][C]-0.0104[/C][C]0.0697[/C][C]1212.2646[/C][C]46614.9769[/C][C]215.905[/C][/ROW]
[ROW][C]40[/C][C]0.0968[/C][C]0.2967[/C][C]0.1265[/C][C]712112.4692[/C][C]212989.35[/C][C]461.5077[/C][/ROW]
[ROW][C]41[/C][C]0.0969[/C][C]0.0395[/C][C]0.1091[/C][C]14202.8621[/C][C]173232.0524[/C][C]416.2115[/C][/ROW]
[ROW][C]42[/C][C]0.097[/C][C]-0.0475[/C][C]0.0988[/C][C]19855.8282[/C][C]147669.3484[/C][C]384.2777[/C][/ROW]
[ROW][C]43[/C][C]0.0971[/C][C]0.0097[/C][C]0.0861[/C][C]1215.8156[/C][C]126747.4151[/C][C]356.016[/C][/ROW]
[ROW][C]44[/C][C]0.0971[/C][C]0.4329[/C][C]0.1294[/C][C]2011208.1733[/C][C]362305.0099[/C][C]601.9178[/C][/ROW]
[ROW][C]45[/C][C]0.0971[/C][C]-0.1587[/C][C]0.1327[/C][C]302311.7024[/C][C]355639.0868[/C][C]596.3548[/C][/ROW]
[ROW][C]46[/C][C]0.097[/C][C]0.0548[/C][C]0.1249[/C][C]36678.1628[/C][C]323742.9944[/C][C]568.9842[/C][/ROW]
[ROW][C]47[/C][C]0.0968[/C][C]0.0529[/C][C]0.1184[/C][C]47893.8473[/C][C]298665.7992[/C][C]546.5032[/C][/ROW]
[ROW][C]48[/C][C]0.0967[/C][C]0.1194[/C][C]0.1184[/C][C]355302.9095[/C][C]303385.5584[/C][C]550.8045[/C][/ROW]
[ROW][C]49[/C][C]0.0967[/C][C]-0.028[/C][C]0.1115[/C][C]4270.1298[/C][C]280376.6793[/C][C]529.5061[/C][/ROW]
[ROW][C]50[/C][C]0.0969[/C][C]0.2293[/C][C]0.1199[/C][C]472309.7624[/C][C]294086.1852[/C][C]542.2971[/C][/ROW]
[ROW][C]51[/C][C]0.097[/C][C]0.1219[/C][C]0.12[/C][C]166411.2015[/C][C]285574.5197[/C][C]534.3917[/C][/ROW]
[ROW][C]52[/C][C]0.0971[/C][C]0.3066[/C][C]0.1317[/C][C]757155.477[/C][C]315048.3295[/C][C]561.2917[/C][/ROW]
[ROW][C]53[/C][C]0.0971[/C][C]0.0657[/C][C]0.1278[/C][C]39159.6766[/C][C]298819.5852[/C][C]546.6439[/C][/ROW]
[ROW][C]54[/C][C]0.0971[/C][C]0.1863[/C][C]0.1311[/C][C]304993.2476[/C][C]299162.5665[/C][C]546.9576[/C][/ROW]
[ROW][C]55[/C][C]0.0971[/C][C]0.0814[/C][C]0.1285[/C][C]86402.7687[/C][C]287964.6824[/C][C]536.6234[/C][/ROW]
[ROW][C]56[/C][C]0.0971[/C][C]0.12[/C][C]0.128[/C][C]154561.848[/C][C]281294.5406[/C][C]530.3721[/C][/ROW]
[ROW][C]57[/C][C]0.0971[/C][C]0.2186[/C][C]0.1323[/C][C]573417.6169[/C][C]295205.1633[/C][C]543.3279[/C][/ROW]
[ROW][C]58[/C][C]0.097[/C][C]0.2604[/C][C]0.1382[/C][C]828011.6831[/C][C]319423.6415[/C][C]565.1758[/C][/ROW]
[ROW][C]59[/C][C]0.0969[/C][C]0.2288[/C][C]0.1421[/C][C]896995.9353[/C][C]344535.4804[/C][C]586.9714[/C][/ROW]
[ROW][C]60[/C][C]0.0967[/C][C]0.1471[/C][C]0.1423[/C][C]538777.1832[/C][C]352628.8846[/C][C]593.8256[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=150289&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=150289&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.0903-0.1017055167.818500
380.09260.09710.099483464.847669316.333263.28
390.095-0.01040.06971212.264646614.9769215.905
400.09680.29670.1265712112.4692212989.35461.5077
410.09690.03950.109114202.8621173232.0524416.2115
420.097-0.04750.098819855.8282147669.3484384.2777
430.09710.00970.08611215.8156126747.4151356.016
440.09710.43290.12942011208.1733362305.0099601.9178
450.0971-0.15870.1327302311.7024355639.0868596.3548
460.0970.05480.124936678.1628323742.9944568.9842
470.09680.05290.118447893.8473298665.7992546.5032
480.09670.11940.1184355302.9095303385.5584550.8045
490.0967-0.0280.11154270.1298280376.6793529.5061
500.09690.22930.1199472309.7624294086.1852542.2971
510.0970.12190.12166411.2015285574.5197534.3917
520.09710.30660.1317757155.477315048.3295561.2917
530.09710.06570.127839159.6766298819.5852546.6439
540.09710.18630.1311304993.2476299162.5665546.9576
550.09710.08140.128586402.7687287964.6824536.6234
560.09710.120.128154561.848281294.5406530.3721
570.09710.21860.1323573417.6169295205.1633543.3279
580.0970.26040.1382828011.6831319423.6415565.1758
590.09690.22880.1421896995.9353344535.4804586.9714
600.09670.14710.1423538777.1832352628.8846593.8256



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