Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 970
  • Last Modified:

Sum of all weights equal to 1

I have the following formula: can i add something to it to be sure that the sum of all the weight is equal to 1?
the weights are between 0.1 and 0.9:
Where N = 11 number of elements to be weighted
i = index of each element
Min = 0.1
Max = 0.9

value = min +(max - min)* (i-1.0)/(N-1)

That's shouldn't be so hard for experts no?
0
dadadude
Asked:
dadadude
  • 3
  • 2
  • 2
  • +1
1 Solution
 
dadadudeAuthor Commented:
Found the solution:
When you use your own weight set in an interpolation procedure, you will have the option of normalizing the weights.  This means that each individual weight value (geographic multiplied by user-assigned weight) is divided by the sum of the weights assigned to all of the units being interpolated. Thus, the sum of all weights will equal one.  This option allows you to compute a population-weighted average when applied to rate data weighted by a population dataset, or by other types of count data.
http://www.biomedware.com/files/documentation/spacestat/Statistics/Interpolation/Spatial_Interpolation.htm#Normalize

Thank you. Hope that it can help other also.
0
 
GwynforWebCommented:
The principle is as follows:-

Given n values

   W1, W2, W3.....Wn

then define their sum S as

    S = W1 + W2 + W3.....+ Wn

then the values

   W1/S, W2/S, W3/S.....Wn/S

will add up to 1.

As

W1/S + W2/S + W3/S.....+ Wn/S =  ( W1 + W2 + W3.....+ Wn )/S = S/S = 1

0
 
TommySzalapskiCommented:
That will normalize the values for the particular set (which may be what you want) but if you want the normalization to be standardized on different sets then you should divide by max*N. That way, any set of the same size is normalized the same way so you won't give preference to some values that shouldn't get it.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
InfoStrangerCommented:
I was almost tricked into solving an impossible equation.  ha ha ha...  This is a trick question.

If you have N = 11 and the weight must be a minimum of 0.1, there is no way that that the sum can ever be 1.  The minimum sum of the weights would be 1.1 and no possible solution.

If N = 10, there is only one possible solution for the weights since the weight must be a minimum of 0.1.  All the weights must be 0.1.

Therefore, N needs to be less than 10 in order to have a logical equation, if the minimum is 0.1.  LOL  Good one.
0
 
dadadudeAuthor Commented:
0.1      0.066666667
0.2      0.133333333
0.3      0.2
0.4      0.266666667
0.5      0.333333333

1.5      1

1.5 is the summation of 0.1 + 0.2 + 0.3 + 0.4 + 0 .5 = 1.5
u devide all the other by 1.5 and add them u'll get 1 lol
0
 
dadadudeAuthor Commented:
well of course the sum will never be 1 if they are not normalized that's for sure
0
 
TommySzalapskiCommented:
If you want the weight to always sum to exactly 1 then you just divide each one by the sum of all of them as you mentioned.
If you want the weights to be normalized in a more standardized way, you should divide by max*N as I previously mentioned.
If you want suggestions for which to use, what application is this for?
0
 
InfoStrangerCommented:
If you normalize the data as you said, your weights are the normalized data not the weights.  Which means that your weights are really meaningless.

They are just arbitrary figures.

All that means is that you randomly pick any 11 numbers sum them up and divide each number by the sum.  It will always add up to 1.  Weights are meaningless in the question.

Like what GwynforWeb said.  You new weights are Wi/S lets call that Zi.

So, now your new weights are Zi the normalized weights.  All you really did was shift all your data to fit.  Your min and max are not needed as well, since you have a new weight.  You will need to shift the min and max on the new weight to be consistent.

The question does not make sense unless you remove the minimum from the weight.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now