Spread.NET 17 Formula Reference
Formula Overview / Functions in a Formula / Categories of Functions / Statistical Functions
In This Topic
    Statistical Functions
    In This Topic

    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.