View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Using linest or logest for non-linear equations

Maybe look at the TREND function, since you know your Xs and Ys?
--
Brevity is the soul of wit.


" wrote:

I need to find four coeffecients for the equation y=a-b*exp(-c*x^d). I have
the x and y values but want to smooth the data. I've been trying to fit a
non-linear trend to the equation using the power and log trends but since my
equation differs I cannot get them to work. Do you know any way to find
these coefficients?