SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES The following table represents

Question

SYSTOLIC AND DIASTOLIC BLOOD PRESSURE OF FEMALES The following table represents systolic and diastolic blood pressure measurements of 40 females. A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements. B) Use the Excel Analysis ToolPak to determine the linear regression equation that uses the systolic pressure to predict the diastolic pressure. C) What is the best predicted value for diastolic pressure given that a woman has a systolic level of 100?

Please type the regression equation:

C) Predicted diastolic pressure. Show calculations of predicted diastolic pressure.

SYS DIAS 104 61 99 64 102 65 114 76 94 58 101 66 108 61 104 41 123 72 93 61 89 56 112 62 107 48 116 62 181 102 98 61 100 53 127 74 107 67 116 71 97 64 155 85 106 59 110 70 105 69 118 82 133 83 113 75 113 66 107 67 95 59 108 72 114 79 104 73 125 73 124 85 92 46 119 81 93 64 106 64

Explanation / Answer

sol)

From Excel

a) The correlation coefficient is=0.7854

b) The regression equation is

y=32.85 +1.156 (x)

c)

Now Predict y when x=100

The fitted Regression model is

y=32.85 +1.156 (100)

y=148.45

SUMMARY OUTPUT Regression Statistics Multiple R 0.785369 R Square 0.616805 Adjusted R Square 0.606721 Standard Error 10.7324 Observations 40 ANOVA df SS MS F Significance F Regression 1 7045.39 7045.39 61.16615 1.96E-09 Residual 38 4377.01 115.1845 Total 39 11422.4 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 32.85378 10.10986 3.249677 0.002421 12.38744 53.32013 DIAS 1.156043 0.147815 7.820879 1.96E-09 0.856807 1.455279

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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