DEVSQ function

This topic describes the formula syntax and usage of the DEVSQ function in the Data Quality Execute Formula transform.

Description

Returns the sum of squares of deviations from a sample mean.

Syntax

DEVSQ(number1, [number2], ...)

The DEVSQ function syntax has the following arguments:

  • number1, number2, ... The first argument is required. Subsequent numbers are optional. Arguments for which to calculate the sum of squared deviations.

Notes

  • Arguments can be a single column reference or a reference to a range of columns.
  • Referenced fields that contain text, logical values, or are empty cells are ignored.
  • Referenced field that contain the value zero are included.
  • Error values or text that cannot be translated into numbers cause errors.
  • The equation for the sum of squared deviations is:
    DEVSQ = Σ(x – x)2

Example

Table 1. Sample data in 7 columns
Col1 Col2 Col3 Col4 Col5 Col6 Col7
55 62 35 32 50 57 54
Table 2. Calculation of sum of squares
Formula Description Result
DEVSQ([Col1]:[Col7]) Sum of squares for fields 1 through 7 in record. 779.4286