Quantitative Data

/in /by

2. Quantitative Data – 15 pts

One way to organize data numerically is to create a frequency distribution. This is important for both quantitative data (numbers that behave as numbers) and qualitative data, where we are interested in some non-numerical attribute. Using the data set in the second tab, create the distributions described below, but be sure you DON’T copy and paste the data to this page. Instead, use the “location” option in your pivot table tools for part A. Part B and C will be based on your work for part A.

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.