The STDEVS aggregation function returns the sample standard deviation of the source values.

This function can be useful for analyzing sample customer feedback variability or sample sales rep deal size variation.

Syntax

Source[STDEVS: Mapping, STDEVS: Mapping 2, etc.]

Arguments

ArgumentData typeDescription
SourceNumberThe values to return the sample standard deviation of.
MappingDate, time period, list

The mapping that determines which values to return the sample standard deviation of.

This argument can be repeated to provide multiple mappings.

The STDEVS aggregation function returns a numeric result.

Calculation engine functionality differences

This function is only available in the Polaris Calculation Engine.

Syntax example

'Recent Feedback'.'Feedback Score'[STDEVS: 'Product Assignment'.'Product Type']

Additional information

  • The sample variance of a single value is zero.
  • The sample variance of a set of values, which includes NaN, is NaN.
  • The square of STDEVS is equal to VARS. See Related Anaplan functions, below.

STDEVS uses this formula:

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

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 STDEVS with another number-typed aggregation function.
  • STDEVS returns zero for unmapped points.
  • You can’t use STDEVS together with the Formula summary method.
  • You can’t use STDEVS in version formulas.

Excel equivalent

STDEV.S

Examples