Article ID: 103493 - View products that this article applies to.
This article was previously published under Q103493
In Microsoft Excel, the QUARTILE() function returns a specified quartile in an array of numeric values. QUARTILE() accepts 2 arguments: Array and Quart. Array is the range of values for which you want to find the quartile value. Quart indicates the value you want to return, where:
NOTE: In Microsoft Excel versions 5.0 and later, you can use the Function Wizard to insert the QUARTILE() function, by clicking Function on the Insert menu. The Function Wizard gives you information about the function, as well as required and optional arguments.
0 Minimum value (Same as MIN()) 1 1st quartile - 25th percentile 2 2nd quartile - 50th percentile (Same as MEDIAN()) 3 3rd quartile - 75th percentile 4 4th quartile - 100th percentile (Same as MAX())
Following is the algorithm used to calculate QUARTILE():
ExampleTo find the 3rd quartile in the array of values, 0,2,3,5,6,8,9, follow these steps:
Article ID: 103493 - Last Review: August 15, 2003 - Revision: 1.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.