QUARTILE.EXC function
Array
The array from which to derive the result.
Quart
The quartile value. 1 identifies the first quartile (the 25th percentile) and 3 identifies the third quartile (the 75th percentile). 2 identifies the median value (the 50th percentile).
Returns
The number of the given array at the given quartile value.
Returns the number of the given array at the given quartile value.
| Quartile value | Meaning |
|---|---|
| 1 | Returns the value at the first quartile (the 25th percentile) |
| 2 | Returns the median value (at the 50th percentile) |
| 3 | Returns the value at the third quartile (the 75th percentile) |
QUARTILE.EXC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 2)QUARTILE.EXC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 2) returns 5 (known as the median, which can also be returned by the MEDIAN function).
All quartile values are valid to use with QUARTILE.INC. QUARTILE.EXC, on the
other hand, excludes percentiles below 1 / (n + 1) and above
n / (n + 1) (where n is the number of elements of the
array). (Both functions map to the full range of the given array elements.)
That means that the quartile values 0 and 4 are not valid to use with
QUARTILE.EXC, nor are the quartile values 1 and 3 if the array only has two
elements.
Related functions
The quartile values map to certain percentiles, as described above. That means that these formulas are equivalent:
Example
Returns 5 (known as the median).