Description Computes the value corresponding to the specified percentile of a specified range of numbers.
Syntax PERCENTILE (array, percentile)
| Argument | Description |
|---|---|
| array | A list of numbers, in the form of a range reference or array constant. Text and logical values are ignored. |
| percentile | The percentile for which you want to find the numeric value. It must be a number between 0 and 1.Text in the argument list that converts to a number will be evaluated as a number; otherwise the function will return the #VALUE! error. Text referenced in cells will return the #VALUE! error. Logical values are evaluated as 1 if TRUE and 0 if FALSE. |
Remarks To determine the value, the function sorts array in ascending order. Then the function assigns a percentile to each number in array: the lowest number is the 0th percentile, the highest number is the 100th percentile, and the middle number is 50th percentile.
If percentile falls on a value in array, the function returns that value.
If percentile does not fall on a value in array, the function calculates the value that would fall at percentile, given the range values above and below that percentile.
This function is the inverse of the PERCENTRANK function.
Examples This function returns 2:
This function returns 2.32:
See Also PERCENTRANK, QUARTILE, RANK
