Excel 2000 in a Nutshell

Name

QUARTILE

Synopsis

Use QUARTILE to find the value at the specified quartile in a list of values. For example, you may want to determine what the median value (50%) is for the list by specifying a value of 2 for the Quart argument.

To Calculate

=QUARTILE(Array, Quart)

Both arguments are required for this function.

Array

Indicates the list of values for which you want to find the quartile value.

Quart

A value between 0 and 4 that indicates the value that should be returned. If the value is 0 the minimum value in the range is returned; 1 returns the first quartile; 2 returns the median value; 3 returns the third quartile; and 4 returns the maximum value in the list.

Example

Figure 15-39 illustrates how to use QUARTILE to find the value at the specified quartile in a list. In this example, “3” is specified for the Quart argument indicating you want the value that is larger than three-fourths of the values in the list. This example also shows how you can use RANK to find the numeric rank of a value in the list if the list was sorted in the specified order.

Figure 15-39. Use QUARTILE to find value at a specified quartile of the list: Use RANK to determine numeric rank of the value