DEVSQ(list)

The DEVSQ function calculates the sum of squares of deviations from the mean of a list of numbers. The formula used is:

image\ebx_1261174431.gif

For example:

DEVSQ(9, 4, 8, 1, 14)

returns 98.8.

See also:

AVERAGE(list) or AVG(list)

Other statistical functions