QUARTILE Excel Function

The QUARTILE Excel function returns the quartile of a given data set. The financial analyst uses the function to determine a specific percentage of income in a population. The function is very useful in revenue analysis.

The syntax of the QUARTILE function is =QUARTILE(array,quart)

We can use the QUARTILE Excel function as follows:
1. Select an empty cell for the output.
2. Type =QUARTILE( in the selected cell. [Alternatively, type =Q and double-click the QUARTILE function from the list of suggestions shown by Excel.
3. Enter the arguments as cell values or cell references.
4. Close the brackets and press the “Enter” key.

For example, we will evaluate the equal portions of the given values in the below table using the QUARTILE Excel function.



Enter the formulas, =QUARTILE($A$2:$A$6,0) in cell B2,  =QUARTILE($A$2:$A$6,1) in cell B3, =QUARTILE($A$2:$A$6,2) in cell B4, =QUARTILE($A$2:$A$6,3) in cell B4, and =QUARTILE($A$2:$A$6,4) in cell B5. Press the “Enter” key every time a formula is entered.  



The output is shown above. Column C is for our reference.

The QUARTILE Function in Excel is found in the formulas tab, as follows:

First, choose an empty cell → select the “Formulas” tab → go to the “Function Library” group → click the “More Functions” option drop-down → click the “Compatibility” option right arrow à select the “QUARTILE” function, as shown below.