Descriptive Statistics

Perhaps the most common Data Analysis tool that you’ll use in Excel is the one for calculating descriptive statistics.

This tutorial focuses on the measures of central tendency and dispersion (or variability).

This tutorial focuses on measures of position, including percentiles, quartiles, and standard scores (z-scores).

When you add a field to the pivot table's Values area, 11 different functions, such as Sum, Count and Average, are available to summarize the data.
The summary functions in a pivot table are similar to the worksheet functions with the same names, with a few differences as noted in the descriptions that follow.