A doctor wanted to determine whether the relation between a males age and his HD

Question

A doctor wanted to determine whether the relation between a males age and his HD Al (so-called good) cholesterol. The doctor randomly selected 17 of his patients in determining HDL cholesterol. The data obtained by the doctor is that in the data table below complete parts a through F below: age, X 36 44 46 32 55 53 61 61 28 38 65 32 50 27 51 49 41 cholesterol, Y 56, 53, 32, 55, 36, 41, 41, 37, 45, 45, 64, 52, 34, 45, 38, 54, 28. assuming the residuals are normally distributed, construct a 95% confidence interval about the slope of the true least square regression line A doctor wanted to determine whether the relation between a males age and his HD Al (so-called good) cholesterol. The doctor randomly selected 17 of his patients in determining HDL cholesterol. The data obtained by the doctor is that in the data table below complete parts a through F below: age, X 36 44 46 32 55 53 61 61 28 38 65 32 50 27 51 49 41 cholesterol, Y 56, 53, 32, 55, 36, 41, 41, 37, 45, 45, 64, 52, 34, 45, 38, 54, 28. assuming the residuals are normally distributed, construct a 95% confidence interval about the slope of the true least square regression line A doctor wanted to determine whether the relation between a males age and his HD Al (so-called good) cholesterol. The doctor randomly selected 17 of his patients in determining HDL cholesterol. The data obtained by the doctor is that in the data table below complete parts a through F below: age, X 36 44 46 32 55 53 61 61 28 38 65 32 50 27 51 49 41 cholesterol, Y 56, 53, 32, 55, 36, 41, 41, 37, 45, 45, 64, 52, 34, 45, 38, 54, 28. assuming the residuals are normally distributed, construct a 95% confidence interval about the slope of the true least square regression line

Explanation / Answer

We can solve this question using excel.

First enter data into excel.

Click on Data -------> Data Analysis --------> Regression ------->

Input

Input Y Range : select y values

Input X Range :select values of x.

Output Range : select any empty cell

---------> ok

We get

So 95% confidence interval about the slope of the true least square regression line is ( - 0.57402 , 0.337793)

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 49.81353 9.983776 4.989447 0.000162 28.53361 71.09344 28.53361 71.09344 X -0.11811 0.213895 -0.55221 0.588941 -0.57402 0.337793 -0.57402 0.337793

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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