Re: Results of trend line in Excel
- From: "Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Mar 2006 17:44:22 -0400
The most likely cause is that you are working with two few digits. If you
format the trendline equation to display more digits I am sure you will find
all is well,
Of course, this problem of copying values from the equation is fraught with
problems - typos resulting from arthritic fingers or from poor reading
glasses being some of them
Best to use LINEST to get the coefficients into cells; see
http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"E0sysengiineer" <E0sysengiineer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:80B576AE-7B7C-4999-916A-BF6CD34D3FFA@xxxxxxxxxxxxxxxx
I fitted some data using the trend line tool. The fit purportedly was a
3-rd
order polynmial. When I create a column of values using the coefficients
that Excel found (Display equation), I find the data does not overlay the
trend line. I created data in the range of the fit so there is no error
due
to extrapolation and the fit R value was 0.9999. Is there an error in the
routine that reports the coefficients for polynomial fits? If so, is the
re
a patch or work around?
Thanks
.
- Prev by Date: dot plot - single x axis location with multiple y axis dots
- Next by Date: Re: excel diagram
- Previous by thread: dot plot - single x axis location with multiple y axis dots
- Next by thread: Re: excel diagram
- Index(es):
Relevant Pages
|
