Trendline s. regression analysis

Giganews Newsgroups
Subject: Trendline s. regression analysis
Posted by:  Kris (k.brist…@snhu.edu)
Date: Wed, 8 Oct 2003

Using the same set of data, I created a scatter diagram
with trendline, equation, and R-squared, and performed a
linear regression analysis in Excel.  Both methods
produced the same coefficient and R-squared, but they
resulted in different intercepts.  Regression analysis
with SPSS yields the same results as the Excel regression
analysis.  Why would the intercept as determined by the
trendline be different?

Replies