Weighted Average Calculator
Paste or type one value,weight pair per line, then Calculate. The result is the weighted mean Σ(value×weight) ÷ Σ(weight), with pair count and weight sum shown.
Click Calculate.
About this tool
Unlike a simple mean, each number can matter more via its weight—course credits, survey sample sizes, or inventory volumes. Blank lines are ignored; each non-empty line must have exactly two numbers separated by a comma, semicolon, or tab. If every weight is zero, the tool errors instead of dividing by zero.
How to use
- List the pairs: Enter one pair per line in the Value,weight box.
- Check separators: Use a comma, semicolon, or tab between value and weight.
- Calculate: Click Calculate to run Σ(value×weight)/Σ(weight).
- Read the mean: Use the Weighted average line, or fix pairs if an error appears.
Common use cases
- Blend exam scores when midterms and finals carry different credit weights.
- Average supplier prices weighted by units purchased.
- Collapse multi-day survey ratings using response counts as weights.
- Check a spreadsheet weighted mean before pasting into a report.
Tips
- Format each line as value,weight — for example 90,2.
- Weight sum must be non-zero; all-zero weights return an error.
FAQ
What formula is used?
Weighted average = Σ(value × weight) ÷ Σ(weight).
Can weights be fractions?
Yes, as long as they are finite numbers and do not all sum to zero.
What if a line has only one number?
That line fails validation with Each line needs value,weight.
Why Total weight cannot be 0?
Dividing by a zero weight sum is undefined, so the tool stops.