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
Hi there. The formula you used was spot-on. However, you used APPROXIMATIONS of the variables. You need to calculate them exactly and then feed them into your sums. see the attached.
Glenn
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
Thanks alot !
OK. can you mark the thread as solved and, preferably, click the add reputation button at the foot of my post, if you found the answer helpful.
Ok, done !
Many thanks...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks