Register to reply 
Method of Least Squares Linear Fitting 
Share this thread: 
#1
Aug3007, 10:02 AM

HW Helper
P: 2,616

1. The problem statement, all variables and given/known data
An experiment was conducted on a liquid at varying temperatures and the volume obtained at the differing temperatures are as follows:
Question: Linearize the above equation and plot the corresponding curve. 2. Relevant equations Microsoft Excel LINEST function, Least squares method statistical equations (too many to post) 3. The attempt at a solution Here's what I understand about linear least squares fitting. I attended a lab session where I was taught how to apply the least squares method in Excel to linearize a given equation and then use mbest and cbest to calculate the other unknown constants in the equation. My understanding is that firstly one takes the equation, and tries to express it, in any mathematical way possible in the form y=mx + c, where y is the dependent variable and x the independent variable. Hence while the y does not have to be the same independent variable as measured directly in the experimental setup, x has to be the same. Hence the resulting linearized equation cannot use expressions of x which are functions of x expressed in ways apart from simply x. eg. x^2 is not allowed, ln x is not allowed. Is this understanding correct? If so, then how is it possible for me to linearise the above given equation? I only got as far as: [tex]\theta + \frac{B}{2D} = \sqrt{ \frac{V1}{D} + (\frac{B}{2D})^2 [/tex] which should suggest (or at least it does to me) that mbest in Excel using the LINEST function should be 1, since the coefficient of θ is 1. But instead I get 0.003004423, which means I have somehow linearized the equation wrongly. How else could it have been linearized? EDIT: I didn't quite get what it means by "plot the corresponding curve". I assume this involves using Excel, but apart from using as source data the values of V and theta from the table, what else could it mean? 


#2
Aug3007, 12:02 PM

HW Helper
P: 4,124



#3
Aug3007, 12:43 PM

P: 1,294

I also got same value, 0.003004423*x+1.00
I instead used http://www.padowan.dk/graph/Download.php it much more better than excel! give it a try. A method to linearlize any equation dV/dt = 2Dt+B find dV/dt when t = 50 [almost middle point] and so y1.156 = (dV/dt)[t50]!! 


#4
Aug3007, 06:47 PM

HW Helper
P: 2,616

Method of Least Squares Linear Fitting



Register to reply 
Related Discussions  
Curve fitting and least squares method.  Calculus & Beyond Homework  2  
LeastSquares fitting of King's Equation  Introductory Physics Homework  3  
Weighted Least Squares Fitting Program  Precalculus Mathematics Homework  0  
Numerical Methods  Linear Least Squares, NonLinear Least Squares, Optimization  Math Learning Materials  0  
Linear Regression, Linear Least Squares, Least Squares, Nonlinear Least Squares  Linear & Abstract Algebra  4 