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