Open the MS Excel file WB$7.$xlsx$.$

Add five columns with single smoothing forecasts for different values of $\backslash$alpha $(0\mathrm{.}15,0\mathrm{.}30,0\mathrm{.}45,0\mathrm{.}60,$ and $0\mathrm{.}75).$

Calculate the corresponding MSEs for each value of $\backslash$alpha $.$

Create a time series graph for every $\backslash$alpha value, comparing the actual and forecasted figures.

Estimate the demand for baby diapers in the clinic for period $25$ using the model that shows the best fit.

Requirements

Submit the Excel file with your calculations, along with a Word file with your comments as Assignment E$-11.$

Attachments

WB$7.$xlsx

$(8\mathrm{.}91$ KB$)$