Science
Spreadsheet functions for science — conformant with Google Sheets and Excel.
Functions commonly used in science:
- ABS
- ACOS
- ACOSH
- ACOT
- ACOTH
- ARRAYFORMULA
- ARRAY_CONSTRAIN
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- BETA.DIST
- BETA.INV
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOM.DIST
- BINOM.INV
- BINOMDIST
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- BYCOL
- BYROW
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CHOOSECOLS
- CHOOSEROWS
- COLUMNS
- COMBIN
- COMBINA
- COMPLEX
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CORREL
- COS
- COSH
- COT
- COTH
- COUNTA
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CRITBINOM
- CSC
- CSCH
- DEGREES
- DELTA
- DEVSQ
- ERF
- ERF.PRECISE
- ERFC
- ERFC.PRECISE
- EXP
- EXPON.DIST
- EXPONDIST
- F.DIST
- F.DIST.RT
- F.INV
- F.INV.RT
- F.TEST
- FACT
- FACTDOUBLE
- FDIST
- FINV
- FISHER
- FISHERINV
- FLATTEN
- FLOOR.MATH
- FLOOR.PRECISE
- FREQUENCY
- FTEST
- GAMMA
- GAMMA.DIST
- GAMMA.INV
- GAMMADIST
- GAMMAINV
- GAMMALN
- GAMMALN.PRECISE
- GAUSS
- GEOMEAN
- GESTEP
- GROWTH
- HARMEAN
- HSTACK
- HYPGEOM.DIST
- HYPGEOMDIST
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCOTH
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- IMTANH
- INTERCEPT
- KURT
- LINEST
- LN
- LOG
- LOG10
- LOGEST
- LOGINV
- LOGNORM.DIST
- LOGNORM.INV
- LOGNORMDIST
- MAKEARRAY
- MAP
- MARGINOFERROR
- MAX
- MAXA
- MDETERM
- MEDIAN
- MIN
- MINA
- MINVERSE
- MMULT
- MOD
- MODE.MULT
- MULTINOMIAL
- MUNIT
- NEGBINOM.DIST
- NEGBINOMDIST
- NORM.DIST
- NORM.INV
- NORM.S.DIST
- NORM.S.INV
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- OCT2BIN
- OCT2DEC
- OCT2HEX
- PEARSON
- PERCENTILE
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PERMUTATIONA
- PHI
- PI
- POISSON
- POISSON.DIST
- POWER
- PROB
- QUARTILE
- QUARTILE.EXC
- QUARTILE.INC
- RADIANS
- RAND
- RANDARRAY
- RANDBETWEEN
- RANK.AVG
- RANK.EQ
- REDUCE
- ROUND
- ROUNDDOWN
- ROWS
- RSQ
- SCAN
- SEC
- SECH
- SEQUENCE
- SERIESSUM
- SIGN
- SIN
- SINH
- SKEW
- SKEW.P
- SLOPE
- SMALL
- SORT
- SORTBY
- SQRT
- SQRTPI
- STANDARDIZE
- STDEV
- STDEV.P
- STDEV.S
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TAN
- TANH
- TDIST
- TINV
- TRANSPOSE
- TREND
- TRIMMEAN
- TRUNC
- VAR
- VAR.P
- VAR.S
- VARA
- VARP
- VARPA
- Z.TEST
- ZTEST