Weighting Results to obtain an overall rank

[Guest]

I am trying to weight a series of results and the obtain an overall rank.
Here is an example...

locations Result 1 Result 2 Result 3
location1 515 89% 4.5%
location2 431 72% 2.3%
location3 535 n/a 5.0%

Weighting...
Result 1 = 30%
Result 2 = 50%
Result 3 = 20%
Total - 100%

What I am trying to do is determine which location is ranked the highest
overall.

I inititally thought since the results varied in their number format that I
would rank each result by location. ex: Location1 > Result 1 > Ranked = 2

I then took the rank and * by the weight. ex: Location1 > Result 1 > Ranked

2*30%

I then did that to each category and added the weighting together and
divided by 100%

I'm honestly not sure if I was correct in the mathmatics of the formula. I
also need to know how to not have a result count if the location did not have
a result. ex: location3 > result 2 = n/a. I do not want that to count against
them and need to know how to omit that from the equation. And lastly, If
there is an easier way to obtain this result, I would love to know. I feel
I'm complicating this process when I feel there is a way to simplify the
process.

 

[Jim Cone]

For what it's worth...
If you are missing a score that has a 50% weight, you are
not going to be able to give the location an objective rank.
You could plug in an "average" score in order to complete the
rankings, but the rankings would be meaningless.

Location3 rank should be "Not enough data"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"casdaq" <[email protected]>
wrote in message
I am trying to weight a series of results and the obtain an overall rank.
Here is an example...

locations Result 1 Result 2 Result 3
location1 515 89% 4.5%
location2 431 72% 2.3%
location3 535 n/a 5.0%

Weighting...
Result 1 = 30%
Result 2 = 50%
Result 3 = 20%
Total - 100%

What I am trying to do is determine which location is ranked the highest
overall.

I inititally thought since the results varied in their number format that I
would rank each result by location. ex: Location1 > Result 1 > Ranked = 2

I then took the rank and * by the weight. ex: Location1 > Result 1 > Ranked

2*30%

I then did that to each category and added the weighting together and
divided by 100%

I'm honestly not sure if I was correct in the mathmatics of the formula. I
also need to know how to not have a result count if the location did not have
a result. ex: location3 > result 2 = n/a. I do not want that to count against
them and need to know how to omit that from the equation. And lastly, If
there is an easier way to obtain this result, I would love to know. I feel
I'm complicating this process when I feel there is a way to simplify the
process.