All functions / Statistics

PERCENTILE.EXC

The value below which a percentage of the data falls, excluding 0% and 100%.

Syntax

=PERCENTILE.EXC(array, k)

Arguments

• array: The numbers.
• k: A percentage strictly between 0 and 1.

Example

=PERCENTILE.EXC({1,2,3,4,5}, 0.25) → 1.5