How to use the QUARTILE.INC Function in Excel

In this article, we will learn about how to use QUARTILE.INC function in Excel.

QUARTILE.INC function returns the nth percentile of the range of values. From Excel 2010 QUARTILE.INC function is preferred

It returns minimum value, 1/4th QUARTILE.INC value, 1/2th QUARTILE.INC value, 3/4th value & maximum value from the array of numbers.

=QUARTILE.INC(array, quart)

Array : list of values
Quart : select a number to get the nth percentile you wish

Quart Nth percentile
0 0th percentile or Min Value
1 25th percentile
2 50th percentile
3 75th percentile

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.