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.