QUARTILE.INC
Formulas / QUARTILE.INCCalculate 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.
Need help with Formulas?
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?
What happens if the array argument is empty?
What happens if QUARTILE.INC is set to 0, 2, and 4?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.