MEDIAN (First, Other...) MEDIAN (First; Other...)
First
The first number or temporal value, or array of these.
Other
Additional numbers or temporal values, or arrays of these.
Returns
The median of the given values.
Returns the median of the given values, which is the value in the middle when they are ordered.
Temporal values are also accepted, in which case they are ordered chronologically and the temporal value in the middle is returned.
Examples
MEDIAN (1, 2, 3, 4, 5, 10)
MEDIAN (1; 2; 3; 4; 5; 10)
Returns 3.5.
PERCENTILE.INC ({ 1, 2, 3, 4, 5, 10 }, 50 % )
PERCENTILE.INC ({ 1; 2; 3; 4; 5; 10 }; 50 % )
Returns 3.5. This example uses the PERCENTILE.INC function instead, which returns the value at the k th percentile, in this case 50%, which is equivalent to the median.
Returns 3.5. Blank values are ignored.
MEDIAN (1, 2, 3, 5, 5, 10)
MEDIAN (1; 2; 3; 5; 5; 10)
Returns 4.
MEDIAN ({ 1, 2, 3, 5, 5, 10 })
MEDIAN ({ 1; 2; 3; 5; 5; 10 })
Returns 4. Arrays are supported.
MEDIAN (1, 2, 3, { 5, 5, 10 })
MEDIAN (1; 2; 3; { 5; 5; 10 })
Returns 4. Arrays mixed with regular numbers are supported.