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 computationSun, 18 Dec 2016 18:59:23 +0100
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2016/Dec/18/t1482084084rtutyhl21q6r32n.htm/, Retrieved Wed, 08 May 2024 07:00:37 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=301205, Retrieved Wed, 08 May 2024 07:00:37 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact71
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-       [ARIMA Forecasting] [] [2016-12-18 17:59:23] [9ac947b5174fcc9cd01e144b03ceb277] [Current]
Feedback Forum

Post a new message
Dataseries X:
7984
7937
7821
7749
7785
7632
7533
7536
7470
7367
7246
7150
7050
6907
6803
6626
6512
6509
6419
6365
6395
6360
6386
6360
6259
6198
6103
6064
5968
5908
5805
5728
5678
5274
5166
5106
5008
5034
4901
4853
4790
4703
4640
4544
4465
4335
4345
4246
4131
4112
4111
4096
3970
3970
3908
3861
3819
3781
3684
3664
3648
3564
3490




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

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

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

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

As an alternative you can also use a QR Code:  

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

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







Univariate ARIMA Extrapolation Forecast
timeY[t]F[t]95% LB95% UBp-value(H0: Y[t] = F[t])P(F[t]>Y[t-1])P(F[t]>Y[t-s])P(F[t]>Y[45])
335678-------
345274-------
355166-------
365106-------
375008-------
385034-------
394901-------
404853-------
414790-------
424703-------
434640-------
444544-------
454465-------
4643354396.69254263.88544529.49950.18130.156700.1567
4743454331.68824091.76484571.61160.45670.489200.1381
4842464280.08733943.2884616.88660.42140.352800.1409
4941314230.84913760.00144701.69690.33880.47496e-040.1649
5041124188.90113603.44314774.3590.39840.57690.00230.1777
5141114152.80823440.85624864.76010.45420.54470.01970.195
5240964119.20663280.07294958.34030.47840.50760.04330.2096
5339704091.53193131.39475051.66920.4020.49640.0770.2229
5439704066.02892979.46555152.59230.43120.56880.12530.2359
5539084043.89142837.17615250.60660.41270.54780.16650.247
5638614024.82072698.185351.46140.40440.56850.22150.2577
5738194007.37022562.50285452.23760.39920.57870.26740.2674
5837813992.64342433.56655551.72040.39510.58640.33350.2763
5936843979.35292306.8435651.86280.36460.59190.33410.2846
6036643967.70642185.34945750.06340.36920.62250.37980.2922
6136483957.63852067.62835847.64870.37410.61960.42870.2994
6235643948.54331953.12625943.96030.35280.61610.43620.306
6334903940.74551842.87426038.61680.33680.63760.43680.3121

