Requires JAVA 1.5 or later. Test your Java

Description
This shows how to graph a straight line in Excel and add the best fit line. 
Info
 Created:Aug 4 2007
 Searchable:Yes
 Audio:No
 Views:13,501

Share Link

Embed Code
Choose width:

Notes
 Make sure you do not have any words with the data
 Highlight the data
 Choose XY(Scatter)
 Label the axes
 Choose "add trendline" from the Chart menu
 Go to the Options tab
 The equation will be the y=mx+b equation of the line
 The closer the Rsquared value is to one, the straighter the line.
 Note the Rsquared value  not quite 1 but pretty good.
 You now know the slope and yintercept of the line.

Comments
 Sorry comments are disabled for this screencast.
Advertisement