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 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:

The tutor tells how to find the number of a day in the year with Excel or LibreOffice Calc. Today, October 21, 2016, is the 295th day of 2016. How do I know? Here are two ways: Counting the days …

Spreadsheets: which day in the year is this? -Calculated with Excel or LibreOffice Calc Read more »

Tagged with: , , ,

The tutor explains how to make a loan payment table. Example: Make a table to show the retirement of a $5000 loan, at 5.99% compounded monthly, with monthly payments of $221.58. The loan will be retired in 24 payments. (Note …

Spreadsheets: how to make an amortization table in Excel or LibreOffice Calc Read more »

Tagged with: , ,