Spread Formula Reference
Statistical Functions
Formula Overview > Functions in a Formula > Categories of Functions > Statistical Functions

The functions that relate to statistical operations are:

AVEDEV AVERAGE AVERAGEA AVERAGEIF
AVERAGEIFS BETADIST BETA.DIST BETAINV
BETA.INV BINOMDIST BINOM.DIST BINOM.DIST.RANGE
BINOM.INV CHIDIST CHIINV CHISQ.DIST
CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT CHISQ.TEST
CHITEST CONFIDENCE CONFIDENCE.NORM CONFIDENCE.T
CORREL COUNT COUNTIF COUNTIFS
COUNTA COVAR COVARIANCE.P COVARIANCE.S
CRITBINOM DEVSQ EXPONDIST EXPON.DIST
FDIST F.DIST F.DIST.RT FINV
F.INV F.INV.RT FISHER FISHERINV
FORECAST FREQUENCY FTEST F.TEST
GAMMA GAMMADIST GAMMA.DIST GAMMAINV
GAMMA.INV GAMMALN GAMMALN.PRECISE GAUSS
GEOMEAN GROWTH HARMEAN HYPGEOMDIST
HYPGEOM.DIST INTERCEPT KURT LARGE
LINEST LOGEST LOGINV LOGNORMDIST
LOGNORM.DIST LOGNORM.INV MAX MAXA
MAXIFS MEDIAN MIN MINA
MINIFS MODE MODE.MULT MODE.SNGL
NEGBINOMDIST NEGBINOM.DIST NORMDIST NORM.DIST
NORMINV NORM.INV NORMSDIST NORM.S.DIST
NORMSINV NORM.S.INV PEARSON PERCENTILE
PERCENTILE.EXC PERCENTILE.INC PERCENTRANK PERCENTRANK.EXC
PERCENTRANK.INC PERMUT PERMUTATIONA PHI
POISSON POISSON.DIST PROB QUARTILE
QUARTILE.EXC QUARTILE.INC RANK RANK.AVG
RANK.EQ RSQ SKEW SKEW.P
SLOPE SMALL STANDARDIZE STDEV
STDEVA STDEVP STDEV.P STDEVPA
STDEV.S STEYX TDIST T.DIST
T.DIST.2T T.DIST.RT TINV T.INV
T.INV.2T TREND TRIMMEAN TTEST
T.TEST VAR VARA VARP
VAR.P VARPA VAR.S WEIBULL
WEIBULL.DIST ZTEST Z.TEST  

Return to the list of Categories of Functions.