| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I find percentages of a number
I have a project that needs to be completed today. I have 21 surveys and I
need to find the average percentage? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find percentages of a number
Do you simply mean an average of cells which are already %s?
=AVERAGE(A1:A10) A1:A10 contains % values "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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find percentages of a number
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/ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I find percentages of a number
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating percentages based on the number of checked boxes in a column | Excel Worksheet Functions | |||
| Calculating percentages based on the number of checked boxes in a column | Excel Discussion (Misc queries) | |||
| Pivot Table Question: Show percentages and standard number format | Excel Discussion (Misc queries) | |||
| Programmatically find out if Chart displays Percentages | Charts and Charting in Excel | |||
| How do I Calculate Percentages for each number in a column? | Excel Discussion (Misc queries) | |||
Linear Mode
