You wish to explore the relationship between two variables, X and Y, for 17 pati
ID: 3307355 • Letter: Y
Question
You wish to explore the relationship between two variables, X and Y, for 17 patients for purposes of predicting the value of Y, given the value of X. Their corresponding values for X are: 9, 15, 10, 16, 10, 20, 11, 20, 15, 15, 8, 13, 18, 10, 8, 10, 16 and the matching (corresponding) values of Y: 45, 57, 45, 51, 65, 88, 44, 87, 89, 59, 66, 65, 56, 47, 66, 41, 56. Given this information, what is the value of the intercept for the regression equation? Provide your answer with a level of accuracy of 1 decimal place.
Explanation / Answer
Perform Regression in Excel
data analysis--->Regression
Regression eq is
Y=33.3+2.1X
SLOP E=2.1
Y INTERCEPT=33.3
SUMMARY OUTPUT Regression Statistics Multiple R 0.535316 R Square 0.286564 Adjusted R Square 0.239001 Standard Error 13.50055 Observations 17 ANOVA df SS MS F Significance F Regression 1 1098.145 1098.145 6.024998 0.026799 Residual 15 2733.972 182.2648 Total 16 3832.118 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 33.25216 11.53915 2.881681 0.011411 8.65704 57.84728 8.65704 57.84728 X 2.06122 0.839742 2.454587 0.026799 0.271352 3.851088 0.271352 3.851088Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.