Gerry's Stats Tools download

To download Gerry's Stats Tools, click this link.

Gerry's Stats Tools is an Excel add-in file. (Its official file name is Gerry's Stats Tools.xla.) You open this file just like you would any other Excel file. It contains a whole bunch of Excel macros that are designed to make stats analysis easier for you. (For those of you who don't know, a macro is a computer program. For the technically minded among you, the macros in Gerry's Stats Tools are programmed in Visual Basic for Applications or VBA for short.)

In order to use Gerry's Stats Tools and Excel Data Analysis tools, there are a few things in Excel you have to check:

1. Under the Tools menu, go to Macros and then Security. Under the Security Level tab, make sure the security is set at medium.
2. Under the Tools menu, go to Add-Ins. Make sure that both the Analysis ToolPak and Analysis Toolpak - VBA boxes are checked.

When you open Gerry's Stats Tools, you should get a dialogue box telling you that Gerry's Stats Tools contains macros (if the macro security is set on medium). Click the middle button to enable the macros. After you do that, Gerry's Stats Tools will appear in the menu bar to the immediate left of Windows. Click it and the menu should pull down. The first item in the list is "What test do I choose?".

By the way, there's a book that goes with the macros called Gerry's Handbook. It covers the topics usually covered in an introductory statistics course. The downloadable version is only $9.95. You can check it out at bookscapes.com.

Papers Index | Home