Posted in A Level Physics

# Least Square Fit Calculation with Excel

Salam.

Today we’ll look at a technique of linear graph analysis called the least square fitting method. Why do we need to find a best fit line to a set of data in the first place? Because a graph is used to show whether there is a relation between the dependent variable (y-axis) and the independent variable (x-axis). In view of the lab practical that you carried out last week, we’ll plot the best fit line using the spreadsheed software Microsoft Office’s Excel. If you’re a fan of open source software, you could always use OpenOffice.org’s Calc (as useful as Excel, and it’s free).

Download the file  “Least squares fitting with Excel” (in pdf format) and open the file in your local computer.
least-squares-fitting-with-excel.

Having said that, if the example in the aforementioned file is too complicated (it is!!) then try this one.It’s more forgiving on your brain….save you guys the headache.. Click the following url linest.

And then, there ‘s chapter 30 on Communicating Information. Click on this: Radio

## Author:nazarin

A graduate in Applied Physics and MSc in Superconductivity, as of recently taught diploma science and teaches A Level. Now lectures at an international automotive college nowadays.Aspires to become an internet entrepreneur/supreme inventor.

## 6 thoughts on “Least Square Fit Calculation with Excel”

1. yanie says:

sir, complicatednyer..

2. Sorry for writing OFFTOPIC – what Word Press theme are you using? It’s looking cool.

1. nazarin says:

it’s Contempt by Michael Heilemann.
sorry for the very very late reply….

3. I drop a comment each time I appreciate a article on a website or I have something to contribute to the discussion.
Usually it’s caused by the fire communicated in the post I read. And on this article Least Square Fit Calculation with Excel | Wanderings. I was actually moved enough to leave a thought 🙂 I actually do have a couple of questions for you if you usually do not mind. Is it only me or do some of the responses come across like written by brain dead visitors? 😛 And, if you are writing on other sites, I’d like to