Hi guys,

I need to rank performance of people based on 4 attributes.
Each person should be ranked on a 1 - 5 scale.

- I need to further split this into 2 cases and check which approach is more appropriate:

- Case 1:
- For attributes 1 to 3, the higher the value the better. For attribute 4, the lower the value the better
- All attributes are important

Name Attribute 1 Attribute 2 Attribute 3 Attribute 4
john 80 80 90 2
jake 50 70 80 4
jill 90 60 80 5
jim 100 85 60 2
jade 50 80 50 7
jin 30 90 50 6

- In this case, since all attributes are important, john should have rank 1 since he is in the top range of the first three attributes and the bottom range of the fourth attribute.
- Basically, in this case, the rank on a 1-5 scale would depend on the combination of all attributes.

Case 2:
Same data

- For attributes 1 to 3, the higher the value the better. For attribute 4, the lower the value the better (same as above)
- Here, attribute 1 gets 50% of the weight, attribute 2 gets 15%, attribute 3 gets 15% and attribute 4 gets 20%.

Any help is appreciated.
Thank You