Problem $3.$

are shown in the next sheet named Super Bowl Data.

a$.$ Use a five$-$year moving average and forecast the cost of a $30$ second commercial for $2021.$

Show your solutions and Forecasted Cost for $2021$ using five year moving average on other sheets.

Write your final answer here.

b$.$ Compute the MAD and MSE and write their values here.

c$.$ Use a ten$-$year moving average and forecast the cost of a $30$ second commercial for $2021.$

Write your final answer here.

d$.$ Compute the MAD and MSE and write their values here.

e$.$ Which model, five$-$ or ten$-$year moving average, is a better predictor model and why? Fully explain.