The QUARTILE.EXC function
It returns the quartile of a data set based on percentile values from 0..1, exclusive.
It returns the quartile of a data set based on percentile values from 0..1, exclusive.
In statistics, the quartiles, of a ranked set of data values, are the three points that divide the set into four equal groups. Each group constitutes a quarter of the data.