This is a homework question I am stuck on . Thanks for any help. The data below
ID: 3126860 • Letter: T
Question
This is a homework question I am stuck on . Thanks for any help.
The data below shows the demand for one type of chip used for industrial equipment from a small manufactor. Construct a chart of the data what appears to happen when a new chip is introduced ? Develop a casual regression model to forecast that include both time and the introduction of a new chip as explanatory variables . what would the forecast be if a new chip was introduced and and what would it be if a new chip was not introduced?
Microprocessor Data Demand Month New Chip Introduced 3949 1 0 3544 2 0 6138 3 0 7752 4 0 10700 5 1 7766 6 0 5482 7 0 8789 8 0 13103 9 1 7326 10 0 8669 11 0 7219 12 0 7456 13 0 9744 14 0 14561 15 1 8564 16 0 12214 17 0 19020 18 1 14751 19 0 14269 20 0 14896 21 0 15359 22 0 16527 23 0 17029 24 0Explanation / Answer
The data below shows the demand for one type of chip used for industrial equipment from a small manufactor. Construct a chart of the data what appears to happen when a new chip is introduced ? Develop a casual regression model to forecast that include both time and the introduction of a new chip as explanatory variables . what would the forecast be if a new chip was introduced and what would it be if a new chip was not introduced?
Regression Analysis
R²
0.892
Adjusted R²
0.881
n
24
R
0.944
k
2
Std. Error
1513.459
Dep. Var.
Demand
ANOVA table
Source
SS
df
MS
F
p-value
Regression
395,804,463.8379
2
197,902,231.9189
86.40
7.35E-11
Residual
48,101,746.1205
21
2,290,559.3391
Total
443,906,209.9583
23
Regression output
confidence interval
variables
coefficients
std. error
t (df=21)
p-value
95% lower
95% upper
Intercept
3,097.1830
658.7939
4.701
.0001
1,727.1461
4,467.2199
Month
535.5705
44.6820
11.986
7.44E-11
442.6493
628.4917
New Chip Introduced
4,955.8635
829.9307
5.971
6.31E-06
3,229.9281
6,681.7988
The regression line is
Demand =3097.18+535.57*t+4955.86*new chip
if a new chip was not introduced, Demand =3097.18+535.57*t
( prediction for month t)
if a new chip was introduced,
Demand =3097.18+535.57*t+4955.86
Demand = 8053.04+535.57*t
Regression Analysis
R²
0.892
Adjusted R²
0.881
n
24
R
0.944
k
2
Std. Error
1513.459
Dep. Var.
Demand
ANOVA table
Source
SS
df
MS
F
p-value
Regression
395,804,463.8379
2
197,902,231.9189
86.40
7.35E-11
Residual
48,101,746.1205
21
2,290,559.3391
Total
443,906,209.9583
23
Regression output
confidence interval
variables
coefficients
std. error
t (df=21)
p-value
95% lower
95% upper
Intercept
3,097.1830
658.7939
4.701
.0001
1,727.1461
4,467.2199
Month
535.5705
44.6820
11.986
7.44E-11
442.6493
628.4917
New Chip Introduced
4,955.8635
829.9307
5.971
6.31E-06
3,229.9281
6,681.7988
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.