Similar to the PERCENTILE formula, MS Excel has two functions that enable you to find the value in a range of numbers at a specific quartile.
QUARTILE.EXC is used if you want to obtain the quartile excluding the first and last values of the range (or array).
Conversely, QUARTILE.INC includes the first and last values of the range.
If you are interested in obtaining the value at the 2nd quartile, the formula is:
=QUARTILE.INC(start_of_range:end_of_range,2)
Which is the same as the 50th percentile.
Be the first to comment on "Excel quartile"