Excel PERCENTILE.INC function

Function              PERCENTILE.INC

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

Syntax  PERCENTILE.INC(array, k)

array  The array which contains data values.

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

Example:

Usage Notes:

  • INC 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