Excel functions / Statistics
DEVSQ function
The sum of the squared distances of the values from their mean.
Syntax
=DEVSQ(number1, [number2], …)
Arguments
number: Numbers, cells or ranges.
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
Sum of squared deviations
A B C 1 Value 2 4 48 3 5 4 8 5 7 6 11 7 4 8 3 In C2:
=DEVSQ(A2:A8)→ 48Divided by n - 1, it is the variance
A B C 1 Value 2 4 8 3 5 4 8 5 7 6 11 7 4 8 3 In C2:
=DEVSQ(A2:A8)/(COUNT(A2:A8)-1)→ 8
Common mistakes
- Not squares of the values. For the squares of the values themselves, use SUMSQ.
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.
- Czech: DEVSQ
- Danish: SAK
- Dutch: DEV.KWAD
- Finnish: OIKAISTU.NELIÖSUMMA
- French: SOMME.CARRES.ECARTS
- German: SUMQUADABW
- Hungarian: SQ
- Italian: DEV.Q
- Norwegian: AVVIK.KVADRERT
- Polish: ODCH.KWADRATOWE
- Portuguese (Brazil): DESVQ
- Portuguese (Portugal): DESVQ
- Russian: КВАДРОТКЛ
- Spanish: DESVIA2
- Swedish: KVADAVV
- Turkish: SAPKARE