FLASH SALE! - "CHATGPT AND ARTIFICIAL INTELLIGENCE FOR MICROSOFT EXCEL AT 60% OFF" Enroll Now

QUARTILE Excel Function

Updated on December 31, 2023
Article byTanuj Kumar
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

QUARTILE Function in Excel

It is one of the statistical functions of Excel. The functions are used to find the various quartiles of a data set. A quartile is just a quantile. There are three quartiles: the first quartile (Q1) is the middle number between the smallest and median data set values. The second quartile (Q2) is the median of the data. The third quartile (Q3) is the middle value between the median of the data set and the highest value. It can also return the data set’s minimum and maximum values along with quartiles. For example, the first quartile Q1 divides the lowest.

Formula

The syntax of the QUARTILE formula is as follows:

QUARTILE Formula

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Parameters

As it is clear from the syntax shown above, it has two mandatory parameters, which are explained below:

Data: The first parameter is a data set, which we will require to determine the quartile.

Quartile: The second parameter defines the type of quartile to be returned by the QUARTILE in Excel. The QUARTILE parameter can have any value from 0 to 4. Then, depending on the value of the QUARTILE parameter, the QUARTILE function returns the respective quartile.

QUARTILE Excel Function Video

 

Examples

In this section, we will understand the uses of the QUARTILE function in Excel and look at a few examples with the help of actual data.

Value of QuartileReturn Vaue
0Minimum Value
1First quartile (also known as 25th Percentile)
2Median Value (or 50th Percentile)
3Third Quartile or 75th Percentile
4Maximum Value
5 to any integer#NUM! Error

How to Use the QUARTILE Function in Excel?

This function is very easy to use, and as explained in the previous section, QUARTILE fuses two mandatory parameters.

You can download this QUARTILE-Function-in-Excel here – QUARTILE-Function-in-Excel

QUARTILE in Excel – Example #1

Let us consider the data set and apply the QUARTILE function based on quartile values 0,1,2,3 and 4.

Example 1

QUARTILE in Excel – Example #2

Let us take a larger data set this time. We will try to find Q1, Q2, Q3, minimum, and maximum values.

Example #2
Example 2-1

Things to Remember

  1. It can be used as a worksheet function.
  2. It returns a numeric value.
  3. It was first introduced in Excel 2000 and is now available in all subsequent versions of Excel.
  4. If the value of the QUARTILE parameter is greater than 4 or less than 0, the function returns a #NUM! Error.
  5. The QUARTILE formulaQUARTILE FormulaQuartile Formula is a statistical tool to calculate the variance from the given data by dividing the same into four defined intervals. First Quartile could be calculated as follows: (Q1) = ((n + 1)/4)th Term.read more through #NUM! Error if the given array is empty.
  6. The QUARTILE function #VALUE! Error if the given value of quart is non-numeric.

Recommended Articles

This article is a guide to QUARTILE Function in Excel. Here, we will learn how to use QUARTILE in Excel along with Excel examples and downloadable Excel templates. You may also look at these useful functions in Excel: –