Navigation:  Formulas and functions > Functions from A to Z > DEVSQ (average square deviation)

Syntax:

DEVSQ(Number1 [, Number2, Number3 ...])

Description:

This returns the sum of squares of deviations of the specified numbers from their sample mean.

Empty cells, text strings and logical values are ignored.

Example:

DEVSQ(2, 2, 2, 3) returns 0.75

See also:

AVEDEV, STDEV.S/STDEV, SUM, VAR.S/VAR