Microsoft Office Tutorials and References
In Depth Information
Figure 11.45
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
Search JabSto ::

Custom Search