Edit

Share via


WorksheetFunction.Percentile_Exc(Object, Double) Method

Definition

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

public:
 double Percentile_Exc(System::Object ^ Arg1, double Arg2);
public double Percentile_Exc (object Arg1, double Arg2);
Public Function Percentile_Exc (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, exclusive.

Returns

Remarks

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

If k is nonnumeric, Percentile_Exc returns the #VALUE! error value.

If k is ≤ 0 or if k ≥ 1, Percentile_Exc returns the #NUM! error value.

If k is not a multiple of 1/(n - 1), Percentile_Exc interpolates to determine the value at the k-th percentile.

Percentile_Exc will interpolate when the value for the specified percentile lies between two values in the array. If it cannot interpolate for the percentile, k specified, Excel will return #NUM! error.

Applies to