Statistical functions

You can use the built-in statistical functions to perform statistical and other calculations. With these functions you can automatically find the average, minimum and maximum of a set of values, calculate the number of permutations, and perform other complex computations.

Here is a complete list of statistical functions in Ability:

AVEDEV

AVERAGE

BINOMDIST

COMB

CORREL

COUNT

COUNTIF

COUNTN

COVAR

DEVSQ

EXPONDIST

FISHER

FISHERINV

FORECAST

GAMMADIST

GAMMALN

GEOMEAN

HARMEAN

HYPGEOMDIST

INTERCEPT

KURT

LARGE

MAX

MEDIAN

MIN

MODE

NEGBINOMDIST

NORMDIST

PEARSON

PERCENTILE

PERCENTRANK

PERM

POISSON

PROB

QUARTILE

RANK

RSQ

SKEW

SLOPE

SMALL

STANDARDIZE

STD

STDEVP

STEYX

VAR

VARP

WAVG

WEIBULL

 

See also:

Other functions