Microsoft Office Tutorials and References
In Depth Information
Appendix: Frequency Distributions with Mac Excel 2011
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
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.