Register to reply 
Linear Least Squares Excel Template 
Share this thread: 
#1
Oct212, 09:58 PM

P: 68

1. The problem statement, all variables and given/known data
I had to make a Linear Least Squares Excel template for my first week's Physics lab to analyze linear data for the rest of the semester. All of my values come out correctly, except the standard deviation values. I was wondering if someone could take a look at my template and see what the problem is. 2. Relevant equations 3. The attempt at a solution See attached file. 


#2
Oct212, 10:45 PM

Mentor
P: 21,215




#3
Oct212, 10:53 PM

P: 68

Okay, I didn't realize that Excel worked in order like that. So it would work correctly if I put m and b below the D calculation, or could I put a new cell above these that is =E26, and change E26 for the new cell in the calculation formulas for m and b?



#4
Oct212, 11:32 PM

Mentor
P: 21,215

Linear Least Squares Excel Template



#5
Oct212, 11:50 PM

Sci Advisor
HW Helper
Thanks
P: 4,958

RGV 


Register to reply 
Related Discussions  
Linear Least squares  Calculus & Beyond Homework  0  
Uncertainty of linear and non linear leastsquares fit  Set Theory, Logic, Probability, Statistics  6  
Linear Least Squares Fit?  General Physics  1  
Numerical Methods  Linear Least Squares, NonLinear Least Squares, Optimization  Mathematics Learning Materials  0  
Linear Regression, Linear Least Squares, Least Squares, Nonlinear Least Squares  Linear & Abstract Algebra  4 