geomean function for ms access

D

doco

Have looked on the web and manuals for algorithym to calculate the geomean()
of a list of ratios. Does anyone know where this may be found? Or have one?

TIA
doco
 
M

MacDermott

My memory from high school (a long time ago) is that a geometric mean is
calculated by multiplying the factors together then exponentiating it to the
inverse of the count of items.
geomean(a,b)=(ab)^1/2
geomean(a,b,c)=(abc)^1/3
geomean(a,b,c,d)=(abcd)^1/4

Shouldn't be too hard to code that as a function which takes an array as its
argument...

HTH
- Turtle
 
Top