- #1
jadi929
- 2
- 0
Hey guys, I'm working on some Current-Voltage data in excel. I need to do some analysis with the data, and the first step is to compute dV/dI. I have to do this in excel so decided to use excel's SLOPE function (5 point slope) to compute dV/dI. However, it seems that the derivative has a lot of noise, especially towards the lower values. Since I am writing a program to automate this analysis, I would really like to get rid of this noise.
Another way I thought of was to fit a line to my initial data, and simply differentiate the fitted line's equation. However, I can't seem to get a decent fit for my initial curve.
Pic shows the initial data and my horrible looking derivative.
screenshot app
Another way I thought of was to fit a line to my initial data, and simply differentiate the fitted line's equation. However, I can't seem to get a decent fit for my initial curve.
Pic shows the initial data and my horrible looking derivative.
screenshot app