Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i generate the equation from the graph? | Charts and Charting in Excel | |||
Finding the slope of a trendline without a graph | Excel Worksheet Functions | |||
Trendline on stacked bar graph | Charts and Charting in Excel | |||
How do i add a trendline to a graph with more than 1 data series? | Excel Discussion (Misc queries) | |||
How generate trendline equations for Power, Exp and Log trendlines | Excel Worksheet Functions |