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?
|