View Single Post
  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

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.


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