MEDIAN
Returns the median of the given numbers.
StatisticalStatistics & Analysis
What it does
Calculates the median (middle value) of a set of numbers.
Syntax
MEDIAN(number1, [number2], ...)
Arguments
number1(number) — First number or range.
Examples
Calculate Median
Find median of 1, 3, 5, 9.
FORMULA
=MEDIAN(1, 3, 5, 9)
RESULT
4
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 1 |
| 3 | 3 |
| 4 | 5 |
| 5 | 9 |