Chapter $9$ ProjectForecasting Techniques $1)$ The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrial Average over a one$-$month period.a$.$ Develop a model for forecasting one of the stock prices $($your choice$)$ using simple exponential smoothing $($in Data Analysis tool$)$ with a smoothing constant of $0\mathrm{.}1,0\mathrm{.}3,0\mathrm{.}5.$b$.$ Using MAD, MSE, and MAPE as a guidance, find the best smoothing constant. $2)$ Consider the prices for the Dow Jones Industrials in the Excel file Closing Stock Prices. Use simple linear regression to forecast the data. What would be the forecast for the next three days? $3)$ Consider the data in the Excel file Consumer Price Index. Use the double exponential smoothing procedure or Forecast Sheet to find forecasts for the next four years. $4)$ Develop a multiple regression model with categorical variables that incorporates seasonality for forecasting sales using the last three years of data in the Excel file New Car Sales, then use your model to predict sales for the next four months. Use Forecast Sheet to predict sales for the same four months and compare the two forecasts. $5)$ For the Holt$-$Winters Additive Model for Seasonality for forecasting Gas Usage use the spreadsheet to experiment with different values for a and g$,$ then find the best combination that minimizes MAD $($Hint: use the Data Table feature of Excel$).$ Forecast gas usage for the next month using the best combination of a and g$.$ Also, use Forecast Sheet to find the forecast for next year. $6)$ Data in the Excel file Microprocessor Data shows the demand for one type of chip used in industrial equipment from a small manufacturer.a$)$ Construct a chart of the data. What appears to happen when a new chip is introduced?b$)$ Develop a causal regression model to forecast demand that includes both time and the introduction of a new chip as explanatory variables.c$)$ What would the forecast be for the next month if a new chip is introduced? What would it be if a new chip is not introduced?