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 »

Tagged with: , ,

The tutor mentions Excel’s convenient conversion utility. I used to wonder, casually, what a nautical mile is compared to an ordinary mile. Not anymore: today I discovered Excel’s convert() formula, which is among the Engineering ones in More Functions, in …

Spreadsheets: Excel: convert() function Read more »

Tagged with: , ,

The tutor tells how to have Excel evaluate a determinant for you. Here’s how: Key in your matrix values. Let’s imagine you use the range a1:d4. Select a cell away from the range, let’s say f6. Key in =mdeterm(a1:d4) then …

Spreadsheets: finding the determinant of a matrix using Excel Read more »

Tagged with:

The tutor tells how to set a border around a selected area in Excel. Here’s how: Select the area around which you want a border, then right click. You’ll see a toolbar and a menu. On the toolbar, find the …

Spreadsheets: How to border a range of cells in Excel Read more »

Tagged with: ,

The tutor shows an example of how to use the yearfrac() function in Excel or LibreOffice Calc. Example: Find the fraction of a year between January 10, 2016, and June 2, 2016. Solution: In Excel or LibreOffice Calc, select a …

Spreadsheets: Calculating fraction of a year: yearfrac() function Read more »

Tagged with: