Statistical functions (reference)

In Excel 2010, several statistical functions have been implemented with new algorithms for improved accuracy.
Read a blog post or try Office 365!

Click one of the links in the following list to see detailed help about the function.

Function

Description

AVEDEV

Returns the average of the absolute deviations of data points from their mean

AVERAGE

Returns the average of its arguments

AVERAGEA

Returns the average of its arguments, including numbers, text, and logical values

AVERAGEIF

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

AVERAGEIFS

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

BETADIST

Returns the beta cumulative distribution function

BETAINV

Returns the inverse of the cumulative distribution function for a specified beta distribution

BINOMDIST

Returns the individual term binomial distribution probability

CHIDIST

Returns the one-tailed probability of the chi-squared distribution

CHIINV

Returns the inverse of the one-tailed probability of the chi-squared distribution

CHITEST

Returns the test for independence

CONFIDENCE

Returns the confidence interval for a population mean

CORREL

Returns the correlation coefficient between two data sets

COUNT

Counts how many numbers are in the list of arguments

COUNTA

Counts how many values are in the list of arguments

COUNTBLANK

Counts the number of blank cells within a range

COUNTIF

Counts the number of cells within a range that meet the given criteria

COUNTIFS

Counts the number of cells within a range that meet multiple criteria

COVAR

Returns covariance, the average of the products of paired deviations

CRITBINOM

Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value

DEVSQ

Returns the sum of squares of deviations

EXPONDIST

Returns the exponential distribution

FDIST

Returns the F probability distribution

FINV

Returns the inverse of the F probability distribution

FISHER

Returns the Fisher transformation

FISHERINV

Returns the inverse of the Fisher transformation

FORECAST

Returns a value along a linear trend

FREQUENCY

Returns a frequency distribution as a vertical array

FTEST

Returns the result of an F-test

GAMMADIST

Returns the gamma distribution

GAMMAINV

Returns the inverse of the gamma cumulative distribution

GAMMALN

Returns the natural logarithm of the gamma function, Γ(x)

GEOMEAN

Returns the geometric mean

GROWTH

Returns values along an exponential trend

HARMEAN

Returns the harmonic mean

HYPGEOMDIST

Returns the hypergeometric distribution

INTERCEPT

Returns the intercept of the linear regression line

KURT

Returns the kurtosis of a data set

LARGE

Returns the k-th largest value in a data set

LINEST

Returns the parameters of a linear trend

LOGEST

Returns the parameters of an exponential trend

LOGINV

Returns the inverse of the lognormal distribution

LOGNORMDIST

Returns the cumulative lognormal distribution

MAX

Returns the maximum value in a list of arguments

MAXA

Returns the maximum value in a list of arguments, including numbers, text, and logical values

MEDIAN

Returns the median of the given numbers

MIN

Returns the minimum value in a list of arguments

MINA

Returns the smallest value in a list of arguments, including numbers, text, and logical values

MODE

Returns the most common value in a data set

NEGBINOMDIST

Returns the negative binomial distribution

NORMDIST

Returns the normal cumulative distribution

NORMINV

Returns the inverse of the normal cumulative distribution

NORMSDIST

Returns the standard normal cumulative distribution

NORMSINV

Returns the inverse of the standard normal cumulative distribution

PEARSON

Returns the Pearson product moment correlation coefficient

PERCENTILE

Returns the k-th percentile of values in a range

PERCENTRANK

Returns the percentage rank of a value in a data set

PERMUT

Returns the number of permutations for a given number of objects

POISSON

Returns the Poisson distribution

PROB

Returns the probability that values in a range are between two limits

QUARTILE

Returns the quartile of a data set

RANK

Returns the rank of a number in a list of numbers

RSQ

Returns the square of the Pearson product moment correlation coefficient

SKEW

Returns the skewness of a distribution

SLOPE

Returns the slope of the linear regression line

SMALL

Returns the k-th smallest value in a data set

STANDARDIZE

Returns a normalized value

STDEV

Estimates standard deviation based on a sample

STDEVA

Estimates standard deviation based on a sample, including numbers, text, and logical values

STDEVP

Calculates standard deviation based on the entire population

STDEVPA

Calculates standard deviation based on the entire population, including numbers, text, and logical values

STEYX

Returns the standard error of the predicted y-value for each x in the regression

TDIST

Returns the Student's t-distribution

TINV

Returns the inverse of the Student's t-distribution

TREND

Returns values along a linear trend

TRIMMEAN

Returns the mean of the interior of a data set

TTEST

Returns the probability associated with a Student's t-test

VAR

Estimates variance based on a sample

VARA

Estimates variance based on a sample, including numbers, text, and logical values

VARP

Calculates variance based on the entire population

VARPA

Calculates variance based on the entire population, including numbers, text, and logical values

WEIBULL

Returns the Weibull distribution

ZTEST

Returns the one-tailed probability-value of a z-test

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language