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.



1 Attachment
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
Background image of page 1
1 page
Answer & Explanation
Verified 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 e

Unlock full access to Course Hero

Explore over 16 million step-by-step answers from our library

Subscribe to view answer
1 Attachment
Chart.PNG
png
Student review
100% (1 rating)