The STDEVP aggregation function returns the population standard deviation of a given line item.
This function can be useful for calculating the variability of survey responses for different customer segments or to see how much test scores vary within each class.
Syntax
Source[STDEVP: Mapping, STDEVP: Mapping 2, etc.]
Arguments
| Argument | Data type | Description |
| Source | Number | The values to return the population standard deviation of. |
| Mapping | Date, time period, list | The mapping that determines which values to return the population standard deviation of. This argument can be repeated to provide multiple mappings. |
The STDEVP aggregation function returns a numeric result.
Calculation engine functionality differences
This function is only available in the Polaris Calculation Engine.
Syntax example
'Product Ratings'.'Customer Rating'[STDEVP: 'Product to Category Map'.'Product Category']
Additional information
- The population variance of a single value is zero.
- The population variance of a set of values, which includes NaN, is NaN.
- The square of STDEVP is equal to VARP. See Related Anaplan functions, below.
Constraints
- You can't use STDEVP with another number-typed aggregation function.
- STDEVP returns zero for unmapped points.
- You can't use STDEVP together with the Formula summary method.
- You can't use STDEVP in version formulas.
Excel equivalent
Examples
Example 1: Calculate the variability of survey responses for different customer segments
Example 2: Calculate how employee performance ratings vary within each department
