Related Functions:

The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0 to 1, exclusive.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.

Syntax

=PERCENTILE.EXC(array,k)

Arguments

Argument Description
array The range of data values for which you want to calculate the k’th percentile
k The value, between 0 and 1, exclusive, of the required percentile

Examples

  A B C D
1 Data      
2 1      
3 3      
4 4      
5 7      
6 8      
7 9      
8        
9 Formula Result Notes
10 =PERCENTILE.EXC(A2:A7,0.25) 2.5 Interpolates when the value for the specified percentile lies between two values in the array

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied value of k is non-numeric
#NUM! Occurs if either:

  the supplied value of k is is < 1/(n+1) or > n/(n+1) – where n is the number of values in the supplied array
  the supplied array is empty