Weighted Average Calculator
Weighted Average Calculator
Weighted mean from value-weight rows.
Weighted average
84.9
84.9 ÷ 1
General numeric
Contribution mix
3
Rows
1
Weight
84.9
Sum
Data review
Quick paste lists
Contribution review
Item #1
30%
Value
85
Weight
0.3
Value × Weight
25.5
Item #2
40%
Value
90
Weight
0.4
Value × Weight
36
Item #3
30%
Value
78
Weight
0.3
Value × Weight
23.4
Formula
Weighted average = sum(value x weight) / sum(weights) - Multiply each value by its corresponding weight.
- Add all weighted products.
- Divide by total weight.
Example
Worked example: values 85, 90, 78 with weights 0.3, 0.4, 0.3
- 1 Weighted sum = 85x0.3 + 90x0.4 + 78x0.3 = 84.9
- 2 Total weight = 1.0
- 3 Weighted average = 84.9 / 1.0 = 84.9
The weighted average is 84.9.
How
- Add value and weight rows or import a CSV with value,weight columns.
- Optionally switch grade-scale mode to enforce valid value ranges.
- Review weighted average, normalized weights, and copy the result or full report.
Avoid
- Leaving blank rows after quick-paste without completing value and weight cells.
- Using negative weights by accident.
- Total weight of zero, which makes division invalid.
FAQ
Must weights sum to 1?
No, any positive total weight works since the formula normalizes by total weight.
Can I use percentages as weights?
Yes, percentages are valid as long as all weights use consistent scale.
Can I import weighted rows from CSV?
Yes. Upload a CSV with at least two columns in value,weight order. Header rows are accepted and skipped automatically.
Why do I see a weight normalization notice?
The notice appears when total weight is not 1 or 100. The calculator still normalizes correctly, but the alert helps catch unintended weighting setups.
What happens if rows are incomplete?
The tool blocks calculation until every active row has both a valid numeric value and a valid numeric weight.
Switch
Switch12
No match.