Statistical Functions

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

Function	Description
RANK(number, list, [order])	An older version of RANKEQ. Returns the rank of a number in a list; if there are duplicates, the rank remains the same. The next rank is skipped.
RANKEQ(number, list, [order])	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(number, list, [order])	Returns the rank of a number in a list, but gives the average rank if there are duplicates.
PERCENTRANK.INC(array, x, [significance])	Returns the rank of a value as a percentage between 0 and 1 of the data set, including 0 and 1.
PERCENTRANK.EXC(array, x, [significance])	Returns the rank of a value as a percentage between 0 and 1 of the data set, excluding 0 and 1.
PERCENTILE(array, k)	Returns the k-th percentile in the given data.
PERCENTILE.EXC(array, k)	Returns the k-th percentile of values in a range, excluding the lowest and highest percentiles.
PERCENTILE.INC(array, k)	Returns the k-th percentile of values in a range, including the lowest and highest percentiles.
QUARTILE.EXC(array, quart)	Returns the quartile (1, 2, 3, or 4) of a data set, excluding the minimum and maximum values.
QUARTILE.INC(array, quart)	Returns the quartile of a data set, including the minimum and maximum values.
NORM.S.DIST(z, cumulative)	Returns the standard normal cumulative distribution function.
NORM.DIST(x, mean, standard_dev, cumulative)	Returns the normal distribution for a specified mean and standard deviation.
MODE.SNGL(number1, [number2], ...)	Returns the most frequently occurring value in a data set (single mode).
VAR.P(number1, [number2], ...)	Calculates the variance based on the entire population.
VAR.S(number1, [number2], ...)	Calculates the variance based on a sample.
STDEV.P(number1, [number2], ...)	Calculates standard deviation based on the entire population.
STDEV.S(number1, [number2], ...)	Calculates standard deviation based on a sample.