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 …
Tag: Excel
Statistics: Spreadsheets: tdist() function
The tutor covers the tdist() function, which seems to work the same on Excel and LibreOffice …
Spreadsheets: Matrix inverse on Excel or LibreOffice Calc
The MINVERSE() function can be tricky to use; the tutor tells how. Example: find the inverse …
Spreadsheets: Matrix inverse on Excel or LibreOffice Calc Read more →
Spreadsheets: Excel: conditional formatting
The tutor opens the discussion about how to display, automatically, a cell’s content according to its …
Spreadsheets: Excel: cumprinc() function
The tutor shows an example using Excel’s cumprinc() function, which calculates the reduction of the amount …
Spreadsheets: internal rate of return (IRR) on LibreOffice Calc
The tutor promotes his equal-opportunity point of view towards computing. I use Microsoft’s programs: witness my …
Spreadsheets: internal rate of return (IRR) on LibreOffice Calc Read more →