Weighted Average
Combine values with explicit nonnegative weights.
Your numbers
Weighted average
Use consistent units. The result follows the assumptions you enter.
Scenario comparison
Up to three snapshots in this tab. Loading one replaces the current inputs.
Formula
Σ(wᵢxᵢ) / Σwᵢ
Combine values with explicit nonnegative weights.
Worked example
- Values
- 10, 20
- Weights
- 1, 3
- Weighted average
- 17.5
- Total weight
- 4
Scope and limitations
Use consistent units. The result follows the assumptions you enter.
Inputs are checked for missing values and allowed ranges. A result outside the finite numeric range is not displayed. Rounding affects display, while the calculation uses the model’s numeric precision.
Check your units and assumptions before relying on a result. Changing a label does not convert a currency or physical unit.
Formula version: 8ded4e330719 · Example checked: