< Back to Statistics Homepage



This is obsolete. Please see your instructor.

StatTools Installer

1. Please see your instructor for the download site and login instructions. Once you have the files, continue with the following.

2. Click on Start->All Programs->Palisade Decision Tools->StatTools 1.1 for Excel. This will bring up Excel with StatTools as a Macro.

2a. If you get a security dialog, press the Enable Macros button.
2b. If the Enable Macros button is not selectable, cancel out of the dialog and close Excel. Re-open Excel and go to Tools->Macro->Security. In the Security dialog, select the MEDIUM security level and press OK. Close Excel. You must REPEAT STEPS 2 and 2a above after changing the security settings.

3. Close and re-open Excel. Go to Tools->Add-Ins. In the dialog, press the Browse button. Navigate to <Local Disk>\Program Files\Palisade\StatTools\, select the file 'StatTools' and press OK.

4. There should be two SELECTED items for StatTools in the Add-Ins dialog. Press OK to close the dialog.

5. StatTools is now linked with Excel. There is a tool bar and menu item associated with StatTools.


StatTools in the A&M Open Access Labs

Click on Start->Applications->Statistics->StatTools 1.1 for Excel. This will bring up Excel and a Security Warning. You must click on "Enable Macros". If StatTools does not appear in the toolbar at the top of Excel follow steps 6-8 in the instructions above.


StatTools Commands Help

How to Open a Data File (pdf)

How to Get Summary Numbers (pdf)

How to Create Summaries for Categorical Data (pdf). NOTE: you must first make a pivot table, so click the link below.

How to Make a Pivot Table (pdf)

How to Make Plots (pdf)