Got an account? | login
Loading Screen Recorder
Screen Recorder Loaded.
Recorder already running.
Graph with Best-Fit

Send us Feedback
Please use the form below or email us at feedback@screencast-o-matic.com

Your email address:


Your Comment:


 
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
    • Language:
      English
    • Views:
      10,221
    • Rating:
      • Currently 3.00/5
      • 1
      • 2
      • 3
      • 4
      • 5
      Average: 3.0 (1 vote)
       
  • Share Link

  • Embed Code

    Choose width:
  • Screencast-O-Matic is a free online screen recorder for recording screen capture video and uploading it from your browser with no install!

  • 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.
  • Comments

    • Sorry comments are disabled for this screencast.

©2011 Screencast-O-Matic | Terms of Service | Privacy | Credits