PHStat2 is Windows software that assists you in learning the concepts of statistics while using Microsoft Excel. PHStat2 allows you to perform many common types of statistical analyses while using the familiar Microsoft Excel interface. The rest of this document is organized into sections that will assist you in setting up and using PHStat2. Note: In this document, the symbol è means “on the next submenu, select.” Table of Contents
1 PHStat2 Technical Requirements
2a Configuring Excel 2007/Excel 2010 Security for PHStat2
2b Configuring Excel 2003 Security for PHStat2
3 Setting up PHStat2
4 Using PHStat2
5 Updating PHStat2
6 Troubleshooting PHStat2
7 What's New in PHStat2?
1 PHStat2 Technical Requirements
There are separate requirements for using PHStat2 and running the PHStat2 setup program. The requirements for running the setup program are more exclusive.. Requirements for using PHStat2:
Windows XP, Windows Vista, Windows 7, or Windows 8.
Microsoft Excel 2003, Excel 2007 or Excel 2010 (32-bit version), with the latest Microsoft-supplied patches and service packs applied. (Visit office.microsoft.com/officeupdate for latest Excel updates.) PHStat2 is not compatible with the 64-bit versions of Microsoft Excel.
PHStat2 no longer fully supports Excel versions earlier than Excel 2003. Users of earlier Excel versions discover that the new procedures discussed in Section 7 will not function properly. For Excel 2007 or Excel 2010, Trust Center Macro Settings set to Disable all macros with notification (see Topic 2a “Configuring Excel 2007/2010 Security for PHStat2” for complete details). For Excel 2003, Microsoft Office macro security level set to Medium (see Topic 2b in “Configuring Excel 2003 Security for PHStat2” for complete details). Internet access for downloading Microsoft Excel updates and PHStat2 updates (visit www.pearsonhighered.com/phstat) as they become available. MyStatLab users will always have access to an up-to-date version of PHStat2 from within their MyStatLab courses and will not need to download updates separately. Requirements for running the PHStat2 setup program:
Windows user account with administrator privileges. Student or faculty accounts used to login onto networked computers in academic settings typically do not have this privilege. If you have such an account, ask your network or lab technician for assistance. Approximately 10 MB hard disk free space while running the setup program and 3 MB hard disk space after program setup. 2a Configuring Excel 2007/Excel 2010 Security for PHStat2
You must change the Trust Center settings to allow PHStat2 to properly function. Follow these steps: 1.In Excel 2007, click the Office Button and then click Excel Options (at bottom of the Office Button menu window). In Excel 2010, click File Options. In the Excel Options dialog box:
2.Click Trust Center in the left pane and then click Trust Center Settings in the right pane. In the Trust Center dialog box:
3.Click Add-ins in the next left pane, and in the Add-ins right pane clear all of the checkboxes. 4.Click Macro Settings in the left pane and in the Macro Settings right pane click Disable all macros with notification. 5.Click OK to close the Trust Center dialog box.
Back in the Excel Options dialog box:
6.Click OK to finish
On some systems with stringent security settings, you may need to modify step 5. For such systems, in step 5, click Trusted Locations in the left pane and then, in the Trusted Locations right pane, click Add new location to add the folder path to the PHStat2 add-in (typically C:\Program Files\PHStat2) before you click OK. 2b Configuring Excel 2003 Security for PHStat2
The Microsoft Office macro security level must be set to Medium in order to allow PHStat2 to properly function. Open Microsoft Excel and select Tools è Macro è Security. In the Security Level tab of the Security dialog box that appears, click the Medium option and then...