• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatically Adjust Weights in Weighted Index

M

mvirgilio53

New Member
So I'm creating a ranking index which uses a basic min/max formula to give a certain category a ranking out of 100. Each category is then weighted between 0 and 1 and the sum of the indicies multiplied by the weights then gives me my final index ranking.


So, I'm wondering if there's a way to get the weights to automatically add to 1. For example if I start out with each weight at .33 and I have 3 weights then I get 1 (close enough at least). But let's say I want to change the first weight to .5 and I want the other 2 to automatically adjust to .25 (.5 + .25 + .25 = 1). How would this be possible?
 
Hi,


The basic assumption that goes into the model is that all weights are equal


In case the first weight is of a predefined value the difference is split equally among remaining weights


Hope this helps to improve the index


http://rapidshare.com/files/402930576/weighted_average.xlsx.html
 
You must log in or register to reply here.
Back
Top