Introduction:-

DEVSQ function in excel is a statistical function. This function is used to find the sum of the squared deviations from the mean from a sample. It is a worksheet function and can be entered into the cell in which value is required.

Syntax:-                        

=DEVSQ(Number1,Number2, ……)

Arguments:-

Number1: First value or reference to the cell containing first value.

Number2: Second value or reference to a cell containing second value.

Keynotes:-

• Arguments may be in form of numbers, names, arrays, or references to the cell that contain numbers.
• Empty cells and cells containing text or logical values are not used.
• Formula for finding sum of squared deviations is:

Examples

In this example, various values are entered in Column A and Column B, and DEVSQ function used to find the sum of the squared deviations from the mean using the formula =DEVSQ(A4:B9) which gives 9595 as the result.