The CumulativeVariance function calculates the variance of a column up to and including the current row value.
- [Column] (required) - The column of numbers to evaluate the cumulative variance.
Cumulative functions depend on the order of the given column. If you change the sorting you will change the result.
A table contains the daily close price of a stock in 2016. Variance can be used to show the volatility of a stock, where a higher variance indicates higher risk. We can use the CumulativeVariance function to identify the change in variance over time.