Excel PERCENTILE Function

Using the Excel PERCENTILE Function


The Excel PERCENTILE returns the k-th percentile of values in a range. A percentile is a value below which a given percentage of values fall. This function is useful is you must establish a threshold of acceptance. For example, an admission team may only wish to interview students who score above the 95th percentile.

The PERCENTILE function is still available for backwards compatibility purposes. However, Microsoft recommends that users explore the PERCENTILE.EXC and PERCENTILE.INC functions for improved accuracy.


=PERCENTILE (array, k)

Syntax Breakdown

Required. An array or range of data.

Required. Percentile value in the range of 0 (zero) to 1, inclusive.

Usage Notes

PERCENTILE will calculate the k-th percentile for a set of data. When using the function, you will need to supply a range of data and a K value to represent the percent.

A percentile is a measurement from statistics. It indicates the value below which a given percentage of observations, the data set, in a group of observations fall. For example, the 40th percentile is the value below which 40% of the observations may be found.

Notes Regarding K
1) K must be a numeric value. Non-numeric values will result in the function returning the #VALUE! error.

2) The function returns the #NUM! error if K < 0 or K > 1.

3) The function interpolates to determine the value at the k-th percentile if K is not a multiple of 1/(n - 1).