Tag: data fitting

By Posted on Posted in chemistry, linear algebra, math, physics Tagged with , , , ,

The tutor shows a nice trick to obtain a least squares line using matrix algebra. In my Nov 25 post I mentioned how, with Excel or LibreOffice Calc, to get a best-fit line for x y 0 3 2 5 …

Linear algebra: best fit line: method of least squares by hand Read more »

By Posted on Posted in business, Excel, LibreOffice Calc, spreadsheets, statistics Tagged with , ,

The tutor shows how to get a best-fit line using Excel or LibreOffice Calc. Let’s imagine you want a best fit line of form y=mx + b for the following data: x y 0 3 2 5 6 10 8 …

Spreadsheets: linear regression in four easy steps on Excel or LibreOffice Calc Read more »