Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 pts Beginning in cell A create a frequency distribution for the quantitative "Calories" column from your Data Set. You should have classes 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 A on this page. Part B 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 gapwidth of zero and that your frequency scale has increments of 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 A Feel free to move this text box out of the way to make room. Part C 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 sentences making sure to cite your STATISTICAL reasons 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started