Statistical Formulas in Excel

Statistical formulas in Excel are used to perform multiple statistical calculations or analysis from the data such as mean, median, mode, average, count and forecast. Some of the statistical formulas are new and may not be available in old Excel versions.

In this tutorial page, you will learn how to use all the statistical formulas in Excel with detailed explanations, examples and videos.

Statistical Formulas in Excel | Rath Point

All Statistical Formulas in Excel

Click on any of the below statistical formulas in Excel to get the detailed information about it.

AVEDEV Formula in Excel

AVERAGE Formula in Excel

AVERAGEA Formula in Excel

AVERAGEIF Formula in Excel

AVERAGEIFS Formula in Excel

BETA.DIST Formula in Excel

BETA.INV Formula in Excel

BINOM.DIST Formula in Excel

BINOM.DIST.RANGE Formula in Excel

BINOM.INV Formula in Excel

CHISQ.DIST Formula in Excel

CHISQ.DIST.RT Formula in Excel

CHISQ.INV Formula in Excel

CHISQ.INV.RT Formula in Excel

CHISQ.TEST Formula in Excel

CONFIDENCE.NORM Formula in Excel

CONFIDENCE.T Formula in Excel

CORREL Formula in Excel

COUNT Formula in Excel

COUNTA Formula in Excel

COUNTBLANK Formula in Excel

COUNTIF Formula in Excel

COUNTIFS Formula in Excel

COVARIANCE.P Formula in Excel

COVARIANCE.S Formula in Excel

DEVSQ Formula in Excel

EXPON.DIST Formula in Excel

F.DIST Formula in Excel

F.DIST.RT Formula in Excel

F.INV Formula in Excel

F.INV.RT Formula in Excel

F.TEST Formula in Excel

FISHER Formula in Excel

FISHERINV Formula in Excel

FORECAST Formula in Excel

FORECAST.ETS Formula in Excel

FORECAST.ETS.CONFINT Formula in Excel

FORECAST.ETS.SEASONALITY Formula in Excel

FORECAST.ETS.STAT Formula in Excel

FORECAST.LINEAR Formula in Excel

FREQUENCY Formula in Excel

GAMMA Formula in Excel

GAMMA.DIST Formula in Excel

GAMMA.INV Formula in Excel

GAMMALN Formula in Excel

GAMMALN.PRECISE Formula in Excel

GAUSS Formula in Excel

GEOMEAN Formula in Excel

GROWTH Formula in Excel

HARMEAN Formula in Excel

HYPGEOM.DIST Formula in Excel

INTERCEPT Formula in Excel

KURT Formula in Excel

LARGE Formula in Excel

LINEST Formula in Excel

LOGEST Formula in Excel

LOGNORM.DIST Formula in Excel

LOGNORM.INV Formula in Excel

MAX Formula in Excel

MAXA Formula in Excel

MAXIFS Formula in Excel

MEDIAN Formula in Excel

MIN Formula in Excel

MINA Formula in Excel

MINIFS Formula in Excel

MODE.MULT Formula in Excel

MODE.SNGL Formula in Excel

NEGBINOM.DIST Formula in Excel

NROM.DIST Formula in Excel

NROM.INV Formula in Excel

NROM.S.DIST Formula in Excel

NROM.S.INV Formula in Excel

PEARSON Formula in Excel

PERCENTILE.EXC Formula in Excel

PERCENTILE.INC Formula in Excel

PERCENTRANK.EXC Formula in Excel

PERCENTRANK.INC Formula in Excel

PERMUT Formula in Excel

PERMUTATIONA Formula in Excel

PHI Formula in Excel

POISSON.DIST Formula in Excel

PROB Formula in Excel

QUARTILE.EXC Formula in Excel

QUARTILE.INC Formula in Excel

RANK.AVG Formula in Excel

RANK.EQ Formula in Excel

RSQ Formula in Excel

SKEW Formula in Excel

SKEW.P Formula in Excel

SLOPE Formula in Excel

SMALL Formula in Excel

STANDARDIZE Formula in Excel

STDEV.P Formula in Excel

STDEV.S Formula in Excel

STDEVA Formula in Excel

STDEVPA Formula in Excel

STEYX Formula in Excel

T.DIST Formula in Excel

T.DIST.2T Formula in Excel

T.DIST.RT Formula in Excel

T.INV Formula in Excel

T.INV.2T Formula in Excel

T.TEST Formula in Excel

TREND Formula in Excel

TRIMMEAN Formula in Excel

VAR.P Formula in Excel

VAR.S Formula in Excel

VARA Formula in Excel

VARPA Formula in Excel

WEIBULL.DIST Formula in Excel

Z.TEST Formula in Excel

Summary of all Statistical Formulas in Excel

AVEDEV

Average of absolute deviations of data points from their mean.

AVERAGE

Average (arithmetic mean) of a given range of cells.

AVERAGEA

Average (arithmetic mean) of a given range of cells, ingores the blank cells but considers the text as zero.

AVERAGEIF

Average (arithmetic mean) of a given range of cells that meet a given criteria.

AVERAGEIFS

Average (arithmetic mean) of a given range of cells that meet multiple criteria.

BETA.DIST

Cumulative beta distribution.

BETA.INV

Inverse of the cumulative beta distribution.

BINOM.DIST

Individual term binomial distribution probability.

BINOM.DIST.RANGE

Binomial distribution probability from a specified number of trials.

BINOM.INV

Inverse of the cumulative binomial distribution.

CHISQ.DIST

Chi-squared distribution.

CHISQ.DIST.RT

Right-tailed probability of the chi-squared distribution.

CHISQ.INV

Inverse of the left-tailed probability of the chi-squared distribution.

CHISQ.INV.RT

Inverse of the right-tailed probability of the chi-squared distribution.

CHISQ.TEST

Chi-square distribution of two provided datasets.

CONFIDENCE.NORM

Confidence interval for a population mean by using a normal distribution.

CONFIDENCE.T

Confidence interval for a population mean by using a student’s t distribution.

CORREL

Correlation coefficient of two cell ranges.

COUNT

Count the number of cells that contain a number.

COUNTA

Counts the number of cells that are not empty in a range.

COUNTBLANK

Counts the number of empty cells in a range.

COUNTIF

Count the number of cells in a range that meet a criterion.

COUNTIFS

Count the number of cells in a range that meet multiple criteria.

COVARIANCE.P

Population covariance, the average of the products of paired deviations.

COVARIANCE.S

Sample covariance, the average of the products deviations for each data point pair in two data sets.

DEVSQ

Sum of the squared deviations from the sample mean.

EXPON.DIST

Exponential distribution.

F.DIST

F probability distribution for two data sets.

F.DIST.RT

Right-tailed F probability distribution for two data sets.

F.INV

Inverse of the F probability distribution.

F.INV.RT

Inverse of the right-tailed F probability distribution for two data sets.

F.TEST

Two-tailed probability that the variances in two arrays are not significantly different.

FISHER

Fisher transformation for a given value.

FISHERINV

Inverse of the Fisher transformation.

» Financial Formulas

» Logical Formulas

» Text Formulas

» Date & Time Formulas

» Lookup & Ref Formulas

» Math & Trig Formulas

» Statistical Formulas

» Engineering Formulas

» Cube Formulas

» Information Formulas

» Compatibility Formulas

» Web Formulas