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 1Required. 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.