Least Square Fit Calculation with Excel

August 6, 2008

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.

Ok,this is your gift. song-for-you1

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