Page 95 - Excel Data Analysis

05 537547 Ch04.qxd 3/4/03 11:52 AM Page 81

CREATING FORMULAS 4

The RANK function is one of several statistical To have Excel automatically analyze your data
functions that determine how a number with 16 different statistical calculations, see
compares to other numbers within a list: Chapter 11.

FUNCTION DESCRIPTION
MEDIAN(number1, [number2]...) Finds the middle number within a list of numbers in ascending or
descending order.
QUARTILE(Array, Quart) Excel displays a value for this argument between 0 and 4 where 0 is
the smallest value in the list, 1 is the value larger than one-fourth of
the values, 2 is larger than one-half, and so on.
MAX(number1, [number2],...) Finds the largest number in the list.
MIN(number1, [number2],...) Finds the smallest number in the list.
LARGE(array, k) Finds the value that is a specific size in relation to the largest value. For
example, a value of 3 for the k argument returns the third largest value.
SMALL(array, k) Finds the value that is a specific size in relation to the smallest value.
For example, a value of 2 for the k argument returns the second
smallest value.

Á Specify the number that ■ You can type 0 to sort data ■ Excel gives the ranking for
you want to rank either as an in a descending order, or any the specified number.
actual number or a cell other number to sort data in
reference. an ascending sort order.
‡ Specify the reference of ° Click OK.
the range of cells containing
numbers that you want to
rank in the Ref field.
81