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.
|