QUARTILE.INC(array,quart)
=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.
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.