Results 1 to 6 of 6

Math Help - Hockey Stick Graph Formula

  1. #1
    Newbie
    Joined
    Nov 2006
    Posts
    4

    Hockey Stick Graph Formula

    I need to come up with the (Excel) formula for a 'hockey stick' graph. Although the numbers do not really matter, here's what I need to show: time line 24 months, saturation value 12,000,000.

    I hope this makes (some) sense.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Newbie
    Joined
    Nov 2006
    Posts
    4
    Guess it did not
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by dontknowmuch View Post
    Guess it did not
    Its too vague. Be more specific, and you may get some help.

    RonL
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Newbie
    Joined
    Nov 2006
    Posts
    4
    Let's say you start a new service and at the beginning you double your subscriber base every week then every month then every quarter and you reach saturation at about 2,000,000 subscribers within 24 months.
    How would an (Excel) formula for that scenario look like?
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by dontknowmuch View Post
    Let's say you start a new service and at the beginning you double your subscriber base every week then every month then every quarter and you reach saturation at about 2,000,000 subscribers within 24 months.
    How would an (Excel) formula for that scenario look like?
    You need the Verhulst equation, which has solution:

    <br />
S(t)=\frac{K S(0)\ e^{rt}}{K+S(0)\ (e^{rt}-1)}<br />

    Where S(0) is the initial number of subscribers, and r is the initial growth constant (in your case 2/wk, so if you measure time t in weeks has a value of 2), and K is your saturation level.

    RonL
    Follow Math Help Forum on Facebook and Google+

  6. #6
    Newbie
    Joined
    Nov 2006
    Posts
    4
    Thanks so much Know I just have to figure out how to put that into Excel.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Cutting stick
    Posted in the Statistics Forum
    Replies: 1
    Last Post: May 3rd 2011, 08:47 AM
  2. Breaking a stick.
    Posted in the Advanced Statistics Forum
    Replies: 3
    Last Post: February 26th 2009, 02:40 AM
  3. length of each stick
    Posted in the Algebra Forum
    Replies: 2
    Last Post: November 1st 2008, 08:02 AM
  4. hockey puck speed.
    Posted in the Math Topics Forum
    Replies: 4
    Last Post: November 10th 2007, 09:54 AM
  5. probability of a Hockey team
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: May 15th 2007, 07:50 PM

Search Tags


/mathhelpforum @mathhelpforum