Statistical Functions
AVEDEV function
The AVEDEV function analyzes the range of data and returns the average of the absolute deviations of numbers from their mean.
AVERAGE function
The AVERAGE function analyzes the range of data and finds the average value.
AVERAGEA function
The AVERAGEA function analyzes the range of data including text and logical values and finds the average value.
AVERAGEIF function
The AVERAGEIF function finds the average value of all numbers in a range of cells, based on the specified criterion.
AVERAGEIFS function
The AVERAGEIFS function finds the average value of all numbers in a range of cells, based on multiple criteria.
BETADIST function
The BETADIST function returns the cumulative beta probability density function.
BETA.DIST function
The BETA.DIST function returns the beta distribution.
BETA.INV function
The BETA.INV function returns the inverse of the beta cumulative probability density function (BETA.DIST).
BETAINV function
The BETAINV function returns the inverse of the cumulative beta probability density function for a specified beta distribution.
BINOMDIST function
The BINOMDIST function returns the individual term binomial distribution probability.
BINOM.DIST function
The BINOM.DIST function returns the individual term binomial distribution probability.
BINOM.DIST.RANGE function
The BINOM.DIST.RANGE function returns the probability of a trial result using a binomial distribution.
BINOM.INV function
The BINOM.INV function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
CHIDIST function
The CHIDIST function returns the right-tailed probability of the chi-squared distribution.
CHIINV function
The CHIINV function returns the inverse of the right-tailed probability of the chi-squared distribution.
CHISQ.DIST function
The CHISQ.DIST function returns the chi-squared distribution.
CHISQ.DIST.RT function
The CHISQ.DIST.RT function returns the right-tailed probability of the chi-squared distribution.
CHISQ.INV function
The CHISQ.INV function returns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.INV.RT function
The CHISQ.INV.RT function returns the inverse of the right-tailed probability of the chi-squared distribution.
CHITEST function
The CHITEST function returns the test for independence, the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.
CHISQ.TEST function
The CHISQ.TEST function returns the test for independence, the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.
CONFIDENCE function
The CONFIDENCE function returns the confidence interval.
CONFIDENCE.NORM function
The CONFIDENCE.NORM function returns the confidence interval for a population mean, using a normal distribution.
CONFIDENCE.T function
The CONFIDENCE.T function returns the confidence interval for a population mean, using a Student's t distribution.
CORREL function
The CORREL function returns the correlation coefficient of two ranges of cells.
COUNT function
The COUNT function counts the number of selected cells that contain numbers.
COUNTA function
The COUNTA function counts the number of cells in a range that are not empty.
COUNTBLANK function
The COUNTBLANK function returns the number of empty cells in a range.
COUNTIF function
The COUNTIF function counts the number of selected cells that meet the specified criterion.
COUNTIFS function
The COUNTIFS function counts the number of selected cells that meet multiple criteria.
COVAR function
The COVAR function returns the covariance of two ranges of data.
COVARIANCE.P function
The COVARIANCE.P function returns the population covariance of two data sets.
COVARIANCE.S function
The COVARIANCE.S function returns the sample covariance of two data sets.
CRITBINOM function
The CRITBINOM function returns the smallest value for which the cumulative binomial distribution is greater than or equal to the specified alpha value.
DEVSQ function
The DEVSQ function returns the sum of the squares of the deviations of numbers from their mean.
EXPON.DIST function
The EXPON.DIST function returns the exponential distribution.
EXPONDIST function
The EXPONDIST function returns the exponential distribution.
F.DIST function
The F.DIST function returns the F probability distribution, which can be used to determine whether two data sets have different degrees of diversity.
FDIST function
The FDIST function returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.
F.DIST.RT function
The F.DIST.RT function returns the (right-tailed) F probability distribution (degree of diversity) for two data sets.
F.INV function
The F.INV function returns the inverse of the (right-tailed) F probability distribution.
FINV function
The FINV function returns the inverse of the (right-tailed) F probability distribution.
F.INV.RT function
The F.INV.RT function returns the inverse of the (right-tailed) F probability distribution.
FISHER function
The FISHER function returns the Fisher transformation of a number.
FISHERINV function
The FISHERINV function performs the inverse of the Fisher transformation.
FORECAST function
The FORECAST function predicts a future value based on existing values provided.
FORECAST.ETS function
The FORECAST.ETS function calculates or predicts a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.
FORECAST.ETS.CONFINT function
The FORECAST.ETS.CONFINT function returns a confidence interval for the forecast value at the specified target date.
FORECAST.ETS.SEASONALITY function
The FORECAST.ETS.SEASONALITY function returns the length of the repetitive pattern the application detects for the specified time series.
FORECAST.ETS.STAT function
The FORECAST.ETS.STAT function returns a statistical value as a result of time series forecasting.
FORECAST.LINEAR Function
The FORECAST.LINEAR function calculates, or predicts, a future value by using existing values and linear regression.
FREQUENCY function
The FREQUENCY function calculates how often values occur within the selected range of cells and displays the first value of the returned vertical array of numbers.
FTEST function
The FTEST function returns the result of an F-test, the two-tailed probability that the variances in two arrays are not significantly different.
F.TEST function
The F.TEST function returns the result of an F-test, the two-tailed probability that the variances in two arrays are not significantly different.
GAMMA function
The GAMMA function returns the gamma function value.
GAMMA.DIST function
The GAMMA.DIST function returns the gamma distribution.
GAMMADIST function
The GAMMADIST function returns the gamma distribution.
GAMMA.INV function
The GAMMA.INV function returns the inverse of the gamma cumulative distribution.
GAMMAINV function
The GAMMAINV function returns the inverse of the gamma cumulative distribution.
GAMMALN function
The GAMMALN function returns the natural logarithm of the gamma function.
GAMMALN.PRECISE function
The GAMMALN.PRECISE function returns the natural logarithm of the gamma function.
GAUSS function
The GAUSS function calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean.
GEOMEAN function
The GEOMEAN function calculates the geometric mean of the argument list.
GROWTH function
The GROWTH function calculates predicted exponential growth by using existing data.
HARMEAN function
The HARMEAN function calculates the harmonic mean of the argument list.
HYPGEOMDIST function
The HYPGEOMDIST function returns the hypergeometric distribution, the probability of a given number of sample successes, given the sample size, population successes, and population size.
HYPGEOM.DIST function
The HYPGEOM.DIST function returns the hypergeometric distribution, the probability of a given number of sample successes, given the sample size, population successes, and population size.
INTERCEPT function
The INTERCEPT function analyzes the first array values and second array values to calculate the intersection point.
KURT function
The KURT function returns the kurtosis of the argument list.
LARGE function
The LARGE function analyzes the range of cells and returns the k-th largest value.
LINEST function
The LINEST function calculates the statistics for a line by using the least squares method and returns an array that describes the line.
LOGEST function
The LOGEST function calculates an exponential curve that fits the data and returns an array of values that describes the curve.
LOGINV function
The LOGINV function returns the inverse of the lognormal cumulative distribution function of the given x value with the specified parameters.
LOGNORM.DIST Function
The LOGNORM.DIST function returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.
LOGNORM.INV function
The LOGNORM.INV function returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev.
LOGNORMDIST Function
The LOGNORMDIST function analyzes logarithmically transformed data and returns the lognormal cumulative distribution function of the given x value with the specified parameters.
MAX function
The MAX function analyzes the range of data and finds the largest number.
MAXA function
The MAXA function analyzes the range of data and finds the largest value.
MAXIFS function
The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria.
MEDIAN function
The MEDIAN function calculates the median of the argument list.
MIN function
The MIN function analyzes the range of data and finds the smallest number.
MINA function
The MINA function analyzes the range of data and finds the smallest value.
MINIFS function
The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.
MODE function
The MODE function analyzes the range of data and returns the most frequently occurring value.
MODE.MULT function
The MODE.MULT function returns the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGL function
The MODE.SNGL function returns the most frequently occurring, or repetitive, value in an array or range of data.
NEGBINOMDIST function
The NEGBINOMDIST function returns the negative binomial distribution.
NEGBINOM.DIST function
The NEGBINOM.DIST function returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success.
NORMDIST function
The NORMDIST function returns the normal distribution for the specified mean and standard deviation.
NORM.DIST function
The NORM.DIST function returns the normal distribution for the specified mean and standard deviation.
NORMINV function
The NORMINV function returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORM.INV function
The NORM.INV function returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORMSDIST function
The NORMSDIST function returns the standard normal cumulative distribution function.
NORM.S.DIST function
The NORM.S.DIST function returns the standard normal distribution (has a mean of zero and a standard deviation of one).
NORMSINV function
The NORMSINV function returns the inverse of the standard normal cumulative distribution.
NORM.S.INV function
The NORM.S.INV function returns the inverse of the standard normal cumulative distribution, which has a mean of zero and a standard deviation of one.
PEARSON function
The PEARSON function returns the Pearson product moment correlation coefficient.
PERCENTILE function
The PERCENTILE function analyzes the range of data and returns the k-th percentile.
PERCENTILE.EXC function
The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INC function
The PERCENTILE.INC function returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
PERCENTRANK function
The PERCENTRANK function returns the rank of a value in a set of values as a percentage of the set.
PERCENTRANK.EXC function
The PERCENTRANK.EXC function returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INC function
The PERCENTRANK.INC function returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.
PERMUT function
The PERMUT function returns the number of permutations for a specified number of items.
PERMUTATIONA function
The PERMUTATIONA function returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.
PHI function
The PHI function returns the value of the density function for a standard normal distribution.
POISSON function
The POISSON function returns the Poisson distribution.
POISSON.DIST function
The POISSON.DIST function returns the Poisson distribution, commonly used to predict the number of events over a specific time.
PROB function
The PROB function returns the probability that values in a range are between lower and upper limits.
QUARTILE function
The QUARTILE function analyzes the range of data and returns the quartile.
QUARTILE.EXC function
The QUARTILE.EXC function returns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INC function
The QUARTILE.INC function returns the quartile of the data set, based on percentile values from 0..1, inclusive.
RANK function
The RANK function returns the rank of a number in a list of numbers.
RANK.AVG function
The RANK.AVG function returns the rank of a number in a list of numbers, and the average rank if more than one value has the same rank.
RANK.EQ function
The RANK.EQ function returns the rank of a number in a list of numbers, and the top rank of a set of values if more than one value has the same rank.
RSQ function
The RSQ function returns the square of the Pearson product moment correlation coefficient.
SKEW function
The SKEW function analyzes the range of data and returns the skewness of a distribution of the argument list.
SKEW.P function
The SKEW.P function returns the skewness of a distribution based on a population.
SLOPE function
The SLOPE function returns the slope of the linear regression line through data in two arrays.
SMALL function
The SMALL function analyzes the range of data and finds the k-th smallest value.
STANDARDIZE function
The STANDARDIZE function returns a normalized value from a distribution characterized by the specified parameters.
STDEV function
The STDEV function analyzes the range of data and returns the standard deviation of a population based on a set of numbers.
STDEV.S function
The STDEV.S function estimates standard deviation based on a sample, ignoring logical values and text in the sample.
STDEVA function
The STDEVA function analyzes the range of data and returns the standard deviation of a population based on a set of numbers, text, and logical values.
STDEVP function
The STDEVP function analyzes the range of data and returns the standard deviation of an entire population.
STDEV.P function
The STDEV.P function calculates standard deviation based on the entire population given as arguments, ignoring logical values and text.
STDEVPA function
The STDEVPA function analyzes the range of data and returns the standard deviation of an entire population.
STEYX function
The STEYX function returns the standard error of the predicted y-value for each x in the regression line.
TDIST function
The TDIST function returns the Percentage Points (probability) for the Student t-distribution.
T.DIST function
The T.DIST function returns the Student's left-tailed t-distribution.
T.DIST.2T function
The T.DIST.2T function returns the two-tailed Student's t-distribution.
T.DIST.RT function
The T.DIST.RT function returns the right-tailed Student's t-distribution.
T.INV function
Returns the left-tailed inverse of the Student's t-distribution.
T.INV.2T function
Returns the two-tailed inverse of the Student's t-distribution.
TINV function
Returns the two-tailed inverse of the Student's t-distribution.
TREND function
Calculates a linear trend line and returns values along it using the method of least squares.
TRIMMEAN function
Returns the mean of the interior of a data set by excluding a percentage of data points from its top and bottom tails.
TTEST function
Returns the probability associated with a Student's t-Test.
T.TEST function
Returns the probability associated with a Student's t-Test.
VAR function
Analyzes the set of values and calculates the sample variance.
VARA function
Analyzes the set of values and calculates the sample variance.
VARP function
Analyzes the set of values and calculates the variance of an entire population.
VAR.P function
Calculates variance based on the entire population, ignoring logical values and text in the population.
VAR.S function
Estimates variance based on a sample, ignoring logical values and text in the sample.
VARPA function
The VARPA function analyzes the set of values and returns the variance of an entire population.
WEIBULL function
The WEIBULL function returns the Weibull distribution, used in reliability analysis such as calculating a device's mean time to failure.
WEIBULL.DIST function
The WEIBULL.DIST function returns the Weibull distribution, used in reliability analysis such as calculating a device's mean time to failure.
ZTEST function
The ZTEST function returns the one-tailed probability-value of a z-test.
Z.TEST function
The Z.TEST function returns the one-tailed P-value of a z-test.