DEVSQ

Calculates the sum of squares of deviations based on a sample.

Sample Usage

DEVSQ(1,2,3,4,5,6,7,8,9,10)
DEVSQ(A2:A6)

Syntax

DEVSQ(value1, [value2, ...])

• value1 - The first number or range of the sample.
• value2, .. - [OPTIONAL] Additional numbers or ranges to include in the sample.
  
  

Examples

DEVSQ(1,2,3,4,5,6,7,8,9,10) returns a value of 82.5.
DEVSQ(A2:A6) returns the Sum of squares of deviations of data above from their sample mean.
 

Notes

• A minimum of two values must be supplied as value arguments. Else, DEVSQ will return a value of 0.
• DEVSQ will ignore any text values found in ranges included in value arguments.
• DEVSQ is equivalent to the variance of a sample multiplied by the number of elements in the sample minus one.