The PERCENTILEX.INC function returns the value corresponding to the k-th percentile of the values taken by an expression that is evaluated for all the rows of a table, k belonging to the closed interval [0, 1].
PERCENTILEX.INC(
table,
expression,
k
)
- table: Table containing the rows on which the expression will be evaluated. It can be the name of an existing table or an expression that returns a table.
- expression: Expression to evaluate for each row of the table.
- k: Percentile in the closed interval [0, 1].
The PERCENTILEX.INC function returns a real number.
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), PERCENTILEX.INC performs an interpolation to calculate the value corresponding to the k-th percentile.
If we start from the following data table, Números:
...we can calculate what value is in the 0.2 percentile with the following measure:
In this case, the value 0.2 is not an integer multiple of 1 / (n + 1), so the function performs an interpolation.