DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel

The following article introduces you to the DEVSQ function - one of the functions in the statistical function group is very popular in Excel.

DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 1

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

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

Inside:

- number1, number1: The value you want to sum the squares of their deviations, where number1 is the required value, from number1 onwards is optional and contains up to 255 number arguments .

Attention:

- The argument must be either a number or a reference array that contains numbers.

- If text or logical values ​​are typed directly into the argument list -> it is still calculated in the function.

- If the reference form or array containing logical values ​​and text will be ignored, the case of the value of 0 is still calculated.

- The function will give an error if the arguments are text or an error value cannot be converted into a number.

- The function using the equation to calculate the square of deviation is:

[DEVSQ = sum {{{left ({x - overline x} right)} ^ 2}}]

For example:

Calculate the sum of squares of deviations of data points in the table below:

DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 2

- In the cell to calculate enter the formula : = DEVSQ (C6: C10)

DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 3

- Press Enter -> the sum of squares of deviations of data points is:

DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 4

- Where the data points are non-adjacent cells. For example, calculate the sum of squares of deviations of data points in cells C6, C8, C10 -> enter the formula: = DEVSQ (C6, C8, C10)

DEVSQ function - The function returns the sum of squares of deviations of data points from the sample mean in Excel Picture 5

Above are instructions and some specific examples when using DEVSQ function in Excel.

Good luck!