Table of Contents
Google Sheets is a powerful spreadsheet program that allows users to input and manipulate data in a variety of ways. One useful feature is the ability to calculate the mean, median, and mode of a set of numbers. To do so, users can simply input their data into a column or row, then use the built-in formulas for these calculations. The mean is the average of all the numbers, the median is the middle number when the data is arranged in order, and the mode is the most commonly occurring number. These calculations can help users gain insights and make informed decisions based on their data.
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 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:
Cite this article
stats writer (2024). How can I calculate the mean, median, and mode in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-calculate-the-mean-median-and-mode-in-google-sheets/
stats writer. "How can I calculate the mean, median, and mode in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-calculate-the-mean-median-and-mode-in-google-sheets/.
stats writer. "How can I calculate the mean, median, and mode in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-calculate-the-mean-median-and-mode-in-google-sheets/.
stats writer (2024) 'How can I calculate the mean, median, and mode in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-calculate-the-mean-median-and-mode-in-google-sheets/.
[1] stats writer, "How can I calculate the mean, median, and mode in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I calculate the mean, median, and mode in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.