Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Growth Curves

I asked aquestion on 26 Dec about modelling growth rates and got a very
helpful reply from Herbert Seidenberg (Thank-you), but in trying to apply the
suggested formula there is clearly something I have not fully understood.

I am trying to model growth of service subscribers where the
parameters/variables a

* Ultimate projected number of subscribers (eg 500 members, 560 members...)
* Time to reach Ultimate subscriber numbers (eg 9months, 14months,
20months...)
* Maximum number of net new signups a month (eg 50 members, 70 members...)
* Month in which max new signups achieved (eg month 5, month 7...)

I want to be able to model the growth of the total subscriber-base for
scenarios whe
1) The number of months for the subscriber-base to plateau at a given level
is variable
2) The maximum number of net new subscribers achieved in a month and the
month that is achieved (eg 70 net new in month 7) is variable
3) The rate of net new signups is increasing up to the month of maximum net
new subscribers and declining thereafter (ie an s-curve) and trending to zero
growth/steady state at the end of the defined growth period.

I need to be able to model the net new signups each month for say:

Total subscriber base when mature = 560
Months to build to maturity = 14
Maximum New sign-ups in month = 70 in month 5 (maximum could be expressed as
a multiplier of the average -ie 1.75*40 = 70).

Any further help that can be offered will be much appreciated.
 
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
How can I average 2 curves? y=10x+3 and y=11x-2 SuziequeQQ Excel Worksheet Functions 1 January 24th 07 03:18 PM
how does excel calculate curves of best fit? Jon H Excel Discussion (Misc queries) 2 December 14th 06 10:37 PM
Bell Curves Rob Charts and Charting in Excel 2 November 14th 06 09:59 PM
size distribution curves cliff Excel Discussion (Misc queries) 0 March 16th 06 02:40 AM
combine 2 curves Ruud Excel Worksheet Functions 1 December 7th 04 02:47 PM


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

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

About Us

"It's about Microsoft Excel"