Excel PERCENTILE function

Function              PERCENTILE

Description        Excel PERCENTILE function returns the most frequently occurring value of a number set.

Syntax  PERCENTILE(array, k)

array  The array which contains data values.

k  Number, representing kth percentile.

Example:

Here I calculated 0.6 or 60% percentile in the data set shown above.

It returned an intermediate value 58.2 because the exact 60% percentile value was not present in data set.

Usage Notes:

• Percentile calculates the kth percentile from a set of data. Percentile 40% means 40% values are lower than the value, likewise 90% percentile means all 90% values lower than the value.
• k can be provided as a decimal (.4) or a percentage (40%)
• k must be between 0 to 1 otherwise it provides #NUM! error.
• If array is empty it returns #NUM! error.
• If the k is non-numeric it supplies #VALUE! error
• When percentile falls between values it calculates and return intermediate value