SheetFX
≡
<< Go back to all functions

QUARTILE.INC

The QUARTILE.INC function in Google Sheets is a statistical function that calculates the quartile of a dataset, based on the specified quartile number. Whether you're analyzing data distributions, conducting statistical analysis, or working with large datasets, the QUARTILE.INC function provides a reliable way to determine quartiles. Explore our comprehensive guide to understand its syntax and usage.

Function Syntax and Parameters

Syntax: QUARTILE.INC(data, quartile_number)

Parameters:

  • data: The array or range containing the dataset.
  • quartile_number: The quartile number to calculate. Valid quartile numbers are 1, 2, and 3.

Step-by-Step Tutorial

  1. Using QUARTILE.INC with an array of numbers:

    • Example: =QUARTILE.INC({1, 2, 3, 4, 5}, 2)
    • Result: 3

  2. Using QUARTILE.INC with a range of cells:

    • Example: If A1:A10 contains a dataset, then =QUARTILE.INC(A1:A10, 1) will return the first quartile value.

Use Cases and Scenarios

  1. Data Analysis: Calculate quartiles for a dataset to understand its distribution.
  2. Statistical Analysis: Use quartiles to detect outliers or anomalies in a dataset.
  3. Business Reporting: Determine quartiles to analyze sales performance or customer behavior.

Related Functions

  • QUARTILE: Calculate quartiles using an alternative algorithm.
  • QUARTILE.EXC: Calculate quartiles using an exclusive algorithm.

Related Articles