DEVSQ

Definition: DEVSQ is a function that returns the sum of squares of deviations of data points from their mean.

Syntax: =DEVSQ(number1, [number2], …)

Situation: This formula is suitable when you need to find the sum of squares of deviations of data points from their mean.

Example: If you have a set of values 1, 2, 3, 4, and 5, the formula =DEVSQ(1,2,3,4,5) returns 10.