PROBLEM 1 (25 POINTS)

The (rounded) average price for a box of cookies obtained from randomly picked bakeries is listed below:

40 23 11 20 22 20 45 15 28 21

22 20 72 19 22 28 25 19 23 47

45 15 30 10 55 15 17 49

a. Construct a grouped frequency distributionand 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 (always round-up;if the width computation results in an integer, round it up to the next integer)

Step 3. Create class boundaries

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