MEDIAN

Definition/Description of Formula:

Returns the median value in a numeric dataset.

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:

• Any text encountered in the value arguments will be ignored.
• MEDIAN returns the center value if the dataset contains an odd number of values. If the combined value arguments contain an even number of values, MEDIAN will interpolate between the two center values.
• MEDIAN finds the center value of the dataset rather than the mean. To find the mean use AVERAGE or AVERAGEA.

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 dataset.

QUARTILE: Returns a value nearest to a specified quartile of a dataset.

PERCENTRANK: Returns the percentage rank (percentile) of a specified value in a dataset.

PERCENTILE: Returns the value at a given percentile of a dataset.

MINA: Returns the minimum numeric value in a dataset.

MIN: Returns the minimum value in a numeric dataset.

 MAXA: Returns the maximum value in a numeric dataset.

MAX: Returns the maximum value in a numeric dataset.

LARGE: Returns the nth largest element from a data set, where n is user-defined.

AVERAGEA: Returns the numerical average value in a dataset.

AVERAGE: Returns the numerical average value in a dataset, ignoring text.

To use the MEDIAN Formula, simply begin with your edited Excellentable:  

Then begin typing the MEDIAN formula in the area you would like to display the outcome: 

	A	B
1	NUMBER
2	3
3	5
4	-1
5	4
6	2
7
8	RESULT	3