# 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.

Bonus! Download the spreadsheet used in this video.

How many different categories (like states) are represented in your dataset? In this video, I teach you three strategies for determining how many unique entries are represented:

• Filters
• Pivot table tallies
• Advanced filters
Bonus! Download the spreadsheet used in this video.