stdev

stdev, function

def nosort process stdev(a: number): number

Returns the sample standard deviation of a (denominator N - 1).

Example

table T = with
  [| as A, as B |]
  [| 0, "a" |]
  [| 0, "a" |]
  [| 0, "b" |]
  [| 1, "b" |]
  [| 2, "c" |]

table G[gdim] = by T.B

show table "Std by group" with
  gdim
  stdev(T.A) as "Std"
  group by gdim

This outputs the following table:

Remarks

The aggregator returns 0 on empty groups.

See also

• stdevp
• The STDEV function in Excel.