Average Percentage help please

[kyleuk via OfficeKB.com]

Hi I have a row that shows payout percentages from a fruit machine every time
I record in & out data
could anyone help me with the formula needed to show an average percentage
payout.
IE:

G4 = 88%
G8 = 78%
G12 = 91%

How would I work out what the average percentage is ?
All previous help much appreciated.

 

[Niek Otten]

=AVERAGE(G4,G8,G12)

But, be careful! The average of the percentages is not the same as the
average percentage of the underlying figures!
It depends on what exactly you're trying to achieve. If in doubt, post again
in this thread, with some examples of the underlying data as well.

 

[Roger Govier]

Hi

=AVERAGE(G4,G8,G12)

Regards

Roger Govier

 

[kyleuk via OfficeKB.com]

Hi Niek
Every week I record money in and money out data and from that I work out
using =(C9/B9) and showing as a payout percentage since last week.

Is there a formula to look at all the percentages so far and show an average ?

And how would it be applied as you said that "The average of the percentages
is not the same as the
average percentage of the underlying figures"

Do I need to calculate the average percentage from the money in and out cells
and not from the percentages.

Thanks for your help.

=AVERAGE(G4,G8,G12)

But, be careful! The average of the percentages is not the same as the
average percentage of the underlying figures!
It depends on what exactly you're trying to achieve. If in doubt, post again
in this thread, with some examples of the underlying data as well.

Hi I have a row that shows payout percentages from a fruit machine every
time

[quoted text clipped - 9 lines]

How would I work out what the average percentage is ?
All previous help much appreciated.

 

[Roger Govier]

Hi

I think what Niek was quite rightly referring to, is that the straight
arithmetic average of your 3 percentages, gives no account to weighting,
with regard to the sample size.

Imagine columns A, B and C, with Turnover in A, Profit in B and Percent
profit in C
A B C
100 78 78% C=B/A formatted as percentage
100 87 87%
250 200 80%
300 225 75%
100 96 96%
50 49 98%
160 90 56%
200 150 75%
100 80 80%
81% Average of percentages =AVERAGE(C1:C10)
1360 1055 78% True Average percentage =SUM(A1:A10)/SUM(B1:B10)

I hope this helps.


Regards

Roger Govier

Hi Niek
Every week I record money in and money out data and from that I work out
using =(C9/B9) and showing as a payout percentage since last week.

Is there a formula to look at all the percentages so far and show an average ?

And how would it be applied as you said that "The average of the percentages
is not the same as the
average percentage of the underlying figures"

Do I need to calculate the average percentage from the money in and out cells
and not from the percentages.

Thanks for your help.

=AVERAGE(G4,G8,G12)

But, be careful! The average of the percentages is not the same as the
average percentage of the underlying figures!
It depends on what exactly you're trying to achieve. If in doubt, post again
in this thread, with some examples of the underlying data as well.

Hi I have a row that shows payout percentages from a fruit machine every
time

[quoted text clipped - 9 lines]

How would I work out what the average percentage is ?
All previous help much appreciated.

 

[keithl816]

Hi kyleuk,

Try

=subtotal(1, g4, g8, g12)