QUARTILE.EXC

The QUARTILE.EXC function in Google Sheets returns the value nearest to a specified quartile of a dataset, calculated exclusive of the 0th and 4th quartiles (the minimum and maximum). It offers an alternative quartile calculation method to the more common QUARTILE.INC. Dive into our comprehensive guide to learn how it works.

Parameters

• data: The array or range containing the dataset to analyze.
• quartile_number: Which quartile to return — 1 for the 25th percentile, 2 for the median, or 3 for the 75th percentile.

Step-by-Step Tutorial

1. Finding the first quartile:

   • Example: If A1:A8 contains 1, 2, 3, 4, 5, 6, 7, 8, then =QUARTILE.EXC(A1:A8, 1) will return 2.25.

2. Finding the median (second quartile):

   • Example: =QUARTILE.EXC(A1:A8, 2)
   • Result: 4.5

Use Cases and Scenarios

1. Statistical Analysis: Break a dataset into quartiles for distribution analysis.
2. Outlier Detection: Combine with the interquartile range to identify unusually high or low values.
3. Academic and Research Reporting: Report quartile-based statistics using the exclusive method preferred in certain fields.

Related Functions

• QUARTILE: Returns the value nearest to a given quartile using the inclusive method.
• PERCENTILE.EXC: Returns the value at a given percentile of a dataset, exclusive method.

Related Articles

• Understanding Statistical Functions in Google Sheets