Documentation/Calc Functions/DEVSQ

Function name:
DEVSQ

Category:
Statistical Analysis

Summary:
Returns the sum of squares of deviations based on a sample mean.

Syntax:
DEVSQ(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns a non-negative real number which is the sum of squares of deviations of Number 1, Number 2, …, Number 255.

Arguments:
Number 1, Number 2, …, Number 255 are real numbers, references to cells or to cell ranges of real numbers.


 * If arguments or the referenced cell don't contain real numbers then the function returns an error value. However, logical values like TRUE and FALSE are considered as 1 and 0, respectively.

Additional details:
The formula for DEVSQ is:

where the numbers are from n0,n1,n2, ... n, a is the result of calling AVERAGE(n0,n1,n2, ... n).

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/SUMSQ SUMSQ]

ODF standard:
Section 6.18.20, part 2

Equivalent Excel functions:
DEVSQ