Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
I have two columns.
one contains two variables (John or Eddie) the other contains a precentage per job relative to the painter (john or Eddie). What is the best way to get an average percentage for each of the painters. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
You really need to know the size of each job, as you can't just add
the percentages together and take an average. Someone with a large percentage of a small job would be skewed compared to someone else having a smaller percentage of a larger job. Hope this helps. Pete On Jun 30, 4:47*pm, MPAVLAS wrote: I have two columns. one contains two variables (John or Eddie) the other contains a precentage per job relative to the painter (john or Eddie). What is the best way to get an average percentage for each of the painters. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
The percentage is Gross Profit on a job. Yes, job size does matter but there
would be too many variables to sort through to make the report completely accurate. I am just lloking to find the avergae gross precentage of each technician. If I sort the techs myself I can easily find there average, but I do not want seperate pages for each tech. I owuld like to just be able to use excel to sort through the list and do it for me. I know it is possible, I have seen excel do way more. "Pete_UK" wrote: You really need to know the size of each job, as you can't just add the percentages together and take an average. Someone with a large percentage of a small job would be skewed compared to someone else having a smaller percentage of a larger job. Hope this helps. Pete On Jun 30, 4:47 pm, MPAVLAS wrote: I have two columns. one contains two variables (John or Eddie) the other contains a precentage per job relative to the painter (john or Eddie). What is the best way to get an average percentage for each of the painters. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
Let's say the two technicians do two jobs - for the first (which is
worth, say, $500) the split is 90%:10%, but on the second job (worth $2000) the split is 40%:60%. The strict average of the percentage split is 65%:35%, but this is meaningless. You need to take the value of each job split between the two, i.e. 450:50 and 800:1200 and compare these - 1250:1250, or 50%:50%. Hope this helps. Pete On Jun 30, 5:38*pm, MPAVLAS wrote: The percentage is Gross Profit on a job. Yes, job size does matter but there would be too many variables to sort through to make the report completely accurate. I am just lloking to find the avergae gross precentage of each technician. If I sort the techs myself I can easily find there average, but I do not want seperate pages for each tech. I owuld like to just be able to use excel to sort through the list and do it for me. I know it is possible, I have seen excel do way more. "Pete_UK" wrote: You really need to know the size of each job, as you can't just add the percentages together and take an average. Someone with a large percentage of a small job would be skewed compared to someone else having a smaller percentage of a larger job. Hope this helps. Pete On Jun 30, 4:47 pm, MPAVLAS wrote: I have two columns. one contains two variables (John or Eddie) the other contains a precentage per job relative to the painter (john or Eddie). What is the best way to get an average percentage for each of the painters.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
No.....Here is my example....
John 50% Eddie 48% Eddie 55% Eddie 66% John 48% John 40% Now I know how to find the averages if I wanted to do it manually, but these figures are just part of a data sheet. I am looking for the average precent per technician based of of precents, not totals. "Pete_UK" wrote: Let's say the two technicians do two jobs - for the first (which is worth, say, $500) the split is 90%:10%, but on the second job (worth $2000) the split is 40%:60%. The strict average of the percentage split is 65%:35%, but this is meaningless. You need to take the value of each job split between the two, i.e. 450:50 and 800:1200 and compare these - 1250:1250, or 50%:50%. Hope this helps. Pete On Jun 30, 5:38 pm, MPAVLAS wrote: The percentage is Gross Profit on a job. Yes, job size does matter but there would be too many variables to sort through to make the report completely accurate. I am just lloking to find the avergae gross precentage of each technician. If I sort the techs myself I can easily find there average, but I do not want seperate pages for each tech. I owuld like to just be able to use excel to sort through the list and do it for me. I know it is possible, I have seen excel do way more. "Pete_UK" wrote: You really need to know the size of each job, as you can't just add the percentages together and take an average. Someone with a large percentage of a small job would be skewed compared to someone else having a smaller percentage of a larger job. Hope this helps. Pete On Jun 30, 4:47 pm, MPAVLAS wrote: I have two columns. one contains two variables (John or Eddie) the other contains a precentage per job relative to the painter (john or Eddie). What is the best way to get an average percentage for each of the painters.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting other than a-z | New Users to Excel | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
sorting | Excel Discussion (Misc queries) |