Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Power and exponential trendlines in formulas

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Please help!!

    I regularly produce response graphs for forecasting and use power and exponential trendlines to help plot future responses.

    To speed up the process I really need to have my forecast equation linked to a cell.

    I know it is possible to plot Linear x and y interception using the LINEST and INTERCEPT functions. Is there a function to plot power and exponential equations?

    thanks

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-18 09:27, Mr B wrote:
    Hi

    Please help!!

    I regularly produce response graphs for forecasting and use power and exponential trendlines to help plot future responses.

    To speed up the process I really need to have my forecast equation linked to a cell.

    I know it is possible to plot Linear x and y interception using the LINEST and INTERCEPT functions. Is there a function to plot power and exponential equations?

    thanks
    Youcan use the LOGEST function instead of
    LINEST to use a logarythmic model. GROWTH
    uses an exponential model. You can also
    use the TREND function to use either a linear
    or polynomial model.

    Good luck!


    "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Tim, the GROWTH function helps.

    Do you know how I can recreate a POWER trendline through a function? Or plot the interception point?

    Thanks again for the earlier help.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-19 09:03, Mr B wrote:
    Thanks Tim, the GROWTH function helps.

    Do you know how I can recreate a POWER trendline through a function? Or plot the interception point?

    Thanks again for the earlier help.
    There is no direct function to do this.
    You can always use the standard transform
    on the data and fall back on the LINEST function:

    model
    LOG(y)=LOG(B) + M LOG(X) linearly.

    Someone clever on the web has probably got a free add-in with a POWER function that will
    do exactly what you want.

    Not that I know where. Good luck!
    "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

  5. #5
    New Member
    Join Date
    Jul 2004
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Power and exponential trendlines in formulas

    I think I’m asking the same thing here, and wonder if there hav been any new discoveries in this area.

    I’m using the power trend line formula to adjust data. I’d like to capture the “c” value and “b” value to plug into other formula’s, but don’t know how to extract it from the “add trend line, options, display formula on chart” series of selections so that it appears on the chart.

    Is this even possible?


    Thanks a gazillion.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •