 Formula Engine Reference Guide |
|
Back to Class Index
QUARTILE(R, Q)
Finds the quartile Q of the data in range R. This is equivalent to PERCENTILE(R, Q/4).
Parameters
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
Examples
A1..A8 = 1, 2, 4, 7, 8, 9, 10, 12
QUARTILE(A1..A8, 2) = 7.5
QUARTILE(A1..A8, 1) = 3.5