Chapter 43 Summarizing data by using 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 pivot tables. In this chapter, I discuss the use of histograms for summarizing data. Prior to Excel 2016, you used the Data Analysis add-in to create histograms. The histograms ...
Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th 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.
