Chapter 30
Summarizing data with histograms and Pareto charts
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?
How do I create a Pareto chart?
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.
This chapter discusses the use of histograms for summarizing data. Before Excel 2016, you used the Data Analysis add-in to create histograms. The histograms created by this ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
