derivative plot

[Guest]

How do i create a derivative plot?
I'm supposed to take reaction rates (slopes) from my graphs and enter in new
columns in the spreadsheet...i'm confused
thanks

 

[Jon Peltier]

You need to calculate the slopes somehow, or were you just going to eyeball
the? I've sometimes used a moving regression on the data. Say my X (or time)
and Y data were in A1:B100 and I wanted a 5-point moving average. I would
enter this formula in C3, and fill it down to C98:

=SLOPE(B3:B7,A3:A7)

The derivative plot would use columns A and C.

- Jon

 

[Bernard Liengme]

Sounds like Chemistry!
How about using LINEST to get a polynomial fit (see
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm)
Do a manual differentiation of this equation and use it to find the slope at
any point
best wishes