You wish to explore the relationship between two variables, X and Y, for 17 pati

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. In order (from patient 1 through patient 17), 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 slope for the regression equation using excel? Provide your answer with a level of accuracy of 1 decimal place.

Explanation / Answer

In excel input the columns of X and Y. Then go to data--> data analysis--> regression. Enter the columns of x and y.

The output:

The regression equation:

y =33.25 + 2.06*x

Slope= 2.06

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 Variable 2.06122 0.839742 2.454587 0.026799 0.271352 3.851088 0.271352 3.851088

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.