How can I calculate trend growth rates in Excel?

Discussion in 'Microsoft Excel Misc' started by Guest, Jul 12, 2005.

  1. Guest

    Guest Guest

    I need help calculating the trend growth rate of GDP of a country over a 20
    year period.

    Thanks!
     
    Guest, Jul 12, 2005
    #1
    1. Advertisements

  2. Can you provide the equations needed to do this calculation?

    "david34" <> wrote in message
    news:...
    >I need help calculating the trend growth rate of GDP of a country over a 20
    > year period.
    >
    > Thanks!
     
    Barb Reinhardt, Jul 12, 2005
    #2
  3. Guest

    Guest Guest

    I'm 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.

    Do you know how I can do this?

    Thanks.

    "Barb Reinhardt" wrote:

    > Can you provide the equations needed to do this calculation?
    >
    > "david34" <> wrote in message
    > news:...
    > >I need help calculating the trend growth rate of GDP of a country over a 20
    > > year period.
    > >
    > > Thanks!

    >
    >
    >
     
    Guest, Jul 12, 2005
    #3
  4. david34 -

    Two issues:

    (1) 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.

    (2) Excel: After you answer the General question, there will be many Excel
    gurus who can explain how to do the number crunching in Excel.

    - Mike
    www.mikemiddleton.com

    "david34" <> wrote in message
    news:...
    > I'm 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.
    >
    > Do you know how I can do this?
    >
    > Thanks.
    >
    > "Barb Reinhardt" wrote:
    >
    >> Can you provide the equations needed to do this calculation?
    >>
    >> "david34" <> wrote in message
    >> news:...
    >> >I need help calculating the trend growth rate of GDP of a country over a
    >> >20
    >> > year period.
    >> >
    >> > Thanks!

    >>
    >>
    >>
     
    Mike Middleton, Jul 12, 2005
    #4
  5. Guest

    Guest Guest

    Thanks.

    "Mike Middleton" wrote:

    > david34 -
    >
    > Two issues:
    >
    > (1) 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.
    >
    > (2) Excel: After you answer the General question, there will be many Excel
    > gurus who can explain how to do the number crunching in Excel.
    >
    > - Mike
    > www.mikemiddleton.com
    >
    > "david34" <> wrote in message
    > news:...
    > > I'm 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.
    > >
    > > Do you know how I can do this?
    > >
    > > Thanks.
    > >
    > > "Barb Reinhardt" wrote:
    > >
    > >> Can you provide the equations needed to do this calculation?
    > >>
    > >> "david34" <> wrote in message
    > >> news:...
    > >> >I need help calculating the trend growth rate of GDP of a country over a
    > >> >20
    > >> > year period.
    > >> >
    > >> > Thanks!
    > >>
    > >>
    > >>

    >
    >
    >
     
    Guest, Jul 16, 2005
    #5

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. NlCO

    LINEST, LOGEST, GROWTH or TREND??

    NlCO, Aug 22, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    263
    Jerry W. Lewis
    Aug 23, 2005
  2. Guest

    How Growth Trend Works

    Guest, Jul 19, 2006, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    223
    Guest
    Jul 20, 2006
  3. Guest

    How do I project yearly growth rates in Excel?

    Guest, Feb 27, 2007, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    1,493
    Guest
    Feb 28, 2007
  4. mike
    Replies:
    2
    Views:
    150
    David Biddulph
    Sep 25, 2008
  5. KenSouthfield

    How do I calculate escalation rates using dates and a set value

    KenSouthfield, May 27, 2010, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    630
    KenSouthfield
    May 27, 2010
Loading...

Share This Page