Free Statistics

of Irreproducible Research!

Author's title

Author*The author of this computation has been verified*
R Software Modulerwasp_arimaforecasting.wasp
Title produced by softwareARIMA Forecasting
Date of computationTue, 28 Dec 2010 15:45:18 +0000
Cite this page as followsStatistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?v=date/2010/Dec/28/t1293550993ql6wjzd50xa4ng3.htm/, Retrieved Sat, 04 May 2024 22:32:11 +0000
Statistical Computations at FreeStatistics.org, Office for Research Development and Education, URL https://freestatistics.org/blog/index.php?pk=116390, Retrieved Sat, 04 May 2024 22:32:11 +0000
QR Codes:

Original text written by user:
IsPrivate?No (this computation is public)
User-defined keywords
Estimated Impact155
Family? (F = Feedback message, R = changed R code, M = changed R Module, P = changed Parameters, D = changed Data)
-     [ARIMA Backward Selection] [Paper_ARIMAB] [2010-12-28 14:47:18] [7318566ef3ec88988be4d1362d0cf918]
- RMPD    [ARIMA Forecasting] [Paper_ARIMAF] [2010-12-28 15:45:18] [edf51d809b713abfc4095a7dca74558e] [Current]
-   P       [ARIMA Forecasting] [Paper_ARIMAF] [2010-12-28 15:47:17] [7318566ef3ec88988be4d1362d0cf918]
Feedback Forum

Post a new message
Dataseries X:
112.52
112.39
112.24
112.10
109.85
111.89
111.88
111.48
110.98
110.42
107.90
109.46
109.11
109.26
109.99
110.17
110.28
109.13
110.15
109.39
108.45
108.23
107.44
104.86
106.23
105.85
104.95
104.46
104.66
103.05
104.16
104.08
104.20
103.68
103.69
101.29
103.03
102.90
102.68
102.98
103.47
101.72
102.82
102.74
102.38
101.81
101.88
99.60
100.93
100.85
100.93
101.10
101.10
99.31
100.33
99.99
99.82
99.65
99.06
96.92
98.20
98.54
98.71
98.20
98.29
96.67
97.69
97.78
97.44
96.92
96.84
95.05
96.33
96.33
96.16
96.50
96.33
94.71
95.82
95.47
95.82
95.99
95.73
93.77
94.71
94.62
94.79
94.88
94.79
93.43
94.37
94.62
94.45
94.37
94.20
92.66
93.51
93.60
93.60
93.77
93.60
92.41
93.60
93.34
92.92
92.07
91.89
90.27
91.72
91.98
91.81
91.98
91.30
89.93
90.87
90.53
90.27
90.10
89.68
87.89




Summary of computational transaction
Raw Inputview raw input (R code)
Raw Outputview raw output of R engine
Computing time5 seconds
R Server'George Udny Yule' @ 72.249.76.132

\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 & 5 seconds \tabularnewline
R Server & 'George Udny Yule' @ 72.249.76.132 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=116390&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]5 seconds[/C][/ROW]
[ROW][C]R Server[/C][C]'George Udny Yule' @ 72.249.76.132[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=116390&T=0

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=116390&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 time5 seconds
R Server'George Udny Yule' @ 72.249.76.132







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[96])
8493.77-------
8594.71-------
8694.62-------
8794.79-------
8894.88-------
8994.79-------
9093.43-------
9194.37-------
9294.62-------
9394.45-------
9494.37-------
9594.2-------
9692.66-------
9793.5193.542592.562694.54770.47480.95730.01140.9573
9893.693.524692.423494.65790.44810.51010.02910.9326
9993.693.578392.366494.82920.48650.48650.02880.9249
10093.7793.656292.341995.01640.43490.53230.03890.9244
10193.693.589392.184895.04630.49430.4040.05310.8944
10292.4192.214390.774993.70980.39880.03470.05560.2796
10393.693.144391.589794.76380.29060.81290.0690.7211
10493.3493.167291.535494.87070.42120.30930.04730.7203
10592.9293.105591.403594.88550.41910.39810.06940.6881
10692.0793.015291.247994.86690.15850.54010.07580.6465
10791.8992.819790.995194.73480.17070.77860.07890.5649
10890.2791.205689.394193.10790.16750.24040.0670.067
10991.7292.126590.047194.3250.35850.9510.10870.3172
11091.9892.109289.911894.44020.45670.62830.1050.3216
11191.8192.16189.848194.62220.38990.55730.12590.3455
11291.9892.236189.811894.82370.42310.62660.12270.3741
11391.392.171689.649394.87120.26340.55530.14990.3614
11489.9390.845688.313693.55920.25420.37140.12920.095
11590.8791.742589.058694.62920.27680.89080.10360.2667
11690.5391.764788.989894.75660.20930.72110.1510.2788
11790.2791.705188.848494.79260.18110.77220.22030.2722
11890.191.618188.684694.79570.17450.79720.39020.2602
11989.6891.429688.4394.68550.14610.78830.39080.2294
12087.8989.872286.916393.08140.1130.54670.4040.0443

