Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do I graph a linear equation? | Charts and Charting in Excel | |||
Excel Connector Lines | Charts and Charting in Excel | |||
How does Excel 2003 calculate trendlines with respect to axes? | Charts and Charting in Excel | |||
How do I get the trendline equation from Excel to script? | Charts and Charting in Excel |