Skip to main content

PERCENTILE

Definition of PERCENTILE

Returns the value at a given percentile of a dataset.

Sample Usage

PERCENTILE(A2:A100,A2)

PERCENTILE(A2:A100,0.67)

Syntax

PERCENTILE(data, percentile)

  • data - The array or range containing the dataset to consider.

  • percentile - The percentile whose value within data will be calculated and returned.

Notes

  • The value returned by PERCENTILE is not necessarily a member of data as this function interpolates between values to calculate the alpha percentile.

  • The 50th percentile, that is setting percentile to 0.5 is equivalent to using MEDIAN with the same dataset.

See Also

SMALL: Returns the nth smallest element from a data set, where n is user-defined.

RANK: Returns the rank of a specified value in a dataset.

QUARTILE: Returns a value nearest to a specified quartile of a dataset.

PERCENTRANK: Returns the percentage rank (percentile) of a specified value in a dataset.

MINA: Returns the minimum numeric value in a dataset.

MIN: Returns the minimum value in a numeric dataset.

MEDIAN: Returns the median value in a numeric dataset.

MAXA: Returns the maximum numeric value in a dataset.

MAX: Returns the maximum value in a numeric dataset.

LARGE: Returns the nth largest element from a data set, where n is user-defined.

AVERAGEA: Returns the numerical average value in a dataset.

AVERAGE: Returns the numerical average value in a dataset, ignoring text.

In order to use the PERCENTILE formula, start with your edited Excellentable

Then type in the PERCENTILE Formula in area you would like to display the outcome:

Type in the complete PERCENTILE formula for a cell as shown below:

Excellentable will generate the outcome when hitting enter. 

Error.

User does not have sufficient privileges to access this Content
Learn More


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.