How to use QUARTILE.EXC Function in Excel

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 Function in Excel - How to use QUARTILE.EXC Function in Excel

QUARTILE.EXC can return the first quartile, second quartile, and third quartile, as shown below:

Syntax:  =QUARTILE.EXC(A2:A9,B2)

Result: 23750000

QUARTILE.EXC Function in Excel - How to use QUARTILE.EXC Function in Excel

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.

 

READ:  How to use CHISQ.INV.RT Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *