# 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 a list of all statistical formulas available:
FunctionDescription
MEDIANReturns the middle value in a dataset.
MODEReturns the most frequently occurring value in a dataset.
MODESNGLReturns the single most frequently occurring value in a dataset. Returns the first mode when multiple numbers recur.
RANKLegacy version of RANKEQ function. It can be used in place of RANKEQ to return the rank of a number in a list of values.
RANKEQReturns 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.
RANKAVGReturns the rank of a number in a list but gives the average rank if there are duplicates.
STDEVLegacy version of the STDEVS function. It can be used in place of STDEVS for sample standard deviation calculations.
STDEVSCalculates standard deviation based on a sample.
STDEVPCalculates standard deviation based on the entire population.
VARSCalculates the variance based on a sample.
VARPCalculates the variance based on the entire population.
QUARTILELegacy version of the QUARTILEINC function. It can be used in place of QUARTILEINC for inclusive quartile calculations.
QUARTILEINCReturns the quartile of a data set (0, 1, 2, 3, 4), including the minimum and maximum values.
QUARTILEEXCReturns the quartile of a data set (1, 2, 3), excluding the minimum and maximum values.
PERCENTILELegacy version of the PERCENTILEINC function. It can be used in place of PERCENTILEINC for inclusive percentile calculations.
PERCENTILEINCReturns the k-th percentile of values in a range, including the lowest and highest percentiles.
PERCENTILEEXCReturns the k-th percentile of values in a range, excluding the lowest and highest percentiles.
NORMDISTReturns the normal distribution for a value with specified mean and standard deviation.
NORMSDISTReturns the standard normal distribution for a given value.
NORMINVCalculates the inverse of the normal cumulative distribution for a specified mean and standard deviation.
NORMSINVReturns the inverse of the standard normal cumulative distribution.
PERCENTRANKLegacy version of the PERCENTRANKINC function. It can be used in place of PERCENTRANKINC for inclusive percentage rank calculations.
PERCENTRANKINCReturns the rank of a value as a percentage between 0 and 1 of the data set, including 0 and 1.
PERCENTRANKEXCReturns the rank of a value as a percentage between 0 and 1 of the data set, excluding 0 and 1.
--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/formula-syntax/statistical-functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.