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
Search JabSto ::




Custom Search