2013
DOI: 10.19030/ajbe.v6i3.7815
|View full text |Cite
|
Sign up to set email alerts
|

Determining The Optimal Values Of Exponential Smoothing Constants Does Solver Really Work?

Abstract: A key issue in exponential smoothing is the choice of the values of the smoothing constants used.One approach that is becoming increasingly popular in introductory management science and operations management textbooks is the use of Solver, an Excel-based non-linear optimizer, to identify values of the smoothing constants that minimize a measure of forecast error like Mean Absolute Deviation (MAD) or Mean Squared Error (MSE).We point out some difficulties with this approach and suggest an easy fix. We examine … Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
2
1
1
1

Citation Types

0
9
0

Year Published

2017
2017
2024
2024

Publication Types

Select...
4
3
2

Relationship

0
9

Authors

Journals

citations
Cited by 16 publications
(10 citation statements)
references
References 6 publications
0
9
0
Order By: Relevance
“…We used the generalized reduced gradient as the optimization algorithm [134], which searches for the extreme values of the functions by the generalized reduced gradient algorithm method (GRG2) [135][136][137][138]. We used the multi-start method to find a globally optimal solution [139,140]. The multi-start method operates by generating candidate starting point values randomly selected between the bounds specified for the variables.…”
Section: Goodness-of-fit Testsmentioning
confidence: 99%
See 1 more Smart Citation
“…We used the generalized reduced gradient as the optimization algorithm [134], which searches for the extreme values of the functions by the generalized reduced gradient algorithm method (GRG2) [135][136][137][138]. We used the multi-start method to find a globally optimal solution [139,140]. The multi-start method operates by generating candidate starting point values randomly selected between the bounds specified for the variables.…”
Section: Goodness-of-fit Testsmentioning
confidence: 99%
“…As the number of runs of the non-linear iterations increases, the probability that the globally optimal solution has been found also increases 100%. For most non-linear problems, this method will at least yield very good solutions [140]. In this study, 1000 starting points have been used for each model and watershed.…”
Section: Goodness-of-fit Testsmentioning
confidence: 99%
“…With spatial and temporal variability of floating cars in the overall traffic, the traditional single exponential smoothing algorithm is modified so that a suitable forecast can be produced in case of missing data in a time interval. The value of smoothing constant (α) is selected as 0.2 suggested by [23] and [24]. The proposed algorithm (see Fig.…”
Section: A Link-level Speed Forecastingmentioning
confidence: 99%
“…In some of the works, authors used classical non-linear optimization methods with constrained values of variables, to optimize HW parameters. In [47] authors used the MS Excel Nonlinear Solver, a spreadsheet-based non-linear optimizer, to find the values of the smoothing parameters, together with an initial forecast that minimize a measure of forecast error MAD or MSE. A detailed description is given to avoid problems reported by several other authors.…”
Section: Review Of Predictive and Not Predictive Algorithms For Real-mentioning
confidence: 99%