software

Hello,

need help.

I created trendlines in excel using polynomial curves. They look pretty
good, but the equations supplied are way off. Can somebody help me.
Using a second order poly gave the best results but still way off.

thanks.--
jlsexcel
------------------------------------------------------------------------
jlsexcel's Profile: www.excelforum.com/member.php...oamp;userid=30169
View this thread: www.excelforum.com/showthread...hreadid=498527jlsexcel -

Perhaps you need to display more significant digits. One way is to click the
trendline equation to select it and then press the Increase Decimal button
repeatedly.

- Mike
www.mikemiddleton.com

quot;jlsexcelquot; gt; wrote in
message ...
gt; Hello,
gt; need help.
gt; I created trendlines in excel using polynomial curves. They look pretty
gt; good, but the equations supplied are way off. Can somebody help me.
gt; Using a second order poly gave the best results but still way off.
gt; thanks.
gt; --
gt; jlsexcel
gt; ------------------------------------------------------------------------
gt; jlsexcel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30169
gt; View this thread: www.excelforum.com/showthread...hreadid=498527

see my Excel Tips on the use of LINEST for polynomial fit
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;jlsexcelquot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; need help.
gt;
gt; I created trendlines in excel using polynomial curves. They look pretty
gt; good, but the equations supplied are way off. Can somebody help me.
gt; Using a second order poly gave the best results but still way off.
gt;
gt; thanks.
gt;
gt;
gt; --
gt; jlsexcel
gt; ------------------------------------------------------------------------
gt; jlsexcel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30169
gt; View this thread: www.excelforum.com/showthread...hreadid=498527
gt;
You can only fit a polynomial trendline to an X-Y scattergraph. They really
should incorporate an error message when you try to fit it to any other type
of graph. Hope this helps.

P. Williams

quot;jlsexcelquot; wrote:

gt;
gt; Hello,
gt;
gt; need help.
gt;
gt; I created trendlines in excel using polynomial curves. They look pretty
gt; good, but the equations supplied are way off. Can somebody help me.
gt; Using a second order poly gave the best results but still way off.
gt;
gt; thanks.
gt;
gt;
gt; --
gt; jlsexcel
gt; ------------------------------------------------------------------------
gt; jlsexcel's Profile: www.excelforum.com/member.php...oamp;userid=30169
gt; View this thread: www.excelforum.com/showthread...hreadid=498527
gt;
gt;

Where is original message?
To the OP: you need to format the trendline to display more digits; or use
LINEST to put the values into cells -
www.stfx.ca/people/bliengme/E...Polynomial.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from emailquot;P Williamsquot; lt;P gt; wrote in message
...
gt; You can only fit a polynomial trendline to an X-Y scattergraph. They
gt; really
gt; should incorporate an error message when you try to fit it to any other
gt; type
gt; of graph. Hope this helps.
gt;
gt; P. Williams
gt;
gt; quot;jlsexcelquot; wrote:
gt;
gt;gt;
gt;gt; Hello,
gt;gt;
gt;gt; need help.
gt;gt;
gt;gt; I created trendlines in excel using polynomial curves. They look pretty
gt;gt; good, but the equations supplied are way off. Can somebody help me.
gt;gt; Using a second order poly gave the best results but still way off.
gt;gt;
gt;gt; thanks.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; jlsexcel
gt;gt; ------------------------------------------------------------------------
gt;gt; jlsexcel's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=30169
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=498527
gt;gt;
gt;gt;