Microsoft Office Tutorials and References
In Depth Information
SMALL returnsthe k-th smallest value in a data set.
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.
Is the position (from the smallest) of the data point you want to return.
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
Shrink refers
to loss due to
spoilage, damage,
and theft.
STANDARDIZE returns a normalized value from a distribution characterized by mean and
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.
Is the arithmetic mean (average) of the data set.
Is the standard deviation of the data set.
The equation for STANDARDIZE is
Search JabSto ::

Custom Search