Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default equation of a curve

I created a simple curve on excel using data points.How can I get the
polynomial equation of the curve ?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 860
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default 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 ?



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 860
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How To Fit An Equation To A Curve vijay4u Excel Discussion (Misc queries) 0 August 8th 06 08:05 PM
How can I curve fit in Excel? Jimg Excel Discussion (Misc queries) 2 March 18th 06 10:37 AM
Equation to refer to data value(s) and not the cell?? [email protected] Excel Discussion (Misc queries) 2 March 10th 06 09:02 AM
How do I make FORMULA TO SOLVE CURVE OR 2ND ORDER EQUATION? HANY Excel Worksheet Functions 1 September 25th 05 01:31 PM
watch a curve change over time like a movie RandyBarrett Charts and Charting in Excel 6 February 19th 05 05:00 AM


All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"