I can get to the answers on excel but i don\'t know how to plug them in. please

Question

I can get to the answers on excel but i don't know how to plug them in. please help Systolic Blood Pressure Age
in years Weight in pounds Directions:

Data on blood pressure, age and weight were collected on 11 patients at a local walk-in clinic.

Systolic blood pressure is the maximum pressure your heart exerts while beating. (Diastolic pressure is the pressure in your veins between beats).

Using Systolic pressure as the dependent variable, perform a regression analysis on the data to the left, then answer the questions shown below. Type your response in the box below the question. Put your regression output in the area below,
beginning in cell G5. 132 52 173 SUMMARY OUTPUT 143 59 184 153 67 194 Regression Statistics 162 73 211 Multiple R 0.988355758 154 64 196 R Square 0.976847104 168 74 220 Adjusted R Square 0.97105888 137 54 188 Standard Error 2.318211131 149 61 188 Observations 11 159 65 207 128 46 167 ANOVA 166 72 217 df SS MS F Significance F Regression 2 1813.916268 906.9581341 168.7645659 2.87357E-07 1. What is the multiple regression equation for this data? (Use actual numbers, not "b0", "b1" and "b2") Residual 8 42.99282278 5.374102848 Total 10 1856.909091 2. Are age and weight significant predictors of systolic blood pressure? How do you know? Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 30.99410295 11.94378039 2.594999401 0.031864509 3.451695983 58.53650992 3.451695983 58.53650992 Age
in years 0.861414686 0.248231411 3.470208241 0.008440159 0.288992027 1.433837346 0.288992027 1.433837346 3. A person is 50 years old and weighs 200 pounds. Predict their systolic blood pressure. Weight in pounds 0.334859197 0.130668274 2.56266641 0.033507671 0.033537617 0.636180778 0.033537617 0.636180778 I can get to the answers on excel but i don't know how to plug them in. please help Systolic Blood Pressure Age
in years Weight in pounds Directions:

Data on blood pressure, age and weight were collected on 11 patients at a local walk-in clinic.

Systolic blood pressure is the maximum pressure your heart exerts while beating. (Diastolic pressure is the pressure in your veins between beats).

Using Systolic pressure as the dependent variable, perform a regression analysis on the data to the left, then answer the questions shown below. Type your response in the box below the question. Put your regression output in the area below,
beginning in cell G5. 132 52 173 SUMMARY OUTPUT 143 59 184 153 67 194 Regression Statistics 162 73 211 Multiple R 0.988355758 154 64 196 R Square 0.976847104 168 74 220 Adjusted R Square 0.97105888 137 54 188 Standard Error 2.318211131 149 61 188 Observations 11 159 65 207 128 46 167 ANOVA 166 72 217 df SS MS F Significance F Regression 2 1813.916268 906.9581341 168.7645659 2.87357E-07 1. What is the multiple regression equation for this data? (Use actual numbers, not "b0", "b1" and "b2") Residual 8 42.99282278 5.374102848 Total 10 1856.909091 2. Are age and weight significant predictors of systolic blood pressure? How do you know? Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 30.99410295 11.94378039 2.594999401 0.031864509 3.451695983 58.53650992 3.451695983 58.53650992 Age
in years 0.861414686 0.248231411 3.470208241 0.008440159 0.288992027 1.433837346 0.288992027 1.433837346 3. A person is 50 years old and weighs 200 pounds. Predict their systolic blood pressure. Weight in pounds 0.334859197 0.130668274 2.56266641 0.033507671 0.033537617 0.636180778 0.033537617 0.636180778

Explanation / Answer

Everthing asked has been solved below.

Regression Equation

Model Summary

Coefficients

Analysis of Variance

Regression Equation

Systolic Blood Pressure = 31.0 + 0.861 Age in Years + 0.335 Weight in Pounds

Model Summary

S R-sq R-sq(adj) R-sq(pred) 2.31821 97.68% 97.11% 95.35%

Coefficients

Term Coef SE Coef T-Value P-Value VIF Constant 31 11.9 2.59 0.032 Age in Years 0.861 0.248 3.47 0.008 9.53 Weight in Pounds 0.335 0.131 2.56 0.034 9.53

Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value Regression 2 1813.92 906.958 168.76 0 Age in Years 1 64.72 64.717 12.04 0.008 Weight in Pounds 1 35.29 35.293 6.57 0.034 Error 8 42.99 5.374 Total 10 1856.91 Yes the age and weight are significant predictors as the P calue is less than 0.05 for both the parameters Systolic Blood Pressure for a 50 year old and 200 pound person is as we get by putting the value in the regression equation Answer= 31+0.861*50+0.335*200 Answer= 141.05

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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