View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Walter Walter is offline
external usenet poster
 
Posts: 78
Default Curve Fitting a Function to known X & Y data

Hi,

I would like to curve-fit the function

(y+d)^2= a+b*(x-c)/ln(x-c)

to X and Y data I have. I would like to know coefficients a,b,c,d,r^2 and
the maximum slope of the function. It is also important for me to see a graph
illustrating both the function and first derivative.

So far I have been doing this using "Tablecurve 2d", but I would like to
built this into a template in order to automate this process (I have over
5000 data files).

Thanks!