The Excel QUARTILE.EXC function returns the quartile for a given set of data. QUARTILE.EXC can return, first quartile, second quartile, and third quartile.
Syntax:= QUARTILE.EXC (array, quart)
The QUARTILE.EXC function syntax has the following arguments:
- Array Required. The array or cell range of numeric values for which you want the quartile value.
-
Quart Required. Indicates which value to return.
Example: Let’s look at some Excel QUARTILE.EXC function examples and explore how to use the QUARTILE.EXC function as a worksheet function in Microsoft Excel:
Example 1:
Suppose we are given the revenue figures below:
QUARTILE.EXC can return the first quartile, second quartile, and third quartile, as shown below:
Syntax: =QUARTILE.EXC(A2:A9,B2)
Result: 23750000
Based on the Excel spreadsheet above, the following QUARTILE.EXC examples would return:
Syntax: =QUARTILE.EXC(A2:A15,B2)
Result: 34000000
Syntax: =QUARTILE.EXC(A2:A15,B2)
Result: 51250000
Note:
- If array is empty, QUARTILE.EXC returns the #NUM! error value.
- If quart is not an integer, it is truncated.
- If quart ≤ 0 or if quart ≥ 4, QUARTILE.EXC returns the #NUM! error value.
-
MIN, MEDIAN, and MAX return the same value as QUARTILE.EXC when quart is equal to 0 (zero), 2, and 4, respectively.