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: https://studio.youtube.com/video/H_N5_vxs8Tg/edit

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

James ThompsonThanks for the help, professor!

senghour khimAmazing!

Yusrina FikriyaThank you

Dawn WrightThank you for the positive feedback!

khalid aljaberihow did you get the forecast

Dawn WrightThis 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.

LourdesThank you!!

SeyiGod bless you richly, please I need such on AIC, BIC and loglikelihood. Thanks

ekaThank 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.