LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Trendline equation and data do not match up

actu.125..Has anyone come across a time when their trendline and data do not
match up?

I have to use a 6th order poly fit on some data I've got. The curve fits
the actual data fine, but when I plot out points using the trendline equation
my data goes crazy.

I have this 6th order equation and x data ranging from 0 to 180 in
increments of 5. the last term of the equation is the y intercept (if x is 0
all other terms fall out) but the trendline eq and the actual data aren't
even close here. The trendline says my y intercept should be .0031, whereas
the actual data (that I created the trendline from) has the y int at .125.
My graph is somewhat sinusoidal... not really but you get the idea, but when
I enter the incremental x data from 0 to 180 into the equation the graph
blows up. The max actual data is around 3 on the y axis and 90 on the x, the
max trendline data is 60 at x = 45. The min actual data is at the y inercept
and is .125 when x = 0 the trendline eq says the min is 3.69 million at x =
180... what gives??!?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
trendline equation doesn't fit data tom r Excel Discussion (Misc queries) 7 August 4th 07 01:42 AM
Trendline equation calculation James Henton Charts and Charting in Excel 3 July 10th 07 10:38 PM
trendline equation terry Charts and Charting in Excel 6 December 19th 06 08:56 PM
Trendline Equation bastien86 Excel Worksheet Functions 5 July 8th 06 03:19 AM
Excel graphed trendline does not match derived equation Keith Charts and Charting in Excel 5 March 13th 06 08:15 PM


All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"