How to use PERCENTRANK.INC Function in Excel

The Excel PERCENTRANK.INC function returns the relative rank of a value in a data set as a percentage representing the number of values less than or equal to the value. Percentile rank is commonly used as a way to interpret standing in standardized tests.

Syntax:= PERCENTRANK.INC (array, x, [significance])

The PERCENTRANK.INC function syntax has the following arguments:

  • Array     Required. The array or range of data with numeric values that defines relative standing.
  • X     Required. The value for which you want to know the rank.
  • Significance     Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.INC uses three digits (0.xxx).

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

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

Syntax:  =PERCENTRANK.INC($B$2:$B$17,B2)

Result: 0.866

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

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

Syntax: =PERCENTRANK.INC($B$2:$B$17,B3)
Result: 0.666

Syntax: =PERCENTRANK.INC($B$2:$B$17,B4)
Result: 0

Syntax: =PERCENTRANK.INC($B$2:$B$17,B5)
Result: 0.266

Syntax: =PERCENTRANK.INC($B$2:$B$17,B6)
Result: 0.533

Syntax: =PERCENTRANK.INC($B$2:$B$17,B7)
Result: 1

Syntax: =PERCENTRANK.INC($B$2:$B$17,B8)
Result: 0.2

Syntax: =PERCENTRANK.INC($B$2:$B$17,9.3)
Result: 0.906

Syntax: =PERCENTRANK.INC($B$2:$B$17,7.7)
Result: 0.366

Syntax: =PERCENTRANK.INC($B$2:$B$17,8.8)
Result: 0.84

Syntax: =PERCENTRANK.INC($B$2:$B$17,B12,2)
Result: 0

Syntax: =PERCENTRANK.INC($B$2:$B$17,B13,2)
Result: 0.33

Syntax: =PERCENTRANK.INC($B$2:$B$17,B14,2)
Result: 0.66

Syntax: =PERCENTRANK.INC($B$2:$B$17,B15,1)
Result: 0.9

Syntax: =PERCENTRANK.INC($B$2:$B$17,B16,1)
Result: 0.6

Syntax: =PERCENTRANK.INC($B$2:$B$17,B17,1)
Result: 0.4

Note:

  • If x does not match one of the values in array, PERCENTRANK.INC interpolates to return the correct percentage rank.
  • If array is empty, PERCENTRANK.INC returns the #NUM! error value.
  • If significance < 1, PERCENTRANK.INC returns the #NUM! error value.
  • If the supplied x is smaller than the minimum, or greater than the maximum value in the supplied array, PERCENTRANK.INC returns the #N/A error value.
READ:  How to use AVERAGEA Function in Excel

 

Add a Comment

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