QUARTILE.INC function
Array
The array from which to derive the result.
Quart
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
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 |
|---|---|
| 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:
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
Returns 5 (known as the median).
Returns 1 (the first array element).
Returns 9 (the last array element).
Returns 3 (the first quartile, also known as the 25th percentile).
Returns 7 (the third quartile, also known as the 75th percentile).