Excel functions / Statistics

DEVSQ function

The sum of the squared distances of the values from their mean.

Syntax

=DEVSQ(number1, [number2], …)

Arguments

When to use it

DEVSQ gives the sum of the squared distances of the values from their mean. Divided by the count it is the population variance; by one less, the sample variance.

Examples

  1. Sum of squared deviations

    ABC
    1Value
    2448
    35
    48
    57
    611
    74
    83

    In C2: =DEVSQ(A2:A8) → 48

    Try this example

  2. Divided by n - 1, it is the variance

    ABC
    1Value
    248
    35
    48
    57
    611
    74
    83

    In C2: =DEVSQ(A2:A8)/(COUNT(A2:A8)-1) → 8

    Try this example

Common mistakes

DEVSQ in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try DEVSQ in the playground

Related functions