Edit

Share via


WorksheetFunction.PercentRank_Inc(Object, Double, Object) Method

Definition

Returns the rank of a value in a data set as a percentage (0..1, inclusive) 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_Inc to evaluate the standing of an aptitude test score among all scores for the test.

public double PercentRank_Inc (object Arg1, double Arg2, object Arg3);
Public Function PercentRank_Inc (Arg1 As Object, Arg2 As Double, Optional Arg3 As Object) As Double

Parameters

Arg1
Object

Array - The array or range of data with numeric values that defines relative standing.

Arg2
Double

X - The value for which you want to know the rank.

Arg3
Object

Significance - An optional value that identifies the number of significant digits for the returned percentage value. If omitted, PercentRank_Inc uses three digits (0.xxx).

Returns

Remarks

If array is empty, PercentRank_Inc returns the #NUM! error value.

If significance < 1, PercentRank_Inc returns the #NUM! error value.

If x does not match one of the values in array, PercentRank_Inc interpolates to return the correct percentage rank.

Applies to