I have four items, each scored in three different categories. I would like to end up with one "final" score, which is a balance between the three scores.
----------------------------------------------
ID | Score 1 | Score 2 | Score 3 | Final Score
1 | 0.3 | 12 | 70 |
2 | 0.7 | 19 | 95 |
3 | 0.6 | 22 | 61 |
4 | 0.2 | 9 | 29 |
----------------------------------------------
Because each of the three metrics is equally important, I would like each one to have the same weight. However, simply adding them won't suffice, since one score is much bigger than the other (so in the example above, Score 3 would be likely to autonomously determine the final score). How could I compute a final score in which each of the three scores has the exact same 'influence'?