|
QUARTILE(R, Q) |
|
Description
This function returns the quartile Q of the data in the 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
Given A1:A8 = 1, 2, 4, 7, 8, 9, 10, 12,
QUARTILE(A1:A8, 2) = 7.5
QUARTILE(A1:A8, 1) = 3.5
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support