CumulativeVariance

The CumulativeVariance function calculates the variance of a column up to and including the current row value.

Syntax

CumulativeVariance(\[Column\])

Function Arguments:

• [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.

Example

CumulativeVariance(\[Close Price\])

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.