LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default Forecast Function - Why does rate of growth trail off with time???

I have 13 months worth of monthly data that I want to trend out for about 3
years on a month-by-monty basis. I am using the FORECAST function but am
puzzled by what I am seeing. I get values that visually "make sense" based
on the historical data, but when I calculate the month-over-month rate of
change I see puzzling results.

Here is the data:
Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07

329 369 390 448 442 437 451 504 552 487 574 610 511

So I am projecting out to April 2010. If you try this confirm that you get
1262 as the value for April 2010.

The thing that puzzles me is that if I chart this data it looks perfectly
linear for the forecasted values. Thus I would expect a uniform rate of
growth. But when I look at the month-over month growth rate, it steadily
declines from 3.197% in Jun 2007 to 1.546% by April 2010.

Can anyone help me understand what is going on? Is FORECAST the best way to
do what I am atttempting?

Thanks in advance for any assistance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: How to forecast 12 months' figures but force a 10% growth? Ralph Excel Worksheet Functions 1 June 6th 07 06:01 PM
Average Growth Rate scott Excel Discussion (Misc queries) 8 October 26th 06 12:01 AM
Growth Rate Native Excel Discussion (Misc queries) 2 September 21st 06 12:34 AM
trouble with a growth rate Larry Holt Excel Worksheet Functions 4 March 18th 06 03:40 AM
monthly growth rate my Excel Worksheet Functions 5 March 2nd 06 01:07 AM


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"