Quick Benchmarks has a tool called “Combine Multiple Jobs”. When using this tool job results are naturally weighted, meaning it takes all the employees who are matched to the jobs selected to be combined and calculate summary statistics of the group. For example, if you are combining three jobs, the average of the 3 jobs would calculate the average for each individual job first, then take the average of the job averages.
The chart below provides a visual of what the system is doing:
|
job A |
employee A |
100 |
|
job A |
employee B |
200 |
|
job A |
employee C |
300 |
|
job A |
employee D |
100 |
|
job B |
employee E |
200 |
|
job B |
employee F |
300 |
|
job C |
employee G |
200 |
|
job C |
employee H |
100 |
|
|
|
|
|
|
Average of combined jobs |
188 |
|
|
|
|
|
|
|
|
|
|
Average of Job A |
175 |
|
|
Average of Job B |
250 |
|
|
Average of Job C |
150 |
|
|
|
|
|
|
Average of the averages |
192 |
In another example, this is where the natural average and the average of averages are the same
|
job A |
employee A |
100 |
|
job A |
employee B |
200 |
|
job A |
employee C |
300 |
|
job B |
employee D |
100 |
|
job B |
employee E |
200 |
|
job B |
employee F |
300 |
|
job C |
employee G |
200 |
|
job C |
employee H |
200 |
|
|
|
|
|
|
Average of combined jobs |
200 |
|
|
|
|
|
|
|
|
|
|
Average of Job A |
200 |
|
|
Average of Job B |
200 |
|
|
Average of Job C |
200 |
|
|
|
|
|
|
Average of the averages |
200 |