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 computationMon, 05 Dec 2011 13:09:59 -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/t13231086497bx63sow1qkgy3o.htm/, Retrieved Fri, 03 May 2024 10:23:43 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=151133, Retrieved Fri, 03 May 2024 10:23:43 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact138
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [ARIMA Backward Selection] [] [2011-12-02 08:01:34] [ee8c3a74bf3b349877806e9a50913c60]
-       [ARIMA Backward Selection] [Werkloosheid Nede...] [2011-12-02 08:30:12] [ee8c3a74bf3b349877806e9a50913c60]
- RMPD      [ARIMA Forecasting] [WS9 Wine Sales Au...] [2011-12-05 18:09:59] [2a6d487209befbc7c5ce02a41ecac161] [Current]
- R P         [ARIMA Forecasting] [WS9 Wine Sales Au...] [2011-12-05 18:48:24] [9d4f280afcb4ecc352d7c6f913a0a151]
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 time2 seconds
R Server'AstonUniversity' @ aston.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 & 2 seconds \tabularnewline
R Server & 'AstonUniversity' @ aston.wessa.net \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=151133&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]2 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'AstonUniversity' @ aston.wessa.net[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=151133&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=151133&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 time2 seconds
R Server'AstonUniversity' @ aston.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-------
3720752337.17161963.04092782.60680.124300.64610
3832643005.10652524.05393577.84160.18780.99930.57210
3933083347.21462811.39793985.15120.45210.60090.24390
4036882836.61362382.53313377.23610.0010.04370.22170
4131363011.72652529.61413585.72330.33570.01050.43590
4228242963.91822489.4593528.80340.31370.27520.79050
4336443606.32213029.02794293.64130.45720.98720.54920
4446943272.12982748.33253895.756100.12130.71430
4529143469.88742914.43344131.20380.04971e-040.49040
4636863518.35782955.14484188.91210.31210.96130.5470
4743584162.33973496.03914955.62880.31440.88040.35950.0161
4855874937.89744147.44675878.99790.08820.88640.42480.4248
4922652337.17161963.04092782.60680.375400.87570
5036853005.10652524.05393577.84160.010.99430.18780
5137543347.21462811.39793985.15120.10570.14970.54790
5237082836.61362382.53313377.23618e-044e-040.0010
5332103011.72652529.61413585.72330.24920.00870.33570
5435172963.91822489.4593528.80340.02750.19660.68630
5539053606.32213029.02794293.64130.19720.60050.45720
5636703272.12982748.33253895.75610.10560.023300
5742213469.88742914.43344131.20380.0130.27660.95030
5844043518.35782955.14484188.91210.00480.020.31210
5950864162.33973496.03914955.62880.01120.27520.31440.0161
6057254937.89744147.44675878.99790.05060.37890.08820.4248

\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 & 2337.1716 & 1963.0409 & 2782.6068 & 0.1243 & 0 & 0.6461 & 0 \tabularnewline
38 & 3264 & 3005.1065 & 2524.0539 & 3577.8416 & 0.1878 & 0.9993 & 0.5721 & 0 \tabularnewline
39 & 3308 & 3347.2146 & 2811.3979 & 3985.1512 & 0.4521 & 0.6009 & 0.2439 & 0 \tabularnewline
40 & 3688 & 2836.6136 & 2382.5331 & 3377.2361 & 0.001 & 0.0437 & 0.2217 & 0 \tabularnewline
41 & 3136 & 3011.7265 & 2529.6141 & 3585.7233 & 0.3357 & 0.0105 & 0.4359 & 0 \tabularnewline
42 & 2824 & 2963.9182 & 2489.459 & 3528.8034 & 0.3137 & 0.2752 & 0.7905 & 0 \tabularnewline
43 & 3644 & 3606.3221 & 3029.0279 & 4293.6413 & 0.4572 & 0.9872 & 0.5492 & 0 \tabularnewline
44 & 4694 & 3272.1298 & 2748.3325 & 3895.7561 & 0 & 0.1213 & 0.7143 & 0 \tabularnewline
45 & 2914 & 3469.8874 & 2914.4334 & 4131.2038 & 0.0497 & 1e-04 & 0.4904 & 0 \tabularnewline
46 & 3686 & 3518.3578 & 2955.1448 & 4188.9121 & 0.3121 & 0.9613 & 0.547 & 0 \tabularnewline
47 & 4358 & 4162.3397 & 3496.0391 & 4955.6288 & 0.3144 & 0.8804 & 0.3595 & 0.0161 \tabularnewline
48 & 5587 & 4937.8974 & 4147.4467 & 5878.9979 & 0.0882 & 0.8864 & 0.4248 & 0.4248 \tabularnewline
49 & 2265 & 2337.1716 & 1963.0409 & 2782.6068 & 0.3754 & 0 & 0.8757 & 0 \tabularnewline
50 & 3685 & 3005.1065 & 2524.0539 & 3577.8416 & 0.01 & 0.9943 & 0.1878 & 0 \tabularnewline
51 & 3754 & 3347.2146 & 2811.3979 & 3985.1512 & 0.1057 & 0.1497 & 0.5479 & 0 \tabularnewline
52 & 3708 & 2836.6136 & 2382.5331 & 3377.2361 & 8e-04 & 4e-04 & 0.001 & 0 \tabularnewline
53 & 3210 & 3011.7265 & 2529.6141 & 3585.7233 & 0.2492 & 0.0087 & 0.3357 & 0 \tabularnewline
54 & 3517 & 2963.9182 & 2489.459 & 3528.8034 & 0.0275 & 0.1966 & 0.6863 & 0 \tabularnewline
55 & 3905 & 3606.3221 & 3029.0279 & 4293.6413 & 0.1972 & 0.6005 & 0.4572 & 0 \tabularnewline
56 & 3670 & 3272.1298 & 2748.3325 & 3895.7561 & 0.1056 & 0.0233 & 0 & 0 \tabularnewline
57 & 4221 & 3469.8874 & 2914.4334 & 4131.2038 & 0.013 & 0.2766 & 0.9503 & 0 \tabularnewline
58 & 4404 & 3518.3578 & 2955.1448 & 4188.9121 & 0.0048 & 0.02 & 0.3121 & 0 \tabularnewline
59 & 5086 & 4162.3397 & 3496.0391 & 4955.6288 & 0.0112 & 0.2752 & 0.3144 & 0.0161 \tabularnewline
60 & 5725 & 4937.8974 & 4147.4467 & 5878.9979 & 0.0506 & 0.3789 & 0.0882 & 0.4248 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=151133&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]2337.1716[/C][C]1963.0409[/C][C]2782.6068[/C][C]0.1243[/C][C]0[/C][C]0.6461[/C][C]0[/C][/ROW]
[ROW][C]38[/C][C]3264[/C][C]3005.1065[/C][C]2524.0539[/C][C]3577.8416[/C][C]0.1878[/C][C]0.9993[/C][C]0.5721[/C][C]0[/C][/ROW]
[ROW][C]39[/C][C]3308[/C][C]3347.2146[/C][C]2811.3979[/C][C]3985.1512[/C][C]0.4521[/C][C]0.6009[/C][C]0.2439[/C][C]0[/C][/ROW]
[ROW][C]40[/C][C]3688[/C][C]2836.6136[/C][C]2382.5331[/C][C]3377.2361[/C][C]0.001[/C][C]0.0437[/C][C]0.2217[/C][C]0[/C][/ROW]
[ROW][C]41[/C][C]3136[/C][C]3011.7265[/C][C]2529.6141[/C][C]3585.7233[/C][C]0.3357[/C][C]0.0105[/C][C]0.4359[/C][C]0[/C][/ROW]
[ROW][C]42[/C][C]2824[/C][C]2963.9182[/C][C]2489.459[/C][C]3528.8034[/C][C]0.3137[/C][C]0.2752[/C][C]0.7905[/C][C]0[/C][/ROW]
[ROW][C]43[/C][C]3644[/C][C]3606.3221[/C][C]3029.0279[/C][C]4293.6413[/C][C]0.4572[/C][C]0.9872[/C][C]0.5492[/C][C]0[/C][/ROW]
[ROW][C]44[/C][C]4694[/C][C]3272.1298[/C][C]2748.3325[/C][C]3895.7561[/C][C]0[/C][C]0.1213[/C][C]0.7143[/C][C]0[/C][/ROW]
[ROW][C]45[/C][C]2914[/C][C]3469.8874[/C][C]2914.4334[/C][C]4131.2038[/C][C]0.0497[/C][C]1e-04[/C][C]0.4904[/C][C]0[/C][/ROW]
[ROW][C]46[/C][C]3686[/C][C]3518.3578[/C][C]2955.1448[/C][C]4188.9121[/C][C]0.3121[/C][C]0.9613[/C][C]0.547[/C][C]0[/C][/ROW]
[ROW][C]47[/C][C]4358[/C][C]4162.3397[/C][C]3496.0391[/C][C]4955.6288[/C][C]0.3144[/C][C]0.8804[/C][C]0.3595[/C][C]0.0161[/C][/ROW]
[ROW][C]48[/C][C]5587[/C][C]4937.8974[/C][C]4147.4467[/C][C]5878.9979[/C][C]0.0882[/C][C]0.8864[/C][C]0.4248[/C][C]0.4248[/C][/ROW]
[ROW][C]49[/C][C]2265[/C][C]2337.1716[/C][C]1963.0409[/C][C]2782.6068[/C][C]0.3754[/C][C]0[/C][C]0.8757[/C][C]0[/C][/ROW]
[ROW][C]50[/C][C]3685[/C][C]3005.1065[/C][C]2524.0539[/C][C]3577.8416[/C][C]0.01[/C][C]0.9943[/C][C]0.1878[/C][C]0[/C][/ROW]
[ROW][C]51[/C][C]3754[/C][C]3347.2146[/C][C]2811.3979[/C][C]3985.1512[/C][C]0.1057[/C][C]0.1497[/C][C]0.5479[/C][C]0[/C][/ROW]
[ROW][C]52[/C][C]3708[/C][C]2836.6136[/C][C]2382.5331[/C][C]3377.2361[/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]3011.7265[/C][C]2529.6141[/C][C]3585.7233[/C][C]0.2492[/C][C]0.0087[/C][C]0.3357[/C][C]0[/C][/ROW]
[ROW][C]54[/C][C]3517[/C][C]2963.9182[/C][C]2489.459[/C][C]3528.8034[/C][C]0.0275[/C][C]0.1966[/C][C]0.6863[/C][C]0[/C][/ROW]
[ROW][C]55[/C][C]3905[/C][C]3606.3221[/C][C]3029.0279[/C][C]4293.6413[/C][C]0.1972[/C][C]0.6005[/C][C]0.4572[/C][C]0[/C][/ROW]
[ROW][C]56[/C][C]3670[/C][C]3272.1298[/C][C]2748.3325[/C][C]3895.7561[/C][C]0.1056[/C][C]0.0233[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]57[/C][C]4221[/C][C]3469.8874[/C][C]2914.4334[/C][C]4131.2038[/C][C]0.013[/C][C]0.2766[/C][C]0.9503[/C][C]0[/C][/ROW]
[ROW][C]58[/C][C]4404[/C][C]3518.3578[/C][C]2955.1448[/C][C]4188.9121[/C][C]0.0048[/C][C]0.02[/C][C]0.3121[/C][C]0[/C][/ROW]
[ROW][C]59[/C][C]5086[/C][C]4162.3397[/C][C]3496.0391[/C][C]4955.6288[/C][C]0.0112[/C][C]0.2752[/C][C]0.3144[/C][C]0.0161[/C][/ROW]
[ROW][C]60[/C][C]5725[/C][C]4937.8974[/C][C]4147.4467[/C][C]5878.9979[/C][C]0.0506[/C][C]0.3789[/C][C]0.0882[/C][C]0.4248[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=151133&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=151133&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-------
3720752337.17161963.04092782.60680.124300.64610
3832643005.10652524.05393577.84160.18780.99930.57210
3933083347.21462811.39793985.15120.45210.60090.24390
4036882836.61362382.53313377.23610.0010.04370.22170
4131363011.72652529.61413585.72330.33570.01050.43590
4228242963.91822489.4593528.80340.31370.27520.79050
4336443606.32213029.02794293.64130.45720.98720.54920
4446943272.12982748.33253895.756100.12130.71430
4529143469.88742914.43344131.20380.04971e-040.49040
4636863518.35782955.14484188.91210.31210.96130.5470
4743584162.33973496.03914955.62880.31440.88040.35950.0161
4855874937.89744147.44675878.99790.08820.88640.42480.4248
4922652337.17161963.04092782.60680.375400.87570
5036853005.10652524.05393577.84160.010.99430.18780
5137543347.21462811.39793985.15120.10570.14970.54790
5237082836.61362382.53313377.23618e-044e-040.0010
5332103011.72652529.61413585.72330.24920.00870.33570
5435172963.91822489.4593528.80340.02750.19660.68630
5539053606.32213029.02794293.64130.19720.60050.45720
5636703272.12982748.33253895.75610.10560.023300
5742213469.88742914.43344131.20380.0130.27660.95030
5844043518.35782955.14484188.91210.00480.020.31210
5950864162.33973496.03914955.62880.01120.27520.31440.0161
6057254937.89744147.44675878.99790.05060.37890.08820.4248







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
370.0972-0.1122068733.928800
380.09720.08620.099267025.867867879.8983260.5377
390.0972-0.01170.071537.783745765.8601213.9296
400.09720.30010.1275724858.793215539.0933464.2619
410.09720.04130.110315443.915175520.0577418.9511
420.0972-0.04720.099819577.1149149529.5672386.6905
430.09720.01040.0871419.6239128371.0039358.289
440.09720.43450.13052021714.921365038.9935604.1846
450.0972-0.16020.1338309010.7653358813.6348599.0105
460.09720.04760.125128103.8975325742.6611570.7387
470.09720.0470.11838282.9583299609.9609547.3664
480.09720.13150.1192421334.2183309753.649556.5552
490.0972-0.03090.11245208.7346286327.1171535.0954
500.09720.22620.1205462255.2331298893.4111546.7115
510.09720.12150.1206165474.3738289998.8086538.5154
520.09720.30720.1322759314.2488319331.0236565.0938
530.09720.06580.128339312.4003302859.3399550.3266
540.09720.18660.1316305899.4292303028.2337550.48
550.09720.08280.12989208.4862291774.5628540.1616
560.09720.12160.1286158300.7115285100.8703533.9484
570.09720.21650.1328564170.1867298389.8853546.2508
580.09720.25170.1382784362.0552320479.5294566.1091
590.09720.22190.1419853148.375343639.0444586.2073
600.09720.15940.1426619530.5429355134.5235595.9316

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
37 & 0.0972 & -0.1122 & 0 & 68733.9288 & 0 & 0 \tabularnewline
38 & 0.0972 & 0.0862 & 0.0992 & 67025.8678 & 67879.8983 & 260.5377 \tabularnewline
39 & 0.0972 & -0.0117 & 0.07 & 1537.7837 & 45765.8601 & 213.9296 \tabularnewline
40 & 0.0972 & 0.3001 & 0.1275 & 724858.793 & 215539.0933 & 464.2619 \tabularnewline
41 & 0.0972 & 0.0413 & 0.1103 & 15443.915 & 175520.0577 & 418.9511 \tabularnewline
42 & 0.0972 & -0.0472 & 0.0998 & 19577.1149 & 149529.5672 & 386.6905 \tabularnewline
43 & 0.0972 & 0.0104 & 0.087 & 1419.6239 & 128371.0039 & 358.289 \tabularnewline
44 & 0.0972 & 0.4345 & 0.1305 & 2021714.921 & 365038.9935 & 604.1846 \tabularnewline
45 & 0.0972 & -0.1602 & 0.1338 & 309010.7653 & 358813.6348 & 599.0105 \tabularnewline
46 & 0.0972 & 0.0476 & 0.1251 & 28103.8975 & 325742.6611 & 570.7387 \tabularnewline
47 & 0.0972 & 0.047 & 0.118 & 38282.9583 & 299609.9609 & 547.3664 \tabularnewline
48 & 0.0972 & 0.1315 & 0.1192 & 421334.2183 & 309753.649 & 556.5552 \tabularnewline
49 & 0.0972 & -0.0309 & 0.1124 & 5208.7346 & 286327.1171 & 535.0954 \tabularnewline
50 & 0.0972 & 0.2262 & 0.1205 & 462255.2331 & 298893.4111 & 546.7115 \tabularnewline
51 & 0.0972 & 0.1215 & 0.1206 & 165474.3738 & 289998.8086 & 538.5154 \tabularnewline
52 & 0.0972 & 0.3072 & 0.1322 & 759314.2488 & 319331.0236 & 565.0938 \tabularnewline
53 & 0.0972 & 0.0658 & 0.1283 & 39312.4003 & 302859.3399 & 550.3266 \tabularnewline
54 & 0.0972 & 0.1866 & 0.1316 & 305899.4292 & 303028.2337 & 550.48 \tabularnewline
55 & 0.0972 & 0.0828 & 0.129 & 89208.4862 & 291774.5628 & 540.1616 \tabularnewline
56 & 0.0972 & 0.1216 & 0.1286 & 158300.7115 & 285100.8703 & 533.9484 \tabularnewline
57 & 0.0972 & 0.2165 & 0.1328 & 564170.1867 & 298389.8853 & 546.2508 \tabularnewline
58 & 0.0972 & 0.2517 & 0.1382 & 784362.0552 & 320479.5294 & 566.1091 \tabularnewline
59 & 0.0972 & 0.2219 & 0.1419 & 853148.375 & 343639.0444 & 586.2073 \tabularnewline
60 & 0.0972 & 0.1594 & 0.1426 & 619530.5429 & 355134.5235 & 595.9316 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=151133&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.0972[/C][C]-0.1122[/C][C]0[/C][C]68733.9288[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]38[/C][C]0.0972[/C][C]0.0862[/C][C]0.0992[/C][C]67025.8678[/C][C]67879.8983[/C][C]260.5377[/C][/ROW]
[ROW][C]39[/C][C]0.0972[/C][C]-0.0117[/C][C]0.07[/C][C]1537.7837[/C][C]45765.8601[/C][C]213.9296[/C][/ROW]
[ROW][C]40[/C][C]0.0972[/C][C]0.3001[/C][C]0.1275[/C][C]724858.793[/C][C]215539.0933[/C][C]464.2619[/C][/ROW]
[ROW][C]41[/C][C]0.0972[/C][C]0.0413[/C][C]0.1103[/C][C]15443.915[/C][C]175520.0577[/C][C]418.9511[/C][/ROW]
[ROW][C]42[/C][C]0.0972[/C][C]-0.0472[/C][C]0.0998[/C][C]19577.1149[/C][C]149529.5672[/C][C]386.6905[/C][/ROW]
[ROW][C]43[/C][C]0.0972[/C][C]0.0104[/C][C]0.087[/C][C]1419.6239[/C][C]128371.0039[/C][C]358.289[/C][/ROW]
[ROW][C]44[/C][C]0.0972[/C][C]0.4345[/C][C]0.1305[/C][C]2021714.921[/C][C]365038.9935[/C][C]604.1846[/C][/ROW]
[ROW][C]45[/C][C]0.0972[/C][C]-0.1602[/C][C]0.1338[/C][C]309010.7653[/C][C]358813.6348[/C][C]599.0105[/C][/ROW]
[ROW][C]46[/C][C]0.0972[/C][C]0.0476[/C][C]0.1251[/C][C]28103.8975[/C][C]325742.6611[/C][C]570.7387[/C][/ROW]
[ROW][C]47[/C][C]0.0972[/C][C]0.047[/C][C]0.118[/C][C]38282.9583[/C][C]299609.9609[/C][C]547.3664[/C][/ROW]
[ROW][C]48[/C][C]0.0972[/C][C]0.1315[/C][C]0.1192[/C][C]421334.2183[/C][C]309753.649[/C][C]556.5552[/C][/ROW]
[ROW][C]49[/C][C]0.0972[/C][C]-0.0309[/C][C]0.1124[/C][C]5208.7346[/C][C]286327.1171[/C][C]535.0954[/C][/ROW]
[ROW][C]50[/C][C]0.0972[/C][C]0.2262[/C][C]0.1205[/C][C]462255.2331[/C][C]298893.4111[/C][C]546.7115[/C][/ROW]
[ROW][C]51[/C][C]0.0972[/C][C]0.1215[/C][C]0.1206[/C][C]165474.3738[/C][C]289998.8086[/C][C]538.5154[/C][/ROW]
[ROW][C]52[/C][C]0.0972[/C][C]0.3072[/C][C]0.1322[/C][C]759314.2488[/C][C]319331.0236[/C][C]565.0938[/C][/ROW]
[ROW][C]53[/C][C]0.0972[/C][C]0.0658[/C][C]0.1283[/C][C]39312.4003[/C][C]302859.3399[/C][C]550.3266[/C][/ROW]
[ROW][C]54[/C][C]0.0972[/C][C]0.1866[/C][C]0.1316[/C][C]305899.4292[/C][C]303028.2337[/C][C]550.48[/C][/ROW]
[ROW][C]55[/C][C]0.0972[/C][C]0.0828[/C][C]0.129[/C][C]89208.4862[/C][C]291774.5628[/C][C]540.1616[/C][/ROW]
[ROW][C]56[/C][C]0.0972[/C][C]0.1216[/C][C]0.1286[/C][C]158300.7115[/C][C]285100.8703[/C][C]533.9484[/C][/ROW]
[ROW][C]57[/C][C]0.0972[/C][C]0.2165[/C][C]0.1328[/C][C]564170.1867[/C][C]298389.8853[/C][C]546.2508[/C][/ROW]
[ROW][C]58[/C][C]0.0972[/C][C]0.2517[/C][C]0.1382[/C][C]784362.0552[/C][C]320479.5294[/C][C]566.1091[/C][/ROW]
[ROW][C]59[/C][C]0.0972[/C][C]0.2219[/C][C]0.1419[/C][C]853148.375[/C][C]343639.0444[/C][C]586.2073[/C][/ROW]
[ROW][C]60[/C][C]0.0972[/C][C]0.1594[/C][C]0.1426[/C][C]619530.5429[/C][C]355134.5235[/C][C]595.9316[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=151133&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=151133&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.0972-0.1122068733.928800
380.09720.08620.099267025.867867879.8983260.5377
390.0972-0.01170.071537.783745765.8601213.9296
400.09720.30010.1275724858.793215539.0933464.2619
410.09720.04130.110315443.915175520.0577418.9511
420.0972-0.04720.099819577.1149149529.5672386.6905
430.09720.01040.0871419.6239128371.0039358.289
440.09720.43450.13052021714.921365038.9935604.1846
450.0972-0.16020.1338309010.7653358813.6348599.0105
460.09720.04760.125128103.8975325742.6611570.7387
470.09720.0470.11838282.9583299609.9609547.3664
480.09720.13150.1192421334.2183309753.649556.5552
490.0972-0.03090.11245208.7346286327.1171535.0954
500.09720.22620.1205462255.2331298893.4111546.7115
510.09720.12150.1206165474.3738289998.8086538.5154
520.09720.30720.1322759314.2488319331.0236565.0938
530.09720.06580.128339312.4003302859.3399550.3266
540.09720.18660.1316305899.4292303028.2337550.48
550.09720.08280.12989208.4862291774.5628540.1616
560.09720.12160.1286158300.7115285100.8703533.9484
570.09720.21650.1328564170.1867298389.8853546.2508
580.09720.25170.1382784362.0552320479.5294566.1091
590.09720.22190.1419853148.375343639.0444586.2073
600.09720.15940.1426619530.5429355134.5235595.9316



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