Graph with Best-Fit

Created: Aug 4 2007

Description

This shows how to graph a straight line in Excel and add the best fit line.

Notes

0:00

Make sure you do not have any words with the data

0:07

Highlight the data

0:09

Choose XY(Scatter)

0:20

Label the axes

0:45

Choose "add trendline" from the Chart menu

0:57

Go to the Options tab

1:02

The equation will be the y=mx+b equation of the line

1: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.

Advertisement