Statistics calculator

Weighted Average Calculator

A simple average treats every value as equally important. A weighted average lets you say that some matter more. A common use in a job search is scoring an offer: rate each factor, give each factor a weight for how much it matters to you, and combine them into one figure that you can compare across offers.

For example a score for each factor of a job offer.

How much each value counts. They do not need to add up to 100.

Result
Weighted average3.9
Simple average, ignoring the weights4
Total of the weights100

The formula

Formula

weighted average = (value 1 × weight 1 + value 2 × weight 2 + ...) ÷ (weight 1 + weight 2 + ...)

values
the numbers to be averaged, such as a score from 1 to 5 for each factor
weights
how much each value counts, entered in the same order as the values; none may be negative and at least one must be above zero
total of the weights
the sum of all the weights, which the result is divided by
weighted average
the sum of each value × its weight, divided by the total of the weights
simple average
the plain mean of the values with the weights ignored, shown for comparison

Explained in full: Weighted Average Formula, Average (Mean) Formula.

How to use it

Enter the values in one box and the weights in the other, in matching order: the first weight belongs to the first value, and so on. There must be exactly one weight for each value. The weights can be on any scale. Percentages that add up to 100 are easy to think about, but 5, 3 and 2 give exactly the same answer as 50, 30 and 20, because only the proportions matter.

To score a job offer, choose the factors first (pay, the work itself, commute or flexibility, prospects), then set the weights before you look at any particular offer, so that you are not tempted to tune them towards the answer you already want. Score each offer on every factor using the same scale, and run the calculator once per offer with the same weights.

Compare the weighted result with the simple average shown beneath it. When they differ, the weights are doing real work: the offer is stronger or weaker on the things you said matter most. A score is an aid to thinking and not a verdict. If the higher-scoring offer feels wrong, a factor is probably missing or a weight is not what you truly believe; the guide on how to evaluate a job offer lists factors that are easy to overlook.

Worked example

The default example scores one job offer out of 5 on three factors, say 4 for pay, 3 for location and 5 for prospects, with weights of 50, 30 and 20.

  1. Multiply each value by its weight: 4 × 50 = 200, 3 × 30 = 90 and 5 × 20 = 100.
  2. Add the products: 200 + 90 + 100 = 390.
  3. Add the weights: 50 + 30 + 20 = 100.
  4. Divide: 390 ÷ 100 = 3.9. The weighted average is 3.9.
  5. For comparison, the simple average is (4 + 3 + 5) ÷ 3 = 4. The weighted figure is lower because the top score of 5 carries the smallest weight.

What the calculator shows for these inputs:

Result
Weighted average3.9
Simple average, ignoring the weights4
Total of the weights100

Assumptions

  • The values are on a common scale, so that a 4 on one factor is comparable with a 4 on another.
  • Weights express relative importance only, and their total does not need to be 100 or 1.
  • A weight of zero removes that value from the result while keeping the two lists the same length.

Limitations

  • The result is only as sound as the scores and weights you choose, and both are judgements.
  • A high score on one factor can offset a low score on another, which hides deal-breakers: an offer you could not accept for one reason may still score well.
  • It does not convert between units, so mixing a salary in thousands with a score out of 5 produces a figure with no meaning.
  • Small differences between two totals, such as 3.9 against 3.8, are within the imprecision of the scores and should not decide anything alone.

Questions and answers

Do the weights have to add up to 100?

No. The calculator divides by the total of the weights, whatever it is, so only their proportions matter. Using percentages that add up to 100 is simply a convenient way to check that you have shared out the importance as you intended.

How is this different from a simple average?

A simple average gives every value the same influence. A weighted average multiplies each value by its weight first, so a factor with weight 50 has two and a half times the pull of one with weight 20. If all the weights are equal, the two averages are the same.

How do I use it to compare two job offers?

Fix one list of factors and one set of weights, then score each offer on every factor and calculate each offer separately. The offer with the higher weighted average is stronger by your own stated priorities. Use the Job Offer Comparison Calculator alongside it for the money side.

Can I use it for things other than job offers?

Yes. The same sum gives an average grade when modules carry different credits, an average hourly rate across jobs with different hours, or an average price across purchases of different sizes. Put the grades, rates or prices in the values and the credits, hours or quantities in the weights.