Excel: percentile

MS Excel has two functions that enable you to find the value in a range of numbers at a specific percentile.

PERCENTILE.EXC is used if you want to obtain the percentile excluding the first and last values of the range (or array).

Conversely, PERCENTILE.INC includes the first and last values of the range.

So, you are interested in obtaining the value at the 25th percentile. The syntax for this is:

=PERCENTILE.INC(start_of_range:end_of_range,.25)

The 50th percentile is:

=PERCENTILE.INC(start_of_range:end_of_range,.50)

And the 75th percentile is:

=PERCENTILE.INC(start_of_range:end_of_range,.75)

Be the first to comment on "Excel: percentile"

Leave a comment

Your email address will not be published.


*