WorksheetFunction.Percentile_Exc (Excel)

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

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 returns a #NUM! error.

Percentile_Exc (Arg1, Arg2)

Dim dblArg2 As Double: dblArg2 = 
Dim dblPercentile_Exc As Double
dblPercentile_Exc = WorksheetFunction.Percentile_Exc(Arg1:=, Arg2:=dblArg2)

Arguments

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

Arg2 (Double) - K - The percentile value in the range 0..1, exclusive.