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

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

The tutor opens the discussion about how to display, automatically, a cell’s content according to its value. What if, in Excel, you want to display any value between 78 and 93 in green? Well, you can, using conditional formatting. On

Tagged with: ,