Results 1 to 6 of 6

error in trendline formula

Threaded View

chiidzzz error in trendline formula 06-07-2014, 02:49 AM
Glenn Kennedy Re: error in trendline formula 06-07-2014, 03:37 AM
chiidzzz Re: error in trendline formula 06-07-2014, 07:39 AM
Glenn Kennedy Re: error in trendline formula 06-07-2014, 08:18 AM
chiidzzz Re: error in trendline formula 06-07-2014, 08:36 AM
Glenn Kennedy Re: error in trendline formula 06-07-2014, 08:36 AM
  1. #1
    Forum Contributor
    Join Date
    07-08-2012
    Location
    beirut
    MS-Off Ver
    Excel 2010
    Posts
    102

    error in trendline formula

    Hi, I have looked in the forum for similar errors, but I still can't understand how to fix this.
    Excel gave me this order 5 polynomial function:
    y = 9E-08x4 - 0.0002x3 + 0.2502x2 - 113.38x + 19102
    but it returns wrong answers, for example for x=603 , it shows me 9756.622 instead of 0.
    sample attached
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power Law Trendline Apparent Error
    By jwcane in forum Excel General
    Replies: 11
    Last Post: 06-22-2011, 02:55 PM
  2. Trendline error
    By RuiPedro in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-20-2011, 10:07 AM
  3. trendline error
    By jlsexcel in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-20-2011, 05:09 AM
  4. Replies: 2
    Last Post: 04-15-2011, 01:15 AM
  5. Trendline covering up error bars
    By itgoeson in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-02-2005, 09:05 PM

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