If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Average" function query
Hi all,
I have an Excel function query that's really bugging me. In column "A" I have about 80 staff annual salaries. In column "B" I have their corresponding annual salary increase. If I sum Column "A", and sum Column "B", and divide the resultant totals, I get what I assume to be the average annual salary increase for the group (3.46%). However, if in Column "C" I calculate each individual's average annual increase (B2/A2 etc), and then use the AVERAGE function over all of the results in column "C" I get a different answer (3.79%). Why is this please, and which answer is correct? Thanks, Robin |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
function error in query (unknown function name) | Bruce L | Running & Setting Up Queries | 5 | October 3rd, 2005 09:22 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
Append Query - Increment Number with Function? | [email protected] | Running & Setting Up Queries | 3 | May 2nd, 2005 05:15 PM |
I want to use the MATCH function with the AVERAGE function but I . | Miguel | Worksheet Functions | 2 | April 23rd, 2005 05:29 PM |