Array
The array from which to derive the result.
K
The percentile. Must be between 0 and 1 (exclusive), which can also be written as 0% and 100%.
Returns
The number of the given array at the k th percentile, or a linearly interpolated value if the number at the k th percentile falls between two numbers.
Returns the number of the given array at the k th percentile, where k is a number between 0 and 1 (exclusive), which can also be specified with the % operator (.5 equals 50%). PERCENTILE.EXC ({ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }, 50 % ) PERCENTILE.EXC ({ 0; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10 }; 50 % ) returns 5 (known as the median ).
PERCENTILE.EXC excludes percentiles below 1 / (n + 1) and above n / (n + 1) (where n is the number of elements of the array). To have the first element of the array returned if k is set to 0%, and the last element of the array returned if k is set to 100%, use PERCENTILE.INC instead. Both functions map to the full range of the given array elements.
Related function
Use PERCENTRANK.EXC to return the percentile rank of a number, which can be seen as the reverse operation to PERCENTILE.EXC. PERCENTILE.EXC ({ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }, 0.5) PERCENTILE.EXC ({ 0; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10 }; 0,5) returns 5, and PERCENTRANK.EXC ({ 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }, 5) PERCENTRANK.EXC ({ 0; 1; 2; 3; 4; 5; 6; 7; 8; 9; 10 }; 5) returns .5.
Examples
Returns 5.
Returns .5 (50%). PERCENTRANK.EXC can be seen as the reverse operation to PERCENTILE.EXC.