- MAD is a universally accepted forecast error measurement.
- MAD is generally low in effectiveness in providing feedback to improve the forecast.
Video Introduction: How MAD is Calculated for Forecast Error Measurement
Text Introduction (Skip if You Watched the Video)
MAD or Mean Absolute Deviation is one of the most common forecast error measurement in use. MAD is moderately easy to understand and relatively easy to calculate. However, when MAD is used, in most cases, the problems with MAD are not explained to the audience, which is an issue that also generalizes to the other primary forecast error measurement calculations. At Brightwork, we do not use MAD when we perform forecast analysis. In this article, you will learn about the issues with MAD that reduce the ability of a person or company to improve their forecast accuracy.
Our References for This Article
If you want to see our references for this article and other related Brightwork articles, visit this link.
How MAD is Calculated
How MAD is calculated is one of the most common questions we get.
MAD is calculated as follows.
- Find the mean of the actuals.
- Subtract the mean of the actuals from the forecast and use the absolute value.
- Add all of the errors together.
- Divide by the number of data points.
The formula is..
MA = Mean of Actuals
= SUM(ABS(F – MA))/# of Data Points
The Broader Context of How MAD is Calculated
Like MAPE, MAD uses absolute values, so one does not understand the bias. But because MAD is squared, the error is not proportional — meaning that larger errors become much larger as they are squared. Any error measurement that is not proportional makes it intuitively more difficult to understand than a proportional measure. How is, particularly, a nonforecasting focused person supposed to interpret non-proportional forecast errors? Our brain is designed to understand proportionality.
For example, the Richter Scale is a logarithmic scale, which allows a relatively small number of values to represent large magnitudes in difference. However, it also means that humans cannot calculate the difference between different earthquake values.
The Same Problem With All the Standard Forecast Error Measurements
How MAD is calculated is one of the most common questions we get. But the narrow question broadens out when one looks at the different dimensions of forecast error.
Due to its lack of proportionality, MAD was never a forecast error method before developing our own. However, in addition to this lack of proportionality, MAD shares the same problems with all standard forecast error measurements.
These include the following:
- They are difficult to weigh. And any forecast error aggregated beyond the product location combination must be weighed to make any sense.
- They make comparisons between different forecasting methods overly complicated.
- They lack the context of the volume of the demand history or the price of the product being forecasted, meaning that the forecast errors must be provided with context through another formula.
- They are difficult to explain, making them less intuitive than a different approach.