Work on the following problems using Excel. Use the attached Excel file $$ClosingStockPrices$$ containing the dataset required. Show all steps in Excel where required. Also make sure your solution file is uploaded into Canvas in Excel format. Please note that this case assignment $2$ accounts for $20\%$ of your total course grade. 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 constance of $0\mathrm{.}3.$