How to analyze big data with Excel

[Paul_Hossler]

The score1 of say 31 is calculated from a country average and the score2 is calculated on city1 vs city2.

So I am not sure on how to proceed. Without the city pairs there is no score2.

Why do you need a 'score2'?



I still think you're thinking city pairs and I'm not sure I'd do it that way

Very simple example of how I'm used to doing a weighted score matrix

1. You're looking at 5 cars (green)

2. Five factors are important (yellow)

3. Since some are more important than others, you weight them (blue)

a. Total = 100% , from 0 - 10, with 10 being the best

b. Some are subject (e.g. color) and some can be quantitative (e.g. gas mileage, 1-10 mpg = 2, 11-15 mpg = 3, ....., > 40mpg = 10)

4. Score each car on each metric 0 - 10 (orange)

5. Apply weighting factors (gold)

6. Total a composite score (gray)

7. Rank high to low by composite score (brown)

In this context, it doesn't seem important to me that (for ex) Ford minus Chevy Low Cost = 3 since Toyota has the highest weighted score



Capture.JPG


Your thoughts??