Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Create composite ranking of items ranked in multiple categories - Really simple math!

  1. Dec 19, 2012 #1
    Hey all,

    So the idea is that I'm trying to create a composite ranking system of items that are already in different categories. For example, suppose there are 4 houses that a buyer is choosing from. These 4 houses are ranked 1-4 in each of the categories such as affordability, location, and design. These categories are then rated Very Important to Not Important (1-4, respectively). I want to create a final ranking of the housings based on this data. What's the best way to do this?

    What I've thought of:

    Pick a house, and multiply its ranking in a category by the importance of that category. Continue to do this for that house for each category, continuing to add to the score. Then divide this score by the maximum score which is the summation of the importance values. Then finally multiply this by 100 to get a percentage match score.

    Here's the idea:
    Ʃ(house ranking in a category*importance of that category)/Ʃ(importances) * 100

    I feel like this is too simplistic and results in error. What would be a better way?

    The important thing is coming up with a relevant score value for each house. I've looked at Borda, Condorcet, and Range systems as examples, but I'm not sure what is best.
     
    Last edited: Dec 19, 2012
  2. jcsd
  3. Dec 19, 2012 #2
    Re: Create composite ranking of items ranked in multiple categories - Really simple m

    Ʃ(house ranking in a category*importance of that category) does all the work.
    The rest is just 'normalization' - scaling for convenience.

    With this scheme the lower the score the better:
    A house ranked #1 in all 4 categories would have a score of 10.
    A house ranked #4 in all 4 categories would have a score of 40.
     
  4. Dec 19, 2012 #3

    jbriggs444

    User Avatar
    Science Advisor

    Re: Create composite ranking of items ranked in multiple categories - Really simple m

    Why don't you evaluate the Borda, Condorcet and Range systems according to a set of attributes, rank those attributes for importance and then select the system that scores best?
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Create composite ranking of items ranked in multiple categories - Really simple math!
Loading...