I need help calculating the trend growth rate of GDP of a country over a 20 year period. Are there any easy to use template for the process. I am trying to find out on officehelp for the same but there is nothing mentioned.
I need help calculating the trend growth rate of GDP of a country over a 20 year period. Are there any easy to use template for the process. I am trying to find out on officehelp for the same but there is nothing mentioned.
Can you provide the equations needed to do this calculation. I am not sure which equations you are referring to. I have GDP numbers in millions of dollars for a 20 year period and I'm trying to calculate the trend growth rate for this series from the first year through the last.
There can be two issues. First in general you need to define what you mean by "trend growth rate." If you don't know the meaning of "trend growth rate," ask the person who asked you to do this analysis. The explanation may involve the pattern of the data and the particular functional form that best fits the data. Second after you answer the General question, there will be many Excel gurus who can explain how to do the number crunching in Excel.
Bookmarks