Weighted Index Calculator Formula
Understand the math behind the weighted index calculator. Each variable explained with a worked example.
Formulas Used
Weighted Index
weighted_index = (i1 * w1 + i2 * w2 + i3 * w3) / total_weightChange from Base (%)
pct_change = ((i1 * w1 + i2 * w2 + i3 * w3) / total_weight) - 100Sum of Weights
weight_sum = total_weightVariables
| Variable | Description | Default |
|---|---|---|
i1 | Item 1 Index | 110 |
w1 | Item 1 Weight | 0.4 |
i2 | Item 2 Index | 130 |
w2 | Item 2 Weight | 0.35 |
i3 | Item 3 Index | 95 |
w3 | Item 3 Weight | 0.25 |
total_weight | Derived value= w1 + w2 + w3 | calculated |
How It Works
How to Calculate a Weighted Index
Formula
Weighted Index = Sum(Ii * Wi) / Sum(Wi)
A weighted index combines multiple individual indices using importance weights. This is how composite indices like the CPI are constructed: each component's index is multiplied by its weight (often an expenditure share), then divided by the total weight.
Worked Example
Three items: indices 110, 130, 95 with weights 0.4, 0.35, 0.25.
i1 = 110w1 = 0.4i2 = 130w2 = 0.35i3 = 95w3 = 0.25
- 01Weighted sum = 110*0.4 + 130*0.35 + 95*0.25
- 02= 44 + 45.5 + 23.75 = 113.25
- 03Total weight = 0.4 + 0.35 + 0.25 = 1.0
- 04Weighted index = 113.25 / 1.0 = 113.25
- 05Overall prices are 13.25% above the base.
Ready to run the numbers?
Open Weighted Index Calculator