STDEV.P
How spread a column's numbers are when they are all there is: the standard deviation dividing by n.
Group: Aggregation. Compatible with DAX.
Syntax
STDEV.P ( <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 all there is.
Remarks
- Population means: the sum of squared differences from the mean is divided by n, the number of values.
- Use
STDEV.Swhen the values are a sample of something larger; it divides by n − 1. - Blanks are left out. With no value, the result is BLANK.
Examples
Spread of the prices per liter
EVALUATE
ROW (
"STDEV.P", STDEV.P ( Products[Price per liter] ),
"STDEV.S", STDEV.S ( Products[Price per liter] )
)| STDEV.P | STDEV.S |
|---|---|
| 13.0384048104053 | 15.0554530541816 |