Interpolation
Whenxdoes not exist within the array, the function interpolates a value between data points.
Inclusive vs.
Exclusive
Starting with Excel 2010, the PERCENTRANK function has been replaced by two distinct functions:PERCENTRANK.INCandPERCENTRANK.EXC.
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.
PERCENTILE Function
The Excel PERCENTILE function calculates the “kth percentile” for a set of data.
A percentile is a value below which a given percentage of values in a data set fall.
QUARTILE can return minimum value, first quartile, second quartile, third quartile, and max value.
