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.
Syntax:

=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
4 100th percentile or Max Value

Let’s run some tests on some numbers using the function

The nth percentile value for the range of values : 0,1,2,3,4
Use the formula:

=QUARTILE.INC(H2:H6,0)

0 : for the first minimal values.
Replace the quart_num with other numbers to get different percentile values from the array values.
0034
As you can see,
The minimum value of the array is 0 and max is 4.
25th percentile is 1, 50th percentile is 2 & 75th percentile for the array will be 3.
Now we wish to find the different percentile of the data.
0035
The data name is defined for the values A2:A11.

Use the formula

=QUARTILE.INC (data, 0)

0036
As you can see the QUARTILE.INC of the array using Excel QUARTILE.INC function.
Notes:

  1. QUARTILE.INC returns the #NUM! error value.
    • If the array input is empty.
    • If quart is less than 0 or more than 4
  2. If quart number is not an integer, it gets truncated.
  3. MIN, MEDIAN, and MAX return the same value as QUARTILE.INC when quart is equal to 0 (zero), 2, and 4, respectively.
  4. Starting with Excel 2010, the QUARTILE.INC function replaces the QUARTILE function with the same behavior.

Hope you understood how to use QUARTILE.INC function and referring cell in Excel. Explore more articles on Excel functions here. Please feel free to state your query or feedback for the above article.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube