We can use Excel to create descriptive statistics for a data set. Here are a few videos with some help on how to do some basic tasks.

The filter command is often a good place to start with a new dataset:

Using Filter

In the Analysis Toolpack, there is a way to quickly calculate the descriptive statistics for a dataset:

Analysis Toolpack Descriptive Statistics

Sometimes, the Analysis Toolpack is missing from the Data menu tab. If it is, here is the way to install it:

Install the Analysis Toolpack

Descriptive statistics can also be computed using the built-in functions Excel provides:

Basic Statistical Functions