Berserk Docs
Aggregate FunctionsStatistical

variance

Calculates the sample variance of values in the group.

Syntax

variance(val)

Parameters

Prop

Type

Returns: real

Syntax

variance(val)

Parameters

Prop

Type

Returns: real

Examples

Example 1 — Sample variance of crossing times

datatable(ship:string, crossing_hours:real)[
  "Naglfar", 48.0,
  "Wave Rider", 72.0,
  "Storm Bear", 36.5,
  "Sea Serpent", 55.0,
  "Ravens Wing", 60.0
]
| summarize variance(crossing_hours)
variance_crossing_hours (real)
175.70000000000002

Example 2 — Variance of voyages per clan

datatable(clan:string, warrior:string, voyages:long)[
  "Lothbrok", "Ragnar", 42,
  "Lothbrok", "Bjorn", 31,
  "Lothbrok", "Ivar", 18,
  "Fairhair", "Harald", 25,
  "Fairhair", "Halfdan", 12
]
| summarize variance(voyages) by clan
clan (string)variance_voyages (real)
Fairhair84.5
Lothbrok144.33333333333331

take_anyif

Returns an arbitrary non-null value from the group for which the predicate is true.

varianceif

Calculates the sample variance of values for which the predicate is true.

On this page

SyntaxParametersSyntaxParametersExamplesExample 1 — Sample variance of crossing timesExample 2 — Variance of voyages per clan