LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

If the line was put on using Chart|Add Trendline, click on the Options
tab in the Add Trendline dialog and request the "Display equation on chart"

If by "linear line equastion" you mean a simple straight line, look at
help for the SLOPE() and INTERCEPT() functions.

If by "linear line equastion" you mean a model that is linear in the
unkown parameters (polynomials, multiple linear regression, etc) then
use LINEST. Help for LINEST misleads most people into thinking it can
only fit a simple straight line; just pass the array of all X columns.
Bernard Liengme gave a link to his site showing how to do polynomials
with LINEST without having to create a column for each power of x.

Jerry

Dawn wrote:

how do i calcualte a non linear line equation using excel? i have the graph
with the non loinear line on i just need to put the equation on.


 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how do I graph a linear equation? Throstle Charts and Charting in Excel 3 January 10th 05 05:19 PM
Excel Connector Lines JeffinDallas Charts and Charting in Excel 0 January 10th 05 05:01 PM
How does Excel 2003 calculate trendlines with respect to axes? BeefmanSteve Charts and Charting in Excel 2 December 22nd 04 10:53 PM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM


All times are GMT +1. The time now is 02:51 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"