devtools::install_github("FinYang/tsdl")
Skipping install of 'tsdl' from a github remote, the SHA1 (56e09154) has not changed since last install.
  Use `force = TRUE` to force installation
library(tsdl)
ts_132 <- tsdl[[132]]
attributes(ts_132)
$tsp
[1] 1959.75 1995.50    4.00

$class
[1] "ts"

$source
[1] "Australian Bureau of Statistics"

$description
[1] "Quarterly Australian Gross non-farm product: $m at average 1989/90 prices. Sep 59 – Jun 1995"

$subject
[1] "Macroeconomic"
plot(ts_132)

Como podemos observar tiene una tendecia bastante marcada, y no es estacionaria

ggseasonplot(ts_132, main = "Quarterly Australian Gross non-farm product: $m at average 1989/90 prices. Sep 59 – Jun 1995")

original =ts_132
original
       Qtr1   Qtr2   Qtr3   Qtr4
1959                       26169
1960  28492  26032  26731  28033
1961  29649  26317  26539  26950
1962  29318  27127  28386  28974
1963  31489  28574  29824  31133
1964  34381  30253  31872  33407
1965  36251  32649  34589  35554
1966  37522  33606  35305  36431
1967  39247  36065  37976  38553
1968  41779  38046  39872  41023
1969  44927  40364  42671  44596
1970  48549  42386  46163  47388
1971  50861  45105  48037  49532
1972  53440  46718  50098  50868
1973  56204  50382  52375  54063
1974  58599  51764  54092  54101
1975  58532  52211  55911  55060
1976  59270  54803  57180  57894
1977  61690  55483  57886  58510
1978  61005  56793  59376  60175
1979  64225  59871  61070  61918
1980  66917  61219  62862  64059
1981  70227  63042  66051  67061
1982  71120  63526  66156  66517
1983  70744  63039  65597  67339
1984  72476  67752  70674  71556
1985  75631  70204  74924  76210
1986  80012  72760  76153  76856
1987  80928  74478  79277  81011
1988  85705  79626  82606  84545
1989  89412  83040  87699  88633
1990  92060  85895  88690  88590
1991  91645  84832  86943  88171
1992  91942  85976  88732  90004
1993  94745  88057  92190  93177
1994  98349  92349  96878  99463
1995 104664  96897 101289       

Imputacion de Datos

Primreo quitamos los datos de los años 1979 y 1989 asignandole NA a todos sus valores:


window(ts_132, start = 1979, end = c(1979, 4))  <- NA
window(ts_132, start = 1989, end = c(1989, 4)) <- NA
plot(ts_132)

Ahora imputaremos los datos con varios metodos:

Seasonal Trend Decomposition usin LOess (STL) imputation

ggplot_na_imputations(ts_132, na_seadec(ts_132, algorithm = "interpolation"))

Seasonal Trend Decomposition usin LOess (STL) imputation


window(ts_132, start= 1979, end= c(1979, 4)) <- NA
window(ts_132, start = 1989, end = c(1989, 4)) <- NA
ggplot_na_imputations(ts_132, na_interpolation(ts_132,option = "spline"))

Media-Mediana-Moda Móvil (MMM-M)

ggplot_na_imputations(ts_132, na_ma(ts_132,k = 4, weighting = "exponential", maxgap = Inf))

Ahora compararemos su diferencia con ECM


ecm_stl <- sum((original - na_seadec(ts_132, algorithm = "interpolation"))^2)
ecm_MMMM <- sum((original - na_ma(ts_132,k = 4, weighting = "exponential", maxgap = Inf))^2)
ecm_spli <- sum((original - na_interpolation(ts_132,option = "spline"))^2)
df_comparativo <- data.frame("Metodo" = c("STL", "MMM-M", "SPL"),
"ECM" =c(ecm_stl, ecm_MMMM, ecm_spli) )

df_comparativo

Nos quedamos con el error mas pequeño que es por interpolacion.