\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[45]) \tabularnewline
33 & 5678 & - & - & - & - & - & - & - \tabularnewline
34 & 5274 & - & - & - & - & - & - & - \tabularnewline
35 & 5166 & - & - & - & - & - & - & - \tabularnewline
36 & 5106 & - & - & - & - & - & - & - \tabularnewline
37 & 5008 & - & - & - & - & - & - & - \tabularnewline
38 & 5034 & - & - & - & - & - & - & - \tabularnewline
39 & 4901 & - & - & - & - & - & - & - \tabularnewline
40 & 4853 & - & - & - & - & - & - & - \tabularnewline
41 & 4790 & - & - & - & - & - & - & - \tabularnewline
42 & 4703 & - & - & - & - & - & - & - \tabularnewline
43 & 4640 & - & - & - & - & - & - & - \tabularnewline
44 & 4544 & - & - & - & - & - & - & - \tabularnewline
45 & 4465 & - & - & - & - & - & - & - \tabularnewline
46 & 4335 & 4396.6925 & 4263.8854 & 4529.4995 & 0.1813 & 0.1567 & 0 & 0.1567 \tabularnewline
47 & 4345 & 4331.6882 & 4091.7648 & 4571.6116 & 0.4567 & 0.4892 & 0 & 0.1381 \tabularnewline
48 & 4246 & 4280.0873 & 3943.288 & 4616.8866 & 0.4214 & 0.3528 & 0 & 0.1409 \tabularnewline
49 & 4131 & 4230.8491 & 3760.0014 & 4701.6969 & 0.3388 & 0.4749 & 6e-04 & 0.1649 \tabularnewline
50 & 4112 & 4188.9011 & 3603.4431 & 4774.359 & 0.3984 & 0.5769 & 0.0023 & 0.1777 \tabularnewline
51 & 4111 & 4152.8082 & 3440.8562 & 4864.7601 & 0.4542 & 0.5447 & 0.0197 & 0.195 \tabularnewline
52 & 4096 & 4119.2066 & 3280.0729 & 4958.3403 & 0.4784 & 0.5076 & 0.0433 & 0.2096 \tabularnewline
53 & 3970 & 4091.5319 & 3131.3947 & 5051.6692 & 0.402 & 0.4964 & 0.077 & 0.2229 \tabularnewline
54 & 3970 & 4066.0289 & 2979.4655 & 5152.5923 & 0.4312 & 0.5688 & 0.1253 & 0.2359 \tabularnewline
55 & 3908 & 4043.8914 & 2837.1761 & 5250.6066 & 0.4127 & 0.5478 & 0.1665 & 0.247 \tabularnewline
56 & 3861 & 4024.8207 & 2698.18 & 5351.4614 & 0.4044 & 0.5685 & 0.2215 & 0.2577 \tabularnewline
57 & 3819 & 4007.3702 & 2562.5028 & 5452.2376 & 0.3992 & 0.5787 & 0.2674 & 0.2674 \tabularnewline
58 & 3781 & 3992.6434 & 2433.5665 & 5551.7204 & 0.3951 & 0.5864 & 0.3335 & 0.2763 \tabularnewline
59 & 3684 & 3979.3529 & 2306.843 & 5651.8628 & 0.3646 & 0.5919 & 0.3341 & 0.2846 \tabularnewline
60 & 3664 & 3967.7064 & 2185.3494 & 5750.0634 & 0.3692 & 0.6225 & 0.3798 & 0.2922 \tabularnewline
61 & 3648 & 3957.6385 & 2067.6283 & 5847.6487 & 0.3741 & 0.6196 & 0.4287 & 0.2994 \tabularnewline
62 & 3564 & 3948.5433 & 1953.1262 & 5943.9603 & 0.3528 & 0.6161 & 0.4362 & 0.306 \tabularnewline
63 & 3490 & 3940.7455 & 1842.8742 & 6038.6168 & 0.3368 & 0.6376 & 0.4368 & 0.3121 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=301205&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[45])[/C][/ROW]
[ROW][C]33[/C][C]5678[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]34[/C][C]5274[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]35[/C][C]5166[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]36[/C][C]5106[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]37[/C][C]5008[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]38[/C][C]5034[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]39[/C][C]4901[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]40[/C][C]4853[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]41[/C][C]4790[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]42[/C][C]4703[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]43[/C][C]4640[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]44[/C][C]4544[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]45[/C][C]4465[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]46[/C][C]4335[/C][C]4396.6925[/C][C]4263.8854[/C][C]4529.4995[/C][C]0.1813[/C][C]0.1567[/C][C]0[/C][C]0.1567[/C][/ROW]
[ROW][C]47[/C][C]4345[/C][C]4331.6882[/C][C]4091.7648[/C][C]4571.6116[/C][C]0.4567[/C][C]0.4892[/C][C]0[/C][C]0.1381[/C][/ROW]
[ROW][C]48[/C][C]4246[/C][C]4280.0873[/C][C]3943.288[/C][C]4616.8866[/C][C]0.4214[/C][C]0.3528[/C][C]0[/C][C]0.1409[/C][/ROW]
[ROW][C]49[/C][C]4131[/C][C]4230.8491[/C][C]3760.0014[/C][C]4701.6969[/C][C]0.3388[/C][C]0.4749[/C][C]6e-04[/C][C]0.1649[/C][/ROW]
[ROW][C]50[/C][C]4112[/C][C]4188.9011[/C][C]3603.4431[/C][C]4774.359[/C][C]0.3984[/C][C]0.5769[/C][C]0.0023[/C][C]0.1777[/C][/ROW]
[ROW][C]51[/C][C]4111[/C][C]4152.8082[/C][C]3440.8562[/C][C]4864.7601[/C][C]0.4542[/C][C]0.5447[/C][C]0.0197[/C][C]0.195[/C][/ROW]
[ROW][C]52[/C][C]4096[/C][C]4119.2066[/C][C]3280.0729[/C][C]4958.3403[/C][C]0.4784[/C][C]0.5076[/C][C]0.0433[/C][C]0.2096[/C][/ROW]
[ROW][C]53[/C][C]3970[/C][C]4091.5319[/C][C]3131.3947[/C][C]5051.6692[/C][C]0.402[/C][C]0.4964[/C][C]0.077[/C][C]0.2229[/C][/ROW]
[ROW][C]54[/C][C]3970[/C][C]4066.0289[/C][C]2979.4655[/C][C]5152.5923[/C][C]0.4312[/C][C]0.5688[/C][C]0.1253[/C][C]0.2359[/C][/ROW]
[ROW][C]55[/C][C]3908[/C][C]4043.8914[/C][C]2837.1761[/C][C]5250.6066[/C][C]0.4127[/C][C]0.5478[/C][C]0.1665[/C][C]0.247[/C][/ROW]
[ROW][C]56[/C][C]3861[/C][C]4024.8207[/C][C]2698.18[/C][C]5351.4614[/C][C]0.4044[/C][C]0.5685[/C][C]0.2215[/C][C]0.2577[/C][/ROW]
[ROW][C]57[/C][C]3819[/C][C]4007.3702[/C][C]2562.5028[/C][C]5452.2376[/C][C]0.3992[/C][C]0.5787[/C][C]0.2674[/C][C]0.2674[/C][/ROW]
[ROW][C]58[/C][C]3781[/C][C]3992.6434[/C][C]2433.5665[/C][C]5551.7204[/C][C]0.3951[/C][C]0.5864[/C][C]0.3335[/C][C]0.2763[/C][/ROW]
[ROW][C]59[/C][C]3684[/C][C]3979.3529[/C][C]2306.843[/C][C]5651.8628[/C][C]0.3646[/C][C]0.5919[/C][C]0.3341[/C][C]0.2846[/C][/ROW]
[ROW][C]60[/C][C]3664[/C][C]3967.7064[/C][C]2185.3494[/C][C]5750.0634[/C][C]0.3692[/C][C]0.6225[/C][C]0.3798[/C][C]0.2922[/C][/ROW]
[ROW][C]61[/C][C]3648[/C][C]3957.6385[/C][C]2067.6283[/C][C]5847.6487[/C][C]0.3741[/C][C]0.6196[/C][C]0.4287[/C][C]0.2994[/C][/ROW]
[ROW][C]62[/C][C]3564[/C][C]3948.5433[/C][C]1953.1262[/C][C]5943.9603[/C][C]0.3528[/C][C]0.6161[/C][C]0.4362[/C][C]0.306[/C][/ROW]
[ROW][C]63[/C][C]3490[/C][C]3940.7455[/C][C]1842.8742[/C][C]6038.6168[/C][C]0.3368[/C][C]0.6376[/C][C]0.4368[/C][C]0.3121[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=301205&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=301205&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[45])
335678-------
345274-------
355166-------
365106-------
375008-------
385034-------
394901-------
404853-------
414790-------
424703-------
434640-------
444544-------
454465-------
4643354396.69254263.88544529.49950.18130.156700.1567
4743454331.68824091.76484571.61160.45670.489200.1381
4842464280.08733943.2884616.88660.42140.352800.1409
4941314230.84913760.00144701.69690.33880.47496e-040.1649
5041124188.90113603.44314774.3590.39840.57690.00230.1777
5141114152.80823440.85624864.76010.45420.54470.01970.195
5240964119.20663280.07294958.34030.47840.50760.04330.2096
5339704091.53193131.39475051.66920.4020.49640.0770.2229
5439704066.02892979.46555152.59230.43120.56880.12530.2359
5539084043.89142837.17615250.60660.41270.54780.16650.247
5638614024.82072698.185351.46140.40440.56850.22150.2577
5738194007.37022562.50285452.23760.39920.57870.26740.2674
5837813992.64342433.56655551.72040.39510.58640.33350.2763
5936843979.35292306.8435651.86280.36460.59190.33410.2846
6036643967.70642185.34945750.06340.36920.62250.37980.2922
6136483957.63852067.62835847.64870.37410.61960.42870.2994
6235643948.54331953.12625943.96030.35280.61610.43620.306
6334903940.74551842.87426038.61680.33680.63760.43680.3121







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPEsMAPESq.EMSERMSEScaledEMASE
460.0154-0.01420.01420.01413805.961600-1.21251.2125
470.02830.00310.00860.0086177.20331991.582444.62710.26160.737
480.0401-0.0080.00840.00841161.94681715.037241.413-0.66990.7147
490.0568-0.02420.01240.01239969.85033778.740561.4715-1.96241.0266
500.0713-0.01870.01360.01355913.77344205.747164.8517-1.51141.1235
510.0875-0.01020.01310.0131747.92273796.109761.6126-0.82171.0732
520.1039-0.00570.0120.0119538.54653330.743557.7126-0.45610.9851
530.1197-0.03060.01430.014214770.00524760.651268.9975-2.38851.1605
540.1363-0.02420.01540.01539221.55055256.306772.5004-1.88731.2412
550.1522-0.03480.01740.017218466.46096577.322181.1007-2.67071.3842
560.1682-0.04240.01960.019426837.22518419.131591.7558-3.21961.551
570.184-0.04930.02210.021835483.323910674.4808103.3174-3.70211.7303
580.1992-0.0560.02470.024344792.948213298.9783115.3212-4.15951.9172
590.2144-0.08020.02870.028187233.342718580.0044136.3085-5.80462.1948
600.2292-0.08290.03230.031592237.570423490.5088153.2661-5.96882.4464
610.2437-0.08490.03560.034695876.004228014.6022167.3756-6.08542.6739
620.2578-0.10790.03980.0386147873.512435065.1264187.2568-7.55752.9611
630.2716-0.12920.04480.0432203171.500544404.3694210.7234-8.85863.2888

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & sMAPE & Sq.E & MSE & RMSE & ScaledE & MASE \tabularnewline
46 & 0.0154 & -0.0142 & 0.0142 & 0.0141 & 3805.9616 & 0 & 0 & -1.2125 & 1.2125 \tabularnewline
47 & 0.0283 & 0.0031 & 0.0086 & 0.0086 & 177.2033 & 1991.5824 & 44.6271 & 0.2616 & 0.737 \tabularnewline
48 & 0.0401 & -0.008 & 0.0084 & 0.0084 & 1161.9468 & 1715.0372 & 41.413 & -0.6699 & 0.7147 \tabularnewline
49 & 0.0568 & -0.0242 & 0.0124 & 0.0123 & 9969.8503 & 3778.7405 & 61.4715 & -1.9624 & 1.0266 \tabularnewline
50 & 0.0713 & -0.0187 & 0.0136 & 0.0135 & 5913.7734 & 4205.7471 & 64.8517 & -1.5114 & 1.1235 \tabularnewline
51 & 0.0875 & -0.0102 & 0.0131 & 0.013 & 1747.9227 & 3796.1097 & 61.6126 & -0.8217 & 1.0732 \tabularnewline
52 & 0.1039 & -0.0057 & 0.012 & 0.0119 & 538.5465 & 3330.7435 & 57.7126 & -0.4561 & 0.9851 \tabularnewline
53 & 0.1197 & -0.0306 & 0.0143 & 0.0142 & 14770.0052 & 4760.6512 & 68.9975 & -2.3885 & 1.1605 \tabularnewline
54 & 0.1363 & -0.0242 & 0.0154 & 0.0153 & 9221.5505 & 5256.3067 & 72.5004 & -1.8873 & 1.2412 \tabularnewline
55 & 0.1522 & -0.0348 & 0.0174 & 0.0172 & 18466.4609 & 6577.3221 & 81.1007 & -2.6707 & 1.3842 \tabularnewline
56 & 0.1682 & -0.0424 & 0.0196 & 0.0194 & 26837.2251 & 8419.1315 & 91.7558 & -3.2196 & 1.551 \tabularnewline
57 & 0.184 & -0.0493 & 0.0221 & 0.0218 & 35483.3239 & 10674.4808 & 103.3174 & -3.7021 & 1.7303 \tabularnewline
58 & 0.1992 & -0.056 & 0.0247 & 0.0243 & 44792.9482 & 13298.9783 & 115.3212 & -4.1595 & 1.9172 \tabularnewline
59 & 0.2144 & -0.0802 & 0.0287 & 0.0281 & 87233.3427 & 18580.0044 & 136.3085 & -5.8046 & 2.1948 \tabularnewline
60 & 0.2292 & -0.0829 & 0.0323 & 0.0315 & 92237.5704 & 23490.5088 & 153.2661 & -5.9688 & 2.4464 \tabularnewline
61 & 0.2437 & -0.0849 & 0.0356 & 0.0346 & 95876.0042 & 28014.6022 & 167.3756 & -6.0854 & 2.6739 \tabularnewline
62 & 0.2578 & -0.1079 & 0.0398 & 0.0386 & 147873.5124 & 35065.1264 & 187.2568 & -7.5575 & 2.9611 \tabularnewline
63 & 0.2716 & -0.1292 & 0.0448 & 0.0432 & 203171.5005 & 44404.3694 & 210.7234 & -8.8586 & 3.2888 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=301205&T=2

