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.

Frequently Asked Questions

What is the PERCENTILE.EXC function?
The PERCENTILE.EXC function returns the kth percentile of values in a range, where the k argument determines the percentile.
What happens if the array argument has items?
The PERCENTILE.EXC function will return the #NUM! error if the array argument is not empty.
What happens if the value for the specified percentile is between two values in the array?
The PERCENTILE.EXC function will interpolate when the value for the specified percentile is between two values in the array.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.