David,
Sure, I can retype the polyonomial in a cell and then use the equation but
what I was trying to do was automatically extract and use the coefficients in
further calculations without having to retype them because the data that was
curve fit was for one piece of a product that was going to be mass produced
but may have slightly different data from each piece.
Thanks anyway. Oter ideas anybody?
--
Matt J


"David" wrote:

Hi. I tried to do this once before also. I wanted to find the points on the
trend line to work with them. I was trying with the 6th degree and the
numbers got to large for Excel to do with, but maybe with the 3rd degree you
can do it. You need to put the formula in a cell and actualy use the formula
to find the data points. I was trying to find stock market closing and a
derivative, but was not able to in the end.
--
David


"Matt J" wrote:

I used the "add trendline" in Excel 2000 to do a 3rd order poly curve fit of
some data. Works great and I chose the "display equation" feature so I can
see the resulting polynomial coefficients, BUT, how can I automatically use
these coefficients in further calculations? Are they, can they be, available
in cells? Used elsewhere, for a slope (derivative) function for instance?
--
Matt J