Name Calories Cereal Calories 100% Bran 70 100% Natural Bran 120 On the left is a list of popular cereals and their calorie count. Answer the following Insert histogram with a title and the vertical axis labeled Frequency and horizontal All-Bran 70 questions using EXCEL functions. Do not use column A in the calculations. Calories. Use a bin size of 10 and an underflow of 45 All-Bran with Extra Fiber 50 Almond Delight 110 Brand Calories Min: 35 Apple Cinnamon Cheer 110 50 Max: 160 Apple Jacks 110 Basic 4 130 90 Median: 110.00 Mean: Bran Chex 106.88 30 Bran Flakes 90 Cap'n Crunch 120 Cheerios 110 Q1: 100.00 Q3 110.00 25 Cinnamon Toast Crunch 120 Clusters 110 Based on the Median and the 20 Cocoa Puffs 110 Mean, describe how the data is Frequency Corn Chex 110 Corn Flake 100 15 Corn Pops 110 Insert Box Plot with a title and the vertical axis labeled. Count Chocula 110 Brands 10 Cracklin' Oat Bran 110 1.80 Cream of Wheat [Quick)] 100 Crispix 110 5 Crispy Wheat & Raising 100 160 Double Chex 100 Froot Loops 110 Frosted Flakes 110 140 [60, 70 180, 90 (100, 110] (120, 130] (140, 150] Frosted Mini-Wheats 100 (50, 60] [70, 80] [50, 100) [110, 120] (130, 140 (150, 160] Fruit & Fibre Dates; Wald 120 Haricanal Calarisa Fruitful Bran 120 120 Fruity Pebbles 110 Consider the quartiles, where is the Golden Crisp 100 interval for the center 50% of the data? Golden Grahame 110 100 Grape Nuts Flakes 100 Cereal Calories Looking at the Histogram of Grape-Nut 110 calories, what is the most frequent Great Grains Pecan 120 Honey Graham Ohs 120 Using both graphs, is the center of Honey Nut Cheerios 110 the data compact or spreadout? Honey-comb 110 Just Right Crunchy Nug 110 Using the histogram, do you think Just Right Fruit & Nut 140 the data is normal (bell shaped) 110 Life 100 20 Justify (explain your logic your previsous answer: Lucky Charms 110 Maypo 100 Muesli Raising; Dates; * 150 Muesli Raisins; Peaches; 150 Mueslix Crispy Blend 160 Multi-Grain Cheerios 100Nut&Honey Crunch 120 Nutri-Grain Almond-Rais 140 Nutri-grain Wheat 30 Oatmeal Raisin Crisp 130 Post Nat. Raisin Bran 120 Product 19 100 Puffed Rice 50 Puffed Wheat 50 Quaker Oat Squares 100 Quaker Oatmeal 100 Raisin Bran 120 Raisin Nut Bran 100 Raisin Squares 30 Rice Chex 110 Rice Krispies 110 Shredded Wheat 80 Shredded Wheat 'n'Bran 30 Shredded Wheat spoon : 30 Smacks 110 Special K 110 Strawberry Fruit Wheats 30 Total Corn Flakes 110 Total Raisin Bran 140 Total Whole Grain 100 Triples 110 Trix 110 Wheat Chex 100 Wheaties 100 Wheaties Honey Gold 110