How to Calculate Weighted Average

Updated May 2026 · ~8 min read

This guide shows you how to use the weighted average calculator effectively: what each input field means, how the formula works behind the scenes, and which common mistakes produce misleading outputs. Every number below is illustrative—plug in your own figures and verify with independent sources.

When you need a weighted average

• Portfolio cost basis: you bought the same symbol at different prices and share counts—your true average cost per share is weighted by how many shares you hold at each price.
• GPA and grades: a 4-credit course should move your average more than a 1-credit lab; credits are the weights.
• Survey or blended metrics: combine scores when each component has a different importance (e.g. 60% exam, 30% project, 10% participation).

The formula

Example 1: Average cost per share (portfolio)

You hold three lots of the same stock. You want one number for “what did I pay per share on average?”—weighted by how many shares you own at each purchase price.

1. Sum of weights: 100 + 50 + 200 = 350 shares.
2. Sum of (weight × value): 18,000 + 20,000 + 28,000 = 66,000.
3. Weighted average price: 66,000 ÷ 350 = $188.57 per share (rounded to cents).

Intuition: you own more shares at $140 than at $400, so your average cost is pulled below the middle of the three prices. A simple average of the three prices (($180 + $400 + $140) / 3 ≈ $240) would ignore position sizes and would be wrong for cost basis.

Suppose course grades are on a 4.0 scale and credit hours are the weights.

Sum of weights = 3 + 4 + 3 = 10 credits. Sum of w×x = 11.1 + 13.2 + 12.0 = 36.3.

Weighted GPA = 36.3 ÷ 10 = 3.63. The four-credit statistics course moved the result more than the three-credit courses—exactly what “weighted” means.

How to use this calculator

1. Choose your currency and units. Ensure all monetary inputs use the same currency; mixing dollars and euros will produce nonsensical results.
2. Enter the primary inputs. For weighted average, the key fields are shown above. Use trailing or forward figures consistently—do not mix periods within a single calculation.
3. Adjust optional parameters. Some calculators allow you to toggle dilution, tax rates, or compounding frequency. Select the option that matches your analytical intent.
4. Review the output. The result appears instantly. If it looks surprising, recheck each input before assuming the market is wrong.
5. Compare scenarios. Change one variable at a time to see sensitivity—this is more useful than running isolated single-point calculations.
6. Export or document. Take a screenshot or copy the inputs into your own spreadsheet so you can reproduce the result later.

Real-world calculation examples

Below are two illustrative scenarios that walk through weighted average step by step. Numbers are fictional and for educational purposes only.

The gap between Scenario A and Scenario B illustrates why small changes in input assumptions can produce dramatically different outcomes. Always document which scenario most closely matches reality before acting on a calculation.

Common questions from users

• Does it account for taxes? Most calculators on StockCalc are pre-tax unless a tax field is provided. Apply your marginal rate manually.
• Can I use monthly inputs? Enter annual figures and adjust the compounding period if the calculator offers that option.
• Why does my spreadsheet differ? Rounding, day-count conventions (360 vs 365), and compounding frequency are the usual culprits.
• Is my data saved? All calculations run locally in your browser. Nothing is stored on our servers.

Limitations to keep in mind

Weighted Average is a starting point, not a final answer. The calculator assumes static inputs and does not model changing market conditions, transaction costs, or behavioral biases. For major financial decisions, cross-check with a qualified advisor and stress-test your assumptions under multiple scenarios.

When computing a weighted average across heterogeneous data sources—for example, blending cost basis from multiple purchase lots or aggregating survey responses with unequal sample sizes—always verify that weights sum to the correct denominator (typically 1.0 or 100%) before trusting the output. A weight that is off by even a few percentage points propagates directly into the final result, and in portfolio contexts this can mean the difference between an accurate cost basis and a misreported capital gain.

Common mistakes

• Mixing annual and monthly rates without conversion.
• Ignoring compounding frequency.
• Using stale price data after market close.
• Using weighted average as the sole decision metric without qualitative context.
• Forgetting to adjust for stock splits or share-count changes.
• Comparing results across different time periods without normalization.
• Relying on a single data vendor without cross-checking against filings.

Try the calculator

FAQ