Point Graph and Derivative

  • Thread starter Thread starter Ming Chen
  • Start date Start date
M

Ming Chen

Hi, Gurus.
I'm using Excel for one of my classes and having this problem. Let's say,
I have a number of sample {x, y} pairs. I have produced a correlation graph
y = f(x) with XY (Scatted), and have the line smoothed.
But what I really care about is not f(x), but f'(x) = dy/dx, the
derivative of f(x). So, my question is, with only the graph I have got, is
there a way to produce a derivative graph of f(x) in excel?

Thanks
Ming Chen
 
Play with adding trendlines until you get a good fit (2nd, 3rd, 4th order
Use LINEST to get the fit parameters in cells (see my website)
Differential the equation of best fit
 
Back
Top