Suppose that you intend to use Solver to compute the optimal weights for a weighted moving average.Changing variable cells would refer to:
A)the MAD cell
B)the MSE cell
C)the MAPE cell
D)the weights cells
E)the forecast cells

Question

Quizplus · Accepted Answer

Changing variable cells in Solver refer to the cells that contain the values that will be optimized to achieve the desired result. In this case, the weights cell should be the changing variable cell as it contains the values that we want Solver to adjust to minimize the error in the forecast.

Suppose That You Intend to Use Solver to Compute the Optimal