Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 11-21-2016, 05:09 PM
jayjones90 jayjones90 is offline trendline error Windows 7 64bit trendline error Office 2016
Novice
trendline error
 
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
  #2  
Old 11-22-2016, 12:29 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline trendline error Windows 7 64bit trendline error Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,776
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Cross posted without links
Please read this to understand why posting links to cross posts is necessary and add links to ALL your cross posts
http://www.mrexcel.com/forum/excel-q...ml#post4688750
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
  #3  
Old 11-22-2016, 12:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline trendline error Windows 7 64bit trendline error Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,776
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Problem solved at EF ( another cross post)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Closed Thread



Similar Threads
Thread Thread Starter Forum Replies Last Post
trendline error Interception between trendline and markers? tinfanide Excel 4 08-24-2015 06:57 AM
Linear trendline? markg2 Excel 0 06-25-2015 05:19 AM
trendline error Automation error Unknown error" message once they open the Excel file hlina Excel 1 10-08-2013 09:14 PM
trendline error Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!! bennypryde Office 1 01-05-2012 03:33 PM
Runtime error 5487 - Word cannot complete the save to to file permission error franferns Word 0 11-25-2009 05:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft