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.

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.

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.

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 -

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 -