Statistics
Weighted Average Calculator
Enter the values in the first box and their weights in the second, in the same order. Weights can be percentages, credit hours, quantities or anything else.
Your result will appear here.
How it's calculated
Multiply each value by its weight, add up the results, and divide by the total of the weights. The weights don't need to add up to 100.
Weighted average = Σ(value × weight) ÷ Σ weight
How to do it in Excel
=SUMPRODUCT(A2:A4, B2:B4)/SUM(B2:B4)- Values in column A, weights in column B.