The quiz tool is being used to collect and score the M4. Assignment: Case Study. You may submit the assignment multiple times prior to the submission deadline, if needed.However, if you choose to resubmit you must re-enter the responses for all questions and all parts of the questions.ONLY THE LAST SUBMISSION WILL BE SCORED.

Files

Data was collected on 77 cereals. The 16 variables are presented in theattached Word file,

download

along with the units of measurement and a summary of the questions to be answered for this assignment. The data for the assignment is presented in theattached Excel file

download

and is also available in StatCrunch.

Variables and Assignment Summary.docx

download

Cereal Data.xlsx

download

Requirements

It is best if you first prepare your responses outside of Canvas and then transfer the completed work into the provided answer fields. It is not possible to save your work in Canvas without submitting it. However,you may resubmit the assignment any time prior to the deadline.Please note, that a resubmission requires resubmitting responses to ALL questions so that the assignment is presented as a complete response.

Prepare responses to the following using the tool of your choice (StatCrunch, Excel, etc) to create graphsand execute operations, as needed. Download and save the work product (graphs, computations,charts) to be embedded within your response in the provided answer fields.All answers must be visible in the field without the needed to click a link.Access this link for instructions on how toembed an image into the answer field.(Links to an external site.)

Prepare explanations in Word to copy and paste into the answer field when you are ready. Be sure that your explanations demonstrate correct grammar and mathematical notation; the Wyris Equation Editor may be needed to insert special characters.

When you are ready to submit your assignment, click Take the Quiz below, enter the responses in the appropriate fields, and then click Submit Quiz.

Please review the scoring rubric as you complete the assignment in order to earn maximum points.M4 Case Study Rubric.pdf

download

Use StatCrunch or the tool of your choice to execute the following tasks and then embed (not link) the result into the questions below. Your explanations must demonstrate correct grammatical and mathematical notation.

Flag question: Question 1

Question 1

15pts

Visual Display

a) Prepare an appropriate graphical display of the number of cereals in the study by manufacturer.Download the image from StatCrunch or other tool and embed it into the answer field.

b) Identify the type of display selected and explain why your choice is both appropriate and the best option for presenting the information.

Question 2

10pts

Review the variables and scan the responses. For each of the measures of center (mean, median,mode), identify a variable that would be best represented by the measure. Determine the measure and explain why it is the best summary option for the selected variable.

For questions 3 and 4, select a variable from calories, sodium, potassium, or rating to use in both questions.

Question 3

35pts

Organization and Presentation

a) Create a frequency distribution for the selected variable.Present the frequency distribution, with all appropriate labels, in the provided answer field as an embedded image.

b) Create the histogram that displays the frequency distribution in part a). Present the histogram, with all appropriate labels, in the answer field as an embedded image.

c) Create a boxplot for the selected variable and identify the five-number summary. Present the boxplot and five number summary, with all appropriate labels, in the answer field as an embedded image.

d) Based on the results of parts a) - c), do you think the mean is the best measure of central tendency for the selected variable? Explain why or why not?

Question 4

20pts

Numeric Summaries

Use the formulas for grouped data and the frequency distribution created in question 3 to estimate the mean and the standard deviation of the selected variable.Embed images of the work process that support your computations.

Question 5

20pts

Making comparisons

a) Create and interpret a side-by-side box-and-whiskers plot for the variables carbo and sugars. Identify the five-number summary for each variable.Embed the image, completed with labels, into the answer field.

b) What do the boxplots suggest about the shapes of the frequency distribution for the variables carbo and sugars?

c) Based on the boxplots and number summaries alone, answer the following:

• Do you think the mean is greater than, equal to, or less than the median of these variables? Support your answer with references to the boxplot.
• Which of these two variables do you think has the greater standard deviation? Support your answer with references to the boxplot.

