Excel_Least_Squares_Regression_Example

Excel_Least_Squares_Regression_Example - Spring force -...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Spring force - displacement relation, using Least Squares Trendline fit to data Displacement, cm 2 4 7 11 17 Force, N 2 3.5 4.5 8 9.5 Force exerted on Spring, N 10 9 8 7 6 5 4 3 2 1 0 0 2 4 6 8 10 12 14 16 18 x, Displacement from Equilibrium Position, cm Force, N Linear Regression for Force, N Linear Regression for Force, N y, Force, N f(x) = 0.51x + 1.28 R = 0.96 orce, N near Regression r Force, N near Regression r Force, N ...
View Full Document

Ask a homework question - tutors are online