Returns the k-th percentile of values in a range, where k is in the range 0 to 1, exclusive.
Syntax
PERCENTILE.EXC(array, k)Argument
arrayobligatoriskt
The array or range of data that defines relative standing.
kobligatoriskt
The percentile value in the range 0 < k < 1.
PERCENTILE.EXC calculates the percentile for a dataset using an exclusive method, meaning the percentile k must be strictly greater than 0 and less than 1. It is useful for statistical analysis where you need to exclude the extreme ends of the distribution range. This function is available in Excel 2010 and later versions.
=PERCENTILE.EXC({1,2,3,4,5}, 0.5)→3Calculates the median (50th percentile) of the provided set.
Select a cell
Click on the cell where you want to display the percentile result.
Enter the formula
Type =PERCENTILE.EXC( followed by your data range and the k value, then press Enter.
PERCENTILE.EXC excludes 0 and 1 from the k range, whereas PERCENTILE.INC includes them.