Cassie_Mathis_Data_Analysis_Cholesterol_Data_Submission-1
xlsx
keyboard_arrow_up
School
Arizona State University *
*We aren’t endorsed by this school
Course
340
Subject
Statistics
Date
Apr 3, 2024
Type
xlsx
Pages
10
Uploaded by Soupandsaladdays
Cholesterol at age 20-44 y
Cholesterol at age 45-64 y
122
137
122
139
126
142
129
151
132
152
137
155
137
161
139
162
143
163
145
166
149
168
149
171
150
173
150
173
150
175
154
177
154
184
155
185
155
186
156
187
158
187
160
188
161
189
162
189
163
189
168
190
169
192
170
194
170
194
172
195
174
197
175
198
175
199
177
200
177
200
178
200
178
200
179
200
180
201
181
202
183
202
184
203
185
204
185
205
185
206
187
207
187
207
188
208
189
210
190
211
191
214
194
215
195
215
198
215
198
216
199
216
200
217
201
218
202
218
202
220
203
221
203
221
205
222
206
223
207
225
209
227
209
229
210
229
211
229
211
232
211
232
212
236
213
240
214
241
214
241
219
243
219
243
220
246
220
246
220
247
226
251
226
251
227
254
228
255
228
256
233
259
236
259
238
264
239
264
241
266
244
268
252
269
254
274
254
279
255
280
265
288
276
296
285
308
288
322
290
331
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Cholesterol at age 20-44 y
Cholesterol at age 45-64 y
8
2
13
4
17
10
18
17
21
26
12
13
6
15
2
7
3
3
0
1
0
2
Copy the raw data
to perform bin gro
each age group w
memo. These are
1
2
3
8
13
17
Cholesterol in People Frequency
This chart isn't available in
Editing this shape or savin
permanently break the cha
a for both age groups into this tab
oupings and create
the graphs for
with the bins described in the mission
e questions 2-4
4
5
6
7
8
9
10
11
18
21
12
6
2
3
0
0
at Ages 20-44 Years
n your version of Excel.
ng this workbook into a different file format will art.
Cholesterol at Cholesterol at age 45-64 y
8
2
13
4
17
10
18
17
21
26
12
13
6
15
2
7
3
3
0
1
0
2
Copy the raw data for both ag
to perform the statstical anal
the mean, median, mode, mi
are for questions 5-12.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ge groups into this tab
lyses to report including
in, and max values. These
Cholesterol at age 20-44 y
Cholesterol at age 45-64 y
Copy the raw data for both age groups into this
to perform probability calculations. These are questions 13-14.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
s tab
for
Related Documents
Related Questions
Systolic Blood Pressure Levels
Body and exam measurements are from 100 subjects. SYSTOLIC is systolic blood
pressure (mm Hg)
SYSTOLIC
110
114
122
120
134
138
108
112
112
104
126
130
100
122
158
92
142
166
114
126
130
104
128
154
120
134
136
102
132
154
128
134
140
104
106
126
118
122
128
102
110
120
114
118
124
124
156
160
114
126
136
92
114
122
114
126
156
118
122
126
112
122
132
106
106
122
106
116
134
98
110
126
88
118
122
112
126
158
112
112
124
134
186
116
128
138
132
134
146
112
120
142
128
132
164
104
128
SYSTOLIC
arrow_forward
The table provided below shows paired data for the heights of a certain country's presidents and their main opponents in the election campaign. Construct a scatterplot. Does there appear to be a correlation?
Click the icon to view the data table for election heights.
Construct a scatterplot. Choose the correct graph below.
OA.
В.
C.
D.
200-
200-
200-
200-
160+
160
President's height
160+
160
President's height
160+
160
President's height
160-
160
President's height
200
200
200
200
Does there appear to be a correlation between the president's height and his opponent's height?
A. Yes, there appears to be a correlation. As the president's height increases, his opponent's height increases.
B. Yes, there appears to be a correlation. The candidate with the highest height usually wins.
C. Yes, there appears to be a correlation. As the president's height increases, his opponent's height decreases.
D. No, there does not appear to be a correlation because there is no general pattern to the data.…
arrow_forward
239
251
292
287
264
209
279
229
225
231
224
258
255
269
259
219
249
206
263
278
249
243
130
256
312
254
240
272
273
228
300
265
290
233
286
263
295
252
232
239
244
284
270
210
316
278
232
247
235
191
The insurance Institute for Highway safety regularly conduct studies to increase public safety on the country highways. One important study that happens every year is the measure of stopping (in feet) from 60 miles an hour (including reaction time). The date it for 50 midsize sedan's is given above.
a) Create a histogram of the data provided above.
b) Describe its main features.
Shape:
Peaks:
Center:
Spread:
Outlier:
c) which numerical summary would you choose for these data? Calculate your chosen summary. How does it reflect the Skewness of the distribution?
arrow_forward
Table 9-3 Serum Levels of Total Cholesterol Reported in 71 Participants*
Cholesterol
Value (mg/dL)
No. Observations
Cholesterol
Value (mg/dL)
No. Observations
Cholesterol
Value (mg/dL)
No. Observations
124
1
128
1
132
1
133
136
1
138
139
146
147
149
151
1
153
2
158
3
160
1
161
1
191
162
1
192
163
2
194
គឺ ៖ ៖ ៖ ធី “ È ឥ ន ន E គឺ ៖ ៖ គគឺ
164
3
196
165
1
197
2
2
166
206
1
169
208
171
4
209
175
1
213
177
2
217
178
2
220
179
1
221
180
4
222
181
1
226
184
2
227
186
1
228
1
241
3
264
2
-
2
arrow_forward
K
Use the pulse rates in beats per minute (bpm) of a random sample of adult females listed in the data set available below to test the claim that the mean is less than 75 bpm. Use a 0.01 significance
level.
Click the icon to view the pulse rate data.
B
Assuming all conditions for conducting a hypothesis test are met, what the null and alternative hypotheses?
OA. Ho: = 75 bpm
H₁:μ>75 bpm
OC. Ho: μ=75 bpm
H₁: 75 bpm
H₁: μ<75 bpm
OD. Ho: μ=75 bpm
H₁: μ#75 bpm
arrow_forward
The table presents the highway gasoline mileage performance and engine displacement for DaimlerChrysler vehicles for model year 2005 (U.S. Environmental protection Agency).
Engine Displacement (in3)
215
201
196
226
226
348
226
348
148
226
122
215
215
148
500
348
165
148
148
500
148
MPG (highway)
30.8
32.5
35.4
28.1
24.4
24.1
28.5
24.2
32.8
28.0
41.3
30.0
28.2
34.1
18.7
20.3
35.1
37.9
33.8
25.9
26.4
(c) Find a 95% confidence interval for the mean highway gasoline mileage when the engine displacement is x = 159 in3.
Round your answers to one decimal place (e.g. 98.7).
(d) Construct a 95% prediction interval on highway gasoline mileage when the engine displacement is x = 159 in3.
Round your answers to one decimal place (e.g. 98.7).
arrow_forward
Participant ID
Pressure
Pressure
Cholesterol
(pounds)
(inches)
1
140
59
200
138
65.00
2.
119
64
150
138
69.75
3
120
62
227
155
65.75
4
127
81
227
180
70.00
125
66
163
161
70.50
135
72
210
206
70.00
105
81
210
235
73.00
8
115
65
275
151
60.75
106
70
208
215
69.00
10
131
77
159
142
61.00
Note: 2 different formulas provided for BMI and MAP.
The data above come from a subsample of 10 participants who attend the seventh examination of the
Framingham Offspring Study.
Problem 7: The body mass index (BMI) of a person is defined as:
masskg
massib
BMI =
(weightpoundsX 0.4536) height
(heightnehes x 0.0254)²
x 703
height
BMI
Add a column to the data titled BMI and compute the BMI of each participant.
arrow_forward
Use excel and answer all parts please
arrow_forward
WAGE
EDUC
EXPER
AGE
GENDER
RACE
1345
6
2
38
0
1
2435
4
18
52
1
1
1715
6
4
45
1
1
1461
6
4
58
1
1
1639
9
3
30
1
0
1345
5
8
43
0
1
1602
7
6
30
0
1
1144
4
3
33
0
0
1566
6
23
51
1
0
1496
4
15
37
1
1
1234
4
9
45
0
0
1345
6
3
55
0
1
1345
5
14
57
0
1
3389
9
16
36
1
1
1839
4
20
60
1
1
981
4
5
35
1
0
1345
9
10
34
0
1
1566
5
4
28
0
0
1187
6
1
25
0
1
1345
7
10
43
0
1
1345
9
2
42
0
1
2167
4
17
47
1
0
1402
11
2
46
1
1
2115
4
15
52
1
0
2218
8
11
64
1
1
3575
11
1
39
1
1
1972
4
1
39
1
1
1234
4
2
40
0
1
1926
5
9
53
1
0
2165
6
15
59
0
1
2365
6
12
35
0
0
1345
9
5
45
0
1
1839
4
14
37
0
0
2613
5
14
37
1
1
2533
11
3
43
1
1
1602
8
5
32
0
1
1839
9
18
40
0
1
2218
7
1
49
1
1
1529
4
10
43
0
0
1461
1
10
31
1
0
3307
9
22
45
1
1
3833
11
3
31
1
1
1839
4
14
55
1
0
1461
6
5
30
0
1
1433
9
3
28
1
0
2115
6
15
60
0
0
1839
4
13
32
1
0
1288
4
9
58
1
0
1288
6
4
29
0
0
arrow_forward
A blood pressure measurement consists of two numbers: the systolic pressure, which is the
maximum pressure taken when the heart is contracting, and the diastolic pressure, which is
the minimum pressure taken at the beginning of the heartbeat. Blood pressures were
measured, in mmHg for a sample of 16 adults. The following table presents the results.
Systolic
134
Diastolic
87
115
83
113
77
123
77
119
69
118
88
130
76
116
70
133
91
112
75
107
71
110
74
108
69
105
66
157
103
154
94
Construct a scatterplot of diastolic pressure (y) versus systolic pressure (x) Verify that
a linear model is appropriate.
a.
b. Compute the least-squares line for predicting the diastolic pressure from the systolic
pressure.
If the systolic pressures of two patients differ by 10 mmHg, by how much would you
predict their diastolic pressures to differ?
Predict the diastolic pressure for a patient whose systolic pressure is 125 mmHg.
C.
d.
arrow_forward
Question 6
The IQ scores of 50 students are given below.
90
91 101 95
115
94
89
112
99
98 102 113 85 106
108 111 85 88 117 94
109 119 111 114 94
114
94 111
104
115
111
99 110 89 112 96
97 99 94 114
108
85 118 117 111 89 101 114 99 99
(a) Construct a grouped frequency distribution for the data. Use 85-89 for the first class
width for each subsequent class.
Class Frequency
85 - 89
1.1
1.1
1-1
·
(b) Which of the following is the correct histogram for this data?
O
Frequency
20
15
10
5
I
0
85 90 95 100 105 110 115 120
IQ Score
arrow_forward
Car
Weight (lbs) Miles per Gallon
3,765
Car 1
19
Car 2
3,964
17
Car 3
3,470
21
Car 4
3,175
22
Car 5
2,580
27
Car 6
3,730
18
Car 7
2,605
26
Car 8
3,772
17
3,310
Car 9
20
Car 10
2,991
25
Car 11
2,752
26
An engineer wanted to determine how the weight of a car affects gas mileage. The accompanying data
represent the weights of various domestic cars and their gas mileages in the city for a certain model year.
Suppose that we add Car 12 to the original data. Car 12 weighs 3 comma 3053,305 pounds and gets
1919 miles per gallon
a) Compute the linear correlation coefficient with Car 12 included.
The linear correlation coefficient with Car 12 included is r-?
(Round to three decimal places as needed.)
b) Recompute the linear correlation coefficient with Car 13 included. How did this new value affect your
result?
The linear correlation coefficient with Car 13 included is r-?
t) Why does this observation not follow the pattern of the data?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Related Questions
- Systolic Blood Pressure Levels Body and exam measurements are from 100 subjects. SYSTOLIC is systolic blood pressure (mm Hg) SYSTOLIC 110 114 122 120 134 138 108 112 112 104 126 130 100 122 158 92 142 166 114 126 130 104 128 154 120 134 136 102 132 154 128 134 140 104 106 126 118 122 128 102 110 120 114 118 124 124 156 160 114 126 136 92 114 122 114 126 156 118 122 126 112 122 132 106 106 122 106 116 134 98 110 126 88 118 122 112 126 158 112 112 124 134 186 116 128 138 132 134 146 112 120 142 128 132 164 104 128 SYSTOLICarrow_forwardThe table provided below shows paired data for the heights of a certain country's presidents and their main opponents in the election campaign. Construct a scatterplot. Does there appear to be a correlation? Click the icon to view the data table for election heights. Construct a scatterplot. Choose the correct graph below. OA. В. C. D. 200- 200- 200- 200- 160+ 160 President's height 160+ 160 President's height 160+ 160 President's height 160- 160 President's height 200 200 200 200 Does there appear to be a correlation between the president's height and his opponent's height? A. Yes, there appears to be a correlation. As the president's height increases, his opponent's height increases. B. Yes, there appears to be a correlation. The candidate with the highest height usually wins. C. Yes, there appears to be a correlation. As the president's height increases, his opponent's height decreases. D. No, there does not appear to be a correlation because there is no general pattern to the data.…arrow_forward239 251 292 287 264 209 279 229 225 231 224 258 255 269 259 219 249 206 263 278 249 243 130 256 312 254 240 272 273 228 300 265 290 233 286 263 295 252 232 239 244 284 270 210 316 278 232 247 235 191 The insurance Institute for Highway safety regularly conduct studies to increase public safety on the country highways. One important study that happens every year is the measure of stopping (in feet) from 60 miles an hour (including reaction time). The date it for 50 midsize sedan's is given above. a) Create a histogram of the data provided above. b) Describe its main features. Shape: Peaks: Center: Spread: Outlier: c) which numerical summary would you choose for these data? Calculate your chosen summary. How does it reflect the Skewness of the distribution?arrow_forward
- Table 9-3 Serum Levels of Total Cholesterol Reported in 71 Participants* Cholesterol Value (mg/dL) No. Observations Cholesterol Value (mg/dL) No. Observations Cholesterol Value (mg/dL) No. Observations 124 1 128 1 132 1 133 136 1 138 139 146 147 149 151 1 153 2 158 3 160 1 161 1 191 162 1 192 163 2 194 គឺ ៖ ៖ ៖ ធី “ È ឥ ន ន E គឺ ៖ ៖ គគឺ 164 3 196 165 1 197 2 2 166 206 1 169 208 171 4 209 175 1 213 177 2 217 178 2 220 179 1 221 180 4 222 181 1 226 184 2 227 186 1 228 1 241 3 264 2 - 2arrow_forwardK Use the pulse rates in beats per minute (bpm) of a random sample of adult females listed in the data set available below to test the claim that the mean is less than 75 bpm. Use a 0.01 significance level. Click the icon to view the pulse rate data. B Assuming all conditions for conducting a hypothesis test are met, what the null and alternative hypotheses? OA. Ho: = 75 bpm H₁:μ>75 bpm OC. Ho: μ=75 bpm H₁: 75 bpm H₁: μ<75 bpm OD. Ho: μ=75 bpm H₁: μ#75 bpmarrow_forwardThe table presents the highway gasoline mileage performance and engine displacement for DaimlerChrysler vehicles for model year 2005 (U.S. Environmental protection Agency). Engine Displacement (in3) 215 201 196 226 226 348 226 348 148 226 122 215 215 148 500 348 165 148 148 500 148 MPG (highway) 30.8 32.5 35.4 28.1 24.4 24.1 28.5 24.2 32.8 28.0 41.3 30.0 28.2 34.1 18.7 20.3 35.1 37.9 33.8 25.9 26.4 (c) Find a 95% confidence interval for the mean highway gasoline mileage when the engine displacement is x = 159 in3. Round your answers to one decimal place (e.g. 98.7). (d) Construct a 95% prediction interval on highway gasoline mileage when the engine displacement is x = 159 in3. Round your answers to one decimal place (e.g. 98.7).arrow_forward
- Participant ID Pressure Pressure Cholesterol (pounds) (inches) 1 140 59 200 138 65.00 2. 119 64 150 138 69.75 3 120 62 227 155 65.75 4 127 81 227 180 70.00 125 66 163 161 70.50 135 72 210 206 70.00 105 81 210 235 73.00 8 115 65 275 151 60.75 106 70 208 215 69.00 10 131 77 159 142 61.00 Note: 2 different formulas provided for BMI and MAP. The data above come from a subsample of 10 participants who attend the seventh examination of the Framingham Offspring Study. Problem 7: The body mass index (BMI) of a person is defined as: masskg massib BMI = (weightpoundsX 0.4536) height (heightnehes x 0.0254)² x 703 height BMI Add a column to the data titled BMI and compute the BMI of each participant.arrow_forwardUse excel and answer all parts pleasearrow_forwardWAGE EDUC EXPER AGE GENDER RACE 1345 6 2 38 0 1 2435 4 18 52 1 1 1715 6 4 45 1 1 1461 6 4 58 1 1 1639 9 3 30 1 0 1345 5 8 43 0 1 1602 7 6 30 0 1 1144 4 3 33 0 0 1566 6 23 51 1 0 1496 4 15 37 1 1 1234 4 9 45 0 0 1345 6 3 55 0 1 1345 5 14 57 0 1 3389 9 16 36 1 1 1839 4 20 60 1 1 981 4 5 35 1 0 1345 9 10 34 0 1 1566 5 4 28 0 0 1187 6 1 25 0 1 1345 7 10 43 0 1 1345 9 2 42 0 1 2167 4 17 47 1 0 1402 11 2 46 1 1 2115 4 15 52 1 0 2218 8 11 64 1 1 3575 11 1 39 1 1 1972 4 1 39 1 1 1234 4 2 40 0 1 1926 5 9 53 1 0 2165 6 15 59 0 1 2365 6 12 35 0 0 1345 9 5 45 0 1 1839 4 14 37 0 0 2613 5 14 37 1 1 2533 11 3 43 1 1 1602 8 5 32 0 1 1839 9 18 40 0 1 2218 7 1 49 1 1 1529 4 10 43 0 0 1461 1 10 31 1 0 3307 9 22 45 1 1 3833 11 3 31 1 1 1839 4 14 55 1 0 1461 6 5 30 0 1 1433 9 3 28 1 0 2115 6 15 60 0 0 1839 4 13 32 1 0 1288 4 9 58 1 0 1288 6 4 29 0 0arrow_forward
- A blood pressure measurement consists of two numbers: the systolic pressure, which is the maximum pressure taken when the heart is contracting, and the diastolic pressure, which is the minimum pressure taken at the beginning of the heartbeat. Blood pressures were measured, in mmHg for a sample of 16 adults. The following table presents the results. Systolic 134 Diastolic 87 115 83 113 77 123 77 119 69 118 88 130 76 116 70 133 91 112 75 107 71 110 74 108 69 105 66 157 103 154 94 Construct a scatterplot of diastolic pressure (y) versus systolic pressure (x) Verify that a linear model is appropriate. a. b. Compute the least-squares line for predicting the diastolic pressure from the systolic pressure. If the systolic pressures of two patients differ by 10 mmHg, by how much would you predict their diastolic pressures to differ? Predict the diastolic pressure for a patient whose systolic pressure is 125 mmHg. C. d.arrow_forwardQuestion 6 The IQ scores of 50 students are given below. 90 91 101 95 115 94 89 112 99 98 102 113 85 106 108 111 85 88 117 94 109 119 111 114 94 114 94 111 104 115 111 99 110 89 112 96 97 99 94 114 108 85 118 117 111 89 101 114 99 99 (a) Construct a grouped frequency distribution for the data. Use 85-89 for the first class width for each subsequent class. Class Frequency 85 - 89 1.1 1.1 1-1 · (b) Which of the following is the correct histogram for this data? O Frequency 20 15 10 5 I 0 85 90 95 100 105 110 115 120 IQ Scorearrow_forwardCar Weight (lbs) Miles per Gallon 3,765 Car 1 19 Car 2 3,964 17 Car 3 3,470 21 Car 4 3,175 22 Car 5 2,580 27 Car 6 3,730 18 Car 7 2,605 26 Car 8 3,772 17 3,310 Car 9 20 Car 10 2,991 25 Car 11 2,752 26 An engineer wanted to determine how the weight of a car affects gas mileage. The accompanying data represent the weights of various domestic cars and their gas mileages in the city for a certain model year. Suppose that we add Car 12 to the original data. Car 12 weighs 3 comma 3053,305 pounds and gets 1919 miles per gallon a) Compute the linear correlation coefficient with Car 12 included. The linear correlation coefficient with Car 12 included is r-? (Round to three decimal places as needed.) b) Recompute the linear correlation coefficient with Car 13 included. How did this new value affect your result? The linear correlation coefficient with Car 13 included is r-? t) Why does this observation not follow the pattern of the data?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage