Excel Function : PERCENTILE
Category
Compatibility
Description
Returns the k-th percentile of values in a range
Microsoft Excel Reference Page
https://support.office.com/en-us/article/PERCENTILE-function-91b43a53-543c-4708-93de-d626debdddca
Syntax and Description of the PERCENTILE Excel Function
The syntax for the PERCENTILE function in Microsoft Excel is: PERCENTILE(array, k) array is the array or range of data that is to be evaluated. k is the percentile value that is to be found.
About PERCENTILE Excel Function
The PERCENTILE function returns the k-th percentile of values in a data set. In other words, PERCENTILE returns the value at which k% of the data fall below it.