Answered step by step
Verified Expert Solution
Link Copied!

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-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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Logics For Databases And Information Systems

Authors: Jan Chomicki ,Gunter Saake

1st Edition

1461375827, 978-1461375821

More Books

Students also viewed these Databases questions

Question

For the standard normal density (x), show that 0(x) x(x).

Answered: 1 week ago