QUARTILEINC

Calculates quartile values to analyze data distribution.

The QUARTILEINC function divides a dataset into four equal parts and returns a value based on the specified quartile. It helps you understand how data is distributed across ranges.

Syntax

QUARTILEINC(array, quart)

Arguments

The QUARTILEINC function syntax has the following arguments:

• array - The range or list of numeric values.

• quart - The quartile value to return:

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

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

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

If a value other than 1, 2, or 3 is provided for quart, the QUARTILEINC function returns a #ERR error.

Example

QUARTILEINC(10,20,30,40,50,60,70,80, 1)
// Returns 25
QUARTILEINC(10,20,30,40,50,60,70,80, 2)
// Returns 45
QUARTILEINC(10,20,30,40,50,60,70,80, 3)
// Returns 65

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

QUARTILEINC function

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

Excel Equivalent

QUARTILEINC

QUARTILE is the legacy version of the QUARTILEINC function and works similarly. It can be used in place of QUARTILEINC for inclusive quartile calculations.

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.