# PERCENTILE.INC

Formulas / PERCENTILE.INC
Calculate the kth percentile.
`PERCENTILE.INC(array, k)`
• array - required, data defining relative standing
• k - required, specifies the percentile value for the range 0..1, inclusive

## Examples

• `=PERCENTILE.INC(scores,E5)`

The PERCENTILE.INC function is used to calculate the percentile of a given set of values. In the example, the 40th percentile of the scores in C5:C14 is calculated.

• `=PERCENTILE.INC(scores,E20)`

The PERCENTILE.INC function can also be used to calculate the percentile of a given set of values from a different range of cells. For example, to calculate the 80th percentile of the scores in C20:C29, the preceding formula would be used.

• `=PERCENTILE.INC(A1:A5,0.5)`

The PERCENTILE.INC function can also be used to calculate the percentile of a given set of values that are in an array. For example, the formula above would calculate the 50th percentile of the values in the array.

• `=PERCENTILE.INC(scores,0.9)`

The PERCENTILE.INC function can also be used to calculate the percentile of a given set of values with a given percentile value. For example, to calculate the 90th percentile of the scores in C30:C39, the preceding formula would be used.

## Summary

The PERCENTILE.INC function calculates the kth percentile of a range of values, with the k argument being a value between 0 and 100. It can be used to examine candidates who have scored above a certain percentile.

• The PERCENTILE.INC function returns a value greater than or equal to the specified percentile, calculated using a range of 0 to 1.
• It calculates the "kth percentile" for a set of data, which is the value below which a given percentage of values fall in a data set.