| AVEDEV | =AVEDEV(number1, number2, ...) | Calculates the average of the absolute deviations from the mean. |
| AVERAGEIF | =AVERAGEIF(range, criteria, [average_range]) | Calculates the average of cells in a range that meet a specified condition. |
| AVERAGEIFS | =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...]) | Calculates the average of cells based on multiple criteria. |
| BETADIST | =BETADIST(x, alpha, beta, [cumulative], [lower], [upper]) | Calculates the probability density function for a beta distribution. |
| BETAINV | =BETAINV(probability, alpha, beta, [lower], [upper]) | Calculates the inverse of the cumulative distribution function for a beta distribution. |
| BINOM.DIST | =BINOM.DIST(x, n, p, [cumulative]) | Calculates the probability of a binomial distribution. |
| BINOM.INV | =BINOM.INV(probability, n, p) | Calculates the inverse of the cumulative distribution function for a binomial distribution. |
| CHISQ.DIST | =CHISQ.DIST(x, deg_freedom, [cumulative]) | Calculates the probability density function for a chi-squared distribution. |
| CHISQ.DIST.RT | =CHISQ.DIST.RT(x, deg_freedom) | Calculates the right-tailed chi-squared distribution. |
| CHISQ.INV | =CHISQ.INV(probability, deg_freedom) | Calculates the inverse of the cumulative distribution function for a chi-squared distribution. |
| CHISQ.INV.RT | =CHISQ.INV.RT(probability, deg_freedom) | Calculates the right-tailed inverse of the cumulative distribution function for a chi-squared distribution. |
| CHISQ.TEST | =CHISQ.TEST(actual_range, expected_range) | Performs a chi-squared test of independence. |
| CONFIDENCE.NORM | =CONFIDENCE.NORM(alpha, stdev, size) | Calculates the confidence interval for a normal distribution. |
| CORREL | =CORREL(array1, array2) | Calculates the correlation coefficient between two data sets. |
| COUNTIF | =COUNTIF(range, criteria) | Counts the number of cells in a range that meet a single condition. |
| COUNTIFS | =COUNTIFS(range1, criteria1, [range2, criteria2, ...]) | Counts the number of cells based on multiple criteria. |
| COVARIANCE.P | =COVARIANCE.P(array1, array2) | Calculates the covariance of two data sets for a population. |
| COVARIANCE.S | =COVARIANCE.S(array1, array2) | Calculates the covariance of two data sets for a sample. |
| DEVSQ | =DEVSQ(number1, number2, ...) | Calculates the sum of the squares of deviations from the mean. |
| F.DIST | =F.DIST(x, deg_freedom1, deg_freedom2, [cumulative]) | Calculates the probability density function for an F-distribution. |
| F.DIST.RT | =F.DIST.RT(x, deg_freedom1, deg_freedom2) | Calculates the right-tailed F-distribution. |
| F.INV | =F.INV(probability, deg_freedom1, deg_freedom2) | Calculates the inverse of the cumulative distribution function for an F-distribution. |
| F.INV.RT | =F.INV.RT(probability, deg_freedom1, deg_freedom2) | Calculates the right-tailed inverse of the cumulative distribution function for an F-distribution. |
| F.TEST | =F.TEST(array1, array2) | Performs an F-test to compare two sample variances. |
| FDIST | =FDIST(x, deg_freedom1, deg_freedom2, [cumulative]) | Calculates the probability density function for an F-distribution. |
| FORECAST | =FORECAST(x, data_y, data_x) | Predicts a future value based on existing data. |
| FREQUENCY | '{=FREQUENCY(data, bins)} | Calculates the frequency distribution of data within specified bins. (Array formula) |
| GAMMADIST | =GAMMADIST(x, alpha, beta, [cumulative]) | Calculates the probability density function for a gamma distribution. |
| GAMMAINV | =GAMMAINV(probability, alpha, beta) | Calculates the inverse of the cumulative distribution function for a gamma distribution. |
| GAMMADIST | =GAMMADIST(x, alpha, beta, [cumulative]) | Calculates the probability density function for a gamma distribution. |
| GAMMAINV | =GAMMAINV(probability, alpha, beta) | Calculates the inverse of the cumulative distribution function for a gamma distribution. |
| GEOMEAN | =GEOMEAN(number1, number2, ...) | Calculates the geometric mean of a set of numbers. |
| HARMEAN | =HARMEAN(number1, number2, ...) | Calculates the harmonic mean of a set of numbers. |
| HYPGEOM.DIST | =HYPGEOM.DIST(x, n, M, N, [cumulative]) | Calculates the probability of a hypergeometric distribution. |
| INTERCEPT | =INTERCEPT(known_y, known_x) | Calculates the y-intercept of a linear regression line. |
| KURT | =KURT(number1, number2, ...) | Calculates the kurtosis of a data set. |
| LARGE | =LARGE(array, k) | Returns the kth largest value in a data set. |
| LINEST | =LINEST(known_y, [known_x], [const], [stats]) | Calculates the statistics for a line that best fits the data. |
| LOGEST | =LOGEST(known_y, [known_x], [const], [stats]) | Calculates the statistics for an exponential curve that best fits the data. |
| LOGNORM.DIST | =LOGNORM.DIST(x, mean, stdev, [cumulative]) | Calculates the probability density function for a log-normal distribution. |
| LOGNORM.INV | =LOGNORM.INV(probability, mean, stdev) | Calculates the inverse of the cumulative distribution function for a log-normal distribution. |
| MAXA | =MAXA(value1, value2, ...) | Returns the highest value in a set of values, including text and logical values. |
| MEDIAN | =MEDIAN(number1, number2, ...) | Calculates the median of a set of numbers. |
| MINA | =MINA(value1, value2, ...) | Returns the lowest value in a set of values, including text and logical values. |
| MODE.MULT | =MODE.MULT(number1, number2, ...) | Returns a vertical array of the most frequently occurring values in a data set. |
| MODE.SNGL | =MODE.SNGL(number1, number2, ...) | Returns the most frequently occurring value in a data set. |
| NEGBINOM.DIST | =NEGBINOM.DIST(k, r, p, [cumulative]) | Calculates the negative binomial distribution. |
| NORM.DIST | =NORM.DIST(x, mean, stdev, [cumulative]) | Calculates the probability density function for a normal distribution. |
| NORM.INV | =NORM.INV(probability, mean, stdev) | Calculates the inverse of the cumulative distribution function for a normal distribution. |
| NORM.S.DIST | =NORM.S.DIST(x, [cumulative]) | Calculates the standard normal cumulative distribution function. |
| NORM.S.INV | =NORM.S.INV(probability) | Calculates the standard normal inverse cumulative distribution function. |
| NORMDIST | =NORMDIST(x, mean, stdev, [cumulative]) | Calculates the probability density function for a normal distribution. |
| NORMINV | =NORMINV(probability, mean, stdev) | Calculates the inverse of the cumulative distribution function for a normal distribution. |
| PEARSON | =PEARSON(array1, array2) | Calculates the Pearson correlation coefficient between two data sets. |
| PERCENTILE.EXC | =PERCENTILE.EXC(array, k) | Calculates the kth percentile of a data set, excluding the median. |
| PERCENTILE.INC | =PERCENTILE.INC(array, k) | Calculates the kth percentile of a data set, including the median. |
| PERCENTRANK.EXC | =PERCENTRANK.EXC(array, x, [significance]) | Calculates the rank of a value in a data set, excluding the median. |
| PERCENTRANK.INC | =PERCENTRANK.INC(array, x, [significance]) | Calculates the rank of a value in a data set, including the median. |
| PERMUT | =PERMUT(n, k) | Calculates the number of permutations for a given set of objects. |
| PERMUTATIONA | =PERMUTATIONA(n, k) | Calculates the number of permutations for a given set of objects, including repetitions. |
| PHI | =PHI(z) | Calculates the value of the standard normal cumulative distribution function. |
| POISSON.DIST | =POISSON.DIST(x, mean, [cumulative]) | Calculates the Poisson distribution. |
| PROB | =PROB(range, probability_range, [lower_limit], [upper_limit]) | Calculates the probability of an outcome in a given range. |
| QUARTILE.EXC | =QUARTILE.EXC(array, quart) | Calculates the quartile for a data set, excluding the median. |
| QUARTILE.INC | =QUARTILE.INC(array, quart) | Calculates the quartile for a data set, including the median. |
| QUARTILE.EXC | =QUARTILE.EXC(array, quart) | Calculates the quartile for a data set, excluding the median. |
| QUARTILE.INC | =QUARTILE.INC(array, quart) | Calculates the quartile for a data set, including the median. |
| RANK | =RANK(number, range, [order]) | Calculates the rank of a number in a list. |
| RSQ | =RSQ(known_y, known_x) | Calculates the coefficient of determination (R-squared) for a linear regression line. |
| SKEW | =SKEW(number1, number2, ...) | Calculates the skewness of a data set. |
| SKEWP | =SKEWP(number1, number2, ...) | Calculates the skewness of a data set. |
| SLOPE | =SLOPE(known_y, known_x) | Calculates the slope of a linear regression line. |
| SMALL | =SMALL(array, k) | Returns the kth smallest value in a data set. |
| STANDARDIZE | =STANDARDIZE(x, mean, stdev) | Converts a value to a standard score (z-score). |
| STDEVP | =STDEVP(number1, number2, ...) | Calculates the standard deviation of a population. |
| STDEV.P | =STDEV.P(number1, number2, ...) | Calculates the standard deviation of a population. |
| STDEVA | =STDEVA(value1, value2, ...) | Calculates the standard deviation of values, including text and logical values. |
| STDEV.PA | =STDEV.PA(value1, value2, ...) | Calculates the standard deviation of values, including text and logical values. |
| STEYX | =STEYX(known_y, known_x) | Calculates the standard error of the predicted y-values in a regression analysis. |
| T.DIST | =T.DIST(x, deg_freedom, [cumulative]) | Calculates the probability density function for a t-distribution. |
| T.DIST.2T | =T.DIST.2T(x, deg_freedom) | Calculates the two-tailed t-distribution. |
| T.DIST.RT | =T.DIST.RT(x, deg_freedom) | Calculates the right-tailed t-distribution. |
| T.INV | =T.INV(probability, deg_freedom) | Calculates the inverse of the cumulative distribution function for a t-distribution. |
| T.INV.2T | =T.INV.2T(probability, deg_freedom) | Calculates the two-tailed inverse of the cumulative distribution function for a t-distribution. |
| T.TEST | =T.TEST(array1, array2, [tails], [type]) | Performs a t-test to determine whether two samples are likely to have come from the same population. |
| TDIST | =TDIST(x, deg_freedom, [tails]) | Calculates the probability density function for a t-distribution. |
| TREND | =TREND(known_y, known_x, [new_x], [const]) | Predicts a y-value based on an existing set of x-values and y-values. |
| TRIMMEAN | =TRIMMEAN(array, percent) | Calculates the mean of a data set after excluding a specified percentage of data points. |
| VAR.P | =VAR.P(number1, number2, ...) | Calculates the variance of a population. |
| VAR.PA | =VAR.PA(value1, value2, ...) | Calculates the variance of values, including text and logical values, for a population. |
| VARP | =VARP(number1, number2, ...) | Calculates the variance of a population. |
| VARPA | =VARPA(value1, value2, ...) | Calculates the variance of values, including text and logical values, for a population. |
| Z.TEST | =Z.TEST(array, [mu], [sigma]) | Performs a z-test to compare a sample mean to a population mean. |
