QUARTILEINC

Calculate quartiles using the inclusive method to understand data distribution.

The QUARTILEINC function divides a dataset into four equal parts and returns a value based on the specified quartile. It uses the inclusive method, meaning the minimum and maximum values are included in the calculation, helping 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. Required.
• quart - The quartile value to return: (Required)
  • 0 - Minimum value
  • 1 - First Quartile (Q1) – 25th percentile
  • 2 - Second Quartile (Q2) – Median (50th percentile)
  • 3 - Third Quartile (Q3) – 75th percentile
  • 4 - Maximum value

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(SELECT([Revenue], 1, 4), 3)

Excel Equivalent#

QUARTILEINC

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.