## Mnemonics as a Numbers Memory Aid – Part 3

September 21st, 2009 by Math Tricks | 2 Comments | Filed in Remember Numbers

``` <!-- google_ad_client = "ca-pub-2176115693811858"; /* Mnemonics as a Numbers Memory Aid – Part 3 */ google_ad_slot = "6749683624"; google_ad_width = 468; google_ad_height = 60; //--> ```

Now that you have the code for our mnemonics memory technique to remember numbers, you will need a means of quickly remembering the code so that you can quickly create words and phrases for the numbers that you want to remember.

I’ll only cover a few at a time so that you will not be besieged with too much information at once. Also, it will give you a chance to practice this memory technique using just a few codes at a time; this will help you to commit to memory a few codes at a time very quickly.

First, “1” can be coded as a “t” or a “d”.  Some teach you that a “t” or a “d” has one downstroke.  This is fine, but so do other letters in the codes for other numbers.  I like to remember the game “Truth or Dare”, and in that game, you can only choose one.

Next, “2” can be coded as an “n”.  Lowercase “n” has two downstrokes.

Last, but not least, “3” can be coded as an “m”.  Lowercase “m” has three downstrokes.

That’s it for today – pretty easy, huh?!!  OK, so go out and practice these code letters for 1, 2, and 3.  Don’t worry – it’s as easy as “Tan Me”!

## Excel Rounding

September 13th, 2009 by Math Tricks | 3 Comments | Filed in Bad Math

``` <!-- google_ad_client = "ca-pub-2176115693811858"; /* Excel Rounding */ google_ad_slot = "7409143208"; google_ad_width = 468; google_ad_height = 60; //--> ```

## Excel Rounding

In my line of work, we generate polynomial curves very often.  It is important for us to have software that will generate polynomial equations for the data that we generate – equations for the standard curves that we generate so that we can determine values for our unknown samples.

This is both an example of real life math and bad math.  To start, I’ll just say that we used to generate linear curves for our assays.  The data for these assays were analyzed in Microsoft Excel, and we were very satisfied with the linear curves generated by Excel.

Last year, we changed our assay such that the standard curve that was generated was no longer linear.  The new type of curve was a second-order polynomial (of the form AX2 + BX + C).  So, OK, Excel can handle polynomial data, right?  Well, we discovered a problem with Excel – Excel rounding of the polynomial coefficients!  The problem seems to exist with only large coefficients, but we do deal with polynomials with large coefficients every day.

To illustrate the problem, I generated some data for the equation:

Y = 8386111X2 + 24421000X + 0.058

Here is a table of data generated using this equation:

 X Y 0.00003 732.6955475 0.00033 8059.901247 0.00333 81414.98075 0.03333 823268.0256 0.33333 9072023.463 3.33333 174582076.7

So far so good.  OK, so using Excel (Microsoft Office 2003), I generated this polynomial curve:

As you can see, the equation of the curve generated by Excel is not the same as the equation that we used to generate the data used in our example.  There was some Excel rounding of the coefficients A and B:

Y = 8386111X2 + 24421000X + 0.058     equation used to generate data

Y = 8E+06X2 + 2E+07X + 0.058    equation generated by Excel

Close, but no cigar!  In our line of work, we require precise and accurate data, ant this Excel rounding problem is unacceptable.  We just got in Office 2007, but the problem still exists there too.  We are now using GraphPad, which does not round.

Well, as it is getting close to Halloween, I thought it appropriate to write about this example of Microsoft math tricks – not treats.  Has anybody else discovered any limitations with Excel?  Please feel free to post!