QUESTION 4 Use Excel to create a regression model at a confidence level of 0.95.
ID: 3341193 • Letter: Q
Question
QUESTION 4
Use Excel to create a regression model at a confidence level of 0.95. Based on your test results, pick the best conclusion. The upper and lower confidence interval values for x indicate that:
The independent variable is significant because the interval contains zero.
The independent variable is significant because the interval does not contain zero.
The independent variable is not significant because the interval contains zero.
The independent variable is not significant because the interval is too large.
The independent variable is significant because the interval contains zero.
The independent variable is significant because the interval does not contain zero.
The independent variable is not significant because the interval contains zero.
The independent variable is not significant because the interval is too large.
Online Quiz - Data for Questions 1-5 Simple Linear Regression 30.3 4.8 15.2 24.9 8.6 20.1 9.3 11.2 14.6 27.9 17.6 15.3 19.8 13.2 25.6 19.4Explanation / Answer
The regression Test results are
Here at the confidence interval 0.95
The upper and lower confidence interval of independent variable (X) is
(-0.82085 , -0.16377)
so that interval doesn't consists the vaue of Zero so that means independent variable is significant here. Option B is correct here.
SUMMARY OUTPUT Regression Statistics Multiple R 0.831523 R Square 0.69143 Adjusted R Square 0.640002 Standard Error 3.142123 Observations 8 ANOVA df SS MS F Significance F Regression 1 132.7374 132.7374 13.44456 0.010496 Residual 6 59.23764 9.872939 Total 7 191.975 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 26.83046 2.364997 11.34482 2.81E-05 21.04352 32.6174 21.04352 32.6174 x -0.49231 0.134267 -3.66668 0.010496 -0.82085 -0.16377 -0.82085 -0.16377Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.