Sample variance: var_samp

Syntax

  • Aggregate syntax

in a Data Set expression

var_samp ( dataset { groupingClause } )

in a Component expression within an aggr clause

var_samp ( component ) { groupingClause }

  • Analytic syntax

in a Data Set expression

var_samp ( dataset over ( analyticClause ) )

in a Component expression within a calc clause

var_samp ( component over ( analyticClause ) )

Input parameters

dataset

the operand Data Set

component

the operand Component

groupingClause

see Aggregate invocation

analyticClause

see Analytic invocation

Semantics for scalar operations

This operator cannot be applied to scalar values.

Input parameters type

dataset

dataset { measure<number> _+ }

component

component<number>

Result type

result

dataset { measure<number> _+ }
| component<number>

Additional Constraints

None.

Behaviour

The operator returns the sample variance of the input values. For other details, see Aggregate and Analytic invocations.