Karo Posted June 17, 2010 Share Posted June 17, 2010 Hi, I have monthly CPI data and I need annual data. How can I do this? I have the impression, that just summing up and dividing by twelve is not correct. I would be glad for help! Karo Quote Link to comment Share on other sites More sharing options...
Misanthrope Posted June 17, 2010 Share Posted June 17, 2010 Hi, I have monthly CPI data and I need annual data. How can I do this? I have the impression, that just summing up and dividing by twelve is not correct. I would be glad for help! Karo Here's the link to the CPI (all items) pdf:- http://www.statistics.gov.uk/downloads/theme_economy/CPI.pdf It shows the index values and also annualised changes in the table CPI12. Quote Link to comment Share on other sites More sharing options...
Karo Posted June 17, 2010 Author Share Posted June 17, 2010 Thank you! It seems to be okay to divide the sum of the monthly values by 12. I'll try it! Quote Link to comment Share on other sites More sharing options...
ChumpusRex Posted August 1, 2010 Share Posted August 1, 2010 (edited) Thank you! It seems to be okay to divide the sum of the monthly values by 12. I'll try it! What do you mean by 'monthly CPI' data? Do you mean the monthly value of the index? Or do you mean the month-on-month percentage change in the index? Or might you even mean the annualised month-on-month percentage change? Or do you simply mean the annual change in index value reported on a month-by-month basis? (I suspect you mean this one, as this is the most frequent method of reporting - in which case there is nothing for you to do, the data is already 'annual'). Since annual figures are a standard calculation - you are best of going directly to the source and obtaining annual data, rather than trying to calculate it. At any rate, calculating an annual figure from monthly figures is liable to accrue significant errors due to rounding. Edited August 1, 2010 by ChumpusRex Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.