How do I calculate a geometric mean in Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a query that calculates the geometric mean. Can this
be done in Access 2003?
 
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?
 
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.
 
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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Geometric Standard Deviation 11
geometric mean of a series of negative asset returns 8
I need to calculate a Geometric mean 7
Access 2003 functions 3
precision in access versus excel 1
Geometric wide lines drawing for printer device driver 0
Create Aggregate function 5
how to input a calculation in excel to find the geometric mean 3

Back
Top