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
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select STATISTICAL category.
5. Select QUARTILE.INC function.
6. Then select ok.
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.
