Re: Compute weighted average

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 06 Oct 2006 11:53:47 +0200
Message-ID: <4omnddFf3iiuU1@individual.net>

On 06.10.2006 11:17, Alex wrote:
> Follow up:
> I forgott to mention that the weights of which the values are weighted
> are in the same table:
>
> Name | Month | Value | Weight | WAVG (Factor)
> -----|-------|-------|--------|-------------------
> A | 1 | 10 | 12 | 10,00 (10 * (12/12)
> B | 2 | 20 | 23 | 16,57 ( 10*(12/35) + 20*(23/35) )
> C | 3 | 40 | 56 | 32,31 ( 10*(56/91) + 20*(23/91) +
> 40*(59/91) )
> D | 4 | 30 | 33 | ...
>
> Can anyone tell me wether there is a function to which I can hand over
> VALUE, WEIGHT and RANGE and which'll return the weighted average?

I'm not too experience with analytic functions but I guess you can order by month and name and then use something like AVG(weight * value) / SUM(weight)

HTH robert Received on Fri Oct 06 2006 - 04:53:47 CDT