Weighted Average Calculator

Calculate a weighted mean and see the contribution of each observation.

Make it work with your data.

Values and weights CSV

Or choose a CSV fileLocal processing · up to 2 MB / 50,000 rows

Value column

Weight column

HOW TO USE IT

Weighted Average Calculator

Select the value and weight columns, calculate, and inspect each row’s share and contribution. Download the detailed calculation.

What to know

Weights may be counts, proportions, or percentages; they do not need to total 100. They must be nonnegative and sum to more than zero. Blank or nonnumeric cells are rejected. The result is sum(value × weight) ÷ sum(weight).

← Explore all tools