DEVSQ

Using the Excel DEVSQ Function

Summary

The Excel DEVSQ function returns the sum of the squared deviations from the mean for a given data set.

Syntax

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

Syntax Breakdown

Number 1
Required. First number for which you want to calculate the sum of squared deviations. Entries can be individual arguments separated by commas, or an array or reference.

Number 2
Optional. Additional numbers for which you want to find the sum of the squared deviations. The function can accept up to 255 arguments. Entries can be individual arguments separated by commas, or an array or reference.


Usage Notes

DEVSQ calculates the sum of the squared deviations from the mean for a given data set, without dividing by N or N - 1.

The function will accept logical values and text representations of numbers that are hard-coded into the arguments. Logical and text values, along with empty cells, included in an array or reference will be ignored.