SheetFX
≡
<< Go back to all functions

QUARTILE.EXC

The QUARTILE.EXC function in Google Sheets returns the value nearest to a given quartile of a dataset, exclusive of 0 and 4. This function is commonly used in statistical analysis to analyze data distribution.

Function Syntax and Parameters

Syntax: QUARTILE.EXC(data, quartile_number)

Parameters:

  • data: The range of data values or array containing the dataset.
  • quartile_number: The quartile number to calculate the value for.

Step-by-Step Tutorial

  1. Using QUARTILE.EXC with a range of cells:
    • Example: If A1:A10 contains the dataset [12, 34, 45, 56, 67, 78, 89, 90, 91, 92], then =QUARTILE.EXC(A1:A10, 1) will return 36.8, which is the first quartile value.

Use Cases and Scenarios

  1. Data Analysis: Determine the quartile range of a dataset for further analysis.
  2. Statistical Analysis: Calculate quartiles to study the distribution of numerical data.

Related Functions

  • QUARTILE.INC: Returns the inclusive quartile of a dataset.

Related Articles