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.

QUARTILE.INC takes 2 required arguments and no optional arguments:

Syntax: QUARTILE.INC(array, quart)

The arguments for the QUARTILE.INC function are:
Argument Required? Description
array Required The array or cell range of numeric values for which you want the quartile value.
quart Required Indicates which value to return.
comments powered by Disqus