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.
SMALL returns the
position of the
specified smallest value in
the data set. To return
state, use the
To return the largest
value, use the LARGE
to loss due to
STANDARDIZE returns a normalized value from a distribution characterized by mean and
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