Food went up by 20%, energy by 50% and transport by 10%. By how much did the cost of living go up? Not by the plain average, because a family spends far more on some things than on others. A weighted aggregate index gives each price relative a weight from what the household spent in the base year.
about 25 min1 simulation1 practice question1 Python program6 questions to check yourself
This lesson is free to read. Enroll free to keep your place and take the tests.
Lesson 2 of 3Show all lessonsHide
Try the code and the simulations beside the lesson.
What you will be able to do
calculate a weighted aggregate index number from weights and price relatives;
calculate the weights from base-year spending, or from quantities and base-year prices;
explain why the weights matter.
Ana's shopping
Ana's household kept a record of its spending in the base year, in euros a week.
Group
Spending (euros)
Price relative now
food
80
120
energy
30
150
transport
50
110
other
40
105
Prices in every group have gone up, but by different amounts. Energy went up by 50%, but Ana spends little on it. Food went up by 20%, and she spends a lot on it. What one number describes the rise in her cost of living?
The weighted aggregate index
The weights are the amounts spent on each group in the base year. Each price relative is multiplied by its weight, and the total is divided by the total of the weights.
I=∑w∑(w×price relative)
Here I is the weighted aggregate index.
Here w is a weight, and ∑ means "add up over all the groups".
Multiply.80×120=9600, 30×150=4500, 50×110=5500 and 40×105=4200.
Add.9600+4500+5500+4200=23800.
Divide by the total weight.20023800=119.
The weighted aggregate index is 119. The plain average of the four relatives is 4485=121.25. It is too high, because it gives energy, the group with the biggest rise, as much weight as food.
Bar chart of Ana's base-year spending in euros a week, which gives the weights: food 80, energy 30, transport 50, other 40. A second panel shows the price relatives of the same four groups, 120, 150, 110 and 105, with a dashed line at the weighted aggregate index of 119 and a dotted line at the plain average of 121.25.
Why it works
Think about the same basket bought now. Food that cost 80 euros now costs 80×1.20=96 euros. Energy costs 30×1.50=45, transport 50×1.10=55 and other things 40×1.05=42 euros. The basket that cost 200 euros now costs 238 euros.
200238×100=119
That is the same number. A weighted aggregate index with base-year spending as weights is the cost of the base-year basket now, as a percentage of what it cost then.
When the weights must be worked out
Sometimes you are given what was bought, not what was spent. Then each weight is the base-year spending: quantity × base-year price.
A café buys these each week in the base year.
Milk: 50 litres at 1.20 euros a litre, so a weight of 50×1.20=60.
Coffee: 5 kilograms at 16 euros a kilogram, so a weight of 5×16=80.
Sugar: 10 kilograms at 1.00 euro a kilogram, so a weight of 10×1.00=10.
The price relatives now are 125 for milk, 110 for coffee and 140 for sugar.
The products are 60×125=7500, 80×110=8800 and 10×140=1400. The weights add up to 150.
1507500+8800+1400=118
Weights can also be given as a ratio, such as 5:3:2, or as percentages. Use the numbers as they are and divide by their total.
Practise with new numbers
Try it in Python
The program finds Ana's weighted aggregate index, and checks it by pricing her base-year basket at today's prices.
Your turn.
The usual mistakes
Taking a plain average of the price relatives. That gives every group the same weight.
Using quantities as weights. 50 litres of milk and 5 kilograms of coffee cannot be added. Multiply each quantity by its base-year price.
Using this year's prices to make the weights. The weights come from the base year.
Dividing by the number of groups. Divide by the total of the weights.
Remember these
Weighted aggregate index =∑w∑(w×price relative).
Weights = base-year spending, or quantity × base-year price.
The index equals the cost of the base-year basket now, as a percentage of its cost then.
The base year has an index of 100.
Check yourself
Try each one on your own first. If you are stuck, open a hint. Then check with Show the answer.
A family's weights are 5, 3 and 2 for food, housing and travel. The price relatives are 110, 130 and 95. Find the weighted aggregate index.
Why is the plain average of Ana's price relatives too high?
A bakery bought 200 kilograms of flour at 0.90 euros a kilogram in the base year. What is the weight for flour?
Two groups have weights 3 and 1, and price relatives 140 and 100. Find the index.
A household spent 250 dollars a week in the base year. The same goods cost 290 dollars now. What is the weighted aggregate index?
Enroll free in Index Numbers
Every lesson is open to read. Enrolling also lets you:
Mark lessons done and carry on where you stopped.
Take the tests of this lesson and its course.
Count the course towards the certificate for its chapter.