# stats functions

distributions, averages, spread and regression.

149 functions.

- [AVEDEV](https://deepcalc.com/functions/avedev.md) — average of absolute deviations from the mean
- [AVERAGE.WEIGHTED](https://deepcalc.com/functions/average-weighted.md) — average of values weighted by a second range
- [AVERAGEA](https://deepcalc.com/functions/averagea.md) — averages values including text and logicals
- [AVERAGEIF](https://deepcalc.com/functions/averageif.md) — averages cells that match a condition
- [AVERAGEIFS](https://deepcalc.com/functions/averageifs.md) — averages cells matching multiple conditions
- [BETA.DIST](https://deepcalc.com/functions/beta-dist.md) — beta distribution
- [BETA.INV](https://deepcalc.com/functions/beta-inv.md) — inverse of the beta distribution
- [BETADIST](https://deepcalc.com/functions/betadist.md) — legacy form of BETA.DIST (cumulative)
- [BETAINV](https://deepcalc.com/functions/betainv.md) — legacy form of BETA.INV
- [BINOM.DIST](https://deepcalc.com/functions/binom-dist.md) — binomial distribution probability
- [BINOM.DIST.RANGE](https://deepcalc.com/functions/binom-dist-range.md) — probability of a trial result range
- [BINOM.INV](https://deepcalc.com/functions/binom-inv.md) — smallest value with cumulative binomial at or above a criterion
- [BINOMDIST](https://deepcalc.com/functions/binomdist.md) — legacy form of BINOM.DIST
- [CHIDIST](https://deepcalc.com/functions/chidist.md) — legacy form of CHISQ.DIST.RT
- [CHIINV](https://deepcalc.com/functions/chiinv.md) — legacy form of CHISQ.INV.RT
- [CHISQ.DIST](https://deepcalc.com/functions/chisq-dist.md) — returns the chi-squared distribution
- [CHISQ.DIST.RT](https://deepcalc.com/functions/chisq-dist-rt.md) — returns the right-tailed chi-squared distribution
- [CHISQ.INV](https://deepcalc.com/functions/chisq-inv.md) — returns the inverse of the chi-squared distribution
- [CHISQ.INV.RT](https://deepcalc.com/functions/chisq-inv-rt.md) — returns the inverse of the right-tailed chi-squared distribution
- [CHISQ.TEST](https://deepcalc.com/functions/chisq-test.md) — chi-squared test for independence
- [CHITEST](https://deepcalc.com/functions/chitest.md) — legacy form of CHISQ.TEST
- [CONFIDENCE](https://deepcalc.com/functions/confidence.md) — legacy form of CONFIDENCE.NORM
- [CONFIDENCE.NORM](https://deepcalc.com/functions/confidence-norm.md) — confidence interval for a population mean, normal
- [CONFIDENCE.T](https://deepcalc.com/functions/confidence-t.md) — confidence interval for a population mean, Student's t
- [CORREL](https://deepcalc.com/functions/correl.md) — correlation coefficient between two data sets
- [COUNT](https://deepcalc.com/functions/count.md) — counts cells containing numbers
- [COUNTA](https://deepcalc.com/functions/counta.md) — counts non-empty cells in a range
- [COUNTBLANK](https://deepcalc.com/functions/countblank.md) — counts empty cells in a range
- [COUNTIF](https://deepcalc.com/functions/countif.md) — counts cells that match a condition
- [COUNTIFS](https://deepcalc.com/functions/countifs.md) — counts cells matching multiple conditions
- [COUNTUNIQUE](https://deepcalc.com/functions/countunique.md) — counts distinct non-empty values
- [COVAR](https://deepcalc.com/functions/covar.md) — legacy form of COVARIANCE.P: population covariance
- [COVARIANCE.P](https://deepcalc.com/functions/covariance-p.md) — population covariance
- [COVARIANCE.S](https://deepcalc.com/functions/covariance-s.md) — sample covariance
- [CRITBINOM](https://deepcalc.com/functions/critbinom.md) — legacy form of BINOM.INV
- [DEVSQ](https://deepcalc.com/functions/devsq.md) — sum of squared deviations from the mean
- [EXPON.DIST](https://deepcalc.com/functions/expon-dist.md) — exponential distribution
- [EXPONDIST](https://deepcalc.com/functions/expondist.md) — legacy form of EXPON.DIST
- [F.DIST](https://deepcalc.com/functions/f-dist.md) — F probability distribution
- [F.DIST.RT](https://deepcalc.com/functions/f-dist-rt.md) — right-tailed F probability distribution
- [F.INV](https://deepcalc.com/functions/f-inv.md) — inverse of the F distribution
- [F.INV.RT](https://deepcalc.com/functions/f-inv-rt.md) — inverse of the right-tailed F distribution
- [F.TEST](https://deepcalc.com/functions/f-test.md) — F-test for equality of variances
- [FDIST](https://deepcalc.com/functions/fdist.md) — legacy form of F.DIST.RT
- [FINV](https://deepcalc.com/functions/finv.md) — legacy form of F.INV.RT
- [FISHER](https://deepcalc.com/functions/fisher.md) — returns the Fisher transformation
- [FISHERINV](https://deepcalc.com/functions/fisherinv.md) — inverse of the Fisher transformation
- [FORECAST](https://deepcalc.com/functions/forecast.md) — predicts a value along a linear trend
- [FORECAST.ETS](https://deepcalc.com/functions/forecast-ets.md) — forecasts a value using exponential smoothing
- [FORECAST.ETS.CONFINT](https://deepcalc.com/functions/forecast-ets-confint.md) — confidence interval for an ETS forecast
- [FORECAST.ETS.SEASONALITY](https://deepcalc.com/functions/forecast-ets-seasonality.md) — season length detected by ETS
- [FORECAST.ETS.STAT](https://deepcalc.com/functions/forecast-ets-stat.md) — statistic from the ETS model
- [FORECAST.LINEAR](https://deepcalc.com/functions/forecast-linear.md) — predicts a value on the linear regression line
- [FREQUENCY](https://deepcalc.com/functions/frequency.md) — counts values falling into bins, spilled as a column
- [FTEST](https://deepcalc.com/functions/ftest.md) — legacy form of F.TEST
- [GAMMA.DIST](https://deepcalc.com/functions/gamma-dist.md) — gamma distribution
- [GAMMA.INV](https://deepcalc.com/functions/gamma-inv.md) — inverse of the gamma distribution
- [GAMMADIST](https://deepcalc.com/functions/gammadist.md) — legacy form of GAMMA.DIST
- [GAMMAINV](https://deepcalc.com/functions/gammainv.md) — legacy form of GAMMA.INV
- [GAMMALN](https://deepcalc.com/functions/gammaln.md) — natural logarithm of the gamma function
- [GAMMALN.PRECISE](https://deepcalc.com/functions/gammaln-precise.md) — natural logarithm of the gamma function
- [GAUSS](https://deepcalc.com/functions/gauss.md) — probability a standard normal member falls between the mean and z
- [GEOMEAN](https://deepcalc.com/functions/geomean.md) — returns geometric mean of positive values
- [GROWTH](https://deepcalc.com/functions/growth.md) — values along an exponential trend
- [HARMEAN](https://deepcalc.com/functions/harmean.md) — returns the harmonic mean
- [HYPGEOM.DIST](https://deepcalc.com/functions/hypgeom-dist.md) — hypergeometric distribution
- [HYPGEOMDIST](https://deepcalc.com/functions/hypgeomdist.md) — legacy form of HYPGEOM.DIST
- [INTERCEPT](https://deepcalc.com/functions/intercept.md) — y-intercept of the linear regression line
- [KURT](https://deepcalc.com/functions/kurt.md) — returns the kurtosis of a data set
- [LARGE](https://deepcalc.com/functions/large.md) — returns the k-th largest value in a data set
- [LINEST](https://deepcalc.com/functions/linest.md) — parameters of the least-squares linear fit
- [LOGEST](https://deepcalc.com/functions/logest.md) — parameters of the exponential curve fit
- [LOGINV](https://deepcalc.com/functions/loginv.md) — legacy form of LOGNORM.INV
- [LOGNORM.DIST](https://deepcalc.com/functions/lognorm-dist.md) — lognormal distribution
- [LOGNORM.INV](https://deepcalc.com/functions/lognorm-inv.md) — inverse of the lognormal distribution
- [LOGNORMDIST](https://deepcalc.com/functions/lognormdist.md) — legacy form of LOGNORM.DIST (cumulative)
- [MARGINOFERROR](https://deepcalc.com/functions/marginoferror.md) — margin of error of a sample at a confidence level
- [MAXA](https://deepcalc.com/functions/maxa.md) — returns the largest value, counting text and logicals
- [MAXIFS](https://deepcalc.com/functions/maxifs.md) — returns largest value matching conditions
- [MEDIAN](https://deepcalc.com/functions/median.md) — returns the median of a set of numbers
- [MINA](https://deepcalc.com/functions/mina.md) — returns the smallest value, counting text and logicals
- [MINIFS](https://deepcalc.com/functions/minifs.md) — returns smallest value matching conditions
- [MODE](https://deepcalc.com/functions/mode.md) — legacy form of MODE.SNGL: most frequent value in a data set
- [MODE.MULT](https://deepcalc.com/functions/mode-mult.md) — returns an array of the most frequently occurring values
- [MODE.SNGL](https://deepcalc.com/functions/mode-sngl.md) — returns the most frequently occurring value
- [NEGBINOM.DIST](https://deepcalc.com/functions/negbinom-dist.md) — negative binomial distribution
- [NEGBINOMDIST](https://deepcalc.com/functions/negbinomdist.md) — legacy form of NEGBINOM.DIST
- [NORM.DIST](https://deepcalc.com/functions/norm-dist.md) — normal distribution
- [NORM.INV](https://deepcalc.com/functions/norm-inv.md) — inverse of the normal distribution
- [NORM.S.DIST](https://deepcalc.com/functions/norm-s-dist.md) — standard normal distribution
- [NORM.S.INV](https://deepcalc.com/functions/norm-s-inv.md) — inverse of the standard normal distribution
- [NORMDIST](https://deepcalc.com/functions/normdist.md) — legacy form of NORM.DIST
- [NORMINV](https://deepcalc.com/functions/norminv.md) — legacy form of NORM.INV
- [NORMSDIST](https://deepcalc.com/functions/normsdist.md) — legacy form of NORM.S.DIST (cumulative)
- [NORMSINV](https://deepcalc.com/functions/normsinv.md) — legacy form of NORM.S.INV
- [PEARSON](https://deepcalc.com/functions/pearson.md) — Pearson product moment correlation coefficient
- [PERCENTILE](https://deepcalc.com/functions/percentile.md) — legacy form of PERCENTILE.INC: k-th percentile
- [PERCENTILE.EXC](https://deepcalc.com/functions/percentile-exc.md) — k-th percentile, exclusive
- [PERCENTILE.INC](https://deepcalc.com/functions/percentile-inc.md) — returns the k-th percentile, inclusive
- [PERCENTOF](https://deepcalc.com/functions/percentof.md) — share of a data subset within a whole
- [PERCENTRANK](https://deepcalc.com/functions/percentrank.md) — legacy form of PERCENTRANK.INC: rank as a percentage
- [PERCENTRANK.EXC](https://deepcalc.com/functions/percentrank-exc.md) — percentage rank, exclusive
- [PERCENTRANK.INC](https://deepcalc.com/functions/percentrank-inc.md) — percentage rank, inclusive
- [PERMUT](https://deepcalc.com/functions/permut.md) — returns the number of permutations of a set of objects
- [PERMUTATIONA](https://deepcalc.com/functions/permutationa.md) — returns the number of permutations with repetitions allowed
- [PHI](https://deepcalc.com/functions/phi.md) — density function value for the standard normal distribution
- [POISSON](https://deepcalc.com/functions/poisson.md) — legacy form of POISSON.DIST
- [POISSON.DIST](https://deepcalc.com/functions/poisson-dist.md) — Poisson distribution
- [PROB](https://deepcalc.com/functions/prob.md) — probability that values fall within limits
- [QUARTILE](https://deepcalc.com/functions/quartile.md) — legacy form of QUARTILE.INC: quartile of a data set
- [QUARTILE.EXC](https://deepcalc.com/functions/quartile-exc.md) — returns a quartile, excluding the median
- [QUARTILE.INC](https://deepcalc.com/functions/quartile-inc.md) — returns a quartile, including the median
- [RANK](https://deepcalc.com/functions/rank.md) — legacy form of RANK.EQ: rank of a number in a list
- [RANK.AVG](https://deepcalc.com/functions/rank-avg.md) — rank of a number, average rank for ties
- [RANK.EQ](https://deepcalc.com/functions/rank-eq.md) — rank of a number, top rank for ties
- [RSQ](https://deepcalc.com/functions/rsq.md) — square of the Pearson correlation coefficient
- [SKEW](https://deepcalc.com/functions/skew.md) — returns the skewness of a distribution
- [SKEW.P](https://deepcalc.com/functions/skew-p.md) — skewness based on the entire population
- [SLOPE](https://deepcalc.com/functions/slope.md) — slope of the linear regression line
- [SMALL](https://deepcalc.com/functions/small.md) — returns the k-th smallest value in a data set
- [STANDARDIZE](https://deepcalc.com/functions/standardize.md) — normalized value from a distribution
- [STDEV](https://deepcalc.com/functions/stdev.md) — legacy form of STDEV.S: sample standard deviation
- [STDEV.P](https://deepcalc.com/functions/stdev-p.md) — population standard deviation
- [STDEV.S](https://deepcalc.com/functions/stdev-s.md) — sample standard deviation
- [STDEVA](https://deepcalc.com/functions/stdeva.md) — sample standard deviation, counting text and logicals
- [STDEVP](https://deepcalc.com/functions/stdevp.md) — legacy form of STDEV.P: population standard deviation
- [STDEVPA](https://deepcalc.com/functions/stdevpa.md) — population standard deviation, counting text and logicals
- [STEYX](https://deepcalc.com/functions/steyx.md) — standard error of the predicted y for each x
- [T.DIST](https://deepcalc.com/functions/t-dist.md) — Student's t-distribution
- [T.DIST.2T](https://deepcalc.com/functions/t-dist-2t.md) — two-tailed Student's t-distribution
- [T.DIST.RT](https://deepcalc.com/functions/t-dist-rt.md) — right-tailed Student's t-distribution
- [T.INV](https://deepcalc.com/functions/t-inv.md) — left-tailed inverse of the t-distribution
- [T.INV.2T](https://deepcalc.com/functions/t-inv-2t.md) — two-tailed inverse of the t-distribution
- [T.TEST](https://deepcalc.com/functions/t-test.md) — probability from Student's t-test
- [TDIST](https://deepcalc.com/functions/tdist.md) — legacy form of T.DIST.RT / T.DIST.2T
- [TINV](https://deepcalc.com/functions/tinv.md) — legacy form of T.INV.2T
- [TREND](https://deepcalc.com/functions/trend.md) — values along a linear trend
- [TRIMMEAN](https://deepcalc.com/functions/trimmean.md) — mean of the interior of a data set
- [TTEST](https://deepcalc.com/functions/ttest.md) — legacy form of T.TEST
- [VAR](https://deepcalc.com/functions/var.md) — legacy form of VAR.S: sample variance
- [VAR.P](https://deepcalc.com/functions/var-p.md) — population variance
- [VAR.S](https://deepcalc.com/functions/var-s.md) — sample variance
- [VARA](https://deepcalc.com/functions/vara.md) — sample variance, counting text and logicals
- [VARP](https://deepcalc.com/functions/varp.md) — legacy form of VAR.P: population variance
- [VARPA](https://deepcalc.com/functions/varpa.md) — population variance, counting text and logicals
- [WEIBULL](https://deepcalc.com/functions/weibull.md) — legacy form of WEIBULL.DIST
- [WEIBULL.DIST](https://deepcalc.com/functions/weibull-dist.md) — Weibull distribution
- [Z.TEST](https://deepcalc.com/functions/z-test.md) — one-tailed p-value of a z-test
- [ZTEST](https://deepcalc.com/functions/ztest.md) — legacy form of Z.TEST

## navigate

- [function index](https://deepcalc.com/functions.md)
- [error values](https://deepcalc.com/errors.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/functions/stats-functions