Solved

# Sum of all weights equal to 1

Posted on 2011-03-22
822 Views
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
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3
• 2
• 2
• +1

Author Comment

ID: 35190731
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

LVL 31

Expert Comment

ID: 35195096
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

As

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

0

LVL 37

Expert Comment

ID: 35201149
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

LVL 3

Expert Comment

ID: 35204879
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

Author Comment

ID: 35208351
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

Author Comment

ID: 35208360
well of course the sum will never be 1 if they are not normalized that's for sure
0

LVL 37

Expert Comment

ID: 35209622
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

LVL 3

Accepted Solution

InfoStranger earned 500 total points
ID: 35292244
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

CAGR Calculation For SIP 13 106
Sampling 3 71
Simplify expression 3 132
What statistical method/formula can be used for Range and Trend? 4 129
Introduction On a scale of 1 to 10, how would you rate our Product? Many of us have answered that question time and time again. But only a few of us have had the pleasure of receiving a stack of the filled out surveys and being asked to do somethi…
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
###### Suggested Courses
Course of the Month2 days, 14 hours left to enroll