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 the mean, population standard deviation unknown: CONFIDENCE.T() function on LibreOffice Calc Read more »

Tagged with: , , ,

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 …

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

Tagged with: , , ,

The tutor covers the tdist() function, which seems to work the same on Excel and LibreOffice Calc. The tdist() function is in the statistics category of functions. Its entry scheme is =tdist(t-value, degrees_of_freedom, number_of_tails) Perhaps surprisingly, the t-value itself must …

Statistics: Spreadsheets: tdist() function Read more »

Tagged with: , , ,

The MINVERSE() function can be tricky to use; the tutor tells how. Example: find the inverse of matrix A: -5 0 1 3 8 9 0 1 0 Solution: Enter the matrix in Excel or LibreOffice Calc. Let’s imagine, for …

Spreadsheets: Matrix inverse on Excel or LibreOffice Calc Read more »

Tagged with: , , ,

The tutor points out how a spreadsheet can show holiday awareness. Most holidays, such as Valentine’s Day, Halloween, or Christmas, happen on a set date. However, Easter is different. As a child, I overheard it’s the Sunday after the first …

Spreadsheets: When is Easter? Read more »

Tagged with: , ,

The tutor provides a brief hint about using trig functions of angles in degrees on LibreOffice Calc. A person who doesn’t use a spreadsheet very often, probably needs it to work quickly and reliably the rare time they do use …

Spreadsheets: trig functions w/ degrees in LibreOffice Calc Read more »

Tagged with: , ,

The tutor shares a feature of LibreOffice Calc that’s very convenient. I don’t evaluate determinants very often, but in the past I’ve done it a few times. I find it’s a process that requires care. LibreOffice Calc will evaluate the …

Spreadsheets: LibreOffice Calc: the determinant of a matrix Read more »

Tagged with: ,

The tutor promotes his equal-opportunity point of view towards computing. I use Microsoft’s programs: witness my post from Sept 28 about using Excel to calculate IRR. However, some of my computers aren’t Windows; rather, they’re Linux. I don’t have a …

Spreadsheets: internal rate of return (IRR) on LibreOffice Calc Read more »

Tagged with: , , , , ,