How to draw a regression line on 7000+ dated data with Excel 2007

J

Jerry W. Lewis

Are your "dates" actual Excel dates or just text?

With actual Excel dates, pre-2007 versions have no problem doing simple
linear regression. To interpret the results though, you need to remember how
Excel dates are stored: An Excel date is the number of days since 1900, so
the numeric value of today's date is 39736, and the intercept of the
regression will be the value of the relationship extrapolated to 30Dec1899
(since Excel mistakenly considers 1900 to be a leap year)
 
S

ShaneDevenshire

Hi,

First select the series on the chart, then choose Chart Tools, Layout,
Trendline, Linear or whichever (there are move if you pick More Trendline
Options at the bottom of the drop-down).

You can also choose the More Trendline Options if you want to see the
equation Excel came up with and the R squared value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Regression - trend line vs. data points?? 1
how to: polynomial regression trendline excel 2007 1
How to create a graph for a given regression equation? 6
REGRESSION ON EXCEL 2
creating a regression line in a graph 1
How do i draw a regression line on a scatter graph 1
Polynomial regression - how does Excel do it? (under "Trendline") 2
Regression - Data Labels on Chart 4

Top