How to Use the DEVSQ Function in Excel

This guide explains how to use DEVSQ Function in Excel, including its syntax, required arguments, practical examples, and common errors.

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:

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

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

- 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)

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

Good luck!