Excel QUARTILE.INC Function

What is QUARTILE.INC function in Excel?

The QUARTILE.INC function is one of the Statistical functions of Excel.

It returns the quartile of a data set, based on percentile values from 0..1, exclusive.

We can find this function in Statistical category of insert function Tab.

How to use QUARTILE.INC function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select QUARTILE.INC function.

6. Then select ok.

excel QUARTILE.INC function

7. In the function arguments Tab you will see QUARTILE.INC function.

8. Array is the array or cell range of numeric values for which you want the quartile value.

9. Quart is a number: minimum value = 0; 1st quartile = 1; median value = 2; 3rd quartile = 3; maximum value = 4.

10. You will see the results in the formula result section.

Examples of QUARTILE.INC function in Excel

QUARTILE.INC related functions 

Leave a Reply

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