## 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.