Statistical Functions

Analyze data using statistical functions to summarize, measure variation, and uncover insights.

Plan supports an array of statistical formulas and functions for calculating rank, standard deviation, variance, mean, median, mode, percentiles, and much more. Below is a list of all statistical formulas available:

Function	Description
MEDIAN	Returns the middle value in a dataset.
MODE	Returns the most frequently occurring value in a dataset.
MODESNGL	Returns the single most frequently occurring value in a dataset. Returns the first mode when multiple numbers recur.
RANK	Legacy version of RANKEQ function. It can be used in place of RANKEQ to return the rank of a number in a list of values.
RANKEQ	Returns the rank of a number in a list; if there are duplicates, the rank remains the same (similar to RANK). The next rank is skipped.
RANKAVG	Returns the rank of a number in a list but gives the average rank if there are duplicates.
QUARTILE	Legacy version of the QUARTILEINC function. It can be used in place of QUARTILEINC for inclusive quartile calculations.
QUARTILEINC	Returns the quartile of a data set (0, 1, 2, 3, 4), including the minimum and maximum values.
QUARTILEEXC	Returns the quartile of a data set (1, 2, 3), excluding the minimum and maximum values.
STDEV	Legacy version of the STDEVS function. It can be used in place of STDEVS for sample standard deviation calculations.
STDEVS	Calculates standard deviation based on a sample.
STDEVP	Calculates standard deviation based on the entire population.
PERCENTILEINC	Returns the k-th percentile of values in a range, including the lowest and highest percentiles.
PERCENTILE	Legacy version of the PERCENTILEINC function. It can be used in place of PERCENTILEINC for inclusive percentile calculations.
PERCENTILEEXC	Returns the k-th percentile of values in a range, excluding the lowest and highest percentiles.
VARS	Calculates the variance based on a sample.
VARP	Calculates the variance based on the entire population.
PERCENTRANK	Legacy version of the PERCENTRANKINC function. It can be used in place of PERCENTRANKINC for inclusive percentage rank calculations.
PERCENTRANKINC	Returns the rank of a value as a percentage between 0 and 1 of the data set, including 0 and 1.
PERCENTRANKEXC	Returns the rank of a value as a percentage between 0 and 1 of the data set, excluding 0 and 1.
NORMDIST	Returns the normal distribution for a value with specified mean and standard deviation.
NORMSDIST	Returns the standard normal distribution for a given value.
NORMINV	Calculates the inverse of the normal cumulative distribution for a specified mean and standard deviation.
NORMSINV	Returns the inverse of the standard normal cumulative distribution.