Use a spreadsheet with the data below to find the all-items index numbers listed below for Years 1 and 2 with Year 0 as the base year.
a. Laspeyres price index.
b. Laspeyres quantity index.
c. Paasche price index.
d. Paasche quantity
e. A value index.
Further information now comes to light which changes various price and quantity data in the table. Use your spreadsheet to find the effect on the ten index numbers you have already constructed in each of the following:
f. Year 2, quantities change to:
A = 207 B = 400 C = 1545
g. Year 2, prices change to:
A = 3.70 B = 2.75
D = 4.54 F = 12.99
G = 0.60 J = 59.99
h. Year 2, quantities change to:
B = 196 C = 710 E = 289
F = 85 G = 70