MEDIAN

Formulas / MEDIAN
Calculates the middle value of a set of numbers
MEDIAN(number1, [number2], ...)
  • number1 - required, a number or cell reference
  • [number2], ... - [OPTIONAL] numbers or cell references, up to a total of 255 arguments

Examples

  • =MEDIAN(A2:A6)

    The MEDIAN function returns the median of any given range of numbers. For example, this returns the median of the five numbers in the range A2:A6. The median number is the one in the very middle of the range.

  • =MEDIAN(A2:A7)

    If the range contains an even number of elements, the MEDIAN function will return the number halfway between the two middle elements. For example, this returns the median of the six numbers in the range A2:A7, which is the midway point between the third and fourth numbers.

Summary

The MEDIAN function is used to calculate the median value of a given set of numbers. The median is the middle number in a group of numbers.

  • The MEDIAN function gets the middle number in a group of numbers, picking the middle number in a set of odd numbers and the average of the middle two numbers in a set of even numbers.
  • MEDIAN accepts references to cells, ranges, or constants as arguments and accepts any arguments in any combination.
  • MEDIAN ignores empty cells, text values, and logical values (TRUE and FALSE).
  • If there are no numbers, MEDIAN throws a #NUM! error.

Frequently Asked Questions

What is MEDIAN Function?
The MEDIAN function calculates the median of a set of numbers. The numbers are provided as arguments.
Which arguments are accepted by the MEDIAN Function?
The MEDIAN function accepts many types of arguments. The full list of argument types that the MEDIAN function accepts is numbers, names, arrays, and references.
How does MEDIAN Function handle even numbers of values?
The MEDIAN function averages the two middle numbers in the set if the set contains an even number of values.
What about logical values and text representations in the arguments?
MEDIAN accepts numbers that appear as logical values or text representations in its arguments. It ignores logical values, text, and empty cells that appear in references in its arguments, however.
Does MEDIAN Function include zero cells?
Yes, MEDIAN includes zero cells in its calculation.
What is the purpose of the MEDIAN Function?
The MEDIAN function is for measuring central tendency, which is the center of a statistical distribution of a set of numbers.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.