Tarea modelos de suavización exponencial

Author

AGHG y JAFL

library(tidyverse)
library(fpp3)

Serie con estacionalidad

aus_production
# A tsibble: 218 x 7 [1Q]
   Quarter  Beer Tobacco Bricks Cement Electricity   Gas
     <qtr> <dbl>   <dbl>  <dbl>  <dbl>       <dbl> <dbl>
 1 1956 Q1   284    5225    189    465        3923     5
 2 1956 Q2   213    5178    204    532        4436     6
 3 1956 Q3   227    5297    208    561        4806     7
 4 1956 Q4   308    5681    197    570        4418     6
 5 1957 Q1   262    5577    187    529        4339     5
 6 1957 Q2   228    5651    214    604        4811     7
 7 1957 Q3   236    5317    227    603        5259     7
 8 1957 Q4   320    6152    222    582        4735     6
 9 1958 Q1   272    5758    199    554        4608     5
10 1958 Q2   233    5641    229    620        5196     7
# ℹ 208 more rows

Training

recent_production <- aus_production %>% filter(year(Quarter) >= 1992)
Gas_train <- recent_production %>% filter(year(Quarter) <= 2007)

Gas_fit <- Gas_train %>%
  model(
    Mean = MEAN(Gas),
    `Naïve` = NAIVE(Gas),
    `Seasonal naïve` = SNAIVE(Gas),
    Drift = RW(Gas ~ drift())
  )

Gas_fc <- Gas_fit %>%
  forecast(h = 10)

Gas_fc %>%
  autoplot(recent_production, level = NULL) +
  xlab("Year") + ylab("Megalitres") +
  ggtitle("Forecasts for quarterly beer production") +
  guides(colour=guide_legend(title="Forecast"))

Gas_accu_train <- accuracy(Gas_fit) |> 
  arrange(MAE)
Gas_accu_train
# A tibble: 4 × 10
  .model         .type          ME  RMSE   MAE    MPE  MAPE  MASE RMSSE    ACF1
  <chr>          <chr>       <dbl> <dbl> <dbl>  <dbl> <dbl> <dbl> <dbl>   <dbl>
1 Seasonal naïve Training 4.98e+ 0  8.95  7.35  2.72   4.05  1     1     0.447 
2 Mean           Training 0        31.2  25.3  -3.26  15.0   3.44  3.49  0.547 
3 Drift          Training 4.96e-15 28.7  25.7  -1.25  14.7   3.49  3.21 -0.0166
4 Naïve          Training 1.40e+ 0 28.7  25.7  -0.445 14.7   3.50  3.21 -0.0166
Gas_accu_fc <- Gas_fc |> 
  accuracy(recent_production) |> 
  arrange(MAPE)

Gas_accu_fc
# A tibble: 4 × 10
  .model         .type    ME  RMSE   MAE   MPE  MAPE  MASE RMSSE    ACF1
  <chr>          <chr> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>   <dbl>
1 Seasonal naïve Test   4.9   7.70   6.3  2.31  2.94 0.857 0.861 -0.215 
2 Drift          Test   8.52 22.3   19.5  3.02  8.49 2.65  2.49  -0.0474
3 Naïve          Test  16.2  26.5   20.6  6.49  8.74 2.80  2.96  -0.0804
4 Mean           Test  43.3  48.1   43.3 18.9  18.9  5.89  5.38  -0.0804
Gas_train |> 
  autoplot(Gas)

Gas_train |> 
  autoplot(log(Gas))

dcmp <- Gas_train |> 
  model(
    STL(log(Gas), robust = TRUE)
  ) 

dcmp |> 
  components() |> 
  autoplot()

dcmp |> 
  components() |> 
  ggplot(aes(x = Quarter, y = season_adjust)) +
  geom_line()

Gas_train |> 
  model(
    STL(Gas, robust = TRUE)
  ) |> 
  components() |> 
  autoplot()

Gas_fit <- Gas_train |> 
  model(
    snaive = SNAIVE(Gas),
    ets_ANA = ETS(Gas ~ error("A") + trend("N") + season("A")),
    ets_AAA = ETS(Gas ~ error("A") + trend("A") + season("A")),
    ets_AAdA = ETS(Gas ~ error("A") + trend("Ad") + season("A")),
    ets_MAdM = ETS(Gas ~ error("M") + trend("Ad") + season("M")),
    ets_ANA_log = ETS(log(Gas) ~ error("A") + trend("N") + season("A")),
    ets_AAA_log = ETS(log(Gas) ~ error("A") + trend("A") + season("A")),
    ets_AAdA_log = ETS(log(Gas) ~ error("A") + trend("Ad") + season("A")),
    ets_MAdM_log = ETS(log(Gas) ~ error("M") + trend("Ad") + season("M")),
    stl_ets_A = decomposition_model(
      STL(log(Gas), robust = TRUE),
      ETS(season_year ~ error('A') + trend('N')+ season('A')),
      ETS(season_adjust~ error('A') + trend('Ad')+ season('N'))
    )
    
  )  

