in reply to Proportionate redistribution of weights

Simple, just distribute that 20% among the rest three according to their ratio 8:6:2. This should result the same as if you re-distribute the original 100% among those 3 according to this same ratio 8:6:2. Either way, the end result would be 50%, 37.5%, 12.5%.

  • Comment on Re: Proportionate redistribution of weights

Replies are listed 'Best First'.
Re^2: Proportionate redistribution of weights
by TrekNoid (Pilgrim) on Oct 26, 2004 at 23:31 UTC
    That's pretty similar to how I see it, though I do it a different way..

    Metric         Weight     Score  Weighted Score
Leadership     40%        2      .8
Punctuality    20%        2      .4
Cleanliness    30%        2      .6
Responsiveness 10%        2      .2
Total          100%              2

    [download]
    Basically, all the weights apply to a total... in this case, it's 100%

    When you eliminate the Punctuality column, you're left with a total of 80%... So just figure out what percentage of 80 the remaining weights are:

    Leadership     40/80 =  50%
Cleanliness    30/80 =  37.5%
Responsiveness 10/80 =  12.5%
Total             80%  100%

    [download]
    So the recalculated weighted score becomes: 
    Metric         Weight     Score  Weighted Score
Leadership     50%        2      1
Cleanliness    37.5%      2      .75
Responsiveness 12.5%      2      .25
Total          100%              2

    [download]
    Trek

    Edit: Added recalculated table.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom