avg

avg, function

def autodiff process avg(a : number): number

The aggregator returns the numerical average of the grouped numbers.

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

table G[gdim] = by T.B

where T.B != "c"
  show table "" a1b4 with
    gdim
    avg(T.A)
    group by gdim

The aggregator returns 0 on empty groups.

avg, montecarlo sampler

The accumulator returns the numerical average of the observed samples.

r = poisson(3)
montecarlo 1000 with
  deviate = random.ranvar(r)
  sample mean = avg(deviate)

show scalar "Average" with mean // 2.93