Returns the sum of squares of deviations based on a sample mean.
DEVSQ(Number 1 [; Number 2 [; … [; Number 255]]])
Returns a non-negative real number which is the sum of squares of deviations of Number 1, Number 2, … , Number 255.
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.
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).
|=DEVSQ(2;3;4)||The function calculates the sum of squares of deviations of 2,3,4 in this case, i.e. (2-3)2 + (3-3)2 + (4-3)2 taking 3 as average of sample.||2|
Related LibreOffice functions:
Equivalent Excel functions: