USA: +1(669)289-8683 
Sign in
Based on what you have learned from your research on regression analysis and correlation, answer the following questions about the Body Fat Versus Weight data set:
- When performing a regression analysis, it is important to first identify your independent/predictor variable versus your dependent/response variable, or simply put, your x versus yvariables. How do you decide which variable is your predictor variable and which is your response variable?
- Based on the Body Fat Versus Weight data set, which variable is the predictor variable? Which variable is the response variable? Explain.
- Using Excel, construct a scatter plot of your data.
- Using the graph and intuition, determine whether there is a positive correlation, a negative correlation, or no correlation. How did you come to this conclusion?
- Calculate the correlation coefficient, r, and verify your conclusion with your scatter plot. What does the correlation coefficient determine?
- Add a regression line to your scatter plot, and obtain the regression equation.Does the line appear to be a good fit for the data? Why or why not?Regression equations help you make predictions. Using your regression equation, discuss what the slope means, and determine the predicted value of weight when body fat equals 0. Interpret the meaning of this result
>fat
. . men.
.25
.6
4.00
.9
5
%.
.8
4.25
0.25
.0
.00
6.00
.00
.25
.25
.1
8 6 5
.00
. 0
5
. 9 .50
.25
. .75
.1
.75
.4
5
.75
.75
.00
.50
.25
.75
.25
4.6 .50
.00
.25
.75
.00
6.5 .25
.00
0
.25
.75
.25
.75
.15
.00
0
.00
.00
.25
.25
.50
13.4 .75
.50
.25
.25
.25
.75
.25
.00
.50
.25
.75
0
.75
.25
.50
.50
.75
7.1 .25
.75
.50
9.4 .75
.00
9.2 .50
.75
.25
.25
.75
.25
.25
.75
.00
.75
0
8.8 .75
.25
.50
.25
0
.75
162.50 21.7 .00
20.8 20.1 .75
.75
.75
177.00 18.2 .00
27.1 20.9 .25
.00
19.8 14.1 25.1 .50
.50
.25
160.25 16.0 151.50 167.00 17.4 15.0 165.25 22.2 171.25 197.00 .00
.75
168.25 20.1 5
176.75 18.1 167.00 19.0 .50
206.50 6.1 0
.75
.50
0
177.25 184.25 .75
0 .75
.25
.75
16.8 .75
.25
159.25 .75
.50
20.2 202.25 23.8 .25
16.0 7.3 178.25 6.8 .00
31.7 10.1 159.75 .25
168.25 18.5 19.3 172.75 154.50 12.7 25.3 .00
11.3 179.75 15.0 11.1 24.0 26.4 12.7 28.8 15.3 25.3
IDNO
BODYFAT
WEIGHT
1
12
6
1
5
4
25
Description:
The dataset provided here is based on a sample of 2
52
2
6.
9
1
7
3
Their body fat and weights were recorded.
3
24
15
4
10
1
8
4.7
Statement:
The doctors office claims that the mean body fat in men is
20
5
27
18
6
20.6
21
Source: http://www2.stetson.edu/~jrasp/data.htm
7
19
1
81
8
12.8
17
9
5.1
1
91
10
12.0
1
98
Mean
Median
Range
Standard Deviation
11
7.5
1
86
Body Fat
18.9
19.0
45
7.7
50
55
59
12
8.5
2
16
Body Weight
1
78
92
17
6.5
24
4.6
29
38
159
88
54
13
20.5
1
80
14
20.8
205
15
21.7
1
87
75
16 20.5
1
62
17
28
1
95
18
22
20
9.2
19
1
6.1
1
83
20
16.5
211
21 19.0
1
79
22
15.3
200
23
15.7
1
40
24
17.6
1
48
25
14.2
1
51
26
159.25
27 8.5
1
31
28
22.4
148
29 4.7
1
33
30
9.4
1
60
31
12.3
1
82
32
160
33
13.4
1
68
34
20.9
2
18.5
35
31.1
2
47
36
3
8.2
191
37
23.6
202
38
27.5
1
96
39
33.8
3
63
40
31.3
203
41
33.1
262.75
42
31.7
20
5.0
43
30.4
217
44
30.8
212
45
8.4
125
46
1
4.1
1
64
47
11.2
133
48
6.4
148.50
49
135
50 5.0
127
51
10.7
1
58
52
7.4
139
53
8.7
137
54
7.1
152
55
4.9
136
56
22.2
198
57
20.1
181
58
27.1
201
59 30.4
202.50
60
24.0
179
61
25.4
2
16.0
62
2
8.8
178
63
2
9.6
1
93
64
25.1
178.00
65
31.0
205.50
66
28.9
183
67
21.1
151
68
14.0
154
69
155
70
13.2
156
71
23.7
167
72
146
73
9.1
160.75
74
13.7
125.00
75 12.0
143
76
18.3
148.25
77
162
78 21.7
177
79 21.1
161
80
18.6
171
81
30.2
163
82
26.0
150
83
18.2
1
90
84
26.2
170
85
26.1
168
86
25.8
167.00
87
15.0
157
88
22.6
16
0.0
89
176
90
14.3
176.00
91
20.2
177.00
92
18.1
179.75
93 9.2
165
94
24.2
192
95 9.6
184
96
1
7.3
2
24.5
97
10.1
188
98
11.1
99
17.7
156.50
100
197
101
198.50
102
173
103
19.8
172
104
2
1.9
196
105
24.7
106
1
7.8
165.50
107
19.1
200.25
108
203.25
109
17.2
194
110
21.0
168.50
111
19.5
170.75
112
183.25
113
21.6
178.25
114
163.00
115
25.9
175
116
16.7
158
117
177.25
118
179.00
119
191.00
120
17.9
187
121
27.0
206
122
24.6
185
123
14.8
124
125 14.0
161.00
126
17.4
127
26.4
177.50
128
152.25
129
20.4
192.25
130
131
18.0
171.75
132
133
23.1
134
25.3
157.00
135
23.8
168.25
136
26.3
186
137
21.4
166
138
28.4
187.75
139
21.8
140
2
12.7
141
24.3
142
173.25
143
22.7
144
9.9
159.75
145
10.8
188.15
146
14.4
156.00
147
208
148
28.6
149
143.75
150 24.5
2
23.0
151 9.9 152.25
152 19.1
241
153
10.6
146.00
154 16.5 156.75
155 20.5 200.25
156 17.2
171.50
157
30.1
205.75
158
10.5
182
159 12.8
1
36.5
160
22.0
161 9.9
151.25
162 14.8
196.00
163
13.3
164
15.2
140.00
165
26.5
218
166 19.0 2
17.0
167 21.4
166.25
168
20.0
224
169
34.7
228
170 16.5
172.75
171 4.1 152.25
172 1.9
125.75
173 20.2 177.25
174
1
6.8
176.25
175 24.6
226
176
10.4
145.25
177 13.4
151.00
178
28.8
241.25
179 22.0
187.25
180
234
181 25.8
219
182 0.0
118.50
183
11.9
145.75
184
12.4
185 17.4
170.50
186 9.2
167.50
187 23.0
232
188 20.1
210
189
190
185.00
191
11.8
153.00
192 36.5
244
193
193.50
194 24.0 224.75
195
22.3
162.75
196
24.8
180.00
197
21.5
156.25
198 17.6
168.00
199
167.25
200 22.6 170.75
201
12.5
202 21.7
150.00
203
27.7
200.50
204
184.00
205
33.4
223
206
16.6
208.75
207
166.00
208
31.5
195.00
209
160.50
210
11.3
211 7.8
140.50
212 26.4
216
213
19.3
214
194.75
215
216
45.1
219.00
217
13.8
149.25
218 8.2
154.50
219
23.9
199.25
220
15.1
221
153.25
222
230
223 11.9
161.75
224 6.1
142.25
225
226 12.8
126.50
227
14.9
169.50
228 24.5 198.50
229
174.50
230
16.9
167.75
231
147.75
232
16.1
182.25
233
15.5
175.50
234 25.9 161.75
235
25.5
157.75
236
18.4
168.75
237
191.50
238
219.15
239
155.25
240
189.75
241 17.0
127.50
242
33.6
224.50
243
29.3
234.25
244
31.4
227.75
245
28.1
199.50
246
155.50
247
29.1
215.50
248
11.5
134.25
249
32.3
201.00
250
28.3
186.75
251
190.75
252
30.7
207.50
