+ Reply to Thread
Results 1 to 2 of 2

Trendline equation

  1. #1
    Registered User
    Join Date
    01-06-2009
    Location
    Kansas City, Missouri
    MS-Off Ver
    Excel 2003
    Posts
    1

    Trendline equation

    Hi, I am attempting to find an equation to fit a curve that I have plotted in Excel. I use the trendline function and get an equation but when i place that formula in excel and with the values they are different. I have attached the spreadsheet to show you. The yellow columns are my original data. The blue columns are the numbers i get from the trendline equation. My R-squared value is 1.0 for both too. Any help is beneficial thanks.
    Attached Files Attached Files
    Last edited by wjp1982; 01-06-2009 at 06:00 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Select each of the trendline equation boxes in turn and change the format to Scientific with 4 decimal places.

    Select D3:I4 and format the same way.

    Select D3:I3 and paste =LINEST(E10:E33, C10:C33^{1,2,3,4,5}). Then hold down the Ctrl and Shift keys and press Enter and you'll see the same coefficients as the first trendline.

    Select D4:I4, and enter =LINEST(D10:D33, C10:C33^{1,2,3,4,5}) as above to see the second set.
    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