Question: Q. Multiple Linear Regression Equation. See the Excel file (multiple regression example on Week 2 CANVAS to do similar analysis for this question. Use the
Q. Multiple Linear Regression Equation.
See the Excel file (multiple regression example on Week 2 CANVAS to do similar analysis for this question.
Use the following data for a sample of 15 males . The data represent the Systolic Blood Pressure (dependent variable y) and the two independent variables (X1 Age in years, and X2 Weight in pounds).
Systolic Blood Pressure Data
| Y | X1 | X2 |
| 132 | 52 | 173 |
| 143 | 59 | 184 |
| 153 | 67 | 194 |
| 162 | 73 | 211 |
| 154 | 64 | 196 |
| 168 | 74 | 220 |
| 137 | 54 | 188 |
| 149 | 61 | 188 |
| 159 | 65 | 207 |
| 128 | 46 | 167 |
| 166 | 72 | 217 |
| 149 | 61 | 188 |
| 159 | 65 | 207 |
| 128 | 46 | 167 |
| 166 | 72 | 217 |
1. Do the multiple regression analysis using Excel data\data analysis egression to obtain the regression results and then use them to find the regression equation.
2. Use the coefficients to present the regression equation and use to estimate the blood pressure of a man of age 65 and weight of 220 pounds.
Copy the Answer from Excel and paste it below.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
