Weighted Sum
The sum of the product of the selected field and the weight field.
The Formula:
WeightedSum = ∑(x w) where x are the items and w are weights
Sample 1:
Given the weights .20, .15, .40 and .25 compute the weighted sum of the following numbers: 25, 20, 15, 30.
Computation:
WeightedSum = 25 x 0.20 + 20 x 0.15 + 15 x 0.40 + 30 x 0.25 = 21.50
Sample 2:
Alex wants to buy a new camera, and has the following preferences based on a scale of 1 to 10, and 10 being the highest:
q Image Quality: 8
q Battery Life: 8
q Zoom Range: 5
Based on reviews the Cony camera gets 7 (out of 10) for Image Quality, 5 for Battery Life and 6 for Zoom Range
The Sanon camera gets 6 for Image Quality, 5 for Battery Life and 7 for Zoom Range
Which camera is best?
Cony: 8 × 7 + 8 × 5 + 5 × 6 = 56 + 40 + 30 = 126
Sanon: 8 × 6 + 8 × 5 + 5 × 7 = 48 + 40 + 35 = 123
Alex decides to buy the Cony.
NOTE 
Weighted columns such as Weighted Mean, Weighted Harmonic Mean, and Weighted Sum have the Weight dropdown list enabled.
