QUARTILE.INC

Formulas / QUARTILE.INC
Calculate the quartile of a data set.
QUARTILE.INC(array,quart)
  • array - required, range of numeric values to get the quartile from
  • quart - required, value to return

Examples

  • =QUARTILE.INC(A1, 2)

    The QUARTILE.INC function can be used in Sourcetable to calculate quartiles from a range of data. For example, this will return the first quartile, or 25th percentile, of the data in cell A1.

  • =QUARTILE.INC(A1, 4)

    The third quartile, or 75th percentile, of the data in cell A1 can be found by using the QUARTILE.INC function with the argument 4, like the formula above.

  • =QUARTILE.INC({1;2;3;4;5;6;7;8;9;10}, 2)

    You can also use the QUARTILE.INC function to calculate quartiles from an array of data, rather than a single cell. For example, if you have the data array {1;2;3;4;5;6;7;8;9;10}, you can use the QUARTILE.INC function with the argument 2 to get the first quartile of the data, such as the formula above.

Summary

The QUARTILE.INC function is used to divide a population into groups by calculating quartiles, which are determined by percentile values. It is a useful tool for summarizing data sets.

  • The QUARTILE.INC function returns the quartile for a given set of data and its arguments are the array of data to analyze and the quartile value to return.
  • The QUARTILE.INC function has "greater than or equal to" behavior when the number is in the first quartile, the second quartile, the third quartile, or the fourth quartile, whereas the QUARTILE.EXC function is exclusive and has "greater than or equal to" behavior.


Frequently Asked Questions

What is the QUARTILE.INC function?
The QUARTILE.INC function returns the quartile of a data set. Quartiles are determined by percentile values and are useful for dividing populations into groups.
What happens if the array argument is empty?
If the array argument is empty, the QUARTILE.INC function returns the #NUM! error.
What happens if QUARTILE.INC is set to 0, 2, and 4?
If QUARTILE.INC is set to 0 (zero), 2, and 4, the function returns the same value as MIN, MEDIAN, and MAX.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV