QUARTILE.EXC

Formulas / QUARTILE.EXC
Calculate the quartile for a set of data.
=QUARTILE.EXC(array,quart)
  • array - required range of numerical values to get the quartile value from
  • quart - required argument to specify which quartile to calculate

Examples

    The function is used to calculate the quartiles of a set of data. Quartiles divide the data into four equal parts. The first quartile is the value that is at the 25th percentile, the second quartile is at the 50th percentile, and the third quartile is at the 75th percentile.

  • =QUARTILE.EXC(A2, 2)

    To calculate the second quartile value for a range of data in cell A2, use the preceding formula. This will return the value at the 50th percentile of the data range.

  • =QUARTILE.EXC(A2, 1)

    To calculate the first quartile value for a range of data in cell A2, use the preceding formula. This will return the value at the 25th percentile of the data range.

  • =QUARTILE.EXC(A2, 3)

    To calculate the third quartile value for a range of data in cell A2, use the formula above. This will return the value at the 75th percentile of the data range.


Summary

The QUARTILE.EXC function is used to calculate the quartile of a given data set. It requires an array and a quart argument, and determines the quartile based on percentile values.

  • The QUARTILE.EXC function takes two arguments, the first being the quartile value and the second being the percentile value.
  • The arguments for the QUARTILE.EXC function are the array containing numeric data to analyze and quart.
  • The quartile argument indicates which quartile value to return and accepts 3 values.

Frequently Asked Questions

What is the QUARTILE.EXC function?
The QUARTILE.EXC function is a statistical function in Sourcetable that returns the quartile of a data set.
What does the QUARTILE.EXC function do?
The QUARTILE.EXC function returns the quartile of the data set, which is the value that divides the data set into four equal parts. It is useful for finding the median, lower quartile, and upper quartile.
What type of data does the QUARTILE.EXC function take as input?
The QUARTILE.EXC function takes an array of numbers as input.
What type of output does the QUARTILE.EXC function produce?
The QUARTILE.EXC function produces a number as output, which is the quartile of the data set.
What happens if the array argument is empty?
If the array argument is empty, the QUARTILE.EXC function produces a #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