The original poster is working on a Linear Least Squares Excel template for a Physics lab, specifically focusing on analyzing linear data. They report that while most values are calculated correctly, the standard deviation values are problematic and seek assistance in identifying the issue.
Some participants have provided guidance on the order of calculations in Excel and the potential for errors when using uncomputed values in formulas. There is an exploration of alternative methods to handle division by zero errors, but no consensus has been reached on the best approach.
Participants note the presence of #DIV/0! errors in the original poster's calculations, indicating issues with the formulas used in the template. There is an emphasis on the importance of calculation order in Excel.
danielu13 said:Homework Statement
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.
Homework Equations
The Attempt at a Solution
See attached file.
Yes.danielu13 said: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,
I don't know what you're saying here. At any rate, you don't want to use a value in a formula before you have computed it. That's why you had all those #DIV/0! errors.danielu13 said: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?
Mark44 said:Yes.
I don't know what you're saying here. At any rate, you don't want to use a value in a formula before you have computed it. That's why you had all those #DIV/0! errors.