STDEV.S DAX Function (Statistical)
Estimates standard deviation based on a sample. Ignores logical values and text in the sample.
Syntax
Parameter | Attributes | Description |
---|---|---|
ColumnName |
A column that contains numbers corresponding to a sample of a population. |
Return values
The standard deviation of a sample population.
Remarks
STDEV.S assumes that the column refers to a sample of the population.
To compute the standard deviation with the entire population, use STDEV.P.
The STDEV.S function internally executes STDEVX.S, without any performance difference.
The following STDEV.S call:
STDEV.S ( table[column] )
corresponds to the following STDEVX.S call:
STDEVX.S ( table, table[column] )
» 3 related functions
Examples
-- Computes the standard deviation over a table of values -- -- STDEV.P : standard deviation over the entire population -- STDEV.S : standard deviation over a sample of the entire population -- -- STDEVX is an iterator, STDEV is the simplified version in case -- you are using a single column. DEFINE TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 } EVALUATE { ( "STDEV.P", STDEV.P ( SampleData[Value] ) ), ( "STDEV.S", STDEV.S ( SampleData[Value] ) ), ( "STDEVX.P", STDEVX.P ( SampleData, SampleData[Value] ) ), ( "STDEVX.S", STDEVX.S ( SampleData, SampleData[Value] ) ), ( "STDEVX.P", STDEVX.P ( Sales, Sales[Quantity] * Sales[Net Price] ) ), ( "STDEVX.S", STDEVX.S ( Sales, Sales[Quantity] * Sales[Net Price] ) ) } -- The STDEV.S over SampleData is very different from STDEV.P because the -- set is small (8 rows for the population, 8 rows for the sample) -- When applied to Sales, the difference is small in hidden decimals because -- the set used has 100,000 rows
Value1 | Value2 |
---|---|
STDEV.P | 2.0000000000 |
STDEV.S | 2.1380899353 |
STDEVX.P | 2.0000000000 |
STDEVX.S | 2.1380899353 |
STDEVX.P | 588.4956677430 |
STDEVX.S | 588.4986034618 |
Related articles
Learn more about STDEV.S in the following articles:
-
Statistical Patterns
DAX includes a few statistical aggregation functions, such as average, variance, and standard deviation. Other typical statistical calculations require you to write longer DAX expressions. Excel, from this point of view, has a much richer language. The Statistical Patterns are a collection of common statistical calculations: median, mode, moving average, percentile, and quartile. » Read more
Related functions
Other related functions are:
Last update: Oct 3, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/stdev-s-function-dax