DEVSQ function
Summary
Returns the sum of squares of deviations
Syntax
DEVSQ(number1, [number2], ...)
The DEVSQ function syntax has the following arguments:
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the sum of squared deviations. You can also use a single array or a reference to an array instead of arguments separated by commas.
• Number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want to calculate the sum of squared deviations. You can also use a single array or a reference to an array instead of arguments separated by commas.
Example
=DEVSQ(A2:A8)