This has to be in a Execl Sheet. There is a document of the Full Questions. A rental car manager estimates the number of full$-$size sedans rented per week so that she can maintain an adequate number of cars in the lot. Data for the past $10$ weeks are shown here:

a$)$ Prepare a forecast through week $11$ by using a five$-$week moving average.

b$)$ Prepare a forecast through week $11$ by using a $3-$period weighted moving average, giving the weight of $0\mathrm{.}5$ to the most recent week, $0\mathrm{.}3$ to the second week and $0\mathrm{.}2$ to the third week.

c$)$ Prepare a forecast using exponential smoothing method with $=0\mathrm{.}2.$ Forecast for week $1$ was $22.$

d$)$ Prepare a forecast through week $11$ by using a regression model $Y=26\mathrm{.}33+0\mathrm{.}3212x$

e$)$ Which method is preferred for this data if mean absolute deviation $($MAD$)$ is used?

f$)$ Make a recommendation for the number of full$-$size sedans for a week.