# MovingVariance
The **MovingVariance** function calculates the statistical variance of a column in a moving window.
### Syntax
```
MovingVariance([column], above, below)
```
Function Arguments:
* **\[column]** (required) - The column of numbers to calculate the variance.
* **above** (required) - The first row to include, counting backwards from the current row.
* **below** (optional) - The last row to include, counting forward from the current row. Defaults to 0 (current row will be the last row included).
> ### 📘
>
> When using this function without a sort enforced, there can be unexpected results. In order to ensure that the values are stable, verify that there is a sorted column within the table.
### Example
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 **MovingVariance** function to identify the change in variance in different moving windows.
```
MovingVariance([Close Price], 4)
```
With \[Close Price] as the **column** argument and 4 as the **above** argument, the variance is calculated for each week along with the four previous weeks. Since the **below** argument is not specified, it defaults to 0.
```
MovingVariance([Close Price], 0, 4)
```
Here, the **above** argument is 0, so there will not be any previous weeks included in the window. The **below** average is 4, so the variance will be computed for each week along with the next 4 weeks.
```
MovingVariance([Close Price], 2, 2)
```
Here, the **above** argument is 2, so the previous two weeks are included in the window. In addition, the **below** argument is 2, so the following two weeks are included as well.
```
MovingVariance([Close Price], 8, -4)
```
Here is an example where the **below** parameter is negative. The **below** parameter can be negative as long as the value is less than that of the **above** parameter. In this example, each window begins 8 weeks before the current week and ends 4 weeks before the current week, inclusive.
