MAPE

When using Solver for the alpha, I am getting the message that the objective cell contents has to be a formula. Has anyone run into this problem?

If you think about it, Solver is doing nothing more than running many iterations of the equations that calculate the objective. For forecasts, this is MAPE or MSE, etc. You have to have links from your objective cell back to the cells you want Solver to change. Inspect the following graphic that shows the linkage …

When using Solver for the alpha, I am getting the message that the objective cell contents has to be a formula. Has anyone run into this problem? Read More »

Use Excel to Calculate MAD, MSE, RMSE & MAPE

To optimize your forecast, whether moving average, exponential smoothing or another form of a forecast, you need to calculate and evaluate MAD, MSE, RMSE, and MAPE. With Excel 2016 or later, this is easy to do. The Mean Absolute Deviation (MAD) is the sum of absolute differences between the actual value and the forecast divided …

Use Excel to Calculate MAD, MSE, RMSE & MAPE Read More »