Functions
DEVSQ
Sum of squared deviations from the mean
Try it
When to use it
When should I use DEVSQ?
Use DEVSQ to compute the sum of squared deviations of values from their mean — a building block for variance and standard deviation calculations, or for manually computing regression sums.
Used in
Syntax
DEVSQ(value1,...)Examples
=DEVSQ(1,2,3,4,5,6,7,8,9,10) // => 82.5