# PERCENTILE.EXC

Formulas / PERCENTILE.EXC
Calculate the kth percentile.
`=PERCENTILE.EXC(array,k)`
• array - required; data values
• k - required; value between 0 and 1 that represents the kth percentile

## Examples

• `=PERCENTILE.EXC(range,.4)`

This formula will return the value at the 40th percentile of the range of data.

• `=PERCENTILE.EXC(range,.9)`

This will return the value at the 90th percentile of the range of data.

• `=PERCENTILE.EXC(range,80%)`

This will return the value at the 80th percentile of the range of data.

## Summary

The PERCENTILE.EXC function allows users to calculate the kth percentile of values in a given range. The function returns the #NUM! error if the array argument is empty.

• The PERCENTILE.EXC function is used to calculate the "kth percentile" of a set of data. The kth percentile is the value below which a certain percentage of values in the data set fall. For example, if k = .4, then 40% of values are less than or equal to the calculated result. Similarly, if k = .9, then 90% of values are less than or equal to the calculated result.