I need to make some graphs (characteristic of a diode) and I know there is a function in Excel to have a smooth curve, which plotted as an average between the measurement points. Do you know how this function is called?
Printable View
I need to make some graphs (characteristic of a diode) and I know there is a function in Excel to have a smooth curve, which plotted as an average between the measurement points. Do you know how this function is called?
The smoothing in Excel is made via splines: you take 3rd degree polynomials, and adjust their four coefficients with the need of continuity, and smooth 1st and 2nd order derivatives. Then you would have to create sufficient points from those polynomials, so that you can see the curve really smoothed.
Using smooth curves is deceptive. I like to see the data and decide for myself, or with the help of real curve fitting, how the variables are related.
Here's another answer. When you create curves using the bezier tool you can change mode from create to edit and select a point(s) click on it and adjust the handle(s) to smooth out the curve....In case you are unaware of that.