Var / Aggregation Layer

Calculate variance across specified columns, similar to numpy var() or pandas var(). Measures the average squared deviation from the mean.

Mathematical form: $σ^{2} = \frac{\sum _{i = 1}^{N} ( x _{i} - x ˉ ) ^{2}}{N - ddof}$ Where:

$σ^{2}$ is the variance
$\overset{x}{ˉ}$ is the mean
$N$ is the number of observations
ddof adjusts degrees of freedom

Common applications:

Investment risk analysis
Process control in manufacturing
Experimental error estimation
Quality assurance
Sensor calibration
Population studies

Provides a simpler interface for single-column variance analysis.

Table

Select

[column, ...]

Numeric columns to analyze. Each selected column must contain numeric data suitable for variance calculation. Non-numeric columns will result in null values.

Ddof

Delta Degrees of Freedom (ddof) for variance calculation:

1 (default): Sample variance (unbiased estimator)
0: Population variance (maximum likelihood estimator) Higher values increase the estimated variance.