Returns the median value in a numerical data set.
Sample usage
MEDIAN(A2:A100,B2:B100,4,26)
MEDIAN(1,2,3,4,5,C6:C20)
Syntax
MEDIAN(value1, [value2, …])
-
value1
– The first value or range to consider when calculating the median value. -
value2, …
– [ OPTIONAL ] – Additional values or ranges to consider when calculating the median value.
Notes
-
Although
MEDIAN
is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function. -
Any text encountered in the
value
arguments will be ignored. -
MEDIAN
returns the centre value if the data set contains an odd number of values. If the combinedvalue
arguments contain an even number of values,MEDIAN
will interpolate between the two centre values. -
MEDIAN
finds the centre value of the data set rather than the mean. To find the mean, useAVERAGE
orAVERAGEA
.
See also
SMALL
: Returns the nth smallest element from a data set, where n is user-defined.
RANK
: Returns the rank of a specified value in a data set.
QUARTILE
: Returns a value nearest to a specified quartile of a data set.
PERCENTRANK
: Returns the percentage rank (percentile) of a specified value in a data set.
PERCENTILE
: Returns the value at a given percentile of a data set.
MINA
: Returns the minimum numerical value in a data set.
MIN
: Returns the minimum value in a numerical data set.
MAXA
: Returns the maximum numerical value in a data set.
MAX
: Returns the maximum value in a numerical data set.
LARGE
: Returns the nth largest element from a data set, where n is user-defined.
AVERAGEA
: Returns the numerical average value in a data set.
AVERAGE
: The AVERAGE function returns the numerical average value in a dataset, ignoring text.