Statistical functions (reference)
To get detailed information about a function, click its name in the first column.
Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.
| 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)
No comments:
Post a Comment