|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 5th, 2006, 11:15 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
trendline error
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: http://www.excelforum.com/member.php...o&userid=30169 View this thread: http://www.excelforum.com/showthread...hreadid=498527 
|
|
#2
January 5th, 2006, 11:28 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
trendline error
jlsexcel -
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 "jlsexcel" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=30169 View this thread: http://www.excelforum.com/showthread...hreadid=498527
|
|
#3
January 6th, 2006, 07:06 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
trendline error
see my Excel Tips on the use of LINEST for polynomial fit -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "jlsexcel" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=30169 View this thread: http://www.excelforum.com/showthread...hreadid=498527
|
|
#4
March 1st, 2006, 02:55 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
trendline error
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 "jlsexcel" wrote: 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: http://www.excelforum.com/member.php...o&userid=30169 View this thread: http://www.excelforum.com/showthread...hreadid=498527
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| UNC Names for splitted backend database | Veli Izzet | General Discussion | 9 | October 12th, 2005 02:07 PM |
| Error message different in MDB and MDE | david epsom dot com dot au | General Discussion | 1 | September 21st, 2004 12:47 AM |
| Help, i'm gettiing error: Access has encountered a problem and needs to close... | betsy | General Discussion | 0 | September 14th, 2004 08:20 PM |
| Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
| Error #1321 MOS 2003 Setup | Chad Harris | Setup, Installing & Configuration | 1 | June 7th, 2004 12:22 AM |
Linear Mode
