Use Excel to Calculate MAD, MSE, RMSE & MAPE

Crystal ball

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, this is easy to do.
View the video here:

Download a copy of the Excel workbook here: Use Excel to Calculate MAD, MSE, RMSE & MAPE

Download Here

11 thoughts on “Use Excel to Calculate MAD, MSE, RMSE & MAPE”

    1. This is just an example of a typical forecast. You can develop your forecast using many different methods: simple regression or one of the many time-series methods. These error metrics can be applied to a variety of numerical forecasts.

  1. Thank you sir, this really good, I’ve been trying to get MAPE on every way in excel but didn’t work until i got this, thank you.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top