- Hodges University
- Terry P. McMahan Library
- Resource Guides
- Finance
- Descriptive Statistics

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

- Descriptive Statistics, Part 1This tutorial focuses on the measures of central tendency and dispersion (or variability).
- Descriptive Statistics, Part 2This tutorial focuses on measures of position, including percentiles, quartiles, and standard scores (z-scores).

- Pivot Table Summary FunctionsWhen 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.

AVEDEV

AVERAGE

COUNT

KURT

LARGE

MAX

MEDIAN

MIN

MODE

QUARTILE

SKEW

SMALL

STDEV

STDEVP

VAR

VARP