Use Excel's statistical functions in your Anaplan XL reports
| Function | Description |
| AVEDEV | Returns the average of the absolute deviations of data points from their mean. |
| AVERAGE | Returns the average of its arguments. |
| AVERAGEA | Returns the average of the values in its list of arguments, including text and logical values. |
| AVERAGEIF | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria. |
| AVERAGEIFS | Returns the average (arithmetic mean) of all cells that meet multiple criteria. |
| BETA.DIST | Returns the beta cumulative distribution function. |
| BETA.INV | Returns the inverse of the cumulative distribution function for a specified beta distribution. |
| BINOM.DIST | Returns the individual term binomial distribution probability. |
| BINOM.DIST.RANGE | Returns the probability of the specified trial using a binomial distribution. |
| BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |
| CHISQ.DIST | Returns the chi-squared distribution. |
| CHISQ.DIST.RT | Returns the one-tailed probability of the chi-squared distribution. |
| CHISQ.INV | Returns the inverse of the left-tailed probability of the chi-squared distribution. |
| CHISQ.INV.RT | Returns the inverse of the right-tailed probability of the chi-squared distribution. |
| CHISQ.TEST | Returns the test for independence. |
| CONFIDENCE.NORM | Returns the confidence interval for a population mean. |
| CONFIDENCE.T | Returns the confidence interval for a population mean, using a student's t distribution. |
| CORREL | Returns the correlation coefficient between two data sets. |
| COUNT | Counts the number of cells that contain numbers (including dates and formulas that evaluate to numbers) within the list of arguments. |
| COUNTA | Counts the number of cells that aren't empty. |
| COUNTBLANK | Counts the empty cells in a specified range. |
| COUNTIF | Counts the number of cells in a range that meet a given criteria. |
| COUNTIFS | Counts the number of cells within a range that meet multiple criteria. |
| COVARIANCE.P | Returns covariance, the average of the products of paired deviations |
| COVARIANCE.S | Returns the sample covariance, the average of the products deviations for each data point pair in two data sets. |
| CRITBINOM | Returns the minimum number yields a binomial distribution less than or equal to the specified criteria. |
| DEVSQ | Returns the sum of the squares of deviations of a data set from their sample mean. |
| EXPON.DIST | Returns the exponential distribution. |
| F.DIST | Returns the F probability distribution. |
| F.DIST.RT | Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets. |
| F.INV | Returns the inverse of the F probability distribution. |
| F.INV.RT | Returns the inverse of the (right-tailed) F probability distribution. |
| F.TEST | Returns the result of an F-test. |
| FISHER | Returns the Fisher transformation at x. |
| FISHERINV | Returns the inverse of the Fisher transformation at y. |
| FORECAST | Calculates or predicts a future value by using existing values. |
| FREQUENCY | Calculates how often values occur within a range of values and then returns a vertical array of numbers. |
| GAMMA | Returns the gamma function result for the specified number. |
| GAMMA.DIST | Returns the gamma distribution. |
| GAMMA.INV | Returns the inverse of the gamma cumulative distribution. |
| GAMMALN | Returns the natural logarithm of the gamma function. |
| GAMMALN.PRECISE | Returns the natural logarithm of the gamma function. |
| GAUSS | Returns the probability that a number will fall between the mean and the specified standard deviation in a normal distribution. |
| GEOMEAN | Returns the geometric mean of an array or range of positive data. |
| GROWTH | Calculates predicted exponential growth by using existing data. |
| HARMEAN | Returns the harmonic mean of a data set. |
| HYPGEOM.DIST | Returns the hypergeometric distribution. |
| HYPGEOMDIST | Returns the hypergeometric distribution. |
| INTERCEPT | Calculates the point at which a line will intersect the y-axis by using existing x and y values. |
| KURT | Returns the Kurtosis of a data set. |
| LARGE | Returns the k-th largest value in a data set. |
| LINEST | Calculates a straight line that best fits your data using the least squares method. |
| LOGEST | Calculates an exponential curve that fits your data and returns an array of values that describes the curve. |
| LOGNORM.DIST | Returns the lognormal distribution of x, where ln(x) is normally distributed with mean and standard deviation. |
| LOGNORM.INV | Returns the inverse of the lognormal cumulative distribution. |
| MAX | Returns the largest value in a set of values. |
| MAXA | Returns the largest value in a set of values, including text and logical values. |
| MEDIAN | Returns the median of the given numbers. |
| MIN | Returns the smallest value in a set of values. |
| MINA | Returns the smallest value in a set of values, including text and logical values. |
| MODE.MULT | Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data. |
| MODE.SNGL | Returns the most common value in a data set. |
| NEGBINOM.DIST | Returns the negative binomial distribution. |
| NORM.DIST | Returns the normal cumulative distribution. |
| NORM.INV | Returns the inverse of the normal cumulative distribution. |
| NORM.S.DIST | Returns the standard normal cumulative distribution. |
| NORM.S.INV | Returns the inverse of the standard normal cumulative distribution. |
| NORMSINV | Returns the inverse of the standard normal cumulative distribution function. |
| PEARSON | Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets. |
| PERCENTILE.EXC | Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive |
| PERCENTILE.INC | Returns the k-th percentile of values in a range. |
| PERCENTRANK.EXC | Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set |
| PERCENTRANK.INC | Returns the percentage rank of a value in a data set. |
| PERMUT | Returns the number of permutations for a given number of objects that can be selected from a range of numbers. |
| PERMUTATIONA | Returns the number of permutations given the specified total number of items and the specified number of items chosen for each permutation. |
| PHI | Returns the value of the probability density function of the specified number for the standard normal distribution. |
| POISSON.DIST | Returns the Poisson distribution. |
| PROB | Returns the probability that values in a range are between two specified limits. |
| QUARTILE.EXC | Returns the quartile of the data set, based on percentile values for 0..1, exclusive. |
| QUARTILE.INC | Returns the quartile of a data set. |
| RANK.AVG | Returns the rank of a number in a list of numbers. |
| RANK.EQ | Returns the rank of a number in a list of numbers. |
| RSQ | Returns the r^2 value of a linear regression line. |
| SKEW | Returns the skew of a distribution. |
| SKEW.P | Returns the population skewness of the specified distribution. |
| SLOPE | Returns the slope of a regression line through data points in KNOWN_Y'S and KNOWN_X'S. |
| SMALL | Returns the k-th smallest value in a data set. |
| STANDARDIZE | Returns a normalized value from a distribution characterized by MEAN and STANDARD_DEV. |
| STDEV.P | Calculates standard deviation based on the entire population |
| STDEV.S | Estimates standard deviation based on a sample. |
| STDEVA | Estimates standard deviation based on a sample. Includes text and logical values. |
| STDEVPA | Estimates standard deviation based on a sample assuming that the arguments represent the total population. Includes text and logical values. |
| STEYX | Returns the standard error of the predicted y value for each x in the regression. |
| T.DIST | Returns the percentage points (probability) for the student t-distribution. |
| T.DIST.2T | Returns the percentage points (probability) for the student t-distribution. |
| T.DIST.RT | Returns the Student's t-distribution. |
| T.INV | Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. |
| T.INV.2T | Returns the inverse of the Student's t-distribution. |
| T.TEST | Returns the probability associated with a Student's t-test. |
| TREND | Returns the y-values along a linear trendline that best fits the values in a data set. |
| TRIMMEAN | Returns the mean of the interior of a data set. |
| VAR.P | Calculates variance based on the entire population. |
| VAR.S | Estimates variance based on a sample. |
| VARA | Returns an estimate for the variance of a population based on a sample data set and may include text or logical values. |
| VARPA | Calculates variance based on the entire population and may include text or logical values. |
| WIEBULL.DIST | Returns the Weibull distribution. |
| Z.TEST | Returns the one-tailed probability-value of a z-test. |
