TECHNICAL HELP

Technical Notes:

In order to run the Excel spreadsheets, you'll need to have the Analysis ToolPak Add-In installed. It's really easy to do. Just open up Excel and go to Tools on the menu bar, and follow: Tools->Add-Ins->Analysis ToolPak (check box). This gives Excel the functionality to create random numbers each time you press F9 and update your spreadsheet accordingly. You can either run these spreadsheets in your browser, or - in the case of Birthdays USA 1978, Experiment two and Radioactive decay spreadsheets, you might want to download them directly to your own computer by right-clicking on the "enter activity" buttons and choosing "save target as". (These activities require you to add formulae or charts to the sheet).

I have programmed some macros in the Experimentone, Families Special Dice, Birthdays, Maternity, Chevalier de Mereand Alex/Beth spreadsheets. Your computer will tell you this and warn you not to open them unless you trust the writer of the macros not to slip in a virus. You can trust me.One file - The Birthday Problem- uses the FATHOM dynamic statistics application. If you don't have it, Download the Fathom V1.03 Demo Installer but remember that this version will not let you print nor save. 

Tech Help for the Families, Special Dice, Birthdays, Maternity and Chevalier de Mere spreadsheets;
the tallying of scores requires the use of a circular formula which is not allowed in the normal calculation mode.
So we need to do the following; Tools-Options-Calculation-Automatic Iteration - Maximum Iterations 1 - OK

This site is best viewed on an 800 by 600 pixel screen with the toolbar on auto hide.

The spreadsheets are sized between 37K and 353K so they do take some time to download. Please be patient.

If you do not have Microsoft Excel installed on your computer don't panic - you can download a free Excel viewer here.