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

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?


"Jose Aleman" wrote:

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

Yes I do.

Thank you very much.

"Dominic" wrote:

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?


"Jose Aleman" wrote:

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

You're welcome.

"Jose Aleman" wrote:

Yes I do.

Thank you very much.

"Dominic" wrote:

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?


"Jose Aleman" wrote:

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