Gas_fit
# A mable: 1 x 10
    snaive      ets_ANA      ets_AAA      ets_AAdA      ets_MAdM  ets_ANA_log
   <model>      <model>      <model>       <model>       <model>      <model>
1 <SNAIVE> <ETS(A,N,A)> <ETS(A,A,A)> <ETS(A,Ad,A)> <ETS(M,Ad,M)> <ETS(A,N,A)>
# ℹ 4 more variables: ets_AAA_log <model>, ets_AAdA_log <model>,
#   ets_MAdM_log <model>, stl_ets_A <model>
accuracy(Gas_fit) |> 
  arrange(MAPE)
# A tibble: 10 × 10
   .model       .type        ME  RMSE   MAE     MPE  MAPE  MASE RMSSE     ACF1
   <chr>        <chr>     <dbl> <dbl> <dbl>   <dbl> <dbl> <dbl> <dbl>    <dbl>
 1 stl_ets_A    Training 0.341   5.05  3.67  0.0990  2.07 0.499 0.565 -0.0162 
 2 ets_AAdA     Training 0.491   5.39  3.95  0.169   2.25 0.538 0.603  0.0569 
 3 ets_AAA      Training 0.0444  5.33  4.04 -0.0440  2.30 0.550 0.595  0.129  
 4 ets_AAA_log  Training 0.0137  5.49  4.10 -0.0294  2.31 0.558 0.614  0.0533 
 5 ets_AAdA_log Training 0.600   5.51  4.14  0.245   2.34 0.563 0.616 -0.0578 
 6 ets_MAdM     Training 0.650   5.51  4.17  0.272   2.35 0.568 0.616 -0.00181
 7 ets_MAdM_log Training 0.218   5.59  4.25  0.0763  2.41 0.578 0.624 -0.00570
 8 ets_ANA_log  Training 1.70    5.71  4.38  0.964   2.48 0.596 0.639 -0.110  
 9 ets_ANA      Training 1.36    5.93  4.42  0.703   2.57 0.601 0.663 -0.0332 
10 snaive       Training 4.98    8.95  7.35  2.72    4.05 1     1      0.447  
Gas_fit |> 
  augment() |> 
  features(.innov, ljung_box, lag= 8)
# A tibble: 10 × 3
   .model       lb_stat lb_pvalue
   <chr>          <dbl>     <dbl>
 1 ets_AAA         8.68 0.370    
 2 ets_AAA_log     9.61 0.293    
 3 ets_AAdA        8.09 0.425    
 4 ets_AAdA_log   12.7  0.124    
 5 ets_ANA        12.9  0.116    
 6 ets_ANA_log     9.12 0.333    
 7 ets_MAdM       10.8  0.211    
 8 ets_MAdM_log    6.05 0.641    
 9 snaive         33.2  0.0000566
10 stl_ets_A       5.21 0.735    

Pronóstico Test

Gas_fc <- Gas_fit |> 
  forecast(h='2 years 6 months')

Gas_fc
# A fable: 100 x 4 [1Q]
# Key:     .model [10]
   .model Quarter         Gas .mean
   <chr>    <qtr>      <dist> <dbl>
 1 snaive 2008 Q1  N(187, 80)   187
 2 snaive 2008 Q2  N(234, 80)   234
 3 snaive 2008 Q3  N(245, 80)   245
 4 snaive 2008 Q4  N(205, 80)   205
 5 snaive 2009 Q1 N(187, 160)   187
 6 snaive 2009 Q2 N(234, 160)   234
 7 snaive 2009 Q3 N(245, 160)   245
 8 snaive 2009 Q4 N(205, 160)   205
 9 snaive 2010 Q1 N(187, 240)   187
10 snaive 2010 Q2 N(234, 240)   234
# ℹ 90 more rows
Gas_fc |> 
  autoplot(recent_production |> filter_index('2005 Q1' ~.), level= NULL, size=1)

Gas_fc |> 
  autoplot(recent_production |> filter_index('2005 Q1' ~.), size=1)+
  facet_wrap(~ .model, ncol= 3)+
  theme(legend.position = 'none')

Gas_fc |> 
  accuracy(recent_production) |> 
  arrange(MAPE)
