Microsoft Office Tutorials and References

In Depth Information

**Appendix: Frequency Distributions with Mac Excel 2011**

Frequency

250

200

150

100

Frequency

50

0

FIGURE 11.15
Frequency Distribution Chart

The final frequency distribution can be seen in Figure 11.15. Notice how the data

is skewed and very few people among the 1,000 customers have a household income

over $200,000. It can be confirmed by going back to the original data to verify that

only 12 households or 1.2 percent have an income over $200,000.

APPENDIX: FREQUENCY DISTRIBUTIONS WITH MAC EXCEL 2011

There is no difference using the Frequency function from the procedure described

above.

REVIEW QUESTIONS

You will find these examples in the Excel Chapter 11 file:

1.
On the Review sheet of Chapter 11, construct a frequency distribution table and

a frequency distribution chart.

2.
Using the Statistics sheet of the Chapter 11

le, create a new frequency distri-

bution table and a new frequency distribution chart. This time apply different

bin sizes in multiples of 5 starting with 65, 70, and ending with 130.

3.
Using the HHold Income sheet of the Chapter 11

le, create a new frequency

distribution table and a new frequency distribution chart. This time program

different bin sizes in multiples of 20,000 starting with 20,000, 40,000, and

ending with 240,000.