View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wired PSF Wired PSF is offline
external usenet poster
 
Posts: 1
Default Idential trend line equations show different trends


Hi

I have plotted a trend line based on some actual known data. I have
then manually calculated the y figure by plugging in the trend line
formula.

y = 5E-05x4 - 0.0283x3 + 5.4408x2 - 521.05x + 29719

On that attachment you can see a difference in results even though its
the same trend line.

Any ideas?

Thanks

Wired


+-------------------------------------------------------------------+
|Filename: dummy data.gif |
|Download: http://www.excelforum.com/attachment.php?postid=5103 |
+-------------------------------------------------------------------+

--
Wired PSF
------------------------------------------------------------------------
Wired PSF's Profile: http://www.excelforum.com/member.php...o&userid=36795
View this thread: http://www.excelforum.com/showthread...hreadid=565052