Variance
The Variance function calculates the volatility of a set of input data values, such as stock prices over a period of time.
1. Syntax
VARIANCE(d0,Alignments...)
2. Input
The Variance function requires the following input:
- d0 - Input data values - The set of data values for which the Variance is calculated.
3. Parameters
The Variance function requires the following parameters:
- Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.
4. Output
The Variance function generates the following output:
- Variance - A single value representing the variance of the input values.