KStat - the Kellogg Statistics package - was designed for classroom use at the Kellogg School of Management at Northwestern University. In its current form, it is "freeware", and may be used by anyone, for any purpose, as long as the underlying macro code is not modified in any way.
In order to download the package, click here:
To use the package, run Excel, and File / Open / KStat.xls.
If you've got your Excel "paranoia" settings turned on, you might be prompted with a few warning windows. DO permit macros to run. If you're running Excel 2000, XP, or 2003 and nothing seems to happen, check "Tools / Macros / Security", and be sure the setting is medium or low: The high setting kills macros - the heart of KStat - without even warning you. If you're running Excel 2007/2010, be sure to read here.
After a few seconds, a welcome message will appear: Click "OK" or press "Enter" to continue. You'll find yourself looking at a blank "Data" page, and a new option - "Statistics" - will be present in the main Excel menu (or, in Excel 2007/2010, in the "Add-Ins" menu). Then either type or cut-and-paste your data into the Data page, or select Statistics / Import Data / File to bring in data from a properly-formatted worksheet. (Click here for an example of an importable dataset.) Note in particular that the rectangular data array must have a blank column to its immediate right, and a blank row at the bottom.
The rest should be self-explanatory: All analysis is triggered by selections from the Statistics menu.
The package contains cell comments which provide concise definitions of the statistical terms you'll encounter. A commented cell will display a small red triangle in its upper-righthand corner. Simply putting the mouse cursor over a commented cell will display the comment.
Due to limitations in the way Excel handles your computer's memory, KStat can only handle data arrays containing up to approximately 5,000 entries, e.g., if you have 20 variables, you're limited to about 250 observations. (As of Excel 2007, these limits have been loosened a bit.) KStat makes no special provision for missing data: If some observations are incomplete, sort them to the bottom of the data array and insert a blank row above them in order to analyze the remaining data.
In order to preserve a clean copy of itself, KStat will NOT remind you to save your work when you close the program. If you wish to save your work inside a copy of KStat, select File /Save As, and save under a new name of your choosing before closing KStat (or Excel). A full copy of KStat will be saved "inside" your newly-named workbook.