Statistical - MEDIAN Function

Description

The MEDIAN function returns the median of the given numbers. The median is the number in the middle of a set of numbers.

Syntax

MEDIAN (number1, [number2] ...)

Arguments

Argument Description Required/ Optional
Number1 1 to 255 numbers for which you want the median. required
number2, ... Optional

Notes

  • The MEDIAN function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.

  • If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle.

  • Arguments can either be numbers or names, arrays, or references that contain numbers.

  • Logical values and text representations of numbers that you type directly into the list of arguments are counted.

  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value zero are included.

  • Arguments that are error values or text that cannot be translated into numbers cause errors.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

Median Function
advanced_excel_statistical_functions.htm
Advertisements