PERCENTILE.EXC function
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 kth percentile, or a linearly interpolated value if the number at the kth percentile falls between two numbers.
Returns the number of the given array at the kth 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.