Re: variance aggregate function incorrect? Reference Materials reg create aggregate

Joseph Syjuco <joseph@xxxxxxxxxxxxxxxx> writes:
> i needed the variance function ... i dont know if i introduced the wrong
> parameters or maybe this variance is not the variance that im looking
> for but it doesnt provide the right results

> variance=(nEx^2 - (Ex)^2)/(n(n-1))

That's what I'd expect it to do, all right.  Please define "doesnt
provide the right results".

                        regards, tom lane



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)