+ Reply to Thread
Results 1 to 4 of 4

Problem with trend line fitting

Hybrid View

  1. #1
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Problem with trend line fitting

    If you want a fit that is linear in log-log space, then you need to do a log-log (power series) fit.

    Select two cells, say A1 and B1, and array enter this: =LINEST(LN(C6:M6), LN(C4:M4))

    That gives 0.8678 and -2.0914, meaning that the best-fit regression =EXP(-2.0914) * x ^ 0.8678. The 0.8678 is the exponent you see in your trendline, and =EXP(-2.0914) is 0.1235, the coefficient you see in your trendline.

    If you want a linear fit, use =LINEST(C6:M6, C4:M4) to get the coefficients.
    Last edited by shg; 04-29-2009 at 03:10 PM.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1