Excel Function : PERCENTILE

Download now!

Excel Function : PERCENTILE




Returns the k-th percentile of values in a range

Microsoft Excel Reference Page


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.