The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Nonlinear curve fitting with exponential function
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Thinh89

Vietnam
2 Posts

Posted - 08/09/2014 :  03:45:49 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi everybody
I am getting some confusions when i try to use nonlinear curve fitting with exponential function . I have tried in two ways , one is Origin and the other is in Excel to compare the result but it's not the same and the result in Excel looks like better than in Origin. Actually ,i use the diode equation : I = Is*exp(qV/n/k/T -1) so the expotential function should be y = a*exp(b*x)
Here is my result in both of them :


Thank for your helps

cdrozdowski111

USA
247 Posts

Posted - 08/09/2014 :  3:47:45 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hey,

I was able to reproduce your results in Excel and Origin.

If you are concerned that the Origin results may not be quite right, try using another computational product to reproduce the fitting- for example Wolfram|Alpha (because it's easy to do online):

1) In your browser, navigate to http://http://www.wolframalpha.com/
2) Enter the below text (your data in the W|A required format) into the "Enter what you want to calculate or know about:" text box and click the "=" button.

exponential fit {0.24,1E-03},{0.34,0.005},{0.36,0.01},{0.39,0.02},{0.43,0.05},{0.46,0.1},{0.49,0.2},{0.53,0.5},{0.57,1},{0.6,2},{0.65,5.000},{0.68,10},{0.69,14}


You will see that Origin and W|A agree almost perfectly (as they should).

As per the following reference, Excel does a log transformation of the original Y data and then performs a linear fit of that data to get the fitting parameters for the original Y data. This produces somewhat incorrect results. Read the reference for a more thorough explanation.

http://www.mikemiddleton.com/Excel-Exponential-Curve-Fit-2010.pdf

Edited by - cdrozdowski111 on 08/09/2014 9:01:14 PM
Go to Top of Page

Thinh89

Vietnam
2 Posts

Posted - 08/11/2014 :  08:09:21 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank for your explaination . It should be very useful with someone who get the same problem with me but dont know why .
Have a good time !!!
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000