Tutoring statistics, the tutor is happy to share the CONFIDENCE.T() function from LibreOffice Calc. My last …
Tutoring statistics, you realize how convenient using a spreadsheet can be. In yesterday’s post I mentioned …
Tutoring spreadsheets, here’s the next level of complexity with the sumif() function: a separate test range. …
Spreadsheets: Excel or LibreOffice Calc: sumif(), continued Read more →
The tutor shows the neat function sumif() found on Excel and also on LibreOffice Calc. At …
Spreadsheets: Excel or LibreOffice Calc: sumif() Read more →
Tutoring spreadsheet usage, cell references are important. Let’s imagine you want a1 in the first sheet …
The tutor explains how to change from scientific notation to regular number format in Excel or …
The tutor shows the seriessum() function, found on both Excel and LibreOffice Calc. A geometric series …
Spreadsheets: Excel and LibreOffice Calc: the sum of a geometric series Read more →
The tutor shows the log() function on Excel and LibreOffice Calc. Pretty much every scientific calculator …
The tutor shares a nice function that seems to work the same in Excel or LibreOffice …
Statistics: Spreadsheets: the frequency() function Read more →
The tutor shows how to get a graph and equation for data using LibreOffice Calc, in …
Spreadsheets: LibreOffice Calc: how to get a graph and equation from data Read more →