Answer to Question #6575 in Statistics and Probability for Jessica Smith

Question

PROBLEM 1
The (rounded) average price for a box of cookies obtained from 28 bakeries is listed below:

40 23 11 20 22 20 45 15 28 22
22 18 72 19 22 28 27 19 23 46
45 15 30 10 56 15 17 59

a. Construct a grouped frequency distribution and a cumulative frequency distribution with 6 classes.
Note: give a brief explanation by specifying the covered steps.

Grouped Frequency Distribution
Step 1. Find Range
Step 2. Compute classes’ width
Step 3. Create class boundaries
Step 4. Tally the data and find the numerical frequencies from the tally

Cumulative Frequency Distribution
Step 1. Find Range
Step 2. Compute classes’ width
Step 3. Find the frequencies and the corresponding percentage

b. Use Excel to construct a Histogram. (Tools  Data Analysis  Histogram  for input range select the given values, for the bin range select the classes upper boundaries values  check Chart Output).