# A tibble: 10 × 10
   .model       .type     ME  RMSE   MAE    MPE  MAPE  MASE RMSSE     ACF1
   <chr>        <chr>  <dbl> <dbl> <dbl>  <dbl> <dbl> <dbl> <dbl>    <dbl>
 1 ets_AAdA     Test   2.09   3.99  3.10  0.886  1.38 0.421 0.446  0.0711 
 2 ets_AAA      Test  -2.46   3.81  2.97 -1.17   1.39 0.404 0.425 -0.340  
 3 stl_ets_A    Test   0.718  4.68  3.77  0.439  1.77 0.513 0.523 -0.212  
 4 ets_MAdM_log Test  -0.566  4.98  3.84 -0.157  1.77 0.522 0.557 -0.288  
 5 ets_ANA_log  Test   1.97   5.33  4.06  0.955  1.89 0.552 0.595  0.00152
 6 ets_AAdA_log Test   1.49   5.37  4.38  0.818  2.06 0.596 0.600 -0.0651 
 7 ets_MAdM     Test   1.48   5.35  4.41  0.816  2.06 0.600 0.598 -0.0464 
 8 ets_ANA      Test   5.26   6.81  5.75  2.34   2.58 0.782 0.761  0.265  
 9 snaive       Test   4.9    7.70  6.3   2.31   2.94 0.857 0.861 -0.215  
10 ets_AAA_log  Test  -5.07   7.80  6.77 -2.11   2.97 0.922 0.872 -0.262  

Pronóstico a futuro

Gas_fut<- recent_production |> 
  model(
   ets_AAdA = ETS(Gas ~ error("M") + trend("Ad") + season("M")) 
  ) |> 
  forecast(h= '2 years 6 months')

Gas_fut
# A fable: 10 x 4 [1Q]
# Key:     .model [1]
   .model   Quarter         Gas .mean
   <chr>      <qtr>      <dist> <dbl>
 1 ets_AAdA 2010 Q3  N(255, 69)  255.
 2 ets_AAdA 2010 Q4  N(211, 58)  211.
 3 ets_AAdA 2011 Q1  N(202, 63)  202.
 4 ets_AAdA 2011 Q2 N(239, 103)  239.
 5 ets_AAdA 2011 Q3 N(257, 161)  257.
 6 ets_AAdA 2011 Q4 N(212, 121)  212.
 7 ets_AAdA 2012 Q1 N(203, 120)  203.
 8 ets_AAdA 2012 Q2 N(241, 184)  241.
 9 ets_AAdA 2012 Q3 N(259, 254)  259.
10 ets_AAdA 2012 Q4 N(214, 184)  214.
Gas_fut |> 
  autoplot(recent_production)

Podemos ver que después de probar con varios modelos, el modelo que más nos puede ayudar a realizar un mejor pronostico es uno que tenga suavización exponencial, el cual maneja un error aditivo, una tendencia amortiguada y una estacionalidad aditiva, donde el error MAPE es de solo 1.37%

Serie desestacionalizada

New_Z<-global_economy |>
  filter(Country=='New Zealand') |> 
  select(-c(Code,Country))

New_Z
# A tsibble: 58 x 7 [1Y]
    Year         GDP Growth   CPI Imports Exports Population
   <dbl>       <dbl>  <dbl> <dbl>   <dbl>   <dbl>      <dbl>
 1  1960 5485854792.     NA  4.99      NA      NA    2371800
 2  1961 5670064168.     NA  5.08      NA      NA    2419700
 3  1962 6077496268.     NA  5.22      NA      NA    2482000
 4  1963 6638937283.     NA  5.32      NA      NA    2531800
 5  1964 7274144351.     NA  5.51      NA      NA    2585400
 6  1965 5654463586.     NA  5.69      NA      NA    2628400
 7  1966 5863733231.     NA  5.85      NA      NA    2675900
 8  1967 5961418094.     NA  6.20      NA      NA    2724100
 9  1968 5180597621.     NA  6.47      NA      NA    2748100
10  1969 5761588762.     NA  6.79      NA      NA    2772800
# ℹ 48 more rows
lambda<-New_Z |> 
  features(Population,features=guerrero) |> 
  pull(lambda_guerrero)

lambda
[1] 0.227769
New_Z |> 
  autoplot(Population)

New_Z |> 
  autoplot(box_cox(Population,lambda))

Training

New_Z_train <- New_Z |> 
  filter_index(~'2007')

New_Z_fit <-  New_Z_train %>%
  model(
    Mean = MEAN(Population),
    Naive = NAIVE(Population),
    Drift = RW(Population ~ drift())
  )

