Excel: Quartile Function
In Excel, the Quartile function returns the quartile from a set of values.
The syntax for the Quartile function is:
Quartile( array, nth_quartile )
array is a range or array from which you want to return the nth quartile.
nth_quartile is the quartile value that you wish to return. It can be one of the following values:
Value Explanation 0 Smallest value in the data set 1 First quartile (25th percentile) 2 Second quartile (50th percentile) 3 Third quartile (75th percentile) 4 Largest value in the data set
Note:
If nth_quartile is not an integer, it will be truncated.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Quartile({7,8,9,10}, 0) would return 7 =Quartile({7,8,9,10}, 1) would return 7.75 =Quartile({7,8,9,10}, 2) would return 8.5 =Quartile({7,8,9,10}, 3) would return 9.25 =Quartile({7,8,9,10}, 4) would return 10 =Quartile(B2:B6, 0) would return 5.4