Graph with Best-Fit
Created: Aug 4 2007
This shows how to graph a straight line in Excel and add the best fit line.
Make sure you do not have any words with the data0:07
Highlight the data0:09
Label the axes0:45
Choose "add trendline" from the Chart menu0:57
Go to the Options tab1:02
The equation will be the y=mx+b equation of the line1:03
The closer the R-squared value is to one, the straighter the line.1:10
Note the R-squared value - not quite 1 but pretty good.1:15
You now know the slope and y-intercept of the line.