software

I have a plot that requires a polynomial trend line to the fourth power that
has error associated with the y-axis values only. From this point on, I'm
relying on the equation displayed by excel to further manipulate that data,
which I have done and double checked with excel and it's corrrect. I'm
having difficulty, however, in continuing the calculations of associated
error. Is Excel capable of outputting the error associated with each
coefficient of the generated trend line equation? If it is possible, how do
you do it?

- BJR

See Help for the LINEST function. You might also find
www.stfx.ca/people/bliengme/E...Polynomial.htm
to be helpful.

For Excel versions prior to 2003, if the LINEST coefficients do not agree
with the coefficients from an quot;XY (Scatter)quot; chart trendline, then the
calculations are too difficult for the old LINEST. For Excel 2003, LINEST
and and an quot;XY (Scatter)quot; chart trendline coefficients should agree.

In 2003, LINEST can incorretly return a zero for some coefficients, but I
don't believe that can occur with polynomials. When it does occur, the
standard errors output by LINEST are still correct, even though the
coefficient is incorrectly zeroed.

Jerry

quot;BJ Richterquot; wrote:

gt; I have a plot that requires a polynomial trend line to the fourth power that
gt; has error associated with the y-axis values only. From this point on, I'm
gt; relying on the equation displayed by excel to further manipulate that data,
gt; which I have done and double checked with excel and it's corrrect. I'm
gt; having difficulty, however, in continuing the calculations of associated
gt; error. Is Excel capable of outputting the error associated with each
gt; coefficient of the generated trend line equation? If it is possible, how do
gt; you do it?
gt;
gt; - BJR