+ Reply to Thread
Results 1 to 4 of 4

Formula for a Line given data set

  1. #1
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Formula for a Line given data set

    Im trying to come up with a polynomial formula for given x's and y's. Im using the linest and index functions, but can seem to get it to work.

    see attached.

    thank you
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,656

    Re: Formula for a Line given data set

    You have several blank cells in your input range to the LINEST() function. You also have more Y values than you have X values. Unlike most other Excel functions that can ignore blank cells, LINEST() cannot work with blank cells, so you need to remove those blank cells from the input range. I am not sure exactly what those blank cells represent, so I am not sure what to recommend. I do note that, if I change the input ranges to B3:B1116 (known_y) and A3:A1116 (known_x), because that matches the range of entered values for the x values, that the formula you have works just fine.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Formula for a Line given data set

    The formula works up to 3282. That's how many Y values are there.
    After that both X and Y columns are empty and it doesn't work.
    Also, Index function doesn't do anything. With or without Index, the formula results in -1.23145.
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  4. #4
    Forum Contributor
    Join Date
    12-18-2011
    Location
    long island
    MS-Off Ver
    365
    Posts
    236

    Re: Formula for a Line given data set

    Had no idea the formula couldn't work with empty cells.
    Once i made that change everything started working.

    Thanks!

+ 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. Replies: 3
    Last Post: 03-12-2017, 03:39 PM
  2. Replies: 1
    Last Post: 09-29-2015, 05:19 AM
  3. [SOLVED] Take Data from one line put on next line and combine data from another column on one line
    By barbibchn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2013, 01:09 AM
  4. Replies: 1
    Last Post: 12-31-2012, 05:31 AM
  5. Replies: 0
    Last Post: 09-26-2012, 11:26 AM
  6. [SOLVED] Comparing two data sets that don't line up on a line to line basis
    By ghan7650 in forum Excel General
    Replies: 10
    Last Post: 05-22-2012, 05:38 PM
  7. Formula to copy data from 1 w/sheet to another and add data to new line
    By wtomas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-01-2008, 09:26 PM

Tags for this Thread

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