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

 
Introducation

The PHSTAT 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.  Version 4 is compatible with Microsoft Windows Excel 2007, Excel 2010, and Excel 2013, (Mac) OS X Excel 2011, and Office 365 Excel. with the latest Microsoft-supplied patches and service packs applied.  Complete configuration and download instructions are contained in the Readme files below while the PhStat Software files contain the program source code.

Version 4
Readme.v4
PhStat.v4 Software

 Quick Instruction for Installing PHSTAT V4 from the Web

For complete instructions on how to download, install and troubleshoot the PHSTAT 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).  PHStat will not work properly with unpatched versions of Excel.  You can only update Excel and install PHStat 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 PhStat.v4 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 PHStat.xlam.  As PHStat begins to load, you will see a security warning message that discusses macros. Should this dialog box appear, click Enable Macros to allow PHStat 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 PHStat loads properly, a PHStat menu will appear in the Add-Ins tab (Excel 2007, Excel 2010, or
Excel 2013)  or in the Apple menu (Excel 2011). 

Using PHSTAT

 You use PHStat by double-clicking the icon or folder listing (or shortcut) for PHStat.xlam. If you prefer, you can use the Excel (File) Open dialog box to open the PHStat.xlam file directly. As PHStat begins to load, you will see a security warning message that discusses macros. Should this dialog box appear, click Enable Macros to allow PHStat 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.)