Excel > Function References > Statistical Functions

DEVSQ function

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

Syntax

DEVSQ(number1,number2,...)

Argument	Description	Remarks
number1,number2,...	1 to 255 arguments for which you want to calculate the sum of squared deviations.	You can also use a single array or a reference to an array instead of arguments that are separated by commas. The arguments must be either numbers or names, arrays, or references that contain numbers. 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.

General remarks

The equation for the sum of squared deviations is:

DEVSQ Equation

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.


1
2
3
4
5
6
7
8

A	B
Data
4
5
8
7
11
4
3
Formula	Description (Result)
=DEVSQ(A2:A8)	Sum of squares of deviations of data in the table from their sample mean (48)

See also
AVEDEV function
STDEV.S function
STDEV.P function
VAR.S function
VAR.P function
List of all functions (by category)

Share your feedback about this topic

Rate this content: