Forum Discussion
Solved
Slope equation calculation (Is it the same as trendline?)
Hi there, I'm trying to calibrate a temperature monitoring system in reference to a calibrated one. The relation is not linear, so the difference equation is not linear. This is where Excel com...
The forum has been broken since late 2024. I only now got a notification of your reply.
For a 4th degree polynomial, you can't just calculate the slope - you have to calculate the coefficients for x, x^2, x^3 and x^4. For OpSens CH2 to PICO CH1:
To use this to predict/interpolate values:
These values look reasonable to me.
The displayed equation of a trendline may have rounded constants. You can change the number format of the equation by clicking on it and then hitting the short-cut key combination Control+1.
You can then set options like these:
Hey JKPieterse,
Thank you for your input! that helped!
The numbers now are not random, however, they are still not correct.
I'll try to share my workbook.
Thanks!