Excel Data Analysis For Dummies
Book image
Explore Book Buy On Amazon

The QUARTILE.EXC and QUARTILE.INC functions in Excel determine the array value at a specified quartile in an array—and work in a manner similar to the percentile functions.

The QUARTILE.EXC formula uses the syntax

=QUARTILE.EXC(array,quart)

The QUARTILE.INC formula uses the syntax

=QUARTILE.INC(array,quart)

where array gives the array of values and quart gives the quartile of the value that you want to find.

To find the value in the first quartile in the array of values (inclusive) shown in the worksheet range A1:A9 in this figure, use the formula

The function returns the value <span class=
4." width="535"/>
The function returns the value 4.
=QUARTILE.INC(A1:A9,2)

The function returns the value 4, because the value 4 is at the 50th percentile in this array. This formula appears in cell G10 in the worksheet shown.

To find the value in the first quartile in the array of values (exclusive) shown in the worksheet range A1:A9 in the figure, use the formula

=QUARTILE.EXC(A1:A9,2)

The function also returns the value 4, because the value 4 is also at the 50th percentile in this array.

About This Article

This article is from the book:

About the book author:

Paul McFedries is a true renaissance geek. He has been a programmer, consultant, database developer, and website builder. He's also the author of more than 90 books including top sellers covering Windows, Office, and macOS.

This article can be found in the category: