# How can I calculate trend growth rates in Excel?

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

1. ### GuestGuest

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

Thanks!

Guest, Jul 12, 2005

2. ### Barb ReinhardtGuest

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

3. ### GuestGuest

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
4. ### Mike MiddletonGuest

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
5. ### GuestGuest

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