M
mcampbe5
Can anyone give me a bit of advise on whether it is possible to return a
formula similar to the one that is available in the graph trendline tool. I
would like to be able to quickly produce a y=mx+c formula from two columns of
data (e.g. pressure transducer calibration results [V/Bar]) that I can enter
into a data logger.
I have had partial success with =SLOPE(A9:A16,B9:B16) and
=TREND(A9:A16,B9:B16,0) but I was wondering if there is a simpler way.
formula similar to the one that is available in the graph trendline tool. I
would like to be able to quickly produce a y=mx+c formula from two columns of
data (e.g. pressure transducer calibration results [V/Bar]) that I can enter
into a data logger.
I have had partial success with =SLOPE(A9:A16,B9:B16) and
=TREND(A9:A16,B9:B16,0) but I was wondering if there is a simpler way.