DEVSQ (First, Other...) DEVSQ (First; Other...)
First
The first number or array of numbers.
Other
Additional numbers or arrays of numbers.
Returns
Number Number
The sum of squares of deviations from the mean.
Returns the sum of squares of deviations from the mean. Each deviation is the difference between a value and the mean of all values. Dividing the result by the number of values minus 1 gives the sample variance, as returned by VAR.S.
Example
DEVSQ (1, 3, 5)
DEVSQ (1; 3; 5)
Returns 8.