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
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
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.
Originally Posted by shg
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
Had no idea the formula couldn't work with empty cells.
Once i made that change everything started working.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks