How to use PERCENTILE.INC Function in Excel

The Excel PERCENTILE.INC function calculates the “kth percentile” for a set of data where k is 0 to 1, inclusive. A percentile is a value below which a given percentage of values in a data set fall. You can use PERCENTILE.INC to determine the 90th percentile, the 80th percentile, etc.

Syntax:= PERCENTILE.INC(array,k)

The PERCENTILE.INC function syntax has the following arguments:

  • Array     Required. The array or range of data that defines relative standing.
  • K     Required. The percentile value in the range 0..1, inclusive.

Example: Let’s look at some Excel PERCENTILE.INC function examples and explore how to use the PERCENTILE.INC function as a worksheet function in Microsoft Excel:

PERCENTILE.INC Function - How to use PERCENTILE.INC Function in Excel

Syntax:  =PERCENTILE.INC(B2:B17,C2)

Result: 9.25

PERCENTILE.INC Function in Excel - How to use PERCENTILE.INC Function in Excel

Based on the Excel spreadsheet above, the following PERCENTILE.INC examples would return:

Syntax: =PERCENTILE.INC(B2:B17,C2)
Result: 8.5

Syntax: =PERCENTILE.INC(B2:B17,C4)
Result: 8.5

Syntax: =PERCENTILE.INC(B2:B17,C5)
Result: 8.4

Syntax: =PERCENTILE.INC(B2:B17,C6)
Result: 8.1

Syntax: =PERCENTILE.INC(B2:B17,C7)
Result: 7.15

Syntax: =PERCENTILE.INC(B2:B17,C8)
Result: #NUM!

Note:

  • If array is empty, PERCENTILE.INC returns the #NUM! error value.
  • If k is nonnumeric, PERCENTILE.INC returns the #VALUE! error value.
  • If k is < 0 or if k > 1, PERCENTILE.INC returns the #NUM! error value.
  • If k is not a multiple of 1/(n – 1), PERCENTILE.INC interpolates to determine the value at the k-th percentile.

 

READ:  How to use MODE.MULT Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *