Re: Compute weighted average

From: Alex <dead.man.walking_at_gmx.de>
Date: 6 Oct 2006 02:17:40 -0700
Message-ID: <1160126260.795837.223160@b28g2000cwb.googlegroups.com>

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?

THX
Alex Received on Fri Oct 06 2006 - 04:17:40 CDT