Chapter 41. Summarizing Data by Using Histograms

Questions answered in this chapter:

  • People often say that a picture is worth a thousand words. Can I use Excel to create a picture (called a histogram) that summarizes the values in a data set?

  • What are some common shapes of histograms?

  • What can I learn by comparing histograms from different data sets?

The ability to summarize a large data set is important. The three tools used most often to summarize data in Microsoft Excel are histograms, descriptive statistics, and PivotTables. In this chapter, I discuss the use of histograms for summarizing data. I cover descriptive statistics in Chapter 42, and PivotTables in Chapter 43.

Answers to This Chapter’s Questions

People often say that a picture is worth ...

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.