Statistical functions

All statistical functions can operate on an array or range of cells. In those cases where a list is specified as the parameter the function can also take a list of discrete cell references and/or values.

AVG

AVEDEV

BETA

BIN

COMBIN

COUNT

COUNTA

COVARIANCE.P

COVARIANCE.S

DEVSQ

GEOMEAN

GRAND

GROWTH

HARMEAN

KURT

LARGE

LINEST

LISTCOUNT

LOGEST

MAX

MEDIAN

MIN

MODE.SNGL

PERCENTILE.INC

PERMUT

QUARTILE.INC

RANK

RANK.EQ

SKEW

SKEW.P

SMALL

SPEARMAN

STANDARDIZE

STD

STDP

TREND

TRIMMEAN

VAR

VARP