Calculate the kth percentile.

`=PERCENTILE.EXC(array,k)`

- array - required; data values
- k - required; value between 0 and 1 that represents the kth percentile

`=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.

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.

The PERCENTILE.EXC function returns the kth percentile of values in a range, where the k argument determines the percentile.

The PERCENTILE.EXC function will return the #NUM! error if the array argument is not empty.

The PERCENTILE.EXC function will interpolate when the value for the specified percentile is between two values in the array.

Drop CSV