I have a producer price index which is the composite of 9 various commodity prices including that of coal. I want to remove the effects of coal price changes from the original index. I have data on coal prices. Does anyone know of a method that I could use to filter out the effects of coal price changes from the original index?

  • $\begingroup$ $P_{agg}-P_{coal}Q_{coal}$? $\endgroup$
    – Herr K.
    Commented Jul 5, 2019 at 18:57
  • 1
    $\begingroup$ Do you happen to know how the index is calculated (Paasche, Laspeyres, etc.), and the components (price changes, weights) for the individual components? Whether a particular method will work for your purposes depends on what information you have available to you. $\endgroup$ Commented Jul 5, 2019 at 21:41
  • $\begingroup$ @dismalscience I don't know the method, but what if the index is an unweighted average of the commodity prices? $\endgroup$
    – london
    Commented Jul 6, 2019 at 20:14

1 Answer 1


The best way is taking the index "ingredients" and rebuild it... assuming you manage the index data on a DB or on an excel file, that should not be too difficult

Otherwise, assuming you're index ingredients are averaged equally, then in a sense, the index is calculated as:

Index = (1 + Product1ChangeIn%)^(1/9) * (1 + Product2ChangeIn%)^(1/9) ...

So based on it, without coal, you're index should be:

Index / (1 + CoalChangeIn%)^(1/9)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.