Buzz
This article introduces the PERCENTILE.INC function, one of the widely used statistical functions in Excel.
Description: This function returns the k-th percentile of values within the range from 0 to 1.
Syntax: PERCENTILE.INC(array,k)
Regarding:
- array: Array or data range needed to determine the percentile, a mandatory parameter.
- k: The percentile value within the range from 0 to 1, including both 0 and 1, is a mandatory parameter.
Note:
- If the array value is empty, the function returns the error value #NUM!
- If the k value is not a number, the function returns the error value #VALUE!.
- If k ≤ 0 or k ≥ 1, the function returns the error value #NUM!
- If k is not a multiple of 1/(n - 1), the function interpolates to determine the value of the kth percentile.
- The PERCENTILE.EXC function interpolates when the percentile value returned falls between two values in the array. In cases where interpolation is not possible, the function returns the error value #NUM!
Example:
Find the value of the 0.56 percentile in the dataset in the table below:
- In the cell where calculation is needed, enter the formula: =PERCENTILE.EXC(E6:K6,0.56)
Press Enter to find the 0.56 percentile value in the dataset:
Using the PERCENTILE.EXC function, the values 0 and 1 are still computed within its range.
+ For k = 1:
+ For k = 0:
Above is the guidance and some specific examples when utilizing the PERCENTILE.INC function in Excel.
Best wishes for your success!
