What Excel function/feature should be used to minimize the mean squared error for an exponential smoothing model?
A) Solver
B) =EXPON
C) =ALPHA
D) Goal seek
Correct Answer:
Verified
Q63: The measure of forecast error where the
Q64: What is the forecast for June using
Q65: The _ is a good measure of
Q66: The measure of whether a forecast method
Q67: Use Solver to determine the alpha
Q69: The measure of forecast error where the
Q70: What Excel function/feature should be used to
Q71: The measure of forecast error where the
Q72: What is the mean absolute percentage error?
A)5.24%
B)5.61%
C)5.40%
D)5.06%
Q73: Describe the basic characteristics of forecasts that
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents