average percentage

[lilbit27]

If i have 5 percentages:

92%
100%
82%
96.4%
58.98%

how do I come up with an average for these 5 percentages?

The way I am getting the percentages is with this formula in a unbound
text box:

=IIf([yestotal]+[nototal]<>0,[yestotal]/([yestotal]+[nototal]),"N/A")

 

[Jeff Boyce]

Averaging percentages is risky math.

If I have one out of 100 (1%), and one out of two (50%), my average (of
percentages) is (1 + 50)/2 or about 25%.

But because there were differing numbers of elements used to calculate the
two separate percentages, what I REALLY have is 2 in 102, for a percentage
of just under 2%.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[lilbit27]

Averaging percentages is risky math.

If I have one out of 100 (1%), and one out of two (50%), my average (of
percentages) is (1 + 50)/2 or about 25%.

But because there were differing numbers of elements used to calculate the
two separate percentages, what I REALLY have is 2 in 102, for a percentage
of just under 2%.

Regards

Jeff Boyce
Microsoft Office/Access MVP

If i have 5 percentages:

how do I come up with an average for these 5 percentages?

The way I am getting the percentages is with this formula in a unbound
text box:

=IIf([yestotal]+[nototal]<>0,[yestotal]/([yestotal]+[nototal]),"N/A")- Hide quoted text -

- Show quoted text -

get a too complex error and a parameter box for yestotal and nototal.

Nototal =nz([n1])+nz([n2])+nz([n3])+nZ([n4])+nz([n5])+nz([n6])+nz([n7])
+nz([n8])+nz([n9])

yestotal=nz([y1])+nz([y2])+nz([y3])+nz([y4])+nz([y5])+nz([y6])+nz([y7])
+nz([y8])+nz([y9])

total =IIf([yestotal]+[nototal]<>0,[yestotal]/([yestotal]+
[nototal]),"N/A")

that's how I get my percentages

Now I need the average of the different percentages. and the
=Avg(IIf([yestotal]+[nototal]<>0,[yestotal]/([yestotal]+[nototal]),"N/
A")) is giving me an error.

 

[Jeff Boyce]

What is "-Hide quoted text-" and "-Show quoted text-"?

Where are the calculated controls for [nototal] and [yestotal]?

You are trying to take the Average of values that might include "N/A" -- how
do you average a text string?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Averaging percentages is risky math.

If I have one out of 100 (1%), and one out of two (50%), my average (of
percentages) is (1 + 50)/2 or about 25%.

But because there were differing numbers of elements used to calculate
the
two separate percentages, what I REALLY have is 2 in 102, for a
percentage
of just under 2%.

Regards

Jeff Boyce
Microsoft Office/Access MVP

If i have 5 percentages:

how do I come up with an average for these 5 percentages?

The way I am getting the percentages is with this formula in a unbound
text box:

=IIf([yestotal]+[nototal]<>0,[yestotal]/([yestotal]+[nototal]),"N/A")-
Hide quoted text -

- Show quoted text -

get a too complex error and a parameter box for yestotal and nototal.

Nototal =nz([n1])+nz([n2])+nz([n3])+nZ([n4])+nz([n5])+nz([n6])+nz([n7])
+nz([n8])+nz([n9])

yestotal=nz([y1])+nz([y2])+nz([y3])+nz([y4])+nz([y5])+nz([y6])+nz([y7])
+nz([y8])+nz([y9])

total =IIf([yestotal]+[nototal]<>0,[yestotal]/([yestotal]+
[nototal]),"N/A")

that's how I get my percentages

Now I need the average of the different percentages. and the
=Avg(IIf([yestotal]+[nototal]<>0,[yestotal]/([yestotal]+[nototal]),"N/
A")) is giving me an error.