Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the equation of the trend line onto the excel sheet
I have graph that is changing continuously and its trendline changes
accordingly. I use the equation of the trendline to do some calculations. Since the data is quite dynamic and I have a large number of graphs, is there a way to have the trendline equation printed in a cell. I can then write a macro to do my calculations. Thanks. Farooq |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the equation of the trend line onto the excel sheet
Try the LINEST() function.
http://j-walk.com/ss/excel/tips/tip101.htm -- David Biddulph "Farooq Sheri" wrote in message ... I have graph that is changing continuously and its trendline changes accordingly. I use the equation of the trendline to do some calculations. Since the data is quite dynamic and I have a large number of graphs, is there a way to have the trendline equation printed in a cell. I can then write a macro to do my calculations. Thanks. Farooq |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the equation of the trend line onto the excel sheet
Thanks; in fact I have to use INTERCEPT function along with either SLOPE or
LINEST to get the answer. Regards Farooq "David Biddulph" wrote: Try the LINEST() function. http://j-walk.com/ss/excel/tips/tip101.htm -- David Biddulph "Farooq Sheri" wrote in message ... I have graph that is changing continuously and its trendline changes accordingly. I use the equation of the trendline to do some calculations. Since the data is quite dynamic and I have a large number of graphs, is there a way to have the trendline equation printed in a cell. I can then write a macro to do my calculations. Thanks. Farooq |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the equation of the trend line onto the excel sheet
Read the LINEST documentation. It will give you SLOPE, INTERCEPT, and more.
Better yet, read Bernard Liengme's explanation: http://people.stfx.ca/bliengme/exceltips/Polynomial.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Farooq Sheri" wrote in message ... Thanks; in fact I have to use INTERCEPT function along with either SLOPE or LINEST to get the answer. Regards Farooq "David Biddulph" wrote: Try the LINEST() function. http://j-walk.com/ss/excel/tips/tip101.htm -- David Biddulph "Farooq Sheri" wrote in message ... I have graph that is changing continuously and its trendline changes accordingly. I use the equation of the trendline to do some calculations. Since the data is quite dynamic and I have a large number of graphs, is there a way to have the trendline equation printed in a cell. I can then write a macro to do my calculations. Thanks. Farooq |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting the equation of the trend line onto the excel sheet
Alternately, Tushar Mehta has enhanced VBA code by David Braden to extract
coefficients from the chart trendline. http://groups.google.com/group/micro...da30f29434786d If you are using an Excel version prior to 2007, this would be a useful sanity check. LINEST prior to 2003 can lose numerical accuracy for numerically challenging problems. LINEST in 2003 is overall much better numerically, but coefficients of exactly zero are not to be trusted. Jerry "David Biddulph" wrote: Try the LINEST() function. http://j-walk.com/ss/excel/tips/tip101.htm -- David Biddulph "Farooq Sheri" wrote in message ... I have graph that is changing continuously and its trendline changes accordingly. I use the equation of the trendline to do some calculations. Since the data is quite dynamic and I have a large number of graphs, is there a way to have the trendline equation printed in a cell. I can then write a macro to do my calculations. Thanks. Farooq |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Results of trend line in Excel | Charts and Charting in Excel | |||
dubbel trend line in excel? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) |