Documentation/Calc Functions/DEVSQ

From The Document Foundation Wiki
Jump to navigation Jump to search


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:

Devsq.png

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

Examples:

Formula Description Returns
=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:

SUMSQ

ODF standard:

Section 6.18.20, part 2

Equivalent Excel functions:

DEVSQ