Level 17 Level 19
Level 18

Statistical functions - Part 2


30 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
GAMMA.INV
Returns the inverse of the gamma cumulative distribution
GAMMALN
Returns the natural logarithm of the gamma function, G(x)
GAMMALN.PRECISE
Returns the natural logarithm of the gamma function, G(x)
GEOMEAN
Returns the geometric mean
GROWTH
Returns values along an exponential trend
HARMEAN
Returns the harmonic mean
HYPGEOM.DIST
Returns the hypergeometric distribution
INTERCEPT
Returns the intercept of the linear regression line
KURT
Returns the kurtosis of a data set
LARGE
Returns the k-th largest value in a data set
LINEST
Returns the parameters of a linear trend
LOGEST
Returns the parameters of an exponential trend
LOGNORM.DIST
Returns the cumulative lognormal distribution
LOGNORM.INV
Returns the inverse of the lognormal cumulative distribution
MAXA
Returns the maximum value in a list of arguments, including numbers, text, and logical values
MEDIAN
Returns the median of the given numbers
MIN
Returns the minimum value in a list of arguments
MINA
Returns the smallest value in a list of arguments, including numbers, text, and logical values
MODE.MULT
Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
MODE.SNGL
Returns the most common value in a data set
NEGBINOM.DIST
Returns the negative binomial distribution
NORM.DIST
Returns the normal cumulative distribution
NORM.INV
Returns the inverse of the normal cumulative distribution
NORM.S.DIST
Returns the standard normal cumulative distribution
NORM.S.INV
Returns the inverse of the standard normal cumulative distribution
PEARSON
Returns the Pearson product moment correlation coefficient
PERCENTILE.EXC
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive
PERCENTILE.INC
Returns the k-th percentile of values in a range
PERCENTRANK.EXC
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
PERCENTRANK.INC
Returns the percentage rank of a value in a data set