Acta Med. 2024, 67: 87-90
https://doi.org/10.14712/18059694.2025.3
Forecasting with Excel
References
1. Montgomery DC, Jennings CL, Kulahci M. Introduction to Time Series Analysis and Forecasting. New York: John Wiley & Sons, Ltd, 2015.
2. V. Write a Scientific Paper (WASP): Effective graphs and tables. Early Hum Dev; 134. Early Hum Dev. 2019 Jul: 134: 51–54.
<https://doi.org/10.1016/j.earlhumdev.2019.05.013>
3. Box GEP, Jenkins GM, Reinsel GC, et al. Time Series Analysis: Forecasting and Control. New York: John Wiley & Sons, Ltd, 2015.
4. Zaiontz C. Real Statistics Using Excel, www.real-statistics.com (2024).
5. Brown RG. Exponential Smoothing for Predicting Demand. Cambridge (MA): Little, 1956.
6. Holt CC. Forecasting trends and seasonals by exponentially weighted averages. O.N.R. Research Memorandum, 1957.
7. PR. Forecasting sales by exponentially weighted moving averages. Manage Sci. 1960; 6: 324–342.
<https://doi.org/10.1287/mnsc.6.3.324>
8. CC. Forecasting seasonals and trends by exponentially weighted moving averages. Int J Forecast. 2004; 20: 5–10.
<https://doi.org/10.1016/j.ijforecast.2003.09.015>
9. V, Pal S. Application of machine learning time series analysis for prediction COVID-19 pandemic. Res Biomed Eng. 2020; 1–13.
10. YJ, Yan Y, Timothy S. A comparative study of ARIMA and Holt-Winters exponential smoothing models for rice price forecasting in Tanzania. Open Access Libr J. 2021; 8: 1–9.
11. D. Statistical Time-Series Forecast via Microsoft Excel (FORECAST. ETS) Built-In Function. J Res Appl Math. 2021; 7: 69–73.
12. A, Sousa I, Dória-Nóbrega S. Forecasting daily admissions to an emergency department considering single and multiple seasonal patterns. Healthc Anal. 2023; 3: 100146.
<https://doi.org/10.1016/j.health.2023.100146>
13. B, Zenteno AC, Joseph D, et al. Forecasting hospital-level COVID-19 admissions using real-time mobility data. Commun Med. 2023; 3: 25.
<https://doi.org/10.1038/s43856-023-00253-5>
<PubMed>
14. L, Zhao P, Wu D, et al. Time series model for forecasting the number of new admission inpatients. BMC Med Inform Decis Mak. 2018; 18: 39.
<https://doi.org/10.1186/s12911-018-0616-8>
<PubMed>
