How to set up Excel to calculate the Mean Absolute Deviation (MAD) the Mean Square Error (MSE), The Root Mean Square Error (RMSE), and the Mean Absolute Percentage Error (MAPE). If you have zero or near zero actual values, you can use SMAPE instead of MAPE. You can download the latest version (August 2021) of the Excel worksheet here: https://www.drdawnwright.com/use-excel-to-calculate-mad-mse-rmse-mape/
See the next video to learn how to evaluate them. https://youtu.be/vxtxrcdmqbw

Please take the opportunity to connect and share this video with your friends and family if you find it useful.