QUARTILE

Formulas / QUARTILE
Calculate the quartile in a data set.
=QUARTILE(array, quart)
  • array - The array or range of data points from which you want to calculate the quartile. The data points can be numbers, logical values, or text representations of numbers.
  • quart - The quartile number you want to calculate. The value of "quart" must be an integer between 0 and 4, inclusive, where 0 represents the minimum value (0th percentile), 1 represents the first quartile (25th percentile), 2 represents the median or second quartile (50th percentile), 3 represents the third quartile (75th percentile), and 4 represents the maximum value (100th percentile).

Examples

  • =QUARTILE(A2:A9,1)

    This will return the first quartile of the data in the range A2 to A9, which is 3.5.

  • =QUARTILE(A2:A9,2)

    This will return the second quartile of the data in the range A2 to A9.


Summary

The QUARTILE function is used to divide a data set into four equal parts. It returns the fourth quartile of a data set, but can also return a #NUM! error if the array argument is empty or the quart argument is not an integer.

  • The QUARTILE function returns the quartile of a given set of data. The arguments for the QUARTILE function are the array of data to analyze and the quartile value to return.

Frequently Asked Questions

What is the QUARTILE function?
The QUARTILE function is a statistical function in Sourcetable that returns the quartile of a data set. Quartiles divide data into groups.
What are the arguments of the QUARTILE function?
The QUARTILE function takes one argument: an array of numbers.
What is the result of the QUARTILE function?
The QUARTILE function returns the quartile of the data set.
When is the QUARTILE function used?
The QUARTILE function is used in sales and survey data to divide data into groups.
What happens if the QUARTILE function array argument is empty?
If the array argument is empty, the QUARTILE function returns the #NUM! error.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV