PERCENTILE.INC function
Returns the k-th percentile of values in a data set (Includes 0 and 1)
Syntax
PERCENTILE.INC(array, k)Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| array | Yes | The array or range of data that defines relative standing.A1:A4 |
| k | Yes | The percentile value in the range 0 and 1 (Includes 0 and 1).0.3 |
Try PERCENTILE.INC
Inclusive first quartile
=PERCENTILE.INC({10;20;30;40},0.25)Inclusive position 1 + 3*0.25 is 1.75, three quarters of the way from 10 to 20.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
PERCENTILE.INC · top-level call
=PERCENTILE.INC({10;20;30;40},0.25)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.