Average Percentage help please

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.

=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.

--
Kind regards,

Niek Otten

"kyleuk via OfficeKB.com" <u15338@uwe> wrote in message
news:56ab69e9838b0@uwe...
> 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.

Hi

=AVERAGE(G4,G8,G12)

Regards

Roger Govier


kyleuk via OfficeKB.com wrote:
> 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.

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.

Niek Otten wrote:
>=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.

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


kyleuk via OfficeKB.com wrote:
> 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.
>
> Niek Otten wrote:
>
>>=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.

Hi kyleuk,

Try

=subtotal(1, g4, g8, g12)