How to Calculate a Weighted Average Step-by-Step
Core Formula & Definition
To calculate a weighted average, multiply each data point by its corresponding weight, sum the resulting products together, and divide that total by the sum of all weights: Weighted Average = ∑(Weight × Value) / ∑(Weights). If weights are already expressed as percentage fractions totaling 100% (1.0), the sum of the products directly equals the final weighted score.
1. Unweighted vs. Weighted Mean: The Core Difference
In a standard arithmetic mean, every observation carries identical importance (an implied weight of 1/n). For instance, averaging the numbers 10 and 20 gives (10 + 20) / 2 = 15.
However, real-world systems rarely distribute importance equally. In academic grading, a final exam covering four months of curriculum is worth vastly more than a single 10-minute quiz. In financial portfolios, a $50,000 index fund holding has far greater influence on net return than a $1,000 speculative stock. A weighted average accounts for these proportional differences.
2. Mathematical Formula and Variable Definitions
In statistical methodology standardized by the NIST/SEMATECH e-Handbook and the Bureau of Labor Statistics (BLS), the weighted mean equation is formulated as:
x̄w = (w1x1 + w2x2 + ... + wnxn) / (w1 + w2 + ... + wn)
Where xi represents each measurement value and wi represents the corresponding non-negative weight factor.
When weights are normalized such that ∑ wi = 1 (or 100%), the denominator equals 1, simplifying the calculation to a straightforward sum of products.
3. Worked Example: College Course Syllabus Grade
Consider a university course where student performance is evaluated across three weighted grading categories:
- Homework: Score = 95 | Weight = 20% (0.20)
- Midterm Exam: Score = 78 | Weight = 30% (0.30)
- Final Exam: Score = 88 | Weight = 50% (0.50)
Step-by-Step Calculation Breakdown
| Category | Score (x) | Weight (w) | Product (w × x) |
|---|---|---|---|
| Homework | 95 | 0.20 | 19.00 |
| Midterm Exam | 78 | 0.30 | 23.40 |
| Final Exam | 88 | 0.50 | 44.00 |
| Total | — | 1.00 (100%) | 86.40 |
Final Course Grade = 19.00 + 23.40 + 44.00 = 86.40% (Grade B)
4. Worked Financial Example: Investment Portfolio Yield
An investor holds a $100,000 three-asset retirement portfolio with distinct annual returns:
- Asset A (S&P 500 Index Fund): $50,000 invested (50% weight) | Return = +12.0%
- Asset B (Treasury Bond Fund): $30,000 invested (30% weight) | Return = +4.0%
- Asset C (Emerging Markets Fund): $20,000 invested (20% weight) | Return = -2.0%
Portfolio Net Yield Math
Weighted Return = (0.50 × 12.0%) + (0.30 × 4.0%) + (0.20 × -2.0%)
Weighted Return = 6.0% + 1.2% - 0.4% = +6.80% Net Annual Yield
A naive unweighted average of the three percentages (12 + 4 - 2) / 3 gives 4.67%, underestimating actual portfolio dollar earnings by more than $2,100.
5. Mistakes to Avoid When Weighting Data
1. Forgetting to Normalize Raw Weights
If your weights are raw counts or credit hours (such as 3 credits, 4 credits, and 1 credit) rather than percentages, you must divide by the total sum of credit hours (∑ w = 8). Dividing by the item count (3) yields an inflated, invalid score.
2. Mixing Percentage Decimals with Integers
If category weight is 20%, multiply by 0.20 (or divide the final product sum by 100). Multiplying 95 by 20 produces 1,900 points. Be consistent across every line item.
Explore Central Tendency Metrics
Solve mean, median, mode, and range with step-by-step mathematical proof.
Sources & References
- NIST/SEMATECH — e-Handbook of Statistical Methods: Section 1.3.5.1 "Measures of Location". National Institute of Standards and Technology. Accessed October 11, 2026.
- Bureau of Labor Statistics (BLS) — Handbook of Methods: Consumer Price Index Weighting Methodology. US Department of Labor. Accessed October 11, 2026.