Google Sheets MEDIAN Function: Syntax, Examples & Tips

value1:
The first number or range of numbers for which you want to find the median.

value2:
Additional numbers or ranges of numbers for which you want to find the median. This parameter is optional and can be repeated for more values.

What is the MEDIAN Function?

The MEDIAN function in Google Sheets is a statistical tool used to find the middle value in a set of numbers. It is particularly useful when you want to determine the central tendency of a dataset, especially when the dataset contains outliers that could skew the average. The MEDIAN function helps provide a more accurate representation of the data's central value.

In simpler terms, the MEDIAN function allows you to find the value that separates the higher half from the lower half of your data set.

A Practical Example

Imagine you are analyzing the test scores of a group of students stored in a Google Sheets document:

Test Scores Table:

You want to find the median score of the students to understand their performance better.

MEDIAN Formula

To achieve this, you would use the MEDIAN function as follows:

=MEDIAN(B2:B6)

In this formula:

• B2:B6 is the range of cells containing the scores of the students.

Result of the Formula

When you apply the MEDIAN formula to the Test Scores Table, the output would be:

This result indicates that the middle score among the students is 88, which provides a better understanding of their overall performance compared to the average.

Why Use MEDIAN?

Using the MEDIAN function is beneficial because it is less affected by outliers and skewed data than the average. This makes it a more reliable measure of central tendency in many situations, especially in datasets with extreme values.

Key Takeaways:

• MEDIAN: A statistical function that finds the middle value in a dataset.
• Robust: Less sensitive to outliers, providing a more accurate representation of central tendency.
• Common Use Cases: Ideal for analyzing scores, financial data, and any scenario where understanding the middle value is important.

The MEDIAN function is an essential tool for anyone working with data in Google Sheets, helping to enhance data analysis and reporting capabilities.

Happy spreadsheeting!