Get more out of your subscription*
- Access to over 100 million course-specific study resources
- 24/7 help from Expert Tutors on 140+ subjects
- Full access to over 1 million Textbook Solutions
*You can change, pause or cancel anytime
Question
Answered
Need this completed in excel and word per directions. See below and thank you so much!!
You work for a hospital that has a specialized center for obesity and weight management. Your boss assigns you the task of analyzing supposedly “healthy” breakfast cereals in the following data set: http://lib.stat.cmu.edu/DASL/Datafiles/Cereals.html. (This data set has also been attached above as an Excel document.) Examine and evaluate the data set for significant findings (e.g. mean, standard deviation, scatterplot, histogram, bar chart etc.) which will be used in educational materials for patients.
name
mfr
type
caloriesprotein fat
sodium
fiber
carbo
sugars
potass
vitaminsshelf
weight
cups
rating
100%_Bran
N
C
70
4
1
130
10
5
6
280
25
3
1
0.33
68.403
100%_Natural_Bran
Q
C
120
3
5
15
2
8
8
135
0
3
1
1 33.9837
All-Bran
K
C
70
4
1
260
9
7
5
320
25
3
1
0.33 59.4255
All-Bran_with_Extra_Fiber
K
C
50
4
0
140
14
8
0
330
25
3
1
0.5 93.7049
Almond_Delight
R
C
110
2
2
200
1
14
8
-1
25
3
1
0.75 34.3848
Apple_Cinnamon_Cheerios
G
C
110
2
2
180
1.5
10.5
10
70
25
1
1
0.75 29.5095
Apple_Jacks
K
C
110
2
0
125
1
11
14
30
25
2
1
1 33.1741
Basic_4
G
C
130
3
2
210
2
18
8
100
25
3
1.33
0.75 37.0386
Bran_Chex
R
C
90
2
1
200
4
15
6
125
25
1
1
0.67 49.1203
Bran_Flakes
P
C
90
3
0
210
5
13
5
190
25
3
1
0.67 53.3138
Cap'n'Crunch
Q
C
120
1
2
220
0
12
12
35
25
2
1
0.75 18.0429
Cheerios
G
C
110
6
2
290
2
17
1
105
25
1
1
1.25
50.765
Cinnamon_Toast_Crunch
G
C
120
1
3
210
0
13
9
45
25
2
1
0.75 19.8236
Clusters
G
C
110
3
2
140
2
13
7
105
25
3
1
0.5 40.4002
Cocoa_Puffs
G
C
110
1
1
180
0
12
13
55
25
2
1
1 22.7364
Corn_Chex
R
C
110
2
0
280
0
22
3
25
25
1
1
1
41.445
Corn_Flakes
K
C
100
2
0
290
1
21
2
35
25
1
1
1 45.8633
Corn_Pops
K
C
110
1
0
90
1
13
12
20
25
2
1
1 35.7828
Count_Chocula
G
C
110
1
1
180
0
12
13
65
25
2
1
1 22.3965
Cracklin'_Oat_Bran
K
C
110
3
3
140
4
10
7
160
25
3
1
0.5 40.4488
Cream_of_Wheat_(Quick)
N
H
100
3
0
80
1
21
0
-1
0
2
1
1 64.5338
Crispix
K
C
110
2
0
220
1
21
3
30
25
3
1
1 46.8956
Crispy_Wheat_&_Raisins
G
C
100
2
1
140
2
11
10
120
25
3
1
0.75 36.1762
Double_Chex
R
C
100
2
0
190
1
18
5
80
25
3
1
0.75 44.3309
Froot_Loops
K
C
110
2
1
125
1
11
13
30
25
2
1
1 32.2076
Frosted_Flakes
K
C
110
1
0
200
1
14
11
25
25
1
1
0.75
31.436
Frosted_Mini-Wheats
K
C
100
3
0
0
3
14
7
100
25
2
1
0.8 58.3451
Fruit_&_Fibre_Dates,_Walnuts,_and_Oats
P
C
120
3
2
160
5
12
10
200
25
3
1.25
0.67
40.917
Fruitful_Bran
K
C
120
3
0
240
5
14
12
190
25
3
1.33
0.67 41.0155
Fruity_Pebbles
P
C
110
1
1
135
0
13
12
25
25
2
1
0.75 28.0258
Golden_Crisp
P
C
100
2
0
45
0
11
15
40
25
1
1
0.88 35.2524
Golden_Grahams
G
C
110
1
1
280
0
15
9
45
25
2
1
0.75
23.804
Grape_Nuts_Flakes
P
C
100
3
1
140
3
15
5
85
25
3
1
0.88 52.0769
Grape-Nuts
P
C
110
3
0
170
3
17
3
90
25
3
1
0.25
53.371
Great_Grains_Pecan
P
C
120
3
3
75
3
13
4
100
25
3
1
0.33 45.8117
Honey_Graham_Ohs
Q
C
120
1
2
220
1
12
11
45
25
2
1
1 21.8713
Honey_Nut_Cheerios
G
C
110
3
1
250
1.5
11.5
10
90
25
1
1
0.75 31.0722
Honey-comb
P
C
110
1
0
180
0
14
11
35
25
1
1
1.33 28.7424
Just_Right_Crunchy__Nuggets
K
C
110
2
1
170
1
17
6
60
100
3
1
1 36.5237
Just_Right_Fruit_&_Nut
K
C
140
3
1
170
2
20
9
95
100
3
1.3
0.75 36.4715
Kix
G
C
110
2
1
260
0
21
3
40
25
2
1
1.5 39.2411
Life
Q
C
100
4
2
150
2
12
6
95
25
2
1
0.67 45.3281
Lucky_Charms
G
C
110
2
1
180
0
12
12
55
25
2
1
1 26.7345
Maypo
A
H
100
4
1
0
0
16
3
95
25
2
1
1 54.8509
Muesli_Raisins,_Dates,_&_Almonds
R
C
150
4
3
95
3
16
11
170
25
3
1
1 37.1369
Muesli_Raisins,_Peaches,_&_Pecans
R
C
150
4
3
150
3
16
11
170
25
3
1
1 34.1398
Mueslix_Crispy_Blend
K
C
160
3
2
150
3
17
13
160
25
3
1.5
0.67 30.3134
Multi-Grain_Cheerios
G
C
100
2
1
220
2
15
6
90
25
1
1
1
40.106
Nut&Honey_Crunch
K
C
120
2
1
190
0
15
9
40
25
2
1
0.67 29.9243
Nutri-Grain_Almond-Raisin
K
C
140
3
2
220
3
21
7
130
25
3
1.33
0.67 40.6923
Nutri-grain_Wheat
K
C
90
3
0
170
3
18
2
90
25
3
1
1 59.6428
Oatmeal_Raisin_Crisp
G
C
130
3
2
170
1.5
13.5
10
120
25
3
1.25
0.5 30.4508
Post_Nat._Raisin_Bran
P
C
120
3
1
200
6
11
14
260
25
3
1.33
0.67 37.8406
Product_19
K
C
100
3
0
320
1
20
3
45
100
3
1
1 41.5035
Puffed_Rice
Q
C
50
1
0
0
0
13
0
15
0
3
0.5
1 60.7561
Puffed_Wheat
Q
C
50
2
0
0
1
10
0
50
0
3
0.5
1 63.0056
Quaker_Oat_Squares
Q
C
100
4
1
135
2
14
6
110
25
3
1
0.5 49.5119
Quaker_Oatmeal
Q
H
100
5
2
0
2.7
-1
-1
110
0
1
1
0.67 50.8284
Raisin_Bran
K
C
120
3
1
210
5
14
12
240
25
2
1.33
0.75 39.2592
Raisin_Nut_Bran
G
C
100
3
2
140
2.5
10.5
8
140
25
3
1
0.5 39.7034
Raisin_Squares
K
C
90
2
0
0
2
15
6
110
25
3
1
0.5 55.3331
Rice_Chex
R
C
110
1
0
240
0
23
2
30
25
1
1
1.13 41.9989
Rice_Krispies
K
C
110
2
0
290
0
22
3
35
25
1
1
1 40.5602
Shredded_Wheat
N
C
80
2
0
0
3
16
0
95
0
1
0.83
1 68.2359
Shredded_Wheat_'n'Bran
N
C
90
3
0
0
4
19
0
140
0
1
1
0.67 74.4729
Shredded_Wheat_spoon_size
N
C
90
3
0
0
3
20
0
120
0
1
1
0.67 72.8018
Smacks
K
C
110
2
1
70
1
9
15
40
25
2
1
0.75 31.2301
Special_K
K
C
110
6
0
230
1
16
3
55
25
1
1
1 53.1313
Strawberry_Fruit_Wheats
N
C
90
2
0
15
3
15
5
90
25
2
1
1
59.364
Total_Corn_Flakes
G
C
110
2
1
200
0
21
3
35
100
3
1
1 38.8397
Total_Raisin_Bran
G
C
140
3
1
190
4
15
14
230
100
3
1.5
1 28.5928
Total_Whole_Grain
G
C
100
3
1
200
3
16
3
110
100
3
1
1 46.6588
Triples
G
C
110
2
1
250
0
21
3
60
25
3
1
0.75 39.1062
Trix
G
C
110
1
1
140
0
13
12
25
25
2
1
1 27.7533
Wheat_Chex
R
C
100
3
1
230
3
17
3
115
25
1
1
0.67 49.7874
Wheaties
G
C
100
3
1
200
3
17
3
110
25
1
1
1 51.5922
Wheaties_Honey_Gold
G
C
110
2
1
200
1
16
8
60
25
1
1
0.75 36.1876
1 page
Answer & Explanation
Solved by verified expert
Rated
a. F
ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing eUnlock full access to Course Hero
Explore over 16 million step-by-step answers from our library
Subscribe to view answer
png
