Weighted and Chain Base Index Numbers - Worksheets, Questions and Revision
34 original exam-style questions - 24 pages of questions with a full mark scheme - free printable PDF.
Weighted and Chain Base Index Numbers revision guideMore GCSE Statistics practiceMock exams
This topic is chapter 4 of GCSE Statistics Higher Topic Workbook 8 and chapter 16 of GCSE Statistics Higher 10-Minute Tests 3.
6.3 Weighted and Chain Base Index Numbers
index number = (price in that year / price in the base year) x 100
| Year | Price of pitch fee (£) |
|---|---|
| 2020 (base year) | 25.00 |
| 2021 | 27.50 |
| 2022 | 30.00 |
| Category | Weight | Price index |
|---|---|---|
| food | 3 | 100 |
| housing | 3 | 108 |
| transport | 2 | 90 |
| leisure | 2 | 125 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| food | 3 | 100 |
| housing | 3 | 140 |
| transport | 2 | 115 |
| leisure | 2 | 95 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| food | 6 | 120 |
| housing | 2 | 112 |
| transport | 1 | 95 |
| leisure | 1 | 120 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| rent | 5 | 140 |
| food | 2 | 125 |
| fuel | 2 | 110 |
| clothes | 1 | 130 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| bread | 4 | 130 |
| milk | 3 | 108 |
| eggs | 2 | 90 |
| cheese | 1 | 108 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| food | 4 | 108 |
| housing | 3 | 125 |
| transport | 2 | 110 |
| leisure | 1 | 90 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| rent | 2 | 95 |
| food | 2 | 90 |
| fuel | 1 | 120 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| rent | 2 | 120 |
| food | 2 | 110 |
| fuel | 1 | 100 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| rent | 6 | 120 |
| food | 2 | 100 |
| fuel | 1 | 110 |
| clothes | 1 | 125 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| food | 4 | 115 |
| housing | 3 | 100 |
| transport | 2 | 130 |
| leisure | 1 | 112 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| bread | 6 | 140 |
| milk | 2 | 110 |
| eggs | 1 | 120 |
| cheese | 1 | 90 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| rent | 4 | 120 |
| food | 3 | 115 |
| fuel | 1 | 95 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| bread | 5 | 125 |
| milk | 2 | 130 |
| eggs | 2 | 112 |
| cheese | 1 | 108 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| rent | 1 | 90 |
| food | 2 | 104 |
| fuel | 7 | 90 |
Work out the weighted mean index number for all categories.
| Month | Members |
|---|---|
| January | 240 |
| February | 258 |
| March | 300 |
| April | 276 |
A chain-base index number compares each month with the month immediately before it:
chain-base index number = (this month's members / previous month's members) x 100
| Category | Weight | Price index |
|---|---|---|
| food | 5 | 95 |
| housing | 3 | 104 |
| transport | 2 | 125 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| rent | 3 | 95 |
| food | 5 | 104 |
| fuel | 2 | 130 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| food | 3 | 90 |
| housing | 5 | 115 |
| transport | 2 | 95 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| bread | 3 | 130 |
| milk | 3 | 115 |
| eggs | 2 | 125 |
| cheese | 2 | 108 |
Work out the weighted mean index number for all categories.
| Category | Weight | Price index |
|---|---|---|
| rent | 4 | 110 |
| food | 3 | 95 |
| fuel | 2 | 120 |
| clothes | 1 | 90 |
Work out the weighted mean index number for all categories.
Student A is finding a chain-base index number for a shop's sales, using Year 3 sales of £84,000 and Year 2 sales of £80,000:
Step 1: 84,000 / 80,000 = 1.05
Step 2: chain-base index number = 1.05
Student B is given a fixed-base index number (Year 1 = 100) for the same shop's sales. The fixed-base index number for Year 4 is 118. Student B says: 'Since the index is 118, sales have increased by 118% since Year 1.'
| Category | Weight | Sub-index this year |
|---|---|---|
| Housing | 5 | 130 |
| Food | 3 | 110 |
| Transport | 2 | 120 |
The weighted index number is defined as:
weighted index = (sum of (weight x sub-index)) / (sum of weights)
| Category | Sub-index this year |
|---|---|
| Housing | 112 |
| Food | 106 |
| Transport | 118 |
| Leisure | 102 |
| Category | Weight | Sub-index |
|---|---|---|
| Housing | 6 | 108 |
| Food | 3 | 115 |
| Leisure | 1 | 122 |
Calculate the local weighted price index.(3)
| Week | Tickets sold |
|---|---|
| Week 1 | 320 |
| Week 2 | 368 |
| Week 3 | 345 |
Week 1 is used as the fixed base period for a fixed-base index number (index = 100).
| Year | Fixed-base index (2018 = 100) |
|---|---|
| 2018 | 100 |
| 2019 | 120 |
| 2020 | 108 |
| 2021 | 135 |
| Category | Weight | Sub-index |
|---|---|---|
| A | 2 | 105 |
| B | 3 | 118 |
| C | 4 | w |
| D | 1 | 130 |
The overall weighted index for all four categories is 117.
| Year | Fixed-base CPI (2019 = 100) |
|---|---|
| 2019 | 100.0 |
| 2020 | 105.0 |
| 2021 | 115.5 |
| 2022 | 121.3 |
| 2023 | 127.4 |
Question 1
- (a) 27.50 / 25.00, oe (correct ratio)M1
- (a) 110 csoA1
- (a) Answer: 110
- (b) 30.00 / 25.00, oeM1
- (b) 120 caoA1
- (b) Answer: 120
- (c) the price in 2022 is 20% higher than the price in the base year (2020), oe; accept 'the price has increased by 20% since 2020'B1
- (c) Answer: The pitch fee in 2022 was 20% higher than in 2020 (the base year).
Question 2
- (i) True caoB1
- (i) Answer: True
- (ii) False caoB1
- (ii) Answer: False
- (iii) False cao; correct increase is 150%B1
- (iii) Answer: False
- (iv) True caoB1
- (iv) Answer: True
Question 3
- each index multiplied by its weightM1
- sum of weighted indices (1054) divided by sum of weights (10)M1
- 105.4 caoA1
- Answer: 105.4
Question 4
- each index multiplied by its weightM1
- sum of weighted indices (1140) divided by sum of weights (10)M1
- 114 caoA1
- Answer: 114
Question 5
- each index multiplied by its weightM1
- sum of weighted indices (1159) divided by sum of weights (10)M1
- 115.9 caoA1
- Answer: 115.9
Question 6
- each index multiplied by its weightM1
- sum of weighted indices (1300) divided by sum of weights (10)M1
- 130 caoA1
- Answer: 130
Question 7
- each index multiplied by its weightM1
- sum of weighted indices (1132) divided by sum of weights (10)M1
- 113.2 caoA1
- Answer: 113.2
Question 8
- each index multiplied by its weightM1
- sum of weighted indices (1117) divided by sum of weights (10)M1
- 111.7 caoA1
- Answer: 111.7
Question 9
- each index multiplied by its weightM1
- sum of weighted indices (490) divided by sum of weights (5)M1
- 98 caoA1
- Answer: 98
Question 10
- (a) 480 x (137.5/100), oeM1
- (a) 660 caoA1
- (a) Answer: £660
- (b) 37.5 (%) caoB1
- (b) Answer: 37.5%
- (c) the claim is not fully justified because it is based on the price of a single item (one sofa), oeB1
- (c) the general cost of living covers many different goods and services, which may have changed in price by different amounts, so a single item's index cannot represent overall cost-of-living change; a weighted index across many goods would be needed instead, oeB1
- (c) Answer: The claim is not fully justified: it is based on the price of only one item, but the cost of living covers many goods and services that may have changed by different amounts. An overall cost-of-living index would need to combine (weight) many items, not rely on a single sofa's price.
Question 11
- each index multiplied by its weightM1
- sum of weighted indices (560) divided by sum of weights (5)M1
- 112 caoA1
- Answer: 112
Question 12
- each index multiplied by its weightM1
- sum of weighted indices (1155) divided by sum of weights (10)M1
- 115.5 caoA1
- Answer: 115.5
Question 13
- each index multiplied by its weightM1
- sum of weighted indices (1132) divided by sum of weights (10)M1
- 113.2 caoA1
- Answer: 113.2
Question 14
- each index multiplied by its weightM1
- sum of weighted indices (1270) divided by sum of weights (10)M1
- 127 caoA1
- Answer: 127
Question 15
- each index multiplied by its weightM1
- sum of weighted indices (920) divided by sum of weights (8)M1
- 115 caoA1
- Answer: 115
Question 16
- each index multiplied by its weightM1
- sum of weighted indices (1217) divided by sum of weights (10)M1
- 121.7 caoA1
- Answer: 121.7
Question 17
- each index multiplied by its weightM1
- sum of weighted indices (928) divided by sum of weights (10)M1
- 92.8 caoA1
- Answer: 92.8
Question 18
- (a) 258/240, oeM1
- (a) 107.5 csoA1
- (a) Answer: 107.5
- (b) 300/258, oeM1
- (b) 116.3 awrt (from 116.279...)A1
- (b) Answer: 116.3
- (c) 276/300, oeM1
- (c) 92 caoA1
- (c) Answer: 92
- (d) April cao, ft from (c) (chain-base index below 100)B1
- (d) Answer: April
Question 19
- each index multiplied by its weightM1
- sum of weighted indices (1037) divided by sum of weights (10)M1
- 103.7 caoA1
- Answer: 103.7
Question 20
- each index multiplied by its weightM1
- sum of weighted indices (1065) divided by sum of weights (10)M1
- 106.5 caoA1
- Answer: 106.5
Question 21
- each index multiplied by its weightM1
- sum of weighted indices (1035) divided by sum of weights (10)M1
- 103.5 caoA1
- Answer: 103.5
Question 22
- each index multiplied by its weightM1
- sum of weighted indices (1201) divided by sum of weights (10)M1
- 120.1 caoA1
- Answer: 120.1
Question 23
- each index multiplied by its weightM1
- sum of weighted indices (1055) divided by sum of weights (10)M1
- 105.5 caoA1
- Answer: 105.5
Question 24
- (a) Student A has not multiplied the ratio by 100 (an index number is expressed as a value around 100, not as a decimal ratio), oeB1
- (a) 105 caoB1
- (a) Answer: Student A forgot to multiply by 100; the correct chain-base index number is 105.
- (b) an index of 118 means sales are 118% of the Year 1 value (a growth multiplier of 1.18), so the increase is 118-100=18%, not 118%, oeB1
- (b) 18 (%) caoB1
- (b) Answer: Student B should have subtracted 100 from the index; the correct percentage increase is 18%.
Question 25
- (a) 5x130, 3x110, 2x120 (=650, 330, 240), oeM1
- (a) 1220 caoA1
- (a) Answer: 1220
- (b) 1220 / (5+3+2), ft from (a)M1
- (b) 122 caoA1
- (b) Answer: 122
- (c) the overall cost of living has risen by 22% since the base year, taking into account how much of the budget goes on each category, oeB1
- (c) Answer: The overall cost of living has risen by 22% since the base year, once the different amounts spent on housing, food and transport are taken into account.
- (d) (130+110+120)/3, oeM1
- (d) 120 caoA1
- (d) housing takes up the largest share of a typical household's spending (weight 5, the highest) and also rose the most (sub-index 130, the highest), so the weighted index (122) correctly reflects its greater importance, unlike the unweighted mean (120) which treats all three categories as equally important, oeB1
- (d) Answer: Unweighted mean = 120. The weighted index (122) is more appropriate because it reflects that housing takes up the largest share of typical spending and rose the most, whereas the unweighted mean treats housing, food and transport as equally important, which does not match real spending patterns.
Question 26
- (a) 20 (%) caoB1
- (a) Answer: 20%
- (b) 40x112, 25x106, 20x118, 15x102 (=4480, 2650, 2360, 1530), oeM1
- (b) (4480+2650+2360+1530)/100, depM1
- (b) 110.2 caoA1
- (b) Answer: 110.2
- (c) higher, oeB1
- (c) because more weight is being placed on transport, which has the highest sub-index (118) of the four categories, this pulls the weighted average up above 110.2, oeB1
- (c) Answer: Higher. Giving transport a greater weight pulls the weighted index towards transport's sub-index (118), which is the highest of the four, so the overall weighted index would rise above 110.2.
Question 27
- (a) which categories of goods and services to include (the 'basket'), oeB1
- (a) what weight to give each category, based on typical local spending patterns, oe; accept 'which base period to use'B1
- (a) Answer: Which categories of goods and services to include in the basket, and what weight to give each category based on typical local spending.
- (b) to get a more representative typical price for each category, reducing the effect of any one shop's unusually high or low price, oeB1
- (b) Answer: Using more than one shop gives a more representative average price for each category, rather than being skewed by one shop's unusually high or low prices.
- (c) 6x108, 3x115, 1x122 (=648, 345, 122), oeM1
- (c) (648+345+122)/(6+3+1), depM1
- (c) 111.5 caoA1
- (c) Answer: 111.5
- (d) the local cost of living has risen by more (11.5%) than the national average (6%), oeB1
- (d) a plausible reason, e.g. local housing costs (which carry the largest local weight, 6 out of 10) may have risen faster than the national average, or the local basket/weights differ from the national CPI's, oeB1
- (d) Answer: The local index (111.5) shows a bigger rise than the national CPI (106): 11.5% locally compared with 6% nationally. This could be because local housing costs, which carry the largest weight (6 out of 10) in the local index, have risen faster than the national average, or because the local basket and weights differ from the national CPI's.
Question 28
- (a) 112 caoB1
- (a) Answer: 112
- (b) (126-100)/100, oeM1
- (b) 26 (%) caoA1
- (b) Answer: 26%
- (c) 126/112, oeM1
- (c) 112.5 caoA1
- (c) Answer: 112.5
- (d) (104-100)/100, oe, to find the 2020-2021 percentage increase (=4%)M1
- (d) 12.5 (%), ft from (c) (percentage increase 2022 to 2023)B1
- (d) comparing the percentage increases (12.5%/4% = 3.125) instead of the raw point rises (14/4=3.5) gives a different, more accurate ratio, because the same number of index points represents a smaller percentage change when the index level itself is already higher, so raw point differences should not be used to compare speeds of change; percentage/chain-base changes should be used instead, oeB1
- (d) Answer: 2020 to 2021: 4% increase. 2022 to 2023: 12.5% increase (from part c). The true ratio is 12.5/4=3.125, not 3.5, so comparing raw index-point rises overstates the comparison; percentage (chain-base) changes give the accurate measure, since the same point-rise represents a smaller percentage change when it is measured from a higher index level.
Question 29
- (a) 78/40, oeM1
- (a) 195 caoA1
- (a) Answer: 195
- (b) 78/52, oeM1
- (b) 150 caoA1
- (b) Answer: 150
- (c) the two index numbers are each expressed relative to a different base period (2015 in (a), 2020 in (b)), oeB1
- (c) an index number only measures change relative to whichever period is set as the base (=100), so the same real prices give different numerical index values when a different base period is chosen, oeB1
- (c) Answer: The index numbers are calculated relative to different base years (2015 and 2020), and an index number only shows change relative to its own base period; since the base prices differ (£40 vs £52), the resulting index values differ even though the actual prices have not changed.
- (d) the direction of the trend (an increase) is the same either way, but the reported size of the change is very different (a 95% increase vs a 50% increase), which could give a misleading impression of the scale of change, oeB1
- (d) a valid situation, e.g. if the chosen base period itself had an unusually high or low price (such as a one-off price spike or crash), the resulting index numbers could distort how 'normal' subsequent changes appear, oeB1
- (d) Answer: The claim is only partly true: both index numbers show an increase, but the reported percentage increase is very different (95% vs 50%), which could mislead readers about the scale of the change. The choice of base year matters in practice, for example if the base period itself had an unusually high or low price (such as a one-off shortage or price crash), which would distort how later changes appear.
Question 30
- (a) 368/320, oeM1
- (a) 115 csoA1
- (a) Answer: 115
- (b) 345/320, oeM1
- (b) 107.8 awrt (from 107.8125)A1
- (b) Answer: 107.8
- (c) 345/368, oeM1
- (c) 93.75 caoA1
- (c) Answer: 93.75
- (d) (115/100) x (93.75/100), ft from (a) and (c)M1
- (d) ...x100, depM1
- (d) 107.8125 (=107.8, 1 dp) cso, matching part (b)A1
- (d) Answer: 1.15 x 0.9375 x 100 = 107.8125 (107.8 to 1 dp), matching part (b).
Question 31
- (a) 120/100, oeM1
- (a) 120 caoA1
- (a) Answer: 120
- (b) 108/120, oeM1
- (b) 90 caoA1
- (b) Answer: 90
- (c) 135/108, oeM1
- (c) 125 caoA1
- (c) Answer: 125
- (d) revenue fell by 10% from 2019 to 2020, ft from (b)B1
- (d) Answer: The company's revenue decreased by 10% from 2019 to 2020.
Question 32
- (a) 2x105, 3x118, 1x130 (=210, 354, 130), oeM1
- (a) 694 csoA1
- (a) Answer: 694
- (b) 117 x (2+3+4+1) (=1170), ft from (a)M1
- (b) 1170 - 694 (=476), depM1
- (b) w=119 caoA1
- (b) Answer: w = 119
- (c) a sub-index only shows the price relative to the base year (=100); you would also need to know the actual base-year price of category C to work out the actual current price, oeB1
- (c) Answer: A sub-index of 119 only tells you the price is 19% higher than in the base year; without knowing the actual base-year price, you cannot work out the actual current price.
Question 33
- (a) weighted index = (108w+124(10-w)) / 10 = 118, oeM1
- (a) 108w+124(10-w) = 1180 cso, from multiplying both sides by 10A1
- (a) Answer: 108w + 124(10-w) = 1180
- (b) 108w+1240-124w=1180, oe (expands the bracket)M1
- (b) -16w=-60, dep (collects terms)M1
- (b) w=3.75, so Category 2's weight = 6.25 caoA1
- (b) Answer: w = 3.75 (Category 1's weight); Category 2's weight = 6.25
Question 34
- (a) 115.5/105.0, oeM1
- (a) 110.0 caoA1
- (a) Answer: 110.0
- (b) 121.3/115.5, oeM1
- (b) 105.0 awrt (from 105.0216...)A1
- (b) Answer: 105.0
- (c) 127.4/121.3, oeM1
- (c) 105.0 awrt (from 105.0288...)A1
- (c) Answer: 105.0
- (d) 105.0/100.0, oe, to find the chain-base index for 2020 (=105.0, i.e. 5% inflation)M1
- (d) correctly restates the chain-base results from (a) and (c): 2021 = 10% inflation, 2022 and 2023 = 5% inflation each, ftB1
- (d) the commentator is incorrect: inflation was NOT roughly the same every year, since 2020-to-2021 (10%) was double the rate of the other three years (5% each), even though the raw point-rises look broadly similar in size; this shows that reading off index-point rises is not a reliable substitute for calculating the actual chain-base percentage rates, oeB1
- (d) Answer: Chain-base 2020 = 105.0 (5% inflation). Together with parts (a) to (c): 2021 = 10% inflation, 2022 = 5%, 2023 = 5%. The commentator is incorrect: 2020-to-2021 had double the inflation rate of the other years, which is not clear just from looking at the raw point-rises; the actual chain-base percentages must be calculated to see this.
Mark your answers
Check answers without an account. Some answers can be checked automatically; use the mark scheme to mark the rest.