Page 267 - Excel Data Analysis

14 537547 AppB.qxd 3/4/03 11:57 AM Page 253

EXCEL FUNCTION QUICK REFERENCE B

STATISTICAL FUNCTIONS (CONTINUED)

FUNCTION DESCRIPTION
LOGEST(known_y's[, known_x's, const, stats]) Finds the exponential curve that fits the specified values.
LOGINV(probability, mean, standard_dev) Finds the inverse of the lognormal cumulative distribution.
LOGNORMDIST(x, mean, standard_dev) Finds the lognormal cumulative distribution.
MAX(number1[, number2,...]) Finds the largest numeric value.
MAXA(value1[, value2,...]) Finds the largest value in the list by comparing numbers, text,
and logical values.
MEDIAN(number1[, number2,...]) Finds the median value for a list.
MIN(number1[, number2,...]) Finds the smallest numeric value.
MINA(value1[, value2,...]) Finds the smallest value in the list by comparing numbers, text,
and logical values.
MODE(number1[, number2,...]) Finds the most frequently occurring value in a list.
NEGBINOMDIST(number_f, number_s, probability_s) Determines the probability of the specified number of failures.
NORMDIST(x, mean, standard_dev, cumulative) Finds the normal distribution of the specified mean and
standard deviation.
NORMINV(probability mean, standard_dev) Finds the inverse of the normal cumulative distribution using
the specified mean and standard deviation values.
NORMSDIST(z) Finds the normal distribution with a mean of 0 and a standard
deviation of 1.
NORMSINV(probability) Finds the inverse of the standard normal cumulative distribution
with a mean of zero and a standard deviation of 1.
PEARSON(array1, array2) Finds the Pearson product moment coefficient r.
PERCENTILE(array, k) Finds the value that is the specified percentile of values in the
list.
PERCENTRANK(array, x[, significance]) Finds the percentage rank of a number within a list.
PERMUT(number, number_chosen) Calculates the number of permutations created from the
specified number of objects.
POISSON(x, mean, cumulative) Calculates the Poisson distribution.
PROB(x_range, prob_range, lower_limit[, upper_limit]) Determines that probability that a range of values is within the
specified limits.
QUARTILE(array, quart) Finds the quartile for a list of values.
RANK(number, ref, order) Finds the rank of a number within a list.
RSQ(known_y's, known_x's) Finds the square of the Pearson product moment correlation
coefficient through the specified data points.
SKEW(number1[, number2,...]) Finds the degree of asymmetry for a series of numbers.

253