higher order polynomial fit line x-coefficients

[barrfly]

I want to feed the coeffieicent from a best fit polynimial line into
individual excel cells. I know that I can see the equation in the
chart view, but how do i get the coefficients? Much like getting the
slope of a straight line wioth the slope function.

Thanks

 

[Guest]

I want to feed the coeffieicent from a best fit polynimial line into
individual excel cells. I know that I can see the equation in the
chart view, but how do i get the coefficients? Much like getting the
slope of a straight line wioth the slope function.

Thanks

You can do this just with the normal straight line fitting function LINEST() --
and some cleverness. Look at this web page for an example:

http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm

Take particular note of the last line telling you how to enter an array function
with Shift/Ctrl/Enter.

Good luck....

Bill

 

[Jerry W. Lewis]

LINEST is the easiest solution, but it is useful to compare LINEST
coefficients with those of the chart trendline, since LINEST can have
numerical problems under some circumstances.

Jerry

 

[Amedee Van Gasse]

barrfly shared this with us in microsoft.public.excel.misc:

I want to feed the coeffieicent from a best fit polynimial line into
individual excel cells. I know that I can see the equation in the
chart view, but how do i get the coefficients? Much like getting the
slope of a straight line wioth the slope function.

Thanks

This page would be interesting for you:
http://j-walk.com/ss/excel/tips/tip101.htm