# 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:

<table data-full-width="false"><thead><tr><th width="247.8887939453125">Function</th><th>Description</th></tr></thead><tbody><tr><td><a href="statistical-functions/median">MEDIAN</a></td><td>Returns the middle value in a dataset.</td></tr><tr><td><a href="statistical-functions/mode">MODE</a></td><td>Returns the most frequently occurring value in a dataset.</td></tr><tr><td><a href="statistical-functions/modesngl">MODESNGL</a></td><td>Returns the single most frequently occurring value in a dataset. Returns the first mode when multiple numbers recur.</td></tr><tr><td><a href="statistical-functions/rankeq">RANK</a></td><td>Legacy version of <strong>RANKEQ</strong> function. It can be used in place of RANKEQ to return the rank of a number in a list of values.</td></tr><tr><td><a href="statistical-functions/rankeq">RANKEQ</a></td><td>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.</td></tr><tr><td><a href="statistical-functions/rankavg">RANKAVG</a></td><td>Returns the rank of a number in a list but gives the average rank if there are duplicates.</td></tr><tr><td><a href="statistical-functions/stdevs">STDEV</a></td><td>Legacy version of the <strong>STDEVS</strong> function. It can be used in place of STDEVS for sample standard deviation calculations.</td></tr><tr><td><a href="statistical-functions/stdevs">STDEVS</a></td><td>Calculates standard deviation based on a sample.</td></tr><tr><td><a href="statistical-functions/stdevp">STDEVP</a></td><td>Calculates standard deviation based on the entire population.</td></tr><tr><td><a href="statistical-functions/vars">VARS</a></td><td>Calculates the variance based on a sample.</td></tr><tr><td><a href="statistical-functions/varp">VARP</a></td><td>Calculates the variance based on the entire population.</td></tr><tr><td><a href="statistical-functions/quartileinc">QUARTILE</a></td><td>Legacy version of the <strong>QUARTILEINC</strong> function. It can be used in place of QUARTILEINC for inclusive quartile calculations.</td></tr><tr><td><a href="statistical-functions/quartileinc">QUARTILEINC</a></td><td>Returns the quartile of a data set (0, 1, 2, 3, 4), including the minimum and maximum values.</td></tr><tr><td><a href="statistical-functions/quartileexc">QUARTILEEXC</a></td><td>Returns the quartile of a data set (1, 2, 3), excluding the minimum and maximum values.</td></tr><tr><td><a href="statistical-functions/percentileinc">PERCENTILE</a></td><td>Legacy version of the <strong>PERCENTILEINC</strong> function. It can be used in place of PERCENTILEINC for inclusive percentile calculations.</td></tr><tr><td><a href="statistical-functions/percentileinc">PERCENTILEINC</a></td><td>Returns the k-th percentile of values in a range, including the lowest and highest percentiles.</td></tr><tr><td><a href="statistical-functions/percentileexc">PERCENTILEEXC</a></td><td>Returns the k-th percentile of values in a range, excluding the lowest and highest percentiles.</td></tr><tr><td><a href="statistical-functions/normdist">NORMDIST</a></td><td>Returns the normal distribution for a value with specified mean and standard deviation.</td></tr><tr><td><a href="statistical-functions/normsdist">NORMSDIST</a></td><td>Returns the standard normal distribution for a given value.</td></tr><tr><td><a href="statistical-functions/norminv">NORMINV</a></td><td>Calculates the inverse of the normal cumulative distribution for a specified mean and standard deviation.</td></tr><tr><td><a href="statistical-functions/normsinv">NORMSINV</a></td><td>Returns the inverse of the standard normal cumulative distribution.</td></tr><tr><td><a href="statistical-functions/percentrankinc">PERCENTRANK</a></td><td>Legacy version of the <strong>PERCENTRANKINC</strong> function. It can be used in place of PERCENTRANKINC for inclusive percentage rank calculations.</td></tr><tr><td><a href="statistical-functions/percentrankinc">PERCENTRANKINC</a></td><td>Returns the rank of a value as a percentage between 0 and 1 of the data set, including 0 and 1.</td></tr><tr><td><a href="statistical-functions/percentrankexc">PERCENTRANKEXC</a></td><td>Returns the rank of a value as a percentage between 0 and 1 of the data set, excluding 0 and 1.</td></tr></tbody></table>