Graph with Best-Fit
 (login)
Looks like you do not have the free java 1.5 (or later) plugin for your browser. Java is a plugin which lets you do alot of cool things right from your browser... You should get it so you can create and view screencasts:
Requires JAVA 1.5 or later if you do not see anything above make sure you have java

  • Description

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

    Stats

    • Created:
      Aug 4 2007
    • Public:
      Yes
    • Audio:
      No
    • Language:
      English
    • Views:
      327
    • Rating:
      • Currently 3.00/5
      • 1
      • 2
      • 3
      • 4
      • 5
      Average: 3.0 (1 vote)
       

  • URL

  • Info

    Embed code

    Choose width:
  • Info

    Export Video (.mov)


      
     
     
     
  • Info

    Notes

    • 0:00Make sure you do not have any words with the data
    • 0:07Highlight the data
    • 0:09Choose XY(Scatter)
    • 0:20Label the axes
    • 0:45Choose "add trendline" from the Chart menu
    • 0:57Go to the Options tab
    • 1:02The equation will be the y=mx+b equation of the line
    • 1:03The closer the R-squared value is to one, the straighter the line.
    • 1:10Note the R-squared value - not quite 1 but pretty good.
    • 1:15You now know the slope and y-intercept of the line.
    More/Less  
  • Info
    ([creator] = comment is from screencast creator)

    Comments

    • Sorry comments are disabled for this screencast.
    More/Less