DEVSQ (average square deviation)

<< Click to Display Table of Contents >>

DEVSQ (average square deviation)

Syntax:

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

Description:

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