Average % percentage

Question

I have 4 sets of numbers with different percentage, how do I find out the average percentage?

 

1) 50,011 - 57.5%

2) 50,552 - 55%

3) 32,324 - 49%

4) 45,023 - 51%

Answer 1

I suggest weighting the averages according to the amount paid.  For example, you paid 50,552 for a discount of 55% (B), so it should weigh more than paying only 32,324 for a discount of 49% (C).  To get the weighted average, multiply each payment by the discount associated with it, add up all these products, then divide by the sum of the the amounts paid.  If I am interpreting the information correctly, this will give a more realistic average.

 

A = weighted average

 

A = [50,011(57.5) + 50,552(55) + 32,324(49) + 45,023(51)] / (50,011 + 50,552 + 32,324 + 45,023) = 53.60

 

(By the way, that total in your line 4 should be 177,910.)