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