M4. Assignment: Case Study The provided data file includes the data collected on 77 cereals. The 16 variables are : Name: Mfr: WPEZ calories: protein: fat: sodium: fiber: carbo: sugars: potass: vitamins: shelf: weight: cups: rating: Name of cereal Manufacturer of cereal where A = American Home Food Products; G = General Mills; K = Kelloggs; N = Nabisco; P = Post; Q: Quaker Oats; R = Ralston Purina cold or hot calories per serving grams of protein grams of fat milligrams of sodium grams ofdietary fiber grams of complex carbohydrates grams of sugars milligrams of potassium vitamins and minerals - 0,25, or 100, indicating the typical percentage of FDA recommended display shelf (1, 2, or 3, counting from the floor) weight in ounces of one serving number of cups in one serving a rating of the cereals taste Use StatCrunch or another tool of your choice to execute the following tasks and submit the responses in the appropriate fields in Canvas. 1. Prepare an appropriate graphical display of the number of cereals in the study by manufacturer. Identify the type of display selected and explain why it is the best display option. 2. Review the variables and scan the responses. For each of the measures of center (mean, median,mode), identify a variable that would be best represented by the measure. Determine the measure and explain why it is the best summary option for the selected variable. 3. Create a frequency distribution, histogram, and boxplot for ONE of the following variables: calories, sodium, potassium, or rating. Do you think the mean is the best measure of central tendency for the selected variable? Use the results of this question to explain why or why not. 4. Use formulas for grouped data and the frequency distribution created in question 3 to estimate the mean and standard deviation of the variable selected for question 3. 5. Create and interpret side-by-side box-and-whiskers plot for the variables ca rbo and sugars; identify the five-number summary for each variable. What do the boxplots reveal about the shape of the distributions? Based on the boxplots alone, do you think the mean is greater than, approximately equal to, or less than the median in these variables? Based on the boxplots alone, which of these two variables do you think has the greater standard deviation? Support your answer with references to the boxplot. Name: Name of cereal mfr: Manufacturer of cereal where A = American Home Food Products; G = General Mills; K = Kelloggs; N = Nabisco type: cold or hot calories: calories per serving protein: grams of protein fat: grams of fat sodium: milligrams of sodium fiber: grams of dietary fiber carbo: grams of complex carbohydrates sugars: grams of sugars potass: milligrams of potassium vitamins: vitamins and minerals - 0, 25, or 100, indicating the typical percentage of FDA recommended shelf: display shelf (1, 2, or 3, counting from the floor) weight: weight in ounces of one serving cups: number of cups in one serving rating: a rating of the cereals\f100%_Bran calorie reigh 3.33 rating 100% _Natural_Bran All-Bran 33.98368 All-Bran_with_Extra_Fiber Almond_Delight 93.70491 Apple_Cinnamon_Cheerios 34.38484 Apple Jacks 23.50954 Basic_4 Bran_Chex 37.03856 Bran_Flakes 19.12025 Cap'n Crunch Da Cheerios 8.04285 Cinnamon_Toast_Crunch 0.765 Clusters 19.82357 Cocoa Puffs 22.73645 Corn_Flakes corn_Pops Count_Chocula 35.78279 Cracklin'_Oat_Bran Cream_of_Wheat_(Quick) 40.44877 Crispix 28EES' 19 Crispy_Wheat_&_Raisins Double_Chex .1762 Froot_Loops Frosted Flakes 32.20758 Frost ed_Mini-Wheats Fruit_& _Fibre_Dates,_Walnuts,_and_! 58.34514 Fruitful_Bran 1705 Fruity Pebbles Golden_Crisp Golden_Grahams Grape Nuts_Flakes Grape-Nuts Great_Grains_Pecan Honey_Graham_Ohs Honey Nut_Cheerios Honey-comb P K N W W H N W W N N O N W W N N E N W W U A N H W W W W W N N W E B A N D N W N H W H W W W F N H W W W H N N N N W W H H N N H W H O H W N W N N N A A WAS ust_Right_Crunchy_Nuggets WHENTHE POO POO ODD ONE NEDOOF NON PE NWW F E N E F POENW OF POP ONDO FDP DO W EDDOF NUNNOF NONNOH U HA PWWOOWPOWPPWA WOONMUNNPOPO EWWONWW WOON ON PO H WW WOOO UU W P FP NFPAOF POONON OUANE G- KONG THENWW WW N F N E F F F F W W N P W W W W W W W W N F W W W N N N N WW F E N W WW N E N W W N E N W W W N W N N P EN W N E N W H W N F W W W W W B 28.7424 Just_Right _Fruit_&_Nut Kix Life Lucky_Charms 45. 32807 Maypo Muesli_Raisins,_Dates,_& Almonds 54.85092 Muesli_Raisins,_Peaches, &_Pecans Mueslix_Crispy_Blend Multi-Grain_Cheerio Nut & Honey_Crunch Nutri-Grain_Almond-Raisin Nutri grain_Wheat Oatmeal_Raisin_Crisp Post _Nat._Raisin_Bran Product_19 puffed_Rice 41.50 puffed_Wheat 60.75611 Quaker _Oat_Squares Quaker _Oat meal 19.51187 Raisin_Bran Raisin_Nut_Bran .2592 Raisin_Squares Rice_Chex 15.33314 Rice Krispies 86856 TE Shredded_Wheat 40.56016 Shredded_Wheat_'n'Bran 68.23589 Shredded_Wheat_spoon_size Smacks Special_K Strawberry_Fruit_Wheats Total_Corn Flakes Total_Raisin_Bran Total_Whole Grain Triples wheat_Che 27.753 Wheaties Wheaties Honey_Gold $1.59215