How to Use the QUARTILE function to calculate the quartiles
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. Here is the syntax that is used:
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:
- In cells A2:A10 type the names of your employees.
- In cells B2:B10 type the number of phone calls the employees make per month.
- Select cells D2 and type the following formula: =QUARTILE($B$2:$B$10,0).
- Select cells D3 and type the following formula: =QUARTILE($B$2:$B$10,1).
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- How to Use the SYD function to calculate depreciation in Excel
- How to use the WORKDAY function to calculate workdays in Excel
- How to Use the YEARFRAC function to calculate employees ages
- How to Use the DATEDIF function to calculate the ages of employees
- Use the DAYS360 function to calculate with a 360-day year
