Descriptive Statistics

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

Tutorials about descriptive statistics include:

Or, watch the entire descriptive statistics playlist in YouTube.

Min and Max

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

Mean, Median, and Standard Deviation

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

Countif

The =countif() function calculates frequencies in Excel. In this video, 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.

Countif with $

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

Return to top

Jump to: Excel for Evaluation homepage | Housekeeping | Cleaning and Recoding | Exploring | Descriptives | Pivot Tables | Charts and Graphs | Extras | Putting It All Together

One thought on “Descriptive Statistics

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s