MEDIAN function
From Apache OpenOffice Wiki
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
MEDIAN
Returns the median of a set of numbers.
Syntax:
MEDIAN(number1; number2; ... number30)
- number1 to number30 are up to 30 numbers or ranges containing numbers.
- MEDIAN returns the median (middle value) of the numbers. If the count of numbers is odd, this is the exact middle value. If the count of numbers is even, the average of the two middle values is returned.
Example:
MEDIAN(1; 5; 9; 20; 21)
- returns 9, the number exactly in the middle.
MEDIAN(1; 5; 9; 20)
- returns 7, which is the average of 5 and 9, the two numbers in the middle.
See Also