A quick guide to Statistical Functions (reference)

person writing on notebook

  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

This post offers you a quick guide to statistical functions for your reference. You will learn all about the statistical functions with a description of each of them. For more details about any statistical function, select its name in the first column.

Note: Version markers represent the version of Excel a function was launched. These functions are absent from earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.

Various forms of statistical presentation - symbolise statistical functions.
Image by janjf93 from Pixabay.

Statistical Functions Table

FunctionDescription
AVEDEV functionYields the average of the absolute deviations of data points from their mean.
AVERAGE functionCaptures the average of its arguments.
AVERAGEA functionReturns the average of its arguments, comprising numbers, text, and logical values.
AVERAGEIF functionReturns the average (arithmetic mean) of all the cells in a range that meet a specific criteria.
AVERAGEIFS functionReturns the average (arithmetic mean) of all cells that satisfy several criteria.
BETA.DIST function
Excel 2010
Obtains the beta cumulative distribution function.
BETA.INV function
Excel 2010
Returns the inverse of the cumulative distribution function for a defined beta distribution.
BINOM.DIST function
Excel 2010
Returns the individual term binomial distribution probability.
BINOM.DIST.RANGE function
Excel 2013
Returns the probability of a trial result applying a binomial distribution.
BINOM.INV function
Excel 2010
Returns the smallest value for which the cumulative binomial distribution is under or equal to a criterion value.
CHISQ.DIST function
Excel 2010
Returns the cumulative beta probability density function.
CHISQ.DIST.RT function
Excel 2010
Returns the one-tailed probability of the chi-squared distribution.
CHISQ.INV function
Excel 2010
Returns the cumulative beta probability density function.
CHISQ.INV.RT function
Excel 2010
Returns the inverse of the one-tailed probability of the chi-squared distribution.
CHISQ.TEST function
Excel 2010
Returns the test for independence.
CONFIDENCE.NORM function
Excel 2010
Returns the confidence interval for a population mean.
CONFIDENCE.T function
Excel 2010
Returns the confidence interval for a population mean, using a Student’s t distribution.
CORREL functionReturns the correlation coefficient between two data sets.
COUNT functionCounts how many numbers are in the list of arguments.
COUNTA functionCounts how many values are in the list of arguments.
COUNTBLANK functionCounts the number of blank cells within a range.
COUNTIF functionCounts the number of cells within a range that meet the given criteria.
COUNTIFS functionCounts the number of cells within a range that meet multiple criteria.
COVARIANCE.P function
Excel 2010
Returns covariance, the average of the products of paired deviations.
COVARIANCE.S function
Excel 2010
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets.
DEVSQ functionReturns the sum of squares of deviations.
EXPON.DIST function
Excel 2010
Returns the exponential distribution.
F.DIST function
Excel 2010
Returns the F probability distribution.
F.DIST.RT function
Excel 2010
Returns the F probability distribution.
F.INV function
Excel 2010
Returns the inverse of the F probability distribution.
F.INV.RT function
Excel 2010
Returns the inverse of the F probability distribution
F.TEST function
Excel 2010
Returns the result of an F-test.
FISHER functionReturns the Fisher transformation.
FISHERINV functionReturns the inverse of the Fisher transformation.
FORECAST functionReturns 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.
FORECAST.ETS function
Excel 2016
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.
FORECAST.ETS.CONFINT function
Excel 2016
Returns a confidence interval for the forecast value at the specified target date.
FORECAST.ETS.SEASONALITY function
Excel 2016
Returns the length of the repetitive pattern Excel detects for the specified time series.
FORECAST.ETS.STAT function
Excel 2016
Returns a statistical value as a result of time series forecasting.
FORECAST.LINEAR function
Excel 2016
Returns a future value based on existing values.
FREQUENCY functionReturns a frequency distribution as a vertical array.
GAMMA function
Excel 2013
Returns the gamma function value.
GAMMA.DIST function
Excel 2010
Returns the gamma distribution.
GAMMA.INV function
Excel 2010
Returns the inverse of the gamma cumulative distribution.
GAMMALN functionReturns the natural logarithm of the gamma function, Γ(x).
GAMMALN.PRECISE function
Excel 2010
Returns the natural logarithm of the gamma function, Γ(x).
GAUSS function
Excel 2013
Returns 0.5 less than the standard normal cumulative distribution.
GEOMEAN functionReturns the geometric mean.
GROWTH functionReturns values along an exponential trend.
HARMEAN functionReturns the harmonic mean.
HYPGEOM.DIST functionReturns the hypergeometric distribution.
INTERCEPT functionReturns the intercept of the linear regression line.
KURT functionReturns the kurtosis of a data set.
LARGE functionReturns the k-th largest value in a data set.
LINEST functionReturns the parameters of a linear trend.
LOGEST functionReturns the parameters of an exponential trend.
LOGNORM.DIST function
Excel 2010
Returns the cumulative lognormal distribution.
LOGNORM.INV function
Excel 2010
Returns the inverse of the lognormal cumulative distribution.
MAX functionReturns the maximum value in a list of arguments.
MAXA functionReturns the maximum value in a list of arguments, including numbers, text, and logical values.
MAXIFS function
Excel 2016
Returns the maximum value among cells specified by a given set of conditions or criteria.
MEDIAN functionReturns the median of the given numbers.
MIN functionReturns the minimum value in a list of arguments.
MINIFS function
Excel 2016
Returns the minimum value among cells specified by a given set of conditions or criteria.
MINA functionReturns the smallest value in a list of arguments, including numbers, text, and logical values.
MODE.MULT function
Excel 2010
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGL function
Excel 2010
Returns the most common value in a data set.
NEGBINOM.DIST function
Excel 2010
Returns the negative binomial distribution.
NORM.DIST function
Excel 2010
Returns the normal cumulative distribution.
NORM.INV function
Excel 2010
Returns the inverse of the normal cumulative distribution.
NORM.S.DIST function
Excel 2010
Returns the standard normal cumulative distribution.
NORM.S.INV function
Excel 2010
Returns the inverse of the standard normal cumulative distribution.
PEARSON functionReturns the Pearson product moment correlation coefficient.
PERCENTILE.EXC function
Excel 2010
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INC function
Excel 2010
Returns the k-th percentile of values in a range.
PERCENTRANK.EXC function
Excel 2010
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INC function
Excel 2010
Returns the percentage rank of a value in a data set.
PERMUT functionReturns the number of permutations for a given number of objects
PERMUTATIONA function
Excel 2013
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.
PHI function
Excel 2013
Returns the value of the density function for a standard normal distribution.
POISSON.DIST function
Excel 2010
Returns the Poisson distribution.
PROB functionReturns the probability that values in a range are between two limits.
QUARTILE.EXC function
Excel 2010
Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INC function
Excel 2010
Returns the quartile of a data set.
RANK.AVG function
Excel 2010
Returns the rank of a number in a list of numbers.
RANK.EQ function
Excel 2010
Returns the rank of a number in a list of numbers.
RSQ functionReturns the square of the Pearson product moment correlation coefficient.
SKEW functionReturns the skewness of a distribution.
SKEW.P function
Excel 2013
Returns the skewness of a distribution based on a population: a characterisation of the degree of asymmetry of a distribution around its mean.
SLOPE functionReturns the slope of the linear regression line.
SMALL functionReturns the k-th smallest value in a data set.
STANDARDISE functionReturns a normalised value.
STDEV.P function
Excel 2010
Calculates standard deviation based on the entire population.
STDEV.S function
Excel 2010
Estimates standard deviation based on a sample.
STDEVA functionEstimates standard deviation based on a sample, including numbers, text, and logical values.
STDEVPA functionCalculates standard deviation based on the entire population, including numbers, text, and logical values.
STEYX functionReturns the standard error of the predicted y-value for each x in the regression.
T.DIST function
Excel 2010
Returns the Percentage Points (probability) for the Student t-distribution.
T.DIST.2T function
Excel 2010
Returns the Percentage Points (probability) for the Student t-distribution.
T.DIST.RT function
Excel 2010
Returns the Student’s t-distribution.
T.INV function
Excel 2010
Returns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom.
T.INV.2T function
Excel 2010
Returns the inverse of the Student’s t-distribution.
T.TEST function
Excel 2010
Returns the probability associated with a Student’s t-test.
TREND functionReturns values along a linear trend.
TRIMMEAN functionReturns the mean of the interior of a data set.
VAR.P function
Excel 2010
Calculates variance based on the entire population.
VAR.S function
Excel 2010
Estimates variance based on a sample.
VARA functionEstimates variance based on a sample, including numbers, text, and logical values.
VARPA functionCalculates variance based on the entire population, including numbers, text, and logical values.
WEIBULL.DIST function
Excel 2010
Returns the Weibull distribution.
Z.TEST function
Excel 2010
Returns the one-tailed probability-value of a z-test.

Important: The calculated results of formulas and some Excel worksheet functions might vary to a small degree 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)

Leave a Reply

%d bloggers like this: