DEVSQ function

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)