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

## Statistics: Spreadsheets: tdist() function

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 …

## Spreadsheets: Matrix inverse on Excel or LibreOffice Calc

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: When is Easter?

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: trig functions w/ degrees in LibreOffice Calc

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 …

Tagged with: , ,

## Spreadsheets: LibreOffice Calc: the determinant of a matrix

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 …

Tagged with: ,

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