Re-Index GDP from 2000's Dollars to 2005's Dollars

Discussion in 'Business, Careers & Education' started by patrickBOOTH, Feb 2, 2012.

  1. patrickBOOTH

    patrickBOOTH Senior member Dubiously Honored

    Messages:
    33,498
    Likes Received:
    8,862
    Joined:
    Oct 16, 2006
    Location:
    New York City
    Before I reinvent the wheel does anybody know how to reindex values to a different base? For example, prior to 2010 US GDP was indexed to 2000's dollars, 2010 to present it is indexed to 2005's dollars. I have a bunch of forecasts of GDP over the years and I want to put them all on the same playing field. Is there an easy way to do this?
     


  2. imageWIS

    imageWIS Senior member

    Messages:
    20,008
    Likes Received:
    97
    Joined:
    Apr 19, 2004
    Location:
    New York City / Buenos Aires
    Do you know the diff between 2000 dollars and 2005 dollars?
     


  3. Nereis

    Nereis Senior member

    Messages:
    1,374
    Likes Received:
    43
    Joined:
    Feb 12, 2009
    I doubt you have an enormous database when it's just a few projections, so you could just write a little command in the next column as either:

    A: Bring the GDP forecasts in 2000 dollars up to 2005 dollars

    B: Bring the GDP forecasts in 2005 dollars back to 2000 dollars

    It's simply a matter of accounting for inflation between 2000 and 2005. You should be able to bring that information up anywhere.
     


  4. patrickBOOTH

    patrickBOOTH Senior member Dubiously Honored

    Messages:
    33,498
    Likes Received:
    8,862
    Joined:
    Oct 16, 2006
    Location:
    New York City
    

    Do you mean the difference in CPI between the two periods? Yes.

    It is not as clear cut, because it was a sudden change over and I am not working with actual historical values, I am working with forecasted values. I know a way to derive based on the %change of the forecast on a 2005 base, but it will take a really long time to do. I have to prepare many years of this. I am just wondering if there is an easy way,
     


  5. Nereis

    Nereis Senior member

    Messages:
    1,374
    Likes Received:
    43
    Joined:
    Feb 12, 2009
    What the form that your GDP forecasts take? If it's in one spreadsheet you can write a sheet level macro and apply it over all the values therein. If it's across many sheets you can write it to the general module (standard/this workbook) to apply it across the entire workbook.
     


  6. imageWIS

    imageWIS Senior member

    Messages:
    20,008
    Likes Received:
    97
    Joined:
    Apr 19, 2004
    Location:
    New York City / Buenos Aires
    

    Beat me too it.
     


  7. patrickBOOTH

    patrickBOOTH Senior member Dubiously Honored

    Messages:
    33,498
    Likes Received:
    8,862
    Joined:
    Oct 16, 2006
    Location:
    New York City
    That seems obvious, but it doesn't work. If I take the historical GDP when it was in 2000's dollars in say 1970 and do it that way and put it in 2005's dollars and compare that number to what the bea currently has 1970's GDP (now in 2005's dollars) it is slightly off.

    I found a way to do it though. The hard way.

    I just took the %changes of the old forecasts and applied them to a historical actual value that is in 2005's dollars to bring the 2000's GDP into 2005's dollars. Seems to have done the trick and only took hours for me to complete. I hate all of you.
     


  8. imageWIS

    imageWIS Senior member

    Messages:
    20,008
    Likes Received:
    97
    Joined:
    Apr 19, 2004
    Location:
    New York City / Buenos Aires
    

    You used Excel, I take it?
     


  9. patrickBOOTH

    patrickBOOTH Senior member Dubiously Honored

    Messages:
    33,498
    Likes Received:
    8,862
    Joined:
    Oct 16, 2006
    Location:
    New York City
    

    Of course, could be part of the problem. I don't have SAS, sorry.
     


  10. Nereis

    Nereis Senior member

    Messages:
    1,374
    Likes Received:
    43
    Joined:
    Feb 12, 2009
    

    You can download stata 11 off of the pirate bay and copy paste the data in, do your stuff, and copy paste it back out.
     


  11. patrickBOOTH

    patrickBOOTH Senior member Dubiously Honored

    Messages:
    33,498
    Likes Received:
    8,862
    Joined:
    Oct 16, 2006
    Location:
    New York City
    

    Unfortunately my company wont allow downloads through our security. Its a hasstle to get anything.
     


  12. imageWIS

    imageWIS Senior member

    Messages:
    20,008
    Likes Received:
    97
    Joined:
    Apr 19, 2004
    Location:
    New York City / Buenos Aires
    

    I see. Excel would require a few extra steps, but you can design a few ad hoc functions / formulas that could save you time.
     


  13. imageWIS

    imageWIS Senior member

    Messages:
    20,008
    Likes Received:
    97
    Joined:
    Apr 19, 2004
    Location:
    New York City / Buenos Aires
    

    Plus you shouldn't risk illegally downloading software at the office.
     


  14. Kajak

    Kajak Senior member

    Messages:
    2,519
    Likes Received:
    168
    Joined:
    Jun 11, 2010
    Location:
    Canada
    

    +1. They invented proxies for a reason.
     


  15. AldenPyle

    AldenPyle Senior member

    Messages:
    944
    Likes Received:
    84
    Joined:
    Apr 5, 2007
    

    Why would you want to do this. BEA.gov (Table 1.1.6) has quarterly GDP in 2005$ running all the way back to 1947. Your tax dollars at work.
     


Share This Page

Styleforum is proudly sponsored by