Weighted Avg

J

Jose Aleman

Hello,

I have never done a weighted average before and I was wondering if you can
help me. Here is an example of my population and I need the Weighted Avg on
the Ratio.

Account Release Bucket Ratio
708267 04/01/06 90+ 29
841415 04/01/06 90+ 46
844776 04/01/06 90+ 44
1348900 04/01/06 90+ 48
1374454 04/01/06 90+ 29
1377459 04/01/06 90+ 45
1384588 04/01/06 90+ 34
1397076 04/01/06 90+ 39
1401258 04/01/06 90+ 53
1401970 04/01/06 90+ 54
1402709 04/01/06 90+ 28
1407850 04/01/06 90+ 37

Avg 40
Weighted Avg

Thanks
 
D

Dominic

Jose,

I do not believe there is enough information here to provide a weighted
average. A weighted average, in general, means that each value you have to
average is assigned a "weight".

For example, suppose you wanted an average of sales. You have three regions.
Region A had one sale of $80. Region B had one sale of $200. Region C had
five sales of 20$.

The "average" would be 80+200+20 divided by 3. Which equals $100.
The "weighted average" would be 80+200+20+20+20+20+20 divided by 7. Which
equals $54.29.

In your data below, there is nothing to "weight" the values for Ratio.

Does this make sense?
 
J

Jose Aleman

Yes I do.

Thank you very much.

Dominic said:
Jose,

I do not believe there is enough information here to provide a weighted
average. A weighted average, in general, means that each value you have to
average is assigned a "weight".

For example, suppose you wanted an average of sales. You have three regions.
Region A had one sale of $80. Region B had one sale of $200. Region C had
five sales of 20$.

The "average" would be 80+200+20 divided by 3. Which equals $100.
The "weighted average" would be 80+200+20+20+20+20+20 divided by 7. Which
equals $54.29.

In your data below, there is nothing to "weight" the values for Ratio.

Does this make sense?
Click to expand...
 
Top