Microsoft Office Tutorials and References
In Depth Information
In this example, the z
value (the result of the
function) is negative.
STDEV estimates standard deviation based on a sample.
The standard deviation is a measure of how widely dispersed values are from the arithmetic
mean (the average) value. Figure 11.46 shows the STDEV calculated for a random sample of
college entrance scores from a local high school. If your data set is the entire population, use
the STDEVP function.
Arguments can be cell references, arrays, or range names. Blank cells or
cells that contain a text, or logical values are ignored. Cells containing zero
(0) are included in the calculation. You can specify up to 30 arguments for
the STDEV function.
The equation for STDEV is