The weight and systolic blood pressure of 26 randomly selected males in the age group 25 to 30 are shown in the table below. Assume that the weight and blood pressure are jointly normally distributed Subject Systolic BP Subject Weight Systolic BP Weight 165 1 130 14 172 153 2 167 133 15 159 128 3 180 150 16 168 132 4 155 128 17 174 149 5 212 151 18 183 158 6 175 146 19 215 150 7 190 150 20 195 163 8 210 140 21 180 156 9 200 148 22 143 124 10 149 125 170 11 158 133 24 235 165 12 169 135 25 192 160 13 170 150 26 187 159 a. Find a regression line relating systolic blood pressure to weight b. Test for significance of regression using a = 0.05 c. Estimate the correlation coefficient O a.y=5.50 +6.73x Regression model is significant r=0.77349 Regression model is significant O b.y = -25.294 +1.426x

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

Use MS Excel pls

The weight and systolic blood pressure of 26 randomly selected males in the age group 25 to 30 are
shown in the table below. Assume that the weight and blood pressure are jointly normally distributed
Systolic BP Subject Weight Systolic BP
Subject
1
Weight
165
130
14
172
153
2
167
133
159
3
180
150
168
4
155
128
174
5
212
151
183
6
175
146
215
7
190
150
195
8
210
140
180
9
200
148
143
149
125
240
158
133
235
169
135
192
13
170
150
187
a. Find a regression line relating systolic blood pressure to weight
b. Test for significance of regression using a = 0.05
c. Estimate the correlation coefficient
O a.y = 5.50 +6.73x
Regression model is significant
r = 0.77349
O b.y = -25.294 + 1.426x
Regression model is significant
r=0.77349
Regression model is significant
r=0.77349
Regression model is not significant
r = 0.77349
O e.y = 69.104 + 0.419x
Regression model is not significant
r = 0.5982
2123
10
11
O c.y = 69.104 + 0.419x
O d.y = 69.104 + 0.419x
561898NNINGS
17
20
21
22
23
24
25
26
128
132
149
158
150
163
156
124
170
165
160
159
Transcribed Image Text:The weight and systolic blood pressure of 26 randomly selected males in the age group 25 to 30 are shown in the table below. Assume that the weight and blood pressure are jointly normally distributed Systolic BP Subject Weight Systolic BP Subject 1 Weight 165 130 14 172 153 2 167 133 159 3 180 150 168 4 155 128 174 5 212 151 183 6 175 146 215 7 190 150 195 8 210 140 180 9 200 148 143 149 125 240 158 133 235 169 135 192 13 170 150 187 a. Find a regression line relating systolic blood pressure to weight b. Test for significance of regression using a = 0.05 c. Estimate the correlation coefficient O a.y = 5.50 +6.73x Regression model is significant r = 0.77349 O b.y = -25.294 + 1.426x Regression model is significant r=0.77349 Regression model is significant r=0.77349 Regression model is not significant r = 0.77349 O e.y = 69.104 + 0.419x Regression model is not significant r = 0.5982 2123 10 11 O c.y = 69.104 + 0.419x O d.y = 69.104 + 0.419x 561898NNINGS 17 20 21 22 23 24 25 26 128 132 149 158 150 163 156 124 170 165 160 159
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON