Excel DEVSQ function

Function              DEVSQ

Description        Excel DEVSQ function returns the sum of squares of deviations of data points from their sample mean.

Syntax  DEVSQ(number1, [number2], …)

number1  First value or reference.

number2  [optional] Second value or reference.

Example:

=DEVSQ(12,13,14,15) = 5

=DEVSQ(123,231,222,332) = 21882

How it works?

Numbers (123,231,222,332)

Average of the numbers 227

=DEVSQ(123,231,222,332) = (123-227)^2+(231-227)^2+(222-227)^2+(332-227)^2=21882

Usage Notes:

• Arguments can be entered as numbers or names, arrays, or references that contain numbers.
• If an array or reference argument contains text, logical values, or empty cells, those values are ignored. Cells with the value zero are included.
• Arguments that are error values or text cause errors.