how do I give weights to averages

[sds1rrnch]

How do I give different weights to the totals That I am averaging?

[Duke Carey]

Let's say column A contains the values and B contains the weights, expressed
as decimals. Column B needs to sum to 100% for this to be correct.

=sumproduct(A1:A10,B1:b10)/sum(A1:a10)

"sds1rrnch" wrote:

> How do I give different weights to the totals That I am averaging?

[Duke Carey]

Not quite correct:

=sumproduct(A1:A10,B1:b10)


"Duke Carey" wrote:

> Let's say column A contains the values and B contains the weights, expressed
> as decimals. Column B needs to sum to 100% for this to be correct.
>
> =sumproduct(A1:A10,B1:b10)/sum(A1:a10)
>
> "sds1rrnch" wrote:
>
> > How do I give different weights to the totals That I am averaging?

[Ron Coderre]

Multiply them by a percent.
All percents must add to 100%

Example:

A1: a sum that equals 100
A2: a sum that equals 50

B1: 75%
B2: 25%

B3: =sumproduct(A1:A2,B1:B2)
The weighted average is 87.5

Note: That formula is the same as:
B3: =(A1*B1)+(A2*B2)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"sds1rrnch" wrote:

> How do I give different weights to the totals That I am averaging?