Definition

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

Sample Usage

Syntax
PERCENTILE.EXC(array,k)
The PERCENTILE.EXC function syntax has the following arguments:
  • Array     Required. The array or range of data that defines relative standing.
  • K     Required. The percentile value in the range 0..1, exclusive.
Remarks
  • If array is empty, PERCENTILE.EXC returns the #NUM! error value
  • If k is nonnumeric, PERCENTILE.EXC returns the #VALUE! error value.
  • If k is ≤ 0 or if k ≥ 1, PERCENTILE.EXC returns the #NUM! error value.
  • If k is not a multiple of 1/(n - 1), PERCENTILE.EXC interpolates to determine the value at the k-th percentile.
  • PERCENTILE.EXC 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.
In order to use the PERCENTILE.EXC formula, start with your edited Excellentable

Then type in the PERCENTILE.EXC formula in the area you would like to display the outcome:
By adding the values you would like to calculate the PERCENTILE.EXC formula for, Excellentable will generate the outcome:



  
    
      



    

        
        Error.
    

    
User does not have sufficient privileges to access this Content 
Learn More