Setting the Initial Value for Single Exponential Smoothing and the Value of the Smoothing Constant for Forecasting Using Solver in Microsoft Excel
Source abstract
Abstract
Although single exponential smoothing is a popular forecasting method for a wide range of applications involving stationary time series data, consistent rules about choosing the initial value and determining the value for the smoothing constant (α) are still required, because they directly impact the forecast accuracy. The purpose of this study is to mitigate these shortcomings. First, a new method for setting the initial value by weighting is derived, and its performance is compared with two other traditional methods. Second, the optimal (α) was automatically solved using Solver in Microsoft Excel, after which 𝛼 was determined by minimizing the mean squared error (MSE). This was accomplished by comparing the 𝛼 from Solver with step search by setting the smoothing constant by varying its value from 0.001 to 1 in increments of 0.001 and then choosing the optimal 𝛼 value from this range that has the lowest MSE. The experimental results show that 𝛼 from Solver and the optimal 𝛼 with step search are not different, and the initial value set by the proposed method outperformed the existing ones regarding the MSE.
Source: crossref · Quality: baseline
Research context
OpenAlex topics: Forecasting Techniques and Applications · Statistical and numerical algorithms · Stock Market Forecasting Methods
SciVX discovery tags are terminology-based. OpenAlex topics are source-provided classifications.
Affiliations
Department of Statistics, Faculty of Science, Khon Kaen University, Khon Kaen 40002, Thailand
Department of Statistics, Faculty of Science, Kasetsart University, Bangkok 10900, Thailand
Funding
International SciKU Branding
References (34)
Show source-provided references
1. A state space framework for automatic forecasting using exponential smoothing methods10.1016/S0169-2070(01)00110-8 ↗
2. The impact of exponential smoothing forecasts on the bullwhip effect10.1002/(SICI)1520-6750(200006)47:4<269::AID-NAV1>3.0.CO;2-Q ↗
3. Forecasting electricity consumption in Pakistan: The way forward10.1016/j.enpol.2015.11.028 ↗
4. Forecasting from time series subject to sporadic perturbations: Effectiveness of different types of forecasting support10.1016/j.ijforecast.2017.09.007 ↗
5. The analysis of cigarette production using double exponential smoothing model
6. The effect on forecasting accuracy of the Holt-Winters Method when using the incorrect model on a non-stationary time series
7. A study of the exponential smoothing technique in software reliability growth prediction10.1002/(SICI)1099-1638(199711/12)13:6<347::AID-QRE116>3.0.CO;2-O ↗
8. Schroeder, R.G., Goldstein, S.M., and Rungtusanatham, M.J. (2013). Operations Management in the Supply Chain: Decisions and Cases, McGraw-Hill/Irwin.
9. Jacobs, F.R., and Chase, R.B. (2013). The Core, McGraw-Hill Higher Education. [3rd ed.]. Chapter 3.
10. Determination of exponential smoothing constant to minimize mean square error and mean absolute deviation
11. Improving demand forecasting accuracy using nonlinear programming software10.1057/palgrave.jors.2601941 ↗
12. Chopra, S., Meindl, P., and Kalra, D.V. (2013). Supply Chain Management: Strategy, Planning, and Operation, Pearson Education.
13. Nariman, N.A., Hamdia, K., Ramadan, A.M., and Sadaghian, H. (2021). Optimum Design of Flexural Strength and Stiffness for Reinforced Concrete Beams Using Machine Learning. Appl. Sci., 11.10.3390/app11188762 ↗
14. Determining The Optimal Values Of Exponential Smoothing Constants Does Solver Really Work?
15. Chopra, S., and Meindl, P. (2013). Supply Chain Management: Strategy, Planning, and Operation, Prentice Hall. [5th ed.]. Chapter 7.
16. Bermudez, J.D., Segura, J.V., and Velcher, E. (2013). Managerial Decision Modeling with Spreadsheets, Prentice Hall. [3rd ed.].
17. Some comments on the initialization of exponential smoothing10.1002/for.3980030109 ↗
18. Brown, R.G. (1959). Statistical Forecasting for Inventory Control, McGraw-Hill.
19. Bayesian adjustment of sales forecasts in multi-item inventory control systems
20. Operations Research in Production Planning, Scheduling and Inventory Control10.1057/jors.1975.120 ↗
21. Volatility forecasting with smooth transition exponential smoothing10.1016/j.ijforecast.2003.09.010 ↗
22. Makridakis, S., Wheelwright, S.C., and Hyndman, R.J. (2008). Forecasting Methods and Applications, John Wiley & Sons.
23. University of Duke (2023, January 11). Averaging and Exponential Smoothing Models. Available online: https://people.duke.edu/~rnau/Decision411_2007/411avg.htm.
24. Analysis and forecasting of wind velocity in chetumal, quintana roo, using the single exponential smoothing method10.1016/j.renene.2009.10.037 ↗
25. Comparative Analysis of single exponential smoothing and Holt’s Method for quality of hospital services forecasting in general hospital10.25008/bcsee.v1i2.8 ↗
26. Improvement of the Holt-Winters Multiplicative Method with a New Initial Value Settings Method
27. Prediksi inflasi di indonesia menggunakan metode moving average, single exponential smoothing dan double exponential smoothing
28. A review of forecasting models for new products
29. Brown, R.G. (1962). Smoothing, Forecasting and Prediction of Discrete Time Series, Prentice-Hall.
30. Exponential smoothing: The state of the art—Part II10.1016/j.ijforecast.2006.03.005 ↗
31. Hyndman, R.J., and Athanasopoulos, G. (2018). Forecasting: Principles and Practice, OTexts.
32. Clements, M., and Hendry, D. (1998). Forecasting Economic Time Series, Cambridge University Press.10.1017/CBO9780511599286 ↗
33. The M3-Competition: Results, conclusions and implications10.1016/S0169-2070(00)00057-1 ↗
34. (2023, January 11). The R Project for Statistical Computing. Available online: https://www.r-project.org/.