STD Function

Returns the standard deviation.

Categories: Aggregate
Descriptive Statistics
Returned data type: DOUBLE

Syntax

Arguments

expression

specifies any valid expression that evaluates to a numeric value.

Requirement At least two non-null or nonmissing arguments are required. Otherwise, the function returns a null or missing value.
Data type DOUBLE
See <sql-expression>
FedSQL Expressions.

Example

The following statements illustrate the STD function:
Statements
Results
select std(2,6);
2.82842712474619
select std(2,6,.);
2.82842714274619
select std(2,4,6,3,1);
1.92353840616714
Last updated: February 23, 2017