Calculates the standard deviation of the specified set. This function assumes that the set represents the entire population. If you want to calculate based a sample of a population, use Stddev.
Standard deviation is a measure of how widely values are dispersed from their mean (average).
Syntax
Stddevp ( set [,numeric_value_expression [,IncludeEmpty] ])
Parameter | Description |
---|---|
A valid MDX set specification. | |
numeric_value_expression | A numeric value or an expression that returns a numeric value (see MDX Grammar Rules). |
IncludeEmpty | Use this keyword if you want to include in the calculation any tuples with #MISSING values. Otherwise, they are omitted by default. |
Example
The following example, based on Sample Basic, calculates the standard deviation (based on the entire population) of the January sales values for all products sold in New York.
WITH MEMBER [Measures].[Std Deviation] AS 'StddevP( Crossjoin( {[Product].Children}, {[Measures].[Sales]} ) ) ' SELECT {[Scenario].[Actual],[Scenario].[Budget]} ON COLUMNS, {Crossjoin( {[Measures].[Sales]},{[Product].Children} ), Crossjoin( {[Measures].[Sales], [Measures].[Std Deviation]}, {[Product]} )} ON ROWS FROM Sample.Basic WHERE ([Year].[Jan], [Market].[New York])
This query returns the following grid:
(axis) | Actual | Budget |
---|---|---|
(Sales, 100) | 678 | 640 |
(Sales, 200) | 551 | 530 |
(Sales, 300) | 663 | 510 |
(Sales, 400) | 587 | 620 |
(Sales, Diet) | #Missing | #Missing |
(Sales, Product) | 2479 | 2300 |
(Std Deviation, Product) | 52.59 | 55.9 |
See Also