The QUARTILE.EXC function returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.
Parts of a QUARTILE.EXC function
QUARTILE.EXC(data, quartile_number)
Part | Description |
data |
The array or range containing the dataset to consider. |
quartile_number |
This is which quartile value to return
|
Sample formulas
QUARTILE.EXC(A2:A100, 3)
QUARTILE.EXC(A2:A100, B2)
Notes
- If the
quartile_number
is not an integer, the number is truncated. - The
quartile_number
must be between 0 and 4, exclusive. - Different from
QUARTILE.INC
,QUARTILE.EXC
calculates quartile based on a quartile range exclusive of 0th and 4th quartile.
Examples
A | |
1 | data |
2 | 6 |
3 | 7 |
4 | 15 |
5 | 36 |
6 | 39 |
7 | 40 |
8 | 41 |
9 | 42 |
10 | 43 |
11 | 47 |
12 | 49 |
A | B | C | |
1 | Quartile | Result | Formula |
2 | 1 | 15 | =QUARTILE.EXC(A2:A12, 1) |
3 | 2 | 40 | =QUARTILE.EXC(A2:A12, 2) |
4 | 3 | 43 | =QUARTILE.EXC(A2:A12, 3) |
Related functions
- PERCENTILE: Returns the value at a given percentile of a dataset.
- PERCENTILE.EXC: The PERCENTILE.EXC function returns the value at a given percentile of a dataset, exclusive of 0 and 1.
- MEDIAN: Returns the median value in a numeric dataset.
- QUARTILE: Returns a value nearest to a specified quartile of a dataset.