Microsoft Office Tutorials and References
In Depth Information
The AVEDEV function returns the average of the absolute deviations of data
points from their mean. AVEDEV is a measure of the variability in a data set.
AVEDEV is influenced by the unit of measurement in the input data.
The DEVSQ function returns the sum of squares of deviations of data points
from their sample mean.
The VAR.S function estimates variance based on a sample.
Logical values (TRUE/FALSE) are ignored in the STDEV.S and STDEV.P
calculations. For some statistics, you need to figure out how many
people answered TRUE to a question. To count TRUE values as 1 and
FALSE values as 0, you use VARA, VARPA, STDEVA, and STDEVPA ver-
sions of those four functions.
The VAR.P function calculates variance based on the entire population.
The STDEV.S function estimates standard deviation based on a sample. The
standard deviation is a measure of how widely values are dispersed from the
average value (that is, the mean). The standard deviation is calculated using
the “ nonbiased ” or “ n − 1 ” method.