Tutoring financial math, loan payments are calculated. The tutor mentions how Excel handles payments at period beginning, as opposed to period end. In my post of October 5, I show how to find the monthly payment of a loan using …
Excel: finding loan payment at the beginning of the month Read more »
Tutoring financial math, spreadsheets might be used. The tutor shows how to find the monthly payment on a loan using Excel. In yesterday’s post I tell how to find the amount against the principal that a certain payment removes, using …
Spreadsheets: Excel: finding the monthly loan payment Read more »
Tutoring financial math, amortization arises. The tutor mentions the Excel function for it. Example: For a 25-year loan of $100,000 at 4%, compounded monthly with monthly payments, what is the amount against the principal of the 101st payment? Solution: Using …
Tutoring differential equations or complex variables, you might use a spreadsheet sometimes. The tutor gives a hint about entering complex numbers on Excel. Excel does, indeed, handle complex numbers. Formulas for them are among the Engineering ones. Apparently, to enter …
Tutoring statistics, the tutor is happy to share the CONFIDENCE.T() function from LibreOffice Calc. My last couple of posts (here and here) I’ve talked about confidence intervals for the mean. Yesterday I mentioned finding one using Excel or LibreOffice Calc’s …
Tutoring statistics, you realize how convenient using a spreadsheet can be. In yesterday’s post I mentioned some theoretical points about two-sided confidence intervals for the population mean. On the practical side, if you simply need a confidence interval for the …
Tutoring spreadsheets, here’s the next level of complexity with the sumif() function: a separate test range. In my March 9 post I brought up sumif(), pointing out that it will selectively add values within a given range. sumif() offers one …
Spreadsheets: Excel or LibreOffice Calc: sumif(), continued Read more »
The tutor shows the neat function sumif() found on Excel and also on LibreOffice Calc. At its simplest, the sumif() function adds the members of a range that meet a certain condition; those that don’t, aren’t included in the sum. …
Spreadsheets: Excel or LibreOffice Calc: sumif() Read more »
Tutoring spreadsheet usage, cell references are important. Let’s imagine you want a1 in the first sheet of a workbook to have the value of b1 in sheet 2. Here’s how you can do so with text: Excel: type, in a1 …
The tutor explains how to change from scientific notation to regular number format in Excel or LibreOffice Calc. In my post from Feb 14 I mention that 1.69e-05 equals 0.0000169. Written 1.69e-05, the number is in scientific notation. Perhaps the …