Forum Discussion
Weighted average reverse
I am calculating weighted average based on BENEFITS (60%) and EFFORTS (40%) and give a total score. Example table: CRITERIA WEIGHTAGE SCORE BENEFITS 60% 10 EFFORTS 40%...
Since it appears that you're expecting the weights to add to 100%, it would appear that the calculation is correct. But is that the case?
And are the numbers under "Score" limited to the range of 1-10? Or can they range more widely. Can they be other than integers?
So, in addition to defining the whole situation a bit more fully, it would help if you could spell out in an example or two what a "correct score" would look like as the "Effort" number goes up or down.