mape_stl <- MAPE(na_seadec(ts_132, algorithm = "interpolation"), original)
mape_MMMM <- MAPE(na_ma(ts_132,k = 4, weighting = "exponential", maxgap = Inf),original)
mape_spli <- MAPE(na_interpolation(ts_132,option = "spline"), original)
df_comparativo_2 <- data.frame("Metodo" = c("STL", "MMM-M", "SPL"),
"MAPE" =c(mape_stl, mape_MMMM, mape_spli) )
df_comparativo_2

Modelo ARIMA

Veamos nuestra serie

plot(original)

Tenemos que volverla estacionaria

se_diff <- diff(original)
plot(se_diff)

adf.test(se_diff, alternative  = "stationary")
Warning: p-value smaller than printed p-value

    Augmented Dickey-Fuller Test

data:  se_diff
Dickey-Fuller = -4.1805, Lag order = 5, p-value = 0.01
alternative hypothesis: stationary

la volvimos estacionaria a traves de la diferenciacion.

Ahora veamos la ACF y la PACF

acf(original)

pacf(original)

mod1 <- arima(original, order = c(1,2,2))
mod2 <- arima(original,order = c(1,3,2) )
mod1

Call:
arima(x = original, order = c(1, 2, 2))

Coefficients:
          ar1      ma1     ma2
      -0.2379  -1.6984  0.7043
s.e.   0.0944   0.0639  0.0619

sigma^2 estimated as 7276287:  log likelihood = -1326.87,  aic = 2661.74
mod2

Call:
arima(x = original, order = c(1, 3, 2))

Coefficients:
          ar1      ma1     ma2
      -0.5574  -1.9975  0.9998
s.e.   0.0696   0.0294  0.0293

sigma^2 estimated as 9778397:  log likelihood = -1343.18,  aic = 2694.36

Hacemos un diagnostico

tsdiag(mod1)

tsdiag(mod2)

Box.test(residuals(mod1), type = "Ljung-Box")

    Box-Ljung test

data:  residuals(mod1)
X-squared = 0.35236, df = 1, p-value = 0.5528
Box.test(residuals(mod2), type = "Ljung-Box")

    Box-Ljung test

data:  residuals(mod2)
X-squared = 2.3113, df = 1, p-value = 0.1284

Nos quedamos con el modelo 1

error = residuals(mod1)
plot(error)

pron <- forecast(mod1, h = 20)
pron
plot(pron)

SARIMA

adf.test(original)

    Augmented Dickey-Fuller Test

data:  original
Dickey-Fuller = -2.677, Lag order = 5, p-value = 0.2946
alternative hypothesis: stationary

No es estacionario como ya habiamos visto

Utilizare la funcion autoarima

ndiffs(original)
[1] 1
model <- auto.arima(original,stepwise = FALSE, approximation = FALSE)
model
Series: original 
ARIMA(1,0,0)(1,1,1)[4] with drift 

Coefficients:
         ar1    sar1     sma1     drift
      0.8664  0.3486  -0.7445  529.1781
s.e.  0.0464  0.1385   0.0961   53.5056

sigma^2 = 728419:  log likelihood = -1142.57
AIC=2295.13   AICc=2295.58   BIC=2309.84
acf(original)

pacf(original)

residual <- resid(model)
plot(residual, main = "Residuales")

adf.test(residual)
Warning: p-value smaller than printed p-value

    Augmented Dickey-Fuller Test

data:  residual
Dickey-Fuller = -4.6403, Lag order = 5, p-value = 0.01
alternative hypothesis: stationary

El p-value esmenor que .05 por lo que es ruido blanco

predic <- forecast(model, h= 20)
plot(predic)

Al observar las graficas de ambos modelos, el modelo SARIMA estima de mejor manera que el ARIMA