[TABLE]
[ROW][C]Univariate ARIMA Extrapolation Forecast Performance[/C][/ROW]
[ROW][C]time[/C][C]% S.E.[/C][C]PE[/C][C]MAPE[/C][C]sMAPE[/C][C]Sq.E[/C][C]MSE[/C][C]RMSE[/C][C]ScaledE[/C][C]MASE[/C][/ROW]
[ROW][C]46[/C][C]0.0154[/C][C]-0.0142[/C][C]0.0142[/C][C]0.0141[/C][C]3805.9616[/C][C]0[/C][C]0[/C][C]-1.2125[/C][C]1.2125[/C][/ROW]
[ROW][C]47[/C][C]0.0283[/C][C]0.0031[/C][C]0.0086[/C][C]0.0086[/C][C]177.2033[/C][C]1991.5824[/C][C]44.6271[/C][C]0.2616[/C][C]0.737[/C][/ROW]
[ROW][C]48[/C][C]0.0401[/C][C]-0.008[/C][C]0.0084[/C][C]0.0084[/C][C]1161.9468[/C][C]1715.0372[/C][C]41.413[/C][C]-0.6699[/C][C]0.7147[/C][/ROW]
[ROW][C]49[/C][C]0.0568[/C][C]-0.0242[/C][C]0.0124[/C][C]0.0123[/C][C]9969.8503[/C][C]3778.7405[/C][C]61.4715[/C][C]-1.9624[/C][C]1.0266[/C][/ROW]
[ROW][C]50[/C][C]0.0713[/C][C]-0.0187[/C][C]0.0136[/C][C]0.0135[/C][C]5913.7734[/C][C]4205.7471[/C][C]64.8517[/C][C]-1.5114[/C][C]1.1235[/C][/ROW]
[ROW][C]51[/C][C]0.0875[/C][C]-0.0102[/C][C]0.0131[/C][C]0.013[/C][C]1747.9227[/C][C]3796.1097[/C][C]61.6126[/C][C]-0.8217[/C][C]1.0732[/C][/ROW]
[ROW][C]52[/C][C]0.1039[/C][C]-0.0057[/C][C]0.012[/C][C]0.0119[/C][C]538.5465[/C][C]3330.7435[/C][C]57.7126[/C][C]-0.4561[/C][C]0.9851[/C][/ROW]
[ROW][C]53[/C][C]0.1197[/C][C]-0.0306[/C][C]0.0143[/C][C]0.0142[/C][C]14770.0052[/C][C]4760.6512[/C][C]68.9975[/C][C]-2.3885[/C][C]1.1605[/C][/ROW]
[ROW][C]54[/C][C]0.1363[/C][C]-0.0242[/C][C]0.0154[/C][C]0.0153[/C][C]9221.5505[/C][C]5256.3067[/C][C]72.5004[/C][C]-1.8873[/C][C]1.2412[/C][/ROW]
[ROW][C]55[/C][C]0.1522[/C][C]-0.0348[/C][C]0.0174[/C][C]0.0172[/C][C]18466.4609[/C][C]6577.3221[/C][C]81.1007[/C][C]-2.6707[/C][C]1.3842[/C][/ROW]
[ROW][C]56[/C][C]0.1682[/C][C]-0.0424[/C][C]0.0196[/C][C]0.0194[/C][C]26837.2251[/C][C]8419.1315[/C][C]91.7558[/C][C]-3.2196[/C][C]1.551[/C][/ROW]
[ROW][C]57[/C][C]0.184[/C][C]-0.0493[/C][C]0.0221[/C][C]0.0218[/C][C]35483.3239[/C][C]10674.4808[/C][C]103.3174[/C][C]-3.7021[/C][C]1.7303[/C][/ROW]
[ROW][C]58[/C][C]0.1992[/C][C]-0.056[/C][C]0.0247[/C][C]0.0243[/C][C]44792.9482[/C][C]13298.9783[/C][C]115.3212[/C][C]-4.1595[/C][C]1.9172[/C][/ROW]
[ROW][C]59[/C][C]0.2144[/C][C]-0.0802[/C][C]0.0287[/C][C]0.0281[/C][C]87233.3427[/C][C]18580.0044[/C][C]136.3085[/C][C]-5.8046[/C][C]2.1948[/C][/ROW]
[ROW][C]60[/C][C]0.2292[/C][C]-0.0829[/C][C]0.0323[/C][C]0.0315[/C][C]92237.5704[/C][C]23490.5088[/C][C]153.2661[/C][C]-5.9688[/C][C]2.4464[/C][/ROW]
[ROW][C]61[/C][C]0.2437[/C][C]-0.0849[/C][C]0.0356[/C][C]0.0346[/C][C]95876.0042[/C][C]28014.6022[/C][C]167.3756[/C][C]-6.0854[/C][C]2.6739[/C][/ROW]
[ROW][C]62[/C][C]0.2578[/C][C]-0.1079[/C][C]0.0398[/C][C]0.0386[/C][C]147873.5124[/C][C]35065.1264[/C][C]187.2568[/C][C]-7.5575[/C][C]2.9611[/C][/ROW]
[ROW][C]63[/C][C]0.2716[/C][C]-0.1292[/C][C]0.0448[/C][C]0.0432[/C][C]203171.5005[/C][C]44404.3694[/C][C]210.7234[/C][C]-8.8586[/C][C]3.2888[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=301205&T=2

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

As an alternative you can also use a QR Code:  

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

Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPEsMAPESq.EMSERMSEScaledEMASE
460.0154-0.01420.01420.01413805.961600-1.21251.2125
470.02830.00310.00860.0086177.20331991.582444.62710.26160.737
480.0401-0.0080.00840.00841161.94681715.037241.413-0.66990.7147
490.0568-0.02420.01240.01239969.85033778.740561.4715-1.96241.0266
500.0713-0.01870.01360.01355913.77344205.747164.8517-1.51141.1235
510.0875-0.01020.01310.0131747.92273796.109761.6126-0.82171.0732
520.1039-0.00570.0120.0119538.54653330.743557.7126-0.45610.9851
530.1197-0.03060.01430.014214770.00524760.651268.9975-2.38851.1605
540.1363-0.02420.01540.01539221.55055256.306772.5004-1.88731.2412
550.1522-0.03480.01740.017218466.46096577.322181.1007-2.67071.3842
560.1682-0.04240.01960.019426837.22518419.131591.7558-3.21961.551
570.184-0.04930.02210.021835483.323910674.4808103.3174-3.70211.7303
580.1992-0.0560.02470.024344792.948213298.9783115.3212-4.15951.9172
590.2144-0.08020.02870.028187233.342718580.0044136.3085-5.80462.1948
600.2292-0.08290.03230.031592237.570423490.5088153.2661-5.96882.4464
610.2437-0.08490.03560.034695876.004228014.6022167.3756-6.08542.6739
620.2578-0.10790.03980.0386147873.512435065.1264187.2568-7.55752.9611
630.2716-0.12920.04480.0432203171.500544404.3694210.7234-8.85863.2888



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