\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[96]) \tabularnewline
84 & 93.77 & - & - & - & - & - & - & - \tabularnewline
85 & 94.71 & - & - & - & - & - & - & - \tabularnewline
86 & 94.62 & - & - & - & - & - & - & - \tabularnewline
87 & 94.79 & - & - & - & - & - & - & - \tabularnewline
88 & 94.88 & - & - & - & - & - & - & - \tabularnewline
89 & 94.79 & - & - & - & - & - & - & - \tabularnewline
90 & 93.43 & - & - & - & - & - & - & - \tabularnewline
91 & 94.37 & - & - & - & - & - & - & - \tabularnewline
92 & 94.62 & - & - & - & - & - & - & - \tabularnewline
93 & 94.45 & - & - & - & - & - & - & - \tabularnewline
94 & 94.37 & - & - & - & - & - & - & - \tabularnewline
95 & 94.2 & - & - & - & - & - & - & - \tabularnewline
96 & 92.66 & - & - & - & - & - & - & - \tabularnewline
97 & 93.51 & 93.5425 & 92.5626 & 94.5477 & 0.4748 & 0.9573 & 0.0114 & 0.9573 \tabularnewline
98 & 93.6 & 93.5246 & 92.4234 & 94.6579 & 0.4481 & 0.5101 & 0.0291 & 0.9326 \tabularnewline
99 & 93.6 & 93.5783 & 92.3664 & 94.8292 & 0.4865 & 0.4865 & 0.0288 & 0.9249 \tabularnewline
100 & 93.77 & 93.6562 & 92.3419 & 95.0164 & 0.4349 & 0.5323 & 0.0389 & 0.9244 \tabularnewline
101 & 93.6 & 93.5893 & 92.1848 & 95.0463 & 0.4943 & 0.404 & 0.0531 & 0.8944 \tabularnewline
102 & 92.41 & 92.2143 & 90.7749 & 93.7098 & 0.3988 & 0.0347 & 0.0556 & 0.2796 \tabularnewline
103 & 93.6 & 93.1443 & 91.5897 & 94.7638 & 0.2906 & 0.8129 & 0.069 & 0.7211 \tabularnewline
104 & 93.34 & 93.1672 & 91.5354 & 94.8707 & 0.4212 & 0.3093 & 0.0473 & 0.7203 \tabularnewline
105 & 92.92 & 93.1055 & 91.4035 & 94.8855 & 0.4191 & 0.3981 & 0.0694 & 0.6881 \tabularnewline
106 & 92.07 & 93.0152 & 91.2479 & 94.8669 & 0.1585 & 0.5401 & 0.0758 & 0.6465 \tabularnewline
107 & 91.89 & 92.8197 & 90.9951 & 94.7348 & 0.1707 & 0.7786 & 0.0789 & 0.5649 \tabularnewline
108 & 90.27 & 91.2056 & 89.3941 & 93.1079 & 0.1675 & 0.2404 & 0.067 & 0.067 \tabularnewline
109 & 91.72 & 92.1265 & 90.0471 & 94.325 & 0.3585 & 0.951 & 0.1087 & 0.3172 \tabularnewline
110 & 91.98 & 92.1092 & 89.9118 & 94.4402 & 0.4567 & 0.6283 & 0.105 & 0.3216 \tabularnewline
111 & 91.81 & 92.161 & 89.8481 & 94.6222 & 0.3899 & 0.5573 & 0.1259 & 0.3455 \tabularnewline
112 & 91.98 & 92.2361 & 89.8118 & 94.8237 & 0.4231 & 0.6266 & 0.1227 & 0.3741 \tabularnewline
113 & 91.3 & 92.1716 & 89.6493 & 94.8712 & 0.2634 & 0.5553 & 0.1499 & 0.3614 \tabularnewline
114 & 89.93 & 90.8456 & 88.3136 & 93.5592 & 0.2542 & 0.3714 & 0.1292 & 0.095 \tabularnewline
115 & 90.87 & 91.7425 & 89.0586 & 94.6292 & 0.2768 & 0.8908 & 0.1036 & 0.2667 \tabularnewline
116 & 90.53 & 91.7647 & 88.9898 & 94.7566 & 0.2093 & 0.7211 & 0.151 & 0.2788 \tabularnewline
117 & 90.27 & 91.7051 & 88.8484 & 94.7926 & 0.1811 & 0.7722 & 0.2203 & 0.2722 \tabularnewline
118 & 90.1 & 91.6181 & 88.6846 & 94.7957 & 0.1745 & 0.7972 & 0.3902 & 0.2602 \tabularnewline
119 & 89.68 & 91.4296 & 88.43 & 94.6855 & 0.1461 & 0.7883 & 0.3908 & 0.2294 \tabularnewline
120 & 87.89 & 89.8722 & 86.9163 & 93.0814 & 0.113 & 0.5467 & 0.404 & 0.0443 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=116390&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[96])[/C][/ROW]
[ROW][C]84[/C][C]93.77[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]85[/C][C]94.71[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]86[/C][C]94.62[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]87[/C][C]94.79[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]88[/C][C]94.88[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]89[/C][C]94.79[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]90[/C][C]93.43[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]91[/C][C]94.37[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]92[/C][C]94.62[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]93[/C][C]94.45[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]94[/C][C]94.37[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]95[/C][C]94.2[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]96[/C][C]92.66[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][C]-[/C][/ROW]
[ROW][C]97[/C][C]93.51[/C][C]93.5425[/C][C]92.5626[/C][C]94.5477[/C][C]0.4748[/C][C]0.9573[/C][C]0.0114[/C][C]0.9573[/C][/ROW]
[ROW][C]98[/C][C]93.6[/C][C]93.5246[/C][C]92.4234[/C][C]94.6579[/C][C]0.4481[/C][C]0.5101[/C][C]0.0291[/C][C]0.9326[/C][/ROW]
[ROW][C]99[/C][C]93.6[/C][C]93.5783[/C][C]92.3664[/C][C]94.8292[/C][C]0.4865[/C][C]0.4865[/C][C]0.0288[/C][C]0.9249[/C][/ROW]
[ROW][C]100[/C][C]93.77[/C][C]93.6562[/C][C]92.3419[/C][C]95.0164[/C][C]0.4349[/C][C]0.5323[/C][C]0.0389[/C][C]0.9244[/C][/ROW]
[ROW][C]101[/C][C]93.6[/C][C]93.5893[/C][C]92.1848[/C][C]95.0463[/C][C]0.4943[/C][C]0.404[/C][C]0.0531[/C][C]0.8944[/C][/ROW]
[ROW][C]102[/C][C]92.41[/C][C]92.2143[/C][C]90.7749[/C][C]93.7098[/C][C]0.3988[/C][C]0.0347[/C][C]0.0556[/C][C]0.2796[/C][/ROW]
[ROW][C]103[/C][C]93.6[/C][C]93.1443[/C][C]91.5897[/C][C]94.7638[/C][C]0.2906[/C][C]0.8129[/C][C]0.069[/C][C]0.7211[/C][/ROW]
[ROW][C]104[/C][C]93.34[/C][C]93.1672[/C][C]91.5354[/C][C]94.8707[/C][C]0.4212[/C][C]0.3093[/C][C]0.0473[/C][C]0.7203[/C][/ROW]
[ROW][C]105[/C][C]92.92[/C][C]93.1055[/C][C]91.4035[/C][C]94.8855[/C][C]0.4191[/C][C]0.3981[/C][C]0.0694[/C][C]0.6881[/C][/ROW]
[ROW][C]106[/C][C]92.07[/C][C]93.0152[/C][C]91.2479[/C][C]94.8669[/C][C]0.1585[/C][C]0.5401[/C][C]0.0758[/C][C]0.6465[/C][/ROW]
[ROW][C]107[/C][C]91.89[/C][C]92.8197[/C][C]90.9951[/C][C]94.7348[/C][C]0.1707[/C][C]0.7786[/C][C]0.0789[/C][C]0.5649[/C][/ROW]
[ROW][C]108[/C][C]90.27[/C][C]91.2056[/C][C]89.3941[/C][C]93.1079[/C][C]0.1675[/C][C]0.2404[/C][C]0.067[/C][C]0.067[/C][/ROW]
[ROW][C]109[/C][C]91.72[/C][C]92.1265[/C][C]90.0471[/C][C]94.325[/C][C]0.3585[/C][C]0.951[/C][C]0.1087[/C][C]0.3172[/C][/ROW]
[ROW][C]110[/C][C]91.98[/C][C]92.1092[/C][C]89.9118[/C][C]94.4402[/C][C]0.4567[/C][C]0.6283[/C][C]0.105[/C][C]0.3216[/C][/ROW]
[ROW][C]111[/C][C]91.81[/C][C]92.161[/C][C]89.8481[/C][C]94.6222[/C][C]0.3899[/C][C]0.5573[/C][C]0.1259[/C][C]0.3455[/C][/ROW]
[ROW][C]112[/C][C]91.98[/C][C]92.2361[/C][C]89.8118[/C][C]94.8237[/C][C]0.4231[/C][C]0.6266[/C][C]0.1227[/C][C]0.3741[/C][/ROW]
[ROW][C]113[/C][C]91.3[/C][C]92.1716[/C][C]89.6493[/C][C]94.8712[/C][C]0.2634[/C][C]0.5553[/C][C]0.1499[/C][C]0.3614[/C][/ROW]
[ROW][C]114[/C][C]89.93[/C][C]90.8456[/C][C]88.3136[/C][C]93.5592[/C][C]0.2542[/C][C]0.3714[/C][C]0.1292[/C][C]0.095[/C][/ROW]
[ROW][C]115[/C][C]90.87[/C][C]91.7425[/C][C]89.0586[/C][C]94.6292[/C][C]0.2768[/C][C]0.8908[/C][C]0.1036[/C][C]0.2667[/C][/ROW]
[ROW][C]116[/C][C]90.53[/C][C]91.7647[/C][C]88.9898[/C][C]94.7566[/C][C]0.2093[/C][C]0.7211[/C][C]0.151[/C][C]0.2788[/C][/ROW]
[ROW][C]117[/C][C]90.27[/C][C]91.7051[/C][C]88.8484[/C][C]94.7926[/C][C]0.1811[/C][C]0.7722[/C][C]0.2203[/C][C]0.2722[/C][/ROW]
[ROW][C]118[/C][C]90.1[/C][C]91.6181[/C][C]88.6846[/C][C]94.7957[/C][C]0.1745[/C][C]0.7972[/C][C]0.3902[/C][C]0.2602[/C][/ROW]
[ROW][C]119[/C][C]89.68[/C][C]91.4296[/C][C]88.43[/C][C]94.6855[/C][C]0.1461[/C][C]0.7883[/C][C]0.3908[/C][C]0.2294[/C][/ROW]
[ROW][C]120[/C][C]87.89[/C][C]89.8722[/C][C]86.9163[/C][C]93.0814[/C][C]0.113[/C][C]0.5467[/C][C]0.404[/C][C]0.0443[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=116390&T=1

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=116390&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[96])
8493.77-------
8594.71-------
8694.62-------
8794.79-------
8894.88-------
8994.79-------
9093.43-------
9194.37-------
9294.62-------
9394.45-------
9494.37-------
9594.2-------
9692.66-------
9793.5193.542592.562694.54770.47480.95730.01140.9573
9893.693.524692.423494.65790.44810.51010.02910.9326
9993.693.578392.366494.82920.48650.48650.02880.9249
10093.7793.656292.341995.01640.43490.53230.03890.9244
10193.693.589392.184895.04630.49430.4040.05310.8944
10292.4192.214390.774993.70980.39880.03470.05560.2796
10393.693.144391.589794.76380.29060.81290.0690.7211
10493.3493.167291.535494.87070.42120.30930.04730.7203
10592.9293.105591.403594.88550.41910.39810.06940.6881
10692.0793.015291.247994.86690.15850.54010.07580.6465
10791.8992.819790.995194.73480.17070.77860.07890.5649
10890.2791.205689.394193.10790.16750.24040.0670.067
10991.7292.126590.047194.3250.35850.9510.10870.3172
11091.9892.109289.911894.44020.45670.62830.1050.3216
11191.8192.16189.848194.62220.38990.55730.12590.3455
11291.9892.236189.811894.82370.42310.62660.12270.3741
11391.392.171689.649394.87120.26340.55530.14990.3614
11489.9390.845688.313693.55920.25420.37140.12920.095
11590.8791.742589.058694.62920.27680.89080.10360.2667
11690.5391.764788.989894.75660.20930.72110.1510.2788
11790.2791.705188.848494.79260.18110.77220.22030.2722
11890.191.618188.684694.79570.17450.79720.39020.2602
11989.6891.429688.4394.68550.14610.78830.39080.2294
12087.8989.872286.916393.08140.1130.54670.4040.0443







