QUARTILEEXC

Calculate quartiles using the exclusive method to understand data distribution.

The QUARTILEEXC function divides a dataset into four equal parts and returns a value based on the specified quartile. It uses the exclusive method, meaning the minimum and maximum values are excluded from the calculation, helping you understand how data is distributed across ranges.

Syntax

QUARTILEEXC(array, quart)

Arguments

The QUARTILEINC function syntax has the following arguments:

• array - The range or list of numeric values. Required.

• quart - The quartile value to return: (Required)

  • 1 - First Quartile (Q1) – 25th percentile

  • 2 - Second Quartile (Q2) – Median (50th percentile)

  • 3 - Third Quartile (Q3) – 75th percentile

Unlike QUARTILEINC, 0 (Minimum) and 4 (Maximum) are not valid inputs in the exclusive method.

Example

QUARTILEEXC(10,20,30,40,50,60,70,80, 1)
// Returns 22.5
QUARTILEEXC(10,20,30,40,50,60,70,80, 2)
// Returns 45
QUARTILEEXC(10,20,30,40,50,60,70,80, 3)
// Returns 67.5

You can use the QUARTILEEXC function to analyze the distribution of a dataset by dividing values into four equal parts for metrics such as sales, revenue, or performance scores.

QUARTILEEXC function

We can also use the SELECT function to select a range of columns from 1 to 4 for the 'Revenue' measure (2022 Revenue - 2025 Revenue).

QUARTILEEXC(SELECT([Revenue], 1, 4), 3)

Excel Equivalent

QUARTILEEXC

FAQs

Q1. What do quartiles represent?

• Q1 (First Quartile): 25% of the values fall below this value.

• Q2 (Second Quartile): 50% of the values fall below this value (Median).

• Q3 (Third Quartile): 75% of the values fall below this value.