# Documentation/Calc Functions/DEVSQ

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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 n_{0},n_{1},n_{2}, ... n, a is the result of calling AVERAGE(n_{0},n_{1},n_{2}, ... 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:

## ODF standard:

## Equivalent Excel functions:

DEVSQ