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