New_Z_fc <- New_Z_fit  %>%
  forecast(h = 10)

New_Z_fc |> 
  autoplot(New_Z, level= NULL)

New_Z_accu_train <- accuracy(New_Z_fit) |> 
  arrange(MAPE)
New_Z_accu_train
# A tibble: 3 × 10
  .model .type          ME    RMSE     MAE      MPE   MAPE   MASE  RMSSE  ACF1
  <chr>  <chr>       <dbl>   <dbl>   <dbl>    <dbl>  <dbl>  <dbl>  <dbl> <dbl>
1 Drift  Training 1.59e-10  27098.  18774. -0.00845  0.574  0.470  0.567 0.358
2 Naive  Training 3.94e+ 4  47823.  39957.  1.22     1.23   1      1     0.358
3 Mean   Training 0        502558. 413606. -2.42    13.0   10.4   10.5   0.925
New_Z_accu_fc <- New_Z_fc |> 
  accuracy(New_Z) |> 
  arrange(MAPE)

New_Z_accu_fc
# A tibble: 3 × 10
  .model .type       ME     RMSE      MAE    MPE   MAPE  MASE RMSSE  ACF1
  <chr>  <chr>    <dbl>    <dbl>    <dbl>  <dbl>  <dbl> <dbl> <dbl> <dbl>
1 Drift  Test    33457.   69327.   40309.  0.706  0.861  1.01  1.45 0.564
2 Naive  Test   250180   299382.  250180   5.47   5.47   6.26  6.26 0.655
3 Mean   Test  1204468. 1215640. 1204468. 26.8   26.8   30.1  25.4  0.655
New_Z_train |> 
  autoplot(Population)

New_Z_train |> 
  autoplot(box_cox(Population, lambda))

New_Z_fit <- New_Z_train |> 
  model(
    
    ets_AAN = ETS(Population ~ error("A") + trend("A") + season("N")),
    ets_AAdN = ETS(Population ~ error("A") + trend("Ad") + season("N")),
    ets_MAN = ETS(Population ~ error("M") + trend("A") + season("N")),
    ets_MAdN = ETS(Population ~ error("M") + trend("Ad") + season("N")),
    
    ets_AAN_bc = ETS(box_cox(Population, lambda) ~ error("A") + trend("A") + season("N")),
    ets_AAdN_bc = ETS(box_cox(Population, lambda) ~ error("A") + trend("Ad") + season("N")),
    ets_MAN_bc = ETS(box_cox(Population, lambda) ~ error("M") + trend("A") + season("N")),
    ets_MAdN_bc = ETS(box_cox(Population, lambda) ~ error("M") + trend("Ad") + season("N"))
  )
    
    

New_Z_fit
# A mable: 1 x 8
       ets_AAN      ets_AAdN      ets_MAN      ets_MAdN   ets_AAN_bc
       <model>       <model>      <model>       <model>      <model>
1 <ETS(A,A,N)> <ETS(A,Ad,N)> <ETS(M,A,N)> <ETS(M,Ad,N)> <ETS(A,A,N)>
# ℹ 3 more variables: ets_AAdN_bc <model>, ets_MAN_bc <model>,
#   ets_MAdN_bc <model>
accuracy(New_Z_fit) |> 
  arrange(MAPE)
# A tibble: 8 × 10
  .model      .type         ME   RMSE    MAE     MPE  MAPE  MASE RMSSE  ACF1
  <chr>       <chr>      <dbl>  <dbl>  <dbl>   <dbl> <dbl> <dbl> <dbl> <dbl>
1 ets_AAdN_bc Training  2327.  26999. 15954.  0.0599 0.481 0.399 0.565 0.149
2 ets_MAdN_bc Training  2355.  27007. 16004.  0.0608 0.483 0.401 0.565 0.134
3 ets_MAN_bc  Training -1623.  27350. 16466. -0.0608 0.497 0.412 0.572 0.237
4 ets_MAdN    Training  2440.  27113. 16396.  0.0650 0.500 0.410 0.567 0.165
5 ets_AAN_bc  Training -1438.  27412. 16712. -0.0531 0.502 0.418 0.573 0.150
6 ets_AAdN    Training  2656.  27252. 16612.  0.0698 0.510 0.416 0.570 0.187
7 ets_MAN     Training   116.  27797. 17251. -0.0160 0.535 0.432 0.581 0.261
8 ets_AAN     Training   -21.7 28577. 17876. -0.0249 0.559 0.447 0.598 0.258
New_Z_fit |> 
  augment() |> 
  features(.innov, ljung_box, lag=10)
