Forum Discussion
Slope equation calculation (Is it the same as trendline?)
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,
IDK what happened to my first reply to you, but here we go again:
Thank you very much for your input! It did help! Now, the numbers are not random. However, they are still not right.
I'll share a sheet of my workbook with the first graph implementing your idea.
Thanks!
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!
