equation of a curve
 

I created a simple curve on excel using data points.How can I get the
polynomial equation of the curve ?

equation of a curve
 

Hi Naty

Right click on one of your data points and select Add trendline.
The trendline dialog boxes offers a number of options for
type of trendline, showing equations in chart etc.

HTH
Martin

equation of a curve
 

Or you can use LINEST; see
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Naty" wrote in message
...
I created a simple curve on excel using data points.How can I get the
polynomial equation of the curve ?

equation of a curve
 

Well, thanks for the advice, but I think since my curve is not linear or
something, it doesn't give me the Add trendline option. My curve looks like a
3rd order polynomial.

"MartinW" wrote:

Hi Naty

Right click on one of your data points and select Add trendline.
The trendline dialog boxes offers a number of options for
type of trendline, showing equations in chart etc.

HTH
Martin

equation of a curve
 

Hi Naty,

You have to be using an XY Scatter chart, not a line graph.
The scatter graph allows for polynomials from 2nd to 6th orders
amongst other options. How is your curve and data setup?

Martin