Straight Line Curve Fit Using Excel

Step 1 First insert the data into Excel as shown. 

Step 2 After inserting the data, select the slope cell, E3, and insert the command  

The result is 1.082. Notice that the y-locations are entered first, followed by the v-locations. 

TABLE E.l. Simulated Data for Two Measurements of the Same Thing (x and y) 

Step 3 To get the intercept, you do the same thing for the intercept cell, E5  

---

Straight line curve fit using Excel, Appendix E, p. 294. 

---