Statistical functions

The following table lists statistical functions.

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.
BINOMDIST	Returns the individual term binomial distribution probability.
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.
COUNTIF	Counts the number of nonblank cells within a range that meet the given criteria.
COVAR	Returns covariance, the average of the products of paired deviations.
DEVSQ	Returns the sum of squares of deviations.
EXPONDIST	Returns the exponential distribution.
FISHER	Returns the Fisher transformation.
FISHERINV	Returns the inverse of the Fisher transformation.
FORECAST	Returns a value along a linear trend.
GEOMEAN	Returns the geometric mean.
GROWTH	Returns values along an exponential trend.
HARMEAN	Returns the harmonic mean.
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.
MAX	Returns the maximum value in a list of arguments.
MATCH	Returns the relative position of an item in an array that matches a specified value in a specified order.
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.
NEGBINOMDIST	Returns the negative binomial distribution, the probability that there will be Number_f failures before the Number_s-th success, with Probability_f probability of a success.
MODE	Returns the most common value in a data set.
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.
PERMUT	Returns the number of permutations for a given number of objects.
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.
TREND	Returns values along a linear trend.
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.