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 …
Tutoring spreadsheets, here’s the next level of complexity with the sumif() function: a separate test range. In my March 9 post I brought up sumif(), pointing out that it will selectively add values within a given range. sumif() offers one …
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 its simplest, the sumif() function adds the members of a range that meet a certain condition; those that don’t, aren’t included in the sum. …
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 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 …
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 …
The tutor gives an example of using Excel’s Goal Seek. Example: Solve lnx + 15= 0.25x Solution: Select a cell (let’s imagine e3), then name it X (or whatever name you prefer. See how to name a cell in my …
Spreadsheets: how to use Excel to solve an equation Read more »
The tutor shows the seriessum() function, found on both Excel and LibreOffice Calc. A geometric series has the form Sn = cr0 + cr1 + … + crn-1 An example is 3 + 3*4 + 3*42 + … + 3*45 …
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 has log and ln keys, with the log base 10, the ln base e. What if you need log base 5, for instance? Of …
The tutor shares a nice function that seems to work the same in Excel or LibreOffice Calc. The frequency() function tells, from an array of values and another of categories, the frequency in each category. A potential use is to …
Statistics: Spreadsheets: the frequency() function Read more »
The tutor shares quick, easy way to get a graph and equation from Excel, 2007 version. Let’s imagine your x data is in range a1:a10, your y-data, b1:b10. Select a1:b10, then click Insert, then the Scatter icon. Then, in the …
Excel: How to make a graph from data and get an equation, 4 easy steps Read more »