| 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.
| Thread | ||
|---|---|---|
| • harmonic mean in SQL | Ted Yu | 22 Oct |
| • RE: harmonic mean in SQL | Jay Blanchard | 22 Oct |
