|List:||General Discussion||« Previous MessageNext Message »|
|From:||Ted Yu||Date:||October 21 2010 11:12pm|
|Subject:||harmonic mean in SQL|
|View as plain text|
Hi, 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 SQL||Ted Yu||22 Oct|
|• RE: harmonic mean in SQL||Jay Blanchard||22 Oct|