higher order polynomial fit line x-coefficients

  • Thread starter Thread starter barrfly
  • Start date Start date
B

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
 
barrfly said:
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
Click to expand...


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
 
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
 
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
Click to expand...

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