Straight_Line_Fit - How To Make A Straight Line Fit Using Excel Let's consider the following example One has measured the force necessary to extend

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
How To Make A Straight Line Fit Using Excel? Let's consider the following example : One has measured the force necessary to extend a spring from its rest (equilibrium position) for various extensions. The goal is to find the spring constant. The theory (Hook's Law) predicts the linear dependence between the force and the change of the length of the spring: F = -kx To find the spring constant k, one needs to plot the negative force -F as a function of x and find the straight-line fit. The slope of that line is equal to the spring constant k . Finding the best straight-line fit could be quite time consuming if done with a calculator. Using Microsoft Excel program significantly simplifies the whole procedure. Follow the steps shown below to make a graph and then draw a straight line that fits your data . A. Start Microsoft Excel 2010 (or Excel 2007). B. Enter your data into Excel spreadsheet. C.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/07/2011 for the course PHYS 221 taught by Professor Pyrak-nolte,laura during the Fall '08 term at Purdue University-West Lafayette.

Page1 / 4

Straight_Line_Fit - How To Make A Straight Line Fit Using Excel Let's consider the following example One has measured the force necessary to extend

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online