# Descriptive Statistics

Summarize your data by finding the mean, median, standard deviation, and other descriptive statistics.

I demonstrate how to use =min() and =max() to calculate the minimum and maximum scores in a dataset.

Learn how to use the =average(), =median(), and =stdev() functions to calculate the mean, median, and standard deviation.

The =countif() function calculates frequencies in Excel. You’ll learn how to use =countif() to tally how many people selected strongly agree, agree, disagree, and strongly disagree options in a satisfaction survey.

Next, use \$ symbols within your =countif function to save even more time as you tally responses on a satisfaction survey.

I show you how to calculate a variety of descriptive statistics for interval or ratio data, including:

• Basic data cleaning: =count, =countblank
• Measures of central tendency: =average, =median, =mode
• Measures of dispersion: =var, =stdev, =min, =max, =quartile, ranges

This tutorial is designed for people with a basic statistics or social science background. That is, I explain how to translate your preexisting knowledge about descriptive statistics into simple Excel formulas rather than explaining why these metrics are useful.