derivative plot

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top