The PERCENTILE.INC function returns the value corresponding to the k-th percentile of the values in a range, k belonging to the closed interval [0, 1].
Syntax
PERCENTILE.INC(
column,
k
)
Parameters
- column: Column containing the values to consider in the calculation.
- k: Percentile in the closed interval [0, 1].
Returned value
The PERCENTILE.INC function returns a real number.
Additional Information
If the column is empty, the function returns Blank.
If k is not in the closed 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.INC performs an interpolation to calculate the value corresponding to the k-th percentile.
Examples
If we start from the following data table:
...we can calculate what value is in the percentile 0.571429 with the following measure:
p = PERCENTILE.INC('Números'[N], 0.571429)
Related functions
Category
Statistical
