Subjects statistics

Mad Mape Calculation

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Mad Mape Calculation


1. **Stating the problem:** We have actual sales and two forecast methods (M1 and M2) for 6 days. We need to calculate: - MAD (Mean Absolute Deviation) for M1 and M2 - MAPE (Mean Absolute Percentage Error) for M1 and M2 2. **Formulas:** - MAD = $\frac{1}{n} \sum_{i=1}^n |\text{Actual}_i - \text{Forecast}_i|$ - MAPE = $\frac{100}{n} \sum_{i=1}^n \left| \frac{\text{Actual}_i - \text{Forecast}_i}{\text{Actual}_i} \right|$ 3. **Calculate absolute errors for each day:** |Day|Actual|M1 Forecast|M2 Forecast|$|Actual - M1|$|$|Actual - M2|$| |---|------|----------|----------|------------|------------| |Mon|16|13|20|$|16-13|=3$|$|16-20|=4$| |Tue|20|20|21|$|20-20|=0$|$|20-21|=1$| |Wed|30|29|32|$|30-29|=1$|$|30-32|=2$| |Thu|27|28|27|$|27-28|=1$|$|27-27|=0$| |Fri|17|17|14|$|17-17|=0$|$|17-14|=3$| |Sat|25|26|29|$|25-26|=1$|$|25-29|=4$| 4. **Calculate MAD:** - MAD M1 = $\frac{3+0+1+1+0+1}{6} = \frac{6}{6} = 1.00$ - MAD M2 = $\frac{4+1+2+0+3+4}{6} = \frac{14}{6} \approx 2.33$ 5. **Calculate MAPE:** - MAPE M1 = $\frac{100}{6} \left( \frac{3}{16} + \frac{0}{20} + \frac{1}{30} + \frac{1}{27} + \frac{0}{17} + \frac{1}{25} \right)$ = $\frac{100}{6} (0.1875 + 0 + 0.0333 + 0.0370 + 0 + 0.04) = \frac{100}{6} (0.2978) \approx 4.96\%$ - MAPE M2 = $\frac{100}{6} \left( \frac{4}{16} + \frac{1}{20} + \frac{2}{30} + \frac{0}{27} + \frac{3}{17} + \frac{4}{25} \right)$ = $\frac{100}{6} (0.25 + 0.05 + 0.0667 + 0 + 0.1765 + 0.16) = \frac{100}{6} (0.7032) \approx 11.72\%$ **Final answers:** - Method 1's MAD = 1.00 - Method 2's MAD = 2.33 - Method 1's MAPE = 4.96% - Method 2's MAPE = 11.72%