The VARS aggregation function returns the unbiased sample variance of a given line item. 

This function can be useful for estimating sales deal variance by region or manufacturing defect rate variance.

Syntax

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

Arguments

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

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

This argument can be repeated to provide multiple mappings.

The VARS aggregation function returns a numeric result.

Calculation engine functionality differences

This function is only available in the Polaris Calculation Engine.

Syntax example

'Recent Deals'.'Deal Value'[VARS: 'Deal Region Map'.'Sales Region']

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 root of VARS is equal to STDEVS. See Related Anaplan functions, below.

VARS uses this formula:

VARS=∑(x−xˉ)2n−1\hspace{10 mm} \text{VARS} = {\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 VARS with another number-typed aggregation function.
  • VARS returns zero for unmapped points.
  • You can’t use VARS together with the Formula summary method.
  • You can’t use VARS in version formulas.

Excel equivalent

VAR.S

Examples