Previous Topic Next topic Print topic


XSTDDEV

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
      X

An XDB Server statistical function for finding the standard deviation of a column. Null values are ignored. The format appears below:

XSTDDEV(x)

where the parameter x is a numeric column.

Note that XSTDDEV(x) is the same as (XVAR(x))E+1/2. The formula used for computing standard deviation is:


Formula for standard deviation

Previous Topic Next topic Print topic