IDEAS home Printed from https://ideas.repec.org/a/eee/intfor/v40y2024i2p616-625.html
   My bibliography  Save this article

Optimal hierarchical EWMA forecasting

Author

Listed:
  • Sbrana, Giacomo
  • Pelagatti, Matteo

Abstract

Prediction of demand at different levels of aggregation is a crucial task in many business and industrial activities. This task may be extremely challenging when the number of time series increases together with the number of parameters governing the dynamics of the underlying model. This paper proposes theoretical and empirical contributions providing practical tools for managers needing efficient, flexible, and timely instruments. We first derive optimal results for predicting a system of time series following multivariate Exponentially Weighted Moving Average (EWMA) dynamics. Our results have relevant practical consequences. Indeed, we propose a fast EM algorithm that maximizes the Gaussian multivariate likelihood regardless of the model’s dimension. Secondly, we show optimal results for the hierarchies, deriving closed-form results for the underlying parameters. Finally, using more than one hundred Walmart sales time series, we show that our approach is competitive with the optimal forecast reconciliation approach based on univariate forecasts.

Suggested Citation

  • Sbrana, Giacomo & Pelagatti, Matteo, 2024. "Optimal hierarchical EWMA forecasting," International Journal of Forecasting, Elsevier, vol. 40(2), pages 616-625.
    • Handle: RePEc:eee:intfor:v:40:y:2024:i:2:p:616-625
    DOI: 10.1016/j.ijforecast.2022.12.008
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S016920702200173X
    Download Restriction: Full text for ScienceDirect subscribers only
    File URL: https://libkey.io/10.1016/j.ijforecast.2022.12.008?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Peter R. Winters, 1960. "Forecasting Sales by Exponentially Weighted Moving Averages," Management Science, INFORMS, vol. 6(3), pages 324-342, April.
    2. R. H. Shumway & D. S. Stoffer, 1982. "An Approach To Time Series Smoothing And Forecasting Using The Em Algorithm," Journal of Time Series Analysis, Wiley Blackwell, vol. 3(4), pages 253-264, July.
    3. Shanika L. Wickramasuriya & George Athanasopoulos & Rob J. Hyndman, 2019. "Optimal Forecast Reconciliation for Hierarchical and Grouped Time Series Through Trace Minimization," Journal of the American Statistical Association, Taylor & Francis Journals, vol. 114(526), pages 804-819, April.
    4. Eddelbuettel, Dirk & Francois, Romain, 2011. "Rcpp: Seamless R and C++ Integration," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 40(i08).
    5. Sbrana, Giacomo & Silvestrini, Andrea & Venditti, Fabrizio, 2017. "Short-term inflation forecasting: The M.E.T.A. approach," International Journal of Forecasting, Elsevier, vol. 33(4), pages 1065-1081.
    6. Athanasopoulos, George & Ahmed, Roman A. & Hyndman, Rob J., 2009. "Hierarchical forecasts for Australian domestic tourism," International Journal of Forecasting, Elsevier, vol. 25(1), pages 146-166.
    7. Hyndman, Rob J. & Lee, Alan J. & Wang, Earo, 2016. "Fast computation of reconciled forecasts for hierarchical and grouped time series," Computational Statistics & Data Analysis, Elsevier, vol. 97(C), pages 16-32.
    8. Lutkepohl, Helmut, 1984. "Forecasting Contemporaneously Aggregated Vector ARMA Processes," Journal of Business & Economic Statistics, American Statistical Association, vol. 2(3), pages 201-214, July.
    9. Durbin, James & Koopman, Siem Jan, 2012. "Time Series Analysis by State Space Methods," OUP Catalogue, Oxford University Press, edition 2, number 9780199641178.
    10. A. C. Harvey, 1986. "Analysis and Generalisation of a Multivariate Exponential Smoothing Model," Management Science, INFORMS, vol. 32(3), pages 374-380, March.
    11. Eddelbuettel, Dirk & Sanderson, Conrad, 2014. "RcppArmadillo: Accelerating R with high-performance C++ linear algebra," Computational Statistics & Data Analysis, Elsevier, vol. 71(C), pages 1054-1063.
    12. Hyndman, Rob J. & Khandakar, Yeasmin, 2008. "Automatic Time Series Forecasting: The forecast Package for R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 27(i03).
    13. Hyndman, Rob J. & Ahmed, Roman A. & Athanasopoulos, George & Shang, Han Lin, 2011. "Optimal combination forecasts for hierarchical time series," Computational Statistics & Data Analysis, Elsevier, vol. 55(9), pages 2579-2589, September.
    14. Poloni, Federico & Sbrana, Giacomo, 2015. "A note on forecasting demand using the multivariate exponential smoothing framework," International Journal of Production Economics, Elsevier, vol. 162(C), pages 143-150.
    15. Phillip G. Enns & Joseph A. Machak & W. Allen Spivey & William J. Wrobleski, 1982. "Forecasting Applications of an Adaptive Multiple Exponential Smoothing Model," Management Science, INFORMS, vol. 28(9), pages 1035-1044, September.
    16. Pennings, Clint L.P. & van Dalen, Jan, 2017. "Integrated hierarchical forecasting," European Journal of Operational Research, Elsevier, vol. 263(2), pages 412-418.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Eckert, Florian & Hyndman, Rob J. & Panagiotelis, Anastasios, 2021. "Forecasting Swiss exports using Bayesian forecast reconciliation," European Journal of Operational Research, Elsevier, vol. 291(2), pages 693-710.
    2. Athanasopoulos, George & Hyndman, Rob J. & Kourentzes, Nikolaos & Panagiotelis, Anastasios, 2024. "Forecast reconciliation: A review," International Journal of Forecasting, Elsevier, vol. 40(2), pages 430-456.
    3. Petropoulos, Fotios & Apiletti, Daniele & Assimakopoulos, Vassilios & Babai, Mohamed Zied & Barrow, Devon K. & Ben Taieb, Souhaib & Bergmeir, Christoph & Bessa, Ricardo J. & Bijak, Jakub & Boylan, Joh, 2022. "Forecasting: theory and practice," International Journal of Forecasting, Elsevier, vol. 38(3), pages 705-871.
      • Fotios Petropoulos & Daniele Apiletti & Vassilios Assimakopoulos & Mohamed Zied Babai & Devon K. Barrow & Souhaib Ben Taieb & Christoph Bergmeir & Ricardo J. Bessa & Jakub Bijak & John E. Boylan & Jet, 2020. "Forecasting: theory and practice," Papers 2012.03854, arXiv.org, revised Jan 2022.
    4. Panagiotelis, Anastasios & Gamakumara, Puwasala & Athanasopoulos, George & Hyndman, Rob J., 2023. "Probabilistic forecast reconciliation: Properties, evaluation and score optimisation," European Journal of Operational Research, Elsevier, vol. 306(2), pages 693-706.
    5. Ana Caroline Pinheiro & Paulo Canas Rodrigues, 2024. "Hierarchical Time Series Forecasting of Fire Spots in Brazil: A Comprehensive Approach," Stats, MDPI, vol. 7(3), pages 1-24, June.
    6. Hollyman, Ross & Petropoulos, Fotios & Tipping, Michael E., 2021. "Understanding forecast reconciliation," European Journal of Operational Research, Elsevier, vol. 294(1), pages 149-160.
    7. George Athanasopoulos & Ashton de Silva, 2010. "Multivariate exponential smoothing for forecasting tourist arrivals to Australia and New Zealand," Monash Econometrics and Business Statistics Working Papers 11/09, Monash University, Department of Econometrics and Business Statistics.
    8. Lila, Maurício Franca & Meira, Erick & Cyrino Oliveira, Fernando Luiz, 2022. "Forecasting unemployment in Brazil: A robust reconciliation approach using hierarchical data," Socio-Economic Planning Sciences, Elsevier, vol. 82(PB).
    9. Abolghasemi, Mahdi & Tarr, Garth & Bergmeir, Christoph, 2024. "Machine learning applications in hierarchical time series forecasting: Investigating the impact of promotions," International Journal of Forecasting, Elsevier, vol. 40(2), pages 597-615.
    10. Nystrup, Peter & Lindström, Erik & Møller, Jan K. & Madsen, Henrik, 2021. "Dimensionality reduction in forecasting with temporal hierarchies," International Journal of Forecasting, Elsevier, vol. 37(3), pages 1127-1146.
    11. Jeon, Jooyoung & Panagiotelis, Anastasios & Petropoulos, Fotios, 2019. "Probabilistic forecast reconciliation with applications to wind power and electric load," European Journal of Operational Research, Elsevier, vol. 279(2), pages 364-379.
    12. Abouarghoub, Wessam & Nomikos, Nikos K. & Petropoulos, Fotios, 2018. "On reconciling macro and micro energy transport forecasts for strategic decision making in the tanker industry," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 113(C), pages 225-238.
    13. Mirko Kremer & Enno Siemsen & Douglas J. Thomas, 2016. "The Sum and Its Parts: Judgmental Hierarchical Forecasting," Management Science, INFORMS, vol. 62(9), pages 2745-2764, September.
    14. Yang, Dazhi & van der Meer, Dennis, 2021. "Post-processing in solar forecasting: Ten overarching thinking tools," Renewable and Sustainable Energy Reviews, Elsevier, vol. 140(C).
    15. Li, Han & Chen, Hua, 2024. "Hierarchical mortality forecasting with EVT tails: An application to solvency capital requirement," International Journal of Forecasting, Elsevier, vol. 40(2), pages 549-563.
    16. Pritularga, Kandrika F. & Svetunkov, Ivan & Kourentzes, Nikolaos, 2021. "Stochastic coherency in forecast reconciliation," International Journal of Production Economics, Elsevier, vol. 240(C).
    17. Han Lin Shang, 2017. "Reconciling Forecasts of Infant Mortality Rates at National and Sub-National Levels: Grouped Time-Series Methods," Population Research and Policy Review, Springer;Southern Demographic Association (SDA), vol. 36(1), pages 55-84, February.
    18. Shanika L. Wickramasuriya & George Athanasopoulos & Rob J. Hyndman, 2019. "Optimal Forecast Reconciliation for Hierarchical and Grouped Time Series Through Trace Minimization," Journal of the American Statistical Association, Taylor & Francis Journals, vol. 114(526), pages 804-819, April.
    19. Han Lin Shang & Yang Yang, 2021. "Forecasting Australian subnational age-specific mortality rates," Journal of Population Research, Springer, vol. 38(1), pages 1-24, March.
    20. Tiago Silveira Gontijo & Marcelo Azevedo Costa, 2020. "Forecasting Hierarchical Time Series in Power Generation," Energies, MDPI, vol. 13(14), pages 1-17, July.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:intfor:v:40:y:2024:i:2:p:616-625. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/ijforecast .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.