Fitting exponentials to data in Excel?

[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.

[moeur]

try using the solver

[Rassis]

Check whether the attached EXCEL application solves your problem.

Have a nice time.

[jvmiller]

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]

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

Cheers

[yrwyddfa]

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

[Rassis]

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

[Mridul]

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?