Using the data below, what is the value of MAD?

Be sure to show your work, all inputs, calculations and explain how you arrived at your answer.
Week1, Time series value=6, Forecast=3.00
Week2, Time series value=5, Forecast=5.00
Week3, Time series value=4, Forecast=5.00
Week4, Time series value=7, Forecast=5.00

1 answer

To calculate the Mean Absolute Deviation (MAD), we first need to understand the formula for MAD, which is defined as the average of the absolute differences between the actual values (time series values) and the forecasted values over a specified time period.

Steps to Calculate MAD:

  1. List the Time Series Values and Forecasts:

    • Week 1: Actual = 6, Forecast = 3.00
    • Week 2: Actual = 5, Forecast = 5.00
    • Week 3: Actual = 4, Forecast = 5.00
    • Week 4: Actual = 7, Forecast = 5.00
  2. Calculate the Absolute Deviations: For each week, we calculate the absolute deviation as follows: \[ \text{Absolute Deviation} = |\text{Actual} - \text{Forecast}| \]

    • Week 1: \[ |6 - 3| = |3| = 3 \]
    • Week 2: \[ |5 - 5| = |0| = 0 \]
    • Week 3: \[ |4 - 5| = |-1| = 1 \]
    • Week 4: \[ |7 - 5| = |2| = 2 \]

    Summary of Absolute Deviations:

    • Week 1: 3
    • Week 2: 0
    • Week 3: 1
    • Week 4: 2
  3. Sum the Absolute Deviations: Now, we add up all the absolute deviations: \[ \text{Sum of Absolute Deviations} = 3 + 0 + 1 + 2 = 6 \]

  4. Calculate the Mean Absolute Deviation (MAD): To find the MAD, we divide the total absolute deviations by the number of observations (in this case, 4 weeks): \[ \text{MAD} = \frac{\text{Sum of Absolute Deviations}}{\text{Number of Observations}} = \frac{6}{4} = 1.5 \]

Conclusion:

Thus, the Mean Absolute Deviation (MAD) for the given time series and forecasts is: \[ \boxed{1.5} \]