• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

Geometric average in VB or SQL

Does anyone know a formula for calculating a geometric mean in visual basic or SQL?
0
colleenasmith
Asked:
colleenasmith
3 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
 
nito8300Commented:
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
colleenasmithAuthor Commented:
i'm actually trying to calc geometric mean for a return series (with some negative numbers) and it's giving me an error - the argument to 'log' must be positive.
0
 
imran_fastCommented:
then incase of -ve value use the absolute value and then later on multipy the value with -1.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
I think, we must split the points among the three
0
 
VenabiliCommented:
Works for me :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now