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

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.