“Forecasting Demand for Industrial Chips Using Causal Regression Model”

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