Part II: Working with Formulas and Functions
FIGURE 16.13
Identifying quartiles for product defects
The QUARTILE function provides the demarcation lines. The MATCH formula in cell D3 in
Figure 16.13 identifies which quartile the value in cell C3 falls into. That formula is then
copied down for all the values.
=MATCH(C3,$G$3:$G$6,-1)
The QUARTILE function takes a range of values and an integer representing which quartile
to return (the quart argument). Acceptable values for the quart argument are 0 for the min-
imum value, 1 for the 25th percentile, 2 for the 50th percentile, 3 for the 75th percentile,
and 4 for the maximum values. If the quart argument is not in the range 0–4, QUARTILE
returns an error. If the quart argument has a decimal, the value is truncated, and only the
integer portion is used.
