Excel PERCENTILE.EXC function

Function              PERCENTILE.EXC

Description        Excel PERCENTILE.EXC function returns the most frequently occurring value of a number set. Here k is 0 to 1 exclusive.

Syntax  PERCENTILE.EXC(array, k)

array  The array which contains data values.

k  Number, representing kth percentile. Here k is 0 to 1 exclusive.

Example:

Usage Notes:

• EXC 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 returns #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