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.

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

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

Do we use mass of H or mass of proton?

Somebody asked we several days ago regarding the use use mass defect formula. In Zm_H do we use the mass of hydrogen always, or use the unified mass of proton?
View this ppt presentation, regarding the issue.

mass of H or p+

Electron capture or positron emission?

Regarding to the latest test you guys took on Nuclear Physics, question 9 states that ⁶⁴Cu decays into ⁶⁴Ni isotope by means of positron emission (Schaum’s Outlines’ Applied Physics 4th Edition). But if you pay a visit to webelements at this hyperlink you’ll see that ⁶⁴Cu decays into ⁶⁴Ni by means of electron capture. Which one is correct? I don’t know for sure, butI know that whether by positron emission or electron capture, both type of decay would resulted in proton being converted to neutron.

RADIOACTIVITY

Yesterday we covered the last parts on nuclear reactions – namely fission and fusion process. Today we proceed with the last topic in this chapter: Radioactivity literally means the spontaneous emission of particles and/or energy from atomic nuclei. As a result, energy is lost/liberated.

Or, you may download it HERE. (click me!click me!click me!)
To Fara and Farhan, thanks for pointing out the mistakes in the notes.