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) 