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. |
