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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!