2. Excel Functions
  3. Excel Statistical Functions

Excel Statistical Functions

Excel Statistical Functions

FunctionDescriptionSupersedes
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BETA.DISTBETADIST
BETA.INVBETAINV
BINOM.DISTBINOMDIST
BINOM.DIST.RANGE
BINOM.INVCRITBINOM
CHISQ.DISTCHIDIST
CHISQ.DIST.RTCHIDIST
CHISQ.INVCHIINV
CHISQ.INV.RTCHIINV
CHISQ.TESTCHITEST
CONFIDENCE.NORMCONFIDENCE
CONFIDENCE.TCONFIDENCE
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVARIANCE.PCOVAR
COVARIANCE.SCOVAR
DEVSQ
EXPON.DISTEXPONDIST
F.DISTFDIST
F.DIST.RTFDIST
F.INVFINV
F.INV.RTFINV
F.TESTFTEST
FISHER
FISHERINV
FORECAST.ETS
FORECAST.ETS.CONFINT
FORECAST.ETS.SEASONALITY
FORECAST.ETS.STAT
FORECAST.LINEARFORECAST
FREQUENCY
GAMMA
GAMMA.DISTGAMMADIST
GAMMA.INVGAMMAINV
GAMMALN
GAMMALN.PRECISE
GAUSS
GEOMEAN
GROWTH
HARMEAN
HYPGEOM.DISTHYPGEOMDIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGNORM.DISTLOGNORMDIST
LOGNORM.INVLOGINV
MAX
MAXA
MAXIFS
MEDIAN
MIN
MINA
MINIFS
MODE.MULTMODE
MODE.SNGLMODE
NEGBINOM.DISTNEGBINOMDIST
NORM.DISTNORMDIST
NORM.INVNORMINV
NORM.S.DISTNORMSDIST
NORM.S.INVNORMSINV
PEARSON
PERCENTILE.EXCPERCENTILE
PERCENTILE.INCPERCENTILE
PERMUT
PERMUTATIONA
PHI
POISSON.DISTPOISSON
PROB
QUARTILE.EXCQUARTILE
QUARTILE.INCQUARTILE
RANK.AVGRANK
RANK.EQRANK
RSQ
SKEW
SKEW.P
SLOPE
SMALL
STANDARDIZE
STDEV.PSTDEVP
STDEV.SSTDEV
STDEVA
STDEVPA
STEYX
TDIST
TDIST.2TTDIST
TDIST.RTTDIST
T.INVTINV
T.INV.2TTINV
T.TESTTTEST
TREND
TRIMMEAN
VAR.PVARP
VAR.SVAR
VARA
VARPA
WEIBULL.DISTWEIBULL
Z.TESTZTEST