How to Calculate Mean, Median & Mode in Google Sheets


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 following screenshot shows how to calculate the mode of a dataset in Google Sheets:

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.

Additional Resources

The following tutorials explain how to calculate other common metrics in Google Sheets:

How to Calculate the Interquartile Range in Google Sheets
How to Calculate the Midrange in Google Sheets
How to Calculate Standard Deviation in Google Sheets

Leave a Reply

Your email address will not be published.