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

Tutoring spreadsheet usage, cell references are important. Let’s imagine you want a1 in the first sheet of a workbook to have the value of b1 in sheet 2. Here’s how you can do so with text: Excel: type, in a1 …

Spreadsheets: how to reference a cell on a different sheet in Excel and in LibreOffice Calc Read more »

The tutor explains how to change from scientific notation to regular number format in Excel or LibreOffice Calc. In my post from Feb 14 I mention that 1.69e-05 equals 0.0000169. Written 1.69e-05, the number is in scientific notation. Perhaps the …

Spreadsheets: Excel, LibreOffice Calc: number formatting: how to get rid of E-05 (for example) Read more »

Tagged with:

The tutor shows how to get a graph and equation for data using LibreOffice Calc, in six easy steps. Let’s imagine your x-data is in a1:a5, your y-data, b1:b5. Select the range a1:b5. Click the Chart icon, which looks like …

Spreadsheets: LibreOffice Calc: how to get a graph and equation from data Read more »

Tagged with: