Calculating different sorts of averages

[Welshbird]

Hi y'all.

I'm trying to calculate the three different sorts of average, and I can see

AVG as mean
MEDIAN as median,

But I can't seem to pick a function which would find me the MODE. I guess I can build one with out too much trouble, but it strikes me that if Oracle includes the other two, it presumably includes the one calculated as the most frequently occuring answer?

Any ideas anyone?
Thanks

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[Thargy]

Fee,

I agree, there appears to be no such function within Oracle.

A perusal of the SQL reference

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/functions001.htm#sthref1044

shows that there is indeed a MOD and MEDIAN function, but no mode.

I have googled, and the word "mode" swamps the returns with irrelevancies. I suggest that you write your own mode function, and let us know what you come up with. A nice interesting one Fee - how does one prove a negative?

Regards

Tharg

Grinding away at things Oracular

 

[KenCunningham]

Fee - don't know if this helps:

http://asktom.oracle.com/pls/ask/f?...P8_DISPLAYID,F4950_P8_CRITERIA:17329730362010