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
