+ Reply to Thread
Results 1 to 3 of 3

Linest Polynomial Not Giving Required Curve

  1. #1
    Forum Contributor
    Join Date
    05-12-2013
    Location
    Australia
    MS-Off Ver
    Microsoft Office 365
    Posts
    132

    Linest Polynomial Not Giving Required Curve

    Trying to extrapolate data as shown in the example. Excel trendline coefficients are almost identical to Linest coefficients but still get crazy values.

    Cheers.
    Attached Files Attached Files

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,015

    Re: Linest Polynomial Not Giving Required Curve

    Extend the trendline forwards and you'll see it behaves pretty much like your formula values.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Contributor
    Join Date
    05-12-2013
    Location
    Australia
    MS-Off Ver
    Microsoft Office 365
    Posts
    132

    Re: Linest Polynomial Not Giving Required Curve

    Yes, thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linest - Polynomial for higher order
    By chaliseyp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-26-2021, 09:04 AM
  2. [SOLVED] Adding a Polynomial Trendline Using Linest
    By danielexcelvba in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-18-2018, 01:53 PM
  3. LinEst for polynomial regression in VBA - error...
    By IDidNotWantToRegiste in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2014, 11:03 PM
  4. LINEST for specifying polynomial regression function
    By InderpalHothi in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-27-2014, 03:11 PM
  5. Converting a polynomial LINEST formula to VBA
    By AARONWEBSTER in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2012, 12:23 PM
  6. Execution Speed: Implementing Polynomial Curve Fit Without Linest
    By mynci in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-14-2010, 04:22 PM
  7. Replies: 5
    Last Post: 06-25-2009, 10:25 AM

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