View Single Post
  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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 wrote:

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