# A tibble: 8 × 3
  .model      lb_stat lb_pvalue
  <chr>         <dbl>     <dbl>
1 ets_AAN        7.12     0.714
2 ets_AAN_bc     8.66     0.564
3 ets_AAdN       8.04     0.625
4 ets_AAdN_bc    8.57     0.573
5 ets_MAN        8.66     0.565
6 ets_MAN_bc     9.81     0.457
7 ets_MAdN       9.45     0.490
8 ets_MAdN_bc    8.61     0.569

Pronóstico Test

New_Z_fc <- New_Z_fit |> 
  forecast(h='10 years')

New_Z_fc
# A fable: 80 x 4 [1Y]
# Key:     .model [8]
   .model   Year          Population    .mean
   <chr>   <dbl>              <dist>    <dbl>
 1 ets_AAN  2008 N(4269706, 8.9e+08) 4269706.
 2 ets_AAN  2009   N(4315611, 2e+09) 4315611.
 3 ets_AAN  2010 N(4361515, 3.3e+09) 4361515.
 4 ets_AAN  2011 N(4407420, 4.9e+09) 4407420.
 5 ets_AAN  2012 N(4453325, 6.8e+09) 4453325.
 6 ets_AAN  2013   N(4499230, 9e+09) 4499230.
 7 ets_AAN  2014 N(4545135, 1.1e+10) 4545135.
 8 ets_AAN  2015 N(4591040, 1.4e+10) 4591040.
 9 ets_AAN  2016 N(4636945, 1.7e+10) 4636945.
10 ets_AAN  2017 N(4682850, 2.1e+10) 4682850.
# ℹ 70 more rows
New_Z_fc |> 
  autoplot(New_Z |> filter_index('2005' ~.), level= NULL, size=1)

New_Z_fc |> 
  autoplot(New_Z |> filter_index('2005' ~.), size=1)+
  facet_wrap(~ .model, ncol= 3)+
  theme(legend.position = 'none')

New_Z_fc |> 
  accuracy(New_Z) |> 
  arrange(MAPE)
# A tibble: 8 × 10
  .model      .type      ME   RMSE    MAE     MPE  MAPE  MASE RMSSE  ACF1
  <chr>       <chr>   <dbl>  <dbl>  <dbl>   <dbl> <dbl> <dbl> <dbl> <dbl>
1 ets_AAN     Test   -2298. 47975. 36691. -0.0799 0.803 0.918 1.00  0.533
2 ets_MAN     Test   -7046. 47051. 37227. -0.184  0.818 0.932 0.984 0.530
3 ets_AAdN    Test   19187. 63500. 40955.  0.388  0.883 1.02  1.33  0.559
4 ets_MAdN    Test   18799. 63475. 41173.  0.379  0.888 1.03  1.33  0.559
5 ets_AAdN_bc Test   24466. 68206. 41830.  0.503  0.898 1.05  1.43  0.565
6 ets_MAdN_bc Test   27399. 70755. 42673.  0.567  0.915 1.07  1.48  0.568
7 ets_AAN_bc  Test  -31476. 49254. 41731. -0.718  0.932 1.04  1.03  0.535
8 ets_MAN_bc  Test  -36026. 52125. 44230. -0.818  0.989 1.11  1.09  0.541

Pronóstico a futuro

New_Z_fut<- New_Z |> 
  model(
   ets_AAN = ETS(Population ~ error("A") + trend("A") + season("N")) 
  ) |> 
  forecast(h= '6 years')

New_Z_fut
# A fable: 6 x 4 [1Y]
# Key:     .model [1]
  .model   Year          Population    .mean
  <chr>   <dbl>              <dist>    <dbl>
1 ets_AAN  2018 N(4880113, 8.5e+08) 4880113.
2 ets_AAN  2019   N(5e+06, 2.5e+09) 4966328.
3 ets_AAN  2020 N(5052543, 5.3e+09) 5052543.
4 ets_AAN  2021 N(5138759, 9.3e+09) 5138759.
5 ets_AAN  2022 N(5224974, 1.5e+10) 5224974.
6 ets_AAN  2023 N(5311189, 2.3e+10) 5311189.
New_Z_fut |> 
  autoplot(New_Z)

De misma forma, para la serie sin estacionalidad podemos que que se ajusta mejor un modelo de suavización exponencial que uno de referencia. De esta forma podemos ver que el modelo con suavización exponencial que mejor se le adecuó es el cual maneja un error aditivo, una tendencia aditiva y sin estacionalidad, el cual nos da un error MAPE de solo 0.80%