Microsoft Office Tutorials and References
In Depth Information
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.
Returns the k th largest value in a data set.
LARGE
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.
Returns the maximum value in a list of arguments, ignoring logical
values and text.
MAX
Returns the maximum value in a list of arguments, including logical
values and text.
MAXA
MEDIAN
Returns the median of the given numbers.
Returns the minimum value in a list of arguments, ignoring logical
values and text.
MIN
Returns the minimum value in a list of arguments, including logical
values and text.
MINA
Returns a vertical array of the most frequently occurring or repetit-
ive values in an array or range of data.
MODE.MULT**
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.
Search JabSto ::




Custom Search