Hi
I need some help calculating a weighted sum. I have an example which shows how it should be done. Any help is great appreciated! Thanks in advance
Sample Data:
<tbody>
</tbody><colgroup><col span="6"><col><col span="2"></colgroup>
<tbody>
</tbody><colgroup><col span="6"><col></colgroup>
Expected Outcome:
<tbody>
</tbody><colgroup><col><col><col span="4"><col></colgroup>
Sample Calculation:
68.29 = 0.48*95 + 0.05*14 + 0.33*47 + 0.14*47
I need some help calculating a weighted sum. I have an example which shows how it should be done. Any help is great appreciated! Thanks in advance
Sample Data:
A | B | C | D | E | F | G | Total | |
B | 48% | 5% | 33% | 14% | 100% | |||
C | 16% | 2% | 5% | 9% | 21% | 23% | 23% | 100% |
F | 13% | 35% | 30% | 22% | 100% | |||
H | 26% | 39% | 17% | 17% | 100% | |||
Z | 32% | 4% | 36% | 28% | 100% |
<tbody>
</tbody><colgroup><col span="6"><col><col span="2"></colgroup>
April | May | June | July | August | September | |
A | 65 | 21 | 16 | 60 | 98 | 83 |
B | 95 | 19 | 90 | 43 | 24 | 46 |
C | 14 | 3 | 68 | 76 | 15 | 14 |
D | 47 | 71 | 15 | 6 | 51 | 80 |
E | 52 | 57 | 40 | 65 | 49 | 79 |
F | 23 | 87 | 70 | 63 | 16 | 94 |
G | 47 | 91 | 59 | 63 | 21 | 6 |
H | 22 | 22 | 70 | 72 | 3 | 72 |
Z | 94 | 73 | 20 | 76 | 33 | 59 |
<tbody>
</tbody><colgroup><col span="6"><col></colgroup>
Expected Outcome:
April | May | June | July | August | September | |
B | 68.29 | 45.86 | 59.52 | 35.10 | 32.14 | 50.10 |
C | 44.98 | 63.93 | 47.63 | 57.77 | 40.81 | 62.47 |
F | 50.87 | 64.57 | 32.30 | 43.39 | 50.00 | 64.00 |
H | 35.48 | 31.70 | 49.91 | 67.65 | 42.74 | 57.22 |
Z | 44.12 | 66.36 | 47.44 | 59.76 | 45.04 | 65.28 |
<tbody>
</tbody><colgroup><col><col><col span="4"><col></colgroup>
Sample Calculation:
68.29 = 0.48*95 + 0.05*14 + 0.33*47 + 0.14*47