$(Slove$ this $on$ Excel please$)$ Twelve$-$day moving average forecasts for January ${16}^{th}$ through January ${30}^{th}$ using

the original $(seasonalized)$ sales data. $(3pts)$

Note that, for example, you will not $be$ able $to$ make a four$-$day moving average forecast for

January $7^{th}$ since four previous sales figures are required.

Question Set $2.$ Using only the Memphis sales data:

Forecast sales for January $7^{th}$ through January ${30}^{th}$ using a three$-$day weighted moving

Find the mean $absolute$ deviation $of$ the sales forecasts for January $7^{th}$ through January ${29}^{th}.$

You should not include the forecast for January ${30}^{th}$ since there $isno$ corresponding sales figure

Find the mean squared error $of$ the sales forecasts, again for January $7^{th}$ through January ${29}^{th}.$

Create a scatter scatter$-$chart for the three$-$day weighted moving average. Label your chart axes

Question Set $3.$ Using only the Atlanta sales data:

Forecast sales for January $5^{th}$ through January ${30}^{th}$ using exponential smoothing with alpha

set $to0\mathrm{.}6.$ Assume the sales forecast for January $4^{th}$ was $675.(6pts)$

Using your forecasts from $Q3\mathrm{.}1,$ find the mean $absolute$ deviation $of$ the sales forecasts for

January $5^{th}$ through January ${29}^{th}.$ Again, you should not include the forecast for January ${30}^{th}$

since there $isno$ corresponding sales figure for that date. $(4pts)$

Using your forecasts from $Q3\mathrm{.}1,$ find the mean squared error $of$