Make Ratings Equal Weight Across Factors

**ExcelerateMyLearning** · 07-05-2023, 05:38 PM

Hi there,

I'm working on an spreadsheet that compares different cities according to population growth, crime index, etc. It then provides a rating for each city relative to that factor compared to the other cities on the list. The ratings for the different factors are then added together to get an overview of which city performs the best across all factors.

My question: How do I make the ratings for each factor equal in weight?

I've attached my spreadsheet and highlighted the column headers I'm asking about.

Thanks for taking a look and any suggestions!

Logan

**ExcelerateMyLearning** · 07-05-2023, 07:49 PM

Here's a simplified version of the sheet I'm working with.

Comparing Cities 2.xlsx

**MrShorty** · 07-05-2023, 09:48 PM

We're usually pretty good at programming known algorithms into a spreadsheet. We are not always very good at coming up with the algorithms themselves. If you help us understand the algorithm you want to use to make these ratings/ratings factors equal in weight, we should be able to help you program that into the spreadsheet. If you need help coming up with an algorithm we may still be able to help, but we will need something more from you to understand how you are going to combine ratings into an overall score.

If this is more about deriving a methodology, I found this description of one website's methodology for their rating system: https://www.areavibes.com/methodology/ maybe something in that description will provide some inspiration?