Question $1$

Given the forecast Data Given, Calculate the MAD $($mean absolute$$ deviation$)$ for $2019$ using a three month moving average.

$$

Question $2$

Given the Forecast Data and your forecast using a three month moving average, what is the tracking signal for $2019?($remember that the tracking signal is sum of errors$/$ MAD$)$

$$

Question $3$

Given the forecast Data Given, Calculate the MAD $($mean absolute$$ deviation$)$ for $2020$ using a three month moving average.

$$

Question $4$

Given the Forecast Data and your forecast using a three month moving average, what is the tracking signal for $2020?($remember that the tracking signal is sum of errors$/$ MAD$)$

$$

Question $5$

Given the forecast Data Given, Calculate the MAD $($mean absolute$$ deviation$)$ for $2021$ using a three month moving average.

$$

Question $6$

Given the Forecast Data and your forecast using a three month moving average, what is the tracking signal for $2021?($remember that the tracking signal is sum of errors$/$ MAD$)$

$$

Question $7$

Given the sales data for the spinners, graph this in Excel.$($Use a line$)$ Which possible aspect of the data is most prominent?

Trend

Randomness

Seasonality

Cyclicality