How can I find percentages of a number

[Guest]

I have a project that needs to be completed today. I have 21 surveys and I
need to find the average percentage?

 

[Guest]

Do you simply mean an average of cells which are already %s?

=AVERAGE(A1:A10)

A1:A10 contains % values

 

[Stan Brown]

Mon, 30 Jul 2007 11:26:03 -0700 from Toppers

Do you simply mean an average of cells which are already %s?

=AVERAGE(A1:A10)

A1:A10 contains % values

That may or may not be a good procedure. It depends on the bases of
the percents.

For instance, if you have 10/100 = 10% and 2/10 = 20%, the average is
not 15%. Instead, you must compute (10+2)/(100+10) which is 10.91%.

 

[pkaraffa]

Mon, 30 Jul 2007 11:26:03 -0700 from Toppers


That may or may not be a good procedure. It depends on the bases of
the percents.

For instance, if you have 10/100 = 10% and 2/10 = 20%, the average is
not 15%. Instead, you must compute (10+2)/(100+10) which is 10.91%.

--
"The Internet is famously powered by the twin engines of
bitterness and contempt." -- Nathan Rabin, /The Onion/
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Stan,

I understand your concept for two bases of percentages. How would you
adapt it to 10/100 = 10% and 2/10 = 20% and 9/18 = 50% and 7/15 =
0.466666666666667% ?

 

[David Biddulph]

=sum(10,2,9,7)/sum(100,10,18,15)

and note that 7/15 is *not* 0.466666666666667%

 

[Stan Brown]

I understand your concept for two bases of percentages. How would you
adapt it to 10/100 = 10% and 2/10 = 20% and 9/18 = 50% and 7/15 =
0.466666666666667% ?

sum(numerators) / sum(denominators), format as %