averaging percentages

[_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

 

[Andy B]

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%

 

[_Bigred]

thanks for the reply.

_Bigred

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%

 

[Wayhe]

-----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?

=AVERAGE(A1:A23) for example