Skip to Content

DEVSQ

Returns the sum of squares of deviations of data points from their sample mean

Syntax

DEVSQ(number1, [number2], ...)

Parameters

  • number1: Required. The first argument
  • number2: Optional. Additional arguments, up to 255

Example

=DEVSQ(A1:A10)
Returns: NumberSince: Excel 2003