Microsoft Office Tutorials and References
In Depth Information
The STDEV function is
used with a sample
data set. Use the
STDEVP function if the
data set represents the
entire population and
not a sample.
STDEVA estimates standard deviation based on a sample that may be comprised of numbers,
text, or logical values.
Similar to STDEV , the STDEVA function calculates the average of its arguments. The difference
is that STDEVA does not ignore text or logical values (TRUE and FALSE). Text and FALSE are
evaluated as zero (0) and TRUE is evaluated as one (1). Refer to Figure 11.46 for a
comparison of the STDEV and STDEVA functions.
Cells that contain a zero (0), text, or logical values are included in the
STDEVA calculation. Arguments can be cell references, arrays, or range
names. Blank cells are ignored. You can specify up to 30 arguments for
the STDEVA function.
STDEVP calculates standard deviation based on the entire population.
Like the STDEV function, the STDEVP function is a measure of how widely dispersed values are
from the arithmetic mean (the average) value. While the STDEV function is used with a sample
of a population, the STDEVP function is used when you have the entire population. Figure 11.47
shows an example of the STDEVP function.
Arguments can be cell references, arrays, or range names. Blank cells or
cells that contain text or logical values are ignored. Cells containing zero
(0) are included in the calculation. You can specify up to 30 arguments for
the STDEVP function.