Edit

Share via


WorksheetFunction.Percentile_Inc(Object, Double) Method

Definition

Returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can examine candidates who score above the 90th percentile.

public:
 double Percentile_Inc(System::Object ^ Arg1, double Arg2);
public double Percentile_Inc (object Arg1, double Arg2);
Public Function Percentile_Inc (Arg1 As Object, Arg2 As Double) As Double

Parameters

Arg1
Object

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

Arg2
Double

K - The percentile value in the range 0..1, inclusive.

Returns

Remarks

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.

Applies to