## Excel: payment against principal

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 …

Tagged with: ,

## Math: Excel: entering complex numbers

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 …

Tagged with:

## Statistics, spreadsheets: confidence interval for the mean, population standard deviation unknown: CONFIDENCE.T() function on LibreOffice Calc

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 …

## Statistics, spreadsheets: confidence interval for population mean: CONFIDENCE() function on Excel and LibreOffice Calc

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 …

## Spreadsheets: Excel or LibreOffice Calc: sumif(), continued

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()

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. …

Tagged with:

## Spreadsheets: how to reference a cell on a different sheet in Excel and in LibreOffice Calc

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 …

## Spreadsheets: Excel, LibreOffice Calc: number formatting: how to get rid of E-05 (for example)

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 …

Tagged with:

## Spreadsheets: how to use Excel to solve an equation

The tutor gives an example of using Excel’s Goal Seek. Example: Solve lnx + 15= 0.25x Solution: Select a cell (let’s imagine e3), then name it X (or whatever name you prefer. See how to name a cell in my …

Tagged with: ,

## Spreadsheets: Excel and LibreOffice Calc: the sum of a geometric series

The tutor shows the seriessum() function, found on both Excel and LibreOffice Calc. A geometric series has the form Sn = cr0 + cr1 + … + crn-1 An example is 3 + 3*4 + 3*42 + … + 3*45 …