$1.$ Generate as many valid forecasts as you can for a five$-$period moving average, a six$-$period moving average, a $7-$period moving average,$1.$ Generate as many valid forecasts as you can for a five$-$period moving average, a six$-$period moving average, a $7-$period moving average,$1.$ Generate as many valid forecasts as you can for a five$-$period moving average, a six$-$period moving average, a $7-$period moving average,$1.$ Generate as many valid forecasts as you can for a five$-$period moving average, a six$-$period moving average, a $7-$period moving average, Generate as many valid forecasts as you can for a five$-$period moving average, a six$-$period moving average, a $7-$period moving average,

nd a weighted average forecasts with weights $0\mathrm{.}4,0\mathrm{.}3,0\mathrm{.}2,$ and $0\mathrm{.}1$ for the most recent data, the next most recent data, and so forth, respectively.

Calculate MAD for each forecast. Insert columns as necessary.

Recommend a forecast and explain why that is your choice.

$.$ Use Excel for all calculations.