QUARTILE.INC function

QUARTILE.INC(array, quart) QUARTILE.INC(array; quart)

array — { Number }

The array from which to derive the result.

quart — Number or { Number }

The quartile value. 0 means that the first value of the array should be returned and 4 means that the last value should be returned. 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
0 Returns the first value
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)
4 Returns the last value

QUARTILE.INC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 2)QUARTILE.INC({ 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) and QUARTILE.INC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 3)QUARTILE.INC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 3) returns 7 (the third quartile, also known as the 75th percentile).

Related functions

The quartile values map to certain percentiles, as described above. That means that these formulas are equivalent:

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

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

Examples

QUARTILE.INC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 2)QUARTILE.INC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 2)

Returns 5 (known as the median).

QUARTILE.INC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 0)QUARTILE.INC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 0)

Returns 1 (the first array element).

QUARTILE.INC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 4)QUARTILE.INC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 4)

Returns 9 (the last array element).

QUARTILE.INC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 1)QUARTILE.INC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 1)

Returns 3 (the first quartile, also known as the 25th percentile).

QUARTILE.INC({ 1, 2, 3, 4, 5, 6, 7, 8, 9 }, 3)QUARTILE.INC({ 1; 2; 3; 4; 5; 6; 7; 8; 9 }; 3)

Returns 7 (the third quartile, also known as the 75th percentile).