Chapter 2. Averages and Outliers Middle Matters
Statistics help you describe data and see the bigger picture. And one of the most important statistics in town is the average. In this chapter, we’ll cover three kinds of average—the mean, median, and mode—and when to use each one. You’ll discover the impact skewness and outliers can have on your results. You’ll find out how histogram and box and whisker charts can help you explore what’s really going on with your data. Along the way, you’ll learn how to use Excel functions and ranges to calculate a whole host of descriptive statistics.
The mode revisited
In the previous chapter, you learned how to calculate different types of frequency and find a dataset’s mode: the value or group with the highest frequency. For example, if you plot the frequencies on a column chart, the mode is ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access