The Excel QUARTILE.INC function returns the quartile (each of four equal groups) for a given set of data. QUARTILE.INC can return minimum value, first quartile, second quartile, third quartile, and max value. Starting with Excel 2010, the QUARTILE.INC function replaces the QUARTILE function with the same behavior.
Use the QUARTILE.INC function to get the quartile for a given set of data. QUARTILE.INC takes two arguments, the array containing numeric data to analyze, and quart, indicating which quartile value to return. The QUARTILE function accepts 5 values for the quart argument, as shown in the table below.
First quartile – 25th percentile
Median value – 50th percentile
Third quartile – 75th percentile
QUARTILE.INC vs QUARTILE.EXC
Percentiles can be defined as "greater than or equal to" (inclusive) or "greater than" (exclusive). The QUARTILE.INC function is inclusive and has "greater than or equal to" behavior. QUARTILE.EXC is exclusive, and has "greater than" behavior. The screen below shows how QUARTILE.INC and QUARTILE.EXC return different results for the same data. Note QUARTILE.EXC cannot be used to get the minimum or maximum value like QUARTILE.INC.
Note: Starting with Excel 2010, the QUARTILE.INC function replaces the QUARTILE function with the same behavior.
The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time).
The Excel PERCENTILE function calculates the "kth percentile" for a set of data. A percentile is a value below which a given percentage of values in a data set fall. You can use PERCENTILE to determine the 90th percentile, the 80th percentile,...