In this article, you will learn about the PERCENTILE.EXC function, the formula syntax and usage of the function in Microsoft Excel.
PERCENTILE.EXC Function in Excel
The PERCENTILE.EXC function in Excel calculates the “kth percentile” for a set of data where k is 0 to 1 exclusively.
Syntax
=PERCENTILE.EXC(array,k)
Arguments:
- array – The array or range of data defining relative standing.
- k – A value between 0 and 1 represents the Kth percentile.
Usage Notes and Possible Errors
- When the array is empty, PERCENTILE.EXC function returns the #NUM! error value
- In case of “k” being nonnumeric, PERCENTILE.EXC function returns the #VALUE! error value.
- If k is ≤ 0 or if k ≥ 1, the PERCENTILE.EXC function returns the #NUM! error value.
- When the argument k is not a multiple of 1/(n + 1), PERCENTILE.EXC interpolates to determine the value at the k-th percentile.
- The PERCENTILE.EXC function will interpolate when the value for the specified percentile lies between two values in the array. If it cannot interpolate for the percentile, k specified, Excel will return #NUM! error.
How to use the PERCENTILE.EXC Function in Excel?
Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.
Take a look at the given example
Enter the data in the respective columns and enter the PERCENTILE.EXC formula.
Formula: =PERCENTILE.EXC(A2:A11,0.75)
Here, A2 refers to the cell name or the cell address that contains the array and the Kth value is determined as 0.75. You will get the result in the Result column.
