Advanced Excel Statistical - DEVSQ Function

Description

The DEVSQ function returns the sum of squares of deviations of data points from their sample mean.

DEVSQ (number1, [number2] ...)

Argument	Description	Required/ Optional
Number1	1 to 255 arguments for which you want to calculate the sum of squared deviations.	Required
number2, ...	You can also use a single array or a reference to an array instead of arguments separated by commas.	Optional

The equation for the sum of squared deviations is −

$$DEVSQ=\sum \left ( x-\bar{x} \right )^2$$
Arguments can either be numbers or names, arrays, or references that contain numbers.
Logical values and text representations of numbers that you type directly into the list of arguments are counted.
If an array or reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value zero are included.
Text representations of numbers, that are supplied as a part of an array, are not interpreted as numeric values by the DEVSQ function.
Arguments that are error values or text that cannot be translated into numbers cause errors.
If none of the values supplied to the Function are numeric DEVSQ returns #NUM! error value.
If any of the number arguments that are supplied directly to the Function are nonnumeric text strings, DEVSQ returns #VALUE! error value.

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_statistical_functions.htm