Statistical Formulas

AVERAGE
Statistical

Calculates the average of a range of cells

COUNT
Statistical

Counts the number of cells that contain numbers

GROWTH
Statistical

Calculates predicted exponential growth

LINEST
Statistical

Returns the parameters of a linear trend

LOGEST
Statistical

Returns the parameters of an exponential trend

FORECAST
Statistical

Predicts a future value based on existing values

FREQUENCY
Statistical

Returns a frequency distribution as a vertical array

GEOMEAN
Statistical

Returns the geometric mean

HARMEAN
Statistical

Returns the harmonic mean

KURT
Statistical

Returns the kurtosis of a data set

LARGE
Statistical

Returns the k-th largest value in a data set

SMALL
Statistical

Returns the k-th smallest value in a data set

MEDIAN
Statistical

Returns the median of the given numbers

MODE
Statistical

Returns the most frequently occurring value in an array

NEGBINOMDIST
Statistical

Returns the negative binomial distribution

NORMDIST
Statistical

Returns the normal cumulative distribution

NORMINV
Statistical

Returns the inverse of the normal cumulative distribution

NORMSDIST
Statistical

Returns the standard normal cumulative distribution

NORMSINV
Statistical

Returns the inverse of the standard normal cumulative distribution

PEARSON
Statistical

Returns the Pearson product moment correlation coefficient