Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Show menu Show menu

PERCENTILE function

Description

PERCENTILE(p,range) computes pth percentile of the contents of the cells in the specified range. If one of the cells in range does not have a numeric value, but is empty or has a string value, then this cell will not be taken into account for calculating the percentile, or any of the other statistical functions.

The argument range can be a list of numbers, cell addresses, cell ranges (such as A1:A10).

Range can also be a matrix. In that case the function returns a matrix with one row and the same number of columns, with each element the PERCENTILE of the corresponding column. If range is a row matrix, it is converted to a column matrix first.

Example

PERCENTILE(75,A1:A100) returns the 75th percentile of the data in cells A1 to A100.

Related functions