Part VII: Appendixes
930
TABLE A.11 (continued)
Function What It Does
F.TEST** Returns the result of an F-test.
FISHER Returns the Fisher transformation.
FISHERINV Returns the inverse of the Fisher transformation.
FORECAST Returns a value along a linear trend.
FREQUENCY Returns a frequency distribution as a vertical array.
GAMMA.DIST** Returns the gamma distribution.
GAMMA.INV** Returns the inverse of the gamma cumulative distribution.
GAMMALN.PRECISE** Returns the natural logarithm of the gamma function, G(x).
GAMMALN 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 kth 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.
MAX Returns the maximum value in a list of arguments, ignoring logical values and text.
MAXA Returns the maximum value in a list of arguments, including logical values and text.
MEDIAN Returns the median of the given numbers.
MIN Returns the minimum value in a list of arguments, ignoring logical values and text.
MINA Returns the minimum value in a list of arguments, including logical values and text.
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.56_474877-bapp01.indd 93056_474877-bapp01.indd 930 3/29/10 11:49 PM3/29/10 11:49 PM