WorksheetFunction.PercentRank Method
Returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK to evaluate the standing of an aptitude test score among all scores for the test.
Syntax
expression.PercentRank(Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | Array - the array or range of data with numeric values that defines relative standing. |
| Arg2 | Required | Double | X - the value for which you want to know the rank. |
| Arg3 | Optional | Variant | Significance - an optional value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK uses three digits (0.xxx). |
Return Value
Double
Remarks
- If array is empty, PERCENTRANK returns the #NUM! error value.
- If significance < 1, PERCENTRANK returns the #NUM! error value.
- If x does not match one of the values in array, PERCENTRANK interpolates to return the correct percentage rank.