ganak.appWeighted Average Calculator
Calculate the weighted average of a set of numbers with different weights. Supports general value-weight pairs, grade calculations with credit hours, and percentage-weighted data. See each item's contribution, compare weighted vs simple average, and get step-by-step formula breakdowns. Essential for GPA, grades, portfolio returns, and cost analysis.
Enter values with custom weights
Weighted vs Simple Average
See the effect of weights on the result
Contribution Breakdown
How each item contributes to the weighted average
| Item | Value | Weight | Wt % | Value x Wt | Contribution |
|---|---|---|---|---|---|
| Item 1 | 85 | 3 | 21.4% | 255 | 18.21 |
| Item 2 | 90 | 4 | 28.6% | 360 | 25.71 |
| Item 3 | 78 | 2 | 14.3% | 156 | 11.14 |
| Item 4 | 92 | 5 | 35.7% | 460 | 32.86 |
| Total | 14 | 100% | 1,231 | 87.9286 |
Step-by-Step Calculation
How the weighted average is computed
Formula
Weighted Average = (w₁x₁ + w₂x₂ + ... + wₙxₙ) / (w₁ + w₂ + ... + wₙ)
Step 1: Multiply each value by its weight
Item 1: 85 × 3 = 255
Item 2: 90 × 4 = 360
Item 3: 78 × 2 = 156
Item 4: 92 × 5 = 460
Step 2: Sum the weighted values
255 + 360 + 156 + 460 = 1,231
Step 3: Sum the weights
3 + 4 + 2 + 5 = 14
Step 4: Divide weighted sum by total weight
1,231 ÷ 14 = 87.9286
What Is a Weighted Average?
Understanding weighted averages and when to use them
A weighted average is a type of average where each value is multiplied by a predetermined weight that reflects its relative importance. Unlike a simple average where every value counts equally, a weighted average gives more influence to values with higher weights.
The weighted average is calculated by multiplying each value by its weight, summing all the products, and then dividing by the total sum of weights. This makes it essential in situations where not all data points contribute equally to the result.
Weighted Average Formula
Weighted Average = Σ(wᵢ × xᵢ) / Σ(wᵢ)
Where wᵢ = weight of item i, xᵢ = value of item i
How to Calculate Weighted Average
Step-by-step guide with a worked example
Follow these steps to calculate a weighted average by hand or verify calculator results:
List each value and its weight
Identify the data values and assign a weight to each one based on its importance.
Multiply each value by its weight
Calculate value × weight for every item. These are the weighted products.
Sum all weighted products
Add up all the value × weight products to get the weighted sum.
Divide by the total weight
Divide the weighted sum by the sum of all weights to get the weighted average.
Worked Example
A student earns the following grades: Math 92 (4 credits), English 85 (3 credits), Science 88 (4 credits), History 78 (3 credits).
Step 1: (92 × 4) + (85 × 3) + (88 × 4) + (78 × 3)
Step 2: 368 + 255 + 352 + 234 = 1,209
Step 3: Total credits = 4 + 3 + 4 + 3 = 14
Step 4: 1,209 ÷ 14 = 86.36
Weighted Average vs Simple Average
When and why to use each type
Simple Average
Every value has equal importance. Just add all values and divide by the count.
(92 + 85 + 88 + 78) ÷ 4 = 85.75
Weighted Average
Values have different levels of importance based on assigned weights.
(92×4 + 85×3 + 88×4 + 78×3) ÷ 14 = 86.36
In this example, the weighted average (86.36) is higher than the simple average (85.75) because the higher-scoring subjects (Math: 92, Science: 88) carry more credits. This demonstrates how weights shift the average toward values with greater importance.
Common Uses of Weighted Averages
Real-world applications across different fields
GPA and Grade Calculations
Courses with more credit hours count more toward your GPA. A 4-credit course has twice the impact of a 2-credit course on your overall grade point average.
Investment Portfolio Returns
Portfolio returns are weighted by the amount invested in each asset. A stock that makes up 60% of your portfolio affects the total return three times more than one making up 20%.
Weighted Average Cost (Accounting)
In inventory accounting, the weighted average cost method values inventory by calculating the average cost per unit based on total cost divided by total units, where each purchase batch is weighted by quantity.
Survey Analysis
Survey responses are often weighted by demographic factors to ensure the results represent the target population accurately, even if certain groups are over- or under-represented in the sample.
How to Calculate Weighted Average in Excel
Using SUMPRODUCT and SUM functions
Excel does not have a built-in WEIGHTEDAVERAGE function, but you can calculate it easily using SUMPRODUCT and SUM:
Formula:
=SUMPRODUCT(values, weights) / SUM(weights)
Example:
If your values are in cells B2:B5 and weights are in C2:C5:
=SUMPRODUCT(B2:B5, C2:C5) / SUM(C2:C5)
SUMPRODUCT multiplies corresponding elements of two arrays and returns the sum of those products — exactly what the weighted average numerator requires. Dividing by SUM of the weights completes the calculation.
Weighted Average with Percentages
When weights are expressed as percentages
When weights are given as percentages (like course syllabus weightings), the calculation works the same way. Just make sure your percentage weights add up to 100%.
Example: Course Grade
Homework: 88 × 20% = 17.6
Midterm: 82 × 25% = 20.5
Project: 91 × 15% = 13.65
Final Exam: 86 × 40% = 34.4
Total: 17.6 + 20.5 + 13.65 + 34.4 = 86.15
When using percentage weights that sum to 100%, the total weight is 100, so the weighted average equals the sum of (value × weight%) directly. Use the Percentage mode in this calculator for this scenario.
Common Mistakes When Calculating Weighted Averages
Pitfalls to avoid for accurate results
Using equal weights when values have different importance. A final exam worth 40% should not be weighted the same as a quiz worth 10%.
Confusing percentages with absolute weights. If weights are percentages (20%, 30%, 50%), they should add up to 100%. If they do not, the result may be misleading.
Averaging weighted averages without re-weighting. You cannot simply average two weighted averages — you need to go back to the original values and weights.
Forgetting to account for missing data. If a value is missing, exclude both the value and its weight from the calculation rather than treating the value as zero.
Mixing up the numerator and denominator. The numerator is the sum of (value × weight) products, not the sum of values. The denominator is the sum of weights, not the count of items.
Frequently Asked Questions
Common questions about weighted averages and how to calculate them