Microsoft Office Tutorials and References

In Depth Information

**SMALL**

SMALL

SMALL
returnsthe
k-th smallest value in a data set.

=SMALL(array,k)

The
SMALL
function is used to retrieve a value based on its standing or rank in the data set.

Figure 11.44 shows an example of the
SMALL
function returning the third smallest number

from the list.

Is the range of data from which you want to return the
k
-th smallest value.

ARRAY

Is the position (from the smallest) of the data point you want to return.

K

Figure 11.44

SMALL
returns the

position of the

specified smallest value in

the data set. To return

the corresponding

state, use the

VLOOKUP
function.

To return the largest

value, use the
LARGE

function.

A

Shrink refers

to loss due to

spoilage, damage,

and theft.

STANDARDIZE

STANDARDIZE
returns a normalized value from a distribution characterized by
mean
and

standard_dev
.

=STANDARDIZE(x,mean,standard_dev)

The mean of a standard normal distribution is zero. However, in real-world situations, the

mean is rarely zero. In order to make accurate comparisons, the x value must be
standardized
.

The result, shown in Figure 11.45, is what the x value is equivalent to in a standard normal

distribution (the z value in the equation).

Is the value you want to normalize.

X

Is the arithmetic mean (average) of the data set.

MEAN

Is the standard deviation of the data set.

STANDARD_DEV

The equation for
STANDARDIZE
is