Statistical functions
| English | 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 its arguments, including numbers, 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 a trial result 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 cumulative beta probability density function |
| CHISQ.DIST.RT | Returns the one-tailed probability of the chi-squared distribution |
| CHISQ.INV | Returns the cumulative beta probability density function |
| CHISQ.INV.RT | Returns the inverse of the one-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 how many numbers are in the list of arguments |
| COUNTA | Counts how many values are in the list of arguments |
| COUNTBLANK | Counts the number of blank cells within a range |
| COUNTIF | Counts the number of cells within a range that meet the 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 |
| DEVSQ | Returns the sum of squares of deviations |
| EXPON.DIST | Returns the exponential distribution |
| F.DIST | Returns the F probability distribution |
| F.DIST.RT | Returns the F probability distribution |
| F.INV | Returns the inverse of the F probability distribution |
| F.INV.RT | Returns the inverse of the F probability distribution |
| F.TEST | Returns the result of an F-test |
| FINV | Returns the inverse of the F probability distribution |
| FISHER | Returns the Fisher transformation |
| FISHERINV | Returns the inverse of the Fisher transformation |
| FORECAST | Returns a value along a linear trend |
| FORECAST.ETS | Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm |
| FORECAST.ETS.CONFINT | Returns a confidence interval for the forecast value at the specified target date |
| FORECAST.ETS.SEASONALITY | Returns the length of the repetitive pattern Excel detects for the specified time series |
| FORECAST.ETS.STAT | Returns a statistical value as a result of time series forecasting |
| FORECAST.LINEAR | Returns a future value based on existing values |
| FREQUENCY | Returns a frequency distribution as a vertical array |
| GAMMA | Returns the Gamma function value |
| 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, Γ(x) |
| GAMMALN.PRECISE | Returns the natural logarithm of the gamma function, Γ(x) |
| GAUSS | Returns 05 less than the standard normal cumulative distribution |
| GEOMEAN | Returns the geometric mean |
| GROWTH | Returns values along an exponential trend |
| HARMEAN | Returns the harmonic mean |
| HYPGEOM.DIST | Returns the hypergeometric distribution |
| INTERCEPT | Returns the intercept of the linear regression line |
| KURT | Returns the kurtosis of a data set |
| LARGE | Returns the k-th largest value in a data set |
| LINEST | Returns the parameters of a linear trend |
| LOGEST | Returns the parameters of an exponential trend |
| LOGNORM.DIST | Returns the cumulative lognormal distribution |
| LOGNORM.INV | Returns the inverse of the lognormal cumulative distribution |
| MAX | Returns the maximum value in a list of arguments |
| MAXA | Returns the maximum value in a list of arguments, including numbers, text, and logical values |
| MAXIFS | Returns the maximum value among cells specified by a given set of conditions or criteria |
| MEDIAN | Returns the median of the given numbers |
| MIN | Returns the minimum value in a list of arguments |
| MINA | Returns the smallest value in a list of arguments, including numbers, text, and logical values |
| MINIFS | Returns the minimum value among cells specified by a given set of conditions or criteria |
| 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.S.DIST | Returns the standard normal cumulative distribution |
| NORM.S.INV | Returns the inverse of the standard normal cumulative distribution |
| NORMINV | Returns the inverse of the normal cumulative distribution |
| PEARSON | Returns the Pearson product moment correlation coefficient |
| PERCENTILE.EXC | Returns the k-th percentile of values in a range, where k is in the range 01, 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 (01, 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 |
| PERMUTATIONA | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
| PHI | Returns the value of the density function for a standard normal distribution |
| POISSON.DIST | Returns the Poisson distribution |
| PROB | Returns the probability that values in a range are between two limits |
| QUARTILE.EXC | Returns the quartile of the data set, based on percentile values from 01, 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 square of the Pearson product moment correlation coefficient |
| SKEW | Returns the skewness of a distribution |
| SKEW.P | Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean |
| SLOPE | Returns the slope of the linear regression line |
| SMALL | Returns the k-th smallest value in a data set |
| STANDARDIZE | Returns a normalized value |
| 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, including numbers, text, and logical values |
| STDEVPA | Calculates standard deviation based on the entire population, including numbers, 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 values along a linear trend |
| 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 | Estimates variance based on a sample, including numbers, text, and logical values |
| VARPA | Calculates variance based on the entire population, including numbers, text, and logical values |
| WEIBULL.DIST | Returns the Weibull distribution |
| Z.TEST | Returns the one-tailed probability-value of a z-test |