LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Keith
 
Posts: n/a
Default Excel graphed trendline does not match derived equation

I have a scatter-point chart and I have been able to plot the linear
trendline through those scatter points. I then formatted the linear
trendline and got the equation for the line.

However, I noticed that the y-intercept (7.9...) of the actual line that was
graphed by Excel is not the same as the y-intercept (8.9573) for the equation
that Excel derived from the graphed line. The actual Excel graphed line and
the line the equation appear to be parallel to each other. As a result,
entering data into the equation supposedly derived from the graphed line will
not result in the line that was graphed by Excel.

Thank you in advance for your help


 
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
how do i add a quadratic trendline to excel moseichuk007 Charts and Charting in Excel 2 April 3rd 23 04:11 PM
extracting the trendline equation Will1 Charts and Charting in Excel 2 November 25th 05 07:50 PM
Rounding in Trendline Equation Phil Hageman Charts and Charting in Excel 3 January 15th 05 01:15 AM
How do I customize the X-axis in excel to match my dataset? cathy Charts and Charting in Excel 1 January 14th 05 01:25 AM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM


All times are GMT +1. The time now is 10:03 AM.

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"