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 drop-down list enabled.