List:General Discussion« Previous MessageNext Message »
From:Ted Yu Date:October 21 2010 11:12pm
Subject:harmonic mean in SQL
View as plain text  
The mathematical way to add two "partial" harmonic means to generate new
harmonic mean is:

Let X1  , X2 be two harmonic means on different rollup rows, generated using
n1 and n2 # of facts respectively.

The combined harmonic mean would be:

(n1 + n2)/( n1/x1 + n2/x2)

If you have experience with computing harmonic mean in SQL, please share.

harmonic mean in SQLTed Yu22 Oct
  • RE: harmonic mean in SQLJay Blanchard22 Oct