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

Question #6575

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

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

Expert's answer

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.

Need a fast expert's response?

Submit orderand get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

## Comments

## Leave a comment