Tutoring financial math, you might often use the HP-10B. The tutor shows how easily it can apply a discount then add tax to get the final price. Example: Imagine a handbag is regular price $85 but is discounted by 20%. …
Calculator usage: finding final price after discount and tax with the HP-10B Read more »
Tutoring financial math, you’ll likely encounter the capable HP-10B. The tutor tells how to use its user-accessible memory. The HP-10B seems to have 11 dedicated places to store your own numbers. The locations are at 0 to 9, plus there …
Tutoring Business English, word processing formats inevitably arise. The tutor suggests how to change the date format in Microsoft Word 2007. I prefer the date format April 14, 2017. There’s no chance of misunderstanding it, since the month is a …
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 statistics, confidence intervals are important. A two-sided confidence interval for the population mean is given by sample_mean – (standard_dev/n1/2)*sig_factor, sample_mean + (standard_dev/n1/2)*sig_factor The sig_factor (significance factor) depends on the certainty (confidence level) with which we want the confidence interval …
Statistics: confidence interval for the mean (two sided) Read more »
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 »
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 shares another brand find. I’ve known of Tetley since I can remember. Who owns the brand? Apparently, since 2000, it’s been part of TATA Global Beverages. Tetley had been a UK company since 1837. It seems that Tetley …
The tutor probes more deeply into the concept of the US trade deficit. In my January 1 post I began about the US trade deficit, mentioning, for example, that it’s exceeded $500 billion per year over the last ten years. …