Weighted Average Calculator

The weighted average calculator is a free online tool for calculating the weighted average of a dataset.

In general, each data in a dataset does not necessarily contribute the same to the mean. For example, the boss’s evaluation is more important than the manager’s evaluation, and the manager’s evaluation is more important than the employee’s self-evaluation. So, the weighted average was born.

The weighted average (also called weighted mean) refers to the average obtained by multiplying each data in the dataset by the corresponding weight, adding them together, and dividing by the total number.

When all weights are equal to 1, then the weighted average is the same as the arithmetic mean.

As a set of data

x₁, x₂, x₃……x_n

The weight of each value is

w₁, w₂, w₃……w_n

The weighted average formula is

x = x₁w₁ + x₂w₂ + x₃w₃……x_nw_nw₁ + w₂ + w₃……w_n

1. Calculate the product of each value and the weight.

x_i * w_i

2. All up all the products.

x₁w₁ + x₂w₂ + x₃w₃……x_nw_n

3. Find the sum of all weights.

w₁ + w₂ + w₃……w_n

4. The sum of the products is divided by the sum of the weights

x = x₁w₁ + x₂w₂ + x₃w₃……x_nw_nw₁ + w₂ + w₃……w_n

For example, there are 5 stocks with prices 20, 35, 60, 55 and 80. The quantities are 100, 500, 300, 600 and 100. What is the average price of all stocks?

x = 20 * 100 + 35 * 500 + 60 * 300 + 55 * 600 + 80 * 100100 + 500 + 300 + 600 + 100

= 785001600

= 49.0625

Using the calculator is simple, follow these 3 steps:

Like the stock example above. Enter 20, 35, 60, 55, 80 in the first input box and enter 100, 500, 300, 600, 100 in the second input box. Then, click Calculate button. As shown in the figure, the result of weighted average is also 49.0625