LS0tDQp0aXRsZTogIlRBUkVBIDMiDQpvdXRwdXQ6DQogIGh0bWxfbm90ZWJvb2s6IGRlZmF1bHQNCiAgcGRmX2RvY3VtZW50OiBkZWZhdWx0DQotLS0NCg0KYGBge3J9DQpkZXZ0b29sczo6aW5zdGFsbF9naXRodWIoIkZpbllhbmcvdHNkbCIpDQpsaWJyYXJ5KHRzZGwpDQp0c18xMzIgPC0gdHNkbFtbMTMyXV0NCmF0dHJpYnV0ZXModHNfMTMyKQ0KcGxvdCh0c18xMzIpDQpgYGANCg0KQ29tbyBwb2RlbW9zIG9ic2VydmFyIHRpZW5lIHVuYSB0ZW5kZWNpYSBiYXN0YW50ZSBtYXJjYWRhLCB5IG5vIGVzIGVzdGFjaW9uYXJpYQ0KYGBge3J9DQpnZ3NlYXNvbnBsb3QodHNfMTMyLCBtYWluID0gIlF1YXJ0ZXJseSBBdXN0cmFsaWFuIEdyb3NzIG5vbi1mYXJtIHByb2R1Y3Q6ICRtIGF0IGF2ZXJhZ2UgMTk4OS85MCBwcmljZXMuIFNlcCA1OSDigJMgSnVuIDE5OTUiKQ0KYGBgDQpgYGB7cn0NCm9yaWdpbmFsID10c18xMzINCm9yaWdpbmFsDQpgYGANCg0KDQojIyBJbXB1dGFjaW9uIGRlIERhdG9zDQoNClByaW1yZW8gcXVpdGFtb3MgbG9zIGRhdG9zIGRlIGxvcyBhw7FvcyAxOTc5IHkgMTk4OSBhc2lnbmFuZG9sZSBOQSBhIHRvZG9zIHN1cyB2YWxvcmVzOg0KDQpgYGB7cn0NCg0Kd2luZG93KHRzXzEzMiwgc3RhcnQgPSAxOTc5LCBlbmQgPSBjKDE5NzksIDQpKSAgPC0gTkENCndpbmRvdyh0c18xMzIsIHN0YXJ0ID0gMTk4OSwgZW5kID0gYygxOTg5LCA0KSkgPC0gTkENCnBsb3QodHNfMTMyKQ0KYGBgDQoNCkFob3JhIGltcHV0YXJlbW9zIGxvcyBkYXRvcyBjb24gdmFyaW9zIG1ldG9kb3M6DQoNCiMjIFNlYXNvbmFsIFRyZW5kIERlY29tcG9zaXRpb24gdXNpbiBMT2VzcyAoU1RMKSBpbXB1dGF0aW9uDQoNCmBgYHtyfQ0KZ2dwbG90X25hX2ltcHV0YXRpb25zKHRzXzEzMiwgbmFfc2VhZGVjKHRzXzEzMiwgYWxnb3JpdGhtID0gImludGVycG9sYXRpb24iKSkNCmBgYA0KDQojIyBTZWFzb25hbCBUcmVuZCBEZWNvbXBvc2l0aW9uIHVzaW4gTE9lc3MgKFNUTCkgaW1wdXRhdGlvbg0KDQpgYGB7cn0NCg0Kd2luZG93KHRzXzEzMiwgc3RhcnQ9IDE5NzksIGVuZD0gYygxOTc5LCA0KSkgPC0gTkENCndpbmRvdyh0c18xMzIsIHN0YXJ0ID0gMTk4OSwgZW5kID0gYygxOTg5LCA0KSkgPC0gTkENCmdncGxvdF9uYV9pbXB1dGF0aW9ucyh0c18xMzIsIG5hX2ludGVycG9sYXRpb24odHNfMTMyLG9wdGlvbiA9ICJzcGxpbmUiKSkNCg0KYGBgDQoNCiMjIE1lZGlhLU1lZGlhbmEtTW9kYSBNw7N2aWwgKE1NTS1NKQ0KDQpgYGB7cn0NCmdncGxvdF9uYV9pbXB1dGF0aW9ucyh0c18xMzIsIG5hX21hKHRzXzEzMixrID0gNCwgd2VpZ2h0aW5nID0gImV4cG9uZW50aWFsIiwgbWF4Z2FwID0gSW5mKSkNCmBgYA0KDQpBaG9yYSBjb21wYXJhcmVtb3Mgc3UgZGlmZXJlbmNpYSBjb24gRUNNDQoNCmBgYHtyfQ0KDQplY21fc3RsIDwtIHN1bSgob3JpZ2luYWwgLSBuYV9zZWFkZWModHNfMTMyLCBhbGdvcml0aG0gPSAiaW50ZXJwb2xhdGlvbiIpKV4yKQ0KZWNtX01NTU0gPC0gc3VtKChvcmlnaW5hbCAtIG5hX21hKHRzXzEzMixrID0gNCwgd2VpZ2h0aW5nID0gImV4cG9uZW50aWFsIiwgbWF4Z2FwID0gSW5mKSleMikNCmVjbV9zcGxpIDwtIHN1bSgob3JpZ2luYWwgLSBuYV9pbnRlcnBvbGF0aW9uKHRzXzEzMixvcHRpb24gPSAic3BsaW5lIikpXjIpDQpkZl9jb21wYXJhdGl2byA8LSBkYXRhLmZyYW1lKCJNZXRvZG8iID0gYygiU1RMIiwgIk1NTS1NIiwgIlNQTCIpLA0KIkVDTSIgPWMoZWNtX3N0bCwgZWNtX01NTU0sIGVjbV9zcGxpKSApDQoNCmRmX2NvbXBhcmF0aXZvDQpgYGANCg0KTm9zIHF1ZWRhbW9zIGNvbiBlbCBlcnJvciBtYXMgcGVxdWXDsW8gcXVlIGVzIHBvciBpbnRlcnBvbGFjaW9uLg0KDQpgYGB7cn0NCm1hcGVfc3RsIDwtIE1BUEUobmFfc2VhZGVjKHRzXzEzMiwgYWxnb3JpdGhtID0gImludGVycG9sYXRpb24iKSwgb3JpZ2luYWwpDQptYXBlX01NTU0gPC0gTUFQRShuYV9tYSh0c18xMzIsayA9IDQsIHdlaWdodGluZyA9ICJleHBvbmVudGlhbCIsIG1heGdhcCA9IEluZiksb3JpZ2luYWwpDQptYXBlX3NwbGkgPC0gTUFQRShuYV9pbnRlcnBvbGF0aW9uKHRzXzEzMixvcHRpb24gPSAic3BsaW5lIiksIG9yaWdpbmFsKQ0KZGZfY29tcGFyYXRpdm9fMiA8LSBkYXRhLmZyYW1lKCJNZXRvZG8iID0gYygiU1RMIiwgIk1NTS1NIiwgIlNQTCIpLA0KIk1BUEUiID1jKG1hcGVfc3RsLCBtYXBlX01NTU0sIG1hcGVfc3BsaSkgKQ0KZGZfY29tcGFyYXRpdm9fMg0KYGBgDQoNCg0KDQoNCiMgTW9kZWxvIEFSSU1BDQoNClZlYW1vcyBudWVzdHJhIHNlcmllDQoNCmBgYHtyfQ0KcGxvdChvcmlnaW5hbCkNCmBgYA0KDQpUZW5lbW9zIHF1ZSB2b2x2ZXJsYSBlc3RhY2lvbmFyaWENCg0KYGBge3J9DQpzZV9kaWZmIDwtIGRpZmYob3JpZ2luYWwpDQpwbG90KHNlX2RpZmYpDQphZGYudGVzdChzZV9kaWZmLCBhbHRlcm5hdGl2ZSAgPSAic3RhdGlvbmFyeSIpDQpgYGANCg0KbGEgdm9sdmltb3MgZXN0YWNpb25hcmlhIGEgdHJhdmVzIGRlIGxhIGRpZmVyZW5jaWFjaW9uLg0KDQpBaG9yYSB2ZWFtb3MgbGEgQUNGIHkgbGEgUEFDRg0KDQpgYGB7cn0NCmFjZihvcmlnaW5hbCkNCnBhY2Yob3JpZ2luYWwpDQpgYGANCg0KYGBge3J9DQptb2QxIDwtIGFyaW1hKG9yaWdpbmFsLCBvcmRlciA9IGMoMSwyLDIpKQ0KbW9kMiA8LSBhcmltYShvcmlnaW5hbCxvcmRlciA9IGMoMSwzLDIpICkNCm1vZDENCm1vZDINCmBgYA0KDQpIYWNlbW9zIHVuIGRpYWdub3N0aWNvDQoNCmBgYHtyfQ0KdHNkaWFnKG1vZDEpDQp0c2RpYWcobW9kMikNCmBgYA0KDQpgYGB7cn0NCkJveC50ZXN0KHJlc2lkdWFscyhtb2QxKSwgdHlwZSA9ICJManVuZy1Cb3giKQ0KQm94LnRlc3QocmVzaWR1YWxzKG1vZDIpLCB0eXBlID0gIkxqdW5nLUJveCIpDQpgYGANCg0KTm9zIHF1ZWRhbW9zIGNvbiBlbCBtb2RlbG8gMQ0KDQpgYGB7cn0NCmVycm9yID0gcmVzaWR1YWxzKG1vZDEpDQpwbG90KGVycm9yKQ0KYGBgDQoNCmBgYHtyfQ0KcHJvbiA8LSBmb3JlY2FzdChtb2QxLCBoID0gMjApDQpwcm9uDQpwbG90KHByb24pDQpgYGANCg0KIyBTQVJJTUENCg0KYGBge3J9DQphZGYudGVzdChvcmlnaW5hbCkNCmBgYA0KDQpObyBlcyBlc3RhY2lvbmFyaW8gY29tbyB5YSBoYWJpYW1vcyB2aXN0bw0KDQpVdGlsaXphcmUgbGEgZnVuY2lvbiBhdXRvYXJpbWENCg0KYGBge3J9DQpuZGlmZnMob3JpZ2luYWwpDQptb2RlbCA8LSBhdXRvLmFyaW1hKG9yaWdpbmFsLHN0ZXB3aXNlID0gRkFMU0UsIGFwcHJveGltYXRpb24gPSBGQUxTRSkNCm1vZGVsDQoNCmFjZihvcmlnaW5hbCkNCnBhY2Yob3JpZ2luYWwpDQoNCmBgYA0KDQpgYGB7cn0NCnJlc2lkdWFsIDwtIHJlc2lkKG1vZGVsKQ0KcGxvdChyZXNpZHVhbCwgbWFpbiA9ICJSZXNpZHVhbGVzIikNCmFkZi50ZXN0KHJlc2lkdWFsKQ0KYGBgDQoNCkVsIHAtdmFsdWUgZXNtZW5vciBxdWUgLjA1IHBvciBsbyBxdWUgZXMgcnVpZG8gYmxhbmNvDQoNCmBgYHtyfQ0KcHJlZGljIDwtIGZvcmVjYXN0KG1vZGVsLCBoPSAyMCkNCnBsb3QocHJlZGljKQ0KYGBgDQoNCkFsIG9ic2VydmFyIGxhcyBncmFmaWNhcyBkZSBhbWJvcyBtb2RlbG9zLCBlbCBtb2RlbG8gU0FSSU1BIGVzdGltYSBkZSBtZWpvciBtYW5lcmEgcXVlIGVsIEFSSU1BDQo=