Whole document tree QUARTILEDescriptionQUARTILE function returns the quartile of the given data points. If @quart is equal to: QUARTILE returns: 0 the smallest value of @array. 1 the first quartile 2 the second quartile 3 the third quartile 4 the largest value of @array. If @array is empty, QUARTILE returns #NUM! error. If @quart < 0 or @quart > 4, QUARTILE returns #NUM! error. If @quart is not an integer, it is truncated. This function is Excel compatible. |