How to use QUARTILE.INC Function in Excel

The Excel QUARTILE.INC function returns the quartile (each of four equal groups) for a given set of data. QUARTILE.INC can return minimum value, first quartile, second quartile, third quartile, and max value. Starting with Excel 2010, the QUARTILE.INC function replaces the QUARTILE function with the same behavior.

Syntax:= QUARTILE.INC (array, quart)

The QUARTILE.INC function syntax has the following arguments:

  1. Array (required argument) – This is the array or cell range of data values for which we want the quartile value.
  2. Quart (required argument) – It indicates which value shall be returned. It is an integer between 0 and 4, representing the required quartile.

Example: Let’s look at some Excel QUARTILE.INC function examples and explore how to use the QUARTILE.INC function as a worksheet function in Microsoft Excel:

Suppose we are given the following revenue figures:

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

QUARTILE.INC can return the minimum value, first quartile, second quartile, third quartile, and max value. The function accepts five values for the quart argument, as shown below:

Syntax:  =QUARTILE.INC(A2:A15,B2)

Result: 15000000

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

Based on the Excel spreadsheet above, the following QUARTILE.INC examples would return:

Syntax: =QUARTILE.INC(A2:A15,B2)
Result: 25500000

Syntax: =QUARTILE.INC(A2:A15,B2)
Result: 34000000

Syntax: =QUARTILE.INC(A2:A15,B2)
Result: 49250000

Syntax: =QUARTILE.INC(A2:A15,B2)
Result: 120000000

Note:

  1. #NUM! error – Occurs if either:
    • The given value of quart is < 0 or > 4; or
    • The given array is empty.
  2. #VALUE! error – Occurs if the given value of quart is non-numeric.
  3. From Excel 2010, the QUARTILE.EXC and QUARTILE.INC functions would replace the QUARTILE function, which is now classified as a compatibility function.
  4. The QUARTILE.INC and QUARTILE.EXC functions both find a requested quartile of a supplied data set. The difference between these two functions is that QUARTILE.INC bases its calculation on a percentile range of 0 to 1 inclusive, whereas QUARTILE.EXC bases its calculation on a percentile range of 0 to 1 exclusive.
  5. If the requested quartile falls between two of the values in the supplied array, MS Excel interpolates between these values to calculate the quartile value.
READ:  How to use CORREL Function in Excel

 

 

 

 

 

 

Add a Comment

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