PDA

Click to See Complete Forum and Search --> : Fitting exponentials to data in Excel?

lauraw123
May 15th, 2005, 07:25 AM
Hello, I was wondering if anyone could help.

I have a set of data which makes up an exponential curve and was wondering how I get the equation of the curve.

Is there a way to do this in Excel or does it need to worked out in some other way?

Any help appreciated.
moeur
May 18th, 2005, 08:25 PM
try using the solver
Rassis
May 20th, 2005, 12:04 PM
Check whether the attached EXCEL application solves your problem.

Have a nice time.
jvmiller
May 31st, 2005, 07:38 PM
create a graph, select the data set, and then add a trendline. then go to format the trendline, and somewhere in there there should be an option to display the equation on the chart. not the most mathematically sound way but it works...

jvmiller
Rassis
Jun 1st, 2005, 03:47 AM
Thanks for the observation. You may prefer this other solution.

Cheers
yrwyddfa
Jul 18th, 2005, 10:51 AM
http://www.vbforums.com/showthread.php?t=311225
Rassis
Jul 18th, 2005, 11:47 AM
Thanks, it really was quite a piece of work...
Mridul
Jul 18th, 2005, 10:21 PM
Hello, I was wondering if anyone could help.

I have a set of data which makes up an exponential curve and was wondering how I get the equation of the curve.

Is there a way to do this in Excel or does it need to worked out in some other way?

Any help appreciated.

Can you please give the y vs x data values or tell how your curve is like - line,circle,parabola,hyperbola,ellipse etc?