How do I calculate a geometric mean in Access 2003?

G

GGoodell

I would like to create a query that calculates the geometric mean. Can this
be done in Access 2003?
 
J

JohnFol

Access does have some statistical functionality, but primarily it's a DB.
Can you expand on what a Geometric Mean is, just in case it's also known by
another name?
 
S

Steven Greenberg

Access does have some statistical functionality, but primarily it's a
DB. Can you expand on what a Geometric Mean is, just in case it's also
known by another name?
Click to expand...
Access should be able to do this as the geometric mean would simply use the
square root function. the geometric mean of "a" and "b" would be square
root of a*b.
 
J

Jeff Boyce

One approach would be to open a code module and set a reference to the Excel
object library, so you could use the geometric mean function GEOMEAN.
 
S

Steven Greenberg

One approach would be to open a code module and set a reference to the
Excel object library, so you could use the geometric mean function
GEOMEAN.
Click to expand...

you can also create a simple function in access where the geometric mean of
two numbers is sqr(a*b)
 
Top