Use pre-Excel 2010 statistical functions in your Anaplan XL reports.
| Function | Description |
| BETADIST | Returns the cumulative beta probability density function. |
| BETAINV | Returns the inverse of the cumulative beta probability density function. |
| BINOMDIST | Returns the individual term binomial distribution probability. |
| CHIDIST | Returns the one-tailed probability of the chi-squared (X^2) distribution; the area in the right tail under the chi-squared distribution curve. |
| CHIINV | Returns the inverse of the one-tailed probability of the chi-squared (X^2) distribution. |
| CHITEST | Returns the test for independence of the characteristics in a table. |
| CONFIDENCE | Returns the confidence interval for a population mean. |
| COVAR | Returns the covariance, the average of products of deviations, for each data point pair. |
| EXPONDIST | Returns the exponential distribution. |
| FDIST | Returns the F probability distribution. |
| FINV | Returns the inverse of the F probability distribution. |
| FTEST | Returns the result of an F-test. |
| GAMMADIST | Returns the gamma distribution. |
| GAMMAINV | Returns the inverse of the gamma cumulative distribution. |
| LOGINV | Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation. |
| LOGNORMDIST | Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard deviation. |
| MODE | Returns the most frequently occuring, or repetitive, number in an array or range of data. |
| NEGBINOMDIST | Returns the negative binomial distribution. |
| NORMDIST | Returns the normal cumulative distribution for the specified mean and standard deviation. |
| NORMINV | Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. |
| NORMSDIST | Returns the standard normal cumulative distribution function. |
| PERCENTILE | Returns the k-th percentile of values in a range. |
| PERCENTRANK | Returns the rank of a value in a data set set as a percentage of the data set. |
| POISSON | Returns the Poisson distribution. |
| QUARTILE | Returns the quartile of a data set. |
| RANK | Returns the rank of a number in a list of numbers. |
| STDEV | Estimates standard deviation based on a sample. |
| STDEVP | Estimates standard deviation based on a sample, assuming that the arguments represent the total population. |
| TDIST | Returns the percentage points (probability) for the student t-distribution, where a numeric value (x) is a calculated value of t for which the percentage points are to be computed. |
| TINV | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. |
| TTEST | The probability associated with t-test. |
| VAR | Returns an estimate for the variance of a population based on a sample data set. |
| VARP | Calculates variance based on the entire population. |
| WEIBULL | Returns the Weibull distribution. |
| ZTEST | Returns the two-tailed P-value of a z-test. |
