RE: harmonic mean in SQL

2010-10-22 Thread Jay Blanchard
f you have experience with computing harmonic mean in SQL, please share. [/snip] Unless I am misunderstanding your question the simplest method would be; SELECT ((n1 + n2)/(n1/x1 + n2/x2)) AS "Harmonic Mean" ...without knowing the structure of the data. If X1 and X2 live on 2 different ro

harmonic mean in SQL

2010-10-21 Thread Ted Yu
experience with computing harmonic mean in SQL, please share.