Re: Help: Oracle MEAN Function

Eisen Chao <echao_at_interaccess.com> wrote in message news:sl52ds34e7f147_at_corp.supernews.com... <snip>
>
> How would I find
>
> The MEAN for
>
> each office
> each type
>
> if MEAN is defined as
>
> ( MAX(type_amt) + MIN(type_amt) ) / 2
>

You should know that this is not the correct meaning of 'mean'. The mean of a set of values is their sum divided by the number of values. The quantity you mention is of dubious significance, to say the least. The function AVG you mentioned doubtless is exactly equivalent to the definition of mean I have just given.

HTH
Adam

> I looked thru the manual and there are only STDDEV, AVG,
> and a few other statistical functions.
>
Received on Tue Jun 27 2000 - 00:00:00 CDT