Data in the Excel File Microprocessor Data.xlsxshows the demand for one type of
Data in the Excel File Microprocessor Data.xlsxshows the demand for one type of chip used in industrial equipment from a small manufacturer.
Construct a combo chart of the data. What appears to happen when a new chip is introduced?
Develop a causal regression model to forecast demand that includes both time and the introduction of a new chip as explanatory variables.
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?
Instructions:
Write your answer in a Microsoft Excel document. Include the data set.
Criteria:
1. Chart of the data,
2. What appears to happen when a new chip is introduced? Conclusion from the chart,
3. Causal regression model
Calculation tables and model,
4. Forecast be for the next month if a new chip is introduced,
5. Forecast be for the next month if a new chip is not introduced