DEVSQ

Syntax:

DEVSQ(list)

Returns the sum of the squares of the deviations of the values in the list from their arithmetic mean. list may be an array, a range of cells, or a comma-separated list of values.

The equation used is:

Σi=n (xix)2

where xi is each value and n is the number of values.

Added in 1.36.