Specifications

StDev
742 InfoMaker
StDev
Description Calculates an estimate of the standard deviation for the specified column.
Standard deviation is a measurement of how widely values vary from average.
Syntax StDev ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )
Return value
Double. Returns an estimate of the standard deviation for column.
Usage If you specify range, StDev returns an estimate for the standard deviation of
column within range. If you specify DISTINCT,
StDev returns an estimate of
the standard deviation for the distinct values in column, or if you specify
expresn, the estimate of the standard deviation of the rows in column where the
value of expresn is distinct.
Argument Description
column The column for which you want an estimate for the standard
deviation of the values in the rows. Column can be the column name
or the column number preceded by a pound sign (#). Column can
also be an expression that includes a reference to the column. The
datatype of column must be numeric.
FOR range
(optional)
The data to be included in the estimate of the standard deviation.
For most presentation styles, values for range are:
• ALL – (Default) The estimate of the standard deviation for all
values in column.
• GROUP n – The estimate of the standard deviation for values in
column in the specified group. Specify the keyword GROUP
followed by the group number: for example, GROUP 1.
• PAGE – The estimate of the standard deviation for the values in
column on a page.
For Crosstabs, specify CROSSTAB for range to indicate the
standard deviation for all values in column in the crosstab.
For Graph objects specify GRAPH and for OLE objects specify
OBJECT to indicate the standard deviation for values in column in
the range specified for the Rows option.
DISTINCT
(optional)
Causes
StDev to consider only the distinct values in column when
determining the standard deviation. For a value of column, the first
row found with the value is used and other rows that have the same
value are ignored.
expresn
(optional)
One or more expressions that you want to evaluate to determine
distinct rows. Expresn can be the name of a column, a function, or
an expression.