Microsoft Office Tutorials and References

In Depth Information

**Using QUARTILE.INC to Break a Data Set into Quarters**

IfyouwanttoreadallthedetailsabouttheHyndmanandFan

Method #X, check out
www.daheiser.info/excel/notes/

NOTE%20N.pdf
for a comparison of the methods.

Using

Using
QUARTILE.INC

to Break a Data Set into Quarters

Use QUARTILE.INC to divide populations into groups.

QUARTILE.INC
to Break a Data Set into Quarters

Note

MIN, MEDIAN, and MAX return the same value as QUARTILE.INC when

quartis equal to 0, 2, and 4, respectively.

Syntax

=QUARTILE.INC(array,quart)

=QUARTILE.EXC(array,quart)

The old QUARTILE function is included in Excel for compatibility only.

QUARTILE.INC is the renamed version of QUARTILE. The QUARTILE.INC func-

tion returns the quartile of a data set. Quartiles are often used in sales

and survey data to divide populations into groups. For example, you can use

QUARTILE.INC to find the top 25% of incomes in a population. These functions

take the following arguments:

•
array

array
—
This is the array or cell range of numeric values for which

you want the quartile value. If array is empty, QUARTILE returns a

#NUM! error.

•
quart

quart
—
This indicates which value to return. You use 0 for the min-

imum value, 1 for the first quartile (25th percentile), 2 for the median

value (50th percentile), 3 for the third quartile (75th percentile), and

4 for the maximum value. If quartis not an integer, it is truncated. If

quartis less than 0 or greater than 4, QUARTILE returns a #NUM! er-

ror.

In
Figure 14.8
,
the formulas in B20:C23 break out the limits for each quartile.

The formula in cell B20 is =QUARTILE.INC($B$2:$B$17,0) to find the minimum

value. The formula in cells C20 and B21 is =QUARTILE.INC($B$2:$B$17,1) to

define the end of the first quartile and the start of the second quartile.