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

Answer 1

Unfortunately, your question requires a lot of work and cannot be done for free.
Submit it with all requirements as an assignment to our control panel and we'll assist you.