# Documentation/Calc Functions/DEVSQ

Jump to navigation Jump to search

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).

## 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

DEVSQ