A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

EXCEL polynomial trendlines



 
 
Thread Tools Display Modes
  #1  
Old August 20th, 2009, 11:49 AM posted to microsoft.public.excel.charting
Fraser Johnson
external usenet poster
 
Posts: 1
Default EXCEL polynomial trendlines

I have been generating trendlines to a number of data set's using a
polynomial fit. If I do not set the intercept to zero the equation indicated
on the graph is correct when I re-generate the trendline curve using second
data set inputing x to obtain y.

However, if I set the intercept to pass through zero the equation given does
not give the correct trendline when I regenerate the curve using a new input
data set for x to obtain y.

Doe anyone have any suggestions of comments as to why this is happening and
what can do to stop it?
  #2  
Old August 20th, 2009, 04:25 PM posted to microsoft.public.excel.charting
Tushar Mehta
external usenet poster
 
Posts: 69
Default EXCEL polynomial trendlines

I am sure your post makes sense to you but it leaves at least me quite
confused.

You are getting the correct trendline with a non-zero intercept and an
incorrect one with the intercept set to zero.

I am not sure what exactly you expect the answer to be to "...why is
it happening?" I guess because one is correct and the other is not?

And, what is it that you want to stop?

On Thu, 20 Aug 2009 03:49:02 -0700, Fraser Johnson Fraser
wrote:

I have been generating trendlines to a number of data set's using a
polynomial fit. If I do not set the intercept to zero the equation indicated
on the graph is correct when I re-generate the trendline curve using second
data set inputing x to obtain y.

However, if I set the intercept to pass through zero the equation given does
not give the correct trendline when I regenerate the curve using a new input
data set for x to obtain y.

Doe anyone have any suggestions of comments as to why this is happening and
what can do to stop it?

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:47 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.