IDEAS home Printed from https://ideas.repec.org/p/msh/ebswps/2007-9.html
   My bibliography  Save this paper

Optimal combination forecasts for hierarchical time series

Author

Listed:
  • Rob J. Hyndman
  • Roman A. Ahmed
  • George Athanasopoulos

Abstract

In many applications, there are multiple time series that are hierarchically organized and can be aggregated at several different levels in groups based on products, geography or some other features. We call these "hierarchical time series". They are commonly forecast using either a "bottom-up" or a "top-down" method. In this paper we propose a new approach to hierarchical forecasting which provides optimal forecasts that are better than forecasts produced by either a top-down or a bottom-up approach. Our method is based on independently forecasting all series at all levels of the hierarchy and then using a regression model to optimally combine and reconcile these forecasts. The resulting revised forecasts add up appropriately across the hierarchy, are unbiased and have minimum variance amongst all combination forecasts under some simple assumptions. We show in a simulation study that our method performs well compared to the top-down approach and the bottom-up method. It also allows us to construct prediction intervals for the resultant forecasts. Finally, we apply the method to forecasting Australian tourism demand where the data are disaggregated by purpose of visit and geographical region.

Suggested Citation

  • Rob J. Hyndman & Roman A. Ahmed & George Athanasopoulos, 2007. "Optimal combination forecasts for hierarchical time series," Monash Econometrics and Business Statistics Working Papers 9/07, Monash University, Department of Econometrics and Business Statistics.
  • Handle: RePEc:msh:ebswps:2007-9
    as

    Download full text from publisher

    File URL: http://www.buseco.monash.edu.au/ebs/pubs/wpapers/2007/wp9-07.pdf
    Download Restriction: no
    ---><---

    Other versions of this item:

    References listed on IDEAS

    as
    1. Collins, Dw, 1976. "Predicting Earnings With Sub-Entity Data - Some Further Evidence," Journal of Accounting Research, Wiley Blackwell, vol. 14(1), pages 163-177.
    2. Kohn, Robert, 1982. "When is an aggregate of a time series efficiently forecast by its past?," Journal of Econometrics, Elsevier, vol. 18(3), pages 337-349, April.
    3. Weale, Martin, 1985. "Testing Linear Hypotheses on National Account Data," The Review of Economics and Statistics, MIT Press, vol. 67(4), pages 685-689, November.
    4. 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).
    5. Solomos Solomou & Martin Weale, 1996. "UK national income, 1920-1938: the implications of balanced estimates," Economic History Review, Economic History Society, vol. 49(1), pages 101-115, February.
    6. Hyndman, Rob J. & Koehler, Anne B. & Snyder, Ralph D. & Grose, Simone, 2002. "A state space framework for automatic forecasting using exponential smoothing methods," International Journal of Forecasting, Elsevier, vol. 18(3), pages 439-454.
    7. A. Espasa & E. Senra & R. Albacete, 2002. "Forecasting inflation in the European Monetary Union: A disaggregated approach by countries and by sectors," The European Journal of Finance, Taylor & Francis Journals, vol. 8(4), pages 402-421.
    8. Zellner, Arnold & Tobias, Justin, 1998. "A Note on Aggregation, Disaggregation and Forecasting Performance," CUDARE Working Papers 198677, University of California, Berkeley, Department of Agricultural and Resource Economics.
    9. Kinney, Wr, 1971. "Predicting Earnings - Entity Versus Subentity Data," Journal of Accounting Research, Wiley Blackwell, vol. 9(1), pages 127-136.
    10. Dangerfield, Byron J. & Morris, John S., 1992. "Top-down or bottom-up: Aggregate versus disaggregate extrapolations," International Journal of Forecasting, Elsevier, vol. 8(2), pages 233-241, October.
    11. Marcellino, Massimiliano & Stock, James H. & Watson, Mark W., 2003. "Macroeconomic forecasting in the Euro area: Country specific versus area-wide information," European Economic Review, Elsevier, vol. 47(1), pages 1-18, February.
    12. Richard Stone & D. G. Champernowne & J. E. Meade, 1942. "The Precision of National Income Estimates," The Review of Economic Studies, Review of Economic Studies Ltd, vol. 9(2), pages 111-125.
    13. Solomou, Solomos & Weale, Martin, 1991. "Balanced estimates of UK GDP 1870-1913," Explorations in Economic History, Elsevier, vol. 28(1), pages 54-63, January.
    14. Tian, Yongge & Wiens, Douglas P., 2006. "On equality and proportionality of ordinary least squares, weighted least squares and best linear unbiased estimators in the general linear model," Statistics & Probability Letters, Elsevier, vol. 76(12), pages 1265-1272, July.
    15. Makridakis, Spyros & Hibon, Michele, 2000. "The M3-Competition: results, conclusions and implications," International Journal of Forecasting, Elsevier, vol. 16(4), pages 451-476.
    16. Fair, Ray C & Shiller, Robert J, 1990. "Comparing Information in Forecasts from Econometric Models," American Economic Review, American Economic Association, vol. 80(3), pages 375-389, June.
    17. 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.
    18. E. Shlifer & R. W. Wolff, 1979. "Aggregation and Proration in Forecasting," Management Science, INFORMS, vol. 25(6), pages 594-603, June.
    19. Tiao, G. C. & Guttman, Irwin, 1980. "Forecasting contemporal aggregates of multiple time series," Journal of Econometrics, Elsevier, vol. 12(2), pages 219-230, February.
    20. Hubrich, Kirstin, 2005. "Forecasting euro area inflation: Does aggregating forecasts by HICP component improve forecast accuracy?," International Journal of Forecasting, Elsevier, vol. 21(1), pages 119-136.
    21. Edwards, John B & Orcutt, Guy H, 1969. "Should Aggregation Prior to Estimation Be the Rule?," The Review of Economics and Statistics, MIT Press, vol. 51(4), pages 409-420, November.
    22. Martin Weale, 1988. "The Reconciliation of Values, Volumes and Prices in the National Accounts," Journal of the Royal Statistical Society Series A, Royal Statistical Society, vol. 151(1), pages 211-221, January.
    23. Solomos Solomou & Martin Weale, 1993. "Balanced Estimates of National Accounts When Measurement Errors are Autocorrelated: The Uk, 1920–38," Journal of the Royal Statistical Society Series A, Royal Statistical Society, vol. 156(1), pages 89-105, January.
    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. Pennings, Clint L.P. & van Dalen, Jan, 2017. "Integrated hierarchical forecasting," European Journal of Operational Research, Elsevier, vol. 263(2), pages 412-418.
    2. 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.
    3. 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.
    4. George Athanasopoulos & Rob J Hyndman & Nikolaos Kourentzes & Anastasios Panagiotelis, 2023. "Forecast Reconciliation: A Review," Monash Econometrics and Business Statistics Working Papers 8/23, Monash University, Department of Econometrics and Business Statistics.
    5. Spiliotis, Evangelos & Petropoulos, Fotios & Kourentzes, Nikolaos & Assimakopoulos, Vassilios, 2020. "Cross-temporal aggregation: Improving the forecast accuracy of hierarchical electricity consumption," Applied Energy, Elsevier, vol. 261(C).
    6. Jing Zeng, 2015. "Combining Country-Specific Forecasts when Forecasting Euro Area Macroeconomic Aggregates," Working Paper Series of the Department of Economics, University of Konstanz 2015-11, Department of Economics, University of Konstanz.
    7. Hendry, David F. & Hubrich, Kirstin, 2011. "Combining Disaggregate Forecasts or Combining Disaggregate Information to Forecast an Aggregate," Journal of Business & Economic Statistics, American Statistical Association, vol. 29(2), pages 216-227.
    8. Spiliotis, Evangelos & Petropoulos, Fotios & Kourentzes, Nikolaos & Assimakopoulos, Vassilios, 2018. "Cross-temporal aggregation: Improving the forecast accuracy of hierarchical electricity consumption," MPRA Paper 91762, University Library of Munich, Germany.
    9. Hubrich, Kirstin, 2005. "Forecasting euro area inflation: Does aggregating forecasts by HICP component improve forecast accuracy?," International Journal of Forecasting, Elsevier, vol. 21(1), pages 119-136.
    10. Jing Zeng, 2016. "Combining country-specific forecasts when forecasting Euro area macroeconomic aggregates," Empirica, Springer;Austrian Institute for Economic Research;Austrian Economic Association, vol. 43(2), pages 415-444, May.
    11. Rostami-Tabar, Bahman & Babai, Mohamed Zied & Ducq, Yves & Syntetos, Aris, 2015. "Non-stationary demand forecasting by cross-sectional aggregation," International Journal of Production Economics, Elsevier, vol. 170(PA), pages 297-309.
    12. Francisco Dias & Maximiano Pinheiro & António Rua, 2018. "A bottom-up approach for forecasting GDP in a data-rich environment," Applied Economics Letters, Taylor & Francis Journals, vol. 25(10), pages 718-723, June.
    13. WAN, Shui-Ki & WANG, Shin-Huei & WOO, Chi-Keung, 2012. "Total tourist arrival forecast: aggregation vs. disaggregation," LIDAM Discussion Papers CORE 2012039, Université catholique de Louvain, Center for Operations Research and Econometrics (CORE).
    14. Brüggemann, Ralf & Lütkepohl, Helmut, 2013. "Forecasting contemporaneous aggregates with stochastic aggregation weights," International Journal of Forecasting, Elsevier, vol. 29(1), pages 60-68.
    15. Carson, Richard T. & Cenesizoglu, Tolga & Parker, Roger, 2011. "Forecasting (aggregate) demand for US commercial air travel," International Journal of Forecasting, Elsevier, vol. 27(3), pages 923-941.
    16. Hendry, David F. & Hubrich, Kirstin, 2006. "Forecasting economic aggregates by disaggregates," Working Paper Series 589, European Central Bank.
    17. Cobb, Marcus P A, 2017. "Joint Forecast Combination of Macroeconomic Aggregates and Their Components," MPRA Paper 76556, University Library of Munich, Germany.
    18. Colin Bermingham & Antonello D’Agostino, 2014. "Understanding and forecasting aggregate and disaggregate price dynamics," Empirical Economics, Springer, vol. 46(2), pages 765-788, March.
    19. Silva, Felipe L.C. & Souza, Reinaldo C. & Cyrino Oliveira, Fernando L. & Lourenco, Plutarcho M. & Calili, Rodrigo F., 2018. "A bottom-up methodology for long term electricity consumption forecasting of an industrial sector - Application to pulp and paper sector in Brazil," Energy, Elsevier, vol. 144(C), pages 1107-1118.
    20. Diogo de Prince & Emerson Fernandes Marçal & Pedro L. Valls Pereira, 2022. "Forecasting Industrial Production Using Its Aggregated and Disaggregated Series or a Combination of Both: Evidence from One Emerging Market Economy," Econometrics, MDPI, vol. 10(2), pages 1-34, June.

    More about this item

    Keywords

    Bottom-up forecasting; combining forecasts; GLS regression; hierarchical forecasting; Moore-Penrose inverse; reconciling forecasts; top-down forecasting.;
    All these keywords.

    JEL classification:

    • C53 - Mathematical and Quantitative Methods - - Econometric Modeling - - - Forecasting and Prediction Models; Simulation Methods
    • C32 - Mathematical and Quantitative Methods - - Multiple or Simultaneous Equation Models; Multiple Variables - - - Time-Series Models; Dynamic Quantile Regressions; Dynamic Treatment Effect Models; Diffusion Processes; State Space Models
    • C23 - Mathematical and Quantitative Methods - - Single Equation Models; Single Variables - - - Models with Panel Data; Spatio-temporal Models

    NEP fields

    This paper has been announced in the following NEP Reports:

    Statistics

    Access and download statistics

    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:msh:ebswps:2007-9. 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: Professor Xibin Zhang (email available below). General contact details of provider: https://edirc.repec.org/data/dxmonau.html .

    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.