Microsoft Office Tutorials and References
In Depth Information
Syntax:
Syntax:
=AVEDEV(number1,number2,...)
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.
Syntax
=DEVSQ(number1,number2,...)
The DEVSQ function returns the sum of squares of deviations of data points
from their sample mean.
Syntax
=VAR.S(number1,number2,...)
The VAR.S function estimates variance based on a sample.
Caution
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.
Syntax
=VAR.P(number1,number2,...)
The VAR.P function calculates variance based on the entire population.
Syntax
=STDEV.S(number1,number2,...)
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.
Search JabSto ::




Custom Search