Thread: [Solved] trendline error
View Single Post
 
Old 11-21-2016, 05:09 PM
jayjones90 jayjones90 is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Nov 2016
Posts: 1
jayjones90 is on a distinguished road
Default trendline error

Hi, Im using a polynominal equation for a last year thesis but have been having a problem.

I have used every polynominal order however none are giving me the correct answer which im using to compare with measured data in order to validate the polynominal equation is working correctly, it is not as you can see in my attached image i have used 10 as "x" however answer is not giving me the same answer as he measured data for 10.

how could i fix this issue? decimal places have already been increased but made no difference.

I have already imported the data on Matlab and used the polynominal function on there instead which did give an answer identical to the measured data so im just curious into what the issue with excel is?

Thanks


Last edited by jayjones90; 11-21-2016 at 05:09 PM. Reason: insert needed image