VAR.S
The variance of a column's numbers, taken as a sample.
Group: Aggregation. Compatible with DAX.
Syntax
VAR.S ( <columnName> )| Parameter | Type | Description |
|---|---|---|
columnName | Column | A column of numbers. |
Returns
Number. The variance of the column's values, taking them as a sample.
Remarks
- The sum of squared differences from the mean divided by n − 1: the square of
STDEV.S. - With a single value the result is NaN; with none, BLANK.
Examples
Variance of the prices per liter, as a sample
EVALUATE
ROW ( "Sample variance", VAR.S ( Products[Price per liter] ) )| Sample variance |
|---|
| 226.666666666667 |