Chapter 7

Summarizing It All

In This Chapter

arrow Working with things great and small

arrow Understanding symmetry, peaks, and plateaus

arrow Getting descriptive

arrow Serving up statistics on a tray

Measures of central tendency and variability are excellent ways of summarizing a set of scores. They aren’t the only ways. Central tendency and variability make up a subset of descriptive statistics. Some descriptive statistics are intuitive — like count, maximum, and minimum. Some are not — like skewness and kurtosis.

In this chapter, I discuss descriptive statistics, and I show you Excel’s capabilities for calculating them and visualizing them.

Counting Out

The most fundamental descriptive statistic I can imagine is the number of scores in a set of scores. Excel offers five ways to determine that number. Yes, five ways. Count them.

COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS

Given an array of cells, COUNT gives you the amount of those cells that contain numerical data. Figure 7-1 shows that I’ve entered a group of scores, selected a cell to hold COUNT’s result, and opened the Function Arguments dialog ...

Get Statistical Analysis with Excel For Dummies, 3rd Edition now with O’Reilly online learning.

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