QUARTILE.EXC Function Explained
The QUARTILE.EXC 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 4, with 0 representing the minimum value, 1 representing the first quartile, 2 representing the median, 3 representing the third quartile, and 4 representing the maximum value.
QUARTILE.EXC Function Syntax
QUARTILE.EXC(array, quart)
- array: The array or range of data for which you want to determine the quartile value.
- quart: A number specifying which quartile value to return. 1 = first quartile (lower quartile) value; 2 = second quartile (median) value; 3 = third quartile (upper quartile) value; 4 = fourth quartile value.