View Single Post
  #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.