averaging percentages

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

can someone tell me how to average multiple percentages?

(Excel 2000)


69.1%
63.3%
63.3%
-----
?%

Then below is a rating (not percentage) ??
165.8
137.9
146.5
 
Hi

You can't really average percentages and know that the result is accurate. A
percentage is a ratio between two figures, in effect. Here, 10% of 500 is 50
and 50% of 1000 is 500. The average of these is 30% (in theory) but 30% of
the total (1500) does not give us the average of the actual results (which
should be 550/2)

500 50 10%
1000 500 50%
1500 450 30%
 
thanks for the reply.

_Bigred



Andy B said:
Hi

You can't really average percentages and know that the result is accurate. A
percentage is a ratio between two figures, in effect. Here, 10% of 500 is 50
and 50% of 1000 is 500. The average of these is 30% (in theory) but 30% of
the total (1500) does not give us the average of the actual results (which
should be 550/2)

500 50 10%
1000 500 50%
1500 450 30%
Click to expand...
 
-----Original Message-----
can someone tell me how to average multiple percentages?

(Excel 2000)


69.1%
63.3%
63.3%
-----
?%

Then below is a rating (not percentage) ??
165.8
137.9
146.5
-----
?

TIA,
_Bigred



.
Why not use the AVERAGE funtion?
Click to expand...

=AVERAGE(A1:A23) for example
 
Back
Top