A percentile is a value below which a given percentage of values in a data set fall.

Note: Microsoft classifies PERCENTILE as a “compatibility function”, now replaced by the PERCENTILE.INC function.

A percentile is a value below which a given percentage of values in a data set fall.

Difference between PERCENTILE.INC and PERCENTILE.EXC

you could use PERCENTILE.EXC to determine the 90th percentile, the 80th percentile, etc.

from a set of numeric data.

RANK can rank values from largest to smallest (i.e.

Difference between PERCENTILE.INC and PERCENTILE.EXC

top sales) as well as smallest to largest (i.e.

Difference between PERCENTILE.INC and PERCENTILE.EXC

Difference between PERCENTILE.INC and PERCENTILE.EXC

Difference between PERCENTILE.INC and PERCENTILE.EXC

Excel PERCENTILE.EXC function

Excel SMALL function

Excel LARGE function

Excel RANK function

Difference between PERCENTILE.INC and PERCENTILE.EXC