Hello,
I'd like to do a linear regression for each different samples that i have. To save time i was thinking about using RSQ function and see if points seems linear or not. In total i have around 700 samples with uniqual data points. I'd like to have the RSQ from linear regression of thermal conductivity=(f) of temperature (K) and extracting for each sample the slope y-intercept and RSQ values.
Basically i want something like this. So each value for each compound and doing it automatically. So the strategy could be everytime that compound change take into account the new values...
test.PNG
Please find attached the complete table.
I hope I was clear enough.
Thank you for your help!
Bookmarks