Use the QUARTILE function to calculate the quartiles - Basic Statistical Functions - Microsoft Excel Tutorials

Use the QUARTILE function to calculate the quartiles using Microsoft Excel

In this example, the quartile of a list has to be determined. The QUARTILE function returns the quartile of a data set. Quartiles are used to divide populations into four classes with each containing one-fourth of the total population.

QUARTILE(array, quart)

array: An array or cell range of numeric values for which you want to find the quartile value.

quart: A number from 0 to 4 that specifies the value to return. (0 = Minimum value, 1 = First quartile (25th percentile), 2 = Median value (50th percentile), 3 = Third quartile (75th percentile), 4 = Maximum value)

To determine the quartiles into which employee telephone use falls:

1. In cells A2:A10 type the names of your employees.
2. In cells B2:B10 type the number of phone calls the employees make per month.
3. Select cells D2 and type the following formula: =QUARTILE($B$2:$B$10,0).
4. Select cells D3 and type the following formula: =QUARTILE($B$2:$B$10,1).

Use the QUARTILE function to calculate the quartiles