Microsoft Office Tutorials and References

In Depth Information

**STDEV**

Figure 11.45

In this example, the z

value (the result of the

STANDARDIZE

function) is negative.

STDEV

STDEV
estimates standard deviation based on a sample.

=STDEV(number1,number2,...)

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.

NUMBER N

The equation for
STDEV
is