AVEDEV
Returns the average of the absolute deviations of data points from their mean.
StatisticalStatistics & Analysis
Statistical
Statistical functions support data analysis, reporting, and quality checks in Excel.
They are used for descriptive statistics and probability-based analysis.
Structured tables improve the reliability of statistical formulas.
Tips
- Validate data before interpreting results.
- Use tables so ranges grow automatically.
Excel functions in this category (111)
AVERAGE
Returns the average of its arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
AVERAGEA
Returns the average of its arguments, including numbers, text, and logical values.
StatisticalStatistics & Analysis
AVERAGEIF
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
StatisticalStatistics & Analysis
AVERAGEIFS
Returns the average (arithmetic mean) of all cells that meet multiple criteria.
StatisticalStatistics & Analysis
BETA.DIST
Returns the beta cumulative distribution function.
StatisticalStatistics & Analysis
BETA.INVn
Returns the inverse of the cumulative distribution function for a specified beta distribution.
StatisticalStatistics & Analysis
BINOM.DIST
Returns the individual term binomial distribution probability.
StatisticalStatistics & Analysis
BINOM.DIST.RANGE
Returns the probability of a trial result using a binomial distribution.
StatisticalStatistics & Analysis
BINOM.INV
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
StatisticalStatistics & Analysis
CHISQ.DIST
Returns the cumulative beta probability density function.
StatisticalStatistics & Analysis
CHISQ.DIST.RT
Returns the one-tailed probability of the chi-squared distribution.
StatisticalStatistics & Analysis
CHISQ.INV
Returns the cumulative beta probability density function.
StatisticalStatistics & Analysis
CHISQ.INV.RT
Returns the inverse of the one-tailed probability of the chi-squared distribution.
StatisticalStatistics & Analysis
CHISQ.TEST
Returns the test for independence.
StatisticalStatistics & Analysis
CONFIDENCE.NORM
Returns the confidence interval for a population mean.
StatisticalStatistics & Analysis
CONFIDENCE.T
Returns the confidence interval for a population mean, using a Student's t distribution.
StatisticalStatistics & Analysis
CORREL
Returns the correlation coefficient between two data sets.
StatisticalStatistics & Analysis
COUNT
Counts how many numbers are in the list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
COUNTA
Counts how many values are in the list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
COUNTBLANK
Counts the number of blank cells within a range.
StatisticalStatistics & Analysis
COUNTIF
Counts the number of cells within a range that meet the given criteria.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
COUNTIFS
Counts the number of cells within a range that meet multiple criteria.
StatisticalMost UsedStatistics & Analysis
COVARIANCE.P
Returns covariance, the average of the products of paired deviations.
StatisticalStatistics & Analysis
COVARIANCE.S
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets.
StatisticalStatistics & Analysis
DEVSQ
Returns the sum of squares of deviations.
StatisticalStatistics & Analysis
EXPON.DIST
Returns the exponential distribution.
StatisticalStatistics & Analysis
F.DIST
Returns the F probability distribution.
StatisticalStatistics & Analysis
F.DIST.RT
Returns the F probability distribution.
StatisticalStatistics & Analysis
F.INV
Returns the inverse of the F probability distribution.
StatisticalStatistics & Analysis
F.INV.RT
Returns the inverse of the F probability distribution.
StatisticalStatistics & Analysis
F.TEST
Returns the result of an F-test.
StatisticalStatistics & Analysis
FISHER
Returns the Fisher transformation.
StatisticalStatistics & Analysis
FISHERINV
Returns the inverse of the Fisher transformation.
StatisticalStatistics & Analysis
FORECAST
Returns a value along a linear trend This function has been replaced with FORECAST.LINEAR as part of the new Forecasting, but it's still available for compatibility with earlier versions.
StatisticalStatistics & Analysis
FORECAST.ETS
Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm.
StatisticalStatistics & Analysis
FORECAST.ETS.CONFINT
Returns a confidence interval for the forecast value at the specified target date.
StatisticalStatistics & Analysis
FORECAST.ETS.SEASONALITY
Returns the length of the repetitive pattern Excel detects for the specified time series.
StatisticalStatistics & Analysis
FORECAST.ETS.STAT
Returns a statistical value as a result of time series forecasting.
StatisticalStatistics & Analysis
FORECAST.LINEAR
Returns a future value based on existing values.
StatisticalStatistics & Analysis
FREQUENCY
Returns a frequency distribution as a vertical array.
StatisticalStatistics & Analysis
GAMMA
Returns the Gamma function value.
StatisticalStatistics & Analysis
GAMMA.DIST
Returns the gamma distribution.
StatisticalStatistics & Analysis
GAMMA.INV
Returns the inverse of the gamma cumulative distribution.
StatisticalStatistics & Analysis
GAMMALN
Returns the natural logarithm of the gamma function, Γ(x).
StatisticalStatistics & Analysis
GAMMALN.PRECISE
Returns the natural logarithm of the gamma function, Γ(x).
StatisticalStatistics & Analysis
GAUSS
Returns 0.5 less than the standard normal cumulative distribution.
StatisticalStatistics & Analysis
GEOMEAN
Returns the geometric mean.
StatisticalStatistics & Analysis
GROWTH
Returns values along an exponential trend.
StatisticalStatistics & Analysis
HARMEAN
Returns the harmonic mean.
StatisticalStatistics & Analysis
HYPGEOM.DIST
Returns the hypergeometric distribution.
StatisticalStatistics & Analysis
INTERCEPT
Returns the intercept of the linear regression line.
StatisticalStatistics & Analysis
KURT
Returns the kurtosis of a data set.
StatisticalStatistics & Analysis
LARGE
Returns the k-th largest value in a data set.
StatisticalStatistics & Analysis
LINEST
Returns the parameters of a linear trend.
StatisticalStatistics & Analysis
LOGEST
Returns the parameters of an exponential trend.
StatisticalStatistics & Analysis
LOGNORM.DIST
Returns the cumulative lognormal distribution.
StatisticalStatistics & Analysis
LOGNORM.INV
Returns the inverse of the lognormal cumulative distribution.
StatisticalStatistics & Analysis
MAX
Returns the maximum value in a list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
MAXA
Returns the maximum value in a list of arguments, including numbers, text, and logical values.
StatisticalStatistics & Analysis
MAXIFS
Returns the maximum value among cells specified by a given set of conditions or criteria.
StatisticalModern Excel FunctionsStatistics & Analysis
MEDIAN
Returns the median of the given numbers.
StatisticalStatistics & Analysis
MIN
Returns the minimum value in a list of arguments.
StatisticalBeginner EssentialsMost UsedStatistics & Analysis
MINA
Returns the smallest value in a list of arguments, including numbers, text, and logical values.
StatisticalStatistics & Analysis
MINIFS
Returns the minimum value among cells specified by a given set of conditions or criteria.
StatisticalModern Excel FunctionsStatistics & Analysis
MODE.MULT
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
StatisticalStatistics & Analysis
MODE.SNGL
Returns the most common value in a data set.
StatisticalStatistics & Analysis
NEGBINOM.DIST
Returns the negative binomial distribution.
StatisticalStatistics & Analysis
NORM.DIST
Returns the normal cumulative distribution.
StatisticalStatistics & Analysis
NORM.S.DIST
Returns the standard normal cumulative distribution.
StatisticalStatistics & Analysis
NORM.S.INV
Returns the inverse of the standard normal cumulative distribution.
StatisticalStatistics & Analysis
NORMINV
Returns the inverse of the normal cumulative distribution.
StatisticalStatistics & Analysis
PEARSON
Returns the Pearson product moment correlation coefficient.
StatisticalStatistics & Analysis
PERCENTILE.EXC
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
StatisticalStatistics & Analysis
PERCENTILE.INC
Returns the k-th percentile of values in a range.
StatisticalStatistics & Analysis
PERCENTRANK.EXC
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
StatisticalStatistics & Analysis
PERCENTRANK.INC
Returns the percentage rank of a value in a data set.
StatisticalStatistics & Analysis
PERMUT
Returns the number of permutations for a given number of objects.
StatisticalStatistics & Analysis
PERMUTATIONA
Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.
StatisticalStatistics & Analysis
PHI
Returns the value of the density function for a standard normal distribution.
StatisticalStatistics & Analysis
POISSON.DIST
Returns the Poisson distribution.
StatisticalStatistics & Analysis
PROB
Returns the probability that values in a range are between two limits.
StatisticalStatistics & Analysis
QUARTILE.EXC
Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
StatisticalStatistics & Analysis
QUARTILE.INC
Returns the quartile of a data set.
StatisticalStatistics & Analysis
RANK.AVG
Returns the rank of a number in a list of numbers.
StatisticalStatistics & Analysis
RANK.EQ
Returns the rank of a number in a list of numbers.
StatisticalStatistics & Analysis
RSQ
Returns the square of the Pearson product moment correlation coefficient.
StatisticalStatistics & Analysis
SKEW
Returns the skewness of a distribution.
StatisticalStatistics & Analysis
SKEW.P
Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.
StatisticalStatistics & Analysis
SLOPE
Returns the slope of the linear regression line.
StatisticalStatistics & Analysis
SMALL
Returns the k-th smallest value in a data set.
StatisticalStatistics & Analysis
STANDARDIZE
Returns a normalized value.
StatisticalStatistics & Analysis
STDEV.P
Calculates standard deviation based on the entire population.
StatisticalStatistics & Analysis
STDEV.S
Estimates standard deviation based on a sample.
StatisticalStatistics & Analysis
STDEVA
Estimates standard deviation based on a sample, including numbers, text, and logical values.
StatisticalStatistics & Analysis
STDEVPA
Calculates standard deviation based on the entire population, including numbers, text, and logical values.
StatisticalStatistics & Analysis
STEYX
Returns the standard error of the predicted y-value for each x in the regression.
StatisticalStatistics & Analysis
T.DIST
Returns the Percentage Points (probability) for the Student t-distribution.
StatisticalStatistics & Analysis
T.DIST.2T
Returns the Percentage Points (probability) for the Student t-distribution.
StatisticalStatistics & Analysis
T.DIST.RT
Returns the Student's t-distribution.
StatisticalStatistics & Analysis
T.INV
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
StatisticalStatistics & Analysis
T.INV.2T
Returns the inverse of the Student's t-distribution.
StatisticalStatistics & Analysis
T.TEST
Returns the probability associated with a Student's t-test.
StatisticalStatistics & Analysis
TREND
Returns values along a linear trend.
StatisticalStatistics & Analysis
TRIMMEAN
Returns the mean of the interior of a data set.
StatisticalStatistics & Analysis
VAR.P
Calculates variance based on the entire population.
StatisticalStatistics & Analysis
VAR.S
Estimates variance based on a sample.
StatisticalStatistics & Analysis
VARA
Estimates variance based on a sample, including numbers, text, and logical values.
StatisticalStatistics & Analysis
VARPA
Calculates variance based on the entire population, including numbers, text, and logical values.
StatisticalStatistics & Analysis
WEIBULL.DIST
Returns the Weibull distribution.
StatisticalStatistics & Analysis
Z.TEST
Returns the one-tailed probability-value of a z-test.
StatisticalStatistics & Analysis