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

Finding asymptote equation and how to draw them in excel 0
Regression - trend line vs. data points?? 1
Multi-Selection with Hand-writing draw tool 0
Regression - Data Labels on Chart 4
How to create a graph for a given regression equation? 6
how to: polynomial regression trendline excel 2007 1
How to make the shading look uniform around a double spaced line in MS Word? 0
Using excel 2007, how to draw the line of best fit onto a scatter 0

Top