WorksheetFunction.Quartile_Inc (Excel)

Returns the quartile of a data set based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use Quartile_Inc to find the top 25 percent of incomes in a population.

The following table describes the values that can be used for Arg2.

Quartile_Inc (Arg1, Arg2)

Dim dblArg2 As Double: dblArg2 = 
Dim dblQuartile_Inc As Double
dblQuartile_Inc = WorksheetFunction.Quartile_Inc(Arg1:=, Arg2:=dblArg2)

Arguments

Arg1 - Array - the array or cell range of numeric values for which you want the quartile value

Arg2 (Double) - Quart - The value to return.