SheetFX
≡
<< Go back to all functions

QUARTILE

The QUARTILE function in Google Sheets is a powerful tool to return a value nearest to a specified quartile of a dataset. Whether you're analyzing statistical data, evaluating survey results, or working with financial data, the QUARTILE function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: QUARTILE(data, quartile_number)

Parameters:

  • data: The array or range of data to consider.
  • quartile_number: The quartile number to calculate. It can be a decimal value ranging from 0 to 4, inclusive.

Step-by-Step Tutorial

  1. Using QUARTILE with an array of numbers:

    • Example: =QUARTILE({1, 2, 3, 4, 5, 6, 7, 8}, 2)
    • Result: 4

  2. Using QUARTILE with a range of cells:

    • Example: If A1:A8 has the values 1, 2, 3, 4, 5, 6, 7, 8, then =QUARTILE(A1:A8, 2) will return 4.

Use Cases and Scenarios

  1. Statistical Analysis: Determine the quartile values in a dataset.
  2. Survey Results: Analyze survey responses using quartiles.
  3. Financial Analysis: Calculate quartiles for financial data distributions.

Related Functions

  • MEDIAN: Find the median value in a set.
  • PERCENTILE: Calculate the k-th percentile of a dataset.

Related Articles