QUESTION 8 Use Excel to create a regression model at a confidence level of 0.95.
ID: 3341196 • Letter: Q
Question
QUESTION 8
Use Excel to create a regression model at a confidence level of 0.95. Based on your test results, pick the best conclusion.Caldulate the VIF for the model using PHStat.The VIF for the model is:
Less than 5, indicating collinearity between the two idependent variables.
Greater than 5, indicating collinearity between the two idependent variables.
Greater than 5, indicating insignificant collinearity between the two idependent variables.
Less than 5, indicating insignificant collinearity between the two idependent variables.
Less than 5, indicating collinearity between the two idependent variables.
Greater than 5, indicating collinearity between the two idependent variables.
Greater than 5, indicating insignificant collinearity between the two idependent variables.
Less than 5, indicating insignificant collinearity between the two idependent variables.
Online Quiz Data for Questions 6-8 Mulitivariate Linear Regression 16 29 48 28 15 37 24 32 47 13 43 12 34. 26 49 28 42 41 13 47 16 26 48 19Explanation / Answer
The multiple regression Test results are :
the variance inflation factor (VIF) quantifies the severity of multicollinearity in an ordinary least squares regression analysis. It provides an index that measures how much the variance (the square of the estimate's standard deviation) of an estimated regression coefficient is increased because of collinearity.
Here,
VIF = 1/(1 - R2 ) = 1 / (1 - 0.8449) = 6.447
Which is greater than 5, indicating collinearity between the two idependent variables. Option B is correct.
SUMMARY OUTPUT Regression Statistics Multiple R 0.919204 R Square 0.844935 Adjusted R Square 0.800631 Standard Error 6.821974 Observations 10 ANOVA df SS MS F Significance F Regression 2 1775.125 887.5623 19.07123 0.001468 Residual 7 325.7753 46.53933 Total 9 2100.9 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 5.045151 8.698264 0.580018 0.580084 -15.523 25.61328 -15.523 25.61328 x1 -0.05127 0.241343 -0.21245 0.837807 -0.62196 0.519412 -0.62196 0.519412 x2 0.887973 0.147521 6.019317 0.000532 0.539142 1.236804 0.539142 1.236804Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.