Can I generate a mX+c Trendline Formula without a graph
 

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.

Can I generate a mX+c Trendline Formula without a graph
 

SLOPE and INTERCEPT will give m and c
LINEST will give m and c and r² and many more statistics
See http://people.stfx.ca/bliengme/ExcelTips.htm for notes on things like
confidence interval for slope.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mcampbe5" wrote in message
...
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.

Can I generate a mX+c Trendline Formula without a graph
 

Thanks Bernard
That does the job perfectly
Regards Mick

"Bernard Liengme" wrote:

SLOPE and INTERCEPT will give m and c
LINEST will give m and c and r² and many more statistics
See http://people.stfx.ca/bliengme/ExcelTips.htm for notes on things like
confidence interval for slope.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"mcampbe5" wrote in message
...
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.