To get detailed information about a function, click its name in the first column.
Function |
Description |
---|---|
Returns the average of the absolute deviations of data points from their mean |
|
Returns the average of its arguments |
|
Returns the average of its arguments, including numbers, text, and logical values |
|
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria |
|
Returns the average (arithmetic mean) of all cells that meet multiple criteria |
|
Returns the beta cumulative distribution function |
|
Returns the inverse of the cumulative distribution function for a specified beta distribution |
|
Returns the individual term binomial distribution probability |
|
Returns the probability of a trial result using a binomial distribution |
|
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
|
Returns the cumulative beta probability density function |
|
Returns the one-tailed probability of the chi-squared distribution |
|
Returns the cumulative beta probability density function |
|
Returns the inverse of the one-tailed probability of the chi-squared distribution |
|
Returns the test for independence |
|
Returns the confidence interval for a population mean |
|
Returns the confidence interval for a population mean, using a Student's t distribution |
|
Returns the correlation coefficient between two data sets |
|
Counts how many numbers are in the list of arguments |
|
Counts how many values are in the list of arguments |
|
Counts the number of blank cells within a range |
|
Counts the number of cells within a range that meet the given criteria |
|
Counts the number of cells within a range that meet multiple criteria |
|
Returns covariance, the average of the products of paired deviations |
|
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets |
|
Returns the sum of squares of deviations |
|
Returns the exponential distribution |
|
Returns the F probability distribution |
|
Returns the F probability distribution |
|
Returns the inverse of the F probability distribution |
|
Returns the inverse of the F probability distribution |
|
Returns the result of an F-test |
|
Returns the Fisher transformation |
|
Returns the inverse of the Fisher transformation |
|
Returns a value along a linear trend Note: In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it's still available for compatibility with earlier versions. |
|
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm |
|
Returns a confidence interval for the forecast value at the specified target date |
|
Returns the length of the repetitive pattern Excel detects for the specified time series |
|
Returns a statistical value as a result of time series forecasting |
|
Returns a future value based on existing values |
|
Returns a frequency distribution as a vertical array |
|
Returns the gamma function value |
|
Returns the gamma distribution |
|
Returns the inverse of the gamma cumulative distribution |
|
Returns the natural logarithm of the gamma function, Γ(x) |
|
Returns the natural logarithm of the gamma function, Γ(x) |
|
Returns 0.5 less than the standard normal cumulative distribution |
|
Returns the geometric mean |
|
Returns values along an exponential trend |
|
Returns the harmonic mean |
|
Returns the hypergeometric distribution |
|
Returns the intercept of the linear regression line |
|
Returns the kurtosis of a data set |
|
Returns the k-th largest value in a data set |
|
Returns the parameters of a linear trend |
|
Returns the parameters of an exponential trend |
|
Returns the cumulative lognormal distribution |
|
Returns the inverse of the lognormal cumulative distribution |
|
Returns the maximum value in a list of arguments |
|
Returns the maximum value in a list of arguments, including numbers, text, and logical values |
|
Returns the maximum value among cells specified by a given set of conditions or criteria |
|
Returns the median of the given numbers |
|
Returns the minimum value in a list of arguments |
|
Returns the minimum value among cells specified by a given set of conditions or criteria. |
|
Returns the smallest value in a list of arguments, including numbers, text, and logical values |
|
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data |
|
Returns the most common value in a data set |
|
Returns the negative binomial distribution |
|
Returns the normal cumulative distribution |
|
Returns the inverse of the normal cumulative distribution |
|
Returns the standard normal cumulative distribution |
|
Returns the inverse of the standard normal cumulative distribution |
|
Returns the Pearson product moment correlation coefficient |
|
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. |
|
Returns the k-th percentile of values in a range |
|
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set |
|
Returns the percentage rank of a value in a data set |
|
Returns the number of permutations for a given number of objects |
|
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects |
|
Returns the value of the density function for a standard normal distribution |
|
Returns the Poisson distribution |
|
Returns the probability that values in a range are between two limits |
|
Returns the quartile of the data set, based on percentile values from 0..1, exclusive |
|
Returns the quartile of a data set |
|
Returns the rank of a number in a list of numbers |
|
Returns the rank of a number in a list of numbers |
|
Returns the square of the Pearson product moment correlation coefficient |
|
Returns the skewness of a distribution |
|
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean |
|
Returns the slope of the linear regression line |
|
Returns the k-th smallest value in a data set |
|
Returns a normalized value |
|
Calculates standard deviation based on the entire population |
|
Estimates standard deviation based on a sample |
|
Estimates standard deviation based on a sample, including numbers, text, and logical values |
|
Calculates standard deviation based on the entire population, including numbers, text, and logical values |
|
Returns the standard error of the predicted y-value for each x in the regression |
|
Returns the Percentage Points (probability) for the Student t-distribution |
|
Returns the Percentage Points (probability) for the Student t-distribution |
|
Returns the Student's t-distribution |
|
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom |
|
Returns the inverse of the Student's t-distribution |
|
Returns the probability associated with a Student's t-test |
|
Returns values along a linear trend |
|
Returns the mean of the interior of a data set |
|
Calculates variance based on the entire population |
|
Estimates variance based on a sample |
|
Estimates variance based on a sample, including numbers, text, and logical values |
|
Calculates variance based on the entire population, including numbers, text, and logical values |
|
Returns the Weibull distribution |
|
Returns the one-tailed probability-value of a z-test |
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
Related Topics
Excel functions (by category) Excel functions (alphabetical)