Statistical functions (reference)

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

Function Description
AVEDEV function Returns the average of the absolute deviations of data points from their mean
AVERAGE function Returns the average of its arguments
AVERAGEA function Returns the average of its arguments, including numbers, text, and logical values
AVERAGEIF function Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS function Returns the average (arithmetic mean) of all cells that meet multiple criteria
BETA.DIST function Returns the beta cumulative distribution function
BETA.INV function Returns the inverse of the cumulative distribution function for a specified beta distribution
BINOM.DIST function Returns the individual term binomial distribution probability
BINOM.INV function Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
CHISQ.DIST function Returns the cumulative beta probability density function
CHISQ.DIST.RT function Returns the one-tailed probability of the chi-squared distribution
CHISQ.INV function Returns the cumulative beta probability density function
CHISQ.INV.RT function Returns the inverse of the one-tailed probability of the chi-squared distribution
CHISQ.TEST function Returns the test for independence
CONFIDENCE.NORM function Returns the confidence interval for a population mean
CONFIDENCE.T function Returns the confidence interval for a population mean, using a Student's t distribution
CORREL function Returns the correlation coefficient between two data sets
COUNT function Counts how many numbers are in the list of arguments
COUNTA function Counts how many values are in the list of arguments
COUNTBLANK function Counts the number of blank cells within a range
COUNTIF function Counts the number of cells within a range that meet the given criteria
COUNTIFS function Counts the number of cells within a range that meet multiple criteria
COVARIANCE.P function Returns covariance, the average of the products of paired deviations
COVARIANCE.S function Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
DEVSQ function Returns the sum of squares of deviations
EXPON.DIST function Returns the exponential distribution
F.DIST function Returns the F probability distribution
F.DIST.RT function Returns the F probability distribution
F.INV function Returns the inverse of the F probability distribution
F.INV.RT function Returns the inverse of the F probability distribution
F.TEST function Returns the result of an F-test
FISHER function Returns the Fisher transformation
FISHERINV function Returns the inverse of the Fisher transformation
FORECAST function Returns a value along a linear trend
FREQUENCY function Returns a frequency distribution as a vertical array
GAMMA.DIST function Returns the gamma distribution
GAMMA.INV function Returns the inverse of the gamma cumulative distribution
GAMMALN function Returns the natural logarithm of the gamma function, Γ(x)
GAMMALN.PRECISE function Returns the natural logarithm of the gamma function, Γ(x)
GEOMEAN function Returns the geometric mean
GROWTH function Returns values along an exponential trend
HARMEAN function Returns the harmonic mean
HYPGEOM.DIST function Returns the hypergeometric distribution
INTERCEPT function Returns the intercept of the linear regression line
KURT function Returns the kurtosis of a data set
LARGE function Returns the k-th largest value in a data set
LINEST function Returns the parameters of a linear trend
LOGEST function Returns the parameters of an exponential trend
LOGNORM.DIST function Returns the cumulative lognormal distribution
LOGNORM.INV function Returns the inverse of the lognormal cumulative distribution
MAX function Returns the maximum value in a list of arguments
MAXA function Returns the maximum value in a list of arguments, including numbers, text, and logical values
MEDIAN function Returns the median of the given numbers
MIN function Returns the minimum value in a list of arguments
MINA function Returns the smallest value in a list of arguments, including numbers, text, and logical values
MODE.MULT function Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
MODE.SNGL function Returns the most common value in a data set
NEGBINOM.DIST function Returns the negative binomial distribution
NORM.DIST function Returns the normal cumulative distribution
NORM.INV function Returns the inverse of the normal cumulative distribution
NORM.S.DIST function Returns the standard normal cumulative distribution
NORM.S.INV function Returns the inverse of the standard normal cumulative distribution
PEARSON function Returns the Pearson product moment correlation coefficient
PERCENTILE.EXC function Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INC function Returns the k-th percentile of values in a range
PERCENTRANK.EXC function Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
PERCENTRANK.INC function Returns the percentage rank of a value in a data set
PERMUT function Returns the number of permutations for a given number of objects
POISSON.DIST function Returns the Poisson distribution
PROB function Returns the probability that values in a range are between two limits
QUARTILE.EXC function Returns the quartile of the data set, based on percentile values from 0..1, exclusive
QUARTILE.INC function Returns the quartile of a data set
RANK.AVG function Returns the rank of a number in a list of numbers
RANK.EQ function Returns the rank of a number in a list of numbers
RSQ function Returns the square of the Pearson product moment correlation coefficient
SKEW function Returns the skewness of a distribution
SLOPE function Returns the slope of the linear regression line
SMALL function Returns the k-th smallest value in a data set
STANDARDIZE function Returns a normalized value
STDEV.P function Calculates standard deviation based on the entire population
STDEV.S function Estimates standard deviation based on a sample
STDEVA function Estimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPA function Calculates standard deviation based on the entire population, including numbers, text, and logical values
STEYX function Returns the standard error of the predicted y-value for each x in the regression
T.DIST function Returns the Percentage Points (probability) for the Student t-distribution
T.DIST.2T function Returns the Percentage Points (probability) for the Student t-distribution
T.DIST.RT function Returns the Student's t-distribution
T.INV function 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 Returns the inverse of the Student's t-distribution
TREND function Returns values along a linear trend
TRIMMEAN function Returns the mean of the interior of a data set
T.TEST function Returns the probability associated with a Student's t-test
VAR.P function Calculates variance based on the entire population
VAR.S function Estimates variance based on a sample
VARA function Estimates variance based on a sample, including numbers, text, and logical values
VARPA function Calculates variance based on the entire population, including numbers, text, and logical values
WEIBULL.DIST function Returns the Weibull distribution
Z.TEST function Returns the one-tailed probability-value of a z-test
 
 
Applies to:
Excel 2010, Excel Web App, SharePoint Online for enterprises, SharePoint Online for professionals and small businesses