> ## Documentation Index
> Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MovingVariance

Calculates the moving variance of values within a specified window of rows relative to the current row.

**Category:** `window`

**Syntax:**

```
MovingVariance([column], window_start, window_end)
```

**Returns:** `Float`

**Context Filtering:** ✓ Yes

## Parameters

| Name           | Type      | Required  | Description                                                                                        |
| -------------- | --------- | --------- | -------------------------------------------------------------------------------------------------- |
| `column`       | `column`  | ✓ Yes     | The numeric column to calculate moving variance for                                                |
| `window_start` | `integer` | ✓ Yes     | The number of rows before the current row to include in the window (negative value)                |
| `window_end`   | ✗ No      | `integer` | The number of rows after the current row to include in the window (positive value). Defaults to 0. |

**Allowed Column Types for `column`:** INT, FLOAT, DECIMAL, NUMBER

## Validation

* Minimum parameters: 2
* Maximum parameters: 3

## Examples

```
MovingVariance([Sales], -6, 0)
```

Returns the variance of sales in a 7-day rolling window (current row and 6 previous rows).

```
MovingVariance([Response_Time], -29, 0)
```

Calculates a 30-day moving variance of response times, useful for tracking data dispersion over time.

```
MovingVariance([Stock_Returns], -19, 0)
```

Calculates a 20-day rolling variance for stock returns to analyze volatility.

## Related Functions

* [CumulativeVariance](cumulativevariance) - Calculates cumulative variance from the first row
* [MovingStdDev](movingstddev) - Calculates moving standard deviation with a window
* [Variance](../aggregate/variance) - Returns the overall variance
* [MovingAvg](movingavg) - Calculates moving average with a window