ID EN
…
#Statistical

MEDIAN

Excel Functions

Get the median of a group of numbers

Syntax

EXCEL 
=MEDIAN(number1, [number2], ...)

Arguments

Parameter Description
number1 A number or cell reference that refers to numeric values.
number2 [optional] A number or cell reference that refers to numeric values.

Return Value

A number representing the median.

Details

The MEDIAN function returns the median (middle number) in a set of data. The calculation performed by MEDIAN varies according to the number of numeric values provided. When the number is odd, MEDIAN returns the middle number in the group. When the number is even, MEDIAN returns the average of the two numbers in the middle. The MEDIAN function takes multiple arguments in the form number1, number2, number3, etc. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. MEDIAN ignores empty cells, text values, and the logical values TRUE and FALSE. The MEDIAN function will accept up to 255 separate arguments. When the number of values provided is odd, MEDIAN returns the middle number: When the number of values provided is even, MEDIAN returns the average of the

Examples

Examples

When the number of values provided is odd, MEDIAN returns the middle number:

EXCEL 
=MEDIAN(1,2,3,4,5) // returns 3
=MEDIAN(1,4,5,7,11) // returns 5
Examples

When the number of values provided is even, MEDIAN returns the average of the two middle numbers:

EXCEL 
=MEDIAN(1,2,3,4,5,6) // returns 3.5
=MEDIAN(1,2,4,6,8,9) // returns 9
Examples

In the worksheet shown above, the formulas in H5 and H6 are:

EXCEL 
=MEDIAN(B5:B16) // returns 83.5
=MEDIAN(D5:D16) // returns 80

See Also

AVERAGE MODE