Excel Reference 545MEDIAN MEDIAN(number1, number2,.. .) returns the
median of up to 30 numbers.
MIN MIN(number1, number2,.. .) returns the smallest of
up to 30 numbers.
MODE MODE(number1, number2,.. .) returns the value
most frequently occurring in up to 30 numbers or in
a specifi ed array or reference.
PERCENTILE PERCENTILE(array, n) returns the nth percentile of
the values in array.
PERCENTRANK PERCENTRANK(array, value, signifi cant-digits)
returns the percent rank of the value in the array,
with the specifi ed number of signifi cant digits
(optional).
PRODUCT PRODUCT(number1, number2,.. .) returns the
product of up to 30 numbers.
RANK RANK(number, range, order) returns the rank of the
number in the range. If order 5 0, then the range is
ranked from largest to smallest; if order 5 1, then
the range is ranked from smallest to largest.
QUOTIENT QUOTIENT(dividend, divisor) returns the quotient
of the numbers, truncated to integers.
SKEW SKEW(number1, number2,.. .) returns the
skewness of up to 30 numbers (or a reference to
numbers).
SMALL SMALL(array, n) returns the nth-smallest number
in array.
STANDARDIZE STANDARDIZE(x, mean, standard deviation)
normalizes a distribution and returns the z score
of x.
STDEV STDEV(number1, number2,.. .) returns the sample
standard deviation of up to 30 numbers, or of an
array of numbers.
STDEVP STDEVP(number1, number2,.. .) returns the
population standard deviation of up to 30 numbers
or of an array of numbers.
SUM SUM(number1, number2,.. .) returns the sum of up
to 30 numbers or of an array of numbers.
SUMIF SUMIF(range, criteria, sum range) returns the sum
of the numbers in range (optionally in sum-range)
according to criteria.
SUMSQ SUMSQ(number1, number2,.. .) returns the sum
of the squares of up to 30 numbers or of an array of
numbers.
TRIMMEAN TRIMMEAN(array, percent) returns the mean of a
set of values in an array, excluding percent of the
values, half from the top and half from the bottom.