PERCENTILE.EXC

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).

Syntax

PERCENTILE.EXC(
    column,
    k
)

Parameters
  • column: Column containing the values to consider in the calculation.
  • k: Percentile in the open interval (0, 1).
Returned value

The PERCENTILE.EXC function returns a real number.

Additional Information

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.

Examples

If we start from the following data table:

PERCENTILE.EXT function. Example of use

...we can calculate what value is in the 0.2 percentile with the following measure:

p = PERCENTILE.EXC('Números'[N], 0.2)

PERCENTILE.EXC function. Example of use

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.

Category
Statistical
Submitted by admin on Mon, 01/14/2019 - 13:29