The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrial Average over a one$-$month period.

Develop a spreadsheet model for forecasting each of the stock prices using simple exponential smoothing with a smoothing constant of inline style text

$0\mathrm{.}3.$

end text

Compare your results to the output from Excel$$s Data Analysis tool.

Compute MAD, MSE, and MAPE.

Does a smoothing constant of inline style text

$0\mathrm{.}1$

end text or inline style text

$0\mathrm{.}5$

end text yield better results?