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 straightline fit. The slope of that line is equal to the spring constant
k
.
Finding the best straightline 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.
Highlight all cells containing data.
In our example, the first column (A) contains values of
x
,
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '08
 PYRAKNOLTE,LAURA
 Force, Purdue University – Physics, Introduction E1, Trendline Options…

Click to edit the document details