Univariate ARIMA Extrapolation Forecast Performance
time% S.E.PEMAPESq.EMSERMSE
970.0055-3e-0400.001100
980.00628e-046e-040.00570.00340.058
990.00682e-045e-045e-040.00240.049
1000.00740.00126e-040.01290.0050.071
1010.00791e-045e-041e-040.00410.0637
1020.00830.00218e-040.03830.00980.0988
1030.00890.00490.00140.20770.0380.195
1040.00930.00190.00140.02980.0370.1924
1050.0098-0.0020.00150.03440.03670.1916
1060.0102-0.01020.00240.89340.12240.3498
1070.0105-0.010.00310.86440.18980.4357
1080.0106-0.01030.00370.87540.2470.497
1090.0122-0.00440.00370.16520.24070.4906
1100.0129-0.00140.00360.01670.22470.474
1110.0136-0.00380.00360.12320.21790.4668
1120.0143-0.00280.00350.06560.20840.4565
1130.0149-0.00950.00390.75970.24080.4907
1140.0152-0.01010.00420.83830.2740.5235
1150.0161-0.00950.00450.76130.29970.5474
1160.0166-0.01350.00491.52440.36090.6008
1170.0172-0.01560.00552.05950.44180.6647
1180.0177-0.01660.0062.30450.52650.7256
1190.0182-0.01910.00653.0610.63670.7979
1200.0182-0.02210.00723.9290.77380.8797

