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 Weight Systolic BP Subject 1 Weight Systolic BP Subject 14 165 130 172 153 2 167 133 159 128 180 150 168 132 155 128 174 149 212 151 183 158 175 146 215 150 190 150 195 163 210 140 180 156 9 200 148 143 124 10 149 125 240 170 11 158 133 235 165 12 169 135 192 160 13 170 150 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= 69.104 + 0.419x 3 4 5 6 7 8 Regression model is not significant r= 0.5982 O b.y = -25.294 +1.426x Regression model is significant r = 0.77349 O c. y = 5.50 +6.73x Regression model is significant r = 0.77349 O d.y=69.104 + 0.419x Regression model is significant r = 0.77349 O e.y = 69.104 +0.419x Regression model is not significant S61K9R522328 17 20 24

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Please solve in excel and paste the screenshot of excel in here. Thank you!

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
155
128
17
174
149
212
151
18
183
158
175
146
19
215
150
190
150
20
195
163
210
140
21
180
156
200
148
22
143
124
149
125
23
240
170
158
133
24
235
165
169
135
25
192
160
13
150
26
59
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 = 69.104 + 0.419x
4
5
6
7
8
9
10
2=23
11
12
Regression model is not significant
r = 0.5982
O b.y = -25.294 +1.426x
Regression model is significant
r=0.77349
O c. y = 5.50+ 6.73x
Regression model is significant
r = 0.77349
O d.y= 69.104 + 0.419x
Regression model is significant
r = 0.77349
O e.y = 69.104 + 0.419x
Regression model is not significant
r = 0.77349
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 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 155 128 17 174 149 212 151 18 183 158 175 146 19 215 150 190 150 20 195 163 210 140 21 180 156 200 148 22 143 124 149 125 23 240 170 158 133 24 235 165 169 135 25 192 160 13 150 26 59 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 = 69.104 + 0.419x 4 5 6 7 8 9 10 2=23 11 12 Regression model is not significant r = 0.5982 O b.y = -25.294 +1.426x Regression model is significant r=0.77349 O c. y = 5.50+ 6.73x Regression model is significant r = 0.77349 O d.y= 69.104 + 0.419x Regression model is significant r = 0.77349 O e.y = 69.104 + 0.419x Regression model is not significant r = 0.77349
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman