Weighted average

Enter equally sized lists of values and weights, separated by semicolons. Weights may be percentages or relative weights and must be non-negative, with a positive total. The result is the sum of each value × weight divided by the sum of weights.