The PERCENTILE.EXC function returns the value corresponding to the k-th percentile of the values in a range, with k belonging to the open interval (0, 1).
PERCENTILE.EXC(
column,
k
)
- column: Column containing the values to consider in the calculation.
- k: Percentile in the open interval (0, 1).
The PERCENTILE.EXC function returns a real number.
If the column is empty, the function returns Blank.
If k is not in the open interval (0, 1), the function returns an error.
If k is not a multiple of 1 / (n + 1) (where n is the number of elements), PERCENTILE.EXC performs an interpolation to calculate the value corresponding to the k-th percentile.
If we start from the following data table:
...we can calculate what value is in the 0.2 percentile with the following measure:
p = PERCENTILE.EXC('Números'[N], 0.2)
In this case, the value 0.2 is not an integer multiple of 1 / (n + 1), so the function performs an interpolation to obtain the requested percentile.