Cassie_Mathis_Data_Analysis_Cholesterol_Data_Submission-1
xlsx
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
Please help asap!
arrow_forward
please solve for following
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
The cholesterol levels (in milligrams per deciliter) of 30 adults are listed below. Find the interquartile range for the cholesterol level of the 30 adults.
172 180
184
185
154 156 165 165 170 171
189 189 190 192 195 198 198 200
200
200
205 205 211 215 220 220 225 238 255 265
OA. 180
B.
30
O O O
C.
31
O D. 211
arrow_forward
please help solve attached
arrow_forward
I need help finding the age p value
arrow_forward
The cholesterol levels (in milligrams per deciliter) of 30 adults are listed below. Find the interquartile range for the cholesterol level of the 30 adults.
154 156
165 165 170
171
172
180 184 185
189 189
190
192
195
198
198
200 200 200
205 205 211
215 220
220
225 238 255 265
O A. 180
О в. 31
OC. 211
O D. 30
arrow_forward
Solve the attached question and give final answers please.The question and historical data is attached.
arrow_forward
Please give the excel formula or spreadsheet.
arrow_forward
The table below shows the number of deaths in the U.S. in a year due to a variety of causes. For
these questions, assume these values are not changing from year to year, and that the population
of the United States is 312 million people.
Cause
Deaths
Passenger car occupant 13,100
| 4,500
Motorcycle driver
Tornado
553
Skydiving
56
g) People sometimes claim skydiving is less dangerous than driving. Does the data support this
claim?
arrow_forward
Here is your (discrete) data
140
131
94
118
133
131
82
109
135
75
231
132
132
156
91
128
132
139
98
160
121
99
126
155
131
106
139
150
99
149
67
98
149
106
128
113
148
134
126
101
102
113
123
140
125
161
70
156
119
132
119
186
157
87
116
97
93
133
142
143
124
142
163
90
145
184
96
134
114
126
117
111
124
121
132
139
115
88
75
131
134
106
114
137
First, sort the data.Second, build a GFDT for this table with a classwidth of 15.(Be sure your lower class limits are multiples of the classwidth.)Next, answer the following questions about the data set:1. What is the first lower class limit in your GFDT (given the classwidth of 15)? 2. Express the fourth class as a closed interval, i.e., [a,b][a,b]. 3. Give the frequency for the fourth class. 4. What is the (arithmetic) mean for this data (report accurate to one decimal place)? 5. Using the GFDT, what is the mode for this data set (Hint: Create the Frequency table first, then determine the class with the…
arrow_forward
Here is your (discrete) data
140
131
94
118
133
131
82
109
135
75
231
132
132
156
91
128
132
139
98
160
121
99
126
155
131
106
139
150
99
149
67
98
149
106
128
113
148
134
126
101
102
113
123
140
125
161
70
156
119
132
119
186
157
87
116
97
93
133
142
143
124
142
163
90
145
184
96
134
114
126
117
111
124
121
132
139
115
88
75
131
134
106
114
137
First, sort the data.Second, build a GFDT for this table with a classwidth of 15.(Be sure your lower class limits are multiples of the classwidth.)Next, answer the following questions about the data set:1. What is the first lower class limit in your GFDT (given the classwidth of 15)? 2. Express the fourth class as a closed interval, i.e., [a,b][a,b]. 3. Give the frequency for the fourth class. 4. What is the (arithmetic) mean for this data (report accurate to one decimal place)? 5. Using the GFDT, what is the mode for this data set (Hint: Create the Frequency table first, then determine the class with the…
arrow_forward
Suppose that a customer is purchasing a car. He conducts an experiment in which he puts 10 gallons of gas in the car and drives it until it runs out of gas. He conducts this experiment 15 times on each car and records the number of miles driven.
Full data set
Car 1
216
243
205
242
239
297
295
172
270
251
165
310
265
316
278
Car 2
231
220
223
205
245
257
242
292
248
252
287
255
250
293
251
Median for Car 2
M=___________mi / 10 gal
(Type an integer or decimal rounded to one decimal place as needed.)
Range for Car 1
R=__________mi / 10 gal
(Type an integer or decimal rounded to one decimal place as needed.)
Range for Car 2
R=__________mi / 10 gal
(Type an integer or decimal rounded to one decimal place as needed.)
Sample standard deviation for Car 1
s=_________mi / 10 gal
(Type an integer or decimal rounded to one decimal place as needed.)
Sample standard deviation…
arrow_forward
Data was collected for 300 fish from the North Atlantic. The length of the fish (in mm) is summarized in the GFDT below.
Lengths (mm)
Frequency
160 - 164
1
165 - 169
16
170 - 174
71
175 - 179
108
180 - 184
83
185 - 189
18
190 - 194
3
What is the upper class limit for the fourth class?upper class limit =
arrow_forward
I need help answering a-1 and a-2
Miles traveled since the last maintanence:
Miles traveled since the last maintenance
11973
11969
11967
11948
11925
11922
11896
11883
11837
11814
11800
11798
11789
11782
11781
11778
11758
11757
11707
11704
11698
11691
11668
11662
11615
11610
11576
11533
11518
11462
11461
11418
11359
11358
11344
11342
11336
11248
11231
11222
11168
11148
11127
11112
11100
11048
11018
11003
10945
10911
10902
10802
10802
10760
10759
10755
10726
10724
10674
10662
10633
10591
10551
10518
10473
10355
10344
10315
10235
10227
10210
10209
10167
10140
10128
10095
10081
10075
10055
10000
arrow_forward
Need to double-check and expand on few question. Thanks. The following is the data:
sodium
calories
1
129
317
2
180
555
3
117
265
4
142
369
5
164
523
6
153
391
7
140
394
8
143
472
9
143
501
10
167
434
11
117
382
12
140
379
13
158
415
14
135
417
15
130
350
16
210
617
17
149
505
18
161
506
19
132
342
20
122
446
21
161
454
22
166
496
23
102
317
24
119
400
25
112
400
26
207
636
27
183
587
28
151
463
29
152
524
30
178
381
31
96
441
32
176
518
33
163
561
34
145
375
35
196
530
36
114
334
37
179
433
38
160
407
39
160
583
40
156
377
41
92
265
42
145
268
43
148
422
44
122
412
45
204
509
46
108
310
47
116
256
48…
arrow_forward
The following data show the ages of recent award-winning male actors at the time when they won their award. Make a frequency table for the data, using bins of 20-29, 30-39,
and so on.
Click the icon to view the ages of male actors.
Complete the table below.
Age
20-29
30-39
40-49
50-59
60-69
70-79
No. of actors
arrow_forward
temp
prod
days
persons
water
58.8
7107
21
129
3067
65.2
6373
22
141
2828
70.9
6796
22
153
2891
77.4
9208
20
166
2994
79.3
14792
25
193
3082
81
14564
23
189
3898
71.9
11964
20
175
3502
63.9
13526
23
186
3060
54.5
12656
20
190
3211
39.5
14119
20
187
3286
44.5
16691
22
195
3542
43.6
14571
19
206
3125
56
13619
22
198
3022
64.7
14575
22
192
2922
73
14556
21
191
3950
78.9
18573
21
200
4488
79.4
15618
22
200
3295
arrow_forward
Data was collected for 300 fish from the North Atlantic. The length of the fish (in mm) is summarized in the GFDT below.
Lengths (mm)
Frequency
100 - 119
1
120 - 139
16
140 - 159
71
160 - 179
108
180 - 199
83
200 - 219
18
220 - 239
3
What is the lower class limit for the sixth class?lower class limit =
arrow_forward
A listing of calories per one ounce of selected salad dressings (not fat-free) is given below.
160 130 145 110 160 145 160 170 100 180
130 120 150 100 145 100 190 120 120 180
160 100 140 150 130 120 160 110 115 140
130 120 140
Send data
to Excel
arrow_forward
The table below shows the number of deaths in the U.S. in a year due to a variety of causes. For
these questions, assume these values are not changing from year to year, and that the population
of the United States is 312 million people.
Cause
Deaths
Passenger car occupant 13,100
Motorcycle driver
4,500
Tornado
553
Skydiving
56
h) People sometimes claim motorcycle riding is less dangerous than driving. Does the data support
this claim? What additional information and/or calculations would be useful to evaluate this claim?
arrow_forward
7.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Related Questions
- Please help asap!arrow_forwardplease solve for followingarrow_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_forward
- The cholesterol levels (in milligrams per deciliter) of 30 adults are listed below. Find the interquartile range for the cholesterol level of the 30 adults. 172 180 184 185 154 156 165 165 170 171 189 189 190 192 195 198 198 200 200 200 205 205 211 215 220 220 225 238 255 265 OA. 180 B. 30 O O O C. 31 O D. 211arrow_forwardplease help solve attachedarrow_forwardI need help finding the age p valuearrow_forward
- The cholesterol levels (in milligrams per deciliter) of 30 adults are listed below. Find the interquartile range for the cholesterol level of the 30 adults. 154 156 165 165 170 171 172 180 184 185 189 189 190 192 195 198 198 200 200 200 205 205 211 215 220 220 225 238 255 265 O A. 180 О в. 31 OC. 211 O D. 30arrow_forwardSolve the attached question and give final answers please.The question and historical data is attached.arrow_forwardPlease give the excel formula or spreadsheet.arrow_forward
- The table below shows the number of deaths in the U.S. in a year due to a variety of causes. For these questions, assume these values are not changing from year to year, and that the population of the United States is 312 million people. Cause Deaths Passenger car occupant 13,100 | 4,500 Motorcycle driver Tornado 553 Skydiving 56 g) People sometimes claim skydiving is less dangerous than driving. Does the data support this claim?arrow_forwardHere is your (discrete) data 140 131 94 118 133 131 82 109 135 75 231 132 132 156 91 128 132 139 98 160 121 99 126 155 131 106 139 150 99 149 67 98 149 106 128 113 148 134 126 101 102 113 123 140 125 161 70 156 119 132 119 186 157 87 116 97 93 133 142 143 124 142 163 90 145 184 96 134 114 126 117 111 124 121 132 139 115 88 75 131 134 106 114 137 First, sort the data.Second, build a GFDT for this table with a classwidth of 15.(Be sure your lower class limits are multiples of the classwidth.)Next, answer the following questions about the data set:1. What is the first lower class limit in your GFDT (given the classwidth of 15)? 2. Express the fourth class as a closed interval, i.e., [a,b][a,b]. 3. Give the frequency for the fourth class. 4. What is the (arithmetic) mean for this data (report accurate to one decimal place)? 5. Using the GFDT, what is the mode for this data set (Hint: Create the Frequency table first, then determine the class with the…arrow_forwardHere is your (discrete) data 140 131 94 118 133 131 82 109 135 75 231 132 132 156 91 128 132 139 98 160 121 99 126 155 131 106 139 150 99 149 67 98 149 106 128 113 148 134 126 101 102 113 123 140 125 161 70 156 119 132 119 186 157 87 116 97 93 133 142 143 124 142 163 90 145 184 96 134 114 126 117 111 124 121 132 139 115 88 75 131 134 106 114 137 First, sort the data.Second, build a GFDT for this table with a classwidth of 15.(Be sure your lower class limits are multiples of the classwidth.)Next, answer the following questions about the data set:1. What is the first lower class limit in your GFDT (given the classwidth of 15)? 2. Express the fourth class as a closed interval, i.e., [a,b][a,b]. 3. Give the frequency for the fourth class. 4. What is the (arithmetic) mean for this data (report accurate to one decimal place)? 5. Using the GFDT, what is the mode for this data set (Hint: Create the Frequency table first, then determine the class with the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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