PERCENTILE.EXC function

PERCENTILE.EXC(array, k) PERCENTILE.EXC(array; k)

array — { Number }

The array from which to derive the result.

k — Number or { Number }

The percentile. Must be between 0 and 1 (exclusive), which can also be written as 0% and 100%.

Returns — Number or { Number }

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

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.

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 (50%). PERCENTRANK.EXC can be seen as the reverse operation to PERCENTILE.EXC.