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.
from a set of numeric data.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
