Hi guys,
I am about ready to lose my mind. I need to figure out how to compare 39 different percentages for a membership recruitment campaign. I work for a membership trade association, and our executive director wants us to use "weighted percentages" to even the playing field for this campaign. So I would need to compare a Division/Section with 1,000+ members to one that only has 3. Obviously if we look at % growth the one with only 3 members would have the highest percentage, but they didn't necessarily recruit the most members, so they shouldn't be rewarded for their effort because they had less to do than a larger Division/Section.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Any ideas? I am at a loss as to what to do here. Any help is appreciated. Or if comparing % growth isn't the best way to measure this so that it would be fair, please feel free to provide your ideas as to what might work.
Thank you!
I am about ready to lose my mind. I need to figure out how to compare 39 different percentages for a membership recruitment campaign. I work for a membership trade association, and our executive director wants us to use "weighted percentages" to even the playing field for this campaign. So I would need to compare a Division/Section with 1,000+ members to one that only has 3. Obviously if we look at % growth the one with only 3 members would have the highest percentage, but they didn't necessarily recruit the most members, so they shouldn't be rewarded for their effort because they had less to do than a larger Division/Section.
| Division/Section | New Members | Membership Total | % Growth |
| Argentine | 2 | 82 | 2.44% |
| Australian/New Zealand | 1 | 189 | 0.53% |
| Brazilian | 7 | 382 | 1.83% |
| British | 5 | 330 | 1.52% |
| Canadian | 3 | 191 | 1.57% |
| Chilean | 1 | 39 | 2.56% |
| Chinese | 10 | 310 | 3.23% |
| Colombian | 2 | 32 | 6.25% |
| Continental European | 5 | 699 | 0.72% |
| Costa Rican | 1 | 13 | 7.69% |
| East & Southern Africa | 2 | 20 | 10.00% |
| Ecuadorian | 0 | 18 | 0.00% |
| Egyptian | 2 | 25 | 8.00% |
| Indian | 2 | 50 | 4.00% |
| Iranian | 3 | 102 | 2.94% |
| Iraqi | 2 | 54 | 3.70% |
| Irish | 4 | 48 | 8.33% |
| Israeli | 4 | 54 | 7.41% |
| Japanese | 20 | 1077 | 1.86% |
| Jordanian | 1 | 3 | 33.33% |
| Korean | 10 | 119 | 8.40% |
| Kuwaiti | 4 | 31 | 12.90% |
| Lebanese | 1 | 12 | 8.33% |
| Mexican | 2 | 47 | 4.26% |
| Nigerian | 0 | 54 | 0.00% |
| Pakistan | 0 | 7 | 0.00% |
| Panamanian | 0 | 2 | 0.00% |
| Peruvian | 3 | 13 | 23.08% |
| Russian | 1 | 12 | 8.33% |
| Saudi Arabian | 11 | 113 | 9.73% |
| Scandinavian | 6 | 233 | 2.58% |
| South African | 3 | 59 | 5.08% |
| Southeast Asian | 2 | 198 | 1.01% |
| Sudanese | 0 | 1 | 0.00% |
| Syrian | 1 | 8 | 12.50% |
| Tunisian | 3 | 54 | 5.56% |
| United Arab Emirates | 1 | 9 | 11.11% |
| Uruguayan | 0 | 18 | 0.00% |
| Venezuelan | 0 | 12 | 0.00% |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Any ideas? I am at a loss as to what to do here. Any help is appreciated. Or if comparing % growth isn't the best way to measure this so that it would be fair, please feel free to provide your ideas as to what might work.
Thank you!
