Tag: Excel

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

Tagged with: , , ,

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

Tagged with: , , ,

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

Tagged with: , , ,

Spreadsheets: Excel: conditional formatting

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: ,

Spreadsheets: Excel: cumprinc() function

The tutor shows an example using Excel’s cumprinc() function, which calculates the reduction of the amount owing over a specific duration. A question a mortgage holder might ponder: “When I go to refinance after 5 years, how much will I

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

Tagged with: , , , , ,