Table of Contents
Google Sheets allows users to quickly and easily calculate Mean, Median, and Mode of a set of data using the AVERAGE, MEDIAN, and MODE functions. Simply select the cells containing your data, then type the formula into the cell you wish to display the result. For example, to calculate the mean, type “=AVERAGE(A2:A12)” into the cell, replacing “A2:A12” with the range of cells containing your data. To calculate the median, use the “=MEDIAN(A2:A12)” formula, and to calculate the mode, use the “=MODE(A2:A12)” formula. The results will be calculated and displayed in the cell you specified.
You can use the following formulas to find the mean, median, and mode of a dataset in Google Sheets:
=AVERAGE(A1:A10) =MEDIAN(A1:A10) =MODE.MULT(A1:A10)
Note: Each of these formulas will simply ignore non-numeric or blank values when calculating these metrics for a range of cells in Google Sheets.
The following examples shows how to use these formulas in practice with the following dataset:
Example: Calculating the Mean in Google Sheets
The mean represents the average value in a dataset.
The following screenshot shows how to calculate the mean of a dataset in Google Sheets:
The mean turns out to be 19.11.
Example: Calculating the Median in Google Sheets
The median represents the middle value in a dataset, when all of the values are arranged from smallest to largest.
The following screenshot shows how to calculate the median of a dataset in Google Sheets:
The median turns out to be 20.
Example: Calculating the Mode in Google Sheets
The mode represents the value that occurs most often in a dataset. Note that a dataset can have no mode, one mode, or multiple modes.
The modes turn out to be 7 and 25. Each of these values appears twice in the dataset, which is more often than any other value occurs.
Note that if you use the =MODE() function instead, it will only return the first mode. For this dataset, only the value 7 would be returned.
This is why it’s a good idea to use the =MODE.MULT() function in case there happens to be more than one mode in the dataset.
The following tutorials explain how to calculate other common metrics in Google Sheets: