Question: Instructions: Part A - 5 pts Beginning in cell A 1 , create a frequency distribution for the quantitative Calories column from your Data Set.

Instructions: Part A-5 pts Beginning in cell A1, create a frequency distribution for the quantitative "Calories" column from your Data Set. You should have classes 50-69,70-89,90-109,110-129,130-149,150-169 in column A and counts for each range in column B. If you get a (blank) row, be sure to remove it. Use the "Location" option to choose the appropriate location for your display using the "Pivot Table" feature. Remember that the pivot table feature has a "location" option, so when you select the data from the data sets page, choose "Existing workbook" and then navigate to cell A1 on this page. Part B-5 pts Using the pivot table from your output in Part A, that means don't make it yourself, create a histogram. Entitle your histogram "Calories in Breakfast Cereal". Ensure you have a gap-width of zero and that your frequency scale has increments of 5. Add an axis title of "Frequency" to the vertical axis and "Calories" to the horizontal axis. Position the histogram below your pivot table from Part A beginning in cell A10. Feel free to move this text box out of the way to make room. Part C-5 pts Based on your histogram from Part B (so don't calculate anything else), about how many calories would you expect to consume eating cereal for breakfast on a single day? Answer in a complete sentence(s), making sure to cite your STATISTICAL reason(s) for your solution and citing the histogram from part B. Type your solution in the textbox provided, then position the text box below your histogram. Resize the text box as needed for your solution to fit within the box.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!