OPIM 5103 Managerial Statistics
Summer 2013
Dr. Robert Jantzen
UConn MBA - Stamford

 
Introducation

The PHSTAT2 program is an Add-In program for Microsoft Excel and is available for download from the Prentice Hall textbook companion website at the links below.  Two versions of the program are available:  Version 3.20 is compatible with Excel 2007 or Excel 2010, or (Mac) OS X Excel 2011 with the latest Microsoft-supplied patches and service packs applied.  Version 3.07 is an older version that operates only under the Windows operating system and is compatible with Microsoft Excel 2003, Excel 2007 or Excel 2010 (32-bit version).  Complete configuration and download instructions are contained in the Readme files below while the PhStat2 Software files contain the program source code.

Version 3.20
Readme.v3.20
PhStat2.v3.20 Software

Version 3.07
Readme.v3.07
PhStat2.v3.07 Software
 

Quick Instruction for Installing PHSTAT2 V3.20 from the Web

For complete instructions on how to download, install and troubleshoot the PHSTAT2 program, click on the Readme link.

Step 1:  Check to see whether you have the latest Microsoft-supplied patches and service packs for Excel applied (visit http://office.microsoft.com/en-us/downloads/redir/XT101808448.aspx  and click on Custom for the latest Excel updates).  PHStat2 will not work properly with unpatched versions of Excel.  You can only update Excel and install PHStat2 if you log on to Windows using a user account that includes administrator priveleges.

Step 2:  Configure Excel to accept the add-in by changing the Trust Center security settings (see Readme link for specific steps for Excel 2007, Excel 2010 or Apple Excel 2011).

Step 3:  Download the PhStat2.v3.20 Software files which are packaged as a zip archive and save it to a folder. Double-click the zip archive and extract the files.  Then click on the icon in the folder for the file named PHStat2.xlam.  As PHStat2 begins to load, you will see a security warning message that discusses macros. Should this dialog box appear, click Enable Macros to allow PHStat2 to be opened. (If you are using Microsoft Windows and “nothing” happens, review Section 2 to make sure your system contains the correct security settings.)  If PHStat2 loads properly, a PHStat menu will appear in the Add-Ins tab (Excel 2007 or Excel 2010) or in the Apple menu (Excel 2011).

Quick Instruction for Installing PHSTAT2 V3.07 from the Web

For complete instructions on how to download, install and troubleshoot the PHSTAT2 program, click on the Readme link.

Step 1:  Check to see whether you have the latest Microsoft-supplied patches and service packs for Excel applied (visit http://office.microsoft.com/en-us/downloads/redir/XT101808448.aspx  and click on Custom for the latest Excel updates).  PHStat2 will not work properly with unpatched versions of Excel.  You can only update Excel and install PHStat2 if you log on to Windows using a user account that includes administrator priveleges.

Step 2:  Configure Excel to accept the add-in by changing the Trust Center security settings (see Readme link for specific steps for Windows only versions of Excel 2003, Excel 2007 or Excel 2010).

Step 3:  Download the PhStat2.v3.07 Software files which are packaged as an executible (*.exe) file. Double-click the file and Run it to begin the setup process.  After the setup completes, check the installation by opening PHStat2. A proper installation will cause Excel to display a PHStat menu in the Add-Ins tab (Excel 2007 or Excel 2010) or the menu bar (Excel 2003).

Using PHSTAT2

You use PHStat2 by double-clicking the Desktop PHStat2 icon or selecting PHStat2 from the Start menu PHStat2 program group. Once properly loaded, PHStat2 will add a new PHStat menu to the Microsoft Excel menu bar, if you are using Excel 2003.  If you are using Excel 2007 or 2010, this menu will appear in the Add-Ins tab.  When using PHStat2 the first time with the correct Excel security settings,  you will see a macro virus warning dialog box as you attempt to open PHStat2. When this dialog box appears, click the Enable Macros button to allow PHStat2 to be opened.