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.
Number1: First value or reference to the cell containing first value.
Number2: Second value or reference to a cell containing second value.
- 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:
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.