Berserk Docs
Aggregate FunctionsStatistical

stdevp

Calculates the population standard deviation of values in the group.

Syntax

stdevp(val)

Parameters

Prop

Type

Returns: real

Syntax

stdevp(val)

Parameters

Prop

Type

Returns: real

Examples

Example 1 — Population standard deviation 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 stdevp(crossing_hours)
stdevp_crossing_hours (real)
11.855800268223145

Example 2 — Population standard deviation 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 stdevp(voyages) by clan
clan (string)stdevp_voyages (real)
Fairhair6.5
Lothbrok9.809292646374773

stdevif

Calculates the sample standard deviation of values for which the predicate is true.

sum

Calculates the sum of values in the group.

On this page

SyntaxParametersSyntaxParametersExamplesExample 1 — Population standard deviation of crossing timesExample 2 — Population standard deviation of voyages per clan