Tue, 31 Jul 2007 09:13:50 -0700 from :
On Jul 30, 8:20 pm, Stan Brown wrote:
Mon, 30 Jul 2007 11:26:03 -0700 from Toppers
:

"Finding percentages" wrote:
I have a project that needs to be completed today. I have 21
surveys and I need to find the average percentage?
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%.

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 %

--
"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/