Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to get polynome (or other type) coefficients of a trendline?
I would like to get coefficients of a trendline (any type) from a chart into
a cell for further analysis.Thanks |
#2
|
|||
|
|||
You can use LINEST for this purpose
http://www.stfx.ca/people/blie ngme/ExcelTips/Polynomial.htm Help for LINEST may have misled you into thinking that it is far more limited than it really is. Alternately, David Braden has posted VBA code to extract the coefficients directly from the chart into cells http://groups.google.com/groups?selm....microsoft.com The advantage of using the chart coefficients (either manually or via Braden's code) is that pre-2003 LINEST uses a numerically poor algorithm that can give inaccurate results with some data sets. The chart trendline (extracted by Braden's code) is much better numerically, provided you format the equation to display to full precision (scientific notation with 14 decimal places). Jerry GoranR wrote: I would like to get coefficients of a trendline (any type) from a chart into a cell for further analysis.Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup argument type | Excel Worksheet Functions | |||
multiple results display after filter function | Excel Worksheet Functions | |||
How do I reverse the linest coefficients? | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |