Syntax. PERCENTILE.EXC(array,k)
Definition. This function returns the k-quantile of the values in a range where k is between 0 and 1.
Arguments
array (required). The range of data that defines the relative standing of the data
k (required). A value between 0 and 1 exclusive
If array has no data points, the function returns the #NUM!
error.
If k isn’t a numeric expression, the PERCENTILE.EXC() function returns the #VALUE!
error. For k ≤ 0 or k ≥ 1, the PERCENTILE.EXC() function returns the #NUM!
error. If k isn’t a multiple of 1/(n – 1), PERCENTILE.EXC() interpolates to determine the value at the k quantile.
PERCENTILE.EXC() interpolates when the value for the given quantile is between two values in the range. If the quantile cannot be interpolated and k is specified, Excel returns the #NUM!
error.
Example. You will find more information about the use of this function in the description of PERCENTILE().
Sample Files
Use the PERCENTILE.EXC worksheet in the Average.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.
3.147.85.181