QUARTILE.EXC function

QUARTILE.EXC(Array, Quart) QUARTILE.EXC(Array; Quart)

Array

{ Number }

The array from which to derive the result.

Quart

Number or { Number }

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

Number or { Number }

The number of the given array at the given quartile value.

Returns the number of the given array at the given quartile value.

Quartile values and their meanings
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:

QUARTILE.EXC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 3)QUARTILE.EXC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 3)
PERCENTILE.EXC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 75%)PERCENTILE.EXC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 75%)

Example

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