Brian,
> {=SUM(C2:G2*(C2:G2-1))/(SUM(C2:G2)*(SUM(C2:G2)-1))}
Interestingly, this gives the wrong answer in Calc (release 3.0)
my 5 numbers are 2, 8, 1,1, 3
which is 64/210
OOo gives me an answer of 0.02857 using the formula above.
Pasting the formula into Excel gives me 0.304762
and simply dividing 64/210 also gives me 0.304762 (in both OOo and Excel)
And I can't get it to work in NeoOffice at all.
Graham
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
