STDEV.S
How spread out a column's numbers are, treating them as a sample: the standard deviation dividing by n − 1.
Group: Aggregation. Compatible with DAX.
Syntax
STDEV.S ( <ColumnName> )| Parameter | Type | Description |
|---|---|---|
ColumnName | Column | A column of numbers. |
Returns
Number. How far the column's values spread around their mean, when they are a sample of more.
Remarks
- Sample means: the sum of squared differences from the mean is divided by n − 1, which makes up for the mean itself being estimated from the same values.
- With a single value there is no sample deviation, and the result is NaN (not a number).
- Blanks are left out. With no value, the result is BLANK.
Examples
Spread of the prices per liter
EVALUATE
ROW ( "Sample deviation", STDEV.S ( Products[Price per liter] ) )| Sample deviation |
|---|
| 15.0554530541816 |