QUARTILE 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.