﻿ Statistical functions (reference)

# 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 Note   This function isn't available in Excel 2016 for Mac. Returns a confidence interval for the forecast value at the specified target date Note   This function isn't available in Excel 2016 for Mac. Returns the length of the repetitive pattern Excel detects for the specified time series Note   This function isn't available in Excel 2016 for Mac. Returns a statistical value as a result of time series forecasting Note   This function isn't available in Excel 2016 for Mac. Returns a future value based on existing values Note   This function isn't available in Excel 2016 for Mac. 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 median of the given numbers Returns the minimum value in a list of arguments 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.

Applies To: Excel 2010, Excel 2013, Excel Online, Excel Starter, Excel 2016 for Mac, Excel 2007, Excel 2016 Preview, Excel for Mac 2011

﻿