PERCENTRANK.EXC()

Syntax. PERCENTRANK.EXC(array,x,significance)

Definition. This function returns the rank of a value (alpha) in a data set as a percentage (0 to 1, exclusive).

Arguments

• array (required). The array or range of data with numeric values that defines the relative position of the data.

• x (required). The value for which you want to know the rank.

• significance (optional). A value that identifies the number of decimal places for the returned percentage value. If significance is not specified, PERCENTRANK.EXC() uses three decimal places (0.xxx).

Note

If array is empty, PERCENTRANK.EXC() returns the #NUM! error value.

If significance is less than 1, PERCENTRANK.EXC() returns the #NUM! error value.

If x does not match one of the values in the array, PERCENTRANK.EXC() interpolates to return the correct percentage rank.

Background. PERCENTRANK.EXC() and PERCENTRANK.INC() are the inverse functions of PERCENTILE.EXC() and PERCENTILE.INC(). This function calculates the relative position a of value x in a value set.

You will find more information about quantiles in the description of PERCENTILE().

Example. You find more information about the use of this function in the description of PERCENTRANK().

See Also

LARGE(), MAX(), MEDIAN(), MIN(), PERCENT.EXC(), PERCENT.INC(), QUARTILE.EXC(), QUARTILE.INC(), SMALL()

Sample Files

Use the PERCENTRANK.EXC worksheet in the Average.xlsx sample file. The sample files are found in the Chapter12 folder. For more information about the sample files, see the section titled Using the Sample Files.