Tag Archives: PERCENTILE

1904, 2019

The PERCENTILE function

Kornilios Ampatzis/ April 19, 2019/ Functions

It returns the k-th percentile of values in a range. This function has been replaced by two new functions and you should avoid using it unless it is absolutely necessary. The new functions are PERCENTILE.INC and PERCENTILE.EXC.

1704, 2019

Excel Statistics – Calculating the Quartiles

Kornilios Ampatzis/ April 17, 2019/ Tutorials

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.