AVEDEV
Returns the average of the absolute deviations of data points from their mean.
StatisticalStatistics & Analysis
Statistics & Analysis
Statistics & Analysis functions help you turn raw numbers into insights. Use them to summarize distributions, compare groups, identify outliers, and model trends—without leaving Excel.
This collection groups Excel functions that are commonly used for statistics & analysis workflows. Instead of browsing hundreds of formulas, you can focus on the exact tools that solve this type of task.
Each function page includes a short explanation and practical usage context. Use these functions as standalone tools or combine them to build more advanced, maintainable formulas.
If you frequently work with reports, dashboards, or recurring templates, bookmarking the key functions from this collection will speed up your day-to-day work.
Tips
- Start with the most common functions in this collection and expand as your problems get more complex.
- Combine these functions with structured tables to keep formulas readable and resilient.
Excel functions in this collection (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
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
F.TEST
Returns the result of an F-test.
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.INV
Returns the inverse of the normal cumulative distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
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
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
STDEVA
Estimates standard deviation based on a sample, including numbers, text, and logical values.
StatisticalStatistics & Analysis
STDEV.P
Calculates standard deviation based on the entire population.
StatisticalStatistics & Analysis
STDEVPA
Calculates standard deviation based on the entire population, including numbers, text, and logical values.
StatisticalStatistics & Analysis
STDEV.S
Estimates standard deviation based on a sample.
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
TREND
Returns values along a linear trend.
StatisticalStatistics & Analysis
TRIMMEAN
Returns the mean of the interior of a data set.
StatisticalStatistics & Analysis
T.TEST
Returns the probability associated with a Student's t-test.
StatisticalStatistics & Analysis
VARA
Estimates variance based on a sample, including numbers, text, and logical values.
StatisticalStatistics & Analysis
VAR.P
Calculates variance based on the entire population.
StatisticalStatistics & Analysis
VARPA
Calculates variance based on the entire population, including numbers, text, and logical values.
StatisticalStatistics & Analysis
VAR.S
Estimates variance based on a sample.
StatisticalStatistics & Analysis
WEIBULL.DIST
Returns the Weibull distribution.
StatisticalStatistics & Analysis
Z.TEST
Returns the one-tailed probability-value of a z-test.
StatisticalStatistics & Analysis