\begin{tabular}{lllllllll}
\hline
Univariate ARIMA Extrapolation Forecast Performance \tabularnewline
time & % S.E. & PE & MAPE & Sq.E & MSE & RMSE \tabularnewline
97 & 0.0055 & -3e-04 & 0 & 0.0011 & 0 & 0 \tabularnewline
98 & 0.0062 & 8e-04 & 6e-04 & 0.0057 & 0.0034 & 0.058 \tabularnewline
99 & 0.0068 & 2e-04 & 5e-04 & 5e-04 & 0.0024 & 0.049 \tabularnewline
100 & 0.0074 & 0.0012 & 6e-04 & 0.0129 & 0.005 & 0.071 \tabularnewline
101 & 0.0079 & 1e-04 & 5e-04 & 1e-04 & 0.0041 & 0.0637 \tabularnewline
102 & 0.0083 & 0.0021 & 8e-04 & 0.0383 & 0.0098 & 0.0988 \tabularnewline
103 & 0.0089 & 0.0049 & 0.0014 & 0.2077 & 0.038 & 0.195 \tabularnewline
104 & 0.0093 & 0.0019 & 0.0014 & 0.0298 & 0.037 & 0.1924 \tabularnewline
105 & 0.0098 & -0.002 & 0.0015 & 0.0344 & 0.0367 & 0.1916 \tabularnewline
106 & 0.0102 & -0.0102 & 0.0024 & 0.8934 & 0.1224 & 0.3498 \tabularnewline
107 & 0.0105 & -0.01 & 0.0031 & 0.8644 & 0.1898 & 0.4357 \tabularnewline
108 & 0.0106 & -0.0103 & 0.0037 & 0.8754 & 0.247 & 0.497 \tabularnewline
109 & 0.0122 & -0.0044 & 0.0037 & 0.1652 & 0.2407 & 0.4906 \tabularnewline
110 & 0.0129 & -0.0014 & 0.0036 & 0.0167 & 0.2247 & 0.474 \tabularnewline
111 & 0.0136 & -0.0038 & 0.0036 & 0.1232 & 0.2179 & 0.4668 \tabularnewline
112 & 0.0143 & -0.0028 & 0.0035 & 0.0656 & 0.2084 & 0.4565 \tabularnewline
113 & 0.0149 & -0.0095 & 0.0039 & 0.7597 & 0.2408 & 0.4907 \tabularnewline
114 & 0.0152 & -0.0101 & 0.0042 & 0.8383 & 0.274 & 0.5235 \tabularnewline
115 & 0.0161 & -0.0095 & 0.0045 & 0.7613 & 0.2997 & 0.5474 \tabularnewline
116 & 0.0166 & -0.0135 & 0.0049 & 1.5244 & 0.3609 & 0.6008 \tabularnewline
117 & 0.0172 & -0.0156 & 0.0055 & 2.0595 & 0.4418 & 0.6647 \tabularnewline
118 & 0.0177 & -0.0166 & 0.006 & 2.3045 & 0.5265 & 0.7256 \tabularnewline
119 & 0.0182 & -0.0191 & 0.0065 & 3.061 & 0.6367 & 0.7979 \tabularnewline
120 & 0.0182 & -0.0221 & 0.0072 & 3.929 & 0.7738 & 0.8797 \tabularnewline
\hline
\end{tabular}
%Source: https://freestatistics.org/blog/index.php?pk=116390&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]97[/C][C]0.0055[/C][C]-3e-04[/C][C]0[/C][C]0.0011[/C][C]0[/C][C]0[/C][/ROW]
[ROW][C]98[/C][C]0.0062[/C][C]8e-04[/C][C]6e-04[/C][C]0.0057[/C][C]0.0034[/C][C]0.058[/C][/ROW]
[ROW][C]99[/C][C]0.0068[/C][C]2e-04[/C][C]5e-04[/C][C]5e-04[/C][C]0.0024[/C][C]0.049[/C][/ROW]
[ROW][C]100[/C][C]0.0074[/C][C]0.0012[/C][C]6e-04[/C][C]0.0129[/C][C]0.005[/C][C]0.071[/C][/ROW]
[ROW][C]101[/C][C]0.0079[/C][C]1e-04[/C][C]5e-04[/C][C]1e-04[/C][C]0.0041[/C][C]0.0637[/C][/ROW]
[ROW][C]102[/C][C]0.0083[/C][C]0.0021[/C][C]8e-04[/C][C]0.0383[/C][C]0.0098[/C][C]0.0988[/C][/ROW]
[ROW][C]103[/C][C]0.0089[/C][C]0.0049[/C][C]0.0014[/C][C]0.2077[/C][C]0.038[/C][C]0.195[/C][/ROW]
[ROW][C]104[/C][C]0.0093[/C][C]0.0019[/C][C]0.0014[/C][C]0.0298[/C][C]0.037[/C][C]0.1924[/C][/ROW]
[ROW][C]105[/C][C]0.0098[/C][C]-0.002[/C][C]0.0015[/C][C]0.0344[/C][C]0.0367[/C][C]0.1916[/C][/ROW]
[ROW][C]106[/C][C]0.0102[/C][C]-0.0102[/C][C]0.0024[/C][C]0.8934[/C][C]0.1224[/C][C]0.3498[/C][/ROW]
[ROW][C]107[/C][C]0.0105[/C][C]-0.01[/C][C]0.0031[/C][C]0.8644[/C][C]0.1898[/C][C]0.4357[/C][/ROW]
[ROW][C]108[/C][C]0.0106[/C][C]-0.0103[/C][C]0.0037[/C][C]0.8754[/C][C]0.247[/C][C]0.497[/C][/ROW]
[ROW][C]109[/C][C]0.0122[/C][C]-0.0044[/C][C]0.0037[/C][C]0.1652[/C][C]0.2407[/C][C]0.4906[/C][/ROW]
[ROW][C]110[/C][C]0.0129[/C][C]-0.0014[/C][C]0.0036[/C][C]0.0167[/C][C]0.2247[/C][C]0.474[/C][/ROW]
[ROW][C]111[/C][C]0.0136[/C][C]-0.0038[/C][C]0.0036[/C][C]0.1232[/C][C]0.2179[/C][C]0.4668[/C][/ROW]
[ROW][C]112[/C][C]0.0143[/C][C]-0.0028[/C][C]0.0035[/C][C]0.0656[/C][C]0.2084[/C][C]0.4565[/C][/ROW]
[ROW][C]113[/C][C]0.0149[/C][C]-0.0095[/C][C]0.0039[/C][C]0.7597[/C][C]0.2408[/C][C]0.4907[/C][/ROW]
[ROW][C]114[/C][C]0.0152[/C][C]-0.0101[/C][C]0.0042[/C][C]0.8383[/C][C]0.274[/C][C]0.5235[/C][/ROW]
[ROW][C]115[/C][C]0.0161[/C][C]-0.0095[/C][C]0.0045[/C][C]0.7613[/C][C]0.2997[/C][C]0.5474[/C][/ROW]
[ROW][C]116[/C][C]0.0166[/C][C]-0.0135[/C][C]0.0049[/C][C]1.5244[/C][C]0.3609[/C][C]0.6008[/C][/ROW]
[ROW][C]117[/C][C]0.0172[/C][C]-0.0156[/C][C]0.0055[/C][C]2.0595[/C][C]0.4418[/C][C]0.6647[/C][/ROW]
[ROW][C]118[/C][C]0.0177[/C][C]-0.0166[/C][C]0.006[/C][C]2.3045[/C][C]0.5265[/C][C]0.7256[/C][/ROW]
[ROW][C]119[/C][C]0.0182[/C][C]-0.0191[/C][C]0.0065[/C][C]3.061[/C][C]0.6367[/C][C]0.7979[/C][/ROW]
[ROW][C]120[/C][C]0.0182[/C][C]-0.0221[/C][C]0.0072[/C][C]3.929[/C][C]0.7738[/C][C]0.8797[/C][/ROW]
[/TABLE]
Source: https://freestatistics.org/blog/index.php?pk=116390&T=2

