calculate non linear equation lines using excel

G

Guest

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.
 
G

Guest

Dawn said:
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.

There are hundreds (or thousands) of forms of non-linear equations. You
gotta know what you want to figure out how to get there.

If you're looking for a simple approximation, then for example you can
put your data points onto a chart in Excel. Then right click on the
line on the chart and select "Add Trendline". From that panel choose
the form of non-linear equation you're looking for and on the Options
tab select the "Display Equation on chart".

If you're looking for an exact fit to your data, then you'll need to
know more about mathematics.

Good luck...

Bill
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top