Chapter 93

Use Analyze Data to find patterns in your data

Questions answered in this chapter:

  • How can I create for the Navy a bill of material (BOM) report?

  • What patterns can I find in stock market prices?

  • Is ER a better hospital than Chicago Hope?

  • How does a father’s height affect a son’s height?

  • If you make families pay when they are late to pick up their children, are they less likely to be late?

In our personal and professional lives, we are exposed each day to multiple sets of data. This book has taught you about Excel’s myriad tools for summarizing and analyzing data. For example:

  • Chapter 24 discussed how conditional formatting can be used to summarize data.

  • Chapters 30 and 31 discussed how histograms, boxplots, and descriptive statistics ...

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.