Globally Unique Identifier (entire table): ba.freestatistics.org/blog/index.php?pk=116390&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
970.0055-3e-0400.001100
980.00628e-046e-040.00570.00340.058
990.00682e-045e-045e-040.00240.049
1000.00740.00126e-040.01290.0050.071
1010.00791e-045e-041e-040.00410.0637
1020.00830.00218e-040.03830.00980.0988
1030.00890.00490.00140.20770.0380.195
1040.00930.00190.00140.02980.0370.1924
1050.0098-0.0020.00150.03440.03670.1916
1060.0102-0.01020.00240.89340.12240.3498
1070.0105-0.010.00310.86440.18980.4357
1080.0106-0.01030.00370.87540.2470.497
1090.0122-0.00440.00370.16520.24070.4906
1100.0129-0.00140.00360.01670.22470.474
1110.0136-0.00380.00360.12320.21790.4668
1120.0143-0.00280.00350.06560.20840.4565
1130.0149-0.00950.00390.75970.24080.4907
1140.0152-0.01010.00420.83830.2740.5235
1150.0161-0.00950.00450.76130.29970.5474
1160.0166-0.01350.00491.52440.36090.6008
1170.0172-0.01560.00552.05950.44180.6647
1180.0177-0.01660.0062.30450.52650.7256
1190.0182-0.01910.00653.0610.63670.7979
1200.0182-0.02210.00723.9290.77380.8797



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