+ Reply to Thread
Results 1 to 3 of 3

Linest - Polynomial for higher order

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Linest - Polynomial for higher order


    I am using the
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    array function to determine the coefficients of a polynomial 2nd order.

    As shown on the attached, the coefficients for the 2nd order are highlighed in black.

    If my best fit curve is polynomial of the order 3 OR 4, how do I get the coefficients.
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365

    Re: Linest - Polynomial for higher order


    I have this webpage in my favourites https://people.stfx.ca/bliengme/exce...polynomial.htm

    It gives an example of a 3rd order line, but I think you can extend as required.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2312

    Re: Linest - Polynomial for higher order

    I tend to use this:


    copied down. The bit in red defines the order of the polynomial. In this case, the first value is the C2 value, the secons is the C1 value and the third is b. See file, where it is also done for a 5th order polynomial.

    These are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.

    You will know the array is active when you see the curly brackets { } appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

    Don't type the curly brackets yourself - it won't work...
    Attached Files Attached Files

    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

+ 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. [SOLVED] Adding a Polynomial Trendline Using Linest
    By danielexcelvba in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-18-2018, 01:53 PM
  2. 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
  3. LINEST for specifying polynomial regression function
    By InderpalHothi in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-27-2014, 03:11 PM
  4. Extract polynomial coefficients with LinEst in VBA
    By shamedt in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-22-2011, 08:45 PM
  5. Replies: 5
    Last Post: 06-25-2009, 10:25 AM
  6. [SOLVED] using linest to generate 3rd order polynomial coefficients
    By Incoherent in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-14-2005, 10:05 AM
  7. higher order polynomial fit line x-coefficients
    By barrfly in forum Excel General
    Replies: 3
    Last Post: 07-12-2005, 05:05 AM

Tags for this Thread


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