Calculate a weighted average salary from one to three salary and weight pairs. Use the same currency and pay period for every included salary; the result is an average, not a combined total.

Use salaries in the same currency and pay period. Weights must use one consistent scale.

For hourly rates, hours can be used as weights. Other relative weights also work.

Labels the amounts; changing this selection does not convert them.

Additional salary and weight pairs

Leave both entries in a pair blank to omit it.

Weighted Salary Formula

The following equation is used to calculate the Weighted Salary.

WS = (ฮฃ(sแตข ร— wแตข)) / (ฮฃ(wแตข))
  • Where W_S is the weighted salary (e.g., $/hour)
  • ฮฃ(s_i ร— w_i) is the sum of each salary/pay rate multiplied by its corresponding weight
  • ฮฃ(w_i) is the sum of all weights

To calculate the weighted salary, sum the product of each salary (or pay rate) and its weight, then divide that total by the sum of all weights.

What is a Weighted Salary?

Definition:

A weighted salary is an average pay amount using specified relative weights, such as hours for hourly rates or headcounts for same-period salaries. Its meaning depends on choosing appropriate weights; it is not the sum of pay and does not convert salaries between periods.

How to Calculate Weighted Salary?

Example Problem:

The following example outlines the steps and information needed to calculate the weighted salary.

First, determine the multiple salaries or pay rates. In this example, assume three pay rates: $15/hour, $20/hour, and $25/hour.

Next, determine the corresponding weighting factors. Suppose 10 hours at $15/hour, 20 hours at $20/hour, and 5 hours at $25/hour were worked.

Finally, calculate the weighted salary using the formula above:

W_S = (15 ร— 10 + 20 ร— 20 + 25 ร— 5) / (10 + 20 + 5)

W_S = (150 + 400 + 125) / 35

W_S โ‰ˆ $19.29/hour

FAQ

Why is a weighted salary calculation important?

It represents the chosen relative weights instead of treating every amount equally. Use one currency and pay period throughout; arbitrary weights do not establish compensation owed.

How is a weighted salary different from a simple average salary?

A simple average gives every entry equal weight. A weighted average uses the selected relative weights; it is more representative only when those weights fit the question.

When should I use a weighted salary calculation?

Use a weighted salary calculation when there are different pay rates or factors such as hours worked, department allocations, or performance-related pay that influence overall compensation.