DEVSQ Function in Excel the Function Returns the Sum of

This article provides a clear overview of DEVSQ Function in Excel the Function Returns the Sum of, with the main facts, useful context, and practical details organized for easy reading.

The article describes the syntax and usage of the DEVSQ () function to calculate the sum of squares of deviations in Excel.

Description

DEVSQ () is a function that returns the sum of squares of deviations between data points from their average.

Syntax

= DEVSQ (number1, number2,.)

Arguments

number1: the first argument, required.

number2: is the next parameter, optional and up to 255 arguments that you may need to calculate the square of their deviation.

number1, number2. can be numbers directly separated by commas, an array, or an array reference.

Note

- Arguments number1, number2. can be numbers or names, an array or a reference containing numbers.

- Ignore arguments that are arrays or references to cells that contain text, logical values, or empty cells except the value of 0 (zero).

- The logical values and text representations form that you enter directly into the argument list will be calculated.

- If the arguments are entered directly as text or the values cannot be converted into numbers, the function will report an error.

- Equation summing squared deviations:

For Example

Calculate the sum of squares of deviations of numbers in the Data column.

Applying DEVSQ (): = DEVSQ (D6: D11) we get the following result:

You can also enter numbers directly into the function: = DEVSQ (9,5,7,5,6,8)

DEVSQ () function is also one of the functions with quite simple syntax and usage, you can quickly remember the syntax and know how to use DEVSQ () function to calculate the sum of squared deviations in Excel. Good luck!