Berserk Docs
Aggregate FunctionsStatistical

variancep

Calculates the population variance of values in the group.

Syntax

variancep(val)

Parameters

Prop

Type

Returns: real

Syntax

variancep(val)

Parameters

Prop

Type

Returns: real

Examples

Example 1 — Population 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 variancep(crossing_hours)
variancep_crossing_hours (real)
140.56

Example 2 — Population 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 variancep(voyages) by clan
clan (string)variancep_voyages (real)
Fairhair42.25
Lothbrok96.22222222222221

varianceif

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

arg_max

Returns both the maximum value and the corresponding return expression from the row where the first expression is maximum.

On this page

SyntaxParametersSyntaxParametersExamplesExample 1 — Population variance of crossing timesExample 2 — Population variance of voyages per clan