Fitting exponentials to data in Excel?

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.

try using the solver

Check whether the attached EXCEL application solves your problem.

Have a nice time.

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

Thanks for the observation. You may prefer this other solution.

Cheers

http://www.vbforums.com/showthread.php?t=311225

Thanks, it really was quite a piece of work...

Quote:

---

Originally Posted by lauraw123

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?