• placeholder
  • All Files
  
You are here:

Statistical Functions

These functions are used for statistical operations like standard deviation, distributions, square roots, average and median

  • Family: PQL
  • Library: Spreadsheet
  • ◉ This function can be used with the Solve plug-in
  • Function List

    AVEDEV

    ◉

    AVERAGE

    ◉

    AVERAGEA

    ◉

    AVERAGEIF

    ◉

    AVERAGEIFS

    ◉

    BETA.DIST

    ◉

    BETA.INV

    ◉

    BINOM.DIST

    ◉

    BINOM.DIST.RANGE

    BINOM.INV

    ◉

    CHISQ.DIST

    ◉

    CHISQ.DIST.RT

    ◉

    CHISQ.INV

    CHISQ.INV.RT

    CHISQ.TEST

    CONFIDENCE.NORM

    ◉

    CONFIDENCE.T

    CORREL

    ◉

    COUNT

    ◉

    COUNTA

    ◉

    COUNTBLANK

    ◉

    COUNTIF

    ◉

    COUNTIFS

    ◉

    COVARIANCE.P

    COVARIANCE.S

    DEVSQ

    EXPON.DIST

    F.DIST

    F.DIST.RT

    F.INV

    F.INV.RT

    F.TEST

    FINV

    ◉

    FISHER

    ◉

    FISHERINV

    ◉

    FORECAST

    FREQUENCY

    GAMMA

    GAMMA.DIST

    GAMMA.INV

    GAMMALN

    GAMMALN.PRECISE

    GAUSS

    GEOMEAN

    ◉

    GROWTH

    HARMEAN

    HYPGEOM.DIST

    INTERCEPT

    KURT

    LARGE

    LINEST

    LOGEST

    LOGNORM.DIST

    ◉

    LOGNORM.INV

    ◉

    MAX

    ◉

    MAXA

    MAXIFS

    MEDIAN

    ◉

    MIN

    ◉

    MINA

    MINIFS

    MODE.MULT

    MODE.SNGL

    NEGBINOM.DIST

    NORM.DIST

    ◉

    NORM.INV

    NORM.S.DIST

    NORM.S.INV

    PEARSON

    PERCENTILE.EXC

    ◉

    PERCENTILE.INC

    ◉

    PERCENTRANK.EXC

    PERCENTRANK.INC

    ◉

    PERMUT

    PERMUTATIONA

    PHI

    POISSON.DIST

    PROB

    QUARTILE.EXC

    ◉

    QUARTILE.INC

    ◉

    RANK.AVG

    ◉

    RANK.EQ

    ◉

    RSQ

    SKEW

    SKEW.P

    SLOPE

    ◉

    SMALL

    STANDARDIZE

    STDEV.P

    ◉

    STDEV.S

    ◉

    STDEVA

    ◉

    STDEVPA

    ◉

    STEYX

    ◉

    T.DIST

    T.DIST.2T

    T.DIST.RT

    T.INV

    T.INV.2T

    T.TEST

    TREND

    TRIMMEAN

    VAR.P

    ◉

    VAR.S

    ◉

    VARA

    ◉

    VARPA

    ◉

    WEIBULL.DIST

    Z.TEST

    Feedback

    Why wasn't this helpful?

    Thanks for your feedback.

    Want to tell us more? Email us

    Check the user forum to see if your question has already been answered.

    Thanks for taking the time to give us some feedback.

    Home | Table of Contents | Index | User Community

    Version: Newton 2025.00 | Pyramid Analytics © 2017-2025