Documentation/How Tos/Calc: DEVSQ function

From OpenOffice.org Wiki

DEVSQ

Returns the sum of squares of deviations from the mean.

Syntax:

DEVSQ(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers.

DEVSQ calculates the mean of all the numbers, then sums the squared deviation of each number from that mean. With N values, the calculation formula is:

.

Example:

DEVSQ(1; 3; 5)

returns 8, calculated as (-2)² + 0 + (2)².

See also:

VAR, STDEV, AVEDEV, AVERAGE

Statistical functions

Functions listed alphabetically, Functions listed by category