Read time: 3 minutes
Introduction
Learn how to calculate the average, median, and mode in Google Sheets. These simple formulas will help you analyze your data more effectively.
What are the Average, Median, and Mode?
The average, median, and mode are known as measures of central tendency. They help identify the center of a dataset, providing valuable insights.
- The average represents the mean value of a dataset.
- The median is the middle value of a dataset when sorted in ascending order.
- The mode represents the most frequent value in a dataset.
Calculating these statistics is straightforward in Google Sheets, thanks to simple formulas that can be applied to a dataset.
Syntax
We use the functions AVERAGE, MEDIAN, and MODE to calculate the average, median, and mode in Google Sheets.
- AVERAGE(value1, [value2, …])
- MEDIAN(value1, [value2, …])
- MODE(value1, [value2, …])
value1: the value or range of values for which we want to calculate the average, median, or mode.
value2, … (optional): additional values or range of values related to the average, median, or mode calculations.
Calculating the Average in Google Sheets
To calculate the average or mean value of a dataset, provide the range of cells containing the input values to the AVERAGE() function. Use the following formula:
=AVERAGE(B2:B9)The average of the dataset will be displayed as shown below:
Calculating the Median in Google Sheets
Similarly, to calculate the median of a dataset, type the following formula:
=MEDIAN(B2:B9)This will calculate and display the median of the dataset.
Calculating the Mode in Google Sheets
Likewise, we can use the following formula to calculate the mode of a dataset:
=MODE(B2:B9)As shown in the image below, the mode of the dataset will now be displayed.
More Similar Statistical Formulas in Google Sheets
If you found our guide on calculating central points of a dataset using formulas for the average, median, and mode helpful, you may also find it useful to learn about other commonly used statistical formulas and techniques:
- How to use the BINOM.DIST function in Google Sheets: Calculating probabilities based on the binomial distribution.
- Using the AVERAGEIF function in Google Sheets: Calculating average values based on conditions in a dataset.
- How to use the SUMIF function in Google Sheets: Calculating totals based on conditions in a dataset.
For more articles, tips, techniques, and formulas in Google Sheets, check out Crawlan.com. Our team of spreadsheet specialists has selected hundreds of resources to help you become a Google Sheets pro. Happy reading!
*Note: This article is a unique adaptation of the original content.
