Excel - Quartile Function

---

---

Quartile Function

The Excel Quartile function is commonly used in statistical and analytical analysis. This function retrieves the quartile of the sample data. It permits users to understand the data distribution perfectly and break down the available dataset into quarters. Quartiles are crucial while developing boxplot charts. The Microsoft Excel quartile function can be utilized to examine the sales-related data as well as the quarterly corporate revenue, student fees, and worker salaries.

Compatibility

This advanced excel function is compatible with the following versions of MS-Excel −

• Excel for Microsoft 365
• Excel for Microsoft 365 for Mac
• Excel for the web
• Excel 2021
• Excel 2021 for Mac
• Excel 2019
• Excel 2019 for Mac
• Excel 2016

The QUARTILE function interchanges the QUARTILE.INC function from Excel 2010.

Syntax

The syntax of Quartile function is as follows −

QUARTILE.INC(array, quart)

Arguments

You can use the following arguments with the Quartile function −

Points to Remember

• The QUARTILE() function will calculate the value of a given quartile of a dataset.
• The QUARTILE() function, retrieves the #NUM! error if the array is empty.
• If the second argument quart value is other than numeric in a QUARTILE() function, then the function receives the #VALUE! error.
• If the quart value is smaller than 0, or larger than 4, then the QUARTILE() function will return the #NUM! Error.

Examples of Quartile Function

Practice the following examples to learn the use of the Quartile function in Excel.

Example 1

The QUARTILE() function will calculate the value of a dataset in a given quartile.

Solution

Step 1 − First, consider the sample dataset that contains array values from the B3:B10 data cell, and the Quart value is present in the D3 cell.

Step 2 − Now go to the D12 cell, and type the formula =QUARTILE(B3:B10, D3).

Step 3 − After that, press the Enter key. The resultant value is 2.75.

Example 2

The QUARTILE() function will return the #NUM! error if the array is empty.

Solution

Step 1 − In this example, we will consider an empty array with a quart value of 1.

Step 2 − In the next step, calculate the QUARTILE() function bypassing the array size B3 to B6 and the quart value as a D3 cell reference. Simply go to the D12 cell, and type =QUARTILE(B3:B10, D3).

Step 3 − After that, press the Enter key, and the function will display a #NUM! value, as provided below −

Example 3

If the value of quart is non-numeric in a QUARTILE() function, then the function return the #VALUE! error.

Solution

Step 1 − In this example, we will assume an array and the k value as a non-numeric value.

Step 2 − Applying the quartile() function, by passing the array and quart-value references. Go to the D12 cell, and paste =QUARTILE(B3:B10, D3)

Step 3 − After that, press the Enter key. This will display the #VALUE! error.

Example 4

If the value of quart is less than 0, or greater than 4, then the QUARTILE() function will return the #NUM! Error.

Solution

For quart less than 0

Step 1 − For quart less than 0, will assume that the value of quart is -1.

Step 2 − After that call the QUARTILE() function, by passing the array values, and the quart-value. Go to the D12 cell, and paste the formula =QUARTILE(B3:B10, D3).

Step 3 − Once you press the Enter key, then, the Quartile function will generate the #NUM! Error, as the quart value is less than 0.

For quart greater than 4

In this case, we will assume that the quart-value should remain greater than 4, lets say 5 for this case.

Step 1 − Apply the quartile() function with the given array values in the range B3:B10 and the quart-value 5. Here, the quart-value is greater than 4, which is 5.

Step 2 − After that, call the QUARTILE() function bypassing the array values and the quart-value. Go to the D12 cell, and type =QUARTILE(B3:B10, D3).

Step 3 − The resultant value is the #NUM! Error, as the quart value is greater than 5.