The STDEVP aggregation function returns the population standard deviation of the source values.

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

ArgumentData typeDescription
SourceNumberThe values to return the population standard deviation of.
MappingDate, 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.

STDEVP uses this formula:

STDEVP=∑(x−xˉ)2n\hspace{10 mm} \text{STDEVP} = \sqrt{\frac{\sum (x - \bar{x})^2}{n}}

where

  • x is each individual value in the data set.
  • x̄ is the mean average of the data set.
  • n is the sample size or the total number of values in the data set.

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

STDEV.P

Examples