QUARTILE.INC Function Explained
The QUARTILE.INC Function in Microsoft Excel returns the quartile of a given set of data. It takes two arguments: an array of numbers and a quartile value ranging from 0 to 1. The quartile value indicates which quartile of the data set to return. For example, a quartile value of 0.25 returns the first quartile, 0.5 returns the second quartile, and 0.75 returns the third quartile.
QUARTILE.INC Function Syntax
QUARTILE.INC(array, quart)
- array: The array or range of data for which you want to calculate the quartile.
- quart: A number specifying which quartile value to return. Possible values are 0, 1, 2, 3, and 4. 0 = minimum value, 1 = first quartile, 2 = second quartile (median), 3 = third quartile, 4 = maximum value.