|
Weighted Avg
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 |
Weighted Avg
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 |
Weighted Avg
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 |
Weighted Avg
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 |
| All times are GMT +1. The time now is 06:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com