Syntax: QUARTILE(R, Q)
R = Range of cells
Q = Quartile as follows:
0 | Minimum value |
1 | First quartile (25th percentile) |
2 | Second quartile (50th percentile) |
3 | Third quartile (75th percentile) |
4 | Maximum value |
QUARTILE finds the quartile Q of the data in range R. This is equivalent to PERCENTILE(R, Q/4).
Examples:
A1..A8 = 1, 2, 4, 7, 8, 9, 10, 12
QUARTILE(A1..A8, 2) = 7.5
QUARTILE(A1..A8, 1) = 3.5
Excel function: QUARTILE