The Excel function: PERCENTILE
Syntax
PERCENTILE(array,k)
The PERCENTILE function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- Array Required. The array or range of data that defines relative standing.
- K Required. The percentile value in the range 0..1, inclusive.