Hi,

I have 9 a weighted average calculated as below
Person 1 57.14 7 399.98
Person 2 72.22 18 1299.96
Person 3 88.89 9 800.01
Person 4 93.75 16 1500
Person 5 55.56 9 500.04
Person 6 80 5 400
Person 7 100 6 600
Person 8 64.71 17 1100.07
Person 9 80 15 1200
Totals 102 7800.06 76.47118

The second column is an average of accuracy scores of the person on the number of cases in the third column.

The fourth column is the result of the product of the two previous columns I use to calculate the weighted average of the whole team.

What I want to know is, having a target of 85%, how do I calculate the importance of each single person in reaching it (or failing it as in this case)?

Please help
Fex329