Formulas and Functions

Function Description
“MAXA” (page 270) The MAXA function returns the largest number in
a collection of values that may include text and
Boolean values.
“MEDIAN” (page 271) The MEDIAN function returns the median value in
a collection of numbers. The median is the value
where half the numbers in the collection are less
than the median and half are greater.
“MIN” (page 272) The MIN function returns the smallest number in
a collection.
“MINA” (page 273) The MINA function returns the smallest number
in a collection of values that may include text and
Boolean values.
“MODE” (page 274) The MODE function returns the most frequently
occurring value in a collection of numbers.
“NEGBINOMDIST” (page 275) The NEGBINOMDIST function returns the
negative binomial distribution.
“NORMDIST” (page 276) The NORMDIST function returns the normal
distribution of the specied function form.
“NORMINV” (page 277) The NORMINV function returns the inverse of the
cumulative normal distribution.
“NORMSDIST” (page 277) The NORMSDIST function returns the standard
normal distribution.
“NORMSINV” (page 278) The NORMSINV function returns the inverse of
the cumulative standard normal distribution.
“PERCENTILE” (page 279) The PERCENTILE function returns the value within
a collection that corresponds to a particular
percentile.
“PERCENTRANK” (page 280) The PERCENTRANK function returns the rank of
a value in a collection as a percentage of the
collection.
“PERMUT” (page 281) The PERMUT function returns the number of
permutations for a given number of objects that
can be selected from a total number of objects.
“POISSON” (page 282) The POISSON function returns the probability
that a specic number of events will occur using
the Poisson distribution.
“PROB” (page 282) The PROB function returns the probability of a
range of values if you know the probabilities of
the individual values.
228 Chapter 10 Statistical Functions