The QUARTILE function in Microsoft Excel 2010


In the following tutorial, we will guide you on how to find the quartiles in a given data set using the QUARTILE function present in Excel 2010 Application.


Description

The QUARTILE function returns the quartiles in a given data set. There are mainly three types of quartiles that you can find for a given data set, the lower quartile (first quartile), the upper quartile (third quartile) and the interquartile.


Syntax

The QUARTLE function has the following syntax with the specified arguments enclosed in parentheses.

=QUARTILE(array, quart)

Where

‘array’ is a required argument and it is range of cells that contain the data set from which you want to find the quartiles.

‘quart’ is also a required argument and it is a number that specifies which quartile to return.
See the figure below for details regarding what numbers return what quartiles in the QUARTILE function.

Figure 1

Constraints

The QUARTILE function returns a #NUM! error value if the array is empty.

If quart<0 or quart>4, the function returns a #NUM! error value.

If the quart argument is not an integer, it will be truncated.


Example

Consider the data set that is specified in the below worksheet. For this data set, we intend to calculate the lower quartile (first quartile), the upper quartile (third quartile) and the median (interquartile).

Figure2

So, this is how you can find out the various quartiles in a given data set using the QUARTILE function in Excel 2010 Application.



Read Other Applications