Returns the sum of squares of deviations of data points from their sample mean.
Syntax
DEVSQ(number1,number2,...)
Number1,number2, ... are 1 to 30 arguments for which you want to calculate the sum of squared deviations.
Remarks
-
The arguments must be numbers or column references that contain numbers.
-
If argument contains text, logical values, or is empty, those values are ignored; however, arguments with the value zero are included.
-
The equation for the sum of squared deviations is:
Example
|
Col1 |
Col2 |
Col3 |
Col4 |
Col5 |
Col6 |
Col7 |
Formula |
Description (Result) |
|
4 |
5 |
8 |
7 |
11 |
4 |
3 |
=DEVSQ([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7]) |
Sum of squares of deviations of data from their sample mean (48) |
